We provide IT Staff Augmentation Services!

Data Warehouse Developer Resume

Orlando, FL

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:

  • Gathered and reported on Confidential ’s Key County Statistical Indicators 2004
  • Developed outcome evaluation reports with SPSS

Hire Now