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 • 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 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.• 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. Show less

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 analysis.• Developed and implemented sophisticated customer segmentation strategies using SQL… Show more • 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 analysis.• 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 INTERNATIONAL”.• 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.• Streamlined and optimized SQL query operations, successfully reducing processing times by over 50%, thus enhancing overall database efficiency and response times for business-critical operations. Show less

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 • 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%, 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 stationery items, ensuring timely delivery and quality standards.Effectively managed vendor payments, invoices, and purchase orders.Achievements:• 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 electrical consumables and stationery items, ensuring timely delivery and quality standards.Effectively managed vendor payments, invoices, and purchase orders.Achievements:• Achieved Cost savings of 7% and 13% for purchase in Minimum Stock & Consumable items. • 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.