Denis - DBA JAVA

PROFESSIONNAL EXPERIENCE

October 2017 – March 2022: Global Jet Luxembourg, Grand-Duché de Luxembourg (freelance)

Senior Developer

From the old central in-house database, I have re-designed and created a new normalized RDB. Wrote fast MySQL stored procedures to migrate the data. Coded main Rest Web Services to expose technical flight data and crew members.
Reverse engineering of a NodeJs scheduled job to compute fuel indices and presenting many flaws. Re-wrote it in the Rust programming language. The performance increased from a 7 min computation to 5 seconds.
| Rust, Cargo, MariaDB Crate.
Build Java agents in order to synchronize Aircrafts, Crew and Technical information between internal GlobalJet systems and Jeppesen Operator.
Used the Enterprise Service Bus (ESB) to exchange XML messages between business applications.
Read specifications and generate Java clients for REST vendor APIs.
Design SQL queries to grab relevant information from the source system.
| Java 11, ActiveMQ, Spring Boot, Spring JMS, MariaDB.

Project Manager, Technical Leader

Managed a 5-person team with junior profiles.
Defined a microservice architecture in order to have perfect reliability, great scalability and very good performance
| Java 11, Spring boot, Spring Cloud.
Used Netflix eureka and Zuul Java framework to handle the microservice registration and api gateway.
| Zuul framework
Managed a project for a mass-market reservation broker (Conception, Development, Tests, Integration).

Senior Developer

Analysed the business data flow of GlobalJet in order to understand the integration concerns.
Put in place an architecture based on an Enterprise Service Bus (ESB) to exchange XML messages between business applications.
Used XSD to define the structure of the business messages on the ESB.
Implemented separate Java Agents to read the data from the master systems and then update the target systems.
Implemented a microservice to separate the concern of reading data from a third-party application (MINT).
Used the Unbound Id LDAP Library to read a write data to Microsoft Active Directory.
| Java 11, ActiveMQ, Spring Boot, Spring JMS.



August 2013 - September 2017 - FREELANCE JAVA DEVELOPEUR, Luxembourg.

C/C++ Developer - Real Solutions, Grand-Duché de Luxembourg

Found bugs in the C/C++ code of the license manager IBSY banking application
Analyzed and fix the code regarding the business needs.
Analyzed compilation and dynamic libraries issues
Wrote tests programs to enhance the reliability of the modules.
| C/C++ Solaris, GCC compiler.

Senior Java Developer - Chamber of Deputies, Grand-Duché de Luxembourg

Optimization of the SQL requests for Informix 11.
Use ehcache to minimize access to the database.
Wrote new API in Java to optimize the search of “petitions” in the system.
Fixed Java portlets to make them work on IBM Portal 8.5.
| Java 8, EhCache, Eclipse Neon, Git, JIRA, Sonar and Jenkins for Continuous Integration.

SENIOR JAVA DEVELOPER, Luxembourg. - CACEIS Luxembourg, Grand-Duché de Luxembourg

Web Service development to allow consultation of “Cash” movements.
Maintenance of the payment application « PRECAPTURE »
Conception and development of Restful Web Services being used in various client application.
Analyzed existing JMS services in order to offer same features though REST protocol.
Used of Swagger to test the REST APIs.
Wrote JUnit Tests to compare the results between new and old APIs.
| Java 8, JEE, Hibernate, WebSphere 7/8, Maven and IBM Rational Team Concert (based on Eclipse).




November 2006 – July 2013 – Checkfree Solutions SA (now Fiserv Inc), Luxembourg.

Java / JavaScript Developer

Conception of global solutions of Electronic Content Management: Actively participate in the different phases of the ECM process: Acquisition (Scanning), Recognition (OCR), Classification (Indexing), Storage, Search and Found of documents.
Designed and developed the Web forms for the in-house application (Web client for the IBM Content Manager ECM).
| Java 1.6, IBM Content Manager 8.
BDO Financial Accounting. Built web screens and coded the asynchronous communication with the database.
| Java 1.6, AJAX. Tomcat 6.
Reverse engineering of the in-house web application. Kernel refactoring, Independence of modules, OOP.
| JavaScript, TypeScript (early version), HTML, CSS.
Spool management for a virtual printer to allow printing from MS Office.
Definition and implementation of the Webservices for the Chamber of Deputies of Luxembourg.
| Java 1.6. SOAP, Spring, IBM WebSphere 7.

Accurate NXG Solution Developer

“Template” module for Accurate NXG: Designed and developed the “Template” module for the Accurate NXG reconciliation application. Built upon 45 reports and 23 Java or PL/SQL stored procedures, customizable for every single client (Loading error management, Pending cases, Workflow and Department/Service distribution, etc). Performance tuning. Followed and uploaded source components to CVS.
SGAM, Société Générale Asset Management: Designed and coded the routine for the balanced repartition of accounts to process by service, regarding the weight of each account (for SGAM, Société Générale Asset Management).
| Java (J2EE), Accurate NXG Scripting.
CACEIS (Crédit Agricole Group): Fixed and improved the reports, PL/SQL performance tuning (reduced the processing time from 12 hours to 4,5 hours).
| SQL, PL/SQL on Oracle 10g.
CNCE (Caisse d’Epargne Group): “Interests scales” computation routine. Accurate NXG Scripting Language, Java, Oracle 10g.




May 2001 - September 2006 – Consulting for ITI inc, Victoria, British Columbia, Canada

Senior Java Developer, Victoria Life Insurance – 2004-2006

Object Oriented Design (UML) of the « Underwriting documents » and « Fees distributions » modules, part of a new life insurance application. Used Together 6.0.
From user’s specifications, implemented the module that creates the roles linked to an insurance policy. Used of Java (JDK 1.4), Swing, JBoss, Eclipse 3.0 and a persistence framework similar to Hibernate.
In collaboration with the architects’ team, defined Data flows based on web services. Integration of the AXIS module into JBoss. Creation of web services in order to validate our approach. Generated the XML Data Structures (XSD). Fixed compatibility issues between the different implementations of the WSDL standard.
Involved in the creation of the Quality Assurance procedure (Code review, Junit tests, PMD Check, etc.)

Oracle / Java developer – Ministry of Forest May 2001-2004

Analyzed the various former back-office systems. Worked with the users to extract the business rules and determine all potential issues in the data to convert. Analyzed the new back-office system from the logical model and the documentation. Reverse-engineered the legacy systems into Oracle Designer 6i. Layout the Database Model. Established strategy and policies for the data conversion and mapped data between the source systems and the new back-office systems. Used Java/JDBC to generate a PL/SQL package for every table of the target database. Programmed the data conversion routines in PL/SQL.
Lead Oracle developer on the Coastal Selling Price (CSP) system at the Ministry of Forests, Revenue Branch. Development tools used include Oracle 8i, Pro*C and PL/SQL. Shell script on Sun Solaris.
Thoroughly analyzed the existing C++ credit card transaction multiplexer to find bugs and compared it to the Java solution. Decided to program the multiplexer project in Java. Designed the software’s architecture. Wrote a JAVA/COM object to create a TCP/IP client, which we could call from an ASP page.
| C++, Oracle Pro C
Implemented business screens for the Florida Project, using the Silver Lake’s programming style specifications. Programmed servlets in Java, using the JDK1.3 and the Oracle XML library. Improved the generated JavaScript code, and Oracle PL/SQL packages to handle new kinds of screens.


June 1995 - March 2001 – IGA, ABC Arbitrage, Paris, France.
Software Engineer, Finance.
Designed and developed an insurance application for the Windows operating system. Windev 3.0, Oracle 6/7, PL/SQL, Visual C++.
Designed and developed Windows applications for the Stock Market division in Visual C/C++, SQL Server.
Developed and optimize SQL queries and processes for the real time analysis of the different market place quotations, aimed to determine financial arbitrage opportunities.
Designed databases and business tools for the stock market activities of ABC Arbitrage
| Power AMC 7.0, Visual C++, DCOM and ADO, SQL Server 7.0, Transact-SQL stored procedures.