Pooja Thawani

Pooja Thawani

Senior Data Analyst
India
English
Full-time Work from Home

About Me

Senior Data Analyst and Business Intelligence Engineer with 3+ years of enterprise experience delivering end-to-end BI, SQL performance engineering, ETL development, and executive reporting in the US Mortgage industry. I…

Experience

Senior Data Analyst — Data Science & Analytics

Onity Group (US Mortgage Servicer & Originator) · Mumbai , Maharashtra , India
Mar 2023 - Present · 3 years 4 months

Designed and delivered the team's flagship Business Intelligence product — a real-time Power BI dashboard serving 250+ users, eliminating 15 daily manually produced reports and recovering the equivalent of approximately 40–50 FTEs of manual effort monthly across the sales organization. Implemented Dynamic Row-Level Security (Loan Officers through EVPs) using a Composite Model (DirectQuery for live operational data, Import Mode for reference tables); refactored the core data pipeline from 30+ minutes to under 2 minutes to enable near-real-time 15–20 minute dashboard refresh. Owned end-to-end development and daily production delivery of a multi-page SSRS PDF morning briefing distributed automatically to the CEO, EVPs, and SVPs — consolidating six to eight fragmented department reports into one authoritative executive scorecard covering pipeline, conversion rates, recapture metrics, headcount analytics, rolling 5-day trends, and six-month regression data. Led enterprise SQL Server performance optimization across a large portfolio of stored procedures and automated data pipelines, reducing overall SQL Server CPU utilization by approximately 40% through incremental loading architecture, data lake decoupling, and evidence-based job schedule re-design

Skills

Microsoft SQL Server T-SQL Stored Procedures CTEs Window Functions Execution Plan Analysis Clustered Indexes Columnstore Indexes Incremental Loading ETL Pipeline Design Data Staging Architecture Data Quality & Validation SQL Agent Job Management Root Cause Analysis Complex Joins Power BI DAX CALCULATE RANKX Time Intelligence RLS DAX Power Query M Language Semantic Modelling DirectQuery Composite Models Dynamic Row-Level Security Incremental Refresh SSRS KPI Development Reporting Automation Dashboard Engineering Microsoft Fabric Power BI Service SSMS Git SharePoint Microsoft Teams Excel Pivot Tables XLOOKUP INDEX-MATCH Encompass Velocify Oracle Python Requirements Gathering Cross-functional Collaboration Stakeholder Management Executive Reporting
Report this Profile?