Resume

Arnaud Degraeve

SQL Server DBA – Teradata DBA

Project Management – Development

Skills Overview

Functional

  • Developers management in cultural diversity (offshore) – up to 16 persons
  • Project management (plannings, costs, resources, deliveries)
  • Project direction (management of several projects in the same time for different clients)
  • Structural and functional audits of SME / SMI
  • Extrem programming / Agile implementation
  • Human management (management of crisis, emergencies, team psychology and consistency)

Expertise

Development

  • Development of end user interfaces (VB / ASP / Dot Net)
  • Building and managing of Data warehouses.
  • Building reports (Crystal Report / BusinessObjects / SSRS)
  • SQL Server (2000 / 2005 / 2008 / 2012)
  • Teradata 13.10 / 14.10 Macros / Stored procedure /
  • Installation / Deployment and maintenance of business applications
  • Interfacing / Development with the most known databases (Oracle, Sybase, DB2, Postgres, mySQL)

Office Skills

Software:    Pack Office – MS Project

Databases:    DB2, Access, MySQL ,PostGres, SQLServer all versions, Teradata / Oracle (development)

Development:    SQL Server 2000 / 2005 / 2008, SQL, JavaScript, Vbscript. ASP, VB, Dot net, VBA – SSIS – SSRS

System:         Linux, Windows NT 4 / 2000 / 2003 / 2008 – MVS

Professional Experience

From 01/2014 – from present    TERADATA – PS Consultant Team – Teradata 14.10 / On call duty

  • Database tuning – queries optimization / development help and advice
  • Troubleshooting on problems. Incidents and changes management for clients
  • Interface with Teradata CS support
  • Implementation of solutions in client context (bank)
  • Metrology development – Space management, resources usage, reports about users and inconsistencies
  • On call duty on nights and week end on production systems
  • Software development in Shell script to block /unblock users / reset and change password of accounts
  • Management of backups with Symantec Netbackup (v7) – Control-M
  • Information system development for SHOEI Europe (Sales, orders, stock, website, replication, securization, exchange with accountancy software and Japan Information system)

SSIS / SSRS / C# / SQL Server 2008 / 2012 / Merge Replication / Netbackup 7.5/ Teradata 14.10 / Linux / Shell Scripts

From 04/2010 – 12/2013        SNCF – SQL Server – Teradata 13.10 / On-call duty

  • Tuning and problems resolutions on production SQL server – Teradata databases and applications
  • Management of crisis – failure of exploitation on the critical databases – Conference calls with clients and providers
  • Merge replication (Tuning on e-Ticket project in order to solve, locks replications problems, response time about a
  • merge between SQL servers and thousands of PDAs) – SNCF one of the three valuable client in the world using merge replication with more than 10.000 clients
  • SQL Server 2008R2 implementation (Best practices, integration of the product within the company, Advice about databases migration) – Documentation
  • SQL Server 2012 implementation (Best practices, integration of the product within the company, Advice about databases migration) – Documentation
  • Management / implementation of monitoring with Tivoli (analysis / checking of the consistency of alerts / creation of script for features non covered by Tivoli)
  • BI Databases optimization / Code review / Process review for importation and transformation of data
  • Clustering deployment an use in productions systems– MSCS – version 2000 – 2005 – 2008 – 2008R2 (5 nodes clusters for e-tickets project
  • Mirroring high performance / high availability mode(Principal, recovering, witness) in SQL Server 2008R2
  • Analysis / code and design review of e-ticket project (merge replication / C# / assemblies / Broker)
  • Interface with Microsoft premier support on the overall projects
  • Teradata management – On call duty on production systems (backups – restore – performance analysis)
  • Teradata development – Best practices management (based on problems met on production system)
  • Management of backups with Symantec Netbackup (v7)
  • Documentation on installation, deployment, best practices, for packaging and deployment
  • Planning and internal projects organization / project management

SSIS / SSRS / Dot net / SQL Server 2008 / 2000 / 2005 / Clusters / Merge Replication / Mirroring / SAN / Nexus / Tivoli / Netbackup / Broker / Teradata 13.10 / MVS / Linux

11/2009 – 03/2010        Direct Group France – France Loisirs (MultiMedia Distribution)

  • Transactional metrology development on production servers (using DataCollector).
  • Development of transverse Surveillance tools in order to follow the product flows consistency (sales, storage,…)
  • Tuning and empowering of user response time. Indexing, queries tuning, stored procedures tuning.
  • Deployment and instance creation on production servers (48 cores).

SSIS / SSRS / Dot net / SQL Server 2008 / DataCollector

03/2009 – 10/2009        VIRTUAL Network – SQL server DBA for final clients

  • EDI development for Carrefour France for FILTRAL (Uvex Group): SSIS for data import from SAGE 500 (ODBC) – Stored procedures development to build export files and for transformation data – Development of VB.net interface for front end users
  • Databases administration for FILTRAL (5 servers) / SQL Server 2000 / 2005
  • Monitoring and scheduling of data import
  • Database administration for financial and commercial databases at SPINDAL – Server installation and creation af new SQL instance ( 2005)

SSIS / SSRS / Dot net / SQL Server 2005 / SQL Server 2000 / VB.net

02/2007 – 03/2009        SFR – 9Cegetel – Tele2 ( Lead Telecom company in France / Europe)

  • Commercial migration of 3 million subscribers from Tele2 to Neuf Cegetel (SFR) using SQL Server 2005 – SSIS – SSRS. Interfaces with Oracle 9 and 10.
  • Built of a complete information system in order to consolidate the consistency of data coming from 10 different applications (invoicing, network provisioning, directory, outstandings, prepaid cards…)
  • Development of reports providing inconsistency for in-time data (SSRS).
  • Development of import flows, to transform, extract , compare, export data – Dot net / SSIS
  • Tuning of queries and execution plan in order to guaranty the response time of imports
  • Hints insertion / fine tuning / guideplan
  • Database administration – SQL Server 2005

SSIS / SSRS / Dot net / SQL Serveur 2005 / Oracle 7-9-10

01/2006 – 12/2007     Missions for final clients of VIRTUAL Network – DBA SQL Server

  • Website development: Meeting site with management of emails, search criteria, profiles, events, picture upload, on line chat,…)
  • Reports development from SAP for FILTRAL France / UVEX
  • Development of a storage location management tool for FILTRAL France
  • Statistics software development – Import from SAGE – tuning – in order to calculate details of sales. (3mn instead of 8hours in the original database) – scheduling of imports
  • SQL instance creation and management plans

SQL Server 2005 / ASP / VB / Crystal Report / Dot net / Javascript / HTML / SSIS / SSRS / Sybase

01/2005 – 02/2006             Internal development for VENTURY – DBA / development

  • Development of activity management tool and project management (full web) / reporting
  • Development of a full web knowledge database
  • Development of a maintenance / computer management with material and troubles tracing

SQL Server 2000-2005 / ASP / VB / Crystal Report / Dot net / Javascript / HTML

2005 – 2006    Missions for final clients (SME / SMI) – DBA SQL Server

  • Databases / applications migration from SQL Server 2000 to SQL Server2005
  • Development of RMA management application / Returns (interface with SAGE 500)
  • Development of a Final Sale Prices / label printing
  • Creation of SQL server instances / managements plans – Queries tuning.

Windows 2003 server / SQL Server 2000-2005 / ASP / VB 6

01/2002 – 02/2005     System information development – Telecom

  • Development of RMA management tool of mobile phones – fixing and dispatching management for CEGETEL SI
  • Development of RMA management tool for SFR – fixing status tracing
  • Development of RMA tool for mobile phones – management of invoices / orders / status tracing – GE Beauvais

SQL Server 2000-2005 / ORACLE 9 / ASP / VB / Crystal Report / Dot net / Javascript / HTML

2003 – 2005                 System information development for FILTRAL France – SQL Server DBA

  • Development of data import between Sage and 2 SQL Server (10 tables, containing 4000 000 records, 2 times per day – ActiveX development – Indexing – Optimization of response time.
  • Development of EDI with CARREFOUR SPAIN – Extract of invoices from SAGE 500 – Computing / formatting to EDI Format – Tracing / flagging of extracted and sent invoices on FTP site
  • Treatment of final customer sales prices for distribution companies (Leclerc Carrefour). Mamangement of business rules (net price, raw price) – Invoices transformation, reporting, printing of label with the final price (Euro and French currency) – 15000 labels printed per day

SQL Server 2000-2005 / VB6 / Crystal Report / Dot net

01/2000 – 02/2003     Audit and development of Financial and commercial Information System

  • Structural audit of CAREX-ELDORAUTO (350 employees) and implementation of a centralized information system consolidating 26 remote sites – Interface with insurance systems (DARVA) and Pacte Office (Renault) – New functional and structural concept implementation
  • Development of an extracting tool : invoices in order to send to Factoring company – Tracing – for CAREX-ELDORAUTO. Extraction from SAGE – formatting to SAP format – automatic sent by mail and fax

SQL Server 2000-2005 / Oracle / ASP / Crystal Report / Dot net / Javascript / HTML / VB6 3/3 Microsoft

2000 – 2001         Development of website for Mercedes – French central bank – Adaptec

  • Development of MERCEDES FRANCE online shop – online payment
  • Development of automatic HTML generation application from dynamic data – in order to workaround the security rules that did not allow dynamic technologies at French central bank.
  • Development of 4 modules of the European ADAPTEC website in 6 languages: Cable selector / Product selector / Reseller selector / …

Windows NT4-2000 server / SQL Server 7-2000 / VB 6 /ASP / Architecture 3/3 / MTS /

1998 – 2000         Project management – Development CEGETEL SI –SQL server DBA (7/2000)

  • Mission of 30 months at CEGETEL SI
  • Team manager with 5 developers for CEGETEL SI
  • Migration of 350 applications Pack Office (version 6 to 97) at CEGETEL SI
  • Technical support level 2 and 3 for RAD applications / developments at CEGETEL SI
  • Data transfer application development, interfacing Tivoli (Active X development) at CEGETEL SI
  • Crisis management on a orders / invoices application badly developed by another company for Bourjois-Chanel
  • DBA and third applicative maintenance on ALATRANS (network troubles monitoring and management) at CEGETEL SI

VB 6 / HTML / Java / Architecture 3/3 / FTP, SQL Server7 et 2000, Access 97 et 2000, javascript / Sybase / Oracle

10/1996 – 10/1998     Project management for BOWNE GLOBAL SOLUTION – Microsoft / Oracle provider

  • Project management on Oracle Datamart
  • Project management on Internet Explorer 4 French version
  • Project management on Pack Office 2000 French version
  • Project management on Windows 98 French version
  • Interface between the final client (MICROSOFT Dublin or MICROSOFT Seattle) and the production teams
  • Software interface translation / localization (online help, books)
  • Soft and DLLs recompilations
  • Implementation of a translation tool based on memory segmentation
  • Kick off in Dublin et and Munich for different projects

Windows 98 / NT4 / Catalyst / MS Project

1994-1996        Software development – Technical lead

  • Mission of 15 month at SULZER France – Creation of a tracing and monitoring of marines engine / stationary engines.
  • Development of end user interfaces
  • Writing of client needs and rules
  • Writing of technical specifications
  • Development of diagnostic rules with business engineers
  • Development of synchronization interfaces between Access central database and remote database (differential)
  • Mission at MENDEZ Traduction – Technical lead on FrontPage 98 French version – Strings translation and Dll compilations

Windows 3.1 / NT4 / Catalyst / MS Project / VB 4 / Access 2.0

Formation

1987        Bac série A1 (mathématiques / Francais) – lycée Jeanne d’Arc

1988        Military Service in French Airforce – BA 717 – Saintes – France

1989 –1994     Psychology – Toulouse University – France

        License of clinical psychology Licence – Toulouse University – France

        Master of clinical psychology psycho-pathology – Toulouse University – France

Languages    

  • English (read, written, spoken)
  • Spanish (read, written, spoken)
  • French (read, written, spoken)