We provide IT Staff Augmentation Services!

Business Analyst/scrum Master Resume

Berkeley Heights, NJ


  • Detail - oriented, organized, efficient, proactive, zealous and pragmatic Senior Business Analyst with 8+ years of experience in business analysis implementing a variety of projects in E-commerce, Insurance (Property and Casualty, Multinational, life). SAFe certified Scrum Master with extensive experience in AgileMethodology, Scrum processes and Project Management.
  • Excellent domain and technical knowledge in variousinsurancebusinessprocesses and, have extensively worked on NewBusiness, Underwriting, Policy Administration and Claims.
  • Strong knowledge, expertise and involvement in various phases of Software Development Life Cycle (SDLC) in Waterfall, SAFe, Agile (Extreme Programming, Test-Driven Development), Scrum-Waterfall Hybrid and KANBAN
  • Experience acting as a liaison between technical and business staff, change agent and a servant leader with an ability to communicate technical information to non-technical stakeholders.
  • Experience in mentoring the team and providing business value-oriented conflict resolution.
  • Skilled in facilitating Requirement Gathering Activities to gather SMART requirements using diverse elicitation techniques like Interviews, Requirement Workshops, Prototyping, Survey/Questionnaire, JAD Sessions and Brainstorming.
  • Excellent writing/documentation skills in creating, modifying and analysing Business Requirement Document (BRD), Functional Requirement Document (FRD), System Requirements Specification (SRS), Use-Case Specification.
  • Ability to analyse requirements and identify dependencies in project, processes, data and systems.
  • Proficient in documenting Unified Modelling 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 Mock Up Screens, Balsamiq.
  • Proven Track Record in conducting GAP Analysis, Root cause Analysis, Impact Analysis, cost Benefit Analysis.
  • As a Scrum Master, Motivated and coached the team with scrum principles.
  • Seasoned in facilitating Scrum Ceremonies including Daily Scrum, Sprint Planning, Sprint Review, Sprint Retrospective and Backlog Refinement meeting.
  • Managed Kanban Boards to visualize and track the progress of user stories in a sprint. Enforced WIP limits to improve the flow of user stories.
  • Planned SAFe PI planning event for teams discuss on the scope of next Program Increment for Agile Release Train.
  • Proven expertise in developing Test Cases, Test Plans, Tet Scripts, Test Scenarios, Procedures and Requirement Traceability Matrix and documenting defects using HP QC and HP ALM. Collaborated.
  • Monitored Black-Box Testing, Smoke Testing, User Acceptance Testing (UAT) and Regression Testing.
  • Expert Knowledge of lean methods, waste elimination, 5S, and error proofing
  • Experienced working with Three-Tier Architecture, Client Side and Server side validation.
  • Strong Knowledge on industry standards like ITIL (Information technology information library) and sig sigma
  • Worked on EXCEL using pivot tables, data exports, excel formulas.
  • Thorough understanding of Business Intelligence (BI) and experienced in creating interactive, analytical dashboards using Tableau and SSRS with available data
  • Designed and implemented SQL queries using joins, unions, outer joins, group by and aggregate functions to extract data from different databases (Oracle, SQL Server) for timely reporting and Validation
  • Strong experience in creating workflows and data flows using ETL tools like Informatica and SSIS


SDLC Methodologies: Waterfall, Agile, Scrum, Extreme Programming, Kanban

Project Management Tools: TFS, MS Share Point, MS Project, HP ALM/QC, Test Manager, JIRA, MS Visio, CA Agile

Database: My SQL, SQL Server 2008/2012, Oracle, MS Access

Design Tools: MS Visio, UML, MS Visual Studio, Eclipse IDE

ETL Tools: Informatica, Microsoft - SQL Server Integration Services(SSIS)

Reporting Tools: Tableau, Microsoft - SQL Server Reporting Services(SSRS), EXCEL

Testing Tools: N-unit, J-unit, Selenium, Load runner, Cucumber, manual testing

Graphical Tools: Mock-Up Screens, Wireframes, Axure

MS Office Tools: MS Office (Word, Excel, PowerPoint), MS Project

Languages: HTML, XML, SQL, Java, ASP.Net, ADO .Net

Operating System: Windows XP/10, Mac OS

Domain Knowledge: Insurance (Property & Casualty), Multinational Insurance, E-commerce, Banking


Confidential, Berkeley Heights, NJ


Roles and responsibilities:

  • Conducted GAP Analysis by understanding the AS IS and TO-BE business process.
  • Conducted operational analysis; provides reports and provides recommendations for change as needed.
  • Created process flow diagrams and shared them with Architects to create sequence diagrams for Dev team to better understand the flow/requirements.
  • Conducted JAD session and focus groups sessions with stakeholders for requirement elicitation.
  • Developed wireframes based on requirement and assisted the UX team to create prototypes.
  • Conducted prototype walkthrough with PO’s to make sure prototypes are aligned to user requirements.
  • Grouped features together to identify Minimum Viable Products for release planning.
  • Written user stories in user story format and made sure they adhere to INVEST criteria.
  • Assisted the product owner in prioritizing the backlog item using MOSCOW technique.
  • Facilitated team for playing Planning Poker to help team estimate the Story points for the user stories during the sprint planning meeting.
  • Played a pivotal role in setting up Acceptance Criteria, creating/reviewing test cases, recording test result for all the user stories in Agile Central.
  • Extensively applied the best use of Agile Central tool's features in keeping the track of User Stories, Tasks and progress of the work through tracking the Velocity and Capacity of the team also constantly monitored Burn Down, Burn up Charts and Cumulative Flow Diagrams for evaluation.
  • Coordinated with other scrum masters, system team and shared services in theAgileRelease Train PI planning events and worked with them throughout the Program Increment.
  • As a Scrum Master, facilitated time-boxed Scrum ceremonies including Backlog refinement, Sprint Planning, Stand up meeting, Sprint Review and Sprint Retrospective.
  • Shared weekly report with stakeholders to ensure visibility of current work in progress by the team.
  • Coach the teams to higher levels of maturity, at a pace sustainable and comfortable for team and organization.
  • Worked withScrumteams to resolve impediments blocking the completion of work or commitments.
  • Tracked the risks of teams and was responsible for maintaining the RACI matrix chart of Agile Release Train.
  • Managed Kanban Boards to visualize and track the progress of user stories in a sprint. Enforced WIP limits to improve the flow of user stories.
  • Communicated effectively across company contacts and clients, internal team about the project requirements, schedules and launches.
  • Facilitated GembaKaizen session with the teams to improve their Agile mindset.
  • Reviewed test cases and helped the team with testing to make sure test cases are aligned with requirements. Used Swagger tool to design, document and test the services
  • Utilized my SQL skills to test the ETL and Data mapping between tables.
  • Demonstrated the developed functionalities to the PO’s to get acceptance of user stories in the same sprint.
  • Demonstrated the solution level efforts of project for objective evaluation and feedback.
  • Participated in Scrum of Scrum meetings and ART Sync meetings
  • Attended SAFe PI planning meeting to plan and discuss on the scope of next Program Increment.

ENVIRONMENT: Pega7.2, Angular JS, Oracle, GIT Hub, AWS Code pipeline, Jenkins, Confluence, MS Project, MS (Power Point, Excel, Word, Project, Visio), CA Agile, Balsamiq, Soap UI, Swagger.

Confidential, Brenham, TX


Roles and responsibilities:

  • Analyzed the prior documentation and business processes for full understanding of the project and business rules in the organization for property & casualty domain. Interviewed area experts, asking detailed questions and carefully recording the requirements hereby building a bridge between the business people and technical people.
  • After being on boarded, conducted GAP Analysis by understanding the AS IS and TO-BE business process
  • Involved in prior documentation and business process to understand the scope and development
  • Conducted Gap analysis, Focus groups sessions, document analysis and one-on-one interviews with the stakeholders for the requirements elicitation.
  • Facilitated the JAD sessions for getting sign-off on the requirements gathered.
  • Developed a vision plan that defined organization policies and procedures of the project.
  • Interacted with SME’s, asking detailed questions and carefully recording the requirements in a format that can be understood and reviewed by both technical and business people.
  • Assisted the project manager to construct a project plan that included Project Schedules, Milestones tracking, and Meeting minutes using MS Project.
  • Documented Business Requirement Document and System Requirement Specification documents.
  • Utilized my SQL skills to perform queries to analyse issues during QA.
  • Assisted the developers to create unit tests, test cases to ensure 100% test coverage of the code.
  • As a Scrum Master, facilitated time-boxed Scrum ceremonies including Backlog refinement, Sprint Planning, Stand up meeting, Sprint Review and Sprint Retrospective.
  • Decomposed the scope from the BRD into user stories by conducting a story writing session with the product owner and then the acceptance criteria for the PSPI.
  • Worked along with team members in backlog prioritization and estimation techniques to help product owner in picking Product Backlog Items (PBIs) to commit to in the sprints.
  • Supported the scrum development team by anticipating and resolving impediments and pushed them to deliver quality results based on schedule.
  • Attended PI planning meeting to plan for next release as we had a SAFe environment.
  • Was responsible for handling requirement churn working along with the product owner.
  • Updated all the information radiators like burn down, burn up charts, cumulative flow diagrams(CFD) for tracking team velocity and sprint progress.
  • Create, maintain, and organize backlog of features, epics, stories, and tasks in JIRA.
  • Used JIRA for issue tracking, user story management and requirement traceability.
  • Submitted weekly reports about the progress of the project to our Program Manager.
  • Responsible for identifying and documenting business rules and creating detailed diagrams including Use Cases, Use Case diagrams, Business Flow diagram, process flow models, Data flow diagrams.
  • Assisted the team to build the enterprise data warehouse using Star Schema with individual different data marts to address the area of interest.
  • Assist with User Acceptance Testing, developing and maintaining quality procedures, and ensure that appropriate documentation is in place. Assisted in Black box, UAT and Regression testing.
  • Understood the data requirements and accordingly helped in designing the OLAP cube for analysis.
  • Integrated the various OLTP to the OLAP by using SSIS as an ETL tool, SSRS as the reporting tool and SSAS for performing analysis.
  • Verified data mapping between the databases/tables in SSIS packages ensuring, data is not corrupted.

ENVIRONMENT: MSBI (SSIS, SSRS, SSAS), SQL Server Management Studio, ASP .Net, ADO .Net, Azure SQL Database, Azure SQL Data warehouse, TFS, N-unit, JIRA 6.4, Confluence, MS Visio, MS Project, HTML, MS (Power Point, Excel, Word, Project), IIS Server, SOA, SOAP, XML, JSON.

Confidential, CT



  • Assisted PM in creating work breakdown structure and project charter using MS Project.
  • Conducted extensive GAP analysis by identifying AS-IS and TO-BE process models and process flows, where, how and in turn help product owner to plan how to bridge the gap.
  • Elicited requirements involving vast set of interactions with various stakeholders by facilitating JAD Sessions, Structured Interviews, Process Analysis and Business Rules Analysis.
  • Analysed feasibility of business requirements and defined scope, found out dependencies by interacting with Management Business Analysts, other Subject Matter Experts, Product Owner, Project Manager and Technical Lead.
  • Created a Macro Document incorporating components of Business Requirement Document and System Requirement Specification incorporating business, functional, non-functional, data and GUI requirements which would in turn serve as the centrepiece of the project.
  • Created Use Case Diagrams and Use Case Narratives to make sure Property & Casualty related lifecycle/requirements is understood by the developers and testers.
  • Created Prototypes, Wireframes and Mock-Up Screens using Axure tool.
  • Handled requirement churn during the project by performing Impact Analysis by checking the feasibility in maintaining the triple constraint and discussing them in daily Scrum.
  • Used JIRA for allotting tasks, user story writing, backlog management, issue tracking, user story management and forward and backward requirement traceability.
  • Defined Acceptance Criteria for User Stories to perform User Acceptance Testing. Designed Test Cases, Test Plans and Test Scenarios to perform Functional Testing, Smoke Testing and Regression Testing and logged down defects and systematically managed them in JIRA.
  • Strong knowledge of client side and server side validation and assisted in writing verbiage for client side validation using Java Script and Ajax.
  • Used Informatica to map the data in central data repository and created Data Marts for enhanced Data Management. Used Tableau for generating reports.
  • Created environment for self-organization and organized team engagement activities.
  • Worked on service oriented architecture (SOA), REST, SOAP, XML, API.

ENVIRONMENT: MS Project, HTML, JavaScript: jQuery and AJAX (JSON and XML) technologies, AWS Redhat, Eclipse IDE, MS (Power Point, Excel, Word), TFS, Oracle 11g, Apache Tomcat Server, Informatica, Tableau, Toad, Web Services, SOA, SOAP, XML, JSON.




  • 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.
  • Conducted Gap analysis for As-IS and TO-BE of the process to identify and validate requirements.
  • Prepared Business Requirement Document (BRD/HLD) and assisted preparation of System Requirement Specification (SRS). Analysed, modified and validated these documents.
  • Created Use Cases and built Use Case Diagram and Activity Diagram using Visio.
  • Worked with QA team to design and develop Test Plan and Test Cases to perform User Acceptance Testing (UAT), Functional Testing and Regression Testing.
  • Maintained project documents and shared important links and tutorials, with the team using SharePoint.
  • Coordinated and controlled Change Request for the clients by conducting impact and cost/benefit analysis, prioritizing and mitigating changes and prepared change request form.
  • Conducted data profiling activities such as data clean up and data scrubbing to improve data quality.
  • Assisted in increasing data integrity by performing data normalization.
  • Used ETL to map data and integrate data from different sources to enterprise data marts using SSIS.
  • Assisted the team to build the enterprise data warehouse using Star Schema with individual different data marts to address the area of interest.
  • Helped in gathering requirements for enabling an enterprise to link all of its critical data to one file, called a master file, that provided a common point of reference.
  • Executed functional tests in the QA environment prior to the QAT process and logged tickets for bugs.
  • Facilitated the QA Test process by assigning test cases to the QA test plan in various builds, assigned test cases to the QA testers, and established contact with the testers.
  • Maintained constant communication with the testers by assisting the Project Manager in conducting Daily Defect Review meetings during and after the QA Test process.
  • SOA enabled ITIL framework of support, specialist for Multi-vendor services operating in different states, hands on experience with Lean six sigma methodologies to ensure quality oriented service delivery and reducing bottlenecks
  • Managed and reported on invoice processing and validation of invoices against deliverables.
  • Monitoring vendor SLA process compliance and overall compliance
  • Integrated the various OLTP to the OLAP by using SSIS as an ETL tool, SSRS as the reporting tool and SSAS for performing analysis.
  • Provided Test Status by creating a Bug Summary Report and a Test Progress Summary spreadsheet on a daily basis during the QAT process
  • Participated in Data Validation process in QAT by developing spreadsheets with data from the reports.

ENVIRONMENT: Wireframes, SQL Server, MS office (Word, Excel, PowerPoint, Visio, UAT Testing, SharePoint, ASP.Net, Ado.Net SSIS, SSRS, SSAS.


Business Analyst


  • Actively Involved in Pre-Analysis of project with SME (Subject Matter Experts) and Developers
  • Conducted Gap analysis for ‘As-in’ and To-be of the process to identify and validate requirements.
  • Participating JAD sessions with SME’s and multiple teams for requirement gathering and refinement.
  • Analysed the gathered requirement and reviewed Business Requirement Document (BRD)/Functional Specification Document (FSD).
  • Created System Requirement Specification (SRS) document to describe all data, functional and behavioural requirement of the system.
  • Used Share point for content management and document management.
  • Wrote Use Case and built Use Case Diagram/ Activity Diagram using MS Visio.
  • Created Requirement Traceability matrix (RTM) using HP QC tool.
  • Used JIRA for allotting task and issue tracking, user story management and requirement traceability.
  • Worked with QA team for designingTest Plan and Test Casesfor UAT and regression testing.
  • Tableau was used as a data visualization tool to communicate information clearly and efficiently via the statistical graphics, plots, information graphics, tables, and charts selected throughout the project

Environment: MS Visio, MS Word, MS Excel, SQL, MS Access, Waterfall, Java /J2EE, Spring framework, Rest Web service, Git Hub (version controlling), HP QC, SOA, HTML 5/CSS, IBM Requisite Pro(Requirement management tool).


Data Analyst


  • Interviewed Business Users to gather Requirements and analysed the feasibility of their needs by coordinating with the project manager and technical lead.
  • Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.
  • Designed the Data marts using Ralph Kimball's Dimension modelling methodologies using ERWIN.
  • Worked with Data Architectures and DBA team to implement data model changes in database in all environments. Generated DDL scripts for database modification, Macros, Views and set tables.
  • Attended Data Governance Team (DGT) meetings to address data modelling changes to reviewed databases and the enterprise database.
  • Designed design flow diagrams like level 1 and level 2 diagrams.
  • Designed Star Schema Data Models for Enterprise Data Warehouse using CA Erwin.
  • Generated DDL statements by Forward Engineering and run the SQL scripts.
  • Worked with DBA to perform intensive data profiling and reverse engineered various already existing databases in order to discern the necessary data relationships underlying general and specific information needs.
  • Created data masking mappings to mask the sensitive data between production and test environment.
  • Designed and developed ETL processes using Data Stage designer to load data from Teradata, MS SQL, Flat Files (Fixed Width) to staging database and from staging to the target Data Warehouse database.
  • Successfully worked closely with the QA team, other developers and the DBA to ensure optimal performance of SQL scripts.
  • SOA enabled ITIL framework of support, specialist for Multi-vendor services operating in different states, hands on experience with Lean six sigma methodologies to ensure quality oriented service delivery and reducing bottlenecks.
  • Ensured the system being developed is Six Sigma (6σ) compliant and the defects/bugs at the time of Go-Live are at the minimum

ENVIRONMENT: SSIS, SSRS, SQL Server Management Studio, MS Visio, Rational Rose, SQL server, HPQC, Microsoft Excel.


DB/ETL Developer


  • Identified and defined Entities, relationships and attributes in the data model as per new specifications after analysing the database systems currently in use.
  • Identified source elements and done mapping with the target systems.
  • Improved performance on SQL queries used indexes for tuning created DDL scripts for database.
  • Created PL/SQL Procedures to implement Property & Casualty related business logic.
  • Created database objects like Tables, Stored Procedures, Indexes, Sequences, Views, and Rules etc.
  • Implemented the standard naming conventions.
  • Created Informatica workflows to integrate data from different sources, transform the data and load it in IBM DB2 databases.
  • For database management system, Toad was used for designing, creating and managing DB2.
  • Created data mapping documents for the migration of data from transactional OLTP databases to OLAP databases of Property & Casualty related policy and claim data to different environments.
  • Did rigorous load testing by using Load Runner.
  • Used SQL scripting and automated the scheduling of the data loads to reduce manual efforts.

ENVIRONMENT: Toad, IBM DB2, Informatica power center, MS access, Load runner, Mercury Quality center, ER- diagrams, MS office

Hire Now