Anurag Srivastava

Business Data Design Lead - Analytics, Supply Demand Balancing Project (SDBP)

• Designing analytic framework in Snowflake, Alteryx and Tableau for Supply Demand Balance Project for fuels value chain.
• Data extraction and enhancement with local master data table and SDBP planning data for analytics which reduced the development time with 50% FTE saving.
• Strategized creation of Analytics Roadmap for distribution planning route network for fuel market in Canada, USA and Europe.

Pricing Analytics - ESPOT

Designed and delivered analytic tools utilizing agile methodlogies for fuels spot market for Europe, tool was developed on spot sales data and ARGUS, PLATTS quotes and term contracts with effective revenue increase of 3 M$

• Comparison between Term vs Spot contracts for customer lifting which enabled accurate inventory management in Fuel Terminals
• Created insights which reinforced the Pricing mechanism and contract negotiations

Market Reference Price (MRP) Process Automation

Technical and design consultation for MRP process automation which enabled smooth setup of MRP monthly across all the countries in Europe using Alteryx.

• Provided business users the flexibility to updated ad-hoc MRP vs once a month updates
• Eliminate several hours per months of manual work efforts for refinery product optimizers across all countries in Europe with effective saving of 3 full time employee

General Interest Uplift (GIU)

North America - 2018-2019

Europe, Asia Pacific- 2020- 2022

Sustained and upgraded the GIU tool for North America and EU using SAP HANA and SQL. Tool was key enabler for revenue management portfolio boost across regions

• Optimizing sales channel and insight generation for revenue management teams with yearly revenue increase of 2M$
• Developed tracking actual vs expected sales of Fuels in all regions
• Developed Deal evaluation tool for renegotiating existing customer with new customer
• Proposed and delivered enhancement steps data quality, accuracy

• Assisting Global reporting unit for Customer Service and Downstream with creation of tableau dashboards, following eliminated 0.25 FTE efforts from multiple OTC team with consolidated reporting
• Understanding respective team requirement and developing tableau dashboard keeping their key process indicators in consideration
• To convey data to business impact story with root cause analysis and suggesting preventive actions, this led to invoice error to drop by 25%
• Create Asia Pacific zone operational expenses monthly reports and presenting data to business story to Asia Pacific Customer service manager
• Maintaining hand to hand coordination with Business Analytics Reporting team to have reconciliation of OPEX and tracking monthly expense.
• Actively participated in Planning and Budgeting 2017 for outlook, plan and forecast for Asia Pacific (Fuels, Lubes) for Bangkok, Shanghai and India Lubes.

Sponsor Product

• Responsible for Ad relevancy data modeling with SQL and tableau
• Served as primary accountable for data load, transformation and extraction through SQL and providing data to business story on non-relevancy report

Cost Per Click- Product Ads

• Monitored Ad defect rate for Amazon UK CPC sellers
• Performed defect rate trend analysis using predictive analytics algorithm (linear regression) and suggested business preventive measures and kept Ad Defect Rate (ADR) below 1.5%
• Introduced dynamic reporting in tableau to monitor real-time Ad defect rate
• Continuously assisted Account management team to manage balance between ADR and revenue.