Full List of All Work Done

Industrial Sector	Services Rendered
Banking, Financial, General Insurance	Project 1 Oracle PL/SQL development and support of Retail Banking Central Processing application Create performance tuning framework (tkprof, sar, vmstat, DBMS_PROFILER) 8i to 9i upgrade to 9i (5.5 Tb database) High pressure, short time scale environment Oracle 8i, XML, Solaris 8 Project 2 Full life cycle development of summary tables and reports showing key business performance indicators for use by the company board of directors. Data cleansing - wrote a PL/SQL package to clean up name fields in the warehouse. Optimise existing reports (Reports 2.5) to run faster. Coding and testing of Head Office Dashboard reports showing periodic claims figures. Analysis, coding and testing of reports providing Annual DTI returns.
e-Government	Project 1 Implementation of 11i CRM, HR and Payroll, Financial, iProcurement, Remedy, SX3 Revs & Bens, Comino. Plan, install, clone, administer, support, troubleshoot, patch all instances. Customisations and development of add-on modules in Forms, Perl, Reports, JSP (MVC model). Work closely with end users and functional consultants to understand needs and diagnose problems. Skills transfer to trainee DBAs meant copious documentation. Set up Quick Address, Scripting, Workflow, Bitmap Printing, Self Service, Email (sendmail), OTL, Concurrent Processes. Work closely with Sun engineers and system administrators to plan the live environment architecture. Implement Sun Cluster 3.0 to work with a two-tier 11i applications configuration. The cluster components were a mix of Cluster 3 Database Services, and GDS using custom built shell scripts. Use TCA APIs to write routines for migrating customer and address data from a variety of systems into 11i HR, integrating QAS to cleanse the address data. Work with SX3 to install iWorld and CurrentWorld Revenues and Benefits system. Provide production support for 11i CRM and Remedy, writing scripts to monitor all services. Liaise with senior managers to plan go-live strategies and co-ordinate activities to ensure a smooth roll-out. Project 2 Provide support for an e-government project implementing Oracle 11i CRM with LG45, LGFF, TCA, 9i Integration Hub extensions. Setup backup solutions using Tivoli, produce documents on backup and restore test procedures as instructions for client staff. Patching, cloning. Advise on platform setup, disk layout, housekeeping procedures, etc (AIX 4.3, Tivoli, 11.5.7). Project 3 Produce a DBA Toolkit to enable full administration of SX3 iWorld instances via menu driven shell scripts. Remit was to produce something flexible and extensible to other areas. Document all work done to enable client staff to understand, use and amend toolkit. SX3 iWold Revs & Bens, Housing, Solaris 8, Veritas NetBackup, Oracle 8.1.7, Forms 6I, Apache. Advise on platform setup, disk layout, procedures, etc. Project 4 Short term contracts to help deliver quick win solutions for long running problems Work closely with users to design appropriate solutions. Remote development to pre-agreed timescales so that users could be shown solution during site visits. Oracle 9i, Forms 6i, Reports 6i, Oracle RLS, Solaris 8 Document solution for effective handover.
Local Government	Development Services: Migrated Unit Counts MIS to a UNIX/Oracle system from the mainframe. (SQL*Forms v3, Pro*C, COBOL, Ingres). Analysis, design & coding of the Admin. & Documentation system (Paradox, Windows) to allow electronic querying of departmental procedures. C and Forms programming standards - research, definition, documentation and building the infrastructure (SCCS, directory structures, libraries, forms reference libraries, stored procedures). Co-ordinated SQL*Forms v2.3 to v3 conversion - wrote UNIX scripts to automate the process. Analysis, design, coding & testing of systems (Housing, Environmental Health, Costing, Charging & Time-Recording, Social Services) using Oracle, SQL*Forms v2.3, v3, RPT, PL/SQL, Pro*C, shell scripts. Community Charge, Benefits, Housing & Time Admin. projects (Bull DPS-8000, COBOL, GCOS, TP8, DM-IV).
Utilities (Gas, Electricity)	Billing and Customer Information Systems Developmnent: Developed time recording and charging system (for in-house use) using Forms 4.5. Pre-implementation support for overseas clients (based in Orlando, Richmond, and Jamaica). Reported directly to senior executives from both SCT and the clients. Developed forms, reports and processes comprising the Voids sub-system, and GIS sub system on the North West Water project. Researched strategies to improve performance of batch processes (multi-processing, tuning, etc.). Produced tools (shell scripts) to manage local tables, and to automate unit test plans. Performed quality and standards reviews. Analysis, design, coding, testing & implementation of a 'CRUD Matrix' impact analysis database. This involved writing complex C/Pro*C programs to analyse any source code (Forms, Pro*C, SQL, etc.) and build a database showing the interaction between modules and database entities. Forms were written to allow querying of the database and cross referencing with the data dictionary and specification documents control data. 1998 Electricity De-Regulation: Data Migration (PL/SQL packages) from an old Meter Operator system to a new one. Develop version control, tracking and release tools & procedures to enable easy delivery of client and server software to any number of environments. Build and test the system using Developer 2000 (forms 4.5, reports 2.5), PL/SQL (packages, triggers), Pro*C and UNIX. Produce technical specifications for coding. Using Designer 2000, design the Oracle database for the system. Advise other projects as to most suitable technical solutions to their questions. Liase with designers of other systems to produce interface requirement specifications (including the Auto Invoicing Interface of Oracle Financials). Work with business analysts to produce functional specifications for the system.
Payroll	Implement Delphi Freedom payroll package (from Midland Software) Ingres, UNIX, ESQL-C, C
Call Centre - Customer Service Management	Full life cycle delivery of a billing/payments/sales ledger system for a call centre. Later enhancements to web enable, with email billing, email correspondence (www.amerada.co.uk). Oracle 7.3.4 (8i when web enabled, replication), UNIX (AIX), Windows NT. Designer 2.1.2 used as per Oracle CDM to support analysis, design and development (functional hierarchy, process modelling, data modelling, application design, generation). Analysis, design, build, QA of account set up, maintenance, payment method, call handling and system integration/messaging functions. Backend interfaces & other processing written in PL/SQL, Perl, SQL Loader, shell and Pro*C. Extensive use of server side PL/SQL in packages and triggers to achieve good client-server partitioning. Front end built using Designer 2.1.2 and Forms 5 with HeadStart to achieve 100% generation. Defined and implemented operational procedures for production system. Developed a standalone version used by Ventura to handle Freeserve customer calls.
Development Standards	Oracle RDBMS, SQL*Forms, Oracle*Forms, Oracle*Reports, Pro*C Shell Scripts, sed, nawk, make, SCCS, C
e-Commerce	Full life cycle design, develop, implement, support, enhance an e-commerce system aimed at SMEs. Second phase to deliver call centre functions and a billing system. Included CTI data handling. Oracle 8i, Linux, Apache (HTTP, SSL, virtual hosting), sendmail/procmail (virtual email), AMANDA (backup). Web front end written in HTML, JavaScript, Perl CGI integrating with PL/SQL APIs to/from the database. Plan, commission, configure production servers (separate web, mail, database hosts). Work closely with ISP (Demon) to implement security, DNS configuration.
Telecommunications	Produce high level designs of e-commerce systems, with a view to rationalising a plethora of systems and hardware platforms. Provide technical out of hours support for a Virtual Call Centre system using Oracle 9i RAC
Processing and Manufacturing	Perform healthcheck of environments Implement cloning procedures Apply 11.5.9 Maintenance Pack to test and production (Win 2K)
Back To Oracle RDBMS and Tools Services