We provide IT Staff Augmentation Services!

Data Warehouse Resume

St Petersburg, FL


Bachelor of Science in Business Administration
Major: Management Information Systems


Confidential,St Petersburg, FL
Data Warehouse Technical Lead
(September 2012 – January 2013 )

Performed initial data warehousing, system integration, and business intelligence needs assessment for Medicare and Medicaid claims processing , administration, and care management. Identified initial KPI’s from care management group and existing applications, reporting systems, and databases for phase 1 implementation into a SQL Server-based Enterprise Data Warehouse. Worked closely with dba group to create hardware and database specifications for a 5 layer Enterprise Data Warehouse as well as process architecture for loading(ETL), reporting, and ad hoc querying. Helped evaluate tools to interpret claims file format 837 and other EDI X12 5010 files. Evaluated and recommend ad hoc reporting vendors and tools that best fit users with low technical experience needs. Developed database objects and reports using the SQL server BI stack per project request specs.

Primary Technical Applications:
Microsoft SQL Server 2008 R2, Microsoft SSIS, Microsoft SSRS, Microsoft BIDS, T-SQL

Confidential,Tulsa, Ok
Senior Data Warehouse Developer
(August 2003 – September 2012 )

Worked as part of a 4 member team on a complete data warehousing assessment, development, and implementation. Initial effort was focused on interviewing various people within the company in order to gain an understanding of the current data environment within existing data marts, the current reporting procedures, and the functionality of the existing operational systems and reporting. The presented solution contained data models for a three layer ‘Kimble-based’ warehouse architecture. Source to target data mappings from initial source through all three layers including staging, ODS, and warehouse structures were developed as well as high level ETL processes. Primary development tasks involved designing and developing the complete ETL architecture including error handling and task auditing processes as well as a standard workflow model for all ETL processes and then developing the specific packages and stored procedures used to transform and load the data into the warehouse. Over eight years, the Samson data warehouse has evolved into a 500GB set of databases and data marts that serve as a source to user reports, DW-direct applications, application databases, and direct user querying.

Primary Technical Applications:
Microsoft SQL Server 2000 – 2008 R2, Microsoft DTS, Microsoft SSIS, Microsoft BIDS, T-SQL, COGNOS REPORTNET, VB script, Java Script, Microsoft DOT NET

Confidential,Tulsa, Ok
Senior Consultant
( June 2000 – August 2003 )

Involved with a consulting team in the development and implementation of a datawarehouse and direct marketing analysis system for Oklahoma’s largest publications company. This warehouse was created in an Oracle 8i RDBMS. The ETL process was executed primarily with the use of PLSQL packages as well as some direct transfer of data using SQL Loader. The user interface for specific analysis of the data was created using the Cognos suite of tools.

Participated with a team of consultants from Stonebridge Technologies and Tibco, Inc. in integrating several sources of key financial data for Williams EM&T into a single web-based portal using the Tibco suite of products. Primary responsibilities in this project were gathering requirements from users, providing solutions for how to best capture the data for delivery to the portal, and developing portions of the portal to display the requested information.

Participated in the installation and customization of Livelink web-based knowledge management and workflow processing software for a local telecom company. Also improved the Livelink reporting system for the client by developing and implementing a set of Java Servlets and JSP’s connecting to an Oracle 8i back end.

Primary Technical Applications:
Oracle 8i RDBMS, PL SQL, T-SQL, Microsoft SQL Server 2000, Microsoft DTS,
Java/J2EE, JavaScript, HTML, XML, Livelink Knowledge Management / Workflow Processing software,

Tibco - Portal Builder 3.0, Active Database, Rendezvous

Confidential,Tulsa, Ok
Powerbuilder Developer
( August 1997 – May 2000 )
Underwent training in Powerbuilder 6.5, PFC, SQL, and Relational Database theory and development. Employed as a consultant to the Vyvx division of Williams Communications Group. Participated in the complete systems development life cycle of creating an order entry, product distribution, and billing software application using Powerbuilder 6.5, PFC, and Transaction SQL interfacing with a Sybase SQLserver RDBMS.

Primary Technical applications:
Powerbuilder 6.5, PFC, Transaction SQL/ Sybase SQLServer, Object Cycle

Confidential,Tulsa, Ok
Mainframe Software Developer
( March 1996 - July 1997 )
Assisted Oklahoma’s largest health insurance organization in ongoing maintenance and development projects for both batch and online systems. Help to provide business solutions through investigation, development, and implementation of automated information systems. Responsible for maintenance of provider and pricing IMS databases as well as new development projects to expand these.

Primary technical applications:


Confidential,Austin,TX/Kansas City,MO
Mainframe Software Developer
( January 1995 - March 1996 )
Assisted in development and maintenance of VANTAGE-ONE life insurance software. Designed reports, programmed modifications, and performed system version upgrades.

Primary technical applications:

COBOLII, JCL, Easytrieve Plus, VSAM, CICS, TSO, Endevor

Hire Now