Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

Mohammed Babiker

Sr. Data Management Consultant
Riyadh

Summary

Senior DM consultant who provides the required guidelines and plans to implement and comply with Data Management standard requirements for better data management and personal identification information protection. In addition, strong hands-on on Data warehouse, Data Modelling, Business Intelligence, and Data Analytics expert with 13+ years of experience in developing and managing large-scale BI and DWH applications. Expert in utilizing ETL, BI and Data-Analytics tools to build analytical data models for customer value development (CVD), churn prediction, competitors’ analysis, behavioral segmentation, campaign management, customer experience and pricing. Proven achievements in managing BI projects including OCDM Oracle Communication Data Model implementation.

Overview

17
17
years of professional experience
5
5
years of post-secondary education

Work History

Sr. Data Management Consultant

Master Works
Riyadh
2021.12 - Current
  • Provide required guidelines and plans to implement and comply with NDMO standard requirements for better data management and personal identification information protection.
  • Define and implement all necessary data directives including regulations, policies, procedures, data governance, and data quality frameworks and data standards according to NDMO standards.
  • Establish rules and procedures for data sharing with top management, external stakeholders, … etc.
  • Perform periodic data quality assessments to maximize value and benefit of data.
  • Identify personal identification information in different data sources in order to be managed protected as per NDMO standards.
  • Prepare, and conduct data asset awareness sessions with different stakeholders to improve data management practice.
  • Provide technical assessment for integrating new technology or initiatives into data standards and best practices.
  • Design architecture of MDM solution encompassing ETL, Database, MDM, and outbound data synchronization components.

Sr. Data Warehouse Solution Architect

Master-Works for Tabadul Company
Riyadh
2018.03 - 2021.12
  • Translating business requirements into technical specifications, including data streams, integrations, transformations, databases, and data warehouses.
  • Extensive experience using various kinds of ETL to build required data flow processes to populate data into central data warehouse, DataMart, and ODS from different organization data sources.
  • Defining data architecture framework, standards, and principles, including modeling, metadata, security, reference data such as product codes and client categories, and master data such as clients, vendors, materials, and employees.
  • Extensive experience in ETL and ELT (Extraction, Transformation, Loading) using different kind of tools.
  • Collaborating and coordinating with multiple departments, stakeholders, partners, and external vendors.
  • Expertise in extracting data from various disparate data sources & (.XLS, .CSV, .TXT) file formats and databases like Oracle, SQL Server, and MySQL.
  • Manage all enterprise’s data models in main data warehouse, drive agreed-upon data roadmap, and ensure maintenance goals are met.
  • Understand and align with data warehouse engineering patterns and standards.
  • Troubleshoot data issues and define standards and processes for all enterprise’s data systems to ensure quality, uptime, and structurally sound data integrations.
  • Responsible for conception, design, development, and deployment of data architecture and data models.
  • Provide leadership for architectural direction, and provide consultation to agile teams.
  • Work together with various business units (BI, Product, and Reporting) to develop data warehouse’s platform vision, strategy, and roadmap.
  • Responsible for designing and implementing detailed data warehouse models and data mappings.
  • Encourage adoption of organization’s frameworks by providing documentation, training, sample code, and developer support.
  • Communicate progress on adoption and effectiveness of developed frameworks to department heads as well as managers and directors.

Sr. Data Warehouse and BI Consultant

Master-Works for Saudi Telecom Company
Riyadh
2015.10 - 2018.02
  • Motivating, coaching, and mentoring juniors BI and DWH developer in order to achieve highest and effective productivity approach and in accordance to agreed time and scope.
  • Designed and build required DWH architecture, which suits business needs and in align with organization strategy objectives.
  • Support development and validation required through lifecycle of DWH and BI systems according to business requirements.
  • Provide technical Data Warehouse and ETL expertise necessary to meet project and business need as well as production and maintenance in support of assigned project and application areas.
  • Develop data architecture, data modeling, and ETL mapping solutions within structured data warehouse environment.
  • Design and develop required ETL procedures for intake of data from both internal and external data sources; as well as ensure data has verified and quality is checked.
  • Design, implement and support different data normalization forms (1st, 2nd and 3rd).
  • Create, implement and manage data warehouse architecture in terms of; data model, facts and dimensions table.
  • Perform periodic data quality check over whole company’s data.
  • Generate required data improvements recommendation report and share it with concerns system’s owner.
  • Support and advice on business process improvements by providing required data summaries and data analysis reports.
  • Work collaboratively as part of team responsible for data collection applications to design, develop, and support end-to-end processes, taking lead on strategy and design of all ETL processes.
  • Provide highly responsive analysis of issues to diagnose and resolve with sense of urgency.
  • Participate in requirements gathering, preparation of specifications, and design for new projects and/or existing systems.
  • Prioritized customer request in accordance to its importance to business.
  • Analyzing organizational data and develop required KPIs that will meet customer needs.
  • Implement business and IT data requirements through new data strategies and designs across all data platforms (relational and dimensional) and data tools (reporting, visualization, analytics, and machine learning).
  • Design and develop various ETL processes and prepare OLAP cubes.
  • Follow various ETL Processes to prepare design for all metadata as well as responsible for development of physical and logical data models.
  • Perform troubleshoot on all ETL processes and resolve issues effectively.
  • Maintain and develop various database scripts and tools to facilitate automation process.

Sr. BI and DWH Specialist

Zain Telecom Company
Khartoum
2013.11 - 2015.09
  • Acting as BI team Leader; Supervise BI analyst personal to ensure high performance functionality in department and provide support to them when it is needed.
  • Work closely with business users to elicit and gather their requirements and then analyze it and convert it into technical requirements.
  • Work with business stakeholders to develop and maintain Customer Lifetime Value (CLV) model in order to design marketing offers and rewards.
  • Actively participate in BI department internal process design and auditing to fulfill data governance and data quality needs.
  • Leading analysis part of offers/products’ development in terms of customer segmentation, value proposition, pricing simulation and post-offer analysis.
  • Responsible for overall development and delivery of analysis, reports, KPIs to different business units (Marketing, Finance, Sales, Network and Strategy).
  • Ensure all BI assigned tasks are handled and executed, by distributing tasks among team and follow-up with them to ensure successful completion.
  • Communicate and collaborate with internal and external customers to analyze information needs and translate it into functional requirements.
  • Overseeing ongoing development and operations of business intelligence architecture that enables fact-based decision-making and ad hoc analysis and insight generation.
  • Ensuring high levels of BI availability through support functions and in-depth testing.
  • Mentoring BI team members by providing guidance, setting individual development plans and ensures its alignment with BI department and overall company strategy.
  • Design and create required ETL mapping process to integrate enterprise data sources into data warehouse systems (IN, CBIO, CRM, REMEDY and CMS).
  • Design, develop, implement, monitor and maintain ETL routines and load schedule according to DWH design and architecture.
  • Responsible for Data Quality Assurance check with other department (RA, QoS and ERP) in terms of accuracy, consistency and data completeness.
  • Create and manage daily and ADHOC data load processes.
  • Maintaining data warehouse consistency.
  • Ongoing review of data sources quality and ETL procedures on ODS staging area.
  • Support development and validation required through lifecycle of DWH and Business Intelligence systems.
  • Monitor DWH and BI systems performance and integrity; provide corrective and preventative maintenance as required.
  • Work collaboratively with other team members on developing and improving standardized data management operations and improving data quality control methods.
  • Contribute to successful completion of projects as required.

BI and DWH Analyst

MTN Telecom Company
Khartoum
2011.05 - 2013.11
  • Supervise BI analyst personal to ensure high performance functionality in department and provide support to them when it is needed.
  • Ensure all BI assigned tasks are handled and executed, by distributing tasks among team and follow-up with them to ensure successful completion.
  • Interfacing with commercial department and translate their business needs into analytics/reporting requirements.
  • Ensure all data issues are identified, tracked and resolved in timely manner.
  • Identify areas for improvement in reporting platform, plan for optimization, expansion, and upgrade operations.
  • Communicate and collaborate with internal and external customers to analyze information needs and translate it to functional requirements.
  • Overseeing ongoing development and operations of operational data store and enterprise data warehouse.
  • Overseeing ongoing development and operations of business intelligence architecture that enables fact-based decision-making and ad hoc analysis and insight generation.
  • Design and implement Oracle BI software and systems, including integration with databases and data warehouses, this includes selecting, blueprinting, gathering requirements, designing and rolling out BI solutions to end users.
  • Ensuring high levels of BI availability through support functions and in-depth testing.
  • Create, develop and maintain OBIEE RPD file.
  • Develop data access queries and uses OBIEE tools like Answers, builds dashboards and help in development of complex ad hoc queries and analysis.

Database Administrator

MTN Telecom Company
Khartoum
2009.07 - 2011.04
  • Database creation, backup and recovery, managing users and resources, tuning and monitoring database.
  • Managing various databases (oracle, access, SQL Server and etc...).
  • Monitor performance and managing parameters to provide fast query responses to 'front end' users.
  • Install and test new versions of database management system (DBMS).
  • Prepare database documentation, including data standards, procedures and definitions for data dictionary (‘metadata’).
  • Control access permissions and privileges.
  • Develop, manage and test backup and recovery plans.
  • Ensure that storage, archiving, backup and recovery procedures are functioning correctly.
  • Create and develop capacity plan for databases.

System and Database Administrator

Ministry of Labour
Khartoum
2006.01 - 2009.06
  • Responsible for Ministry’s DBs' related tasks (managing data, users, backup, recovery and security).
  • Archive System Supervisor (supervise 6 persons) to ensure data quality, integrity and consistency.
  • Created and implemented database designs and data models.
  • Tested programs and databases to identify issues and make necessary modifications.
  • Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
  • Created and updated database designs and data models.
  • Set up and controlled user profiles and access levels for each database segment to protect important data.
  • Modified databases to meet needs and goals determined during planning process.
  • Utilized RDBMS tools and utilities to monitor, tune and optimize system performance.

Education

Bachelor of Science - Computer Science

UNIVERSITY of TECHNOLOGY
Khartoum, SUDAN
2001.04 - 2005.12

Skills

Data Management

undefined

Accomplishments

Successfully participated and manged below BI and DWH projects and deliver high quality output to support the enterprise achieving their strategic and objective goals.

  • Location Intelligence Project.
  • OCDM Project.
  • MTN Datamart Project.
  • Centralized Reporting System Project.
  • BIB Solution Project.
  • MIMIR Project.
  • Customer Segmentation Project.

Timeline

Sr. Data Management Consultant

Master Works
2021.12 - Current

Sr. Data Warehouse Solution Architect

Master-Works for Tabadul Company
2018.03 - 2021.12

Sr. Data Warehouse and BI Consultant

Master-Works for Saudi Telecom Company
2015.10 - 2018.02

Sr. BI and DWH Specialist

Zain Telecom Company
2013.11 - 2015.09

BI and DWH Analyst

MTN Telecom Company
2011.05 - 2013.11

Database Administrator

MTN Telecom Company
2009.07 - 2011.04

System and Database Administrator

Ministry of Labour
2006.01 - 2009.06

Bachelor of Science - Computer Science

UNIVERSITY of TECHNOLOGY
2001.04 - 2005.12
Mohammed BabikerSr. Data Management Consultant