loader
Summary
Overview
Work History
Education
Skills
Accomplishments
Software
Languages
Certification
Interests
Timeline
SOMYA SAXENA

SOMYA SAXENA

MBA | Supply Chain & Operations
Ghaziabad
Summary

Agile and adaptable Manager with stellar procurement and planning history, motivational approach and upbeat nature. Skilled at training employees and leveraging organized approaches to handle daily planning, scheduling, data analysis and reporting requirements. Forward-thinking and industrious with diplomatic communication style focused on maximizing engagement and satisfaction.

Overview
2
2
Languages
2
2
Certifications
6
6
years of post-secondary education
2
2
years of professional experience
Work History

Management Intern | Procurement Analytics

Amway India Enterprises Pvt. Ltd.
2020-04 - 2020-06

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

Junior Manager | Production Planning & Control

JSW Steel Ltd.
2014-08 - 2016-04
  • 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
Education

MBA Supply Chain & Operations

National Institute Of Industrial Engineering NITIE
2019-06 - 2021-05

BTech Mechanical Engineering

Dr B R Ambedkar National Institute Of Technology
2010-07 - 2014-07
Skills

Data Analytics & Reporting

Teamwork

Detail-oriented

Effective communicator

Leadership

Creative and Innovative

Risk Assessment

Accomplishments
  • Used Microsoft Excel and VBA to develop BOM Creation Tool which slashed the quote generation time per order to 15 Minutes instead of an average of 2 days as before
  • Graduate Aptitude Test In Engineering (GATE), 2019 - 99.82 Percentile (Mechanical Engg)
Software

Microsoft Excel/VBA

Microsoft Powerpoint

Tableau

Python

Languages

English

Hindi

Certification

MS Excel & VBA

2020-03

Statistics for Data Science and Business Analysis

2020-02
Interests

Web Design

Dancing

App Development

Digital Art

Timeline

Management Intern | Procurement Analytics

Amway India Enterprises Pvt. Ltd.
2020-04 - 2020-06

MS Excel & VBA

2020-03

Statistics for Data Science and Business Analysis

2020-02

MBA Supply Chain & Operations

National Institute Of Industrial Engineering NITIE
2019-06 - 2021-05

Junior Manager | Production Planning & Control

JSW Steel Ltd.
2014-08 - 2016-04

BTech Mechanical Engineering

Dr B R Ambedkar National Institute Of Technology
2010-07 - 2014-07