SUMMARY:

• Senior Business Analyst with 12.5 years of diverse experience with requirements management, business analysis and project management among Banking and Healthcare domain.
• Excellent analytical skills to understand the business process and Functionality, Requirements and to translate them to System Requirement Specifications. Developing Functional specifications for business process refinement and automation.
• Proficient in UML Use Case Diagrams and Activity Diagrams.
• Strong Experience on Health Care Reform HCR and Exchange.
• Strong Experience in FACETS, HIPAA, Medicare, Medicaid, ICD 9, ICD 10 and Claims processing.
• Strong experience in eliciting, developing and documenting Business and Functional Requirements Specifications in Data Warehouse projects.
• Well versed at writing Use Cases for articulating Business Activities and System Operations.
• Experience with understanding As Is business processes and the subsequent realization of To Be processes using techniques such as Gap Analysis.
• Involved in P2 Phases in assessing the Navigator impacts to start the P4 Phase in gathering the Business Requirements.
• Thorough Understanding of Software Development Life Cycle SDLC and Agile Methodology. Worked in various phases like Requirements, Analysis/Design, Development and Testing.
• Expert in ETL Tool Informatica .
• Worked Business Analysts in documenting business requirements, technical specifications and implementation of various ETL standards in the mappings.

TECHNICAL SKILLS:

• Business Tools: Rational Suite Requisite Pro, Clear Quest, Clear Case , MS Visio, JIRA Agile Tool , Informatica ETL Tool , Business Objects, Cognos Reports, Quality Center, SnagIt Mock Up , ACORD Standard, BI Tool SSIS,SSAS,SSRS Reporting tool.
• Business Skills: Business Definition Requirements, Business Process Analysis, Gap Analysis, Use Case Modeling Analysis
• Methodologies: Waterfall, Agile
• Languages: SQL, C, CPP, ASP.Net, XML, Schema, C
• Databases: SQL Server 7.0 2000 Access 2000
• Operating Systems: Windows XP/95/98/NT/2000
• General: MS Office Word, Excel, Power Point

WORK EXPERIENCE:

Confidential

Role: Lead Business Analyst

• The IBM ODM Rules Engine Pilot will continue the effort to develop IBM's ODM as an independent Rules Engine as a component of the Optum Program Determination PD application. The Rules Engine Pilot will provide an automated solution hosted on the Optum Cloud to use resident's information to determine eligibility into applicable Medicaid/CHIP programs.
• Specifically, the Pilot will develop the IBM's ODM as a functioning rules engine to mirror the existing Medicaid rules engine component of the Massachusetts Health Insurance Exchange solution. The Rules Engine will accurately assign applicants to one of the 24 prioritized Aid Categories by applying the applicable participation factors and eligibility rules.

Responsibilities:

• Worked Business Analysts in documenting business requirements, technical specifications and implementation of various ETL standards in the mappings.
• Worked as a Scrum Master in scheduling and hosting Scrum, Backlog and planning meetings.
• Analyzed the business requirements and wrote Test Plans and Test Cases.
• Worked in the design of Data Warehouse using Star-Schema methodology and converted data from various sources to Oracle tables.
• Developed views, functions, procedures, and packages using PL/SQL SQL to transform data between source staging area to target staging area.
• Created staging tables necessary to store validated customer data prior to loading data into customer interface tables.
• Documented the process procedures and flow for the process.
• Performed both Business Analysis and Data Analysis for the e-portfolio consolidation project on the web interface and the reporting interfaces.
• Worked closely with the QA Team to review and enhance the Test Plan and Test Cases.
• Created mock ups using SnagIt Tool.
• Environment: Rally, Rational Suite RequisitePro, Clear Quest, Clear case , MS Visio, MS SQL Server 2005, Caligo.

Confidential

Role: Lead Business Analyst

Beginning in 2014, individuals and small employers must have access to essential health benefits EHB - including pediatric dental and vision coverage. Small employers and individuals without EHB coverage must pay a penalty. Essential health benefits vary from state to state. States will choose the type of plans they want offered in an Exchange to meet their specific EHB, based on benchmark plan types provided by the Feds this means multiple plans Confidential must meet/match.

Responsibilities:

• Working as a liaison between technology and the business clients to improve business processes and support critical business strategies.
• Facilitating JAD sessions for defining business requirements and follow-up for Project Plan updates.
• Designing use-cases and use-case models to further refine the requirements and understand the business processes.
• Creating Test Cases, Test Scripts, and Customer Reports.
• Creating workflow and process flow Visio diagrams reflecting current and proposed business processes and site functionality.
• Writing SQL Queries.
• Creating data mapping Documents.
• Providing support for Build and Test team.
• Working in all the phases in SDLC Lifecycle.
• Working as a Lead BA, coordinating with offshore team members.
• Reviewing Design document.
• Creating Mock ups for the custom pages.
• Work closely with clients and the business to identify and analyze core business processes and workflows.
• Documentation of process and work flows.
• Development of clear and detailed process maps and business requirements.
• Environment: Rational Suite RequisitePro, Clear Quest, Clear case , MS Visio, MS SQL Server 2005, Caligo.

Confidential

Role: Lead Business Analyst

Summary of Benefits and Coverage Document needs to be requested by the member through Navigator via email or US mail. The request will be made through Contact us page. The Email request will be processed through ASD Application and US Mail request will be processed through KANA Application.

Responsibilities:

• Created user story through Agile Software development methodologies.
• Coordinated Scrum meetings, Backlog Discussions and Planning Discussions.
• Worked as a liaison between technology and the business clients to improve business processes and support critical business strategies.
• Facilitated JAD sessions for defining business requirements and follow-up for Project Plan updates.
• Created stories with JIRA Tool.
• Created Use Case Narrative document and Requirements document.
• Worked in all the phases in SDLC Lifecycle.
• Assisted development and testing team UAT and System Testing .
• Worked closely with the QA Team to review and enhance the Test Plan and Test Cases.
• Created Customer Reports for the Medicare Members.
• Created Mock ups for the SBC in the member facing Application.
• Worked in Clear Case tool Version Control of the Project Documents .
• Worked as a Lead BA, coordinated with offshore team members.
• Created FACETS tool requirements for the Summary of Benefits and Coverage request.
• Environment : Waterfall Methodology, Rational Suite RequisitePro, Clear Quest, Clear case ,MS Visio, MS SQL Server 2005

Confidential

Project:

Accessing to Claims, benefits, ID Cards and Health Records is leveraged for Medicare Members. Accessing to Health Assessment is disabled for Medicare members as part of this project.

Responsibilities:

• Worked in Process Mapping and Business Process Reengineering.
• Facilitated workshops and focus groups.
• Developed business requirements.
• Translated and simplified requirements.
• Created Test Cases and Test Scripts.
• Worked closely with the QA Team to review and enhance the Test Plan and Test Cases.
• Created Customer Reports for the Medicare Members.
• Wrote SQL Queries.
• Created Mock ups for the custom pages.
• Worked closely with clients and the business to identify and analyze core business processes and workflows.
• Documented process and work flows.
• Developed clear and detailed process maps and business requirements.
• Environment : Waterfall Methodology, Rational Suite RequisitePro, Clear Quest, Clear case ,MS Visio, MS SQL Server 2005,ASP.NET

Confidential

Project Description:

• As the need for Health Insurance Policies and competition in the business is increasing, Confidential plans to declare that Facets support ten million members for its 4.51 and above versions.
• The purpose of this project is to increase the number of Members/Subscriber enrolled in Facets to ten times. Since the impact will be seen on all Members/Subscriber related and dependent tables, we need to increase the capacity in all those tables and see the impact. Need to perform smoke testing on selected user screens for sample data and test the impact on facets batch applications. As an outcome of this project we need to provide our test analysis report.

Responsibilities:

• Analyze the requirement and understand the end need of client.
• Capturing the list of all the tables from Member/Subscriber modules and all dependent and related tables from other modules like Claims, Billing, and UM etc.
• Preparing an approach document to define the steps for loading ten millions Member/Subscriber data in facets and perform required testing.
• Environment : AGILE Methodology, Rational Suite RequisitePro, Clear Quest, Clear case ,MS Visio, MS SQL Server 2005,ASP.NET

Role: Lead Business Analyst

Confidential

Responsibilities:

• Worked Business Analysts in documenting business requirements, technical specifications and implementation of various ETL standards in the mappings.
• Analyzed the business requirements and wrote Test Plans and Test Cases.
• Worked in the design of Data Warehouse using Star-Schema methodology and converted data from various sources to Oracle tables.
• Developed views, functions, procedures, and packages using PL/SQL SQL to transform data between source staging area to target staging area.
• Wrote SQL queries to perform Data Validation and Data Integrity testing.
• Created SQL Loader scripts to load legacy data into Oracle staging tables.
• Created staging tables necessary to store validated customer data prior to loading data into customer interface tables.
• Documented the process procedures and flow for the process.
• Performed both Business Analysis and Data Analysis for the e-portfolio consolidation project on the web interface and the reporting interfaces.
• Worked closely with the QA Team to review and enhance the Test Plan and Test Cases.
• Created mock ups using SnagIt Tool.
• Environment : Waterfall Methodology, Rational Suite RequisitePro, Clear Quest, Clear case ,MS Visio, MS SQL Server 2005,ASP.NET

Role: Lead Business Analyst

Confidential

Responsibilities:

• Worked as a Data Analyst for a team responsible for data mining related to maintaining coding convention and administering the Navigator Web application.
• Designed and developed several mappings to load data from Source systems to ODS and then to Data Mart.
• Worked in Fine-tuning of Informatica mapping, Stored Procedures and SQL to obtain optimal performance and throughput.
• Created and maintained several custom reports using Business Objects.
• Maintained/updated system data flow chart, Visio documents, and system documentations.
• Coordinated with Database team, Project Teams, and Application Team in trouble shooting issues and worked with P1 team for major business critical production issues.
• Gathered Requirements and scheduled and facilitated team meetings.
• Coordinated with the Navigator Steering Committee.
• Developed business requirements.
• Created Customer Reports for the Small Group Members.
• Wrote SQL Queries.
• Created Mock ups for the member facing Application.
• Detailed out the requirements to the downstream application.
• Identified issues and risks.
• Environment : Waterfall Methodology, Rational Suite RequisitePro, Clear Quest, Clear case ,MS Visio, MS SQL Server 2005,ASP.NET

Confidential

Role: Lead Business Analyst

Responsibilities:

• Served as the first point of contact for the volunteers on the project, listening to their opinions, providing suggestions, attending to their administrative problems, and discussing any other issues of concern with them.
• Responsible for coordinating the project volunteers and the project.
• Developed relations with the various societies and other external organizations to promote new ideas and plans related to project.
• Gathered regular feedback from volunteers and provided feedback to the Project Manager.
• Kept an up to date list of volunteers including their names, contacts and the number of active members involved in the project.
• Prepared Handover Notes at the end of the year, to pass on the next year's project leaders.
• Created Test Cases and Test Scripts.
• Created Customer Reports for the Claim functionality.
• Environment : Waterfall Methodology, Rational Suite RequisitePro, Clear Quest, Clear case ,MS Visio, MS SQL Server 2005,ASP.NET

Confidential

Responsibilities:

• Responsible for developing a project plan that works to achieve progression criteria using sound scientific processes in the shortest amount of time with the least cost.
• Made sure all team members and their line managers and key stakeholders support the project.
• Interacted directly with line managers to ensure resources are available when needed, and to negotiate amendments to the project plan especially those that change deliverable completion dates.
• Responsible for organizing, facilitating and ensuring follow-up action on issues raised in the meeting.
• Kept team members and stakeholders informed of key developments, program decisions, issues, and changes to the project and the project plan.
• Environment: Waterfall Methodology, VSS,MS Visio, MS SQL Server 2005,ASP.NET

Confidential

Role: Application Support Lead

Responsibilities:

• Managed all aspects of tasks and deliverables for assigned projects.
• Allocated work assignments to assigned technical resources based on project plans and resource expertise and availability.
• Ensured the completion of assigned projects within established time frames and budget while meeting project objectives.
• Facilitated effective execution of product and service delivery processes including but not limited to project and resource planning, requirements collection, change management, risk management, issue tracking, deployment, and process improvement.
• Environment: AGILE Methodology, VSS, MS Visio, ASP.NET, C , SQL Server

Confidential

Role: Business Analyst

Responsibilities:

• Facilitated communication between the project team and business stakeholders.
• Ensured customer is fully informed of project status.
• Obtained feedback from business stakeholders and adjusted project scope, schedule, and resources as necessary.
• Responsible for the budget and expense tracking process associated with assigned project.
• Created Test Cases and Test Scripts.
• Designed use-cases and use-case models to further refine the requirements and understand the business processes.
• Created Customer Reports for the Claim functionality.
• Environment: Waterfall Methodology, VSS, MS Visio, ASP.NET, C , SQL Server

Confidential

Role: Business Analyst

Responsibilities:

• Followed the Corporate IT Project Management Methodology.
• Determined the project approach, staffing, responsibilities, and schedule.
• Developed and reviewed estimates and estimating assumptions for the project's schedule, effort, and cost using established estimating models, best practices, and past experience.
• Defined team member roles and expectations, and ensured timely feedback.
• Measured and monitored progress at clearly defined points in the process to ensure that the project was delivered on time, within budget, and that it met or exceeded expectations balance scope, schedule, budget, quality, and risks.
• Identified issues and risks.
• Created Use Case Narrative document and Requirements document.
• Worked in all the phases of SDLC Lifecycle.
• Assisted development and testing teams.
• Environment: Waterfall Methodology, VSS, MS Visio, ASP.NET, C , SQL Server

Confidential

Role: Business Systems Analyst

Responsibilities:

• Created user story through Agile Software development methodologies.
• Engaged with business/client.
• Reviewed Design document and created Test Cases and Test Scripts.
• Worked closely with the QA Team to review and enhance the Test Plan and Test Cases.
• Supported UAT/business testing, shadow testing activities using Agile tool to track Agile progress.
• Translated and simplified requirements.
• Developed clear and detailed process maps and business requirements.
• Environment: AGILE Methodology, Rational Suite RequisitePro, Clear Quest, Clear case , MS Visio, ASP.NET, C , SQL Server

Confidential

Role: Business Systems Analyst

Responsibilities:

• Prepared Functional Specifications.
• Scheduled, allocated and monitored Tasks.
• Resolved technical issues and facilitated to perform independent Unit/Integration Testing and System Testing.
• Created Use Case Narrative document and Requirements document.
• Worked in Agile Software development methodologies.

Confidential

Role: Business Systems Analyst

Responsibilities:

• Coordinated Scrum meeting, Backlog Discussion and Planning Discussion.
• Created stories using JIRA Tool.
• Worked in JAD sessions to gather Requirements.
• Created Use Case Narrative document and Requirements document.
• Worked in all the phases in SDLC Lifecycle.
• Assisted Development and testing teams UAT and System Testing .
• Wrote SQL Queries.
• Created Mock ups for the SBC in the member facing Application.
• Environment: Waterfall Methodology, VSS, MS Visio, ASP.NET, C , SQL Server