ETL
Rich

Professional Summary

A Senior Data Warehousing position at an organization requiring expertise designing, developing, testing and implementing secure, scalable and high-performance BI and analytic solutions

15 Years Data Warehousing
20+ Years Oracle Development

Education

  • Manchester Metropolitan University

Professional Experience

Cisco Systems
Duration
April 2002 – Sept 2016 (14 years 5 Months)
Role
Sr IT Engineer/Tech Lead
Responsibilities
My role is in the HR and Finance BI team
I designed and built the HR data warehouse based on Oracle RAC. I designed and developed the ETL using Informatica and PL/SQL. I am responsible for database design including the star schema data model. Create and apply standards and best practices. Perform Performance tuning of the ETL, database and reporting SQL. The HR data warehouse is the source of HR data for the Teradata Enterprise data warehouse. Use Agile/Scrum and continuous delivery methodologies. Mentor and guide junior developers in design and developmentWork with cross functional teams and collaborate with team members across different regions.

Projects include:
Convert source system from Peoplesoft to Oracle HRMS
Added external data sources for Staffing (ADP Virtual Edge, Avature)
Database performance tuning with Oracle expert systems
OBIEE Manager Metrics and HR Business Intelligence with over 12,000 users
Tableau Enterprise Learning Tool
Performance tool to capture SQL from OBIEE for regression testing
Slowly changing dimensions including hierarchies
Cisco Big Data Analytics (Hadoop, MapReduce, Sqoop, Spark, Hive, Python)
Environment
Oracle 12c OBIEE PL/SQL Informatica UNIX Linux C Perl shell scripts Hadoop Hive MapReduce Oracle ERP Oracle HRMS Oracle RAC SQL TOAD Rally Performance tuning
Smartage.com
Duration
March 2000 – July 2000 (5 months) San Francisco Bay Area
Role
Senior Database Engineer
International Programming & Systems, Inc.
Duration
October 1994 – February 2000 (5 years 5 months)
Role
Contract Database Engineer
Contracts at:
Hewlett Packard
GE Capital Container Finance
Bank of America
Roche Bioscience
Pacific Bell Information Services
GT Global Capital Management
Self Employed Contractor, London, United Kingdom
Duration
March 1988 – August 1993 (5 years 6 months)
Role
Contract Database Engineer
Responsibilities
Prudential portfolio management
Price Waterhouse
Morgan Grenfell
National Grid
British Telecom
Guinness Plc
Shell Chemicals
Bata Footwear Canada
Trustee Savings Bank England & Wales
Drexel Burnham Lambert Securities
Duration
1987 – 1988 (1 year)
Role
Analyst Programmer
Liberty Life Assurance
Duration
1985 – 1987 (2 years)
Role
Junior Analyst/Programmer