Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

SUMEET SHROTRI

Data Engineer

Summary

Database professional with solid foundation in data management and optimization strategies. Recognized for ability to enhance database performance and deliver impactful solutions through collaborative efforts. Known for adaptability and commitment to achieving team objectives.

Overview

22
22
years of professional experience
5
5
Certifications

Work History

Sr. Database Developer

Astor & Sanders
08.2022 - Current
  • Analyzed the legacy system having two separate databases.
  • Designed & created a consolidated data model for the two Legacy databases.
  • Some of the changes include creating, designing, and defining additional master tables to help consolidate the transaction data from two different databases.
  • Introducing tables to track emails being sent to customers/applicants.
  • Identifying and removing unwanted columns.
  • Mapping common data elements.
  • Designed a schema to store data for Performance study.
  • Created Python scripts to analyze data using Python Numpy, Pandas & SQLAlChemy libraries to find data anomalies & patterns.
  • Demo application to States partners and act a primary contact from application demo stage to implementation stage for State partners.
  • Created Django commands in Python to update, insert records in the database.
  • Tested the commands using AWS Kubernetes.
  • Created Tableau reports for 28 states to show daily enrollment records that are above/below 2 standard deviations than the average for the last 15 days.
  • Created tableau reports and dashboards on MySQL and csv files to show the weekly, monthly & yearly enrollments & their status.
  • Reports can be drilled down by States, Months & status.
  • Wrote queries on JSON data to display the enrollment attributes.
  • Created reports using tableau features like filters, context filters, unions etc.
  • Created refresh schedules, subscriptions & alerts to send emails to development & business teams when the standard deviation is breached.
  • Performance testing using Jmeter.
  • Wage Calculator – Analyze the current State systems for Alaska and Idaho and created a Data Model.
  • Identify the database requirements for the enhancements.
  • Designed & created tables to support the wage calculator upgrades for Idaho & Alaska.
  • Created documentation supporting the wage calculator.
  • Contributed on a proposal for DOL by creating Tableau reports on the publicly available Federal Labor data to create statistics.
  • These were used by the corporate team to pitch in for prospective DOL projects.
  • Contributed to a proposal for creating a centralized database for Unemployment Insurance.
  • Created documents to highlight advantages & disadvantages between Oracle, AWS MySQL & AWS PostgreSQL.
  • Created a POC to migrate data from IBM Informix to MySQL.
  • Creates a POC to migrate data from IBM Informix to PostgreSQL.
  • Created a POC for AWS Glue, AWS Aurora.

Sr. Database Developer

Synechron
03.2010 - 08.2022
  • Migration of non-mobility insurance claims to the mobility platform.
  • Analyze source system for data anomalies.
  • Create mapping from source table to target tables.
  • Create SQL loader scripts for downloading data from Source MySQL tables.
  • Create SQL loader scripts to load data to staging Oracle tables.
  • Create procedures. packages to massage data according to the mappings/rules and load into pre-prod tables & prod tables.
  • Used bulk operations to load the data.
  • Create automated shell scripts to run the execution.
  • Create scripts to tally the source & target data quality & record counts.
  • Create scripts for multithreading the load process.
  • Create Materialized views for Reporting.
  • Support UAT and Production implementations.
  • Mobility Insurance – Analyze underlying data issues for claims in Production using Oracle SQL queries.
  • Provide a business workaround if possible or perform a data zap to unblock the customers/claims.
  • Perform Data Analysis to identify patterns for the issue & create SQL scripts to pull all impacted records and perform an impact analysis.
  • Create PL/SQL bulk scripts and provide the development team with analysis to design a permanent fix.
  • Create SQL reports to identify the claims for ongoing issues to have them fixed proactively.
  • Create SQL reports to identify the missing master data setup.
  • Collaborate with business and get them to fixed proactively.
  • Created PL/SQL procedures for a production tool -Nucleus, which has been created for end users to perform simple data changes on Customer/Claim data.
  • The UI is built using Node Js and calls SQL queries & Pl/SQL scripts in background.
  • Tune queries for User reports, Nucleus tool.
  • Was leading a offshore team of four people.
  • Perform regular KT sessions for team members.
  • Created documentation around reports, common issues & their fixes, KT sessions.
  • Tools used – Oracle - Toad, SQL Developer, Jira, Kibanna, Putty, PostMan, Git, tortoise SVN.

Sr. Database Developer

JP Morgan Chase
06.2013 - 05.2015
  • Liquidity Risk – LRI is built to monitor the RISK data for JPMC through various reports that are generated Daily and/or Monthly.
  • Debug procedures/packages created to massage inbound data from staging area.
  • Create multiple weekly reports in SQL for management.
  • Performed query tuning for reports.
  • Debug Oracle/UNIX code errors caused by the batch jobs.
  • Support implementations.
  • Created housekeeping scripts in UNIX and scheduled them through in-house scheduling tool.
  • Support half-yearly DR failover.
  • Was leading a offshore team of two people.
  • Perform regular KT sessions for team members.
  • Created documentation around reports, common issues & their fixes, KT sessions.
  • Tools used – Oracle - Toad, Jira, UNIX Shell Scripting, Putty, SVN.

Sr. Database Developer

Bank of America
03.2011 - 02.2013
  • Created a central data repository for all Customers & their Accounts.
  • Data from different data sources like ORACLE, SYBASE & DB2 were sourced to a staging area and then extracted, transformed & loaded onto the central repository.
  • This system acts as a sole source for master data for all downstream systems.
  • Analyzed the source systems & created mappings between source and target.
  • Created staging tables to map the target tables.
  • Used global temporary tables and for some data sources used tables with no logging for faster execution.
  • Created Pl/SQL procedures, packages & SQL Loader scripts to load data into data into staging area and then created another set of procedures & packages to massage and merge the data into the central database.
  • Support production deployments & provide post-production support.
  • Created documentation on the Procedures & packages explaining the execution.
  • Created documentation on the transformation logic used in Procedures & packages.
  • Tools used – Oracle - Toad, UNIX shell, Putty, SQL Loader.

Database Developer

Morgan Stanley/Saxon
08.2010 - 12.2010
  • Created Data Warehouse for MSCC data for Month end reporting.
  • This warehouse was developed using PL/SQL as database & Hyperion as the Reporting tool.
  • Database was installed on UNIX platform & UNIX shell scripts were used for automation of execution of PL/SQL program units.
  • Data received from SAXON was from multiple sources like flat files & from other Oracle databases.
  • Used SQL Loader to upload data into staging tables.
  • Support development of reports in Hyperion.
  • Created Java scripts in Hyperion to perform intermediate processing.
  • Data warehouse consisted of three databases – DataStage: Used for staging purpose, Data History: Used for maintaining history of upload, Data Store: Month end Snapshot Used for month end reporting.
  • Tools used – Oracle - Toad, UNIX shell, Putty, SQL Loader, Hyperion, Java Script.

EDS
07.2005 - 03.2010
  • Client – Symantec Jul-2009 – Mar-2010: This system is to upload Customer data through excel files, flat files or through upstream interfaces into the database & then apply cleansing and filtering rules on it to get valid and correct data output. Tool used – Toad, SQL Navigator, SFDC.
  • Client – RBS – Royal Bank of Scotland Nov-2008 – Jun-2009: Developed Oracle Pl/SQL procedures to calculate the fees, rebates for the claims for different services offered to customers by RBS. Creates UNIX scripts & cron jobs to execute them. Created reports to provide weekly data for analysis to management.
  • Client – ABM Amro Jul-2005 – Oct-2008: Created reports using Oracle for the back-Office system – Wallstreet for ABN Amro. Provide production support. Created scripts for the daily incoming & outgoing files. Created Unix scripts to transfer & download files. Automate the process using cron jobs. Provided on-site UAT support.

Indus Software
07.2004 - 07.2005
  • Migration from Legacy de-centralized systems to a Centralized System using Oracle Pl/SQL scripts.
  • Analyzed Legacy system for data & relations and new system for the data model.
  • Migrated 5 branches for ING Vysya for 5 portfolios (Home Loan, Auto Loan, Commercial Vehicle, Two-wheeler & Personal Loan).
  • Created Pre & Post migration scripts to perform the records/claims tally and other reports for management.
  • Designed Migration strategy, supported UAT testing & provided postproduction support.

Cummins, India
07.2003 - 07.2004
  • Costing Information System – Designed Tables, created procedures & oracle Forms that were integrated with Oracle apps Finance module.

Education

Master of Science - Computer Science

Bachelor of Computer Science - undefined

Skills

  • Effective team leadership

  • Proficient in Oracle PL/SQL

  • Database query optimization

  • Bulk Operations

  • Concurrency management in PL/SQL

  • Data integration development

  • Tableau data visualization

  • Database query optimization

  • Master data management

  • JSON/XML

  • SQL programming

  • Python

  • NumPy

  • Pandas

  • SqlAlChemy

  • Data migration

  • Database design

  • AWS Glue

  • Kubernetes

  • Performance testing with JMeter

  • Shell Scripting

Database performance tuning

Data migration strategies

Certification

OCP – Application Developer, Oracle 9i, Oracle Forms & Reports

Timeline

Sr. Database Developer

Astor & Sanders
08.2022 - Current

Sr. Database Developer

JP Morgan Chase
06.2013 - 05.2015

Sr. Database Developer

Bank of America
03.2011 - 02.2013

Database Developer

Morgan Stanley/Saxon
08.2010 - 12.2010

Sr. Database Developer

Synechron
03.2010 - 08.2022

EDS
07.2005 - 03.2010

Indus Software
07.2004 - 07.2005

Cummins, India
07.2003 - 07.2004

Bachelor of Computer Science - undefined

Master of Science - Computer Science

Similar Profiles

CREATE PROFILE
SUMEET SHROTRIData Engineer