Rachid Oukhayi

BPCE LEASE GROUPE BPCE Business Analyst Data

• Collection of business needs (EDB), scoping and writing of technical and functional specifications for the DATA platform.

• Testing, acceptance, validation and production deployment of technical and functional deliverables.

• Collection, storage and historization of flows in the Data Lake as well as data exploitation for business/business/regulatory use.

• Manage interactions with Data sources: Cassiopae 4.5 and 3.46 back offices (Metropolis, Nouméa, Tahiti, Réunion); external partners (LLD Pro, Athlon, LTSC Data Green…), BPCE Group (NDOD Flows: risk, defaults and LGD, Tethys: tier aggregation and unification, Racine: BPCE agency information), CRM OSCAR (Salesforce tool), BIRD Project (PowerBI), Drone Project (electronic invoicing) …

• Development and implementation of Data Quality KPIs.

• Implementation of Data governance and preparation of Data Mapping, anonymization and GDPR implementation.

• Participation in architecture workshops around solutions provided by the DATAHUB data platform in response to various needs (opting for exchange solutions with files, feeding Azure CUBES for PowerBI needs, feeding Oracle via Scoop…)

• Scoping, reflection and implementation of a cross-functional Oracle database for Tiers/Files fed by Datahub in communication with various third-party applications (Spider, Salesforce, MyCarLease, LoaPart…)

• Strong proposals for performance improvement (job optimization, Spark 2 to 3, Cluster mode, partition keys…)

• Monitoring and improvement of production and Bench jobs under the CTLM scheduler.

• Level 1 support for Datalake, Informatica Power Center incidents.

• Level 2 support for Java-related jobs.

• Preparation of Pipelines via Git, Bitbucket, Jenkins, XLR/XLD.

• Implementation of costreams and CFT flows for reception and transmission to various partners.

Expert and TeamLead on EDI applications, underwriting (Marine, Aviation and Space) and applications for the issuance of Cargo and high-risk certificates.

Participation in the Move to the cloud project (OpenShift, Docker…)

Perform transformations and processing of large volumes of data for the creation of RDDs from existing RDDs.

Use of Parquet, Avro formats…

Query various HDFS and Hbase data sources

Spark administration via its interface (Job visualization, stages, storage, Environments, Executors), in order to improve performance.

SQL abstractions in the form of tables with DataFrame

Create a job with spark-submit

Realization of POCs around Big Data (SPARK2, HADOOP 3.X, APACHE HIVE, PIG, HBASE, HQL, HDFS, ZOOKEEPER, SQOOP)

Evolutionary maintenance, TMA and redesign of underwriting tools for Marine, Aviation and Space (high risk) at AXAXL Groupe AXA

TECHNICAL ENVIRONMENT: ECLIPSE, WEBLOGIC12, AS400, DB2, JAVA8, ORACLE12, SWAGGER, JUNKINS, FORTIFY.