Varun Aggarwal

Experience

• 

  Aon

  Oct 2011 - Mar 2014

  Projects Worked: American Express HW Data Conversion(Health & Welfare), Air Canada DB Data Conversion(Defined Benefits)Technologies Acquainted: Informatica 9x (Designer, Monitor and Workflow designer), MS Access, DB2, Unix File Handling tool Secure CRT & Secure Fx Roles & Responsibilities• Interacting with the onsite coordinators and understand requirement specifications• Developing and testing Informatica maps based on the specifications and provide elaborative test plans including unit testing, aggregate testing and special test scenarios.• Debugging the working of the informatica maps, Troubleshooting, Testing, and Documentation of Data Warehouse and maintaining root cause analysis (RCA) document.• Ensuring Data transformations, validation rules, best practices applied are processed successfully.• Querying the data loaded to test for the integrity as per the requirement and cross checking the expected load using MS access.• Defect Raising and verifying the solution with the designated teams.• Delegating work to the offshore team and reviewing to ensure proper coding standards are followed and quality is maintained. Show less

  • Functional System Analyst Experienced

    Apr 2010 - Mar 2014

  • Senior Setup Configuration Specialist

    Oct 2011 - Oct 2012
• 

  Cognizant

  Apr 2014 - Sept 2017

  Associate Projects, Analytics & Information Management
• 

  Apple

  Jun 2014 - May 2016

  Functional QA Lead Consultant

  Projects Worked: Product Launch Dashboard, Quote Ladder, GBI iTunes Financials, ACCAR 2, Global Resource Locator, LDW SearchTechnologies Acquainted: Teradata, Oracle, SAP HANA, Apple Internal Web Applications, Apple RADAR, Dashboard ValidationsRoles & Responsibilities• Coordinate with Development teams on a multi-vendor environment, understand the requirements & design and organize the QA walkthroughs with partner vendors and stakeholders.• Provide Test Strategy, Project Estimation, Resource Plan and Test Schedule.• Provide Entry/Exit criteria and raise important risks and dependencies to all partners.• Create and Execute test scenarios and test scripts/cases • Validate the varied GBI Dashboards/ User interfaces at the front end against the backend semantic databases by framing complex queries on Oracle, Teradata and SAP HANA. • Defect Analysis, Defect re-testing, reporting issues in RADAR and provide RCA• Worked with the Automation teams to automate the QA test process using Selenium.• Provide Test Closure reports and summary documents.• Hold regular status calls with the onshore partners and discuss the project, adhering to milestone dates and ensuring the deliverables are made accordingly.• Worked in as Teradata developer for one of the tracks(GRL), analysed data changes & dependencies and worked on TD procedures, DML, DDL and deployed changes using the global deployment tool Show less

• 

  Jabil

  Jun 2016 - Oct 2016

  Big Data QA Lead Consultant

  Projects Worked: Jabil Enterprise Information PlatformTechnologies Acquainted: Big Data- Data Ingestion, HIVE, Sqoop, UNIX, APS, MSTRRoles & Responsibilities:• Coordinate with Development team, understand the requirements & design and organize the QA walkthroughs with partners and stakeholders.• Provide Test Strategy, Project Estimation, Resource Plan and Test Schedule.• Provide Entry/Exit criteria and raise important risks and dependencies to all stakeholders.• Create and Execute test scenarios and test scripts/cases for data validation across Hadoop layers.• Defect Analysis, Defect re-testing and provide RCA• Provide Test Closure reports and summary documents.• Hold regular status calls with the onshore partners and discuss the project, adhering to milestone dates and ensuring the deliverables are made accordingly.• Managed team of 8 in an Onsite –Offshore model. Show less

• 

  Huawei Technologies India

  Nov 2016 - Sept 2017

  Big Data QA lead consultant

  Worked on CarbonData(Apache open source file format developed by Huawei) for executing Non Functional use cases for CarbonData using HiveQL and SparkSQL queries• Worked as Big Data QA Lead consultant and provided Big Data QA solutions. • Worked on QA Automation utilities and organized Process and solution walkthroughs.• Provided a roadmap for building a Test Center Of Excellence for Huawei. • Project Estimations.• Test Strategy and Test Design.• Test Execution along with Automation.• Test Summary and closure. Show less

• 

  HARMAN India

  Sept 2017 - Aug 2018

  Lead Product Engineer
• 

  Carelon Global Solutions India

  Aug 2018 - now

  • Manager Architecture

    Apr 2023 - now

  • Associate Delivery Manager

    May 2021 - Apr 2023

  • Associate Technical Architect

    Apr 2020 - May 2021

  • Technical Lead

    Aug 2018 - Apr 2020