Jonathan Tran Email & Phone Number

Sydney, Nsw, Au

Sydney, New South Wales, Australia

Macquarie Park, Nsw, Australia

Sydney, Australia

Optus

4th rotation: Commercial Reporting AnalystReports to the Commercial Manager with responsibility for providing commercial insights and analysis for Optus’ mobile networks which, includes radio access, mobile transmission and mobile capacity. ♦ Assisted in providing commercial insight behind an A$1Bn Mobile Network Capital financial plan♦ Ensured that the Mobile Network investment plans were financially aligned Optus finance strategy♦ Formulated presentation packs for CEO and Senior Leadership♦ Detailed monthly/quarterly/annual forecasts, budgeting reports and driver/variance analysis.♦ Oversaw the financials behind hundreds of projects to deliver new mobile equipment and services♦ Maximised the use of TM1 as a reporting tool♦ Streamlined reporting processes through use of BW Hana, TM1, BPC♦ Developed new reporting processes to provide higher quality insights♦ Business Partnered with Network divisions including network strategy and procurement, to deliver and communicate OPEX targets, and ensure that the business and finance are aligned♦ Be the go to person for variance analysis for total Networks

Optus

3rd rotation: Commercial Reporting AnalystWeekly task:- Collate and consolidate inputs from various parts of the business to deliver the CEO's dashboard which provides metrics on revenue and strategic drivers> Ensure that all relevant business units have submitted their inputs by deadline> Identify and seek driver commentary from the business for all substantial movements> Identify and resolve any inaccurate inputs by implementing standardised high level controls> Provide high level driver commentary where available and movement commentary where driver is not available Monthly task:- Update the CEO report which contains high level P&L breakdown for both the Optus Group and the consumer business within Optus> Utilise TM1 to splice data and identify the business unit and product that is driving month on month and month to budget variances> Liaise with relevant business unit/analysts to collate driver commentary> Provide written variance analysis backed up by driver commentary Quarterly tasks:- Collate and consolidate inputs from various parts of the business to deliver the following:> Investor relation pack which contains both financial and non-financial data> ABS consumer sales> ABS CPI> ABS Internet activity On-going tasks:- Identify key strategic drivers and seek data from the broader business to present on the CEO dashboard- Optimise and/or eliminate BAU reports through the use of efficient excel practices and leveraging TM1- Verify the integrity of data that will be presented to the CEO, senior management and shareholders- Challenge data provided from the business by identifying outliers and work with the business to rectify and/or explain any abnormalitiesProject (WIP):- Leverage TM1 to assist in the development of a self-serve solution for the CEO's dashboard> Work closely with a TM1 developer> Create a DBS solution for manual inputs> Ensure new dashboard is accurate > Ensure fluid transition to the new dashboard

Optus

2nd rotation: Marketing Commercial OPEX AnalystPortfolio consists of the following:- Marketing and Product OPEX- Vividwireless OPEXMonth-end reporting tasks:- Preparing an update pack for the Director of Marketing Commercial- Preparing various packs tailored to individual business unit directors- Updating spreadsheets to reflect current month, forecast version, budget version- Provide analysis on variance drivers for each business unit under my portfolio- Day +3 Consolidated flash report (Compiled through SAP/TM1 as required)- Update stakeholders on current spend, and assist them in keeping within expectationsQuarterly tasks:- Adjusting forecast and phasing of OPEX as per feedback from stakeholders and upper management. Updating salary data, reconciliation of headcount and dollars to better reflect the business and liaise with the business to better forecast headcount movements.- Preparation of quarterly update packs for all business units and Marketing Commercial director- Advise the business of outlook, in terms of how to meet expectations.Yearly tasks:- Development and implementation of AOP- Engage the business and determine requirements of the business, within expectations OR- Implement AOP baseline as per instructions provided by upper management- Engage with the business to determine next year's initiative schedules- Methodically apply stretches (if any) to business units capable of taking them on- Budget transfersOne-off tasks:- Development/Maintenance of standardised reports using excel that are easy to refresh >Created TM1 based report that rolls itself over months, quarters, calendar years, financial years and is easy to adapt to other business units). Benefit: saves time with rolling over the file>Created SAP based report that extracts BU tailored data in regards to OPEX. Benefit: saves time analysing BAU OPEX expenditure>Created standardised auto-update Powerpoint slides. Benefit: saves time

Optus

1st rotation: Product Financial OperationsMy portfolio consists of the following:- Device vendor P.O. and invoice management- Financial operations requests dropboxIn addition to my portfolio I also perform other tasks that include but are not limited to:- Daily inventory stock on hand (SOH) reports and analysis- Weekly inventory Moving Average Price (MAP) reports and analysis- Ad Hoc Statement of Accounts (SOA) reports and analysis- Liaising with vendors, vendor's accounts receivable and Optus' accounts payable to organise smooth payment transition.I am currently learning to use SAP and excel (intermediate) to assist in the tasks that I am undertaking.As my rotation comes to a close I would have acquired new portfolios and more additional tasks, which will include month-end reporting tasks in other portfolios.Month-end reporting tasks include accounting for:- The assets and liabilities side of Optus' Qantas Frequent Flyers program- The "Other receivables" general ledger - The "Device manufacturers" general ledger- Preparing one-off journals and explanations for my team, so that management accounting can eliminate one offs and see monthly results at underlying BAU level- The "Google Play" portfolio - Any changes in balance sheet reconciliations for any of the previous month-end tasksOther responsibilities:- Mentoring/buddying an intern from the UNSW coop scholarship program- Mentoring/buddying a new graduate to Optus so that they can take over my responsibilities as I move on to my next rotation- Organise smooth transition for ad hoc payments, this includes the payment to Netflix to allow for the latest Optus' marketing campaigns and strategy

Parramatta

Help customers with their general banking needs and/or find the right person for them to speak to in regards to their finances whether it be for business or personal banking.To excel at enhancing and securing the financial well-being of businesses, communities and individuals.

Fairfield Nsw

As a Locum co-ordinator my responsibilities were as follows:- P.O. and Invoice creation- Stakeholder management - Liaising with hospital administration staff in regards to shift bookings for clients- Liaising with Oz Locums' accountants to organise BAS - General filing and organisation- Maintenance of information in all MYOB modules

Bachelor Of Business, Accounting And Finance

Activities and Societies: Vietnamese Student Association

Education record

Activities and Societies: I was a dedicated library monitor and was also a member of the table tennis team representing my school.