Ankit Srivastava
Gurgaon
Summary
Results-driven data engineer with extensive experience at Axtria - Ingenious Insights, specializing in SQL pipeline design and automation. Proven ability to enhance data processing efficiency and accuracy, leveraging advanced Excel macros and collaborative problem-solving skills. Adept at creating scalable ETL workflows and insightful dashboards to drive sales performance.
Overview
6
6
years of professional experience
Work History
Senior Associate
Axtria - Ingenious Insights
Gurgaon
04.2022 - Current
Designed and maintained SQL pipelines for processing pharmaceutical sales data.
- Automated data transformation tasks with Excel macros, cutting manual efforts by 50%.
- Managed comprehensive data processing for Gulf and Vietnam, ensuring accuracy and timeliness.
- Collaborated with cross-functional teams to implement scalable solutions on SalesIQ platform.
- Optimized SQL queries for large datasets, enhancing performance by up to 40%.
Associate Data Engineer
TCS
Bangalore
05.2019 - 04.2022
- Developed and maintained ETL workflows for reporting systems utilizing SQL and Excel macros.
- Migrated legacy Excel reports to SQL pipelines and Tableau dashboards, enhancing accessibility.
- Established data validation layers to ensure integrity of client-facing dashboards.
- Collaborated with BI team and clients to create comprehensive solutions for sales performance monitoring.
Education
B.Tech - Computer Science
University of Petroleum And Energy Studies
Dehradun05-2019
Skills
- Languages/Tools: SQL (Advanced), Python (Basics), Excel (Advanced Macros), Tableau, Power BI
- Data Engineering: Data Pipelines, ETL/ELT Workflows, Data Cleaning, Excel-to-SQL Automation
- Databases: MySQL, Oracle, Snowflake (Beginner)
- Other: Data Modeling, Dashboarding, Data Analysis
Timeline
Senior Associate
Axtria - Ingenious Insights
04.2022 - Current
Associate Data Engineer
TCS
05.2019 - 04.2022
B.Tech - Computer Science
University of Petroleum And Energy Studies
Similar Profiles
Yashasvini DhakadeYashasvini Dhakade
Associate at Axtria – Ingenious InsightsAssociate at Axtria – Ingenious Insights
Nalin AroraNalin Arora
Data Associate at Axtria - Ingenious InsightsData Associate at Axtria - Ingenious Insights
Sarvesh Kumar PandeySarvesh Kumar Pandey
Senior Associate at Axtria Ingenious InsightsSenior Associate at Axtria Ingenious Insights
Ashutosh SrivastavaAshutosh Srivastava
Senior Associate at Axtria - Ingenious InsightsSenior Associate at Axtria - Ingenious Insights
Sanjivani PurwarSanjivani Purwar
Tutor at TeachingTutor at Teaching