Deloy B. Cox

*** **** **** *****

American Fork, UT 84003

801-***-****

Email: aboanj@r.postjobfree.com

introduction

Seasoned Oracle/SQL Server database professional with 20+ years of

diversified experience in software development, analysis, design,

administration, and project management. Recent emphasis on ETL,

Data Warehousing and Business Intelligence functions.

SkillS OVErview

Business Objects Data Services

Back-end Development Create/maintain BODS 3.2, 4.0 Projects, Jobs,

Work Flows, Data Flows (standard and embedded), Datastores (Oracle

11g/Exadata) and associated sub-components such as transforms

(query, case, pivot, map operation, data transfer, merge, SQL,

validation, etc.). Development activities include re-write of

existing batch processes and on-going backend batch processing

interface development and maintenance.

Microsoft Business Intelligence and Database Systems

Back-end Development SQL Server Analysis Services (SSAS) 2008 R2

(OLAP), SQL Server Reporting Services (SSRS) 2008 R2. SQL Server

T-SQL.

Front-end Development SQL Server Reporting Services (SSRS) 2008

R2 and Excel 2010 to create and maintain reports, charts and

queries.

MicroStrategy Business Intelligence System

Back-end Development MicroStrategy (7.x/8.x). Maintained

logical data model and physical schemas.

Production Support Software Installation & Upgrade, System

monitoring, software license tracking, and user access

administration.

Ascential DataStage ETL System

Back-end Development Ascential DataStage (7.2). Developed and

maintained ETL scripts feeding into database for business

intelligence system.

Production Support System monitoring of daily ETL processes.

Relational Database Systems

Operating Systems MS Windows, HP_UX

Databases Oracle 9i/10g,11g, MS SQL Server 2005/2008/SSAS/SSRS,

Sybase

Languages SQL, PL/SQL, Transact-SQL, Visual Basic

Data Warehousing Requirements/Business Analysis, ETL, Data

Cleansing, Logical/Physical Database Design and Development,

Multidimensional (OLAP) Design and Development, Database Tuning,

Design and Development of Data Marts, Operational Data Stores,

Star/Snowflake Schemas

Applications Business Objects, HP OpenView Service Desk, Quest

Software, Embarcadero, MS Visio, ER/Studio, S-Designer, ERwin,

PL/SQL Developer, TOAD, Crystal Reports

Business Skills

Systems Analysis Requirements gathering, fact finding and legacy

system analysis, metric creation and standardization, scope

definition, prototype and proof-of-concept delivery, report layout

design and presentation

Teamwork Self-motivated and able to work independently, or in a

team

Other Strong customer service ethic, Ability to travel as needed

Industry Experience

Finance, Sales, Mining, E-Commerce, Transportation, Education,

Human Resources

Experience

Sr. Data Warehouse Engineer 2011-2013

The Church of Jesus Christ of Latter-day Saints (Riverton, UT)

ETL / Data Warehouse Developer

Primary duty was using SAP Business Objects Data Services (BODS)

software to create scripts to load data into a large Oracle (11g -

Exadata) data warehouse. These responsibilities included new

development, maintenance, production support and troubleshooting of

batch loading processes.

Tasks involved a complete re-design of the production ETL process,

enabling a weekly refresh of the data warehouse for highly improved

data quality and data loading performance. The data warehouse

includes multiple tables exceeding 100 million rows in size.

Tasks also involved design and maintenance of data warehouse tables

using dimensional modeling (Kimball star-schema) methodologies.

Worked in a structured environment of front-end development,

database administration, QA, and system administration teams.

Sr. Data Warehouse Developer 2006-2011

Rio Tinto, Inc. (South Jordan, UT)

Member of Reporting and Analytics Team for a Large International

Mining Company

Developed and maintained data warehouses and reporting systems for

tracking mining processes, using SQL Server Analysis Services

(SSAS) (OLAP) and SQL Server Reporting Services (SSRS), and

MicroStrategy Business Warehousing Services (ROLAP), as business

intelligence tools.

Developed and maintain reports for HR Planning System.

Re-designed the SQL Server Analysis Services OLAP cube to improve

data loading and resolve performance issues

Developed and maintained ETL processes, using IBM (Ascential)

DataStage, for loading data into sales and marketing (Oracle) data

warehouse. Administration and maintenance of the business

intelligence reporting system (MicroStrategy).

Applications Engineer (Contract & Full Time) 2002-2006

Novell Corporation (Provo, UT)

Lead Architect for Enterprise Sales Reporting Data Mart

Designed and maintained Oracle Operational Data Store (Data Mart)

using dimensional modeling and star schema (Kimball) approach for

Sales reporting.

Designed all data refresh processes and report queries for

enterprise reporting system

Contracted to help design and develop enterprise reporting system

for large corporate sales organization

Designed a new Operational Data Store using dimensional modeling

and star schema approach for Sales reporting.

Re-designed data population SQL scripts used to populate report

data repository, reducing data migration runtimes by 66%.

Re-designed system functionality for maintaining page-level

security on web-based corporate sales reports.

Designed and developed corporate sales reports containing corporate

security.

Contract Developer 2001-2002

NS Arrow Corporation/TruTek (American Fork, UT; Salt Lake City,

UT)

Contracted for Analyst/Developer duties for enhancements to the

corporate partner authorization system.

Migration of a financial point-of-sale tracking system from Sybase

to Oracle 8.x database for PowerBuilder client.

Designed and developed Oracle PL/SQL processes for linking

financial point-of-sale and authorized partner tracking systems.

Ogio - Contracted to design interface for EDI Sales Orders process.

Helped to map the EDI sales order form field translations between

EDISoft and Oracle E-Commerce tables.

Developed Oracle PL/SQL script to perform import, field translation

and export of the sales order records.

BETrans, LLC - Contracted to Design/Develop new Oracle database for

tracking vehicles in the freight transportation industry.

Designed and developed the Oracle 8i database for the web-based

vehicle tracking system.

Griffin Corp - Contracted to develop a system for tracking tax

exempt statuses for a major health firm.

Created database and client program using Microsoft Access database

and client technologies.

Contracted to Optimize Oracle database tables and SQL scripts for

new internet technology company.

Re-designed (normalized) Oracle database tables and indexes.

Optimized and re-created existing SQL statements to reduce

processing times by as much as 78%.

Oracle Systems Development/Sr. Software Engineer 1999-2000

PointClick.com (NetPartner, Inc.) (American Fork, UT)

Lead Developer for all Oracle Database design and development for

internet e-commerce company.

Lead engineer on Oracle development team of 6 individuals.

Developed the core PL/SQL processes for validating and processing

high volume, real-time, e-commerce traffic.

Developed prototype for the back-end of a new e-commerce tracking

system that added extensive dynamic capabilities.

Developed and maintained numerous complex database views for

real-time balance tracking, and implemented extensive performance

and tuning measures.

Application Engineer/Business Analyst 1990-1999

Novell, Inc. (Provo, UT)

Developer for Corporate Leads Data Collection and Standardization

System.

Lead developer for sales leads collection and data cleanup system

requiring extensive Oracle PL/SQL.

Performed minor database administration tasks for Oracle database

on Windows NT platform.

Siebel 98 Sales Force Automation System Development and Maintenance

Sole resource for design and development of a leads collection and

data cleanup system using Oracle PL/SQL.

Lead resource for migration of Sybase-based Partner Tracking System

to Oracle-based Siebel System.

Developer of a PowerBuilder/Oracle PL/SQL based utility for

enhanced data migration from existing systems.

Developer for Client/Server Systems

Lead analyst and developer for a corporate point-of-sale tracking

system using PowerBuilder 5.x/Sybase 11x. Developer of 4 major

system enhancements, which provided 60%+ increase in user

productivity.

Designed and development a facilities maintenance work order

tracking system with security base on signature level authority.

Client development using PowerBuilder 2.x, 3.x.

Education

B.S., Operations & Systems Analysis

Brigham Young University, Provo, Utah

A.S. General Education

Dixie College, St George, Utah

Contact this candidate