Andres Guerrero

Software Engineer

Banco de occidente•  February 2019 - Present

Responsible for the migration and mapping of tables and attributes of legacy data from Databases in SIIF and SISCAR to a new application in Oracle Flexcube using Oracle SQL. Member of the team in charge of the creation of new products and packages for the bank using Oracle Flexcube like: - Paquete Cuenta Activa Full - Paquete Cuenta Activa Básica - Cupo Rotativo Monoproducto Responsible for making the Functional and Technical documents for the requirements of data outputs that the bank needs during the data migration.

Software Engineer

Pontificia Universidad Javeriana Cali•  April 2018 - December 2018

Researcher, designer and developer in an innovation project for the public health system in Ladera. Using user centered design methods, the team will develop a strategy to improve the experience in the western areas of the city. Achievements: -Creation of emotional prototype to change the way women have an experience in the waiting room before there meetup with the doctor, by bringing a team of manicure specialists and giving them free manicures while they are taught with helpful tips and information about the importance of doing the cytology for cervix cancer. -Creation of a functional prototype of a special camera that captures an image of the cervix to determine if there is a risk of cancer in the patient thanks to artificial intelligence. This product changes the way that the traditional cytology is made since women surveyed find it very uncomfortable and invasive. We are currently looking for sponsorships to help us finish this prototype.

Software Engineer

Branding Doctors•  September 2017 - April 2018

Branding Doctors is a start-up company based in Frankfurt Oder, Germany. Our goal is to create unique brands and shape the future of companies, with a team of Strategic Marketers which work hand in hand with Designers and Web developers. We differ in customizing our services, especially personalized for each market and client. My Achievements: - Design the brand identity of a company based on a concept worked on previous stages. - Design the social media for Facebook, Instagram, LinkedIn and Twitter for the company and various other small enterprises in Poland, Israel and Chile. - Design printed materials like Brochures, Tri-Folds, Packaging, etc. for clients. - Design User Interfaces using Photoshop, Illustrator and Experience Design for websites or apps. - Maintain already existent websites using wordpress and filezilla. - Develop new websites for clients using worpress, html and css. - Developed the brand of Branding Doctors, as well as the design guidelines for presentations and social media.