Gary Baker Email & Phone Number

Victoria, Australia

As well as Data Analysis and Conversion, I administered an in house application, Microsoft SBS Network, MS SQL Server, routers, VIOP, MS Exchange, 3 externally hosted web sites and VPN access.I installed a MS SQL server to replace the MS Access storage of the inhouse application working with the developer to change the application to suit.I analysed the data and functionality within the MS Access system and worked out what data had value for the conversion project to the cloud based… Show more As well as Data Analysis and Conversion, I administered an in house application, Microsoft SBS Network, MS SQL Server, routers, VIOP, MS Exchange, 3 externally hosted web sites and VPN access.I installed a MS SQL server to replace the MS Access storage of the inhouse application working with the developer to change the application to suit.I analysed the data and functionality within the MS Access system and worked out what data had value for the conversion project to the cloud based system.I wrote many Crystal reports against the incumbent system data and many other data sources to allow the company to analyse trends rapidly.When I took over the environment many infrastructure changes and upgrades were made to increase reliability and performace.I arrived at code to replace functionality in the MS Access system whenever it failed so the business could continue to use the system for the time until the cloud based system is fully implemented.I converted the appropriate data (being the more complex structures) from this inhouse system and eBay into a cloud based system.Many data sets were built from other data sources when suppliers were unable to provide this data directly. eg: OCR from PDF into Excel then MS SQL of product fitment data then merging this with pricelist data to arrive at all combinations available to publish on eBay. Show less

I provide support to the business’s customers for Reporting (including Crystal Reports, SSRS and PowerBI) Systems projects and Data conversions.I tested a patch upgrade to the application “Authority” and arrived at methods of using this application to get around several systemic issues for a water board.I migrated the data from many different data sources into MS SQL, for a PHN, reforming this data to be used with Dynamics CRM. I was then asked to do another project extracting… Show more I provide support to the business’s customers for Reporting (including Crystal Reports, SSRS and PowerBI) Systems projects and Data conversions.I tested a patch upgrade to the application “Authority” and arrived at methods of using this application to get around several systemic issues for a water board.I migrated the data from many different data sources into MS SQL, for a PHN, reforming this data to be used with Dynamics CRM. I was then asked to do another project extracting further data reforming and loading into Microsoft Dynamics CRM.I then did a minor project using Power BI to change a number of reports for the PHN.This was achieved by rebuilding all the databases from scripted databases and the going through all Stored Procedures to find interactions between the databases including their data warehouse and SSRS reports. While doing this work several issues with data and the SSRS reports were found and redressed.Most recently I have been re designing then coding and testing then making production changes to a Local Council web based Application to support Multiple Councils using the one application. This has required particular attention to data separation as the Councils using the application are understandably particular about data visibility. The application currently covers Customer Relationship Management, Council FAQs, Projects, Works Management, OHS Incidents, Staff Training, Building and Road Assets inspection & remediation. Show less

Melbourne

I was the Database Admininistrator and supported the business’s management ,decision making processes ,month end, regulatory, contractual ,ratings houses data and reporting (mainly using Crystal Reports).I was the Database Administrator installing and maintaining Database environments.Provided the data, analysis and reports that enabled the company to move from a 0 to a 4 Star S&P rating for Investments.Data regimes, analysis and ongoing monthly specialised reporting that… Show more I was the Database Admininistrator and supported the business’s management ,decision making processes ,month end, regulatory, contractual ,ratings houses data and reporting (mainly using Crystal Reports).I was the Database Administrator installing and maintaining Database environments.Provided the data, analysis and reports that enabled the company to move from a 0 to a 4 Star S&P rating for Investments.Data regimes, analysis and ongoing monthly specialised reporting that allowed LFS to negotiate the sale of 2 tranches totalling $367million worth of loans.Advise Infrastructure and Core Systems Development departments throughout my tenure, due to my systems knowledge.Create and maintain SQL code and processes to create data structures in a Data Warehouse.Created processes and regimes to enable system's migrations for part of a separate Core System migration project.I ensured Data Integrity was maintained across all environments.Designed and implemented a custom automated Extract Transform and Load system to bring data from various sources into a Data Warehouse.Maintained standards for reports, documentation and processes.Directly managed between 3 and 6 technical staff.Ensured successful operation of the Crystal Enterprises Servers and of the C to SQL loading processes.Developed and maintained over 200 complex Production Crystal Reports as leader of a team of between 3 and 6 developers.Trained internal staff on the concepts and methods of creating Crystal reports.Work through any data quality issues found to resolution either in SQL or the C systems. Show less

Tenix Defence Systems at Williamstown specialise in the building of World Class Naval Ships and was winding down the ANZAC Naval Ship Building project.The first contract was for a 600 machine replacement project. Then I moved to Tenix Group IT implementing a network asset discovery and management application and a range of other projects.

This Telecommunications Infrastructure management company has a Maximo asset maintenance system and several standalone systems containing other data on the infrastructure supply and costings. My brief was after many months of many people attempting to get a total asset valuation and projected maintenance costings for the whole Telstra network I was asked to do this minor project for the bid team for Silcar’s bid to continue managing these assets. After 2 weeks I had achieved the aims of the… Show more This Telecommunications Infrastructure management company has a Maximo asset maintenance system and several standalone systems containing other data on the infrastructure supply and costings. My brief was after many months of many people attempting to get a total asset valuation and projected maintenance costings for the whole Telstra network I was asked to do this minor project for the bid team for Silcar’s bid to continue managing these assets. After 2 weeks I had achieved the aims of the project. Show less

Traralgon

This home loans and investment in home loans company has a very old UNIX & C environment, which had major issues when developing management reports. I began the project to create then populate nightly a SQL database from the legacy systems. 4 staff were then employed to specify and manage the transition to a more modern system. I created many reports using Crystal Reports to support the business’s management and decision-making processes and data cleansing projects.

Maryvale Mill

PaperlinX are a leader in supplying paper throughout Australia. The Maryvale Mill is said to be the largest CMMS implementation in Australia and is the premier installation of PBS4. The PaperlinX CMMS system engineer left the site unexpectedly and left many system issues and projects part completed.I was asked to take over all system issues and projects as a representative the software vendor, Paradigm Designs Australia, on site for a 3-month contract.This contract was extended so… Show more PaperlinX are a leader in supplying paper throughout Australia. The Maryvale Mill is said to be the largest CMMS implementation in Australia and is the premier installation of PBS4. The PaperlinX CMMS system engineer left the site unexpectedly and left many system issues and projects part completed.I was asked to take over all system issues and projects as a representative the software vendor, Paradigm Designs Australia, on site for a 3-month contract.This contract was extended so I could train a new system engineer when one was eventually employed. Show less

Paradigm Designs are a leader in CMMS systems throughout Australia.PDA had many network and infrastructure issues both internally and at many of their sites which I addressed on an as needed basis.

John Wilson & Partners are a leader in supplying staff for infrastructure design and engineering services to the water sector in Qld and recently expanded to include a Melbourne branch office. JWP have had a long involvement with Asset Maintenance Systems including many Maximo implementations around Australia. I have during this role worked with Tenix Defence, Tenix Alliance, Australian Paper, PZ Cussons, Parks Victoria and Bonlac to develop and improve a streamlined approach for reporting and… Show more John Wilson & Partners are a leader in supplying staff for infrastructure design and engineering services to the water sector in Qld and recently expanded to include a Melbourne branch office. JWP have had a long involvement with Asset Maintenance Systems including many Maximo implementations around Australia. I have during this role worked with Tenix Defence, Tenix Alliance, Australian Paper, PZ Cussons, Parks Victoria and Bonlac to develop and improve a streamlined approach for reporting and audit reporting on the Maximo Asset Management System, Oracle Financials and PBS Asset Management Systems applications. I also helped to design and develop a web based Asset Management application, with Paradigm Business Systems, for Tenix Alliance Pty Ltd. During the course of this job I have also helped with several system implementations of PBS Asset Management Systems applications and became certified by Paradigm Business Systems as a PBS Application Specialist. Show less

Tenix Alliance (formerly Enetech) is a leader in infrastructure maintenance and engineering services to the power, gas, water, telecommunications and transport industries, employing more than 1000 people around Australia. My original brief was to create the management reports for the Tenix Group reporting needs for the financial controller. I was then asked to analyse the Oracle Financials Projects ledger to the General Ledger to find several system issues and to identify how to repair the… Show more Tenix Alliance (formerly Enetech) is a leader in infrastructure maintenance and engineering services to the power, gas, water, telecommunications and transport industries, employing more than 1000 people around Australia. My original brief was to create the management reports for the Tenix Group reporting needs for the financial controller. I was then asked to analyse the Oracle Financials Projects ledger to the General Ledger to find several system issues and to identify how to repair the issues. I then created Purchase Order reports and an Expediting and Freight reporting system for the Energy Alliance department's new IT initiative. To deliver the reports using the Intranet/Internet without application license costs we implemented a Crystal Enterprises server and a small Data Warehouse. Show less

AusData was a company specialising in high speed scanning of documents.I was asked to take over a software project for AusData, which was for the ANZ cheque processing centres Australia wide. This project was converting the readers’ data streams, which were stored in DB2 using ANZ developed VB User Function Libraries, into formatted text files into specialised software for the machine operators and supervisors.

SAGE Computer Support in Morwell specialises in the installation and support of all types of computer systems for industry, health and education sectors throughout the Latrobe Valley. I was asked to take over a project for SAGE (as a Business/Systems Analyst) as the skills required were outside of their available expertise. This project was completed within the time frame and well under the projected project cost. The customer had a decommissioned system which needed to have data extracted from… Show more SAGE Computer Support in Morwell specialises in the installation and support of all types of computer systems for industry, health and education sectors throughout the Latrobe Valley. I was asked to take over a project for SAGE (as a Business/Systems Analyst) as the skills required were outside of their available expertise. This project was completed within the time frame and well under the projected project cost. The customer had a decommissioned system which needed to have data extracted from it and this data needed to be combined into a MS Access database so it could be ported to a replacement system. Show less

Enetech was a leader in infrastructure maintenance and engineering services to the power, gas, water, telecommunications and transport industries, employing more than 1000 people around Australia. After another Crystal Reports consultant had spent 2 months creating several reports for an implementation of a new application suite the Project Manager found that the reports were totally unusable. I was asked to rewrite these reports in the available time, being 5 days. Crystal Reports 7 was used… Show more Enetech was a leader in infrastructure maintenance and engineering services to the power, gas, water, telecommunications and transport industries, employing more than 1000 people around Australia. After another Crystal Reports consultant had spent 2 months creating several reports for an implementation of a new application suite the Project Manager found that the reports were totally unusable. I was asked to rewrite these reports in the available time, being 5 days. Crystal Reports 7 was used as the application, Maximo, could only run native version 7 reports with SQL generated from Crystal statements. Show less

Tenix Defence Systems at Williamstown specialise in the building of World Class Naval Ships and is currently working on the ANZAC Naval Ship Building project.The Material Planning and Control (MPAC) project came from Tenix’s need to track and plan delivery/manufacturing of materials/parts used in building the ships. I was a Business Analyst / Data Cleansing /Infrastructure resource for the MPAC project System Team for the final 8 weeks of the implementation. At the start of my contract… Show more Tenix Defence Systems at Williamstown specialise in the building of World Class Naval Ships and is currently working on the ANZAC Naval Ship Building project.The Material Planning and Control (MPAC) project came from Tenix’s need to track and plan delivery/manufacturing of materials/parts used in building the ships. I was a Business Analyst / Data Cleansing /Infrastructure resource for the MPAC project System Team for the final 8 weeks of the implementation. At the start of my contract the project was running 6 weeks late and due to my efforts was delivered on time. Show less

SIMS was a Lotus Business Partner specialising in Lotus Notes and LAN/WAN installation, support and optimisation. The other entity Corporate Systems is a company that has focused on the provision of Lotus Learning Space solutions since 1996. Winner of the 1998 Lotus Asia Pacific Star Award for Distributed Learning they see themselves as the leaders in delivering Learning Space solutions to corporate and educational institutions. Analysed the business’s needs and modified many in-house… Show more SIMS was a Lotus Business Partner specialising in Lotus Notes and LAN/WAN installation, support and optimisation. The other entity Corporate Systems is a company that has focused on the provision of Lotus Learning Space solutions since 1996. Winner of the 1998 Lotus Asia Pacific Star Award for Distributed Learning they see themselves as the leaders in delivering Learning Space solutions to corporate and educational institutions. Analysed the business’s needs and modified many in-house databases and forms to suit these needs.Analysed a customer’s organisational meeting scheduling requirements and designed the required changes to the Lotus Notes environment. Modified the Lotus Notes environment and a Lotus supplied Calendar Printing template to suit a customer’s requirements. Analysed the business’s warranty tracking needs designed and developed a complex equipment register database to suit. Show less

Don Smallgoods specialises in the manufacture and distribution of smallgoods products.In doing these roles my duties have included:-Ensured successful operation and management of IT Department.Analyse IT business needs of all segments of the business then supply solutions.Rewrite many sales reports in Crystal Reports Professional 4 & 5 and had a VB front end developed to make running them easy for the users. Managed the implementation of several new systems (including JD… Show more Don Smallgoods specialises in the manufacture and distribution of smallgoods products.In doing these roles my duties have included:-Ensured successful operation and management of IT Department.Analyse IT business needs of all segments of the business then supply solutions.Rewrite many sales reports in Crystal Reports Professional 4 & 5 and had a VB front end developed to make running them easy for the users. Managed the implementation of several new systems (including JD Edwards, World).Managed the IT Department staff and help ensure their career development.Management of outsourced services and contractors.Year2000 Compliance identification and planning.Investigation of all non-compliant computer hardware/software.Replacement/re-engineering of non-compliant hardware/software.Re-engineering of legacy systems where appropriate and cost effective.Liaised with management regarding Year 2000 issues and resolutions.Liaised with Upper Management, Customers, Contractors and suppliers at all levels.Hardware and Software support.Managed ongoing maintenance of legacy systems.System Administration of Novell server, NT Servers and Lotus Notes server.Reviewed all suppliers and repairers of hardware.Developed a SOE for the company.Created policies and images to make rebuilding of workstation environments rapid.Established, tested and maintained all backup regimes. Managed data conversion projects.Upgraded and reconfigured the network infrastructure for optimum stability and performance. Show less

School Of Business And Electronic Commerce.

This school was the first in Australia to offer an ecommerce degree and the interactions between business and the Internet are the focus of most of the offered courses.In doing this role my duties included:-Supported the desktop needs of the Lecturers and Staff of the Churchill school.Supported the notebook needs of the Lecturers of the Churchill school.Supported dial-in access to the Computer Centre for Lecturers’ home machines.Optimised hardware and software on desktops… Show more This school was the first in Australia to offer an ecommerce degree and the interactions between business and the Internet are the focus of most of the offered courses.In doing this role my duties included:-Supported the desktop needs of the Lecturers and Staff of the Churchill school.Supported the notebook needs of the Lecturers of the Churchill school.Supported dial-in access to the Computer Centre for Lecturers’ home machines.Optimised hardware and software on desktops and LAN.Reviewed all suppliers and repairers of hardware.Developed a SOE for the school of Business and Commerce.Created policies and images to make rebuilding of environments rapid.Redeveloped several MS Access databases for the school.Some maintenance / development of the school’s web site.Tested the usage of remote control over TCP/IP over the Internet.Took a leading role in the assessment of LDAP based mail products for the university. Show less

This company is a telecommunications equipment supplier and repairer. In doing this role my duties included:-Analyse the business needs for a job costing and tracking system specified the required changes to a decommissioned DBASE 4 application suite.Made the required changes to the DBASE 4 application suite. Reinstatement and ongoing development of a DBASE 4 application suite at the Service Centre.Optimised the workstations, hardware, software and the Netware 4.1… Show more This company is a telecommunications equipment supplier and repairer. In doing this role my duties included:-Analyse the business needs for a job costing and tracking system specified the required changes to a decommissioned DBASE 4 application suite.Made the required changes to the DBASE 4 application suite. Reinstatement and ongoing development of a DBASE 4 application suite at the Service Centre.Optimised the workstations, hardware, software and the Netware 4.1 LAN.Optimised the hardware and software at the Support Centre, which was a 50 user Netware 4.1, site with an ISDN WAN link to Sydney and the head office at Notting Hill. Took over the support and ongoing development of the DBASE 5 “Support Call Centre” application at the Support Centre.Established and test proper backup regimes. Show less

Vic

Intellisol (VIC) was a start-up branch of a NSW based company that develops additional modules for, sells and installs the Great Plains Dynamics accounting package.In doing this role my duties have included:-Supported the client base in all areas of their business’s IT needs.Analyse business needs of customers and provide solutions to suit.Installed Great Plains Dynamics and some Intellisol developed additional modules.Provided Project Management throughout… Show more Intellisol (VIC) was a start-up branch of a NSW based company that develops additional modules for, sells and installs the Great Plains Dynamics accounting package.In doing this role my duties have included:-Supported the client base in all areas of their business’s IT needs.Analyse business needs of customers and provide solutions to suit.Installed Great Plains Dynamics and some Intellisol developed additional modules.Provided Project Management throughout implementations.Technical assistance to the client base for the products and LAN/WAN environments.Pre sales technical discussions with prospects.Hardware and software procurement and installation.Installed a network and setup the companies’ new office systems.Established and tested backup regimes.Implement a Lotus Notes database of faults and solutions in the products I was responsible for maintaining. Including replication with the USA using the Internet.Completed a Great Plains Dynamics, Certified Accounting Applications Specialist course. Show less

Soft Centre developed and supported a range of software products covering three main areas:MasterPrint which includes Production Costing and Estimating, Inventory control, Debtors, Sales Analysis, Purchasing and Outwork for the printing and allied industries.Seams which is a version of MasterPrint for the garment and cloth manufacturing industry and a Point Of Sale system. The customer base was over 600 manufacturing companies throughout Australasia.In doing these roles my duties… Show more Soft Centre developed and supported a range of software products covering three main areas:MasterPrint which includes Production Costing and Estimating, Inventory control, Debtors, Sales Analysis, Purchasing and Outwork for the printing and allied industries.Seams which is a version of MasterPrint for the garment and cloth manufacturing industry and a Point Of Sale system. The customer base was over 600 manufacturing companies throughout Australasia.In doing these roles my duties have included:-Investigation, Analysis, Design, Development, Implementation and Integration of system modifications.Lead the development of the “Manufacturing Estimating Development Language” which was a 4GL developed as part of the MasterPrint environment.Project Management.Brought to market then ongoing development of “MasterPrint Open System”.Installation and training clients’ on the usage of “MasterPrint Open System”.Training of internal staff on the installation and usage of “MasterPrint Open System” and “Manufacturing Estimating Development Language”.Looked after the role of Technical Service Manager for several months. Took over the MasterPrint product manager role.Presented technically orientated demonstrations to prospective customers of the Estimating environment.Modernised the in house network and desktop environment. Established and test proper backup regimes.Established remote control access for the external users and overseas branches. Show less

This company was a medical service provider that deals with the rehabilitation of workplace injuries. In doing this role my duties included:-Reinstatement of the network environment and the modernisation of software and the configuration of PC’s. Phone support to the users making any required changes.Monitoring backups and system performance over this period.

SIMS is a Lotus Business Partner specialising in Lotus Notes and LAN/WAN installation, support and optimisation. In doing this role my duties have included:-Ad hoc programming E.g.: Designed and wrote a program to intercept the printed output of a proprietary purchasing system and strip out the fax numbers and names. This data was then placed into separate files, and command files to drive the sending of the purchase orders by a fax server for the Crown Casino.Installation and… Show more SIMS is a Lotus Business Partner specialising in Lotus Notes and LAN/WAN installation, support and optimisation. In doing this role my duties have included:-Ad hoc programming E.g.: Designed and wrote a program to intercept the printed output of a proprietary purchasing system and strip out the fax numbers and names. This data was then placed into separate files, and command files to drive the sending of the purchase orders by a fax server for the Crown Casino.Installation and support of LAN’s and WAN’s. Installation and support of Lotus Notes & Lotus Domino servers. Show less

This group of companies included the five frequency control products manufacturing plants (located in Australia, England, USA, Singapore and Mauritius) and Head Office operations. Other companies in the group included a printing and packaging company (Thomas Frame & Co), a graphic arts and plate making house (C.S. Graphics), and cutting forme manufacturers (Australian Laserforme and Laserforme Singapore).In doing this role my duties have included:-Discussed project requirements with all… Show more This group of companies included the five frequency control products manufacturing plants (located in Australia, England, USA, Singapore and Mauritius) and Head Office operations. Other companies in the group included a printing and packaging company (Thomas Frame & Co), a graphic arts and plate making house (C.S. Graphics), and cutting forme manufacturers (Australian Laserforme and Laserforme Singapore).In doing this role my duties have included:-Discussed project requirements with all levels of management and design solutions.Wrote and maintained software to suit nine manufacturing companies within the group in the COMET environment.Evaluated all hardware and software needs throughout the group.Sourced and purchased all hardware and software.Installed and supported all hardware and software.Researched and specified projects for external consultants.Managed projects contracted to external consultants.Designed and wrote an in house EDI system to transfer Production Orders between sales offices and production plants electronically.Supported Laserforme’s Australian agency for the carton design package IPDS.Installed and maintain remote communications.Migrated from the COMET environment to the client server application Great Plains Dynamics.Implemented remote node communications so customers could interact securely with our Fileserver from remote locations.Established and test proper backup regimes.Migrated all DOS based word processors and spreadsheets to Windows applications.Implemented and supported Netware 3.11, Personal Netware and Windows for Workgroups networks to handle CAD files, output to CNC devices and office computing needs for over 20 of Laserforme’s customers. Show less

Keylink Computers was a consulting company in the QANTEL minicomputer environment that developed and supported a range of software products which included: Production Costing, Estimating, Outwork, Inventory control, Debtors, Sales Analysis, Purchasing, Creditors, Payroll and General Ledger. In 1990 we created a subsidiary company Binary Image to import specialised imaging cards and created the first digital storage of medical X-ray film application in Australia. This project evolved into a full… Show more Keylink Computers was a consulting company in the QANTEL minicomputer environment that developed and supported a range of software products which included: Production Costing, Estimating, Outwork, Inventory control, Debtors, Sales Analysis, Purchasing, Creditors, Payroll and General Ledger. In 1990 we created a subsidiary company Binary Image to import specialised imaging cards and created the first digital storage of medical X-ray film application in Australia. This project evolved into a full telemedicine environment, which was used by Telstra to demonstrate the teleconferencing abilities of ISDN Australia wide. From 1987 I was the Victorian agent for the COMET operating system on DOS PC’s, which was a replacement for the QANTEL proprietary environment.In doing these roles my duties have included:-Design, write and maintain software to suit mainly manufacturing companies in the QANTEL then COMET environments.Discussed project requirements with all levels of the customer’s management and designed solutions to suit.Evaluated all hardware and software needs of the customers.Employment and training and management of analyst programmers.Supervision of up to 5 full time programmers on 20 projects in the QIC Basic (QANTEL) environment.Supported all client software and hardware needs.Established proper backup regimes.Modified software and implemented VAT for a customer in the UK and GST for customers in New Zealand.Modified software and implemented multiple currency additions for several customers.Helped develop the COMET operating system, and maintained the Report Generator and Utilities for the developers of COMET.Helped setup the Victorian and New Zealand dealer networks for IPEX Computers, which Keylink was wholesaling for over two years.Researched & Developed hardware and software solutions to store X-ray films.Researched & Developed hardware and software for Telemedicine. Show less