Rupinder Monga, Frm Email & Phone Number

Ottawa, Ontario, Canada

Specialist in crafting Financial Models tailored for fiber networks, encompassing fixed wireless, and satellite technologies• Formulate comprehensive business case models for community-owned broadband networks• Develop dashboards, KPIs, and financial models specifically designed for rural broadband initiatives• Deliver persuasive financial model presentations to a diverse audience, including mayors, councillors, investors, and other stakeholders• Streamline project finance models through automation to bolster support for multi-million dollar Rural Broadband projects• Collaborate on the financial aspects of various projects under the "Universal Broadband Fund". Finally, winning projects worth $200 M• Provide decision support to the CEO, Finance, Marketing and Sales by understanding the business, challenges and opportunities• Prepare monthly performance reports and variance analysis of results• Assist in leading and coordinating the forecasting, strategic planning and annual budgeting processes in support of Business• Engage a diverse set of stakeholders and provide financial consultation to overcome obstacles and achieve objectives• Played a key role in the M&A of the company• Created an ESOP conversion model for the Company's Employees• Provided critical insights and recommendations to the Management throughout the acquisition process• Create models to automate the generation of Bill of Materials• Optimize and update the consolidated Financials of the company• Directed the strategic planning and execution of a rural broadband project, overseeing budgeting, financial modeling, stakeholder communication, and material ordering• Product management of OSS/ BSS software to ensure seamless implementation

Ottawa, Ontario, Canada

Ottawa, Ontario, Canada

Ottawa, Ontario, Canada

Toronto, Ontario, Canada

Engaged as a consultant on ventures encompassing Finance and Analytics• Conducted Revenue, Shipment, and Weight Forecasting for a logistics firm based in Europe• Developed Financial Models, M&A Deal Structures, and Real Estate Project Models for an Accounting firm in the United States• Crafted a KPI dashboard to provide business insights for the same accounting firm in the US • Designed a budgeting model for a real estate firm operating in Africa• Created a Project Finance model for a real estate firm operating in Africa

New Delhi Area, India

Contributed to the overall strategic vision by developing and driving analytical models, enabling successful revenue growth• Developed lead scoring model based on 3 million customer data, helping raise sales conversion from 1% to 5%• Identified attractive target segments and geographies based on clickstream data, enabling appropriate product launch in 10 locations contributing 30% of the revenue• Employed Insights derived from customer's mobile application usage data to refine content formats, leading to remarkable improvement in Net Promotor Score (NPS) to +9 from –25• Launched Analytics vertical to widen the bouquet of offerings and increased the revenue by 15%• Led a multidisciplinary team to deliver consulting solutions and subsequent training to multiple clients on Finance and Analytics­ - Creating a comprehensive Scorecard for bank customers: US Bank­ - Reducing customer churn: Africa’s Telecom Giant­ - Upselling telecom products: Asia’s Telecom Company ­ - Encouraging repeat purchases: Middle East’s Pharmacy­ - Managing supply chain: Middle East’s Pharmacy­ - Financial Forecasting Model: Asia's Telecom Company­ - Budgeting Model: Africa's Bank­ - Variance Analysis Model: Africa's Hotel­ - Financial Reporting Tool: Africa’s Hotel­ - Project Finance Model: Africa's Hotel

Gurgaon, India

• Index Quant Strategies – leading investment bank in Europe - Responsible for review of index manuals - Back-testing of new indices and validating models of pre-existing indices covering multiple asset classes - Involved in creating innovative index products based on different asset classes like fixed income, equities, derivatives, and commodities to satisfy clients’ requirements and to help manage the risk - Responsible for Data quality management - Recommend process enhancements for the efficient, accurate and timely completion of all operational activities to support index data management and implementation which includes data loading, quality checks and reporting - Monitor daily calculations of existing indices. The process includes composition review, rebalances, corporate actions adjustment, daily calculation and publication of index levels• Hedging Strategies – Investment bank in the US - Developed an automated Excel – VBA template to hedge FX exposure of a portfolio using different trading strategies like Put Spread, Collar, and Put-Spread Collar with different start and end option dates - Generated Volatility Curve to price different option strategies

Jaipur Area, India

• Trade across the Euro Dollar Futures curve on CME in a competitive environment• Intensively use different strategies like Calendar Spreads, Condor, Butterfly etc to capture market move• Analyze daily technical and statistical reports to make trade decisions• Proficiently follow all fixed income instruments and their relationship to each other and market events

Rotterdam Area, Netherlands

• Continuously Price and Trade CAC Index Options on Euronext• Build and Maintain Options portfolio while adhering to risk management guidelines• Respond decisively and immediately to senior trader's trade requests• Interact with mid-office and brokers on a regular basis for timely trade matching and settlements• Responsible for improving Models, Risk Management and Trading Methods• Successfully passed the exams and training to be Eurex and Xetra Trader

Rotterdam Area, Netherlands

• Performed Stress testing and back testing of Structured Products (Excel - VBA)• Studied the gap risk of Structured Products• Developed a stress testing framework, dedicated to specific risk scenarios• Made process flowcharts for Structured Products by extracting information from prospectuses• Converted process flowcharts to Excel models for stress testing• Created data models to predict 5% VaR scenarios• Predicted correctly the 2008 Financial Crisis effect on various Private Indices

Gurgaon, India

• Managed Sales and Marketing of 150 Maruti-Suzuki Dealerships across 11 states of India• Achieved revenue growth of 40% for the year '06 - '07• Developed and implemented customized accessories sales and promotion plans while adhering to the Maruti corporate rubric• Devised and applied strategies for incentive planning, employee training, and allocation of human resources• Created and executed development strategies based on analysis of market-based and competitor research to efficiently sustain growth and maintain market share• Partnered with sales operations to design, implement, and administer a sales incentive compensation plan• Collaborated with the sales head to develop accurate and insightful sales forecasts, incorporating historical sales data, and market trends

Masters, Financial Management

Bachelor Of Technology (B.Tech.), Mechanical Engineering