Accenture - ISAS Project - TAFE Queensland

June 2003 to October 2004

Brisbane, Queensland

Position

Conversion Analyst

Project Description

PeopleSoft Student Administration was selected by TAFE Queensland to replace the legacy CAP system. PeopleSoft supports the administration of students throughout the entire student lifecycle. TAFE Queensland and Accenture share a joint responsibility for the implementation. Accenture has successfully implemented PeopleSoft in a number of Universities in Australia.

One of the requirements of the project is that 5 years of legacy business data be available to the new PeopleSoft system. The overall goals of the conversion were to minimise business disruption, process inefficiency, and support issues after the Conversion.

Role

Overall responsibility for the conversion of Classes and Academic Advisement and shared responsibility for the Student Enrolments conversion. Part of the execution team, performing the conversion steps. Large amount of SQL written to reconcile the conversion process. Used by team management as roving problem solver and general Oracle and SQL expert. Required to rapidly come up to speed on PeopleSoft and CAP (the legacy system) and understand the TAFE Queensland business. Also needed to acquire skills in the PeopleSoft development environment (People Tools, Application Designer, People Code and SQR). Required to rapidly acquire skills in the PeopleSoft Architecture, datamodel fundamentals and the PeopleSoft system from both a technical and business perspective.

Gold Coast City Council - Infrastructure Charges Evolution (ICE) Project

October 2002 to April 2003
Surfers Paradise, Queensland

Position

Business Systems Analyst and Team Leader

Project Description

The Infrastructure Charges Evolution (ICE) project is to introduce robust systems and processes that comply with the Integrated Planing Act (IPA) 1997 and the Integrated Planning and Other Legislation Amendment Act (IPOLA) 2002.
These Acts require all Local Government Entities in Queensland to charge sufficiently for the cost of providing infrastructure (Roads, Parks, Water, Sewage etc) to new developments and for building applications that may increase the use of the infrastructure network.

Role

The Business Systems Analyst/Team Leader was responsible for the development of all software designs, managing the software development life cycle through to completion and supervising up to four developers.

Accenture - Courts Modernisation Project (CMP) Phase Four

December 2001 to August 2002
Brisbane, Queensland

Position

Development DBA & Senior Analyst/Programmer (Conversion)

Project Description

Accenture have been working with the Justice Department on the QWIC (Queensland Wide Integrated Courts) system. QWIC is a full case management system flowing from Police Bench Charge Sheets (a summary of alleged offences) through to case scheduling, verdict management and penalty enforcement. Phase four is a major enhancement of the financial components of QWIC, implementing stricter debtor and creditor control and more fluid reporting parameters.

Role(s)

Senior Analyst/Programmer (Conversion)
Initially worked on functional analysis and helped determine the conversion requirements.
This conversion was to populate the debtors and creditors of the system with balances and to determine the cash at bank values.
From the beginning of February I became the development DBA.

Development DBA
The development DBA role was one of the three roles in the Application Architecture Team. The team reviewed all functional requirements and detailed designs. Major design decisions were brought before the team during the detailed design phase.
The development DBA was responsible for documenting the new datamodel, for building the datamodel scripts, reviewing all SQL and performance tuning. The development DBA was also heavily involved in version and release management.

Accenture - Courts Modernisation Project (CMP) Phase Three

March 2001 to December 2001
Brisbane, Queensland

Position

Senior Analyst/Programmer

Project Description

Phase three was a large component consisting of an interface to SPER (State Penalties Enforcement Registry). This major enhancement enables QWIC to pass debts (fines and other penalties) to SPER for enforcement.

Role(s)

Involved in the functional designs of the input and output modules. Also shared responsibility for the design of the system architecture. Responsible for all of the C and Pro C in the interface and large amounts of PL/SQL containing the primary business logic for the interface.
During system testing and test scripting the Senior Analyst/Programmer as responsible for advising and supporting the user acceptance test team.

IBM GSA - Telstra Alliance Global Connect

October 2000 to March 2001
Brisbane, Queensland

Position

Analyst/Programmer

Project Description

IBM Global Services is the services division of IBM Australia.
Contracted by IBM as part of team to provide software development and maintenance to Telstra Global Connect.

The team developed and maintained software to track telephone switching assets in telephone exchanges. The software determines when the switching capacity at telephone exchanges will need increasing, schedules those increases and tracks the progress of the work orders to increase capacity.

Role

Four systems are developed and maintained, NCFA, Stockman, SIS and SNI. Primary responsible for NCFA and Stockman, which are developed in Java and use the NetDynamics (now called Sun One) Application Server. NCFA and Stockman are developed on Windows NT and system tested, user acceptance tested and deployed to UNIX (Solaris). NCFA was a custom built work flow application

Accenture - Courts Modernisation Project Phase One

March 1999 to October 2000
Brisbane, Queensland

Position

Senior Analyst/Programmer

Project Description

Accenture have been working with the Justice Department on the Courts Modernisation Project.
The conversion cell was responsible the conversion of the legacy mainframe data to an Oracle System. The conversion cell was required to have a detailed knowledge of the entire functionality of the new QWIC (Queensland Wide Integrated Courts) application and had a large amount of responsibility for system integration.
The Justice Department placed a high level of importance on the conversion process.

Role(s)

Conversion Cell
Contracted to act as a technical expert and business analyst in the conversion cell.

Involved in the full conversion SDLC including design, build, test and execution

Technical Architecture Team
During down times in the conversion design/build/test/deploy cycle I was used by Technical Architecture team and to do some Oracle Spatial work and other Oracle tasks including performance testing. The Geographical Information Service (GIS) was used in QWIC to validate names and addresses and uses the MapInfo data set and the Oracle Spatial product.

Jupiters Technology - Keno on the Web

March 1998 to March 1999
Brisbane, Queensland

Position

Lead Analyst/Programmer

Project Description

Jupiters Technology developed a web interface into the Jupiters Keno system. This software enabled players to participant in Jupiters Keno via the Internet.
Jupiters discontinued this project after the software was complete due to uncertainty of Commonwealth Government Regulations concerning Internet Gaming.

Role

The Lead Analyst/Programmer was the lead role in developing the user and functional requirements, prototyping the product and giving user demonstrations.

Jupiters Technology - Keno Information System (KIS)

January 1997 to February 1998
Brisbane, Queensland

Position

Lead Analyst Programmer

Project Description

In January 1997 the KIS (Keno Information System) was commenced. This project was to load game data into an ORACLE database to allow for historic reporting of gaming activities.

Role

The Lead Analyst Programmer was responsible for the design, build and delivery of the KIS product.

Jupiters Technology - Real Time Transaction Processing Engine

January 1996 to March 1999
Brisbane, Queensland

Position

Analyst/Programmer

Project Description

Jupiters Technology provided software and hardware engineering for the Jupiters KENO project. This twenty million dollar project enabled clubs, hotels and the TAB to play the game of KENO over a wide area network. Keno is a game where a draw of 20 balls occurs every three minutes. Punters bet on the ball draw.
A team was assembled in December 1995 to write a real-time transaction processing system in C on a SVR4 Concurrent UNIX Machine.

Role

Analyst Programmer under the direct supervision of the Project Team Leader. Duties covered the entire SDLC

Comalco Smelting Business Unit Systems Group - Case Tool Translation

December 1994 to December 1995
Brisbane, Queensland

Position

Trainee Programmer

Project Description

In late1994 Comalco Smelting changed case tools. The unit switched from Excelerator/RTS and Excelerator/Windows to System Architect following a company wide business decision. The data dictionary of existing designs needed transferring to the new tool. A solution was implemented to solve this business problem.

Role

Trainee Programmer produced all deliverables required for the entire SLDC.

Forest Lake College - Life Long Learning (Adult Education)

August 1999 to Current
Brisbane, Queensland

Position

Casual IT Trainer

Background Description

Forest Lake College is a Prep to 12 College run by the Anglican and United Churches in Forest Lake. Life Long Learning is an initiative of Forest Lake College, designed to offer Adults in the Forest Lake catchment area Adult Enrichment classes. Some of the more successful classes are computer classes.

Summary of Skills Obtained From Tutoring

Gained experience in preparing course work and being able to explain technical concepts to people of varying technical ability. Experience in public speaking and training.

Freelance Sound Engineer

1986 - 1994
Brisbane Queensland