Tom Pettit Email & Phone Number

Sydney, New South Wales, Australia

At Grosvenor Engineering Group, I maintained and supported the ARMS system, an MS Access-based application integrated with SQL Server, managing critical operational tasks such as job setups, technician entries, accounting, reporting, timesheets, HR functionality, and administration reporting. The system was used by over 300 users across Australia and New.

Sydney, Australia

Maintaining and migrating to Access 2013 an existing Fleet Management database system.

Sydney, Australia

• Development and ongoing maintenance of bespoke system running all aspects of the business including work recording, reporting and invoicing.Since working on this multi user MS Access system I have
• Migrated backend to MariaDB (MySQL).
• Increased performance and reliability
• Incorporated Stored Procedures, Views and Pass-through queries
• Setup remote access for business use and development
• Modified VBA code to use discrete functions to improve performance, reduce duplicate code and expedite future maintenance and development

Sydney

Developed a Quoting and Reporting system with MS Access and MySQL (MariaDB) to streamline the existing quoting and reporting processes. System interacts with MYOB and MS Visio, offer remote access and provide flexibility and speed to the AVLink quoting capabilities.

Sydney, Australia

Remediate and enhance an existing MS Excel reporting system.

Sydney, Australia

Delivered an MS Access/SQL Server based system to manage and control the processes and workflow of migrating thousands of clients accounts between banking entities. The system was developed within the allocated and remarkably short 3 week development period and was successfully launched with a base of 50 users.

Sydney, Australia

• Develop an MS Access Proof of Concept database and application to store, retrieve and report on operational, financial and statistical data for TfNSW projects.Tasks included
• Develop the Proof of Concept System in MS Access/SQL
• Export to and Read from Excel workbooks with bespoke VBA functions to deal with more than 255 columns
• DSNless data connections
• Bespoke Write Conflict routine
• Complete auditing of all data changes

Sydney, Australia

Projects with Dimension DataTransport for NSW August 6, 2014 - October 4, 2016Lead Developer, Developed new system for TAP program to report on and keep track of 500+ projects. Migrated database to SQL Server Back End. NSW Police Force May 26, 2014 - July 31, 2014Migrate two MS Access databases to SQL Server and improve performance.NSW Police Force January.

Sydney, Australia

Adding new functionality to an in house developed MS Access database for a utilities company.

Mascot

I have improved, modified and created 4 systems while at Qantas.1) Improved data collection of an existing, newly created and incomplete system by automating the extensive, manual data collection process to reduce the steps required by the operator to define and import the data to improve speed, accuracy and time required. Also added multiple charts and.

Leichardt

Maintain existing MS Access order processing system which had reached the limits of MS Access and had started to show signs of instability and slowness as well as keep it operational whilst migrating system to SQL Server 2005. I also performed all data cleansing and migration to SQL Server and the implementation of SQL Server based system into production..

Sydney, Australia

Added new functionality to an existing in house developed system. Functionality included full integration with MS Outlook and MS Access to display and manipulate tasks and meetings with client details from the database, display task and meeting data in access to replicate the look and feel of Outlook in Month, Week and Daily Schedule views including.

Huntingwood

Testing applications in preparation for Windows 7 rollout as well as maintaining and new development of the database applications being used to record and report compatability issues, staff, their current applications and automating communications with information derived from the databases. I also automated the creation of and emailing 2,500 documents to.

Sydney, Australia

Assist with Windows 7 and Office 2010 rollout primarily by testing and fixing existing Access and Excel applications to ensure they work with Office 2010 in a Windows 7 environment.Locate all MS Access databases within HSBC Sydney, liaise with the database owners to convert,test and remediation in preparation for their system and Office upgrade. I have.

Parramatta

Modify and Merge the functionality of two MS Access database applications into one application/database and document and comment existing and new code.

Sydney

Short contract where I assisted with modifications to Macro Scheduler scripts to extract data from one application through automated screen navigation and data scraping and enters the data into another application, simulating data rekeying with automated macros.

Assisted to migrate a large chunk of data consisting of 9 million records from a legacy system to SAP. Started January 11, 2011. Completed on February 18, 2011. Reduced the processing time of the data from an estimated 12-15 hours ((based on test runs using Access Queries) to 50 minutes using SQL Server and T-SQL with MS Access 2010 for reporting and.

Test and remediate several dozen pre MS Access 2003 db's and applications for conversion to MS Access 2010, document and maintain an Issues Register to enable an insight into the remediation requirements before the organisation upgrades to Office 2010. Role finishes on Monday 13th December 2010. Client was Sydney Water.

I worked for Dell, Sydney Water was the client. Test and remediate several dozen pre MS Access 2003 db's and applications for conversion to MS Access 2010, document and maintain an Issues Register to enable an insight into the remediation requirements before the organisation upgrades to Office 2010. Role finishes on Monday 13th December 2010.

Conducting evening sessions for the BSBITU101A - Operate A Personal Computer unit of competency from the BSB10107 Certificate I In Business qualification.

Data preparation for migration to SAP. Completion date is November 12, 2010.

Two week contract to assist with the investigation of a new sales model through data validation, analysis and modelling using MS Access and Excel.

3 month project to convert an existing spreadsheet application into a multi-user database application using MS Access 2003 and SQL Database.The final system accepts project information from up to 40 users in two countries and provides project forecasts to assist in determining the feasibility of a product release.

A short-term project to improve the efficiency of an existing manual Resource Management process in the HR Department. The resulting system improved accuracy and reduced the time used in the process by 90% each month. The system was developed in MS Access 2000 and automated data importing from Excel files, processing and exporting results to Excel.

I was in the Reporting Team for the Customer Call Centre. My duties included* Support and Maintain existing applications and databases* Develop new applications as required by the business* Implement standardised software development procedures* Implement and follow the full SDLC.* Support team members in report productionPosition was made redundant in.

Primary role was to support the old VAX system (inherited when Qantas bought the company) until its retirement. Assisted in extraction and migration of VAX data into new system. Also developed a Print Server application in VB6 to capture print jobs from the VAX and print the data on newly designed forms using Microsoft technologies.

Initial role was for the RAAF at Richmond to develop a system which tracks the costs involved in flying the Hercules Aircraft around the world (VB6 and SQL Server). I also developed 3 in house systems for Aspect in MS Access.

My first break into software development. I helped support the Sydney Easter Show (3 shows) by developing or supporting applications to assist in the running of the following showsDog Show, Cat Show, Show System (runs almost all shows, the shows which could not fit in this system has there own dedicated system, ie. Dog, Cat..) amongst other (see my.

Community Adult Learning, First role since graduating. Held 11 classes per week teaching computers as well as maintaining the centres computers. We move location while I was there, I planned and wired the new buildings network requirements and setup the servers, basically got the entire centres network and computer systems operational with the assistance.

Associate Diploma Of Business, Computer Programming

Advanced Certificate, Information Technology

Activities and Societies: I assisted a local Aboriginal organisation named Enmaraleek in maintaining their computer systems. Whilst not.

Certificate Iv Taa, Workplace Training And Assessment

Certificate Ii, Information Technology

I completed this course of study to satisfy the new VETAB rules governing the TAA40104 which came into effect at the same time I achieved.