Akshay Pande

• Steered enhancement and management of an Airflow DAG pipeline dedicated to measuring ROI incrementality as part of performance marketing team.
  
• Developed a pivotal Databricks tool that empowered marketing managers to oversee steering types more effectively, elevating clarity of marketing performance reports.

• Architected and implemented dimensional models, advanced batch processing algorithms, and ADF pipelines within Azure, leveraging parquet sources and CI/CD infrastructure. This innovation powered a supply chain analytics product, enhancing visibility into stock disruptions, contributing over US $1.2 million in value, and securing a place among the top 1% of Shell's most-viewed reports
  
• Conceptualized and defined an AI use-case, delivering critical data to AI teams focused on optimizing inventory replenishment through Reinforcement Learning for Lubricants Supply Chain.
  
• Led on-boarding for the product team, interviewing and mentoring 20+ new data engineers. Additionally, played pivotal role in establishing comprehensive on-boarding documentation and protocols.

• Developed end-to-end business logic and data layer for a global B2B Lubes profitability app within Shell's Lubes Supply Chain. This solution offered granular insights into COGS and delivery costs and resulted in time savings of 7000+ hours annually, yielding over US $15 million in value.
  
• Orchestrated data scheduling and integration using Azure Data Factory and Databricks, successfully ingesting two years' worth of real-time inventory and forecasting data from third-party systems, generating value of over US $19 million.
  Seamlessly consolidated and blended data from over 50 SAP sources using Alteryx, enhancing accuracy of monthly financial reports encompassing 10 million+ records.
  
• Implemented a re-networking opportunity screen to suggest optimal routes for excess supply chain stock. Moreover, designed Python algorithms to identify unit conversion discrepancies within the product portfolio, automatically updating logs to SharePoint.
  
• Crafted SQL procedures to identify supply plant routes and compute unit logistics costs and tariffs, catering to 300+ plants and over 10,000 products sourced from high-volume transactional databases.
  
• Led intricate ETL solution migration from SAP HANA to Azure, specifically targeting the North American iteration.

• Modeled, tested, and refined reporting dashboards using Web Intelligence, further enhancing data warehousing capabilities through creation of calculation views in SAP HANA.
  
• Delved deep into legacy SAP (ABAP) transactions, documenting their underlying logic. This initiative enhanced visibility into stock and pack/bulk shipments within Trading and Supply, contributing added value of over US $1.5 million.
  
• Championed knowledge-sharing by conducting insightful sessions on topics such as DevOps, as well as fostering a more inclusive environment through Autism & Disability Awareness seminars.

Major Energy client

• Successfully executed over 20 change requests spanning diverse functional areas, including asset manufacturing, procurement, and materials management. As ABAP programmer and SAP BW developer, these contributions were instrumental for a global SAP implementation.
  
• Crafted specialized interface in ABAP, enabling generation of XML invoices directly from a transactional SAP BW cube. This innovation addressed a critical legal and fiscal requirement.