Melvin Gibson
Atlanta, GA · Enterprise Strategy & Innovation

MelvinGibson.

Enterprise Innovation Analyst · CCI Systems

R&D strategy analyst in utilities and energy technology. I support the investment decisions that set where R&D funding goes across a global portfolio, lead the enterprise initiatives it depends on, and build the data platform behind its reporting.

Collegiate tennis taught me to own the point and adjust under pressure. I work the same way — close enough to the numbers to explain every variance, close enough to leadership to connect it to the decision.

Pillar 01

Investment Strategy & Portfolio Governance

Deciding where R&D money goes — then proving what it bought.

$86.6M
R&D portfolio governed
100
projects · 10 PMs · 5 regions
2 wks → 3 days
gate review cycle time
  • Led the annual Project Investment Plan with Finance — an ROI, strategic-fit and risk scoring model that set which R&D initiatives were funded company-wide.
  • Built the reporting suite that measures funded projects against the criteria which justified them, closing the loop between decision and outcome.
  • Redesigned stage-gate and change control, cutting gate review from two weeks to three days and moving approval upkeep from the PMO to project managers.
Governance Reporting
Stage-Gate & Cost Plan Views
ⓘAll data shown is anonymised & fictional.Representative replicas of production dashboards. No proprietary data is displayed.
Rate model architecture
Build 02 · Rate Model
SPM Burden Rate Architecture
Labor cost structures built from scratch — incorporating productive hours, T&E, and all contributing cost factors — to tie $86.6M in portfolio financials directly back to the P&L.
BURDEN RATE ARCHITECTURE — ServiceNow SPM COST INPUTS Direct Labor Salary · Benefits · Payroll Tax Productive Hours Available hrs − PTO − overhead T&E / Indirect Costs Travel · Supplies · Overhead % R&D Cost Factors RATE CALCULATION Burden Rate = (Labor + Indirect) ÷ Productive Hours → Hourly Fully-Loaded Rate ServiceNow SPM CONFIG Rate Card by Role Engineer · PM · Analyst · Exec Time Tracking (Timecards) Hours logged × role rate Cost Plan Breakdown Planned vs. Actual by project OUTPUT — TIED BACK TO P&L R&D Labor Cost By project / by period Planned vs. Actuals Real-time variance view T&E Allocation Direct + overhead blended P&L Reconciliation SPM cost ↔ finance ledger Power BI Dashboards Raw cost inputs Calculated / output SPM configuration R&D factors
CLICK TO EXPAND
03
Cost Accounting · Actual vs. Standard Costing · Financial Analysis
Solving the Project Absorption Problem
We were pricing both planning and actuals off the same burden rate — and actuals never quite tied back to the P&L. I built an allocation method for actuals that divides real cost center spend by real hours, so it reconciles to the P&L every time.
Actual CostingCost AllocationP&L ReconciliationBusiness Case Development
Always Ties to P&LActuals ≠ Burden RateMonthly ReconciliationBuilt From Real Hours
Always
Reconciles to the P&L
$86.6M
Portfolio reconciled
One burden rate priced both planning and actuals — and actuals didn't tie to the P&L

The R&D portfolio used a single burden rate for everything: pricing projects during planning, and pricing those same projects again once hours were actually logged against them. That worked for planning, where an assumed rate is the only option before the work happens. But for actuals, it meant reported project cost was still just hours × an assumed rate — not a number tied to what the cost center actually spent. Every period, the actual cost rolling up from projects didn't reconcile to the cost center's real P&L spend, and there was no way to close that gap without constantly updating the rate itself, which broke every time there was a raise, RIF, or backfill.

Make actual cost always tie back to the P&L

Leadership needed project actuals that would reconcile to Finance's own P&L every period, not just approximate it. I already had what that required sitting in the data: what each cost center actually spent per period, and how many hours were submitted against projects from that cost center. The question was whether dividing those two real numbers — instead of applying the burden rate — would produce an actual cost that ties out by construction, every time.

Take the burden rate out of actuals entirely

I built an actual-cost allocation model that replaces the burden rate on the actuals side only: each period, divide the cost center's real P&L spend by the real project hours submitted against it, then allocate that number across every project in proportion to the hours it pulled from that cost center. Because both inputs come directly from the P&L and the submitted hours, the result reconciles to the cost center's real spend by definition — there's no assumption left to drift. I ran the calculation on a monthly cycle so a mid-year raise or RIF shows up immediately instead of smoothing across the year, and defined the hours denominator as project hours only — so the cost of PTO, training and admin time is absorbed into the rate charged to project work, which is what lets project cost alone tie to the P&L with no reconciling items. The burden rate still prices planning, where no actual spend exists yet to divide — but actuals now run entirely on this method.

Always
Ties to the P&L
$0
Burden rate dependency in actuals
Monthly
Reconciliation cycle
$86.6M
Portfolio reconciled to real P&L
  • Actual project cost now reconciles dollar-for-dollar to each cost center's real P&L spend, by construction — not an approximation from an assumed rate
  • Removed the burden rate from actuals entirely; it now only prices forward-looking planning, where no real spend exists yet
  • The reconciliation gap that used to show up every period between reported project cost and the P&L is gone — the math can't drift because it's built from the same numbers as the P&L itself
  • Gave Finance and R&D leadership a shared, always-reconciled view of actual project cost, using the same actual-costing language Finance already works in
Actual-Cost Allocation Calculator

Drag the inputs to see the method itself — no rate card, just a cost center's real spend and real hours, divided and allocated to a project. Illustrative numbers, same math used in production.

$480,000
3,200 hrs
240 hrs
Effective Cost / Hour
$150/hr
Cost center spend ÷ total hours logged
This Project's Actual Cost
$36,000
Effective cost/hour × project hours
Pillar 02

Enterprise Platform & Process Implementation

Replacing the system of record, and getting an organisation to actually use it.

$250K
saved annually, from go-live
95%
adoption across 1,000+ users
5 months
assessment to go-live
  • Identified a $500K/yr legacy platform for replacement, built the benchmarking business case, and secured approval from the COO and VP of R&D.
  • Drove the ServiceNow SPM implementation end to end — rate model, business rules, approval workflow, stage-gate lifecycle — inside a non-negotiable five-month window.
  • Built the onboarding programme by role rather than by feature for 1,000+ users, and stayed sole platform administrator after go-live.
“He doesn't wait to be told what to do, he identifies what needs to be done and takes action. That kind of initiative is rare and incredibly valuable in a fast-paced environment.”
Eric Ayala · Director of Program Management
Before & After
What Actually Changed
Before - Planview Era After - ServiceNow SPM + Fabric
Platform Cost$500K per year with minimal return on investment$250K saved annually from day one of go-live
User AdoptionLow adoption — most users had stopped logging in entirely95% timecard adoption across 1,000+ R&D users
Financial ReportingManual reconciliation across multiple sources, taking up to 2 days per cycleInstant. Automated pipelines deliver always-current data
Data AccessSiloed inside the platform — only licensed users could see anything800+ stakeholders with real-time access via Fabric Lakehouse
Portfolio VisibilityNo reliable source of truth, data integrity constantly questionedSingle governed source tied directly back to the P&L
Resource PlanningNo visibility into utilization, overallocation, or capacity gapsReal-time capacity planning surfaced automatically
Executive DecisionsFunding decisions made on stale, manually compiled informationLive portfolio intelligence driving every executive review cycle
Pillar 03

Data Engineering & Executive Reporting

Building the platform the portfolio’s reporting runs on.

800+
stakeholders served
$100M+
annual cost actuals ingested
2 days → 0
manual reporting cycle
  • Architected the R&D data platform from scratch — a Fabric medallion lakehouse over 15+ ServiceNow tables via REST API and PySpark, retiring a two-day manual reporting cycle.
  • Engineered a SAP integration ingesting $100M+ in annual cost actuals, then built the company’s first project-level cost forecasting model.
  • Owned the Power BI suite for 800+ stakeholders across portfolio health, capacity and project financials, with automated SQL validation behind it.
Build · Reporting
Executive Reporting Suite
ⓘAll data shown is anonymised & fictional.Representative replicas of production dashboards. No proprietary data is displayed.
Fabric lakehouse pipeline architecture
02
Microsoft Fabric · Data Architecture · Power BI · Lakehouse
Taking SPM Data Beyond the Platform
Leadership asked for better reporting. I came back with a full data architecture proposal that gave the entire organization access to live portfolio intelligence.
Microsoft FabricLakehouseREST APIPower BI
15+ Source Tables800+ Stakeholders2-Day Cycle RemovedReal-Time Visibility
800+
Users reached
Instant
Was 2 days
The right people still could not see the data

The platform was live and generating reliable data — but a large portion of the organization had no licenses, including finance and senior executives. They were still manually reconciling portfolio data from multiple sources, a process that took up to 2 days and carried consistent risk of error. Funding decisions were being made on information that was already outdated the moment it was compiled.

Turn a reporting request into a governed architecture

When leadership asked for better reporting access, I proposed something bigger: rebuilding the full enterprise data model in Microsoft Fabric rather than layering exports on top of flat files. The goal was a governed, always-current source of truth that anyone in the organization could access — no platform license required.

Initial load, delta pulls, governed access

I architected the Lakehouse starting with a full API load to establish the baseline, followed by automated delta pulls that only retrieve updated fields on each run — preventing large repeated requests from impacting the source system. Once curated, the data became accessible org-wide. I then built 10+ Power BI dashboards connecting directly to the Lakehouse, with no manual refresh required.

2 days
Reporting cycle eliminated
800+
Users now have access
10+
Dashboards live
$86.6M
Portfolio made visible
  • Manual reconciliation eliminated entirely — 2 days of work reduced to instant
  • Finance and executives gained real-time portfolio visibility for the first time
  • Funding decisions now backed by a governed, always-current single source of truth tied to the P&L
  • Executive reporting cycles replaced with continuous live visibility into $86.6M in spend
  • Leadership described the portfolio visibility as transformational
Track Record

Where this was built

Sept 2026 – Present
Enterprise Innovation Analyst
CCI Systems
Telecommunications and digital infrastructure engineering services.
  • Own enterprise innovation intake, opportunity assessment, prioritisation and governance across all business units, reporting to the VP, Head of Innovation & Emerging Technologies.
  • Coordinate enterprise proof-of-concept initiatives from intake through value realisation, tracking KPIs, adoption and innovation portfolio performance.
  • Develop executive-ready business cases, ROI analyses and dashboards that shape enterprise innovation priorities.
Jan 2025 – Aug 2026
Senior Analyst, R&D Strategy Office
Landis+Gyr
Global smart metering and grid intelligence leader serving 800+ utility customers across 30+ countries.
  • Supported ownership of an $86.6M R&D investment portfolio spanning smart metering hardware and grid software — 100 projects and 10 project managers across Japan, China, India, Europe and the Americas.
  • Led the annual Project Investment Plan with Finance, applying the ROI, strategic-fit and risk scoring model that set company-wide R&D funding.
  • Identified the $500K/yr legacy PPM platform for replacement and drove the ServiceNow SPM implementation that replaced it — $250K annual savings, 95% adoption, 1,000+ users, five months.
Aug 2023 – Jan 2025
Project Manager, Emerge Head-End Platform
Landis+Gyr
AMI and meter-to-cash modernisation for utility customers.
  • Managed six concurrent AMI and meter-to-cash projects, coordinating 200+ contributors and $7M+ in programme funding.
  • Cut schedule variance 30% across six workstreams with Power BI KPI scorecards.
  • Defined functional requirements and mapped data flows across SCADA, MDM, Outage Management and Analytics platforms.
Strategy & Investment Planning

Investment Prioritisation · Portfolio Analysis · Scenario Planning · Benchmarking · Demand Intake · Stage-Gate Lifecycle · Resource & Capacity Planning · Roadmapping

Financial Analysis & Modeling

Planned vs. Actuals · Budget Variance · Cost Forecasting · P&L Reconciliation · Rate Models & Burden Rates · ROI & Cost-Benefit · Business Case Development

Platforms & Systems

ServiceNow SPM · SAP · Apliqo · Planview · Azure DevOps · Power Automate · Microsoft 365

Data Engineering & BI

Microsoft Fabric · Medallion Lakehouse · PySpark · SQL · Python · REST API · Power BI (DAX, Semantic Models) · KPI Framework Design

Utilities & Energy Domain

Smart Metering · AMI · Grid Edge Intelligence · Head-End Systems · MDM · Meter-to-Cash · SCADA · Outage Management · Hardware NPI

Education & Certifications
MBA, Project Management — Louisiana State UniversityFeb 2024
BS Biology, Research/Informatics — Fort Valley State UniversityMay 2022
Six Sigma Green BeltCertified
AWS Cloud FoundationsCertified
Get In Touch

Open to the
right conversation.

I’m at CCI Systems, owning enterprise innovation intake and governance. I’m not actively looking — but I’m always open to a conversation about investment strategy, portfolio governance, or the data platforms that hold them together.

Email
gibsonm816@gmail.com
Phone
(404) 437-8465
Location
Atlanta, GA
Download Resume

The best way to reach me is through LinkedIn. Connect with me there, send a message, or check out my full profile to learn more about my background and experience.

Connect on LinkedIn