Ankush Arora

Experience

• 

  Capgemini

  Jan 2017 - Jan 2020

  Data Engineer

  Bayer AG (Business Intelligence & Data Integration Solution):• Led a team of 5 data engineers in designing and implementing a robust data integration and businessintelligence solution, optimizing pharmaceutical sales reporting and operational processes, while ensuring adherence to project timelines and quality standards.• Developed high-performance ETL pipelines using IBM DataStage, Talend, MySQL, and Oracle, increasing data processing speed by 30%.• Managed CI/CD pipelines, ensuring the smooth deployment of updates, and provided ongoing technical support to enhance system scalability and reliability.• Utilized JIRA for issue tracking, sprint planning, and collaboration, ensuring effective project management and timely delivery of solutions.Vertiv (Enterprise Datawarehouse Solution):• Designed and implemented a comprehensive data warehouse solution that integrated and consolidated data from multiple sources to support enterprise-level business intelligence.• Applied advanced SQL queries to optimize ETL workflows, resulting in a 20% reduction in report generation time and improved data accessibility for stakeholders.• Developed and maintained interactive dashboards in Tableau, enabling more efficient analysis of business performance and key metrics.Daimler Overseas (Data Integration and Reporting Solution for German Market):• Managed data integration and reporting systems, specifically focused on the German market, ensuring data accuracy and consistency across multiple sources.• Led the design and optimization of ETL processes to consolidate sales, operational, and financial data,enabling better decision-making for Daimler’s overseas operations.• Developed interactive dashboards, providing real-time insights into market performance, sales trends, and operational efficiency for the German market. Show less