Arnaud Degraeve
- Nationality: French
- Tel: +33 6 64 66 68 10
- Mail: adegraeve@virtualnetwork.fr
- www.arnaud-degraeve.com
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
- SQL Server all versions management
- Teradata 12 – 13 – 14 management
- Data securization – indexing – tuning – normalization and databases denormalization
- Networking (Installation – maintenance) Microsoft – Linux
- Interfacing with Oracle (data import via ETL, SSIS, Queries)
- Microsoft n/3 Architectures
- Dot net development (VB.net / C#)
- Securization and integration in Active Directory
- Execution plans – Queries and import processes tuning (hints, locks, guideplans …)
- Databases management and housekeeping
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)