Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Timeline
Generic
Prashant Pathak

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

undefined

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

Similar Profiles

CREATE PROFILE
Prashant PathakData Engineer