Muhammad Akhtar Afzaal Khan, Power BI Consultant / Power BI Architect / Power BI Developer

Muhammad Akhtar Afzaal Khan

Power BI Consultant / Power BI Architect / Power BI Developer

UBT – United Business Technologies Inc.

البلد
الولايات المتحدة - Bloomington
التعليم
ماجستير, Computer Science
الخبرات
24 years, 1 أشهر

مشاركة سيرتي الذاتية

حظر المستخدم


الخبرة العملية

مجموع سنوات الخبرة :24 years, 1 أشهر

Power BI Consultant / Power BI Architect / Power BI Developer في UBT – United Business Technologies Inc.
  • الولايات المتحدة - Troy
  • أغسطس 2023 إلى مارس 2024

Responsibility.

i) End to End implementation of Power BI, Power BI administration, Implementation of Security, Client Handling. Power BI Quey, DAX & MDX Writing and Power BI Embedded Programming.

ii) Connecting Power BI with the Snowflake, ServiceNow and Jira & Oracle as a data source.

iii) Studying, Planning & Executing the Implementation of Microsoft Cortana Analytics, Power Platform using Power Apps, Power Automate, Power Virtual Agent, Adaptive cards, JSON and Graph API.

iv) Connecting to EasyVista via Premium Connector.

Power BI Consultant / Power BI Architect / Power BI Developer. في EY – Ernst & Young (End Client), LTI Mind Tree (2nd Last Company), Enterprise Solutions Inc (3rd Las
  • الولايات المتحدة - Alpharetta
  • مارس 2023 إلى يوليو 2023

Responsibility.

i) Involved in the Planning, Analysis, Designing, testing and Deployment of One of the largest ever developed system in the world, which are One GL (General Ledger), TR (Trade Receivable), FS Lending. These systems are Planned to implement in 160 countries step by step.

ii) Involved in the System Architecting, Dashboard, Report (pbix) & Paginated Report (rdl) Development, Power Query, DAX & MDX Routine development using bim file.

iii) Involved in the Analysis, Designing, Deployment & Testing extensively.

iv) Planning the Migration of Report form Old Systems like Business Objects, Cognos, Tableau to Power BI.

v) Planning Implementation of Power Platform using Power Apps, Power Automate, Power Virtual Agent.

Power BI Architect / Power BI Developer / System Analyst في M.O.J - Ministry of Justice (Kuwait) / AIMS – Arab Information Management Services
  • الكويت - الكويت
  • ديسمبر 2021 إلى ديسمبر 2022

Responsibility.
i) Extensively Involved in the Requirement Gathering Activity, Planning, Analysis, Design, Implementation & Programming for the conversion of existing AS-400 System Dashboards into the Power BI Platform.

ii) Connecting Power BI with the Snowflake, ServiceNow and Jira as a datasource.

iii) Planned and architecture the migration of Reports & Dashboards from Business Objects, Cognos, Tableau, Qlik View and Web focus to Power BI System.

iv) Planning the Migration of Reports form Old Systems like Cognos, Tableau, QlikView to Power BI.

v) Planning the Dashboard of New Power BI System using Power BI Methodologies & technologies like Power Query, DAX, MDX, Power BI Service, Power BI Reporting, SSRS, SSIS, Azure Synapse, Azure Databricks, Azure Data Lake, Azure Data Warehouse, ADF, Reporting (Client & Server) tool.

vi) Planning Implementation of Power Platform using Power Apps, Power Flows, Power Automate, Power Virtual Agent.

vii) Planned the conversion of new System using Technologies like Microsoft Dot Net Core 6, Clean Architecture without Domain Driven Design (DDD), Razor Pages, Blazer, Angular 14, Crystal Report.

Power BI Architect / Power BI Developer / Enterprise Architect / Solution Architect / System Analyst في M.O.H.E - Ministry of Higher Education (Kuwait) / A.T.G - Al-Almiah Technology Group
  • الكويت - الكويت
  • أكتوبر 2010 إلى ديسمبر 2021

Responsibility.

i) Extensively involved in the Development of Business Intelligence System using Microsoft Technologies like Power BI, Power Query, DAX, Power BI Service, Power BI Reporting, Azure Cloud, SSAS, SSIS & SSRS.

ii) Involved & Familiar in the Development of Datawarehouse System on Cloud & On Premises, using SSIS, Azure Cloud, ADF, Azure Synapse, Azure Databricks, Dataflows, Data Pipelines, Data Modelling, ETL & ELT Methodologies & Technologies.

iii) Planned and architecture the migration of Reports & Dashboards from Tableau, Qlik Sense and Web focus to Power BI System.

iv) Planning the Migration of Reports form Old Systems like Cognos & QlikView to Power BI.

v) Involved in the Project Management, Business Analysis, Software Architecting, Analysis, Design, Testing & Documentation Activities.

vi) Involved in the Solution Development using Microsoft Technologies like .Net Framework, .Net 5, .Net 6, VB.Net, C#.Net, MVC, Clean Architecture, Domain Driven Design, Microservices & Crystal Report.

IT Project Manager / Senior System Analyst في FAPCO
  • الكويت - الكويت
  • نوفمبر 2008 إلى سبتمبر 2010

Main Achievements.

i) Involved extensively as a Project Manager in different projects of ‘Kuwait Airways’ (one of them is Main Web site of Kuwait Airways).

ii) Lead a Team of 10 persons for developing Portal using Microsoft Dot net Technologies.

Responsibilities.

i) Developed different documents for Projects (as specified by the PMI standard) like Project Charter, Project Scope Management, and Project Risk Management & Project Management Plan etc. Research, Analyze, recommend, implement new technologies, standards, processes, tools and techniques.

ii) Perform the Business Requirements Gathering & Analysis. Identify common best practices for architecting solutions and components. Analyze existing use-case, analysis, design, and deployment models and describe how they are organized. Incorporate existing code and reusable assets in the development of a new application. Provide assistance with respect to installation, integration and tuning of integrated solutions.

iii) Provide technical support for the client throughout all stages of the product development.

iv) Take an active part in the development and review of internal business processes.

System Development Officer في ABK ( AL Ahli Bank of Kuwait )
  • الكويت - الكويت
  • أغسطس 2005 إلى أكتوبر 2008

Main Achievements.

i) Worked extensively for development of Intranet based solutions for the departments of Bank.

ii) Doing Analysis, Designing & developing Core Soft ware’s for the Risk Management Department like CBK Reporting System, Provision System & Risk Rating System.

iii) Doing Analysis, Designing & implementing latest Microsoft Dot Net technologies for developing Web Based Portal Solutions for the different departments of bank.

Responsibilities.

The details of my Job Responsibilities are as follows.

i) Perform the Business Requirement Gathering & Analysis, Developing the Business Document, Technical Document, Use Cases, DFD’s, RFPs, RFQs.

ii) Involved in the Selection of Platform and Technologies. Extensively involved in the programming using the Microsoft Technologies.

iii) Analyze existing use-case, analysis, design, and deployment models and describe how they are organized.

iv) Collaborate with the Software Specialists and the Technical Architect to select appropriate design solutions and ensure the compatibility of system components.

v) Review other solution designs to select appropriate technology, ensure efficient use of resources and ensure integration of multiple systems and technologies.

vi) Used Different Software Technologies like ASP.net, VB.Net, C#, Web Services and databases like SQL Server (2000 / 2005 / 2008), MS Access & Microsoft Excel.

Dot Net Web Developer في Agility (Kuwait) / PWC (Public Ware House Company - Kuwait)
  • الكويت - الكويت
  • يونيو 2004 إلى أغسطس 2005

Main Achievements.

i) Worked on Web based Portal solution for Corporate Environments.

ii) Worked on the PWC Developed Work flow tool named Micro Clear.

Responsibilities.

During the period I performed the different types of jobs its details are as follows.

i) Involved in the Selection of Platform and Technologies. Extensively involved in the programming using the Microsoft Technologies like ASP.net.

ii) Developed the Software Using the PWC workflow tool which is Micro Clear for workflow integration. Developed the Software Using the Self Developed tool in the ASP.net for workflow integration.

iii) Used Different Software Technologies like ASP.net, VB.Net, C#, Web Services and databases like SQL Server (2000 / 2005), MS Access & Microsoft Excel.

Software Engineer في International Leasing & Financial Company (ILIC)
  • الكويت - الكويت
  • يونيو 2003 إلى يونيو 2004

Responsibilities.

During the period I performed the different types of jobs its details are as follows.

i) Involved in the Financial & Web Based Solution Development. Perform the Business Requirement Gathering & Analysis. Developing the Business Document, Technical Document, Use Cases, DFD’s.

ii) Involved in the Selection of Platform and Technologies.

iii) Extensively involved in the Programming using the Microsoft Technologies like ASP.net, VB.net, C# & Web Services using database SQL Server (2000).

Software Engineer في DATA PULSE (Est.)
  • الكويت - الكويت
  • يناير 2003 إلى يونيو 2003

Responsibilities.

During the period I performed the different types of jobs its details are as follows.

i) Perform the Business Requirement Gathering & Analysis.

ii) Developing the Business Document, Technical Document, Use Cases, DFD’s.

iii) Involved in the Selection of Platform and Technologies for the Web Based Accounting System.

iv) Extensively involved in the Programming using the Microsoft Technologies like ASP.net, VB.net, C# & Web Services using database SQL Server (2000).

Software Engineer في PRCIENCE (KARACHI, PAKISTAN) - AMERICAN BASED MULTINATIONAL COMPANY
  • باكستان - كراتشي
  • يوليو 2000 إلى ديسمبر 2002

Main Achievements.

a) Worked on Scientific Software’s for the EDA (Electronic Design Automation) Industry.

b) Worked on Software’s using Microsoft Visual C++ and Java technologies using the databases like SQL Server, MS Access & ORACLE.

c) Heavy Involvement on the Web Based Portal Development.

Software Engineer في MICRO SYSTEM
  • باكستان - كراتشي
  • يناير 2000 إلى يوليو 2000

Responsibilities.

During the period I performed the different types of jobs its details are as follows.

i) Involved in the Scientific & Web Based System Development.

ii) Analysis and Design of different Software Modules, Construction of the user interface of project.

iii) Database programming using DAO / ADO, Printing capabilities of Software.

iv) Help System of the project, Collection Classes of MFC Programming.

v) Creating Installation and Uninstallation of different programme.

vi) Extensively involved in the Programming using the Microsoft Technologies like C, C++, VC++, MFC, ATL, COM, DCOM Programming using database SQL Server (2000) & MS Access.

الخلفية التعليمية

ماجستير, Computer Science
  • في University Of Karachi
  • ديسمبر 1999

M.C.S ( Master of Computer Science from University of Karachi - Pakistan )

دبلوم, Computer Science
  • في N.C.R / AT&T
  • يوليو 1998

D.C.S (Diploma in Computer Science from AT&T, Karachi - Pakistan)

بكالوريوس, Computer Science, Mathematics, Physics, Chemistry
  • في University Of Karachi
  • يوليو 1997

B.Sc ( Bachelor of Science from University of Karachi - Pakistan )

دبلوم, English Language
  • في P.A.C.C ( Pak American Culture Center )
  • يونيو 1997

D.E.L (Diploma in English Language from P.A.C.C, Karachi - Pakistan)

Specialties & Skills

Reporting
Data Analysis
Data Warehousing
visualisation
Business Intelligence
Project Management
Business Analysis
Business Intelligence
System Analysis & Design
Agile Project Management
MSSDT ( Microsoft Sql Server Data Tools )
Microsoft .Net Programming
ASP.net
Microsoft .Net Core Programming
Microsoft Entity Framework Programming
Microsoft Entity Framework Core Programming
Jenkins
Microsoft Fabric
Microsoft Power BI
Power BI Desktop
OneLake
Data Pipelines
Azure Synapse Analytics
DataLake
Power BI Service
DataFlows
Dynamic Analysis
DeltaLake
Data Management
Crystal Reports
Bit Bucket
GCP Cloud
Power BI Query
Power BI DAX (Data Analysis Expressions) Programming
Power BI Administration
Power BI Embedded Programming
Data Analysis
Data Modeling
Static Analysis
Power BI Report Server
Power BI Paginated Report
UML (Unified Modeling Language)
Database Modeling
Power Builder API
ADF (Azure Data Factory)
Azure Databricks
Data Science
Report Development
ETL (Extract Transfer Load) Programming
LakeHouse
SSIS (SQL Server Integration Services)
Database Design
ELT (Extrace Load Transfer) Programming
SQL Server Programming
SSAS (SQL Server Analysis Services)
Data Warehousing
SSRS (Sql Server Reporting Services)
Dashboard Development
Confluence
TFS (Team Foundation Server)
VSS (MS Visual Source Safe)
Azure Cloud
AWS Cloud

اللغات

العربية
متمرّس
الانجليزية
متمرّس
الهندية
متمرّس
الأوردو
متمرّس

التدريب و الشهادات

PMP Exam Preparation Course (تدريب)
معهد التدريب:
Life Long
تاريخ الدورة:
March 2010
المدة:
40 ساعة
P.M.P - Certification Revision 2020 (Updation) from P.M.I (Pennsylvania, America). (الشهادة)
تاريخ الدورة:
July 2020
صالحة لغاية:
July 2023
P.M.P - Certification Revision 2023 (Updation) from P.M.I (Pennsylvania, America) (الشهادة)
تاريخ الدورة:
July 2023
صالحة لغاية:
July 2026
M.C.T.S (MS.Net Framework 2012 – Programming in HTML5 with JavaScript & CSS3) (الشهادة)
تاريخ الدورة:
September 2017
M.C.T.S (MS.Net Framework 4.0 / 2013 – Asp.net MVC Programming) (الشهادة)
تاريخ الدورة:
November 2018
M.C.P.D (MS.Net Framework 2.0 / 2008 – Web Developer) (الشهادة)
تاريخ الدورة:
December 2017
M.C.S.D (Solutions Developer 4.0 / 2013 - Web Developer) (الشهادة)
تاريخ الدورة:
December 2018
MS Office Project Traning 2007 (تدريب)
معهد التدريب:
Life Long
تاريخ الدورة:
July 2010
المدة:
30 ساعة
P.M.P - Certification Revision 2011 (Initial) from P.M.I (Pennsylvania, America). (الشهادة)
تاريخ الدورة:
July 2011
صالحة لغاية:
July 2014
P.M.P - Certification Revision 2014 (Updation) from P.M.I (Pennsylvania, America). (الشهادة)
تاريخ الدورة:
July 2014
صالحة لغاية:
July 2017
P.M.P - Certification Revision 2017 (Updation) from P.M.I (Pennsylvania, America). (الشهادة)
تاريخ الدورة:
July 2017
صالحة لغاية:
July 2020
DA-100: Analyzing Data with Microsoft Power BI (الشهادة)
تاريخ الدورة:
October 2020