ipms-updates20100406-isens

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, [email protected]


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.


3/39

OverallOverallContext DiagramContext Diagram


4/39

IPMSIPMS


5/39

PMIS(NPMC)

NARIS(OTNA)

IPMS(PNFC)

IPMSIPMS


6/39

IPMSIPMS


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/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


9/39


10/39

What does NPMC have?What does NPMC have?

Officers/EP

PMIS


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


12/39

What does OTNA have?What does OTNA have?

Officers/EP

NARIS


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


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)


15/39

What does PNFC have?What does PNFC have?

PNFC PNFC


16/39

STOP

Business Process PainsBusiness Process Pains

IPMS

Officers/EP

NARIS

PMIS

PNFC

Officers/EP

PNFCusers


17/39

Business Process PainsBusiness Process Pains


18/39

What is the Solution?What is the Solution?

SYSTEMSANALYSIS

DESIGN

NewIPMS


19/39

Officers/EP

NARIS

Officers/EP

PNFC

PMIS

PNFCIPMS

Integrated PersonnelIntegrated PersonnelManagement SystemManagement System


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


21/39

The Need for a New IPMS.The Need for a New IPMS.Operating System

Stability Reliability

No Licensing Mechanism Optional Subscription


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.


23/39

Integrated PersonnelIntegrated PersonnelManagement SystemManagement System


24/39

User Diagram:User Diagram:

USERSREPORTS:

1.Hardcopy2.Softcopy

3.Viewing4.Query, Etc

IPMS


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


26/39

User DiagramUser Diagram

PNFCUnit Admin

CHIPs Reports1.Updated SOI2.Accurate Personnel Inventory

3.Other required Executive Reports

IPMSPersonnel Files


27/39


OTNA IPMSOrders

OTNA Reports1.Leave Record2.Statement of Service3.Orders4.Other required Executive Reports


28/39


PNFC

PNFC Required Data1.Number of Payees

2.Number of Area3.Number of personnel per area4.Other required Executive Reports

IPMSPayroll-related system


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


30/39

IPMS ETL ProcessIPMS ETL Process


31/39

ETL: Extract Transform LoadETL: Extract Transform Load


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


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


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.


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.


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.


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.


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.


39/39

Thank You!

ipms-updates20100406-isens

Documents