HARSHAD VANJARA
Ottawa,Canada
Summary
Senior analyst with robust background in data analysis, financial modeling, and strategic planning. Known for strong collaboration skills and adaptability in fast-paced environments. Adept at leveraging advanced analytical tools and methodologies to drive impactful business decisions. Consistently delivers results through teamwork and solutions-focused approach.
Overview
12
12
years of professional experience
Work History
Senior Analyst Valuations
Brookfield Renewable
01.2021 - Current
- Building valuation models for renewable energy assets and funds
- Building and maintaining corporate models and other decision-making models for different funds and investment assets under management worth more than $20 billion
- Preparing and delivering budgeting, investment and valuation presentations aimed at higher management
- Assisting in capital market activities (Model updates, scenario analysis, Negotiation etc.)
- Preparing financial budgets and strategic plan for assets under management and reporting KPIs and other important findings to upper management for informed decision making
- Preparing project financing for assets under management and running equity and lender case scenarios for projects under development
- Evaluating Investment and growth opportunities (SWOT analysis and valuation models)
- Full cycle analysis to learn the factors responsible for change in IRR from acquisition for assets under management
- Conducting on demand scenario analysis and sensitivity for various assets for real time decision making
- Building and maintaining business plan, corporate covenant, and credit rating models
- Creating dashboards to analyze, centralize and summarize large data sets pertaining to different renewable assets
- Automated the creation of valuation bridges using excel macros reducing the time by 100%
- Collaborating closely with different teams within Brookfield (reporting, accounting, treasury, capital markets etc.) for data gathering and other ad-hoc requests
- Mentored junior analysts, fostering professional development while enhancing overall team performance.
- Collaborated with cross-functional teams to identify areas of improvement, leading to increased operational effectiveness.
- Optimized project management, resulting in timely deliverables and improved client satisfaction rates.
- Enhanced team productivity by streamlining workflow processes and implementing time-saving strategies.
- Analyzed data to identify root causes of problems and recommend corrective actions.
- Developed customized reports, summarizing and presenting data in visually appealing format.
- Deployed predictive analytics models to forecast future trends.
- Developed complex dashboard and reporting tools to track business performance metrics.
- Improved company efficiency with the development of key performance indicators and tracking metrics.
Assistant Manager Finance
Firstsource Solutions Ltd
01.2020 - 01.2021
- Built commercial and business financial models for comparison (actual vs forecast), forecasting numbers, budgeting, impact, and variance analysis
- Collaborated with business finance and accounting team for analyzing monthly and quarterly financials and financial planning
- Created 3 statement model for the organization to analyze the impact upon P&L, Cashflow and Balance Sheet of the organization for various growth scenarios
- Created revenue, expense, and sales pipeline analytics for all the business segments within the organization for enabling effective decision making
- Communicated with external parties and stakeholders to maintain relationship and answering administrative questions
- Created financial information packages (KPI reports) for stakeholders and prospective investors at the end of every financial quarter
- Conducted client business analysis, competitor analysis, industry research and prepared PowerPoint presentations aimed at senior management for corporate development activities
- Prepared M&A target analysis and PowerPoint presentations aimed at CFO and CEO
- Created reports and dashboards to analyze, centralize and summarize large data sets for various business segments within the organization
- Automated the creation of 2 quarter ending reports, increasing efficiency, and reducing the time by almost 100%
- Worked closely in cross-functional teams for ad-hoc requests and special projects
- Managed team of 3 members for business deliverables with stringent deadlines
Senior Consultant
Mazars
01.2019 - 01.2020
- Prepared financial models for private businesses for forecasting numbers, Valuation (DCF and comparable transaction approach), identifying trends, analytics, and calculating key performance indicators (KPIs)
- Created financial models for valuation of real estate properties using direct cap and market approach
- Created a model for qualitative and quantitative analysis of more than 300 listed medium and small enterprises, Reducing the time for analysis by more than 60%
- Preparation of Information memorandum (Pitchbook) for private firms to raise capital
- Analyzed huge volume of data for financial analysis, variance analysis, ratio analysis, and to develop meaningful insights
- Communicated with clients to learn the requirements and to discuss the solutions and suggestions; represented the firm at various events to establish network and relationships
Associate Solution Advisor
Deloitte USI
01.2017 - 01.2019
- Assisted in auditing of real estate appraisals for residential and commercial properties in US
- Created financial models for forecasting numbers, analysis, valuation and reporting for various businesses and real estate properties in US
- Created securitization models for various investment banks for variety of asset types such as Residential and Commercial Mortgage Back Securities, Asset Backed Securities, Non-performing assets, Auto Loans, Student Loans and Reverse Mortgages
- Due diligence of financial documentation for structured securities for accuracy and consistency with the underlying model
- Communicated with investment banks and investigated the differences in the waterfall models
- Ran various analytics for securitization deals
- Automated the calculations of credit analysis ratios for various deals, reducing the time and effort spent on this activity by 100%
- Prepared variance analysis, and responsible for identifying and trouble-shooting issues
- Created automated excel utilities for comparing different spreadsheets and variance analysis, hence reduced the time and efforts spent on these activities by more than 90%
- Received a client appreciation awards for excellent time management and efficiency of work
- Trained team of 5 members on different aspects of financial and cashflow modelling
- Conducted valuation audits of real estate properties and businesses for accuracy of key assumptions and calculations
Software Engineer
Vistaar Systems
01.2013 - 01.2016
- Developing analytical pricing solutions to distributors & suppliers, designing & developing various modules for pricing software using excel VBA and Java
- Solved the problem of unnecessary and erroneous data overwriting by creating an excel utility that allow a read only access to the database system for the front-end developers
- Managed a team of 8 & handled work allocation, resource optimization activities on a timely basis
- Requirement analysis, client communications and translating customer requirements into project deliverable
- Conducted knowledge transfer and training sessions
- Reengineered the entire pricing software legacy code to reduce the run-time by more than 50%
Education
Master of Business Administration - Finance
Sydenham Institute of Management Studies
01.2018
Bachelor of Engineering - Information Technology
Rajiv Gandhi Institute of Technology
01.2013
Skills
- Business/Financial Modelling & Valuation
- Financial budgeting & forecasting
- Project Finance
- Structured finance
- Business Analysis
- Capital Markets
- Excel Macros & Automation
- Database Management/SQL
- Customer Service/Client Relationship Management
- Tableau
- Advanced Excel & Macros (VBA)
- Advanced PowerPoint
- Macabacus
- MS Word
- Python
- Data Analysis
- Financial Modeling
- Tech-Savvy
- Investor Relations
- Budget Planning
- Industry analysis
- Financial Forecasting
- Portfolio valuation
- MS Excel
- Process Improvements
- Multiple Priorities Management
- Team Collaboration and Leadership
- Root Cause Analysis
- Python Programming
- Tableau Software
- Data Modeling
- Competitive Analysis
- Tech-Savvy
- Investor Relations
- Budget Planning
- Industry analysis
- Financial Forecasting
- Portfolio valuation
- MS Excel
- Process Improvements
- Multiple Priorities Management
- Team Collaboration and Leadership
- Root Cause Analysis
- Python Programming
- Tableau Software
- Data Modeling
- Competitive Analysis
- Tech-Savvy
- Investor Relations
- Budget Planning
- Industry analysis
- Financial Forecasting
- Portfolio valuation
- MS Excel
- Process Improvements
- Multiple Priorities Management
- Team Collaboration and Leadership
- Root Cause Analysis
- Python Programming
- Tableau Software
- Data Modeling
- Competitive Analysis
- Tech-Savvy
- Investor Relations
- Budget Planning
- Industry analysis
- Financial Forecasting
- Portfolio valuation
- MS Excel
- Process Improvements
- Multiple Priorities Management
- Team Collaboration and Leadership
- Root Cause Analysis
- Python Programming
- Tableau Software
- Data Modeling
- Competitive Analysis
- Tech-Savvy
- Investor Relations
- Budget Planning
- Industry analysis
- Financial Forecasting
- Portfolio valuation
- MS Excel
- Process Improvements
- Multiple Priorities Management
- Team Collaboration and Leadership
- Root Cause Analysis
- Python Programming
- Tableau Software
- Data Modeling
- Competitive Analysis
- Tech-Savvy
- Investor Relations
- Budget Planning
- Industry analysis
- Financial Forecasting
- Portfolio valuation
- MS Excel
- Process Improvements
- Multiple Priorities Management
- Team Collaboration and Leadership
- Root Cause Analysis
- Python Programming
- Tableau Software
- Data Modeling
- Competitive Analysis
Accomplishments
- Achieved [Result] by completing [Task] with accuracy and efficiency.
- Used Microsoft Excel to develop inventory tracking spreadsheets.
- Resolved product issue through consumer testing.
- Achieved [Result] through effectively helping with [Task].
- Collaborated with team of [Number] in the development of [Project name].
Internship
Research Intern, NVS Brokerage, 01/2017, 12/2017, Involved in conducting research and fundamental business analysis on companies in textile sector, presenting findings/preparing equity research reports based on business analysis, financial analysis, and peer analysis., Created equity analyst reports on Trident ltd and Indo count ltd., Prepared a utility to automatically update equity and mutual fund related transactions using excel automation (macros).
Languages
English
Native or Bilingual
Hindi
Native or Bilingual
Gujarati
Full Professional
Marathi
Full Professional
Bengali
Professional Working
Timeline
Senior Analyst Valuations
Brookfield Renewable
01.2021 - Current
Assistant Manager Finance
Firstsource Solutions Ltd
01.2020 - 01.2021
Senior Consultant
Mazars
01.2019 - 01.2020
Associate Solution Advisor
Deloitte USI
01.2017 - 01.2019
Software Engineer
Vistaar Systems
01.2013 - 01.2016
Bachelor of Engineering - Information Technology
Rajiv Gandhi Institute of Technology
Master of Business Administration - Finance
Sydenham Institute of Management Studies
Similar Profiles
Salim BathawabSalim Bathawab
Settlements & Structured Transactions Analyst at Brookfield RenewableSettlements & Structured Transactions Analyst at Brookfield Renewable
MOUHAMADOU DIOPMOUHAMADOU DIOP
Analyst, Settlement and Structured Transactions at Brookfield RenewableAnalyst, Settlement and Structured Transactions at Brookfield Renewable
Mouhamadou DiopMouhamadou Diop
Analyst, Settlement and Structured Transactions at Brookfield RenewableAnalyst, Settlement and Structured Transactions at Brookfield Renewable
Harjot VaidHarjot Vaid
Volunteer at St Maurice ParishVolunteer at St Maurice Parish
Annie HebertAnnie Hebert
Personal Support Worker at Triloka Psychology & Integrative Wellness CenterPersonal Support Worker at Triloka Psychology & Integrative Wellness Center