Muhammad Khaleel Afzal, Deputy Manager IT  (Business Intelligence)

Muhammad Khaleel Afzal

Deputy Manager IT (Business Intelligence)

National Transmission & Despatch Company

Location
Pakistan - Lahore
Education
Master's degree, Computer Science
Experience
12 years, 8 Months

Share My Profile

Block User


Work Experience

Total years of experience :12 years, 8 Months

Deputy Manager IT (Business Intelligence) at National Transmission & Despatch Company
  • Pakistan - Lahore
  • My current job since December 2021

Work closely with Project Director ERP and Stakeholders to provide efficient solutions.
• Analyze the business flow, use cases and changes to design architecture, user interfaces
and data models.
• Preparing different Software Documents & RFPs for stakeholders.
• Lead to manage Data team for collection of data all over the organization to design data
warehouse.
• Working to Design & Development of Business Intelligence Application for Power Sector
for Reporting and Analysis using Machine Learning & Deep Learning for Predictions.
• Working to Design & Development of Employee Self Service Mobile App using Angular
Ionic, .Net Core to facilitate employees including internal chat with Nest.JS.
• Coordinate with SAP Vendor to working to SAP implementation within organization.
• Working on SAP BI/BW module for Dashboard & Reporting.
• Coordinate to implement integration solution of different software’s i.e SharePoint,
SCADA, GIS and Metering system with SAP ERP.

Assistant Director Technical (Software & Databases) at Pakistan Telecommunication Authority
  • Pakistan - Islamabad
  • June 2020 to December 2021

Work closely with Project Managers and Stakeholders to provide efficient solutions.
• Analyze the business flow, use cases and changes to design architecture, user
interfaces and data models.
• Preparing different Software Documents & RFPs for stakeholders.
• Develop Business Intelligence Application DIRBS View for statistics and predictive
Analysis of Device Identification, Registration & Blocking System.
• Working to develop a computer aided system that will help to monitor different server
with active services and backups using asp.net core 3.1, oracle, & angular to apply
automation.
• Design Software Architecture to manage Big data, Angular and .Net Core
Applications.
• Working on analysis & development of Telecom ERP including different Module &
BI Dashboards using Angular, .Net Core 3.1, Dapper, Oracle, PostgresSQL, Chart.Js, High
Charts & Ubantu.
• Designing & Implementation of customize ETL layer using Apache Pyspark Python
scripts to extract and load data into data warehouse by creating data pipeline with the help of
Elastic search to develop data driven Applications using Angular.
• Development of Oracle Forms and Reports.
• Configuration & Implementation of Oracle 12 c Fusion Middleware ERP forms &
reports using Oracle & JSP.
• Administration of Different Database including Oracle, SQL Server, PostgreSQL by
creating solutions of Failover, Backups, Monitoring and Optimization.
• Deployment of different software application in IIS and Nginix Server using Windows
& Linux Servers.
• Coordinate to implement integration solution of different software’s i.e FIA
Immigration system, FBR payment with Registration of Devices system.

Deputy Executive Officer Database at Punjab Safe City Authority Punjab Police Integrated Command & Control, Pakistan
  • Pakistan - Lahore
  • June 2019 to June 2020

Work closely with Project Managers and Stakeholders to provide efficient solutions.
• Analyze the business flow, use cases and changes to design architecture, user
interfaces and data models.
• Preparing different Software Documents & RFPs for stakeholders.
• Designed Crime board Business Intelligence Application for prediction of crimes in
different areas using Python and Machine learning Algorithms.
• Lead to Develop and manage different Policing Software’s based on .Net Webforms
& MVC & Angular framework by using of SQL Server, mySQL & Oracle databases.
• Working on Face Recognition Alert using, Java, Deep learning, open cv, Python.
• Working on migration of different software from SQL Server and mySQL into Oracle
for higher availability of large data.
• Design Dashboard based on ETL using Open Source Apache PySpark, Licensed
Oracle Data Integration Tools and SQL Server Data Integration Tools.
• Prepare Backup plan and Replication on SQL Server, MySQL & Oracle.

Senior Software Engineer at DigiSkills Virtual University of Pakistan
  • Pakistan - Lahore
  • October 2018 to June 2019

• Work closely with Project Managers and Stakeholders to provide efficient solutions.
• Analyze the business flow, use cases and changes to design architecture, user
interfaces and data models.
• Preparing different Software Development Documents & RFPs for stakeholders.
• Lead to Develop Education Leaning Management System portal like edx, coursia.
Main purpose for this portal (digiskills.pk) to produce 1 million skill persons all over the
Pakistan till 2020. HR Management System, Forum Discussion and online Video Lectures
management portal are main features.

Senior Software Engineer at Netways Technology
  • Pakistan - Lahore
  • August 2018 to October 2018

Work closely with Project Managers and Stockholders to provide efficient solutions.
• Analyze the business flow, use cases and changes to design architecture, user interfaces
and data models.
• Lead to develop Crypto currency boot that is helpful to perform auto trade and generate
revenue for Stake Brokers using .Net Core 2.1, Core Web Api, EntrityFramework Core
and Angular.

System Developer at Al Salam Medical Group
  • Saudi Arabia - Riyadh
  • July 2016 to July 2018

Work closely with Project Managers and Stakeholders to provide efficient solutions.
• Analyze the business flow, use cases and changes to implement architecture, user
interfaces and data models.
• Participates to Develop Health Information ERP by using latest technology including 3
tier architecture, Asp.Net web forms, SQL Server 2014 & Crystal Reporting with TFS
based Server.
• Assist Team Lead to design Solution Architecture to manage Business logic and
application with Security.
• Working on Patient Registration Module
• Participated member to develop Queuing Patient system using Asp.net & WCF services.
• Develop Dynamic form-based Survey Management System
• To develop Message Centre for Sending and receiving internal messages, notification and
especially on time reminders with in application.

SSA / Project Coordinator at Punjab Police
  • Pakistan - Lahore
  • January 2015 to July 2016

Work closely with Project Managers and Stakeholders to provide efficient solutions.
• Analyze the business flow, use cases and changes to implement architecture, user
interfaces and data models.
• Coordinate to develop IGP 8787 police complaint center Application in Asp.Net and successfully
deploy Computerized Policing Complaint & Record Management System to deploy it in
all Police Stations in Punjab.

Software Engineer at Willing Ways (Smart Solutions)
  • Pakistan - Lahore
  • September 2011 to December 2014

Develop & Implement Hospital Management Information System in Asp.Net.
Develop dynamic websites to promote company profile.
Promote website using Digital Marketing & SEO.

Education

Master's degree, Computer Science
  • at Riphah International University
  • July 2023

18 years of Education in Artificial Intelligence, Data sciences & Research work

Bachelor's degree, BS Information Technology
  • at University of Education Lahore
  • February 2014

4 year Bachelor of Hons Program to polish skills in Programming, Databases, Data structure, Project Management, Networking and Server Administrations

Specialties & Skills

AngularJS
SharePoint
ASP.NET MVC
Web Development
Telerick Tools
Crystal Reporting
Entity Framework
MS Azure
TFS server
Bootstrap
Asp.Net
UML & OO Design
Javascript/Jquery
NEST.JS
Deep Learning
Chart.Js
DevOps & Automation (Junkin)
SAP S/4 Hana
Angular
.Net Core 3.1
Agile/Scrum
SAP ABAP
SAP BI/ BW
Windows Server 2012 & 2016
SQL Server
Apache PySpark
Angular Ionic
Redmine/Mentus
Open CV
Machine Learning
Oracle 12 C Middle ware Form & Report Builder
Power BI Server
PostgresSQL
Elastic Search (ELK)
Ubuntu, Kali & Centos 7.0

Languages

English
Intermediate
Urdu
Native Speaker
Arabic
Beginner

Training and Certifications

Human digital Interaction (Training)
Training Institute:
Information Technology University
Duration:
40 hours
1 year Certificate in Cyber Security (Training)
Training Institute:
NIAIS
Date Attended:
September 2020
1 year Certificate in Cyber Security (Training)
Training Institute:
NIAIS
Date Attended:
September 2020
Microsoft Azure Administration (Training)
Training Institute:
System Limited
Date Attended:
December 2019
MCSD (Certificate)
Date Attended:
May 2014
Valid Until:
May 2016
MCSE (Certificate)
Date Attended:
November 2010
Valid Until:
January 2011