Business System Analyst Resume
Norfolk, VA
SUMMARY:
- Over 8 years of Experience as a Business analyst/Business System analyst in variety of projects under H ealthcare Domain.
- Experienced in different Software Development Methodologies like Scrum, Waterfall, Water - Scrum-fall Hybrid, also have fair understanding of other industry standard methodologies like SAFe.
- Highly proficient in working with diverse users and stakeholders to elicit, analyze, communicate and gather requirements using techniques such as Interviews, brainstorming sessions, workshops like JAD, observations and existing system documentation/procedures- Document Analysis, Prototyping, Requirements Workshops, Questionnaires, Focus Groups.
- Involved in Sprint Ceremonies (Sprint Planning, Daily Scrum, Sprint Review and Sprint Retrospective) for Agile Scrum Methodology. Worked extensively in agile environment creating user stories, documents, and essential business use cases.
- Experienced in writing User stories using INVEST criteria, facilitating Product Owner to prioritize using Moscow, KANO model and also used estimation techniques such as Planning Poker, T-shirt sizing.
- Proficient in facilitating functional requirement walkthroughs for all the impacting projects, knowledge transfer sessions to make the users and other teams aware of all the changes being made in the system.
- Created multiple Unified Modeling Language (UML) diagrams including Use Cases, Activity, Sequence, Data Flow and ER Diagrams using Balsamiq and MS-Visio and assisted in Business Process Modeling.
- Experience in performing GAP Analysis, SWOT Analysis, Impact Analysis, to understand the TO-BE system and modify the AS-IS system.
- Experience in Data warehousing and ETL process. Aware of the DW creation process including OLTP, OLAP, Data marts, Staging, Data sources, Normalization, Dimension tables.
- Good knowledge of the Star and Snowflake schema, different OLAP operations such as slice, dice, roll-up, drill down and pivot, facts and fact tables, etc. transformation and validation rules.
- Involved in Data/Dimensional Modeling; Data mapping, Data integration, Data migration, Data Extraction, Transformation & Loading (ETL).
- Designed and implemented basic SQL queries for reporting/data validation. Also, used Joins, Unions, Outer Joins, and Group by, Order by, and Aggregate functions to extract data from Databases like SQL server.
- Good Knowledge on Web services like REST/SOAP
- Assisted in creating API Documentation containing all the information required to work with the API, with details about the functions, classes, return types and arguments using Open API and Swagger Tools with Automated documentation process
- Involved in conducting UAT sessions, test planning, creating test cases, test execution, issue resolution and report generation to assure that all the aspects of the project follow the business requirements.
- Coordinated with the testing team during the formulation of Test Plan and Test Cases for Functional, System, Integration, UAT (User Acceptance Testing) and Regression Testing, Black Box, White Box based on Design Document, User Requirement Document for the Functional and Performance Testing.
- Involved in maintaining product backlog, writing PBIs, sizing user stories. Managed open issues, removed impediments, & worked with cross-functional teams to improve software quality & test coverage - JIRA.
TECHNICAL SKILLS:
Methodologies : Waterfall, Agile - SAFe.
Project Management : JIRA, HP ALM, MS Project, MS SharePoint.
Database : Oracle DB, DB2, MS Access, SQL Server.
Data Warehousing : Data Modeling, Data Marts, Data Mapping, OLTP, OLAP, ETL, Informatica
Business Modeling Tools : MS Visio, Balsamiq
Defect Tracking : JIRA
Testing Tools : Postman, SOAP U
Operating Systems : Windows 7, Windows 10, Mac OS
PROFESSIONAL EXPERIENCE:
Confidential, Norfolk, VA
Business System Analyst
Responsibilities:
- Gathered and analyzed business requirements from stakeholders (Subject Matter Experts (SME) Business Users and translated into system requirements
- Created user stories, use cases, test cases, end to end workflows, interface diagrams and mapping documents.
- Converted the business requirements into Epics, features and user stories.
- Documented the user stories using INVEST Criteria following (AS a user……., I want……, So that……….) and Acceptance Criteria using Gherkin format.
- Assisting the Product Owner to prioritize the sprint backlog user stories using MoSCoW model in JIRA
- Worked with Product Owners and Business Users to demonstrate the changes in the system to ensure all relevant business needs are addressed
- Created mock ups and wireframes by using Balsamiq, M.S. Visio.
- Maintained and updated the documentation in confluence and SharePoint.
- Used SQL queries for reporting/data validation. Also, used Joins, Unions, Outer Joins, and Group by, Order by, and Aggregate functions to extract data.
- Worked on creating new workflows, Urgency, SLA for Claims, Complaint etc using Pega application.
- Used SoapuI to perform unit testing on integration components and testing web services.
- Involved in maintaining product backlog, writing PBIs, sizing user stories. Managed open issues, removed impediments, & worked with cross-functional teams to improve software quality & test coverage - JIRA.
- Involved in all the Scrum Ceremonies such as like sprint Planning, Daily standup, Sprint Review, Sprint Retrospective.
- Involved in all phases of Software development life cycle by using SAFe agile Methodology.
- Worked with Product Owners and other business system analysts in PI planning session to identify the PI objectives, goals, timelines, dependencies, and risks involved with other cross functional teams
- Collaborated closely with the developers, testers to implement the requirements.
- Performed Acceptance Test Driven Development (ATDD) practice, assisted in writing Test cases and Test Scenarios. Also performed Black-Box testing.
- Performed User Acceptance Testing (UAT) to make sure the developed system functionality meets the defined acceptance criteria
Environment: Agile, Pega 7.1V, 7.3V, MS Excel, MS Word, MS Visio, Balsamiq, Jira, REST API, SOAP API, SOAP UI, Postman.
Confidential, Minneapolis,MN
Sr. Business Systems Analyst
Responsibilities:
- Studied existing business application and processes, current source system , collected end user requirements by using interviews, requirement workshops, brainstorming sessions and suggested the improvised business process model.
- Worked closely with product owner to develop user stories and acceptance criteria to build an incremental business values using Agile Scrum and in JIRA.
- Performed Document analysis, and GAP analysis to analyze As-Is business process and the To-Be system and assisted in fixing the scope of the project and to check the compatibility of the existing system infrastructure.
- Conducted thorough analysis of the Business Requirements and created design specification to accomplish and achieve business needs related to PAR
- Worked with FACETS Team for member information
- Participated in the walkthroughs and meetings specifically for Claims filing processing, weekly status meetings to present status and in corporate any digressions from the original scope.
- Responsible for identifying and documenting business rules and creating detailed Use Case and requirement document.
- Captured process flows by preparing Use Cases, Activity Diagrams and Sequence Diagrams and other UML diagrams for a clear understanding of the project vision by using MS VISIO.
- Involved in creation of Mock-Ups and Wireframes of user interface using Balsamiq for client verification.
- Functioned as the primary liaison between the business line and the technical areas throughout the project cycle.
- Writing SQL queries to extract and analyze data from FACETS Database and produce weekly and monthly reports and also Performed Data analysis and Data validation by writing SQL queries.
- Helped the testing team to successfully conduct User Acceptance Testing (UAT), based on the Design Document and User Requirement Document for the Functional and Performance Testing.
- Used SOAP UI for testing REST and Web services calls also performed manual testing to test the functionality.
Environment: Agile (scrum), Pega, MS Excel, MS Word, MS Visio, Lucid Chart, Balsamiq, MS Project, HPQC, JIRA, XML, REST API, SOAP API, SOAP UI, Swagger.
Confidential, Denver, CO
Business Systems Analyst
Responsibilities:
- Elicited requirements from Business users and stakeholders by interviewing and asking them detailed questions, by JAD sessions, Focus Groups, Brainstorming, Prototyping and recorded and documented the requirements in a format easily understood and reviewed by both business and technical people.
- Involved in all scrum ceremonies like daily stand ups for sprint progress, sprint review to capture any feedback or changed requirements from the stakeholders for Potential Shippable Product Increment (PSPI).
- Assisted Product Owner in slicing, prioritizing, and estimation of user stories.
- Performed Impact Analysis to derive and document requirements for the new Data Warehouse. Performed AS-IS and TO-BE business process analysis to check the compatibility of the existing system with the new business requirements.
- Created UI screen mockups and prototypes for the proposed system, using Balsamiq, to provide a user-friendly front end for the proposed system.
- Developed Use Cases, flow diagram, sequence diagram, using UML diagrams in MS Visio.
- Worked on data integration, data migration, and data modeling. Worked with Informatica power center for extracting, transforming, loading, and maintaining the data.
- Helped the data warehouse team with information to support th0e analysis of the data requirements for reporting and in defining the source to target data mappings, business rules and data definitions.
- Assisted in Normalization of databases up to 3NF to put them into the star schema of the data warehouse.
- Helped translate Business processes into Informatica Mappings for building Data marts and used transformations of Informatica for various types of data conversions, and logical data modeling.
- Assisted the data analyst with trigger functions like Insert, Update and Delete to maintain the data integrity and set specific procedures for the data flow in the data warehouse.
- Assisted in creating the data profiling stored procedure using dynamic SQL, as well as in generating complex scripts to schedule using SQL to test various reports and ETL load jobs in development and QA.
- Executed SQL Join queries like outer join, inner join and cross join to pull data from multiple tables and validate the data for its accuracy and data integrity.
- Assisted the programmer and the technical writer in designing API implementation documentation, describing how to effectively use the Software API for system integration using Postman.
- Extensively worked on JIRA as an issue tracking tool by creating EPICS, User stories and for resolving issues & bugs.
Environment: Agile Scrum, JIRA, MS Visio, HP ALM, Informatica Power Center, MS outlook, UAT, MS office Suite (Excel, Word, Power point), Oracle, XML, REST API, SOAP, Postman.
Confidential, Weston, FL
Business Systems Analyst
Responsibilities:
- Elicited requirements from Business users and stakeholders by interviewing and asking them detailed questions, by JAD sessions, Focus Groups, Brainstorming, Prototyping and recorded and documented the requirements in a format easily understood and reviewed by both business and technical people.
- Developed and Maintain Business Requirements document (BRD) and Software requirements specification (SRS)
- Develop and maintain Functional Specification Document (FSD)
- Performed Impact Analysis to derive and document requirements for the new Data Warehouse. Performed AS-IS and TO-BE business process analysis to check the compatibility of the existing system with the new business requirements.
- Created UI screen mockups and prototypes for the proposed system, using Balsamiq, to provide a user-friendly front end for the proposed system.
- Developed Use Cases, flow diagram, sequence diagram, using UML diagrams in MS Visio.
- Worked on data integration, data migration, and data modeling. Worked with Informatica power center for extracting, transforming, loading, and maintaining the data.
- Helped the data warehouse team with information to support th0e analysis of the data requirements for reporting and in defining the source to target data mappings, business rules and data definitions.
- Helped translate Business processes into Informatica Mappings for building Data marts and used transformations of Informatica for various types of data conversions, and logical data modeling.
- Assisted the data analyst with trigger functions like Insert, Update and Delete to maintain the data integrity and set specific procedures for the data flow in the data warehouse.
- Executed SQL Join queries like outer join, inner join and cross join to pull data from multiple tables and validate the data for its accuracy and data integrity.
Environment: Waterfall, MS Word, MS Excel, Outlook, MS Visio, MS Project, HP ALM, SQL, REST API, SOAP UI.
Confidential
Business Analyst
Responsibilities:
- Performed Business Process re-engineering and Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements
- Elicited the business requirements for the project using One-One Interviews, Document analysis, Surveys, JAD sessions and used the standard template of the organization to develop requirements.
- Used wireframes and screenshots for the application to easily communicate it to the users using MS Visio.
- Conduct project related Presentations periodically to the management and end users during various phases of SDLC.
- Used DDL, DML and DCL SQL queries to perform data analysis, data validation and data manipulation.
- Working with Data warehouse team and source systems in preparing Data mapping documents and data models to procure the required data feeds into the Application.
- Involved in data analysis techniques to validate business rules and identify low quality missing data in the existing enterprise data warehouse (EDW).
- Used API’s to integrate various service providers through RESTful API services. Performed the API documentation and completed the API testing using POSTMAN.
- Identified bugs during the test phase and reported using JIRA. Assisted the Testing team in creating Test Plans, Test Scenarios, Test Cases and collect Test Data for successful completion of Integration and Functional testing.
- Conducted User Acceptance Testing with UAT cases and resolved issues with the users.
- Generated different reports for predictive and exploratory analysis using IBM Cognos reporting tool.
Environment: Waterfall, MS Excel, MS Word, MS Visio, Lucid Chart, Test Manager, UAT, MS Project, SQL server, Cognos, HTML, CSS.
Confidential
Business Analyst
Responsibilities:
- Conducted formal interviews, Live Meetings and JAD sessions with business users Subject Matter Experts (SME's) to gather the requirements and transformed those into Business Requirement Document (BRD).
- Prepared detailed Business Requirement Documents (BRD) to in corporate high-level business requirements, and Software Requirements Specification (SRS) for functional, non-functional requirements.
- Monitored and assisted in designing and development of Use Cases, Activity Diagrams, Sequence Diagrams, using UML.
- Worked on interface requirements for the Patient Appointment feature in the system that allowed the user to check the Doctor's availability & their schedule before finalizing the patient's appointment.
- Maintained a Requirement Traceability Matrix to ensure that all Functional Requirements are addressed.
- Worked with the Doctors & other Medical staff to understand the requirements for new features.
- Documented & validated the requirements for Patient Care Module which includes the IPD & OPD modules. The main components of IPD & OPD modules were Patient Appointments & Hospital visit history, as well as patient Admission details.
- Worked on capturing the requirements for generating solution for patient appointment & hospital visit history required a unique Patient MRN (Medical Record Number) to be generated so that these details could be tracked accordingly. It also needed the search feature so that a patient could be searched on MRN, Name & DOB.
- Conducted User Acceptance Testing with UAT cases and resolved issues with the users.
- Worked in close co-ordination with the QA analyst and testing team, reviewed and validated test plans, test cases and test scenarios.
Environment : Waterfall, MS Access, MS Visio, MS Project, Windows XP, MS-Office, RTM, SQL.
Confidential
Business Analyst
Responsibilities:
- Conferred with Business Users to elicit requirements using various techniques like interviews, requirement workshops, JAD sessions and worked with design & development team on the solution design.
- Study of the existing application and mapping of existing functionality to the proposed system
- Interacted with users to verify user requirements, manage Change Control, and update existing documentation.
- Prepared detailed Business Requirement Documents (BRD) to in corporate high-level business requirements, and Software Requirements Specification (SRS) for functional, non-functional requirements.
- Worked on GUI development: created screen-mock-ups to review requirements, provide feedback on the screen design.
- Experience in documenting the Requirements Traceability Matrix (RTM).
- Demonstrated understanding and experience with SQL queries.
- Assisted QA team in developing test plan, test cases, test scenarios based on business requirements and technical specifications.
- Collaborated with the QA team to ensure adequate testing of software by conducting UAT.
Environment: Waterfall, MS office, M.S Visio, MS Access, Balsamiq, SQL server
