Jasmeet Jawanda
Ryde,Australia
Summary
Finance Professional with more than 12years of experience in various facets of finance roles that includes financial modelling, business valuation, risk analysis, costing, pricing, planning & forecasting and development of financial reports, management report pack and Dashboards. Possess strong working knowledge of Excel, IBM TM1 & SAP. Worked as Subject Matter Expert in various projects. Highly motivated team player and vastly experienced at meeting timelines coupled with strong Problem Solving, Time Management, Interpersonal and Communication skills.
Overview
14
14
years of professional experience
Work History
Finance Reporting Manager
Wesfarmers Industries & Safety Pty Ltd
05.2021 - 04.2022
- Timely reporting of monthly divisional results of Wesfarmers Industries compliant with corporate requirement and business objectives which include Sales, Capex, Opex, Trading margin, Profit margin Cogs, Profit Margin and EBIT
- Separate and consolidated financial reporting and analysis on Blackwoods and Bullivants Industries
- Complete commentary on all aspects of P&L statements and Financial reporting pack
- Preparation of Cash flow, Profit & Loss and Balance Sheet along with MTD & YTD commentary and reporting variance to Budget and Last year
- Full insight on market trends supported with analysis, graphs and commentary
- Conduct analysis of the organisation product portfolio and sales activity
- Constant tracking of Operating Expenses against budget for all cost centres on monthly basis and producing variance reports
- Completion of the monthly accruals, journals, fixed assets and depreciation schedules
- Preparation of Financial reporting pack, Management pack, Exco pack, Board reports and dashboards.
Project Consultant
Masterpet Pty Ltd
07.2020 - 04.2021
- Preparing Companywide Data pool for TM1 which includes validation, authentication and reconciliation of Payroll, Budget, Rebate, Cogs, Trade Expenditure, Sales & Margin data with Journal Ledgers and Profit & Loss statement and then preparing TM1 cubes
- Devised the structure of cubes and modules to bring all Finance operations into single platform
- Collaborating across departments and TM1 Developers to develop TM1 modules and coding for companywide business processes
- Developing, documenting, and Training staff with new Business processes aligned with TM1
- Testing of all modules and reports of TM1, authenticating success or preparing error reports
- Setting up new Reporting processes with TM1 views for Companywide business reporting.
Commercial Analyst
AimBig Employment Pty Ltd
10.2019 - 04.2020
- Monthly, Quarterly & Annual Revenue Forecasting & Costing of Education, Training and Employment programs
- Complete analysis and reporting on Trade Expenditure
- Quarterly analysis of Employment Industry and Company performance using the Data released by Dept of Employment of Australian Government
- Developing and maintaining complete databases for major business process
- Quarterly and Annual Budgeting and setting up targets based on analysis of Employment Industry and Company performance and constant evolution of performance against targets
- Credit Risk management and overseeing funds allocation to Education, Training and Marketing programs
- Monthly Reporting Pack and Dashboard covering all essential Business requirements to support internal teams and higher management.
Commercial Analyst
Optus Pty Ltd
02.2014 - 09.2019
- Calculate monthly commission for dealers which includes commission for new Activation, Airtime, Bolt on Services, Service fee and Bonuses while meeting timelines
- Setup new Business Partner, Rate plans, products and commission structures in TM1
- Analysing Data and preparing meaningful commercial reports for higher management
- Processing final payments of terminating Business Partners which includes settling hardware amounts, cancellations & debits against the commission generating
- Forecasting monthly sales and doing trend/performance analysis
- Charging Royalty on Revenue earned by Business Partners approx
- Budgeting annual payments for promotional schemes to Franchised Optus Dealers
- Charging commission on mobile accessories sold by Optus Dealers approx
- Processing monthly accruals for Corporation fees for Advertisements and promotions.
Reporting Analyst
Optus Pty Ltd
02.2009 - 01.2014
- Calculate and analyse monthly payments/remit transferred to dealers’ hardware account
- Analysing Data trends/performance and reporting to Management in relation to monthly and annual subsidy paid
- Managed the hardware account of Yes Optus dealers in NSW & QLD worth around AUD 20 million
- Coordinate the investigations of irregularities and make necessary recommendations and/or modifications to remit plans and process in conjunction with management
- Evaluate remit claims, process payments, account settlements and report variance
- Maintaining budget allocated to dealers for promotion of new products
- Processing payments for returned and transfer logistics
- Main lead person for major system changes, worked closely with IT to work on new requirements and perform UATs.
Rebate Analyst
Novartis Pharmaceuticals Pty Ltd
11.2007 - 01.2009
Education
Masters of Business Administration - Management Accounting & Finance
Central Queensland University
Masters of Computer Applications - Data Analysis and Programming
Maharishi Dayanand University
Skills
- IBM TM1: Experience in TM1 configuration and generating reports through Database
- Tableau: Experienced in generating reports by integrating multiple tables
- SAP: Experience in generating reports, setting up Credit limits & Pricing and Posting Journals
- MS Excel: Advanced in V/H lookups, Pivot tables, Indexing, Macros, Formulas & Functions
- Oracle: Experience in writing queries and joining tables to generate reports
- Financial Modelling: Experience in constructing and using Financial Models in Excel Spreadsheets
References
Available on request.
Timeline
Finance Reporting Manager
Wesfarmers Industries & Safety Pty Ltd
05.2021 - 04.2022
Project Consultant
Masterpet Pty Ltd
07.2020 - 04.2021
Commercial Analyst
AimBig Employment Pty Ltd
10.2019 - 04.2020
Commercial Analyst
Optus Pty Ltd
02.2014 - 09.2019
Reporting Analyst
Optus Pty Ltd
02.2009 - 01.2014
Rebate Analyst
Novartis Pharmaceuticals Pty Ltd
11.2007 - 01.2009
Masters of Business Administration - Management Accounting & Finance
Central Queensland University
Masters of Computer Applications - Data Analysis and Programming
Maharishi Dayanand University