IT - PDA?s PA Meals team will incorporate appropriate migration strategies within the policy of ITP_INF000, along with providing a migration audit plan checklist for any future data migrations. Additionally, the INF000 will be incorporated into the Delivery Center?s development framework, where a...
IT - PDA?s PA Meals team will incorporate appropriate migration strategies within the policy of ITP_INF000, along with providing a migration audit plan checklist for any future data migrations. Additionally, the INF000 will be incorporated into the Delivery Center?s development framework, where appropriate. PDA added a Business Analyst to the team for assisting with future application testing and documentation. This individual will be directly involved in helping develop and orchestrate a testing strategy based on delivery center standards to include, but not limited to: - Determine appropriate criteria to be tested. - Assist in establishing a test group of qualified testers. - Coordinate with technical team on pass/fail criteria. - Utilize standard testing tasks/checklists ensuring consistency. - Assist the team, key business users and the technical team in reviewing testing results. The reports were reviewed electronically (100s of report pages) checking for various scenarios. As a result, these complete reports are similar and difficult to distinguish between without an associated checklist and specific report criteria. In the future, full test plans and execution results capturing pass/fail of the defined tests will be retained in pdf (or similar) format. The team will continue with best practices and delivery center standards, utilizing a Business Analyst as part of the testing and review process. The SEFA report had extensive testing, however, there is a timing issue that will always exist if the expectation is to provide the data in both January and September. The January report will be accurate for when it is run, along with what transactions were sent by the warehouse vendor. Subsequently, changes can and will occur to those commodities being reported on over the next 6 months. Additionally, it is reliant upon the warehouse vendor to report all transactions timely. As a result, running the same report after June 30th will consistently vary due to a physical inventory review in June, along with additional transactions being updated as part of the inventory review. PDA is recommending a one-time annual report in September, which will include all the adjustments from a June physical inventory and updated transactions. A January report is fine to run but should not be considered a fully accurate assessment due to the timing and missing data. Program - PDA strives to maintain accurate and complete records with respect to the receipt, distribution, and inventory of USDA donated foods, including end products processed from donated food. To that end, PDA has already or will put the following steps in place to strengthen procedures for future periods to ensure errors identified during the reconciliation process are corrected timely in the system: 1) All findings noted with regards to the Commodity Processors Inventory Report have been corrected and no known issues remain. 2) No further inventory balances remain on record with inactive distributors, as all product was previously transferred to active distributors. 3) Processor monthly performance reports (MPRs) will be completed and filed in accordance with USDA?s prescribed schedule (90 days after completion of month). 4) BFA will work with the Commodity Distributors and USDA to mutually resolve discrepancies and achieve reconciliation with USDA receipts. 5) Moving forward, all Commodity Distributor Inventory Reports will be reconciled by the beginning of a new federal fiscal year (October 1), and inventory balances at commodity distributors will agree with year-end physical inventory counts. Anticipated Completion Date: IT - 09/30/2023; Program 1-Completed; 2-Completed; 3-09/30/2023; 4-09/30/2023; 5-09/30/2023 Contact Person and Title: Caryn Long Earl, PDA, Director, Bureau of Food Assistance (BFA)