Curriculum Vitae 

Date of Birth:   16 April 1974  

Main Technical Skills: 

Employment History: 

Jul 2005 – Oct 2006       [snip] – Senior Developer 

Senior Developer 

I was brought in to provide expert oversight of a new system rollout and integration with legacy systems.

Also carried out maintenance to the existing systems and acted as a technical mentor to other team members. 

1. Management Reporting                       Jan 2006 to Oct 2006     10 months 

I am solely responsible for the delivery of a management reporting system delivering business critical information to internal customers.

Due to time constraints an initial release of the most important reports has been delivered based upon the production data model. I am now responsible for a strategic, longer term flexible solution where the data is extracted from the production systems and transformed into a star schema design using PL/SQL and materialised views. An abstraction of this design is then presented to the users in Business Objects.

Initially the requirements were poorly defined and I am now co-located with customers to gain a better understanding of their expectations and how the data will be used within the business.

As part of this project I am also mentoring a non-technical user in the use of Business Objects and SQL to deliver comprehensive reports. 

2. [snip]         Jul 2005 to Jan 2006      6 months 

The project had to deliver a suite of data interfaces in PL/SQL between an existing application and a new commercial sales order processing system (Klopotek), also remove redundant components from the existing Oracle Forms and Reports (version 6i) based application.

The data interfaces had to be created ensuring an audit trail is present and reducing complexity to ease future maintenance.

The creation of the interfaces has involved the understanding of the data models for the external supplier’s systems .

Technologies used to deliver this are Oracle 9i, SQL & PL/SQL, Forms 6i, Reports 6i, Business Objects, TOAD, Oracle Developer and PVCS (version control software).

The difficulties of this project arose from the very tight timescales (which were met), the complexities of understanding legacy code, a new data model, limited documentation and poorly defined user requirements.

The difficulties were also increased as the external supplier was German and careful communication was required to ensure clear understanding of business processes. 

Apr 2004 – Jul 2005       [snip] – Senior Developer 

In my role as senior developer for [snip] I was brought into the project after a contracted solution had failed to meet expected performance.

I was responsible for identifying problems in the work already completed and improve the performance whilst working in the confines of the existing architecture

I worked with Oracle’s performance and tuning utilities to make significant improvements.

To achieve this I used TKPROF and explain plan to identify underperforming code and improve the speed by creating new indexes, using hints, re-writing SQL and PL/SQL using parallelism, analytic functions, bulk collects and other relevant Oracle techniques.

In addition to my development responsibilities I provided technical advice to the technical architect, project boards and other team members on subjects including OLTP database design, OLAP database design, code tuning and appropriate use of tools and technologies. This advice resulted in changes to the architecture to segregate historical data to improve OLTP performance and establishment of detailed workshops to further investigate design issues.

I also performed briefings and presentations to the development teams on many of the issues mentioned above.

Alongside my main technical responsibilities I also conducted technical interviews as part of a panel and mentored more junior members of staff within Oracle database design, SQL, PL/SQL and Business Objects.

The technologies used for this project were Oracle 9i and 10g, Oracle SQL & PL/SQL, Business Objects (5 and 6), TOAD, PVCS (Version control software), Caliber RM and Mercury Test Director. 

Jul 2000 – Apr 2004       [snip] – Senior Analyst Programmer 

My primary responsibly was for the delivery of Business Information to all areas of the business.

I was part of a six-person team responsible for the design and implementation of a data warehouse (using a star schema design) to meet customer requirements.

The solution was initially implemented on an Oracle 7.3 database and was later upgraded to Oracle 8i.

Data was presented to the business via Business Objects universes and reports.

This project enabled me to experience the full software lifecycle as well as allowing me to expand my technical skills along side the skills of project management.

The technologies used for this project were Oracle 7 and 8i, Oracle SQL & PL/SQL, Business Objects and TOAD. 

Jan 1999 – Jul 2000       [snip] – Analyst Programmer 

My primary responsibly was for the delivery of Business Information to all areas of the business.

I was part of a six-person team responsible for the design and implementation of a data warehouse (using a star schema design) to meet customer requirements.

The solution was initially implemented on an Oracle 7.3 database and was later upgraded to Oracle 8i.

Data was presented to the business via Business Objects universes and reports.

This project enabled me to experience the full software lifecycle as well as allowing me to expand my technical skills along side the skills of project management.

The technologies used for this project were Oracle 7 and 8i, Oracle SQL & PL/SQL, Business Objects and TOAD. 

Sep 1997 – Jan 1999      [snip] - Analyst Programmer 

My main responsibility was for the support and development of in-house Oracle (version 7.3) based applications.  This involved developing reports, using Oracle Reports (versions 1.1 and 4.5), in response to customer requests and enhancing applications, using Oracle Forms (versions 3 and 4.5).  Both types of development required testing and implementation within the existing application. 

Aug 1996 - Sep 1997      [snip], Worcester 

Temporary drawing office assistant - producing customised maps from OS maps and engineering schematics to assist in the informing of customers affected by engineering work 

Jul 1995 - Aug 1996       [snip], Peterborough 

Export sales and purchasing administrator with additional responsibilities including system administration and assistance in selection of replacement computer system. 

Education: