Available for BI & Automation Opportunities

Muhammad Hamza Irfan

Business Intelligence & Data Analytics Professional | Automation Specialist

6+ years of hands-on experience steering enterprise reporting, sales analytics, database transformations, and workflow automation. Expert at optimizing data pipelines and replacing manual operational overhead with automated Power BI, Qlik Sense, and Power Automate solutions.

Send Email www.hamzairfan.work +92 315 1303531

Quantifiable Achievements

Operational & Analytics Business Impact

Ufone / PTCL Group

130+ Franchise Distribution

Architected an automated Power Automate report-splitting workflow that reduced daily report dispatch across 130+ franchises from several hours of manual work to under 4 minutes.

BankIslami Pakistan

40% Workload Reduction

Designed and deployed 10+ enterprise Power BI dashboards and optimized SQL ETL pipelines, cutting manual recurring reporting overhead by 40% across departments.

Career Track Record

6+ Years Expertise

Proven history driving end-to-end BI solutions, RPA automation, and database management across telecom, banking, pharmaceutical, and insurance sectors.

Core Technical Capabilities

Comprehensive tech stack across Business Intelligence, Automation, and Web Systems

BI & Analytics

Power BI (Desktop & On-Prem)
Qlik Sense Enterprise
Advanced Excel Dashboards
Executive KPI Architecture

Data & ETL

SQL & SQL Server Querying
MySQL Database Design
ETL Pipeline Optimization
Data Quality & Modeling

Workflow RPA

Microsoft Power Automate
UiPath Studio
n8n Automation Workflows
Scheduled Dispatchers

Software Engineering

PHP (Laravel / CodeIgniter)
JavaScript, jQuery, AJAX
HTML5, CSS3, Tailwind
C#, .NET Basics

Professional Experience

Track record in telecommunications, banking, pharma, and assurance

Apr 2026 – Present Karachi, PK

Officer Business Support (Retail Sales)

Ufone (PTCL Group / Etisalat)

Automated the daily Stock Out Report using Microsoft Power Automate, guaranteeing generation and delivery before the 8:30 AM deadline.
Architected an automated report-splitting workflow for 130+ franchises, delivering specific reports in under 4 minutes vs hours of manual labor.
Maintained performance dashboards to evaluate retail sales targets and analyze cross-channel KPI compliance.

Nov 2024 – Mar 2025 Karachi, PK

Business Intelligence Analyst

BankIslami Pakistan Limited

Deployed 10+ Power BI dashboards, achieving a 40% reduction in recurring manual reporting workloads.
Managed on-premise Power BI Report Server infrastructure, maintaining data security protocols and performance tuning.
Refined ETL pipelines in SQL Server for faster database processing and higher data accuracy.

Feb 2024 – Oct 2024 Karachi, PK

Executive B.I. Analyst

International Brands Limited (Searle Pharmaceuticals)

Built interactive Power BI reports for sales, operational supply chain, and pharmaceutical distribution.
Executed query optimization and DAX model tuning to improve report load responsiveness.

Nov 2019 – Jan 2024 4+ Years Career Track

BI Analyst & Operations Progression

Adamjee Life Assurance Company

Officer BI Analyst (IT) (Apr 23 – Jan 24)

Built Qlik Sense dashboards empowering 100+ users with self-service insights, cutting prep time by 30%.

Officer Persistency & BI Analyst (Jun 22 – Mar 23)

Automated persistency and business renewal reporting to support sales renewal targets.

Associate BI Analyst & Project Associate (Nov 19 – May 22)

Constructed dynamic performance trackers and optimized processing workflows across banca channels.

Featured Projects & Automations

Custom applications, enterprise bots, and management systems

Vehicle Auction System

Built a live auction portal in CodeIgniter 4 handling 500+ daily bids with optimized database queries and strict security controls.

CodeIgniter 4 MySQL AJAX

WhatsApp Enterprise Bot

Engineered an automated UiPath workflow for bulk messaging, notification dispatches, and group management, saving 10+ hours weekly.

UiPath RPA Automation

Clinic Management System

Developed a full-stack Laravel management portal handling patient appointments, treatment history, operational records, and expense tracking.

Laravel PHP Bootstrap

Education & Credentials

Academic qualifications and professional technical diplomas

Graduated 2026

Associate Degree in Commerce

University of Sindh

2016 – 2019

ACCP Pro Diploma in Software Engineering

Aptech Computer Education (3-Year Track)

2010 - 2012

Matriculation

Usman Public School Campus IX

2012 – 2014

HSC Pre Engineering

Govt. Degree Collage for men Buffer zone