WFM implementation – Created methodology including calculations based on client discussions to understand value realization due to Workforce Management (WFM) implementation across 2,000+ sites for the second-largest food and beverage business in the world. Designed and executed surveys, collected, and analysed data, and created dashboards to monitor and assess the success of WFM program.Key skills: Power BI, Power automate, Advanced Excel, Power PointProcurement cost optimization – Prepared the spend cube, performed As-Is analysis for suppliers, BUs and PMs, and identified ~2% savings across 4 levers – supplier consolidation, price parity, competitive bidding and best cost country sourcing leveraging Alteryx and Power BI. Also created a tracking mechanism for the same with sophisticated VBA model based on regular client discussions. Performed vendor mapping on 10,000+ vendors to identify vendor optimization opportunities.Key skills: Power BI AlteryxInventory Optimization and footprint optimization– Performed seasonality analysis, DIO analysis and ABC XYZ analysis to identify obsolete inventory, and critical SKUs to bring down inventory related costs.For a US based defense manufacturer, identified 4-6% savings per year over a span of 5 years across three levers – site consolidation, sub-leasing and contract negotiation, to optimize EBITDA.Cost Take-Out for a US based Renal Technology Company - Evaluated current portfolio and operating model, reviewed client identified cost and cash savings initiatives and identified incremental initiatives to slow the cash burn-rate. Mentored the team to develop a Cashflow Forecast Model for Value Creation Initiatives and establish a tracking mechanism. Performed Span & Layers analysis, identifying opportunities worth USD 1.1 million and created severance model to show the 1x cost.

National Winner- Vidhan'21, IMI New Delhi, Hesol Consulting, operations case challengeCampus Winner- pwc 3.0, market entry consulting case competition

Managed multiple social media handles coordinated the publishing of NITIE’s quarterly NewsletterSPOC, Placecom and MRC interfaceStrategically categorized placement & corporate related posts

Co-ideated and implemented a central database system by aligning with higher management for 18+ useful KPIs. Created a list of data discrepancy issues to be leveraged for further data entries.Developed and automated an end to end real-time dashboard for the B2B sales funnel from the lead tracking to revenue realization. This reduced man-working hours by 10 per week and improved data consistency from 60% to 95% prioritizing key areas based on Kaizen.Built and automated the financial projection dashboard week-on-week from scratch, enabling strategy stakeholders to make data driven financial decisions more accurately

Created demand plan, altered colored & white base production by 50%, so retailers can have wide variety of colorsCost- revenue analysis for paint, strategized paint procurement over manufacturing with 30L+ projected revenueConducted value stream mapping of warehouse activities to identify VA & NVA, performed ABC classification

Developed DDP website using JavaScript, CSS, HTML and coordinated with Backend development teamPerformed pre-processing data cleaning operation using SQL and developed dashboards using Power BI. Proposed developing a responsive User-Interface for Data Discovery Platform using Bootstrap Technology. Developed Standard Operating Procedure for DDP insights & designed dashboards for clients with FMEA. Coordinated with Cross-Functional teams viz. Frontend, Backend and DBMS teams to develop the websiteMonitored & reviewed daily productivity to resolve inefficiencies using 5-Why technique of Root Cause AnalysisSpearheaded knowledge management practices for capturing SOPs and solution to issues on new platformBuilt Power BI Dashboards with interactive UI for Visualization of KPIs for various international clients

Performed "Numerical analysis of Droplet impact on solid surfaces." by correcting the the available code on Fortran-77. Analyzed the code, charted out the mistakes and corrected them.

Wesmarty Infotech is a sister company of Petroleumsoft, working on the software solutions for oil and natural gas companies. During this internship developing mathematical relations governing fluid flow using concepts of CFD was the work to be focused, to solve them numerically.

NTPC (National Thermal Power Corporation) is an Indian PSU working mainly on thermal power production. Got opportunity to learn the overall working of thermal power plants and got acquainted with the management required in maintaining such large firms.

Technotholon is an international level exam held for students of class 9th-12th. Conducted the exam in more than 5 schools and for nearly 1000 students. The main work included bringing in more participation from schools and organizing the exam at various centres in the city.