BI & DATA ANALYST · KARACHI, PAKISTAN

FARHAN AHMED

Business
Intelligence &
Data Analytics.

I turn complex business data into clear insights, interactive dashboards, and automated reporting solutions.

Farhan Ahmed, BI & Data Analyst
POWER BI · SQL · PYTHON · AUTOMATION

Transforming data
into decisions.

Explore My Work Let's talk

01 — ABOUT

I'm Farhan,
a BI & Data Analyst.

More than just dashboards. With 3+ years at Smollan, I work across the full BI cycle — gathering requirements, building Power BI dashboards, analysing data with SQL and Python, and automating reporting so insights reach stakeholders on time.

My focus: helping business teams understand performance, monitor field execution, and spend less time on repetitive reporting.

LinkedIn +92 305 5836914

QUICK FACTS

Based inKarachi, Pakistan
DepartmentOperational Intelligence
StudiedBS CS · Sukkur IBA
Experience3+ years
LanguagesUrdu · Sindhi · English

“From raw rows to the last KPI.”

02 — SKILLS

The toolkit behind the insights.

BI & Visualization

  • Power BI
  • DAX
  • Power Query
  • Dashboard design

Data

  • SQL
  • Python
  • Excel
  • Data cleaning
  • Analysis

Automation

  • Automated email reporting
  • Python scripting
  • Reporting workflows

Integration

  • Google Chat API
  • Chatbot development
  • Database integration

Business

  • KPI reporting
  • Requirements gathering
  • Stakeholder collaboration

03 — WORK

Dashboards that teams use every day.

POWER BI · RETAIL

EPOS Market Share Dashboard

Value share, category & brand performance with month, 3-month and year-on-year growth across retail accounts. Recognised with a Certificate of Appreciation.

My role: requirements, data modelling, DAX & dashboard design.

POWER BI · FIELD EXECUTION

OSA Availability Dashboard

On-shelf availability by region, category and distributor, with top available / missing SKUs and new-product tracking.

My role: requirements, data modelling, DAX & dashboard design.

POWER BI · AUDIT

Price Tracking Dashboard

Executive summary of store audits: price positioning, discount overview and price-point distributions by category.

My role: requirements, data modelling, DAX & dashboard design.

01

Automated Email Reporting System

Designed the backend and mechanism for automated email reports, now used across multiple accounts.

10–15+ hrs saved / week

Python · SQL

02

Magnum Merchandising & Audit Analytics

Power BI reporting for field execution and audit performance.

Power BI · DAX

03

BA Activity Dashboards

Reporting for Nido and Fruita Vitals brand-ambassador activities.

Power BI

04

Imtiaz BA Programme Reporting

Business associate programme reporting.

Power BI · Excel

05

Unilever Reporting & Dashboards

Supporting business reporting and dashboard solutions.

Power BI · SQL

06

People Team Chatbot

A Google Chat bot that answers employee people-team queries instantly.

Google Chat API

04 — EXPERIENCE

The path so far.

  1. Aug 2024 — Present

    BI & Data Analyst

    Smollan · Operational Intelligence

    Own dashboards and automation for multiple FMCG accounts; built the Automailer reporting system.

  2. Oct 2023 — Aug 2024

    Business Intelligence Executive

    Smollan

    Built Power BI reports for field execution, audits and BA programmes.

  3. Sep 2023 — Oct 2023

    Information Technology Intern

    Internship

    Supported IT operations and data tasks.

  4. Graduated 2023

    BS Computer Science

    Sukkur IBA University

    Foundation in databases, programming and data structures.

05 — ACHIEVEMENTS

Impact through data.

10–15+

hours of manual reporting saved per week

Through the automated email reporting system used across accounts.

CERTIFICATE OF APPRECIATION

EPOS Dashboard

Awarded by Smollan Pakistan on behalf of Unilever in recognition of my contribution to developing an EPOS Dashboard.

06 — CONTACT

Let's make data work smarter.

+92 305 5836914 farhanahmed2k191@gmail.com linkedin.com/in/farhan-bi

© 2026 Farhan Ahmed · BI & Data Analyst