CURRICULM VITAE

·         Date of Birth – 18.5.1977

·         Nationality – British

·        Driving – Full clean licence

·         Member of British Computer Society

·         GCSE – 8 Passes including Math’s and English

·         A Level Economics and Information Technology

Microsoft developer with 10 years experience the last 5 being in contract positions.  I have the ability to specify, design, write, test and support an extensive range of both commercial and bespoke software.  I have gained experience in many different sized companies and industry sectors with the ability to adapt quickly to new environments. 

I am a confident and persuasive communicator, both orally and written.  I am able to work both independently or as part of a team.  I work best when under pressure with clear deadlines.  Thriving on challenges whether technical, business or personal.  I have the ability to think “outside of the box” to find solutions to problems using all available resources and technologies. 

 ·         Developed bespoke reporting application – GSCC

·         Developed Document Management System – GSCC

·         Data migration project of excel spreadsheets and Access databases into SQL 2000 database. - GSCC

·         Specified and implemented [snip] helpdesk system on time and to budget – [snip]

·         Developed add-on modules for labour recording system – Sonoco Limited

·         Developing and administering databases – Capita PLC

·         Data migration from Access and Excel to SQL Server – Capita PLC

·         Writing data manipulation and transformation applications – Capita PLC 

Career Summary

[snip] (Contract)

This was an initial six month contract, extended (currently three times) to 2 years.

Supporting and developing additional modules for core business systems.  Projects include:

• Conversion and migration of 30 spreadsheets and Access databases into an SQL 2000 database.  This included manipulating the data using SQL, VBA and VB code.  I also managed the data cleansing process which was performed by members of the project team.  Address information was validated using Quick Address Pro api and Visual Basic code.
• The specification, development, training, support and enhancement of a querying/ reporting tool.  This enabled the users to create and run their own reports.  This was developed using Visual Basic 6 with a SQL server 2000 backend. 
• The specification and development of a document management system, which is used to scan, index and store received application forms.  This application was developed using Visual Basic 6 and SQL server and it also used a Canon 80 page per minute scanner.
• During this time I have been heavily involved with developments of the core CRM system adding functionality to this using SQL server features such as stored procedures.

[snip] - Television Licensing (Contract)

Contract work within the Business Change Team developing and managing a number of databases.  This included creating databases (forms, tables, queries, modules etc) as well as writing data manipulation programs with Visual Basic 6 to convert data from legacy systems to the new SQL Server databases.

[snip] (Contract)

Contract to extract data from a Pick based D3 system. The data was then manipulated using Excel VBA macros.

[snip] (Contract)

Contract to amend and enhance an existing Access database to produce new reports and exports into Excel.  This contract involved writing queries, forms, and VBA code in Access, writing VBA code in Excel to manipulate and format the Access data export.  When the new functions were signed off and on completion, I was involved in completed technical and user documentation, allowing clients to maintain the system..

[snip] (Contract)

Developing a number of new Access databases for a subscription based magazine.  Data was converted from Legacy systems and from external sources using Excel macros and Access modules/queries.  This was an ongoing project involving several short term contracts.

[snip] (Contract)

Working with [snip] on an Access 97 database development for a major foreign bank.  My role was to ‘tidy and bug fix’ the system.   This contract was initially for three days.  However, this was extended to a total of two months.  My main roles in this contract were:

·         Writing and amending Access VBA code.

·         Writing queries and SQL’s.

·         Designing and amending Access forms.

·         Documenting new and existing code.

·         Testing and bug fixing

·         Maintaining project plans and writing weekly status reports
 

[snip] (Contract)

·         Developing, maintaining and support both new and existing Access database front ends against Oracle 8 back end.

·         Produce and run Oracle SQL queries to update, retrieve and manipulate data.

·         Produce documentation for new and existing scripts and applications

·         Maintained FTP scripts used to publish from internal to internet systems.

·         Developed and maintained crystal reports against Oracle database.

[snip]                                                    July 1995 – August 2000

This was a permanent role with [snip] who are the second largest distributors of magazines in the UK.  A joint venture between BBC, EMAP and Haymarket publishing,  employing approximately 220 people.  Whilst there I was promoted though a number of roles within the Technical Support and Business Systems teams.

Roles held:

Information Systems Analyst                              April 1998 - August 2000           

Help Desk Support Analyst                                 April 1997 - April 1998

IT Operator                                                        July 1995 - April 1997

·         Developed reporting system using Access 2000 to measure the effectiveness of a£3 million sales initiative.  System imported data from Oracle database into a standalone Access system using a series of calculations and reports to provide information to Directors.

·         Developed Sales Based Replenishment prototype system written in Visual Basic to run complex algorithms to predict the sales and supply of magazines into individual retailers.  This system took EDI data from an Oracle data warehouse and imported it into another Oracle database.  This system used ftp to transfer data from Head Office to remote wholesale sites.

·         Designed advanced spreadsheets for a number of business areas including Excel VBA macros.

·         Managed procurement, implementation and customization of [snip] helpdesk system.

·         Defined and developed suite of management reports in Crystal Reports against an Oracle database with Visual Basic 6 front end to provide statistics from Help Desk system liaising with the Help Desk Manager and business users to gather requirements.

·         Developed Visual Basic e-mail notification server application for [snip] to enable notification of call logging to users, this system integrated with Outlook and MS Exchange.

·         Developed Visual Basic application to gather performance data into an Oracle database from Windows NT servers using Crystal Reports to produce management reports.

·         Responsible for producing reports from core business systems based on users specifications and requirements using SQL against Oracle and Ingres databases and writing VBA code to manipulate the results

·         Developed Point Of Sale application using Visual Basic, Oracle and Crystal Reports to track details of point of sale activity for the Frontline group.

·         Created UNIX scripts to improve business efficiency.  An example of this reduced one type of helpdesk calls by 75 %