Edmar Pelayo

Software Engineer Intern @JPMorganChase

Developed an application to optimize the consolidation of 40 different data sources creating a single view of a unified financial perspective. The processing time was optimized and reduced with a factor of over 15 minutes down to under a minute) Configured JP Morgan Chase\'s Oracle Cloud platform to host databases for data visualization on Oracle SQL Developer, optimizing financial instruments using Java backend. Developed the normalization of data sources, utilizing partitions and indexes, resulting in up to 95% reduction in query times. Collaborated seamlessly with cross-functional financial teams across global locations (London, India), tailoring schemas to specific use cases. Such as counting different Key Performance Indicators metrics across different Regions. Implemented version control for database tables using Liquibase, enhancing schema (table design) management and change tracking. Created a robust CI/CD pipeline with Jenkins, automating application build and deployment processes to allow for Continuous Integration and Continous Development of our project Devised and executed comprehensive mock unit tests (utilizing JUnit and Mockito) to ensure the reliability and security of software components within the Spring Boot framework, which served as the foundation for developing our CSV Upload API.