Juan is available for hire

Juan Andres Ramil

Verified Expert in Engineering

BI and Software Developer

Buenos Aires, Argentina

Toptal member since September 29, 2020

Expertise

Back-end Developers Web Development Front-end Full-stack SaaS AWS RDS SQL REST API Python GitHub HTML5 PostgreSQL

Bio

Juan is a full-stack engineer with over 20 years of experience and a strong background in BI and DW. He has defined the architectures for industrial IoT, web applications, and new microservices. He has successfully led re-engineering processes for core components on production systems and created and managed high-performance distributed engineering teams, among other tasks. He enjoys finding simple, cost-effective solutions for complex problems with a holistic and pragmatic approach.

Portfolio

Patron Technology, Inc.

Python, Team Leadership, Django, Amazon Web Services (AWS), Amazon EC2, MySQL...

Reventador

Architecture, Python, JavaScript, React, Amazon Web Services (AWS), Scrum...

FreshBooks

JavaScript, MySQL, PostgreSQL, Flask, SQLAlchemy, REST, Ember.js, Python...

Experience

SQL - 15 years
Python - 10 years
JavaScript - 10 years
PostgreSQL - 9 years
Docker - 5 years
Amazon Web Services (AWS) - 4 years
React - 3 years
Vue - 2 years

Availability

Part-time

Preferred Environment

Python, JavaScript, Flask, React, PostgreSQL, Amazon Web Services (AWS)

The most amazing...

...solution I've delivered is a layered reference architecture for a restful API service, allowing a fast development pace of reliable code.

Work Experience

Team Lead

2022 - PRESENT

Patron Technology, Inc.

Led the Ticketleap development and support teams. Ticketleap is an event marketing and management tool.
Oversaw the investigation and execution of projects to resolve and mitigate technical debt on the application affecting security, performance, and stability.
Coordinated support tasks to ensure overall system security, stability, and performance.

Technologies: Python, Team Leadership, Django, Amazon Web Services (AWS), Amazon EC2, MySQL, Microsoft SQL Server, PCI Compliance, Firebase, DevOps, Ansible, Amazon RDS, JavaScript, Technical Leadership, API Gateways, Architecture, AWS Lambda, Amazon Aurora, Front-end, Full-stack, Web Development, REST APIs, Containers, GitHub, Redis Cache, AWS DevOps, Microservices, OAuth, Full-stack Development, Amazon S3 (AWS S3), AWS Secrets Manager, HTML, CSS, HTML5, Amazon Simple Queue Service (SQS), Amazon DynamoDB, Back-end Development, Containerization, Software as a Service (SaaS)

Team Lead Full-stack Software Engineer | Software Architect

2022 - 2022

Reventador

Took over an abandoned project with an existing non-functional codebase and created a new software engineering area to take over the stalled project.
Defined the working methodology, operational road map, project structure, and metrics for the whole software engineering area.
Documented and defined the high-level architecture for the complete system and the detailed level architecture for the individual modules.
Built a new engineering team from the ground up and defined operational processes for a high-performance team.

Technologies: Architecture, Python, JavaScript, React, Amazon Web Services (AWS), Scrum, PostgreSQL, DevOps, Apache Kafka, Industrial Internet of Things (IIoT), Team Leadership, Redis Streams, Redis, GitOps, Web Development, APIs, Software Architecture, Back-end, CI/CD Pipelines, Technical Leadership, Microservices Architecture, API Gateways, Front-end, Full-stack, REST APIs, Containers, GitHub, AWS DevOps, Microservices, Full-stack Development, TypeScript, Amazon S3 (AWS S3), HTML, CSS, HTML5, Back-end Development, Containerization, Software as a Service (SaaS)

Team Lead Full-stack Software Engineer

2020 - 2022

FreshBooks

Managed a team of seven engineers in five different countries and time zones.
Introduced a highly decoupled architecture as the foundation for a new domain-oriented service. This new architecture addressed several identified technical debts at the company.
Performed the initial project scoping, sizing, and phase planning and coordinated the initial phase that created the base service with a skeleton to support the functionality.
Worked in the development of the checkout links payment functionality.
Worked in the development of the profitability reporting functionality.

Technologies: JavaScript, MySQL, PostgreSQL, Flask, SQLAlchemy, REST, Ember.js, Python, Docker, Google Cloud Platform (GCP), Amazon Web Services (AWS), Architecture, Team Leadership, Web Development, APIs, Software Architecture, Back-end, CI/CD Pipelines, Technical Leadership, Microservices Architecture, API Gateways, Amazon Aurora, Front-end, Full-stack, REST APIs, Containers, GitHub, Redis Cache, Asyncio, Python Asyncio, FastAPI, Microservices, OAuth, Full-stack Development, TypeScript, Amazon S3 (AWS S3), HTML, CSS, CSS3, HTML5, Amazon Simple Queue Service (SQS), Amazon DynamoDB, Amazon RDS, Back-end Development, Containerization, Software as a Service (SaaS)

Senior Full-stack Software Engineer

2019 - 2020

Reciprocity

Re-engineered the authentication module to allow for users' self-management of SAML settings and other social authentication methods. This reduced the number of related ticket support requests by 90%.
Conducted an extensive refactor on an asynchronous service to allow long pooling connected systems to continue working independently from the CI/CD pipeline.
Created the initial draft of the microservice architecture in collaboration with the platform team.

Technologies: Amazon Web Services (AWS), RQ, Vuex, Vue, OAuth 2, SAML-auth, Azure, Kubernetes, Docker Compose, Docker, Redis, MySQL, PostgreSQL, SQLAlchemy, Asyncio, Flask, Python, JavaScript, Architecture, Web Development, APIs, Software Architecture, Back-end, GraphQL, CI/CD Pipelines, Technical Leadership, Microservices Architecture, API Gateways, Front-end, Full-stack, REST APIs, Containers, GitHub, Redis Cache, Microservices, OAuth, Full-stack Development, TypeScript, Amazon S3 (AWS S3), HTML, CSS, CSS3, HTML5, Amazon Simple Queue Service (SQS), Amazon RDS, Back-end Development, Containerization, Software as a Service (SaaS)

Senior Back-end Software Engineer

2018 - 2019

Freelance

Assisted in a geospatial information processing pipeline that generated validated maps based on custom rules.
Created unit, integration, and E2E automated tests to guarantee 100% test coverage of all the code.
Refactored modules structure to make them suitable for automatic testing.

Technologies: SQL, Docker Compose, Docker, Luigi, SQLAlchemy, Python 3, PostGIS, PostgreSQL, JavaScript, Back-end, REST APIs, GitHub, GIS, Geocoding, Back-end Development

Senior Full-stack Engineer

2016 - 2018

Adroll

Assisted in creating the new ads library service for ads creation and handling that changed the way ads were handled across all internal services.
Created a master-to-master logical replication mechanism for ads using Lambda functions.
Assisted with the Facebook marketing API integration for social media advertising.

Technologies: Amazon Web Services (AWS), RQ, Redis, PostgreSQL, AWS Lambda, SQLAlchemy, Flask, Redux, React, Docker, Python, JavaScript, Web Development, APIs, Software Architecture, Back-end, GraphQL, CI/CD Pipelines, Technical Leadership, Microservices Architecture, API Gateways, Architecture, Amazon Aurora, Front-end, Full-stack, REST APIs, Containers, GitHub, Redis Cache, Asyncio, Python Asyncio, AWS DevOps, Microservices, Full-stack Development, TypeScript, Amazon S3 (AWS S3), HTML, CSS, CSS3, HTML5, Amazon Simple Queue Service (SQS), Back-end Development, Containerization, Software as a Service (SaaS)

Co-founder | Lead Engineer

2013 - 2016

Qualia Labs

Designed and implemented the main ETL pipeline for data processing and extraction.
Designed and implemented the real-time data warehouse for ad hoc queries.
Created an Angular component for visual querying and the reporting of unstructured data.

Technologies: Amazon Web Services (AWS), Amazon EC2, Amazon S3 (AWS S3), Machine Learning, AngularJS, SQLAlchemy, Flask, PostgreSQL, Python, JavaScript, Web App Development, Web Development, Software Architecture, Back-end, Technical Leadership, API Gateways, Front-end, Full-stack, REST APIs, GitHub, ETL, Snowflake, Full-stack Development, HTML, CSS, HTML5, Back-end Development

Technical Team Lead

2007 - 2013

Verizon Business

Performed project management tasks and conducted stakeholder negotiations.
Defined and created the core OLAP cubes in relational and multi-dimensional databases, ETL processes, and ad hoc queries.
Provided technical leadership for other members of the team.

Technologies: OLAP, Subversion (SVN), Git, Pentaho Reports, Pentaho Dashboard, Pentaho Mondrian OLAP Engine, Oracle PL/SQL, Java, Business Intelligence (BI), Oracle RDBMS, JavaScript, Software Architecture, Technical Leadership, Architecture, ETL, Data Engineering, HTML, Back-end Development

Senior Business Intelligence Consultant

2006 - 2007

Oracle

Defined and implemented multiple ROLAP and MOLAP cubes for high volumes of data.
Coded highly performant ETL mapping and implemented them on Oracle Real Application Cluster.
Designed and coded high-performance PL/SQL-stored procedures to handle several TBs of data.

Technologies: SQL, PL/SQL, OLAP, Oracle RDBMS, Business Intelligence (BI), ETL, Data Engineering

Semi-senior Analyst

2004 - 2006

Santander Bank

Automated a set of core data cleansing and data clearing processes.
Performed data analysis on client trends and product behavior for direct marketing campaigns.
Created automated processes for data augmentation on direct marketing campaigns.

Technologies: Apache Struts, Java, PL/SQL, SQL, OLAP, Oracle RDBMS, ETL, Data Engineering

Business Intelligence Consultant

2002 - 2003

TCN

Implemented an ETL mapping definition using Oracle Warehouse Builder on ROLAP models in Oracle RDBMS.
Created and implemented a change and deployment management system for ETL mappings.
Developed several PL/SQL libraries to improve Oracle Warehouse Builder's mappings performance.

Technologies: PL/SQL, SQL, IBM Db2, Teradata, OLAP, Oracle RDBMS, ETL, Data Engineering

Business Intelligence Consultant

2000 - 2001

Oracle

Assisted in the deployment and customization of specific, niche data templates for the pharmaceutical industry.
Improved tuning and performance of PL/SQL and SQL ETL processes.
Created forms for curated data matching between different providers' data sources for the pharmaceutical industry.

Technologies: PL/SQL, SQL, OLAP, Oracle RDBMS, ETL, Data Engineering

Experience

Graph-oriented System of Record

https://github.com/vamaq/schemaless

This is a proof of concept on how a flexible multi-purpose record management system could be implemented as a directed property graph using a relational management system. The idea was to set a migration path from a traditional RDBM schema definition into a graph database without altering the current technology stack.

Education

1999 - 2004

Bachelor's Degree in Computer Science

Universidad de Belgrano - Buenos Aires, Argentina

Skills

Libraries/APIs

SQLAlchemy, REST APIs, Vue, React, Asyncio, Python Asyncio, Luigi, Vuex, RQ

Tools

GitHub, Git, Amazon Simple Queue Service (SQS), Docker Compose, Pentaho Mondrian OLAP Engine, Subversion (SVN), Ansible, GIS, Geocoding

Languages

Python 3, Python, SQL, HTML, HTML5, JavaScript, TypeScript, CSS, CSS3, C++, Java, GraphQL, Snowflake

Frameworks

Flask, AngularJS, Redux, OAuth 2, Apache Struts, Ember.js, Django

Paradigms

Microservices Architecture, Microservices, ETL, Business Intelligence (BI), OLAP, REST, Scrum, DevOps

Platforms

Docker, Linux, AWS Lambda, Amazon Web Services (AWS), Kubernetes, Azure, Amazon EC2, Google Cloud Platform (GCP), Apache Kafka, Visual Studio Code (VS Code), Firebase

Storage

PostgreSQL, MySQL, Amazon S3 (AWS S3), Amazon Aurora, Amazon DynamoDB, PostGIS, Redis, Oracle RDBMS, Oracle PL/SQL, PL/SQL, Teradata, IBM Db2, Microsoft SQL Server, Redis Cache

Other

Architecture, Web Development, APIs, Back-end, Amazon RDS, Technical Leadership, Front-end, Full-stack, Containers, Full-stack Development, Back-end Development, Containerization, Software as a Service (SaaS), Software Architecture, CI/CD Pipelines, API Gateways, Data Engineering, FastAPI, AWS DevOps, OAuth, AWS Secrets Manager, Machine Learning, SAML-auth, Pentaho Dashboard, Pentaho Reports, Team Leadership, Industrial Internet of Things (IIoT), Redis Streams, GitOps, Web App Development, PCI Compliance

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.

Share your needs

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

Choose your talent

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

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