Sumit Mishra Email and Phone Number

● Implementing and standardizing data models on Snowflake data warehouse to onboard data from multiple upstream systems. ● Architecting Azure-Snowflake, Azure-Legacy Sftp integration thus ensuring continue data transfer and meeting data load SLAs to alpha platform. ● Setup Git CICD pipelines to create azure artifacts for automated deployments. ● Acting as a data integration point of contact between State Street business, CRD and Clients in Europe, UK, and North America to implement end to end data pipeline. ● Implemented custom data pipelines using JavaScript - SQL thus enhancing platform capabilities to support client specific data provisioning. ● Architecting Azure Functions across multiple clients to perform file operations on Azure Storage. ● Built data processes to Flatten performance and Liquidity data utilizing standard vertical DWH model as source, thus improving data processing time to less than 15 minutes from 4 hours and allowed to skip legacy data processing pipelines that could not manage heavy volumes. ● Optimized Talend interfaces and reduced TMC memory utilization, thus reducing data load time from 5 hours to 2 minutes for every 400 flat reports. ● Implemented parquet file generation and consumption process for non-snowflake clients utilizing Kafka message for client notification.

Designing Snowflake data warehouses and ETL/ELT processes to provide most cost effective solutions to usersSetting up new snowflake oriented processes and training business teams on new environmentGuiding teams across multiple locations to ensure continuous product developmentWorking with provisioning teams to help setup code environments, data warehouse sizing

Remodeling, standardizing and automating legacy investment data load and file system processes to enable early error detection, reduce manual effort and execution time by 50% to 60%Developed date validation logic to verify Holidays and Market Close days thus increasing reporting accuracy by 10%Redesigning 200 plus integration target tables and migrating billions of records without downtime thus improving datasets efficiency for reporting purposes by over 80% while keeping current production up and runningAutomated BI solution deployments on 7 environments using PowerShell as part of TFS build and achieved minimum manual intervention in execution and deployment of ETL and reporting processes thus resulting in reduced project cost by 8%Introduced Data and File auditing thus enabling user detection, application behavior, and vendor activityMigrate new integration solutions to Azure as part of cloud migrationSupervise a small team of ETL and report developers to create and migrate over 300 ETL packages and 100 plus reportsCoordinate with client and business users to set project expectationsCreate ETL and reporting documentation to help stakeholders with the migration process and ensure a smooth transition

Migrated legacy ETL solutions to SSDT 2017 thus removing multiple version dependenciesCreated Integration environment with independent ETL architecture, database, and configurations to enable the sales team to demo ETL and reporting capabilities to prospective clients on Azure without downtimeDeveloped custom script components to replace limited functionality third party checksum tools which resulted in reduced project cost by 5%

Implemented ETL architecture for incremental data loads utilizing OLTP source using change tracking and Change Data Capture thus providing customer near Real-Time Reporting Data every 5 minutesDesigned Data Warehouse based on Star and Snowflake data modeling for reporting and analysis

Implemented ETL process to regulate energy bidding process by generating and publishing Locational marginal pricing files (LMP) used to establish the price for bidding based on location and congestion (Consumer monthly energy bills are based on this price)Developed SSRS reports consuming historical load data to generate precise load curves used for energy forecasting by government and non-government organizationImplemented Matrix report to reduce the number of pages from 300 to 80 which improved performance and increased the number of users accessing the reportDeveloped Energy distribution zones and Business intelligence process to load historical data from 1997 to 2017 and current data for each zone into Zonal load reports used by Markets and planning team for accurate pricing, distributionUtilized PI time series data as source in ETL to generate output with 2 seconds of delay for each data point

Created Load balance package to run 42 ETL packages at a stretch in parallel resulting in increased database performanceImplemented and Standardized ETL for data migration, incremental Loads to onboard new customers, reducing go-live time by 50%Redesigned multiple ETL processes and database table relation to load upstream differential data from SQL database backup, therefore, bringing ETL process run time from 5 days to 1 day

Implemented ETL to migrate billing data to report databaseCreated BI process to feed data into the Billing system