Specifications include, but are not limited to: The purpose of the Request for Proposal (RFP) is to solicit sealed proposals to establish a contract through competitive negotiations for the procurement of services to analyze, cleanse and prepare data for conversion of the New Mexico Educational Retirement Board (NMERB) legacy data from their Pension Administration System (PAS) in preparation for the PAS Modernization Project. The selected vendor is expected to provide data analysis, data cleansing and data conversion extraction/technical services in support of the implementation of a new PAS. A. DATA ANALYSIS REQUIREMENTS 1. Provide a written deliverable, Data Analysis Project Plan, which covers the Data Analysis approach and activities. It should identify all resources necessary for successfully completing the Data Analysis. 2. Perform the analysis per the Data Analysis Project Plan. 3. Provide a written deliverable, Initial Data Analysis Report, on the existing production data, identifying the following items: a. The existing data problems. b. Key data components, key points of time related to the data, missing elements of the data, and summarize elements of the data. c. The attributes and relationships of the key data components data. d. An analysis of the key data components to identify data that will need to be cleaned and/or corrected prior to the implementation of the new PAS system. 4. Map the legacy data to the new PAS data structures, working with the new PAS vendor. 5. Provide a written deliverable, Final Data Analysis Plan, updating the Initial Analysis Report to include information gained following the data mapping.
