• Migration of over 200 batch scripts from a Windows 2000 Server to a Linux based server.
• Provide support for current and new data warehouse pre and post migration. Investigate batch failures; write and tune SQL data extracts; produce bespoke application reports using Oracle Discoverer and Excel with ODBC data connections; Shell scripting to automate SQL scripts; Liaison with users and IT manager in the event of failure and rectification.
• Data mapping between current and new data warehouse.

• Install Oracle 10g on Windows 2000 servers and migrate databases from 9i to 10g.
• Departmental Application Upgrades
• Application Support Investigate program failures; write SQL data extracts and loaders; produce bespoke application reports using Ingres Report Writer, Shell scripting to automate SQL scripts and notify support staff of failure or success.
• Design, Code, Test & Implement various small projects.

• Enhance and develop the company’s front-end Forms 9i application and back-end systems. Development included changes to Oracle packages, screen layouts, validation and functionality as well as Unix shell script changes.
• Code Review and sign off of other developer’s changes.
• Testing including Unit Testing, System Testing and UAT Testing Support.
• SQL Scripting to identify test data cases and for data verification following testing cycles.
• Exposure to Oracle APEX by working through the Oracle Tutorial and system testing one of the larger in-house developments utilising this technology.

• Enhance and develop interfaces between the Council’s revenues systems (Business Rates, Council Tax and Housing Benefits), Financial System (Powersolve), Cash Receipting System (Icon) and external Parking System (Chipside).
• Write HTML wrappers around standard system outputs (e.g. Invoices) to enable e-mailing to external clients.
• Design and development of a menu system to automate various help-desk support functions.
• Application support – Investigate program failures; write SQL data extracts and loaders; produce reports.
• DBA Work - Oracle RDBMS upgrades on Windows NT Platform, backup Oracle and Ingres databases, Copy Ingres databases from live to test.
• Plan and implement application upgrades.
• Reporting progress to project manager and deputising for project manager in his absence.
• Coaching new and existing team members in new procedures and installation issues.

• Monitoring Performance Targets, training and personal development plans and managing workflows for various team members. Mentor and coach new members of the team.
• Assist Project Manager on small to medium sized projects, Provide project status reporting to project management team.
• Change Control – Act as sign-off authority for change requests originating from different project teams.
• Testing - Liaison with the testing teams to ensure the application’s stability and integrity.
• Specific Projects
- Lead a set of developers on a 10 month project to migrate the in-house system from Oracle Forms 4.5 to Forms 6i
- Introduction of several new ‘brands’ onto the Churchill system to comply with the required specifications.
- Lead the team responsible for front end changes to the Churchill application as part of a wider migration project to transfer the Churchill Insurance Portfolio to Direct Line following acquisition by RBS Group.
- Design, development, document and roll out of a company wide (2000 user) generic menu system.
• PRINCE2 Practitioner - Status achieved in October 2004.

• Senior member of a customer based team of 6 responsible for all Unix/Oracle/Ingres development.
• Successful introduction of Oracle Developer/2000 as the environment for all new system developments.
• Monthly Progress Reporting and Project Board Attendance
• Identification of requirements and commissioning of training
• Systems Analysis, Program Design, Production, Testing and Implementation
• Implementation of a new housing system and providing front-line support for the Oracle Financials System V10.7 (Including User Support, Change Management and Patch Installation)
• Systems Analysis, Program Design, Production, Testing and Implementation
• Supervision of two new team members from different technological backgrounds
• Database Administration
• Key role in the implementation of Oracle Financials on a customer site.
• Development of interfaces for feeder systems, automation of standard processes and development of bespoke reports and data manipulation scripts.
• Provided backup support for a housing system on additional sites including local government and housing association customers.
• Use of standard Oracle tools for implementation and development (PL*SQL, SQL*Plus, Forms, & Reports)

• Maintenance programmer on a variety of the Council’s primary computer systems.
• Support provided for implementation of Government legislation such as Community Charge, NNDR and Council Tax against tight deadlines.
• Through part time study attained an HNC in Computer Science, with a distinction for programming.
• Skills utilised COBOL, Easytrieve+ and JCL in an IBM Mainframe environment.