Sep 2024 – Mar 2025 · 6 mos · Gurugram, Haryana, India

• Orchestrated the hydration & migration of petabyte-scale SORs to Organized Data Layer(ODL) from on-prem Big-Data to Google Cloud’s BigQuery while optimizing data lineage, and traceability & Designed metadata-driven ETL pipelines, ensuring seamless ingestion of over 3 billion records while enhancing schema evolution and processing efficiency.
• Spearheaded data engg efforts for portfolios - Ace, Clic, and Icare, which process over 250 million high-priority customer cases annually by refining the Icare ODL logic for accurate status tracking (open, updated, resolved, closed, terminated) & ensuring accurate tracking of fraud & disputes cases for investigative analytics across 10+ years of historical data.
• Implemented rule-based data quality frameworks using Qalibrate, setting up dynamic thresholds and validation rules for global dispute management, write-offs and complaints data. Enhanced data accuracy & integrity across 200+ tables, validating over 500 million transactions monthly, ensuring audit readiness for US regulatory banking compliance.
• Led the DLM and data purging activities for multi-terabyte datasets across American & Canadian markets, ensuring adherence to regulatory standards & Conducted audit-driven data retention policies, managing compliance investigations for 1.26 billion archived and purged records spanning 15+ years.

Aug 2022 – Mar 2024 · 1 yr 7 mos · Pune, Maharashtra, India

• Established solution for the Impala issue related to parquet decimal precision in PROD target database tables, ensuring accurate data validation and integrity for Barclays UK Retail Banking's MDI databases
• Simplified seamless data transfer from SIT to OAT by conducting 450+ count validations solutions, extracting PROD data via CSV, and employing Ab Initio graphs for efficient SIT data loading. Adhered to Change Request (CR) protocols, enabling smooth transfer, crucial updates, and advancements in target environment
• Fulfilled a meticulous 90+ HUE table verification process based on CRA criteria, categorizing tables, and overseeing checks, ensured a well-prepared table set for an accurate KPMG audit aligned with industry standards

Jun 2021 – Jul 2021 · 1 mo

• Led the development of data transformation processes for Barclays UK Retail Banking in Hive and Impala within Hadoop, resulting in a 25% increase in database operations and operational efficiency
• Leveraged Tableau to drive comprehensive data visualization, analysis, and exploration, culminating in creation of 10+ impactful dashboards that played a pivotal role in project’s success.
• Created detailed presentations and documentation on data warehousing concepts, including ELT/ETL to Data Lake, facilitating knowledge dissemination among team members and ensuring a smooth implementation process

Jul 2020 – Jun 2021 · 11 mos

• • Managed marketing strategies, campaigns, team management, partnerships, and performance assessment for VJTI’s annual fest worth INR 75+ lakhs, getting a footfall of 80,000 attendees and status of 5000+ online registrations for robotic events

Jul 2019 – Jul 2020 · 1 yr

• • Promoted our fest nationwide, appointing Campus Ambassadors to boost attendance at Guest Lectures, Exhibitions, and events in colleges. Managed event matches for all robotic and coding events at Technovanza.

Jul 2018 – Jun 2019 · 11 mos

• • In my role as the Head of Department for the Green Griffins house, I actively engaged and encouraged junior students to participate and excel in various robotics, coding, and technical events organized by the House Cup committee at Technovanza VJTI. Through mentorship and guidance, I aimed to inspire a competitive spirit and foster a winning mindset among the juniors, contributing to the overall success and achievements of the Green Griffins house in these events.

Jul 2019 – Jun 2021 · 1 yr 11 mos

• • Demonstrated 2 months of mentorship, tech support, educational commitment, and skills enhancement for peers in software and web development through workshops and mentorship in "Inheritance" event

Jul 2019 – Jun 2020 · 11 mos

• • As the Event Manager for Table Tennis at the Enthusia Sports Festival 2019, I orchestrated an exciting and smooth tournament, ensuring a fantastic experience for all participants. From organizing logistics to overseeing the matches, my role aimed at promoting sportsmanship and a competitive yet friendly environment, contributing to the overall success of the event.

Aug 2018 – Jul 2019 · 11 mos

• • Engaged students from various academic years within their respective departments, encouraging their active participation in IEEE events. Additionally, I took the initiative to personally promote these events on a more individual level, highlighting the unique opportunities they offered. This approach aimed to generate interest and create a dynamic atmosphere of engagement and collaboration within the IEEE community.