Hamid O.

Project Context As part of a response to a call for tenders, participation in the realization of a POC: Integration, aggregation, and analysis of market data (reference and quotation). Technical Environment Hadoop, HBase, Scoop, Java, shell script Continuous Integration: Git, Jenkins Cloud: AWS Tasks: ▪ VM preparation (dev) + Hadoop installation ▪ Design and implementation of the HBase database ▪ Writing technical documentation

Mission Context PnL Eco vs Accounting reconciliation and reporting (R2D2 Project) Technical Environment C#, Oracle 1 1g R2, PL/SQL, Batch, Multithreading, TDD approach Continuous Integration: Jenkins, Nant, SVN Reporting: SAP Business Object XI 4.x Project R2D2 (Heavy Client): ▪ Participation in the Oracle migration from version 10g to 1 1g R2 ▪ Optimization and refactoring of the application's core business written in Pl\SQL by implementing new Oracle 1 1g features such as ResultCache, sequence increments, and Bulk processing based on AWR reports. ▪ Review and update of the partitioned and global index mapping (based on AWR and index usage monitoring) ▪ Participation in the development of the reporting module for monitoring monthly PnL evolution ▪ Participation in the development of user GUI needs evolution ▪ Refactoring of C# code at the client layer (GUI) and server layer to improve code quality and reduce technical debt, based on CAST reports (software quality factors) ▪ Configuration and setup of new functional scopes (region, entity, BU, SBU,…) ▪ Proposal and implementation of multi-threading: leveraging the physical capabilities of the application server by implementing parallelism for certain processes (with an application lock system) ▪ Security assessment: implementation of a secure connection (https) and the double-check process for user rights (client-side + application server-side) ▪ Participation in the development of evolution for the MOA test automation engine (BDD implementation) ▪ Unit tests with nUnit (TDD approach) and non-regression tests ▪ Participation in the initial steps of preparing the R2D2 application for "Continuous Delivery" mode by increasing the coverage rate of unit tests and MOA tests, removing dead code (C#, PL\SQL) Decision Support Project (SAP Business Object XI 4.x): ▪ Implementation of the data model based on materialized views and a daily snapshot process for data historization ▪ Sizing of storage space requirements ▪ Implementation of the model and implementation of the BusinessObject universe ▪ Implementation of contexts to manage daily indicators and different time axes: monthly, quarterly, and annual ▪ Development of Webi reports ▪ User training on using the LaunchPad module (autonomy in creating Webi reports) and documentation ▪ Technical documentation of the implemented solution to facilitate future evolutions and maintenance ▪ Administration tasks: LCM, user rights and profile management, and publication management for automatic generation and sending of reports in various formats (xlsx, pdf, cvs,..)