Summary
Overview
Work History
Skills
Professional Snapshot
Personal Information
Extracurricular Activities
Timeline
Generic
Baljeet Singh Randhawa

Baljeet Singh Randhawa

Finance
Pune

Summary

Master of Business Administration (Finance), 9 years experience in Financial planning and Analysis, Financial Modeling,Financial Reporting with Deloitte, Accenture, British Petroleum, Johnson Controls, Internship Chartered Accountancy, Handled team of 3-4 Analyst, associates, ERP used SAP, One stream.

Power BI skills,Data Visualization

Overview

12
12
years of professional experience

Work History

Manager

Johnson controls India pvt ltd
05.2023 - 08.2024
  • Financial planning and Analyst in corporate FP &A team- exposure and analysis of globe across North America, Europe -Middle east, Latin America, Asia pacific region and global products data
  • Aged receivables, bad debt provision analysis of all regions
  • Travel, entertainment and training expenditure review, comparison with ARN (Approval requisition number) data
  • Financial rotational programme cost reporting
  • FX Analysis -Impact of Local currency of entities to USD Analysis legal enties wise, region wise
  • Worked majorly on One stream ERP (Earlier version of Hyperion)
  • Actively support in preparation of any ad-hoc reporting requirement that may come up from time to time.

Financial Analyst (Department-Inventory)

BP Business Solutions India Pvt Ltd (British Petroleum)
01.2021 - 05.2023
  • Actual Inventory versus forecasted and variance analysis and reconciliations
  • Handling various types of Contracts, for e.g., Pipeline, Terminaling
  • Invoice and expenses review
  • Gain /Loss Analysis
  • Month end Commentary and Analysis
  • Research of Volume in Barrels/Gallons in various tools and reaching to various stakeholders accordingly
  • Aging Analysis of receivables -to reduce the financial burden and take timely accurate measures
  • Actively support in preparation of any ad-hoc reporting requirement that may come up from time to time.

Client Financial Management Analyst

Accenture Enterprise Enablement
04.2017 - 08.2020
  • Budgeting and forecasting
  • Forecast vs Actual Comparison and Variance Analysis- To Compare the forecast numbers versus Actual and check with leads and team the reason for variance
  • FTE,Headcount Time and operating expenses variance and Trend Analysis
  • Revenue Recognition- Compliance with US GAAP
  • Invoice review and creation: To check the Invoice backup and Invoice breakdown and generate Invoice in SAP
  • Inventory Reconciliation-To Track the variance between billings and Revenue
  • And reconcile
  • Trend Analysis - To Check trend of Resources time, expenses, overheads- Month on Month and Year on year Basis
  • To help Internal and external Audit requirements
  • Project Life Cycle Management (Start to end project tracking project and to Maintain financials
  • To Pass Journal entries
  • Actively support in preparation of any ad-hoc reporting requirement that may come up from time to time.

Project Controller Analyst

Deloitte Consulting India Pvt Ltd
04.2015 - 04.2017
  • Budgeting & forecasting for Deloitte's individual projects and measuring performance
  • Performing budget & forecast analysis for India and US service line/area
  • FTE,Headcount Time and operating expenses variance and Trend Analysis
  • Forecasted & budgeted net service revenue and conduct variance analysis
  • Budget allocation for large accounts and effectively monitoring the usage and reporting to partners in weekly conference calls and presentations
  • Monitoring project expenditures (time and expense) and ensuring compliance as per firm policies
  • Pricing review for new projects and extensions to the existing deals
  • Setting up financial trackers for new projects as per the statement of work (SOW) and pricing model
  • To do periodic expense audit and further review with resources based on Policies
  • Issue invoices to the clients
  • Billing & Collection Report & follow up on the collections
  • Actively support in preparation of any ad-hoc reporting requirement that may come up from time to time.

Internship of Chartered Accountancy Studies

CA Mahajan& Aibara & S Gautam Associates
09.2012 - 09.2014
  • Internal Audit- Purchase to Pay, Order to cash
  • Concurrent Audit-Payment Management, Stock Taking etc
  • Statutory Audit.

Skills

Financial Planning and Analysis

Professional Snapshot

Budgeting and Forecasting: Develop and manage the annual budget, annual operating plan, zero based budgeting,rolling forecast

Financial Modeling: Conduct in-depth financial analysis to evaluate projects, initiatives, and investments. Provide commentaries and analysis based on financial data.

Variance and Trend Analysis: MTD, QTD, YTD, YOY  variance analysis, trend analysis of P& L components – Sales, COGS, SGA, GM, etc and Balance sheet item Analysis -Aged receivables analysis.

Portfolio Handled: Handled Client of $23 Mn and $15 Mn independently from Gas and food sector- pricing, revenue recognition, variance analysis.

Revenue recognition: Performed revenue recognition as per US GAAP for various types of contracts with various methodologies -percentage of completion, cost recoverability method, etc.

Cost Control: Identify areas where cost savings can be achieved without compromising the quality or effectiveness of services.

Financial Reporting: Generate financial reports for senior management and other stakeholders. Including key performance indicators, budget vs. actual comparisons, and financial forecasts.

Stakeholder Communication: Collaborate with leaders, executives, and other stakeholders to communicate financial performance, provide insights, and align spending with the firm's strategic goals.

Process Improvement: Continuously assess and improve financial processes to streamline workflows, enhance efficiency, and reduce costs.

Transition :Various transitions from US stakeholders and preparing Standard operating procedures (SOP)

Audit requirements: Supporting the audit asks by providing them key information as requested.

Ad Hoc Analysis: Conduct ad hoc financial analysis and modeling as requested by senior management to support decision-making.

Personal Information

  • Passport Number: M0582185
  • Date of Birth: 11/12/87
  • Gender: Male
  • Nationality: Indian
  • Marital Status: Married

Extracurricular Activities

· Member of fun committee to manage FP &A quarterly events, Captain of FP &A cricket team.

Timeline

Manager

Johnson controls India pvt ltd
05.2023 - 08.2024

Financial Analyst (Department-Inventory)

BP Business Solutions India Pvt Ltd (British Petroleum)
01.2021 - 05.2023

Client Financial Management Analyst

Accenture Enterprise Enablement
04.2017 - 08.2020

Project Controller Analyst

Deloitte Consulting India Pvt Ltd
04.2015 - 04.2017

Internship of Chartered Accountancy Studies

CA Mahajan& Aibara & S Gautam Associates
09.2012 - 09.2014
Baljeet Singh RandhawaFinance