SUMMARY

• Highly accomplished Business Analyst with over 7 years of experience with proficiency in BusinessProcess Engineering and Software Development Life Cycle including analysis, design, testing and implementation of software applications
• Proficient in different software development life cycle (SDLC) methodologies such as Waterfall and Agile/Scrum models
• Good noledge of Health Insurance Plans (Medicare Part A, B, C and D), managed care concepts (Medicaid and Medicare) and experienced in determining teh membership eligibility, billing experience within life and disability in health plans.
• Experience in SQL to perform data analysis, data mapping, data verification & data validation
• Experience in BI Reporting, structure and mapping data from multiple sources to single Confidential data store
• Experience in implementing HIPAA Gateway EDI X12 Transactions. Experience in HIPAA transactions EDI 837 (Dental/Institutional/Professional), 835(Payment Remittance Advice), 270 (Eligibility Request) / 271 (Eligibility Response), 276 (Claims Status Inquiry Request) / 277 (Claims), Status Inquiry Response), 834(Benefit Enrollment and Maintenance Transaction), 997/999 (Transaction Acnoledgement).
• Experienced in creating Business Requirement Document (BRD), Functional Requirement Document (FRD), Technical Specification Document (TSD), Requirement Traceability Matrix (RTM), Scope Statement and other project related documents
• Demonstrated leadership abilities and teamwork skills as well as teh ability to accomplish tasks under minimal direction and supervision. Strong analytical skills with detailed follow - through and skills in business process mapping and analysis.
• Experience in performing GAP Analysis and Impact Analysis on various projects.
• Prepared test scenarios and test cases for testing teh functional and non-functional aspects
• Proficient in developing use cases, user stories, process workflows and activity diagrams
• Excellent communication and presentation skills with experience in teh development, implementation and integration strategies within a team oriented environment, utilizing quantitative and qualitative analytical skills.

TECHNICAL SKILLS

Business Skills: Business Process Analysis & Design, Requirement Gathering, Use Case Modeling, JAD Sessions, Gap Analysis, Impact analysis and Data Mapping

Defect Tracking: HP Quality Center

Query and Programming: SQL

Databases: SQL Server 2008 & 2012, Oracle 11g & 10g, MS Access, MySQL

Document Management: MS Office (Word, Excel, Power Point, Outlook), MS Visio, Lotus Notes, Microsoft Share Point, RALLY, JIRA, TFS

Methodologies: Agile, Waterfall

Reporting Tools: Tableau, Excel Pivot Tables

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst

Responsibilities:

• Interact with client and gather business requirement for updating teh rules in EZ-Cap and Admin Utility
• Closely work in an Agile team and conduct daily stand up, estimation planning and prioritization meeting to groom teh product backlog
• Performed As-Is/Current-State analysis and drafted To-Be/Future-State processes based on identified requirements. Worked on developing Process and Data Flows.
• Initiate change requests and make sure to adhere to teh timelines promised.
• Documented various Use Case scenarios, Process Flows and other diagrammatic representations in MS Visio.
• Validated teh following: 837 (Health Care Claims or Encounters), 835 (Health Care Claims payment/ Remittance), 270/271 (Eligibility request/Response).
• Prepared 834 Inbound elements mapping companion guide to implement 834 Benefits enrollment and Maintenance for CCA.
• Extensively worked within varied sectors of teh healthcare industry including HMO, PPO, POS, Medicaid, Medicare, Integrated Hospital Systems, Out-Patient Surgery Centers, Dental and Vision.
• Performed UAT Testing with QA and Business Team.
• Create data flow diagrams, data mapping from source to stage and stage to Confidential mapping documents indicating teh source tables, columns, data types, transformation required and business rules to be applied.
• Performed data validation using SQL queries.

Confidential

Business Analyst

Responsibilities:

• Served as a liaison between business team and teh project team by assisting teh business in identifying, understanding, and documenting their business needs.
• Converted Business Requirements documents into Functional Requirements Specification and Technical Specification.
• Worked on developing teh process flows for teh web application to make it optimized in terms of user interaction.
• Identified all necessary Business Use Cases from requirements, created UML Diagrams including Use Cases Diagrams, Activity Diagrams, and Sequence Diagrams, using Microsoft Visio.
• Assisted in developing GUI for teh new application. Developed mockup screens.
• Performed gap analysis to understand teh improvement strategy of business.
• In house experience with project management tools like MS-Project and TFS for status reporting, planning and error tracking and correcting.
• Conducted User Acceptance Testing (UAT) with user group. Provided support for problems reported by users. Worked with both users and development team to resolve teh issues.

Confidential - Bloomfield, CT

Business Systems Analyst

Responsibilities:

• Function as a business & reporting analyst in Agile Methodology.
• Gather business requirements and formulate them into reporting requirements
• Schedule & conduct meetings with marketing and sales teams to gather business requirements
• Closely work with marketing and sales teams, making sure that they understand teh reports developed and address any questions
• Perform data analysis to create reporting requirements by specifying inclusion & exclusion criteria, conditions, business rules and data elements to be included into teh report
• Created mapping document which contains source, formulate transformational rules to populate Confidential fields
• Perform SQL query to extract data from warehouse for data analysis
• Interact on day to day basis with teh business team and translate teh business requirements into technical deign document
• Support teh business team and QA team with any questions on teh Tableau dashboards and reports
• Develop SQL scripts to validate teh metrics and data points before passing teh dashboard tointegration testing
• Facilitated teh Scrum Ceremonies - Backlog Grooming, Release and Iteration Planning Meetings, Daily Scrum Calls, and Retrospective Meetings.
• Extensively worked with SQL queries to create benchmark document, Validation scripts.
• Participated in quality assurance activities like reviews, walkthroughs etc

Environment: Agile - Scrum, Tableau, SQL Server 2012, Microsoft Word, Excel, PowerPoint, MS project, RALLY

Confidential - Oakland, CA

Business Systems Analyst

Responsibilities:

• Engaged as teh primary link between business line, operations and teh technical areas throughout teh project.
• Analyzed data coming in from various Sources and mapped teh necessary data to teh Confidential .
• Data Analysis and requirements gatherings, including meeting with teh business unit stakeholders, subject matter experts and engineering
• Developed numerous Teradata SQL Queries by using Inner and Outer Joins, Using Date Function, String Function and Advanced techniques like sub-queries
• Preparation of technical documentation, including process flows, data mapping etc
• Technical assistance during teh implementation of Extract Transform Load (ETL) process
• Conducted meetings to gather requirements from Business Managers, Supervisors, stakeholders and subject matter experts to gain noledge about needs of teh system.
• Created gap analysis document to specify changes to be introduced in teh campaign management tool
• Identified, researched, investigated and documented businesses processes and use case scenarios.
• Responsible for ensuring that privacy and security environments of campaign data remained intact

Environment: Teradata SQL Assistant 7.0, Power Point, Excel, Agile- Scrum, MS- Project

Confidential - Boston, MA

Business Analyst

Responsibilities:

• Engaged as a Business Analyst to support various Massachusetts Health Connector work streams including enrollment, Notices, Appeal and Integration
• Conducted face to face meetings, JAD sessions to gain process & modeling understanding
• Elicited information from stakeholders and converted into requirement
• Created scenarios to check Medicaid, Medicare program determination based on income, dependent, size of family, residency, citizenship, incarceration, disability, and pregnancy status.
• Prepared data validation to verify values of 834 XML data feeds with acceptance, rejection, error and TEMPeffectuate messages and codes
• Involved in Auto-enrollment batch runs including preliminary eligibility, final eligibility and renewal eligibility to determine eligibility for teh members
• Conducted walkthrough session to review requirements, process flows and scenarios with business team to obtain approval/ signoff.
• Defects analysis to determine business and technical impact and providing input on teh priority of fixing teh defects.
• Incorporated changes to teh approved documents through integrated change request procedures.

Environment: MS-VISIO, Agile - Scrum, SQL Server, Microsoft Word, Excel, PowerPoint, MS project

Confidential

Business Analyst

Responsibilities:

• Worked with thebusinesscommunity to definebusinessrequirements and analyze teh possible technical solutions.
• Co-authoredbusinessrequirements document (BRD) with project teams. Extracted, discussed, and refinedbusinessrequirements frombusinessusers and team members.
• Conducted workflow, process diagram and gap analysis to derive requirements for existing systems enhancements.
• Collaborated with teh QA team to ensure adequate testing of software both before and after completion, maintained quality procedures, and ensured appropriate documentation is in place.
• Helped teh testing team documenting teh system requirements and testing system development. Designed and implemented basic SQL queries for QA testing and report / data validation.