Hatem Hassan

COE Team Structure is:

Led a cross-functional team of vendors and act the role of system integrator in the successful execution of the City Operation Center (COC) mega project for ACUD (the New Administrative Capital of Egypt).

The COC eco system include:

Citizen interfaces:

Designed and implemented digital interfaces for citizens, including a mobile app and web portal, enabling services such as payments, reservations, and complaints.

Operation channels & IOT platform:

Developed a comprehensive IoT platform and operation interfaces that monitored critical city services, including water, gas, and electricity grids, as well as managed meters and payments. The system is integrated also with field management applications and devices.

Management systems integrated:

Digital Signage, LDS, ADMS, Smart parking, smart lighting, smart irrigation, SCDA, AMI (water, gas and electricity). ESB integration

External system integrations:

Billing system, CRM, ITSM, asset management, ERP, GIS, security and public safety platform as well as payment gateway. API management integration

End point and sensors integrations:

Meters (electricity, water and gas), grids (electricity, water and gas), lighting, parking.

Big Data and Analytics platforms:

Data integration: (KAFKA & SSIS)

Data store: (HBase, Durid, SQL server)

Data Virtualization: OLAP store SSAS/Kylin

SQL server

AI & MI:

Data Collection: PySpark, Pandas • Data Preparation & Cleaning: Pandas, PyTorch • Data Visualization & Analysis: Matplotlib and Seaborn • Feature Engineering: Pandas, Scikit Learn • Model Training & Parameters: PyTorch, Scikit Learn • Model Evaluation: Scikit Learn • Model Deployment: PKL, H5, PB • Prediction : Flask API Service

BI: PowerBI, KNOWAGE

As a Senior Manager in the Business Intelligence & Data Management function at Etisalat Misr, I played a pivotal role in driving strategic initiatives, optimizing processes, and ensuring efficient delivery of business intelligence solutions. Here are the key responsibilities and achievements during my tenure:

Strategic Alignment and Objective Setting: Translated organizational strategies into SMART objectives for function managers and colleagues. Ensured that targets and program execution were aligned with the company’s values and mission.

Efficient Systems Implementation: Designed and implemented systems that efficiently performed the work and fulfilled the mission and goals of the BI & DSS (Business Intelligence & Decision Support Systems) function. Leveraged tools such as BW, Tableau, QlikView, and advanced analytics to enhance data-driven decision-making.

Resource Allocation and Staffing: Effectively allocated resources to staff the BI & DSS function, ensuring productivity and quality goals were met. Managed incoming data/reporting requests and delegated tasks to appropriate team members.

Monitoring and Controls: Established and maintained relevant controls and feedback systems to monitor the operation of the BI & DSS function. Prepared periodic reports for management, tracking progress toward strategic goals.

BI Awareness and Roadmap: Raised organizational awareness of BI & DSS solutions. Created and led the BI Competency Center (BICC) to drive BI strategy and best practices.

Business Intelligence Leadership: Led a team of system analysts and developers in implementing corporate BI solutions. Defined and developed the BI strategy/process around reporting and information delivery. Ensured a single version of the truth by maintaining the information presentation layer using business definitions and rules. Supported pre and post-analysis requirements for products and services. Assisted in business case information requirements.

Initially performed a BI/DW Architecture audit in preparation for a deployment of enterprise and operational balanced scorecard and data mining. Objectives being to provide a set of technical recommendations in the areas of dimensional models, enterprise data warehouse model, metadata platform, BI tool selection / performance management dashboard deployment, data profiling and general ETL architecture.

Senior Architect / PM for the deployment of an enterprise and operational balanced scorecard initiative (Performance Management) involving the complete re-architecture of the current enterprise DW/BI architecture, dimensional modeling, metadata design, requirements refinement (KPI definition), data management support, solution strategy/design specifications (incl. ETL designs); along with defining a clear BI/DW short/medium/long-term roadmap.

§ Manage team of technical developers in design and implement BI solutions in several enterprises like (CIB, EAB, Bayer, Vodafone, Toyota…).

§ Focused team on rapid troubleshooting and resolution of client issues. Reorganized and staffed technical support team, integrating it with larger customer support group. Developed support policies and Quality of Service agreements. Worked with customer support group to identify and provide customer self-help mechanisms.

§ Product manager for Business Objects ® product line and IBM data management products.

Listed below some of those projects: ·

§ Electronic Bill (e-Bill): a project for Saudi Telecom Company (STC). The project is to extract the Customers landline and GSM billing data and load it to a target database to provide an online access and downloadable invoices to the STC customers.

§ Revenue Data Mart Project (RDM): The project handles mobile (GSM) and landline billing systems for STC. GSM system uses the “Integrated Customer Management System” ICMS on AS400 and landline users application” an in-house developed system on IBM mainframe”.

§ Decision Support Facility (DSF): To support the reporting requirements for the logistics & Stock Management staff and managers of the Ordnance Corps of the Saudi Army, the Ordnance Corps Computer Center (SAAOC-CC) sponsored a “Decision Support Facility DSF” project to simplify and facilitate the generation of information reporting relevant to the logistics and stock management within the Ordnance Corps / Supply division.

§ Installed a big GIS lab contains SUN ALTRA II workstation with UNIX Solaris, 3 NT workstations, 2 A0 plotters, 1 A0 color printer, 1 A0 scanner, 2 A0 digitizers and configured all drivers, TCP/IP networking

§ Remote sensing images Processed (TM, SPOT, ASPENS2 IRS, IC) using ERDASS IMAGINE 8.3

§ Prepare Analysis and management documentation using GIS software (Arc/View 3.0, AutoCAD 14).

§ Prepare Maps catalog.