Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Timeline
Generic

MAHMOUD KARAM

Chief Data Officer
Riyadh

Summary

Strategic and enabler Data Analytics highly skilled professional with 17+ years of experience leading many teams of data management and analytics in different enterprise telco operators to deliver high quality and reliable solutions for Data Analytics and Enterprise Applications including Finance, BI, Data warehouse, Big Data and Database across solution design, Architecture, Modelling, implementation, performance optimization and support platforms. Excellent in review and assess existing Data Management and analytics strategy, develop, and review new Data strategy. Highly committed to Business, services, operational, and product enhancements through effective utilization of modern architecture and technical tools with high experience in selecting the right solutions, tools and Technologies per business and industry needs. Specialized in Data management digital transformation roadmap for Telecom Operators, with strong proven achievements history for STC, Solutions, ORANGE, ETISALAT MISR, ETISALAT UAE, OOREDOO Kuwait, ZAIN Bahrain, ZAIN Jordon. Equipped with strong portfolio of successes driving full lifecycle of large-scale Data projects, ensuring compliance with requirements, policies, procedures, regulations, and top-quality standards. Works collaboratively with cross-functional teams and provides members with the resources, training, guidance, support, and motivation to surpass challenging objectives. Advanced communicator in English.



Overview

14
14
years of professional experience
1
1
year of post-secondary education
3
3
Certifications
2
2
Languages

Work History

Data Management Director

STC
01.2020 - Current
  • Transform profitability management data management and analytics in stc including business process, strategy, data flow, insights, solutions, systems, skillset, methodologies and transform the entire department into digital to boost the output of profitability management team and introduce a new insights that was not exist before for entire stc organization under business finance department, included but not limited entire stc products and services, segmented allocated P&L per business unit, product, service… etc
  • The digital transformation program that I built based on an extensive maturity assessment for the current situation for both business and technical side, which led to identify the main pain areas, gap analysis with proper recommendation and clear roadmap for actionable projects to streamline the data cycle E2E and enable business to discover potential insights they never touched before
  • Profitability Management Digital Transformation program include,
  • Analytics and Business insights (SL&R) Project
  • Operational Data Management Project – ODM

Data Management Expert Consultant

Ooredoo Kuwait
01.2018
  • Reduce delay queue of MSTR reports and dashboards
  • Collect Stats Optimization: Reduce Process running from 6 hours to 1.5 hours, increase process collection from 500 Table to 1000+, 4X time saved of ETL window, Dedicated Collect stat window allocated
  • ETL performance tuning: ETL time reduced from 12hrs to 6hrs with 2X performance gain
  • Reduce DataMart Time: Tuning of several DM procedures results in 3X performance improvements
  • Successfully implemented two major projects in data management for Ooredoo Kuwait IT data management department
  • Enterprise ETL Revamp Project: (6Months)
  • Optimize all ETL jobs for enterprise Data warehouse and Enhance the whole ETL window plan from 11 hours to 4 hours
  • Redesign the whole ETTL architecture with more that 370 source and Target objects
  • Automate and parametrized 515 session and connection to use one unified optimized configuration
  • Data Management LDAP Integration Project: (2 Months)
  • Install and configure LDAP integration for Teradata Enterprise DB system to enable business users login with their domain credentials utilizing SSO.

BI / DWH Technical Expert Lead - Project Manager

SAP MENA – Zain Bahrain, Zain
01.2016 - 01.2018
  • Utilize 14 years’ experience in Data Management solutions to managing a Major project to implement BI Data warehouse complete solution consists of 5 projects (1
  • EDW, 2
  • BI, 3
  • Predictive Analytics Model, 4
  • Event Streaming Processing, 5
  • Information Steward) for large Telecom Operator in Bahrain with a budget of Multi Millions USD, Transforming the project from going to fail into success story
  • By conducting a deep reassessment for all the business requirements and come up with the right approach to deliver such project according to the deliverable complexity, dependences, efforts and business priority and switch it from waterfall methodology to Scrum Agile
  • Managing Multi Cultural resources (7 Nationalities) including building a stunning team with a different skill set form multi nationality, handling project stakeholders including high level CXOs, Customer management, Vendors, project Team, PS consultants, ETL/BI/DB/Modelling/Architecture consultants
  • Conduct a reassessment for the project deliverable and all the business requirements from different business users (Marketing, Sales, Customer Care, Retails, Finance, Engineering, Network) and come up with the detailed analysis and the Gaps
  • Put a plan with a different approach and methodology according to the output to fit in the project deliverable requirement from business and technical perspective with the right judgment on the needed solutions, modelling and Tools
  • Adjust the Data modelling and Database design in the right way and fix the existing issues, optimize the current data quality and MDM
  • Complete all the needed ETL layer on top of 20+ different types of source system
  • Conduct a data integration, synchronization, schedule dependency to ensure the data consistency
  • Built Hundreds of BO reports, Deliver a very complex Dashboard Dashboards, Tens BO universes self-services
  • Implementing different SAP Technologies and applications (DLM, Dynamic tiring, ESP, IS)
  • DWH, BI and Big Data Applications and Database Manager

Etisalat
01.2012 - 01.2016
  • Deliver expertise and leadership focused on DW / BI, Big Data, and DB operations, playing a key role in solutions architecting, administration, support, development, maintenance, and data warehousing optimisation
  • Coordinate assigned team, ensuring proper completion of full project lifecycles from tendering, planning, and development to delivery on time and within budget of Millions of USD
  • Forge and cultivate productive relationships with vendors and clients
  • Identify / target issues as well as introduce process improvements as needed
  • Produce and deliver presentations as well as reports
  • Perform business analysis, requirements mapping, risk assessment / management, data integration, and implementation of data governance / master data management policies as well as procedures
  • Manage Capex / Opex for data warehouse
  • Research and identify opportunities for systems expansion as well as integration
  • Key Contributions:
  • Solid wide scope and knowledge in DWH, BI and BIG DATA solutions for over 12+ years
  • Surpassed client satisfaction goals through optimal core technical integration and modelling for highly sophisticated DW / BI Pain areas (SOV, NBA, Usage, Customer Profile, Payment, and Revenue)
  • Selected to tackle consulting job for multinational telecom operator, encompassing Teradata and Netezza Databases, Cognos Reporting system, and Data Stage ETL tool to boost workload administration
  • Etisalat Speaker in Nile University Event about BIG DATA Traffic case study
  • Https://goo.gl/gQAvMu
  • Initiate, Prepare and Deliver a new solution and present it to the top management
  • One of the people that shared in infrastructure strategy and optimization projects
  • Involved in ROI calculation and use it to assess the vendor offering values
  • Excellent Multi-vendor handling with experience in how to match each vendor offering with customer need
  • Chosen to serve as member of RFP Committees for data warehouse and IT solutions
  • Worked as technical expert in designing, building, installing, configuring, and supporting 300+ terabytes of data warehouses including "appliances"
  • Excellent experience in evaluating and selecting all infrastructure components such as software, hardware, database management systems
  • Implemented top quality gate focused on production aggregated and OLAP data for telecom with 200+ TB
  • Runs POC programs using Hadoop, ETL, BI, and SQL tools for both IBM Big Insights and Teradata Aster
  • Orchestrated successful merger of four teams consolidated support and administration teams, including Data Integration / BI Support Team, ODS Support Team, Campaign Management, Advanced Analytics Support Team, and Data Warehouse Database Administration Team
  • Implemented Micro strategy Mobile Dashboard system for CXO online Dashboards
  • Facilitated reporting through creation of unified power universes to empower business user
  • Commended with various awards for superior performance, project delivery, and contributions.

Senior Database / DWH Administrator

Etisalat
01.2007 - 01.2012
  • Played an instrumental role in pre-launch team as well as database and infrastructure team
  • Conducted administration, installation, migration, and troubleshooting of databases across diverse platforms with a strong focus on efficiency and security
  • Managed large Active Enterprise DWH / Teradata systems and database with more than 300+ TB in addition to 100s of integrated applications
  • Troubleshot telecom systems
  • Completed design and implementation of cLDM / PDM for EDWH as well as TASM / TDWM with highly complex and mixed workload (8000+ reports, analytics models, campaigns, developers, and support teams)
  • Handled design, logical modelling, and implementation of databases for all telecom systems
  • Implemented backup and recovery platforms
  • Administered Performance and Capacity Analysis (PMCP) for current systems and new projects.

Education

MSc - Data Science

University of Arizona
03.2022 - Current

Master of Business Administration (MBA) - undefined

ESLSCA

BSc. of Engineering - Telecommunication & Electronics Engineering

PMP - Project Management Institute

Skills

Analytics, BI and Data Management Technologies: SAS Viya, Micro strategy, Power BI, Qlik Sense, Tableau, Incorta, IBM Datastage, Informatica, SAP Business objects, Power Centre and Exchange with CDC, SAP Data Services, SAP ESP, SAP Information Steward, Talend, Teradata Campaign Management (TRM) and SPSS Statistics / Analyticsundefined

Accomplishments

  • Reference Data Management Project – RDM
  • Costing and Profitability system Project - CPM
  • Data Quality and Data Governance project
  • Orchestration and scheduling project
  • Data Management Expert
  • TCS, STCS – Contractor (2019-2020)
  • Profitability Management Digital Transformation Program: (STCS – 1Year)
  • Conduct extensive analysis for the current costing system implementation, capabilities, and resources
  • Perform gap analysis between current situation and the target solution needed
  • Develop digital transformation roadmap consists of 7 projects covering all the pain areas and transforming the whole costing cycle to be fully automated
  • EDW Platform Enhancement Project: (TCS - 6 Months)
  • MVC Application: Perform analysis and implementation that gained 45 TB space on Teradata after application of MVC to 100 Plus tables
  • Teradata DB Cleansing: Unused tables dropped from EDW saving 60 TB of space
  • Built a proactive monitoring system and scripts for all possible elements in Teradata database
  • Automated space management strategy and all Teradata housekeeping TD 12 new features, including space distribution planning, monitor space usage, regular compression, and DBQL with automatic maintenance scripts
  • Restructured backup system, including backup policies, SLAs, archival, and restoration in order to ensure business continuity
  • Slashed costs while optimising resources with major space savings
  • Completed major upgrade and patching of Teradata system from Version 6 to Version 12
  • Delivered Data Guard Replication Customer care databases, full alarm system, enterprise data warehouse, enterprise web portal, BSCS Billing migration, data centre, Oracle e-Business Suite ERP, Telepin E-TOPUP, and Enterprise Oracle DWH
  • Fuelled business through enhanced Teradata EDWH capacity planning and expansion project from one single system to multi parallel system and from 10 TB to 200+ TB
  • Exceeded goals, resulting in Expectation Award for pre-launch project of Etisalat IT development
  • Database Administrator
  • Orange, Egypt (2005-2007)
  • One of the key persons of database administration in the largest Telecom operator in Egypt at that time
  • Implementing a new solution with a new innovative idea in telecom system led to significant enhancement in systems life cycle and performance and reduce time to market
  • One of the key persons of Data Centre Relocation Project (The largest IT project in mobinil / Orange)
  • Key Contributions:
  • Full responsibility of all databases tasks, moving and migration in DATA CENETER RELOCATION PROJECT and maintain all data recovery in case of disaster this project takes all our time, efforts, full dedication, high focusing and fast solve problems skills
  • Administrated, performance tuning with significant figure print on all Telecom DB Systems (Billing, IN, ERP, POS, Portal...Etc.) with unique initiatives and innovation solutions
  • Implement B&R strategy using flash copy (Storage replication technology)
  • Administrated Oracle databases related to the BSCS software (2 T bytes, around 800 users connected 24/7)
  • The databases are installed on HP-UX servers
  • Managed lots of projects such as (EBILL migration, VRS migration) with supported several production and development databases on several platforms Unix HP/UX, Unix IBM/AIX, Linux SUSE and Windows
  • Profitability Management Digital Transformation Program, STC (2019-2020)
  • EDW Platform Enhancement Project, STC (2019)
  • Enterprise ETL Revamp Project, Ooredoo Kuwait (2018)
  • Data Management LDAP Integration Project, Ooredoo Kuwait (2018)
  • Enterprise DWH and Analytics Digital Transformation, SAP- ZAIN Bahrain (2016-2018) Implement BI Data warehouse complete solution consists of 5 projects (EDW, BI, Predictive Analytics Model, Event Streaming Processing, Information Steward) for large Telecom Operator in Bahrain with a budget of Multi Millions USD, Transforming the project from going to fail into success story
  • Large Telecom IT Systems Re-Platforming, Etisalat (2013-2016): Consolidated all major IT systems and services into a new powerful IBM Platform integrated with Etisalat Data centre relocation project
  • EDWH ETL Metadata Solution, Etisalat (2015): Built ETL Jobs metadata solution based on Datastage DB2 metadata DB and UC4 metadata DB integrated to produce one complete metadata view for all ETL jobs
  • BI System Upgrade & Process revamp, Etisalat (2015): Revamp BI system and processes including upgrade Business objects application to the latest version and introduce Microstrategy application for mobile dashboard for Top Management and CXO with 8000+ reports, universes and dashboards
  • EDWH Data Quality process, Etisalat (2015) - Telecom Billing System Upgrade, Etisalat (2009)
  • Introducing IBM Flash drive for IT systems Performance, Etisalat (20 15)
  • ETL Jobs Revamp, Etisalat (2014): Clean-up, revamp & performance tuning for ETL jobs, application (Datastage) and processes for EDWH system including 2000+ extraction and integration jobs including Usage, Revenue, Payments, Sales, Customer Life Cycle, Customer profiles, GIS, SIS, CRM, ERP, Loyalty, ...etc
  • EDWH BI Metadata System, Etisalat (2014): Develop BI Metadata java-based system-based BO audit DB and BO file store DB with daily auto refresh in structured oracle DB and built a complete universe on it
  • Advanced Analytics (ANA) Appliance System, Etisalat (2013): Teradata appliance 2750 with 45TB to use in all advanced analytics activates including TRM, TWM, SPSS, and Aprimo and campaign management
  • Enterprise Online Data Store (ODS), Etisalat (2012): Built and maintained Online Data Store (ODS) system to provide real time business data requirements, based on Oracle database and Informatica CDC
  • Telecom Oracle Databases HA upgrades, Etisalat (2008-2012): upgrade over 100+ production oracle database to latest version and Haigh Availability ASM, RAC solutions
  • Network Performance Analytics (NPA) Appliance, Etisalat (2012): Teradata appliance 2700 with half RAC and 40TB, integrated with Anritsu probing system to enhance network performance by analyse the network element and components and get figures about dropped call, missed, attempted …Etc
  • Data Packet Inspection (DPI) Appliance system, Etisalat (2011): Teradata appliance 2750 with 45TB to collect & analyse large Data Packet Inspection (DPI) system to get more insights about customer behaviour
  • Establish Enterprise Large DWH Project for Telecom operator, Etisalat (2007): Built DWH complete solution starting with all vendors’ solutions evaluations, POCs, planning, choosing best suitable tools, applications and database, then implemented using both Bill Inmon and Ralph Kimball methodologies
  • Including ETL, BI, Quality, Analytics and Campaign Management in one of the largest telecom operator in Middle East
  • Major Teradata Upgrades and HW replacement, Etisalat (2009, 2011, 2013, 2015): Upgrade Teradata systems versions starting v6 through v12, v13.10, v14 till v15.10 and HW starting Model 5000 through 5500, 5550, 6690 till 6800
  • Along major four upgrades in 9 years
  • Launch Advanced Analytics, Etisalat (2010): core assisting from modelling, architecture and database side in launching advanced analytics platform including MRM, Data Mining, Sampling and scoring, built campaigns and predictive analysis for telecom operator customers’ behaviour
  • Lunch IT Systems for Large Telecom Operator, Etisalat (2007): one of cornerstones and key persons in building All Etisalat telecom operator IT systems from scratch, including planning, vendor management, project management, technical implementation, EOT and UAT with Ericsson and tens of vendors
  • EDWH Data Migration Project, Etisalat (2007): DWH Data migration project from oracle to Teradata with all required changes in modelling, data structure, physical implementation and ETL/BI code change
  • IT Telecom Data Centre Relocation, Orange (Mobinil 2005): moving IT data centre from World Trade centre to Nile city including all activities of planning, installation, migration, HA, upgrades, performance tuning, troubleshooting, recovery, monitoring and swift extraordinary problem solving.

Certification

CORe, Harvard Business School - 2023

Timeline

MSc - Data Science

University of Arizona
03.2022 - Current

Data Management Director

STC
01.2020 - Current

Data Management Expert Consultant

Ooredoo Kuwait
01.2018

BI / DWH Technical Expert Lead - Project Manager

SAP MENA – Zain Bahrain, Zain
01.2016 - 01.2018

Etisalat
01.2012 - 01.2016

Senior Database / DWH Administrator

Etisalat
01.2007 - 01.2012

Master of Business Administration (MBA) - undefined

ESLSCA

BSc. of Engineering - Telecommunication & Electronics Engineering

PMP - Project Management Institute

Similar Profiles

CREATE PROFILE
MAHMOUD KARAMChief Data Officer