Asset Management Platform
- Built a full asset management system that ingests behind- and front-of-the-meter power data into Snowflake and carries it straight through to reporting, managing 300+ projects
- Gives the team insight into how ESA contracts and assets are performing, as an internal tool hosted on Azure with a JavaScript front end
- Includes performance forecasting and anomaly detection, supporting proactive maintenance and capital planning decisions
SnowflakeAzureJavaScriptForecastingAnomaly Detection
Unplanned Maintenance Analysis
- Designed the analysis pipeline, joining a maintenance work-order tracker with Snowflake revenue and site-mapping data to measure how unplanned maintenance affects site-level profitability
- Modeled each site's failures as a Poisson process to turn failure history into a forward-looking expected value at risk
- Built a size-independent reliability metric (work orders per generator) and paired it with site value to separate genuinely unreliable sites from merely large ones
- Designed a rule-based triage framework combining financial, recurrence, and risk signals into review, protect, and monitor tiers
- Tested seasonal cost assumptions with Kruskal-Wallis and Mann-Whitney U tests, traced repeat failures to their downstream escalation, and documented assumptions, caveats, and data gaps in a written report
PythonSQLSnowflakeRisk ModelingStatistics
Billing Data Review Workflow
Generate Capital
In progress- Adding a feature to an internal billing tool that catches faulty performance data and routes it for manual review
- Building the review UI and designing the system underneath that routes flagged data through the workflow
- Setting security permissions for the feature and working across teams to meet stakeholder needs
System DesignUI DevelopmentAccess ControlData Quality
DSCR Data Pipeline in dbt
- Moved the Debt Service Coverage Ratio (DSCR) logic out of a Power BI report and down to the dbt level, automating a calculation stakeholders previously did by hand
- Used SQL to merge multiple data sources and compute DSCR in the warehouse rather than in Power BI
- Pushing the logic upstream improved efficiency and accuracy and made the resulting tables reusable by other areas of the company
- Left a leaner, more efficient dashboard with fewer opportunities to fail, since the merging and calculation logic no longer lives in Power BI
dbtSQLData EngineeringPower BI
AI Report Summarization System
- NLP pipeline integrating Azure Cognitive Services and GPT-4 to summarize 100+ page transfer pricing reports, cutting analyst preparation time by ~98% (4 hours → ~5 minutes)
PythonLLMNLPAzure
Invoice Reconciliation Automation
- Applied fuzzy matching to reconcile invoice line items against project estimates and generate automated PDF outputs, reducing processing time from ~5 hours to under 1 minute
PythonFuzzy MatchingAutomation
Renewable Energy Transfer Pricing Model
- Built a simulation model to optimize intercompany renewable energy transfer pricing, maximizing profit through carbon credit monetization
PythonSimulation
Personnel Operations Dashboard
- Power BI dashboard built for a professional association client to track personnel metrics, headcount, and operational KPIs for leadership decision-making
Power BISQLPython