ANAND MATTA

. Having 8+ years of experience in the IT industry as a Software Test Engineer proficient in ETL Testing, BI Testing, SQL, Data Warehouse Testing, and Test Automation.

. Design and develop comprehensive test strategies, test plans, and test cases for ETL processes to ensure accurate data extraction,transformation, and loading.transformation, and loading.

· Collaborate with cross-functional teams to understand data integration requirements, source data, and target data models.

· Design, create, and execute test cases, test scenarios, and test scripts to validate ETL workflows, BI reports, and data warehouse structures.

· Verify data correctness by writing complex SQL queries to perform data integrity checks.

· Develop and maintain automated test scripts using Query Surge tool and frameworks, ensuring efficient regression testing.

· Evaluate data quality and integrity by performing thorough data validation, identifying discrepancies, and ensuring data consistency.

· Validate and verify the accuracy of business intelligence (BI) reports, dashboards, and visualizations.

· Strong communication and collaboration skills and presenting technical concepts to non-technical stakeholders.

8+ years

Project Details: 1

Title: PROVIDER DATA TRANSFORMATION (PDT),

Client: Elevance Health, USA, 

Skills : Oracle SQL Developer, Toad, Jira Software, Cloverleaf Integration, MongoDB, TCL, Postman.

Description:  Aims to send/receive the Providers data to BCBSA in adherence with Fast Healthcare Interoperability Resources (FHIR) standards. Rather than sending the data in traditional flat file method, this project aims to send the data via Rest API for the data exchange between the BCBSA and Elevance. This Pays the path to send and retrieve Provider data near to Realtime. 

Project Details: 2

Title: CMS Interoperability Mandate Solution Recommendation,

Client:  Elevance Health, USA,

Skills: MS SQL Management Studio, Jira Software, Cloverleaf Integration, MongoDB, TCL, Postman, 

Description: The CMS Interoperability and Patient Access final rule requires CMS-regulated payers to implement and maintain a secure, standards-based Patient Access API (using Health Level 7 (HL7) Fast Healthcare Interoperability Resources (FHIR) 4.0.1) that allows patients to easily access their claims and encounter information, including cost, as well as a defined subset of their clinical information through third-party applications of their choice. 

Project Details: 3

Title: Strategic Provider System SC Weekly,

Client:  Bayer,

Skills: Oracle, SQL, Informatica, Test Automation,

Description: This project is to migrate healthcare provider, organization, and   patient related information from MDX (Microsoft SQL server) to MDM(Oracle).   SC Weekly project is used to find Individual and Organizational   reimbursements claimed and processed. Also used to find maximum number of   patients treated by a healthcare provider and number of health care   organizations and health care provider worked/working. A full history file   with all the above mentioned will be sent to SC Weekly and will be loaded to   RAW and Landing layer tables following Inbound, Warehouse and Core layers.   Incremental loads will happen weekly basis.. 

Project Details: 4

Title: IMCM (Integrated Multi-Channel Marketing), 

Client: Bayer, 

Skills: ETL, Hive, SQL Server,Redshift,AWS, 

Description: Bayer seeks to optimize investments across marketing channels to continually deliver better value to customers and maximize Returns on those Investments (ROI). Toward that aim, Bayer seeks to create an Integrated Multi-Channel Marketing (IMCM) solution that will facilitate and enable advanced analytics and KPI reporting necessary to take fact-based decisions in optimizing their IMCM to drive ROI and continually improve performance.

Certified Cloverleaf Analyst