Navy Retention Monitoring System 08/18/2005 By CDR Robert Weitzman, Analysis Branch Head, Center for Career Development What is NRMS? It is the Navy‟s replacement for two legacy retention reporting systems – Navy Retention (NAVRET) database and Retention Monitoring System (RMS). NRMS fulfills the Navy‟s requirement to be able to report and analyze retention data. NRMS is a joint project spearheaded and funded by the Navy Personnel Command‟s Center (NPC) for Career Development (CCD) and developed in cooperation with the Fleets. Accepted after nearly two years of requirements gathering and development, NRMS takes Retention Analysis to new levels of capability. As the Navy develops Sea Warrior, NRMS will be a key element in monitoring and analyzing retention so that the Navy can effectively deliver the right Sailor, with the right skills, to the right place, at the right time. Master Chief Michael Doyle, the Fleet Career Counselor for Commander, Pacific Fleet who built NAVRET and was a key player in the development of NRMS, says “I am pleased that we will finally have a system that provides the same data to all levels of the Navy. The Navy Retention Monitoring System will provide the data we need quickly, easily and effectively. I encourage every counselor to get their accounts today. Start using it now so that you will be ready before everyone starts using it in FY06.” Why develop NRMS? Currently, Fleets use NAVRET and N1 Staff uses RMS to monitor and report on retention. Both of these tools calculate retention metrics differently (especially attrition). With NRMS, everyone has access to the corporate system, so retention statistics are reported using a common standard and therefore directly comparable. NAVRET was a desktop application (based on Microsoft Access) and had a limited user base. Since NRMS is web-based, individual commands will get access, increasing the user-base significantly (we expect nearly two-thousand users). With NAVRET, Immediate Superiors in Command (ISIC‟s) spent much of their time running reports for their subordinate commands. In NRMS, not only are individual commands empowered to run their own stats, ISIC‟s can now access multi-dimensional data sets to conduct an extensive range of retention analysis never before possible. Who will use NRMS? The largest user base is the Command Career Counselor (rated NC or NEC 9588). ISIC/TYCOM/Fleet NC‟s will use NRMS, too, as well as N1 Staff involved in manpower analysis. Although CO‟s, XO‟s, & CMC‟s will want to review the retention reports, they won‟t need accounts (the CCC will have access, and can send reports by email or hardcopy in either Word or Excel format). Analysts at NPRST, in N1, Enlisted Community Manager‟s (ECM‟s), Navy Diversity Directorate, CCD, etc will benefit from the cube and ad hoc capability (see more on this below). Plus, since NRMS is fed by the Navy Standard Integrated Personnel System (NSIPS), officer continuation rate data is available to assist analysts and Officer Community Manager‟s (OCM‟s) in monitoring and reporting officer continuation rates. NRMS is relatively easy to use. Broken down into list, cube, and ad hoc reports, NRMS has something for every user. Career Counselor (list style) reports are pre-formatted and the user can choose from drop-down menu selections to tailor their query. List reports include all the reports NAVRET offered Retention – Attrition (RET-ATT), Transaction, Honor Roll Reports, etc. Each month, the unit CCC will be able to run their own stats for their CO. The multi-dimensional (cube style) aspect for ISIC/TYCOM/Fleet and N1 Staff level users takes a few minutes to figure out. But once you understand it, it really is a point-and-click application that supports in-depth retention analysis. These cube reports are great for trend analysis. For example, in a few seconds, you can get a spreadsheet style report with attrition data as far back as 1992. Analysts can filter these cubes (slice and dice) the data by an incredible range of demographics. If you want attrition data for a specific rating at a specific command, by gender, zone, etc, over the past 10 years you are just a few clicks away. The data is easily turned into any type of chart that you prefer. These cube reports are what CCD and ECM analysts use to pull retention data for reporting and retention goal setting. When the Chief of Naval Personnel (CNP) reports to the Office of the Secretary of Defense (OSD) or testifies before Congress, cube reports are used to pull the data he needs to talk to Navy‟s Retention. The ad hoc analysis capability is very powerful. Super-users will have a nearly infinite combination of queries at their fingertips. This lets the user answer virtually any retention question imaginable. For example, we wanted to know how many General Detail Sailors (GENDET‟s) were on certain big decks with greater than 24 months of service (GENDET‟s are eligible for A-School between 18 to 24 months) and in a few seconds we had the name of every GENDET, by command who met our search criteria. The utility of NRMS in this case is obvious. What‟s more is that with the historical data, we could get the number of GENDET‟s over time (back to 1992) who had met that criteria. If a command implements a program, it is easy to get the stats to help evaluate the programs effectiveness. NRMS is online and ready for use NOW! New users are getting their accounts and you can too if you are a unit CCC. Don‟t wait! Even though NRMS is online, the decision was made to closeout FY05 with NAVRET. This approach provides two wins: (1) Users have time to get accounts and familiarize themselves with NRMS before FY06 hits, and (2) the Fleets do not need to adjust their Retention Excellence Award benchmarks mid-year. (Remember, attrition is calculated differently in NRMS…for example, the Zone-A Attrition benchmark with NAVRET is 18% based on transactions, but will be more like 9% when using NRMS, based on inventory). Quick Summary of NRMS Highlights: · Uses state of the art Business Intelligence Commercial Off the Shelf (COTS) software · Fed by the N1 corporate data warehouse (NSIPS with feeds from NES, OPINS, TFMMS, etc) · Provides historical data back to 1992 · 24 hour help desk · Includes both an on-line tutorial and a downloadable computer based training application · Meets Navy Enterprise Application Development Guide and NMCI Policy (including PKI) With NRMS, Navy retention reporting and analysis will improve, especially since individual commands can pull their own stats. As we mature the system, we will deploy the scheduling feature that can automatically run standard monthly reports, and send them to the CCC‟s email account. By next year, when the upgrade to the next software version is implemented, NRMS will become seamless with Microsoft PowerPoint. With this upgrade, if you build a report that has retention charts, each month you just need to open the PowerPoint presentation and you will be able to hit an „update‟ button, and your charts will automatically populate with the most recent data. CCD demonstrated NRMS at the 2005 Annual Navy Counselor Association Symposium, and the positive reception was huge, with hundreds of CCC‟s signing up for accounts. If you are a command CCC or analyst needing retention data, go to https://nsips.nmci.navy.mil/ for information on the System Access Authorization Request (SAAR) process. This is a secure site, so you must be in NMCI or have a PKI certification. If you need help in completing the SAAR process, check with your ISIC, or you can call either the NRMS help at 1-877-589-5991 desk or 1-866-U-ASK-NPC.