VARUN RAO

Supply Chain Sell In Project

• Led the end-to-end implementation of a sell-in projection framework in the supply chain, resulting in a 15% improvement in forecast accuracy and optimized inventory planning across key markets.
• Collaborated with cross-functional teams, including sales, marketing, and product, to integrate promotional calendars and market trends into sell-in forecasts, ensuring alignment with business objectives.
• Optimized the sell-in projection workflow by introducing automation, reducing manual intervention by 30% and improving forecast turnaround time.
• Improved forecast granularity, enabling SKU-level visibility for better inventory control and reduced stockouts.
• Implemented a feedback loop to continuously refine the sell-in projection model based on historical data and evolving market dynamics.
• Developed custom SQL scripts to automate data extraction and transformation for sell-in forecasting, saving 30+ hours per month in manual effort.
• Resolved data inconsistencies across systems through a structured data validation framework, ensuring accurate sell-in forecasts.
• Tracked and analyzed promotional impact on sell-in performance, providing actionable insights for future campaigns.

Supply Chain Procurement Project

• Led the Procurement Team to develop and implement cost savings, operation improvements, strategic sourcing, and new revenue opportunities through the incorporation of technology and by leveraging a cognitive automation tool called AERA (using SQL to deliver high-quality supply chain solutions to FMCG giants
• Spearheaded the design and implementation of an invoicing system which helped in automated feedback mechanism thereby reducing the costs and time
• Headed the team in the successful integration of a new source system from scratch blended into an existing architecture to reduce the action time by more than 60% thereby resulting in faster invoicing transactions of goods
• Coordinated with cross-functional teams to identify areas of improvements and drive automation plan and to integrate new systems with existing ERP solutions, ensuring seamless data flow and method continuity
• Utilized Agile project management methodologies to deliver project milestones on time and within budget
• Conducted data analysis to identify bottlenecks and areas for improvement, providing actionable insights to senior management
• Designed and implemented a dashboard in Power BI for real-time monitoring of invoicing status and key performance indicators (KPIs) and worked effectively to integrate the product system and PBI architecture through Azure Databricks
• Automated KPI reporting using SQL scripts and ETL processes, reducing manual reporting time by 60% and improving data accuracy
• Monitored system performance and provided ongoing support and training to staff, ensuring optimal use of new technologies
• Provided comprehensive training and documentation for users, facilitating smooth transition and adoption of the new system

• Coordinated a content migration project, transferring 100 articles including images, videos, and documents to a new WordPress site while maintaining content integrity and functionality
• Created, edited, and published content using the WordPress CMS
• Edited and proofread content for clarity, grammar, and style, ensuring high editorial standards
• Customized WordPress themes to enhance user experience and align with brand identity and incorporated SEO best practices and plugins like Yoast SEO, leading to a 25% increase in organic traffic