Ahmed Samir, Developer in Riyadh, Saudi Arabia
Ahmed is available for hire
Hire Ahmed

Ahmed Samir

Verified Expert  in Engineering

Data Architect and Developer

Location
Riyadh, Saudi Arabia
Toptal Member Since
March 2, 2023

Ahmed is a data architect with extensive experience in business intelligence, data warehousing, data governance, data management, data quality, and data modeling. He has proven experience gathering business requirements from business users, defining KPIs, mapping to databases, defining data quality issues, and designing reports and visualization systems. Ahmed is a great team player with comprehensive business, analytical, and technical skills.

Portfolio

Technology Control Company
IBM Cognos, IBM Db2, Data Visualization, Data Aggregation, ETL Tools...
Technology Control Company
IBM Cognos, Cognos 10, Cognos Analytics 11, Cognos Framework Manager...
EJADA Systems
Business Intelligence (BI), Data Architecture, Database Modeling, IBM Cognos...

Experience

Availability

Part-time

Preferred Environment

Windows, Linux, IBM Cognos, Tableau, IBM Db2, Oracle, SQL, Teradata, Incorta, Erwin

The most amazing...

...organizations I've worked for are Saudi Arabia's financial investigation unit and the criminal investigation department at the ministry of the interior.

Work Experience

Data Architect and Business Intelligence Consultant

2017 - PRESENT
Technology Control Company
  • Acted as a BI team leader, leading requirement gathering and data analysis.
  • Translated business requirements into technical solution concepts and designs. I designed data warehouse models and created SMX documents.
  • Validated data loaded to the data warehouse by the integration team using IBM Cognos Analytics and SQL queries.
  • Created data quality reports to indicate quality issues in the data warehouse and source systems.
  • Designed and published relational and multidimensional models using IBM Cognos Framework Manager.
  • Developed reports and dashboards using IBM Cognos Report Studio.
  • Wrote complex queries to create required views to handle business user requirements.
  • Led the validation of reports generated using SQL queries.
  • Handled Cognos administration, deployment, and installation on Linux and applied security as per security rules.
Technologies: IBM Cognos, IBM Db2, Data Visualization, Data Aggregation, ETL Tools, Data Engineering, Database Security, Data Privacy, Data Governance, Business Intelligence (BI), Cognos 10, Cognos Analytics 11, Cognos Framework Manager, IBM Cognos Business Intelligence, Data Architecture, Database Modeling, Data Modeling, Data Warehousing, Engineering, Erwin, ETL, Linux, Windows, SQL, Dimensional Modeling, Reports, Relational Databases, Databases, Dashboards, Data Reporting, RDBMS, Database Architecture, BI Reporting, Data, Dashboard Design, Data Warehouse Design, Report Development, Database Design, Database Transactions, Database Structure

Business Intelligence Consultant

2015 - 2017
Technology Control Company
  • Acted as a BI team leader, leading requirement gathering and data analysis.
  • Translated business requirements into technical solution concepts and designs.
  • Validated data loaded to the data warehouse by the integration team using IBM Cognos Analytics and SQL queries.
  • Created data quality reports to indicate quality issues in the data warehouse and source systems.
  • Designed and published relational and multidimensional models using IBM Cognos Framework Manager.
  • Developed reports and dashboards using IBM Cognos Report Studio.
  • Wrote complex queries to create required views to handle business user requirements.
Technologies: IBM Cognos, Cognos 10, Cognos Analytics 11, Cognos Framework Manager, IBM Cognos Business Intelligence, SQL, Windows, Linux, Dimensional Modeling, Reports, Relational Databases, Databases, Dashboards, Data Reporting, RDBMS, Database Architecture, BI Reporting, Data, Dashboard Design, Data Warehouse Design, Report Development, Database Transactions, Database Structure

Business Intelligence Consultant

2012 - 2014
EJADA Systems
  • Worked on the Yesser business intelligence system for Qiyas 5 and other e-government sources in Saudi Arabia.
  • Incorporated money transfer data into the data warehouse at Arab National Bank (ANB), Saudi Arabia.
  • Performed an analysis of e-government sources and requirement gathering.
Technologies: Business Intelligence (BI), Data Architecture, Database Modeling, IBM Cognos, SQL, Data Modeling, Data Visualization, Data Warehousing, Data Engineering, Data Aggregation, Cognos 10, Cognos Framework Manager, IBM Cognos Business Intelligence, Data Quality, Datastage, Microsoft SQL Server, Business Requirements, User Requirements, Technical Requirements, Windows, Linux, Dimensional Modeling, Reports, Relational Databases, Databases, Dashboards, Data Reporting, RDBMS, BI Reporting, Data, Dashboard Design, Report Development, Database Design, Database Transactions, Database Structure

Data Warehouse Consultant

2010 - 2012
DataGear
  • Contributed to the population propagation and forecast at the Riyadh Development Authority (RDA), Saudi Arabia.
  • Built a data warehouse and performed core banking migration at the National Bank of Egypt.
  • Contributed to the BSCS 7 migration to BSCS iX at Moroc Telecom, the main telecommunications company in Morocco, using Informatica PowerCenter 8.6.
Technologies: Business Intelligence (BI), Data Engineering, Data Modeling, SQL, ETL, Oracle Database, SAS, Data Quality, Oracle, Oracle ODI, Oracle Data Integrator (ODI), Data Validation, ETL Tools, Flux, SAS Enterprise Guide, Informatica, Informatica ETL, Erwin, erwin Data Modeler, SQL Server 2008, Windows, Dimensional Modeling, Reports, Relational Databases, Databases, Dashboards, Data Reporting, RDBMS, BI Reporting, Data, Report Development, Database Design

Technical Support

2008 - 2009
Jelcom Training Center
  • Helped the company maintain its network performance.
  • Assisted the company in maintaining its training environment.
  • Contributed to the training environment administration and maintenance.
Technologies: Technical Support, Networking, Windows

Data Analytics for Ministry of the Interior

This project for Saudi Arabia's ministry of the interior required me to act as a BI team leader, handling requirement gathering and data analysis, translating business requirements into technical solution concepts and designs, designing data warehouse models, and creating SMX documents. I also validated data loaded to the data warehouse by the integration team using IBM Cognos Analytics and SQL queries and created data quality reports to indicate quality issues in the data warehouse and source systems.

In addition, I defined data governance and security rules for accessing the data, created and published relational and multidimensional models using IBM Cognos Framework Manager, designed reports and dashboards using IBM Cognos Report Studio, and wrote complex queries to create required views to handle business user requirements. I also handled the validation of reports generated using SQL queries and the Cognos administration, deployment, and installation on Linux. I applied security as per security rules and optimized reports.

Yesser Business Intelligence System for Qiyas 5 and other E-government Sources, Saudi Arabia

An analytics project for e-government sources in Saudi Arabia. I used the following technologies: IBM Cognos and SQL Server. My responsibilities included the analysis of e-government sources and requirement gathering. I also translated business requirements into technical solution concepts and designs. I was tasked with the creation of relational and multidimensional models and project and publishing packages using IBM Cognos Framework Manager. I created reports, a dashboard, and a portal using IBM Cognos Report Studio. I also created advanced active reports, validating the reports generated using SQL queries. I carried out a performance optimization of ETL scripts and reports.

The following subject areas were covered: Qiyas, GSB, IBM Rational ClearQuest, an SMS Gateway, Quduratiq, customer satisfaction, remedy, Clicky, IBM Tivoli Monitoring/LDAP, AMER, LAN integration, and a Saudi portal.

Incorporation of Money Transfer Data into the Data Warehouse

I incorporated money transfer data into the data warehouse at anb, Arab National Bank (ANB) in Saudi Arabia. I used IBM DataStage. I developed ETL jobs as per business rules using ETL design documents using IBM DataStage.

Population Propagation and Forecast at Al Riyadh Development Authority

I contributed to the population propagation and forecast at Al Riyadh Development Authority, Saudi Arabia. I used SAS Enterprise Guide to implement statistical models.

Data Warehouse and Core Banking Migration at National Bank of Egypt

Used Oracle Data Integrator, DataFlux, erwin Data Modeler, and Oracle Database. I prepared mapping for the migration and data warehouse for the first phase in the customer information area. I contributed to the NBE (National Bank of Egypt) core bank migration ''Essentials and Legacy" to the IFLEX phase 1 customer information area using Oracle Data Integrator. Using Oracle Data Integrator, I also contributed to the NBE (National Bank of Egypt) data warehouse creation phase 1 customer information area. I worked on customer unification and data quality using DataFlux. I also designed a customer information model in a data warehouse.

BSCS 7 Migration to BSCS iX at Moroc Telecom

BSCS 7 migration to BSCS iX at Morocco Telecom: I used Informatica Power Center 8.6 for this remote project. I prepared mapping for the migration using Informatica Power Center 8.6.
2009 - 2010

Diploma in Data Warehousing and Business Intelligence

Information Technology Institute (ITI) - Egypt

2003 - 2008

Bachelor's Degree in Electronics and Communications Engineering

Mansoura University - Mansoura, Egypt

MARCH 2023 - PRESENT

Cloudera CDP Data Visualization Training

Cloudera

FEBRUARY 2023 - PRESENT

Cloudera Essentials for CDP

Cloudera

DECEMBER 2022 - PRESENT

Advanced Designer Certificate

Dataiku

NOVEMBER 2022 - PRESENT

Core Designer Certificate

Dataiku

NOVEMBER 2022 - PRESENT

Data Analysis Professional Nanodegree

Udacity

MAY 2022 - PRESENT

SAS Visual Business Analytics Professional

SAS

MAY 2022 - PRESENT

Incorta 5 Foundations for Developers

Incorta

MAY 2022 - PRESENT

Incorta 5 Fundamentals for Administrators

Incorta

MAY 2022 - PRESENT

Incorta 5 Essentials for Business Analysts

Incorta

APRIL 2022 - PRESENT

Data Visualization with Tableau

University of California, Davis

MARCH 2022 - PRESENT

Data Analytics Professional

Google

MARCH 2019 - PRESENT

Nanodegree, Data Analysis

Udacity

JUNE 2012 - PRESENT

Cognos 10 BI Author

IBM

APRIL 2012 - PRESENT

SAS BI Content Developer

SAS

Tools

IBM Cognos, Tableau, Erwin, SAS Enterprise Guide, Cognos Analytics 11, Cognos Framework Manager, Informatica ETL, Cloudera

Languages

SQL, SAS

Paradigms

Business Intelligence (BI), ETL, Dimensional Modeling, Database Design, Oracle ODI

Storage

Relational Databases, Databases, RDBMS, Database Modeling, Microsoft SQL Server, Database Architecture, MySQL, Database Transactions, Database Structure, IBM Db2, Teradata, Datastage, Database Security, Data Validation, SQL Server 2008

Platforms

Oracle, Oracle Database, Windows, Linux, Incorta, Oracle Data Integrator (ODI), Dataiku

Frameworks

Flux

Other

Data Visualization, Data Aggregation, Data Analytics, Reports, Dashboards, Data Reporting, BI Reporting, Data, Dashboard Design, Data Warehouse Design, Report Development, Data Modeling, Data Architecture, Data Warehousing, ETL Tools, Data Engineering, Data Analysis, Engineering, Informatica, Data Privacy, Data Governance, Technical Support, Networking, Cognos 10, IBM Cognos Business Intelligence, Data Quality, erwin Data Modeler, Business Requirements, User Requirements, Technical Requirements, Database Analytics, Customer Data Platform (CDP)

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring