We provide IT Staff Augmentation Services!

Sr. Business Analyst Resume

Charlotte, NC


  • 8 + years of Healthcare Industry experience as a Business Analyst/Scrum master with solid understanding of Business Requirements Gathering, Experience in elicitation, documentation and presentation of high level and detailed requirements, Very good experience in development and enhancement for enterprise applications with strong SDLC methodology from Ideation to Implementation of a Project.
  • Professional experience in Business Analysis, Software Development Life Cycle: System Analysis, Design, Development, Testing, and Implementation on Business Systems in a fast - moving environment.
  • Ample experience working with SharePoint Service Applications, Business Connectivity Service, SharePoint Search Service, and Managed Metadata Service,
  • Extensive experience in analyzing and requirements gathering and writing functional specifications including use cases in both waterfall and Agile methodologies.
  • Strong experience in RUP Business Modeling process.
  • Well versed in in-person as well as live meeting, Joint Application Requirements (JAR) and Joint Application Development (JAD) sessions.
  • Expertise in UML (class diagrams, object diagrams, GAP Analysis, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs.
  • Very good experience in Front End UI data handling and documentation using a mix of technologies such as HTML, CSS, jQuery, Java script, Flash and even Silverlight.
  • Working knowledge of health care industry Claims Processing, Medicare, Medicaid and Commercial Claims both from the Health Care Standpoint and the Pharmaceutical Standpoint (PBM).
  • Sound knowledge in the HealthCare transactions: Eligibility Request/Response (270/271), Claim Status Request/Response (276/277), Benefit Enrollment (834), Health Care Services Request (278), Payment/Advise (835) and Health Care Claims (837).
  • Experience in Developing and evaluating business process Models (BPM).
  • Proven success as a business analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.
  • Experience using Salesforce for Outlook settings for managing cases.
  • Excellent hands on experience in various FACETS Modules Product, Providers, Subscriber/Member, Claims and Broker Commission.
  • Design and review of various documents including the Business requirements document ( BRD ), Software Requirement Specifications ( SRS ), Use Case Specifications, Functional Specifications ( FSD ), Systems Design Specification ( SDS ), Solution Summary Document (SSD), Requirement Traceability Matrix ( RTM ) and testing documents
  • Used Postman&SOAPUI for rest service testing.
  • Developed MDM strategies and solutions utilizing SQL server MDS tools.Developed and implemented data feeds from source data models.
  • Used MS Excel spread sheet, PowerPoint, MS Visio, and MS Projects.
  • Demonstrated ability to identify root causes of problems, consider both the long and short-term impact of proposed solutions and develop workable solutions. Ability to manage (Multiple) project tasks with changing priorities and tight deadlines. Ability to work well in a team. Open to Team related tasks, team meetings, team interaction and conference calls.
  • Excellent command over Written and Spoken English Language, Medical Terminologies, Health Care Laws, Policies, Guidelines and Action Plans.


SDLC Project Methodologies: Agile, Waterfall, RSA, Hybrid

Testing tools/Servers: HP Quality Center/ ALM, Cucumber, CRM/Salesforce, FACETS 3.1.0, 2.9.3, TFS, JIRA, RALLY

Software Languages: C, VB Script, XML, Microsoft SQL, Java

Version Control Systems: Rational Clear Case, Rational Rose

System Integration Tool: MS SQL Server, MS Access, and Oracle, Sybase, AS400

Modeling Tools: MS Visio, MS SharePoint, Tableau

Database Management Tool: MS SQL Server, Toad (oracle)

Reporting Tool: Report builder, Report designer

Document Management Tools: MKS, SharePoint, Share Drive


Confidential, Charlotte, NC

Sr. Business Analyst


  • Successfully created a Business Requirement Document (BRD) and Functional Requirement Specifications (FRD) in a timely manner. Conducted the FRD reviews and walkthroughs with designers, developers and stakeholders.
  • Analyzed Business Requirements and segregated them into high level and low-level Use Cases, Activity Diagrams/State Chart Diagrams (UML).
  • Critically evaluated information gathered from multiple sources, reconciled conflicts, decomposed high-level information into details, abstracted up from low-level information to a general understanding, and distinguished user requests from the underlying true needs.
  • Proactively communicated and collaborated with customers to analyze information needs and functional requirements and delivered the following artifacts as needed: Functional requirements (Business Requirements Document), Process Flows, User Stories, Use Cases, GUI, Screen and Interface designs)
  • Worked independently with clients to define project concepts and business cases and under the direction of Project Manager Design and document bureau or department-wide IT solutions when new technology is involved.
  • Drove and challenged business units on their assumptions of how they would successfully execute their plans.
  • Communicated and interacted professionally with a diverse group, peers, executives, managers, and subject matter experts.

Confidential, Detroit, MI

Business Analyst/QA Tester


  • Met with client groups to determine requirements and goals. Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures and create a Business Requirement Document.
  • Worked extensively on the EDI Transactions like; EDI 270, EDI 271, EDI 276 EDI 834, EDI 835, EDI 837
  • Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
  • Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
  • Used Power Shell Scripts to deploy solutions to SharePoint environment and write complex script for managing and duplicating security.
  • Responsible for preparing Software Requirement Specification (SRS) and documenting them.
  • Created Process Work flows, Functional Specifications documents and documented system requirements.
  • Provide implementation assessment, strategy, and mentoring services for Rational Rose, UML and RUP.
  • Validated claims against the HIPAA Standard and processed through the Gateway.
  • Trained business users on SharePoint configuration and provided technical guidance to other team members
  • Identified and clearly defined functional issues and support IT development staff throughout the design, development, unit testing, and implementation phases of the software development life cycle.
  • Analyzed and translated business requirements into system specifications.
  • Used Tableau as data visualization tool to communicate information clearly and efficiently via statistical graphics and to create executive dashboards, weekly/monthly reports on the status of key business measurements.
  • Working with clients to better understand their needs and present solutions using structured SDLC approach.
  • Interaction with the developers and testers to report and correct bugs using JIRA.
  • Worked on Salesforce for business process management and customer relationship managements and also updating technical documentation from functional documentation.
  • Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, and information needs. Ensured that critical requirements are not missed.
  • Aided management in standardizing web applications by preparing GUI standards and recommending alternatives for incorporation in a phased, iterative manner.
  • Interacted with client and the Technical Team for requirement gathering and translation of Business Requirement to Technical specifications.
  • Involved in the re-engineering of SharePoint based CRM system, Identified the processes and prioritize them in order of redesign urgency. Redesigned portal processes.
  • Extraction of test data from tables and loading of data into SQL tables.
  • Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, maps, funnel charts, lollypop charts, donuts, bubbles, etc. and other making use of actions, other local and global filters.
  • Hands on experience in embedding Tableau reports and dashboards on external websites using Java API scripting.
  • Worked on Embedded views of Tableau with web applications to integrate reports.

Environment: : MS Excel, SharePoint (2013), XML, HTML, MS Office, MS Visio, JIRA, HIPAA EDI, UML, SQL, TABLEAU 9.2, 10.1

Confidential, WoonSocket, RI

Sr. Business Analyst/Scrum Master


  • Analyzed the business and system requirement documents, created Business Requirement Document (BRD), Functional Requirement Document (FRD) and responsible for developing detailed test cases.
  • Drove multiple projects with different work streams towards completion of testing, defect resolution, implementation, and support in an Agile/Scrum development environment.
  • Provided life cycle support in FACET’s enhancements to FACET’s workflow and network management suite with pricing and network modeler application - was actively involved in gathering business requirements, assisting in functional design, technical design, and production support documentation for the interfaces
  • Performed impact analysis during the project to manage requirements churn by checking the feasibility in maintaining triple constraints and discussing them in Daily Scrum Stand-up Meeting.
  • Actively assisted the product owner in Prioritizing the Product Backlog as per the maximum business value along with proactively working on grooming User Stories in planning activities using INVEST criteria.
  • Designed Use Cases, Use Case diagrams, Activity diagrams, Entity Relationship Diagram and Sequence diagrams in UML methodology.
  • Proficient in branding SharePoint sites, editing custom master pages, page layouts using CSS and JQuery,
  • Worked on creating, managing and customizing SharePoint site contents, lists, libraries, pages, site columns, content types, workflows, permission, and Out of the Box web parts.
  • Performed Smoke testing, Positive and Negative testing and Usability testing.
  • Validated claims against the HIPAA Standard and processed through the Gateway.
  • Worked extensively on the EDI Transactions like; EDI 270, EDI 271, EDI 276 EDI 834, EDI 835, EDI 837
  • Worked on FACETS Tri Zetto transactions, and Medicare/Medicaid Health Insurance Claims Processing System.
  • Worked on analyzing the mainframe reports for the members /eligibility/claims and mapping the fields with FACETS reports
  • Executed test cases and analyzed test results, found and reported bugs to Team Foundation Server (TFS).
  • Created automated coded UI Test cases using Microsoft Test Manager (MTM).
  • Supported the team in designing the Test Strategy, Test Cases, and Companion Guide from the development stage to the production stage including internal requirements and external requirements.
  • Salesforce.com Reports, Dashboards, Forecasts, Workflows.
  • Providing ongoing maintenance and administration services including periodic data cleansing, custom objects, workflow, Triggers and Integrating existing Applications with salesforce.com.
  • Worked on Service cloud, tracking customer inquiries, escalating issues requiring.
  • Documented and shared the requirements with Salesforce.com consultants for further implementation.
  • Worked on IaaS, PaaS, and SaaS platforms for creating technical documentation and storing huge amount of customer data along with data migration.
  • Acted as a liaison between experts and the client to ensure standards were met, while tracking all project requirements and maintaining appropriate documentation.
  • Assured entry/exit criteria are met for the different phases of testing.
  • Powerful data driven testing with data from files and database by using Postman &SOAPUI for rest service testing.
  • Worked on Tableau for generating Geo Access Maps and dashboards for network adequacy in Provider Data Services.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Assured entry/exit criteria are met for the different phases of testing.

Environment: :Hybrid Agile, MS Project, MS Excel, XML, HTML, MS Office, SharePoint, MS Visio, FACETS, UI, Test Director, Salesforce.com, UML, SQL, QTP, Postman, Power Orders

Confidential, Schaumburg, IL

Sr. Business Analyst/QA Tester


  • Worked closely with the Executive Sponsor, SMEs and stakeholders to define requirements for the various processes and to identify the enhancements and modifications for the To-be processes.
  • Assisted Project Manager and Lead BA in Project planning and setting the timelines for the project and updating Performance metrics spreadsheet as required.
  • Actively involved in the documentation of the Business Requirements, Functional Requirements and wrote BRDs for the various processes as required.
  • Monitored Medicaid Management Information System (MMIS) to make sure it can handle the HIPAA transactions such as 835, 837 (P, D, I) 276, 277, 278. And to make sure the Inbound and Outbound is run through job control language (JCL) in batch mode.
  • Executed test cases for several transactions such as 820, 834, 835, 837, 270/271, 277and 278.
  • With help of SQL developers, Performed Data mapping, logical data modelling, created class diagrams, entity relation (ER) diagrams.
  • Creating unit test cases, creating unit test plans, conducting and/or participating in code reviews, and executing manual testing, user acceptance testing, unit testing and regression testing.
  • Distributed, multi-platform architecture development on high-volume production systems
  • Designed test cases and test scripts for the User Acceptance Testing (UAT) for the core data in Medicaid management information system (MMIS) Legacy system
  • Created and documented Use Cases and Test Cases for the processes defined using HP ALM/Quality Center and RALLY on some other departmental assignments.
  • Worked closely with the Testing team to ensure successful execution of the Test Cases.
  • Used SQL to execute queries to the database for Data mining and to verify integrity of the data.
  • Worked closely with SMEs and end-users to define and outline the As-Is and To-Be procedures and training materials.
  • Conducted JAD sessions and peer review sessions with the SMEs, developers and business users.
  • Analyzed the scope of the project for different review sessions of the application.
  • Operated project testing efforts by performing System Integration testing, Regression testing and by helping UAT team in User Acceptance testing.
  • Created SQL queries to find out the data in HIPPA compliance

Environment:: MS- Visio, HP ALM Quality Center, HP QTP, SQL Server, MS Office, Agile, Web Services, RALLY.


Business Analyst


  • Engaged with project teams to integrate change management activities into the overall project.
  • Involved in HIPAA/EDI Medical Claims Analysis, Design, Implementation and Documentation.
  • Involved in preparing the Test Scenarios for Health Care Claim Payment/Advice.
  • Gathered requirements and prepared business requirement documents (BRD).
  • Created Use Cases, FAD’s and Solution Requirement Document based on the business requirements.
  • Analyzed the defects with QA and Development teams.
  • Conducted face to face meeting, webinars and JAD session to gain process & amp; modeling understanding
  • Written multiple Use Cases for multiple transactions include 837I (Health care claim Institutional), 835(Payment/Remittance advice), 276/277 (Claims status), 270/271 (inquire/response health care eligibility and benefits; both inbound and outbound).
  • Extensively involved in planning efforts for the Digital team including mobile app.
  • Worked with the Project Manager (PM) on various Project Management activities like keeping track of Project Status, Deadlines, Environment Request, and Compliance Issues.
  • Worked closely with project manager and other users and created work flow diagrams using MS Visio/UML.
  • Ensured Use-Cases were consistent and covered all aspects of the Requirements document.
  • Was involved in Functional System Testing, Integration Testing, Regression Testing, and User Acceptance
  • Test using the test cases given by the client before releasing the application.
  • Involved in project status meetings, QA review meeting, and System Test meeting.
  • Created test cases and test scripts for the User Acceptance testing (UAT).

Environment:: MS- Visio, HP ALM Quality Center, HP QTP, SQL Server, MS Office, Agile, Web Services.


Business Analyst


  • Involved in all aspects of the software development life cycle, including requirements analysis, design, development and production support.
  • Involved in database analysis and design and business logic modules. Used Erwin to design the basic database diagrams.
  • Created Tables, Views, Clustered and Non- Clustered Indexes, User defined data types.
  • Created Triggers to enforce data and Referential Integrity.
  • Actively designed the database to fasten certain daily jobs, stored procedures.
  • Writing T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL Queries and Stored Procedures.
  • Use DDL and DML for writing triggers, stored procedures, and data manipulation.
  • Capable of writing complex SQL queries.
  • Perform daily database backup & restoration and monitor the performance of Database Server.
  • Collaborated with the .NET developers and involved in developing web services.
  • Participated in daily scrum meetings, and retrospect meetings after each sprint to discuss the challenges faced and objectives of the next sprint.

Environment: : SQL Server Management Studio (SSMS), SQL Server 2008 R2,Microsoft Visual Studio 2012, ASP .NET MVC 4, MS Office Suite (Word, Excel and PowerPoint).

Hire Now