Khanabdulbasit1111@gmail.

com 📩
Riyadh, Saudi Arabia 📌
Abdul Basit Khan +966539654198 📞
https://tini.bio/abdulbasitkhanbidev/projects 📊
https://www.linkedin.com/in/abdul-basit-khan-aaab12193/
Profile Summary
Business Intelligence Developer with over 6+ years of experience in interpre ng and analyzing data to drive
business solu ons. Proficient in sta s cs, mathema cs, and analy cs, with a strong understanding of business
opera ons and analy cs tools for effec ve data analysis. Currently serving as a Business Intelligence Consultant
at NiceOne Headquarters, I have held versa le roles in database development, data warehousing, data
engineering, data analysis, dashboard crea on, ad-hoc repor ng, business analysis, and data modeling.

Certificates/Awards
TDS-C01 Tableau Desktop Specialist
DA-100 Microso Cer fied Power BI Data Analyst Associate
PL-300 Microso Cer fied Power BI Data Analyst
Microstrategy Departmental Analyst
Get Started with Looker
Analyzing and Visualizing Data in Looker
Prepare Data for Looker Dashboards and Reports
PL-900 Microso Cer fied Power Pla orm Fundamentals
DP-900 Microso Cer fied Azure Data Fundamentals
AZ-900 Microso Cer fied Azure Fundamentals
AI-900 Microso Cer fied Azure AI Fundamentals
Data Warehouse & Business Intelligence
Oracle Cloud Infrastructure Founda on Certified
Oracle Cloud Data Management Founda on Certified
Oracle Cer fied Professional Suite
Manage Data Models in Looker
Build LookML Objects in Looker
QlikSense Repor ng Tool

Technical Skills Soft Skills

Microso Power BI Leadership Skills

Tableau Presentation Skills
Amazon Quicksight Teamwork & Flexibility
Microstrategy Time Management
Looker Conflict Resolu on
SSRS Story Telling
QLIK Stakeholder Management
DWH & Analy cs Work in Multi-Vendor Environment
Data Modeling & Mapping Adaptability
Data Warehousing Attention To Details
ETL Problem Solving
Database SQL-PLSQL Negotiation Skills
Redshi Leadership
Oracle Networking Skills
So ware Development Life Cycle Project Management Skills
Scrum Master Mentoring & Coaching
SSMS Customer Interaction Skills
Data Visualiza on Trusted Communicator
NICEONE, Saudi Arabia 02/2024 –Present Mcdonalds, Saudi Arabia 08/2022 –01/2023
Business Intelligence Lead Business Intelligence Consultant
Oversee the design and implementa on of data Design and implement data warehouses, databases,
warehouses, databases, views, stored tables, views, func ons, and stored procedures.
procedures, and tables, ensuring alignment with Collaborate with stakeholders to translate business
business objec ves and best prac ces. requirements into effec ve data models that support
Partner with mul -cultural teams, stakeholders, long-term solu ons.
and business units to understand and translate Define and implement data modeling standards and
complex business needs into comprehensive dimensional models to meet analy cal needs.
data models that support long-term solu ons. Develop and maintain conceptual, logical, and
Direct the development of conceptual, logical, physical data models that address business data
and physical data models that fulfill business requirements and allow for future scalability.
data requirements and support BI repor ng and Maintain comprehensive metadata for data models
analy cs, while ensuring flexibility for future and recommend opportuni es for their reuse across
growth. projects.
Write and review complex SQL queries and ETL Work with diverse teams to gather and share
processes, ensuring efficient extrac on and necessary data and insights.
transforma on of data while crea ng calculated Write complex SQL queries and manage ETL processes
fields, measures, dimensions, and built-in to extract, transform, and load data, crea ng
func ons as needed. calculated fields, measures, and dimensions as
Lead efforts to analyze source system data, needed.
understanding data structures, defini ons, and Facilitate ad-hoc repor ng requests and create
anomalies to ensure data integrity. visualiza ons (e.g., geographical maps, charts) to
Manage the migra on of data from various present data insights.
sources into a centralized data warehouse, Oversee the migra on of data from mul ple sources
par cularly in Amazon Redshi , ensuring a into centralized systems like SQL Server or Amazon
seamless integra on process. Redshi .
Analyze large datasets and perform ad-hoc Manage and develop BI dashboards/dossiers and self-
repor ng, using visualiza ons such as KPIs, service interfaces using tools such as Tableau and
charts, and graphs to iden fy trends, pa erns, MicroStrategy.
and ac onable insights.
Create, test and deploy reports & dashboards Devna ves Inc, Pakistan 07/2021 – 08/2022
using BI tools like Amazon QuickSight, ensuring Business Intelligence Developer
they provide ac onable insights that meet
Create and maintain data warehouses, databases,
business requirements.
views, stored procedures, and tables.
Monitor and op mize the performance and
Collaborate with diverse teams to gather and analyze
reliability of BI solu ons, ensuring they meet the
data requirements.
evolving needs of the business.
Communicate with stakeholders to document and
Proac vely troubleshoot and resolve any issues
clarify repor ng needs.
related to data quality, performance, or user
Execute customized SQL queries for client ad-hoc
access to enhance user experience.
requests and perform data analysis.
Ensure comprehensive documenta on of BI
Design dashboards and visualiza ons using Tableau,
solu ons, including data models, ETL processes,
Power BI, and Amazon QuickSight, presen ng insights
and report defini ons for transparency and
to management and clients.
future reference.
Develop mapping specifica ons and implement
Mentor and support team members and end-
source-to-target mappings for ETL processes.
users, providing training on BI tools and
Define and implement data modeling standards and
solu ons to enhance their effec veness and
dimensional models to support analy cal
data literacy.
requirements.
Analyze source system data to understand structures,
defini ons, and anomalies.
MTBC CareCloud, Pakistan 12/2020 – 06/2021 Created and maintain conceptual, logical, and physical
Business Intelligence Developer data models to meet business needs and facilitate
Designed and model data warehouses and future growth.
integra ons to support business needs. Write complex SQL and DAX queries, crea ng
Conducted logical and physical data modeling to calculated fields, measures, and dimensions as
ensure op mal data structure and integrity. required.
Developed and manage SSIS packages for data Managed service accounts, handle pricing modules,
engineering tasks and code deployment. and oversee user access permissions.
Collaborated with various teams to gather and
share necessary data and insights. Dice Analy cs, Pakistan 02/2018 – 06/2019
Communicated with stakeholders to document DWH & Business Intelligence Developer
and clarify repor ng requirements. Designed data warehouse, database, tables and views.
Performed ad-hoc requests using customized Successfully transferred data from various sources
SQL queries and ETL processes to extract and like flat files, MS Access, and Excel into database.
format data. Wrote complex DAX and SQL queries to retrieve and
Defined and implement data modeling manipulate data.
standards and dimensional models that meet
analy cal needs. Developed mapping specifications, Source to target
Analyzed source system data to understand mappings and ETL development.
structures, defini ons, and anomalies. Performed tasks related to performance tuning of
Analyzed qualita ve, quan ta ve, and sta s cal ETL jobs.
data, and design dashboards that visualize key Implemented star schema and snowflake schema's
performance indicators (KPIs), charts, and technique as dimensional modeling.
graphs. Presented data and conclusions to team to improve
Write complex SQL and DAX queries, crea ng strategies and operations.
calculated fields, measures, and dimensions as Provided guidelines and assistance in many
required. projects.
Developed interac ve dashboards using Power Ad-hoc reporting in the form of visualizations to
BI and SSRS to present data insights effec vely. design dashboards on Reporting tools Power BI,
SSRS and Tableau.
Techohash, Pakistan 07/2019 – 11/2020
Business Intelligence Developer
Free Lancer, Pakistan 2017 – 2021
Designed Data warehouse, databases, views, Business Intelligence Developer
stored procedure and tables etc.
Collaboration with different multi-cultural Communicated with customers to gather and
teams/staff/team members to get required data document repor ng requirements effec vely.
and information. Executed ad-hoc requests using Excel and customized
Communicating with customers to gather and SQL queries/ETL to extract and format data as
document reporting requirements. needed.
Analyzed qualitative and quantitative even Wrote complex DAX and SQL queries to retrieve and
different format of the data. manipulate data.
Write Complex functions for calculated fields and Provided guidelines and assistance across various
SQL to get required data. projects to ensure successful outcomes.
Migrated data from multiple sources into the Designed and implemented data warehouses,
single source like in SQL Server Database plus databases, tables, views, func ons, and complex
translating those data in the form of visuals like stored procedures.
geographical maps, graph charts tree map, heat Developed ad-hoc reports and visualiza ons using
map, bar charts, line charts etc. Power BI, SSRS, and Tableau to create insigh ul
Ad-hoc reporting in the form of visualizations to dashboards.
design dashboards on Reporting tool; Tableau and Analyzed qualita ve and quan ta ve data across
presenting data and conclusions to the top various formats to extract meaningful insights.
management, manager and to the clients to make
improvements into business.