Vidhya Raj

Data Analyst with close to 2 years of experience delivering BI and reporting solutions on Microsoft Fabric, SQL and Python for banking, telecom and semiconductor clients. Skilled in DAX, Star Schema modeling, Row-Level Security, Fabric Lakehouse with Medallion Architecture, Data Factory pipelines, PySpark notebooks and Airflow-orchestrated ELT. Cut report processing time from 20 hours to 30 minutes on ~3M records and delivered 30+ reports for executive decision-making.

Data Analyst at Pirllabs Private Limited (2025 – Present)

Banking MIS & Reporting | Power BI, SQL, MySQL, SQL Server, Oracle, DAX, Python, Airflow

• Cut report processing time from 20 hours to 30 minutes on ~3M records and MIS turnaround to ~10 minutes through SQL indexing, CTEs, window functions and stored procedures.
• Delivered 20+ MIS reports and 3 core management reports on Star schemas with reusable DAX measures, achieving 95% report accuracy.
• Presented KPI trends and insights to management, supporting data-driven decision-making.
• Built SQL and Python ELT pipelines (Oracle to MySQL and a data warehouse) with incremental loading and reconciliation checks, orchestrated with Apache Airflow DAGs.
• Designed data structures and pipeline architecture from client requirements, increasing reporting efficiency by 20%.
• Implemented static and dynamic Row-Level Security (RLS) and published to Power BI Service with an on-premises gateway and automated daily refresh.

Semiconductor Reporting Suite (Microsoft Fabric) at Pirllabs Private Limited (2025 – Present)

Medallion Architecture, PySpark, DAX, Power BI, SQL, Python

• Independently delivered 13+ Power BI reports end-to-end, from data modeling to dashboards, with DAX measures and interactive visuals on a Fabric semantic model for manufacturing KPI tracking.
• Contributed to a Fabric Medallion Architecture implementation (OneLake, Lakehouse with Delta Lake tables, Data Factory pipelines, Dataflow Gen2, Data Warehouse, SQL Analytics Endpoint) across Dev/UAT/Production.
• Developed PySpark and SQL transformations in Fabric Notebooks for cleaning, deduplication, REGEXP validation, incremental loads and reconciliation between layers.
• Built an AI agent in Microsoft Fabric on the semantic model so business users could query operational KPIs in natural language.

Telecom Real-Time Monitoring POC at Pirllabs Private Limited (2025 – Present)

Power BI, Real-Time Intelligence

• Delivered a POC dashboard on Real-Time Intelligence for high-volume streaming data, tracking live telecom KPIs.
• Validated pipeline performance under high-throughput conditions with the team.

Freelance Power BI Developer at Self-Employed (2024 – 2025)

Power BI, SQL, Python (Pandas, NumPy), DAX, Excel

• Designed and delivered Power BI dashboards for business clients, with data modeling, DAX measures and interactive visuals for sales and operational KPIs.
• Wrote SQL queries (joins, CTEs, window functions, stored procedures) to extract and prepare data from relational databases and Excel/CSV sources for reporting.
• Automated data cleaning and transformation with Python (Pandas, NumPy), improving data consistency and reducing manual effort.
• Gathered requirements directly from clients and delivered end-to-end, from data preparation to final dashboards.

Bachelor of Computer Applications (BCA) – University First Rank Holder – University of Madras (2021 – 2024)