Md Abu Hanif

Performed data analysis and KPI reporting across sales, production, inventory, and marketing functions using large datasets to surface trends and actionable insights. Built and optimized 80+ interactive dashboards in Power BI and Google Looker, including LookML model work and performance tuning to reduce reporting turnaround times. Designed and maintained a centralized data warehouse consolidating 8+ source systems, and implemented ETL pipelines to automate data workflows at scale. Managed SQL Server databases and cloud-based pipeline infrastructure on Azure and GCP, including governance, security, backup/recovery, and data quality frameworks.

Led migration of on-premise reporting infrastructure to cloud services including Azure SQL and Power BI Service, plus GCP BigQuery for analytics workloads. Reworked data pipeline and reporting components to improve scalability and reduce infrastructure costs. Supported the transition to cloud-based analytics while maintaining reporting continuity.

Developed a suite of executive KPI dashboards across Power BI and Google Looker to track real-time business metrics. Authored LookML models and applied performance optimization techniques such as caching and aggregate awareness. Delivered dashboards used for monitoring sales, inventory, and production KPIs.

Modernized legacy, Excel-based data workflows by implementing automated ETL/ELT pipelines using SSIS and Python. Enabled reliable recurring data processing for operational and finance teams while reducing manual effort. Improved overall workflow efficiency by streamlining data ingestion and transformations.

Architected and built a centralized enterprise data warehouse consolidating multiple source systems into a unified model. Focused on reducing reporting latency and enabling self-service analytics for a large internal user base. Worked on data integration and warehouse design to support consistent enterprise reporting needs.