Ahmed Abdelkader

Experience

• 

  TE Data

  Apr 2013 - Jul 2018

  Workforce Analyst

  Support the Head of the Call Center Operations Management in the design and implementation of a Service Level Agreement concept.Delivering the yearly plans after applying the forecast and plan all needed resources in addition to integrating all marketing and customer service plans.Getting Information - Observing, receiving, and otherwise obtaining information from all relevant sources to achieve the cost-efficiency.Drive continuous improvement of KPI analysis to track and monitor the call center employees' performance reports.Deal with the call center agent vendor's invoice based on contract rules. and count the FTE depend on the full productivity.Headcount management that builds the headcount plan with the goals and budget in mind and sends it for executive review by providing the headcount analysis such as "Hiring, Resigned, Terminated and Attrition efficiency".Give support to the department in such data analysis approaches. Show less

• 

  Telecom Egypt

  Aug 2018 - Oct 2024

  Driving the development and implementation of data strategies, delivering actionable insights to support business objectives, and fostering a culture of data-driven decision-making within the organization.Lead and manage a team of data analysts, providing guidance and support in their day-to-day activities.Serve as the primary point of contact for all phases of analytic projects.Define key performance indicators (KPIs) and develop reports to track and measure performance based on these metrics.Promote the use of analytics to drive continuous improvement and innovation across the organization.Plan and build self-service capabilities to empower business owners with relevant data, enabling them to gain insights and analyze data independently.Enhance our customer 360 platform with advanced analytics, providing call center users with valuable insights to handle customer interactions intelligently.Provide deep analytics to the network planning team to optimize the distribution of network components.Manage Customer Value Management (CVM) campaigns and support the provision of figures that demonstrate the efficiency of these campaigns. Show less Collaborate with top consulting firms like McKinsey, Detecon, and Logic, delivering advanced reports to support their strategies and project implementations in the data field.Create and maintain a comprehensive C-level dashboard encompassing 200+ KPIs across all company sectors and customer journeys.Support marketing stakeholders by developing decks for business monitoring and automating repetitive tasks.Perform in-depth analysis of performance, customer, and network-planning data to generate detailed assessment reports highlighting strengths and areas for improvement.Manage high-quality predictive intelligence models to support marketing strategies, decisions, and churn detection.Develop various segmentation models (micro-segmentation, value-driven, behavior-driven) to aid commercial decision-making at all levels.Utilize data mining, segmentation, and modeling techniques to enhance subscriber ARPU.Generate prescriptive, tactical, and strategic insights to boost marketing effectiveness.Conduct financial analyses to identify growth and savings opportunities, leveraging diverse data sources such as CDR data, website/mobile app tracking, CRM, purchasing data, media campaigns, customer satisfaction, and turnover.Perform analyses including:Revenue VarianceNew, Repeat, and Lost CustomersCohort AnalysisMarket Basket AnalysisCustomer Lifetime Value (CLV)Profitability MatrixPareto AnalysisDesign and implement data and analytics solutions using Power BI and other BI tools.Integrate and link data from various source systems.Visualize insights in intuitive dashboards for diverse stakeholders. Show less Contribute to the implementation of the IT strategic research and data management strategy and plans as befitting the division and business line needs and objectives.Collect and review reports from relevant entities and ensure their accuracy for the best use of data.Carry out deep analysis of the facts finding reports summarizing performance facts, customer-related facts, network planning facts, and other facts for the development of results assessment reports showing strengths and areas for improvement.Participate in the development of analysis reporting templates for standardized and efficient results.Perform research and development in direct coordination with the division head for the continuous identification of new analysis techniques.Implement IT strategic research and data management policies and procedures in order to ensure all relevant requirements are fulfilled whilst delivering high-quality services. Show less Assessing customer requirements and ensuring that these are met.Setting customer service standards.Recording, analyzing, and distributing statistical information.Supports and enhances processes around using data profiling, data quality, data mapping, and metadata tools to validate and uncover root cause data issues, and maintain data dictionary, mapping rules, and data lineage.Uses and supports database applications and analytical tools to: evaluate data quality, applications, and functions, produce output, and maintain operation.Conduct business-process re-engineering/optimization using BPMN and follow-up on cross-functional improvement initiatives.Participate in working groups to address improvement areas in the organization. Show less

  • Head of Data Analytics and BI

    May 2024 - Oct 2024

  • BI Developer and Big Data Analytics Supervisor

    Nov 2021 - May 2024

  • Data Analytics and BI Senior Analyst

    Sept 2019 - Nov 2021

  • Sr Data Analyst, Quality Management

    Aug 2018 - Sept 2019
• 

  Giza Systems

  Oct 2024 - now

  BI Developer Lead

  I specialize in delivering data-driven insights through advanced BI visualization tools like Power BI and Tableau, tailored to diverse client technologies. I am responsible for leading the implementation and analysis of complex projects, ensuring data management best practices are upheld across various domains.Empower businesses by transforming their data into actionable intelligence, fostering informed decision-making through seamless integration of business intelligence solutions. Show less