Felipe is available for hire
Hire FelipeFelipe Pilon
Verified Expert in Engineering
Software Developer
Blumenau - State of Santa Catarina, Brazil
Toptal member since March 15, 2021
Bio
Felipe is a database developer with 10+ years of experience, mainly with Microsoft SQL Server, but he's also familiar with Oracle, MySQL, and Postgres. He's worked with several software implementation projects around the globe, most of them related to logistics. Passionate about programming, he's always ready for new challenges. His skills include problem solving, logical thinking, and troubleshooting.
Portfolio
The Körber Group
Microsoft SQL Server, Oracle, C#, Warehouse Management System (WMS), SQL...
DHL International
Microsoft SQL Server, C#, SQL, Data Modeling, Database Modeling...
The Körber Group
Microsoft SQL Server, Oracle, C#, SQL, Data Modeling, Database Modeling...
Experience
- Microsoft SQL Server - 12 years
- Data Modeling - 12 years
- SQL - 12 years
- Database Modeling - 12 years
- Database Design - 11 years
- PostgreSQL - 3 years
- Node.js - 3 years
- JavaScript - 3 years
Availability
Part-time
Preferred Environment
Microsoft SQL Server, PostgreSQL, MySQL, Node.js, React, C#
The most amazing...
...project I've worked on is implementing a warehouse management system (WMS) for a customer who needed to integrate it with his automation system.
Work Experience
Logistics Consultant
2020 - PRESENT
The Körber Group
- Built the integration between the WMS system and the Geek+ robotics solution for a customer in Australia. We used SQL Server Service Broker, Windows Services, and Web Server (designed with C#) in the solution, along with regular database routines.
- Participated in a workshop where one of my tasks was to design new customer warehouse operation processes. This included the creation of process flows with Microsoft Visio. Some of the processes required database modeling as well.
- Managed a team of 1-5 developers using an internal methodology (hybrid Scrum) to deliver the WMS processes I also helped design. The deliveries included integrations with the robotic system, voice applications, mobile processes, and web pages.
Technologies: Microsoft SQL Server, Oracle, C#, Warehouse Management System (WMS), SQL, Data Modeling, Database Modeling, Database Design, JSON
Functional Analyst
2018 - 2020
DHL International
- Developed new WMS processes to manage a client cross-docking operation. Even though this client operation was completely different, I integrated the new processes with the application standard ones, reusing the same database model and routines.
- Designed and developed the serial number control functionality in the WMS system. This required new database tables and routines able to manage a high volume of transactions a day.
- Implemented the source code control using Git and TFS. I also created a Windows app using C# that we used to generate and export releases from Git, increasing the quality of the deliveries and helping manage the product backlog.
Technologies: Microsoft SQL Server, C#, SQL, Data Modeling, Database Modeling, Database Design, JSON
Implementation Consultant
2014 - 2018
The Körber Group
- Used Microsoft SQL Server to develop the integration between the Körber's WMS system and the customer's WCS system provided by Knapp. This project had a huge complexity due to the high volume of transactions executed by the operation.
- Executed assessment for a customer who was having several performance issues with the WMS system. Throughout this project, I mapped and performed some database model changes and rewrote some routines that were harming the application.
- Designed and developed a solution for a customer to control inventory attributes that were not physically available on the goods' packages. It ran along with the other warehouse processes and needed to be transparent for the final users.
- Improved the standard WMS cartonization stored procedures to accommodate customer requirements such as goods nested volume and knead percent.
Technologies: Microsoft SQL Server, Oracle, C#, SQL, Data Modeling, Database Modeling, Database Design
Software Developer
2012 - 2013
BGA Gerencial Tecnologia
- Developed a Windows desktop app using C# and WPF that auto generates invoices for customer orders, integrating the customer's ERP and WMS systems.
- Designed several SQL queries for the BGA's BI system, such as the average ticket price and quantity and the target versus performed sales report queries.
- Developed several changes to the Linx ERP system, mainly in the accounting module, along with several reports using VFP and Crystal Reports.
Technologies: Microsoft SQL Server, C#, Visual FoxPro, Windows Presentation Foundation (WPF), SQL, Data Modeling, Database Modeling, Database Design
Software Developer
2009 - 2012
Linx
- Developed the integration between the Link ERP system and the Sythex WMS system for an eCommerce customer. This was entirely developed using Microsoft SQL Server stored procedures, jobs, and linked servers.
- Used Visual FoxPro and Microsoft SQL Server to develop a tool to auto-generate invoices for eCommerce orders within the Linx ERP system.
- Developed the integration between a customer's Linx POS system and the invoicing system from Inventti. Apart from Microsoft SQL Server and Visual FoxPro development, I created a Windows service using C# to process the invoices.
Technologies: Microsoft SQL Server, C#, Visual FoxPro, SQL, Data Modeling, Database Modeling, Database Design
Experience
WMS and WCS Integration
The integration of the Körber WMS system and Knapp WCS system. During 6+ months, this project required a high level of skills in stored procedure design and data modeling due to the tremendous number of transactions and concurrency between all warehouse processes. I worked along with the customer's DBA to identify and fix many points of failure of the application and helped the implementation team troubleshoot issues within the application.
WMS Serial Number Capture Capture Implementation
Using T-SQL, I designed and developed the database model to store goods serial number information. It contained four levels of information — pallet ID, carton ID, serial numbers one and two). Beyond the database model, it required a series of stored procedures to validate and update the serial information throughout the WMS processes.
WMS Cross-docking Functionality
With the warehouse operations team, I mapped the processes required for a cross-docking operation. Later in the project, I designed the database changes and developed the routines to handle the new warehouse processes.
Education
2009 - 2013
Bachelor's Degree in Computer Science
Universidade Regional de Blumenau (FURB) - Blumenau, Brazil
Certifications
JULY 2020 - PRESENT
CTL.SC0x—Supply Chain Analytics
edX, Inc.
SEPTEMBER 2011 - PRESENT
2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
KeepIt
MARCH 2011 - PRESENT
6232: Implementing a Microsoft SQL Server 2008 Database
KeepIt
Skills
Libraries/APIs
Node.js, React
Languages
SQL, C#, Visual FoxPro, JavaScript, T-SQL (Transact-SQL)
Storage
Microsoft SQL Server, Database Modeling, PostgreSQL, JSON, MySQL
Paradigms
Database Design
Frameworks
Windows Presentation Foundation (WPF)
Platforms
Oracle
Other
Warehouse Management System (WMS), Data Modeling
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