Seller 248475 - Chelmsford, Essex, UK
Database Developer / Analyst Programmer
Involved in full cycle projects including:
• Visit Client to discuss their requirements
• Business, data, procedures analysis
• Write specification, agree with Client
• Develop prototype (Rad), discuss with Client
• Develop system (new or modify existing one)
• Write users and technical manuals
• Install system
• Train users
• Support system
| Rating: | Unrated (New) |
| Hourly Rate: | £20.00 |
| Available From: | Now |
CV
Employment History
(Jan 2007 to Apr 2007)
Tools: Mysql, Access, Excel, VB, asp.net
Role: 1. Add facilities to the BPCF Hedge Funds system I previously wrote.
2. Prototype web-site database applications
(Sep 2005 to Nov 2006)
Tools: Access, Excel, VB, VBA, Sql, ODBC, ActiveX and components, Crystal Reports
Role: 1. Develop 4 systems:
919: map, reconciliation and auto-reporting facilities (gross paid, gross os, recoveries); data read and migrated from various sources.
820: similar to 919 with less complexity.
HR training system: to record employees training courses and provide reports.
Project Management/workflow: to monitor projects workflow.
Including discussing the requirements with managers and users, data analysis, specification, development, users and technical reference manuals, train end-users.
2. Support: Debug and support various financial applications written in VB, VBA, Access, Excel.
(Jul 2005 to Dec 2005)
Bell Pottinger (finance)Tools: Access, Excel, VB (6), VBA, Sql, VBA
Role: Develop BPCF Contacts Management System
Including discussing the requirements with managers and users, data analysis, specification, development, users and technical reference manuals, train end-users.
(Jan 2005 to Jun 2005)
Hackney Borough Council (public sector)Tools: Access, Sql, Visual Basic, MS projects
Role: Develop a Home Visitors Management System.
Including discussing the requirements with managers and users, data analysis, specification, development, users and technical reference manuals, train end-users.
(Dec 2004 to Feb 2005)
Babergh Council, Suffolk (public sector)Tools: Access, VB, Sql, Business Objects / Crystal Reports, VB, Sql
Role: Develop Projects Management System
Including discussing the requirements with managers and users, data analysis, specification, development, users and technical reference manuals, train end-users.
(Aug 2004 to Sep 2004)
Silver Homes (property developer)Tools: VB, VBA, Access, Excel
Role: Develop Financial Reporting system
Including data migration and cleansing
(Jul 2004 to Aug 2004)
Marsh Insurance (finance)Tools: Access, VBA, Oracle queries via Odbc and Sql, output reports onto Excel (excel also running VBA code to check and accept data), OLap, Crystal Reports
Role: Develop Financial Reporting System
System to enable the authorised users to map data from various sources, see detailed and grouped results by range, type, date in any required format (Excel, text file, Word) depending on the users requests.
(Feb 2004 to Apr 2004)
Rayburn Engineering (motor industry)Tools: .net, Sql, Crystal Reports, Access, Excel
Role: Migrate Job Number system I previous wrote in VB6 onto .Net
(data converted from access onto sql)
System includes: Orders, Invoices and Ledgers
(Jan 2002 to Jan 2004)
Educare, Hatfield, HertsTools: VB.net, Sql, Crystal Reports / Business Objects
Role: Develop a Recruitment System
(May 2001 to Sep 2001)
FTP, Witham, EssexTools: FoxPro, Access, VB, Business Objects / Crystal Reports,
MS Project
Role: Debug already written FoxPro systems then rewrite it
in Visual Basic version 6 data held on Access,
reports written in Crystal Reports
Additional Information
Technical Skills (15 years):
Access, Excel, VBA, Visual Basic (3,4,5,6, up to .net),
Sql (Databases, View, Stored Procedures, DTS), mysql
BusinessObjects/Crystal Reports (up to XI),
MS-Office (MS-Project, Word, Powerpoint, Front Page),
Asp.net, Html, VBScript
Database technology: ADO, DAO, ODBC
Structured analysis methods: Ssadm, Lsdm
CAREER SUMMARY (1994 to 2007)
Database Developer / Analyst Programmer
Involved in full cycle projects including:
• Visit Client to discuss their requirements
• Business, data, procedures analysis
• Write specification, agree with Client
• Develop prototype (Rad), discuss with Client
• Develop system (new or modify existing one)
• Write users and technical manuals
• Install system
• Train users
• Support system
Key skills used:
• Develop, enhance and support applications written in VBA, Visual Basic,
Asp.net –back-end: SQL, Access or others (Oracle) via Odbc
• Full project life cycle experience including complete documentation
• Good Communication Skills with users and their managers
• Support existing MDB, Sql, mysql, T-Sql applications
• Migrate various databases & applications from Access & Excel databases to
Sql.
RECENT COURSES
Apr 07 – May 07 OneTech (UK) Ltd
CIW Database Specialist (Perl, Pho, Asp)
Prior to 2000 freelanced (since March 1994) as a database developer/analyst programmer
Tools: Visual Basic (versions 3 to 6), Sql (6.5 and mysql), Crystal Reports, VBA, Access, Clipper, DBase), Ssadm, Lsdm for clients including:
Companies Systems Tools
Welsh Office – Cardiff Recruitment system VB6, Sql, Crystal Reports
British Nursing Association World Wide Recruitment system VB5/6, Sql, Crystal Reports
DETR Environment – London Various survey type systems VBA, Access
Three Valleys Water Various small systems VBA, Access
British Rail Fixed penalty fair VB5, Access, Crystal Reports
NHS Chelmsford Orthoptic and Appointments systems Delphi, Paradox, VBA, Access
Electricity Board, Essex Stock Control Clipper, DBase
DRA – Bromley On-line catalogue VB3, Access, Crystal Reports
Rhone Poulenc Lab system VBA, Access
BP – Hemel Hempstead Lab system Clipper, DBase
Barclays Bank Map. System VBA, Access
More full details can be provided upon request.
Categories & Skills
Healthcare (Non-Clinical)
Categories
IT & Internet
Categories
Skills
- .NET (Programming)
- ActiveX (Programming)
- ADO
- ASP (Programming)
- ASP.NET (Programming)
- Basic (Programming)
- CA-Clipper (Programming)
- Crystal Reports (Reporting & Analysis)
- DAO
- DOS (Programming)
- FoxPro (Database Development & Admin)
- French (Foreign Languages)
- MS Access
- MySQL (Database Development & Admin)
- ODBC
- OLE DB
- Reportbuilder (Programming)
- Reportwriter (Programming)
- SQL (Programming)
- SQL Server (Programming - SQL)
- Transact-SQL (Programming - SQL)
- VBA (Programming)
- Visual Basic (Programming - Visual Studio)
- Visual Basic .NET (Programming - Visual Studio)
- Visual FoxPro (Programming - Visual Studio)
- Visual Studio (Programming)

