Automating an inventory management system while maintaining test ...
Transcript of Automating an inventory management system while maintaining test ...
![Page 1: Automating an inventory management system while maintaining test ...](https://reader034.fdocument.pub/reader034/viewer/2022051521/586cbe161a28abaa238b76fb/html5/thumbnails/1.jpg)
Automating an Inventory Management System
While Maintaining Test Integrity
IPAC Conference, Las Vegas
July 24, 2012
![Page 2: Automating an inventory management system while maintaining test ...](https://reader034.fdocument.pub/reader034/viewer/2022051521/586cbe161a28abaa238b76fb/html5/thumbnails/2.jpg)
AGENDA
• Nationwide Testing (NWT) Overview
• Automating an Inventory Management detailed steps on:
º Research
º Development
º Implementation
º Oversight
1
![Page 3: Automating an inventory management system while maintaining test ...](https://reader034.fdocument.pub/reader034/viewer/2022051521/586cbe161a28abaa238b76fb/html5/thumbnails/3.jpg)
NWT OVERVIEW 1 2
![Page 4: Automating an inventory management system while maintaining test ...](https://reader034.fdocument.pub/reader034/viewer/2022051521/586cbe161a28abaa238b76fb/html5/thumbnails/4.jpg)
NWT ORGANIZATION
3
![Page 5: Automating an inventory management system while maintaining test ...](https://reader034.fdocument.pub/reader034/viewer/2022051521/586cbe161a28abaa238b76fb/html5/thumbnails/5.jpg)
NWT OVERVIEW
Mission Focus
• Government-to-government organization
• Authorized to support federal, state and local agencies in all U.S. states and territories
• Nationwide network with more than 500 agency personnel
Stability, Scale
• Over 30 years of test administration and HR expertise
• Administers assessment solutions and entry-level and promotional tests to 1 million applicants annually
4
![Page 6: Automating an inventory management system while maintaining test ...](https://reader034.fdocument.pub/reader034/viewer/2022051521/586cbe161a28abaa238b76fb/html5/thumbnails/6.jpg)
NWT CUSTOMERS
5
![Page 7: Automating an inventory management system while maintaining test ...](https://reader034.fdocument.pub/reader034/viewer/2022051521/586cbe161a28abaa238b76fb/html5/thumbnails/7.jpg)
NWT OFFERINGS 2 6
![Page 8: Automating an inventory management system while maintaining test ...](https://reader034.fdocument.pub/reader034/viewer/2022051521/586cbe161a28abaa238b76fb/html5/thumbnails/8.jpg)
NWT OFFERINGS
7
![Page 9: Automating an inventory management system while maintaining test ...](https://reader034.fdocument.pub/reader034/viewer/2022051521/586cbe161a28abaa238b76fb/html5/thumbnails/9.jpg)
RESEARCH 3 8
![Page 10: Automating an inventory management system while maintaining test ...](https://reader034.fdocument.pub/reader034/viewer/2022051521/586cbe161a28abaa238b76fb/html5/thumbnails/10.jpg)
RESEARCH
• Risks of not pursuing modernization initiative:
º Inadequate test security
º Test Loss Compromise (TLC)
• NWT reputation of secure test handling and security
• Manual process did not function optimally
9
![Page 11: Automating an inventory management system while maintaining test ...](https://reader034.fdocument.pub/reader034/viewer/2022051521/586cbe161a28abaa238b76fb/html5/thumbnails/11.jpg)
MANUAL VS. AUTOMATED
• Manual process was
lengthy and not easily
accessible
• Increase transparency
when automating system to
an Internet based site
• NWT warehouse operation
is unique and is not fit for
off-the-shelf and needed
customization
º Varying suspense dates
º Serial numbers
10
![Page 12: Automating an inventory management system while maintaining test ...](https://reader034.fdocument.pub/reader034/viewer/2022051521/586cbe161a28abaa238b76fb/html5/thumbnails/12.jpg)
NWT RESEARCH AND DEVELOPMENT
Through conducting a
formal study it was
determined that the
previous inventory
management software
needed to be replaced.
NWT collaborated with
technical counterparts
within OPM to design,
build and implement a
system that adequately
addressed distinctive
inventory management
needs
11
![Page 13: Automating an inventory management system while maintaining test ...](https://reader034.fdocument.pub/reader034/viewer/2022051521/586cbe161a28abaa238b76fb/html5/thumbnails/13.jpg)
IMPORTANCE DEFINED
• As a testing service provider, test security is the most
important function we provide our clients
• Internal material handling, distribution system and
processes would be streamlined
High quality system
Increased accountability
12
![Page 14: Automating an inventory management system while maintaining test ...](https://reader034.fdocument.pub/reader034/viewer/2022051521/586cbe161a28abaa238b76fb/html5/thumbnails/14.jpg)
SYSTEM REQUIREMENTS SPECIFICATIONS
• Inventory and order management system Software
Requirements Specifications (SRS) sections included:
• Introduction
• Overall system design
• Inventory
management
• Ordering
• Allocating
• Picking
• Packing
• Shipping
• Receiving orders
• Warehouse
management
• Field operation
management
• System reporting and
querying
• Vendor requirements
• Warehouse equipment
13
![Page 15: Automating an inventory management system while maintaining test ...](https://reader034.fdocument.pub/reader034/viewer/2022051521/586cbe161a28abaa238b76fb/html5/thumbnails/15.jpg)
DEVELOPMENT 4 14
![Page 16: Automating an inventory management system while maintaining test ...](https://reader034.fdocument.pub/reader034/viewer/2022051521/586cbe161a28abaa238b76fb/html5/thumbnails/16.jpg)
DESIGN & DEVELOPMENT
IT Specialist, program analysts,
warehouse management and
contractor diligently
reviewed SRS
Ensured project scope and technical
requirements properly
addressed the needs
Once all parties understood
requirements, system
development began
15
![Page 17: Automating an inventory management system while maintaining test ...](https://reader034.fdocument.pub/reader034/viewer/2022051521/586cbe161a28abaa238b76fb/html5/thumbnails/17.jpg)
SYSTEM DEVELOPMENT
• Ongoing communication with developers and
programming staff
• Each portion of the SRS was tested for errors by IT
personnel and a program analyst
• The system was finalized after a few minor changes
Continuous testing on each developmental aspect ensured that NWT would receive the highest quality
automated system
16
![Page 18: Automating an inventory management system while maintaining test ...](https://reader034.fdocument.pub/reader034/viewer/2022051521/586cbe161a28abaa238b76fb/html5/thumbnails/18.jpg)
IMPLEMENTATION 5 17
![Page 19: Automating an inventory management system while maintaining test ...](https://reader034.fdocument.pub/reader034/viewer/2022051521/586cbe161a28abaa238b76fb/html5/thumbnails/19.jpg)
IMPLEMENTATION GOALS
Minimize the impact of implementation on day-to-
day operations
Account for all test material and enter it into the new
system
Train all system users
18
![Page 20: Automating an inventory management system while maintaining test ...](https://reader034.fdocument.pub/reader034/viewer/2022051521/586cbe161a28abaa238b76fb/html5/thumbnails/20.jpg)
IMPLEMENTATION PLAN
• Ensured all orders needed for first two months were
placed and filled before implementation began
• Field staff returned any
test materials no longer
needed to the warehouse
• Shut down the old
inventory system
19
![Page 21: Automating an inventory management system while maintaining test ...](https://reader034.fdocument.pub/reader034/viewer/2022051521/586cbe161a28abaa238b76fb/html5/thumbnails/21.jpg)
IMPLEMENTATION PLAN (cont.)
• Conducted a nationwide physical inventory of all test
material
• Entered all test material that was in use by employees
into the new system
• Entered all test material that was stored in the
warehouse into the new system
• Activated the new inventory system
20
![Page 22: Automating an inventory management system while maintaining test ...](https://reader034.fdocument.pub/reader034/viewer/2022051521/586cbe161a28abaa238b76fb/html5/thumbnails/22.jpg)
TRAINING
• Three types of training tools were used:
User
Guide
Web-
based
training
Online
test
site
21
![Page 23: Automating an inventory management system while maintaining test ...](https://reader034.fdocument.pub/reader034/viewer/2022051521/586cbe161a28abaa238b76fb/html5/thumbnails/23.jpg)
OVERSIGHT 6 22
![Page 24: Automating an inventory management system while maintaining test ...](https://reader034.fdocument.pub/reader034/viewer/2022051521/586cbe161a28abaa238b76fb/html5/thumbnails/24.jpg)
3 LEVELS OF CONTINUOUS OVERSIGHT
Material-In-Use Inventory Verification
Active Inventory Verification
F
R
E
Q
U
E
N
C
Y
Continuous Monitoring of Material Order Contents
23
![Page 25: Automating an inventory management system while maintaining test ...](https://reader034.fdocument.pub/reader034/viewer/2022051521/586cbe161a28abaa238b76fb/html5/thumbnails/25.jpg)
CONTINUOUS MONITORING
• OPM warehouse ensures correct test material quantities
are being requested by field staff before orders are filled
• Multiple counts of material are
completed by warehousemen
upon order shipment and receipt
• Verification of outbound
shipment address
• UPS tracking number assigned to each shipping box in a
given order
24
![Page 26: Automating an inventory management system while maintaining test ...](https://reader034.fdocument.pub/reader034/viewer/2022051521/586cbe161a28abaa238b76fb/html5/thumbnails/26.jpg)
INVENTORY VERIFICATION
• Two types of inventory verification are done at regular
intervals:
Material-In-Use Inventory
Any test material that is
currently in use by
NWT field staff for
test administration
Active Inventory
Any test material that is
available to order from
the automated system
by NWT field staff
25
![Page 27: Automating an inventory management system while maintaining test ...](https://reader034.fdocument.pub/reader034/viewer/2022051521/586cbe161a28abaa238b76fb/html5/thumbnails/27.jpg)
BENEFITS REALIZED
• Minimize chance for TLC
• Data and reports available to rectify any discrepancies
• Increased operational efficiency
• Customer peace of mind
• Accurate online inventory system accessible to all levels
of the organization despite geographic disbursement
26
![Page 28: Automating an inventory management system while maintaining test ...](https://reader034.fdocument.pub/reader034/viewer/2022051521/586cbe161a28abaa238b76fb/html5/thumbnails/28.jpg)
Athena M. Dattilo, MPA, PMP
(312) 886-0249
Charles F. Trucco, MA
(312) 886-2884
[email protected] or (312) 353-6234
CONTACT US
27