SUMMARY

• Sr. Business Systems Analyst/ ScrumMaster with 8+ of experience in Business Development Process and System and Data Analysis.
• Extensive knowledge, expertise and involvement in various phases of Software Development Life Cycle (SDLC) in Waterfall, Scrum, Agile (Extreme Programming, Test - Driven Development) and Scrum-Waterfall Hybrid software development life cycle environments.
• Substantial experience in conducting structured walkthroughs using workflow diagrams to identify, understand and conduct process analysis for business process improvement (BPR) and modeling.
• Skilled as a liaison between technical team and management, change agent and a servant leader with an ability to communicate technical information to non-technical stakeholders. Experience of mentoring the team and providing business value oriented conflict resolution.
• Experienced in mentoring the team and providing business value oriented conflict resolution.
• Skilled in conducting and facilitating Requirement Gathering Activities to gather SMART (Specific, Measurable, Attainable, Realistic and Timely) requirements using diverse elicitation techniques including, but not limited to, Interviews, Prototyping, Survey/Questionnaire, JAD Sessions and Brainstorming.
• Ability to analyze requirements and identify dependencies in project, processes, data and systems.
• Excellent writing & documentation skills in creating, modifying and analyzing Business Requirement Document (BRD), System Requirements Specification (SRS), Use-Case Specification, High Level and Low Level Documents (HLD/LLD).
• Detailed understanding of preparation of RACI Matrix (Responsible, Accountable, Consulted and Informed) and Requirement Traceability Matrix (RTM) throughout the process to verify adherence.
• Proficient in Requirement Management, Sprint Planning, Issue Tracking, Impediment Management, and Work Allocation using tools like JIRA and HP ALM.
• Thorough understanding of preparation and use of Unified Modeling Language(UML) diagrams including Process Diagram, Activity Chart, Use Case Diagram, Sequence Diagram, Data Flow Diagram and ER Diagram using MS Visio and Rational Rose to support system design.
• Experienced in creating Prototypes, Wireframes and Mock-Up Screens to visualize Graphical User Interface (GUI) using tools like Balsamiq Mockups and Mockup Screens.
• Proven Track Record in conducting AS-IS and TO-BE analysis, ROI Analysis, GAP Analysis, Risk Analysis, Cost-Benefit Analysis and SWOT Analysis to assist Product Owner and Project Manager in planning.
• Assisted the underwriter in performing Credit Risk Analysis by analyzing different factors.
• Seasoned in facilitating Scrum Ceremonies including Daily Scrum, Sprint Planning, Sprint Review, Sprint Retrospective and Backlog Refinement meeting.
• Experienced in conducting Scrum Training Workshops and User Story Writing workshops to familiarize stakeholders with Scrum process skeleton and concept.
• Adept in handling Requirement Churns by performing Impact Analysis.
• Well versed with backlog prioritization techniques (MoSCoW, Business Value, Kano, And Technical Risk) and estimation techniques (Planning Poker and T-shirt sizing) to help product owner in picking Product Backlog Items (PBIs) to commit to in the iterations (Sprints)
• Proven expertise in developing Test Cases, Test Plans, Procedures and Traceability Matrix and documenting defects using HP QC and HP ALM. Collaborated and monitored Black-Box Testing, Smoke Testing, User Acceptance Testing (UAT) and Regression Testing.
• Experienced in working on Three-Tier Architecture, Client Side Verification and Server side Verification.
• Well versed with writing SQL queries to integrate and extract data for analysis and reporting.
• Detailed understanding of Data Modeling and Schemas and use of Business Intelligence (BI) to enable effective decision making.
• Thorough understanding of Business Intelligence (BI) and experienced in creating interactive, analytical dashboards using Tableau and IBM Cognos for decision making.

TECHNICAL SKILLS

Operating System: Windows XP/Vista/7/8/10

Modeling Tools: MS Visio, Mock-Up Screens, Rational Rose

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

Business Skills: Process Modeling, Change Management, GAP Analysis, Impact Analysis, SWOT Analysis, JAD Sessions, Project Scheduling, Project Budgeting

Data Warehousing: Data Modeling, Data Marts, OLTP, OLAP, Data Mining, Slicing/Dicing, Drill Up/Drill Down, Pivot

Project Management Tools: MS Project, MS SharePoint Server (2013,2010, 2007)

Requirement Management: JIRA, HP ALM, MS Office

Testing Tools: HP QC, HP ALM

Reporting/BI tools: Tableau Desktop, IBM Cognos, MS Excel

ETL Tools: Informatica Powercenter v9.x, SSIS

Methodology Tools: JIRA, HP ALM

Databases: MySQL, Oracle, MS Access

Languages: HTML, XML, SQL, C++

PROFESSIONAL EXPERIENCE

Confidential, BUFFALO, NY

SR. BUSINESS ANALYST/SCRUM MASTER

RESPONSIBILITIES:

• Conducted GAP analysis by identifying AS-IS and TO-BE process models and process flows.
• Facilitated JAD Sessions with users, developers, and database design team to deal with backend synchronization issues accompanied with interviews and document analysis.
• Worked with the Business Owners to identify a Risk Response Strategy based on the Positive and Negative Risks associated with the project.
• Assisted the underwriter in performing Credit Risk Analysis by analyzing different factors like Payment History, New Credit, Amount Owed, Length of Credit History and Type of Credit.
• Identified the requirements of the stakeholders and created Business Requirement Document (BRD) and Functional Requirement Document (FRD).
• Performed What-if analysis using Excel as per the requirements of the managers.
• Created Use Case Diagrams, Activity Diagrams and Entity Relationship Diagram (E-R) using MS Visio and developed a better understanding of Business Processes involved.
• Facilitated the Various Scrum meetings, which included Daily Scrum meetings with the Scrum development team.
• Maintained Sprint burn down chart, Product burn down chart, Time boxed the Sprints and Daily Scrum meetings for the record.
• Managed Product Backlog with the help of Product owner and Scrum development team by using JIRA also generated reports to analyze the performance of the project.
• Created Requirement Traceability matrix (RTM) and managed migration process and developer fixes, retested fixes, defects/bugs tracking, issue log and tracked progress for team members of project through completion.
• Broke down EPICS into smaller user stories by applying INVEST model.
• Worked with the Product Owner during the Sprint Review Meeting for the Potential Shippable Product Increment (PSPI) and help decide which feature is DONE and satisfied using the acceptance criteria.
• Actively participated in the testing of the system during UAT, Regression Testing, and Black box Testing.
• Responsible for numerous decisions in respect to business policies, procedures, methods for implementation.
• Administered ETL Process and identified source table, target table and mapped the data, created the data mapping document using Informatica Powercenter.
• Used WSDL and SOAP to in corporate web services to provide inter-platform connectivity.
• Created various types of reports/sub-reports and drilldown like standard and cross tab -reports with bar chart, pie chart and line-chart graph representation reports using Tableau.
• Used SharePoint 2013 as Content management system for maintaining documents.
• Performed SQL query operation such as DML and DDL commands and also supervised the source to target mappings in Informatica Power Center.
• Performed SQL queries using JOINS and nested queries to fetch data from MS SQL Server.
• Created deployment flowchart in conjunction with the development, infrastructure, and network teams containing instructions for maintaining the Application.

ENVIRONMENT: Hybrid (Waterfall - Scrum), JIRA 6.1, MS Project 2013, SharePoint (2013), MS Visio, MS Office 2013 (MS Word, MS Excel, MS PowerPoint), UML, MS SQL Server 2012, HTML, Tableau 8.0, Informatica PowerCenter, Data Mapping, Data Transformation, WSDL, SOAP, Data Marts.

Confidential, SAINT PAUL, MN

SR. BUSINESS ANALYST

RESPONSIBILITIES:

• Involved throughout the System Development Life Cycle (SDLC)-Waterfall.
• Gathered project requirements, using techniques such as: JAD, document analysis, requirements workshops, and interviews with Subject Matter Experts (SME) and stakeholders.
• 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.
• Assisted in creating a Risk Management Plan for identifying, assessing and monitoring different kinds of risks.
• Worked with GUI development, requirements creation/design to create the initial UI wireframes, and mockups.
• Developed Mockup screens and prototypes for the learner’s home page requirements document.
• Created Use Case document by specifying actors, normal flow, alternative flows for all use cases.
• Used HPALM for requirements gathering, and writing the associated test cases against the requirements.
• Worked with end users to define User Acceptance Test scenarios and write the Test Plan.
• 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.
• Coordinated with the other business analysts for assisting the Data mapping process, Data extraction and Integration to the data mart.
• 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.
• Used Tableau to perform various different visualizations.

ENVIRONMENT: Waterfall, MS Project Professional 2013, Informatica PowerCenter, MS Office 2013(MS Word, MS Excel, MS PowerPoint, MS Visio), GAP Analysis, UML, Tableau 8.0, HPALM 11.0x, Data Mapping, Data Extraction, Data Integration, SOA, WSDL, SOAP.

Confidential, BROOKLYN, NY

BUSINESS SYSTEMS ANALYST

RESPONSIBILITIES:

• Understood state of art processes by interacting with stakeholders and documents analysis and performed GAP analysis to assist Product Owner and Project Manager in planning the transition.
• Facilitated JAD sessions as Moderator and conducted interviews with various Subject Matter Experts (SMEs) and stakeholders, process reviews and policy & procedure reviews to elicit requirements.
• Prepared Business Requirement Document (BRD/HLD) and assisted in preparation of System Requirement Specification (SRS). Analyzed, modified and validated these documents.
• Created Use Cases and built Use Case Diagram and Activity Diagram using MS Visio.
• Managed and tracked requirements using HP ALM through Application Life-Cycle.
• Worked with QA team to design and develop Test Plan and Test Cases to perform User Acceptance Testing (UAT), Functional Testing and Regression Testing.
• Assisted Data modeling process by creating conceptual and logical ER diagrams and designing database schemas to help development of an accurate Data Warehouse Structure.
• Integrated various OLTP to the OLAP by using Informatica as an ETL tool and used Tableau as reporting tool. Also maintained the Bill Inmon and Ralph Kimball Paradigms.
• Assisted in scripting business rules for classes in middle tier application, and assisted in drafting agreements for various web services in a Web Service Level Agreement (WSLA) document in XML.
• Assisted in increasing Data Integrity by performing Data Normalization and adding Data Verification and Validity to maintain accuracy and effectiveness of data.
• Had experience in the usage of SharePoint 2010 for content and document management.
• Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries on MS SQL Server.
• Was involved in using Tableau for effective reporting to provide Business Intelligence (BI) to facilitate expenditure tracking using various matrices critical to decision making.
• Involved in implementation by assisting in the preparation of training module. Helped the end users getting accustomed to the system by live demonstrations and system tutorials.
• Timely tracked progress and reported it to Product Owner and Project Manager.

ENVIRONMENT: Waterfall, MS Office 2007 (MS Word, MS Excel, MS PowerPoint), Tableau 8.0, Informatica PowerCenter, MS Visio 2010, MS Project 2010, HP ALM, Wireframes, Mock-Up Screens, MS SQL Server 2008 R2, SharePoint 2010, GAP Analysis, UML, Data Normalization, Data Modeling, Data Verification, Data Mining, OLTP, OLAP, XML, SOAP, WSDL.

Confidential, DULUTH, GA

BUSINESS ANALYST/SCRUM MASTER

RESPONSIBILITIES:

• Conducted GAP Analysis to understand limitations of the existing system and contributed to design of future system; assisted in modeling the AS-IS and TO-BE business workflow.
• Performed document analysis to derive business rules from legacy system and validated them with stakeholders for consistency and completeness.
• Assisted in designing systems integration with Microsoft Dynamics CRM and other business systems and integration tools.
• Analyzed requirements wrote User Stories and managed Agile Lifecycle in JIRA from planning to sprint deployment. Tracked and communicated team velocity and sprint/release progress. Assisted in managing the Product Backlog and Sprint Backlog.
• Reviewed and assisted the team in functional testing of the application prior to demo in the sprint review meeting. Maintained the Sprint Burn down and Release Burn Down charts.
• Developed test scenarios/scripts, test plans, prepared user acceptance test cases (UAT), UAT issue log for tracking the defects in JIRA and collaborated with system users to conduct UAT.
• Developed use case documentation for system requirements, business process flows, and screen mockups using MS Visio.
• Removed internal and external impediments that hinder team’s productivity. Worked with the team in the grooming and prioritization of product backlog using technique such as planning poker.
• Served as liaison between the scrum team, architect and key stakeholders, earning their confidence with reliable follow-through.
• Instructed and modeled core agile principles of collaboration, prioritization, team accountability and visibility. Ensured consistent application of scrum methodologies across the team.
• Used SharePoint 2010 as Content Management System for maintaining documents and templates available across the organization.

ENVIRONMENT: Hybrid Waterfall-Scrum Methodology, JIRA 5.2, MS Office 2007 (MS Word, MS Excel, MS PowerPoint), Mock-up screens, Microsoft Dynamics CRM, SharePoint 2010.

Confidential

BUSINESS ANALYST

RESPONSIBILITIES:

• Analyzed existingsystem processes, gathered requirements for new processes & documented Software Requirements Specifications (SRS)
• CreatedBusinessRequirement Document (BRD) specifications using MS Visio and Word
• Creating GUI mock-ups using MS Visio to understand UI and UX requirements.
• Planned and defined system requirements & use cases.
• Worked withbusinesspartners to define the scope & divide it in multiple sprints, as part of the agile team.
• Organized and facilitated sprint planning, daily stand-up meetings & reviews
• Tracked and communicated team velocity and sprint/release progress
• Managed defect triage meetings & prioritized them as part of the sprint
• Prepared user stories & documented requirements based on user stories
• Analyzed non-functional requirements such as response time, throughput to better serve the end user.
• Actively involved in walkthroughs and meetings with development team to discuss related issues.
• Maintained all the functional documents up to date throughout the project
• Reconciliation between reports generated out of existing system and the new systems built.
• Performed SQL queries using joins and nested queries to fetch data from MS SQL Server.
• Performed SQL query operation such as DML and DDL commands and also supervised the source to target mappings.

ENVIRONMENT: Scrum Methodology, MS Office 2007 (MS Excel, MS Word, MS PowerPoint), MS Visio, MS Project, Mock-Up Screens, UML, MS SQL Server 2005, SharePoint 2007.

Confidential

BUSINESS ANALYST

RESPONSIBILITIES:

• Interacted with the customers and internal stakeholders to gather user requirements and their expectations from the system.
• Involved in analyzing Business Requirements and developing System Specifications.
• Analyzed monthly/quarterly performance against plans and forecast and recommended corrective actions.
• Assessed business priorities, and advised business units on risks and Cost-Benefit analysis.
• Used MS Visio to generate various UML Diagrams.
• Organized cross training of team members and users to become more responsive.
• Participated in the development and preparation of the Test Plan with the testing team as well as ensuring testability, reliability, usability, maintainability and performance of the application.
• Involved in incident reporting and change and configuration management procedures.
• Ensured that the modifications suggested by the users were incorporated into the application.
• Formed a bridge between the Project Manager and different teams with effective presentations.
• Performed SQL queries using joins and nested queries to fetch data from MS SQL Server.

ENVIRONMENT: Waterfall Methodology, MS Office 2007 (MS Excel, MS Word, MS PowerPoint), MS Visio 2007, MS Project 2007, Mock-Up Screens, UML, SharePoint 2007, MS SQL Server 2005.

Confidential

JR. BUSINESS ANALYST

RESPONSIBILITIES:

• Worked with the Project Manager in defining the scope and requirements of the project.
• Captured the existingbusinessfunctions and processes.
• Gathered the requirements using different elicitation techniques such as JAD Sessions, Interviews and Brainstorming.
• Assisting in creating a high level Business Requirements Document (BRD) and Functional Requirements Specification (FSD) document.
• Created Wireframes and Mock Up Screens using various UI components such as Radio Buttons, Text Box, Drop Down Box etc.
• Defined business rules pertaining to the reservation system.
• Created UML diagrams (Structural, Behavioral and Interactive) and created Information Diagrams, Activity Diagrams and Process Flow Diagrams using MS Visio.
• Utilized MS Project to create Work Breakdown Structures (WBS), prioritized the tasks and to track the progress of the project and improve efficiency from time to time.
• Coordinated in creating Test Plans, Test Cases and Requirements Traceability Matrix (RTM) and logged all the defects using HPQC.
• Was involved in User Acceptance Testing (UAT), Black Box Testing, Regression Testing, GUI Testing and Smoke Testing.
• Was involved in dealing with Change Requests by performing Impact Analysis.
• Performed SQL queries using JOINS and Nested queries to fetch data from MS SQL Server.

ENVIRONMENT: Waterfall Methodology, MS Office 2007 (MS Excel, MS Word, MS PowerPoint), MS Visio, MS Project 2007, Mock-Up Screens, UML, HPQC, SharePoint 2007, MS SQL Server 2005.