Yehia Haqqi

I am a commercial professional with 5+ years of experience in data analysis, pricing strategy, sales operations, and performance management within Egypt's competitive home appliance, mobiles and Lighting products market. I have expertise in analyzing sales trends, competitor benchmarking, and inventory performance to support category growth and product planning. I have Skills in assortment planning, pricing and discount analysis, and KPI-driven performance tracking across large-scale retail networks and the distribution sector.

Combines strong analytical capabilities — leveraging Power BI, Excel, Looker and CRM tools, with hands-on retail expertise to deliver actionable category insights that influence buying decisions, optimize product mix, and drive measurable business results. Adept at cross-functional collaboration with sales, marketing, and supply chain teams to align category strategies with market demand and organizational objectives.

Commercial Support Analyst - Senior Specialist at Kanawat for Trading & Distribution (2021-12 – Present)

• Analyze sales performance across all product categories including home appliances, mobiles, air conditioners, and lighting, using advanced KPIs and dashboards.
• Monitor and evaluate inventory performance through dedicated inventory KPIs, identifying slow-moving and non-moving items and presenting actionable recommendations to management for clearance or supplier returns.
• Track inventory age and movement to minimize dead stock and optimize inventory health across all categories.
• Develop and maintain a comprehensive Brand Master Plan covering purchasing timelines, stock coverage forecasts, and product mix optimization per sub-category.
• Identify which sub-categories to pause or replenish based on sell-through rates and market demand.
• Provide deep brand-level insights through integrated dashboards to support strategic buying decisions.
• Analyze pricing structures and discount schemes across all product lines to ensure margin protection and competitiveness.
• Review and approve discount requests submitted by the sales team for key accounts "OR and IR accounts" ensuring profitability thresholds are maintained.
• Prepare end-of-month discount utilization reports, presenting profitability analysis per product, item, and account.
• Set competitive pricing for new products such as Armadillo brand, leveraging market intelligence and benchmarking in collaboration with the Product Manager.
• Lead annual, quarterly, and monthly sales forecasting processes, tracking forecast accuracy and reporting basis analysis.
• Coordinate with sales, marketing, and product management teams to align on pricing and volume targets for upcoming periods.
• Submit finalized demand plans to the production team to ensure manufacturing alignment with projected sales.
• Calculate and process commissions for all sales personnel including retail staff, key account managers, promoters, and distributor channel salesperson.
• Manage sell-out commissions for trade partners based on actual end-customer sales.
• Administer price protection compensation in cases of market price reductions.
• Design and execute incentive competitions in coordination with senior management, including (Umrah trips, European travel rewards, and gold cash prizes).

Sales Support and Operations Specialist at Kanawat Telecom (2021-12 – Present)

• Prepare daily closing payment reports for consignment shops.
• Prepare E-Top up Variance report between Ax and Win Cash System.
• Prepare a Sales Analysis report every month and show a profit for every item.
• Prepare weekly stock on hand in non-consignment shops for orange management.
• Prepare daily stock reports based on management view, design & requirements for non-consignment andconsignment shops.
• Report any fraud behavior on the system.
• Report for pending transfers to the area manager to close them.
• Transfer Airtime between stores and different channels.
• Monitor actual Airtime balance, bill payment budget & Orange cash versus system daily.
• Transfer products on the system between shops.
• Communicate any price change to retail staff and finance team.
• Make Orders for All orange product balances depending on business needs.
• Calculate commission for all Agents, shop managers, and retail management team.
• Prepare and communicate targets & sales (stores & individual).
• Handel any Orange request or task needs.
• Managing online orders & fulfillment
• Coordinating between warehouse and online platforms
• Handling returns & customer complaints online
• Updating product listings & pricing
• Report on online sales performance
• Working with platforms like Noon, Amazon, or the company's own website.

Senior Sales Coordinator at Raya Holdings, Raya Trade (2019-05 – 2021-12)

• Act as the primary point of contact for the sales team to ensure all inquiries, requests, and issues are resolved efficiently.
• Coordinate sales activities, including order processing, shipment tracking, and managing customer accounts.
• Assist in the preparation and distribution of sales proposals, contracts, and presentations.
• Maintain and update customer and sales data in the CRM system, ensuring accuracy and completeness.
• Generate sales reports and dashboards to track team performance, sales targets, and customer trends.
• Analyze sales data to identify opportunities for growth and improvement.
• Work closely with the customer service team to address client inquiries, resolve complaints, and ensure a high level of satisfaction.
• Support the sales team in managing key accounts and maintaining strong client relationships.

Sales Promoter (Marketing SFO) at Samsung Mobile and Electronics (2017-03 – 2019-05)

• Responsible on Management and development of projects: in-store activities, events, samplings, and roadshows.
• Setup Campaigns Strategy and trying to achieve it through BTL.
• Responsible for Roadshow and Events.
• Responsible on all BTL materials, set and negotiate the prices of BTL and outdoors printing, constructions distributions & renting.
• POP merchandising, compliance checks and related reporting.
• Responsible for assessing the shops and choosing the advertising method to be used in them.
• Responsible for all production (Shops' signs, vinyl etc.... ).
• Assisted with the installation, maintenance and technical support for merchandising demo units.
• Trained retail Staff on the Brand product at a store level, large meetings, and national conferences.
• Attending trade shows and exhibitions when required.
• Collecting all the information required. (market news)
• Organized around 50 roadshows in more than 15 governorate allover Egypt.

Bachelor of Arts in Oriental Languages Department – Cairo University (2016)