Data Sap

Byung Ick Lee ( Ken Lee)

** ********* ****, ***** *******, NJ 07508

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

Phone : 914-***-****

Objective

Creative and detail-oriented BW / BI Analyst with over 6

years of extensive, global, multi dimensional IT experience

seeks employment in the fields of SAP BI.

Profile 6+ years of extensive, global, multi-dimensional experience in

IT.

Production support and maintenance of SAP BW system.

SAP BW 3.5 and BI 7.1 experience in migrating, upgrade, and

development.

SAP BW training and documentation for North American HQ

leadership and team.

Partnered with strategy, creative and technology leadership to

tailor unique programs in response to internal clients'

business requirements.

Skills Technical :

Data Modeling

Defining and implementing multi-dimensional, logical and

physical model

Analytical skills to translate business requirements 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.

Transformation

Start Routine and End Routine BI 7.0 : Transfer Routine and

Update Routine in BW3.5

Data Distribution/Reporting

BEx Analyzer, BEx Designer, and WAD development including Auto

Mailing System configuration.

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.

Line Item Dimension/High cardinality, Aggregation and

Compression of the InfoCube.

User Management

Maintain user role security/management.

Experiences Carl Zeiss Inc, Thornwood, NY

2010 - present

SAP BW/BI Analyst

Roles and Responsibilities :

Provide all BI related support to 6 Carl Zeiss Companies in

North America.

(Meditec, Microscopy, IMT, SportsOptics, Carl Zeiss Canada,

SBE)

Perform feasibility studies, translating conceptual business

requirements into functional requirement for BW reporting

realization in the BW system.

Identify conflicting business practices & integration issues

that inhibit the attainment of project goal and suggest

alternative solution.

Conduct BW training to BW end-users and power users.

Collaborate with Business Intelligence Team in HQ(Germany) on

Internal and Global BI Projects.

Provide leadership and management to outsourced partners

responsible for SAP BI application planning, design and

development.

Manage and track the status of requirements throughout the

project life cycle: enforce and redefine as necessary to

fulfill business requirement.

Data load monitoring and repair staging processes to ensure

data accuracy for companies world wide.

JPM Consulting Global Inc., San Jose, CA

2007 - 2010

SAP BW/BI Consultant

Client : MagnaChip Semiconductor, Seoul, Korea

Production Support for SAP BW : Troubleshoot, Data Load

monitoring and end-user Support

Analyze user request and transform into technical

specification for development.

Conduct BW Training for end user and management and BW manual

creation.

BW Project :

-New Client Initial Setup.

Tasks : Data Migration / Remodelling of Infoprovider,

DataSources, Query and Transformation

for the new company code and new standards .

-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.

-ASP Trend (Average Sales Price Trend) and 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.

Performance Tuning using Aggregates/Roll up.

Information Broadcaster : Automated reports distribution via

E-mail.

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.

-Capital Expenditure Reduction

Tasks : Data extraction from R/3 CBO tables and Flat file

data loading.

Data modeling/Implementation - Data flow design with ODS.

Report development with RRI(Report to Report Interface).

Education Performance Tuning using Line Item Dimension / High

Cardinality

SAP Course : BW370 Integrated Planning, BC400 ABAP Workbench

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