Hossein Hajiaghaei

I collected unstructured data from SharePoint Online and Excel and organized it into a structured database. I designed Power BI reports for the HR manager and the board of directors, enabling precise monitoring of driver productivity, vehicle sanitization processes, and staff training. Non-compliant drivers were identified, and overall productivity increased by 50%.

A large petrochemical company in Iran underwent a comprehensive ETL process, followed by the design of highly professional reports for the production, inventory, and finance departments. After interpreting these reports, I uncovered several criminal activities, leading to the recovery of millions of dollars in stolen funds. Additionally, numerous flawed processes were identified and corrected. This effort significantly reduced the workload of the finance team.

The scattered nature of data sources had made decision-making based on data nearly impossible. I designed the process for consolidating, cleansing, and storing the data. Working alongside managers and consultants, I developed and analyzed financial and inventory reports. Now, managers rely solely on these reports for their decisions. The inventory sold off millions of dollars' worth of idle stock, channeling the funds back into production. Several harmful processes in the finance and inventory departments were identified and corrected. Managerial efficiency increased by 50%, and 40% of the financial staff were freed up to focus on analyzing report data after receiving proper training. Exclusive board reports provided complete transparency in sales and inventory operations.