Home

Sreshta - Sr businesss analyst

[email protected]

Location: Dallas, Texas, USA

Relocation: yes

Visa: H4-EAD

SUMMARY OF SKILLS & EXPERTISE Business Analyst professional with over 8+ years of experience. Excellent analytical skills to understand the business process functionality and to translate them to Business Requirement Specification and System Requirement Specifications Solid understanding of Software Development Life Cycle (SDLC) processes including requirements gathering, analysis and design, development tools technologies and release. Experience in varying environments utilizing SDLC and ITIL Framework Good understanding of Project Management Practices and Principles including Time Management, Budget Management, Resource Management, Risk Management and Change Mgmt. Experience in conducting GAP analysis, Impact analysis, SWOT analysis, Cost benefit analysis and ROI. Experience in implementing Rational Unified Process Methodology (UML) using Rational tools, working with Agile Development methodology by implementing and delivering Business Processes in iterations. Experience in database modeling and development of Entity Relationship Diagrams (ERD), SQL (ad hoc queries), Data migration, Data mapping, ETL, MDM and reporting process. (KPIs). Proficiency in value stream mapping, process modelling and mapping tools (e.g., Microsoft Visio, Lucidchart) and familiarity with business process management software. Experience in mobile app development and implementation including hardware confiscation and optimization. Knowledge of Kimball data warehouse design principles and strong experience in database modeling and development of Entity Relationship Diagrams (ERD), SQL (ad hoc queries, stored procedure), Data migration, Data mapping, ETL, MDM and reporting process. (KPIs). Understanding of Web Services and API technologies like REST/SOAP using XML, was also involved in gathering requirements for client-side and server-side validation and their testing using Postman, SOAP UI and documented them using tools like Swagger, POSTMAN. Familiarity of SNOWFLAKE, Talend, Power BI, Azure Data Lake Storage. Understanding of various financial products ( Loans, Derivatives, Repos, Reverse Repos, Swaps etc.) and GL postings. Excellent communication and technical writing skills in large corporate environments. SKILLS Methodologies : RUP, UML, CMM, ISO, DMAIC, Scrum, Agile, Kanban Project Management Tools : Microsoft Project, MS-Office, Excel, Power Point Content Management Tools : Microsoft SharePoint, Documentum, ServiceNow Document Design Tools : Rational SoDA, Rational Requisite Pro, Visio Testing tools : Serena, QTP, HP ALM Business modeling tools : Microsoft Visio 2007, Rational Rose, Figma CERTIFICATIONS Certified Scrum Master, CSM, Scrum Alliance, 2024 Certified Scaled Agile Product Owner, Safe Certification- In progress PROFESSIONAL EXPERIENCE Metlife Cary, NC May 2022 to Present Sr. Business Analyst Responsibilities: Worked on data architecture remodeling by identifying, creating, and connecting APIs as part of company wide effort for minimizing the dependency on old AS400 based backend data interface systems. Assisted and contributed to the design, development, and deployment of business systems to meet our Retirement Plans and Pension division goals and objectives. Develop and utilize a deep understanding of how various retirement plans systems communicate and share data with each other. Gather and analyze business requirements and write Business Rules Document as part of the vendor guidelines of the documentation. Perform data analysis for the existing system and identify changes for the internal schema for performance, also perform data mapping from source to target using Business Process Mapping Notation (BPMN). Participate in Design walk-through with SMEs to baseline the business architecture. Identified applicable technology alternatives to given business problems in collaboration with Product owner and technical lead. Worked on Altassian(JIRA)/Confluence (Agile Management Tools) to log user stories and create product backlog and prioritize stories. Also, to plan the sprint and epics and identify the dependency between functions. As part of Agile Kanban SDLC methodology, participated and conducted agile ceremonies like PI planning, Sprint planning, daily standup, user story grooming session, sprint review, retrospective meetings. Worked closely with QA team and developers to clarify/understand issues, resolve and provided feedback to nail down the bugs. Worked with project team to ensure that logical and physical data models were developed in line with Key standards and guidelines. Perform source to target data mappings, business rules and data definitions as well as define the Key identifiers for each mapping/interface. Documented data quality and traceability documents for each source interface as well as used the tool Snagit to document current process and define future process. Used Lucid Chart to create Swim Lane and process flow diagrams. Used Visio to create mockups and diagrams too. Used SQL Developer to perform data check while data mapping. Used HP ALM to log test cases and test scenarios and defect entry for defect discussions. Worked with Project and Release Management to sequence/coordinate development activities within software development environment methodologies. Identifies applicable technological alternatives to given business problems with the assistance and direction of the Senior Business Analyst and Business Solutions Consultant. Alight Solutions Chicago, IL March 2020 to April 2022 Sr Business Analyst Responsibilities Participated in multiple waterfall Salesforce CRM solution projects by completing and updating requirement documentation; managing requirement scope; adjusting schedules when necessary; determining daily priorities; ensuring efficient and on-time delivery of project tasks and milestones; following proper escalation paths; and managing customer and supplier relationships. Lead and delivered successfully the first Agile Scrum (SDLC) initiative which included agile coaching of the stakeholders as well as the dev and testing team. Used Azure DevOps as a one stop Agile solution to log user stories and defects and generate reports of work progress. Conducted Agile ceremonies like Sprint planning, Daily standup meeting, story grooming sessions, product backlog refinement, sprint review and sprint retrospective. Provided project level analysis producing required project analysis documentation (business requirements, scope matrix, User stories, use cases, sequence diagrams, future state proposals, UAT plan) as part of project management responsibilities. Used Visio to create Swim Lane and process flow diagrams and also Figma to lay the foundation of the Business Process Modeling Notation. Collaborated closely with developers to implement the requirements, provide necessary guidance to testers during QA process. Also worked on Identifying improvement opportunities (proactive and reactive) including documenting business and systems requirements Also worked to understand and negotiate the needs and expectations of multiple stakeholders as and when needed. Served as a liaison between Operations and IT to assist or gather business requirements needed for system modifications, enhancement, and implementations. Created and maintained issue logs, meeting minutes, meeting schedules, project summaries and updates. Met with project team regularly to review project deliverables and deadlines and then helped the testers to complete their testing and retesting of bugs and enhancements. Handled day-to-day operational requests from the business to accommodate changes to the Congnito Form samples which were locked as requirements before sprint planning. Developed understanding of Licensing and permitting process and created user manuals for end users using snagit. Worked with data analytics team to get their signoff to follow the companywide guidelines for data modeling, data taxonomy. Capital One Mclean, VA January 2019 to February 2020 Business Analyst Responsibilities: Worked on automation, enhancement and maintenance of ecourts expungement portal for both internal and external users and improve the client experience of initiating and completing and expungement. Worked on solving helpdesk issues generated by both internal court staff and external users such as prosecutors, public defenders, Private Attorneys, pro se users and other parties like police department. Also worked on a Dynamics 365 CRM based solution for an internal application related to travel advisory. Also worked on analyzing and designing business requirement for Data Marts and Data warehouse by connecting with data and ETL teams. Identified and wrote data sources and identification rules for storing data in data warehouse. Accessed data from AS400 systems of Promis Gavel for criminal court data, ACS for Municipal court data and FACTS for family court data. For above AS400 applications, validated prod support issues and created test data in the test environment for testing and root cause analysis. Also worked on creating a feasibility analysis to decrease the dependence on AS400 system and its downstream effect as a companywide project to replace AS400 applications. Used a home-grown config to search, parse and extract the xml log files in production in order to triage the production support issues. Worked on Agile SDLC implementing scrum iterations to deliver projects which included daily standups and weekly grooming sessions. Used agile management tool Azure DevOps to create storyboards, functions, epics, User stories and then follow them up to complete within a certain timeline within an iteration. Documented Requirement Traceability Matrix in Requisite Pro for traceability of requirements through test cases. Actively work with product owner to plan and refine product backlog along with execution and reporting of the smooth movement of Agile Studio cards across project. In order to create prototype and wireframes for the user experience enhancements and inclusion of new features used UI/UX tool AdobeXD. Coordinate with standards team to get approvals for mockups and Wireframes for UX design changes in AdobeXD obtain information on project limitations and capabilities, performance requirements and interfaces. Experience working with Analytics team on data management for data modeling, data taxonomy involving data governance. Participated in End-to-End testing, Integration Testing, User Acceptance Testing (UAT) and Regression testing for each scrum with an extensive use of Snagit tool to take screenshots. Used SQL developer to perform queries to fetch data from database to perform data analysis for testing.Also participated in creating test cases and test scenarios for testing of the user stories and setting up automated test scripts in HP ALM. Mahindra Satyam Hyderabad, India June 2015 to October 2018 Business System Analyst Responsibilities: Enhance the user experience of website and improve the client experience of digital selling, buying and auctions.Also worked on supporting day today production issues generated by business groups across the customer locations for business in a call center set up. Worked on a lift and shift project and conducted reverse engineering of legacy applications to accelerate system redesign and modernization efforts using webservices. Used Splunk to search, parse and extract the xml log files in production to triage the production support issues. Also worked on value stream mapping, process modelling using tools like Microsoft Visio, Lucidchart and also worked with business process management team. Familiarity with XML, XSD language as had to go through the logs in order to triage application prod support .Used Splunk tool to search, XML log files in production to analyze the root cause behind the issue being reported. Extracted the XML log files for further analysis of the developer into the file to triage the issue further.Worked on Agile SDLC implementing scrum/Kanban iterations method wise to deliver project. Worked on analyzing Datawarehouse for Data Integration and lift and shift project. Used Power BI for querying the data and worked on data mapping for reporting related projects. Used agile management tool Azure DevOps to create storyboards, functions, epics, User stories and then follow them up to complete within a certain timeline within an iteration. Actively work with product owner to plan and refine product backlog along with execution and reporting of the smooth movement of Jira cards across project. Coordinate with different stakeholders across functions and different teams to design mockups and Wireframes for UX design changes in Figma and lucid chart and obtain information on project limitations and capabilities, performance requirements and interfaces. Coordinated with data governance team to figure out the dependencies of the API. Work on resolving the support tickets generated by the dealers, sellers and end users during their day to day business on Service Now. Also worked on collecting requirements for customization of chatbots feature through Microsoft Azure. Retrieve and triage data for analysis of system capabilities and requirements by accessing the API services through POSTMAN and accessing GITHUB repos to see the code when needed. Worked with code base located in different legacy data sources and also in webservices like JSON, REST and Mashery API. Worked on creating user stories in JIRA for data migration from AS400 to REST APIs to make it more efficient way of data handling. Triaged endpoints of Rest and JSON APIs to cite in the JIRA cards for the dev team to find exact data location. Used Power BI to run SQL query to test data while performing any test required during the production support. Worked on Application Rationalization Project (ARP) with PMO to identify application redundancy and phase out across MTA. Also worked on Hours-of-service application for LIRR, MNR under MTA. Prepared As Is (current state) and To Be (future state) diagrams documents for applications to identify gaps in what they want vs what they have. Also helped the Project Manager in reviewing the scope of the project, timeline, budgeting and managing the risk log on SharePoint. Helped Project Manager in preparing decks (PowerPoint slides) for steering committee meetings and timeline review meetings. Used JIRA/confluence as Agile Management Tool to create storyboards, user stories, functions and different tasks and test scenarios. Understanding Central Federal Regulation to ensure that BRD (Business Requirement Document) captures it for application to be compliant with regulation. Worked with the ethics and compliance department and liaised between the compliance director and business stakeholders as well as the IT team since it was an application for employees to comply with the laws and policies related to Hours of Service. Worked in Agile scrum SDLC methodology and lead and coached Scrum adoption and planned scrum implementation. Used Visio to create Swim Lane and process flow diagrams. Used Balsamiq to create mockups and wireframes. Used SQL developer to query data in order to do data analysis during requirement gathering and test execution. Used HP ALM to log test scripts and test scenarios, so that the defect logs could be traced back to requirements. Keywords: quality analyst user interface user experience business intelligence active directory information technology golang hewlett packard microsoft Illinois North Carolina Virginia