Mark Steen Senior Data Warehouse Consultant

Mark T. Steen

Senior Data Warehouse Consultant

Empowering Business Decisions. . .

thru information solutions

Home

Approach

Services

Resume

Tips and Tricks

Links

Contact Info
mtsteen@yahoo.com
(972) 814-4170

Personal Info
Location - Dallas, TX
Willing to relocate? - No
Acceptable Travel? - 75%

Online Resume
Professional Experience
Projects
Software/Tools
Education

Printer friendly version
Microsoft Word version

Projects

Professional Experience

Projects

Software

Education

HE Butt Grocery Company - San Antonio, Texas

Led a team of consultants to build a data warehouse for reporting on retail

pharmacy information.

Responsible for the logical and physical design (ERWin 4.0) of staging, ODS

and star schema databases.

Supervised the design and development of the ETL programs (Informatica)

necessary to populate the various databases.

Worked with the consultant and client teams to identify business rules and

gather requirements.

Approximate database size: 100G (expected to grow to 500G within first year).

Neiman Marcus Online - Irving, Texas

Reviewed the physical database design and recommended changes to

improve reporting functionality.

Consulted with the client's DBA's on MicroStrategy configuration changes

to enhance query performance on the Informix XPS database.

JC Penney - Plano, Texas
Merchandising Project

Led a team of consultants to build a data warehouse for reporting on

merchandising information.

Worked with client and consultant teams to review the physical database

design in Teradata V2R4 and implemented changes to improve reporting

functionality.

Reviewed SQL generated by MicroStrategy Platform software and implemented

changes in the model as necessary to enhance performance.
Human Resources Project

Led a team of consultants to build a data warehouse for reporting on human

resource and performance

review information.

Designed and implemented the logical data model and physical database

design in Teradata V2R3

Developed a complex view layer to support the reporting and security

requirements of the project

Implemented this solution with MicroStrategy platform software.

Lowes Home Improvement Centers - Wilkesboro, North Carolina

Designed the logical data model for a data warehouse to support the

client's human resource and payroll reporting needs.

Led joint design sessions to analyze business processes and gather

requirements.

Blockbuster.com - Dallas, Texas

Led a team of consultants to implement a narrowcast solution utilizing

MicroStrategy Broadcaster technology.

Interfaced with the client's web site systems integrator to design and develop

the data extraction process to load the Oracle 8.0.5 data warehouse that

supported this solution.

Facilitated joint sessions to develop the look and feel of the emails that

would be sent out.

Consulted with the client's IT staff on the necessary requirements for

infrastructure design.

McNeil Consumer Healthcare - Fort Washington, Pennsylvania

Analysis and design of data warehouse using MicroStrategy platform software.

Led the ETL program design effort utilizing PL/SQL in Oracle 7.3.3.4.

Worked with the consultant and client teams to identify business rules and

gather requirements.

Logical and physical design of the data warehouse.

IXC Communications, Inc. - Austin, Texas

Upgraded fact tables to Oracle8 partition tables in Oracle 8.0.5.

Advised client team on issues regarding the implementation of MicroStrategy

platform software.

Devised a new backup and recovery strategy for the data warehouse utilizing

Oracle8 partition tables and exports.

Interfaced with internal MIS staff on issues regarding physical database layout,

performance and disaster recovery strategies.

Updated documentation of the existing data model and provided advice on

possible modifications.

GTE - Marketing Information Management - Irving, Texas

Worked with a team of consultants to implement Microstrategy platform

software.

Discovered and analyzed current business rules in the data.

Designed and implemented transformation routines to move data from source

databases into the data warehouse.

Modeled a view layer within the data warehouse to better facilitate reporting

functionality.

Built reports using MicroStrategy DSS Agent.

AT&T Capital Corporation - Grapevine, Texas

Responsible for the production support a system of three Oracle databases

(production, quality assurance and development).

Developed and implemented an automated system for migrating data from

production to quality assurance to keep the two databases in sync on a monthly

basis.