Gaurav Gupta

Recently architected process optimization initiatives, propelling efficiency enhancements and establishing best practices in financial operations for a leading renewable energy client in Germany

• Developed a comprehensive financial forecast for Q2’2023, spanning multiple service lines and targeting revenue of approximately $2 billion. To streamline the process, created automated forecast templates using VBA, reducing turnaround time and increasing efficiency • Leading the data validation process for monthly financial data within the newly introduced system, Workday.

• Managing regulatory reports on Treasury International Capital for Federal Reserves and on Cayman Islands along with monthly and quarterly variance analysi • Developed automated solutions for extracting data from web based database using UI • Implemented Alteryx solution to streamline TIC regulatory reports along with automation of Excel-based reports using VBA resulting in net savings of 1 headcount;

• Developed strategic plan for XL Catlin to enable senior management in the efficient allocation of capital across business units and regions by analyzing and segmenting product portfolios primarily into 3 segments- growth, maintain and drop based on their net profitability for next 5 years • Prepared and analyzed financial plans and forecasts on annual and quarterly basis for XL Catlin • Developed automated reports using VBA which improved productivity by 20% with annual savings of ~90 hours

• Led knowledge transfer of financial planning and forecasting process to India from Suncorp Insurance, Australia; ensured 100% SLA on data quality and timelines to deliver expense planning reports at year end • Developed revenue budget model with back solve functionality, which resulted in improved efficiency of budgeting process by reducing overall timeframe to prepare revenue plan from 30 days to 25 days

• Developed enhanced KPI reporting, evaluation of key business trends, and variance analysis which assisted senior management in taking informed decisions and in identifying cross sell opportunities in their service line • Prepared financial Plan and forecasting models to assist management in better capital allocation across service lines for current year business development by analyzing profitability of key business accounts