Name: Ali Raza

Job Role: Business Intelligence Consultant

Experience: 3.5 Years+

Address: Lahore Pakistan

Skills

Power BI 95%
DAX 85%
Data Visualization 90%
Data Analysis 85%
SQL 80%

About

About Me

Microsoft Certified Data Analyst with 3.5+ years of experience having good understanding of SQL & relational database I am proficient in using Power BI Data Analysis Expressions [DAX] to develop Dashboards, & Reports. Demonstrated success in leading impactful projects and providing effective mentorship.

  • Profile: Business Intelligence & Consultant
  • Domain: Big Data, Ecommerce & Digital Marketing
  • Education: Master of Computer Science
  • Language: English, Punjabi
  • BI Tools: Microsoft Power BI & Tableau
  • Other Skills: Cloud, Excel, Git, JIRA, Google Analytics & Business Analytics

0 +   Projects completed

LinkedIn

Resume

Resume

Seasoned Business Intelligence Consultant with 3.5+ years of experience driving business strategies through data-driven insights. Proven expertise in data , statistical analysis, machine learning algorithms and project management.

Experience


2024-Present

Business Intelligence Consultant

Punjab Information Technology Board

Developing custom reports and visualizations to support business decision-making processes.

  • Optimizing SQL queries to improve report performance, resulting in 20% faster reports in Dbeaver.
  • Collaborating with different teams to gather requirements and ensure data understanding and proper documentation.
  • Trained the end-users on reports and dashboards customization to promote data decision making.

2022-2024

Business Intelligence Consultant

TMR Consultig

Designed & developed Power BI dashboards to monitor department performance, resulting in increased efficiency.

  • Served the department for adhoc queries & reports using DAX function.
  • Delivered multiple training and mentorship sessions on analytical tools like SQL, MS Excel, Power BI and Tableau
  • Implementing data models & DAX calculations to improve data accuracy.
  • Worked & analyzed variety of data sources.



Education


2018-2020

Master Of Computer Science

Pir Mehr Ali Shah Arid Agriculture University Rawalpindi Pakistan

Grade: First class distinction.

2016-2018

Bachlor Of Computer Science

Islamia Univeristy Bahawalpur Pakistan

Grade: First class distinction.

Projects

Projects

Below are the sample Data Analytics projects on SQL, Python, Dax, Power BI & Tableau

Financial Insight Reports using SQL

In today's fast-paced business environment, making informed financial decisions is crucial for an organization's success. Financial professionals rely on accurate and timely data to assess their company's performance, identify trends, and make strategic decisions

HR Analytics Dashboard

This project highlights my ability to use data visualization and analytics tools to identify key insights and provide actionable recommendations. HR analytics aim to provide insight into how best to manage employees and reach business goals.

Pizza-Sales-Dashboard

A year's worth of sales from a fictitious pizza place, including the date and time of each order and the pizzas served, with additional details on the type, size, quantity, price, and ingredients.


Road Accident Analysis

The purpose of this Power BI dashboard is to analyze road accident data and identify patterns and trends that can help improve road safety. Imported the data into Power BI and cleaned it to ensure it was accurate and ready for analysis. The data includes information about accidents, such as the number of vehicles involved, severity of the accident, and the location and time of the accident.

Codebasics Cricket Best 11

To display all the matches and their outcomes in the data base To display total matches, avg won, avr tied, avg no result, runs per match, wkts per match in Indian Stadiums To display a particular batsman, his country, his total sixes, his total fours, his total runs, his total centuries To display a particular bowler, his country, his total_maiden spells, total wickets taken by him.

0 Achievements
0 Projects
0 Deliverd Projects
0 Completed Project

More projects on Github

I love to solve business problems & uncover hidden data stories


GitHub

Contact

Contact Me

Below are the details to reach out to me!

Address

Lahore, Pakistan

Contact Number

+ 92 310 2521 471

Email Address

aliraza6344988@gmail.com