SUMMARY

• Having 11+ Years of professional work experience in IT service industry as a Software Test Engineer in Confidential and Software Quality Assurance Senior Analyst in Confidential.
• Having 2.5 years of experience in Banking and Insurance domain.
• Having 2 years of experience in Tosca ETL Automation.
• Having 8+ years of experience in Health Care domain.
• Having around 8 years of experience in ETL testing with extensive usage of MSBI, Teradata & DB2.
• Good Knowledge in the Architectural Design and Software Development Life Cycle of Testing applications.
• Implemented projects in Agile Methodology with Scrum framework.
• Have good knowledge in multiple databases like Oracle, DB2 and Teradata.
• Preparing SQL scripts according to the defined requirements constraints.
• Basic knowledge in UNIX commands.
• Capable of learning new technologies and their implementation.
• Posse’s good communication, Analytical skills, and problem - solving capabilities.
• Ability to work under tight schedule.
• Team spirit and self-motivation to accelerate productivity.
• Involved in BA meetings to straighten the business requirements.
• Having good exposure to DATA MODEL and carried projects individually.
• Having good experience in implementing projects individually.
• Experience in understanding and using NoSQL databases Mongo DB, Apache Cassandra, Apache Ignite, Dynamo DB, Couch DB and Redis.

TECHNICAL SKILLS

ETL Tools: Informatica 8.6, MSBI and Data Stage

Operating Systems: Windows, UNIX

Databases: Oracle, Teradata, SQL and DB2

Tools: ALM 12.05, JIRA, SQL Developer, Query Surge, Post Man tool, Rapid SQL, IBM Control Center, Micro Soft Visual studio, SQL Server Management Studio, Tricentis Tosca, Qtest.

Domain Knowledge: HealthCare, Banking

Documentation: Microsoft office tools

PROFESSIONAL EXPERIENCE

Confidential, Vermont

Team member and Individual Contributor

Environment: Data Stage, DB2, ALM, Windows

Responsibilities:

• This project is intended to identify and automate regression checks which business performs for their regular outbound extract files.
• This project helps the businesses to replace the manual process of verifying the out bound files with Tosca ETL automation.
• It will save time and improve the overall quality of the files delivered to the external vendors.

Confidential

Team member

Environment: Data Stage, DB2, ALM, Windows

Responsibilities:

• This project is intended to downstream the files from the IDS data warehouse to the vendors on request.
• As part of the IDS data warehouse the BCBS is identified different extracts and will be sending different files for set of data.
• The files may have information related to pharmacy, members, providers, benefits, claims etc.

Confidential

Team member

Environment: Data Stage, SQL Server, DB2, ALM, Windows

Responsibilities:

• My Blue Heath, Confidential ’s health and wellness portal, offers registered users the ability to view health and wellness content, track activity and participate in challenges that support lifestyle changes towards a heathier individual.
• The portal is a benefit service for Confidential insured members, however, Confidential has made a commitment to Accountable Blue groups that allow these groups the ability to offer access to both insured (blue) and non-insured (non-blue) employees.

Confidential

Team member

Environment: Data Stage, DB2, ALM, Windows

Responsibilities:

• IDS is Integrated Data Store captures data from already existing data warehouse and current ongoing transactions data (PMHS).
• The aim of this project is established new warehouse with more organized and quality of data.
• The IDS is divided in to 7 data marts or domains named MEMBERS, PROVIDERS, PHARMACY, BENEFITS, CLAIMS, GROUPS & FINANCE.

Confidential

Team member

Environment: Informatica, Oracle, HPQC, Teradata, Windows

Responsibilities:

• The purpose of the Business Summary is to describe the high-level business need that the functional or non-functional requirement is intended to satisfy or what the business expects from the solution. Needs may be stated as new/updated functionality, regulatory or regional changes, business rules, processes, etc.
• Load FircoSoft data into the EDW to integrate with policy, Claims, and agency data for analysis.
• Confidential leverages platform and data services with a third-party vendor, FircoSoft, to enable the closed-loop feedback process and reporting for use by Claims (NCAT), Distribution, Underwriting, Licensed Sales Center and set-up for future business solutions.
• Confidential EDW feedback enables business units to survey customers (Agents, policy holders) after a defined interaction.
• It also sends alerts to business unit managers to contact customers and agents who meet predefined survey criteria to gather additional feedback, identify issues and provide solutions.

Confidential

Team member

Environment: Informatica, Oracle, SQL, HPQC, TOAD

Responsibilities:

• Direct client interaction involving SCRUM calls, walkthroughs, meetings, and reviews on a weekly basis and in between as needed.
• Analyzing the BRD document and involving in meetings with BA team.
• Validating Data model, BRD and Data base to have unique status.
• Writing SQL queries using joins, DML and DDL operations as part of DB testing and back-end data validation in tables
• Validating data by using SQL Queries which is loaded using Informatica or data stage as ETL tool.
• Validating ETL code by doing strategy testing and functional testing.
• Identification of Test scenarios for every applicable release and preparation of Test cases is performed in the Test Design phase.
• Verification of the actual results against the expected results of the Test cases.
• Test Cases are executed, and deviations found from the expected behavior of the test cases are logged as defects in both ALM (Application Life Cycle Management) and JIRA.
• Preparation of Test strategy, Test plan Test Execution reports, Test Summary Reports, Defect reports.
• Validating flat files through temporary tables approach.