Case Execution Management Information System CEMIS

1
Case Execution Management Information
System(CEMIS)

• ILCO Symposium
• 27 August 2003

2
FMS AUTOMATION TOOLS
BASED ON CORE BUSINESS PROCESSES
DSAMS - Defense Security Assistance Management
System
PORTAL - Interim solution. Provides DSAMS Letter
of Offer and Acceptance info to the International
Customer links with current case execution
legacy systems.
CEMIS - Case Execution Management
Information System
3
Re-direction - CEMIS

• DSCA Director memo 10 Jan 01 outlined new effort

Continue through Training Module
4
CEMIS Concept
Army CISIL 1976

• Improve Support to International Customers
• Improve Quality and Timeliness of Information
• Standardize Processes
• Allow continuous Business Process Reengineering
  (BPR)

Consolidate/ Replace Four Separate
Case Execution Legacy Systems

Navy MISIL 1989
Air Force SAMIS 1983
Air Force CMCS 1989
5
CEMIS Requirements Process

• Phase I Jul Dec 01
• Requirements Charter Team developed macro-level
  ORD
• Phase II CEMIS Requirements Teams Jan Dec
  02
• Developed detailed level requirements (ORD 2)
• 5 teams 54 members
• Intensive meetings schedule 1 to 3 teams every
  week
• IT (Standard Systems Group (SSG) Gunter Annex as
  the Acquisition Agent) were active participants.
  Assisted in requirements definition and placement
  into ORD.
• Phase III Analysis of CEMIS Alternatives Jan
  Jul 03
• Phase IV system
  design/development

6
CEMIS Requirements Teams Case Execution through
Case Closure

• Order Processing Team
• More proactive case management
• Logistics (MILSTRIP/Requisitions etc etc etc )
• Acquisition (contracting) (Acquisition Sub Team)
• Finance Team
• New funds distribution methodology increased
  visibility/accountability
• CFO Compliance/new FM architecture
• Corporate Information Team
• Management Tools and Metrics
• Oversight Group
• Overall ORD coordination/scrub
• Systems Team (DSCA IT - formed June 02)
• Security Requirements processing capability
  requirements in the ORD
• Continues to meet every month
• All ORD requirements were assigned Business
  Process Capabilities of Existing, Modification,
  or New Development

7
CEMIS Business Processes
Corporate Information
Reconcile Data, Process Discrepancies
Receive/Track Order Progress
Delivery Report
Establish Case Budget/ Obligation Authority
Case Recon Closure
Complete the Order
Create/Receive/ and Process Orders
Case Management Planning/Tools
Unique Program Tools (Drawdowns, EDA, Worldwide
Warehouse)
8
CEMIS ORD AT A GLANCE

• Logistics
• Automating manual processes, but many business
  practices remain the same
• due to domestic system constraints.
• Acquisition/Contracting Information
• More information from PMs/PEOs/SPOs (system
  interfaces)
• Finance
• Big changes CFO/FFMIA compliance new funds
  control/distribution
• delivery reporting reconciliation (automated
  continuous) closure an event
• Delivery reporting and case closure for the
  DSAMS Training Module
• Addition of Unique Security Cooperation
  Functions (Drawdowns, EDA, EUM, etc.)
• Some Business Process Reengineering, some
  standardization and
• management tools and metrics

9
Analysis of Alternatives (AoA) Options

• Alternative 1 As-Is (Mandatory)
• Alternative 2 Evolve Web-enable
• Portal Legacies Left in Place
• Alternative 3 Best of Breed
• Portal Single System (Best of Breed)
• Alternative 4 New Build
• Build to Requirements
• Alternative 5 Commercial Off The Shelf (COTS)
• Assessment of ERP products
• Alternative 6 System Re-host Modernize

10
AoA Options (Cont.)

• From Jan through May 03, SSG weighed
  approximately 1,000 ORD requirements against
  SEER-SEM software cost estimating model to
  perform fit analysis against all options except
  COTS.
• COTS analyzed separately by Gartner Group.
• On 3 Jun 03 Lt General Walters, DSCA Director,
  eliminated Options 1 (As Is), 2 (Evolve/Web
  Enable), 4 (New Build), and 5 (COTS).
• Best of Breed (3) and Re-host/Modernize (6)
  remained.
• On 22 Jul 03, Lt General Walters chose Option 6,
  Rehost/Modernize, as the way ahead for CEMIS.

11
AoA Options (Cont.)
1. As-Is (with historical budget) - Cant
achieve ORD in a decade 2. Evolve and Web-enable
the Legacy Systems - Not affordable 3.
Best-of-Breed - Possibly economically
feasible 4. New Build - Not affordable 5.
COTS - Potentially lowest price, but
too risky 6. Re-host and Modernize -
Possibly economically feasible and most flexible

12
Re-Host/Modernize Option

• Phase One Re-host
• Takes 4 existing legacy systems in current
  databases and languages
• Translates each into C or Java on Oracle
  database.
• Uses artificial intelligence tool vs. manual
  code translation.
• Turn off legacy systems.
• Result Still 4 separate systems doing same
  things, but now in one (same) modern language and
  database.
• Phase Two Refactor/Web-Enable
• Consolidate the 4 separate systems into one
  system and web-enable.
• Eliminate redundant code choose best business
  processes among MILDEPs
• Result One database for all 3 MILDEPs.
• Phase Three Modernize
• Add in Modification and New
  Development ORD requirements based on
  affordability and priority.

13
The Re-host and Modernize 3-Step Strategy
Rebuilt Legacy Systems
STEP 1
STEP 2
Consolidated System
CISIL Code
CISIL New Code

• Automated Tool

• Semi-Automated
• Process

• Single System
• Single Relational
• Database
• Some common
• processes

MISIL Code
MISIL New Code
SAMIS Code
SAMIS New Code
CMCS Code
CMCS New Code
C, Java, Relational DBMS
USG direction on data similarity and preferred
processes
Shut down legacy
STEP 3

• Manual coding
• Evolve over time to meet ORD requirements and
• increase standardization of processes

CEMIS IOC FOC
Spiral Development
14
CEMIS Project Timeline
Pre-Systems
Systems Acquisition
Acquisition
SYSTEM DEVELOPMENT
CONCEPT DEVELOPMENT

Acquisition
Strategy
Operational Requirements Document ORD macro
Analysis of Alternatives (AOA)
Deficiency Analysis
MNS
ORD
detailed
R E Q U I R E M E N T S D E T E R M I N A T I O
N
Jan 01 May 01 Dec 01
Dec 02 Jul 03 Jun 04 Dec 04
Dec 05