Mohamed T.

Experience

• 

  Orange

  Mar 2015 - Dec 2016

  Reporting Analyst

  1-Develop new reporting tools for the Retail, TAM & Franchise Agents for to ensure accuracy of the submitted figures and to minimize time consumption.2-Maintain the relationships between the databases, solve any identified issues. Maintain claims database using SQL program working with large databases.3-Maintain & secure the database by reducing the risk of missing suspicious activities.4-Provide the necessary information about how to deal with the Access tool to the SIRA team to submit their reports successfully without any discrepancies.5-Try to implement continuous auditing & backups to protect the database environment to ensure complete visibility across the databases.6-Designing forms & queries on the MS Access tool to facilitate the data entry.7-Validate and handle Gross Adds KPI in the quarterly sales incentives plan for the SOHO segment.8-Submit the franchise monthly achievements and calculate the relevant commission on all levels (Authorized agents, Shop Managers, representatives).9-Responsible for providing a periodic global KPIs analysis to the segment management.10-Collect, analyze, validate & issue the Acquisition KPI for sales incentive plan (SIP) for the SOHO segment sales employees.11-Providing the retail and franchise team with the weekly achievements that they attained to keep them on track with their figures.12-Daily tasks involved extensive use of MS Excel and MS Access.13-Maintain database quality through periodic revisiting of all discrepancies identified by extracted reports to ensure accurate payout to sales staff as well as the franchises commissions.14-Act as the interface with the data base teams to provide the required reports for the SOHO segment in addition to the quarterly SIP inputs.15-Presenting weekly and monthly sales reports, with a focus on KPI targeting and trending analysis, to the board of manager and head of the sales development. Show less

• 

  IQVIA

  Jan 2017 - Sept 2018

  Data Analyst

  1- Collect, review & analyze the sales data reports to ensure objectives are being met.2- Responsible for a numerous of distributors to ensure providing the sales data.3- Responsible for saving account vendors & maintain the relation with the distributor’s.4- Conduct quantitative and statistics analysis to track and monitor the health care market. Built multiple scenarios to each client and led presentations to recommend distributor’s and products.5- Supported research insights with quantitative analysis of datasets using MS excel.6- Collaborate with the marketing offering team & the sales team to handle any of requested information they need & to provide data analysis reports.7- Providing monthly reports to our client’s displaying their market share, product’s growth and droop by geographic criteria. Show less

• 

  Mantrac Group

  Oct 2018 - now

  1- Gather and evaluate relevant market and competitor information to review market position and determine threats and opportunities.2- On-going competitive intelligence gathering including risks and opportunities for growth in various markets.3- Perform analysis of the data provided by syndicated market research companies (product details, shipments, models, price.) to identify trends and insights that can affect company planning and decision making.4- Fueling the business unit managers across the group (east & west Africa) with the upcoming projects that would benefit their sales performance.5- Applying data cleansing and automation to all raw data coming from third party provider to minimize time consumption.6- Develop clear, accurate and timely reporting solutions for both internal and external customers.7- Monitor Business partnering KPIs and proactively alert management about any issues and potential risks. Show less 1- Data combining from internal databases and external third parties to create and maintain a live feed of market sizing database, including but not limited to market competitors.2- Produce periodic report for all construction segments (New & Used machine sales) with active economic & political insights on all AME market (East & West Africa).3- Analyze and interrupt trends and patterns in the database, as well as providing clear ad-hoc analysis and report.4- Tracking the new and the upcoming projects in all AME and reported to the sales team in order to qualify new leads. Show less

  • MI Senior Construction Data Analyst Analyst

    Sept 2022 - now

  • Group Construction Market Intelligence Analyst

    Oct 2018 - now