Data Project

Byung Ick Lee ( Ken Lee)

** ************ **, *****, ** 07470

E-Mail : *****@**********.***

Phone : 201-***-****

Objective SAP BW/BI Consultant.

Profile Over 4.5 years of experience as SAP BW consultant.

Experience in over 5 full life cycle implementation of BW

project.

Experience with BW 3.5 to BI 7.o Upgrade.

Production support and maintenance of BW/BI system

Query implementation and Reporting

Skill Data Modeling

Defining and implementing multi-dimensional, logical and

physical model

Analytical skills to translate business requirement to system

design.

Data Acquisition

Data Extraction from both non-SAP sources(DB Connect, Flat

File, UD Connect) and SAP sources including Standard Business

Content, delta extraction and generic data sources from SD and

MM module.

Transformation

Start Routine, End Routine, Expert Routine and Rule Group in

BI 7.0 and Transfer Routine and Update Routine in BW3.5

Data Distribution/Reporting

BEx Analyzer, BEx Designer, and WAD development including Auto

Mailing System configuration.

Implement Open Hub's Infospoke to extract data to non-SAP

system.

Administration and Monitoring

Configuration of Infobojects, ODS/DSO, Infoproviders, Data

Sources, Transfer/ Extract Structure, Communication Structure

including Transformation and DTP in BI7.0.

Performance Optimization

BW performance management using BW statistics and new BI

Administration Cockpit.

Configuration of Data Transfer Parameter for general data,

ODS, Data Mart, and DB Connect.

User Management

Implementing and designing user role security/management.

Production Support

Monitoring, Trouble shooting, User Training and Technical

support.

Experiences JPM Consulting Global Inc., San Jose, CA

2005 - present

SAP BW/BI Consultant

Client : MagnaChip Semiconductor, Seoul, Korea

Project : New Client Initial Setup.

Tasks : Data Migration/ Remodel - Infoprovider,

DataSource, Query, Transformation,

Technical BCT according to new company standard.

Project : BW 3.5 to BI7.0 Upgrade.

Tasks : Functional Migration - DataSource, Query,

Transformation,

Technical BCT installation and Data extraction using DTP.

BI System monitoring with new BI admin workbench.

Process Chain development for master and transaction data.

Performance Optimization-BI parameter setting for data

transfer.

Project : I. ASP Trend (Average Sales Price Trend)

II.VMI (Vendor Managed Inventory)

Tasks : Data Modeling / Data extraction from R/3 Standard

and CBO tables.

Transformation - Transfer /Update Rule enhancement.

Report development with BEx Query designer and WAD.

Project : Revenue Forecast vs. Actual

Tasks : Data extraction from i2 solution using DB

connect.

Data modeling/Implementation with MultiProvider from various

data sources.

Transformation - Transfer /Update Rule enhancement.

Report development - Query development using Variables with

Customer Exit function.

Project : Capital Expenditure Reduction

Tasks : Data extraction from R/3 CBO tables.

Data modeling/Implementation - Data flow design with ODS.

Report development with RRI(Report to Report Interface).

Project :Human Resource :PA(Personal Administration) and

Organization Management Implementation

Tasks : Business content Activation/Installation.

Master Data and Transactional Data Extraction from R/3 to BW.

Transfer Routine enhancement.

Query implementation/ enhancement and web report publishing.

Other Projects :

Information Broadcasting-Web Reports Mailing System

Master Data -Vendor Master and Material Master Attribute

addition and Maintenance

Purchasing Progress Project-PR-PO-GR Progression Status report

for Purchasing Dept.

Education BW Training, Khoj Information Technology Inc., Oakland, NJ

M.F.A., Computer Art, Academy of Art University, San

Francisco, CA

B.A., Computer Science, New Jersey Institute of Technology,

Newark, NJ

Contact this candidate