GAURAV AGASHE
Summary
Responsive expert experienced in monitoring database performance, troubleshooting issues and optimizing database environment. Possesses strong analytical skills, excellent problem-solving abilities, and deep understanding of database technologies and systems. Equally confident working independently and collaboratively as needed and utilizing excellent communication skills.
Overview
7
7
years of professional experience
Work History
Data Engineer II
Credit One Bank
02.2023 - Current
- Spearheaded the development and optimization of end-to-end data pipelines, resulting in a 70% reduction in manual efforts for data collection and analysis, while enhancing data quality and integrity
- Engineered and implemented a comprehensive diagnostic dashboard system comprising 40 individual dashboards, empowering the Treasury and Finance department with enhanced data visibility, analytics, and actionable insights
- Led the migration of SSIS data pipelines to Python, leveraging modern technologies to improve agility, scalability, and processing speed by 30%, enhancing operational efficiency
- Implemented robust data quality checks and monitoring mechanisms throughout the ETL lifecycle, ensuring a 95% data accuracy rate and compliance with industry standards and regulations.
Data Engineer Intern
Swire Coca Cola
10.2022 - 12.2022
- Conducted extensive data profiling and cleansing procedures during the migration of pipelines from Azure Data Factory to Azure Synapse, achieving a 25% reduction in data anomalies and ensuring data integrity
- Employed advanced data modeling techniques for efficient data representation and storage in Snowflake cloud data warehouse, resulting in a 20% improvement in data retrieval times and enhancing data accessibility
- Implemented data versioning and lineage tracking methods to ensure auditability, compliance, and transparency in data transformations, achieving a 98% success rate.
Engineer
TATA Consultancy Services (Morgan Stanley)
09.2017 - 08.2021
- Managed and updated a complex backend Autosys plant, performing compatibility reports, migration activities, sanity checks, and decommissioning jobs for 1700+ applications and 1.2 million Autosys jobs, ensuring data continuity and system reliability
- Implemented change data capture (CDC) mechanisms for real-time data updates in cloud-hosted microservices architecture, reducing data latency by 40% and improving data timeliness
- Collaborated cross-functionally to design and implement CI/CD pipelines, ensuring seamless and error-free deployment of data solutions with a 99% success rate
- Developed and maintained comprehensive data dictionaries, documentation, and metadata repositories to facilitate efficient data cataloging, governance, and compliance.
Education
Master of Science in Information Systems -
University of Utah, David Eccles School of Business
Salt Lake City, UT12.2022
Master in Computer Applications - undefined
Govt. College of Engineering
05.2017
Skills
- Spring Boot
- Spring MVC
- Cucumber
- Django
- Junit
- SQL (Structured Query Language)
- Oracle
- MongoDB
- MySQL
- Microsoft SQL Server
- PL/SQL
- T-SQL
- PostgreSQL
- NoSQL
Timeline
Data Engineer II
Credit One Bank
02.2023 - Current
Data Engineer Intern
Swire Coca Cola
10.2022 - 12.2022
Engineer
TATA Consultancy Services (Morgan Stanley)
09.2017 - 08.2021
Master of Science in Information Systems -
University of Utah, David Eccles School of Business
Master in Computer Applications - undefined
Govt. College of Engineering
Similar Profiles
Vinit SrivastavaVinit Srivastava
Tech Lead & Architect at Credit One BankTech Lead & Architect at Credit One Bank
Tiana WrightTiana Wright
Risk Modernization Technology Analyst at Credit One BankRisk Modernization Technology Analyst at Credit One Bank
Joe VelascoJoe Velasco
Back Office (Mail Room, Team Lead) at Credit One BankBack Office (Mail Room, Team Lead) at Credit One Bank