Abhishek Dubey

• Utilized predictive analytics to remove redundancies in forecasting models for 25 retail outlets, increasing efficiency and fulfillment rate by 75%.
• Utilized Power BI to build automated reports and dashboards to monitor performance metrics and presented them to senior executives, directors and other stakeholders.
• Initiated CSCM cost savings opportunities around case pick, full pallet ordering and internal network optimizations, which led to a significant reduction of wastage by around 2M within a span of 9 months.
• Analyzed historical data (including transactional, survey, and behavioral) to identify trends and make predictions.
• Created complex stored procedures, triggers, functions, indexes, tables, views, joins and other T-SQL code to implement business rules.
• Introduced a new data collection system which improved database efficiency by 30%.
• Evaluated supplier performance and identified and selected 7 new vendors to enhance operations which resulted in a 38% cost reduction for the sourcing & procurement of raw materials.
• Utilized Power BI for advance analysis actions, calculations, parameters, background images, maps, trend lines, groups, hierarchies, detail level summary report sets, and KPI dashboards.
• Performed data analysis on supplier performance using ERP software and Advanced Microsoft Excel functions to support process improvement initiatives, which prevented shipment delays for enterprise customers.
• Developed and reviewed simultaneous SQL queries with the use of join clauses (inner, left, and right) in Tableau desktop to validate static and dynamic data for data validation.
• Used advanced chart visualizations in Tableau such as dual axis, box plots, bullet graphs, treemaps, bubble charts, and waterfall charts to solve complex problems and to create interactive dashboards and visualizations.
• Created a database and monthly review process that identified $85,000 worth of expired products in 1 year.
• Developed 85% custom Microsoft Power BI dashboards, visualizations, and interfaces with Microsoft SSRS to deliver meaningful and actionable insights..
• Created and managed master data objects ensuring data accuracy and integrity and successful execution in SAP within agreed timelines.
• Utilized advanced Microsoft Excel, VLOOKUP and XLOOKUP functions to efficiently create pivot tables and pivot reporting.

• Facilitated stakeholder engagement by organizing community meetings and gathering feedback on proposed plans, fostering a collaborative decision-making process.
• Conducted root cause analysis on forecast errors, identifying areas for improvement and implementing corrective actions.
• Utilized advanced Excel functions and tools for data manipulation, analysis, and visualization in support of demand planning activities.
• Managed high-impact projects to improve overall supply chain effectiveness and responsiveness.
• Increased automation in reporting processes by designing dynamic dashboards using visualization tools like Tableau or Power BI.
• Enabled real-time monitoring of key performance indicators through the development of interactive dashboards and visualizations using cutting-edge tools like Tableau or Power BI.
• Reduced manual errors in purchase orders by automating data entry with SAP MM integration.
• Ensured timely delivery of materials by monitoring stock levels and collaborating with suppliers to expedite shipments when necessary using SAP MM tools.

.

• Anticipated and identified business issues (including performance gaps, opportunities, and emerging needs) for management and developed appropriate action plans to maximize business profitability.
• Reduced monthly forecast variance from 20% to 4% by thoroughly examining past expenses and collaborating with the budget owners to ensure the most up to date information was incorporated in the forecast..
• Utilized SAP to gather, export and sort data for Excel and used the information to create over different reports.
• Improved system performance by optimizing SAP MM configurations and settings.
• Demonstrated flexibility in accommodating last-minute schedule changes or additional interpreting requests as needed to support student success.