Data Warehouse Developer Resume Orlando, FL - Hire IT People

TECHNICAL SKILLS

SAS EBI Platform, CA/Erwin, Microsoft SQL Server DW/BI(RDBMS,SSIS,SSAS), Crystal Reports, Cognos, SAP, Micro Strategy, Informatica, Oracle 11g, JBOSS
SAS ( Macro, SAS Graph, PROCs, Data Step),SQL, ETL, OLAP(MOLAP,ROLAP), MDX, UML 2.0, JavaScript
Unix(AIX), Microsoft Windows, Linux

PROFESSIONAL EXPERIENCE

Data Warehouse Developer

Confidential - Orlando, FL

Responsibilities:

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, Kissimmee, FL

Responsibilities: