Ken Cromb
Senior Pmo Analyst @Baker McKenzie
Signup · Get unlimited contacts
WORK HISTORY
Senior Pmo Analyst @Baker McKenzie
London, GB
Developed key data-driven PMO reports in Power BI that provide fast and accurate tracking and insight into the rollout of 50+ PBS21 Professional Business Services projects across 60+ global offices.As PMO Project Online administrator, led migration of plans from Project Professional into Project Online, managing permissions, setting up Enterprise custom fields, milestone definition and Project health RAG indicators.Set up automated import of projects into Power BI from multiple MS Project Online PWA sites. Key milestone data is extracted from 700+-task plans to be shown in Gantt charts and dynamic project plan views. Task-level milestone status is filterable by Business Area, Project and Project Manager across dynamic time periods.Developed Risk & Issue search and reporting tools to show all R&I, highlighting high-risk and overdue items. Set up of dashboard subscriptions to push key pages to PMO senior management and Project managers, resulting in a 90% drop in overdue items in the Financial year.Assistance with preparation of the PMO monthly report with a view to make it more data-informed and automated. Documented Process mapping to reduce report turnaround.
EDUCATION
West Thames College, London
BEC/TEC National Certificate
SKILLS
ABOUT KEN CROMB
I specialise in creating compelling and insightful reports and dashboards that help drive project performance improvements. I enjoy troubleshooting and interrogating processes and working with large, complex data sets to identify performance trends and automation opportunities. PMO Assisting Project Management Teams with definition and delivery of effective scorecards and performance measurement, helping to drive successful execution of strategic objectives and to improve visibility of performance shortfalls. Creation of Risk & Issue search and reporting tools to highlight high-risk and overdue items.Power BI 7 years of commercial experience as a Power BI developer, working in close liaison with key stakeholders to understand their reporting deliverables. Design and development of innovative reports and dashboards that create an unrivalled customer experience. Creative use of bookmarks, buttons, field parameters, What If scenario analysis & drillthroughs for intuitive navigation and dynamic presentations. Publishing Reports and Apps to Power BI on the Web, scheduling data refreshes, controlling security access via Row Level Security (RLS) and creation of customised report views for the Power BI Mobile App. Data shaping using Power Query and DAX to Extract, Transform and Load (ETL) information from Excel, SSMS, ServiceNow, Salesforce, SharePoint, the Web and Azure Data Warehouse. Power Automate/Power Query Automation of Outlook file attachment handling and Power BI report refreshes. Setup of customer-triggered ad-hoc report refreshes via Power Automate. Extensive Power Query & M-Code experience to help improve report loading and performance.Advanced Excel skills Experienced in the use of a wide range of Excel functions and creation of Pivot tables, dashboards, Advanced filtering, Combo charting, conditional formatting, data validation.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.