Ibtissam Kamal

Role Teradata Consultant Project(s): Migration of Datastage Warehouse jobs to Teradata.

Mission(s) and achievements: Extraction of business rules from existing Datastage jobs.

- Adaptation of TPT scripts on the MVS environment

- Design and development of SQL Scripts

- Adaptation of the data model for migration.

- Optimization of processing at the M control level.

- Preparation of the environment with datasets

- Execution of technical and non-regression tests.

Environment: Teradata, SQL, TPT, BTEQ, Shell, Teradata SQL Assistant, Teradata Administrator, GIT, MVS, Datastage

Role Teradata Consultant Project(s): Provision of dynamic coefficients following the implementation of a statistical technique for modeling consumption and production for a group of sites with similar behaviors.

Mission(s) and achievements: Participation in business needs analysis and creation of user stories.

- Creation of new indicators (accuracy, minimum number of panelists, completion rate).

- Design and development of Scripts for data loading with TPT

- Implementation of business rules in Teradata processing with BTEQ.

- Development of Teradata Stored Procedures for IHMs

- Development of queries for dataset preparation

- Support for business users in qualifying user stories

- Optimization of Teradata processing and improvement of response times

- Handling of incidents and anomalies.

- Participation in the organization of Agile ceremonies

Environment: Teradata, SQL, TPT, BTEQ, Shell, Teradata SQL Assistant, Teradata Administrator, GIT

TERADATA CONSULTANT

For BNP Paribas, I participated in the development of several projects:

• Creation and modification of Teradata components from functional specification documents.

• Analysis of requests in project and TMA mode.

• Scoping of incident or anomaly corrections.

• Execution of unit tests and writing of associated documents (Impact Study, DTU, Delivery Sheet…).

• Audit and optimization of Teradata processing

Mission(s) and achievements

-> Symbio:

Tool for monitoring and managing the performance of BNP PARIBAS after-sales operations production:

- Migration of Datastage loading jobs to Teradata-Oracle processing via TPT and CFT transfer

- Creation of new indicators for processable stock and non-processable stock corresponding to pending cases without a final decision, using BTEQ

- Handling of evolution requests and anomalies

- Audit and optimization of Teradata queries

-> Oara: ARNC activity and reporting tool.

- Creation of Teradata scripts (BTEQ) to load data into tables and for mass data modification.

- Monitoring and handling of incidents

-> DWR-NPE/FBE: Forbearance and Non-Performing Loans Management

- Analysis and design of business needs

- Development of processing and SQL queries for the implementation of two new indicators (FBE and NPE) by the European regulator

- Monitoring and execution of business requests

- Code review and improvement of processing times.

-> DWR-RETAIL/NON RETAIL: Organizational segmentation of BDDF customers between Retail and Non-Retail:

- Creation of scripts for the implementation of datamart tables

- Development of loading scripts (BTEQ) according to provided business rules

- Creation of Fastload or BTEQ import scripts

- Execution of unit tests

- Handling of anomalies via HP-ALM

Environment: Teradata, Teradata SQL Assistant, TPT, SQL, BTEQ, SHELL, HP-ALM