Shivam Gupta

Experience

• 

  Marico Limited

  Mar 2017 - Dec 2018

  Software Engineer

  Technology : | Azure Data Warehouse | ADF | ADL | BLOB | MSBI | MS-SQL | SSIS | Data EngineerRole : Analysis,Database Design & Development with Scheduling & Automation & Data AnalystMajor Projects : 1. On-Premise to Azure Migration : Strategy for heavy data loading from MS-SQL to Azure DW.2. MDM : Standardization & correction of Masters & Lookup tables with different formats on Azure.3. SPMS : Sales process Management system complex report development & optimization

• 

  Loylty Rewardz Mngt Pvt Ltd

  Dec 2018 - Sept 2020

  Senior Software Engineer

  Technology : | MS-SQL, MY-SQL | PostgreSQL | Azure DW | ADF | ADL | MSBI | SSIS |Role : Analysis,Database Design & Development with Scheduling & AutomationMajor Projects : 1. L42 Migration : End to end Banking DB migration from MS-SQL to MY-SQL with recon2. Framework Design : Design the complete architecture and development with automation.3. MIS Reports : Development various complex MIS reports with PostgreSQL MPP (Greenplum)

• 

  Morgan Stanley

  Sept 2020 - Sept 2021

  Senior Database Engineer

  | MS-SQL, MY-SQL | PostgreSQL | Azure DW | ADF | ADL | MSBI | SSIS |

• 

  LTIMindtree

  Aug 2021 - now

  Technology : | SQL Database | ADF | ADLS | Synapse | Azure DW | Oracle | MY-SQL | PostgreSQL | Logic App | Blob | Mongo DB | CICD Deployment | Optimization | SSIS | Migration | Agile |Role : Analysis, Database Design & Development with Automation.Projects : Manufacturing AnalyticsViatris' Manufacturing Data Platform is a centralized system for all manufacturing data that integrates information from SAP, TrackWise, and LIMS systems. This initiative enables a data-centric strategy for manufacturing and advanced business intelligence and analytics capabilities for Viatris. Show less

  • Principal Data Engineer

    May 2024 - now

  • Senior Data Engineer

    Aug 2021 - May 2024