About the role
Job Description – PMO Operations Lead
Location: Bangalore
Company: Mphasis
Role Overview
We are looking for a highly organized, analytical, and detail-oriented PMO Operations Lead to manage day-to-day operational activities across multiple delivery portfolios. The ideal candidate will be responsible for operational reporting, Power BI dashboards, financial tracking, business metrics, data analysis, automation, executive communications, and stakeholder coordination.
The role will work closely with Delivery, Finance, Accounts Receivable, Accounts Payable, HR, PMO, Delivery Operations, Customer Relationship Managers, and Leadership teams to ensure accurate reporting, effective operational governance, and timely execution of business activities.
Key Responsibilities
PMO Operations
Own and manage PMO operational activities across multiple projects, accounts, and business units.
Establish standardized operational processes, reporting templates, dashboards, and governance artifacts.
Drive timely execution of recurring operational activities and ensure adherence to organizational timelines.
Maintain operational trackers for revenue, resources, demand, onboarding, billing, renewals, and project performance.
Identify opportunities to improve PMO processes through automation, standardization, and data-driven reporting.
Support leadership in identifying operational risks, gaps, dependencies, and improvement opportunities.
Business & Operational Metrics
Prepare, analyze, and publish Delivery Operations Metrics, Business KPIs, and Operations Dashboards for leadership review.
Track key business metrics including Revenue and revenue forecast, Utilization, Resource allocation, Open positions and demand, Hiring and onboarding status, Resource movements, Billing and invoicing status, SoW renewals and extensions, PO consumption and balance, and Operational performance.
Conduct weekly operational reviews / Co-Hort Reviews covering revenue performance, hiring status, open demand, staffing updates, financial metrics, risks, and action items.
Generate MIS reports, management dashboards, trend analysis, and executive insights to support business decision-making.
Perform data validation and reconciliation across multiple operational and financial data sources.
Power BI & Data Analytics
Design, develop, maintain, and publish Power BI reports and interactive dashboards for PMO, Delivery, Finance, and Leadership teams.
Build executive dashboards covering Revenue, Margin, Utilization, Demand, Staffing, Billing, PO Balance, SoW Renewals, and Delivery Operations.
Develop data models and establish relationships between multiple data sources to provide reliable business insights.
Create and maintain DAX measures, calculated columns, KPIs, and business calculations.
Use Power Query / M for data extraction, transformation, cleansing, and preparation.
Connect Power BI with Excel, SQL databases, SharePoint, Jira, and other business data sources.
Implement appropriate data refresh mechanisms and ensure dashboard data accuracy and consistency.
Translate business requirements into meaningful visualizations, analytical reports, and leadership dashboards.
Continuously enhance dashboards based on changing business and leadership requirements.
Financial Operations
Coordinate end-to-end customer invoicing activities in collaboration with Finance and Delivery teams to ensure timely billing.
Track and manage Statement of Work (SoW) renewals and extensions, ensuring renewals are initiated and completed before contract expiry.
Perform periodic Purchase Order (PO) balance reviews, monitor consumption, identify potential risks, and coordinate extension or renewal activities.
Support revenue forecasting, billing reconciliation, margin analysis, and financial reporting.
Track invoicing, collections, revenue realization, and financial action items.
Coordinate with Finance, Revenue, and Accounts Receivable teams to resolve operational and billing discrepancies.
Maintain accurate financial and operational data for leadership reporting.
Reporting, Automation & Coding
Develop and maintain automated reports, trackers, dashboards, and operational workflows to reduce manual effort.
Use SQL to extract, query, validate, reconcile, and analyze operational and financial data.
Develop automation using VBA, Python, Power Automate, or similar scripting/automation technologies to improve reporting efficiency.
Automate recurring PMO activities such as data consolidation, report generation, tracker updates, notifications, and data validation.
Use Power Query and DAX to automate data transformation and business calculations within Power BI.
Identify repetitive manual processes and implement scalable automation solutions.
Troubleshoot data and reporting issues and work with relevant technical teams to resolve them.
Maintain documentation for reports, data sources, automation scripts, dashboards, and reporting processes.
Communication & Executive Reporting
Drive internal PMO and Delivery communications, ensuring timely dissemination of business updates, operational announcements, and leadership communications.
Prepare executive presentations, PowerPoint decks, Power BI dashboards, business summaries, leadership reports, QBR/MBR decks, and operational review presentations.
Convert complex operational and financial data into concise executive-level insights.
Maintain a centralized repository of reports, templates, operational documents, dashboards, and presentation assets.
Ensure accuracy, consistency, and timely availability of all reports and communications.
Stakeholder Management
Collaborate effectively with Delivery Managers, Delivery Heads, Finance, HR, PMO Office, Customer Relationship Managers, Revenue Teams, Invoicing Teams, and Leadership teams.
Serve as a primary coordination point for operational activities across cross-functional teams.
Facilitate regular operational review meetings, track action items, and ensure timely follow-up and closure.
Coordinate with stakeholders to collect, validate, and consolidate business information.
Build strong working relationships with internal stakeholders to enable smooth execution of business operations.
Proactively highlight risks, dependencies, delays, and business-impacting issues to leadership.
Required Skills
6–10 years of experience in PMO Operations, Business Operations, Program Operations, Delivery Operations, or Project Coordination.
Strong experience in PMO reporting, business metrics, financial tracking, operational dashboards, and executive reporting.
Strong hands-on experience in Power BI report and dashboard development.
Good knowledge of DAX, Power Query/M, data modeling, and dashboard development.
Advanced Microsoft Excel skills including Pivot Tables, Power Query, XLOOKUP/VLOOKUP, advanced formulas, data analysis, and dashboard creation.
Advanced Microsoft PowerPoint skills with the ability to create executive-level presentations and business review decks.
Working knowledge of SQL for data extraction, analysis, validation, and reconciliation.
Hands-on experience with coding/automation, preferably using VBA, Python, Power Automate, or similar technologies.
Experience with Jira, Confluence, MS Project, SharePoint, or similar project management and collaboration tools.
Strong understanding of Revenue, Invoicing, P&L, Margin, PO, SoW, Renewals, Resource Management, and Delivery Operations.
Excellent analytical, communication, documentation, and stakeholder management skills.
Strong organizational skills with the ability to manage multiple priorities in a fast-paced environment.
Preferred Experience
Experience working in IT Services, Consulting, or Global Delivery organizations.
Experience developing Power BI dashboards for senior leadership and business operations.
Exposure to revenue reporting, invoicing, collections, P&L, margin analysis, resource management, SoW lifecycle management, PO tracking, and renewals.
Experience in reporting automation and process improvement.
Experience integrating data from multiple sources such as Excel, SQL, Jira, SharePoint, and other enterprise systems.
Experience supporting senior leadership with QBR/MBR, operational reviews, business reporting, and data-driven insights.
Knowledge of Agile/Scrum project environments is an added advantage.
Key Competencies
PMO & Business Operations
Power BI Reporting & Dashboard Development
Data Analytics & Visualization
SQL & Data Validation
DAX & Power Query
Excel & PowerPoint
Reporting Automation & Coding
Revenue & Financial Operations
Invoicing & Collections Coordination
P&L & Margin Tracking
SoW & Renewal Management
PO Tracking
Resource & Demand Management
Executive Reporting
Stakeholder Management
Process Improvement & Automation