William Kweon

Summary

Business Improvement & Information Delivery System 1. Focus on Delivering Value for Business Objectives. 2. Business Process Reengineering 3. Increase Operational Efficiency 4. Decision Making Support 5. Share Information Company wide

Objective

<> Business Improvement (Project Base)  - Focus on Delivering Value for Business Objectives.  - Business Process Reengineering  - Increase Operational Efficiency  - Decision Making Support  - Share Information Company wide<> Information Delivery System (Routine Base)  - Windows Server Maintenance (Exchange, Local Applications)  - Network Maintenance (Branches, Plant, R&D Center, Region office)  - Computer Room Maintenance  - PC and Printer Maintenance  - Introduce the new global system.  - Patch & upgrade for all systems  - Backup & Restore

Interest

<> Business Improvement (Project Base)  - Focus on Delivering Value for Business Objectives.  - Business Process Reengineering  - Increase Operational Efficiency  - Decision Making Support  - Share Information Company wide<> Information Delivery System (Routine Base)  - Windows Server Maintenance (Exchange, Local Applications)  - Network Maintenance (Branches, Plant, R&D Center, Region office)  - Computer Room Maintenance  - PC and Printer Maintenance  - Introduce the new global system.  - Patch & upgrade for all systems  - Backup & Restore

Work History

Work History

Business Consultant

DIAGEO Korea

Sales Evaluation Index (2005)

+ The purpose of this project is to provide the index of sales effectiveness

by customer in order to increase cash collection and to reduce bad debt for sales.

+ Role: Project Manager, System Analyst and Designer

+ Effectiveness

- Prevent bad debt for sales.

- Increase cash collection at 20 percent

- Reduce Note-receivable and DSO (Days of Sales Outstanding)

- Improve sales volume through discount program for wholesaler

- Find sales opportunity through Customer Segmentation by its contribution

+ Cross-functional Project

- Commercial Sales, Finance Team, Branch

+ System Infrastructure: Interface: JDE WorldSoft v7.3 on AS/400

Economic Profit System (2004 ~ 2005)

+ The purpose of this project is the introduction of financial P&L concept

to sales part in order to evaluate the performance of sales function, branches,

salesmen, and wholesalers that are about 1,300.

+ Role: Project Manager, System Analyst and Designer

+ Effectiveness

- Paradigm shift from volume to financial profit

- Extend financial P&L analysis to customer level

- Provide customer performance for decision-making

- Improve accuracy for evaluating wholesalers

+ Cross-functional Project

- Commercial Sales, Decision Support Team, Finance Team, Branch

+ System Infrastructure

- Oracle 8i, ETL Tool (Sagent), PowerPlay v6

- Interface: JDE WorldSoft v7.3 on AS/400

SOX (Sarbanes and Oxley Act) Project (2005)

+ The purpose is to improve IS securities and define processes for the open

and aboveboard management and streamlined business.

+ Role: Project Manager IS function

+ Effectiveness

- Make Disaster Recovery Plan on IT system

- Define IT Management Process

- Set up process of Change & Project on IS

- Audit process on IT master file such as Customer, Supplier, Employee,

Bank Account, Price, and Item.

Information Technology Support (2004)

+ The purpose is to provide IS services and maintain IT infrastructure and network

in order to support business improvement.

+ Role: Manager of Technical Support Team (TST)

+ Scope

- Support JDE ERP system on AS/400 with WILUS that is 3rd party.

- Provide e-mail service with MS-exchange.

- Maintain servers and PC with 3rd party.

- Maintain network with domestic and global sites.

- Manage IT budget.

Market Intelligence (2003)

+ The purpose is to support information for decision making through analyzing

competitor's information in Market. There are Market share, Grey Market Price,

and Depletion.

+ Role: Project Manager, System Analyst and Designer

+ Effectiveness

- Share market information Company-wide

- Provide permanent service through consolidating competitor's data from PC

to Database

- Set-up business process for analysis of competitors

- Customer segmentation for CRM

+ Cross-functional Project

- Marketing team, Commercial Sales

+ System Infrastructure

- DBMS: Oracle 8i, ETL Tool: Sagent, OLAP Tool: PowerPlay v6

Global SCM implementation with Amsterdam (2003)

+ Supply Chain Management

+ Role: Project Manager & System Designer

+ Effectiveness

- Prevention of stock shortage

- Automatic Purchase Order to Amsterdam supply

- Provide safe stock by SKU

+ System Infrastructure

- JDE Sales & Inventory module

- Local Interface program coded RPG

- Rumba emulator for AS/400

+ Cross-functional Project

- Logistics Team, Global Amsterdam supply

Automatic bank transfer for collecting A/R (2002)

+ After sales Order services select AR list from JDE. And then they collect A/R

form customer's bank account through DACOM network.

+ Role: Project Manager & System Designer

+ Effectiveness

- Observe liquor laws

- Rise cash sales up to 90%

- Reduce collecting time in 2 days

+ System Infrastructure

- DACOM in-house Program

- Local system on AS/400 for interfacing with JDE

- JDE Sales Module

+ Cross-functional Project

- Joheung Bank, DACOM, Credit Support Team

Common Data Model Implementation for Customer Analysis (2001)

+ DIAGEO has a standard data warehouse that is called Common Data Model (CDM). CDM

can include all kinds of measurable data for business like finance, sales,

inventory, etc.

+ Role: Project Manager & System Designer

+ Effectiveness

- Share business information company-wide

- Support decision-making

- Reduce IS working hours for developing new report system on legacy system

- Define Customer Database for CRM

+ System Infrastructure

- DBMS: Oracle 8i, ETL Tool: Sagent, OLAP Tool: PowerPlay v6

+ Cross-functional Project

- Global IS Team, Finance, Logistics, Sales, Marketing

Introduction of ERP System & Customization (Aug. 1999 ~ Jun. 2000)

+ Project Detail

- JDE Finance Module (Account Receivable, Account Payable,

and General Account)

- JDE Distribution Module (Sales Order, Purchase Order, and Inventory)

- Customization List

Note receivable, Mortgage, and Sales Order Hold (RPG)

Cost Accounting (Visual Basic)

- JDE Version: WorldSoft 7.3.1

H/W Platform: IBM AS/400

-Role: Business Process Analysis and Coordinator

-Cross-functional Project

HongKong IS Team, Finance, Sales, Logistics, Production, Procurement

-Effectiveness

Business Process reengineering through ERP system

Reduce maintenance cost for legacy system

Improve system stability

3rd Party Logistics Project (Feb. 1998 ~ Aug. 1998)

+ The object is to reduce delivery cost and improve logistic process through outsourcing.

+Role

Business Analyst and Designer

+ Effectiveness

- Reduce safe stock from 130 days to 87 days

- Reduce working capital and logistics cost

- Improve delivery process

+ Cross-functional Project

- Logistics, Finance, and Sales Team

+ System Infrastructure

- Interface: Doosan VAX system and RESKO in-house S/W

Management Information System and IT Infrastructure (1995 ~ 1997)

+ The object is to provide decision-making system to team managers and to improve efficiency and effectiveness for users.

+ Role

- Business Analyst, IT specialist

+ Effectiveness

- Provide accurate business information for decision-making

- Improve efficiency and effectiveness

- Less manual job and more information service through OLAP tool

- Increase stabilization on IT infrastructure and network.

+ Scope

- MIS Part

Sales Analysis from Order service to daily Sale Order closing

Inventory management

Market share information with competitors

Dealer master file (DMF) that is customer information.

Account receivable system.

- IT Part

Maintain NT servers for e-mail and applications.

Support PCs for users

Maintain LAN and WAN

-Cross-functional Project

Logistics, Credit support, Sales, and Doosan Information and Communication Company (DICC)

-System Infrastructure

Interface: in-house S/W on Doosan VAX system, Essbase OLAP tool

Budget Control (1994)

+ The object is to provide decision-making system to team managers and to improve efficiency and effectiveness for users.

+ Role

- Budget Controller in Management Account Team

+ Scope

- Analyze plan and actual by month, team, account and project.

- Manage a revised supplementary budget.

- Control budget by month, team, account and project.

Team Manager

Oxy RB

CARE (Jun.2009 ~ Oct.2009)+ The purpose of the project is to implement Global Standard CRM solution into local and improve the customer complain response process according to Global Standard for Consumer Support Team.+ Role: Project Manager+ Effectiveness  - Process Standardization according to Global Policy- Consistent Consumer Response Service   - Contribute Product Correction and improve Consumer Satisfaction  - Build Database with Global Standard Hierarchy  - Provide powerful analysis tool for decision making+ Cross-functional Project: Customer Support Team, East Asia IS Team, SFI (3rd Party)+ System Infrastructure: Windows Server, SQL

e-Expense System (Nov.2008 ~ Aug.2009) + The propose of project is to optimize the process and save cost through Process reengineering with Web solution and e-mailsolution.+ Role: Project Manager, System Analysis and Design+ Effectiveness- Optimize whole process from making voucher to uploading into ERP system- Receive TAX Reclaim from NTS. (About 40 Million per year)- Save 1 Man/Month+ Cross-functional Project: Finance Team, Marketing, Sales, Third party developer  + System Infrastructure      - Web Based Application (http://expense.rb-one.com/kr)      - MS-SQL

Global IS Security Audit (Oct.2008)  + It is to make Global Security Level of IS Infrastructure and Business Process    User System Account (Creation, Delete, Authority)    Segregation of Duty for ERP System    Master File Management    Disaster Recovery Plan Review    Backup & Restore    H/W policy

Disaster Recovery Plan (Apr.2008 ~ Sep.2008)  + It is to make Business Continuity Plan for Business Disaster    Build Backup System in IDC Center    Set up Backup & Restore Plan    Make Business Continuity Plan

One Master File (Jan.2008 ~ Jun.2008)+ There are many business solutions in company and they have own system setup for product and customers master files. Sometimes each master file conflicts each other and maintenance is all manual. This project is to unify all master files into one and make official process for master file maintenance.+ Role: Project Manager, System Analyst and Designer+ Effectiveness  - Introduce global hierarchy for product master in order to provide common tool for communication clear.  - Automate masters update for all business applications.  - Optimize work flow.+ Cross-functional ProjectSales Support Team, China Vendor, China developer+ System Infrastructure: Web-based In-house Program

In-Market-Sales of Distributor (Jun.2007 ~ Nov.2007)

+ This is one of Market Intelligence System and provides the Distributor

information of P&L, IMS, and Inventory in order to analyze and evaluate

Distributors about their contribution to our company and financial status.

+ Role: Project Manager, System Analyst and Designer

+ Effectiveness

- Provide IMS analysis reports for all distributors (71) over country.

- Support decision making support with company standard analysis reports

about P&L, IMS and Stock.

- Optimize work flow.

- Save Man/Month by redefining R&R with Sales Reps and administrator.

+ Cross-functional Project

Sales Support Team, Marketing, Sales Branch, China IS Team

+ System Infrastructure: Web-based In-house Program, MS-SQL

E-POS (Apr.2007 ~ Oct.2007)

+ This is one of Market Intelligence System and provides the Market information

of the actual data of Point-of-Sales from all stores of 4 major customers, like

E-Mart, Tesco, Lotte-Mart, and Homever. It is used for Marketing and Sales

Support Team for decision making. This system is for increasing sale through

meeting consumer's needs.

+ Role: Project Manager, System Analyst and Designer

+ Effectiveness

- Provide POS analysis reports for 4 Major Customer

(E-Mart, Tesco, Lotte-Mart, and Homever).

- Support decision making solution with company standard analysis reports.

- Provide Common tool for communication between teams through

sharing information.

- Optimize work flow.

- Save Man/Month by 40%.

- Improve Information Service Consistency from human dependency to system Framework.

+ Cross-functional Project

- Sales Support Team, Marketing, Sales Branch, China IS Team

+ System Infrastructure: Web-based In-house Program, MS-SQL

Go-to-Market(Dec.2006 ~ Sep.2007)

+ This provides a new way of working of Sales Function. Sales raps can go to customers without commuting to office everyday. They can use their time to value added activity in the field. It must increase sales and customer satisfaction.

+ Role: Project Team Member for providing IS solutions. (GM is a PM)

+ Effectiveness

- Reduce commuting time between home and office and increase store visit

from 48 to 72 times per month.

- Save office expense through 4 branches closed.

- Provide new way of working in sales reps through using IS solutions.

- Support decision making support with company standard analysis reports about P&L, IMS and Stock.

E-4P (Oct.2006 ~ Mar. 2007)

+ The purpose of this project is to contribute sale increase through providing

new way of analyzing market information by reproducing 4P data from promoters

of all Hyper-markets. (E-4P includes Price, Promotion, Placement, and Presence

in the stores of Hyper Market like E-Mart, Tesco, …

+ Role: Project Manager, System Analyst and Designer

+ Effectiveness

- Present KPI for Marketing and Sales activity.

- Support decision support through sharing information over company.

- Reduce period of analysis (4 Days to 1 day)

- Save 77 days per month for 12 people for data collection and analysis

(10 Promoters, 1 Data Collector, 1 Analysis)

- Improve business process from human to system.

+ Cross-functional Project

- Commercial Sales, Marketing, Sales Branch, China IS Team

+ System Infrastructure: Web-based In-house Program, MS-SQL

Team Manager

Oxy RB

Education

Education

Master

Helsinki School of Economics

Bachelor

Korea University

Skills

Skills

JDE ERP

Distribution Module * Sales Order * Purchase Order * Inventory Management

OLAP Tool

EssBase, Business Object, PowerPlay

MS PowerPoint

MS Excel