OA
Omar Yasser Salah Eldin Ahmed
Senior DWH Analyst at American University in Cairo
Nasr City, Cairo, EgyptWork Experience
Senior DWH AnalystFull Time
American University in Cairo
Dec 2019 - Present -5 yrs, 6 months
Egypt , Cairo
- Job Details:a) Create high-level data solution design for business Intelligence and Data Warehousing projects (Conceptual Model, Source to Target Mapping) to align with the enterprise data strategy and translate business needs into long-term information architecture solutions. b) Develop and refine the enterprise data warehouse logical & physical data models including entities, tables, columns, attributes & relationships c) Develop the new architecture models (Facts, Dimensions & relationships) for the new connected source systems d) Develop data quality Cleansing rules for data elements and identify data gaps in DWH with the main source systems. e) Develop data visualizations and reports to support data-driven decisions making and strategic planning f) Analyze deficiencies in reporting capabilities and data models g) Assist in ETL, CDC & transformation jobs using IBM data-stage & Informatica h) Create, maintain & document all the new architecture, related metadata and training documentation & project related activities to be presented to upper management
DWH Senior Solution architectFull Time
Etisalat Egypt
Jun 2018 - Dec 2019 -1 yr, 6 months
Egypt , Cairo
- Job Details:a) Acting as a point of contact between the data warehouse and Etisalat different teams (Business, IT, Technical, etc.), covering the end to end DWH projects life cycle. b) Develop DWH Solutions architecture & design (Scope, Processes, risks…) using business requirements. c) Translate & transform business requirements into detailed system requirements, technical design specifications and technical feasibility. d) Work with stakeholders across the business & IT Teams (IN, Billing, CRM, Digital) to ensure that DWH solutions, IT new products & services are clearly assessed, defined, and approved for deployment & integration e) Conduct data discovery, profiling, source to target mapping, and reconciliation f) Direct and lead DWH development teams from project initiation through the delivery of the final product g) Assist in Data integration, Data Modeling & developing reports on Teradata Database h) Assist in solving business user complaints and challenges related to DWH Models, and take corrective action if required. i) Documenting all the project related activities to be presented to upper management
Education
Bachelor's Degree in Communication and information Technology Engineering
German University in Cairo (GUC)Jan 2012