Jean-Roch LEFORT DATA ARCHITECT

*, ****** ** ***********

***** ******** - ******

mobile +33 (0)6 09 31 81 74

phone +33 (0)1 34 84 42 92

e-mail : ac91y0@r.postjobfree.com

born july the 29th, 1970 in Saint-Amand Montrond (France) birth language : french

fluent in spoken english, proficient in written english More than 20 years of experience in designing, implementing, mining and tuning databases. I am looking for a position where I can make the best value out of an information system. Case study, diagnostic, emergency actions, efficient design, training, tuning and optimization, repairs, damage control, failure recovery and documenting are strategic assets I can bring to increase the success of your company. PROFESSIONAL EXPERIENCE

January 2003 -

now

Database and software architect for WITBE (http://www.witbe.net) :

● Design, development, Tuning and evolution for all the databases of the company applications

● Data modeling, ER design, writing of guidelines for developers

● Documentation and specifications writing

● Software packaging and implementation of an extended quality services

● Customer service : installing, configuring, scaling, tuning and high level support

● Setup of a high level support service.

● Design of a cloud based storage, data mining and advanced reporting solution

● Database upgrades through Oracle versions from 7 to 12g

● Database migrations Oracle to Postgres, Oracle to cloud solutions (HBase, Hadoop, Elastic Search)

● Design and development using BIG DATA technologies (HBase, InfluxDB, TimeSeries, Cassandra)

● Implementation of an E.R.P. and interfacing with accounting solutions. September 1998 -

December 2002

Web site architect for QUAERIS S.A. (Paris) :

● Design and development of a dynamic data based web site page generator

● Design and development of internet and extranet web sites using enterprise databases

● Training facilitator for website design and server side programming

● Expert in diagnostic and critical situation recovery for large commercial websites (Kelkoo.com, Cdiscount.com, Hermès, La Vie Financière).

October 1994 -

August 1998

Technical consultant for CODA SOFTWARE S.A. (http://www.coda.com) (premium accounting software) :

● Design of an architecture, scaling and optimization of resources software

● Training facilitator for the technical configuration and API

● Setup of a high level technical support to improve customer experience

● High level service for customers including High Availability, Backups and Crash Recovery

● Design and development of taylor made applications

● Pre-sales presentations for the technical aspects of the solution

● Design and development of the first WEB interfaces for the company software suite

● Design of advanced reports in accounting analysis September 1993 -

September 1994

Software developer for ABSYSS (http://www.absyss.com/):

● Design and development of an event based Database Engine

● Design and development of an advanced scheduling language

● Design and development of a multi platform communication exchange code generator September 1992 -

August 1993

Assistant to the IT director of EPITA (https://www.epita.fr/en): computer engineering school

● Design and development of an automatic exam application for students

● Development of a management software for the School administration.

● Building, Installing, Configuring terminals and PCs for students. EDUCATION

EPITA : 1990 - 1992 Computer Science engineering School - Systems / Network / Database specialization Ecole Pour l'Informatique et les Techniques Avancées (Paris - France) Advanced Math : 1989 Preparation for engineering school - advanced Physics Mathématiques supérieures (Bourges - France)

High School : 1986 - 1989 Graduated with mention - Major Math / Physics / Biology Baccalauréat C & D - Mention AB (Bourges - France) SKILLS

Programming languages ● Mastered languages : C, Java (Applet, Applications, Servlets, J2EE), Visual Basic, C#(.Net), JavaScript, GoLang

● Application servers : IIS/ASP, Apache/PHP/tomcat, IBM WebSphere, BEA WebLogic, Oracle Application Server, Node JS.

● Mastered SQL languages : (Transact-SQL, PL/SQL, MySQL, PGSQL).

● Mastered scripting languages bash, tcsh, PHP,Perl,DOS,.

● XML manipulation languages : XSLT transformation (xalan, saxon), schema definition, parsing, indexing, querying.

● JSON manipulation

Development techniques ● Collection of needs

● Specification writing

● Application Prototyping

● Agile development method

● Automatic unit testing, stress testing, packaging and deployment

● Benchmarks, Advanced optimization and tuning, Scaling

● Database ER design (CaseStudio, AMC Designer, Embarcadero).

● Documenting about high availability, backup procedures, efficient diagnosing, crash recovery Miscellaneous experiences ● Pre-sale : introduction to the solutions, commercial proposals, targeted demos of solutions.

● General and Analytic accounting for multinational companies (for CODA customers)

● On site customer relationship management, onsite advanced assistance and critical situation handling.

● Emergency assistance, advanced diagnostic, short term fixes and specifications for long term improvements. Advanced tuning and optimization for large critical databases. (Cofinoga, Cetelem, Kelkoo, Cdiscount, France Télécom, BNP, AXA, Société Générale).

● Training facilitator about any topic in my competences.

● Consulting for advanced tuning, optimization and scaling

● Product Industrialisation and Quality management : implementation of development processes, Packaging automation, Test automation, Deployment automation Database Oracle Database version 6.0 to 12g :

● Installation, configuration, maintenance and optimization (any platform)

● Database administration : high volumes and availability, partitioning MS SQL Server jusqu'à 2012 ET Sybase (SAP Adaptive Server) :

● Database administration : high volumes and availability

● Migration tool design (C# .net) from mainframe databases MySQL de 3.23 à aujourd'hui (MariaDB) :

● Contribution to the open source community (optimization for High End computers)

● Advanced administration, replication, high volumes.

● Migration tools and procedures from old proprietary databases PostgreSQL up to current version :

● Advanced administration, replication, high volumes, partitioning

● Migration tools and procedures from Oracle, MS SQL, Sybase and MySQL BIG DATA :

Hadoop / Hbase / Storm / Kafka : implementing, development, installation automation, rpm packaging RHEL/CentOS, automatic deployment and administration. Elastic Search : architecture, deployment, index design, advanced querying and reporting using Kibana

JSON Based storage, indexation and querying.

Operating Systems UNIX

● Proprietary unix systems AIX, HPUX, Solaris : (administration and architecture)

● GNU/Linux RedHat / CentOS / Ubuntu : (administration, development, packaging) Windows Workstation and Server, Mac OS Workstations, Misc proprietary workstations (SUN, DEC, HP, Silicon Graphics, SONY)

Personal skills ● Graphic design / illustration

● Drawing / painting / photography

● Automobile and mechanics enthusiast

● Electronics / PC building

Contact this candidate