kevin gurney

FoxPro developer, providing bespoke software for mainly manufacturing companies and add-ons to Pegasus Opera/Operations.

Development of ETL packages, SQL stored procedures and Python routines to automate processing of regular client data feeds Implementation of PostgreSQL database as our core processing and presentation platform, utilising SQL, PL/pgSQL, stored procedures, triggers, Python, with Pentaho Data Integration software. As a small company, I was responsible for the setup, maintenance, loading and querying of the PostgreSQL databases The databases were large datasets, consisting sensitive data of records of sales made by suppliers to major supermarkets at a daily and individual product level Data would be queried to meet auditor needs and often exported to Excel for further analysis, summaries, pivoting and filtering. Often there would be requirement for additional smaller datasets to be matched into the Excel output post extraction from the database Implementation of email archive, using MailArchiva running on Xen instances Implementation of Linux based infrastructure, Debian servers with Ubuntu desktops and an implementation of a windows domain. Office and remote workers are supported

With 20 years experience of database development, design and analysis, I am able to advise on data processing strategies and database/query optimisation. I am experienced in Microsoft SQL Server and more recently have taken an interest in open source data tools, with a speciality in the PostGresQL database and Pentaho suite of tools, which make for a cost-effective way of implementing a data processing strategy.

* Leading a team of six SQL/ETL specialists. * Building data warehouses * Understanding and building data vaults

Platform migration from Fox-pro 2.6 to Microsoft SQL Server Enterprise Edition, code refactoring from xBase code to SQL routines and stored procedures Creation of logical/physical data model to upgrade from a legacy xBase system to a SQL Server platform to enable our debt recovery team to manage recoveries of non-payment for petrol Lead analyst on our largest client, top 2 UK supermarket, part of a team that delivered over £40-million directly to our client, for 2008, the fifth annual increase since joining FAP Perl used to transform unstructured report data from a client to both deal with the non-uniform structure of the data and slight changes over time and to prove integrity of conversion by checking totals against totals embedded within the reports. The output would be to CSV, where, SSIS would then be used to load the data to the database Involvement in creation and sign-off of Technical Specification documents with clients to enable automation of data transfer from client systems; mainframes and Oracle Financials

Acted as central point for SQL query optimisation within data analyst team Administration of an early 14TB SAN, responsible for support, security, backup, data recovery and configuration of over 25 SQL server instances (8 enterprise) Perl was used to query multiple servers to perform monitoring such as checking last successful backups Administration and troubleshooting of an Oracle 9i instance

Moved the business data platform to SQL Server 7, refactored xBase code and demonstrated benefits to our team and management. SQL Server is still in use in this industry today Acted as subject matter expert for SQL Server within the data analyst team ETL using DTS and Data Junction to load client datasets Senior analyst on our most successful audit at a top 2 UK supermarket. Working with 30 auditors and 3 supporting colleagues we exceeded the results of the incumbent auditors to become the preferred supplier of accounts payable auditing services Initially employed to transform client data, noticed transformation work was repetitive, so found and implemented an ETL tool (Data Junction) to replace Clipper code. This created interface consistency across team members and cut time spent custom-coding transformations

Various science and computing courses to keep challenge brain and keep skills up