Summary:

• A mix of delivery and supporting PMO
• Data Analytics reporting (excel, vba)
• Project plans- set up and maintenance
• Managing project change requests

Must have:

• Advanced MS Project
• Advanced Excel (Pivot, Formulas)
• Excel VBA Macros – Automation
• Data Analytics
• Executive Reporting
• Attention to Details
• JIRA, Confluence Knowledge
• Project Experience Required

Nice To Have:

• PMP

Job Overview:

• Integrated Project Plan:
o Structure & Hierarchy – Setup & Maintenance
o MPP Template Ownership
• Columns, Definitions, Drop Down values
• New MPP template change roll-out:
o Baseline Plan Ownership
• Baseline plan updates to align to approved PCRs:
o IPP Data Quality Management
• Automation:
o Excel & MS Project – Macro Build & Maintenance
o Excel – Macro Templates Maintenance
• Training & Support:
o Initial MPP Roll-out Trainings & Communication
o MPP Template Change Roll-out, Trainings & Communication
o Continuous support to Delivery Team on MPP & JIRA
• JIRA:
o JIRA RAID – Setup & Maintenance
• Project Change Requests:
o PCR Analysis
• Impact to Overall Schedule
• Impact to Inter-dependencies:
o Response Plan Document Updates
• Response Document Update
• Gantt Excel Document Update
• Change Management Log Update:
o Ensure the PCR updates are completed by Delivery Team in the live MPP
• Data Analytics & Reporting:
o Status/ ESC Reporting Support
o Data Quality Reports & Resolution
o Ad-hoc Reporting/ Data-Analysis Requests
• Project Executives
• Delivery Team

Key Skills/Requirements:

• Advanced MS Project
• Advanced Excel (Pivot, Formulas)
• Excel VBA Macros – Automation
• Data Analytics
• Executive Reporting
• Attention to Details
• JIRA, Confluence Knowledge
• Project Experience Required
• PMP Desired