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
Financial Modelling
Financial Management
Budgeting and forecasting
Data Mining and data visualization
Business Planning
Strategic Planning
Project Management
Contract Management
Team Leadership
Operations Management
Performance Management
MS Office
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