Abhijit Dharmadhikari
Vice President
Pune
Summary
Data Engineer with over 13 years of experience in designing, developing, and optimizing data integration pipelines and architectures. Demonstrated proficiency in ETL tools like Pentaho and DBT, alongside strong expertise in Snowflake, Oracle, and big data technologies such as Hadoop and Spark. Skilled in collaborating with cross-functional teams to deliver high-quality data solutions that enhance business insights and support decision-making
Overview
13
13
years of professional experience
4
4
years of post-secondary education
2
2
Certifications
Work History
Vice President
BNY
9 2021 - Current
- Leading data engineering team focused on integrating all data governance systems, including Business Glossary, Data Quality, and Data Lineage, to ingest data into data warehouse for reporting and analytics.
- As product architect, collaborating with product owner to understand stakeholder requirements and design effective solutions.
- Designed overall architecture for integration and developed Pentaho ETL processes to consolidate data in integration database through API and database integration.
- Migrated data warehouse from Oracle to Snowflake, redesigning and optimizing ETL processes using DBT on Snowflake.
- Experienced in data governance tool Collibra, contributing to workflow development, and serving as an architect for the entire data governance team.
- Integrated BNY's internal LLM model with Data Governance Chatbot.
Specialist Software Engineer
LTI
09.2018 - 08.2021
- Lead offshore Counterpart Credit Risk team for Nordea. Responsible for developing and enhancing/rectifying IMM models used in risk calculation using Oracle PL/SQL.
- Implemented SACCR measures in tight regulatory schedule which saved bank from regulatory penalties.
- Developed ETL process in Pentaho to feed data to Credit Risk Engine from all golden sources.
- Worked extensively on performance tuning of end-of-day jobs and backend SQL used in Credit Risk portal.
- Worked as Business Analyst to analyze post-trade data and find code/data issues.
- Developed in-house ETL tool for trade data warehouse using PL/SQL and Python.
Consultant
Capgemini
05.2015 - 09.2018
- Oracle PL/SQL developer for energy trading application for EDF Energy.
- Worked on creating ODS part for reporting data warehouse.
- Performance tuning overnight end-of-day job by implementing indexing, partitioning, and other performance tuning techniques.
- Automated server sanity checks through shell scripting.
- Developed delivery quality reporting application backend and highly optimized queries for BI reporting.
Software Engineer
Accenture
02.2012 - 02.2015
- Oracle PL/SQL Developer in British Sky Broadcasting account in CRT IT team.
- Automated bulk data correction process, which was originally a manual database update, through PL/SQL procedures.
- Developed SQL scripts for operations team to ease data correction work.
Education
Bachelor of Engineering - Electronics And Telecommunication
Amravati University
Amravati 05.2007 - 05.2011
Skills
Snowflake
ETL (Pentaho,DBT)
Oracle PLSQL
Data Warehouse
Hadoop (Hive, Sqoop, Spark)
Data modelling
Python
Data Governance
Certification
Snowflake - Data Warehouse
Timeline
Snowflake - Data Warehouse
01-2021
IIT Roorkee - Certification Program in Machine Learning
07-2020
Specialist Software Engineer
LTI
09.2018 - 08.2021
Consultant
Capgemini
05.2015 - 09.2018
Software Engineer
Accenture
02.2012 - 02.2015
Bachelor of Engineering - Electronics And Telecommunication
Amravati University
05.2007 - 05.2011
Vice President
BNY
9 2021 - Current
Similar Profiles
Lucas BrownLucas Brown
Senior Associate - Fund / Client Accounting at BNYSenior Associate - Fund / Client Accounting at BNY
Timothy DrexlerTimothy Drexler
Senior Vice President - Product Owner at BNYSenior Vice President - Product Owner at BNY
Elizabeth MartingaleElizabeth Martingale
Senior Associate at BNYSenior Associate at BNY