Muhammad Hamza Irfan

BankIslami Private Limited | Business Intelligence Dept

WORK

Business Intelligence Dept
BankIslami Private Limited

    Work closely with business stakeholders at BankIslami to identify their data analysis requirements and translate them into actionable insights. Design and implement Power BI dashboards, reports, and applications that simplify complex financial and operational data for better decision-making. Develop interactive charts, graphs, and visualizations to empower users with self-service analytics. Configure and maintain the Power BI Report Server for on-premises deployment, ensuring secure and efficient report accessibility within the organization's infrastructure. Oversee data modeling, extraction, transformation, and loading (ETL) processes to facilitate seamless data integration. Optimize Power BI applications for improved performance and responsiveness while ensuring data accuracy, consistency, and quality. Collaborate with data engineers, analysts, and business teams to fulfill the organization's reporting and analytical needs. Stay informed about the latest Power BI updates, industry trends, and best practices to continuously enhance analytics solutions and drive data-driven decision-making at BankIslami.

Current Position

Executive B.I. Analyst
International Brands Limited (Searle Pharmaceuticals)

    Work together with business partners to understand their needs regarding data analysis as well as gather requirements. Create and implement Power BI dashboards, reports, and applications that efficiently and comprehensibly display complicated data. Make interactive graphs, charts, and data visualizations so that people may examine and evaluate the information on their own. To guarantee precise and effective data integration into Power BI applications, carry out data modeling, data extraction, transformation, and loading (ETL) procedures. Applications for Power BI should be tuned and optimized for better responsiveness and performance. Verify the accuracy, consistency, and quality of the data in Power BI apps. Work together to meet the data analysis and reporting needs of cross-functional teams made up of data engineers, analysts, and business users. To consistently developp Power BI applications and solutions, stay current with the newest features, upgrades, and market trends.

Feb 2024 - Oct 2024

Officer B.I. Analyst (IT Dept) (Placement)
Adamjee Life Assurance Company

    Collaborate with business stakeholders to gather requirements and understand their data analysis needs. Design and develop Qlik Sense applications, dashboards, and reports that effectively present complex data in a user-friendly manner. Create interactive data visualizations, charts, and graphs to enable end-users to explore and analyze data independently. Perform data modeling, data extraction, transformation, and loading (ETL) tasks to ensure accurate and efficient data integration into Qlik Sense applications. Optimize and tune Qlik Sense applications for improved performance and responsiveness. Conduct data quality checks and ensure data integrity and consistency within Qlik Sense applications. Collaborate with cross-functional teams, including data engineers, analysts, and business users, to support their data analysis and reporting requirements. Stay up to date with the latest Qlik Sense features, updates, and industry trends to continuously improve Qlik Sense applications and solutions.

Apr 2023 - Jan 2024

Officer Persistency/B.I. Analyst (Banca) (Placement)
Adamjee Life Assurance Company

    Following up on all persistency related matters for business renewal growth. Generating and sharing persistency related reports to the sales team and channel partners. Collaborated with the tech / IT team on persistency related open portal that was accessible to the sales team. Exploring on different ideas and generating different reports / dashboards that highlight the productivity of the business in different fields. Maintaining a strict follow-up on all document delivery related matters that ensure business goodwill. Maintaining and sharing daily business report with sales and channel partner. Ensuring high level of efficiency by trying to implement more cost effective and efficient processes in daily routine tasks with collaboration with IT team. Collaboration with all interlinked departments that are associated with the policy issuance process.

Jun 2022 - Mar 2023

Associate - B.I. Analyst (Banca) (Placement)
Adamjee Life Assurance Company

    Specialize in generating on demand dashboards that outlay business growth. Proper Command on initiating and implementing dynamic business trackers that focus of different aspects of the industry. Maintaining and sharing daily business report with sales and channel partners. Correspondence with sales, underwriting and channel partner regarding pre issuance Banca assurance quires. Maintain the record of requirements shared by the sales or channel partner. Maintain the record of physical cases received from channel partners. Generate reports of pending business on demand.

Jan 2021 - May 2022

Project Associate
Adamjee Life Assurance Company

    Maintaining and sharing daily business report with sales and channel partner. Correspondence with sales, underwriting and channel partner regarding Banca assurance and Investment services queries. Investment Services new business processing. Maintain the record of Investment Services cases processed. Maintain the record of requirements shared by the sales or channel partner. Maintain the record of Investment Services cases dispatched. Maintain the record of physical cases received from channel partner. Handling dispatch queries regarding Investment Services. Handling pre issuance queries regarding Investment Services. Manage cancellations of Investment services except policy level cancellation. Generate weekly report of Requirements processed and cases processed. Supervise Banca assurance new business processing. Supervise Banca assurance pre issuance queries.

Mar 2020 - Dec 2020

Internee
Adamjee Life Assurance Company

    Maintaining and sharing daily business report with sales and channel partner. Correspondence with sales, underwriting and channel partner regarding Banca assurance queries. Banca assurance new business processing. Maintain the record of Banca assurance cases processed. Maintain the record of requirements shared by the sales or channel partner. Maintain the record of physical cases received from channel partner. Handling pre issuance queries regarding Banca assurance.

Nov 2019 - Jan 2020

PHP Developer
Kingdom Vision

    Create backend logics. Working on PHP framework codeigniter. Create dynamic pages using Jquery. Design dynamic back-end using AJAX. Use of database MySQL. Create intractable UI using Jquery UI. Client side validation with Jquery Validate.

Jul 2019 - Oct 2019



EDUCATION

Bachelor (B.Com)
National Collage for Men

IN PROGRESS

ACCP Pro Diploma
Aptech Computer Education Shahra e Faisal
3 Years Diploma

Feb 2016 - Nov 2019

HSC Pre Engineering
Govt. Degree Collage for men Buffer zone

May 2012 - May 2014

Matriculation
Usman Public School Campus IX

April 2010 - April 2012


SKILLS

Microsoft Excel


Microsoft Power Bi


Php


Codeigniter 3


Codeigniter 4


laravel


UI Path


My SQL


Qlik Sense


Arduino


IOT


C++


Java Script


C#


HTML/CSS



PERSONAL PROJECTS

Smart Door Key

  • Enable user to remotely unlock the door over the internet via virtual assistants like Google Assistant, Amazon Alexa, Apple Siri, ETC.
  • Include local web server in order to unlock the door over LAN in case of internet failure.
  • It include with a proper logging system every time the user unlocks the door it will get logged in the database, not just that it will also log WiFi username and passwords along with some network errors.
  • Language used: C++, PhP | Database used: MYSQL | Hardware used: Node MCU.

Smart Jacket

  • Extracts all medically essential vitals such as heart rate, bloody oxygen levels, body temperature & body movement via step detection.
  • It’s an artificial medical hub on consumer fingertips to cater the physically conscious target audience.
  • It maintains a data register using JAVA file system and prepares consumer timely reports for better insights on an app.
  • Language used: C++, JAVA, XML. | Hardware used: Arduino Nano, HC-05 (Bluetooth Module), MAX30100 (Pulse Oxy-meter), Thermistor (Body Temp) & MPU 6050 (Gyro Sensor).

Vehicle Tracking System

  • Track vehicle using and android app over the SMS, all SMS sent or received are encrypted.
  • Tracking include the real time location (5m Accuracy), real time speed and heading.
  • Will add geo fencing feature in the future prototype.
  • There are some auxiliary controls such as engine start notification, battery disconnect notification and switch off/on engine control.
  • It has an emergency battery backup system which last up to 2 days while continuously broadcasting its current location and state.
  • Language used: C++, Java & XML | Hardware used: Sim 808 GSM/GPS Module & Arduino Mega.

Event Management System

  • Project acquired by Events organizing companies.
  • Project purpose is to record event details against unique user IDs.
  • Event details include Client information, venue information, date, day and time.
  • Events alerts found when events are close. (reminder system)
  • Language used: Java, Microsoft SQL.

Advertisement Beacon

  • Enable the brands in the malls to broadcast their promotional advertisements to real time consumer’s mobile phones via Bluetooth.
  • Location based app which have advertisement tools to flourish sales activity.
  • Language used: C++, JAVA & XML | Hardware used: ESP32.

Clinic Management System (CMS)

  • Relation between patients and doctors in the sense of manipulating appointment and treatment dates and information.
  • Patient Panel: Take appointments, cancel appointments and view treatment history.
  • Admin Panel: Create update patient, create treatment, create appointment, view and edit panel, can view and respond to public and registered users queries, add expense, view and manage accounts.
  • Language used: HTML, Core PHP, JavaScript, JQuery, Bootstrap | Database used: MYSQL

Jewelry Gallery (Static Website)

  • Web showcase of a jewelry store, where users can compare prices and types of jewelry.
  • Purpose: advertisement.
  • Language used: HTML/CSS, JavaScript, JQuery.

Xbox Games

  • Application used to display Xbox Games and their specification and has dynamic search.
  • Language used: C#, XML.

CONTACT

Email
[email protected]
[email protected]

Adress
1-A73 Ettawa Society
Sector 52-A, KDA Scheme 33
Karachi, Pakistan.

Phone
+92-315-1303531

Social Links

CONTACT FORM

Your message has been sent. Thank you!

© Copyrights Zahaus Tech www.zahaustech.com . All Rights Reserved