Delivering
Results.
Managing
Complexity.

Federal consulting firms like Apex manage dozens of government contracts simultaneously. Each contract has its own budget, timeline, team, deliverables, and risks. Without a centralized view, Program Directors are flying blind: they rely on weekly emails, spreadsheets from different PMs, and status meetings that take hours but produce little clarity.

In this scenario, Apex Consulting Group was awarded a 8 million federal contract with the U.S. Department of Health and Human Services to modernize digital programs across three agencies. As Program Director, I was responsible for six simultaneous workstreams, 72 team members, and reporting directly to the executive sponsor and agency stakeholders. The question was simple: how do you keep six projects, three agencies, and 72 people aligned without losing visibility on what matters?

The Approach

The answer was a PMO Portfolio Dashboard: a single source of truth that gives the Program Director, project managers, and executive sponsors an instant read on the health of the entire portfolio. The dashboard was designed around four core PM disciplines:

• RAG Status Reporting (Red / Amber / Green) Every project gets a traffic light status updated weekly. Green means on track. Amber means there is a risk that needs attention. Red means there is an active problem affecting schedule or budget. This is the language every executive speaks: no jargon, no long reports, just a clear signal.
• Budget vs Actual Tracking Each workstream has a planned budget and a real spend number. The dashboard compares them side by side so the Program Director can immediately see if a project is burning through money faster than expected, before it becomes a crisis. In this portfolio, the EPA Environmental Data Migration was flagged early because spend was high relative to completion percentage, signaling an efficiency problem.
• Milestone Tracking Milestones are the heartbeat of a project. Missing one rarely hurts you alone: it usually delays the next three. The dashboard tracks every major milestone across all six projects in one view, color coded by status. When the HHS Security Audit milestone turned amber, it triggered an immediate escalation before the deadline was missed.
• Risk Register Every project has risks. The difference between a good PM and a great one is whether those risks are identified early, documented clearly, and actively managed. The risk register tracks seven active risks across severity, probability, impact, mitigation action, and current status. It is reviewed in every weekly status meeting.

Tools and Methodology

• Framework: PMI PMBOK, Hybrid Agile-Waterfall delivery model
• Reporting cadence: Weekly status reports, monthly executive briefings, quarterly contract reviews
• Data visualization: Custom HTML dashboard with Chart.js, accessible without Power BI licenses
• Governance: RACI matrix at kickoff, change control process documented, stakeholder communication plan active across all six workstreams

Key Outcomes

• EPA Migration risk identified 6 weeks early: the dashboard flagged a spend-to-completion mismatch before it became a schedule breach. A corrective action plan was implemented within one week.
• HHS Cybersecurity audit risk escalated proactively: milestone tracking caught a vendor availability issue 3 weeks before the deadline. A backup vendor was engaged without missing the contract milestone.
• Executive reporting time reduced by 4 hours per week: instead of compiling status from six separate PMs, the Program Director had a single dashboard updated in real time.
• 72 team members, 3 agencies, zero missed deliverables through the end of Q2 2025.

What This Demonstrates

Strong program management is not just about keeping things organized. It is about building systems that give leadership clarity, surface problems early, and keep teams accountable without micromanaging. As a Program Director, your job is to make complexity invisible to the people above you and solvable for the people below you. This dashboard is the tool that makes that possible.

The U.S. housing market in the first half of 2026 will not be decided by headlines. It will be decided by affordability and timing.

This project focused on forecasting median U.S. home prices through June 2026 using 10 years of macroeconomic data. Rather than chasing a single outcome, three scenarios were modeled to understand ranges, probabilities, and decision windows.

Three Scenarios Modeled

• Optimistic: $440K — strong labor market, rate relief, and sustained demand
• Base Case: $402K — modest decline of approximately 1%, reflecting current affordability pressures
• Pessimistic: $388K — continued rate pressure and weakening buyer sentiment

Key Findings

• The most likely outcome clusters around a modest decline of approximately 1%
• The spread between scenarios is wide, roughly a $50K range
• The April to May 2026 window appears critical as affordability pressure meets policy lag

Data Sources and Methodology

The model incorporates multiple macro signals from Federal Reserve, BLS, and BEA data to capture how rates, inflation, and income growth interact with housing demand. What makes this analysis useful is not the model itself but the structure: scenario-based thinking instead of single forecasts, conservative assumptions, and a focus on decision timing rather than predictions.

This project is intended for educational purposes only and should not be interpreted as financial advice or a recommendation to buy, sell, or hold any security. The analysis is based on publicly available data and personal interpretation. I currently hold shares in CHWY, the company used in this case study.

This project was developed to simplify the complexity of options market analysis and make it accessible to a wider audience. It uses Gamma Exposure as the core metric to understand how much pressure is building in a stock, whether from call buyers, put sellers, or both.

All data is pulled directly from Thinkorswim in real time with zero delay. The entire analysis was built in Excel using formulas, offering a level of flexibility and transparency often hidden behind paid platforms that charge up to one hundred dollars monthly for similar tools.

Why CHWY?

• Balance sheet shows manageable debt levels
• Free cash flow has remained consistent and is improving
• Revenue growth has steadily increased since 2020
• Social sentiment indicates long-term positive expectations

Dashboard Components

• Net Exposure by Strike: shows where options traders are most concentrated by strike price
• Net Gamma by Expiration: shows which expiration dates are driving the most market sensitivity
• Cleaned Data Table: organizes call and put data by strike including volume, open interest, and gamma contribution
• Raw Data Feed: live export from Thinkorswim processed into the visuals above

Tools and Skills Used

• Market research using real-time data feeds from Thinkorswim
• Gamma Exposure modeling for options strategy evaluation
• Excel-based financial dashboards with automated formulas
• Integration of technical analysis with fundamental research

Most organizations build one budget and hope it holds. But what happens when a major grant falls through? What if donations come in higher than expected? What if you need to hire two people in Q3?

Organizations that plan with a single number are not planning. They are guessing. This project was built to solve that problem.

The Approach

I designed an interactive budget planning model that gives decision-makers three scenarios to work with at the same time: a Best Case, a Base Case, and a Worst Case. The goal was simple. Help leadership understand the financial range they are operating in, not just a single number on a spreadsheet.

The model is built around four key PM deliverables:

• Baseline Review: Before planning the future, you have to understand the present. The first section shows actual income and expenses for January through June, broken down by funding source (grants, donations, fundraising) and expense category (operations, programs, admin). This is the project baseline, the starting point every PM needs before making decisions.
• Funding Forecast: This section models three possible funding outcomes for July through December. Best Case assumes strong grant renewals and a successful year-end campaign. Base Case reflects steady, realistic growth. Worst Case models what happens if two major grants are not renewed. Each scenario updates the chart instantly when selected. This is scenario planning, a core PM skill used to prepare for uncertainty instead of being surprised by it.
• Expense Forecast: Expenses are just as uncertain as income. This section models three spending outcomes: Conservative (freeze hiring, defer costs), Moderate (planned growth), and High Growth (new hires, facility upgrades). Understanding both sides of the budget is essential for scope and resource management, two areas every PM owns.
• Custom Scenario Explorer: Two sliders let the user adjust funding and expense assumptions in real time. As they move the sliders, the projected net position updates instantly: surplus, break-even, or deficit. This is the equivalent of a risk simulation. Instead of reacting to a financial problem after it happens, leadership can model it in advance and make a decision before it becomes a crisis.

Why This Matters for Project Management

Every PM manages a budget. Whether it is a $500K IT project or a $48M federal contract, the skill is the same: understand your baseline, model your risks, communicate your projections clearly, and give leadership the information they need to make good decisions. This model demonstrates that skill in a visual, interactive format that any stakeholder can understand without opening Excel.

Key Outcomes

• Replaced static annual budget with a dynamic three-scenario planning model
• Enabled leadership to stress-test assumptions before committing to a financial strategy
• Reduced time spent on budget revision meetings by providing self-service scenario exploration
• Created a reusable framework applicable to any organization managing multiple funding streams

This dashboard was built for a real daycare client using Power BI, connected directly to their ProCare system. The main challenge was that the director had been manually tracking which parents dropped off their kids early or picked them up late. That process was taking too much time and causing delays in other responsibilities. On top of that, they were starting to miss fees that should have been charged, meaning money was being left on the table.

With this solution, everything became visual and automated. They can now instantly see how many kids arrived early or left late, which classrooms tend to have more of those cases, and what time parents are usually coming and going. The dashboard even calculates total fee charges by child.

Data Analytics and Automation

• Used Power BI to automate operational tracking and reduce manual workload
• Transformed raw check-in and check-out data into meaningful performance insights
• Created custom DAX measures to calculate fees based on arrival and pickup patterns
• Developed interactive visualizations to highlight trends by classroom and time of day
• Integrated real-time data from ProCare into a fully automated reporting workflow

Business Impact

• Identified gaps in revenue collection due to unmonitored late pickups and early drop-offs
• Improved decision-making through visual trend analysis and historical patterns
• Supported upselling strategies by providing clear evidence of extended care usage
• Reduced daily administrative burden on the daycare director by replacing manual logs
• Improved transparency and communication with parents using data-backed insights

Client Outcome

This dashboard gave the daycare full visibility and control over an area they had been struggling with. It turned a time-consuming process into something simple and automated. The result was more time for the staff, stronger family communication, and a clear path to recover and grow revenue with confidence.

Is it better to buy a home or rent and invest in the stock market? This interactive tool uses 63 years of real U.S. data to answer that question — not with a single opinion, but with your actual numbers.

What the Tool Does

• Select any purchase year from 1963 to 2026 and enter your actual purchase price
• Customize down payment, appreciation rate, property tax, and maintenance
• See 5 live KPIs: monthly payment, down payment, equity accumulated, all-in cost, and net gain
• Path A vs Path B: homeownership net wealth vs renting and investing the down payment in the S&P 500
• Real S&P 500 annual returns — including actual crash years like 2008 (-37%) and 2022 (-18%)
• Decade-by-decade comparison table showing which asset class won each era
• 63-year home price history with S&P 500 index overlay and decade filters

Key Findings

• U.S. home prices have appreciated 2,352% since 1963 — no decade showed a permanent decline
• S&P 500 outperformed real estate in 5 out of 7 decades on raw returns
• Real estate won the 1970s (inflation) and 2000s (dot-com crash + 2008)
• When leverage and rent savings are factored in, homeownership is highly competitive
• The break-even vs renting typically occurs between years 5 and 10