Ankita Upadhyay

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.

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%.

• Graduation with Distinction
• 9.1 GPA/CGPA