Lease Cost Dashboard.

Databank managed more than 20 data centers, but lease, tax, and insurance details were scattered across multiple Salesforce objects. Finance spent hours assembling numbers and still had no single view of true facility costs, renewal timelines, or outlier premiums. COGS forecasting and negotiation strategy were reactive by default. You cannot negotiate a renewal you did not see coming.

I built the refresh schedule and the SOP as part of the deliverable, not as follow-up. Analysis work that depends on the analyst dies when they leave. A three-layer workbook (raw data, normalized cost model, dashboard) meant Finance could extend the model without me, which is why it was still the source of truth after handoff rather than a report nobody could reproduce.

• Audited every real-estate-related object and field in Salesforce, including custom facility-cost objects and legacy attachments.
• Built a consolidated Salesforce report exporting rent, CAM, taxes, insurance, renewal clauses, and square footage on a monthly refresh.
• Three-layer Excel model: raw data, normalized cost model, and a pivot dashboard with slicers for region, facility, and lease end date.
• Ran two training sessions with Finance and Ops and documented a one-page SOP so the team could refresh and extend it without me.

~$400K

annualized savings from two leases and one insurance policy flagged for renegotiation, about 8% of facility OPEX

5 hrs/week → <30 min/month

manual data wrangling

1 week

to become Finance's single source of truth

12 months

of renewal lead time for leadership planning