Waldemar G.
Back-end and Systems Engineer

Skills

Bootstrap

Visual Basic

Transact-sql

Delphi

Javascript

Angular

Waldemar is available for hire

Hire Waldemar G.

All Howdy Candidates are vetted for skills and english proficiency.

Bio

A Systems Analyst specializing in Back-End development with significant expertise in SQL Server, focusing on Transact SQL programming, including procedures, functions, triggers, jobs, and views, as well as Oracle Database 19C utilizing PL/SQL. Proficient in developing and managing REST APIs and C# within a Microsoft-based BFF architecture. Demonstrates comprehensive knowledge of banking interfaces in compliance with CNAB240, CNAB400, and CNAB1000 standards and adeptly manages investment fund operations interfaces using IBM high platform and SQL Server. Experienced in migrating legacy applications from VB6 and Delphi to the .Net framework.

Systems Analyst
4/1/2020 - 1/1/2023

Activities involved the creation of REST APIs using VS2022 with C# in a two-tier BFF (Backend for Frontend) architecture, interfacing with Oracle databases. Experience in publishing APIs on the Google ApiGee platform. Led the migration of projects from classic ASP to a modern frontend implemented with Angular and Bootstrap, while re-configuring backend APIs to operate in two layers, distinguishing between business logic (BFF) and data access (Oracle).

Developed the Retrofit tool for purging obsolete log data and optimizing SQL Server databases. Created and optimized stored procedures in MS SQL Server. Authenticated REST APIs for analytical databases were developed using DotNet Core. Frontend development tasks in DotNet Core with access to Oracle databases were performed alongside the creation of two-layer APIs (BFF) published on Apigee. Authored best practices guides for SQL Server and provided support and technical assessments for the development team specializing in DotNet/SQL Server. Oversaw the design and optimization of SQL Server databases and defined project architecture using design patterns. Utilized IBM RTC for cataloging sources and publications and IBM Jazz for publishing applications in an Intranet IIS environment. Managed planning and process scheduling using Control-M.
Senior Systems Analyst
5/2/2018 - 1/2/2019

Led the migration of legacy products from Delphi to C# (.NET MVC5), implementing and optimizing SQL Server databases. This involved substantial translation of application logic and user interface components to the newer .NET framework, resulting in improved performance and maintainability. Utilized C# programming language within the .NET MVC5 framework to recreate functionalities and interfaces. Enhanced data storage and retrieval systems with SQL Server, ensuring data integrity and query efficiency. Employed modern development practices including object-oriented programming, automated testing, and version control through Git. Additionally, optimized database interactions and implemented best practices for SQL server maintenance and performance tuning.
Systems Analyst
5/2/2013 - 9/2/2017

Developed bank interfacing for accounts payable with banking institutions including Itaú, Santander, HSBC, CEF, Banco do Brasil, and Bradesco. Conducted data entry into accounts payable from the acceptance of invoices in the Document Control (DC) system. Achieved bank integration with Bradesco through FinNet data van transmission for automatic collection of interstate rate differences as per EC87. Successfully integrated accounts payable processes with the Protheus accounting system.

Data Processing Technology at Mackenzie University
1985 - 1988
University Extension in Systems Analysis and Audit at Paulista University
1988 - 1989