Ahmed Samir

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.

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.

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.

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

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 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.