Assistant Director, Reporting & Analytics
- Designed and evolved the target architecture for Transaction API/Jira data across MongoDB, Cosmos DB, Fabric, and Databricks, establishing the team's direction for event capture, hydration, and BI consumption.
- Built a canonical event-envelope model for MongoDB/Cosmos DB ingestion, replacing fragmented endpoint-specific schemas with a single reusable ingestion contract.
- Designed a Bronze+ schema-governance framework, gating new fields before promotion to Silver/Gold and preventing uncontrolled schema drift into Power BI semantic models.
- Automated semantic model updates via XMLA/TOM, syncing approved fields into Power BI models while preserving existing DAX measures and Direct Lake behavior, eliminating manual model maintenance.
- Designed and built the JSM Field Catalog, a Python-based metadata discovery platform integrating Jira APIs to support schema analysis and dashboard development while reducing manual field-mapping effort.
- Built a Fabric pipeline observability portal using Azure and Fabric REST APIs, identifying a roughly two-hour pipeline bottleneck caused by full-refresh Jira pulls instead of incremental loads.