Mubashir Imdad

• Developed a centralized data repository, unifying transactional data from multiple databases into a structured architecture for enterprise analytics and the development of Digital 360 Performance Dashboard. • Developed and maintained enterprise dashboards published on Microsoft Fabric to track deposits, branch KPIs, system monitoring, financial performance, and digital channel activity. • Designed and implemented Microsoft Fabric environments from the ground up, including end-to-end setup of data gateways, connection architecture, security access controls, and automated data refresh pipelines. • Automated reporting workflows using Python and SQL, generating Excel analytics reports and distributing them automatically via email and shared folders. • Managed and optimized ETL processes using SQL stored procedures and Talend to efficiently process and transform large scale banking datasets. • Delivered advanced ad-hoc analytical reports and insights to stakeholders, supporting data driven decision making across business functions.

• Wrote and optimized complex SQL queries to extract, transform, and prepare audit datasets for BI and analytics across multiple banking entities. • Developed Audit Quality and Audit Projects dashboards to monitor data quality, completeness, inconsistencies, and project progress across six entities. • Built automated reporting workflows using SQL, Excel, Power Query, and Microsoft Power Automate, generating automated visualizations and reports for senior management via email. • Transformed raw audit data into actionable insights using Excel and Microsoft Power Query to support audit leadership decisions. • Maintained BI governance and reporting operations, including dashboard refresh schedules, access management, and data integrity controls.

• Implemented web analytics tracking using Google Analytics (GA3 & GA4) to monitor user behavior, traffic sources, demographics, and engagement metrics for marketing performance analysis. • Led migration of GA3 historical data to Google BigQuery using APIs, Python, and Google Sheets to preserve analytics history and enable advanced reporting. • Developed analytics dashboards in Looker Studio and Microsoft Power BI to visualize website engagement, marketing performance, and client insights. • Built a Python-based automation tool to process Excel datasets and automatically generate visualizations, improving reporting efficiency. • Applied machine learning models (classification & regression) in Python for predictive analytics and performance evaluation.