Project Info

• Created By
  Echo Simanjuntak
• Client
  PT. Bank Tabungan Pensiunan Nasional, Tbk
• Year
  2011
• Category
  Data warehouse

Project Description

• Consolidated Staging Database using Microsoft SQL 2008 R2 Database to MS SQL 2008 R2 Data warehouse Database
• ETL using Microsoft SQL 2008 R2 Data Integration services
• Create 15 Data Mart Cube in OBI (Oracle BI) Repository
• Maintain Dashboard design and reporting either in BI: Publisher or BI: Answer (BI Analysis)
• Create 15 reports analysis from each cube as a sample
• Creating report standard template for BI: Publisher / XML publisher from current iSeries report / Crystal Report

Technologies

• MS SQL 2008
• OBIEE 11g
• Windows Server 2008

Role

• BI Developer