Zeyad Ahmed

Junior Reporting Analyst at Al-Mousa Company

Cairo, Egypt

Al-Mousa Company

Feb 2024 - Present -1 yr, 4 months

Egypt , Cairo

Job Details:Data Analysis & Reporting: • Generated daily sales performance reports using Excel and Google Sheets, analyzing data from 200 transactions per day with Pivot Tables and Pivot Charts to identify trends and high-demand areas. • Conducted product performance analysis using Pivot Tables and Pivot Charts, identifying the most in-demand products based on actual sales data, which contributed to optimizing display and pricing strategies. • Developed employee performance reports using Pivot Tables and visual charts, helping management improve evaluation accuracy by 15% and increasing team engagement. Process Automation & Excel Optimization: • Automated tasks using VLOOKUP functions to pull data from multiple sources, reducing manual data entry time by 40%. • Designed a comprehensive treasury sheet in Excel to track company expenses, reducing calculation errors by 30% and improving overall team efficiency. • Developed a payroll sheet using Excel and Google Sheets to consolidate deductions, bonuses, and absences from multiple data sources, contributing to error reduction and streamlining the payroll process.

Raya Holding for Financial Investments

Feb 2023 - Feb 2024 -1 yr

Egypt , Cairo

Job Details:Performance Reporting & Analysis (Training and Skill Development): • Assisted in preparing weekly performance reports for 20 service centers and showrooms, as part of a development opportunity to enhance my reporting skills. • Analyzed 30 customer complaints daily using Excel to identify recurring issues, providing insights for improving service quality as part of my skill development. • Contributed to improving reporting techniques by using Pivot Tables and Charts in Excel, reducing report generation time by 25%, as part of my ongoing professional development. Quality Monitoring & Training (Skill Development): • Monitored customer service quality standards to better understand service performance and contributed to a 10% improvement in customer satisfaction, under the guidance of my manager. • Participated in training sessions to learn how to use Excel for reporting, helping to accelerate my skills and integration into the team by 20%.