Shrinath Bothe
DB Developer
Pune
Summary
Efficient Database Developer with 2.9 yrs of experience showing broad knowledge of high availability SQL Server solutions. Adaptable professional with background in improving workflow processes, creating database objects and overseeing security tasks.
Overview
3
3
years of professional experience
Work History
Consultant Database Developer
Morgan Stanley
12.2022 - Current
- Streamlined data retrieval for end-users by creating and maintaining complex views & nested stored procedures which dumps approx 1million rows of data per day.
- Collaborated in the database designing for renovating legacy systems. Including columnar wise database transformation to row wise DB storage.
- Ensured accurate reporting results with thorough validation of ETL processes, data transformations, aggregations & by writing SQL recon scripts.
- Worked on Autosys to orchestrate ETL jobs.
- Resolved 4 production incidents related to modification & optimization of legacy SPs within established SLAs, thus minimizing the impact on end-user experience and business operations.
Associate Engineer 1
Datametica Solutions
09.2021 - 11.2022
- To understand and analyze the existing logic in Khol’s EDW environment
- Implement the same logic in Big query to fulfill the business needs and improve the performance as per SCD 1/2/3, Truncate Load and Insert only
- Coordinate with BA for requirement gathering
- Migration operations like data cleansing, source to target transformations, data analysis, data purging
- Workflow scheduling, managing, monitoring operations on Airflow
- Creating and Reviewing CTE, views
- Data validation of the migrated data for historical data as well as incremental load
- Responsible for dealing with the problems, bug fixing and troubleshooting
- Providing technical details & documentation as per company standard for unit testing and flow of data (ETL process).
Education
MSC (Computer Science) -
College of Computer Science
Pune, India 04.2001 -
BSC (Computer Science) -
College of Computer Science
Pune, India 04.2001 -
Skills
- Data Migration
- Data Warehousing
- RDBMS
- Performance Tuning
- Data Modeling
- Database Development
- Database Design
- SQL Programming
- Database objects creation
- ETL development
- Query Optimization
- Bigquery
- GCP
Timeline
Consultant Database Developer
Morgan Stanley
12.2022 - Current
Associate Engineer 1
Datametica Solutions
09.2021 - 11.2022
MSC (Computer Science) -
College of Computer Science
04.2001 -
BSC (Computer Science) -
College of Computer Science
04.2001 -
Similar Profiles
Jonathan WalkerJonathan Walker
Beneficiary Service Representative at Morgan StanleyBeneficiary Service Representative at Morgan Stanley
Raunak MotiwaleRaunak Motiwale
Associate, Syndicate Operations at Morgan StanleyAssociate, Syndicate Operations at Morgan Stanley
Stevland PoliteStevland Polite
Vice President Institutional Securities Technology at Morgan StanleyVice President Institutional Securities Technology at Morgan Stanley
Deji OnitiriDeji Onitiri
Registered Client Service Associate at Morgan StanleyRegistered Client Service Associate at Morgan Stanley
Pratik ChaflePratik Chafle
Data Engineer Manager at SaksoftData Engineer Manager at Saksoft