Hady Shaaban Attya

Analytics lead || Senior data scientistFull Time

• Job Details:• Increased Retail store conversion by 50% through an automated accurate tracking tool for 180 stores across Egypt. • Operationalize retail analytics through processes of store morning brief and proper documentation and action plan • Built a retail-scoring system that helped to focus on stores in terms of all KPIs (Conversion, AOV, ASP, SSQM, Sales, DOH, Quartile) blended in one metric resulting in healthy growth and proper performance segmentation. • Reduced lost opportunity by around 200M every month & reduced DOH by 50% to be 16 days (14 is the consumer electronics benchmark) throughout automated dashboard that track excess stock and lost opportunity, ABC, turnover, zero stock, and GP. • Built a digital marketing dashboard for Facebook and Google ads end to end from building the API to the visualization and insights generation that helped to optimize the digital spend budget. • Build web-scrapping tool that ended up to a price index live dashboard for the A class items. Helped in stock optimization, CVM activities and GP maintaining. • Worked as a liaise and senior scientist in McKinsey advanced analytics projects as below: - Price automation/optimization. - CVM , recommendation and propensity engines - Credit risk engine. - Demand volume forecasting model. • Assisted in the creation of a data warehouse for all B.tech data sources used for sales, stock, and digital metrics,..by clear documentation for KPIs. • Built an alerting system that helped in tracking web events to take corrective actions proactively mainly for ordering event and cart abandonment corrections. • Built analytics team of 7 analysts with proper handover and orientation in addition to the needed support for them till ramping up.

Supply analytics leadFull Time

• Job Details:Measuring level of customer & captain satisfaction on a daily basis to improve business performance and productivity, provide conclusions to customer and captain experience teams. That’s for different segments, markets, layers… .  Analyze daily performance of customer service agents via set of KPI’s. Customers’ satisfaction, reachability, Agent satisfaction, Agent passionately, Issue resolution, SLA…. .  Analyze daily dissatisfaction, provide reasoning per segment for more improvement.  Provide automated scripts for customized daily, weekly, monthly reports required via different tools.  Analyze credits and waivers for customers and captains relative to gross revenue on a daily basis per different segments.  Develop automated visualizations for performance dashboards at tableau.  Assist in building data warehouse for customer care analytics passing by different phases ( business questions , dashboards’ documentation , data dictionary , validation of accuracy …)  Analyze performance of automated templates / macros versus agent’s performance regarding satisfaction & Issue resolution.

Senior Service Data Analyst/Planning & MarketingFull Time

• Job Details:Prepare Monthly Sales Performance Reports for All12 Branches (Opel & Chevrolet).  Evaluate Service Centers KPI.  Analyze Retention Figures and prepare reports.  Prepare & analyze Productivity Reports.  Analyze Case Studies for Upcoming Campaigns (Passenger & Commercial).  Develop Specific / National marketing and sales campaigns.  Evaluate Performance & Effectiveness of service Campaigns.  Perform Market Surveys – Service Like to Like Analysis with competitors through site surveys.  Conduct market research with competitors and monitoring their activities.  Plan for service marketing activities (Artwork, IVRs, SMS, Social Media, Radio Ads .etc.).  Communicate with service managers, parts team and marketing team for suitable campaigns and promotions.  Cooperate with Marketing Dept. in business case study for Loyalty Program.  Prepare the required data for new service dept. launching.  Preliminary semi-annual budget proposal (Forecast) for all branches.  Revise Head counts to adjust Direct / indirect workforce. Mobile 0201143076926 Email hadyshaaban@yahoo.com  Create and Maintain Service Department Data base and Templates.  Collect and analyze service data to provide service presentations and reports.