Ahmed Hany

Designed an interactive HR analytics dashboard to monitor workforce data and track hiring progress. Analyzed job vacancies, departmental hiring distribution, job requirements, and candidate acceptance ratios. Built visualizations for hiring timelines, job status, and role classifications to support data-driven HR recruitment and workforce planning decisions.

Performed a churn analysis using Excel to identify key factors behind customer attrition. Analyzed churn patterns across multiple segments including demographics, usage behavior, payment delays, and support interactions. Produced actionable retention recommendations and quantified churn volume at about 250K customers with higher churn among mature, high-usage users.

Created a supplier quality analytics dashboard focused on defect trends across materials and vendors. Combined and cleaned data from multiple Excel sources to keep values consistent and accurate. Visualized defect frequency and supplier-to-material relationships in Excel and Tableau to surface quality gaps for evaluation and process improvements.

Built a dashboard to analyze population growth and cancer mortality trends across multiple years. Cleaned and structured demographic datasets using Excel, then created visual analysis in Tableau. Used the results to highlight long-term patterns and notable anomalies for reporting and forecasting-oriented insights.

Combined data entry and analysis to support daily operations across operational and HR datasets with a focus on data accuracy. Built daily reports for the business owner and HR manager, tracking attendance, task completion, and performance KPIs. Maintained data integrity across operational workflows and HR processes, and created an internal management application for monthly team tasks. Also deployed a desktop automation tool to reduce manual effort and improve reporting efficiency.

Provided customer support and retail sales assistance, resolving customer issues with an emphasis on professionalism and speed. Coordinated with team members to improve customer satisfaction through effective communication. Supported store performance by consistently meeting service quality and sales targets.

Trained participants on foundational mathematics and statistics topics used in data analysis applications. Supported learners in applying statistical concepts with Microsoft Excel formulas and dashboard exercises. Mentored students on using Excel-based visualizations to extract insights from data.

Taught foundational mathematics, statistics, and probability concepts for data analysis. Guided students in implementing statistical ideas using Microsoft Excel formulas and dashboard workflows. Mentored learners in performing statistical analysis and turning results into insights using Excel visualizations.