SUMMARY:

• 20 years of business systems sales, design and development, over 5 years in sales, 10 years in data warehouse implementation and over 20 years in database design.
• He has lead and participated in countless projects and managed many people in his team over the years.  
• He has been working with Oracle systems integration and development projects for 15 years.
• He is a certified Teradata Master and has been working on Teradata solutions for over 10 years.

TECHNICAL SKILLS:

Software/Tools: Teradata, Oracle, Teradata Viewpoint, PMON, TASM, Multiload, Fastload, Fastexport, TPump, BTEQ, Performance Tuning (UPI, NUPI, Partitioning, Teradata Columnar, USI, NUSI, JI, Temporary Tables, etc.), Teradata Explain, Teradata Visual Explain, Statistics Collection, DBQL, Linux/Unix Shell Scripts, ETL, MySQL, SQL, PL/SQL, Toad, Oracle SQL Developer, Oracle PL/SQL Developer,SQL Plus, Erwin Data Modeller, Oracle Data Modeller, Triggers, C, Perl, Data Wharehousing, Star - schema, metadata, stored procedures, packages

PROFESSIONAL EXPERIENCE:

Confidential, Victoria, BC

Data Integration Consultant

Responsibilities:

• ENKON created an integrated Land Titles System for the Government of Botswana called LIS (Land Information System). Currently, Botswana has many limited systems with many manual paper based processes.
• Responsible for migrating all existing data from 7 different systems into LIS for the initial production release and is responsible for setting up integration interfaces with another 8 different systems when in production.
• Role has involved travelling to Africa and consulting with the highest levels of Officials in the Government of Botswana to gather and analyze requirements.
• The list of Officials consulted with include the Permanent Secretary of Botswana, Surveyor General of Botswana, Directors and other Departmental Heads, Technical Architects, Programmers, DBA’s, and Analysts.
• As the Integration Lead also responsible for database analysts, data modelling and providing Architectural direction and technical IT support. Have been hands on doing technical developer work and assisting team members by assisting them in development work to meet tight deadlines.
• Main hands on work was creating ETL/ELT code from various source systems into the new LIS system. Also, created technical documentation for all code personally created for sign-off by customer.

Confidential, Miamisburg, Ohio

Senior Teradata Consultant and DBA

Responsibilities:

• Senior Consultant for Teradata’s DCM (Demand Chain Management) product.
• The DCM solution is designed to manage and improve inventory management and forecasting at the retail level.
• DCM is used by many fortune 500 companies across North America.
• Leadership role in customer presentations, RFP’s (request for proposal), demo’s, consultations, general sales support, complete Performance Benchmarking (Teradata, DCM, Linux, Front End, etc.), POCs (Proof of Concept - which included creating Teradata databases and installing DCM from scratch on internal and customer environments before starting POC ), and customer support.
• This work also included Teradata DBA work such as understanding Teradata Optimizer and performance tuning and monitoring using Viewpoint, PMON, DBQL, and TASM.
• Queries performance improvements made by using appropriate indices such as UPI, NUPI, NUPI, NUSI, partitioning, JI’s, temporary tables, statistics, etc.
• Data loaded (ETL/ELT) into the Teradata Database for many different clients using a vast array of products and techniques including tools such as shell scripts, Perl, SQL Scripts, Multiload, Fastload, Fastexport, TPump, BTEQ, etc.
• Data was in many different formats and sometimes located internally within client systems with only certain technologies available and choice of ETL tools and methods had to be choose accordingly.

Confidential, Seattle, WA

Physical Data Architect

Responsibilities:

• Data Architect responsible for implementing Boeing’s C ommon Data Warehouse that has approximately 40 source systems using various technologies such as Oracle, DB2, SQL Server, etc. integrated into a single Teradata Data Warehouse.
• Work included temporal design and implementation, performance analysis, physical design, SQL optimization, DBQL reporting, Cognos BI Analysis, and mentoring junior team members.
• Architecture role also included but not limited to ownership of documents/specifications (P+/Macroscope), making final decisions on implementation decisions, ownership of schema promotion process from the Physical Data Model in Erwin, briefing management team on architectural direction and project development status, quarterly capacity forecasting (CPU and Disk), and assisting with and buying off on database upgrades.
• To implement this data architect role had to understand how the Teradata Cost Based Optimizer works and had to work on performance tuning and monitoring using Viewpoint, PMON, DBQL, and TASM. Queries performance improvements made by using appropriate indices such as UPI, NUPI, NUPI, NUSI, partitioning, JI’s, temporary tables, statistics, etc. as well as re-writing SQL statements to make them more efficient.
• Also had to write and modify data load programs to make sure they were performing adequately in production environment and not ending up in the TASM Penalty Box. Data load programs (ETL) created and enhanced used Teradata tools such as shell scripts, SQL Scripts, Multiload, Fastload, Fastexport, TPump, BTEQ, etc.

Confidential, Seattle, WA

Systems Consultant

Responsibilities:

• Writing temporal SQL queries in Oracle on Areva’s Data Warehouse. Queries included the sale price of selling futures contracts on electrical power, the value of electrical power over given time periods, the amount of power available to sell from a given company, etc.
• Also assisted in SQL query optimization for poorly performing queries.

Confidential, Victoria, BC and Seattle, WA

Various Positions

• Worked on Boeing’s BRIDGE and later BIDS projects. Both projects had use of PL-SQL, SQL, PRO-C, C, UNIX, Shell scripting, Perl, stored procedures, and triggers.
• Data Model was stored in Oracle Designer. Assigned to work on performance improvements for slow loading ETL code. Both projects had extensive use of code generators.
• BIDS had approximately 100K lines of code and the project was 97-98% generatable from Oracle Designer modelling tool with the push of a button.
• Many of the Documentation/Specs were also generated from Oracle Designer on BIDS.

Confidential

• Led development effort from preliminary analysis to customer hand off of Oracle Forms application that tracked Environment Appeals sent to the ministry.
• Data Model was stored in Oracle Designer and initial dataset was loaded via Oracle SQL Loader.
• The contract was a six month fixed bid contract bid that was achieved successfully.

Confidential

• Oracle Forms Developer on BC new public pension plan system called IPAS. Worked and or used Oracle Forms, PL/SQL, Reports, UNIX shell Scripts, Pro-C triggers, Penfax, etc. Was responsible for among other things the entire development of the purchase of service module of the system.
• Joined the project early and worked through system hand-off and the start of sustaining.

Confidential, Victoria, BC

Various Positions

• ETL work that loaded Ministries MS Access data into new Oracle database application. Data was loaded into Oracle via Oracle SQL Loader and PL-SQL, Stored Procedures, and triggers were also used.

Confidential

• Worked as PL-SQL and Oracle Forms and Reports Developer on the Ministries EMS (Environment Monitoring System).

Confidential, Victoria, BC

Various Positions

• Worked as a PL-SQL and Oracle Forms and Designer expert during the preliminary analysis of new corporate system

Confidential

• Created the Account Information Database Systems for the Community Learning Network which allowed school children, education professionals, and others access to the Ministries intranet.
• Application was modelled in Oracle Designer, used an Oracle database, and the front end used stored procedures, PL-SQL and Oracle Forms and Reports. ETL was performed via UNIX, C, and Perl.