Hamza Ayari

Data Analyst, Bi Developer

I am a Data Analyst , Bi Developer and a Problem solver!, Passionate about Data and Technology in general, proficient at creating Dashboards, Reports, Forms, Automation Softwares and much more...

Let's Begin

My Work

Data Analysis

ETL (Extract, Transform and Load) data from all different sources (Excel files, text files, Data bases, JSON files, APIs...) . Creating Dashobards, Reports and KPIs using various tool like Power BI, SQL and Python and Excel for usefull and automated and up to date Reports.

Business intelligence Development

Creating Python scripts and transforming them into Desktop programs with graphical user interface (GUI). The created Programs can be for Data Cleaning or for automating repetative tasks and more.

Web Development

Creating static Websites & Web applications using Pythons libreries such as Django and Flask

Few Of My Projects

portfolio img

Human Resources Master report

This master Power Bi dashboard with 30+ pages had all the necessary info that the department need and it helped facilitate the daily task of the HR professionls by allowing fast and easy access to all the data (General info, Headcount, Payroll, work patterns and FTE, Tenure, pension, contracts...).

portfolio img

Recruitment Report

This recruitment report uses public APIs provided by the recruitment platform,so there is direct connection between the recruitment platform and the dashboard wich provide usefull and up to date information for recruiters and managers.

portfolio img

Absenteeism and Sickness Report

This report uses sickness and Absenteeism data to help track the overall well being of the employees in different departments.

portfolio img

Surveys Results Reports

After designing and creating the survey, the collected data was used to create usefull reports for the Business.

portfolio img

Azure User Accounts

This report was created for the IT department to help keep track of all the user accounts in the tenant, using data from the Azure infrastructure portal.

portfolio img

Company Devices Report

This report uses also data from Azure IT infrastructure portal to help keep track and monitor all company devices.

portfolio img

IT Security Reports and KPIs

This report uses the exported data from the Intune portal to monitor the compliance and safety of user accounts and devices.

portfolio img

IT Requests Tickets KPI Analysis

The Data of this report was cleaned using Python scripts and programs for more efficient analysis.

portfolio img

Incident Ticket Analysis Report

This report was done with the help of data cleaning software to keep track of the received ticket and the quality of service.

portfolio img

Servers Migration Report

This report was created and automated using advanced Excel.

portfolio img

Plant Printing Report

This Report was created then automated using SQL Procedures and jobs .

portfolio img

Company Average TTR report

Migrated the company average TTR and SLA report from excel to powerBi.

portfolio img

Helpdesk team Shift management Tool

This Python program Helps with creating the shift repartition for the Service desk Team for a given period of Time.

portfolio img

Payslip Sender

This Software was created for the HR department to parse data from payslips and Presence sheets then send hundreds of them to all company users in few minutes, this process used to be done manualy in the company and it usually take days.

portfolio img

Workload division

This software takes the entire team workload extracted in CSV form from the ticketing systems and divides it evenly between team members based on availability and type of workload.

portfolio img

Data Cleaning Software

This Software cleans up Data from multiple resources for Power BI presentations to weekly save Hours of Data manipulation and provide more precise and almost Error free Data.

portfolio img

VPN Sending Software

This Software also created with Python automates the task of sending VPN configuration files to the end user via email.

portfolio img

Document Filler

This Tool can save hundreds of hours worth of filling documents and contracts by hand, it is simple and intuitive, you select a template with place holders that matches the excel file that has the necessary information and then the Magic happens! .

portfolio img

Portfolio Website

This Portfolio Website is created by me and hopefully more will come in the future.

portfolio img

Service Desk team Documentation Website

This website was created as a documentation portal for the service desk team of the company, it was created using Flask,html and css .

portfolio img

Plant production Documentation Website

This website was created as a documentation portal for the production department of the company to host pdf documents for cutting machine operators, it was created using JS,html and css .

portfolio img

Ticketing System with Django

This ticketing webapp is created with Django Python framework, it has full CRUD fuctionality and user Authentication and related to an IT admin portal .

My Profile

Name Hamza Ayari

Birthday July 11, 1993

Address 33 DH Mannouba,Tunisia

Phone +216 53 288 123

Email Ayarihamza939@gmail.com

Website https://ayarihamzaa.github.io/Portfolio_Website/

Some Skills

Team Player with strong communication skills and sense of Leadership. Always eager to Help others and learn more and more everyday. ITIL V4 Foundation Certified.

Reporting : Power BI, Advanced Excel, Power Query

Programming and Automation : Python, SQL, C#

Web Development : Django, Flask, Java Script, HTML, CSS

Other skills: Power Platform, MS365, Sharepoint, MS Forms, Jira

This is me

Data Analyst & Bi Developer

Passionate about data analysis and business intelligence technologies, and their significant positive impact on all types of businesses...

GitHub

Copyright © 2022 Hamza Ayari