John Fairhall Email & Phone Number

Melbourne, Vic, Au

Melbourne, Australia

Melbourne, Victoria, Australia

• Within a team, aided in the maintenance and development of Visage; a client/server platform using a backend of Spring, Spring Boot, Java 8/Java 17, Postgres, Hibernate, Liquibase, Lucene and React with an ActionScript/Flex frontend which allows multi-practice Pathology Service customers to manage their practices, including scheduling and managing workflows for technicians, doctors and transcriptionists workflows, claiming services against Medicare and Insurance providers and providing… Show more • Within a team, aided in the maintenance and development of Visage; a client/server platform using a backend of Spring, Spring Boot, Java 8/Java 17, Postgres, Hibernate, Liquibase, Lucene and React with an ActionScript/Flex frontend which allows multi-practice Pathology Service customers to manage their practices, including scheduling and managing workflows for technicians, doctors and transcriptionists workflows, claiming services against Medicare and Insurance providers and providing billing. Customers include the largest Pathology labs in Australia – I-Med and Lumus.• Extend and improve the capabilities of Visage by liaising with the System Architects, understanding and aiding in development of specifications and developing those specifications with other development team members in a Confluence/JIRA working environment, including new development of, or improving;o Medicare Claiming processes (Bulk Billing, DVA, Proda, Eclipse/IMC, PCI)o Pathology Results collection tracking,o Deconstruction of Client/Server into Microserviceso Security and Customer Data Siloing• Provide mentorship to more recent developers on intricacies of system design• Provide analysis and resolution to production service issuesAchievements• Helped in design and development enhancements to a Medicare Simulation system.o Providing development guidance to several new team memberso Learnt React• Aided in design and developed Document microserviceo Removed monolithic server-side processing of pathology and diagnostic reporting• Implemented extensive upgrade to Pathology request workflow• Implemented workflow to allow doctor overread and mentoring/registrar reviewso Developed creation of registrar workflows to allow junior registrars to have their disgnostic reports reviewed for correctness Show less

Melbourne, Australia

As a Solution Architect for Telcoinabox, I designed and directed implementation of multiple telecommunication projects for Telstra Wholesale, Belong, Belong Mobile and Macquarie Mobile, ensuring a comprehensive, integrated approach to the design, roll-out and sign-off of projects. I liaised with Business Analysts, Developers, Operations, QAs and third-party providers to design solutions that deliver on client needs, identifying and resolving troubleshooting issues in order to comply with… Show more As a Solution Architect for Telcoinabox, I designed and directed implementation of multiple telecommunication projects for Telstra Wholesale, Belong, Belong Mobile and Macquarie Mobile, ensuring a comprehensive, integrated approach to the design, roll-out and sign-off of projects. I liaised with Business Analysts, Developers, Operations, QAs and third-party providers to design solutions that deliver on client needs, identifying and resolving troubleshooting issues in order to comply with regulations. I work with other architects, Management, BAs, developers and Infrastructure to develop new functionality within a Windows/Linux/Tomcat/Java EE/WSO2/MSSQL environment. I, as part of a team of Architects, oversaw the project development of Telstra’s Octane System, design and communicate upgrades and modifications including new B2B provisioning of services, PCI compliance updates and data retention implementation. Show less

Responsibilities:• Design and implement software for the Utilibill system – a provisioning and billing platform using Apache Tomcat, Java 8, JavaScript, servlets and JPSs, MSSQL and MySQL.• Liaise with Telcoinabox Business Analysts to design and implement new B2B provisioning and management of telecommunications services.• Monitor the reliability and platform performance of the Utilibill Servers, detect potential issues, identify and recommend tools, technologies and methods that… Show more Responsibilities:• Design and implement software for the Utilibill system – a provisioning and billing platform using Apache Tomcat, Java 8, JavaScript, servlets and JPSs, MSSQL and MySQL.• Liaise with Telcoinabox Business Analysts to design and implement new B2B provisioning and management of telecommunications services.• Monitor the reliability and platform performance of the Utilibill Servers, detect potential issues, identify and recommend tools, technologies and methods that will assist in resolving the problem.• Conduct analysis of project enhancements, to ensure feasibility of the project and perform risk assessment.• Form and build relationships with vendors and other technical partners to develop technical solutions using technology and product analysis.Achievements:• Implemented the provisioning and management of multiple products including; Engin Hosted Voice, Thuraya Satellite Phone, TalkTalk Mobile for TIAB UK, Telstra SHDSL, Wide Area Alert and standard internal queuing mechanisms for provisioning processes. • Refactored Telstra broadband and voice provisioning mechanisms to significantly improve maintainability and robustness of the process for Utilibill operators. • Created the front-end view of scheduled task system, resulting in increased efficiency and improved consistency in creation and configuration of scheduled tasks.• Created the front-end view of internal status of Utilibill server, including bespoke database connection pools, to aid analysis of system health. Show less

• Maintained and enhanced Spotlight on SQL Enterprise Agent (SoSSE), a MSSQL monitoring solution, coding using Agile TDD (Test Driven Development) in Java 6 using Eclipse as IDE • Involved in the redesign and recoding of the SoSSE agent, conduct testing and establish Java GUI components that allow the Agent to report on its internal status during run-time. • Enhanced the Quest Notification System (QNS) which allows a user to receive notifications from a variety of Quest products; design… Show more • Maintained and enhanced Spotlight on SQL Enterprise Agent (SoSSE), a MSSQL monitoring solution, coding using Agile TDD (Test Driven Development) in Java 6 using Eclipse as IDE • Involved in the redesign and recoding of the SoSSE agent, conduct testing and establish Java GUI components that allow the Agent to report on its internal status during run-time. • Enhanced the Quest Notification System (QNS) which allows a user to receive notifications from a variety of Quest products; design new functionality to QNS and resolve faults. • Enhanced SQL Impact; a program that analyses a wide variety of source programming languages and extracts the Oracle SQL references, allowing easy analysis of code impact of altering a database schema.Achievements:• SoSSE Agent – Established various Java GUI components that allow the Agent to report on its internal status during run-time to allow easier bug analysis. • SQL Impact – Designed and developed generic tagged language parser, allowing ColdFusion, HTML and XML to be recognised and analysed. • SQL Impact – Performed analysis of complete Oracle 9 SQL language, and implemented parsing to allow SQL Impact to handle it. Show less

As a Technical Team Member for IBM Australia, I managed the technical aspects of the Solplus Project; a Unix / Oracle database with a Visual Basic 3 front end for Telstra. With a hands-on approach, I performed analyst and programming tasks for the project, allowing marketing groups within Telstra to assign customer details to independent service suppliers, track orders and issue payments. I wrote technical proposals, specifications and calculating estimates, whilst guiding and supporting staff… Show more As a Technical Team Member for IBM Australia, I managed the technical aspects of the Solplus Project; a Unix / Oracle database with a Visual Basic 3 front end for Telstra. With a hands-on approach, I performed analyst and programming tasks for the project, allowing marketing groups within Telstra to assign customer details to independent service suppliers, track orders and issue payments. I wrote technical proposals, specifications and calculating estimates, whilst guiding and supporting staff made up of 3 analyst / programmers and 1 DBA to ensure the system was developed in an efficient and compliant manner. Show less

Responsibilities:. Wrote SQL, PL/SQL and Korn scripts to split Mobil and BP database data apart.

System Tested the Oxygen Datamart Consolidation, the process that extracted data from Oxygen, a pharmaceutical sales and marketing information tracking system, and created a data warehouse from it, capable of being routinely updated. System was an NT Oracle 7.3.4 database installation. Responsibilities:. Aiding in the planning, creation and execution of a system test strategy.. Wrote and executed test plans, test cases and SQL test scripts.

Programmed back-end enhancements for Telstra to Custran, an application on the Winback project that allows phone service customers to transfer their phone service provider from another provider back to Telstra. Coding is in PL/SQL, SQLPlus and Pro*C on an Oracle 7.3.4 database.Responsibilities:. Design and implementation of back-end enhancements using Pro*C, PL/SQL and SQL*Plus.. Analysis and correction of bugs.Achievements:. Put in team leader role (with one… Show more Programmed back-end enhancements for Telstra to Custran, an application on the Winback project that allows phone service customers to transfer their phone service provider from another provider back to Telstra. Coding is in PL/SQL, SQLPlus and Pro*C on an Oracle 7.3.4 database.Responsibilities:. Design and implementation of back-end enhancements using Pro*C, PL/SQL and SQL*Plus.. Analysis and correction of bugs.Achievements:. Put in team leader role (with one subordinate) to design and implement a version control system (CSVC) for several applications to aid Telstra in reaching CMM level 2. The version control system comprises of a set of korn scripts that interface with an Oracle database to control access to file versions and record releases, using RCS to physically store file versions. Show less

Contracted to the Victorian Dpt of Justice to implement a system that extracts Invoice information from an Oracle Financials system and automatically faxed an invoice using the unix VisiFax software. The system was written using Pro*C and korn scripts. This system has since been taken up by the Victorian Department of Education.Achievements:Completed design and implementation within two months, ahead of schedule by a monthContracted to the Victorian Dpt of Treasury and… Show more Contracted to the Victorian Dpt of Justice to implement a system that extracts Invoice information from an Oracle Financials system and automatically faxed an invoice using the unix VisiFax software. The system was written using Pro*C and korn scripts. This system has since been taken up by the Victorian Department of Education.Achievements:Completed design and implementation within two months, ahead of schedule by a monthContracted to the Victorian Dpt of Treasury and Finance to work with a team creating DXF, a secure web site that allows departments to submit financial information to Treasury and inserts that information into Treasury’s Oracle Financials 10.6 system.Responsibilities:Aid in design and implementation of DXF.Achievements:. DXF is responsible for allowing millions of dollars worth of accounting information to be processed through to DTF and enabled the first ever completely electronic lodging of financial information to produce the Victorian Consolidated Funds Report at the end of the 1997 financial year.DXF has been written up in The Melbourne Age and won a Gold award at the 1998 Government IT Productivity Awards.Contracted to BP Australia to convert the Bulwer Refinery Oracle Financials system data 10.1.3 over to BP’s ISPA (a large modified Oracle Financials system 10.6) and to interface ISPA with Bulwer’s installation of Maximo, an inventory and invoicing system, using the Oracle RPC mechanism.Responsibilities:Design and implement conversion of Oracle Financials data from one system to another, ensuring no loss of significant financial data.Design and implement interface between Oracle Financials and Maximo.Achievements:Converted over 100 million dollars worth of Assets data, including depreciation data not available through standard interfaces. Depreciation calculations after transferal of assets showed less than a $2 dollar difference between the two systems. Show less

a consultancy providing outsourcing of large I.T. Projects for Australian businesses and the Australian Federal Government.DFAT ADCNETAs a member of a large (50+ people) software development team, I aided in the implementation and design of ADCNET (Australian Diplomatic Communications Network). ADCNET is a network of message handling and storage systems that is intended to allow the Australian Diplomatic Corps to send secure electronic messages between Australian and overseas posts.… Show more a consultancy providing outsourcing of large I.T. Projects for Australian businesses and the Australian Federal Government.DFAT ADCNETAs a member of a large (50+ people) software development team, I aided in the implementation and design of ADCNET (Australian Diplomatic Communications Network). ADCNET is a network of message handling and storage systems that is intended to allow the Australian Diplomatic Corps to send secure electronic messages between Australian and overseas posts. All implementation was in C, in an HP-UX environment. Implementation documentation was done in accordance with the MIL 2167/A standard.Responsibilities:Design and implementation of government document parsing system, allowing ASCII and Applix documents to be validated against DFAT's proprietary document format and relevant fields of the documents were extracted to allow the document to be routed through the message processing system.Design and implementation of DSGen, a program that accepts C type declarations and automatically writes libraries in C of functions related to the C types, such as deep duplication, memory allocation, memory freeing and list types based on the input C types. Show less