Gencer D.

Private Bank

• Evolutionary and corrective maintenance on Winch², Structured Products and Mutual Funds Management Software.

• Migration of Temenos T24 Core Banking software to AVALOQ: Reconciliation base, data feeding, import, and reporting

• Data synchronization via Service Broker

• Integration of Vanilla Products (NeuCP, NeuMTN) into Winch²

• Export of Asset Master Data, Trading, Valuation, and Ledger Booking files to AVALOQ

• Performance improvement through SQL optimization: reporting queries, extraction procedures, table normalization

• SSIS Package Optimization

A leading player in insurance and wealth management, with a comprehensive approach to life insurance, private banking, financial management, as well as health, provident, and casualty insurance.

• Intervention in support and evolutionary and corrective maintenance for applications (KLIFE) and unit-linked life insurance contract management batches (SQL Server, VB6, C#, Winform)

• IFI rate historicalization for SCPIs and OPCIs (SQL Server, C#, Winform, NHibernate)

• Rewriting and optimization of reallocation arbitrage (SQL Server, VB6)

• Generation of year-end closing reallocation arbitrage for the EuroTrading custodian (SQL Server)

• Integration of FID, FIC, and FAS mandates for Premium Luxembourg products (SQL Server, C#, Winform, NHibernate)

• POC (SSIS/SQL Server) on setting up SSIS ETL for the migration of all integrations and extractions + industrialization of deployments under SSISDB for run and projects.

• Writing application design documents (DCA)

• Non-regression testing (TNR)

• Participation in various SCRUM events (Daily, Reviews, etc…)

Ecofi Investissements, a recognized and awarded player for its expertise in equity, credit, diversified, and money market management, with a strong commitment to socially responsible investment (SRI).

• Produce monthly reporting of investment funds and mandates (performance, risk indicators, etc.). (Reportive)

• Migration of Talend jobs to SSIS to populate the reporting Datamart. (SQL Server/SSIS, Talend)

• Implementation of a SQL Job monitoring Dashboard (SQL Server/SSRS)

• Optimization of performance and volatility calculation queries and procedures. (SQL Server)

• Migration and evolution of import flows for CACEIS valuation and inventory files. (SQL Server/SSIS)

• Evolution and bug fixes on the mandate management application (Winform, VB.Net, SQL Server)

• Following the Tracker v2 / v3 migration (NeoXam), redesign of the SSIS flow for copying abstraction layers (SQL Server/SSIS)

• Rewriting, normalization, and optimization of Tracker v3 procedures. (SQL Server)

• As part of the Business Continuity Plan (BCP) implementation, update all flows: Development charter and standards, structuring, configuration, and deployment of packages. (SQL Server/SSIS)

File server replication for production (Robocopy, SSIS)

Technical environment: C#, VB.Net, Talend 6.5.1, SQL Server 2014, SSIS/SSRS, Reportive 10.2.