Naresh Agarwal

10+ years IT professional (Investment Banking/Pharma), Senior Data Engineer QA. Expertise: data pipelines, warehousing, ETL/BI testing (Python automation), LLM Testing using DeepEval and RAGAs Proficient: Informatica, JIRA, Confluence, Power BI, Databricks, PySpark, Salesforce

Senior Data Engineer QA at Confidential (2022-04 – Present)

Worked on an AWS cloud-based application called UIP, used by business users in investment management to access data related to funds, holdings, indexes, ratings, etc. Data is fetched from source systems using data access layers (DAL) and stored in AWS databases.

• Technical Environment: AWS Redshift, Azure Data Factory, PowerBI, Tableau, Python, Redshift.
• Understanding functional requirements for change requests.
• Testing data according to business rules on Power BI and Tableau dashboards.
• Creating SQL scripts for automated functional and regression testing.
• Creating and tracking defects until closure.
• Preparing execution plans and deciding delivery dates after discussing the impacts.
• LLM testing for GenAI Product.

Senior Integration Consultant at MTX Group (2021-03 – 2022-03)

Worked on multiple projects involving data integration between Salesforce and other applications using Mulesoft. Ensured continuous data integrity across Salesforce and third-party applications.

• Technical Environment: Mulesoft, Salesforce, Tableau, Informatica.
• Ensuring data integrity between Salesforce and other applications.
• Testing data integration processes.
• Creating and tracking defects until closure.
• Preparing execution plans and deciding delivery dates after discussing the impacts.

Senior ETL Test Consultant at ZS Associates (2020-02 – 2021-03)

Worked on an ecosystem analytics dashboard based on Qlik Sense and Tableau, providing large-scale data insights for pharmacy-related product sales and marketing data. Data is fetched from source systems using interfaces called OASIS, hosted on Amazon Redshift.

• Technical Environment: Informatica, Qlik Sense, Tableau, Python, Redshift.
• Understanding functional requirements for change requests.
• Testing data according to business rules on Qlik Sense and Tableau dashboards.
• Creating SQL scripts for automated functional and regression testing.
• Creating and tracking defects until closure.
• Preparing execution plans and deciding delivery dates after discussing impacts.

Test Analyst at Fidelity International (2016-10 – 2019-11)

Worked on an OBIEE-based application called Discovery, used by business users in investment management to access data related to funds, holdings, indexes, ratings, etc. Data is fetched from source systems using data out layers (DOL) and stored in Oracle databases, then processed and stored in TimesTen databases.

• Technical Environment: Informatica, OBIEE, Oracle, Python, Control-m, Putty, Unix.
• Understanding functional requirements for change requests.
• Loading data using Control-M.
• Testing data at different databases like Oracle and TimesTen.
• Creating OBIEE reports according to use cases defined by business analysts.
• Creating SQL scripts for automated functional and regression testing.
• Creating and tracking defects until closure.
• Managing code execution, environment setup, and test case execution for UAT.
• Performing scenario-based testing to cover negative testing.
• Organizing status calls to provide updates on project status and open issues to management.

Test Engineer at Infosys Limited (2014-08 – 2016-10)

Worked on the Rainbow 2 project, which involved creating a new bank, William & Glyn, from the existing RBS bank. The project required migrating data for 1.8 million customers in multiple phases, and delivering BI reports based on priority.

• Technical Environment: Informatica, Cognos, DB2, Mainframe.
• Collaborating with clients to understand and implement report requirements.
• Designing and validating test rules for business and system requirements.
• Preparing and managing execution plans, including code execution and UAT.
• Conducting scenario-based testing and organizing status calls for updates.
• Validating data integrity across various levels and tools, including Framework Manager and Cognos.

MS in Business Analytics – Birla Institute of Technology and Science, Pilani

B Tech in CSE – Arya College of Engineering and IT, Jaipur, Rajasthan Technical University, Kota