About Me
I am a data analyst, passionate about working with organizations that want to make effective use of their data, from the first
ideas around what you want to measure and how to capture data accurately, through data preparation, analysis and management, all the way to
the impactful presentation of insights. I can support each step of the process to enable your organization to make evidence-driven decisions
or share insights with new audiences.
With nearly 5 years in data analytics, I'm a Microsoft Certified Power BI Data Analyst adept in BI analysis, Tableau, Python, Power Automate,
Power Apps, UI Path RPA, SQL, Snowflake, Excel VBA, and many more.
Having collaborated with esteemed multinational companies such as Huawei, Zong 4G Pakistan, Fortescue Metal Group, Rio Tinto, Roy Hill, and
Enco Group, I bring a wealth of experience. Beyond analytics, my passion extends to steering Digital Transformation initiatives, contributing
to organizational growth and innovation.
Acceptance Testing Dashboard
This dashboard was created to monitor the company's overall equipment delivery stats. This includes multiple filters and attractive visuals to illustrate delivery KPIs. Moreover, I have created many customizations on this dashboard according to customer demands and to make it more user-centered. There is also a customized toggle button used in this dashboard to switch between two visuals.
Daily Plan Dashboard
This dashboard was created for the purpose of monitoring resource activity in fields. An excel based BI dashboard that fetches its data from an excel sheet, which updates periodically. There are many customizations on this dashboard like all the counts appearing on this dashboard are clickable. We can click counts to filter data and export that filtered data from the export given below.
Financial Penalty dashboard
It's a Financial Penalty dashboard that I had created using gradient coloring. on customer demand, I have also added a scroller that is basically giving visibility for penalty criteria.
Quality Of Sales Dashboard (Tableau Based)
This Tableau dashboard was developd to monitor quality of sales for Zong mobile SIMS.
4G Daily Dashboard
This dashboard is to monitor Zong overal 4G KPIs, like Active base, base movement KPIS, gross adds, reconnections, churns, etc.
Purchase orders Tool
This purchase order tool is a part of the Supply Chain management system. It monitors pruchase orders/Purchase requests of services that Huawei provides to its customers.
Budget Dashboard-Excel Based
Revolutionize financial planning with our Budgeting Dashboard—an Excel-based powerhouse featuring advanced VBA scripts, Power Query, and Power Pivot. Automated, visually captivating, and tailored for my client, it ensures precision, efficiency, and strategic decision-making in a single, user-friendly interface.
Unrecovered Tool Management (Excel VBA)
Efficiently manage tools with my Excel VBA solution designed for my client. This tool, tailored for the mining industry, tracks pending or unrecovered tools, ensuring accountability. Utilizing advanced VBA techniques, it offers real-time insights and financial monitoring to optimize operational efficiency for client dynamic needs.
Notification Tracker (Excel VBA)
Optimize communication with the Excel VBA Notification Tracker tool designed exclusively for my client. Leveraging advanced VBA techniques, this tool incorporates user-friendly forms to efficiently gather information from users. Streamline the tracking of notifications, ensuring swift and accurate data collection. Elevate your communication workflow with this tailored solution, enhancing responsiveness and data accuracy for client dynamic operations.
Electricity Nomination Dashboard (Power BI)
Transformed energy management with a dynamic Electricity Dashboard for my client. Harnessing the power of Power BI, seamlessly integrated with Power Apps and Power Automate, this tool provides real-time insights into electricity demand across all sites. Elevate your energy strategy with unparalleled efficiency and precision in decision-making.
UIPath Automation WorkFlow
This UIPath RPA was designed for web scraping purpose. It opens a website using chrome web browser and scraps the data from a perticular website using web scraping techniques and then passes this data to a Python script for data transformation and eventually, data gets saved to an excel file. It uses If/Else conditions, loops, etc. to perform the task.
Powerful Power Automate Integration
Unlock automation potential with my expertise in designing numerous Power Automate workflows. Seamlessly integrated with Power BI, these workflows provide dynamic data inputs, enhancing insights and decision-making. Additionally, independent flows automate daily recurring tasks, streamlining operations for unparalleled efficiency. Elevate your workflow automation strategy with precision and productivity.
Python script to extract Outlook attachment data
It's a python based project that extracts data from the attachments of emails that we receive on daily bases. After data extraction it gets saved in a local folder and then it is serves as a data source for other BI projects.
Python script to Send automated Outlook Emails
Python based project that sends automated emails. This project was developed to mitegate the hassle of sharing daily kPI progress update with all stakeholders.