Yuri Franzoni da Silva, Developer in Coquitlam, BC, Canada
Yuri is available for hire
Hire Yuri

Yuri Franzoni da Silva

Verified Expert  in Engineering

Microsoft Office Developer

Location
Coquitlam, BC, Canada
Toptal Member Since
July 18, 2023

Yuri is a systems developer experienced in Progress OpenEdge, Kafka, AWS cloud, PHP, and SQL technologies. He has experience working in TOTVS Datasul ERP environments, handling custom coding. He is skilled in building Kafka pipelines using the Progress OpenEdge and Confluent platforms to stream data from a Progress CDC-enabled database to AWS cloud database instances. Yuri is a versatile professional with expertise in various domains, including HTML5/CSS3, PHP, Java, MySQL, and SQL Server.

Portfolio

Celayix, Inc.
OpenEdge ABL, Progress 4GL, Amazon S3 (AWS S3), Redshift, Bitbucket...
Self-employed
OpenEdge ABL, Progress 4GL, TOTVS ERP, REST, HTML5, SQL, Microsoft Office...
TOTVS
OpenEdge ABL, Progress 4GL, Adobe Flex, Microsoft Office...

Experience

Availability

Part-time

Preferred Environment

OpenEdge, Progress 4GL, Apache Kafka, Redshift, Amazon S3 (AWS S3), Amazon RDS, Amazon DynamoDB, Amazon EC2, OpenEdge ABL, Windows

The most amazing...

...project I've built from scratch is a data warehouse solution using Progress CDC, Confluent Kafka, and AWS Redshift.

Work Experience

Progress OpenEdge Web Developer

2021 - PRESENT
Celayix, Inc.
  • Worked with the Confluent platform to build a Kafka pipeline to stream data from a Progress CDC-enabled database to AWS cloud database instances, including Relational Database Service (RDS) and Redshift.
  • Built REST web services using the Progress OpenEdge language and existing frameworks and libraries from Celayix. Worked with CloudFormation, DynamoDB, RDS databases, Redshift clusters, SQS queues, EC2 instances, and S3 buckets AWS cloud services.
  • Contributed to a Progress database structure migration project, from type I to type II, based on Progress documentation and statistics collected from production clients.
Technologies: OpenEdge ABL, Progress 4GL, Amazon S3 (AWS S3), Redshift, Bitbucket, Apache Kafka, Amazon EC2, Amazon DynamoDB, Amazon RDS, TeamCity, Git, Red Hat Enterprise Linux

Software Developer Consultant

2013 - 2021
Self-employed
  • Handled the systems development and custom coding in ERP environments working with Progress, Flex, PHP, and Java.
  • Conducted the conversion and migration of different ERP versions and legacy systems.
  • Carried out the integration between ERPs and web apps through REST and SOAP web services.
Technologies: OpenEdge ABL, Progress 4GL, TOTVS ERP, REST, HTML5, SQL, Microsoft Office, Red Hat Enterprise Linux

Progress Datasul Developer

2012 - 2013
TOTVS
  • Acted as the systems developer and handled custom coding to the TOTVS Datasul ERP family, including TOTVS 12, EMS 2.06/5.06, and human capital management (HCM).
  • Worked in Progress OpenEdge, Adobe Flex, and metadata environments.
  • Custom-tailored software development and customizations for multiple TOTVS Datasul ERP suite customers.
Technologies: OpenEdge ABL, Progress 4GL, Adobe Flex, Microsoft Office, Red Hat Enterprise Linux

Data Warehouse Solution from Progress to AWS Redshift using Kafka

This project aimed to implement a data streaming pipeline from multiple Progress OpenEdge databases, which would be polled by a Kafka cluster to automatically apply changes to several monitored tables into a Redshift cluster at AWS.

To make this happen, I had to learn how to build a successful change data capture (CDC)-enabled OpenEdge environment and set up and configure a Confluent Kafka platform from scratch, including using Kafka connectors, KSQL streams, and other components and deploy and configure an Amazon Redshift instance.

I conducted technical research and coordinated a small team with their corresponding tasks and milestones.

After deploying the solution we created, the company was able to start migrating several legacy reports and dashboards using modern data analytics tools. Also, the company's clients could log into the data warehouse environment and connect their software for querying data.

Progress OpenEdge Database Maintenance and Type II Storage Migration

The company had around 400 separate Progress OpenEdge databases, one per client, created using pre-existing templates. Over time, these databases grew and required frequent maintenance work such as re-indexing, dumping, and loading. The source templates were created long ago using type I storage architecture, which is now obsolete.

This project aimed to migrate these 400 databases to the type II structure, which had sizes varying from 1 gigabyte to 45 gigabytes, using knowledge and best practices from Progress for this task. We had to analyze the usage statistics for every client to decide how to split the new database structure into multiple database areas across several hard drives.

I helped develop a PowerShell script to execute a full database backup and binary dump, deleting the existing database, recreating a new one, and finally running a binary load and re-indexing.

As an outcome, we had a performance increase ranging from 15% to 40%, dramatically reducing client downtime for database maintenance.

Tools

OpenEdge, Progress 4GL, TeamCity, Bitbucket, Git, Kafka Streams

Languages

OpenEdge ABL, Visual Basic 6 (VB6), Visual Basic for Applications (VBA), HTML5, SQL

Platforms

Windows, MacOS, Apache Kafka, Amazon EC2, Linux, Red Hat Enterprise Linux

Frameworks

Windows PowerShell, Adobe Flex

Paradigms

REST

Storage

Redshift, Amazon S3 (AWS S3), Amazon DynamoDB, Databases

Other

Microsoft Office, Amazon RDS, TOTVS ERP, CDC

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