Summary
Overview
Work History
Education
Skills
Accomplishments
Languages
Technical Skills
Projects & Achievements
Timeline
Generic

Ashish Gupta

Delhi,Delhi

Summary

Results-driven Data Engineer with EXL Service, specializing in ETL development and data modeling. Enhanced data visibility by 30% through automated reporting and optimized SQL queries. Proven analytical problem solver with a keen attention to detail, delivering impactful dashboards that support strategic decision-making and foster collaboration across teams.


Or


Results-focused data professional equipped for impactful contributions. Expertise in designing, building, and optimizing complex data pipelines and ETL processes. Strong in SQL, Python, and cloud platforms, ensuring seamless data integration and robust data solutions. Known for excelling in collaborative environments, adapting swiftly to evolving needs, and driving team success.


Or


Results-driven Data Engineer / Data Analyst with 7+ years of experience at EXL Services, specializing in data analysis, reporting, and automation using Microsoft Excel. Proficient in data modeling, ETL processes, and business intelligence solutions to drive data-driven decision-making. Strong expertise in Excel functions (VLOOKUP, PivotTables, Power Query), SQL, and data visualization. Adept at collaborating with cross-functional teams to deliver high-impact analytics solutions for clients.

Overview

7
7
years of professional experience

Work History

Data Engineer

EXL Service
08.2018 - Current
  • Developed and maintained Excel-based dashboards & reports for clients, improving data visibility by 30%.
  • Automated monthly financial reports using Excel VBA, reducing manual effort by 50%.
  • Performed data cleaning & transformation using Power Query to ensure high-quality datasets for analysis.
  • Created complex Excel models for forecasting and trend analysis, supporting client decision-making.
  • Collaborated with stakeholders to gather requirements and deliver data-driven insights.
  • Optimized SQL queries for data extraction and integrated results into Excel for further analysis.
  • Trained junior analysts on advanced Excel techniques and best practices in data handling.
  • Assisted in designing data pipelines to support data extraction and transformation.
  • Supported database management tasks using SQL for data retrieval and analysis.
  • Collaborated with teams to gather requirements for data integration projects.
  • Learned best practices in data modeling and storage solutions for efficiency.
  • Participated in troubleshooting data issues to enhance system reliability.
  • Engaged in training sessions on big data technologies and tools like Hadoop or Spark.
  • Contributed to the development of dashboards for visualizing key performance indicators (KPIs).
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • .Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
  • Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
  • Streamlined complex workflows by breaking them down into manageable components for easier implementation and maintenance.
  • Designed data models for complex analysis needs.
  • Increased efficiency of data-driven decision making by creating user-friendly dashboards that enable quick access to key metrics.
  • Provided technical guidance and mentorship to junior team members, fostering a collaborative learning environment within the organization.

Education

Master of Computer Applications - Computer Science

National Institute of Technology
Karnataka, India
06-2018

Skills

  • ETL development
  • Data warehousing
  • Data modeling
  • Data pipeline design
  • Excel functions
  • Data analysis
  • SQL
  • SQL databases
  • Data cleaning
  • Analytical problem solving
  • Attention to detail
  • Data validation
  • Database management
  • Database programming and SQL
  • Database maintenance
  • Data mapping
  • Data mining
  • Data exports
  • Data formatting
  • Business needs analysis
  • Data integrity validation
  • Trend analysis
  • Predictive analytics
  • Data screening

Accomplishments

  • Automated Client Reporting System: Reduced report generation time from 8 hours to 2 hours using Excel VBA.
  • Data Migration Project: Successfully migrated 10+ legacy reports to Power Query-based solutions.
  • EXL Excellence Award: Recognized for outstanding performance in data analytics delivery (if applicable).
  • Documented and resolved [Issue] which led to [Results].
  • Supervised team of [Number] staff members.
  • Used Microsoft Excel to develop inventory tracking spreadsheets.

Languages

Hindi

Technical Skills

✔ Data Analysis: Excel (Advanced), Power Pivot, Power Query, DAX
✔ Data Engineering: ETL Processes, Data Cleaning, SQL (Intermediate)
✔ Reporting & Visualization: Excel Dashboards, Conditional Formatting, Charts
✔ Automation: Excel Macros (VBA), Data Validation, Formulas
✔ Tools: Microsoft Office Suite, SQL Server, Power BI (Basic)
✔ Domain Knowledge: Banking, Finance, Healthcare (as per EXL projects)

Projects & Achievements

  • Automated Client Reporting System: Reduced report generation time from 8 hours to 2 hours using Excel VBA.
  • Data Migration Project: Successfully migrated 10+ legacy reports to Power Query-based solutions.
  • EXL Excellence Award: Recognized for outstanding performance in data analytics delivery (if applicable).

Timeline

Data Engineer

EXL Service
08.2018 - Current

Master of Computer Applications - Computer Science

National Institute of Technology

Similar Profiles

CREATE PROFILE
Ashish Gupta