Hayet Hafed

Power Center Architecture

Administration Console

Operating System Profiles

Version Upgrades

Monitoring and Repository Manager for Log information

Client Tools and Sample Workflow Creation

BELLE Project: HSBC France Retail Bank Divestment Project Within the Business Intelligence team, my tasks focused on reviewing all processing and components constituting deliverables for the BELLE project.

• Design of processing, analysis/review of Informatica mappings, sessions, and workflows

• Analysis/review of Shell scripts for processing launches

• Design, analysis/review of Oracle scripts for creation, insertion, and updates

• Recommendations and feedback for appropriate corrections for each analyzed or reviewed component

• Support and training for junior developers

• Creation of scheduling jobs and implementation of ControlM for BELLE processing

• Maintenance of existing code and handling of evolution requests

• Deployment of different parts of the BI technical architecture

• Administration of technical and functional repositories of the Business Intelligence platform Functional environment: Savings, provident, regulatory, PENELOP standard Technical environment: Informatica PowerCenter 10.4.1, Oracle 12g, Unix (Shell), and ControlM

Design, Modeling, and Development of all data extraction processes for PDM and DataHub Core Service & Quality/DSI France, SOT Project Team APDATA Project: Ambition Prévoyance Solution: extract data from PDM (Public Data Model) and DataHub to send them to different destinations: accounting, management, and BCEF

• Technical and functional expertise role in data management

• Technical design and analysis

• Support for business analysts in requirements specification

• Informatica development, unit tests, and integration tests

• VA2A2 acceptance and end-to-end acceptance

• Writing technical documents RCD, PDD, and DI/DE

• Deployments and installation on different environments Functional environment: Savings, provident, actuarial, understanding of the concept of table historization Public Data Model (PDM): effective date, knowledge date, centralization date, GT_ROWVERSION Technical environment: Informatica PowerCenter 10.4.1, Oracle 11g, Unix (Shell), and ControlM