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
12.2021 - 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
03.2018 - 12.2021
- 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
10.2015 - 02.2018
- 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
11.2013 - 09.2015
- 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
05.2011 - 11.2013
- 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
07.2009 - 04.2011
- 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
01.2006 - 06.2009
- 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 04.2001 - 12.2005
Skills
Data Management
undefinedAccomplishments
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
12.2021 - Current
Sr. Data Warehouse Solution Architect
Master-Works for Tabadul Company
03.2018 - 12.2021
Sr. Data Warehouse and BI Consultant
Master-Works for Saudi Telecom Company
10.2015 - 02.2018
Sr. BI and DWH Specialist
Zain Telecom Company
11.2013 - 09.2015
BI and DWH Analyst
MTN Telecom Company
05.2011 - 11.2013
Database Administrator
MTN Telecom Company
07.2009 - 04.2011
System and Database Administrator
Ministry of Labour
01.2006 - 06.2009
Bachelor of Science - Computer Science
UNIVERSITY of TECHNOLOGY
04.2001 - 12.2005
Similar Profiles
Omar HusseinOmar Hussein
Technical Lead at Master Team (spun-off Master Works in Jan 2023)Technical Lead at Master Team (spun-off Master Works in Jan 2023)
Jonathan BrownJonathan Brown
Car Detailer at Master Detailing, Inc.Car Detailer at Master Detailing, Inc.
Haley WooleyHaley Wooley
Operations Facilitator at Panel MasterOperations Facilitator at Panel Master