BUSINESS TRANSFORMATION Business Transformation for Contingency Operations (Iraq) Project Update July 27, 2006 Contract Organizations Processes Solicitation Contractor Write Manage Receive Capture Data Opportunity Posting Registry Contracts Contracts Proposal JCCI rebuikUng-iraq.ret Access DB til_:] - 1 l_h ~ ~ - USACE FedBia)pps.gov IRMS CD ... ... ... u SPS SPS c (GRD) ' ~ :::s AFCEE Fed B ia)pps.gov ~ ~ ~ GJ ~ GJ ~ ' ? ? ? ? CD JCCI / One of the following opti:Ons: ConlractiBJ Web forms & Enhance IRMS to - • FedB i 1 zOpps ftS USACE El - Templates to workflow Accept Contract U) • Reblilding,..iraq.net Capture Contract managemen t Data "a (GRD) / c I CCR • Baglxladbusinessoenter. org Data w AFCEE • "Cu s tom Solution" 2 Spirals- Proposed Spiral 0 -Change Template from Word to Excel with macro to dump key fields in DB -Enhance one of the following options for bid posting I receipt proposals I Arabic support Fedbizopps.gov Rebuilding-iraq. net Baghdadbusinesscenter.org "Custom Solution" Spiral1 -Modify IRMS input screen to look like MS Access input screen. Add 8 additional fields Gen. Scott needs to support 'Iraqi First Program' Spiral 2 -Implement Iraqi Central Contractor Registry Utilize third party (D&B)? Incorporate with bid posting I receipt proposal solution Spiral N -Simple web workflow management system to capture high-level milestones Synopsis, Solicitation, Proposal, Technical Evaluation, Award All Spirals starl at the same time 3 Spirals- Proposed Spiral o.jCbX6) I Change template from Word to Excel with macro to dump key fields in DB: • Validate approach • Identify all sources of word documents • Identify variation is data elements and formats in word docs Identify DB to transfer word documents • Map field from word documents to DB • Define batch process to migrate word to DB Define on-going process to migrate word to DB Enhance one of the following options for bid posting I receipt proposals I Arabic support: Define existing view bid/proposal receipt capabilities and limitations • Define requirements for Iraqi vendors and gaps with current systems • Technical selection, commence development • Develop Arabic and English web interface • Test solution • Deploy solution Spiral1.j(b)(6) Modify IRMS input screen to look like MS Access input screen: • Define level of contract detail needed for data reporting • Does the IRMS/MS Access DB provide the necessary level of detail Define technology restrictions on web-based systems in theater • Determine ownership of IRMS and our ability to make modifications • Determine if development will take place in Iraq 4 Spirals- Proposed Spiral 2: l(b)(6) I Implement Iraqi Central Contractor Registry: Define vendor data elements Identify data source (D&B, JCCI Excel spreadsheets, etc.) Determine validation procedures for vendor data Prioritize vendors for outreach and training Create/execute outreach and training program for identified vendors Spiral Nl(b)(6) I Simple web workflow management system to capture high-level milestones: Identify pilot organization for web workflow deployment, and develop technical/infrastructure profiles Define processes and key documents to incorporate into web workflow Evaluate workflow tools and select technical solution Configure workflow tool Test solution Deploy solution at pilot organization All Spirals start at the same time 5 Bid System Comparison baghdadbusinesscenter. org rebuilding-iraq. net fedbizopps.gov Environment OS: Windows 2000 OS: Linux OS: Unix Database: SQL Server Database: Oracle Database: Oracle WebServer/Middleware: liS 5.0 WebServer/Middleware: Oracle WebServer/Middleware: NetScape Front End: ASP Front End: HTMLIJ2EE Enterprise 4.1 This is probably running on Oracle Front End: HTMUJ2EE Portal Software. Also running Verity search engine to search the solicitations Ranking 2,667,807 327,941 101 ,726 Load 50-75 concurrent users 500-750 concurrent users 20-to-30 million site requests per month, rebuilding-iraq.net has roughly 10 sending over 75,000vendor notification times the number of users than em ails per day and hosting over 380,000 baghdadbusinesscenter.org accessible solicitation documents Search Opportunities X X X Post Opportunities X X Receives Bids Automatic Notifications X Policies Posted X X Arabic Language Helpful Links X X X Owner Civil Affairs 354/ Private US Army Corp of Engineers US Government Location Jordan United States United States 6 JCC-IA Database vs IRMS JCC-1/A IRMS Description Database that stores contract data for JCC-1. The Integrated Reconstruction Management data is manually entered by procurement clerks System - a repository of project, financial and from contract documents awarded by JCC-1/A. contracts data derived from several main Items such as the contract number, requisition sources; IRMS will be the repository and number, solicitation number, item or service archive for storing all reconstruction and non- purchased, other information., are recorded for reconstruction project data from IRMO, GRD, producing ad hoc reports requested from various PCO, MNF-1, MNC-1, MNSTC-1, and USAID. FOIA requests, Congressional contracts data requests, 2207 reports, internal report usage, etc Participants JCC-1/A IRMO, GRD/PCO, MNF-1, MNSTC-1, USAID, CEFMS, RMS Data Sources Manual Data Entry into the JCC-1/A EBiz- Provides finance data from CEFMS (Corps of Engineers Financial Management System) & RMS (Resident Management System) Primavera- Provides tool for resource planning MAXIMO- Provides project and asset data Functionality Reports All Report Parameters are Dates: - 50 + reports - Montly Totals -Project comparison reports by funding - Contracts Awarded/Not Awarded program , PCO sectors, & sub-sectors - Actions by CO - Interactive Iraqi Map which shows number of - Actions by Customer projects, cost, percentage of cost to overall cost -Analysis of Host Nation Contracts by Province -Benchmark Reports (Global, DoD, Facilities, -Closed Sec, GRD/PCO) Forms Contract Input Form N/A Users 4-5 manual entry users 50-70 users (top level) Environment Microsoft Access DB (Front & Back End) PHP Front End ~ June July • Kickoff Iraq Trip Problem Requirements Gath«ing • Milestones D lraqTrips D On-going Activities D Future Activities Refine Tech A Its • August Iraq Trip Technical Selection Development Project Timeline September I October Iraq Trip Iraq Trip Test Deploy • Go Live 8 Task Force IT Requirements Cell Phone Blackberry: • l(b)(6) I configuration as a standard for OSD • l(b)(6) ponfiguration as a std for BTA Access to email remotely: • DFAS VPN • Web Solution • Backup allow forwarding to web mail Satellite Phone: • Iridium (1) • Satellite WIFI - 1 Tablet PC: • Toughbook- 1 • Regular- 1 9