Prashant Pathak
Data Engineer
Mumbai
Summary
A result oriented professional with an experience of over 10 years in database technologies and scripting. Equipped with skills to model solution based on various use case and requirement. Have a knack to adjust to firms technological needs and provide timely solution. Proficient in working with huge volume of data, diagnose performance bottleneck and query tuning.
Overview
11
11
years of professional experience
17
17
years of post-secondary education
3
3
Certifications
Work History
Senior Manager
Morgan Stanley
08.2018 - Current
- Project :DS-OL (Data Standard for Order Life Cycle)
- Designed process to extract Orders data from multiple sources , perform ETL and generate submission file for Hong Kong SFC regulator.
- Designed validation model that check data quality, followed by Auto-Analysis (for violation) & alert mechanism to stakeholders
- Perform optimization and automation of process , reduced entire processing time by more than 50%
- As SDM (Software Delivery Manager) for a team of 8 members work to inculcate agile (Devops) best practices within team , resolve blockers and evaluate KPI for squad
- Project :Volcker
- Involved in upgrade of Volcker system (regulatory upgrade to Volcker 2.0) Modeled the system to generate Xml file for various regulators, which included a 2 layer validation (XSD validation & Rule based validation)
- Designed Python Flask GUI to enable users to override business metric
- Flask UI had kerberized login (authentication) , LDAP based authorization and incorporated Sql Alchemy ORM for modeling
- Designed multiple SAP Boxi report (BI report) based on client requirements
IT Engineer
NSEIT, BNP Paribas
04.2017 - 08.2018
- Project :Bizcore Reporting
- Extract Ledger and exposure data for HK region from Data Warehouse daily
- Load data in staging area and perform ETL via Informatica Powercenter
- Performed query optimization, error diagnosis and troubleshoot issue to generate submission file on time(SLA).
Associate
Cognizant Technology, Kotak Life Insurance
03.2016 - 04.2017
- Designed "Dedupe" engine for client , that could be coupled with various system and helped fetch already existing customer based on details provided
- This system ran multiple configured rules based on inputs provided and returned matching client with confidence score.
- It could cater multiple requests with high accuracy and optimum performance (approx. 3 sec per request).
System Engineer
Tata Consultancy Services
09.2012 - 02.2016
- TCS Bancs Implementation and migration of .Net version of product for Merrill Lynch
- Develop new modules (CR) on Stock Exchange Circular for multiple clients.
- Established Auto allocation by reading files via external tables.
- Handling production issues and assist client to resolve system issues.
Education
BE - Computer Science Engineering
Siddaganga Institute of Technology
Tumkur, Karnataka 08.2008 - 08.2023
12th CBSE -
Chinmaya Vidyalaya
Jharkhand 03.2007 - 04.2008
10th CBSE -
DAV School
Jharkhand 04.2005 - 03.2006
Skills
Database Development : DB2, Oracle & Greenplum
Scripting :Python & Unix
Web Development : Python Flask
Business Intelligence Report (Visualization): SAP Boxi, SSRS & Tableau
Data Modelling , Data Analysis & Data Warehousing
Spark : Pyspark (Streaming)
Cloud : Azure Services (ADF, Synapse & Databricks)
Devops : Jenkins , Jira & GIT
Kdb
Accomplishments
- Awarded GRIT recognition under category "Tech Debt and Legacy code reductions", at Morgan Stanley Q1 2022
- Awarded "Shining Star of the month" for overall performance, at CTS Aug 2016
- Awarded "Star Team" for overall performance, at TCS Jan 2016
- Awarded "Star Of the Quarter" for overall performance, at TCS Aug 2015
- Awarded "On the Spot" for Leading L1 Team, at TCS Jun 2015
- Awarded "On the Spot" for performance in Dot Net Implementation of DSPML, at TCS Oct2014
- Awarded "Star Team" for Dot Net Implementation of DSPML, at TCS Aug 2014
- Awarded "Consistent High Performer" in Dot Net, at TCS ILP training Dec 2012
- Awarded TCS Gem for Outstanding performance in training at TCS Dec 2012
Certification
Microsoft certified Azure Data Engineer Associate
Timeline
Microsoft certified Azure Data Engineer Associate
05-2023
Microsoft certified Azure Data Fundamentals
09-2022
Microsoft certified Azure Fundamentals
08-2022
Senior Manager
Morgan Stanley
08.2018 - Current
IT Engineer
NSEIT, BNP Paribas
04.2017 - 08.2018
Associate
Cognizant Technology, Kotak Life Insurance
03.2016 - 04.2017
System Engineer
Tata Consultancy Services
09.2012 - 02.2016
BE - Computer Science Engineering
Siddaganga Institute of Technology
08.2008 - 08.2023
12th CBSE -
Chinmaya Vidyalaya
03.2007 - 04.2008
10th CBSE -
DAV School
04.2005 - 03.2006