Cyrille TIJSSELING

En résumé

Entreprises

• DPS Software - Software Engineer

  maintenant

• DPS software - Sql Developer

  2006 - maintenant Data Migration / BI Developer:
  My main role is to deal with the Data Migration projects. I'm in charge of Migrating Data from legacy applications (legal account software such as Opsis, Osprey, Quill, SOS, Axxia, AlphaLaw, AIM, etc) into our legal account software (DPS Software).
  Here are my main activities:
  
  * Collect and analyse the project's business requirements with the stakeholders ;
  * Design Schema integration for the ETL process. ;
  * Create process to extract, transform and load (ETL) data from legacy systems using SSIS and C# - (Data Cleaning, Conversion, Migration, etc). ;
  * Investigate and rectify technical issues within the ETL process. ;
  * Interact with internal and external teams to troubleshoot any issue in data migration cycle. ;
  * Create and maintain technical documentation
  
  My second role is to develop Business Intelligence services. I'm working on a variety of greenfield projects for my firm as well as for our clients.
  My main activities:
  
  * Develop new BI services for our Cloud clients as well as the external ones. ;
  * Responsible for developing all the SSRS reports and dashboards (bespoke as well as the ones that get included into our Legal Account/Case Management Software). ;
  * Creation of a Cash Flow Forecasting tool using Excel VBA ;
  * When required I assist the Software Developers in writing T-SQL (Stored Procedures, Functions, Triggers, etc). ;
  * Develop data warehouse in order to create reports for the system engineers or the sales team and analyse them using SSAS cubes or Data Mining. ;
  * Train I.T. managers in SSRS and in T-SQL on site or at DPS ;
  * DBA duties: Backup, Restore, Upgrading, Patching, DTS, Detach, SQL Agent, small DB/OLAP Modelling, etc on the development server and on the cloud.
  
  Main technology used:
  
  * SQL Server: SQL 2000, 2005, 2008, 2008R2, 2012. ;
  * Visual Studio 2010 for VB.Net and C# and BI.
  * Office : Excel and Access VBA 2010 and 2013 ;
  * Redgate: SQL Compare, SQL Data Compare, SQL Prompt

• Laserform - 2nd level support & analyst

  2005 - 2006 Provided 1st level support and then, after a promotion, a 2nd level support to our Legal Cashier clients using my knowledge of SARs and SQL .
  Sole legal cashier, evans butler wade solicitors ,

• Evans Butler Wades - Sole Legal Cashier & Credit Controller

  2004 - 2005 legal cashier, various temping positions ,

• Bindman & Partners - Legal Cashier

  2004 - 2004 Bindman & Partners as well at Levenes.
  Various junior positions in

• Cliford Chance - Junior Legal Cashier

  2003 - 2003

• Bindman & Partners - Junior Legal Cashier

  2000 - 2002

• Bindman & Partners - Clerk assistant

  1999 - 2000

• Enzo Disagaro Ltd - Account assistant

  1998 - 1998

• MNEF - Marketing assistant

  1997 - 1997

• Bindman & Partners - Legal Cashier

  1997 - 2003 Bindman & Partners as well at Levenes.
  Various junior positions in

Formations

• Westminster University (Londres)

  Londres 2013 - maintenant MSc Business intelligence and analytics
  
  
  - Part time ongoing
  SUBJECTS: EXCEL & ACCESS VBA, DATA MINING USING SAS AND SSAS, STATISTICS AND OR USING SPSS, R AND AIMM, OLAP, DATA VISUALIZATION, ETC
  MSc in Theoretical Physics awarded with Merit

• Kings College (Londres)

  Londres 2010 - 2012 Master of Science in Theoretical Physics
  
  Subjects: Advanced Quantum Mechanics, General Relativity, Quantum Computing (Information theory), Equilibrium Analysis (advanced statistical mechanics), etc.

• Open University (Londres)

  Londres 2004 - 2008 Bachelor of Science in Physics
  
  Subjects: Computing Simulation, Fluid & Wave dynamics, Quantum Mechanics, Special Relativity, etc.
  HND IN BUSINESS ADMINISTRATION IN FRANCE

• Institut Universitaire De Technologie

  Poitiers 1994 - 1996 DUT GEA
  
  * Subjects: Management of small and medium-size companies, Accountancy, Marketing, Algorithms, Advanced Statistical Methods (Business Intelligence), etc.
  
  Skills & Abilities Strong skills in SQL development: currently in charge of B.I. reports (SSRS) and ETL (SSIS).
  Conversant with T-SQL coding (Functions, Stored Procedures, SQL agents, dealing with constraints, triggers, etc) using SQL

Réseau

• Gilles GONTIER

• Jean Olivier BILLES