
Zohaib Ur Rehman Khan
Lahore, Pakistan
Zohaib Ur Rehman Khan
Excel Expert, Web App Development, Power BI,Looker
Category : Business management
Senior Analytics Lead | Fleet, Payroll, Operations, Compliance & HR Analytics | Billing & KPI Dashboards | Quality, Marketing & Workforce Insights | Web Apps (Next.js, React, TypeScript, HTML) ,Power BI (DAX, Power Query, Data Modeling), Looker, Excel Expert (Power Query, Power Pivot, DAX, VBA, Advance Functions), Google Apps Script | Automation Expert
Working hours
- Monday:08h00 To 18h00
- Tuesday:08h00 To 18h00
- Wednesday:08h00 To 18h00
- Thursday:08h00 To 18h00
- Friday:08h00 To 18h00
- Saturday:00h15 To 23h45
- Sunday:00h15 To 23h45
- Senior Analytics Lead | Fleet, Payroll, Operations, Compliance & HR Analytics | Billing & KPI Dashboards | Quality, Marketing & Workforce Insights | Web Apps (Next.js, React, TypeScript, ...
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.
- 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.
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
- 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.
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
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
- 🇬🇧 English
Please sign in as a customer to give your feedback




