I turn messy, multi-source data into decisions people can act on. Over 5+ years I've worked across healthcare, government, and manufacturing — building reconciliations, large-scale data integrations, and the dashboards that leadership actually reads. I hold an MS in Data Analytics and an MS in Statistics, and I care as much about why a number moves as about reporting that it did.
📍 Based in Chattanooga, TN · 📫 mngajjar27@gmail.com
Languages & Query: SQL · Python (pandas) · SAS BI & Dashboards: Power BI · Sigma · Advanced Excel (Power Query, VBA, PivotTables) . Tableau Data & Modeling: Star-schema modeling · ETL workflows · Snowflake · Relational databases . Microsoft Fabrics . End-to-End Data Lifecycle Workflow: Git/GitHub · Google Colab · Visual Studio
Healthcare Claims Analytics End-to-end claims & cost analytics on a synthetic star-schema dataset — SQL analysis plus a Python dashboard. Key finding: the top 5% of members drive 36% of total spend, and chronic conditions account for 83% of paid claims.
Public Safety Analytics Dashboard A multi-page SQL Server + Power BI operational dashboard covering crime, arrests, and jail operations. Key finding: ~88% average jail capacity utilization, with staffing gaps as the leading operational risk.
I'm open to Data Analyst, Business Intelligence, and Billing/Reporting Analyst roles.
- 📧 Email: mngajjar27@gmail.com
- 💼 LinkedIn: https://www.linkedin.com/in/mahek-gajjar/