Kamal El Abkari

Regional health agencies, the National Solidarity and Autonomy Fund (CNSA) and the Digital Health Agency (DNS) launched regional and national calls for projects this summer to select new medico-social establishments and services (ESMS) partners of the Digital ESMS program aiming to accelerate the computerization of their users' files.

Development & operational maintenance of the data platform

 Monitoring of processes and Knowledge Capitalization:

 Diagnosis of problems encountered in data processing or reported by users

 Implementation of any necessary corrections

 Launching tools or recovery commands (manual recovery, resource reconfiguration, file copying, backup operations…)

 Communication of problems.

 Developments:

 Definition and formalization of user needs (e.g., ELECTION, Unit of Account Rate…)

 Implementation of new data processing according to business needs

 Integration of new controls into the monitoring process

 Software version upgrades: from ODI 12.1.3 to 12.2.1.4

 Bug fixes after migration to ODI 12.2.1.4

 Documentation of processes: detailed technical specifications of ODI flows

 Development of mappings with ODI 12c, Unit tests.

 Development of packages with ODI12c, Integration tests.

 Deployment of ODI scenarios.

 Writing and updating documentation

 Development of business views in Oracle SQL

 Power BI Desktop: creation of ODI Production Monitoring reports

TECHNICAL ENVIRONMENT:

 Agile Method, Jira-Software, ODI 12.2.1, Oracle 12c, Power BI V2.97, SQL, PLSQL

Subject – context: assignment conducted entirely in English (Contacts in France, India, Germany, Italy, Canada, USA, Japan…)

Manage and Administer Sanofi's Next Generation Data Center (NGDC) Platforms (EMEA, AMER, APAC).

 High Availability Architecture – F5 Load Balancer – Multi-server

 SAP BusinessObject migration projects

 Installation of DEV, TEST, PRE-PROD, PROD platforms

 HTTPS/HTTP – Security - Administration

 Performance issues

 Security Administration

 Redesign of the Business Object XI3.1 architecture

 Migration to the new SAP BI4.2 SP7, SP4, SP3 architecture using the 360 Suite tool

 Creation of workspaces for new projects

 Mastery of the Central Management Console environment and the BI launch pad.

 Knowledge of BI4 security management concepts

 Implementation of the BI4 security matrix

 Incident management on ServiceNow (Snow)

 Technical Architecture File

 Software installation procedures, SSO implementation….

 Development of complex BO Reports.

 Universe Creation

 BO Report Optimization (BOXI R 3, BI4)

 Active participation either as Project Manager or as consultant on certain Universe and Report developments, universe evolution, on these applications.

 Requirements gathering, development of universes, reports,

 Writing of functional and detailed specifications associated with these developments.

 Promotion in the different environments

 Transfer of skills to the support team based in India

 Active participation in testing during platform evolutions (an upgrade 4.1/4.2 SP4, a migration 4.2 SP4/ 4.2 SP7

 Evaluation of the new platform

 Non-regression testing

 User Acceptance tests

User training on new BO versions, as well as new universes

Informatica Developer

Subject – context:

Optimization of Informatica Mappings on resource-consuming Workflows

 Mapping level optimization

 Improve session performance

 Single-pass read configuration

 Optimization of direct mappings, filters, expressions, external procedures

TECHNICAL ENVIRONMENT:

 English, Agile Method, SQL Server 2014; Informatica 9, Oracle BusinessObjects XI R2; BusinessObjectsXIR3; SAP BI4.x; Windows Server; 360 Suite;