SUMMARY:

• Expert in Enterprise Project Management (EPM) - Portfolio, Program and Project Management using Integrated Dynamic Scheduling techniques across Multiple Vendors with 40+ MS Project Schedules.
• Demonstrated experience in Program Management oversight for the delivery of services to include staffing (200+), subcontractor relations, customer relationship management, reporting, etc.
• Exceptional skills in Advanced VBA programming and coding macros to leverage project reporting using Microsoft Office Suite of tools.
• Proficient in the use of Advanced Excel and Power BI - Power Query, Power Pivot and Power View i.e. M-Query and Data Analytics Expressions (DAX)
• Exceptional skills in Predictive, prescriptive, descriptive and visual analytics using Microsoft Power BI models, reports and dashboards

WORK EXPERIENCE:

Project Schedule and Cost Analyst

Confidential, Raleigh, NC

Responsibilities:

• Support cross program scheduling for multiple strategic IT initiatives
• Work with Project Managers, Program Managers and Senior Technical personnel to track, analyze, and report progress on assigned projects
• Regularly assess the portfolio- status, progress and forecast through compliance dashboard reports
• Help Project Manager to track Stakeholders approval through DocuSign and archive project deliverables in Project Sites
• Provide inputs into Program and Portfolio Management (PPM) tool based on schedule updates, risks, issues and change requests
• Coach the SWI PMs to leverage MS Project Views and Filters to review their project schedules for reliability and to run Schedule Quality Compliance checks to fix the Key Performance Indicators, schedule risks/issues prior to conducting an Integrated Baseline Review
• Conduct Integrated Baseline Reviews, generate detailed Steelray Project Analyzer Scorecard Reports and help PMs understand these reports and fix schedule risks/issues in their projects
• Track Performance Measurement Baseline for all SWI projects and provide progress updates to the Senior Management
• Establish and maintain project cost and schedule Performance Measurement Baseline
• Conduct PM Governance Meetings to collaborate with Project Managers; guide them if they had any question with respect to the new PM Orientation, PM Job Aids such as project schedule templates, project initiation, execution and control or closing in PPM, Key Project Milestones, SDLC Milestones, External Dependency Milestones (ITEST), Project Compliance Reporting through Steelray Project Analyzer Scorecards, Stage Gate processes, Change Request processes
• Communicate with all SWI Project Managers to update their projects in PPM for project status, progress and forecast information
• Guide PM’s through the Change Control Process and Stage Gate Review processes
• Update existing SWI Project Schedule templates to track marked milestones
• Generate and export PPM dashboard report in APPTIO for all In Progress SWI projects (120+) on the Utilization of 30 PPM Required Enterprise Custom Fields
• Programmatically download all In Progress SWI projects from Project Online 2016 using VBA Script application and manually download Master Projects with their Sub-Projects from Project Online 2016
• Conduct DCMA 14-Point Schedule Quality Assessment by running Steelray Project Analyzer detailed scorecard reports and group matrix reports on the Project Set of all In Progress SWI project MPP files downloaded
• Finalize the Scorecard Report for all In Progress SWI projects and create a PowerPoint presentation for Trend Analysis of the SWI Program for the Senior Management distribution
• Upload all MPP files and detailed Steelray Project Analyzer output files used for the Senior Management Scorecard reporting to iT Effectiveness SharePoint site
• Create visually aesthetic, real-time dashboard reports in Power BI using the data sources from PPM, SharePoint lists and MS Excel.

SENIOR PROJECT CONTROLS ANALYST

Confidential, Silver Spring, MD

Responsibilities:

• Assigned to the Geography Project Management Branch ( Confidential ) and supported 22 Confidential Branch Division Chiefs and their 200+ enterprise resources in the resource pool of Enterprise Portfolio Management Tool with their on-going program planning
• Created 18 project schedules for the Geography Division to plan, coordinate, and administer all geographic and cartographic activities needed to facilitate the Bureau's statistical programs throughout the US and its territories; Managed a program to continuously update features, boundaries and geographic entities in TIGER and the Master Address File (MAF) and to conduct research into geographic concepts, methods, and standards needed to facilitate the Bureau's data collection and dissemination programs; Tracked work towards partnerships and programs Confidential of Bureau has with governments including the Boundary and Annexation Survey, School District Review Program, American Indian and Alaska Native Programs and Confidential partnership programs; Tracked work performed on a web service that fulfills the need for a geocoding service from the Geography Division
• Weekly updated and statused the Confidential Integrated Master Schedule (IMS) and the 18 Confidential Sub-Project Schedules; Rescheduled work not completed in the week to start after the Status Date; Forecasted the Remaining Work, Reviewed and updated Task Usage, Resource Usage; Reviewed and validated the Critical Path; Tracked Variance from the Baseline; Refined the schedules to ensure there is neither any Negative Total Slack on tasks nor any excessive Positive Slack on tasks
• Weekly examined each identified Project- Risk and Issue associated with the Geographic Support Activity Program Sites; Mapped each identified Issue to existing Risk(s); Mapped each Risk to Task(s) in the respective schedules; Mapped each Issue to Task(s) in the respective schedules; Updated the status of each Risk and Issue based on inputs from the Confidential Project Management Branch ( Confidential ) Chief
• Worked with the Contracting Office (CO) in the Contracts Management Branch to identify direct costs associated with the utilized Contractors through the submitted invoices and entered the Actual Costs of the Contractors on the project tasks to monitor, track and report on the project progress and management of contract resources
• Served as a technical advisor to the Contracting Officers Technical Representative (COTR) and staff on all subjects related to Planning and Scheduling Practices with Project Server
• Leveraged advanced understanding of project management methodology, project control principles, and hands on experience with scheduling software (e.g. Primavera and/or Microsoft Project Professional and Microsoft Project Server) to ensure Project Controls provides successful tools to manage project work, resources, and dollars
• Ensured the Directorate or Division Portfolio Management Governing Board’s (PMGB) governance decisions get implemented in the Enterprise Portfolio Management Tool (EPMT) configuration; Confirmed the EPMT configuration served the Directorates Portfolio and Project Management needs; Determined any additional Directorate/Division Project Server configuration necessary while staying within bounds of the Enterprise Project Server configurations; Submitted Configuration Change Requests, System Change Requests and Report Change Requests
• Managed and maintained Division resources security settings, Organizational Breakdown Structure (OBS),Resource Breakdown Structure (RBS) and Directorate custom fields in the enterprise resource pool; Managed and maintained the Confidential Division’s portion of the Enterprise Resource Pool - any and all changes to the Resource Branch, Resource Division, Resource Directorate, Region, Labor Categories, Standard Rate, Overtime Rate; Managed the synchronization of Project Server data with other external systems such as Active Directory and CHRIS
• Examined current reports available and determined additional Directorate and/or Division reporting needs; Developed Directorate and/or Division business requirements for portfolio management e.g. a custom SSRS report to track the Actual Work of Confidential Division resources on Internal Use Software (IUS); Worked with the Confidential Schedule Staff to develop new reports for Business Intelligence to analyze and report project controls data; Facilitated EPMT Decisions and Governance at Confidential
• Provided first line of Help Desk Support for the Confidential Division EPMT users; Troubleshooted Issues related to Project Server faced by Confidential resources and resolved them or created workarounds; Helped team members with correcting their timesheet entries and submissions as necessary; Documented job aids or instructions e.g. FAQs and provided guidance to Confidential resources, trained and mentored the Confidential Status Managers
• Work with Microsoft Project Server Add-in software such as One Pager Pro for colorful timeline views and Masterlink for monitoring and tracking External Dependency links

MASTER SCHEDULER

Confidential, Columbia, MD

Responsibilities:

• Created a Schedule Test and Assessment Tool (STAT) Checklist to identify, measure and rate key credibility indicators contained within a project schedule based on the accepted rules of logic network development used in Critical Path Method (CPM) scheduling techniques that reflect both good and poor characteristics in the areas of schedule structure, maintenance, and performance.
• Trained Booz Allen Hamilton contractors in generating an Integrated Master Schedule using Integrated Dynamic Scheduling techniques across Multiple Vendors with 30+ MS Project Master Schedules in MS Project Professional 2010, MS Project Server 2010 and Project Web App 2010.
• Led the program-wide implementation of standard Work Breakdown Structure ( Confidential ) using CMS XLC Methodology - ensured that the project schedule represented a detailed Confidential - decomposition into Control Account, Work Packages, Deliverables, Activities, Gate Reviews and Milestones
• Partnered with component leads and Subcontractors for development, implementation, maintenance, and oversight of all program schedules
• Ensured that project schedules are horizontally and vertically integrated across company functional groups including Finance (Project Control), Engineering and Development
• Monitored and reported the critical path and tracked overall schedule performance
• Executed critical path analysis and schedule risk analysis
• Worked with the project teams to develop solutions for mitigating schedule risk and achieving project goals and objectives
• Assisted in preparation of initial set up, weekly and monthly schedule reviews including summary overview, critical path, and variance reports
• Implemented project management techniques to gauge progress and identify schedule variance to facilitate focus and intervention on critical areas
• Provided program management schedule services to manage the overall technical integration of all Marketplace systems and XOC
• Maintained EIDM baseline project schedule for all work performed including new development projects, maintenance releases, software fixes, data clean-ups and normal operations
• Logically linked all activities to reflect the flow of work
• Evaluated changes to the activity workflow and sequencing for impact on interface points
• Conducted Total float analysis to enable early warning of criticality
• Ensured there is no excessive positive total float on scheduled activities
• Presented potential impacts on the schedule to the Team and explore workarounds, mitigations and contingency plans. Discussed potential solutions with the CMS Project Manager
• Linked Project risks from the Project Risk Register to the schedule, by mapping the risk ID number in a custom text field in the schedule file
• Identified minimum and maximum durations, percentage likelihood of occurrence and alternative branching sequences for identified potential critical areas of work by coordinating with Control Account Managers, as required by the CMS Project Manager, typically at inception and at significant decision points or risk periods
• Incorporated changes to deliverables (such as Change Requests, Software fixes, Data Clean-ups, Data Requests), or to the scope of work, when the change to the schedule had an impact on the Integrated Master Schedule (IMS)
• Maintained a log of significant changes to specific elements within the schedule including:
• Changes that materially changed the intent or deliverable of an activity
• Changes in logic flow or sequencing
• Changes to Resources applied to an activity if a change to the level/rate of resource was made affecting cost or schedule of the activity
• Performed routine analysis of individual schedules identifying key dependencies, gaps, and risks while supporting CMS with Integrated Master Schedule process
• Established a process to coordinate, analyze, collaborate, and communicate with CMS Marketplace IT PMO
• Coordinated activities, analyzed, and assisted in coordination of the Integrated Master Schedule with the CMS Marketplace IT PMO
• Developed metrics to monitor and analyze Operations and Performance
• Conducted Portfolio performance reviews using Project Timeline views, Executive Dashboards, Variance Analysis and forecasting
• Assessed downstream impacts through cross project dependencies (external predecessors and successors) established in the schedules
• Customized schedules by leveraging custom Fields, Views, Tables, Filters & Groups
• Leveraged the use of Macros and other custom tools such as Confidential Schedule Pro, SSI Tools etc. to conduct health checks on various schedules
• Validated Schedule Integrity by resolving Negative Slack, conducting Critical Path Analysis (CPA) and Schedule Health Assessments
• Conducted Schedule Risk Analysis using Monte Carlo “What if” Scenarios and PERT
• Performed Schedule Change Management by comparing project schedules across the 4 weeks of a month
• Mentored various internal and external schedulers on Scheduling Best Practices

PROGRAM MANAGER

Confidential, Arlington, VA

Responsibilities:

• Managed the development and execution of independent testing of system solutions to ensure that requirements have been met and any resulting Automated Information System (AIS), COTS, or infrastructure change/upgrade relating to the AIS does not adversely affect the production environment.
• Ensured detailed testing engagement plans, schedules, test cases and scripts were developed for the testing of AIS releases
• Monitored all system test activities and life cycle events
• Conducted functional testing and other testing strategies necessitated by the application and infrastructure context;
• Participated in project-related reviews in accordance with the SDLC Methodology.

Confidential, Chantilly, VA

Responsibilities:

• Managed a program consisting of twelve (12) IT projects (Application Development, SharePoint 2010, IV&V, O&M) and provided assistance with Program Management Service, Business