Aug 2024
Data & Analytics Specialist
Researchyar — BI Consultancy · Remote
- Designed two production data warehouses: Kimball star-schema marts with a Data Vault 2.0 raw vault for auditability.
- Built 8 enterprise Power BI reports on SSAS Tabular with DAX time intelligence and dynamic row-level security.
- Piloted Microsoft Fabric: migrated a legacy SSIS pipeline to Fabric Pipelines with Lakehouse ingestion via Dataflow Gen2.
- Developed an RFM segmentation model (Python + SQL) on 1.5M+ customers, contributing to a ~8% churn reduction.
- Cut report query runtime by ~60% through T-SQL tuning and covering indexes.