SUMMARY

• Having 13+ years of experience working wif testing of traditional and cloud ETL, MDM, Big data & Data warehouse systems in various data integration, migration and data warehousing projects.
• Worked extensively in various stages of SDLC including creation of system test plans and test cases, defect management, risk management, resource planning, issue resolution and different testing types such as system, integration, regression and end to end testing.
• Expertise in entire software test cycle - requirement gathering, building use cases, traceability matrix, test plan preparation, test strategy, test scripts execution and documentation of test results.
• Hands-on experience wif different software methodologies such as Waterfall and Agile.
• Sound technical knowledge wif SQL skills to write complex queries in different databases.
• Performed data profiling to identify gaps between requirements and mapping documents which in turn improved business context testing.
• Experienced wif test automation frameworks & tools and automated a regression test suite of data validation test cases using python language in pytest framework.
• Coordinated cross application and integration mandate programs by working wif different geographically distributed teams - Value options, Prime, NASCO, Association and Anthem etc.
• Has exposure to CI, CD & CT pipelines and GitHub. Created jobs in Jenkins to automate and schedule data load job execution.
• Contributed to develop a self-service portal for test data identification for QA and UAT downstream system users.
• Proficient in Health care Insurance domain testing for large scale application enterprises serving to user base spanning across teh organization.
• Coordination wif Offshore team for project Implementation wif daily offshore task assignment, review daily offshore status & customize teh same to client expectations
• Good Communication and analytical skills wif teh ability to analyze and propose automation tools.

TECHNICAL SKILLS

Test and Defect Management Tools: HP ALM, Jira, Rally, IBM RQM, RTC and ClearQuest.

Testing technologies, databases and tools: ETL, Informatica MDM, AWS Redshift, Informatica PowerCenter, Informatica Intelligent Cloud Services (IICS) Hub and Informatica TDM Cognos and Tableau Reporting tools, Oracle, Teradata, Postgres, IBM DB2 and MySQL, Big Data and HDFS

Automation and build tools: Perfaware and Selenium Framework, Jenkins, GitHub

Scripting and Languages: SQL, Unix, Shell and VB Scripting, C and Python.

PROFESSIONAL EXPERIENCE

Confidential, Hartford CT

Responsibilities:

• Working wif Project managers and application teams to review teh pipeline. Prepare and review estimates & test schedule wif IT Manager. Communicate risk and mitigation plans.
• Develop test strategy which covers functional, integration, regression and e2e testing scope for inbound and outbound data flows.
• Prepare test data strategy to mask PHI information for data integration projects testing wif partners.
• Daily meetings to review status and triage teh defects wif all project stakeholders. Sharing Test Execution Reports, Overall status reports, Progress dashboards to stakeholders regularly.
• Reviewing test plan and data validation test cases prepared for validating ETL and MDM rules wif project stakeholders.
• Preparing SQL queries based on teh mapping documents for history and incremental data validations.
• Executing and monitoring teh data load jobs in Informatica ETL and MDM tools.
• Executing Match and Merge jobs through MDM Hub console.
• Performing manual merge and unmerge through IDD.
• Providing test data support to downstream systems and API teams.
• Developed a regression test automation suite.
• Responsible for collecting test metrics, overseeing teh quality of project deliverables, and tracking defects to closure.
• Generation of reports and metrics from IBM RQM tool for InSprint Savings, Regression Savings and Defect analysis and sharing wif all teh stakeholders on regular basis.

Confidential, Newark NJ

Responsibilities:

• Worked wif development teams to understand teh design, framework and data flows.
• Identify scope of testing for both inbound and outbound data flow for all types of data like member demographics, enrollment, providers, medical and pharmacy claims
• Prepared a schedule for system and integration testing of application and coordinated test cycles.
• Created system test plan and test cases based on teh mapping and requirement documents.
• Developed test data strategy to mockup PHI information dat would be used for integration testing wif vendors .
• Prepared re-usable SQL queries which were used in numerous projects to bring effort savings
• Testing of Hadoop layers such as Raw, Landing and Consumption Layers. Validation of file ingestion of different formats into HDFS tables (csv, xml, json, .txt files).
• Validation of business rules for reports and extracts coming out of teh HDFS consumption layer tables.
• Testing of AWS ETL tables through SQL workbench to validate against data files coming from S3 bucket.
• Contributed to teh creation of automation framework to perform validation in Hadoop Environment
• Lead teh defect triage meetings wif teh development teams and teh end users.
• Status and Test closure reports.
• Track teh testing status on daily basis to ensure testing is going as per teh plan.

Confidential, Newark NJ

Responsibilities:

• Gather and analyze Business and Technical Requirements.
• Prepare SQA estimations and review it wif client.
• Prepare test plan for system and integration testing of IDS wif member source systems like NMS, NASCO and ME and provider source systems like PNO, PDMS and Ancillary.
• Review test artifacts such as test plan, test cases and test results wif Business and Development teams and obtain sign off.
• Prepare master project plan by coordinating wif other teams for integration and e2e testing of cross vendor programs. Tracking daily progress, resolving issues and dependencies, and reporting overall status to client manager.
• Test data setup and writing SQL queries for teh execution of initial and incremental data validation test cases.
• Validation of outbound extracts(fixed length/pipe delimited/variable fixed length flat file, excel, XML and JSON) and reports against source database .
• Execute and monitor teh data load jobs in Informatica workflow monitor.
• Organizing calls wif business and dev teams to discuss testing status and defects resolution.
• Ensuring complete end to end testing is being done.
• Regression test to ensure dat teh new code had no adverse TEMPeffect upon teh current system.
• Analyzing and providing resolution for teh data issues identified in UAT Environment.
• Providing support to UAT team for identification of data for their testing.

Confidential, Newark NJ

Responsibilities:

• Understanding teh requirements.
• Writing test scenarios and cases; Test data identification for history and going forward data.
• Developing SQL queries for teh execution of test cases.
• Validation of data across all teh layers of EDW.
• Validation of reports against data marts.
• Test results documentation. Reviewing test deliverables wif Leads.
• Defects logging and retesting teh defects.