ipms-updates20100406-isens
Post on 09-Apr-2018
221 Views
Preview:
TRANSCRIPT
-
8/8/2019 IPMS-Updates20100406-Isens
1/39
PN-IPMSPN-IPMSSystems Analysis andSystems Analysis and
Design UpdatesDesign Updates
17 April 2010
Caroline G. Apolinario-Lozano, MCScarol@isens.asia
-
8/8/2019 IPMS-Updates20100406-Isens
2/39
IPMS Project UpdateIPMS Project UpdateUser Objectives:
To integrate the three systems and databasesinto a single unified system and database.
To make the system readily available to the17 Naval Offices securely anytime andanywhere.
To provide the navy personnel access to theirown personnel records online.
-
8/8/2019 IPMS-Updates20100406-Isens
3/39
OverallOverallContext DiagramContext Diagram
-
8/8/2019 IPMS-Updates20100406-Isens
4/39
IPMSIPMS
-
8/8/2019 IPMS-Updates20100406-Isens
5/39
PMIS(NPMC)
NARIS(OTNA)
IPMS(PNFC)
IPMSIPMS
-
8/8/2019 IPMS-Updates20100406-Isens
6/39
IPMSIPMS
-
8/8/2019 IPMS-Updates20100406-Isens
7/39
Critical Findings:NPMCCritical Findings:NPMCPMIS was developed last 2003 and was deployed
on 2005
It was developed using Visual Basic
Its mainstream support ended last March 31,2005;
Microsofts extended support ended March2008
VB is a dead technologyMicrosoft SQL Server a proprietary database
-
8/8/2019 IPMS-Updates20100406-Isens
8/39
Critical Findings:NPMCCritical Findings:NPMCMicrosoft Windows 2003 operating system used.
Its near end-of-life with the release ofWindows 2008
Current IPMS is not designed in a cross-platformenvironment.
Current working module is Personnel Module
Limited access to SOI by PN Personnel
Updating of records is the sole responsibility ofNPMC.
Orders and DF modules development areongoing/testing period
-
8/8/2019 IPMS-Updates20100406-Isens
9/39
-
8/8/2019 IPMS-Updates20100406-Isens
10/39
What does NPMC have?What does NPMC have?
Officers/EP
PMIS
-
8/8/2019 IPMS-Updates20100406-Isens
11/39
Critical Findings:OTNACritical Findings:OTNA
NARIS Naval Adjutant Records InformationSystem
A system developed using FoxBase during thelate 80s
Its a text based system running on MS-DOS
OTNA maintains and updates its own database
It is still being used to generate Statement of
Service and Leave BalanceIssuance of SOI is OTNAs Function (ONA/N1 Cir #
7 dated 22 April 2009) but is currentlydone at NPMC
-
8/8/2019 IPMS-Updates20100406-Isens
12/39
What does OTNA have?What does OTNA have?
Officers/EP
NARIS
-
8/8/2019 IPMS-Updates20100406-Isens
13/39
Critical Findings:PNFCCritical Findings:PNFCPNFC is using the Payroll Module of the IPMS
developed using I4GL,ISQL
Database: Informix
Operating System: SCO UnixThey maintain and update their own personnel
database that are necessary in payroll processingsuch as:
Promotion/Demotion orders Long Pay Order
-
8/8/2019 IPMS-Updates20100406-Isens
14/39
Critical Findings:PNFCCritical Findings:PNFCThey maintain and update their own personnel
database that are necessary in payroll processingsuch as:
Assignment orders/CHIPS Report for the units with extra collateral pay CAD Orders/Enlistment Order Retirement/discharge orders
Reenlistment order c/o major unit For reserve officers - Tour of Active Duty
(ETAD)
-
8/8/2019 IPMS-Updates20100406-Isens
15/39
What does PNFC have?What does PNFC have?
PNFC PNFC
-
8/8/2019 IPMS-Updates20100406-Isens
16/39
STOP
Business Process PainsBusiness Process Pains
IPMS
Officers/EP
NARIS
PMIS
PNFC
Officers/EP
PNFCusers
-
8/8/2019 IPMS-Updates20100406-Isens
17/39
Business Process PainsBusiness Process Pains
-
8/8/2019 IPMS-Updates20100406-Isens
18/39
What is the Solution?What is the Solution?
SYSTEMSANALYSIS
DESIGN
NewIPMS
-
8/8/2019 IPMS-Updates20100406-Isens
19/39
Officers/EP
NARIS
Officers/EP
PNFC
PMIS
PNFCIPMS
Integrated PersonnelIntegrated PersonnelManagement SystemManagement System
-
8/8/2019 IPMS-Updates20100406-Isens
20/39
The Need for a New IPMS.The Need for a New IPMS.Data Base
Scalability and Flexibility High Performance
High Availability Robust Transactional Support Web and Data Warehouse Strengths Strong Data Protection
Open Source Freedom and 24x7 Support Lowest Total Cost of Ownership
-
8/8/2019 IPMS-Updates20100406-Isens
21/39
The Need for a New IPMS.The Need for a New IPMS.Operating System
Stability Reliability
No Licensing Mechanism Optional Subscription
-
8/8/2019 IPMS-Updates20100406-Isens
22/39
The Need for a New IPMS.The Need for a New IPMS.
Browser-based Application Accessible via navy network and/or www No special configuration or changes are
needed on user's PCs.
Lower costs. Centralised data is secure and easy to
backup. Updates can be made quickly and easily. Information is accessible to a wide audience
anywhere. Available 24 hours a day, 7 days a week. Everybody has a browser - familiar interface
encourages use.
-
8/8/2019 IPMS-Updates20100406-Isens
23/39
Integrated PersonnelIntegrated PersonnelManagement SystemManagement System
-
8/8/2019 IPMS-Updates20100406-Isens
24/39
User Diagram:User Diagram:
USERSREPORTS:
1.Hardcopy2.Softcopy
3.Viewing4.Query, Etc
IPMS
-
8/8/2019 IPMS-Updates20100406-Isens
25/39
User Diagram:User Diagram:
N1/NPMC
Statistical Reports1.# of Capt2.# of Logistician3.# of Retiring this year
4.Due for promotion5.Due for Specialization
Strength Reports1.Fleet Count2.Marine Count3.NISF4.NLC5.Naval Force6.Etc
1.SLL Report3.Automated QRS4.Other Required Executive Reports
IPMSPersonnel Files
-
8/8/2019 IPMS-Updates20100406-Isens
26/39
User DiagramUser Diagram
PNFCUnit Admin
CHIPs Reports1.Updated SOI2.Accurate Personnel Inventory
3.Other required Executive Reports
IPMSPersonnel Files
-
8/8/2019 IPMS-Updates20100406-Isens
27/39
User DiagramUser Diagram
OTNA IPMSOrders
OTNA Reports1.Leave Record2.Statement of Service3.Orders4.Other required Executive Reports
-
8/8/2019 IPMS-Updates20100406-Isens
28/39
User DiagramUser Diagram
PNFC
PNFC Required Data1.Number of Payees
2.Number of Area3.Number of personnel per area4.Other required Executive Reports
IPMSPayroll-related system
-
8/8/2019 IPMS-Updates20100406-Isens
29/39
How will the new IPMS work?How will the new IPMS work?
SOI
IndividualUsers
1 Family
OTNA
Orders
PNFC
Inquiry
Report
Report
OtherUsers
-
8/8/2019 IPMS-Updates20100406-Isens
30/39
IPMS ETL ProcessIPMS ETL Process
-
8/8/2019 IPMS-Updates20100406-Isens
31/39
ETL: Extract Transform LoadETL: Extract Transform Load
-
8/8/2019 IPMS-Updates20100406-Isens
32/39
Hardware Capacity PlanHardware Capacity PlanUse of RAID technology is highly recommended
for the following reasons: Higher Data Security
Fault Tolerance Improved Availability Increased Integrated Capacity Improved Performance
At least Quad Core ProcessorMinimum of 4Gb Memory
Redundant Power Supply
-
8/8/2019 IPMS-Updates20100406-Isens
33/39
Hardware Capacity PlanHardware Capacity PlanRaid Level 10- Mirroring, Requires minimum of 4
Drives Drive Bays: Standard 5 hot-swap SAS/SATA Flex-bay Storage Drive: 500Gb Serial ATA Hard Drive 7200 RPM
16MB Buffer 2nd Hard Drive: 500Gb Serial ATA Hard Drive 7200
RPM 16MB Buffer 3rd Hard Drive: 500Gb Serial ATA Hard Drive 7200 RPM
16MB Buffer 4thHard Drive: 500Gb Serial ATA Hard Drive 7200 RPM
16MB Buffer
-
8/8/2019 IPMS-Updates20100406-Isens
34/39
Software Capacity PlanSoftware Capacity PlanTo meet the recommended Browser-based User
Interface requirements of Philippine Navy-IPMS,the following is the suggested
Database/Operating System/Front-endDevelopment Tool to be used:
MySQL for Database
The most widely used open sourcedatabase because of its consistent fastperformance, high reliability andease-of-use.
-
8/8/2019 IPMS-Updates20100406-Isens
35/39
Software Capacity PlanSoftware Capacity PlanLinux for Operating System
open source, multi-platform,
multi-user operating system.PhP/Java/
a widely-used open source general-purpose scripting language that is specially
suited for web development. It is very useful in integrating WebPages
with databases.
-
8/8/2019 IPMS-Updates20100406-Isens
36/39
Network Capacity PlanNetwork Capacity PlanReview the current network setup
Network equipment (routers, switches) End-user equipment (workstations)
Local access requirements
Remote access requirements
Existing applications
Determine future/planned applications aside
from IPMS that will run in the network.Connectivity outside the organization (to
stakeholders)
Allocate a minimum of 2Mbps CIR to IPMS server.
-
8/8/2019 IPMS-Updates20100406-Isens
37/39
Network Security PlanNetwork Security PlanImplement NIPRNet and SIPRNet
NIPRNet. Nonsecure Internet Protocol RouterNetwork. It is used to exchange sensitivebut unclassified information between"internal" users as well as providing usersaccess to the Internet.
SIPRNet. Secure Internet Protocol RouterNetwork. A secured network dedicated to
computers directly accessing the IPMSserver.
Implement a Semestral Security Audit To determine the vulnerabilityof the
system/network.
-
8/8/2019 IPMS-Updates20100406-Isens
38/39
Information Security PlanInformation Security PlanProtect the security and confidentiality of
protected Information;
Protect against anticipated threats or hazards to
the security or integrity of suchinformation; and
Protect against unauthorized access to or use ofprotected Information that could result in
substantial harm or inconvenience to anypersonnel and the entire organization.
-
8/8/2019 IPMS-Updates20100406-Isens
39/39
Thank You!
top related