Looking for a job

Marcelo Schoen

@marceloschoen

Senior Full Stack Developer at Stefanini Brasil, integrating Adobe digital signing and migrating document data to SQL Server.

Brazil

Message

At Stefanini Brasil, I integrate Adobe digital signing and work on code tuning, legacy application support, and Azure DevOps Pipelines. I also analyze and migrate data from Documents to SQL Server using VBA.

Previously at Stefanini Brasil, I worked on Microsoft Azure Database for Raízen, tuning databases and creating PowerShell scripts for performance monitoring, analysis, and alerts.

In earlier database administrator roles at Stefanini Brasil, I managed replication and Availability Group maintenance, monitored SQL Server health, and supported migrations. I also created automation and stability tools, including self-repair for severe index fragmentation.

My earlier development work included ERP and CRM systems. At Sistêmica - Plune Cloud ERP + BI, I developed PostgreSQL, JavaScript, and PERL features; at Maxiserv Assessoria De Cobrança, I worked on C# CRM software and SQL Server integrations.

Experience

Work history, roles, and key accomplishments

Current

Senior Full Stack Developer

Current

Stefanini Brasil

Jan 2021 - Present (5 years 9 months)

* Adobe digital signing Integration
* Proactive code tuning and evaluation
* Support of Legacy application and repositories (TFS)
* Azure Devops Pipelines
* Data analysis and migration from Documents to SQL Server (VBA)
* SAP bridge integration from Third Party application

Senior Sql Server Database Administrator

Stefanini Brasil

Jul 2020 - Dec 2020 (5 months)

Client : Raízen - Microsoft Azure Database

Main Tasks:
* Database tuning
* Creation of Powershell scripts to extract performance counters of potential offenders
* Creation of Powershell scripts to monitor and generate performance analysis on worked items
* Creation of Powershell scripts to generate alerts with overall database performance
* Pro-active monitoring of SQL Server stability and usage

Senior Sql Server Database Administrator \ Administrador de Banco de Dados Sênio

Stefanini Brasil

Jan 2018 - Jul 2020 (2 years 6 months)

Main Tasks:
* Replication Management
* Availability Group maintenance
* Customer Support ( Incidents / Defects / Deployments / Meetings )
* Database Server Migration
* Pro-active Server Status monitoring ( index fragmentation, stability, deadlocks, Replication versioning )
* Creation of Powershell Scripts to help automate customer support on low impact issues
* Creation of tools to help improve ov

Web Developer \ Desenvolvedor Web - ERP

Sistêmica - Plune Cloud ERP + BI

Nov 2016 - Sep 2017 (10 months)

All of the UI is already done, new screens and usage could be easily made by the existing framework.
Development was done using PostGreSQL, Javascript and PERL.
Main Tasks :
* Creation of Triggers and Functions to support new pages
* Maintenance and creation of JavaScript functions to improve the overall page usability
* Creation of PERL scripts for RegEx a page reading on specific sections ( st

C# Developer \ Desenvolvedor C#

Maxiserv Assessoria De Cobrança

May 2014 - Oct 2016 (2 years 5 months)

CRM Software - Charges
Main Tasks :
* Integrate and maintain stability of Communication's Software / Hardware
* Create routines to improve the overall performance and speed of Operators.
* SQL Server multi-server integration, 3+ servers used for different purposes
* Integration and interpretation of Financial Institution's documents
* Creation of Windows Services to support constant data update

Visual Basic 6 Senior Developer \ Desenvolvedor VB6 Sênior

JobSystem

Apr 2012 - Sep 2012 (5 months)

Civil Construction ERP
Main Tasks :
* Support and improve usability of SQL Server databases
* Creation of Adaptive report for Engineers
* Creation of tools for Data Mining
* Upgrade of SQL Server versions and overall structure

Visual Basic 6 Developer \ Desenvolvedor VB6

Inova Contact Center

Jan 2005 - Mar 2010 (5 years 2 months)

Marketing CRM
Main Tasks
* Integration with Communication Hardware / Software
* Creation of web-page auto-read scripts to improve Data gathering
* Real-time integration of new Client-to-Dial lists, based on configurable details
* Support for real-time performance analysis of the Operators