Rim Ghzeail

Designing, developing, and maintaining a traffic management application that integrates SNCF data related to train circulation, commercial schedules, products, provisions, sales, and revenue collection for onboard railway catering services. Monitoring and controlling sales and revenue collection by implementing interactive dashboards and analytical reports. Developing PL/SQL procedures and packages to automate data processing and improve data flow quality. Participating in the migration of an Oracle Forms/Oracle Database application to a SQL Server database: Preparing mockups and prototypes for the new interface. Writing technical documentation (specifications, design, test procedures). Migrating Oracle PL/SQL procedures and functions to SQL Server (T-SQL). Testing and validating client-delivered batches before production deployment. Tracking tasks and team progress using Azure DevOps during sprint planning, with progress reporting and coordination with developers and the project manager. Technical Environment: Oracle APEX 19.1.0.00.15, Oracle Database 12c, PL/SQL packages, Triggers, JavaScript, HTML/CSS, SQL Developer, Azure DevOps, SQL Server, T-SQL

Development and Maintenance of a web application that manages various types of tests (Manual and Automated), including the insertion and recording of test results. Database Management of the application’s Oracle database, handling approximately 100 tables. Management of an Automatic Alert System: Implemented an email notification system using the UTL_MAIL package to send alerts based on predefined triggers. Quality Assurance Testing: Designed, developed, and executed automated test scripts to verify application functionality, ensuring quality standards are met. Performance Testing: Conducted performance testing using JMeter to evaluate the application’s scalability and stability under load. Technical Environment: Oracle APEX, SQL, PL/SQL, Postman, Katalon Studio, Jenkins, JMeter, Temenos T24

The development of "a digital bank " web application for the credit risk management department that allows it to deal with the credit requests and the huge volume of financial documents to be processed. Thus, it allows it to enhance the borrower experience with the bank by optimizing its credit application decision-making process. Our solution carries several modules: • Authentication and security of the application. • Connection of the application to the database including the borrower and his financial information. • Automation of recognition and extraction of key information from scanned documents by processing the images and applying the OCR technology on relying on more advanced techniques. •Storage of the extracted data. • Displaying the extracted data. • Calculation of financial ratios and displaying the credit acceptance or rejection deci- sion. Technical environment: Python, Django, Oracle, web technologies

The evaluation of automated commission rules on a Big Data architecture : The implementation of a Big Data architecture to automate the calculation of commissions in the telecom sector. Technical environment: kafka, flink, HDFS, kibana, elasticsearch

Decision making system in collaboration with gfi (cynapsys) This project consists in building a Business Intelligence Platform that improves business efficiency by analyzing the visitor’s activity and his shopping experience and displays automated recommendations and predictions. Technologies used: Elasticsearch, Logstash, Kibana (ELK), React.js, FireBase, NoSQL, Prediction Algorithms.