Designed an integrated project plan process using Microsoft Project.  This consisted of over 50 concurrent project plans linked by a common resource pool.  Project plans were source controlled thru checkout / checkin.  Customized the MsProject plans with over 200 components (Fields, Tables, Views, Filters, Forms, Calendars, Macros).  Used Visual Basic for Applications in Excel, Outlook & Access to develop the following automation.

• Created a weekly process to integrate these plans and distribute the centrally maintained components.

• Developed an automated process to maintain the individual resource calendars for 250+ people in MsProject by extracting vacation days from the Lotus Notes Vacation Planner tool.

• Created an Excel timesheet to collect weekly actuals and allow bottom-up re-estimating thru remaining work and start/finish date adjustments.  This data was then automatically posted to the MsProject plans.  Developed an automated process to generate these timesheets and email them each week. 

• Extracted and reported Earned Value information as well as calculating EV performance ratios (SPI, CPI, TCPI, etc.) not provided by MsProject. 

• Created an automated process to generate S-curve charts as PDF files showing cumulative baseline, projected and actual work/starts/finishes for each MsProject plan.

•  Created an automated MsProject plan auditing process that analyzed each plan for over thirty items. i.e. Task guidelines compliance, Task relationship quality, Resource assignment anomalies, etc.  This created a custom email for each plan owner with the specific plan issues identified.

• Created a consolidated Resource Information report showing baseline, actual and projected hours by week by MsProject plan.  This was used to analyze resource-leveling issues.