← TEAM / DISCIPLINE 05

DATA AUTOMATION / BUSINESS INTELLIGENCE

JAMSHED
MUHAMMAD

End-to-End Data Automation · BigQuery · APIs · Dashboards

PROFILE / 05

Jamshed builds the system behind the dashboard — collecting raw data, cleaning it, validating it, automating the repetitive work, structuring it in databases and warehouses, then presenting it as decision-ready reporting.

UPWORK322Total jobs
DELIVERY19,977Total hours
EXPERIENCE15+Years in data
PROFILE100%Job Success
STATUSTOPRated Plus
END-TO-END ARCHITECTURE

RAW DATA →
DECISIONS.

A dashboard is only as reliable as the pipeline behind it. The work starts with the source, not the chart.

01RAW DATA

Sheets · Excel · CSV · APIs · POS / CRM · GA4

→
02CLEAN

SQL transforms · duplicates · standardisation · reconciliation

→
03AUTOMATE

Apps Script · APIs · schedules · recurring imports

→
04BIGQUERY

Warehouse · staging · history · reporting tables

→
05QA

Missing data · anomaly checks · source-vs-destination validation

→
06DASHBOARD

Looker Studio · Power BI · Tableau · management reports

COMPLETE WORKFLOW

ONE SPECIALIST.
THE WHOLE PATH.

From extraction and SQL to QA and executive reporting, the delivery is designed as one connected system.

01 / SOURCES

Integrate

Google Sheets, Excel/CSV, APIs, POS/CRM systems, GA4, emailed reports, external platforms and existing databases.

APIsGA4Google SheetsExcel
02 / TRANSFORM

Structure

SQL transformations, reconciliation, calculated fields, business rules, duplicate handling and standardised reporting datasets.

SQLBigQueryData ModelsValidation
03 / AUTOMATE

Run

Scheduled imports, synchronisation, recurring reporting, Google Apps Script, APIs, monitoring and automated QA processes.

Apps ScriptETLVBASchedules
04 / REPORT

Decide

Executive KPI dashboards, operational reporting and management views built on reliable, tested data.

Looker StudioPower BITableauExcel
SELECTED UPWORK WORK

BUILT FOR
REAL OPERATIONS.

Client names and private datasets are not reproduced here. These portfolio cards represent the public service areas and project patterns Jamshed delivers through his Upwork practice.

01 / BIGQUERY
BQ

Automated Reporting Warehouse

Raw sources are staged, transformed and stored in BigQuery, then exposed as stable reporting tables for recurring dashboards.

BigQuery · SQL · APIs · ETL
02 / LOOKER STUDIO

Executive KPI Dashboard

Decision-ready management views that separate top-line KPIs, trend signals, operational exceptions and drill-down detail.

Looker Studio · KPI Design · BI
03 / AUTOMATION
API→SQL→QA→BI

API + Scheduled ETL

Automated imports, synchronisation and recurring reporting workflows designed to remove repeated manual handling.

Apps Script · APIs · Schedules
04 / EXCEL + VBA
VBA

Report Automation Engine

Structured spreadsheets, macros and validation logic for repeatable reports, reconciliations and operational workflows.

Excel · VBA · Data QA
05 / MARKETING DATA

GA4 + Platform Reporting

Cross-platform data brought into one reporting layer for cleaner performance analysis and shared business definitions.

GA4 · Google Ads · APIs
06 / MANAGEMENT BI

Power BI / Tableau Reporting

Operational and executive dashboards built around questions, thresholds and actions rather than decorative charts.

Power BI · Tableau · Reporting
LIVE PROFILE / UPWORKVIEW CURRENT WORK HISTORY & PORTFOLIO↗
BACKGROUND / PROOF

EXPERIENCE
WITH STRUCTURE.

EDUCATION
University of Engineering & Technology, Taxila, Pakistan

BE in Information Technology · 2004–2008

KRL Institute of Technology, Kahuta, Rawalpindi, Pakistan

Diploma · Computer Hardware · 1999–2003

Govt. High School Kahuta, Rawalpindi, Pakistan

Mathematics, Physics, Chemistry, Biology & English · 1997–1999

LANGUAGES
EN

English

Fluent · Verified
ਪੰ

Panjabi / Punjabi

Native or Bilingual
اردو

Urdu

Fluent
BIGQUERY / APIs / BI

FROM RAW DATA
TO A SYSTEM.

Send the current sources, the reporting requirement and what is still being done manually.

Start with Jamshed ↗Upwork ↗
Previous specialist← Abdullah LuqmanNext specialistMorage Luqman →