Ankit Mehta Email and Phone Number

1. Strategic Analysis and Cost Reduction Impact: Analyzed and provided key insights for an SMS-channel related project at Uber, contributing to significant cost-cutting measures in the INSA region.2. Dashboard Automation and Optimization: Developed and automated multiple finance dashboards, meticulously ensuring data accuracy through rigorous fact-checks, query analysis, and corrections. These dashboards, recognized for their reliability, now serve as the single source of truth for leadership teams across multiple domains, offering crucial insights for daily decision-making.3. Root Cause Analysis and Query Enhancement: Led comprehensive root cause analyses across multiple projects, collaborating closely with cross-functional teams. Identified and addressed issues, resulting in significant improvements and corrections to queries and logics embedded in various dashboards, ensuring data accuracy and enhancing overall project effectiveness.

1. Worked on HR integration system: Automated the process to gather relevant data from various different sources/systems, transforming the data as per business requirements, and sending encrypted data-files to the destination server to get processed.2. Worked on Utility Rebilling process: Retrieved and processed the data for power consumption metrics and billing details from different sources and used billing period to generate invoice files and send error mail to the concerned team, while also automating the entire process.3. Used ODI Designer to design & develop complex interfaces, and procedures to load, process, clean, transform as well as send data to and from various heterogeneous data sources. And then used several features of OBIEE to create meaningful reports as per business requirements4. Project Governance:Established robust communication and stakeholder engagement with internal as well as overseas teams to identify resources, help achieve project milestones and KPIs as well as identify and mitigate project risks quickly. As a key member of the governance team, I was also involved in creating Executive status reports on a weekly, monthly, and quarterly basis5. Performance tuning efforts:Identified and improved ODI (ETL) loads execution time, and was also involved in performance tuning various database objects

1. Played a crucial part in capturing, documenting, and guaranteeing bug-free solutions for a variety of clients2. Produced thorough test cases and scenarios based on the applications being tested for different modules and projects3. Coordinated with cross-functional teams to speed up bug-free delivery and application testing