Curriculum Vitae - Mr Daniel E. Small

Carters Rise Driving Licence. Yes & Car Owner

Reading Mobile Number. 07931 565181

RG31 7YT Email: daniel.small@virgin.net

Skillset Overview

SQL Server/ T-SQL Excel/Access 2007 ETL / DTS / BCP

Custom Scripting VBA/ADO ANSI SQL

C/C++ C# v2.0

Looking for...

"A Database Developer/BI Data Analyst or a role based around SQL (SQL Server, Access, Excel, C#.Net), ETL and possibly a reporting tool."

History

MCTS - SQL SERVER 2008 - Database Developer Self Paced Study

MCTS - SQL SERVER 2008 - Business Intelligence Developer April/11 -

Currently studying to become an MCP due to be realised in late 2011.

Quantum TM Data Developer CONTRACT Mar/10 – July/10

Development and maintenance of their Quanta 3 CRM database. The work involved extensive ETL activities using SQL Server 2005 and Access/Excel 2007. Most of the data loads were in Excel format, which was imported into staging tables in Access for offline cleansing and then using link tables to “push” the data into staging tables on the back end SQL Server 2005 database. Tools used at this site were primarily Advanced SQL, VBA (ADO Recordsets), Access 2007, Excel 2007.

NOTE: I have been providing spousal care between July 2008 and 2010 due an RTA.

Goodman - Reading Support Developer CONTRACT May/08 – Aug/08

A temporary role to assist with maintaining the software base and assisting with bug fixes due to a sudden departure. Activities at this site includes maintaining a webforms application in C# with an SQL Server 2005 back-end and assisting with custom extracts from an SQL Server database. This is partly a support role to ensure delivery of Goodman facilities management IT services to their satellite contacts.

Telindus - Hook Database Developer CONTRACT Mar/08 – May/08

SQL Server 2005, custom ETL processes to import data from a multitude of sources from CSV to Excel and Access using Office Automation Objects. The data loading process was driven from a basic SSIS package. Some extractions involved using VBA to write custom scripting formats.

Skillprover - Reading Analyst Developer PERM 2005–2008

Skillprover is a project aimed at delivering web-based IT assessment solutions to organisations. Predominantly, the testing materials are based around in-vogue IT skills. Skillprover was a complete portal for all commercial testing needs, offering stock tests and a custom test utility. Extensive SQL Server 2005 usage over this time using T-SQL, advanced joins, views and triggers. Skillprover is a normalised 2-Tier Framework ASP.Net 2.0 application via WebForms and C# with with strong backend Referential Integrity and Stored Procedure business logic using T-SQL on an SQL 2000 Server. I have provided training and 1st line support to Skillprover clients.

Verizon - Reading ETL Developer PERM 2004-2005

Data analysis activities using SQL Server and MS Access MDF and Excel files to import datasets in various structures in different stages into a Siebel Analytics system. This involved extensive query writing in Access via VBA to merge data using Recordset techniques (DAO/ADO) into a local SQL Server based on industry Dun & Bradstreet numbering (DUNs). A further cross validation exercise then converted the accounts using T-SQL ready for an Informatica loading process. Most of the T-SQL work was based around writing custom conversions via set based SQL.

Euphony - Reading Datawarehouse Developer PERM 2003–2004

Datawarehousing using SQL Server 2000 using strong database design and normalization skills. I employed data loading techniques through MS Access and Oracle 8i using OPENQUERY/OPENROWSET data warehouse T-SQL via DTS. In addition, I have assisted a third party software outfit on the approach to database design, normalisation and optimisation strategies for large volume data management. I have used the Profiler, DBCC, QEPs and index tuning to improve existing query performance.

Abacus Billing - Reading Solutions Developer PERM 1999–2003

Senior role. Responsible for the design and development of a billing solution known as Abacus Mediation for telecom operators using SQL Server 7/2000 and VB. Mediation is the process of providing call rating based on start, duration and tariff of telephone calls from switches. Rating algorithms derived from dialling code analysis of Areas, Regions and Countries. Set based (VENN) SQL approach taken for all SQL transactions in order to avoid the likely overhead of using cursors. VB development for front end maintenance of the Abacus Billing interface. Some development using C for custom extract file processing.

Aspen Field Marketing - Maidenhead Solutions Developer PERM 1996–1999

Greenfield development of a Britvic™ field marketing IT solution that collates information about customer expenditure in sales outlets such as service stations. Most stages of the project lifecycle sustained from Outline Design, Prototyping through to Development. DB-Library functions within C were used in conjunction with T/SQL to access a SQL SERVER 6.5 database. I had also enhanced a Psion™ Handheld PDA application in Clarion™ C/C++ adopting the EPOC32 API (now Symbian), which enabled on-site data entry of sales information.

Yesteryear Skills

DEC VAX VMS : INGRES RDBMS : UNIX : C : COBOL : BASIC PLUS 2 : INFORMIX

Mortgages, Accounts Payable, Derivatives, Early GSM, Defra, Statistics Office, CAA

Hobbies, Interests & Qualities

Instrumental music, keep-fit, horror literature, chess and sudoku.

Education

HND Computer Science Thames Valley University Slough