ANKIT KUMAR
+919508663490 ● India ● ankitathghara2393@gmail.com
SUMMARY
Skilled ETL Production Support Engineer with experience in ensuring data integrity, optimization, and seamless
operations. Proficient in MS SQL and ETL Debugging, monitoring/scheduling SQL agent jobs.
PROFESSIONAL EXPERIENCE
WIPRO LTD Bangalore
Project Engineer – ETL Support Engineer June 2021 - Current
● Provided effective production support as an integral member of the Production support team, utilizing ServiceNow
for incident tracking, problem resolution, and change management following ITIL practices
● Monitored and managed ETL jobs scheduled through SQL Agent, leveraging SSIS for seamless data extraction,
transformation, and loading processes.
● Managed and executed daily, weekly, and monthly ETL tasks, enhancing data integrity and efficiency while
decreasing processing durations.
● Resolved job failures by debugging SSIS packages to find out the root cause behind the failure.
● Documented and maintained comprehensive knowledge base articles, providing valuable resources for the team,
and contributing to the overall efficiency of support processes.
● Collaborated with upstream and downstream teams to recover failed jobs caused by incorrect file transfer/ Data
discrepancy before the SLA Breach.
● Proficient in writing MS SQL statements to troubleshoot SQL Agents' job failures.
● Created indexing for tables for SQL query optimization used in multiple store procedures and user-defined
functions using the service now change management process.
● Successfully implemented changes required over the system to fix the problem records.
● Working in close collaboration with the decommission team for delinking databases from various master data load
jobs and feed jobs.
● Extensive experience in Team Foundation Server(TFS) in Visual Studio 2013/19 for doing package-level reports
and database code-level changes.
● Debugged Store procedures, functions, and views to analyze database dependency on different data marts.
● Proficient understanding of Data Warehousing principles including star schema, fact and dim tables.
● Did deployments for both Database and package level changes using Release Management Tool(RLM) for
delinking database and problem record fix.
TECHNICAL TOOLS
● Platforms:- Visual Studio 2013/2019, MS SQL Server 2016, Microsoft failover Cluster Management, Microsoft
Release management tool, Microsoft Excel, Microsoft Word and MS Outlook,
● Version Control:- Team Foundation Server(TFS) with VS 2019.
● ETL tools:- SQL Server Integration Services(SSIS), SQL Server import/export wizard, SSDT.
KEY ACCOMPLISHMENTS
● Awarded with the Brightest Beginner Award in 2022.
● Received Appreciation from clients for problem fixes.
● Received acknowledgement from the Delivery Lead level for supporting multiple teams.
EDUCATION
Kalinga Institute of Industrial Technology, Bhubaneswar — B.Tech
Information Technology, (May 2017 - May 2021)
CGPA - 7.8/10
BNS DAV PUBLIC SCHOOL, Giridih - Higher Secondary
CBSE (PCM), (April. 2015-April 2016)
Percentage - 81/100
BNS DAV PUBLIC SCHOOL, Giridih - Senior Secondary
CGPA - 9.2/10
(April 2013-April 2014)
