Purusharth Pathak

Experience

• 

  LTI - Larsen & Toubro Infotech

  Aug 2013 - Nov 2015

  Software Developer MSBI

  • Understanding the end-to-end requirement and working with the Architect to contribute in design which involves ETL changes for the product design• Business communication with the stake holders, 3rd party data vendors (GEICO, All State, PMA, Scottsdale , Sompo Japan etc) to understand the new requirement on Reporting and modify the product to provide best solution• Developed stored procedures for DWS (data warehouse) interface using T-Sql and worked on Reports development• Resolving technical issues and implementing Change Requests within the defined SLA. Actively involved in follow ups with teams of upstream systems, partner systems to get things done • Job optimization for performance as and when required. Also monitored daily production and test jobs for the Product run and daily execution• Involved actively with Production support team to get the feeds processed and resolving issues• Was involved in maintenance activities and product enhancements initiatives• Bug fixes and complete support for the ETL challenges Show less

• 

  CDK Global

  Nov 2015 - Mar 2018

  Senior Member Technical

  SQL Server developer.Vast experience in understanding data quality and maintaining data integrity and consistency. Involved in data correction activities. Understanding the end-to-end requirement and working with the Architect to contribute in design which involves ETL changes for the product designDeveloped stored procedures for DWS (data warehouse) interface using T-Sql and worked on Reports developmentResolving technical issues and implementing Change Requests within the defined SLA. Actively involved in follow-ups with teams of upstream systems, partner systems to get things done Job optimization for performance as and when required. Also monitored daily production and test jobs for the Product run and daily executionInvolved actively with Production support team to get the feeds processed and resolving issuesWas involved in maintenance activities and product enhancements initiativesBug fixes and complete support for the ETL challenges Show less

• 

  Tieto

  Mar 2018 - Oct 2021

  Senior Software Engineer

  Working in healthcare and welfare domain.Current role of SQL developer and perform database management. Also involved in Data tuning and warehouse model architecture.

• 

  Tietoevry

  Oct 2021 - Dec 2023

  Lead Software Engineer

  I was heading data platform team wherein I managed as scrum master and lead in product development of Lifecare HIS ( upto release 2023 MR ). During my tenure I was able to take database in CI CD , worked with database packaging with Dacpac, Dbnuggest , DBOPs , Gatekeeping and securing the databases changes and laid foundations for zero maintenance solutions. The role includes the dba responsibilites as well.

• 

  Genpact

  Jan 2024 - now

  Senior Principal Consultant