Hassan Haroun Adam

CCRM and compliance project

Compliance:

MICO Application – DAT scope:

•DQA

•CTC, CFP datamart

FIRCO/DDF/GARO data feed

EWRA Reporting

Compliance Business Database (CFO)

DRTP (Access Rights)

Customer Relations:

AMCC Datamart (Marketing Analysis and Customer Knowledge)

UNICA Business Database (BMU)

Interaction Data Layer – 360 View

RAF IF

Flow Orchestration (FLOW project)

LCL mon contact Telephone Statistical Monitoring

Enterprise CRM

Technologies Used:

- Big Data (hive, ampla, GitLab, Metis, xml, scala, Java, and Python)

- Business Intelligence (teradata, sql server: siss, ssrs, qlikview, sql, bteq, unix, Data Warehouse, and datamart)

• Expertise through the Creation, Modification of Power BI Reports (all data sources such as (Excel, txt, csv WebServices, SQL, Sharepoint…) and associated documentation,

• Opening the SQL warehouse to Self-service BI through SQL views, and materialized views. Any dataset opening (making views available) must be documented in the Safran Helicopter Engines data catalog.

• Support and Assistance to the Power BI referent to ensure the continuity of the BI community, and the POWER BI SCHOOLS.

• Support and Assistance to users in the development of Power BI Reports through Use Cases platforms,

• Assistance in writing documentation around the deployment of Agile BI.

• Creation/Modification of SSIS flows and associated documentation. Technologies: server

Air France joint revenue project, management of Air France and KLM data warehouse. The AFKLM BI projects contain the classic elements of a BI project, namely a database, an ETL tool for data loading, loading scripts grouped into loading chains, a scheduler organizing these chains, and various data visualization tools for end-users.

– To form a transversal Business Intelligence Unit – To develop and produce standard management reports – To centralize and improve Innovation Power – To steer Forecasting and Budgeting processes – To facilitate convergence of MI processes & Tools – To improve efficiency of data production and Reporting – To organize Joint Quality control on Data.

QlikView SalesAllinOne*

– Dynamic analysis tool with some report functionalities – Through selections all shown info is updated – Level of detail: detailed sales portfolio information – Target group: (outdoor) sales employees – Main Information: trade/corporate contracted info, MIDT, FWB, (BSP) AMS/RP.

Tools – Dynamic analysis tool; no reporting functionalities – Through selections all shown info is updated – Level of detail: detailed network (subline/flights) analysis – Target group: to support operational process of revenue management – Main Information: Delorean (forward booking), Monet (Revenues).

Business Object – BoXi:

– To build queries and reports. Not a dynamic analysis tool – Selections are defined in query – Level of detail: very detailed information – Target group: building queries/reports by expert BI users, refresh of reports by non-experts – Main Information: everything we have available, from booking till load factor.

Technologies: OS: Linux, Windows DBs: Oracle, Teradata, PostgreSQL DataViz: SAP BO, Qlikview, Tibco spotfire, kibana ETL: Powermart Informatica Big Data: HortonWork, Spark, elasticsearch Method: Atlassian Suite (Jira & Confluence) for agile Kanban, safe Language: Java, ABAP (very exceptional), SQL Master data management: Talend