We provide IT Staff Augmentation Services!

Data Warehouse Project Resume Profile

4.00/5 (Submit Your Rating)

Seoul, KoreA

Hire Now

Summary

  • 14 years of IT experience in analysis, design and development of Business Intelligence, Data Warehouse, ETL, ERP, MDM and web application systems
  • 5 years of Business Intelligence and Data Warehouse experience
  • 5 years of ETL experience using SSIS and Informatica PowerCenter
  • 5 years of BI experience using SSAS/SSRS, Cognos BI
  • 5 years of database experience using MS SQL and Oracle
  • 4 years of data modeling experience dimensional, transactional using ER-Win Tool.
  • 4 years of T-SQL, PL/SQL experience.
  • 4 years of programing experience using C , Java
  • 3 years of experience in ERP , MDM project

Work Experience

Confidential

Project Experience

Travel Agency Performance Management System

  • Designed the dimensional modeling using ER-Win in MS SQL database.
  • Developed the ETL program using SSIS
  • Developed Cube and Report using SSAS and SSRS

Regional Headquarter BI/Data Mart Project 2013

  • Data Mart implemented with airline booking, ticketing, market share data
  • Designed the dimensional modeling using ER-Win in MS SQL database.
  • Developed the ETL program using SSIS
  • Developed Cube and Report using SSAS and SSRS

Cargo Tracking BI System 2012

  • BI system to analyze the cargo tracking data
  • Designed the dimensional modeling using ER-Win in MS SQL database.
  • Developed the ETL program using SSIS
  • Developed Cube and Report using SSAS and SSRS

Headquarter BI/Data Warehouse Project

Korean Air Business Intelligence and Data Warehouse Development Project

  • Korean Air ERP Project using Oracle E-Business Suites R12, Oracle Database, Oracle SOA Suites, Oracle SSO, Oracle Portal etc.
  • Developed Cube and Report using SSAS and SSRS/SharePoint
  • Developed the ETL program using SSIS
  • ODS, EDW, DM and BI system configuration.
  • Designed the dimensional modeling using ER-Win in Oracle database.
  • Developed the MDM Master Data Management and DD Data Dictionary system using Oracle EBS PIM module in the ERP Project.

Korean Air Homepage Development and Maintenance

  • Develop and maintain the Korean Air Homepage using ASP.NET
  • Develop and maintain Korean Air Internet Booking Engine using JAVA

IT Skill

  • ETL: Microsoft SSIS 2012, Informatica PowerCenter 9.5
  • Business Intelligence: Microsoft SSAS/SSRS 2012, IBM Cognos 10
  • Databases: MS SQL 2012, Oracle 11g
  • Data Technologies: Dimensional/ER data modeling using ER-WIN tool, data profiling using Orange tool
  • Languages: C , Java, T-SQL, PL/SQL
  • OS / Environments: Windows Server, Unix Server
  • ERP: Oracle E-Business Suite R12 PIM module

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship