Tahar Messas

Project on various PSA Finance Bank applications in the areas of Risk/Accounting/Securitization and regulatory reporting. Monitoring and maintenance of the credit risk management decision-making chain (BASEL2, IFRS9) Tasks performed:

• Study of the existing system and analysis of client needs,

• Development of stored procedures and stored functions in PL/SQL,

• Corrective and evolutionary maintenance of SQL scripts and Shell scripts,

• Development of an APEX application,

• Creation of M queries in Power Query,

• Creation of the Tabular data model in Power Pivot,

• Creation of reports on Power BI Desktop,

• Development of DAX measures,

• Development of SAS programs,

• Execution of tests (unit, integration, and non-regression),

• Ticket management via JIRA,

• Writing detailed technical specifications,

• Delivery of specific programs to testing and production.

Environment: Oracle, SQL, PL/SQL, APEX, SQL Developer, Shell (Unix), Power BI, Power Query (M), DAX, SAS Enterprise Guide, SAS, PuTTY, GitHub, TeamCity, JIRA.

CORE INVOICE Project: Billing, document production, accounting, and payments/reimbursements flow management. Tasks performed:

• Study of the existing system and analysis of client needs,

• Corrective and evolutionary maintenance of PL/SQL batches,

• Creation of tables, views, indexes, and triggers in Oracle,

• Development in Oracle PL/SQL (packages, procedures, and stored functions),

• Development of extraction batches for data to files (csv, xml, json),

• Development of import batches for files (csv, xml, json) into the database,

• Corrective and evolutionary maintenance of APEX applications,

• Execution of tests (unit, integration, and non-regression),

• Delivery of specific programs to testing and production.

Environment: Oracle, SQL, PL/SQL, APEX, SQL Developer, XML, JSON, RabbitMQ, API, GitKraken, JIRA, Agile methodology

• Maintenance in operational condition (MOC) for I-CDC client, IT subsidiary of Caisse des Dépôts Project FIDELIO: Guarantee management (including InfoGarant), Loan transfer (bulk, split), Downgrading and Provisions, TRICP risk centralization (Information Processing of Private Debts). Tasks performed:

• Study of the existing system and analysis of client needs,

• Corrective and evolutionary maintenance of PL/SQL batches,

• Optimization of processes,

• Creation of tables, views, indexes, and triggers in Oracle,

• Development of stored procedures and stored functions in PL/SQL,

• Execution of tests (unit, integration, and non-regression).

Environment: Oracle, SQL, PL/SQL, SQL*LOADER, Shell, TOAD.

• Personal project for skill development (C#.NET, PYTHON, and TALEND): COMMERCIAL MANAGEMENT: Commercial management application with functionalities for managing clients, suppliers, orders,

• Creation of conceptual, logical, and physical data models using the Merise method,

• Creation of databases in SQL Server, MySQL, and PostgreSQL,

• Development of stored procedures in SQL Server (T-SQL),

• Development of GUIs in Windows Forms, WPF, and ASP.NET MVC with C#.NET,

• Creation of graphical interfaces in Python,

• Development of Python scripts for data extraction to CSV files,

• Development of Python scripts for importing files into the database,

• Design, modeling, and development of Talend jobs,

• Development in Talend of file integration processes into the database,

• Development in Talend of data extraction processes to files,

• Creation of reports and dashboards in Power BI.

Environment: C# .NET, Windows Forms, WPF, ASP.NET MVC, Visual Studio, .NET Framework, .NET Core, Python, HTML/CSS, JavaScript, SQL Server, T-SQL, MySQL, PostgreSQL, Talend, IDLE, Merise, PowerAMC, Visual Studio Code, Git, Power BI.