Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Hi, I’m

Ankita Upadhyay

Bangalore
Ankita Upadhyay

Summary

Accomplished Senior Data Engineer with over 12 years of experience at Dell International Services and Infosys Ltd. Proficient in Python, SQL/NoSQL, and cloud platforms like Microsoft Azure, I have significantly enhanced data processing efficiency and system reliability. My expertise in automating workflows and optimizing data pipelines has driven impactful data-driven decisions. Renowned for exceptional cross-functional collaboration and mentoring, I have fostered a culture of continuous learning and achieved a 98% on-time delivery rate. My ability to translate complex data into actionable insights using Tableau/Power BI has significantly improved stakeholder engagement and team capabilities.

Overview

13
years of professional experience
1
Certification

Work History

Dell International Services

Senior Data Engineer
03.2017 - Current

Job overview

Technical Skills:

  • Programming: Proficient in languages like Python and SQL for developing data pipelines and ETL processes. Skilled in developing low-code applications for data entry, reporting, and dashboard creation using Oracle APEX. Automated data workflows, reducing manual intervention by 40%.
  • Database Warehouse Management: Expertise in SQL and NoSQL databases, such as MySQL, PostgreSQL, CosmosDB, Elastic Search, and Cassandra. Improved query performance by 30%.
  • Big Data Technologies: Experience with Hadoop, Spark, Hive, and Kafka for handling large-scale data processing. Managed data volumes exceeding 10TB.
  • Cloud Platforms: Skilled in using cloud services like AWS, Azure, and Google Cloud for data storage and processing. Migrated on-premises data to cloud, reducing costs by 20%.
  • Data Visualization: Skilled in using tools like Tableau, Power BI, and Matplotlib for creating insightful visualizations. Developed dashboards that increased stakeholder engagement significantly.

Project Experience:

  • Data Pipeline Development: Designed and implemented data pipelines that improved data processing efficiency by 30%. Reduced data latency by 50%.
  • Data Cleaning and Preparation: Cleaned and transformed raw data, reducing data processing errors & enhancing data quality, leading to more accurate analytics.
  • Performance Optimization: Optimized database queries and ETL processes, reducing data retrieval times . Achieved a 99.9% uptime for critical data services.
  • Insight Generation: Analyzed complex datasets to generate actionable insights, leading to a 25% increase in data-driven decision-making. Identified key trends that informed strategic business decisions.

Collaboration:

  • Stakeholder Communication: Presented data insights to non-technical stakeholders, improving understanding and engagement by 20%. Conducted workshops to enhance data literacy.
  • Cross-functional Teams: Worked closely with data scientists, analysts, and business stakeholders to understand data requirements and deliver solutions. Facilitated cross-departmental projects that improved data integration.
  • Mentorship: Provided training and knowledge transfer to junior engineers, reducing onboarding time by 30%. Mentored team members, fostering a culture of continuous learning.

Infosys Ltd.

Functional Test Analyst
02.2012 - 03.2017

Job overview

Testing Delivery Management: Owned and managed all testing deliveries across streams, ensuring the highest quality and adherence to release cadence. Achieved a 98% on-time delivery rate.

Automated Testing: Conducted automated testing to ensure the performance and stability of large multi-tier applications, resulting in a 20% reduction in manual testing efforts.

ETL Data Verification: Verified data in target databases after ETL processes using XML and file-to-DB validation, improving data accuracy by 10%.

Performance and Reliability Testing: Drove business-critical testing efforts to ensure performance, reliability, and scalability, reducing system downtime by 15%.

Informatica Monitoring: Monitored Informatica jobs using PowerCenter Workflow Monitor, ensuring a 95% job success rate.

System Test Leadership: Led system test efforts and test planning for each release, increasing test coverage by 25%.

Data Analytics Leadership: Led data analytics initiatives, providing insights that improved project outcomes.

Knowledge Transfer: Responsible for domain knowledge transfer to new joiners, reducing onboarding time by 30%.

Performance Testing: Developed user behaviour models for performance tests, analysed results, diagnosed bottlenecks, and collaborated with engineers to identify solutions, enhancing system performance by 15%.

Manual Testing: Prepared and executed manual test scenarios and test cases using Python, Shell Scripting, and VBScript, achieving a 95% defect detection rate.

SQL Query Preparation: Prepared SQL queries for source and target systems, optimizing data retrieval by 20%.

Defect Management: Reported defects and verified fixed defects and issue resolutions, improving overall software quality by 15%.

Education

Biju Patnaik University of Technology
Raurkela, India

Bachelor of Technology from Information Technology

University Overview

  • Graduation with Distinction
  • 9.1 GPA/CGPA

Skills

  • Python
  • SQL and NoSQL databases, such as MySQL, PostgreSQL, CosmosDB
  • Hadoop, Spark, Hive, and Kafka
  • Tableau and Power BI
  • Microsoft Azure
  • BigQuery and Snowflake
  • Elastic Search
  • Test Automation
  • UNIX

Certification

ISTQB Certification

Microsoft HTML5 with javascript and CSS3 70-480

Languages

English
Bilingual or Proficient (C2)
Hindi
Bilingual or Proficient (C2)

Timeline

Senior Data Engineer

Dell International Services
03.2017 - Current

Functional Test Analyst

Infosys Ltd.
02.2012 - 03.2017

Biju Patnaik University of Technology

Bachelor of Technology from Information Technology
Ankita Upadhyay