Senior Consultant Application Sales Consulting Oracle Korea
-
1. S = (P + R) x E S= P= R= E= Source : Strategy Execution, By Daniel M. Beall 2001
1. Strategy Formulation Sound Flawed Missed Opportunity Doomed From The Start Flawed Strategic Success At Risk Sound Strategy Execution
2. Lack of a well defined strategy Strategy Formulation 57% Lack of a link between strategy and Operational plan Strategy Cascading 53% Lack of accountability of results Responsibility 45% Lack of meaningful performance measures KPI Lack of pay for performance Reward 21% 34% Lack of appropriate data DW/DM 21% Source : How Strategic Performance Management Is Helping Companies Create Business Value, By Omar Aguilar, Strategic Finance, January 2003
3. Balanced Scorecard Input (Resources) / Initiatives & Programs Output (Results)
3. Value Tree ( )- ROIC ( )- Cascading ( )- BSC BSC, ( ) Index BSC
3. Operation Layer Data Integration Layer Intelligence Layer ERP, Legacy DW/DM SEM
3. < > by e-mail, PHP, Mobile High Range Alert Target Low Range 120 105.6 Exception (notify) 105.6 :
3. CORP SBU Top-Down EDUCATION PERSONAL GOAL ALIGNMENT Bottom-Up BALANCED PAYCHECKS The Strategy Focused Workforce
3. Vision / CSF/KPI C.S.F KPI CDP Feedback Activity Define / HR
4. - - KPI, (Plan) -KPI (Do) Data Warehouse/Data Mart Exception Management On-line / Off-line (Do),, (See)
4. Plan / CSF Do / Alert / See
5. GL Interface Budget Performance Report Planning & Forecasting Variance Oracle Financial Analyzer Data Analysis Ad Hoc Individual Data Slice What-If Exception
5. Rolling Plan EVA, CFROI,,
5. Map KPI KPI Segment need Financial Planning
5. OBSC Feedback & Corrective Action loading
5. KPI KPI Communication Common Language / KPI
5. ( ) / Process Innovation
5. Cumulative Percentage of Sales 100 90 80 70 60 50 40 30 (1) 20-80 Rules (2) 60-99 Rules (1) The Most Profitable 20% : (+) 300% (2) The Remaining 80% : (-) 200% Cumulative Profits (percent of total profits) 350 300 250 200 150 100 20 50 10 0 0 10 20 30 40 50 60 70 80 90 100 Cumulative Percentage of Products Cumulative Sales 0 0 20 40 60 80 100 Most Profitable Product Cumulative Percentage of Products Least Profitable Product Cumulative Profitability
5. Process Capacity Simulation
5. Proactive Management (Alert). e-mail mobile, (PHP), Application. Information Alert.,.
5.,
5.
5. Total Compensation & : Communication Validation
5. Oracle Mainframe DB2, Informix SAP, People Soft Syndicated data Benchmarking data 2 3 Design Target Warehouse Map Source to Target OWB (Oracle Warehouse Builder) OWB* Oracle ETT ( Extraction Transformation Transformation ) Legacy,,,. 1 Define Sources 4 Generate Code 5 Instantiate Warehouse 6 Extract Data
5. KMS System EIP ( Enterprise Information Portal ) Data Warehouse Solution Web System DW ROLAP ETT 1 ODS ODS ODS DW DW DW 3 MOLAP Data Mining Alert/Workflow Data Mart Data Mining DM MOLAP DM Campaign DM 2 4 SEM OFA BSC ABM Analytical Intelligence OLAP E-Business Intelligence
5. References POSCO, One-Stop - - - Best Practice Oracle e-business Suite One Vendor Solution Open System 100% iplatform Web Solution Self-service, 3 Tier Architecture,, (Oracle, ERP, Legacy)
D E M O N S T R A T I O N
Q U E S T I O N S A N S W E R S