SUMMARY

• Sr. Business Analyst with about 8 years of experience in effectively meeting the evolving business needs, with a focus on designing, development & implementation of the business processes.
• Experienced in gathering business requirements from end client using various elicitation techniques like Interviews, Brainstorming, Survey, Questionnaires, Document Analysis, Focus Groups and Requirements Workshops.
• Proficient in Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Requirement Document (FRD), Functional Specifications Document (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM), testing documents and in conducting AS - IS & TO-BE Gap analysis.
• Experience attending and collaborating on the conduction of SCRUM ceremonies: Sprint Planning, Sprint Review, Daily Stand-Up Meeting and Retrospective Meetings.
• Experienced in Business Process Flow, Business Process Modeling, Business Process Re-Engineering, Data Warehouse, Data Analysis, Data Mapping, Data Modeling.
• Hands on experience with SDLC methodologies like Agile/SCRUM, Waterfall.
• Strong experience in Application Design (Prototyping, Screen Mock-ups), wireframes, UI design.
• Experience in facilitating weekly and monthly business review meetings to keep SME’s, Stakeholders, product managers, executive staff and team members apprised of goals, project status with timely identification, tracking, resolving issues and conflicts and preparing product demonstrations.
• Experienced in performing backend testing and writing SQL Queries for testing RDBMS such as MySQL, MS SQL Server, Oracle, and Teradata for data integrity.
• Worked with the project team to determine appropriate Test/Deployment Plans & support product launch.
• Worked on JIRA for Reporting andused for bug tracking, issue tracking, & project management.
• Experienced in the Informatica/ ETL (Extract, Transform and Load) of data into a data warehouse/date mart.
• Used Tableau and Power BI for generating Analytical Reports required for the project for further analysis.
• Strong organizational and documentation skills, proficient in MS Office Suite (MS Visio, Word, Excel, and PowerPoint)
• Possess excellent analytical, problem solving, communication & interpersonal skills, with ability to interact with individuals at all levels & can work as a part of a team as well as independently.

TECHNICAL SKILLS

Project Management tools & Methodologies: Agile, Waterfall, Scrum & SAFe frameworks, JIRA

Databases: MS SQL Server, MySQL, Oracle, Teradata

ETL Tools: Informatica Power Center, Cognos, Alteryx

Programming Languages: SQL, C, Python

Other BA Tools: MS Office Suite, MS Visio, MS Project, SoapUI, Postman, HP Quality center, XML & HTML

PROFESSIONAL EXPERIENCE

Confidential

Sr. Business Analyst

Responsibilities:

• Implemented Agile within the different groups involved in the project to configure and develop process, standards, and procedures.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
• Converted User Requirements into Business Requirements, analyzed the same, and segregated them into High Level and Low-Level business requirements.
• Performed Data Analysis and data profiling using complex SQL queries on various sources systems including Oracle and Teradata.
• Designed and developed an end-to-end data warehousing and OLAP solution using SSIS, SSAS, SSRS, and SQL Server.
• Involved with working on ETL tool Informatica to populate the database, data transformation from the old database to the new database using Oracle.
• Created the ETL data mapping documents between source systems and the target data warehouse.
• Followed the UML based method using MS Visio to create Use Cases, Activity Diagrams/State Chart Diagrams, Sequence Diagrams, Collaboration Diagrams.
• Developed Conceptual and Logical ER diagrams identifying the entities, constraints, relationships, and cardinality.
• Worked extensively on Data Profiling, Data cleansing, Data Mapping and Data Quality.
• Developed Data mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP.
• Reviewed and finalized the User Requirement Specification (URS), Functional Requirement Specification (FRS), Technical Specification, and Detailed Design documents.
• Used Rational Clear Quest for handling change requests.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.

Confidential, TX

Business Analyst

Responsibilities:

• Review and understand the active business process with the immediate stakeholders and document business process description, scenarios, and requirements.
• Followed Agile Framework for Business development using Jira.
• Conducted Scrum ceremonies like Sprint Planning meetings, daily Standup calls, Retrospective meetings and demo and training the customers on the new features developed.
• Developed user requirements specifications, personas, storyboards, scenarios, prototypes, wireframes, functional specifications, and design specifications.
• Worked on Jira to document user stories, issues, bugs and defects.
• Designed and implemented basic SQL queries for testing and report/data validation.
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI design) using Microsoft Visio.
• Experience with Cognos in designing dashboards and reports.
• Involved in research and reporting of data and business analytics using Crystal Reports, MicroStrategy and Cognos.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge and performing QA.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules.
• Acted as a Liaison between Client and Offshore Development Team.
• Perform GAP analysis and troubleshoot issues, analyze, and suggest solutions.
• Work with project manager on project schedules, project plans and data governance.
• Worked with offshore development team and fixes by addressing the issues

Confidential, PA

Business Analyst

Responsibilities:

• Responsible for gathering requirements and specifications for the existing system to build the web services for same.
• Analyze and validate all data attributes required for the new web service.
• Conducted and participated in JAD sessions with stake holders and system users to develop the System Requirement Specification.
• Understand the XML and JSON schemas and explain to the team.
• Prepared detailed business flow diagrams to present business process effectively to business, developers and QA using MS Visio.
• Experienced in writing SQL queries for analyzing the existing system data-store and data mapping to transform the data from one data source to another.
• Documented the System Requirement Specification and Functional Requirement Specification and given walkthrough to Business stakeholders, developers, testers took sign-off.
• Documented functional requirement including objectives, in-scope, out-of-scope, risk dependencies, impacted system, source to target data mapping, As-Is and To-Be process flow, error handling rules, file layouts, and table structures.
• Prepare Requirements Traceability matrix (RTM) to enable the development team and Testing team match their design and test cases respectively with requirements.
• Performed User Acceptance Testing (UAT) and identified the defects in complex scenarios and tracking them to closure in HP Quality Center.
• Utilized Soap UI and Postman tools for system testing and reported to developers for issue fixing.
• Communicated project status, prepared, and shared meeting minutes, raised issues and concern/risk/roadblocks to the project team.
• Provided domain expertise to developers in the design phase, clarified requirement related question during development and system integration testing.

Confidential, Schenectady, NY

Business Analyst

Responsibilities:

• Analyzed the scope and vision documents that defined the primary goals, objectives, and scope of the project to prepare business requirements Documents (BRD).
• Worked on understanding the business process from functional and technical standpoint.
• Involved in gathering business requirements, documenting the business process, and worked on identifying the system requirements, analysis, testing and implementation of new releases and application.
• Document, analyze and define the user and system requirements and managed them using Rational Requisite Pro.
• Identified and established scope and parameters of requirements analysis to define impact, outcome criteria, and measure-taking actions through interface analysis, prototyping and JRP/JAD sessions with Focus group.
• Collaborated with the Development team during the Design, Build and Test phase of system projects to clarify business requirements as required.
• Provided postproduction support/analysis and assisted in performing User Acceptance Testing (UAT), performance testing and validated test plans.
• Served as a liaison between the development team and the business client, with the goal of enhancing business processes and achieving a clear understanding of the client's requirements.

Confidential

Analyst (Data & Reporting)

Responsibilities:

• Work closely with stakeholders from across both the Business and IT teams to define and gather business requirements of the project.
• Experienced in writing SQL statements to query the database for Data Analysis and Data Validation.
• Prepare clear documentation to communicate requirements and related information and assisted Project Manager in creating the project plan and deciding the milestone for the project.
• Worked with the development team during the Design, Build and Test phase of system projects to clarify business requirements as required.
• Perform UAT testing and ensure business stakeholders and IT teams are well informed on the testing efforts/results.
• Developed training content on system functionality and delivered training sessions to end-users.
• Handled production deployment and provided postproduction support and analysis.
• Performed Business data analysis and develop dashboards, data stories using Tableau to communicate insights and KPIs to the senior management.