Dr Chris Rick MBCS, CITP, OCP
Tel:07973 209 342 and 020 8777 8073
e-mail: chris@rickcc.com
Career details, publications and more on: www.rickcc.com
Profile
Designer and developer with 28+ years of experience in an Oracle environment
using SQL, PL/SQL,t-SQL, Perl, Oracle forms and various OS command languages
and shells, always with design responsibility and then actually implementing. Full life cycle in all developments. Lengthy time with SQL Server and T-SQL with
much conversion between that and Oracle.
Oracle development and production DBA for
12 years creating and running 30+ large databases and many development
databases most recently for litigation support and direct mail with, much experience
and expertise in tuning.
Tuning and Optimisation over whole career tuned and optimised many large
systems for huge performance gains.
Includes two years almost exclusively tuning Oracle systems.
Creator and deliverer of DBA and developer
training: many short courses and a full week DBA course.
Team leader and manager of many
teams always with successful delivery
Applications: ETL, Ab Initio, Publishing, data
warehouses for Direct Marketing, text retrieval, Marketing support, BI, AI,
Media, CRM, litigation support, name and address processing deduplication and
merge. Utitlity billing. Real-time radar and telephone exchanges.
Expertise summary
PL/SQL 16+ years
SQL 24+ years
Oracle DBA V4 to V10
19 years
Database and
application tuning and optimisation 19 years
Forms - 6 years +++
SQL*Loader lots!
Perl 6 months
Design and build 11
large systems, and many small ones
Direct marketing, CRM,
Data warehouses & ETL 16 years
Text retrieval - 1
year
Marketing Support 20
years
Litigation Support 3
years
AI 4 years
Unix over whole career
- Bourne, Korn
Ab Initio 12 months
Toad 3 months
SQL Navigator 3
years
T-SQL 3 years
SQL Server 3 years
Major Achievements
Invented, designed and created an AI driven Direct Marketing, CRM data
warehouse product with fuzzy matching, query generation, deduplication, data
loading, PAF file handling, multi-dimensional analysis, ETL, dynamic SQL
generation, job-scheduling and queue management, grid components and many other
features (95,000+ lines of PL/SQL, 72 forms and Perl components being the core)
that have been proven to save two large customers (Eurotunnel and Informa Plc.)
over £1m a year each managing their marketing data warehouses. Supported both customers in defining new
requirements and creating the solutions.
Full life cycle. Acted as DBA for
Informa for many years.
Took over an abandoned 1+ billion row call record database belonging to
Inphomation for the receivers (Maryland First Financial). Analysed what the data meant and then carried
out analysis of the data to provide the proof of how MCI and ATT had underpaid
this company which enabled Maryland First Financial to recover many millions
from these companies for creditors.
Supported lawyers at each stage and produced all required analysis and
reporting. Analysed the defendants
consultant teams activities (Arthur Andersens) and produced refutation of
their propositions.
Created the Eurotunnel database live and development environments operated as
DBA and developed the first 3 applications with a small team to meet the first
performance target for release of money.
Set up many more databases over 3 years and acted as senior DBA until
handing over to permanent staff. Then
designed and developed 3 more applications including a very, very large
text-retrieval database to provide litigation support and a configuration
control system. The developments were
done with small teams where I designed and then developed the applications. Finally the last 2 years were spent tuning
all the applications developed in Eurotunnel over the previous 7 years. A lot of code, but many systems turned into
much more useful systems through the speed-ups achieved.
Timeline
|
|
From |
To and length |
Description |
|
32, (30) |
Jan -16 |
|
Eurotunnel. Link with chosen supplier to provide a
specification they can work to. Do
next level design of processes, schema, and continue as design authority. Convert PL/SQL to t-SQL for many
processes. Continue detailed analysis
of ET business. |
|
31 |
Nov 15 |
June 16 8 months |
NOW pensions. Take over daily data loads. Design and build processing and reporting
suite for Late reporting T-SQL.
Support users with analysis and reporting on database. |
|
30, (29) |
Jan 14 |
Oct 15 9 months |
Waiting for phase 1
at Eurotunnel to finish! Carry out SQL
Server experiments to ensure that design works. Interview potential suppliers and carry out
investigation of their proposals.
Produce documents to further define the proposed solution of (29). Only part-time. Writing books to fill in. |
|
29 |
Sep 14 |
Dec 14 4 months |
Produce a
specification of a database system to replace SAP CRM within Eurotunnel. Analyse the data and current
processing. Produce a data model to
hold the data. Carry out first phase
design: define processes to collect data, clean it, disseminate it and report
on it. Produce interface to
Qlikview. Carry out detailed design of
many processes to prove any assumptions made.
Provide documents and presentations for senior management. Provide planning and estimates to enable
suppliers to quote for the work. |
|
28 |
Mar 14 |
Aug 14 6 months |
Return to charity
(26) part time. Analyse data and
report to retention staff. Fix large
data structure errors. |
|
27 |
Oct 13 |
Feb 14 5 months |
Return to Sodexho to
provide Oracle expertise during transition to a different user
interface. Analyse data warehouse
using SSIS and SSAS and fix non-performance, T-SQL procedures and new cubes.
.NET, C# (small) PL/SQL 11g |
|
26 |
Feb 13 |
Oct 13 8.5 months++ |
Analyse CRM database
run under ThankQ in SQL database and report to director. Advise on how to improve their data. Convert my tools from PL/SQL to T-SQL to
cleanse their data. Advise on
expansion and how to generate more income.
Carry out analysis of their data and set up automated analysis. Fix SQL errors in generated reports. Generate templates (standards) for their
data entry to improve the quality of data going into the database. Do the dedup and merge. Carry out data loads and automate the
procedures. |
|
25 |
Sep 12 |
Jan 13 5 months |
Build music website
for entertainer. Develop server for
the site using Raspberry Pi! Build
multiple Oracle databases in a VMWARE environment running Linux. |
|
24 |
Feb 12 |
Aug 12 |
CGG Veritas: build interface to move data from database pairs to remote ones with low bandwidth comms. On different continents, process the data at the remote site and return the results. This was mostly PL/SQL triggers, a package and many package modifications. Interfacing to systems with no documentation forensic programming!10g, PL/SQL, Toad, SQL Developer |
|
23 |
Aug 11 |
Jan 12 6 months |
Building wine database and query system with web access using MySQL |
|
22 |
June 10 |
July 11 |
External consultant at Ab Initio. Short engagements linked to database interfaces in healthcare, banking and name and address processing. Built parser and formatter for Informix SQL. Converted interfaces to Teradata and SAP. Built PGP graphs. Attended many courses and helped to deliver the basic course three times. |
|
21 |
Dec 09 |
May 10 6 months |
Engaged as design consultant by EDF to advise on overall Design of the RDB database system and structure, and how it interacts and interfaces with SAP CRM and BI systems. Achieved: High Level design document and identified key architectural design issues and risks and associated solution options. Designed near real-time interface with SAP. Verified design with pilot. PL/SQL 10g |
|
20 |
April 09 |
Nov 09 6 months |
Design and build
image processing system used to find matches in a forensic database for C
and C. PL/SQL and Oracle forms.
Supporting Javelin. Continue with
certification study. Java and PL/SQL |
|
19 |
Oct 08 |
March 09 6 months |
Bring C and C
name and address processing up to the Javelin standard. Carry out and win 3 competitive dedup
competitions. Implement the dedup and
merge for two of those contracts.
Return to being a DBA and start conversion of name and address
processing into SQLServer. PL/SQL. |
|
18 |
May 08 |
Sep 08 5 months |
Studying for Oracle
DBA certification, Java certification. Writing book. Supporting Javelin and enhancing name and
address processing. PL/SQL, Java |
|
17 |
Jun 06 |
April 08 23 months |
Sodexho: System review and database tuning. Project analysis. Testing. PL/SQL. Near real-time interface between internal
system and Pivotal CRM in PL/SQL Design, design database, build, test. Design build complex scheduling and
reporting system to automate company production full life-cycle Oracle V9. |
|
16, (14, 8) |
Feb 06 |
May 06 |
Eurotunnel and
Informa PLC: Product design,
development and support, data loading for Informa PLC and Eurotunnel. Oracle V8/V10, PL/SQL, Forms V6i, Perl,
Java |
|
15 |
Jan 06 |
Jan 06 1 month |
Informa PLC: Develop and deliver short course on Database
Tuning to DBAs and developers. Oracle
V9 |
|
14 |
Jan 02 |
Dec 05 48 months |
Topnet: Designer, Developer, DBA, Perl, Forms 6, SQL,
PL/SQL. Direct Mail, ETL, Data
warehouse, AI, SAP CRM interface, multi-dimensional analysis, |
|
13, (11) |
Mar 01 |
Dec 02 10 months |
Inphomation/Worldcom: PL/SQL, DBA, SQL, ETL, Unix. Litigation support |
|
12, (6) |
Jan 01 |
Feb 01 2 months |
Maracis/NHS: |
|
11 |
Feb 00 |
Dec 00 11 months |
Inphomation/ATT: rescue database, analysis, process call data
for litigation, development, Unix, PL/SQL, SQL, ETL. |
|
10 |
Apr 99 |
Feb 00 11 months |
Allders: Database monitoring and tuning DBA, PL/SQL,
Unix, Y2K, disaster recovery. |
|
9 |
Sep 98 |
Mar 99 7 months |
Woolwich: Production DBA, tuning, set up for 24/7
running, produce diagnostic scripts, fault tree production, disaster recovery |
|
8 |
Oct 97 |
Aug 98 11 months |
Topnet :
Direct marketing, ETL, Forms 3, Javelin re-write in PL/SQL, DBA, SQL,
VMS, product support. |
|
7 |
Dec 96 |
Sep 97 10 months |
Digicon: Oil exploration monitor DBA, Developer 2000,
database tuning, Unix, state modelling, PL/SQL. |
|
6 |
Jul 96 |
Nov 96 5 months |
Maracis/NHS:
Mental health database, DBA, database tuning, data loading, SQL, Unix.
|
|
5 |
Jul 96 |
Sep 96 3 months |
British Army at Rhinedalen: DBA course develop, deliver,
hand over. |
|
4 |
Mar 88 |
Jun 96 100 months |
Eurotunnel: Set
up first databases, development and LIVE environment, design, develop, SQL,
PL/SQL, c, SQL*Textretrieval, DCL, ticket systems, configuration management,
litigation support, DBA, database tuning, DBA courses, VMS, team leader. |
|
3 |
Mar 87 |
Feb 88 12 months |
Maclarens:
Develop Direct Marketing System.
Forms 2.1, DCL, DBA, SQL, DCL, VMS, Pro* Cobol |
|
2 |
May 86 |
Feb 87 10 months |
Stock Exchange (Big Bang): Billing system, OCI
Pro*Pascal, SQL, VMS |
|
|
|
|
|
|
1 |
Up to |
Apr 86 |
Multi-threaded,
multi-processor design and development of real time systems controlling radar
systems and telephone exchanges.
Running teams with design responsibility. |
Education and qualifications
BSc. Hons. (1st class) Computer
Studies
PhD. Numerical algorithms for large
data sets
MBCS, CITP
Oracle 1Z0-001 - 100%
- 5/3/07
Oracle 1Z0-147 - 97% - 20/9/07 and achieve Oracle Certified Associate
Oracle 1Z0-101 - 98% - 11/10/07
Oracle 1Z0-141 - 97% - 24/12/07 and achieve Oracle Certified
Professional
Published papers and articles Too
boring to list and available on request.
Now added hyper-book on software development. Also on www.rickcc.com
References - Available on request