Zohaib Ur Rehman Khan

Led data analyst team, delivering insights and reports to support business goals.
- Provided advanced data analysis for Amazon DSPs (USA) across payroll, fleet, human resource, quality, compliance and invoicing.
- Developed and maintained Looker/Power BI/Excel dashboards (DAX, Power Query, VBA, Data Models) and Next js Web apps for automated reporting.
- Delivered data-driven insights to improve operational efficiency and decision-making.

Results-driven Data Analyst with expertise in developing customized MS Excel and Google Sheets
applications using VBA & Apps script to meet client-specific requirements. Skilled in designing,
developing, and maintaining interactive dashboards (on Power BI, MS Excel & Google Spreadsheets),
advanced Excel solutions, and comprehensive reports to support data-driven decision-making.
Proficient in transforming complex administrative, accounting, and financial data into actionable
insights that drive operational efficiency and strategic growth. Experienced in leveraging advanced
Excel functionalities such as VBA macros, pivot tables, Power Pivot, Power Query, formulas, and data
visualization tools to streamline processes and deliver tailored, client-focused analytical solutions.

Spearheaded QA processes for international medical billing projects, ensuring compliance and high-quality outcomes.
- Designed interactive dashboards (Power BI & MS Excel) using VBA, Power Query, and Power Pivots to monitor performance metrics.
- Utilized data analysis to extract actionable insights, contributing to strategic planning and business growth

Led the international Workforce Management (WFM) team and oversaw workforce operations for a staff of 600+ across Lahore and Islamabad. Focused on optimizing processes, improving performance visibility, and driving operational efficiency through data and automation. Key dashboards and projects include:

Performance Dashboard: Assessed team metrics using a Holistic Score (savings, bills, completion rates) with daily/monthly trends via Looker.

Tardiness Dashboard: Monitored punctuality trends using biometric data (late arrivals, early leaves, missed scans) across both sites.

Call Time Dashboard: Delivered granular talk-time analysis with hourly breakdowns, updated via automated text file processing.

Breaks Tracker: Google Sheets/Form-based system to track and report daily/monthly break durations.

Leaves Dashboard: Integrated leave data to show availed and remaining quotas for each employee.

HR Dashboard: Centralized view of headcount, tenure, attrition, active warnings, and contract types (permanent/contractual).

Enabled data-driven decision-making and performance accountability through robust reporting solutions and operational oversight.

As a Marketing & Analytics Consultant at Solworx Technologies Ltd, I help businesses make smarter decisions by turning their data into clear insights and actionable strategies. I work closely with clients to understand their goals, analyze their performance, and create marketing and reporting solutions that actually move the needle.

My work spans across:

Marketing performance analysis and data-driven insights

Dashboard creation for visibility, BI reporting, and tracking KPIs

Campaign optimization for Google Ads

Process improvement across marketing and reporting workflows

Advisory on analytics tools, automation (like AppScript), and internal reporting systems