Curriculum
Vitae
Age 41
Summary
Xxx has over 15 years IT experience,
all within systems development, both for large and small
organisations. Has been developing applications using SQL
Server for almost 10 years extensively using stored procedures,
with front ends in VB, Access or ASP / HTML web.
References Available from previous clients, on offer
of contract.
Skillset
Skill / Toolset
|
Basic OK(1yr)
Good(2yrs+)
Excellent(3yrs+)
|
|
Visual InterDev 6.0 |
********************************************************* |
|
ASP |
************************************************** |
|
HTML |
****************************************** |
|
VBscript |
************************************************** |
SQL Server 7 / 2000
|
********************************************************* |
Stored Procedures/triggers
|
*********************************************** |
DTS
|
************************* |
|
MDX ( OLAP ) |
******** |
|
JavaScript |
************************************** |
|
ADO |
************************** ****** |
|
IIS |
*************************** |
|
VSS |
**************************** |
|
XML |
***************** |
|
MTS |
******************* |
|
COM |
************************************ |
Visual Basic v 4, 5 and 6.0
|
*********************************************** |
|
COM+ |
************ |
|
FrontPage |
************* |
|
Access 2000 |
************************* |
Access 97
|
********************************************************** |
|
VBA / DAO |
***************************************************** |
|
SQL Server 6.5 |
******************************************************* |
|
Business Objects |
************ |
|
Oracle RDBMS |
*********** |
T-SQL
|
********************************************* |
|
ONYX ( CRM ) |
*************************** |
|
UNIX (AIX and HP) |
************ |
Excel 97/2000 and WORD
|
********************************** |
|
ErWin / database design |
************************************************* |
|
Microsoft Office + Visio |
********************************* |
Contracts from 1994
to 2002
(N.B. LATEST
CONTRACTS FIRST )
[snip](25/8/02 –4/11/02)
Developer
* 3 tier
development using VB, SQL Server, and ASP. Development of
several components with extensive use made of stored procedures
for SQL 7 and 2000.
*
Building of COM+ objects to create business and data-access
tiers. Sourcesafe deployed.Javascript used for validation.
[snip](July02)
Systems
Analyst/Database Designer
* Design
and build Access/VBA system to manage comments from public made
on web in relation to complex planning document.
* Design and build SQL
Server 2000 database to support back-office work-flow and web
deployment.
[snip](4 months)(Jan02-Apr02)
Analyst/Programmer
* Performed data analysis with accountants to map
data from legacy systems to new Oracle CEDAR e-Financials
package.
* Developed interface using Access 97 for users to
control and manage the loading and interfacing of data to the
new system.
* Worked with users to define data requirements,
and with accountants to ensure reconciliation of financial data
being transferred across to new system..
Tornado Group plc(Marlow,Bucks)(5 weeks)(Oct01-Nov01)
Web Developer/Analyst Programmer
*
Developing digital media download site using ASP/HTML/ADO with
an Oracle CMS database.
PandaNet(Bromsgrove)(2 months)(Jul01-Sep01)
Web Developer
*
Developing Home Shopping site for the Co-Op using ASP/HTML/Javascript/ADO
and SQL Server 7. Extensive use of CSS throughout system. Write
and implement COM print object using VB6. ASP developed using
Allaire HomeSite.
*
Setup DTS package for daily data load of latest price data for
catalogue.
* Develop reports using Business Objects.
NTL ( Winchester, Hook and
Basingstoke) (10 months )(Jun00-Apr01)
Internet CRM developer
* Set up fully integrated development environment
using Interdev 6 and Visual Source Safe from scratch. The
facility for debugging was also enabled.
* Developed enhancements to ONYX CRM system, in the
area of campaigns and list management.
Using ASP, HTML and Javascript in multi-user
Interdev environment. Extensive use of stored
procedures called via ADO. Define new CSS
classes.
* Design / Develop front-end for new sales stream
and hook into MTS /COM+ objects (VB6).
*
Load forms from XML wrapped data using predefined schemas.
*
Transform list data using programmatic XSL elements to render
XML bound data.
* Added new SQL7 audit tables,
and developed triggers to provide audit trail.
Intapps.com ( Twickenham) (4 months
)(Feb00-May00)
Web Developer
* Support and maintain the Marconi intranet careers
site, using ASP, HTML, Javascript, VBscript and SQL Server 6.5.
Site Server used for session variables. Implemented to live
server using FTP and RAS. Frontpage used for new web forms.
Fletcher Associates ( Tewkesbury) (2
months )(Jan99-Feb00)
Web Architect / Programmer
* Analysis and design of websites yellowtag.com and
theoilsite.com using ErWin, SQL Server 6.5, and Visio followed
by programming in ASP and HTML with Dreamweaver used to generate
forms.
Post Office Parcelforce (Swindon) (5
months )(Jul99-Nov99)
Analyst Programmer
* Develop Access / SQL Server system to analyse
demand patterns and incorporate Inventory business logic to
generate economic order quantities for central warehouse.
Extensive use of VBA and statistical formulae.
British Telecom ( Birmingham) ( 2
years)(Aug97-May99)
Analyst Programmer
* Help with development of MARCUS a bespoke CRM
written in ASP, HTML with a SQL Server database.
* Convert ‘Staff In Post’ database from Access 2 to
Access97/SQL Server. Attached tables eliminated, and replaced by
pass-thru queries and DAO/ODBC, to maximise remote dial-up
performance. Extensive use made of stored procedures. NT
Integrated Logins implemented, and also a bespoke central
user/facility administration system.
*
Develop sales revenue forecasting system using Access97 and
pass-thru queries to SQL .
*
Develop and incorporate Excel97 graphing component for display
purposes.
* Perform upsizing from Access 2 to Access97/SQL
server followed by performance tuning and pass-thru query
development, for MIDAS the Sales Prospect system. Implement VB6
COM object to periodically update SQL
database.
* Develop audit system, incorporating activeX
controls and complex commandbars using Access97. ‘Probe’ allowed
users to link together documents, recording notes, interviews,
tests and questions. Information then uploaded to central
database for MIS analysis. Now used internationally by British
Telecom.
Kennings Car and Van Rental
(Chesterfield) ( 4 months
)(97)
Database Designer
* Analysis and design of Customer database using
ErWin and SQL Server. Database setup and conversion routines
from existing systems using Access 97 with Jet3.5 and
ODBCDirect. Installed SQL database, and performance tuned using
serverside cursors.
Landis and Gyr (Telford) (
Seimens UK - 5 months)(96-97)
Analyst Programmer
* Development of an asset management and
calibration database in Access 7.The system maintains a log of
all items of equipment used within this electronics
manufacturing company, as well as a full repair and calibration
history. It tracks and lists all items due for calibration
according to ISO9000 protocol.
Post Office – PoiT
(Chesterfield) ( 4 months )(96)
Programmer
*
Three months development of a new Costings and Contributions
system, based on VB4, SQL Server and Access. Developed
SQL scripts to create tables, stored procedures and triggers for
system installation.
Post Office - Royal Mail (Chesterfield)
( 4 months)(95-96)
Programmer
* Two months programming an interface from existing
accounting systems to new ACUITYSQL system. Programmed the
control mechanisms for importing and exporting data in Access.
*
Developed application to capture raw costing data from Royal
Mail offices.
Landis & Gyr
(Telford)
( 3 months )(95)
Analyst Programmer
* Analyse, develop and
implement returns system using Access and VB 3.0.
* Solve client-server / network problems, capacity
plan systems, re-configuration of databases on network.
Post Office – PoiT
(Chesterfield) ( 3 months )(94-95)
Programmer and Documenter
* Development of configuration
management system, for PC distribution.
* Performance tuning.
* User Guide, Technical Guide
and Standards documents using Word.
Gloucestershire Business Services
(Gloucester) ( 4 months )(94)
Implementer
* Implementation of TimeFrame
in London for Prison Services.
* Tuning of code.
* Production of User Guide,
and Training Guide.
* Production of Install disks
using Application Developers Toolkit.
Previous IT experience ( 1982 –1994 ) ( most recent first )
National Rivers
Authority
(Bristol) 1992 – 1994
Development Team Leader
* Specification of a National Water Archiving and
Monitoring System.
English and American Insurance Group
(Gloucester) 1987 - 1992
Team
Leader
* Development of a London Market Reinsurance system
called SLIPSTREAM using MODEL204.
Northern Star Insurance Co Ltd
(Gloucester) 1985 - 1987
Analyst Programmer
* Development of Household and Personal Lines
insurance using Mantis, Cobol and DL1.
Kay and CO Lt
d
(Worcester) 1982 - 1985
Trainee Programmer to Senior Analyst Programmer
* Support/development COBOL
programming for warehousing systems.
Qualifications
10 O-levels and 3 Science A-levels attained
at Kings School Worcester.
BSc Applied Biology attained at Warwick
University and North East Surrey College. |
