Malhar P
Data Analyst
Habilidades
Experiência profissional
Data analytics Engineer
Prosys Infotech Private Limited • Período integral
May 2024 - Present • 2 yrs
Experienced Data Analyst and BI Consultant specializing in Azure-based analytics solutions for QSR and Finance domains. Designed and deployed end-to-end data pipelines using Azure Data Factory and Synapse, enabling automated reporting and scalable data architecture. Developed executive Power BI dashboards covering operations scorecards, P&L reporting, revenue analysis, cost optimization, inventory reconciliation, and sales forecasting. Improved reporting efficiency by up to 60% through automation and data modeling best practices (Star Schema, DAX optimization). Integrated data from SQL databases, APIs, Excel, and cloud platforms into centralized reporting systems. Resolved KPI mismatches, blank value inconsistencies, and data quality issues to enhance reporting accuracy. Skilled in SQL (advanced queries, CTEs, window functions), Python (Pandas), Power BI, Microsoft Fabric, Snowflake, Azure DevOps, and ETL/ELT pipeline development. Focused on delivering business impact, not just dashboards.