Rahul Prajapati

o Open Box & Clearance Pricing in Retail

o Implemented dynamic Tableau dashboard to track the historical Revenue, Discount erosion, Store & In-Transit inventory KPI for electronics retailer across the US market, Identified the AT Risk Inventory & formulated the inter-store inventory movement plan to save the margins.

o Implemented the Discount Forecasting model for SKUs on Promo for open box items and revised the minimum & maximum discount for SKUs at Department & brand level, Recommended reduction in discount for daily Pricing of SKU for Ecommerce & retail channel using analytical model for SKUs available.

o Implemented Density Based Clustering Algorithm to cluster the retail store to recommend the discount to improve the margins and able to save approximately $ 13.4 million.

o Implemented Dynamic Tableau dashboard to track the tentative delivery dates of ecommerce channel SKUs for the client and its competitor across the US at department level, Strategized the action planfor faster delivery of SKUs in the lagging region.

o Lead the weekly status call with client to understand the problem statement and propose the business solutions.

o Recognized for the automating different reports using R and SQL to monitor the Product lifecycle state, category sales report resulted in ~250 hours of manual effort annually.

o Collected requirements from the client, Analyzed, Strategizedand Presented Release plan of same to client

o Developed and enhanced client specified requirement for various applications and delivered in stringent timeline

o Gathered data from various data source, cleaned data and generated report on daily, weekly & monthly basis to track the performance of the instruments

o Administeredand Managed deployment of quarterly requirements in Production to ensure Go Live with NO Defect Achieved 40% reduction in Testing and Deployment effort of team in pre-production environment by using automation tool

• Performed root cause analysis to provide resolutions for production issues.
• Mentored junior engineers in advanced concepts, fostering professional development within the team.
• Conducted thorough audits of system architecture, identifying areas for improvement and implementing corrective actions.

Provided 1st Level network support, monitoring, fault management and raised incident for Sprint USA & MBNL UK