Professional Summary

Name in Full: Seungwan Noh (SAP BI BW Developer)

e-mail: acofjy@r.postjobfree.com, Contact No: 201-***-****

Over 10 years of SAP BI consulting experience in SAP, around 4 years of

Data Warehouse experience.

. SAP BI/BW Project Experience:

BI/BW Consulting (15 times)

. Industry Experience:

Semiconductor, Telecommunication, Manufacturing, Logistics, IT

Service, Retails

Qualified Skill

. SAP BW consultant with 13 year's experience in BW implementation with

SAP modules

. Seasoned professional with comprehensive technical skill-set and

expertise in translating functional specifications into BW solutions

. Participated in 7 times full-cycle BW implementation

. Customer-focused communicator with strong business process knowledge,

analytical skills and 12 years extensive data modeling experience in

various industries

. Proactive achiever, committed to creating high quality project

deliverables in a timely manner

. Personable team player with excellent interpersonal skills-gets along

well with people

. Excellent knowledge in DSO Modeling on ODS Layer in Data Warehouse

. Excellent knowledge in Multidimensional Modeling and Star schema

concepts

. Very familiar with Administrator Workbench and Transport System

. Experienced with installations and enhancements of Standard Business

Content

. Proven skill and experience with business requirement analysis and BW

solution design involving complex data flows and transformations

. Extensive experience in BEx Analyzer, BEx Designer, and WAD, Web

Intelligence development including template definition and

customization

. Good Knowledge of R/3 logistics (MM, SD, SCM), finance (FI, CO-PA,

CCA) modules, and BPC

. Experienced in ABAP programming by creating Start Routines and End

Routines in transformation

. Excellent knowledge in configuring BW objects, including Info Objects,

DSO and Info Providers, Extract, Transfer and Communication

Structures, Data Sources, and Transfer and Update Rules,

Transformation

. Experienced in data extraction from Non-SAP sources and integration

of Non-SAP data with existing R/3 data

. Excellent knowledge in Performance management and tuning

Work Experience

. SAP BI Developer

03.2014 ~

MOVADO Group.

. SAP BI Senior Consultant

11.2008 ~ 02.2014

Y&B Associates LLC.

. SAP BW Senior Consultant 11.2004 ~

10.2008

Samsung SDS America

. SAP BW Consultant

01.2000 ~ 09.2004

LAPHA&SOLUTIONS

. Senior DW Consultant

10.1997 ~ 12.1999

EDS Korea.

. DW Consultant 07.1996 ~ 09.1997

Samsung SDS Korea

Consulting / Maintaining Experience

MOVADO Group. BI System Maintenance

3.14.2014 ~ RIDGEWOOD

- Working as BI Developer to maintain BW System.

- Developing the Scorecard Dashboard using WAD, APD

- Created queries and delivered reports to user.

- Maintained Info Cubes & DSO Objects.

- Monitored job schedules and performance.

- Did performance tuning for query & extraction.

- Created START and END ROUTINES to load data.

- Coded START and END ROUTINES to meet different scenarios.

- Working on Extractor Enhancements populates the non-standard Data.

- Did ABAP code for user exits in ECC and BW system.

Keumho BW Upgrade Project

9.1.2013 ~ 10.18.2013 SEOUL

- Working as BW Consultant for BW upgrade

- Upgrade BW 7.0 to BW 7.3.

- Tested new functionalities and fixed the problems

Yacult BI Project

3.1.2013 ~ 8.30.2013 SEOUL

- Working as BW Consultant. Implementing Management Dashboard System.

- Design and Data Modeling of Management Reporting System(Marketing,

Billing, CO-PA)

- Working on Extractor Enhancements and USER EXITS to populate the non-

standard Data.

- Developed queries using Business Explorer and Web Intelligence of BO.

- Created and tested auth. and security profiles for InfoCubes and reports

for casual and power users.

- Trained the BW user group in for Web Intelligence.

KT(Korea Telecommunication) BW Project

7.25.2011 ~ 12.31.2012 SEOUL

- Working as BW Consultant Implementing Management Reporting of ECC

- Provided BW queries for Web Intelligence development

- Gathered user requirements and designed InfoCubes & DSO Objects.

- Designed Flexible Master Data Load for customer, material, vendor master

data

- Designed Dashboard and reports based on user requirements

- Did Data Modeling of ECC reporting system(FI,CO,SD,MM, PS, PM, AA,BPC,

PLM, PCM)

- Worked on Automatic Loading Process using Process Chains.

- Integrated on Multiple Cubes and DSO for FI, AA, HR, CO-PA, BPC, MM, SD,

PS, PM, PPM, PCM.

- Analyzed source system (SAP ECC System) and extract data from ECC using

BCT Data Sources.

- Created Custom and Generic Extractors with Delta.

- Created START and END ROUTINES to load data from DSO to InfoCube.

- Coded START and END ROUTINES to meet different scenarios.

- Working on Extractor Enhancements populates the non-standard Data.

- Pull the non-SAP data form legacy source system using Informatica

- Did ABAP code for user exits in ECC and BW system.

- Developed queries using BEx(Business Explorer) and Web Intelligence.

- Created and tested auth. and security profiles for InfoCube and reports

for casual and power users.

- Tested new functionalities and fixed the problems

- Did performance management and tuning for the huge data

Yacult BW Upgrade Project

1.3.2011 ~ 6.30.2011 SEOUL

- Working as BW Consultant for BW upgrade

- Upgrade BW 3.5 to BW 7.0.

- Tested new functionalities and fixed the problems.

CJ SCM BI Project

5.11.2009 ~ 2.26.2010 SEOUL

- Working as BI Consultant Implementing SCM System.

- Design and Data Modeling of SCM System(PP, MM, SD(Order, Delivery,

Billing))

- Web Templates design of Custom Queries.

- Working on Extractor Enhancements and USER EXITS to populate the non-

standard Data with BW 7.0.

- Developed query using Web Intelligence of Business Objects.

- Supported to develop web report using Xcelsius.

- Created and tested auth. and security profiles for InfoCubes and reports

for casual and power users.

- Trained the BW user group in Business Object.

Samsung Electronics Mexico BW Project

3.1.2008 ~ 5.30.2008 MEXICO CITY

- Working as BW Consultant. Implementing Management Dashboard System.

- Design and Data Modeling of Management Reporting System(Marketing,

Billing)

- Web Templates design of Custom Queries.

- Working on Extractor Enhancements and USER EXITS to populate the non-

standard Data.

- Developed query using business explorer.

- Developed web report using WAD(Web Application Development).

- Created and tested auth. and security profiles for InfoCubes and reports

for casual and power users.

- Trained the BW user group in BEX Analyzer.

Samsung Semiconductor Inc. BW System Maintenance

6.1.2006 ~ 12.15.2007 SAN JOSE

- Working as BW Consultant to support SSI BW System Maintenance.

- Created query requested by user and deliver reports to user.

- Maintained InfoCubes & ODS Objects.

- Monitored job schedules and performance.

- Did performance tuning for query & extraction.

Samsung Semiconductor Inc. BW Project

3.6.2006 ~ 4.15.2007 SAN JOSE

- Working as BW Consultant. Implementing Management Reporting and Early

Warning Reporting System.

- Converted R/3 Early Warning report developed by ABAP to EW report

developed by BW query.

- Gathered user requirements and designed InfoCubes & ODS Objects.

- Designed Flexible Master Data Load for customer, material, vendor master

data

- Did Data Modeling of SSI reporting system(FI,CO,SD,MM)

- Web Templates design of Custom Queries.

- Worked on Automatic Loading Process using Process Chains.

- Worked on Multiple Cubes and ODS for FI, CO-PA, Inventory, Purchasing,

Sales Order, Delivery, Billing.

- Analyzed source system (SAP R/3 System) and extract data from R/3 using

BCT Data Sources.

- Created Custom and Generic Extractors with Delta.

- Created START ROUTINES to load data from ODS to InfoCube.

- Coded Transfer Rules and Update Rules to meet different scenarios.

- Working on Extractor Enhancements populates the non standard Data.

- Push the billing data to the DW system using Informatica

- Did ABAP code for user exits in R/3 and BW system.

- Designed developed the procedure to automate the query execution using

BAPI-CRM and scheduler.

- Developed query using BEx(Business Explorer).

- Developed web report using WAD(Web Application Development).

- Created and tested auth. and security profiles for InfoCube and reports

for casual and power users.

- Implemented Jump functionality - created RRI queries.

- Performed the upgrade from BW 3.1C to BW 3.5 with BC

- Tested new functionalities and fixed the problems using Conference

calls, OSS Notes etc.

Samsung Electronics Canada EW Reporting Project

10.1.2005 ~ 12.23.2005 TORONTO

- Working as BW Consultant. Implementing Early Warning Reporting System.

- Converted R/3 EW report developed by ABAP to EW report developed by BW

query.

- Designed EW Reporting System (MM, SCM)

- Web Templates design of Custom Queries.

- Working on Automatic Loading Process using Process Chains

- Analyzed source system(SAP R/3 System)

- Developed extraction program using ABAP and extractor.

- Developed query using Business Explorer.

- Developed web report using WAD(Web Application Development).

- Created and tested auth. and security profiles for InfoCubes and reports

for casual and power users.

- Trained the BW user group in BEX Analyzer and Browser.

Samsung Electronics IT Division BW Project

7.1.2005 ~ 9.30.2005 IRVINE

- Working as BW Consultant. Implementing Management Dashboard System.

- Designed Management Reporting System(CO, Marketing)

- Web Templates design of Custom Queries.

- Working on Extractor Enhancements and USER EXITS to populate the non-

standard Data.

- Developed query using business explorer.

- Developed web report using WAD(Web Application Development).

- Created and tested auth. and security profiles for InfoCube and reports

for casual and power users.

- Trained the BW user group in BEX Analyzer and Browser.

Samsung Electronics Canada BW Project I

2.4.2005 ~ 6.30.2005 TORONTO

- Working as BW Consultant. Implementing Management Reporting Systems.

- Designing Flexible Master Data Load for customer, material master data.

- Designed the Info Cubes in all these areas (SD, MM, SCM)

- Web Templates design of Custom Queries.

- Working on Automatic Loading Process using Process Chains.

- Worked on Multiple Cubes and ODS for AR/AP, CO-PA, Inventory,

Purchasing, Order, Delivery, Billing.

- Analyzed source system (SAP R/3 System) and extract data from R/3 using

BCT Data Sources.

- Created Custom and Generic Extractors with Delta.

- Created START ROUTINES to load Contract related POS.

- Coded Transfer Rules and Update Rules to meet different scenarios

- Worked on Extractor Enhancements populates the non standard Data.

- Did ABAP codes for USER EXITS in R/3.

- Designed the procedure to automate the query execution using Reporting

Agent and Scheduler.

- Developed query using BEx.

- Developed web report using WAD (Web Application Development) for

Dashboard.

Samsung Electronics Logistics BW Project

10.18.2004 ~2.3.2005 SAN DIEGO

- Working as BW Consultant. Implementing Logistics Reporting Systems.

- Designing Flexible Master Data Load for customer, material, vendor

master data.

- Designed ADC Reporting System (SD, MM, SCM)

- Web Templates design of Custom Queries.

- Working on Automatic Loading Process using Process Chains.

- Worked on Multiple Cubes and ODS for AR/AP, Inventory, Purchasing,

Order, Delivery, Billing.

- Analyzed source system(SAP R/3 System)

- Completed the setup for data extraction from SAP R/3 using Business

Contents (LO Cockpit) and master data and transaction data load and

monitoring.

- Developed query using BEx

-

Samsung Telecommunication America BW Project

10.1.2003 ~ 9.30.2004 DALLAS

- Gathered user requirements and designed Custom InfoCube by enhancing

Info Sources and Info Objects.

- Implemented Purchasing InfoCubes (0PUR_O01, 0PUR_O02).

- Activated Extract Structures, Data Sources, Transfer Structures, Update

Rules for standard inventory cubes (0IC_C03).

- Customized the Extractor of Inventory Aging Data from SAP R/3 to BW and

created reports.

- Co-Coordinated in the Implementation of FI/CO Cubes (ZCOPA_C01,

0CCA_O09, 0CCA_C03, 0CCA_C11, 0FIAR_O03, 0FIAP_O03, 0FIGL_O02,

0FIGL_C01).

- All the Data Sources are replicated activated and scheduled the

InfoPackage and solved the errors.

- Created ODS Objects and extracted data having data targets as ODS and

InfoCube.

- Created Transfer Rules, Update Rules and Update Routines.

- Extracted data using Business Contents LO Cockpit.

- Created Info Package group, event chains and process chains for Data

Loading.

- Analyzed and solved the errors using scheduling and monitoring tools.

- Created transport requests for BW Objects, Queries and Workbooks and

Roles using CTS for different landscape.

- Created and tested auth. and security profiles for InfoCubes and reports

for casual and power users.

- Designed and created Queries using BW Front End - BEX Analyzer and WAD.

- Created Custom Queries using Variables, Structures.

- Implements Jump functionality - created RRI queries.

Hyundai-Kia Motors SEM Project

6.25. 2003 ~ 8.29.2003 SEOUL

- Planned project schedule and resources & defined project scope.

- Designed Balance Score Card and Management Cockpit.

- Fulfilled multidimensional data modeling.

- Created all the elements of Balance Score Card (BSC) and assigned the

data sources and value ranges for the status reporting.

- Developed query using BEx(Business Explorer)

LG-EDS Systems BSC Project

8.5.2002 ~ 4.31.2003 SEOUL

- Planned project schedule and resources & defined project scope.

- Analyzed source system(R/3 : FI,CO,SD,PS).

- Fulfilled multidimensional data modeling.

- Created all the Elements of Balance Score Card (BSC) and status reports.

- Developed extraction program using ABAP and extractor.

- Developed query using BEx(Business Explorer).

SK Corp. BW Project

2.1.2002 ~ 4.30.2002 SEOUL

- Planned project schedule and resources & defined project scope.

- Designed data warehouse architecture

- Fulfilled multidimensional data modeling

Samsung Electronics. Legal Consolidation BW Project

8.1.2001 ~ 9.30.2001 SEOUL

- Analyzed source system(R/3 : FI, CO).

- Fulfilled multidimensional data modeling.

- Developed Extraction Program using ABAP and extractor.

Hynix Enterprise Data Warehouse Project

10.25.2000 ~ 5.30.2001 SEOUL

- Planned project schedule and resources & defined project scope.

- Designed data warehouse architecture

- Analyzed source system(R/3 : FI, AR, IM, Purchasing, SD).

- Fulfilled multidimensional data modeling using Rapid Marts(FI,CO,SD,MM).

- Developed extraction program using ActaWorks(Data Service of Business

Object).

Hyundai Construction Corp. BW Project

1.13.2000 ~ 10.20.2000 SEOUL

- Performed the Process study of Connecting BW 2.0B with SAP R/3 4.6C.

- Followed ASAP Implementation Methodology for both BW and SAP R/3 4.6C.

- Did the configuration using Administrator Workbench.

- Customized Data Sources, Info Objects, Info Sources and Info Cubes.

- Created FI-CO Info cube by Generating Transfer Structure (Extract

Structure) for FI-CO table and defining and assigning a Data sources.

- Gathered user requirements and Designed Data modeling for Custom Cubes.

- Uploaded Data from SAP R/3 (Master data and transactional data).

- Performed Data Staging - Mechanism while loading Data to PSA, InfoCube &

ODS.

- Uploaded Master Data and Transaction Data from Flat Files.

- Extracted data using both LO-Cockpit and LIS-Info structure.

- Created extract structure, data source for CO-PA Cube.

- Developed Custom Queries in the BW Front end using BEx Analyzer.

- Created Queries using BW- Reporting Variables, Navigational attributes,

Calculated key figures, Restricted key figures and Filters.

- Created and Tested Authorization for Reporting on Global data.

Employment DSS Project

8.1998 ~ 10.1999 SEOUL

- Planned project schedule and resources & defined project scope.

- Designed data warehouse architecture

- Analyzed business requirement & fulfilled multidimensional data modeling

- Developed Extraction Program using MQ Series

Marketing DSS & Information Share KMS Development

5.1997 ~ 9.1997 SEOUL

- Planned project schedule and resources & defined project scope.

- Analyzed business requirement & fulfilled multidimensional data modeling

- Designed data warehouse architecture

Customer & Sales Analysis DSS Project

2.1997 ~ 4.1997 SEOUL

- Planned project schedule and resources & defined project scope.

- Fulfilled multidimensional data modeling.

- Developed reports to support decision using MSTR.

- Designed data warehouse architecture.

Sales Analysis DSS(Decision Support System) Project

8.1996 ~ 1.1997 SEOUL

- Fulfilled multidimensional data modeling.

- Developed reports to support decision using MSTR

PERSONAL PROFILE

- Mobility Green Card

- Language Spoken/Written Fluent in English

as Second Language

References are Available upon request

The End of CV

Contact this candidate