- Gather and analyze business requirements from stakeholders. Translate requirements into technical form using Source Systems and then utilize the Data warehouse to build the end product. - Automate existing business reports developed in Excel through Data Warehouse & BI Landscape and deliver them for daily reporting. - Collaborate with stakeholders on requirements & prioritization, and work with business and development teams to ensure insights are built according to the acceptance criteria. - Create the Business Requirement Document (BRD) for mapping source system tables and attributes for technical teams. - Develop an early prototype using Qlik sense based on Business Requirements and update it according to stakeholder feedback, leading to the final report. - Develop SQL Server queries and Qlik sense Dashboards to fulfill ad hoc data requests. - Perform UAT with Stakeholders to ensure the final product meets the acceptance criteria. - Collaborate with the Technical, QA & Delivery team for smooth deployment of Projects from development to production and solve any tickets raised for report bugs. - Share and collaborate with Business wrong, missing and bad data to improve data accuracy. Improved data accuracy from 50% to 80% in a span of two years. After exposition of major issues source system data was improved.

SAB | Dec 2021 - Mar 2023

Business/Data Analyst

- Gather Business users’ requirements, understand business needs, and translate them for DateWarehouse, semantic layer designing, and implementation in Tableau. - Write a business requirement document (BRD) to map source system tables and attributes for the technical team. - Create interactive mockup dashboards/reports in Tableau for business users to understand and clarify the final output of the requirement. - Collaborate with stakeholders on requirements and prioritization, and work with development teams to ensure requirements are developed according to the acceptance criteria. - Develop business logic for the mapped attributes to build the Semantic layer and Tableau Dashboards. - Automate existing business SAS Reports to deliver them through Data Warehouse and BI Landscape and deliver them for daily reporting. - Collaborate with the Technical, QA & Delivery team for smooth deployment of Projects from development to production.

Ufone | Dec 2019 - Dec 2021

Executive BI Reporting and Quality Assurance

- Write SQL queries to extract relevant data from the Teradata access layer to fulfill business requirements. Extract relevant data from MSTR & Teradata in coordination with other team members. - Data Sanity Check with other reported data to ensure accuracy. Re-validation and re-verifi cation of Data Sanity with other reported numbers from related teams. - Review, enhance, and regularize the final Visualization as Dashboards or Data Models. - Extraction, compilation, and modeling of GIS-required data using SQL/MSTR and Tableau. Load the finalized GIS data into Tableau for appropriate GIS views (regional, City/district, and Cell Site level) for agreed KPIs. Finally, Automate the finalized GIS views for regular reporting to relevant teams. - Convert old dashboards created in Excel to Tableau for more dynamic analysis and understanding of critical KPIs performance. - Analyzing Ufone KPIs through Geo Analysis at the State Level, Region Level drilled down to Districts by integrating Pakistan Shapefile & Tableau Desktop Map Visual. Sharing the Dashboard with relevant Teams Using Tableau Server for Live interactions. - Collaborate with the Data Warehouse team for automation of reports & solve any discrepancies found in KPI numbers. - Support marketing, strategy & fi nance teams through ad-hoc reporting based on their demand.

Dice Analytics | Oct 2018 - Dec 2019

BI Consultant & Trainer

- Design, develop, and maintain business intelligence dashboards using Power BI. - Design fact tables and dimensions in MS SQL Server, then pull them into the Power BI environment. - Design multiple dashboards and reports by importing data from SQL Server, MySQL, and Postgres. - Maintain EZ Analytics product through web development and Power BI dashboard maintenance used as iframe. - Create measures or calculated columns using DAX to solve a business problem to build dashboards. - Provide Training related to Data Warehouse and BI to the corporate as well as regular customers. - Develop and use semantic data model, and development of Ad-hoc reports. - Development of Dashboards/Reports using different BI platforms (MicroStrategy, Tableau, Power BI). - Provide Training on Data Warehouse & BI Landscape to resources of different domains. - Received an award for my contribution in expanding the reach of the company to new clients.

My Education

Take a look at my formal education

Bachelor's degree, Computer ScienceQuaid-i-Azam University, Islamabad | 2018

About Me

With over 7 years of working in corporate sectors I have been playing with data to generate insights and present it to stakeholders in best way possible for decision making. I have developed and visualized over 400+ dashboards in my career so far.

Create Your Data Portfolio for Free