SUMMARY

• Professional experience of over 8 years working in various comprehensive projects in Datawarehouse, Health care, Health Insurance, Hospital, Pharmaceutical domains as a Business Analyst, Sr Business Analyst and a Data Analyst.
• Experienced and in - depth knowledge of different phases of System Development Life Cycle (SDLC) and methodologies such as Waterfall, Agile-Scrum, SAFe, and Waterfall-Scrum Hybrid.
• Possess good people skills and Communication skills
• Conducted various analysis like GAP Analysis, Feasibility Analysis, Impact Analysis, Cost Benefit Analysis, Risk Analysis, and SWOT Analysis.
• Experienced in Identifying, Reviewing, Analysing and Documenting the business and user needs.
• Used different Elicitation Techniques for the Requirements Gathering like Brainstorming Sessions, Joint Application Development (JAD), Interview Sessions, Workshops, Focus Group, Surveys, Questionnaires, Document Analysis, and Observations with Subject Matter Expert (SME's), Business users and Business Owners.
• Proficient in gathering and analyzing the Business Requirements and documenting them into Business Requirement Document (BRD), Functional Specification Document (FSD) and System Requirement specification (SRS).
• Experienced with Business Process Reengineering and addressed business problems by identifying new applications of technology to make business more efficient.
• Experienced in creating Test Plans, Test Scenarios and Test cases and documenting project processes and procedures.
• Identified Business Problems and formulated Solutions to meet the Business needs.
• Experienced in handling and implementing the change effectively by using change management process.
• Experience with various tools for planning, tracking and managing projects such as Atlassian Jira, Team Foundation Server (TFS), HP Agile Manager and MS Project Professional.
• Good knowledge in process modelling and created UML Diagrams (Use Cases, Sequence Diagrams, and Activity Diagrams) Workflow diagrams with the help of MS Visio, and Rational Rose.
• Designed Prototype, Mock-up screen, and Wireframes using MS Visio while developing GUI applications
• Expertise in facilitating UAT testing, Regression testing, Smoke testing, and SIT testing.
• Experienced in writing the User Stories using the INVEST format and handling the requirement churn.
• Have worked with Scrum artifacts like Sprint Burn down charts, Product Burn down charts, product backlog and impediments list.
• Have participated in Story Point estimation where techniques such as Planning Poker, T-shirt sizing and prioritization techniques like Moscow and Kano were used.
• Developed and maintained all project related documentation needed for implementation of application.
• Used SharePoint and docSTAR for Content Management for managing documents.
• Experience with database queries on various RDBMS like Oracle, SQL Server, My SQL, MS Access, Stored procedures and Online Analytical Processing (OLAP).
• Knowledge in Data warehousing concepts- Data modelling, Data mapping, Conceptual, Logical & Physical Data Model, Star schema, Snowflake schema, and Normalization.
• Experienced with data analysis & data mapping.
• Good knowledge and experience with the Relational Database Concepts.
• Experience in designing dimensional modelling, star and snow flake schemas, Fact and dimension tables, physical and logical data modelling using Erwin modelling tool.
• Good experience in identifying the Reporting Needs and Data Base Requirements.
• Working knowledge of XML including validation of Web Methods, Web Services, WSDL, SOAP, UDDI, HTML, AJAX and CSS
• Experienced in setting up and administrating Sharepoint 2013.
• Developed systems complying withthe rules defined by Health Insurance Portability & Accountability Act (HIPAA) and Health & Human Services (HHS): Privacy Rule, Security Rule, Transactions & Code Sets Rule, Unique Identifiers Rule (NPI)
• Good understanding of Health Insurance Programs (Medicaid, Medicare Part A, Part B, Part C, Part D) and Managed Care Programs (HMO, PPO, POS), with expertise in HIPAA transactions and paper claim forms (CMS 1500, UB 04).
• Experienced working in Datawarehouse Environment.
• Knowledge of File Formats used for EDI transactions ASC X 12 837/276/277/834, 999 Functional Acknowledgement and TA1 Interchange Acknowledgement.
• Knowledge on Healthcare Claim Processing and HIPAA Standard Transactions X12-837 for Equivalent
• Status request and response, X12-270/271 Eligibility inquiry and response for a Health Plan,
• Good Knowledge in Medicaid Management Information Systems (MMIS), Claims Process, Electronic Medical Records, Electronic Health Records and HL7 standards.
• Assisted in converting ICD-9 codes to ICD-10 codes by General Equivalence Mapping (GEM).

TECHNICAL SKILLS

Requirements Management: JIRA, Team Foundation Server (TFS), HP ALM, Sharepoint 2010,2013

Methodologies: Waterfall, Agile-Scrum, Agile-Waterfall.

Database: Teradata, MS Access, MS SQL, SQL Server

MS Office Tools: Word, Excel, PowerPoint, Visio

Project Management Tools: MS Project, MS SharePoint server 2007,2010,2013, JIRA

Business Modelling tools: MS Visio, Rational Rose.

ETL Tools: Informatica, SSIS

Reporting tools: Business Objects, BI Query, Tableau, Crystal Reports

Testing Tools: HP Quality Center, HP ALM

Operating Systems: Microsoft Windows 7,8,10, XP / vista

Languages: HTML, XML, AJAX, SQL

Healthcare: HIPAA compliance, Medicare, Medicaid, MMIS, Claims Process, HL7, ICD-10

EDI Transaction sets: 270, 271, 276, 277, 834, 835, 837

EDI Tools: DataConnect

Other Tools: Teradata Assistant, SSMS

PROFESSIONAL EXPERIENCE

DATA BUSINESS ANALYST

Confidential, Phoenix, Arizona

Responsibilities:

• Gathered requirements for new table creation in Data warehouse in provider, Authorization and claims area.
• Gathered requirements for new Data - marts and create Business Requirements Document (BRD).
• Collaborated with Business users, Data Architects and SQL developers to ensure alignment with standards and requirement detail to allow solution development with minimal additional discovery.
• Facilitated JAD sessions, Brain Storming sessions and Team meetings.
• Designed STTMs (Source To Target Mapping) for Stage, Integration and consolidated layer to bring in data from other sources into Data warehouse.
• Worked with developers in creating, validating and documenting SSIS Packages and Job Schedules.
• Written SQL queries to explore relation among complex data sets.
• Worked extensively on documenting the ETL data load processes in SSIS.
• Data analysis using adhoc queries to test the correctness of data.
• Developing process flow documentation and design using MS Visio
• Created technical requirements documentation and Operational Logs for several processes
• Documented source-to-target mapping documentation for ongoing complex data integration and transformation projects.
• Set up Sharepoint site for Team use and managed the project content for team.
• Worked with X12 based EDI data sets (835, 837)
• Documented the operational log for BIML processes to automate creation of SSIS packages.
• Worked with developers in creating operational logs for ETL jobs.
• Worked on resolving and documenting missing data issues.
• Worked on defining requirements for creating new reports and modifying existing reports for Business.
• Written Test plans and Test cases and worked with Business users.
• Used Tableau for generating reports.
• Written user stories for the Sprints, participated in Backlog grooming, Sprint Planning, Task planning and Sprint retrospective.
• Used Team Foundation Server 2010(TFS) for all the source code maintenance among the whole team members.
• Worked with Claims, Authorizations, Provider and other Healthcare Business Data.

Environment: Waterfall-Scrum, SharePoint 2013, MS Office (Word, Excel, PowerPoint, Visio), TFS, Microsoft SQL Server Management studio, Visual Studio, SQL Server Integration Services(SSIS), SQL Server 2014, Tableau

BUSINESS ANALYST

Confidential, Springfield, Illinois

Responsibilities:

• Gathered, analyzed, and documented business and technical requirements from both formal and informal sessions and validated the needs of the business stakeholders.
• Gathered the requirements by conducting client group interviews, focused groups, workshops and online surveys.
• Prepared the Business Requirement Document (BRD) and System Requirement Specification (SRS) to provide details of business and functional requirements along with the implementation plan of these requirements.
• Interacted with client to assess needs, identify key challenges, and define project scope and deliverables.
• Performed requirement analysis by conducting JAD sessions, Brain Storming Sessions and developed Use Cases and Activity Diagrams using Visio.
• Prepared the Project Scope and Objectives for new projects.
• Conducted GAP analysis by understanding the AS-IS Business Process and To-Be Business Process.
• Maintained a requirements Tracebility Matrix (RTM) to document the changes
• Worked with Developers to create FSDs(Functional Specification Document), Test Plan Documents and Test cases.
• Worked with Project Manager and Project lead to create Project plan, Estimates and Work Breakdown Structure using MS Project.
• Create Use Case Documents by specifying actors, normal flow; alternative flows for all use cases.
• Responsible for managing the Change Requests and the Change Management Process.
• Worked as a bridge/liaison between the Business team, Technical Team and clients.
• Prepare and maintain the Requirement traceability matrix to determine all requirements are met.
• Identified the Reporting needs and the Data Requirements.
• Prepared weekly status report to brief the customer on project status.
• Prepared Meeting Agendas and Meeting Minutes and circulate to the meeting group.
• Documented Source-to-Target Data Mapping for the EDW.
• Used SharePoint as a content management to document the artifacts and other documents.
• Worked with Developers to create FSDs, Test Plan Documents and Test cases.
• Worked with developers in developing Logical and Physical Data Modeling.
• Written SQL Queries for analysing the data patterns, finding issues with data and initiating correction.
• Worked with Developers during QA Testing and data validation.
• Develop Test plan documents, Test cases and participated in User Acceptance Testing.
• Worked on Medicaid claim Data, Pharmacy Data and other healthcare data

Environment: Waterfall, MS Office (Word, Excel, PowerPoint, Visio), Share point 2013, JIRA, Business Objects, Informatica, BI Query, Teradata, SQL Assistant

SR. BUSINESS ANALYST

Confidential, BRONX, NY

Responsibilities:

• Identified the Business need prepared the Request for Proposal.
• Interviewed the end users, asked detailed questions and carefully recorded the requirements in a format that can be reviewed and understood by both business people and technical people.
• Conducted GAP Analysis of current state (As-Is) and proposed state (To-Be) situations.
• Responsible for the Business Process Mapping to understand the business and responsibilties.
• Conducted Cost-benefit analysis and calculated ROI.
• Conducted Business Process Re-engineering.
• Conducted Requirement Workshop to gather requirements from various departments. Conducted Focus Groups and Interviews with physicians and to understand additional functionalities deemed critical.
• Prepared a Questionnaire and conducted a survey to understand the user needs.
• Created Business Requirement Documents (BRD), Functional Requirement Specification (FRS) and Technical Requirement Specification
• Assisted the project manager in Project Budgeting and Resource scheduling, in order to optimize the utilization of the project resources using MS project.
• Worked with GUI development, designed the initial UI wireframes, and mock-ups.
• Used MS VISIO to create Use Case diagrams, activity and Sequence diagrams so that the development team and other stake holders can understand thebusiness process.
• Created GUI components such as checkboxes, radio buttons, drop buttons, drop down menus
• Helped team to maintain optimal Velocity, and complete story points in each sprint consistently.
• Assisted in logical data modelling, creating ER diagrams to structure data in the SQL Server environments.
• Authored Test Cases for various Test Scenarios, documented UAT Plan, and helped managing defects and issues log using HP ALM during the testing phase.
• Assisted in creating Data Model, ER Diagrams and used these artifacts to develop the Design Model: use case Diagrams, Activity and Sequence Diagrams.
• Manage the meta-data for the Subject Area models for the Data Warehouse environment.
• Document all source-to-target data mapping for the EDW.
• Developed fact tables and established relationship using dimension modelling as basis for designing Data Warehouse.
• Designed and implemented SQL queries for managing database, QA testing and data validation.
• Used SharePoint as a content management to document the artifacts and other documents.
• Developed reports using Tableau v9.0 to communicate information using graphs, charts and others.
• Performed User Acceptance Testing (UAT) in conjugation with the QA team. Also, created an Error Repository and managed the testing process with the QA team. Logged and tracked the defects using HP Quality Centre.
• Assisted in the Deployment and management of the application.
• Assisted in creating training materials for hospital employees to get them familiarized with the new technological advancements to be incorporated by the hospital.

Environment: Waterfall-Scrum, HP ALM, Balsamiq, Visual Studio, Tableau, SQL SERVER 2012, AJAX, IIS Web Server, Java Script, HTML, CSS, SharePoint 2013

BUSINESS ANALYST

Confidential, Wallingford, Connecticut

Responsibilities:

• Conducted interviews with the Business users, SME’s, Developers, PMs and QA teams to better understand the business processes and application knowledge.
• Carried out business Process Mapping and Re-engineering.
• Reviewed the existing Business documents, TR3 guides to understand the current system.
• Conducted Gap analysis to identify the gaps in the existing 4010 and to be 5010 implementation.
• Conducted System appreciation to understand the current system behavior and the sensitivity and impact around the changes through system study and interviews with IT and Business SME.
• Conducted Impact Analysis to analyze the impact on Business, People and Technology.
• Conducted impact analysis to analyze the impact of the migration.
• Conducted JAD sessions and other Requirment Elicitation Techniques with IT and business users to finalize the Business rules associated with the identified changes.
• Assisted in creating system Analysis document, 5010 mapping document and Status report.
• Successfully received Sign-offs by utilizing Clear Quest tool after resolving all open questions.
• Lead and facilitated numerous meetings to help answer any question on requirements during Design, Development, Testing and Implementation Phase.
• Created testing function specific scenarios for exception conditions with gap in data.
• Involved in forward and backward mapping between ICD 9 and ICD 10
• Worked with Architects and Developers in altering the various HIPAA 837, 270/271, 834(File Format Cleaning) Claim work flows.
• Used docSTAR, content management tool to document the artifacts.
• Prepared data mapping for HIPAA transactions between HIPAA and proprietary formats.
• Analyzed production data using SQL Server to understand problems and triage issues with developers and management. Created SQL Queries, stored procedures to retrieve, manipulate and analyze data.
• Assisting business users in defining UAT test cases and plans; Established and maintained test cases and test data in Quality Center.
• Participated in the production of HIPAA 5010 EDI Test data

Environment: Waterfall, HPALM, MS Visio, SQL, MS Office (Word, PowerPoint, Excel), MS-Project, docSTAR, HTML Windows XP, IBM Cognos.

BUSINESS ANALYST

Confidential

Responsibilities:

• Responsible for all phases of the software development Life cycle (SDLC).
• Involved in gathering, Analysis of requirements and transitioning them into Business needs.
• Performed Impact Analysis to determine the impact of the enhancement on the business and organization.
• Performed Feasibility Study, Cost-Benefit Analysis and Return on Investment (ROI) in order to mitigate certain risks associated with the project.
• Created Business Process flows and created cost estimates.
• Conducted JAD sessions, interviews and Brainstorming sessions with key stakeholders and SME’s to gather requirements.
• Created Vision document and Business Glossary. Worked onbusiness rules(Structure and policies of organization) for the application.
• Conducted user interviews, gathered requirements, and analyzed the requirements for the new health insurance product.
• Created wireframes and mock up screens using Mock Flow.
• Translated Business requirements into software requirements specifications (SRS).
• Create Test management strategies and Test plans.
• Developed reports using Tableau v9.0 to communicate information using graphs, charts and others.
• Performed User Acceptance Testing (UAT) in conjugation with the QA team. Also, created an error repository and managed the testing process with the QA team. Logged and tracked the defects using HP Quality Centre

Environment: Waterfall-Scrum, MS Excel, MS Word, Requisite Pro, MS Project, MS Visio, Outlook, Microsoft SQL Server, Microsoft Visual studio, Tableau