Summary:

• A mix of delivery and supporting PMO
• Data Analytics reporting (excel, vba)
• Project plans- set up and maintenance, project schedules
• Managing project change requests
• Ensure project control procedures and policies within a program of related projects are executed.
• Assist in maintaining project schedules. Develop and maintain issue logs. Maintain project repositories of documents.
• Prepare documents for various recurring meetings including minutes, issue logs etc.
• Develop presentation documentation as required for project teams.
• Develop consolidate program status reports. We require a project coordinator whose primary focus will be on providing financial management and analytical support to project managers at the program level for a large (Tier 1) initiative.
• As part of this project team, prime responsibility will be to: Manage relationships and all activities with all required partners (business, TS Finance, program PMO, TS project teams, external partners) related to program one-time and on-going financials (prepare budget, forecasts and actuals).
• Utilize project management software for development and distribution of comprehensive set of monthly, weekly and ad hoc project financial reporting to a variety of program stakeholders (including templates for use by other project members).
• Work closely with TS Finance to provide necessary detailed financial data to support the forecasting and tracking of capitalization and amortization.
• Manage all financial status meetings for the program.
• Provide support for invoice processing.
• Manage process for all required updates to internal financial management tracking tools (e.g. EPM, Carpe Diem).
• Manage reporting and tracking for resource utilization.
• Exercise discretion in managing correspondence and information, escalating issues where appropriate.
• Act as central point of communication for core team members, management, business partners and other stakeholders on program, organization and platform issues.

Skills:

• MS Project knowledge to create and maintain project plans.
• MS Excel and PowerPoint knowledge to create and maintain documents .
• Knowledge and experience in maintaining a central repository of project plans, reports, competencies etc.

Job Overview:

• Integrated Project Plan:
o Structure & Hierarchy – Setup & Maintenance
o MPP Template Ownership
o Columns, Definitions, Drop Down values
o New MPP template change roll-out
o Baseline Plan Ownership
o 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
o Impact to Overall Schedule
o Impact to Inter-dependencies
o Response Plan Document Updates
o Response Document Update
o Gantt Excel Document Update
o 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
o Project Executives
o Delivery Team

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

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