CURRICULUM VITAE

CURRICULUM VITAE

Name:

David Andrews

Home Telephone:

(020) 75315863

E-mail:

dave@crestnet.co.uk

Qualifications:

B.Sc. Computer Science (Southampton University 1994) 2:1

Areas of Experience:

Product	Experience
Visual Basic 3/4/5/6	12 years
ASP	2 years
HTML	1 year
Sybase	3.5 years
Oracle	2 years
SQL Server	9 months
Access	11 years
CODA	2 years
PVCS and Visual Source Safe	7 years
VB.NET/XML	Training courses at Learning Tree

Companies Worked For

Company:	BMS Group
From:	March 2005
To:	September 2006
Working On:	I was involved in coding changes and adding new code and web pages around Lexis (a document management and workflow system) This involved: Modifying Lexis web pages (using ASP and Javascript) Creating new web pages in ASP, Javascript and SQL (accessing both Oracle and SQL Server) Writing COM objects to interact with the Lexis database (SQL Server) and BMS’s Oracle database Writing VB programs to move data from PC Docs into the Lexis database Writing an Outlook COM Add-In (in VB and SQL) to allow the user to interrogate Lexis and attach documents to e-mails

Company:	ODPM Office of the Deputy Prime Minister
From:	August 2003
To:	December 2004
Working On:	I was involved in several projects including:: ICARUS - a web site that I designed and built in ASP, Javascript, CSS and SQL Server (using T-SQL Stored procedures, triggers). This web site (of 140+ pages) is for maintaining financial information and static data and allows users to run reports which can be exported to Excel. The web site tracked usage and allowed users to be assigned to roles, so that they could only access certain pages. Extracting data from the underlying SQL Server ICARUS database via DTS packages to be uploaded into SAP/BW. Uploading data into the ICARUS SQL Server database from source data and the old systems via DTS packages. Writing VB programs to analyze the code within ASP web pages OSIRIS - developing and maintaining a client/server Access VBA application which managed departmental financial information. This involved: writing queries to answer users’ questions; recoding forms as required; applying coding standards to the existing code. MATlog - a web site written in ASP and SQL Server to store job requests for the team that I was working in. WDCA - a web site to capture financial information from government offices and agencies. This web site is written in ASP, Javascript, CSS and SQL Server. Budgetting WS - a web site (written in ASP, Javascript, CSS and SQL Server) to capture budget forecasts across the year for loading into SAP. writing VB Excel macros as required by members of the team to process spreadsheets etc.

Company:	Auros
From:	August 2002
To:	June 2003
Working On:	I worked for AUROS (at their customer’s site CITB). This involved: developing ActiveX User Interface DLLs and COM+ components in VB6, to replace a large INGRES system writing 100s of stored procedures redesigning parts of the database writing the migration scripts from INGRES to the new SQL Server 2000 database (including a few DTS packages) acting as the project’s DBA (doing backups, restores etc…).

Company:	GVA Software
From:	February 2002
To:	May 2002
Working On:	From February 2002 to May 2002 and in July 2002 I worked for GVA Software developing SQL Server DTS packages for one of their clients - to transfer data in and out of their systems. I wrote some VB6, SQL Server and Oracle code into GVA’s main product to implement licensing and fix various bugs. I also wrote an Excel VBA application to maintain their clients’ licensing requirements.

Company:	Philatex.com/Crestnet Technology
From:	October 2001
To:	Feb 2002
Working On:	From October 2001 to date I have been writing my own website in ASP, HTML, JavaScript and Access 2000 called Philatex.com. This website allows user to enter swaps, view swaps entered by others and edit their account details. This website is currently up and running in test mode.

Company:	Land Securities
From:	April 2001
To:	October 2001
Working On:	From April 2001 to October 2001, I worked for Land Securities. This has involved modifying VB programs and stored procedures to make them partnership compliant (i.e. allowing programs to be multi-company for CODA). I wrote a VB6 program to analyze source code to find areas of code that could potentially not be compliant. I wrote an application to post journals into CODA both via a front end and via a spreadsheet. This was a VB6 application using CODA callable link with a ActiveX/COM link to Excel I have also written a complex reporting system with SQL Server stored procedures, Excel VBA and an ActiveX DLL (which I coded in VB6). This application allows the user to define their own complex ad hoc reports via a maintenance program encapsulated in ActiveX DLL. The structure of the resulting reports was stored in SQL Server tables. The structure of the reports was interpreted along with the report data when the user choose to run the report in Excel via Excel VBA and the ActiveX DLL.

Company:	Pfizer (Central Research)
From:	February 2000
To:	February 2001
Working On:	I worked on ECADA (a chemical ordering, experiment creation application and data analysis system), which is a client/server application written in VB and Oracle. This involved: bringing the project in house from an external supplier; fixing the bugs that remained within the system; adding new functionality to the project; replacing Oracle for Objects with ADO (I wrote a VB program to parse the VB code and to replace the relevant code); replacing the reports that were generated by the system with web reports (these I wrote in ASP and SQL. I also needed to write an ActiveX DLL to reference the SimplePlot DLL which I used to draw the graphs within the reports). I also wrote an ASP web application which allowed the users to generate generic reports (this application was driven by 5 database tables and allowed super users to write SQL statements which were stored in the database and were executed when the user selected the report to run from the web page. Parameters could be entered by the user, if required by the selected report).

Company:	Cazenove
From:	August 1999
To:	December 1999
Working On:	I worked for Cazenove (a stock broker in the City), writing three pieces of software: the first for posting documents using VB and Oracle; the second to perform matching on CODA; the third piece of software is a maintenance program for the posting application that gives it the flexibility required for the various document posting requirements. On these projects I have been using VB4/VB6, Oracle (including stored procedures) and CODA callable link. The posting program is a dynamic program (the aim of this application is to provide one program that has the flexibility to post all the document types that the business wishes to post without writing a separate application for each of these types.) which allows the input window to be predefined for the document type, i.e. field names can be changed, input fields repositioned, enabled/disabled and default values assigned. Logic may be applied as document lines are added to the document. Extra lines can be added to the document automatically before the document is posted. Documents may imported/exported from Excel spreadsheets. Documents may also be posted based on SQL results returned from the current or other databases.

Company:	Cap Gemini (Thomas Cook)
From:	March 1999
To:	July 1999
Working On:	I worked at Thomas Cook for Cap Gemini on their Y2K project. I was working as a “test specialist” on GRMS, a system I was involved in a few years ago. As test specialist my role involved: looking at the code that has been changed; flagging up potential areas of concern for testing; managing the users who were testing the system; identifying whether errors found by the users were of concern or not; identifying the error in the code (for re-renovation); validating results entered by the user.

Company:	Keane UK Ltd (East Midlands Electric)
From:	August 1998
To:	February 1999
Working On:	From August 1998 until February 1999 I worked on my first contract for Keane (UK) Ltd (formerly Icom Solutions Ltd) working on the Quotations project for East Midlands Electric in Nottingham. On this project I worked on the main Quotation system writing VB4, VB5 and VB6 code as well as writing Oracle stored procedures, functions and packages. I also wrote a maintenance program, to hide the complexities of product pricing from the user, using VB 6.0 to write the front end and ActiveX controls and Oracle stored procedures for the back end.

Company:	Thomas Cook Financial Services (April 1995 to July 1998)
From:	April 1995
To:	July 1998
Working On:	From April 1997 to May 1998 I was involved in the Ledger Replacement Project. Our team was replacing the General Ledger (then on MSA) for Thomas Cook with CODA (a client/server application which allowed bespoke enhancements). On this project I wrote several applications in VB4 (16 bit), Callable Link (a DLL supplied by CODA to allow bespoke developments) and Sybase 11. These applications included: an application to upload budgets into CODA via a spreadsheet, a text file or manually on line; a complex Journal Voucher upload program, which allowed the user to enter intercompany currency documents; a JV Maintenance program to maintain the extra static data needed to run the JV Upload program; a currency browser application to browse currency transactions within the General Ledger; a Posting History application; a static data maintenance program to maintain “elements” within CODA as well as the reporting data structures. I also designed a reporting database using star structures to reduce the complexity of reports that we needed to write. I also helped members of the team by: loading data (from spreadsheets and flat files) into the CODA link tables; wrote Excel macros when required; prototyped reports etc.

	From September 1996 to March 1997, I worked developing an order capturing system (for the sale of traveller’s cheques and foreign money), programming in both VB4 (32 bit) and Sybase 11. I was responsible for coding the class modules that interacted between the database and the front end, the stored procedures on the database, the denomination picking object (which determined which denomination to split a currency order into) and an application that processed a fixed width text file that contained orders from various branches of Thomas Cook and Nationwide Building Society.

	From June 1996 to September 1996, I worked on the AESOP project, which was an Order Processing system. I was responsible for looking after the Access database and its documentation, the coding of the static data maintenance windows, writing the reporting modules of code (using VS-Flex) and the reports.

	From April 1995 until June 1996 I worked on the R.M.S. (Refund Management System – now GRMS) suite of programs. I was involved in coding the front end using VB3 and the back end using Sybase 4.92 (writing stored procedures and creating tables).

	While at Thomas Cooks I went on the following I.T. courses: Fast Tack to Sybase; Advanced Transact SQL; PC-Docs Administration; COGNOS Powerplay User and Administration; COGNOS Impromptu User and Administration; CODA Table Link; CODA Callable Link; a 4 day team leading course; Advanced Visual Basic 5.0 (from QA).

Company:	Roster Control Systems
From:	July 1994
To:	March 1995
Working On:	From July 1994 to March 1995 I worked at R.C.S. (a small software house writing rostering software for the security industry), coding in VB 3 and SQL. I used Access to construct queries, write reports and create a small database. I wrote the manual for the major product that we were developing at the time using Doc-To-Help. I also gave support to users testing the product both in the U.K. and Ireland.

I am a keen traveller and I have visited several countries in Europe as well as Cuba, Mexico, Tunisia, Egypt, China, India and Sri Lanka. I am interested in ancient history. I like to play bridge and have played at various clubs and competitions. I regularly go to the gym.