Pascal GILLET Software & Data Architect

• Post and Telecommunications Office of New Caledonia: OPT is the government agency in charge of the postal service and telecommunications in New Caledonia.
  • Specific Modules: Back-office web application providing billing and payment operations on top of BSCS, keeping a record of the organization’s sales and purchase transactions, and producing invoices, receipts and reports.
  • Self care: Front office web application allowing post-paid subscribers to manage their billing and account information, such as viewing their account balances and payment histories.
  June/July 2007: Mission in Nouméa, New Caledonia, for integration and development on the fly.
• Orange Cameroon: Stock (Inventory) management web application accessible from the Orange stores in all Cameroon, allowing creation of purchase order requests, product life cycle management and reporting; operating with the Alcatel's cashier application for product selling.
  September 2008: Mission in Douala, Cameroon, for integration and test with the customer.
• Angola Telecom: Adaptation of the Alcatel's billing suite solution previously put forward to Orange Cameroon and Orange Ivory Coast.
  
  • Responsible for organizing software resources (Oracle, BSCS on development & integration environments)
  • Responsible for making a prototype demo by simply adapting the products to english and portuguese languages (internationalization) and changing the visual appearance in compliance with the customer's visual identity
  • Promoted use of CVS branching and merging to maintain multiple versions of a product for providing support and new features while a generic abstract version is kept into the main trunk

Member of the techno cluster "JEE Best Practices".
Recognizing potential reuse in the organization or in the existent Alcatel’s applications, making these diverse systems able to work together (inter-operate) and promoting standardization during the design of software components:

• Made ready-to-use project templates embedding common tools and libraries
• Implemented sample applications as a good starting point for Alcatel's applications
• Implemented a reusable BSCS login module (JAAS) for the authentication and authorization of users
• Implemented a library achieving logging separation, i.e. distinct configuration of multiple web applications while sharing the logging binaries in the Servlet container (or any JEE environment)

Release 4: proposal and implementation of an architecture overhaul due to a performance degradation caused by an increasing activity and a monolithic architecture implemented on earlier prototype based solutions (poor mechanisms for file locking, then worked poorly with multiple users):

• Business logic components: EJB allowing concurrency control & transaction processing
• Application servers: JBoss (development), WebSphere (integration & production environments)
• Persistence layer: Hibernate
• RDBMS: Oracle
• Storage of raw data representing software in BLOBs
• Messaging service (JMS) for asynchronous data transfer (data mirroring) and operation notification

Proposal and implementation of the FLS library covering the ARINC specification. The library aims to read, write and validate Field Loadable Softwares by ensuring data integrity and authenticity. It has been primarily used within the architecture quoted above but can be reused for other applications within the airline organization as this file format is very widespread at it.

• Working environment: Study of different software solutions dedicated to data flow analysis in real time (neural networks, non-linear regressions)
• Realizations:
  • Preprocessing Java tool for historized data of fly campaigns from filing equipment of Command Control (process interface) to build a coherent and stable corpus
  • Java multi-layer perceptron (delta rule, gradient descent) to demonstrate that artificial neural networks alone are relevant for the given goal