|
Home › Cancy and Craig › Craigs CV
Craigs CV
Experienced SQL Developer, DBA, Data-warehouse Analyst
Highlights
- Eight years experience in managing huge SQL databases.
- Proven ability to analyze and structure Data-warehouse & Business Intelligence data (Microsoft & Thomson Directories).
- Strong report writing and data query skills (reports governed the DWP nation-wide desktop roll-out).
- Proven on-site client facing experience (Oversaw the SQL team for a two million pound project building an online auction system).
- Experienced at end to end requirement capture and system design (EDS Work Management system).
- Ability to lead teams and mentor others (team leader and mentor for 4 of the last 7 positions)
Work History
Developer, Epiphany (Feb 2006 - Jul 2008)
Gathered requirements, developed, enhanced & documented financial trading package to simulate the global OTC Foreign Exchange markets. Included complex trading algorithms, wavelets, neural networks, huge memory resident databases, in-depth reporting, time-series analytics and data-mining templates. more >>
- Technologies: C++, Perl, C, Java, SQL, MS SQL Server, MySql, Apache, Linux, AJAX, PHP, XML, LDAP, SVG
- Company: Epiphany
is a UK based consortium providing outsourced services to financial and other industries.
Analyst, Developer, EDS & DWP (Mar 2006 - Dec 2006)
Designed, built, tested and integrated an on-line Request & Asset Management system. This included migration of existing disparate data, work-flow automation, on-demand management reporting and full life-cycle management, thereby enabling world-class delivery to the DWP. Included seamless integration with MS Project & Sharepoint servers. This system is now governs the management, allocation and reporting of KPIs on large part of the £2.6 billion contract between EDS & DWP. more >>
- Technologies: SQL, MS SQL Server, MS Project Server, MS Project, Sharepoint, AJAX, ASP, PHP, XML, MDX
- Company: EDS
is one of the worlds largest global computer infrastructure providers.
Systems Analyst, Developer, AnalystOutsource (Sep 2005 - Feb 2006)
Produced an end-to-end employee monitoring & management solution, integrating staff communication & desktop management over a global IP network. Included analysis and development of time-sheet system, asset usage monitoring, integrated intra/extranet, integrated VOIP, integrated chat & file-server management. more >>
- Technologies: Linux, VOIP, Perl, PHP, Apache, SQL, Shell scripting
- Company: AnalystOutsource
is an outsource management company.
Data-warehouse Developer, Microsoft UK (Apr 2003 - Oct 2003)
Built datawarehouse structures and data extraction DTS packages, to nightly transform and load huge volumes of call centre data into the European call centre data-warehouse. This data was extracted from Siebel servers, email servers and call switches spread throughout Europe and the US. In parallel, built OLAP Cubes using MDX and Analysis Services as a data-source for online Excel pivot-table reports. more >>
- Technologies: SQL, MS SQL Server, IIS, OLAP, DTS, MDX, Analysis Services, Stored Procedures, Office Web Components, VBS, Excel
- Company: Microsoft
(European head office in Reading).
Technical Architect & Developer, EDS & DWP (Jan 2003 - Mar 2003)
Gathered requirements, designed, built, tested, integrated and documented an end-to-end online work management system. This system is now used within EDS & DWP for the management, allocation and reporting of work across three business divisions. more >>
- Technologies: SQL, MS SQL Server, ASP, Niku Project Management, MS Project Server
- Company: EDS
is one of the worlds largest global computer infrastructure providers.
Reports Developer, EDS & DWP (Jun 2002 - Jan 2003)
Automated the extraction of data from a variety of sources, to produce 100+ time-sensitive reports. These reports were used by senior management to govern the nationwide roll-out of new desktops connecting 900+ sites and 120,000+ staff for the Department of Work and Pensions. more >>
- Technologies: SQL, MS SQL Server, ASP, XML, XSLT, MS Access, Niku Project Management, MS Project Server, SharePoint, SAP
- Company: EDS
is one of the worlds largest global computer infrastructure providers working on the Early Office Infrastructure project for the DWP.
SQL DBA / Developer, Azarn (Feb - May 2002)
Rewrote Azarn's SQL Database, Stored Procedures and product interfaces, leading a team of 3 contract developers and 2 staff members. more >>
- The live system is available at www.emaxmail.com
.
- Technologies: SQL Server 7.0, SQL, XML, SOAP, ASP, Perl
- Company: Azarn is an Internet based messaging provider.
Data-warehouse Developer, Thomson Directories (Jun - Aug 2001)
Managed the manipulation and transfer of gigabytes of sales information supporting a sales force of several hundred people and looking after a base of over 1 million customers. more >>
- Technologies: SQL (on both MS SQL Server and Sybase Adaptive Server), Brio, OLAP, Business Intelligence, Perl, ASP
- Company: Thomson Directories
publish over 170 editions of the Thomson Local (Yellow Pages) free to more than 22 million homes and businesses around the UK.
SQL Data Analyst, Izodia (Jul 2000 - May 2001)
Oversaw the database team for a £2million project building an online auction, inventory and information portal of 70,000+ spare aircraft parts. more >>
- Technologies: SQL Server 7.0 & 2000, SQL, Oracle 8i, Perl, ASP, XML
- Company: Izodia UK's largest B2B E-Commerce software provider (300+ staff).
SQL Architect, Azarn (3 mths)
SQL Programmer, NetActive (2 mths)Network Administrator, Raukura (4 mths)DBA, IHUG (6 mths)SQL Developer, Ablaze Media (30 mths)
Reference Letters
 EDS & DWP
"Overall I would hire Craig again as his involvement in our project was the major factor in it’s success."
--Jason Williams
|
 Izodia
"Craig has earned himself a strong reputation...for being the very best..."
--David Newall
|
 Azarn (2000)
"In particular I was impressed with his clear and logical thinking..."
--Azhar Chaudhary
|
 NetActive
"It is clear that Craig...has a flair providing the right solution..."
--Justin Harding
|
 Raukura
"He has the ability to communicate effectively to all staff on all levels."
--Kim Smith
|
 IHUG
"He has extremely good skills and is a fast learner."
--Herman Pienaar
|
Verbal references available on request
This document can be found online at http://www.redmondfamily.com/craigcv
|
Experience
| Mths | Skills |
| 84 | SQL |
| 72 | SQL Server 2000, 7.0, 6.5 |
| 60 | ASP/PHP/IIS/Apache |
| 48 | Access 95 - 2000 |
| 12 | MySql |
| 12 | MS Project Server |
| 03 | Sybase Adaptive Server |
| Mths | Roles |
| 72 | SQL Developer |
| 72 | DBA |
| 52 | SQL Architect |
| 14 | BI Analyst |
| 14 | Data Warehouse Developer |
| 36 | Team Leader |
| 24 | Customer Facing Consultancy |
| Mths | Languages |
| 60 | HTML/AJAX |
| 60 | ASP/PHP |
| 30 | Perl |
| 18 | OLAP |
| 14 | XML/XSLT |
| 12 | C / C++ |
| 07 | MDX |
Other Information
Date Of Birth: 24 Nov 1973
MCP: Designing and Implementing Databases (70-229)
Nationality: British / New Zealand (have both UK & NZ passports)
Marital Status: Married
Drivers License: Full and clean UK drivers license
Languages: Also fluent in Mandarin Chinese (spent 2 years in Taiwan)
Personal Website: www.redmondfamily.com/craig
|