Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Senior Program Planning and Scheduling Analyst, Sierra Nevada Corporation, Small Aircraft Modification

START Date: 
January, 2013
As a scheduler, I'm responsible for the design, development and maintenance of Aircraft Modification schedules in MS Project. In this position I create schedules for use by Program Management, Engineering and Operations. •Currently I run schedule risk analysis with @Risk and keep a schedule risk register •For new programs, I run discrepancy analysis reports. I build these reports by extracting data from engineering drawings in PDFs and cleaning them up in MS Excel. I then take data from the material specialist and compare the data part list to make sure we have complete data and report the discrepancy. Once I have a consolidated part list by aircraft modification, I then compare to the list from procurement. I consolidate the price and parts with vlookups and small VBA macros (and other MS Excel formulas) to maintain procurement’s price list. I run data through RStudio with R program scripts to generate statistics reports. Finally, I price out the cost for parts per modification. •I'm responsible for the design, development and maintenance of Aircraft Modification schedules in MS Project 2007, 2010, and now 2013. •I work closely with Engineering, Manufacturing, Supply Chain, Program Management, Quality Assurance and Test to create schedules that can accurately forecast delivery dates and assist in developing work plans •I provide detail level status reports to the project team weekly and program level status reports to the Program Manager and customer monthly in a PowerPoint presentation with critical paths for each aircraft and the material impacting our critical path. I provide Gantt charts and visual timelines. •I have created a macro in MS Excel 2010 to combine 3 reports from Enterprise BI and information from the schedule in MS Project 2010 to give accurate material shortages and where this shortages impact the critical path.
Experience Hours (Planning & Scheduling): 
3500
Experience Hours (Cost Management): 
500