Amit Rastogi Email & Phone Number

Gurugram, Haryana, India

• Utilizing Excel and SQL to manage and analyze purchase and sales data, ensuring efficient and cost-effective procurement processes.
• Develop and maintain Power Bi Dashboard with utilizing DAX query, measures and calculated columns if required to monitor and enhance cost effectiveness in project.
• Calculate PAT (Profit After Tax) and EBIDTA (Earnings before Interest, Taxes, Depreciation and Amortization) on a monthly basis to provide accurate financial insights.
• Submit detailed… Show more
• Submit detailed reports to management, utilizing normalization of data, ensuring data accuracy by removing ambiguity and null values during the data cleaning process using SQL and other tools.
• Conducted in-depth inventory analysis, utilizing advanced Excel techniques, which resulted in a notable 12% revenue growth by optimizing stock levels and minimizing overstock.

Delhi, India

• Strategized and analyzed market trends for over 50 diverse brands, successfully leading to a substantial increase in GMV by 35 CR through targeted initiatives and data insights.
• Effectively reduced product return rates by 23% for key brands like “HILLSON FOOTWEAR PRIVATE LIMITED” and “DHARAM OVERSEAS”, by identifying and addressing major factors contributing to returns through detailed data.
• Developed and implemented sophisticated customer segmentation strategies using SQL… Show more
• Developed and implemented sophisticated customer segmentation strategies using SQL & Excel, markedly accelerating stock clearance rates and enhancing sales efficiency for brands including “BSA ENTERPRISES” and “SKYBER.
• Performed optimal TD discount analysis for both regular (BAU) and event days, significantly enhancing inventory liquidation across various brands, leading to a 27% increase in overall inventory movement.
• Enhanced the effectiveness and reach of various political and product ad campaigns, leveraging SQL and Excel for data analysis, directly leading to a significant 9% boost in campaign ROI and revenue growth.

Noida, Uttar Pradesh, India

• Conducted data-driven supplier performance evaluations using advanced data analysis techniques, using MS-Excel and MySQL.
• Developed comprehensive procurement plans rooted in data analysis to optimize sourcing processes and maintain ideal inventory levels.
• Tracked and analyzed Purchase Order (PO) preparation, material arrivals, and vendor payments using data-driven approaches.
• Analyzed, reviewed, and revised procurement programs to increase operating efficiency by up to 30%… Show more
• Analyzed, reviewed, and revised procurement programs to increase operating efficiency by up to 30%, significantly enhancing procurement process.
• Employed Advanced Excel functions (VLOOKUP, Pivot Tables) for in-depth data analysis and report creation,reducing manual work by 2 hours and increasing workflow efficiency. Show less

Udupi, Karnataka, India

• Conducted preventive and breakdown maintenance of plant equipment.Optimized power consumption through daily monitoring and maintained accurate maintenance records.Managed P2P procurement of electrical consumables and.
• Achieved Cost savings of 7% and 13% for purchase in Minimum Stock & Consumable items.
• Achieved Cost… Show more Conducted preventive and breakdown maintenance of plant equipment.Optimized power consumption through daily monitoring and maintained accurate maintenance records.Managed P2P procurement of.
• Achieved Cost Saving by suggesting equivalent & alternative brands.
• Increased the PO conversion rate from 27% to 62% in less than 6 months.
• Increased the Gross Margin from 4.5% to 13% within a year. Show less

Khatima, (U.K.)

- Managed procurement of materials for projects and general maintenance.- Successfully sourced a wide range of electrical equipment and critical mechanical equipment.- Conducted evaluations of potential suppliers and maintained meticulous procurement documentation.