Designed and Developed Oracle Data Mart for RAP assessment Management Reports for Enfield,Harringey and Barnet

Developed ETL processes to extract data from Microsoft Access to Oracle Datawarehouse using PL/SQL and SQL*LOADER

Developed Statutory RAP Assessment Reports(Social care) using Oracle Discoverer and deployed via Oracle Portal

Prepared Requirement Analysis Documents for reporting requirements for new clients to the in-house Datawarehouse System TIGER

Performed general support duties and minor database administration tasks

Development Environment: WINDOWS NT, UNIX, ORACLE 10g, Oracle Discoverer ,Oracle Portal, Oracle Business Intelligence, TOAD.PL/SQL

Migrated .Legacy Expert Witness System from Oracle Forms 4.5 /Reports2.5 to Oracle Forms 10g release 2 /Oracle Reports10g Release 2

Analysis, design and development of major enhancements to the migrated Expert Witness which included customer upgrade, transaction auditing, .and developing PL/SQL interfaces to feed data to Sweet and Maxwells Legal Hub , a web front end developed in XML

Organised Design Walkthroughs with End users, Technical Team and Middle Management
Co-ordinated Unit Testing, Regression Testing and Systems Testing with Clients

Development Environment: WINDOWS NT, ORACLE 10g Release, FORMS 10g, Reports 10g, TOAD.PL/SQL

Developed enhancements to NHBC Fusion System using Oracle forms/Reports 10g Release 2 ,Oracle 10g database and pl/sql

Supported various systems within Field Based Services Division covering Oracle mobile services, PDA and Fusion warranty

Resolution of software bugs raised through helpdesk system.

Adhoc script creation for reporting purposes

Development Environment: WINDOWS NT, UNIX, ORACLE 10g, FORMS 10g, Reports 10g, TOAD.PL/SQL

Designed and developed management reports on Network performance on BT Wholesale database using Reports 9i.

Reported on subscriber usage of BT Broadband enabling BT wholesale to target Broadband business more profitably

Established automated scheduling of the reporting process.

Reduced runtime of existing long running reporting by 50% by performance tuning software.

Development Environment: WINDOWS NT, UNIX, ORACLE 10g RAC, FORMS 9i, Reports 9i, TOAD.PL/SQL

Developed major enhancements for an Oracle based automated Army Supply chain system (GLOBAL).

Mainly involved in the analysis, design, specification and development of enhancements to Screens and Reports using Forms10gi/Reports 10g.

Wrote resource assessments on user requirements, code reviewed work of team members and resolved software bugs raised through Helpdesk system. Co-ordinated UAT and regression testing with clients

Development Environment: WINDOWS NT, UNIX, ORACLE 10g, FORMS 10g, Reports 10g, TOAD.PL/SQL

Supported and wrote enhancements for various Oracle based applications BODS and OLIVER using Forms10g/Reports 10g and PL/SQL. These applications are used to manage bus routes and schedule journeys

Migrated data into Oracle 10g from four legacy systems and developed software to cleanse data.
Involved in all aspects of the project life cycle

Development Environment: WINDOWS NT, UNIX, ORACLE 10g, FORMS 10g, Reports 10g, TOAD.PL/SQL

Developed 26 new run-time reports on the Social Services Client Index reporting database using Reports 6i
Amended existing reports and Front end Screens using Forms 9i/Reports 9i to take account of identified faults and changed requirements. Coordinated regression testing, user acceptance and systems testing of software

Developed and implemented Major system critical enhancements to Insurance Claims Settlement system Portia.

These enhancements centred on specification, design and development of
Screens using Forms 9i on an Oracle9i Database, new database packages and triggers and
Full unit, system and regression testing of the system.

Fixed general software bugs rose through Helpdesk Support for Property Insurance Modules

Development Environment: WINDOWS NT, UNIX, ORACLE V9i, FORMS 9i,Reports9i , TOAD.PL/SQL

Migrated data of National Screen Services Sales, Invoicing and Inventory system from Microsoft Access to Oracle 9i.

Re-development of National Screen Services Microsoft Access Screens/Reports to Forms 9i/Reports 9i. I developed the following core modules: - Stock Entry, Distribution, Dispatch, Order Entry, Reports and Invoicing.

Documentation of Change Management,Software Configuration and Coding Standards for use in subsequent GAP Oracle projects using the current project as a pilot project.

Coached and mentored junior members of the team, with limited experience of Oracle Products

Development Environment: WINDOWS NT, UNIX, ORACLE V9i, FORMS 9i, Reports 9i, TOAD.PL/SQL, SQL*LOADER

Delivered on time, a backlog of major enhancements to screens (Oracle FORMS 4.5/5) and reports (Oracle REPORTS 2.5/3) centring on Re-insurance Run-Off Environment.

Upgraded over 600 modules from Forms 4.5/5 to Forms 6i and Reports 2.5/3 to Reports 6i.

Supported six major in-house Reinsurance/Insurance Claims Settlement systems developed in Oracle, resolving problems raised by users via helpdesk, configuration management, release of software into Production, Systems Administration.

Development Environment: WINDOWS NT, UNIX, ORACLE V8i, FORMS 4.5/5/6i/Reports2.5/3/ 6i, TOAD,PL/SQL