Ronak Agarwal Email & Phone Number

London, GB

• Cultivate and manage business development opportunities, developing & maintaining long-term client relationships and networks.
• Assist in the strategy and implementation of Enterprise Performance Management tools, processes and transformational solutions.
• Plan and develop finance, supply chain or sales models for various clients, helping them track KPIs on dashboards, forecast data and generate business intelligence reports.
• Led implementation of an Anaplan Workforce Planning Solution for a CPG client. Created sophisticated Excel wireframes & user stories after documenting future state requirements. Collaborated daily with stakeholders &.
• Helped with an Anaplan solution implementation for a Retail client for their sales planning. Aggregated data from various sources, transformed data through calculations & designed dashboards for Sales Directors to view.
• Assisted with planning and developing finance models for a CPG client for their FP&A Margin Planning, helping client track KPIs on dashboards, forecast financial data and generate business intelligence reports using.

New York, NY, US

• As a part of Fund Analytics & Reporting team in Valuation Services, worked with multiple clients in alternate investment space to help with portfolio monitoring and financial reporting by streamlining data ingestion.
• Conducted extensive data analyses & modeling, synthesized information and developed client engagement reports using tools like iLEVEL, MS Excel.
• Created an Excel Dashboard to track KPIs for a real estate client, providing a business overview on the progress to respective stakeholders.
• Developed an Excel based Macros/Automation to help analyze quarterly financials for a private equity client, reducing manual efforts and saving costs.

Newark, NJ, US

• Work with different teams in the Supply Chain Management department to optimize internal processes by designing process maps & analyzing areas of improvement, helping achieve service levels of 99%.
• Analyze weekly procurement spends (USD 350K) based on supplier & product category using various tools, helping reduce ordering and shipping costs.
• Evaluate logistics contracts based on transportation costs, delivery time, order accuracy, temperature control, storage space & product variety, resulting in on-time & reliable deliveries and saving 5% on logistics cost.
• Extract & clean inventory data of 2200+ products on daily basis from hospital information system and analyze it using Excel to track usage, costs and trends, helping reduce warehouse costs and space utilization by 15%+.
• Evaluate supplier contracts based on price, product, quality and comparison from previous contracts.
• Automated invoicing and sales order processes in system, reducing processing time of those tasks by 30%.

Dublin 2, IE

• Led five-member team to develop & test EAM/ERP solutions for North American and European clients to optimize business processes, increase efficiencies and track metrics.
• Developed Business Intelligence reports for client leadership to track their KPIs like cost, sales & inventory, forecast trends and provide analytics to help with critical business decisions, reducing management.
• Helped clients optimize production, increase sales & reduce costs by showcasing trends & irregularities on customized dashboards using various data visualization tools, providing insights on future revenues & profits.
• Collaborated with pre-sales & consulting team and engaged in RFP, RFI & onboarding processes to showcase benefits of software solutions, analytics & automation to potential clients, helping generate new clients.
• Involved in project scope, planning and deliverables to design roadmap for team, ensuring zero SLA breaches.
• Mentored 15+ employees on automation and 25+ employees on ERP solutions and various other skills.

Dublin 2, IE

• Helped develop multiple EAM solutions for US clients to optimize their supply chain and financial processes, analyzing trends in procurement, logistics and inventory costs and delivering projects worth millions in USD.
• Automated software processes and helped implement them for four clients, reducing manual efforts required for those processes by over 80% and time by more than 50%; recognized by senior leadership for the same.
• Led new joiner training program comprising 100 trainees during first three months.

Mumbai, Maharashtra, IN

• Worked on multiple cross-platform app and web development projects using Javascript, HTML and CSS.

Master Of Business Administration - Mba, Business Administration And Management, General

Bachelor Of Technology - Btech, Computer Science