toptal.com
Contact us: +1.888.867.7001
Samuel Gomes, Solution Architect and Developer in Barcelona, Spain
Samuel Gomes

Solution Architect and Developer in Barcelona, Spain

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.
Samuel is now available for hire
Hire Samuel

Portfolio

Experience

Location

Barcelona, Spain

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.

Employment

  • 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

Experience

  • 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.

Skills

  • 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

Education

  • Bachelor's Degree in Graphic Design
    2002 - 2005
    São Paulo University Center for Fine Arts - São Paulo, Brazil

To view more profiles

Join Toptal
Share it with others
Hire the top 3% of freelance developers TM