Project Sql Server

Reginald Danford-Cordingley

+1-613-***-**** - **********@*****.***

Citizenship

British / Canadian - Security Cleared by the Canadian Federal Government

SKILL SUMMARY

I have over 25 years of Analysis, Design, Development, Database

Administration, Integration and High-Level Consultancy experience within

various industries including Financial Services, Telecoms, Pharmaceuticals,

Energy, Transport, Public Sector and Software. I am a Siebel 2000 and

Siebel 7 Certified Consultant with an indepth knowledge of EAI, Oracle and

SQL Server.

I have developed/enhanced Integrations between Siebel and BEA, Biztalk,

eMail, FTP, Flat Files, HTTP, MQ, JMS, Websphere.

TOOLS SUMMARY

Operating Systems: MS-Windows, Unix, VMS, MS-DOS

Applications MS Office, Siebel, Siebel Tools, EIM, EAI, Siebel

Analytics, Hyper-V

Databases Oracle, SQL Server, MySQL

Programming Visual Basic.NET, PL/SQL, TSQL, SQL*Plus, COBOL, Visual C#,

LINQ, Entity Framework, ADO.NET, ASP.NET, VBA, VBScript,

Jscript, Visual Studio.NET, HTML, Shell Scripts, Siebel VB,

eScript, NET Framework, PHP, MVC

Others Actuate, XML, MSXML, MSMQ, MQ Series, XMLSpy, TOAD,

hMailServer, Stylizer, SQL Examiner, SQL Data Examiner, SQL

Server Integration Services (SSIS), DTS, Visio, Enterprise

Architect, UML, SOAP UI, JMS, SQL Server 2012 File Table,

Vault, Visual Sourcesafe, VAX CMS, VAX MMS

WORK EXPERIENCE

Citizenship and Immigration Canada Ottawa

Jan/2013-Jun/2014

Siebel Integration Consultant (Contract)

. Onsite working as Siebel Integration and Configuration consultant on a

Siebel 8.1 Public Sector project known as GCMS on SQL Server 2008 R2.

This system manages Account, Opportunity, Contacts, Service Requests

etc for both Citizenship and Temporary Visa Applications to work,

study and visit in Canada, as well as Immigrate to Canada or apply for

Refugee Status in Canada

. Design/Development/Enhancement of Inbound/Outbound Web Services, MSMQ

and JMS with Internal and External systems such as FOSS (Internal

Mainframe system used by CBSA) and MEL (CIC Online Web Forms) as well

as external systems such as CBSA and RCMP.

. Design and Development of SQL Server 2012 File Table system to replace

Siebel File System to store EAI Queue Item messages which are used to

recover failed inbound and outbound messages. Development of Proof of

Concept for SQL Server 2012 File Table.

. Development of Inbound/Outbound Interfaces to eStorage SQL Server

Database to replace Siebel File System.

. Development of new interfaces to FOSS for New/Replacement Pemanent

Residence Cards

. Maintenance of existing interfaces for Admissibilities checks to

CBSA/RCMP for Security and Organised Crime etc

. Redevelopment of Refugee Interfaces to replace reliance on existing

FOSS Mainframe system

. Configuration of Business Components, Web Services, Tables, Applets,

VBCs, Views, Links, Workflows, Business Services, Data Maps, eScript,

EAI Value Maps, Dispatchers, JMS Receivers, MSMQ, JMS etc

. Support for Production and Testing issues, bug fixes etc

Swisscom Bern Jan/2012-Oct/2012

Solution Architect (Contract)

. Onsite working as Solution Architect at Swisscom on the Symphony

Project (Siebel 8.1 eCommunications), mainly involved in Feasibility

and High-Level Design of Integration Issues between Siebel and

"downstream" systems, such as Fulfillment, Workforce Management,

Assurance, Notification, Logistics etc via Tibco, in order to fulfil

Business Requirements

. Meetings with and Presentations to Stakeholders, End-to-End

Architects, Business Representatives, Solution Architects, Technical

Designers, Developers and Testers to resolve business requirements and

end-to-end issues affecting Siebel and other systems, mainly relating

to Orders, Quotes, Appointments, Products and Agreements during Order

Entry and Order Fulfillment.

. Solution Architect on the Vertical, Workforce Management, ACR500,

Instant Fulfillment and End-to-End Issues Projects. Usually assigned

to several projects at the same time.

. Lead Architect on the Revise Order Appointments project between Siebel

and WFM (Workforce Management) where I redesigned the end to end

interfaces between the two systems to resolve urgent business

requirements.

. Managed issues assigned to me and built consensus for their resolution

. Organised sessions and meetings to define and resolve issues and

present solutions

. Liaison on architectural solutions with decision-makers across

multiple systems in Swisscom IT and external suppliers, such as

Accenture and Oracle

. Use of the Enterprise Architect modelling tool to model the impact of

new projects across Swisscom's IT System Universe and to map Business

Requirements to IT Requirements to Projects and IT Components. Use of

Use Case Diagrams,Activity Diagrams, Sequence and Collaboration

Diagrams, Statechart Diagrams and Static Structure Diagrams.

T-Systems Budapest Feb/2011-Jul/2011

Integration Architect (Contract)

. Onsite working as Integration Architect on Localisation of Deutsche

Telecom Kernel system for Magyar Telekom. The Kernel was developed in

Germany and is being localised in Hungary, Slovakia, Czech Republic

and Macedonia. This system will use Siebel eCommunications 8.1 and

will link to back end systems such as Billing and Provisioning via

Oracle AIA and SOA BP.

. Worked on localisation of high level design of Order Execution Engine

which manages Orders from Siebel and passes them as appropriate to

Billing and SPA (Provisioning). Worked on solutions for Order

Decomposition and Product Decomposition in Order Execution based upon

Siebel Product structure. Worked on solutions for integration between

Order Execution and Enterprise Product Catalogue. Liaised with Product

Management team.

. Performed Gap Analysis with kernel staff from Germany for missing

integrations in Siebel-Enterprise Product Catalogue integration

. Liaised with Magyar Telecom staff to resolve business issues in the

design. Liaised with T-Systems staff in Germany to resolve design

issues.

. Developed powerpoint presentations to be given by Technical Architect

to high-level Kernel and Client personnel.

. Worked with representatives of the Low Level Design Team who were

working offshore in India.

. Wrote high level Test Cases for the different Scenarios for Order

Execution.

. Used Visio for High-Level Design of Order Execution scenarios. Use of

Use Case Diagrams,Activity Diagrams, Sequence and Collaboration

Diagrams, Statechart Diagrams and Static Structure Diagrams.

Yellow Pages Group Montreal Aug/2010-Feb/2011

Siebel Architect (Contract)

. Onsite working as Siebel Integration and Configuration consultant on a

Siebel 7.8 Media project on Oracle 10.2. This system manages Account,

Opportunity, Contacts etc for Yellow Pages advertising both online and

printed.

. Design/Development/Enhancement of Inbound/Outbound Web Services with

Internal and External systems such as Advertiser Centre and Sales Call

Form System.

. Configuration of Business Components, Web Services, Tables, Applets,

PDQs, View Links, eScript, Workflows, Business Services, Data Maps,

eScript, Runtime Events

. Deletion of Opportunities and Opportunity Products for previous years

using EIM

. Integration of Inline Base 64 File Attachments

. Developed COM-enabled Excel programs to load and modify Siebel data

Quorum IRB Seattle Mar/2010-Aug/2010

Siebel Consultant (Contract)

. Onsite working as the sole Configuration and Deployment consultant on

a Siebel 7.8 Clinical project on SQL Server 2005. This system manages

Account, Site, Clinical Protocol details for a FDA Review Board.

. Analyzed and resolved defects in an upcoming code release. Developed

new Workflows, Runtime Events; modified Applets, eScript, Views,

Business Components etc.

. Designed and developed new Screens, Views, Applets, Business Objects,

Business Components, Runtime Events and Workflows for new release to

manage Shipment of documents by Fedex, USPS etc.

. Deployed two new releases and migrated Repositories across multiple

environments up to Production. Used Excel COM spreadsheet to load

LOVs, PDQs etc. Modified production data as appropriate to support the

releases.

. Developed SSIS and COM projects for Data Migration to support new

releases.

. Advised client on Siebel Best Practises and Design.

. As the sole Siebel technical expert in the company, I reported

directly to the CIO and was responsible for all aspects of the Siebel

system.

Export Development Canada Ottawa Jul/2009-

Dec/2009

Siebel Integration Consultant (Contract)

. Onsite working alongside Oracle as an EAI/Configuration consultant on

a recent Siebel 8.0 Sales project on SQL Server 2005. This system

manages Company and Contact details.

. Analysed and resolved errors in the integration between Siebel and

Legacy application via Biztalk.

. Created and modified new Views and Applets for the Siebel Marketing

screens: Events, Programs and Objectives.

. As EDC operate a no-scripting policy, all modifications had to be done

using configuration only, i.e. Runtime Events, Workflow, Vanilla

Business Services, Data Validation, User Properties, Calculated

Fields, State Models etc.

Bureau Veritas Paris Nov/2008-Apr/2009

Siebel Integration and Scripting Consultant (Contract)

. Onsite working alongside Accenture on a new Siebel 8.0 Field Services

project on Oracle 10g to manage clients, invoices, contracts and

auditors for Bureau Veritas, a leading ISO Certification company for a

pilot project in Brazil.

. Developed Business Services to create Credit Memos and Credit Memo

Lines from Invoices and Invoice Lines.

. Developed eScript Business Services to provide Re-Indexation

functionality of Agreement Lines, Entitlements Service Requests etc to

account for increases in fees for multi-year contracts.

. Developed eScript to calculate Expenses and Logistics items which are

applied to charges generated by Siebel vanilla Order Management

functionality.

. Designed and developed integrations inbound and outbound of the Audit

Report with an external off line .NET application.

. The integration produces XML using Workflows, Integration Objects,

Business Services, eScript and Data Maps. Both inbound and outbound

integrations used XSLT to transform the XML. XML produced is emailed

to the auditors using the Siebel Outbound Communication Manager. On

Inbound, Lotus Notes writes the attached files to a temporary folder

which is then processed by the Inbound Siebel Workflow. This processes

each inbound folder in turn and then processes each file in the

current folder. Wrote eScript to generate the list of files and

folders to be processed by the Inbound Workflow.

Bayer AG Cologne Aug/2008-Nov/2008

Siebel Integration Consultant (Contract)

. Onsite to develop/enhance new Siebel 8.0 system on Oracle 10i. System

was an ePharma system to manage Health Care contacts and accounts in

France.

. Designed and Developed 9 inbound and 2 outbound integrations between

Cegedim Dendrite and Bayer using XML files transported by FTP.

. Designed and Developed 2 master workflows to call subordinate

workflows in correct order and handle logging, file handling etc

. Integrations were designed to be "loosely-coupled" along SOA lines

. Developed VB Script application to handle input/output file renaming

and zip/unzip for files to/from Cegedim

. Used ActiveX Data Control Applications in Excel and VBA to load/update

data in Siebel

. Development/Bug Fixing/Problem Analysis of Applets, Business Services,

Workflows, Business Components, eScript, Integration Objects, Data

Maps and EAI Value Maps.

iRelate (De Post) Brussels Feb/2008-Jun/2008

Siebel Integration Consultant (Contract)

. Onsite to develop/enhance new Siebel 7.8 system on Oracle 9i. System

managed Postal Points for De Post. Postal Points provide postal

services from shops, garages etc.

. Developed and tested integrations with REMUS and RCS+ systems using MQ

Series.

. Development/Bug Fixing/Problem Analysis of Applets, Business Services,

Workflows, Integration Objects, Data Maps, eScript, Business

Components and Workflow Policies

Deloitte Touche (Boxer) Stockholm Jul/2007-Feb/2008

Siebel Lead Developer (Contract)

. Onsite to develop/enhance Siebel 7.8 eSales system on SQL Server 2005.

System managed TV Channel Subscriptions. Took over the development of

several integrations including device-card management, direct debits,

addresses and Social Security Numbers and applications for Boxer

service from the Boxer.se website.

. Development/Bug Fixing/Problem Analysis of Applets, Business Services,

Workflows, Business Components, Web Services, EAI, External Business

Components and Personalisation

Bearing Point (Loyalty Partner) Munich Jan/2007-May/2007

Consultant (Contract)

. Onsite to develop/enhance existing Siebel 7.8 eLoyalty system on

Oracle 10.2 for Deutsche Bahn which tracked the issue of DB Cards for

discounted rail travel to passengers.

. Development/Bug Fixing/Problem Analysis of Applets, Business Services,

eScript, Workflows, Business Components, Web Services, eScript, EAI,

EIM, PL/SQL, Shell and SQL*Loader

Cap Gemini (Euroclear) Brussels Aug/2006-Dec/2006

Consultant (Contract)

. Onsite to maintain/enhance existing Siebel 7.7 eSales system on SQL

Server 2000.

. Installation of Siebel 7.7 Test environment across 4 servers including

Web Server with multiple object managers

. Design/Development/Testing of Archive Processes using EIM, DTS, TSQL

and VBScript to archive Service Request and Activity records nightly

to an Archive database on SQL Server 2000 and to purge other data from

Siebel.

Canadian National Railways Montreal Apr/2005-Aug/2006

Consultant (Contract)

. Onsite to maintain/enhance existing Siebel 7.7 eSales system on Oracle

9i (FAST)

. Developed and maintained eScript to handle Interline Quotes for

journeys across multiple Railway Companies

. Developed Siebel Applets and Views for both English and French Web

Clients, including public-facing Siebel-driven web site for online

quotes

. Designed and Developed ActiveX Data Control Applications in Excel and

VBA to load/update data in Siebel, invoke Workflows from Excel and

generate/read/update XML

. Integration Design of Workflows and XML Messages integrating Siebel

and Websphere for the Carload on the Web project.

. Design, Development and Testing of Workflows, Business Services,

Applets and Business Components to act as a back end for a Websphere

front end using MQ Series as part of Carload on the Web project.

CSC Sverige A/B (Vodafone) Karlskrona Aug/2004-Feb/2005

Consultant (Contract)

. Onsite to advise Vodafone of Siebel technical issues relating to

ongoing Siebel eCommunications 7.5 project being developed by

LogicaCMG on Oracle 9i.

. Setup Siebel 7.5 Server/Web Client/Tools environment; reviewed current

Siebel environment; represented Vodafone in technical discussions with

LogicaCMG; advised Vodafone on Siebel strategic, technical and

architectural issues relating to Siebel configuration, performance,

integration, migration and analytics.

. Advised Vodafone on Siebel 7.7 feature set and technologies

. Liaised with Siebel Expert Services and TAMs

. Gave a presentation to CSC staff on Siebel Architecture using

Powerpoint

. Reviewed Siebel Work Estimates and Timeplans provided by LogicaCMG on

behalf of Vodafone Sverige

. Provided estimates for the amount of work required for Siebel

implementations at Vodafone Sverige AB to CSC

Vodafone UK Plc Stoke-on-Trent May/2004-Jul/2004

Consultant (Contract)

. Onsite to maintain existing Siebel 6.3 eCommunications system on

Oracle 9i; developing/amending Siebel VB in Applets, Business

Components, Business Services, eScript, etc.

. Developed Change Requests and Resolve Bugs in Live System

. Developed performance tests in Siebel Tools using Business Services

and Asynchronous Workflows to prove the existence of a memory leak in

Siebel Workflow

. Use of Siebel ksh utilities to maintain repositories and migrate

Siebel to different environments

. Reviewed existing Business Service/Business Component code for memory

leaks, bad code etc and recommended improvements

Ementor A/S (Debitel) Copenhagen Dec/2003-Feb/2004

Consultant (Contract)

. Worked onsite to develop integration between Siebel 7.5

eCommunications for Mobile Carriers on Oracle 8i and BEA using

WebServices, EAI, Business Services, Integration Objects, SOAP, WSDL,

XML and eScript.

. Creation of new XML files using XMLSpy.

. Developed a generic eScript Business Service to handle selects,

inserts, updates and deletes for a property set.

. Developed and tested Inbound and Outbound Web Services between Siebel

and BEA.

. Managed Siebel Integration team and liaised with other project teams

with regard to progress and problem resolution. Developed web page to

track progress and issues and publish WSDL files.

Ceridian Canada Inc Winnipeg Sep/2003-Oct/2003

Consultant (Contract)

. Built enhancements to client database using Siebel 5.5 on SQL Server

7.0 using Siebel VB.

. Design, development and enhancement of both new and existing Views &

Applets and code.

. Development of new Actuate reports. Development of Workflow and VB

Script to extract data from Siebel & pass it to a Web Service using

the Siebel ActiveX Data Control.

. Creation of XML files in code using MSXML and DOM.

Online Business Systems (Sprint) Toronto Feb/2003-Aug/2003

Senior Technical Architect

. Onsite on a project to pass Order & Account information from Oracle to

Siebel 6.0 running on Oracle 8i using EAI & HTTP with WebSphere as a

middle-tier

. Advised Online and Sprint and liaised with Siebel TAM to resolve

architectural and technical issues

. Developed prototype using EAI, Workflow, Siebel eScript and Business

Services to demonstrate the potential solution and provided estimates

for implementation from a Siebel viewpoint.

. Analysed the existing (heavily-customised) Siebel Business Components

at Sprint with regard to running them in server-mode rather than

client-mode and suggested code changes to enable this

. Installed, setup and administered Sprint Oracle Development and QA

databases and Siebel environment in new environment for use by Online.

DBA for Oracle database managing Data Files etc.

. Acted as a Pre-Sales Consultant.

Noetix Inc Seattle Aug/2002-Jan/2003

Siebel Integration Consultant (Contract)

. Consulted and advised Noetix on improvements to their Noetix Views

software in order to improve its integration with Siebel 7 and Siebel

7.5. Noetix Views & Noetix Web Query allow users to create ad-hoc web

reports from the Siebel COM Business Objects Layer.

. Advised Noetix on the Siebel Data Model and Repository and suggested

improvements to the Installation process.

Siebel Systems Canada Ltd Toronto Aug/2000-Jul/2002

Senior Technical Manager, Alliances

. Managed and advised Partners concerning Siebel Architecture and

Integration

. Validated Siebel Software Partners by testing their products'

integration with Siebel products either in Toronto or on-site. It was

my decision as to whether Partner software was or was not validated.

Siebel was installed on either SQL Server 7.0 or Oracle 8i.

. Installed clean versions of Siebel Gateway, Server, Database Server,

Database, Siebel Client, Siebel Tools and Web Server for each

individual Validation (so every two weeks or so).

. Reviewed Partner documentation and suggested improvements to both

documentation and software

. Worked independently and reported to Technical Director, Alliances in

San Mateo, CA.

. Has indepth experience with the Siebel database structure, SQL Server

7.0/2000, Oracle 8i, integration technologies such as EAI and EIM,

Siebel Workflow, Siebel VB, Siebel Analytics Server, Siebel Server

installation and administration, and Siebel Tools

. Trained in Siebel Analytics and have configured Siebel Analytics with

Cognos and ThinkAnalytics software

. Designed, developed, maintained and DBA, auditing and data migration

for the internal Partner Database system developed in SQL Server 7 &

2000. Developed an in-house Access 2000 front-end to the Partner

database.

Pfizer Central Research Sandwich Apr/1999-Mar/2000

Analyst/Programmer and Team Leader (Contract)

. Managed Team of 2 Developers in design and development code for Phase

4 of the IMSO Project which handled orders for liquid plates of

compounds. Plates are produced by robotic system ALSB.

. IMSO was written in Visual Basic 5.0, RDO, ActiveX, and PL/SQL on

Oracle 7.3 / VMS. IMSO was developed in a OO manner using VB Classes

and Collection Classes.

. Responsible for Database Design, Function Design, Entity Modelling,

Development and Testing.

Barclays Mercantile Business Finance Basingstoke

May/1998-Mar/1999

Consultant (Contract)

. Redevelopment of Corporate Banking System (CBS) for Euros. Forms and

Reports modified to allow input and display of both Sterling and

Euros. Used Oracle RDB 7.0 / OpenVMS on Server with Access 2.0 holding

Report data generated from RDB. User Interface written in Visual Basic

3.0/4.0 on Windows 95 with COBOL on the Server. ACMS/CDD linked Client

and Server.

. Upgrade of User Interface to Visual Basic 4.0 (32bit) and conversion

of ACMS on Server to Compaq TpWare which converts ACMS into an ActiveX

DLL. Liaised with Compaq on this Project.

Lloyds TSB Plc Manchester Mar/1998-May/1998

Consultant (Contract)

. Year 2000/Oracle Migration work converting DCL and SQL*Forms 2.3/3.0

to SQL*Forms 4.5, development of TPU Programs to perform global text

replacement to hundreds of source files, population of Oracle Tables

listing table/column usage.

Coventry Building Society Coventry Jan/1997-Jan/1998

Consultant (Contract)

. Design and Development of Financial Systems using Oracle 7.1,

SQL*Forms 3.0, PLSQL, Shell Scripts and Pro*COBOL on Unix

. Worked on Direct Debit, Standing Order and Internal Transfer Forms

covering internal and external money transfers. Development of

Savings and Mortgage Systems including interface with legacy Bull

System.

. Development of Back-End System for Automated Teller Machine System.

Support for System and User Testing.

Liverpool Victoria Insurance London Sep/1996-Dec/1996

Consultant (Contract)

. Development of Pro*COBOL and PL/SQL on a Oracle 7.1 / Unix System to

link ICL Mainframe systems with Husky Mobile Computers providing a two-

way link between Central Office and mobile Insurance Agents.

Siemens Business Communication Ltd Milton Keynes May/1996-

Sep/1996

Consultant (Contract)

. Migration of Customer data from Mercury computers (ICL Mainframes) to

Siemens Oracle system using PL/SQL.

British Gas Plc London Nov/1995-May/1996

Consultant (Contract)

. Support of very large Corporate Billing Oracle 7.0 / VMS System for

British Gas. Datafixing, maintenance, system help desk, user support

etc. Amended Pro*COBOL and SQL*PLUS code. Used SQL*FORMS 3.0.

Origin (UK) Ltd Surrey Sep/1995-Nov/1995

Consultant (Contract)

. Design and Prototyping for a bid to develop a Gas Day Management

system in Visual Basic and Oracle for Kinetica Ltd using Access 2.0,

DAO and Visual Basic 3.0 for the prototype.

. Design and Development of a Hospital Database system for Philips

Medical Systems in Crawley using SQL*Forms 4.5 on Oracle 7.0 /

Windows.

MW Kellogg Ltd London Jun/1995-Sep/1995

Consultant (Contract)

. Development and Enhancement of Materials Status System used to manage

the raw materials needed in the construction of petrochemical plants

by the client around the world. Developed in PL/SQL, Pro*COBOL,

SQL*FORMS 3.0 on a Oracle 6.0 / VMS system.

BTEC London Oct/1994-Apr/1995

Consultant (Contract)

. Development and Maintenance work on BTEC's systems which manage

Examination and Student databases. Enhanced PL/SQL, Pro*COBOL,

SQL*FORMS 3.0 code on a Oracle 6.0 / VMS system.

Reuters Ltd London Mar/1994-Sep/1994

Consultant (Contract)

. Designed and developed a fault logging system to record network faults

against Communications Circuits for Reuters.

. Developed in PL/SQL, SQL*FORMS 3.0, SQL*LOADER, Oracle 6.0 on Unix /

Xwindows System.

Middlesex University London Nov/1993-Mar/1994

Consultant (Contract)

. Development of PRO*COBOL in Oracle 6.0 / VMS system to create data

files for the Further Education Statistical Report required by the

Department of Education every year.

Eurotunnel Ltd London Sep/1993-Nov/1993

Consultant (Contract)

. Designed Oracle 6.0 tables on VMS containing information from other

Systems for use with an Executive Information System written in HOLOS.

Used Access 2.0 to model system metadata.

Reuters Ltd London Jun/1993-Sep/1993

Consultant (Contract)

. Developed enhancements and fixes to Reuters Admin systems (with which

I had previous experience) in Oracle 6.0 on Unix / Xwindows,

SQL*FORMS 2.3 / 3.0, PL/SQL and Pro*COBOL.

British Gas Plc London Oct/1992- Mar/1993

Consultant (Contract)

. Development of Gas Transportation project in Oracle 6.0 / VMS,

SQL*FORMS 2.3, Pro*COBOL, PL/SQL which managed the transportation and

billing of gas being shipped by British Gas for customers.

Perot Systems Europe Ltd London May/1992- Sep/1992

Consultant (Contract)

. Analysis and Design of the Fleet Plan for Europcar. Oracle 6.0 on Unix

/ Xwindows, SQL*FORMS 3.0 and SQL*PLUS

.

Reuters Ltd London Sep/1991- May/1992

Consultant (Contract)

. Designed and developed Network Administration project to allow Reuters

engineers to allocate telecommunication circuits and equipment so that

Reuters terminals can be used at client sites. Developed in SQL*FORMS

2.3, PL/SQL and Pro*COBOL on Oracle 6.0 on Unix / Xwindows.

Premier Systems (Anglo Leasing) London Apr/1989- Sep/1991

Consultant

. Analysis, Design, Development, Testing of New system for Anglo Leasing

Plc to replace a MUMPS system with an ORACLE 6.0 / VMS system covering

all aspects of Anglo's business including Cash Book, Sales Ledger,

Equipment Disposals areas. At this time, this was the largest Oracle

Database in Europe.

. Developed in SQL*FORMS 2.3, Pro*COBOL and DCL.

British Telecom International London Dec/1986 -

Apr/1989

Analyst/Programmer

. Design and Development of a new exchange system in VMS, COBOL,

ACMS/TDMS and DBMS designed to handle the records needed to control a

single BTI digital exchange.

. Design and Development of an MIS system in Oracle 5.0 / VMS, SQL*FORMS

2.0 and SQL*PLUS to hold Marketing information on Major Customers.

Personal Project (http://www.ordersofbattle.com) Jan/1992-

Present

. Analysis, Design and Development of a Military History database of

World War II Orders of Battle. Containing information on military

units such as Divisions, Brigades, Battalions etc in the Second World

War compiled from official histories, war diaries etc.

. This has been going in various forms since 1991 and has now been

redeveloped in Visual Studio.NET 2008 to use VB.NET, LINQ and the

Entity Framework on SQL Server 2012. The web pages use ASP.NET on MVC.

Files are stored in SQL Server 2012 File Table.

. This database has been available online at

http://www.ordersofbattle.com since November 2004

. All text pages from HTML stored in the database rather than using

static HTML pages.

. Developed my own inhouse replication system using MSMQ, FTP, LINQ for

Entities and LINQ for XML. The different components are activated as

Windows Services

. I use SQL Examiner and SQL Data Examiner to keep all my databases in

sync and to double check and fix replication errors

. Built three new Host Servers using Windows 2008 Hyper-V to run all

Server machines as Virtual Machines. These store the Virtual Machines

on an inhouse QNAP machine which functions as the iSCSI target.

Personal Project Jan/2007-Jan/2013

. Created a technical web log using Word Press, PHP, IIS and MySQL as an

exercise to learn about blog software. Blog concentrated on SQL

Server, .NET Framework, Mini-ITX and CRM.

EDUCATION

1981 - 1984 BA (Hons) Humanities (II ii), University of Glamorgan,

Pontypridd, Wales

Contact this candidate