Vaibhav Bansal

Project : British Petroleum

• Led migration from Cloudera Data Lake to AWS, improving performance by 15%.
• Built scalable data pipelines processing millions of semi-structured records (SAP, APIs, manual files).
• Performed data profiling, mapping design, and ETL development for navigation issue resolution.
• Delivered reports and insights to business users and stakeholders.
• Performance optimization to get the most efficient results from data pipelines and queries.
• Collaborated with stakeholders to gather business requirements and propose optimized, cost-efficient solutions.

Project : Mckinsey & Co.

• Lead and mentor a team of ETL testers
• Assign tasks, manage workloads, and track progress to ensure timely delivery of quality deliverables.
• Performed data validation in various ETL environments, such as DataStage, QuerySurge.
• Conduct audits, risk analysis, and root cause analysis for production defects.

Project : CVS pharamcy, Walgreens , Eli lilly

• Performed end-to-end validations using SQL queries across different databases like Oracle and Teradata.
• Created and optimized automated testing tools for repetitive tasks.
• Performed data validation in various ETL environments, like Informatica, Ab Initio, and SSIS.
• Analyzed source-to-target mappings provided by developers to ensure that data is being transformed correctly as per business requirements.

Project : HP

• Worked on HP-UX platform developing and automating test cases for networking utilities.
• Conducted manual and automation testing for HP-UX patches and releases.