Douglas S.

Data Engineer

Senior Systems Analyst
2/1/2022 - Present

Managed and controlled the database of drivers and vehicles for transportation. Integrated ERP systems for delivery tracking and monitoring using WEBAPI. Created and maintained procedures, views, and functions in SQL Server databases. Conducted code reviews to improve deliverables and gathered requirements. Migrated business rules from legacy systems to new technologies. Supported the selection and integration of new developers into the team. Developed expertise in database management, ERP integration, and code review processes.

Dev Senior - Freelancer
9/1/2021 - 1/1/2023

Analyzed and developed systems for the transfer of loads between hubs in Brazil and Argentina, focusing on validating EDI documents and performing integrations with partners via WebServices. Developed proficiency in ASP.NET MVC, back-end development, and SOAP. Demonstrated expertise in software development, SQL, HTML, and database management.

Systems Analyst
3/1/2019 - 7/1/2021

Developed systems for issuing and validating fiscal documents for carriers, including CTe, MDFe, CONEMB, and PREFAT. Achieved integration with ERP systems for efficient tracking and monitoring of deliveries and facilitated client integration via WEBAPI. Engaged in integration with SAP using SOAP protocols for streamlined invoice generation and processing. Conducted creation and maintenance of SQL Server database procedures, views, and functions. Applied rigorous code review practices to enhance delivery quality and gathered requirements for new features from internal stakeholders. Migrated business rules from legacy systems to modern technologies and played a pivotal role in selecting and onboarding new team members.

Systems Analyst
9/1/2018 - 3/1/2019

Engineered and maintained BPO and BPM systems using .NET Web technologies, including WebForms and MVC, coupled with extensive use of JQuery. Automated RPA processes across various environments such as Windows Services, Desktop applications, REST WebApi, and Web services. Developed and upheld database procedures, views, functions, triggers, and linked servers within Oracle and SQL Server databases.

Systems Analyst
2/1/2017 - 9/1/2018

Specialized in the analysis and development of software using .NET languages, with robust experience in C#, ASP, VB.NET, and VB6. Focused on developing and maintaining software systems designed for controlling freight and toll payments. Adept in creating and maintaining complex SQL Server database components, including procedures, views, functions, triggers, and linked servers. Proven ability to perform integrations via web services, and skilled in reading and writing various carrier file formats such as CTe and MDFe. Successfully integrated with the SEFAZ system for generating CTe.

Systems Analyst
7/1/2016 - 2/1/2017

Developed and maintained software for monitoring and tracking vehicles via GPRS using C# and VB.NET. Created and maintained procedures, views, functions, triggers, and linked servers within SQL Server databases. Maintained an e-commerce platform developed in ASP.NET and C#. Conducted requirement gathering sessions with internal and external clients and wrote detailed specifications for the development team. Executed integrations via Web Service, and handled reading and writing various files for carriers, including CTe, Conemb, and Notfis. Achieved successful integration with SSW and BSoft systems for generating CTe, as well as with the SEFAZ system for generating CTe and NFe.

Requirements Analyst
6/1/2016 - 7/1/2016

Demonstrated expertise in gathering requirements from internal clients and translating them into detailed specifications. Developed and maintained database tables using SQL Server. Proficient in creating and managing applications with C# and VB.NET. Specialized in the analysis and development of applications tailored for health insurance quoting, ensuring efficient and accurate processing of quotes.

Mid-Level Programmer
3/1/2016 - 6/1/2016

Developed and maintained software for monitoring and tracking vehicles via GPRS using C# and VB.NET. Created and maintained procedures, views, functions, and tables in SQL Server databases. Managed e-commerce platforms developed with ASP.NET and C#. Engaged in requirement gathering with internal and external clients and wrote detailed specifications for the development team.

Programmer Analyst
5/1/2015 - 11/1/2015

Developed and maintained VB.NET applications, ensuring robust functionality and performance. Created and managed tables, stored procedures, views, and functions in SQL Server databases, optimizing data retrieval and manipulation. Generated reports using Report Viewer and Crystal Report, delivering insightful analyses and visualizations. Designed and maintained user interfaces with Windows Forms, enhancing user experience and application usability.

Programmer Analyst
6/1/2008 - 12/1/2014

Developed and maintained applications for monitoring telephone networks using VB.NET, C#, and ASP.NET. Created and maintained procedures, views, functions, and tables in SQL Server databases. Demonstrated proficiency in manipulating and creating XML files. Generated comprehensive reports utilizing Report Viewer and Crystal Reports. Established and maintained user interfaces with Windows Forms. Ensured code integrity and applied maintenance techniques in C++.

Systems Analysis and Development at Technology in Systems Analysis and Development
2006 - 2009

Mechanical Maintenance at ETEC Basilides de Godoy
1996 - 1999

Electronics at Barueri Institute of Technology
2000 - 2002

Web Programming at Campus Code
2015 - 2015

SOLID with C#: Object Orientation with C# at Alura
2/1/2018

SOLID with C#: Object Orientation with C# at Alura
2/1/2018

Tests: TDD with C# at Alura
2/1/2018

Career, Competence or Opportunity – Strong Educacional FGV – Profº Marcelo Rivani at Strong Educacional
3/1/2016