SOMYA SAXENA

Project Title:

Supplier Analytics Dashboard - Category, Portfolio, Strategic Sourcing Team, Segmentation & Risk Assessment

Methodology:

• Performed As-Is Analysis of the direct & indirect Procurement Processes for the Global Business Operations
• Analyzed existing techniques & metrices used for Business Intelligence insights for procurement department
• Benchmarked business intelligence tools used across top FMCGs for comparative analysis of current practices
• Liaised with the planning, direct & indirect procurement teams to understand & collate existing pain points
• Identified key areas having Maximum Impact on the Risk Assessment of the procurement supply chain
• Implemented the Extract, Transform, Load (ETL) Process to convert raw data to insightful visualisations

Deliverables:

• Designed Tableau Based Real - Time Comprehensive Dashboard for Risk Assessment of the supply chain
• Provided clean overview of Vital Metrics of Procurement Process Performance across the sub departments
• Delivered informative dashboard for Smooth Virtual Onboarding of incoming employee in the department
• Aided in Analyzing past purchase trends using Price vs Quantity Ordered graph in Price Tracking Module
• Built a complete Drill Down of all supplier information for the buyers – who, what, where, when, how much
• Facilitated Identification of Mono Sourced Items, their suppliers & sources which get impacted during crisis
• Developed intuitive Crisis Indicators to identify the crisis zones around the world on an interactive map
• Designed Mould Health Dashboard to track health of packaging material moulds at supplier locations
  

• Supervised as Shift In-Charge to coordinate with Hot Strip Mill & Steel Melting Shops for Scheduling jobs
• Analyzed total production & performed Gap Analysis of planned vs actual production to increase productivity
• Prepared daily production plans & monitored their implementation to ensure timely delivery to avoid penalties
• Forecasted demand with the marketing department using trend data to cater to valuable customers on priority
• Fostered the use of VBA Tools in MS Excel for Analyzing and Reporting of Key Performance Parameters
• Enhanced the availability of human resource by Automating of Reports & streamlining the communications
• Liaised with various departments to ensure a Smooth Workflow and hence timely delivery to customers
• Diminished the errors and processing time for Data Analysis, Boosting accuracy and precision of the reports
• Conducted Stock Reconciliation drives to verify the total inventory of the steel zone for periodic Auditing
• Facilitated the set-up of Rolling Rules along with HSM and PDQC dept for the newer Silicon Steel Grades
• Initiated the Web-Based Reporting Dashboard project for continuous monitoring & updating of the KPIs
• Implemented Google’s OAuth Protocol for Authentication & authorization by the employees of company
• Coordinated with various sub departments like MIS, HR planning, CR planning for Seamless Data Integration
• Collaborated with the IT wing of JSW, JSoft Solutions, for the Technical and Functional support required
• Enhanced the transparency within the department by increasing the accessibility and reachability to all