Guillaume Vieillevoye

SQL Server administration
Migration from SQL Server 2008 to SQL Server 2017
Build a datawarehouse
Import data from various brokers and other data providers
Create reports for business and regulatory (MIFID, EMIR, CRS …) purposes
Rewrite a MS Access application with .Net and SQL Server to import and reconcile bank accounts movements and balances with internal accounts

Environment: SQL Server, SSRS, .NET

Create and maintain fund accounting reports

Modify the datawarehouse to provide the needed data to reports

Maintain a C#.NET DLL that decrypts sensitive data via a T24 web service

Create custom data sources

Create C#.NET automated deployment tools for SQL and SSRS components

Environment: SQL Server, SSRS, Temenos T24, C#.NET

Maintenance/evolution and performance optimization/tuning of the datawarehouse
Create/maintain fund accounting reports, Data extraction, Data migration
Environment: Oracle, PL/SQL, Toad, Crystal Reports, GP3

• Flexible reporting project

Create DB2 SQL queries

Create custody, fund accounting and transfer agent reports with Cognos and internal tools

• Jupiter project (migration from Olympic to Simcorp Dimension)

Build reports specifications for new reports and for reports that require to be rewritten because of the migration

Define the new sources and structure of the data federation layer

Define test plans and test the new reports and the new data federation layer

• Reporting reverse engineering project

Build reports specifications based on existing reports for which there has never been written specifications

Environment: DB2, SQL Server, Toad, SQuirreL, Cognos Report, Olympic, Simcorp Dimension

Windows application development dealing with soil analysis and samples

Environment: SQL Server, C#.NET, DevExpress

BPM Document management reporting

Evaluation of the reporting possibilities of JasperSoft tools (Jasper Reports, Jasper ETL, Jasper Analysis et Jasper Server)

Comparison between JasperReports and Crystal Reports

Design a Java prototype application using Jasper ETL jobs and Jasper reports for the Intradel (internal) project

BPM Document management reporting

Environment: J2EE, Jasper (Talend) ETL, Jasper Reports & Ireport, Eclipse

Company Overview: RBC - Dexia Investor Services

Development of data extractions with Oracle 10

Development of customer reports with Crystal Reports

Environment: Oracle, Crystal Reports, PL/SQL, TOAD

Development of graphical interfaces and reporting tools around T24 data

Development of a data transfer tool between relational databases and multivalue databases

Environment: C# .NET, Temenos T24, JBase, Universe, Oracle, MS SQL Server, Crystal Reports, PL/SQL, TOAD

Training at the Chambre de Commerce in creation and management of companies to get the state authorization to create a company

Participation to the International contest for innovative companies « 1,2,3 GO »

Environment: Superwaba (JVM & Framework)

Development of financial reporting tools to help the management to take decisions depending on the evolution of the market

Management of electronic data transfers. Bank accounts reconciliation with internal systems (Camra/GP2 and policies management system).

Import of prices, exchange rates, corporate actions… in the portfolio management system (Camra/GP2).

Swift trade input system (linked to GP2)

Participation to the migration project from Camra to Sungard GP2

Prepare the portfolio valuation and publication of data in the secured Internet site for LIA customers

Real time applications with Bloomberg data.

Automatic creation of Excel files with Bloomberg formulas

Intranet pages development with Java and JSP

Environment: Visual Basic, J2EE & JSP, Oracle, MS SQL Server, Sybase, Crystal Reports, GP2, Camra, Bloomberg, Swift

Development of software of stock exchange portfolio management with Progress 4GL, Progress databases and Oracle databases

Environment: Progress, Oracle, MS SQL Server, TOAD

Maintenance of mainframes, network

Supervision and supervision of Visa, Eurocard and Bancomat transactions

Environment: Novell & X25 networks, Bull, Tandem