SUMMARY

• Having 13+ years of experience working with 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 with different software methodologies such as Waterfall and Agile.
• Sound technical knowledge with 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 with 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 with different geographically distributed teams - Value options, Prime, NASCO, Association and Anthem etc.
• Have 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 the organization.
• Coordination with Offshore team for project Implementation with daily offshore task assignment, review daily offshore status & customize the same to client expectations
• Good Communication and analytical skills with the 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 with Project managers and application teams to review the pipeline. Prepare and review estimates & test schedule with 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 with partners.
• Daily meetings to review status and triage the defects with 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 with project stakeholders.
• Preparing SQL queries based on the mapping documents for history and incremental data validations.
• Executing and monitoring the 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 the 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 with all the stakeholders on regular basis.

Confidential, Newark NJ

Responsibilities:

• Worked with development teams to understand the 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 the mapping and requirement documents.
• Developed test data strategy to mockup PHI information dat would be used for integration testing with 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 the HDFS consumption layer tables.
• Testing of AWS ETL tables through SQL workbench to validate against data files coming from S3 bucket.
• Contributed to the creation of automation framework to perform validation in Hadoop Environment
• Lead the defect triage meetings with the development teams and the end users.
• Status and Test closure reports.
• Track the testing status on daily basis to ensure testing is going as per the plan.

Confidential, Newark NJ

Responsibilities:

• Gather and analyze Business and Technical Requirements.
• Prepare SQA estimations and review it with client.
• Prepare test plan for system and integration testing of IDS with 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 with Business and Development teams and obtain sign off.
• Prepare master project plan by coordinating with 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 the 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 the data load jobs in Informatica workflow monitor.
• Organizing calls with 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 the new code had no adverse effect upon the current system.
• Analyzing and providing resolution for the data issues identified in UAT Environment.
• Providing support to UAT team for identification of data for their testing.

Confidential, Newark NJ

Responsibilities:

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