Ahmad Zaid Alkilani
Amman
Summary
As a data analyst , I convert data into facts that can assist stockholders and managers to take important decisions at the company. I mainly cooperate with accountants and human resources to help them with applications that can track the daily transaction and employee progress using recent technologies such as power bi , python and AI tools for data analytics purposes. as a data analyst , I have faced issues in the business including manual data entry and sync problems in onedrive and therefore , I am looking forward to take a course in onedrive to be able to solve any sync problems and setup onedrive properly so all employees can be on the same page. Also , during my last experience , I improved myself in data analytics field by reading about python and power bi and also improved myself in accounting by taking online courses in youtube in financial accounting and management accounting. Recently , I started creating AI agents and automation workflow that simplify processes at the company I am currently working for.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Data Analyst
04.2024 - Current
- Register the financial bank transaction from the company bank account into the financial record Excel sheet for cost control purposes, using an AI tool and a Python app for mapping with the generated Excel from the AI tool.
- Browse hardcopy invoices using a Python application that can open hardcopy invoices from the OneDrive path on the company server.
- Assist the accountant in calculating the salary loan taken by employees using a created Python application.
- Assist the human resources department in tracking employees' attendance via the Excel attendance tracker dashboard and database.
- Use quick AI data analysis tools such as Julia AI tool and ChatGPT to have a better understanding of Excel data and quick data visualization.
- Assist the accountant in preparing the income statement and balance sheet using the Python language.
- Prepare a financial report via Power BI that includes pie charts, bar charts, and tables summarizing dividends and deposits for each partner in the company, petty cash balances, payables balances, post-dated checks, active guarantees, analysis for cost, revenue, and net for ongoing projects and completed projects, and the total remaining balances for manpower in all ongoing projects and in all completed projects.
- Offered a breakdown of the remaining total balance by typing the name of the manpower using a created Python application.
- Communicate every day with payables vendors to reconcile vendor accounts.
- Created tree category to assist in registering data into structured columns in the Excel sheet.
- Assist accountants in calculating salaries every month.
- Assist accountants in preparing cash flow statements using a Python application and AI tools such as Julia and ChatGPT. ai
- Create an app via Power App software to view the payment method and the number, and to copy the number into Arab Bank without the need to enter payment details manually.
- Create an app that can view the details, such as the main category, subcategory, and the customer name of any number entered in the company database.
- Create a good-looking presentation using an AI tool called Gamma.
Electrical Engineer
AGN
01.2019 - 06.2020
Smart Home Engineer
Luminous Technology
01.2018 - 11.2018
- Programmed control panels for residential projects.
- Assisted technicians in wire termination for electrical systems such as lighting, shutters, and sound systems.
Smart Home Engineer
Living Tech - Traditional Living Redefined
11.2016 - 03.2017
- Programmed electrical system using Smart G4 brand, HDL, and Legrand.
- Assist technicians in electrical work.
Technical Support Engineer
United Pioneering Business
06.2015 - 11.2016
Smart Home Engineer
Spacia System
01.2014 - 11.2014
Education
Technology Management
Westcliff University
Irvine , USA02-2024
Mechatronics Engineering - Computer Programming
Balqa Applied University
Amman02-2013
Skills
- Experienced in Python programming
- Power BI data visualization
- Excel data analysis skills
- Effective communication
- Conversational AI design
- n8n
Accomplishments
- analyzed excel data with more than one million rows and used machine learning algorithms to predict future data.
- prediction of Diabetes possibility using classification models such as keras (tensorflow)
- prediction of breast cancer death possibility using python machine learning classification model
- created power bi dashboard that connect different excel sheet into one single dashboard for cost control
- Created python apps that help accounting department and human resource department
- created smart app for navigating hardcopy invoices using python
- Created sentiment analysis using google form , Google sheet , n8n in which we had much better understanding of employees and manpower perspective.
- created equation in excel sheets to control the downpayments for manpower across all ongoing and completed projects.
Certification
- Python for data science
- Comprehensive accounting.
Languages
English
Professional Working
Timeline
Data Analyst
04.2024 - Current
Electrical Engineer
AGN
01.2019 - 06.2020
Smart Home Engineer
Luminous Technology
01.2018 - 11.2018
Smart Home Engineer
Living Tech - Traditional Living Redefined
11.2016 - 03.2017
Technical Support Engineer
United Pioneering Business
06.2015 - 11.2016
Smart Home Engineer
Spacia System
01.2014 - 11.2014
Technology Management
Westcliff University
Mechatronics Engineering - Computer Programming
Balqa Applied University
Padel, Pickeball, Table tennis, Soccer
- I joined Jordan pickleball club and it is a great opportunity to build friendship and improve connections.