Data Warehouse Developer Resume Profile

Summary

I am writing in response to your advertised position: SAS Guru. My time with my current employer, has allowed me to become an expert using the SAS Enterprise Business Intelligence - EBI Platform from integration to presentation, including and not limited to:
SAS EBI Platform Administration: install and upgrade on a UNIX OS
SAS EBI Tools: Base SAS Management Console, Data Integration Studio, OLAP Cube Studio, Information Map, Enterprise Guide, Web Report Studio, BI Dashboard Viewer, Information Delivery Portal, SAS Deployment Manager and Office Analytics including Add in for Microsoft Office.
Data manipulation and staging of transactional OLTP data
Utilize data efficiently from Data Warehouse technologies and best practices.
Analytics and Data Mining exploit staged data to find meaningful patterns for model training, scoring and assigning probable outcomes with SAS Enterprise Miner
I would be pleased to provide you with more information on this when given the opportunity to meet. If you will contact me at, we can set up an appointment.

Objective

Seek to fill role as SAS Guru to reliably use SAS tools for business.

Technical skills

Relevant Applications:

SAS EBI Platform, CA/Erwin, Microsoft SQL Server DW/BI RDBMS,SSIS,SSAS, Crystal Reports, Cognos, SAP, Micro Strategy, Informatica, Oracle 11g, JBOSS

Data Manipulation Languages/Programming:

SAS Macro, SAS Graph, PROCs, Data Step, SQL, ETL, OLAP MOLAP,ROLAP, MDX, UML 2.0, JavaScript
Platforms:
Unix AIX, Microsoft Windows, Linux

Relevant Experience

Data Warehouse Developer

Confidential

Maintained Data Warehouse database including optimization of tables by indexing
Architected and Developed a successful class scheduling and enrollment management drill-down/drill-across SAS OLAP reporting solution allowing to better utilize available location resources
Designed and Developed dashboards with SAS BI Dashboards
Front Room SAS BI Architect including development and implementation user interface, JBOSS web portal
Architected and Developed Enrollment and Registration Trend Model via SAS EBI
Wrote MDX measures on all SAS OLAP cubes
Designed and Developed modular ETL Flows and Data extract Scheduling Automation Process, including CDC
Trained/mentored programmers in SAS DW/BI System
Imported/Exported metadata from CA ERWIN data model tool and implemented from logical to physical
Managed Metadata: Business, Technical and Process
Analyzed, designed and developed BI SAS Security Environment using SAS Management Console
Migrated and installed SAS 9.2 BI Enterprise Server EBI on AIX multi-tier server Meta, Compute, Web from SAS 9.1.3 EBI including 9.2 TSM3 upgrade
Set up SAS 9.2 DW/BI System Architecture
Migrated/Converted Cognos Reporting System to SAS 9.1.3 Enterprise Server
Implemented Development, Testing and Production environments as well as promotion process
Documented processes for user training

Research Assistant

Confidential

Gathered and reported on Community Vision's Key County Statistical Indicators 2004
Developed outcome evaluation reports with SPSS

Math Tutor

Confidential

Tutored all undergraduate math and statistics