Daniel Azao Zigla

Within the Testing Center department of BNP Paribas Cardif, the HAUSSMANN project aims to implement an application architecture for processing information exchanges between contract management systems (internal and external PMS), Finance IS (Accounting and Management Control), and Actuarial.

My role involves taking charge of the following activities:

- Execution of batch and TP chains (including pre-analysis of malfunctions = debugging)

- Implementation of test automation

- Identification of anomalies and Management in Quality Center/ALM (declaration, tracking, closure)

- ORACLE Hexadata database in testing

- Taking over from the technical team for processing and data

- Component installation (database updates, ETL...)

- Participating in the review of Delivery Notes to identify data impacts and coordinating with technical designers and Project Managers.

The system will handle:

- Execution of initialization processes, known as "run-in" processes

- Data catch-up routines if necessary (database purge or update)

- Execution of daily processes

- Notification and status maintenance of defined roadmap actions (files, actions, and processes)

- Consideration and notification of technical actions (file integration) or batch requests.

- If a crash or defect is observed during execution => Notify anomalies in ALM for processing by the SAFIR technical team, then route to the correct contacts.

- Contribute to the launch (and analysis) of processes via SAS

Technological environment: Control-m, Oracle Developer, Putty, WinSCP, Informatica, Unix, ALM, JIRA

Member of the Data Service team, responsible for corrective and evolutionary maintenance of the existing BI.

Experience Details

- Gathering business requirements

- Ensuring corrective and evolutionary maintenance of the existing BI solution, which includes understanding the current system, developing data loading packages using SSIS, and modeling tabular cubes using SSAS.

Technical/Functional/Methodological Environment: SQL Server 2016, Visual Studio 2017, Power BI, Teams, Azure DevOps

Within the Credit Risk department, my mission consists of taking charge of the following activities:

Automation of data collection, its historical storage, and the production of dashboards via Power BI for internal use and the ECB.

My tasks were as follows:

- Gathering client requirements and proposing an application architecture

- Implementing a decision support system to extract, transform, store, and make available data resulting from Credit Stress Test exercises

- Presenting results via a personalized, flexible, and interactive dashboard allowing consultation, visualization, and comparison of different annual Stress Test exercises

- Writing technical documents, user guides

As a transverse technical assistant, these actions were carried out on various projects: IFRS9, STRESS TEST, BACK TESTING…

In addition to these missions, I worked on migrating QlikView reports to Power BI.

The actions to be taken were as follows:

- Analysis and design of the Power BI data model

- Development of visuals, development of business rules in DAX language

- Testing and validation of migrated reports with the business

- Configuration of gateways and publication of Power BI applications on different environments - Writing user guides for Power BI reports

- User support in the use of the new tool

Technological Environment: SQL Server, Oracle Developer, Visual Studio (SSIS), POWER BI, Jupyter