Rizwan Afgan

Experience

• 

  Oracas

  Oct 2013 - Jun 2016

  Data Analyst

  Implemented complete end to end Data Analytics solutions using MS BI StackDesigned and implemented an operational dashboard in Tableau to find areas of improvements for sales resulting in 18% sales growth annuallyDesign & Implementation of Data Architecture & Data Modelling Working with Key stakeholders to identify and model business processes for better analysisDefining Key Performance Indicators according to business processes Implementation of Data Governance Standards

• 

  S&P Global

  Jun 2016 - Sept 2018

  Business Intelligence Consultant

  Partnered with clients to define BI strategies aligned with business objectives.Developed robust data models and ETL processes, improving data accuracy by 20%.Designed and implemented interactive dashboards, driving real-time decision-making.Conducted data analyses leading to a 15% revenue increase and 10% cost reduction.Collaborated cross-functionally to promote a data-driven culture.Provided expert guidance and training, enhancing analytical capabilities.Stayed updated on BI trends, recommending innovative solutions. Show less

• 

  Zong CMPak Ltd

  Sept 2018 - Jan 2021

  Sr. Executive IT (Data Management & Data Science)

  Active member of Digital transformation team and implemented MicroStrategy system along with Zones and inhouse IT team Created an automated system for third party payments & omni channels reporting systemPerformed customer & sales analysis for creating various campaignsQuery performance tuning of slow reporting workloads and resolution of bottlenecksUnderstanding customer business requirements and translate them to analytical data models with a vision on how to implement a solution.Responsible for project management of analytics projectsResponsible for designing Analytics Architecture, analytical Data mart & DWH Development.Used Analytical/Statistical tools to develop and deliver the analytics solution to the business. Show less

• 

  EXCEED IT Services

  Jan 2021 - Feb 2023

  Sr. Business Intelligence Consultant

  Took an active part in Digital Transformation project of The Crosby Group, USA and moved their analytics infrastructure from SAP to Azure & Power BIPerformed pre & post marketing campaign analysis using statistical methods & A/B testingWorked closely with business and technical teams regarding their reporting & analysis needsMaintained Power BI infrastructure and implemented visually engaging BI dashboardsResponsible for project management of analytics projectsCompleted and updated documentation of Roadmap, Projects, Solution Design documents, Business rules documents & application requirements documents. Show less

• 

  TELEIOS GLOBAL FZ LLC

  Oct 2022 - Feb 2023

  Sr Data Analytics Consultant

  Setup Power BI Infrastructure for Reporting and AnalysisUsed Google Analytics for Campaigns AnalysisCreated dashboards in Power BI for C-level executivesCoordinated with other business sections for gathering data for analytics

• 

  UnionCoop

  Feb 2023 - now

  BI & Analytics Lead

  Key Achievements:Led the implementation of Microsoft Fabric, streamlining data processes and improving overall data efficiency across the organization.Established robust data governance frameworks that ensured data integrity, compliance, and accuracy for business-critical decisions.Managed multiple projects to deliver high-quality BI solutions, driving better business outcomes and faster decision-making through effective dashboard and report delivery.Key Responsibilities:Collaborate with marketing, operations, and sales teams to provide data-driven insights that support strategic initiatives and drive business growth.Lead the planning and execution of BI projects, ensuring alignment with business objectives and delivering solutions that enhance decision-making and operational efficiency.Oversee data governance processes to ensure the accuracy, reliability, and compliance of all analytics and reporting outputs.Manage a team of BI analysts, fostering a collaborative, results-oriented culture to meet business needs and ensure continuous improvement.Develop and maintain executive dashboards and reports in Power BI to provide leadership with actionable insights and support data-driven decisions.Design & Implement efficient ETL processes, ensuring seamless integration and accessibility of data for reporting and analytics.Actively develop and optimize Power BI reports and data models, improving performance, query efficiency, and user experience across business functions.Lead the development of automated reporting solutions to reduce manual work, ensuring real-time access to accurate business data. Show less