John P.

Experience

• 

  Movimiento Independiente de Renovación Absoluta "MIRA"

  Oct 2011 - Aug 2014

  PHP:Created and maintained custom-made applications.Yii 1:Developed models, views, and controllers for forms, reports, and information listings.JavaScript:Made modifications and created code for the client-side of modules created in PHP.HTML:Layout design for the modules.CSS:Modified the display of content in views.HappiJS:Created endpoints for data creation, deletion, and updating.PostgreSQL:Created and modified tables, triggers, indexes, constraints, foreign keys, and materialized views. Show less

  • Development Engineer

    Oct 2012 - Aug 2014

  • Analyst Engineer

    Oct 2011 - Oct 2012
• 

  ICETEX

  Sept 2014 - Sept 2015

  Development Engineer

  Oracle DB:Created scripts for daily scheduled job review on the server.SQL Developer (Oracle):Developed SQL scripts for data updates using stored procedures.Created SQL statements to update user platform information.Oracle Linux:Installed the operating system on a USB drive to gain more knowledge about the Oracle database and perform SQL query optimizations.ICETEX Platform:Created an Excel file with user data and a Word email template for user notifications.Designed a mail merge for mass emails to active platform users. Show less

• 

  Movimiento Independiente de Renovación Absoluta "MIRA"

  Apr 2016 - Dec 2017

  Development Engineer

  DEVOPS:Created scripts to automate tasks between servers using SSH agents with GPG keys for backup transfers, among other tasks.Configured the Apache and MySQL servers to customize server usage.Set up alerts on the server that were sent to the development team, notifying them of the slowest SQL queries for optimization.Provided guidance on the purchase of new infrastructure tools.Configured 3 data servers with a mirrored structure, including 2 productive servers with data replication and one for reading data using MySQL databases.PHP:Developed custom web software, creating models, controllers, and views for each module.Implemented libraries for generating customized PDFs sent via email.Yii 2:Created custom migrations to transfer data from old models to new structures.Developed applications from model to view.Created forms for entering data into multiple tables.Designed list-style information collection reports, where each indicator led to another list.MySQL:Designed data structures for new modules and modified/created indexes to optimize performance.JavaScript:Modified client-side components to reduce server workload using JavaScript objects.Git:Migrated the application's code from GitHub to GitLab for CI/CD use. Show less

• 

  Millicom (Tigo)

  Apr 2018 - May 2020

  Development Engineer

  JavaScript (Approximately 7 applications):Test-driven development using comprehensions and structuring.Unit testing (TDD).ReactJS (Approximately 5 applications):Utilization of function components.Use of hooks like useState and custom hooks.Consuming endpoints and optimizing performance.Zendesk (Approximately 10 applications):Created enterprise-type React applications with MVC architecture.Scrum:15-day sprints with all ceremonies applied.

• 

  BITS Americas S.A.S

  Jun 2020 - Jun 2022

  Development Engineer

  Python:Utilized list comprehensions, functions, and error handling.ReactJS:Developed unit testing and apps using custom hooks.Odoo (Python):Developed applications using the Odoo Framework.Created views, models, reports, computed fields, and controllers.Conducted maintenance on modules with dependencies and other modules, managing inheritance towards models and views.PostgreSQL:Created tables with indexed fields to achieve optimal performance.

• 

  Freelance

  Sept 2022 - Aug 2023

  Full Stack Engineer (Angular, Flutter, NodeJS)

  Flutter:Gradually migrated an application to the null safety version.Developed features using provider, cubit, bloc, and riverpod.Implemented screen pagination.Uploaded to Google Play Store and Apple App Store, connecting beta and production versions.Created a registration form with QR code integration for linking information.Modified forms and optimized application performance.Fixed bugs and designed custom layouts using custom painter.Implemented routing to improve communication with web and external links.Configured authentication with Google and Apple.Node.js:Created and modified endpoints.Developed middlewares to transfer information between models.Optimized response times.Configured the connection to work locally when internet access was unavailable for development.Angular:Modified templates to display information correctly.Created pipes.Created modules with routing and without.MongoDB:Created indexes and optimized update queries.Created documents and conducted information consistency testing along with Node.js. Show less

• 

  Autónomo

  Aug 2023 - Jan 2024

  Ingeniero Backend "Senior" - Frontend "Semi Senior"
• 

  Ocati S.A.

  Jan 2024 - Aug 2024

  It developed:- New modules using Odoo framework- New functionalities to existent modules It developed:- New modules using Odoo framework- New functionalities to existent modules

  • Software Developer Engineer

    Apr 2024 - Aug 2024

  • Software Developer Engineer

    Jan 2024 - Mar 2024