Gaurav Agrawal
Senior Data Engineer
Bangalore
Summary
Dedicated professional with 7 years of diverse experience in developing ETL pipelines, data modeling, and reporting, managing databases and addressing queries from internal and external customers. Proven track record of translating concepts into actionable strategies, driving successful project execution. Seeking opportunities in software enhancement, business intelligence, and team management to leverage expertise in creating data-driven solutions and delivering measurable business outcomes.
Overview
7
7
years of professional experience
4
4
years of post-secondary education
2
2
Certifications
2
2
Languages
Work History
Senior Data Engineer
LTIMindtree Pvt Ltd
Bangaluru
06.2022 - Current
- Contributing to a leading bank in the USA, consistently implement ETL solutions to meet project requirements using SSIS and Azure Data Factory.
- Majorly contributed on Performance optimization of SSIS jobs and SQL Queries.
- Led a high-performing team in executing a seamless data center migration project during the merger of the client organization, ensuring a successful integration and smooth data transition
- Automated 50+ reporting processes by effectively managing, updating, and customizing reports to meet customer requirements and saved $6000 for clients.
- Leveraged SQL, VLOOKUPs, and pivot tables to streamline reporting tasks and enhance data-driven decision-making
- Implemented complex KPIs to ensure the business met customer expectations efficiently
- Developed data processing pipelines to ensure clean data integration between source and destination systems
- Ensured data quality through rigorous testing, validation, and monitoring of all data assets, minimizing inaccuracies and inconsistencies.
IT Analyst
Tata Consultancy Services
Chennai
04.2021 - 05.2022
- Developed highly complex SSIS packages and SQL stored procedures and function and deployed and monitored Daily jobs configured on SQL servers
- Led the data migration project, facilitating the transfer of clean data from legacy systems to cloud systems and delivered project before the deadline.
- Created data mapping and ensured data validation and provided support to address any discrepancies during the migration process
- Analyzed and resolved all application-related production issues
- Provided escalation support and maintenance for the client application environment
- Tools and technologies used: SSMS, SQL, Excel, ServiceNow, PagerDuty
- Resolved customer queries promptly using a client ticket tracking system and saved 500+ hours.
- Monitored project activities and prepared status reports for clients
- Collaborated with cross-functional teams to gather requirements, design data integration solutions, and implement best practices for SSIS development
System Engineer
Tata Consultancy Services
Chennai
04.2018 - 03.2021
- Developed and maintained complex SSIS packages to streamline data extraction, transformation, and loading processes
- Ensured seamless integration and data flow between various systems, which enhanced reporting and business intelligence capabilities
- Handled production support tickets efficiently, resolving issues related to data processing and system performance
- Provided timely solutions to minimize downtime and ensure uninterrupted data operations, maintaining high levels of customer satisfaction
- Managed account-level activities, including coordinating with clients and stakeholders to address their needs and requirements
- Oversaw various account-related tasks to ensure smooth operations and support the overall success of client engagements
- Provided production support by monitoring system performance, troubleshooting issues, and implementing proactive measures to prevent downtime, resulting in a 25% reduction in incidents
Education
B.E. - Computer Science & Engineering
ACTS-RGPV
Satna 06.2013 - 06.2017
Skills
T-SQL
PLSQL
SSIS
Power BI
SSRS
Performance Optimization
Azure Data Factory
AGILE
ETL Development
Certification
Microsoft Azure Data Fundamental DP 900
Awards
- Super Guru award
- Star Award of the Quarter
- Platform Innovator
- Consider it done award
- On Spot Award Thrice
- Service Commitment Award
Timeline
Senior Data Engineer
LTIMindtree Pvt Ltd
06.2022 - Current
IT Analyst
Tata Consultancy Services
04.2021 - 05.2022
System Engineer
Tata Consultancy Services
04.2018 - 03.2021
B.E. - Computer Science & Engineering
ACTS-RGPV
06.2013 - 06.2017