Samuel Gomes, Developer in Barcelona, Spain
Samuel is available for hire
Hire Samuel

Samuel Gomes

Verified Expert  in Engineering

Solution Architect and Developer

Location
Barcelona, Spain
Toptal Member Since
June 16, 2021

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.

Portfolio

Freelance (Toptal Clients)
Oracle, Oracle Application Express (APEX), PostgreSQL...
International Workplace Group (IWG)
C#, Azure, Microsoft SQL Server, Microsoft Power BI, Databricks, SQL, Azure SQL...
Learnlight
C#, PostgreSQL, Node.js, Amazon Web Services (AWS), Jenkins, Docker...

Experience

Availability

Part-time

Preferred Environment

PostgreSQL, Node.js, C#, Amazon Web Services (AWS), Azure, Microsoft SQL Server, Apache Kafka, Jira, Confluence, APIs

The most amazing...

...solutions I've worked on helped corporations digitalize their workflows in sales, retail marketing, field service, mobile banking, and e-learning markets.

Work Experience

Data Engineer

2021 - PRESENT
Freelance (Toptal Clients)
  • 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.
Technologies: Oracle, Oracle Application Express (APEX), PostgreSQL, Amazon Web Services (AWS), .NET, Microsoft SQL Server, Python, Google Cloud, Data Warehousing, Jira, Trello, Docker

Technical Solution Architect

2021 - 2021
International Workplace Group (IWG)
  • Designed a solution to unify customer access to business centers and rooms and identify related services, such as printing and coffee. The solution impacted 200,000 customers in phase one and two million in phase two.
  • Created a technical documentation template on Confluence and migrated the existing solutions to it.
  • Became a central technical reference for all solutions used in the business centers and worked with other solution architects and enterprise architects to create conventions and standards.
Technologies: C#, Azure, Microsoft SQL Server, Microsoft Power BI, Databricks, SQL, Azure SQL, Azure Data Factory, Azure Data Lake, Jira

Head of Software Development | Database Administrator

2014 - 2020
Learnlight
  • 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.
Technologies: C#, PostgreSQL, Node.js, Amazon Web Services (AWS), Jenkins, Docker, JasperReports, Agile, Confluence, Bitbucket, GraphQL, PL/pgSQL, SQL, ETL, Data Warehousing, Jira

Solution Architect | Project Manager

2010 - 2013
Spring Global
  • 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.
Technologies: C#, ASP.NET, Microsoft SQL Server, Web Services, SAP Process Integration (PI), SAP BusinessObjects Data Service (BODS), Confluence, Project Management Professional (PMP), ETL, Data Integration, SQL, Data Modeling, Jira

Senior Software Developer | Team Leader

2006 - 2010
Spring Global
  • 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.
Technologies: C#, ASP.NET, Java, Microsoft SQL Server, SQL, Data Modeling, APIs, Web Services, Data Warehousing

Learnlight E-learning Platform

https://app.learnlight.com
A C# and PostgreSQL edtech learning platform. I optimized the platform code and moved inefficient NHibernate queries to high-performing PL/pgSQL queries. This allowed us to move the solution to AWS EC2s and expand the number of students. I also kicked off the migration from C# to Node.js.

Unilever Copacabana Acceleration, Middle Americas

Sales automation, using an M-series application for Windows, Windows Mobile, and iOS, with hundreds of users in Venezuela, Colombia, and Ecuador, covering the foods, personal care, and ice cream divisions. I was the project manager and solution architect, working with a team of 12 developers. You can see a promotional video shown to current and prospective customers here: https://vimeo.com/139851304.

Unilever Copacabana, Brazil

Sales automation, using an M-series application for Windows and iOS, for hundreds of users, nationwide in Brazil, covering the foods, personal care, and ice cream divisions. I was the solution architect and project manager, leading a team of 21 developers.

Santander Mobile Banking, Brazil

An all-in-one mobile banking platform for iOS, BlackBerry, and Android, using an M-series MCP framework, with hundreds of thousands of users nationwide. As the project manager and tech lead, I delivered this solution with only three developers.

Languages

PL/pgSQL, SQL, C#, Java, GraphQL, C#.NET, Objective-C, Python

Paradigms

Agile, ETL

Storage

PostgreSQL, Microsoft SQL Server, Data Integration, Oracle PL/SQL, MongoDB, Azure SQL, Google Cloud

Other

Data Engineering, Data Modeling, APIs, Web Services, Project Management Professional (PMP), Data Warehousing, SAP Process Integration (PI), SAP BusinessObjects Data Service (BODS), Design, Lean Project Management, Gestalt Laws, Semiotic Analysis, Azure Data Factory, Azure Data Lake

Tools

Bitbucket, Jira, Confluence, Jenkins, Microsoft Power BI, Oracle Application Express (APEX), Trello

Frameworks

ASP.NET, .NET

Libraries/APIs

Node.js, JasperReports

Platforms

Amazon Web Services (AWS), Azure, Apache Kafka, Docker, Databricks, Android, iOS, Talend, Oracle

2002 - 2005

Bachelor's Degree in Graphic Design

São Paulo University Center for Fine Arts - São Paulo, Brazil

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring