
Samuel Gomes
-
Project Success0
-
Total Service0
-
Completed Service0
-
In Queue service0
About Freelancer
Sam is an all-terrain solution architect with 15+ years of experience. He began his career as a full-stack C# developer and has since been a tech lead, delivery manager, project manager, database administrator, and head of development. Sam has led and developed sales, marketing, field service, mobile banking, and e-learning solutions for clients such as IWG, Unilever, P&G, Santander, Bosch, L’Oréal, and Carrefour. He loves to solve problems and get his hands dirty to deliver what clients need.
Education
Work & Experience
Developed sales automation solutions for companies, including Capel (beverages), Coopeuch (fintech), Bosch, and L'Oreal, increasing sales efficiency by 23%. Built a retail marketing solution for Carrefour, allowing merchandisers to research and report product pricing using PDAs. Developed a field services solution for SKY (Satellite TV), allowing technicians to manage work orders and communicate instantly with dispatch. Supported live applications, optimizing database queries and reports.
Developed sales automation solutions for Unilever, retail marketing for Procter & Gamble, and mobile banking for Santander and ItauBBA, supporting almost 500,000 users in total. Led and coordinated multiple teams of 3-21 developers located in Brazil and Colombia for multiple projects, using Jira, Confluence, and Microsoft Project. Worked closely with the client's technical team, designing complex integrations using batch files and web services.
Created new code and moved problematic NHibernate queries from the main application to PL/pgSQL stored procedures. This increased application performance by 230% while the number of students increased by 300% in the same period. Collaborated with the product team to translate business requirements into technical requirements and assisted in developing complex database functions. Tailored an Agile-based project management methodology, using sprints, Jira, and Confluence. Implemented CI/CD pipelines using Jenkins. Migrated the platform to AWS, adding fault tolerance, high availability, environment separation, and load balancing.
Migrated an Oracle APEX application and data warehouse to a new AWS RDS instance, tuning queries and optimizing database tables, such as partitioning and indexes. Tracked tasks and progress using Trello. Optimized queries, databases, and server settings for querying and processing millions of records daily for a financial services company; dockerized a server running an integration application; and used Jira to track and report progress. Assisted a retail company in migrating from Microsoft SQL to PostgreSQL and optimizing indexes and server configuration settings.
