Amit Bhargava

• Led the development of Python-based applications for Apple's Global Allocation system, improving supply chain efficiency.
• Designed and implemented data ingestion and integration pipelines using Python and PL/SQL.
• Collaborated with cross-functional teams to optimize the allocation and production planning process, reducing time spent on manual data handling by 30%.
• Spearheaded the creation of UAT processes, enhancing test accuracy and reducing errors by 20%.

• Designed and developed complex Python/ PySpark ETL pipelines, modernizing legacy systems and integrating advanced analytics for financial reporting.
• Reduced system latency by 20% through optimization of SQL queries and implementing performance tuning strategies.
• Migrated large datasets to a cloud data lake, improving reporting accuracy and efficiency across the finance and treasury departments.

• Coordinated a cross-regional team to develop and optimize ETL processes for risk management, reducing processing time by 25%.
• Successfully migrated historical data warehouse systems to Oracle 11g, ensuring seamless data access for business users.

• Developed and optimized materialized views, improving data accessibility for British Telecom’s internal systems. - Led the cross-LOB functionality development, impacting seven interfaces and improving system integration.
• Implemented Bulk Upload functionality in SQL
• Loader, reducing manual job creation time for British Telecom’s LLU Planning group.

Project Brief:
Global Logistics system is a module in ERP named ATLAS.

Responsibilities:
Added new concept of generating RFQ at creation of Performa in Global Logistics System Module.
 Added a new functionality for importing source order in GLS from procurement module.

• Implemented customized ERP modules, enhancing the finance, sales, and inventory management systems for clients. Developed and integrated complex features like multi-currency support and inter-branch transaction systems.
• Led database design and development of Oracle-based applications, improving financial and inventory tracking systems.