Fabiano Chapuis de Oliveira
Data Engineer at Critical TechWorks- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Full professional proficiency
-
Spanish Elementary proficiency
-
Portuguese Native or bilingual proficiency
Topline Score
Bio
Credentials
-
Gestalt-Terapia: Fundamentos e Técnicas
IMT - Instituto Mineiro de Gestalt-TerapiaAug, 2023- Nov, 2024 -
INTRODUÇÃO À MITOLOGIA GREGA - COSMOS, DIVINDADES E HERÓIS
MitosferaJul, 2023- Nov, 2024 -
Agile Leadership and Resilient Teams
UdemyNov, 2020- Nov, 2024 -
Speak like a Pro: Public Speaking for Professionals
UdemyNov, 2020- Nov, 2024 -
Stress Management: 40+ easy ways to deal with stress
UdemyNov, 2020- Nov, 2024 -
Agile PM 201 - Uderstanding Agile at a Deeper Level
UdemyOct, 2020- Nov, 2024 -
Identify & Define the Problem with Business Analysis
UdemyOct, 2020- Nov, 2024 -
Python Advanced
QualiCADMar, 2020- Nov, 2024 -
ITIL - Foundation
AXELOS Global Best PracticeJul, 2017- Nov, 2024 -
DBA/OCP Oracle
OracleJul, 2004- Nov, 2024 -
An Introduction to Consumer Neuroscience & Neuromarketing
CourseraJan, 2015- Nov, 2024
Experience
-
Critical TechWorks
-
Portugal
-
IT Services and IT Consulting
-
700 & Above Employee
-
Data Engineer
-
Apr 2021 - Present
Critical Techworks is a BMW Group & Critical Software joint venture company - IaC - Infrastructure development using Terraform. - GDPR compliance module built on the first application layer (depersonalization) - PaaS – AWS environment for architecting, management, and development of multiple resources, such as Lambda function, S3, Kinesis, Firehose, CloudWatch, SNS, SQS, and Glue database including DEV, INT, PRD environments. - Python development as main code for lambda functions, unit tests, and others. - SQL/NoSQL queries using AWS Athena for data analysis. - Jira for overall planning and breakdown to stories. - Confluence as a general documentation and collaboration tool. - Bitbucket for source code projects. - GitHub for development-focused topics (documentation and discussion), unit tests and test automation and for projects using pipelines. Show less
-
-
-
TAP Air Portugal
-
Portugal
-
Airlines and Aviation
-
700 & Above Employee
-
Business Intelligence Analyst
-
Jul 2020 - Apr 2021
TAP IT - Business Intelligence & Analytics team - ETL processes development according to the business requirements. - Assuring GDPR procedures are correctly applied according to the data flow, depending on the requirements needed. - Ensuring the development process follows the good practices and requirements for all environments (DEV, QLT, PRD). - Documenting the development stage for deployment plan in all environments. - Project orientation depending on business needs. TAP IT - Business Intelligence & Analytics team - ETL processes development according to the business requirements. - Assuring GDPR procedures are correctly applied according to the data flow, depending on the requirements needed. - Ensuring the development process follows the good practices and requirements for all environments (DEV, QLT, PRD). - Documenting the development stage for deployment plan in all environments. - Project orientation depending on business needs.
-
-
-
BNP Paribas
-
France
-
Banking
-
700 & Above Employee
-
Business Analyst
-
Aug 2019 - Jul 2020
Shared Data Ecosystem - Systems for Capital Reporting - Part of the Capital Reporting Solutions Services team, which is accountable for the data quality management and reporting for the BNP bank group and its subsidiaries. - Ensuring the successful load and availability of all the referential, gross data, indexes, and other data for the quarterly report to the ECB - European Central Bank. - Production of COREP regulatory reports and their distribution to the supervisor ECB (European Central Bank). - Providing Data Quality, tacking, and production back-up. - Contributing to the Data Quality program by applying Quality & integrity criteria to the scope of responsibility. - Performing non-regression testing. - Managing and controlling user administration and assisting users during the closing period. - DRP (Disaster Recovery Plan), which consists of a series of tests to ensure data reliability and recovery. > Achievements - Effective participation in implementation project (regulatory evolution, new functionalities, and optimization). Show less
-
-
-
Fraedom (VISA group)
-
Auckland, New Zealand
-
Data Services Analyst
-
Mar 2017 - Apr 2018
- Implemented and monitored the Data File Management process, a formal process of managing complex data files containing sensitive financial information. - Mined and plugged data into various Data Science models which were currently being developed by the company, an ongoing initiative. - Provided data for various reporting components, having the ability to identify crucial pieces of information and deliver them in a state whereby they can be easily used for report and insight analysis. - Managed General data file (inbound/outbound). - Ongoing management of GDPR rules for data flow (data minimization, storage limitation, security and accountability) > Achievements - Developed a deep understanding of our Database Systems, coordinated with 20+ Databases, distributed over 15 servers, containing millions of records that grew exponentially. - Managed the complex financial data systems, ensuring the systems were performing as expected and identified points of failure and developed solutions. - Implemented a project to decrease incidents related to delay in data processing (ETL process) by 20%. Show less
-
-
-
METRIX - (Intellihub group)
-
Auckland, New Zealand
-
AMI Data Services Analyst
-
Jan 2016 - Mar 2017
- Responsible for data cleansing in SAP, investigating installation paperwork, historical power readings researching, data amendment, and updating the Electricity Authority (entirely responsible for the regulation of the New Zealand electricity market). - Data cleansing, reconciling, and processing using SAP, Excel, Access databases according to the Electricity Authority compliance legislation. - Identified discrepancies and non-conformities in electricity data readings related to the installation paperwork, the historical consumption, and the current electricity reading and compared with patterns to identify possible tampering power and other trends. - Provided audit and compliance reports as needed. > Achievements - Performed data cleansing and data mining actions, along with the data cleansing team, which cleaned and made the data compliant in 95% of all electricity consumers. Show less
-
-
-
The Icehouse
-
New Zealand
-
Professional Training and Coaching
-
1 - 100 Employee
-
Impact Analyst
-
Aug 2015 - Dec 2015
Short Term Contract - Database management extraction, cleansing and analysis of various data sources (Access, Excel, others). - Data loading process into CRM for further analysis and insight reporting for financial /sales/marketing departments. > Achievements - Performed data gathering activities from multiple data sources and ETL processing development which recovered approximately 90% of fragmented data which was used for marketing campaigns. Short Term Contract - Database management extraction, cleansing and analysis of various data sources (Access, Excel, others). - Data loading process into CRM for further analysis and insight reporting for financial /sales/marketing departments. > Achievements - Performed data gathering activities from multiple data sources and ETL processing development which recovered approximately 90% of fragmented data which was used for marketing campaigns.
-
-
-
-
Project and Financial Manager
-
Jun 2013 - Sep 2014
- Project delivery (milestones) management and progress coordination. - Implementation of the financial management system (ERP). - Finance accounting / bank reconciliation / payable/receivable. - Resource planning. - Project delivery (milestones) management and progress coordination. - Implementation of the financial management system (ERP). - Finance accounting / bank reconciliation / payable/receivable. - Resource planning.
-
-
-
-
R&D Project Coordinator
-
Jun 2012 - Jun 2013
- Developed and monitored end-to-end detailed work/project plans (Planning/Initiation, Requirements & Analysis, Test, and Deploy/Delivery). - Defined project inter-dependencies, outputs, critical path dependencies, and task durations. - Analyzed business and performance metrics and reported out on trends and strategic opportunities as it related to business risks. - Managed Project Budget/Financials through financial tracking and reporting (plan, actual, forecast). - Procurement and Supply chain management for all the supplies required for the projects - Defined resource needs/requirements, securing resource alignment and track resource allocations against the project schedule - taking into account resource availability and/or constraints. - Recognized and realized commercial opportunities that enhanced product vision and the roadmap through technical and design innovation. - Partnered with both internal, external and stakeholders to ensure successful completion of projects. - Recognized and realized commercial opportunities that enhanced product vision and the roadmap through technical and design innovation. - Varied ad hoc projects and reports that required coordination across the various teams. Show less
-
-
-
-
R&D Project Manager
-
Sep 2009 - Jun 2012
- Developed and monitored end-to-end detailed work/project plans (Planning/Initiation, Requirements & Analysis, Test, and Deploy/Delivery). - Defined project inter-dependencies, outputs, critical path dependencies, and task durations. - Analyzed business and performance metrics and reported out on trends and strategic opportunities as it related to business risks. - Procurement and Supply chain management for all the supplies required for the projects - Managed Project Budget/Financials through financial tracking and reporting (plan, actual, forecast). - Defined resource needs/requirements, securing resource alignment and track resource allocations against the project schedule - taking into account resource availability and/or constraints. - Recognized and realized commercial opportunities that enhanced product vision and the roadmap through technical and design innovation. - Partnered with both internal, external and stakeholders to ensure successful completion of projects. - Recognized and realized commercial opportunities that enhanced product vision and the roadmap through technical and design innovation. - Varied ad hoc projects and reports that required coordination across the various teams. Show less
-
-
-
-
Financial And Administrative Manager
-
Feb 2004 - Sep 2009
- Managed administrative processes, such as warehouse, vehicles, people, and organizational structure check-in. - Responsible for the financial processes such as bank reconciliation, accounts receivable and payable functions, cash flow and payroll. - Procurement and supply chain management. - Financial planning, budget management, and forecasting. - Overseed the implementation of the ERP system, with specific customizations in respect to the company business model. - Managed administrative processes, such as warehouse, vehicles, people, and organizational structure check-in. - Responsible for the financial processes such as bank reconciliation, accounts receivable and payable functions, cash flow and payroll. - Procurement and supply chain management. - Financial planning, budget management, and forecasting. - Overseed the implementation of the ERP system, with specific customizations in respect to the company business model.
-
-
-
-
Oracle Database Administrator
-
Feb 2002 - Feb 2004
- Oracle 8 database management - Data migration from SQL Server 6.5 to Oracle 8i - Scripting/triggers for new database structure - Operated Oracle Enterprise Manager and Backup/Recovery routines to keep it working properly and safely. - Oracle 8 database management - Data migration from SQL Server 6.5 to Oracle 8i - Scripting/triggers for new database structure - Operated Oracle Enterprise Manager and Backup/Recovery routines to keep it working properly and safely.
-
-
-
Banco Rural S/A
-
Banking
-
100 - 200 Employee
-
Administrative Analyst
-
Jan 1998 - Feb 2002
- Internet banking support and customer services management - Data file monitoring process - Banking reconciliation and payable/receivable support - General administrative tasks - Customer service - Internet banking support and customer services management - Data file monitoring process - Banking reconciliation and payable/receivable support - General administrative tasks - Customer service
-
-
-
Samarco
-
Mining
-
700 & Above Employee
-
Trainee - Costs, Budget and Patrimony
-
Jan 1996 - Dec 1997
- Assisted with the inventory of company assets, property and resource planning - Compared and analyzed budget expenditure in a monthly report to the Board of directors - Forecasting / Budgeting - Prepared reports concerning information related to costs and budgets - Capital expenditures analysis and assets stocktaking for financial control - Assisted with the inventory of company assets, property and resource planning - Compared and analyzed budget expenditure in a monthly report to the Board of directors - Forecasting / Budgeting - Prepared reports concerning information related to costs and budgets - Capital expenditures analysis and assets stocktaking for financial control
-
-
Education
-
2014 - 2015
NZIE - New Zealand Institute of Education
Diploma in Applied Business - Level 7, Advanced Business - International Marketing -
2018 -
University of Michigan
Specialization - Coursera, Data Science -
2018 -
365 Careers
Specialization - Udemy, Data Science -
2017 - 2017
AXELOS – Global Best Pratice
ITIL Foundation Certificate in IT Service Management, ITIL -
2009 - 2009
IETEC
Project Management - Course for PMI certification, Project Management -
2002 - 2004
Oracle do Brasil / SP
Oracle Certified Professional / Database Administrator – 8i, Database -
1994 - 1997
Universidade FUMEC
Bachelor of Business Administration (B.B.A.), Business Administration and Management, General
Community
