Designed and implemented an integrated Earned Value Management System (EVMS) using Custom off the shelf (COTS) tools with custom interfaces to form the individual tools into an integrated system.  The program (Healthcare Integrated General Ledger Accounting System (HIGLAS)) is a ten-year plan to implement Oracle Financials to receive Medicare claim data electronically from the 50 state Medicare claim processors.  The EVMS system that was implemented to monitor this 200+ person program was approved by the government agency (CMS) as fulfilling the 32 OMB EVMS guidelines or equivalent.  Project Scheduling was provided by Microsoft Project, Earned Value calculation and basic reporting were provided by MPM and graphical EVM reporting was provided by Winsight.  It used Visual Basic for Applications in MsProject, Excel, Outlook & Access to develop the following automation.

• Created interfaces from four IBM labor reporting systems to post daily actuals at the work package level to the Integrated Master Schedule (IMS) in MsProject.

• Created and Excel spreadsheet to allow review of actuals posted by the Work Package Manager (WPM) and updates to Estimate to Complete (ETC) and planned Start & Finish dates.  The changes made in this spreadsheet were posted to the IMS on a weekly basis.

• Created Excel tools to extract data from MsProject and provide the ability to maintain work package data, milestones, resource assignments and predecessor relationships.  These tools allowed the thirty work package managers to provide updates to a central IMS administrator without ever having direct update access to the IMS. 

• Created several Excel based reports/query tools that allowed Work Package Managers or Cost Account Managers to extract current data from the system relating to Deliverables, Milestone Variances, Resource Allocation & Actuals & Budget vs. Actuals.

• Extensive use of automation was used to distribute information via email.  For example, weekly reports were zipped and sent as an email attachment to the Work Package and Cost Account Managers.  Work Authorizations were created as PDF files and attached to an individual email sent to each of the 200+ resources weekly.