John Spencer

John Spencer Email and Phone Number

Application Developer
John Spencer's Location
Greater Melbourne Area, Australia
About John Spencer

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.

John Spencer's Current Company Details

Application Developer
John Spencer Work Experience Details
  • Telstra
    Application Developer
    Telstra May 2018 - Feb 2019
    Melbourne, Australia
    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… 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
  • Telstra
    Project Manager
    Telstra Jul 2016 - Apr 2018
    Melbourne
    Customer 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.
  • Self Employed
    Board Member
    Self Employed 2005 - Feb 2016
    Melbourne, Australia
    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… 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
  • Telstra Wholesale It Support
    Manager, Problem And Change Management
    Telstra Wholesale It Support Sep 2003 - Oct 2005
    Melbourne, Australia
    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… 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
  • Telstra Wholesale It Support
    Delivery Program Manager
    Telstra Wholesale It Support Aug 2000 - Sep 2003
    Melbourne, Australia
    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… 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
  • Telstra Credit Management
    Manager, National Collection Centre
    Telstra Credit Management Nov 1997 - Aug 2000
    Melbourne, Australia
    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… 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
  • Telstra Audit And Risk Management
    Senior It Audit Manager
    Telstra Audit And Risk Management Apr 1995 - Nov 1997
    Melbourne, Australia
    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… 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
  • Telstra Audit And Risk Management
    Audit Analyst/Programmer
    Telstra Audit And Risk Management Apr 1994 - Apr 1995
    Melbourne, Australia
    Key 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 Internal
    Telstra Internal
    Leadership Development Program
  • Swinburne Institute Of Technology
    Swinburne Institute Of Technology
    Business Administration
  • Northgate Grammar School, Ipswich, England
    Northgate Grammar School, Ipswich, England
    Management Information Systems, General
  • 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?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

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.