Sales Engineer
Resume:
Deloy B. Cox
American Fork, UT 84003
Email: *****.***@*****.***
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