NIKHIL GUPTA
Associate Consultant
PUNE,Maharashtra
Summary
- 7.5 Years of experience in Analysis, testing projects and engaging with clients from different geographies.
- Presently working for MedPro Insurance PLC as Test Lead.
- Dedicated and skilled ETL Tester with more than 4 Years of experience in ensuring the quality and accuracy of data extraction, transformation, and loading processes.
- Proficient in various ETL testing methodologies and tools, seeking to leverage expertise in a dynamic organization to contribute to the development of robust data pipelines.
- QA Lead for creating scenarios and writing complex SQLs for ETL, Master Data Management (MDM) projects.
- Worked in different insurance domain like General Insurance, Property and Casualty and Medical Liability Insurance.
- Handling the different database for the ETL scenarios and performance issues.
- Experience in working with Agile model.
- Onsite Experience in working for Zurich Insurance PLC in United Kingdom.
Overview
4
4
years of professional experience
4
4
years of post-secondary education
Work History
ETL Test Lead
MEDPRO Insurance PLC
01.2022 - Current
- Medpro Insurance PLC is part of Berkshire Hathaway family
- MedPro Group was founded in 1899 and was first company to offer malpractice insurance in U.S.A
- Today, it protects over quarter million healthcare providers in USA.
- Monitored resolution of bugs, tested fixes, and helped developers tackle ongoing problems by providing QA perspective.
- Built automated test scripts to handle repetitive software testing work.
- Developed and maintained defect databases for known issues.
- Developed comprehensive test plans, addressing all aspects of ETL processes to ensure thorough coverage and minimal risk.
- Established effective communication channels between cross-functional teams for better collaboration during testing cycles.
- Documented testing procedures for developers and future testing use.
- Kept scripts and test cases updated with current requirements.
- Requirement Analysis from sprint backlog in JIRA
- Test Scenario and test case design activities.
- Handling key aspects related to testing that includes strategy, planning, building scenarios and data creation.
- Proficient in preparing test plan and ensuring all stakeholders and strong business analysis skills.
- Expertise in writing complex SQL Queries, ETL testing and handling large databases.
- Ownership of entire life cycle of testing, defect management, and reporting test results, deeply analyzing test artifacts and enhancing test artifacts to improve quality of testing.
- Leading Regression testing, Smoke testing, Integration testing
- Responsible for Test planning and preparation of Data Integration, Match & Merge rule validations
- Coordinate with program and development management teams in product development lifecycle to conform end-user product and quality requirements and shipment schedules.
- Translating excel formulas into SQLs to automate through application, saving time from huge worksheets.
- Led activities like project estimations, maintaining JIRA, and other activities as per agile format.
Onsite Technical Lead
Zurich Insurance Group UK
10.2020 - 12.2021
- -Zurich UK PLC is one of subsidiaries from Zurich Insurance Group based in Zurich Switzerland
- This project is all about decommissioning of Z-Trade application and completing transition into new application called ZDR (Z-Trade Data Repository).
- Analyze requirement and work with offshore team to complete it.
- Completed data transition of all source codes related to Z-Trade application and downstream application.
- Provided support to migration and de-commissioning activities (Handle migration and de-commissioning related issues) and fixing issues.
- Provided support to ZDR(Z-Trade Data Repository) Application.
- Provided support for downstream system for Z-Trade Policies, manual workarounds and any issues related to Z-Trade Policies.
- Preparation of manual file to fix vehicle entry or financial issues for policies.
- Share manual file with respective team so that it can processed in batch Job.
- Deletion of policies from system and its downstream applications.
- Provided support for any claims and investigation queries which needs input from Z-Trade XMLs.
- Worked on Brexit policy project which is Ad hoc project, Customer needs data from Production database and for all policies which term end date is before Brexit(Britain Exit).
- Preparation of ZDR Runbook which is full process document for given project.
Associate Consultant
AIG (American Insurance Group)
2 2017 - 10.2020
- AIG (American International Group) is American multinational, finance and insurance corporation
- Project includes many modules such as Ab initio, Claims Mapping, Ad hoc user request, daily, weekly and monthly report generation.
- Requirement gathering from Business Team.
- Analyze data to understand various scenarios of client business.
- Taking care of biggest and important module of our project (Excess Mapping Module).
- Write SQL queries using DML commands to retrieve data from database as per business requirement.
- Proficient use of Advance Excel for analyzing data to create reports and shared with user as per requirement.
- Use excels formulas and V-LOOKUP to create reports and analyze data.
- Creating input file that included claim list so that we can be attached in ticket and support team uses command and load claims into table.
- Creating ticket in service now to load data from input files in Tables.
- Creation of process documents that team can understand thoroughly and work on given tasks.
- Received appreciation mail from AIG Lead for managing excess mapping table.
- Perform data analysis for complex business issues related to TPAIR loss processing, recommends solutions and provide supporting statistics related to claim processing issues and provides impact analysis of corrections related to potentially incorrect data in TPAIR.
Education
Bachelor of Science - Electronics And Communication Engineering
Sushila Devi Bansal College of Technology, Indore
Indore, India 08.2011 - 07.2015
Skills
Database: MS SQL Server, DB2, Oracle
Test Management: JIRA, Zephyr
ETL Tools: Informatica, Data stage, Talend
Regression Testing
Black Box Testing
White Box Testing
Bug Tracking and Resolution
Test Plans and Test Methodologies
Manual test case preparation
Testing Concepts: SDLC, STLC, Agile(Scrum)
Education Summary
S.D. Bansal College of Technology, Indore, Bachelor’s of Engineering (B.E) in Electronics and Communication Engineering (E&C), 2011-2015
Awards
- Received 5 spot awards from my reporting manager, team lead in Atos|Syntel.
- Anniversary/Milestone award for completing 5 successful years in Atos|Syntel.
- Individual Awards Adaptive – Atos|Syntel Agile Value Awards Q3 2021.
- Received appreciation from Zurich client to complete the migration and transition activities fluently.
- Received appreciation email from Reporting Manager, Delivery Director and Engagement Director for my efforts and contribution to Atos|Syntel.
Accomplishments
- Received 5 spot awards from my reporting manager, team lead in Atos|Syntel.
- Anniversary/Milestone award for completing 5 successful years in Atos|Syntel.
- Individual Awards Adaptive – Atos|Syntel Agile Value Awards Q3 2021.
- Received appreciation from Zurich client to complete the migration and transition activities fluently.
- Received appreciation email from Reporting Manager, Delivery Director and Engagement Director for my efforts and contribution to Atos|Syntel.
Timeline
ETL Test Lead
MEDPRO Insurance PLC
01.2022 - Current
Onsite Technical Lead
Zurich Insurance Group UK
10.2020 - 12.2021
Bachelor of Science - Electronics And Communication Engineering
Sushila Devi Bansal College of Technology, Indore
08.2011 - 07.2015
Associate Consultant
AIG (American Insurance Group)
2 2017 - 10.2020