David Kestering

FreeBalance - SEFA/PA

Senior Technical Architect

I use the Pentaho Server suite for dashboard development, in addition to Pentaho Data Integration, Python and Golang for ETL. Saiku plugin for OLAP.
I participate in the FreeBalance Business Intelligence architecture development team, helping to control its structure and functioning in different operating systems and databases.

Technical Support Specialist | PL/SQL Developer | B.I. Specialist

Using technologies like Python, Golang and Pentaho, with oracle and sql server databases, I worked to help to migrate accountability data of SEFA’s systems to FreeBalance software.
In B.I. we use BIRT (Business Intelligence and Reporting Tools) to create reports and dashboards for SEFA data analysts.
I am charged to analyze customer issues and requirements and facilitate solutions.
I do technical analisys of requirements and tailor software solution using FreeBalance software.
I learn and understand client’s current technical environment and recommend possible modifications to ensure optimum integration with FreeBalance’s products/solutions.
I act as primary technical contact for the client during deployment and post-implementation.
I understand proposed solution and provide technical expertise in executing same using tools and techniques that are open source based.
I do complete technical product installations and upgrades, including database and software installs and system tuning.
Collaboratively I develop and deliver technical training to clients.

Techlead IT - SEMAS/PA

Data Administrator Level 3

I am acting as Oracle's Database Administrator, Data Administrator and Business Intelligence Analyst, located at the Environment and Sustainability State Secretary (SEMAS/PA).
Our current projects involve the maintenance of the systems:
1) SIMLAM;
2) SISFLORA;
3) SICAR;
Specific Assignments:
I perform data analysis, installation, administration, customization and maintenance of Oracle Database;
I create database programs (Stored Procedures, Functions, Views, Triggers and Cursors);
I perform the development of data integration through ETL using a Pentaho Data Integration (PDI) tool.
I Perform corrective and preventive maintenance routines, ensuring maximum system performance;
I help at the support activities for the test and production environments;
I perform Optimize database routines, ensuring high availability, capacity, continuity and security of information systems;
I help to Support the IT and Systems team in technical support actions of 1st and 2nd level.

Montreal IT – Hospital of Santa Casa de Misericórdia Foundation of Pará

Project Manager | Tech lead | Senior Systems Analyst

I am based within the Hospital of Santa Casa de Misericórdia Foundation of Pará, where I manage the team development projects using agile methodologies in the SoulMV software;
Our current projects involve the implementation of the systems:
1) Hospitality and Hospital Beds Center;
2) Hospital Infection Control Advisory and Epidemiological Surveillance Center;
3) Management of Sterile Materials Control;
4) Surgical Center and Obstetric Center;
5) Adult Clinic and Specialty Medical Clinic;
Specific Assignments:
I perform data analysis, installation, administration, customization and maintenance of Oracle Database, besides leading a team of 8 people delegating project development activities creating database programs (Stored Procedures, Functions, Views, Triggers and Cursors);
I perform the development of data integration through ETL using a Pentaho Data Integration (PDI) tool.;
I Perform corrective and preventive maintenance routines, ensuring maximum system performance;
I help at the support activities for the test and production environments;
I perform Optimize database routines, ensuring high availability, capacity, continuity and security of information systems;
I help to Support the IT and Systems team in technical support actions of 1st and 2nd level.

Alubar Global Management

Lead Data Analyst

I am responsible for translating data analysis strategies into system architectures; To support IT and Systems teams in technical support actions; To create analytical solutions in accordance with the expectations of stakeholders; To design, develop and deliver data analysis solutions; To track and monitor the operation and maintenance of the ERP, SIM, ECM, BI database systems, among others. As well as, support outsourced teams in the development and implementation of changes and improvements in the company's systems.
Specific Assignments
Analyze, install and configure database systems;
Perform corrective and preventive maintenance routines, ensuring maximum system performance;
Support the support activities for the test and production environments;
Maintain and guarantee the operation of the data replication routine between the different databases;
Optimize database routines, ensuring high availability, capacity, continuity and security of information systems;
Validate the backup policy of database systems, ensuring the shortest interruption time in case of need for recovery;
Maintain control of access and privileges to data, according to the company's security policy;
Create users and access to the test or production databases, according to the needs;
Manage the system's capacity process, requesting adequate resources to maintain its functioning and projecting future demands for the continuity of a stable operation;
Ensure strict compliance with software licensing laws and policies;
Perform cleaning, validation, normalization and integration of data in BI systems;
Support the IT and Systems team in technical support actions of 1st and 2nd level.

Amazon's University - UNAMA - SER Educational Group

Oracle's Database Language Teacher in Oracle Database specialization

Teacher of Oracle's Database Specialization - Advanced Database Language Discipline. Students learn how to create and maintain database objects, as well as store, retrieve and manipulate data. They even learn how to recover data using advanced techniques, such as cluster operators and related subqueries. They also learn to write SQL script files to automate tasks using an SQL * Plus tool. The fundamental concepts are reinforced by calculations and practical exercises. It is also taught PL/SQL language, where students learn to create and optimize database objects such as Procedures, Functions, Triggers, Cursors, and others

Montreal IT – SEDUC/PA

Tech Leader | Oracle and PostgreSQL DBA | PL/SQL and PHP Developer - Senior Level

I perform data analysis, installation, administration, customization and maintenance of Oracle Database, besides leading a team of 5 people delegating project development activities creating database programs (Stored Procedures, Functions, Views, Triggers and Cursors). We perform monitoring, data auditing and performance analysis of the database and information systems, as well as maintenance of PL/SQL routines and procedures, as well as the implementation of backup and restore policies
We fine-tune database performance and data dictionary maintenance, in addition to modeling the logical and physical data architecture, as well as migrating data between heterogeneous environments, defining SQL queries, and optimizing operations. I do data extraction using extractions tools, transformation and loading (ETL);
In Web development, I develop websites and systems using PHP language with Zend or Laravel framework with some raids on AngularJS and NodeJS;
In project management we use Mantis, JIRA and BitBucket;
In B.I. I perform data management using the best practices in business process management (BPM), with the treatment of the information aiming to provide the understanding and alignment of the organizational processes with the resources involved, I work in the modeling of multidimensional databases using the best practices, DataWerehousing (DW), mapping business opportunities with the customer, implementing ETL routines for database optimization and automation, and managing the conversion of OLTP to OLAP information, to finally develop analysis and construction of indicators and KPIs, using Qlik Sense tool to improve performance and productivity in decision making for the customer's business.