Pranav Ghosh
M&T Bank
West Seneca,NY
1
Certification
16
years of professional experience
Executive‑level Data Engineering and Software Development leader with 16 years of experience shaping high‑impact data platforms across commercial lending, regulatory reporting, and enterprise analytics. I specialize in modernizing legacy systems and driving cloud transformation, with deep expertise in Azure data services, ETL engineering, and enterprise data warehousing. I bring a strong track record of leading technical teams, elevating engineering standards, strengthening SDLC practices, and delivering mission‑critical initiatives with clarity, precision, and long‑term strategic value.
Work History
Technical Lead
2 Years 6 Months- Teamed on development of technology roadmap spanning 16 years.
- Built enterprise frameworks to capture Commercial Lending data from multiple upstream systems and load it into the Operational Data Store (ODS) supporting regulatory reporting and internal bank analytics.
- Migrated and modernized on‑prem Informatica PowerCenter pipelines to Azure, leveraging Azure Data Factory, ADLS Gen2, Azure SQL, and Synapse to improve scalability, reliability, and cost efficiency.
- Achieved Microsoft Azure certifications (AZ‑900, DP‑900) demonstrating strong cloud fundamentals and data platform expertise.
- Designed and implemented software architecture frameworks that enhanced system performance, scalability, and long‑term maintainability.
- Led cross‑functional teams (QA, DevOps, Support, Business) to deliver complex technical initiatives on time and within budget.
- Mentored junior developers, improving team capability, coding standards, and overall engineering quality.
- Streamlined development processes by integrating Agile methodologies, resulting in faster delivery cycles and improved team efficiency.
- Collaborated with business stakeholders to define requirements and ensure alignment with regulatory and operational objectives.
- Conducted thorough code reviews to maintain high-quality standards, reduce technical debt, and optimize system performance.
- Evaluated emerging technologies and recommended solutions that drove innovation and competitive advantage for enterprise data platforms.
- Managed project timelines, resources, and dependencies to successfully deliver multiple concurrent initiatives.
- Enhanced system reliability through debugging, performance tuning, and optimization of ETL workflows.
- Implemented CI/CD strategies to accelerate release cycles and improve deployment consistency across environments.
- Analyzed performance metrics to identify bottlenecks and implemented solutions that boosted development and runtime efficiency.
- Coordinated and contributed to microservices architecture transition, enabling faster feature deployment and improved modularity.
- Oversaw technology and software budgets, ensuring cost-effective resource utilization.
- Led technical upgrade projects by coordinating with consultants and developers for seamless integrations and platform enhancements.
- Technologies: Ab-Initio, Informatica PowerCenter, Teradata, Oracle, Salesforce, Unix, Azure Data Factory, ADLS Gen2, Azure SQL, Power BI GitHub, ServiceNow.
Associate Architect
10 Years 4 Months- Completed regulatory reports for CCAR in accordance with FRB guidelines. – (Schedule A-M) which are filed to FRB quarterly and annually. Regulatory reporting for LATAM region (Mexico, Peru, Brazil, Costa Rica, Honduras, Panama).
- Utilized Ab Initio for data processing and management tasks., GDE (Graphical Development Environment) 3.2.5.2/Co-Op2.2.2.9, Oracle 11/10g, Windows 7/XP, UNIX, Autosys, Control center, Service Now, RLM, Sybase, Spark.
- Employed Citibank's in-house tools for data processing tasks.: Rules Harmony, Helix (Both these tools are Ab-Initio frameworks).
Technical Project Lead/Developer
5 Years 4 Months- The project is aimed at developing and supporting CCAR (Schedule H) – Reporting which is reported to FED on a quarterly basis. The Comprehensive Capital Analysis and Review (CCAR) is an annual exercise by the Federal Reserve to ensure that institutions have well-defined and forward-looking capital planning processes that account for their unique risks and sufficient capital to continue operations through times of economic and financial stress.
- Utilized Talend, Ab Initio, GDE 3.0.5.2, Co>op 3.0, Oracle 11/10g, Windows 7/XP, and UNIX to streamline data processing and reporting workflows.
- Led cross-functional teams to deliver complex technical projects on time and within budget.
- Coordinated project schedules, resources, and stakeholder communications to ensure alignment and transparency.
- Implemented agile methodologies to enhance project delivery efficiency and team collaboration.
ETL Developer
3 Years 1 Month- Utilized Informatica Power Center for data integration tasks in a UNIX environment.
- Designed and developed ETL processes for data integration and transformation.
- Collaborated with cross-functional teams to gather requirements and optimize data workflows.
- Implemented data quality checks and validation procedures to ensure accuracy of information.
Education
Bachelor of Engineering - Information Science
12th
State Board
10th
State Board
Skills
ETL & Data Engineering
Azure ADF
Informatica
Ab Initio
Talend
Data Warehousing & Dimensional Modeling
Requirements & Data Analysis
Autosys
Automic
Control Center
Cloud & DevOps
Azure (ADF
ADLS
Synapse)
CI/CD
GitLab
Bitbucket
Software Engineering
Software Design & Development
SDLC & Agile
Code Review & Optimization
Technical Documentation
Programming & Scripting
Shell Scripting
SQL (Oracle
Teradata
SQL Server)
Business Intelligence & Reporting
Power BI
Reporting & Analytics
Requirements Gathering
Leadership & Collaboration
Technical Leadership
Team Mentoring
Cross‑functional Coordination
Client Relationship Management
Issue Investigation & Resolution
Tools & Platforms
ServiceNow
Defect Tracking Tools
Database Management (Oracle
Teradata Express
SQL Server
Toad Automation)
Salesforce Backup and Salesforce Restore
Certification
Microsoft Certified: Azure Data Fundamentals
Credential ID 30B3F7E43518312E
Microsoft Certified: Azure Fundamentals
Credential ID 3D4B43DB0391C81
Talend Data Integration v6
Credential ID 68cw3832e98qw32-52374287
Oracle-ExaData
Timeline
Technical Lead
M&T Bank
01.2024 - CurrentRead More
Associate Architect
Virtusa Consulting Service Pvt Ltd
09.2013 - 01.2024Read More
Technical Project Lead/Developer
Virtusa
11.2010 - 03.2016Read More
ETL Developer
Hewlett-Packard India sales Pvt Ltd
07.2010 - 08.2013Read More
Dr.V.S.E.C Sharda Nagar Kanpur
10th
Read More
Dr.V.S.E.C Sharda Nagar Kanpur
12th
Read More
VTU University
Bachelor of Engineering from Information Science
Read More