Minuteman international implements an oracle applications data warehouse in 4 weeks
Download
1 / 13

Minuteman International Implements an Oracle Applications Data Warehouse in 4 Weeks - PowerPoint PPT Presentation


  • 158 Views
  • Uploaded on

Minuteman International Implements an Oracle Applications Data Warehouse in 4 Weeks. A Case Study Dean Theobold, VP Manufacturing Stan Choflet, Jaros Mike Spencer, Jaros. Agenda. Minuteman Company Overview Oracle Applications Implementation Minuteman’s Reporting Environment

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Minuteman International Implements an Oracle Applications Data Warehouse in 4 Weeks' - sook


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Minuteman international implements an oracle applications data warehouse in 4 weeks l.jpg

Minuteman International Implements an Oracle Applications Data Warehouse in 4 Weeks

A Case Study

Dean Theobold, VP Manufacturing

Stan Choflet, Jaros

Mike Spencer, Jaros


Agenda l.jpg
Agenda

  • Minuteman Company Overview

  • Oracle Applications Implementation

  • Minuteman’s Reporting Environment

  • Jaros Company Overview

  • Jaros Data Warehouse Implementation

  • Discoverer Demonstration


Minuteman company overview l.jpg
Minuteman Company Overview

  • HQ – Addision, IL (Chicago)

  • 2002 Revenue – $72M, 400 Employees

  • Four Companies:

    • Minuteman International (Addison, IL)

      • Powered Cleaning Equipment

    • Multi-Clean – (Shoreview, MI)

      • Cleaning Chemicals and Solutions

    • Parker Sweeper (Springfield, OH)

      • Grounds Maintenance Equipment

    • PowerBoss (Aberdeen, NC)

      • Industrial Sweepers and Scrubbers


Oracle applications implementation l.jpg
Oracle Applications Implementation

  • Began in 2001 with Financials, 11.03

  • Rolling out Manufacturing to last 2 plants now

  • GL, AP, AR, Purchasing, Order Management, Inventory, BOM, WIP, Master Scheduling/MRP

  • Legacy Unix system (Historical Sales Data)

  • Bolt-on, Internally Developed Procurement Rejection System

  • Hardware: Sunfire V880 (4-Way)


Pre jaros oracle reporting environment l.jpg

Standard Oracle Reports didn’t meet user requirements

Difficult to make good decisions w/o data

Many Custom Reports & Applications

The Problem

Complex Table Structures

Multiple Data Sources

Custom reports were resource intensive

Extensive use of Excel for data manipulation

No tools or time to do detailed analysis

(Pre-Jaros)Oracle Reporting Environment


Initial requirements l.jpg
Initial Requirements

  • CEO Driven Initiatives

    • Business Dashboard

    • Revenue/Product/Customer Analysis

  • DARC Engagement

    • Reviewed Requirements and Alternatives

      • Oracle BIS, EDW, Discoverer, Noetix, Jaros

    • Recommended Jaros Sales Analysis & Discoverer

  • Jaros/DARC Engagement

    • Product Demonstration to Executive Management

    • Decision to Implement Full Jaros Product Suite

      • Jaros Modules: GL, AP, AR, Purchasing, Inventory, Orders

      • Oracle Discoverer, Jaros Dashboard

      • Manufacturing (MRP, BOM, WIP) planned for Phase 2


Slide7 l.jpg

Jaros Technologies

  • Background / Experience

    • Oracle Applications, Database

    • Custom Data Warehouses

  • Product Suite

    • Jaros Analytics Modules (Packaged DW/ODS)

      • GL, AP, AR, Purchasing

      • Orders, Shipments, Inventory, Costing

      • Service, Contracts (Q2)

      • BOM, WIP, MRP (Q2)

      • Fixed Assets, Projects (Q3)

  • Value Proposition

    • Dramatically Lower Costs and Time

      • 2 day install, 4 week implementation

      • Risk Free Trial

    • Packaged Application Approach

      • 80-90% out of the box (Mfg, Distribution)

    • Highly Extensible DW/ODS Architecture

      • Account Segments, Flexfields, Hierarchies

      • Custom, Legacy Integration

    • High Performance Architecture

    • Near Real Time Reporting

Custom Data Warehouses

Jaros Analytics Customers


Data warehouse implementation l.jpg
Data Warehouse Implementation

  • Scope: Sales, Financials, Procurement, Inventory

  • Project Plan: 4 weeks to Production

    • Week 1: Installation of product; Configure Hierarchies, Flexfields and Account Segments; Data Validation; POC including out of the box Discoverer EUL for Data Warehouse

    • Week 2-3: User Requirements Sessions, Build Custom Business Areas, Deliver Enhanced EUL and Discoverer Workbooks, Integrate Bolt-On Procurement Rejection System Data

    • Week 4: Training IT and Finance Users, Promote DW to Production

  • Post Jaros Engagement

    • All Reporting and Analysis to be Derived from DW/ODS

    • Rapid Report Development in IT (10x – 100x)

    • Integration of Legacy Sales Data (Unix System Flat Files)

    • Business User Ad Hoc Reporting/Analysis with Discoverer Desktop

    • Business User Dashboard Web Report Delivery with Drill-Down

      • Starting with Rollout to Sales, Finance


Customer quotes l.jpg
Customer Quotes

“In the first week, Jaros advanced our ability to do reporting and analysis by at least a year”

Paul Neumann, Director - IT

“This is the first experience related to our Oracle Implementation where we got exactly what we wanted in the expected timeframe”

“Reports that used to take IT weeks to deliver, I am doing myself in just a few minutes”

Dean Theobold, VP - Manufacturing


New business visibility with dw l.jpg
New Business Visibility with DW

  • Manufacturing Visibility

    • Shop Floor and Shipping Productivity by Individual

    • Relationship Between Open Orders, Supplies, Resources for Improved Planning and Management

    • On Time Delivery by Customer, Product, Plant

    • Rejects: Reasons for Scrapping Parts, Rework, Return for Credit

  • Supplier Visibility

    • Supplier Performance: On-time delivery, quality

    • Top $ Components: Supplier Competition

    • Supplier Consolidation Opportunities


New business visibility with dw11 l.jpg
New Business Visibility with DW

  • Customer/Sales Related Information

    • AR by Customer/Sales Rep

      • Open AR total by time bucket, Drill by Cust/Rep

      • Customer Trends for DSO

    • Open Orders by Customer, Delivery Trends

      • Net Bookings Snapshot

    • Product Sales by Rep/Customer

  • Inventory Visibility

    • Current/Historical Carrying Cost

    • New Inventory $$ per New Orders (Projected Costs)

    • By Item Type (Finished Goods, Subassembly, Category Code)


New business visibility with dw12 l.jpg
New Business Visibility with DW

  • ISO 9002 Project

    • Goals by Department

      • Analyze, Clean Up Data, Set Goals, Measure

      • Ex: Reduce “Catch-All Bucket” for Rejects

      • Ex: Picking Lines by QTR (Wrong Shipments, etc)

        • 44,000 line items, 27K Orders

      • Ex: On-time Delivery Performance

  • Verify Implementation Assumptions

    • Cycle Times

    • Standard Costs


How it works l.jpg

Legacy

Oracle

Applications

Other ERP

How it Works

9iAS, Any Reporting Tool, OLAP, Other Applications

Discoverer EUL: ODS

Discoverer EUL: DW

Multidimensional, Star Schema

Data Warehouse – Strategic Reporting

Summary, Detail, Snapshot Data

ETL Mappings (Complex Transformations)

Operational Data Store (ODS)

High Performance Staging Area, Point of Integration,

Lowest Level of Detail, Near Real Time Tactical Reporting

ETL Mappings: Extraction, Transformation, and Load(Near Real Time)

Insulation Views Change Tracking


ad