Marcio A. — Data Engineer

Data Engineer, Systems Integration Consulting, ETL/ELT, Data Engineering, NEORIS

May 2020 – May 2021 ( 1 year project )
Responsibilities:

• I worked as an IT Consultant assigned by NEORIS for British American Tobacco Holding.
• Develop and Supports the metadata ingestion process to help the company create a Modern Datawarehouse/Data
• Lake from many sources (Databases, Datasets, Files, APIs) using Wherescape RED Tool, ensuring that it runs efficiently, reliably, and scalably, through the initiation and monitoring of ingestion processes.
• Collaborates closely with internal and external stakeholders in the ingestion process. Contributes to the design, development, testing, integration, support, and documentation of user-facing applications and back-end systems.

Technologies: SQL, SnowFlake Database, Wherescape RED, Microsoft Azure (Azure Blob Storage, Azure DevOps, Azure Datafactory)

Data Engineer, ETL Developer, Data Integration, Database Developer, Software Engineer, System Analyst , IT Consultant

September 1994 – Present ( more than 25 years )
Responsibilities:

• Requirements Analysis, System Analysis, Software Developer
• Database Developer, Database Design, Database Modeler, Database Object Management
• Database Analyst, Data Analyst, ETL Developer, Oracle Developer, Software Developer, Data Integration
• Data Replication, Performance Tuning and Query Optimization, Process Automation, experience working remotely when needed.

Data Engineer, ETL, Database Developer, Systems / Data Analyst, Software Engineer DBC Company

March 2015 – April 2019 (4 years 3 months)
Responsibilities:

• I worked as an IT Consultant for clients of DBC Company Below are some clients where I worked assigned by DBC Company - www.dbccompany.com.br
• Systems Analyst, Oracle Developer, Database Developer

Dana Holding Corporation Brazil

March 2015 – October 2015 (7 months)
Responsibilities:

• I worked alongside the client’s business area and my main job tasks were Tasks Management, Improvement of Business Process, Process Automation, Requirements Analysis, System Analysis, Software Developer,
• Database Design, Database Modeling, Database Object Management, Maintaining Development, Test and Production Environments.

Technologies: Oracle Database (10g, 11g), Oracle Forms 10g, Oracle Reports 10g, Oracle PL/SQL,
SQL, Windows, Microsoft Office.

ETL, Database Developer, Systems Analyst, Data Analyst, Software Engineer Grupo DIMED

November 2015 – April 2019 (3 years 6 months)

Description: The result of this project made it possible to keep up-to-date near real-time
critical data such as promotions, prizes, price of items, sales, items of sales, taxation, customers information and others, avoiding integrity errors and creating predictive actions alerts to solve possible errors. In another special project, I worked to improve the validation process of the PBM (Program Benefits Management) based on the sales information and optimization of the data warehouse integration process.
Responsibilities:

• I worked as System Analyst, Data Analyst, ETL Developer, Oracle Developer, Software Developer, Data Integration, Data Replication, Performance Tuning and Query Optimization, experience working remotely when needed.
• My main job tasks are Analysis, Development, Process Optimization, Requirements Analysis, Process Automation, Improvement of Business Process, System Analysis, Database Design, Database Modeling, Database Object Management, Database Analyst, ETL, Data Integration, Data Replication Process
• Monitoring more than 400 Oracle instances(pharmacy stores), Maintaining Development, Test and Production Environments.
• I was responsible for analyzing, designing and developing a new Integrated System that has a Data Pipeline from 4 main Oracle Instances and more than 400 others Oracle Instances outside the company, located in many cities in 4 provinces.

Technologies: Oracle Database (10g, 11g, 12c) Oracle Forms 10g, Oracle Reports 10g, Oracle PL/SQL, SQL, Oracle APEX, Python, Linux, Windows, Microsoft Office.

São João Pharmaceutical Group

2014
Analysis and Development - Data Integration Process Monitoring for more than 400 Database Instances (pharmacy stores), maintaining development, test and production environments.

Court of Justice of Rio Grande do Sul – Brazil

2013
Analysis and Development - Data Replication Process Monitoring about 100 Oracle instances (database of County Courthouse), maintaining development, test, and production environments.

TNT - Brazil, Electronic Document Management System

2010

Analysis and Development, maintaining development, test and production environments, implementing a Tracking Control near real-time based in EDI files for Apple products.
Technologies: GCP, AWS, Azure, Python, Oracle Database (9i, 10g, 11g), Oracle Forms (6i, 10g),
Oracle Reports (6i, 10g), Oracle PL/SQL, SQL, ODI 10g (Oracle Data Integrator), MySQL, PostgreSQL, Pentaho Data Integration, Metabase, Java, Microsoft Visual Basic; Microsoft SQL Server, T-SQL, ZIM, Microsoft Office, Windows, Unix, Linux, SVN, CVS, GitHub.