Rameesha Ishtiaq

Rameesha Ishtiaq

Data Analyst | BI Consultant | Salesforce Specialist

I turn data chaos into clarity

Breaking bad data management habits, building early warning dashboards, and designing frameworks that harden the process so the same fires never start again. Delivered across P&G Australia, Saudi Arabia, and New Zealand.

40%
Faster Issue Resolution
500+
Users Trusting the Data
3
P&G Markets
Power BI Tableau Salesforce (Certified Admin) Advanced Excel SQL Data Quality Master Data Mapping
Portfolio
Dashboard Projects
Master Data Management Dashboard
P&G Australia & New Zealand
Tool: Power BI
Scope: 3 pages, 500+ users
Type: Master Data Quality & POG Tracking

The Problem

  • Products missing from the master reference database
  • Planograms not tracked consistently across Coles and Woolworths
  • Soft conversion requests piling up with no visibility into status
  • Teams relying on email chains and manual spreadsheet checks

My Solution

  • Missing Master Data page surfacing unmatched products filterable by GTIN and brand
  • Active POG's tracking planogram compliance across retailers with slicers for planogram type, category, retailer, and date
  • Prism Maintenance monitoring soft conversion requests and weekly maintenance with a matched rows KPI

Impact

Eliminated hours of weekly manual reconciliation. POG tracking across retailers went from scattered spreadsheets to a single real time filterable view for 500+ users.

Missing Master Data
Missing Master Data
Active POGs
Active POG's
Prism Maintenance
Prism Maintenance
Elevated Shopping Experience Dashboard
P&G Australia
Tool: Power BI
Scope: 100+ stores, 15+ brands
Type: In Store Compliance Monitoring

The Problem

  • Dozens of brands with specific display and shelf placement rules
  • Hundreds of retail locations to monitor simultaneously
  • Manual tracking by field teams compiling Excel reports monthly
  • Non compliance going undetected until the next store visit

My Solution

  • Matrix visual with conditional formatting (green = compliant, red = non compliant) by brand and store
  • 12 slicers covering Retailer, Site, State, GTIN, Product Name, Brand, Category, Sub Category, Segment, Planogram Type, Display Type, and Promo Week
  • Full drill down capability across any combination of filters

Impact

Brand managers can now spot non compliant stores instantly and take action the same week instead of waiting for monthly field reports.

Elevated Shopping Experience Top
Compliance Matrix (Top)
Elevated Shopping Experience Bottom
Compliance Matrix (Bottom)
Image Recognition Master Data Dashboard
P&G Saudi Arabia
Tool: Power BI
Scope: Product image verification + master data
Type: Data Quality & Validation

The Problem

  • Image recognition system capturing product photos with no link to master data
  • GTINs, brands, categories, shelf widths in separate systems
  • QA teams toggling between 3 different tools to verify a single product
  • New product onboarding validation was a multi step manual process

My Solution

  • Unified dashboard combining front and back product images with the full master data table
  • GTIN selection instantly loads corresponding product images alongside all data fields
  • Slicers for GTIN, Brand, Category, Sub Category, Name, and Last Updated for flexible filtering

Impact

Product verification now happens in one screen instead of three. Onboarding validation reduced from a multi step process to a single dashboard check.

IR Master Data Table
Master Data Table View
IR Product Images
Product Image Viewer
IR Health Dashboard
GreenTree Consumer Goods
Tool: Power BI
Scope: 3 pages, 25+ stores, 3 retailers
Type: Data Health Monitoring

The Problem

  • No visibility into store level data health across 25+ retail locations
  • Missing data weeks going unnoticed for weeks at a time
  • Master data mapping incomplete across multiple dimensions
  • Stakeholders making decisions on unreliable reports

My Solution

  • Store Health Monitor tracking active/inactive status with missing week detection
  • Data Freshness Tracker showing lag by retailer with On Track, Delayed, and Overdue KPIs
  • Master Data Mapping tracking completeness across 10 dimensions with monthly trends

Impact

Reduced data issue identification time by 40% by surfacing missing weeks and unmapped records before they reached downstream reports.

Store Health Monitor
Store Health Monitor
Data Freshness Tracker
Data Freshness Tracker
Master Data Mapping
Master Data Mapping

Tell me what's broken and I'll tell you how I'd fix it.

Available full time for dashboard and data quality projects.