Alex Chouwak

My role is to strengthen a Project Management Office (PMO) team to bring my technical expertise regarding the analysis and development of new technical and functional needs, as well as the implementation of a multi-level technical testing strategy.

GTData Project, financial data management and centralization tool.

It allows selecting and acquiring market data from multiple sources (Bloomberg, Refinitiv, Morning Star…) to feed Covéa Finance's Information System tools while ensuring optimal data quality.

Project: Respond to new business needs within the framework of a new technical evolution to be implemented, with analysis of business needs and impact studies.

Roles, actions taken, and objectives achieved:

Drafting detailed technical specifications in coordination with the Business Unit.

Analysis of technical and functional requirements.

Identify and implement database performance optimization strategies.

Participation in various project stages (study, costing, development, testing...).

Development of new TRANSACT modules (SQL Server) to ensure new evolutions formalized by the client while respecting deadlines.

Development of PL/SQL program (Package and procedures) to ensure data exchange between CRM and the SCOTT tool.

Implementation of Scripting to automate processes and consistency tests.

Participation in the continuous service improvement process (proposing solutions).

Corrective and evolutionary maintenance of existing systems - Query optimization.

Performing unit and integration tests.

Improvement of processing time by 75% using table partitioning and indexing solutions.

Creation of a continuous global report on processing status (incidents, duration, updates, etc. ...).

Development in Pro*c of interfaces for supervising client alerts, as well as feeding the CRM (via an ETL).

Technical, business, and functional environment:

SCOTT tool for configuring and entering new contracts (maintenance contracts, renovations, etc. ...), Ultra Edit, Notepad++, Teams, CRM, SCOTT.

LINUX (HP), UNIX, ORACLE SQL DEVELOPER, SQLServer, TOAD, Oracle 12c and 19c, SHELL, PowerShell, pro*c.

PUTTY, MICROSOFT OUTLOOK, STORED PROCEDURES, SHELL, KORN SHELL,

Microsoft SQL Server Management Studio 18.

Use of the DevOps method to automate integration and delivery tasks.

Project: Respond to new financial needs within the framework of a new functionality to be implemented, with analysis of business needs and impact studies.

Roles, actions taken, and objectives achieved:

Development of PL/SQL (Package and procedures) and POSTG modules, and implementation of Scripting to automate the processing and monitoring of unit tests.