We provide IT Staff Augmentation Services!

Sr. Business Analyst / Scrum Master Resume

Raleigh, NC

SUMMARY

  • 9+ Years of experience as Business Analyst in Retail, Healthcare Insurance and Finance Industries
  • Knowledge of E - Commerce, Remarketization & Personalization, Business Process Models, Acts (GAAP), Budgeting & Forecasting, HIPAA, ICDs, Preferred provider organization(PPO), Drug formulary, Order to cash applications, Payer-provider concepts, Health Maintenance Organization (HMO), Housing and Maintenance Data Warehouses
  • Performed analysis and assessments onUS Healthcare Insurance, Retail-ecommerce/Investment Banking Front, Middle and Back office applications, environments and third party service provider’s products
  • Excellent knowledge in Retail(Ecommerce)/US Healthcare Insurance compliance and reporting, Statement Analysis, Trend Forecasting
  • Working knowledge and understanding of operational workflows/processes for Retail and Healthcare Insurance.
  • Good understanding on EDI transactions (270, 271, 834, 835, 837), HIPAA gateway, ICD9 and ICD10, HIPAA 4010 and 5010.
  • Extensive knowledge of Procedural and Diagnostic codes, Claims Process, Health information Exchange (HIE), Electronic Health Record (EHR) and Electronic Medical Record (EMR).
  • Supported the risk assessments through the analysis of data elements related to potential indicators of customer, product, or geographic risk, evaluating and enhancing the Marketing & personalization segments of Retail Industry.
  • Extensive knowledge in US GAAP, Adhoc reporting, budegeting & forecasting of various business units
  • Experience in full Software Development Lifecycle (SDLC) from association with end-users for requirements determination, defining the system scope, system analysis, Business Case Development to Rollout, Production, testing, maintenance and documentation, Strong hands on experience in Data Warehousing concepts, Data Mining, DBA tasks like performance tuning and security created ER (Entity relationship Diagrams), Acted as business logic development layer.
  • Excellent technical documentation skills in preparing Business Requirements Document (BRD), Use Case Document, Functional Requirement Document (FRD), Software Requirements Specification (SRS), Workflows.
  • Extensive knowledge of Object Oriented Analysis and Design using UML, Rational Unified Process (RUP), Requisite Pro, DOORS and Visio.
  • Thorough knowledge of UML, RUP, Waterfall, Agile- SCRUM, RAD methodology and rational tools.
  • Proficient in developing Use Case Model, Analysis Model, Design Model, Implementation Model, Use Case Diagrams, Behavior Diagrams (sequence diagrams, collaboration diagrams, and activity diagrams), and Class Diagrams based on UML methodology using Rational Rose.
  • Expertise in project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support
  • Excellent organizational and interpersonal skills with a strong facility for acquiring new knowledge very rapidly, problem-solver skilled at analyzing business needs.
  • Excellent communication skills (written and verbal), ability to proactively build relationships with other team members and interact with Business Units and all levels of Management within the organization.

TECHNICAL SKILLS

Project Methodologies: Waterfall, Agile (SCRUM

Project Management Tools: MS Project, MS Office Suite, CLARITY, Rally

Databases: Oracle, SQL Server, Teradata

ETL Tools: Informatica, SAP BODS

Tools: MS Visio, Oracle, TOAD, SQL Developer, SharePoint, MS Office, Excel, Power Point, Tableau, Erwin Studio

OS: Windows Vista, Windows XP Professional, Linux, MAC

Requirement Tools: Rational Requisite Pro, Doors, Quality Center

Bug Tracking and Reporting: HP Quality Center, Rational Clear Quest, JIRA, Tableau, Cognos, SAP BPC (Business Planning & Consolidation)

PROFESSIONAL EXPERIENCE

Confidential - Raleigh, NC

Sr. Business Analyst / Scrum Master

Responsibilities:

  • Gathered requirements from users and stakeholders using different elicitation technique such as JAD session, work session, interviews, brainstorming and document analysis.
  • Performed analysis on enterprise data/report integration and provided functional specification to development team to build Enterprise Reporting Systems.
  • Performed the GAP analysis to find the Root Cause of the issues.
  • Successfully used Agile/Scrum Method for gathering requirements and facilitated user stores workshop
  • Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.
  • Developed an implementation guide for Partners for EDI X12 transactions such as 834, 835,837,270 and 271.
  • Validated Medical and Hospital claims in FACETS, verified Codes with description and requirements, verified adjudication process of Claims in FACETS
  • Prepared UATs, Reviewing System Test Plans and defect monitoring.
  • Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
  • Scheduled business objects reports using Broadcast agent.
  • Validated data integration by developing and executing test plans and scenarios including data design, tool design, data extract/transform, networks, and hardware.
  • Conducted meetings for creating and execution of test cases, developing and maintaining test plans, defining QA stories for work breakdown structures and work assignment.
  • Worked on the FACETS front end and backend for testing and for documenting the Business requirement documents.
  • Worked with QA testing teams, while interacting with business users and gathering user’s requirements to develop necessary Test plans, Test Cases and Test script.
  • Involved in data loading for the SIT (System Integrating Testing) in the Test Environment.
  • Designed and developed various Ad hoc, Daily, Weekly, Monthly and year-end reports for the Business Analyst using SQL, MS Excel, MS Access and Teradata.
  • Use Cases and other Process Flow Models were designed using Visio and Rational Rose.
  • Used Quality Center to analyze, track and report defects.
  • Worked with relational databases, and developed PL/SQL queries to interact with Databases.
  • Initiating and facilitating all Agile ceremonies and providing Agile coaching to teams on all aspects of the project
  • Management framework, with a strong focus on Scrum practices. Facilitating and documenting all scrum events (as needed) including daily stand up meetings, sprint planning, user demos, retrospectives, and backlog grooming for multiple scrum teams.
  • Managing the product line and reporting the product strength by providing Burn down Metrics and Velocity reports to the management.
  • Gathering the requirements from the user and creating prototypes.
  • Resolving the conflicts on requirements between the UAT users and the Developers.
  • Conducting daily defect review meetings with the users and prioritizing the business impacted defects.
  • Managed project teams across different countries and time zones.
  • Tracked progress on.

Environment: Microsoft Office (MS word, Excel, PowerPoint etc.), Clarity, MS Visio, HP Quality Center, Rally, SharePoint, Confluence

Confidential - Baton Rouge, Louisiana

Sr. Business Analyst / Scrum Master

Responsibilities:

  • Worked with Trizetto Facets claims data for claims subject area, Enrollment and billing data for member/Subscriber, and Product subject areas.
  • Served as a liaison between the internal/external customer support and the IT organization as an attempt to construct an accurate picture of the purpose the implemented system is expected to serve.
  • Systems Documentation included Business Requirements Document (BRD), Systems Requirement Specification (SRS) and test plans using Requisite Pro.
  • Involved in all SDLC stages under Agile process requirement analysis, implementation, testing (functional and use acceptance) and deployment.
  • Conducted numerous JAD sessions with Business users, developer, CQA and SMEs.
  • Prepared the Business Requirement Document (BRD) and Functional Requirement Document (FRD) for the enhancement of the existing services.
  • Coordinated and worked with Project Manager to prepare Project Plan in MS Project for Process Claim Domain.
  • Performed the GAP analysis to find the Root Cause of the issues.
  • Regression testing - test scripts were documented and checked across all the airlines and validated for UAT.
  • Evaluated business requirements and prepare detailed functional and technical specifications.
  • Developed technical design documents and mapping documents for implementing health care HIPAA transactions like 834, 837I, 837P, 837D, 997,270, 271, 276and 277.
  • Streamlined Claims (837,820EDI X12) Migration project by gathering functional specifications.
  • Used QTP to write Data driven test scripts to handle positive and negative sets of data.
  • Created test data for EDI 837I, 837D, 837P to have Segments/loops information with different combination of Submitter, Receiver, Billing Provider, Pay-To-Provider, Subscriber, Payer, Patient, Claim Information, Physicians, Referring Provider, Service Line Info, Adjudication Information.
  • Worked with the QA team in writing Test Plan and conducting the testing process
  • Wrote SQL queries to validate data in database and Facets.
  • Experience in writing the test cases and test plans for Facets.
  • Involved in writing extensive SQL Queries for back end testing Oracle database.
  • Involved in configuration changes in Facets testing.
  • Configured facets modules such as Claims, Membership, Billing, Benefit and plan.
  • Performed QA Acceptance testing for test workflows with business users and performed data encryption testing as per HIPAA guidelines to ensure the privacy, security and confidentiality.
  • Played major role in 24/7 production support for EDI transactions like 834, 837I, 837D, 837P, 270, 271, 276, 277.
  • Processed EDI 837P, 837I,834and 837D transactions, verified 837 transactions were converted correctly to XML file format and verified the claims data loaded to Facets for further processing
  • Extensively used HP Quality center for defect tracking management of test cases.
  • Created Test Suite, added assertions in Soap UI tool to validate the response XML.
  • Developed tables, Views, Stored Procedures and Triggers using SQL Scripting.
  • Planned the UAT testing, test plans, test cases and worked with the business users for UAT test execution in developing the training documentation.
  • Responsible for planning the SIT (System Integration Testing), Defect tracking & closure.
  • Participated in developing and executing Test Plans, performing functional, usability testing and ensuring that the software meets the system Requirement.
  • Formed advanced SQL Queries and used Microsoft Excel to investigate data issues in the Data Warehouse and worked with the Users and Technology Team to formulate a solution to resolve the issue.
  • Maintained Requirement Traceability Matrix (RTM) and managed requirements.
  • Microsoft Office (Outlook, Word, Excel, Visio, Access) at various phases of development for documenting the requirements.
  • Communicated with business and development teams to resolve issues during test execution and ensured enhancements meet established quality and end user needs.
  • Experience in relational databases (RDBMS) like Oracle, SQL, and MS Access.
  • Extensive knowledge of Test Matrix, Traceability Matrix
  • Initiating and facilitating all Agile ceremonies and providing Agile coaching to teams on all aspects of the project
  • Management framework, with a strong focus on Scrum practices. Facilitating and documenting all scrum events (as needed) including daily stand up meetings, sprint planning, user demos, retrospectives, and backlog grooming for multiple scrum teams.
  • Gathering the requirements from the user and creating prototypes.
  • Resolving the conflicts on requirements between the UAT users and the Developers.
  • Conducting daily defect review meetings with the users and prioritizing the business impacted defects.
  • Managed project teams across different countries and time zones.
  • Tracked progress on a daily basis to eliminate potential issues and risks, and present overall project status and metrics to management.

Environment: MS Visio, MS Project, PL/SQL, Oracle, MS Office Suite, SharePoint, Actimize, Rally, Regulatory compliance, Waterfall

Confidential

Business System Analyst / Scrum Master

Responsibilities:

  • Conducted JAD sessions to facilitate cross functional requirements definition andanalysisand determine the scope ofthe project
  • Performed analysis and prepared theAS-ISand TO-Berequirement documents. Performed a completeGAP Analysisto identify problems and inconsistencies with the existing system.
  • Conducted detail and comprehensiveBusiness Analysisby working with end users and stakeholders to identify the system, functional requirements and propose enhancements and technical solutions
  • Conducted requirementsanalysisusing use case driven approach and produced detailed use cases for all the interfaces
  • Documented Vision & Scope document, Use Cases, User Stories and Requirement Specification documents
  • Attended daily scrum call to provide BA activity updates to the team. Worked with Product Owners/functional teams to understand the requirements and document user stories.
  • Utilized MS Team Foundation server (TFS) - Agile Template to document user stories, review and update sprint backlog items and provide inputs to test cases and defects
  • Actively participated in Scrum planning meetings to prioritize user stories and provided inputs in the Retrospective meeting for process and sprint improvements
  • Created Business/ProcessFlow/Data flow diagram andContext diagram, Swim lane diagramusing MS Visio
  • Elicited business and functional requirements by reviewing all outputs/reports to ensure that all data points are defined and mapped correctly
  • Responsible for the designing of an Extract of data from multiple sources, Transform and translate (ETL) data to metadata requirements. Also, involved in verifying and validating Loaded data in file/table
  • Created data mapping documents, data transformation rules and maintaining data dictionary, requirements documents to maintain data integrity from multiple data sources including Oracle and MS SQL
  • Identified roadblocks to mitigate project risks to complete the project and created process improvement plan
  • Worked closely with testing team on test cases/test data, functional, regression, system, integration, end-to-end, and black box resting
  • Interacted with Development and QA Team to ensure overall quality and scalability of the software.
  • Extensively involved in user acceptance testing, performance management and documenting user manual.
  • Helping the team to make decisions.
  • Reflecting Agile and Scrum values to the team.
  • Reminding the team of their arrangements (e.g. policies).
  • Helping the team to continuously improve their process.
  • Reflecting issues to the team through observation from outside of the team.
  • Asking open questions.
  • Checking all the models the team uses (e.g. Sprint backlog, metrics, etc.) and shows them differences between the model and the real world.
  • Helping the team to maintain their Scrum tools (Story board, Action board, charts, backlogs, etc.).
  • Helping team and product owner to find a suitable definition of done
  • Driven efficiency and operational improvement through business process definition, system alignment, and optimization of standard business application functionality.

Environment: MS Visio, Oracle 8i, SQL, MS Word, MS Excel, MS PowerPoint, MS Project, MS SharePoint, Crystal Reports, JIRA

Confidential

Business Analyst

Responsibilities:

  • Gatheredbusinessrequirements through interviews, surveys, and observing from account managers and UI (User Interface) of the existing compliance reporting system.
  • Interacted with the client to felicitate the requirement gathering.
  • Creation of ETL Processes for the added new Subject areas, Develop Data Extraction, Transformation and Loading using Data Services
  • Developed complex mappings to load the data using different transformations like Source qualifier, Aggregator, Lookup, Filter, Expression, Sequence Generator & few more
  • Test the mappings to assure that the data is loaded as per ETL Specification
  • Worked as an ETL consultant throughout the project. Extracted and transferred source data from different data sources like Excel files and flat files into different databases
  • Debugging and Performance Tuning of targets, sources and mappings
  • Creating reports as per the requirement using Cognos from the source data warehouse cubes
  • Debugging and Performance Tuning of targets, sources and mappings
  • Analyzing the progress/performance of ETL Jobs
  • Involved in preparation of Functional Specification Document to consolidate all the requirements which was served as a prerequisite for development and testing
  • Involved in code reviews and performance tuning
  • Performed User Acceptance Testing (UAT)
  • Performed Analysis sessions with Business and Tech teams to finalize the Functional Requirements derived from the high-level business needs.
  • Reviewed the high-Level Design flows with the Tech teams in assuring that the system to be developed is meeting the Business Requirements.
  • Worked with SME's in Sales and marketing business Units to collect thebusiness process requirements, documented them inBusinessRequirement Document (BRD) and performedBusinessProcess Reengineering.
  • Designed Use Cases, Use Case diagrams, Activity diagrams, Sequence diagrams in UML methodology using MS Visio
  • Worked closely with the UI team to model the screens, which met user defined requirements, organizational and regulatory standards.
  • Prepared Requirement Traceability Matrix to map the High-Level Business Needs to the refined Functional
  • Requirements after having multiple JAD sessions with Business Users and Technical Teams
  • Created Class diagrams diagram, Data Mapping and, Logical Data Modeling
  • Conducted work sessions withBusinessPartners and Application Architecture team to help identify all the possiblebusinessand system Alerts/Errors
  • Worked closely with UI team to model the screens, which met user defined requirements, organizational and regulatory standards.
  • Involved in UAT to provide the Test results to Business partners in getting the approvals for the deployment.
  • Involved in the User Acceptance Testing to provide the Test results with the Business team to make sure that there is no deviation from the scope change.
  • Assisted Project Manager in various activities like funding the teams, preparing project initiation deck, project status deck so and so forth.

Environment: Waterfall Methodology, Informatica, Cognos, Oracle MS Word, MS Excel, MS Visio, UML Diagrams, MS PowerPoint

Hire Now