Data Engineer Lead

Rajeev Thakur

Lead Data Engineer Database Architect

Email: ******.***@*****.***• Phone: 969-***-**** •

Career Summary

Experienced and solutions-oriented Lead Data Engineer with 16+ years of experience in end-to-end database development, data modeling, and performance optimization. Specialized in Oracle and Snowflake platforms, with a proven ability to design scalable architectures, optimize data pipelines, and support critical decision-making in enterprise financial systems. Expert in translating complex business requirements into robust data solutions aligned with strategic goals.

Technical Skills

**Core Competencies: **

• Oracle SQL/PLSQL: Expert in stored procedures, triggers, cursors, analytic functions, partitioning, and query optimization.

• Oracle Performance Tuning: Deep experience using Execution Plans, AWR, SQL Tuning Advisor, SQL Baselines, Histograms, and DBMS Profiler.

• Snowflake Cloud Warehouse: Proficient in Streams, Tasks, Virtual Warehouses, Clustering Keys, Time Travel, Snowpipe, and Zero-Copy Cloning.

• Data Modeling: Proficient in logical/physical modeling, normalization, and dimensional design for transactional and analytical systems.

• ETL/Data Integration: Skilled in SQL Loader, External Tables, UTL_FILE, Python scripts, and Snowpipe for ingesting structured/unstructured data.

• Tools: SQL Developer, Toad, Git, SVN, JIRA

• Platforms: Windows, Linux

Professional Experience

BNY Mellon – Vice President, Data Engineer

May 2022 – Present

• Architected data structures for WMKYC and PACE projects with optimized Oracle table designs.

• Used SQL Loader and External Tables to process large datasets from multiple sources.

• Implemented PL/SQL functions, procedures, packages, and reconciliation logic.

• Applied Oracle tuning techniques using AWR, Session History, Indexing, and Execution Plans.

• Partnered with cross-teams to assess impact of schema changes and risk mitigation.

Xoriant Solutions – Senior Tech Lead

Nov 2021 – May 2022

• Integrated Snowflake into QPharma’s data pipeline for scalable data warehousing.

• Designed models using clustering keys and materialized views to enhance reporting performance.

• Developed PL/SQL-based procedures for transaction validation and order tracking.

Fulcrum Digital – Senior Technology Lead

Jun 2018 – Feb 2021

• Built data models in Erwin for Mastercard’s Pay-by-Bank App ecosystem.

• Implemented secure transaction systems with materialized views and PL/SQL procedures.

• Improved performance using AWR insights and SQL Tuning Advisor recommendations.

Tech Mahindra – Tech Specialist

May 2016 – Jun 2018

• Led Oracle PL/SQL development and data model design for AT&T’s telecom platform.

• Utilized DBMS Profiler and tuning reports to enhance stored procedures and batch loads.

• Enabled near-real-time data ingestion using SQL Loader and partitioned designs.

Atos India – Tech Lead

Jul 2014 – May 2016

• Delivered full-stack development of the Vamos platform with a focus on backend SQL.

• Created logic for subscriptions, renewals, GUI integrations, and performance fixes.

Infosys Ltd – Tech Lead

Feb 2013 – Jun 2014

• Implemented OEDQ for Barclays C&D for global screening and compliance.

• Optimized search algorithms with PL/SQL and improved detection accuracy.

Tata Consultancy Services – IT Analyst

Nov 2010 – Feb 2013

• Built partner certification database for Cisco using PL/SQL and partitioned tables.

• Designed complex logic to assign and manage partner status workflows.

Rolta India Ltd – Production Executive

Jul 2007 – Oct 2010

• Led end-to-end data migration from Ameren’s Framme to G-Tech systems.

• Ensured seamless migration through mapping, transformation, and validation logic.

Education

Bachelor of Technology

Languages

English Hindi

Interests

Cloud Computing, Artificial Intelligence

Contact this candidate