Ammar Allam Portfolio




Greetings!
Explore my portfolio, where you'll discover a proficient BI Specialist & Data Analyst adept in SQL, PowerBI, Power Builder, SSRS, Excel, and Python.
Access my digital channels by clicking on the menu button.

Work Projects at Comsys

    Technologies

    SQL Server, Power BI, Power Builder, and EazyCode

Design interactive customer service operations dashboard in Power BI, offering real-time visibility into team and department performance metrics, facilitating data-driven decisions.

Develop user-friendly database management system and desktop application with EazyCode tool, simplifying ticket data management for service admins without direct SQL Server interaction, streamlining customer service operations.

Enhance restaurant's (POS) and hotel's dashboards using Power BI and SQL Server and implementing database triggers for data integrity and dynamic visualizations, aiding informed decision-making.

Create modernized paginated reports for restaurant and hotel operation systems, utilizing Power Builder and SQL Server stored procedures for comprehensive insight, which improved client satisfaction by 30%.

Implement Multi_language reporting capabilities, allowing users to select preferred language parameters within reports, ensuring inclusivity across diverse user bases.

Address hotel chain management's critical reporting challenge by developing stored procedures with hotel-specific database parameters, providing customized reports for each property from a centralized location, enhancing oversight and decision-making and enhanced operational efficiency by 40%.


Database Management System

I emphasized essential components such as ERD, Mapping, OLTP, and Data_Warehouse. By utilizing SSIS, SSAS, and SSRS, I successfully implemented data integration, analysis, and reporting functionalities. This project highlighted the significance of these tools in facilitating efficient decision-making and providing valuable data-driven insights for organizations.


Sales Management

I focused on fulfilling a business request for an executive sales report targeted at sales managers. I followed user stories to maintain acceptance criteria throughout the project. By utilizing SQL, I extracted, cleaned, and transformed data from the database to create a robust data model. The result was an insightful and actionable sales report, providing valuable information to empower sales managers in making informed decisions for business growth.

Customer Satisfaction Analysis of Reviews

I am delighted to present the analysis of the Amazon Fine Food Reviews Dataset, included approximately 500,000 reviews. The main objective of this analysis is to gain insights into customer satisfaction levels and understand their evaluations of various products. Through rigorous examination of the dataset, we have uncovered valuable information that sheds light on customers' sentiments and experiences with Amazon products.

CLTV Analysis using Python

Customer Lifetime Value (CLTV) analysis is a crucial tool for businesses seeking to understand the long-term value of their customers. By estimating the total value a customer brings to the business over their entire relationship, CLTV analysis guides strategic decisions regarding customer acquisition, retention, and resource allocation.