Summary
Overview
Work History
Education
Skills
Interests
Timeline
Generic
Subhadip Roy

Subhadip Roy

Data Engineer Technology Lead
Hyderabad

Summary

Experienced Data Engineering Lead with 11+ years of expertise in financial services and enterprise data systems. Proven track record in leading large-scale data migration and engineering projects, designing scalable data architectures, and delivering high-impact solutions for global clients. Strong hands-on skills in SQL, PL/SQL, PostgreSQL, Snowflake, and Oracle with deep experience in ETL pipeline development, data modeling, performance tuning, and warehouse design. Adept at integrating AI-based data transformation, data governance frameworks, and reconciliation solutions to improve data quality and accelerate decision-making. Recognized for onsite client engagement in the US, building trusted partnerships and driving business value through data-driven insights.

Overview

12
12
years of professional experience
1
1
Language

Work History

Technology Lead

Broadridge
04.2022 - Current
  • Designed and developed end-to-end data pipelines using Python, PostgreSQL, and Snowflake to process and transform ~10M+ financial and demographic records daily, enabling accurate personalized analytics that improved customer segmentation and increased marketing ROI by 15%.
  • Built automated reporting pipeline with PostgreSQL and shell scripts, processing millions of financial and demographic records daily to deliver accurate reports 60% faster, ensuring timely insights for decision-making.
  • Led full project lifecycle for an enterprise-grade Investor Insights platform, architecting Snowflake-based reporting databases and scalable ingestion pipelines in Python/SQL to handle 50M+ monthly financial records. Delivered real-time dashboards that democratized investment analytics while reducing development cycles by 80% (6 months → 1 month).
  • Leading the Development Efforts AI-driven data categorization pipelines using GPT models, Python, and PostgreSQL to structure unorganized text datasets. Improved classification accuracy by 30% and drastically reduced manual effort, enabling faster turnaround on analytical reporting
  • Automated ad-hoc queries frequently used by Sales and Marketing into reusable PostgreSQL functions, reducing query processing effort by 50%, accelerating turnaround time on requests, and enabling faster decision-making across business teams
  • Provided mentorship to junior team members, fostering professional growth and strong work ethics in the workplace.

Senior Consultant

Syniti
03.2020 - 03.2022
  • Implemented a robust data reconciliation framework by developing reusable PL/SQL scripts and stored procedures for data transformation, validation, and loading across multiple modules of ERP systems, reducing data discrepancies by 40% and ensuring higher data accuracy for downstream reporting and analytics
  • Delivered large-scale data migration projects by mapping legacy datasets in SQL-driven ETL tools and loading into Snowflake, SQL Server, and SAP systems using plugins and automated workflows. Improved client data visibility across ERP and reporting platforms, enabling seamless adoption in finance, operations, and analytics.

Associate Team Leader

Tech Mahindra
10.2013 - 01.2020
  • Managed 10+ enterprise-scale data migration projects across telecom and financial domains, ensuring on-time delivery and alignment with client requirements.
  • Developed custom migration scripts and SQL-based transformation logic to enable seamless migration of multi-terabyte datasets into modern platforms
  • Performed reverse engineering and ER modeling of complex legacy databases, supporting architectural modernization and strengthening system scalability.
  • Worked onsite with US enterprise clients as a trusted partner, aligning with stakeholders, identifying gaps, and delivering customized solutions that streamlined data workflows and enhanced project outcomes.
  • Ensured end-to-end data integrity by implementing rigorous validation frameworks, monitoring procedures, and automated reconciliation checks, reducing migration defects and post-go-live issues by 40%.

Education

B.Tech/B.E. - Information Technology

West Bengal University of Technology (WBUT)
01.2013

Emerging Leaders Managment Program - Organizational Leadership

GlobalNxt University
04.2001 -

Skills

Programming & Scripting: SQL, PL/SQL, Python, Unix

undefined

Interests

Automobiles

Sports

Timeline

Technology Lead

Broadridge
04.2022 - Current

Senior Consultant

Syniti
03.2020 - 03.2022

Associate Team Leader

Tech Mahindra
10.2013 - 01.2020

Emerging Leaders Managment Program - Organizational Leadership

GlobalNxt University
04.2001 -

B.Tech/B.E. - Information Technology

West Bengal University of Technology (WBUT)
Subhadip RoyData Engineer Technology Lead