Robert Bartlett Email & Phone Number

Sunshine, Vic, Au

Melbourne, Victoria, Australia

Melbourne, Australia

• Creating & improving reporting across Customer & Commercial Department, within the complex regulatory and commercial environments in which Jemena operates. Achieved through requirements gathering and elicitation, design, analysis, development, testing, and feedback, to create bespoke reporting dashboards. These reports support the Management Team by delivering high quality, informative reports and analytics across all areas of Customer Operations, to enable agile, data driven decision making. This highly detailed data has allowed the Jemena Gas Disconnection Squad to focus on areas where a greater return on effort will be achieved, such as particular market segments or unsuccessful disconnection reasons, which is resulting in lifting the overall Disconnection success rate.• Created & developed the reporting structure & practises for the Operations Improvement Squad across the gas meter tracking areas. Developed all reporting to monitor & analyse the performance of the Squad, extracting & managing the data from SAP ERP, Hana, and Business Objects, and utilising data visualisation and trend analysis. This was achieved primarily in MS Excel, & I am preparing the reporting for migration to MS Power BI.• Introduced improvements & included automation to allow reporting to be completed more efficiently. The Disconnection Reporting took more than two days each month to complete when first created, but this is now completed in under two hours. The Disconnection data has been developed as a single source to be shared across the Disconnection Performance, Segmentation, and Retailer reporting areas.• Worked with the Commercial Strategy team in closing out an issue with a Retailer for the Watchman Security Lighting. Built and presented a model to breakdown the O&M & Usage costs as per their requirements, and provided documentation and details to support the discussions. These items were essential in this agreement being reached, which was a big risk to Jemena.

Melbourne, Australia

• A short term contract to analyse the outcomes of the project to reduce the incidence of estimated gas meter reads for all customers on Jemena's gas networks in NSW & ACT. • Data analysis in Excel, Business Objects, and SAP of meter read results, liaising with external customer service teams and meter read service providers, and reporting on results to senior management, the project steering committee, and retailers.

Richmond, Vic

• Engage with our client’s stakeholders to conduct in-depth analysis and assessment on their products and packaging, gather information, and present reports on results.• Developed sustainability reporting, documentation, and processes utilised by the management team.

South Melbourne

• Developed flexible and easy to use Contract Compliance documentation and processes to be utilised by the management team to track deliverables. • Hired by the National Account Director to identify unknown areas of risk to Datacom across twelve high profile clients. This was required as responsible staff have moved across different contracts or have left the business.• The new documentation and process is to be utilised for each new Contract and Statement of Work going forward, to make information clear and consistent across all contracts.

Brooklyn, Victoria

• Responsible for monitoring and analysing the performance against the cost efficiency and control mechanism criteria, and safety & service level key performance indicators. • Managing four teams of up to 15 staff across my areas of responsibility including financial reporting, administration, planned maintenance, and inventory.• Developing and mentoring staff to adapt to changes in the client agreement, by altering responsibilities and reporting lines.• Identified annual savings of up to $50K to PFM through my understanding of the contract and investigation into safety & performance KPI’s for response and restoration work. • Managing and building strong relationships with PFM’s majority sub-contractor workforce, negotiating pricing schedules for new work codes, and implementing alterations to agreements and contracts as required. One alteration to the agreements resulted in saving of up to $10K per month.• Implementing and finessing a short-term invoice management tool based in SharePoint and implementing business processes and documentation to ensure timely payment to sub-contractor workforce. This short-term tool is still in use today.• Presenting a daily briefing of the Performance Centre to office and field-based staff, to provide an understanding of the service KPI’s daily results from Tableau, promote communication through the team to share knowledge, build teamwork and improve performance.

Laverton North

• Support the General Manager of Networks Victoria & the Contract Managers of the AusNet Services Gas and Electricity Service Contracts. • Responsible for monitoring and analysing the performance against criteria to enable the Management Team to make informed business decisions.• Provide accurate & timely reports of unitised costs against targets, trend analysis to identify variations, financial analysis on direct, indirect & overhead costs.• Creation of monthly written reports & dashboards on all aspects of the client relationship• Creation of Total Costs versus Target Report (TAC v TATR) of unitised service items of work. This report takes 500,000 lines of data & provides a view of costs against target for an individual unit of work, for all work completed under the contract. This report is paramount in the performance in the Cost Incentive of the contract, which is the basis of the Target Reset and Term Extension negotiations at the end of each contract year. I developed a new version of this report when our client introduced a new finance system (SAP). • Comprehension of the Service Contracts with AusNet Services and the Collaborative Contracting Principles under which they operate. This enabled an understanding of the commercial drivers of the contracts and allowed me to define my own plans within the larger business strategy. • Used knowledge to influence the senior management team that Downer had achieved targets that the client believed had not been met under the terms of the contract. This lead to awarding Downer a contract extension with AusNet Services.• Successful negotiation with the client in the removal of Normal and Overtime Unit Rates & move to blended rates for units of work. This had been a sticking point between the Contract Managers & the Client. I was able to demonstrate why our method to set rates achieved a fair outcome. There was no financial gain or loss to either party.

Southbank

• Validation of the monthly invoice of Operations & Maintenance and Capital work.• Monitoring of work volumes and costs against forecast and budget.• Trend analysis to identify variations.• Completion of reports on all aspects of the Service Provider relationship.• Monitoring performance against Key Performance Indicators.• Development and implementation of all Microsoft Excel based tools utilised in this role. These tools and this role did not exist prior to my commencement and I created these using advanced functions in Excel. • Creation of the annual Gas OPEX Financial Year Budget of approximately $15 Million, built up from a ‘work unit’ level, and presented to the Gas Group Senior Management Team and the AusNet Services INS Finance Group.• Accurate validation of the Service Provider’s invoice of Operations & Maintenance and Capital work with 10,000 lines of data, to the value of $5 Million each month.• Detailed analysis and identification of a single discrepancy in invoicing that resulted in a $250,000 refund from our Service Provider.

Abbotsford

• Responsible for the ownership of the post-sale process in the production of FMCG by factories across Asia through to customer delivery. • Close liaison with the customer through this process ensuring a high level of customer service and repeat orders. • Successful implementation of an order handling system in the office for consistent and accurate handling of customer orders, to ensure delivery to the customer in forecast timeframes.• Successful implementation of an Access database to assist in customer relationship management, and keep accurate customer records in one central and controllable system.• Running all aspects of the business whilst the owner was overseas for a period of five weeks.

Preston

• The Business Planning Analyst has responsibilities to the Operations and Sales groups. • Responsible for the completion of accurate and timely reports on costs and productivity by the Operations Group.• Trend analysis from data gathered.• Planning for workforce requirements. This was achieved through the compilation and analysis of forecast and completed work for the Operations Group, and investigations into variations to the forecast. • Responsible for the creation of Quarterly and Annual Sales Forecasts for the Sales Group, which included analysis on sales made, the creation of Cost / Benefit and Sales Impact analysis on solutions for Process Change and Strategic Initiatives, and comparison of forecasts. • This information was utilised in strategic decision making by the Operations and Sales Senior Management Teams and General Managers.• Developed and implemented innovations to the reporting and analysis aspect of the role through the use of advanced functions in Excel. This allowed the ability to take on further responsibilities.• Developed multiple Business Cases for the change by Optus to move from reselling the Telstra Local Call Service, to the installation of Optus’ own equipment into Telstra exchanges. This included analysis of installation timetables and changes to staff levels in Customer Service, Sales, and Operational areas.• Developed multiple Business Cases for the change by Optus from Analogue Subscriber TV to the Digital Service. This included analysis of changes to staff levels in Customer Service, Sales, and Installation Services to cope with the expected increase in demand, and changes to logistics and the ordering process for equipment.

Preston

• Responsible for forecast capacity for the Operations Group, which includes field based staff and contractors. This is completed through tracking headcount and availability, and the completion rates and productivity of this group. • Responsible for the completion of accurate and timely reports for Senior Management on available quota, completed work volumes and customer additions to the network, and ad hoc reports as required. This role required liaison with all levels of Management, other Internal Business Units, and External Groups.• Development and implementation of all Microsoft Excel based tools utilised in this role. These tools did not exist prior to my commencement.• Acting Dispatch Team Leader of a team of 12 staff over a four-week period.• Streamlined the process for the completion of daily and weekly Operations Staff completed work and productivity reports. This was achieved through improvements I built into the models used in the calculation of completed work.• Created a set of Procedures and Work Instructions for the Dispatch and Capacity Planning role and responsibilities. This was utilised in the training of new members to the team.

Graduate Certificate Of Management, Business Administration And Management, General

Fields of Study included : • 101 Financial Management (Including Accounting Comes Alive training module) • 102 Management Perspectives •.

Bachelor Of Science (B.Sc.), Applied Physics & Computing