Apoorv Gupta ★ MM, CSM®, CAPM®

Experience

• 

  Indian Agricultural Research Institute

  Jun 2012 - Jul 2012

  Research Project Intern

  ✅ Brought on board to research efficacy and opportunities for harnessing Solar Energy expansion in India.➡️ Analyzed research project report on "Economic Analysis of Solar Energy" for a prestigious government institution in India to find technical solutions that are realistic, feasible and improve overall efficiency.➡️ Secondary research using mainly Indian government databases on trends and information regarding current usage of solar energy and its potential to provide more energy at lower costs.➡️ Synthesized big data into meaningful information by using trend-analysis (graphical representation of trends using charts and histograms) in addition to regression-analysis plotting correlation of different factors such as time and cost involved in tapping solar energy; using various Excel models and functions.➡️ Evaluated merits and demerits of using solar energy and potentially minimizing costs by comparing different alternatives such as merits and demerits of other sources of energy like wind-energy, hydro-energy and depletion of fossil fuels by burning and conversion into energy.📌 Found "silicon" as a major element that can be potentially used as a substitute to silver in the solar cells/panels to cut down costs significantly and demonstrated the same by doing calculations.📌 Received a certificate of commendation for successful completion of the report ahead of the deadline. Show less

• 

  The University of British Columbia

  Jan 2015 - Jan 2016

  Project Manager (Pro bono)- United We Can

  ✅ Brought on board to perform analysis of internal and external data to uncover and understand key trends in the business using numerical and statistical models – strategized product lines by expanding into cell phones, Keurig cups, mattresses and different geographies. Identified impacts on business processes based on detailed solutions and strategies➡️ Analyzed market data using excel models to project trends to explore expansion opportunities.➡️ Recognized as leader, mentor, and a coach with exceptional knowledge of product ownership, as well as business strategy development, risk management, operational planning, and continuous improvement of technology and processes.📌 Key Impact & Metrics: contributed to a substantial increase in gross revenue – condos $2239.56, pubs $2482.44 and restaurants $2148 per month, with an overall average gross revenue increasing to $13,558.96 per month. Show less

• 

  Bennington Financial Corp.

  Jan 2017 - Jan 2018

  Credit Analyst (Contract)

  ✅ Recruited to analyze credit risk and financing scenarios, business financials and personal net worth statements to facilitate effective decision making – drove continuous improvement, automation and innovation of various financial reports➡️ Made recommendations to structure credit deals by analyzing Credit Bureau Reports and Financial Projections/statements.➡️ Facilitated Beta testing new enterprise software to improve process workflow from credit to funding.📌 Key Impact: translated stakeholder and business requirements into 10 different tangible deliverables such as functional specification, workflow, user acceptance testing, user stories, user cases, data flow and model. Show less

• 

  CIBC Mellon

  Jan 2018 - Feb 2022

  Senior Analyst

  ✅ As an Analyst was mandated with carrying out professional market analysis, including equity, debt, and derivatives by conducting research on market indicators and financial information. Rapidly progressed through organizational ranks, earning a promotion to Senior Fund Accountant in 2019 with the responsibility of training junior staff➡️ Elicited business requirements and documentation for investment entries and distribution of funds.➡️ Developed benchmarks and performance measures. Carried out stress tests to test capacity for work from home and User Acceptance Testing (UAT) for income distribution modules. Tracked and delivered NAV to stakeholders before EOD.➡️ Offered expert advice on the building of key reporting processes, enhanced reporting through the use of leading-edge analytics & statistical tools. Presented ideas via reports and presentations, outlining findings and making recommendations.➡️ Critically reviewed relevant economic and business publications, corporate annual reports, as well as online sources.📌 Key Impact: implemented process improvements and procedural enhancements to create efficiency and enhance controls. Prepared reports to effectively support client and director requests and fund investment programs. 📌 Trained and mentored Fund Accountants 📌 Reconciled financial reports of over 10 mutual funds daily to accurately calculate Net Asset Values (NAV) worth $75M-$5B. Show less

• 

  Sheridan College

  Jan 2020 - Jun 2023

  Sessional Professor

  ✅ Selected to assist the preparation and delivery of course material for Microeconomics class. Conducted teaching program effectiveness assessment and made recommendations for improvement. Created and delivered customized teaching programs percolating high ordered thinking skills. Researched and incorporated case studies and examples into experimental learning➡️ Prepared lectures and taught the course. Trained & mentored students in critical thinking and problem evaluation. ➡️ Designed and developed curriculum; analyzed and presented latest academic research findings to diverse audiences.📌 Key Impact: implemented innovative and creative methods using new technologies to enhance learning experiences. Show less

• 

  CIBC

  Mar 2022 - now

  Business Consultant