Profile

·        Enthusiastic, reliable and very experienced Professional, [snip] possesses an excellent range of skills and abilities which cover the full project lifecycle; Project Management, Team Leading, Business and Systems Analysis, Design, Development (Unix & Oracle specialist), Testing, Implementation & Support. 

·        Focussed on results, [snip] has a “can-do, will-do” attitude and always produces quality deliverables to deadlines. 

·        [snip] is an effective communicator, able to interact and get on with Permanent and Temporary staff at all levels, in any organisation, including liasing/negotiating with third-party suppliers.  

·        In addition, [snip] often undertakes projects on behalf of a Consulting Business of which he is part owner. Typically this involves, Tendering Proposals, Internet Marketing Strategies, Analysis/Feasibility Reports and code changes/support for software (Oracle PL/SQL) previously developed for clients. 

Key Skills

·        Flexible and pragmatic, able to work alone or in teams.

·        Recruited and managed teams of between 2 and 14 people.

·        Produced and controlled Project plans, forecasted costs and budgets in addition to developing tendering and proposal documents.

·        Very versatile, able to manage Projects and resources, able to produce User and Functional Requirements Specifications and Technical Designs/Specifications and Implementation plans.

·        Familiar with UML and Object-Orientated Analysis and Design (RAD/RUP) methodology which enhances existing extensive experience in Structured Systems Analysis & Design Techniques (SSADM).

·        Expert in Client-Server based systems involving design and development in RDBMS (ORACLE 8i, Ingres and some Informix) and UNIX/LINUX technologies (e.g. PL/SQL, SQL, SQLPLUS, UNIX Korn Shell Scripting, and PERL/AWK/SED etc.)

·        Production of Test Strategies, Conditions, Test Specifications and Test Data for User, Functional/System, Technical and Performance Testing, incident management and change control.

·        Additional Technical Skills include; XML, Business Objects, T.O.A.D, T-Plan, Visual Basic 6/ADO, Tivoli Maestro, Perl/CGI, HTML, AS/400 (iSeries) and CASE tools - ADW/IEW, Systems Engineer and ARGOUML. 

Contracts 

Retail Banking

Feb 2005 – Present    Senior Business Analyst/Project Manager  (Workflow)      [snip]

·         Last major project involved a 400Gbyte document image migration from two separate source systems (including an external 3^rd Party) into the corporate document storage/retrieval system. Activities covered the full life cycle including project planning and tracking, specification, design, technical specification/refinement, testing and detailed implementation plans. A major proportion of the work was co-ordinating with several project managers, technical and operational staff to achieve this.

·         Working on the Common Processing System (CPS is Workflow Management/document imaging) based on a clustered Oracle/Unix, Web Brower based platform. Liaising closely with Business users (at all levels) to refine and advise on Business Requirements ahead of translating those into solutions via Functional Specifications and Technical Designs. Identification and estimating of work required for planning/control.

·         Providing information to Developers/Testers and assisting with Data Definitions, Product Testing and liasing with Implementation teams. Part of last release also involved defining, developing and loading reference data in database tables, allowing 3 additional key business areas (Saving Operations/Mortgage Services and Specialist Banking) onto the system. This was based around SQLLoader/SQL and involved complex referential relationships spanning a significant number of rows of data and included development changes to the web based workflow interfaces. 

July 2004 – Feb 2005             Test Manager            (E-Banking)                           [snip]

·          Managed a team of 7 Staff undertaking on-line E-Banking System/Product Testing. (VB/ASP Front End/W2K3 backend + SQL Server/Oracle databases)

·          Production of Test Strategies, Environment Specifications, Test Data Production, Data Loading and Control.

·          Planning and status reporting, defect tracking and Project Management also involved extensive use of Test Director,

·          Liasing with Test Automation Team Specialists, User Test Managers/testers and other teams involved.

·          Use of Test Director and Automation Tools QEP (both for data load/set-up and for testing) 

Share Dealing

Feb 2004 –June 2004            Systems Analyst                                            [snip]

·          Testing of a new product Pro-Quote, Real Time share dealing system available via Subscription based Web Services (XML/Java).

·          Production of Functional Specifications for the public interface to the Web Broker system (Internet based Share Dealing).

·          Analysis/Design and Testing on Consolidated Tax Vouchers project (AS/400)

Utilities

May 2003 – Feb 2004            Technical Project Manager/Test Manager              [snip]

·          Production of Test Strategy for Data Migration Project taking Ingres / HP-UX based data and loading (ETL) to an Oracle 8i / Solaris 8 Platform.

·          Planning, managing and assigning work for a team of 5 people, reviewing progress and analysis of functional design specifications to produce test conditions/scripts/data etc.

·          Production of detailed implementation plans.

·          Liaising with external Auditors ([snip]) regarding technical aspects of the project.

·          Regular progress meetings and reviews with [snip] (Software supplier).

·          Analysis of data migration issues, problem definition and liaison with Business users to identify solutions.

·          Defining technical tasks and assisting Unix admin and DBA staff in the building of test environments for UAT, System, Regression, Performance Testing and the target live environment (Sun V880/ SAN storage).

·          Design, development and deployment of custom tools (based on Korn Shells and PL/SQL procedures) to improve efficiency of processes, data loading, data analysis and performance tuning activities.

·          Control of Configuration/Releases Management for test and live patches across 16 database instances. 

Oct 2002- Apr 2003      Data Warehouse Test Analyst        [snip]

·          Testing of Java based Web Browser screens for Invoice Billing processing based on UML Documentation.

·          Planning and preparation of Data Warehouse Testing based on Unix and Oracle 8i. System was based on Oracle Warehouse Builder and controlled by Java/Unix Korn Scripts accepting feeds from over 20 live interfaces.

·          Test scripting and execution-covering interfaces into the Data Warehouse Extract, Transform/Load (ETL), and movement up to enterprise & reporting marts. Extensive use of TOAD & SQL for results checking and evidence capture.

·          Regular progress reporting, incident raising (T-Plan) and tracking, regression testing and sign off preparation.

Share Dealing

Apr 2002- Aug 2002   Systems Analyst                                [snip]

·          Analysis and Design work on Bonds Trading Project, Enhanced Web Broker Content (XML based News & Research feeds project and Self-Investment Personal Pensions Schemes (SIPPS).

·          Analysis of FIGARO equities trading system (iSeries AS/400) to produce a usable data dictionary.

·          Advice and guidance to Project Managers & Analysts on Projects and Methodologies.

·          Investigated requirements and products for cross-platform Change Control/Configuration Management/Code and Release Control (Main Platforms involved AS/400, Lotus Domino, Solaris, Websphere and NT).

Utilities

Feb 2002- Apr 2002   Consultant/Software Developer        [snip]

·          Tendered for fixed duration project and delivered it within given estimate.

·          Enhancements to Liquidated Damages Monetary calculation system to enable multi-company operation (across 6 in the group).

·          RAD project life-cycle undertaken to define and make changes (All developed in Oracle 8i PL/SQL packages and procedures and UNIX Korn/AWK scripts)

·          Data take on and verification of accurate results. 

Dec 2001- Jan 2002   Team Leader                          [snip]

·          Planning and impact/change analysis, update of test plans, test cases, test data for the NHHDC system.

·          Liasing with permanent staff and Logica staff to ensure team of 6 delivered tested code through system test.

·          Configuration management with UNIX Admin/Oracle DBA’s on how to set up test databases for the application. 

Banking

Sep 2001– Dec 2001 Technical Test Analyst          [snip]

·          Based around IBM’s Banking Data Warehousing model (System 1 under Oracle and Dynix), provided test plans for the Mortgages area data feeds.

·          Technical appraisal and suggested improvements on PL/SQL and data load performance. 

Utilities

Feb 2001– Jul 2001    Analyst/Developer                 [snip]

·          Working on the Liquidated Damages area, delivered the following, based on the user business requirements; Technical Options Document (detailing options, change impact, costs and benefits). Logical Design. Physical Design (based around UNIX & Oracle 8i/PLSQL). Program Specifications to meet Physical Design.

·          Coded, tested and Implemented KORN Shell Scripts and Oracle PL/SQL packages and procedures for building the database (DDL) and the application.

·          Migrated historic data into the system and implemented the working system into Production. The system delivered the ability to accurately calculate and track millions of £ owed between major utilities companies. 

Banking

Nov 2000 – Feb 2001 Technical Consultant             [snip]

·         Performance, Resilience and Operational Proving (PROP) Testing Approach Strategy.

·          Evaluation of Automated Testing Tools (Performance and Functionality).

·          Requirements definition for a Test Lab Environment (Covering IBM Mainframe through Client-Server architectures).

·          Assisted in defining and documenting Change Management/Control and Testing Procedures.
 

Utilities

Nov 1997 – Oct 2000 Analyst/Programmer [snip]

·          Defining and building performance sized databases (Oracle 7 and 8) and populating with realistic data in order to carry out performance and stress testing (including Pool Scenario 6)

·          Testing using T-Plan e.g. Factory Acceptance, System Acceptance and User/Business Acceptance testing on NHHDC, EACAA, NHHDA and RMS (Read Management System) systems.

·          Change Control and Configuration Management of test servers & test databases, populating data therein. Software control (patches and full releases) and database upgrades.

·          Implementation and operational support of the 1998 systems - Monitoring overnight batch processing, raising incidents and resolution of problems, both technical and application.  

Summary of Permanent Roles
 

Prior to becoming a contractor, after graduating with a 2:1 Honours Degree in Computer Science, [snip] gained a wealth of experience working for the following organisations;  

 This is a summary of around 12 years permanent experience.