Franco Arratia Email & Phone Number

Cochabamba Department, Bolivia

Cochabamba Department, Bolivia

Cochabamba, Bolivia

𝗦𝘂𝗺𝗺𝗮𝗿𝘆: Technological platform that specializes in logistics services, job assignment, real-time tracking, truck management and route optimization. All this in the construction and materials transportation industry. • I had the opportunity to learn about the project almost in its entirety, all of this because I participated in the implementation of new features in almost all of the platform's microservices.• I was responsible for the implementation from scratch of some particular microservices, defining the structure of the project, and its architecture.• I got involved in the refactoring of several microservices modules, improving the performance and maintainability.• I actively participated in the technical documentation of the implemented services and their interaction with all the involved microservices.𝑻𝒆𝒄𝒉𝒔𝒕𝒂𝒄𝒌: 𝑀𝑖𝑐𝑟𝑜𝑠𝑒𝑟𝑣𝑖𝑐𝑒𝑠, 𝐴𝑚𝑎𝑧𝑜𝑛 𝑊𝑒𝑏 𝑆𝑒𝑟𝑣𝑖𝑐𝑒𝑠 (𝐸𝐶2, 𝑆3, 𝑅𝐷𝑆, 𝐿𝑎𝑚𝑏𝑑𝑎, 𝐾𝑖𝑛𝑒𝑠𝑖𝑠, 𝐸𝐶𝑆), 𝐷𝑜𝑐𝑘𝑒𝑟, 𝐽𝑎𝑣𝑎8, 𝐽𝑎𝑣𝑎17, 𝐷𝑟𝑜𝑝𝑤𝑖𝑧𝑎𝑟𝑑, 𝐽𝐷𝐵𝐼, 𝑅𝑒𝑑𝑖𝑠, 𝑇𝑤𝑖𝑙𝑖𝑜, 𝑀𝑎𝑛𝑑𝑟𝑖𝑙𝑙, 𝐶𝑜𝑢𝑟𝑖𝑒𝑟, 𝑆𝑡𝑟𝑖𝑝𝑒, 𝑃𝑙𝑎𝑖𝑑, 𝑂𝑟𝑎𝑐𝑙𝑒 𝑁𝑒𝑡𝑠𝑢𝑖𝑡𝑒, 𝐺𝑖𝑡, 𝐺𝑖𝑡𝐻𝑢𝑏, 𝐺𝑖𝑡𝐻𝑢𝑏 𝐴𝑐𝑡𝑖𝑜𝑛𝑠, 𝐽𝑒𝑛𝑘𝑖𝑛𝑠.

San Francisco, California

𝗦𝘂𝗺𝗺𝗮𝗿𝘆: System specialized in energy efficiency solutions for commercial clients and industrialists in the United States. • Improved the performance of the system by refactoring/improving some SQL queries and stored procedures and ETL processes of the application (the average improvement was 40%).• Implemented a library for the integration of Hangfire with the project for the purpose of executing tasks in the background.• Improved the performance of the project by refactoring the data access layer following good practices, the correct use of ORM annotations and the improvement of SQL queries (NHibernate was the ORM used in the project).• Defined good practices for coding, and the standardization of tools for the team.• Trained new members regarding Java technologies, the spring framework ecosystem and CI/CD tools.𝑻𝒆𝒄𝒉𝒔𝒕𝒂𝒄𝒌: 𝐶#, 𝑈𝑛𝑖𝑡𝑦, 𝐴𝑑𝐻𝑜𝑐𝑄𝑢𝑒𝑟𝑖𝑒𝑠, 𝐴𝑆𝑃.𝑁𝐸𝑇 𝑀𝑉𝐶 5, 𝑁𝐻𝑖𝑏𝑒𝑟𝑛𝑎𝑡𝑒, 𝐻𝑎𝑛𝑔𝑓𝑖𝑟𝑒, 𝐻𝑇𝑀𝐿, 𝐶𝑆𝑆, 𝐴𝑛𝑔𝑢𝑙𝑎𝑟, 𝐵𝑜𝑜𝑡𝑠𝑡𝑟𝑎𝑝

Cochabamba, Bolivia

𝗦𝘂𝗺𝗺𝗮𝗿𝘆: Monolithic project mainly focused on the medical area. Some of the main features are: Predictive modeling solution for healthcare fraud, automated customer service fraud prevention solution, and social forms technologies for the medical industry.• Researched about architectural patterns to take into account for the development of the project (Layered, Event-Driven, Micro-Kernel, Space-Based and Microservices).• Participated in making decisions and defining the architecture of the project (The defined architecture was microservices).• Participated in the research and definition of the technological stack for the implementation of microservices (Spring Cloud, Eureka, Zuul, Ribbon, Hystrix, etc).• Implemented from scratch some of the microservices defined by the team, such as: Document Management System - DMS, and its orchestration with the other microservices.• Participated in the definition and configuration of the Continuous Integration - CI and Continuous Delivery - CD processes.𝑻𝒆𝒄𝒉𝒔𝒕𝒂𝒄𝒌: 𝑀𝑖𝑐𝑟𝑜𝑠𝑒𝑟𝑣𝑖𝑐𝑒𝑠, 𝐴𝑚𝑎𝑧𝑜𝑛 𝑊𝑒𝑏 𝑆𝑒𝑟𝑣𝑖𝑐𝑒𝑠, 𝐷𝑜𝑐𝑘𝑒𝑟, 𝐾𝑢𝑏𝑒𝑟𝑛𝑒𝑡𝑒𝑠, 𝐽𝑒𝑛𝑘𝑖𝑛𝑠, 𝐺𝑖𝑡, 𝐽𝑎𝑣𝑎8, 𝑆𝑝𝑟𝑖𝑛𝑔 𝐹𝑟𝑎𝑚𝑒𝑤𝑜𝑟𝑘 𝐸𝑐𝑜𝑠𝑦𝑠𝑡𝑒𝑚, 𝑁𝑒𝑡𝑓𝑙𝑖𝑥 𝑂𝑆𝑆 𝑆𝑡𝑎𝑐𝑘 (𝐸𝑢𝑟𝑒𝑘𝑎, 𝑍𝑢𝑢𝑙, 𝑅𝑖𝑏𝑏𝑜𝑛, 𝐻𝑦𝑠𝑡𝑟𝑖𝑥), 𝑀𝑦𝑆𝑄𝐿, 𝑀𝑜𝑛𝑔𝑜𝐷𝐵, 𝐴𝑛𝑔𝑢𝑙𝑎𝑟𝐽𝑆, 𝐵𝑜𝑜𝑡𝑠𝑡𝑟𝑎𝑝.

Cochabamba, Bolivia

𝗦𝘂𝗺𝗺𝗮𝗿𝘆: On-premises and cloud system that was leading accounting software for nonprofits and government organizations. Designed to let you track unlimited funds and manage your books with ease. • Became the reference in the Entity Framework technology, providing support and training to the other project teams.• Worked on the migration of a project implemented with Visual Basic 6 to a new one with current technologies at the time as dot Net Framework 4.5• Refactored the project's persistence module to make it more testable (unit tests in the data access layer - DAL). With this refactoring we were able to increase the test coverage of the project.• Implemented a tool that was used to restore test environments to their initial state, the specific module of the tool consisted mainly of restoring very large databases to an initial state so that the quality control team could test the new features added in each sprint. The improvement in process time was 93%. This process used to take an average of half an hour, after the implementation of the tool's module it took between 2 to 3 minutes.𝑻𝒆𝒄𝒉𝒔𝒕𝒂𝒄𝒌: 𝐶#, 𝐶++, 𝐸𝑛𝑡𝑖𝑡𝑦 𝐹𝑟𝑎𝑚𝑒𝑤𝑜𝑟𝑘, 𝑀𝑎𝑛𝑎𝑔𝑒 𝐸𝑥𝑡𝑒𝑛𝑠𝑖𝑏𝑖𝑙𝑖𝑡𝑦 𝐹𝑟𝑎𝑚𝑒𝑤𝑜𝑟𝑘 (𝑀𝐸𝐹), 𝐴𝑆𝑃.𝑁𝐸𝑇 𝑀𝑉|𝐶 5, 𝑂𝑊𝐼𝑁, 𝐻𝑇𝑀𝐿, 𝐴𝑛𝑔𝑢𝑙𝑎𝑟 𝐽𝑆, 𝐾𝑒𝑛𝑑𝑜 𝑈𝐼, 𝐵𝑜𝑜𝑡𝑠𝑡𝑟𝑎𝑝, 𝐽𝑎𝑣𝑎𝑠𝑐𝑟𝑖𝑝𝑡

Cochabamba, Bolivia

• Implemented from scratch a distributed system to manage the tasks carried out on a computer. A system which used to extend its functionality through plugins. (Technologies: C#, SOA architecture, WPF, WCF, Entity Framework, MAF, ASP.NET)• Implemented from scratch an extensible console tool that generates statistical graphs from Mercurial logs. This had the ability to extend its functionality to read the logs of subversion, perforce, etc. (Technologies: Java, JfreeChart, Json Libraries, HTML, CSS, Javascript)

Engineer In Commercial Software Development, Computer Software Engineering

Ingeniero De Sistemas, Computer Science

Activities and Societies: Jala Foundation