SUMMARY

• 8+ years of experience as a Business Systems Analyst with excellent knowledge of the full Software Development Life Cycle (SDLC) methodologies such as Waterfall, Agile, Hybrid Waterfall - Scrum, frame works and processes.
• Good domain knowledge and work experience in Supply Chain Management, E-commerce and Financial/Banking services.
• Excellent analytical skills to understand the Business process, functionality, cross functional requirements across various business units and departments, and translating them into Requirement Specifications in order to provide comprehensive solutions.
• Highly skilled in various Business Requirements elicitation techniques and analysis such as client interviewing, job shadowing, requirements workshops, survey/questionnaire, and Joint Application Development (JAD).
• Interacted with various stakeholders, subject matter experts, project manager, developers and users to understand various stakeholder needs, and translating them into requirements.
• Worked extensively on Business Process Modeling, Gap analysis, Risk analysis, SWOT analysis, Cause and effect analysis, Cost Benefit analysis, Feasibility analysis and estimation of ROI.
• Extensive experience in creating various artifacts including Business Requirement Document (BRD), Software Requirements Specification (SRS), Functional Requirements Document (FRD), Test Plan, Test Scenarios, and Test Cases as well as documenting project processes and procedures.
• Proficient in UML Modeling like Activity Diagrams, Sequence Diagrams, Use case Diagrams with Rational Rose and MS Visio.
• Managed requirements and tracked defects working with HP Application Lifecycle Management (HPALM) and HP Quality Center (HPQC) and well versed in conducting various types of testing including Regression Testing, System Testing and User Acceptance Testing (UAT).
• Proficient with various tools such as Atlassian Jira, Team Foundation Server (TFS), HP Agile Manager, and MS Project Professional for planning, tracking and managing projects.
• Experience in modeling business process flow for performing workflow analysis and business process analysis for Business Process Re-engineering to enhance the business process.
• Good understanding of Project Process and ability to analyze business problems and identify solutions.
• Expertise in creating Data Models, such as Conceptual model and Logical model in the form of entities and relationships to capture the user requirements properly in the underlying database.
• Practical knowledge of Data Warehousing architecture, implementation approaches, schemas, dimensional modeling and translating the business requirements into various types of dimensions.
• Cultivated experience in working with different web services such as WSDL, SOAP, UDDI, REST under various architectures such as Three-Tier Architecture, and Service Oriented Architecture (SOA). Involved in scripting business logic in the web methods of the web services, and documenting the Web Service Level Agreement (WSLA) document, through the use of XML.
• Highly skilled in tracing requirements throughout the development process and verifying adherence to Requirements Traceability Matrix (RTM).
• As a certified Scrum Master, facilitated scrum teams working in the agile software development.
• Proficient in writing user stories (INVEST format) and handling the requirement churn. Efficient at facilitating estimation techniques such as Planning Poker, T-shirt sizing and Prioritization techniques such as Moscow, Kano techniques.
• Expertise in broad range of technologies, including business process tools such as MS Project, MS Excel, MS Access, MS PowerPoint, MS SharePoint, MS Visio and Rational Suite
• Assisted QA team in developing Test scenarios, Test Cases for the User Acceptance testing.
• Strong Analytical and Problem Solving skills, Multi-Tasking abilities, with proven experience in utilizing people and process knowledge to assist enterprises in making critical decisions.
• Team player and self-starter with excellent communication, coordination, documentation, project planning and interpersonal skills.

TECHNICAL SKILLS

Operating Systems: Windows 7,8,10,XP/Vista/Mac OS X

Modeling Tools: Rational Rose, MS Visio, Balsamiq, Axure

SDLC Methodologies: Waterfall, Agile-Scrum, Waterfall-Scrum

Business Skills: Change Management, Impact Analysis, and JAD sessions, SWOT Analysis, Project Planning, Project Scheduling and Project Budgeting.

Requirement Management: MS Office, JIRA, HP ALM, TFS, VersionOne

Project Management Tools: MS Project, MS SharePoint Server

Testing Tools: HP QC v10.0, HP ALM v11.5, HP UFT 12.02

Financial Tools: MS Excel functions and pivot tables

ETL Tools: Informatica PowerCenter, SQL Server Data Tools

Reporting Tools: Tableau Desktop, IBM Cognos, MS Office Suite, Spotfire

Languages: HTML, XML, SQL, jQuery

Databases: MySQL, MS Access, Oracle

PROFESSIONAL EXPERIENCE

Confidential, Oaks, PA

Sr Business Systems Analyst/Scrum Master

Responsibilities:

• Analyzed the Business Process along with the prior project documentation for complete understanding of the project.
• Also, interviewed SME’s and CRO in order to better understand the business process and contribute in the Business Process Model re-engineering and optimization.
• Captained GAP Analysis by understanding the AS-IS business process and TO-BE business process.
• Conducted JAD sessions and interviews with key stakeholders and SME’s for requirements gathering.
• Prepared Business Requirement Document (BRD) and Functional Requirement Document (FRD).
• Lead a story writing session with an aim of decomposing the scope into epics and user stories with product owners. Also, worked on the acceptance criteria for the above developed user stories.
• Facilitated prioritization and estimation of the user stories by using MOSCOW and Planning Poker techniques.
• As a Scrum Master, facilitated and conducted the sprint planning and the daily scrum standup meeting.
• Developed and analyzed the Sprint/Product Burn Down Chart in order to calculate the team’s velocity and track sprint progress.
• This was then utilized for planning of the upcoming sprints.
• Resolved impediments faced by the scrum team at the team and the organizational level.
• Used Team Foundation Server (TFS) to plan and track the sprints,
• Developed mock-ups and wireframes along with the screen designs using Axure.
• Performed Impact Analysis, Feasibility Study, Cost-Benefit Analysis and Return on Investment (ROI) in order to mitigate certain risks associated with the project and project output.
• Designed data models and conducted Normalization and De-Normalization of the data as per the Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) frameworks respectively for data analysis.
• Performed slicing and dicing of data marts in order to facilitate the analytical decision making process.
• Integrated various OLTP to OLAP by using Informatica PowerCenter as an ETL tool.
• Developed reports using Tableau v9.0 to communicate information-using graphs, charts and other info graphical solutions to the project team.
• Performed User Acceptance Testing (UAT) in conjugation with the QA team. Also, created an error repository and managed the testing process with the QA team.
• Assisted in creation of test cases in HPQC, and scheduling manual and automated execution of those test cases, through integration with HP Unified Functional Testing (UFT).
• Logged and tracked the defects using HP Quality Center.
• Used Restful API to communicate with security lending system of the front desk.
• Coordinated with web service provider and consumer to design API request and response calls.
• Created Requirement Traceability Matrix (RTM) in order to track test cases and test plans.
• Portrayed as a Proxy Product Owner, to facilitate the Product Backlog Grooming meeting to reprioritize the PBI’s as per the business value.
• As Scrum Master, I facilitated the Sprint Review and Sprint Retrospective Meeting at the end of each sprint.

Environment: Scrum-Waterfall Hybrid Methodology, Content management, TFS, Oracle 11g, MS-Visio 2013, Java, JavaScript, MS Project 2016, Erwin Standard Edition, Informatica PowerCenter 9.6, Axure RP Pro 6.5, MS SharePoint 2013, Tableau 9.1, MS Office, MS Excel, Agile, HP Quality Center 11, HP UFT 12.02.

Confidential, Strongsville, OH

Sr Business Systems Analyst/ Scrum Master

Responsibilities:

• Performed extensive Document Reviews and GAP analysis to develop a thorough understanding of AS-IS business processes model and TO-BE business process model.
• Conducted high-level requirement gathering sessions with Business Owners, risk analyst and concerned teams for requirement elicitation via JAD Sessions, Interviews, and Brainstorming Sessions.
• Created Business Requirement Documents (BRD) and Functional Requirement Specification (FRS).
• Translated the system requirements in the form of user stories with the help of Subject Matter Experts.
• Played a crucial role in Risk Management that included impact analysis and risk mitigation.
• Assisted in scripting business rules in middle tier application, and assisted in drafting agreements for various web services in a Web Service Level Agreement (WSLA) document in XML.
• Gathered requirements for the SOA architecture with loosely coupled components through WSDL, and SOAP architectural style for Web services for the backend of the project.
• As a scrum Master, assisted the Product Owner in prioritizing the Product Backlog items using the Kano technique and facilitated the estimation of efforts required along with Scrum team using T-shirt sizing technique.
• Used JIRA for drafting the User Stories and managing the requirements.
• As a SCRUM Master, facilitated and time-boxed the Agile Scrum Ceremonies such as Sprint Planning Meeting, Daily Standups, Sprint Review Meeting, Sprint Retrospective Meeting and Backlog Grooming Sessions.
• Protected team from Impediments as well as from over and under commitment issues.
• Created and managed the sprint burn down charts and tracked the velocity for better estimation of the progress.
• Active part of the Smoke testing, Black Box testing, Regression Testing and System Testing.
• Led the User Acceptance Testing (UAT) efforts, and opened/closed defects on HP-QC.
• Worked with the Product Owner during the Sprint Review Meeting for the Potential Shippable Product Increments (PSPIs) and helped decide which features are DONE as per the acceptance criteria.
• Used Spotfire for generating reports.

Environment: Waterfall-Scrum Hybrid, MS Office 2013, JIRA 6.0, SOA, SOAPUI, MS SharePoint 2013 for content management, Bloomberg B-Pipe(API), Visual Studio .NET, JavaScript, Microsoft SQL Server, HP Quality Center 10.0.

Confidential, Las Vegas, NV

Business Systems Analyst

Responsibilities:

• Involved throughout the System Development Life Cycle (SDLC)-Waterfall.
• Gathered project requirements, using techniques such as: JAD, document analysis, interface analysis, requirements workshops, and interviews with Subject Matter Experts (SME) and stakeholders.
• Performed Impact Analysis, Feasibility Study, Cost-Benefit Analysis and Return on Investment (ROI) in order to mitigate certain risks associated with the achieving the project objectives.
• Performed GAP Analysis and documented the gap between the existing system and desired system.
• Developed a high level Business Requirements Document (BRD) and Functional Specification Document (FSD) and had them base-lined from the business owner.
• Performed Change Management by handling change requests by performing change impact analysis on business and technical impacts, and getting the approval from the Change Control Board (CCB), to make the appropriate changes.
• Worked with GUI development, requirements creation/design to create the initial UI wireframes, and mockups. Developed Mockup screens and prototypes using MS Visio.
• Created Use Case document by specifying actors, normal flow, alternative flows for all use cases.
• Created activity diagrams to represent the current state business process, context flow diagrams to identify the interfaces and the data flow of the system, and sequence diagrams to specify the order of interactions.
• Constructed Requirements traceability matrix to determine the source of the requirement, to ensure all requirements are met and to locate affected system components when there is a requirements change.
• Used MS Project Professional to manage schedules, deadlines, resources and the project tasks.
• Created Dimensional Model with Lead Architect, ensuring the historical data is properly stored in the dedicated data marts, and the requirements are properly captured by the data marts for data mining process.
• Coordinated with the other data analysts for assisting the Data mapping process, and Data extraction and Integration to the data mart by using the Informatica Powercenter from the legacy systems.
• Generated Data Mapping Sheets for transfer of data from the source systems to target systems.
• Used Tableau to perform various different visualizations, and for generating reports.
• Used SharePoint 2013 for content management

Environment: Waterfall, MS Project Professional 2013, Microsoft SQL Server, Informatica Powercenter, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), Balsamiq, Erwin, Tableau, SharePoint 2013.

Confidential, Troy, MI

Sr Business Analyst

Responsibilities:

• The project was implemented using Waterfall methodology.
• Captured Requirements by conducting interviews with stakeholders, brainstorming sessions with stakeholders, and performing JAD sessions and documented the Business Requirement Document (BRD).
• Coordinated with Tech lead to create Functional Specification Document (FSD) and had it base-lined.
• Involved extensively in feasibility studies, data analysis, gap analysis and risk analysis.
• Experience in documenting the Requirements Traceability Matrix in MS Excel, after documenting the requirements against the associated test cases with their status.
• Well acquainted with workflows and Unified Modeling Language (UML) diagrams including Use Cases, Activity Charts, Sequence diagrams using MS-Visio.
• Created Data Flow Diagrams and ER Diagrams for Data Modeling.
• Developed wireframes, GUI prototypes, and screen mockups using Mockup Screens.
• Closely monitored and reported project status, change requests and scope creep.
• Coordinated and controlled change requests with the Change Approval Board to effectively manage change in the requirements, by performing change impact analysis on the business and technical impacts.
• Conducted ETL workshops to understand requirements for Data Warehouse Design (Extraction, Transform and Load) operations on the database using Informatica PowerCenter.
• Performed slicing and dicing of data marts in order to facilitate the analytical decision making process.
• Created and maintained the various UML diagrams using MS Visio.
• Develop test cases using HP Quality Center and participated in User Acceptance Testing.
• Used Tableau desktop for reporting.

Environment: Waterfall, Java, Microsoft SQL Server, Informatica Powercenter 8.1, MS Word, MS Excel, MS PowerPoint, MS Visio, Content Management, Erwin, HP-QC 11.0, Tableau 7, Sharepoint 2010.

Confidential

Business Analyst

Responsibilities:

• Participated in preparing the project scope and objectives.
• Expert in requirement gatherings while following various elicitation techniques for business requirements by conducting client group interviews, focused groups, workshops and online surveys.
• Prepared business requirement document (BRD) and System Requirement Specification (SRS) to provide details of each business and functional requirement, development and implementation plan of these requirements, timelines.
• Assisted in developing the project deadlines/deliverables/strategies to effectively manage projects.
• Prepared and maintained the Requirement Traceability Matrix (RTM) to record the business and functional requirements.
• Prepared use case diagrams and description documentation based on the analysis, and obtained approvals from the clients.
• Prepared Mockup screens with the help of UI components using wireframes for testing the front end.
• Prepared activity diagrams on MS Visio to better understand the flow of activities along with the timelines.
• Coordinated with project stakeholders to track the progress of the project, update status and lead review meeting to ensure that schedules and deliverables are met.
• Coordinated and controlled change request for the clients by conducting impact and cost analysis, prioritizing and mitigating changes.
• Managed the contents using SharePoint 2007.
• Tracked defects using HPALM.

Environment: Waterfall, MS Visio 2010, MS Office Suite 2010(MS Excel, MS Word, MS PowerPoint), Windows XP, MS Project 2010, SharePoint 2010, HPALM 11.0.

Confidential

Business Analyst

Responsibilities:

• Analyzed the business process along with the prior project documentation for complete understanding of the project.
• Also, interviewed SME’s in order to better understand the business process model.
• Captained GAP Analysis by understanding the as-is business process and to-be business process.
• Conducted JAD sessions and one-to-one interviews with key stakeholders and SME’s for requirements gathering.
• Prepared Business Requirement Document (BRD) and Functional Requirement Document (FRD).
• Developed Activity Diagrams, Sequence Diagrams and USE Case Diagrams using MS Visio
• Created sample wireframes to make system better understood by Business and Technology Teams.
• Created the Software Requirements Specifications document.
• Developed GUI components such as Radio Buttons, Text Box, Drop Downs along with the screen designs.
• Handled Change Requests by performing Impact Analysis and obtaining the approval from the Change Control Board.
• Developed Test Plans, Test Scripts and maintained defects using HPQC.
• Also, performed User Acceptance Test (UAT) to make sure that all the requirements are met in such a way that the customers are satisfied.
• Worked on SharePoint 2007 for content management.

Environment: Waterfall, MS Visio 2007, MS Office 2007 (MS Excel, MS Word, MS PowerPoint), Windows XP, HPQC 9.2, Mockups, MS Project 2007, SharePoint 2007, MS SQL Server 2008.

Confidential

Jr. Business Analyst

Responsibilities:

• Involved in high-level requirement meetings with business users and SME’s to understand the requirement.
• Build credibility, establish rapport, and maintain communication with stakeholders at multiple levels (external vendors, business partners and internal IT teams).
• Co-ordinated and facilitated weekly Project status meetings, record and distribute minutes.
• Generating responsiveness, turn around time related metrics and performance Dashboard to the management on a weekly basis.
• Weekly project status reporting, tracking milestones, issues, risks and action items
• Attended weekly change request meetings to document changes and implement procedures to test changes upon completion.
• Collaborate with external teams and stakeholders to make sure the team is in the right direction and provide necessary inputs.
• Performed data integration testing by executing SQL statements and manually verifying the contents.
• Worked with UI team to finalize the user interface.
• Worked on periodic maintenance releases of applications including enhancements and defects.
• Made sure that data was inserted, updated and deleted accordingly using various SQL queries.
• Maintained Requirements Traceability Matrix to ensure all the requirements have been met.

Environment: Waterfall Methodology, MS Office 2007 (MS Excel, MS Word, MS PowerPoint), MS SQL Server 2008, MS Project 2007, Mockup Screens, HPQC 9.2.