Navy Data Environment NDE

1
Navy Data Environment (NDE) Navy Modernization
(NM) Project Update 19 December 2001
2
Naval Message Aug 01 Timeline
14 Jan 02 FMPMIS-LOG, SPAWAR, AMPS, TAMS, LCRS
System Ready
19 Oct 01 TAMS, AMPS LCRS, SPAWAR functional
requirements
16 Apr 01 AIPS functions in NDE-NM
15 Jan 02- 22 Mar 02 Run FMPMIS Log Legacy in
Parallel. Train Users
TAMS, LCRS-FMP, and SPAWAR have started
the process of documenting. AMPS needs funding
to begin.
25 Mar 02 Shutdown Legacy FMPMIS logistics
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
Apr
2
3
Navy Modernization State March 29, 2002
MC, NAVAIR, CG, Foreign, SWD
NDE
File update (xls) and Manual
NDE-NM AIPS FMPMIS
Send, all other alts missing from NDE and send BG
BL Locks
NDE sends alerts to CDMD-OA when alts are
approved.
CDMD-OA
SEA 53 AMPS
AMPS pulls Alteration information
CDMD-OA assigns work-files to clear alerts
Replication
TAMS updates Alt status
NDE-SIDE SPAWAR
TAMS SUBLANT/SUBPAC
LCRS pulls alteration information
LCRS-FMP AIRLANT/PAC
Non-CNO Avails
4
NDE-NM FMPMIS-LOG Detail

• Availability Functions Sep 4 Jan 18
• Security Changes to Support FMPMIS Sep 4 -Sep 7
  100
• Create Use Case Sep 7 - Sep 16 100
• Create Avails (Adds) Sep 10 - Jan 3 90
• Manage Avails (Edits) Jan 11 60
• Email Notification Jan 18 10
• Avail Change Process Approval Jan 18 10
• Alteration Functions Feb
• Add Alt, Edit Alt, Arch Alt, Assign
  Applicability
• Material Functions Mar
• Procurement, BOM, Supercede, Copy
• FMPLOG Replication for Prg/Exe Mar
• FMPMIS LOG in NDE-NM Ready for Beta Testing Mar
  29, 2002

4
5
NDE-NM FMPMIS-LOG Issues

• Business Process Changes
• Developed SPAWAR equipment change for AA to PA to
  SA/AER process.
• Resources
• Need a PLSQL Programmer for the next 5 months
  (70k)
• Need a Java/Web Programmer for the next 4 months
  (60k)
• 3 Programmers at 50 (70k) - FMPMIS budget covers
  other 50
• Funding to Complete
• Funding Requirement 200,000 - Provided by
  NAVSEA
• Risks
• Module Lead (Greg Trout) and programming group
  are not co-located.
• The programming group is needed for support on
  NDE-NM (AIPS).
• Critical Path
• NDE-NM Web Programmers need to finish ISEA
  Transfer by 28 January
• Hire Additional Java Programmer - GSA
  interviewing, onboard 2 January
• PLSQL Programmer identified and will report on 2
  January
• Use Cases need to be modified using Functional
  Specs

5
6
NDE-NM SPAWAR Detail

• NDE-NM to IDB replication Aug 27 - Oct 26 100
• IDB to NDE-NM replication Oct 26 - Mar
• Convert IDB to Oracle Oct 26- Nov 30 100
• Purchase SUN 420 for NDE-SIDE Nov 29 100
• Migrate IDB from SQL to Oracle server Jan 03
  85
• IDB to populate NDE-NM (5 common tables) Nov 5 -
  Jan 30
• Write Repl Program for NDE/NDE-SIDE Jan 7 - Jan
  30
• Configure and Ship SUN 420 to SPAWAR Jan 14
• Put into Test Feb TBD
• Put into Production Mar TBD
• BF CCB Functions in NDE Dec Mar
• Develop Spec CCB process for NDE-SIDE Dec
  01 30
• Develop NDE-SIDE interfaces for function Jan-Feb
  2002
• Put into Test Feb TBD
• Put into Production Mar TBD

6
7
NDE-NM SPAWAR Issues

• Business Process Changes
• Developed functional spec for the process of
  SPAWAR AA to PA to SA/AER.
• Developing function process for alteration
  baseline changes (CCB process).
• Resources
• SPAWAR is providing 4 programmers
• NAVSEA is providing 1 programmer (30k) and a
  Replication Server (85k)
• Funding to Complete
• First Quarter NAVSEA Funding Requirements 115k
  Provided
• Risks
• NMCI Waiver for Server has been submitted to
  NAVSEA and approved.
• SPAWAR needs to populate IDB to NDE-NM (5 basic
  tables)
• SPAWAR needs to document new requirements for CCB
  process.
• Critical Path
• Meeting between SPAWAR, 04M, and SEA 53 to
  document the
• BFI CCB process planned for week of FMP
  Conference (NAVSEA 04M)

7
8
NDE-NM LCRS Detail

• LCRS to NDE-NM replication Sep 4 - TBD
• Identify data for LCRS-FMP to use Sep 4 - Sep
  7 100
• Sign MOA for SEAR to connect to NDE Dec 01 90
• Develop SQL against NDE-TEST TBD
• Test on NDE-TEST TBD
• Put into Production TBD

8
9
NDE-NM LCRS Issues

• Business Process Changes
• No process changes at this time.
• Newport News will enter alteration data into
  NDE-NM, LCRS-FMP will pull via a database link
  for LCRS use (linking alts to work packages)
• Resources
• Requires a PLSQL Oracle programmer for 1 month
• Funding to Complete
• Requirement from Gail Covington is 16K.
• Risks
• NDE-NM/SEAR MOU has not been signed by NSLC. At
  Newport News for Signature.
• Critical Path
• MOA must be signed between Newport News , NSLC,
  and NAVSEA 04M. NSLC to follow up.

9
10
NDE-NM AMPS Detail

• Host AMPS Application Jul 27 - Jan 30
• Sign CONOPS Jul 27 100
• Order Server and Delivered Dec 01 100
• Establish Production Environment Jan 02
• Export/Import Prod database Jan 02
• Put into Production Jan 02
• BF/BG Avail Data to AMPS Replication Sep 7 - Jan
  30
• Contacted VIPER (avails) Sep 7- Sep 10 100
• Determined that VIPER was not authority Jan 18
• AMPS requirements Meeting Jan 02
• Change AMPS to read NDE-NM avail data Jan 02
• Put into Production Jan 02
• BF Baseline Process Nov 1 Feb 28
• Define Requirements Nov - Dec 90
• AMPS/SPAWAR joint meeting Jan 02
• Program Requirements Feb 02

10
11
NDE-NM AMPS Issues

• Business Process Changes
• Need to define the business rules for locking
  baseline amps configuration alterations. What
  can be edited on an alteration after it is
  locked?
• Resources
• SEA 53 is providing 1 ASP programmer, cost
  75,000 and will increase on new contract
  starting in January.
• NAVSEA provided equipment and programming, cost
  21,760
• Funding to Complete
• Funding Requirement 21,760 (NAVSEA) Provided.
• Risks
• Requirements from the working group and SEA 53.
• Critical Path
• AMPS needs to fund the task for for documenting
  AMPS requirements (SEA 53)
• 04M3 Conduct a working group meeting in January
  to finalize AMPS requirements.

11
12
NDE-NM Master Alt List Detail

• Prototype of Master Alt List Functions
• Completed by NSLCJAX Jun 01 100
• CD turned over to NSLCPAC Jun 01 100
• Develop Functions in NDE-NM
• Develop Requirements Oct-Dec 90
• Develop Use Cases Dec-Jan 65
• Determine data fields to add to NDE-NM Jan 02
• Design Screens for RMMCO edits Feb 02
• Test on NDE-TEST Feb 02
• Put into Production Mar 02

12
13
NDE-NM Master Alt List Issues

• Business Process Changes
• Need to determine the input rules of RMMCO.
• Ed Moe is documenting the as-is requirements of
  the RMMCO web application that runs today.
• Steve Walker (NSLCJAX) is creating Use Cases to
  outline what is needed.
• Resources
• Requires a functional person to integration the
  requirements into NDE.
• Requires a Java/Web programmer for 4 months
• Funding to Complete
• Funding Requirement 57,600 provided
• Risks
• New programmers coming online from Silverstream.
• Critical Path
• Ed Moe needs to finish documentation by 18
  January
• Steve Walker needs to finish Use Cases (65
  complete for 8 Use Cases) by 1 Feb.

13
14
NDE-NM TAMS Detail

• Identify TAMS Functions (the Matrix report)
• Pam Smith visited SUBLANT. She is working the
  details for data transfer.
• NSLCPAC contacted SUBPAC, but still need to send
  a person to Pearl to meet with SUBPAC and review
  current TAMS system and develop a plan for
  linking TAMS SUBPAC to NDE.
• Develop Functions in NDE-NM
• Functional Requirements Needed

14
15
NDE-NM TAMS Issues

• Business Process Changes
• SUBLANT does not load data from any other source.
  They have status data that can update NDE-NM for
  SUBLANT alterations.
• Resources
• No additional resources required at this time.
• Funding to Complete
• Funding Requirement Unknown
• Risks
• Requirements for SUBPAC have not been established
• Critical Path
• SUBLANT needs to finish MOA
• Schedule a Trip to SUBPAC

15
16
NDE-NM Action List Summary

• NAVSEA 04M
• Issue Policy on SPAWAR equipment alterations (PA,
  SA, AER) In process
• Resolved Funding Issues - Completed
• Lead BFI Baseline functional working group
• NSLC
• Get NDE-NM registered in the 8030 database -
  Completed
• Sign SEAR MOU (LCRS-FMP) - Still in Process at
  Newport News
• Purchase SPAWAR NDE-SIDE SUN computer - Completed
• Purchase AMPS web application production server -
  Completed
• SPAWAR
• Continue support of integration of IDB into
  NDE-NM - In process
• Provide 4 SPAWAR programmers for integration
  effort - Completed
• SEA 53
• Provide 1 programmer for integration efforts of
  AMPS - Completed
• Provide a functional requirements document for
  AMPS - In process
• Newport News
• Sign SEAR MOA Develop SQL against NDE-NM for
  LCRS-FMP

16
17
NDE-NM Usage
Top Users
Unique Users in a Month
Since April 111,591 edits 112 New Alts
17
18
NDE-NM Summary

• Integration Area Level of
  Confidence
• to complete by 29 Mar 02
• FMPMIS-LOG HIGH
• SPAWAR HIGH
• LCRS-FMP MED
• Behind in developing database link
• AMPS MED
• Still in process of developing specs
• Master Alt List MED
• Still in process of developing specs and use
  cases
• TAMS MED
• Work in process for SUBLANT but not SUBPAC

18