Johann Morales

Situation: Need for a reliable and high-performance PnL calculation to integrate new data sources and meet business requirements. Task: Develop and optimize PnL calculation processes while ensuring system stability and maintainability. Actions: • Developed new PnL calculation processes and integrated new data sources • Optimized Spark jobs and migrated to Spark 3 to improve performance and reduce processing times • Implemented and maintained Power BI dashboards to monitor production • Automated deployments via CI/CD pipelines • Provided application support and production management, including on- call duties Results: • Reduced processing time by 30% • Improved reliability and simplified production monitoring

Situation: Existing market reserves calculation methodology was either non- existent or obsolete. Task: Develop and industrialize new reserve calculations while ensuring system stability and performance. Actions: • Developed new reserve calculations in collaboration with prototype developers • Implemented unit and integration tests to ensure development robustness • Managed deployments and automated processes via CI/CD pipelines • Provided application support and production maintenance Results : • Improved calculation accuracy • Reduced reporting errors

Situation: Need for a high-performance and scalable solution to visualize data quality control results with optimized ingestion for data visualization tools Task: Add new data sources, optimize their preparation and resources consumption, and enhance the maintainability and industrialization of the project Actions: • Integrated new data sources for control results • Prepared and transformed data for optimal consumption in data visualization tools • Developed a previously non-existent test suite • Implemented a CI/CD pipeline to automate deployments • Trained and mentored junior developers • Migrated the project to a new Big Data cluster with enhanced security standards • Led technical workshops and ensured compliance with Data Management standards Results: • Faster processing and improved accessibility of data in visualization tools • Increased project stability through testing and CI/CD implementation • Empowered team, making them independent in handling complex topics • Successful migration, ensuring better scalability and performance • 100% compliance with Data Management standards

Situation: A data control engine was extracted from an existing project to make it reusable and applicable across multiple projects Task: Improve and modernize the application while supporting client teams in implementing their technical and functional data controls Actions: • Trained and assisted client teams in implementing their data control. • Optimized extracted code to align with Spark best practices • Developed a robust test suite • Redesigned the application to simplify client adoption of the framework • Established a CI/CD pipeline to automate deployments • Conducted technical workshops Results: • Achieved a 75% average improvement in processing performance • Enhanced ease of use for the framework • Increased project stability through testing and CI/CD • Adoption of the framework by multiple new clients