Between leaving school and discovering computer programming I made a couple of mis-steps. Doesn’t everybody? Since then I have never been far from computers, programming them, using them, or making them work properly for people and organisations.Throughout my career I have enjoyed many positions in programming, analysis and design, project management, and user department management.Most recently using MS Access and VBA, I developed a user-friendly application to record and correctly amortise commission payments from 2015 onwards. An average of 1M records were processed each month, with amortisation as defined by the newly introduced IFRS15 Accounting Standard.My personal and professional experiences have taught me the following about myself:I can align, lead and grow teams from 10 to 100 people.- The customer is central to all that I do.- I speak tech and exec - My gut instinct is good but I seek data for my decisions- The buck always stops with meI drive myself to be a better person- I am constantly learning- I stay calm when faced with adversity- I focus on making high-quality decisionsI write solid programs to do what the user wants- VBA enhancements making MS Excel perform better with large amounts of data- VBA enhancement making MS Access perform significantly faster - adjust COBOL legacy programs to cater for current needsPrivately I sail, I manage yacht races, I manage the administration for a volunteer organisation. And guess what? I have applied VBA enhanced Excel in all these situations to make them better for the customers.Professional SkillsExcel/Access/VBA Programming | COBOL | User Experience (UX) Design | Project ManagementDomain Knowledge Commercial (Accounting, Mailing, Sales & Marketing reporting) | Manufacturing (Requirements planning, Scheduling, Performance and Utilisation reporting) | Activity Support (Yacht Race planning and Scoring, Member Management processes, Race Manager support)Now available for contract. Reach out.
-
Application DeveloperTelstra May 2018 - Feb 2019Melbourne, AustraliaAfter the introduction of a new international accounting standard for income and related expenses, including sales commission payments, Telstra decided there was a requirement to calculate the run-in data from FY2015 for implementation from the start of FY2019. Using MS Access and Visual Basic, I developed an application to record and correctly amortise commission payments from 2015 forwards.Key Objectives• Process commission payments from 2015 onwards, amortising them as defined by the… Show more After the introduction of a new international accounting standard for income and related expenses, including sales commission payments, Telstra decided there was a requirement to calculate the run-in data from FY2015 for implementation from the start of FY2019. Using MS Access and Visual Basic, I developed an application to record and correctly amortise commission payments from 2015 forwards.Key Objectives• Process commission payments from 2015 onwards, amortising them as defined by the IFRS15 Accounting Standard. Commission payments averaging 1M records per month• Make the process user-friendly to be managed and operated by Finance department personnel. Show less -
Project ManagerTelstra Jul 2016 - Apr 2018MelbourneCustomer Lifetime Value forecasts the likely value and tenure of customers, and relates it to a number of factors such sales channel and location. The project consolidates product sales data relating to Investment Costs, Revenue, Overheads and Other costs into a model that provides a Whole of Customer view and forecast.The project was delivered on-time and within budget tolerances. -
Board MemberSelf Employed 2005 - Feb 2016Melbourne, AustraliaUse my attributes to develop areas of my personal pursuits. To do this I have taken on a number of (mostly) unpaid roles. Board level activities, as Commodore, within Royal Brighton Yacht Clubo I was Commodore of the Royal Brighton Yacht Club from 2010 to 2012, with overall responsibility for the Club’s turnover of $2.5m and Assets of $10mo Chaired the General Committee (equiv. Board) with the objective of providing a Club that was responsive to members’ needs. Board… Show more Use my attributes to develop areas of my personal pursuits. To do this I have taken on a number of (mostly) unpaid roles. Board level activities, as Commodore, within Royal Brighton Yacht Clubo I was Commodore of the Royal Brighton Yacht Club from 2010 to 2012, with overall responsibility for the Club’s turnover of $2.5m and Assets of $10mo Chaired the General Committee (equiv. Board) with the objective of providing a Club that was responsive to members’ needs. Board Member of the Brighton District Masonic Hall Co. Ltd.o Primary objective is to ensure the Board acts responsibly in the interests of the shareholders, and of the tenants of the property. Sailing Instructoro Primary responsibility is always to ensure that pupils are safe.o After that they are taught to have fun sailing a yacht.o Customer focus is paramount, and on a number of occasions I was given pupils that had complained about other Instructors. Internal education within local Freemasonryo Working with new members to give them the basic knowledge necessary to progress within the organisation. Show less
-
Manager, Problem And Change ManagementTelstra Wholesale It Support Sep 2003 - Oct 2005Melbourne, AustraliaThe Wholesale Business Unit of Telstra (TW) supplies network capacity and telecommunications products to other carriers and Service Providers, including Internet Service Providers.Key Objectives• Provide operational support for TW’s on-line Customer Order and Service Faults interfaces • Provide operational support for TW’s Siebel based Customer Relationship Management • Manage the IT changes necessary to support the entry of :- New carriers into Multi-carrier… Show more The Wholesale Business Unit of Telstra (TW) supplies network capacity and telecommunications products to other carriers and Service Providers, including Internet Service Providers.Key Objectives• Provide operational support for TW’s on-line Customer Order and Service Faults interfaces • Provide operational support for TW’s Siebel based Customer Relationship Management • Manage the IT changes necessary to support the entry of :- New carriers into Multi-carrier Pre-selection (MCP) New Service Providers into the Unconditioned Local Loop program (ULL) Achievements• Improved visibility and credibility within Telstra Corporate Change and Problem Management of the overall Telstra Wholesale customer interactive environment, and specifically :- The complex relationships between the on-line environment and supporting applications The importance of the unique interactive environment to TW customers such as OPTUS• Improved vendor Production Support focus on the Root Cause Analysis necessary to improve software issue resolution, resulting in a 1-cycle (1 month) reduction in the time taken to resolve production issues. Show less
-
Delivery Program ManagerTelstra Wholesale It Support Aug 2000 - Sep 2003Melbourne, AustraliaKey Objective• Support Telstra Wholesale’s business expansion by managing the out-sourced delivery and operation of IT applications.Achievements• Negotiated 20% cost saving on application maintenance from IBM/GSA. • Initiated and lead Industry level negotiations, which Resulted in better end-user service for Multi-carrier Pre-selection Reduced address errors by 40%, reducing re-work and providing cost-savings for all industry participants Detected and… Show more Key Objective• Support Telstra Wholesale’s business expansion by managing the out-sourced delivery and operation of IT applications.Achievements• Negotiated 20% cost saving on application maintenance from IBM/GSA. • Initiated and lead Industry level negotiations, which Resulted in better end-user service for Multi-carrier Pre-selection Reduced address errors by 40%, reducing re-work and providing cost-savings for all industry participants Detected and corrected significant data security issues presented an on-going threat to other carriers’ business Show less
-
Manager, National Collection CentreTelstra Credit Management Nov 1997 - Aug 2000Melbourne, AustraliaTelstra’s National Collection Centre was a new Centre formed to specialise in the collection of finalised accounts that subsequently became delinquent (overdue by 30 days or more).Key Objectives• Reduce Telstra’s bad debt write-off by managing all aspects of Finals’ collection activities. • Improve staff performance to increase collections and reduce the costs of collectionAchievements• By driving technical and cultural change, delivered year on year efficiency and… Show more Telstra’s National Collection Centre was a new Centre formed to specialise in the collection of finalised accounts that subsequently became delinquent (overdue by 30 days or more).Key Objectives• Reduce Telstra’s bad debt write-off by managing all aspects of Finals’ collection activities. • Improve staff performance to increase collections and reduce the costs of collectionAchievements• By driving technical and cultural change, delivered year on year efficiency and effectiveness improvements in Final Account Collections,, measured by : Delivered on or under budget expenditure and headcount performance for each year Increased staff productivity, (over 2 years, daily collections improved from of $741 to $3,559) Reduced ratio of cost to recovery from over 30% in January 1998 to 7.9% by June 2000• Managed the incorporation of the Parramatta based National Insolvency Centre into the National Collection Centre, improving output and reducing insolvency processing costs, as evidenced by Reduction in time to process administration details Increase in recoveries• Designed and implemented a Reward and Recognition Scheme which improved collections by over 2% (approximately $1M), significantly exceeding the program cost.• Managed the development and implementation of an innovative skip tracing technology, improving internal recoveries by over $5 million per annum.• Managed the internal development of two new large tactical IT applications, and their supporting processes, to automate collection, referral and re-referral functionality.• Assisted in designing the new Collection Agent Contract under which a panel of agents was appointed to assist in the collection of excess debt and very old debt.• Coached and managed the teams providing collection support to special projects with the objective of cleaning the debtors’ ledgers of very old debit and credit balances, to reduce long-term outstanding debt. Show less
-
Senior It Audit ManagerTelstra Audit And Risk Management Apr 1995 - Nov 1997Melbourne, AustraliaThe Audit and Risk Management department (A&RM) provided Telstra’s internal audit services.Key Objectives• Provide on-going technical support to the compliance audit function.• Ensure that a secure LAN service was maintained for all users. • Ensure that the IT component of process audits accurately reflected the application technology and functionality.Achievements• Saved Telstra $8M annually in software licensing fees. This was achieved by negotiating with a… Show more The Audit and Risk Management department (A&RM) provided Telstra’s internal audit services.Key Objectives• Provide on-going technical support to the compliance audit function.• Ensure that a secure LAN service was maintained for all users. • Ensure that the IT component of process audits accurately reflected the application technology and functionality.Achievements• Saved Telstra $8M annually in software licensing fees. This was achieved by negotiating with a Microsoft the proper means of accurately and acceptably measuring software usage. (A by-product of this activity was to successfully defend Telstra from media claims of software piracy.)• Completed the first audit using the leading edge risk assessment methodology : It was performed using the new Control And Risk Framework for Telstra (CRAFT) It was the first Y2K Readiness Audit performed by Telstra The report was instrumental in upgrading the visibility of the potential Y2K risk within Telstra• Eliminated a potential for large-scale fraud by adding significant new process and IT controls to the fully automated Creditors Cheque Payments application. (The risk areas were uncovered by again utilising CRAFT.) Show less
-
Audit Analyst/ProgrammerTelstra Audit And Risk Management Apr 1994 - Apr 1995Melbourne, AustraliaKey ObjectiveProvide Technical Support within IS&T Audit to support the compliance audit function.Achievements• Developed special purpose reporting systems to monitor Telstra critical activities (eg. Progress Reporting for the FLEXCAB Rate Code Elimination project).
John Spencer Education Details
-
Telstra InternalLeadership Development Program -
Swinburne Institute Of TechnologyBusiness Administration -
Northgate Grammar School, Ipswich, EnglandManagement Information Systems, General -
General
Frequently Asked Questions about John Spencer
What is John Spencer's role at the current company?
John Spencer's current role is Application Developer.
What schools did John Spencer attend?
John Spencer attended Telstra Internal, Swinburne Institute Of Technology, Northgate Grammar School, Ipswich, England, General.
Not the John Spencer you were looking for?
-
-
1jarden.co.nz
-
1toyota.com.au
-
1hotmail.com
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial