Abdelhadi Senhadji

Projects: Management and coordination of version 21.1 projects of the PREDICA SI (ARPEGE) / MCO Management

• IFRS17: Implementation of an extractor from the ARPEGE BUSINESS INTELLIGENCE SI to the data platform

• CONVERGENCE: integration of collective retirement data through the NOEE solution

• RENCO: integration of annuity data through the KELIA (KAPIA) solution

• Optimization of business view calculation processes for indicators / contracts

- Gathering business requirements

- Project costing

- Drafting the requirements specification note

- Monitoring and coordination of workstreams (Business, Delivery)

- Preparation and participation in various committees (project, steering, operational)

- Analysis of general functional specifications

- Participation in the development of test strategies

- Drafting detailed functional and technical specifications

- Development of Oracle / Unix evolutions

- Optimization of SQL queries and stored procedures

- Delivery and deployment of Unix/Oracle assets via Git/Jenkins/IBM Change

- Delivery monitoring

- Execution of test plans

- Performing unit and integration tests

- Assistance to business for acceptance testing

- Preparation and execution of production deployments

- Corrective and evolutionary maintenance

Environment: JIRA, iObeya, Citrix, noemi, (ServiceNow) Windows, Unix, MVS, Oracle 1 1g, 12c, DB2, Shell, SQL, PL-SQL, Putty, Toad, SQLDeveloper, WinSCP, SAS Guide, Lotus Notes, HP ALM Quality Center, Informatica PowerCenter, Synergy, Git, Jenkins, IBM Rational Change Method: SCRUM

Project: Redesign of the Prudential Reporting SI - CoRep - Risk authority RRT Moody's

• Evolutionary and corrective maintenance of the CAPRC application (Calculation of risk-weighted assets for Credit).

• Preparation of 'Credit Risk' data for feeding the BFC tool

• Preparation of 'Credit Risk' data for feeding the SIRCO tool

• Implementation of Frameworks by assigning exposure for regulatory and specific BPCE reports.

- Drafting and updating detailed technical specifications

- Specification of technical solutions

- Development of Shell scripts for loading the database with SQLLDR

- Implementation of technical choices and development of Packages and stored procedures

- Optimization of SQL queries and stored procedures

- COREP generation

- Delivery and deployment of Unix/Oracle assets via Git/Jenkins

- Delivery monitoring

- Execution of test plans

- Performing unit and integration tests

- Assistance for acceptance testing

- Drafting operational documentation

- Monitoring of batch processing production

- Generation of regulatory reporting

- User support

- Skills transfer

Environment: Windows, Unix, Oracle, DB2, Shell, SQL, PL-SQL, Putty, Toad, SQLDeveloper, WinSCP, Eclipse, SVN, Git, Jenkins, JIRA, Risk authority RRT MOODY'S Method: SCRUM

Project FICOVIE (Amending Finance Law): Implementation of a platform for collecting, compiling, and issuing declarative data flows to the DGFiP: Lot 1 - Savings / Capitalization Products

• Implementation of a history of beneficiary clause type changes and/or free clause wording changes within ARPEGE (Prédica's Business Intelligence Information System)

• FICOVIE (Amending Finance Law): Implementation of a platform for collecting, compiling, and issuing declarative data flows to the DGFiP: Lot 2 - Provident / Funeral / Death Products

• Implementation of querying for compiling litigation files

- Project costing

- Drafting the requirements specification note

- Analysis of general functional specifications

- Drafting detailed functional and technical specifications

- Development of Shell scripts for loading the buffer database with SQLLDR

- Development of Packages and stored procedures for populating the business database

- Optimization of SQL queries and stored procedures

- Delivery and deployment of Unix/Oracle assets via Git/Jenkins

- Delivery monitoring

- Execution of test plans

- Performing unit and integration tests

- Assistance for acceptance testing

- Preparation and execution of production deployments

- Corrective and evolutionary maintenance

Environment: Windows, Unix, MVS, Oracle 1 1g, 12c, DB2, Shell, SQL, PL SQL, Putty, Toad, SQLDeveloper, WinSCP, SAS Guide, Lotus Notes, Quality Center, Informatica PowerCenter, Synergy, Git, Jenkins