I've been working as a tech lead and proserv consultant in data migration and modernization projects, creating Amazon Prescritive Guidances, delivering trainings for internal team, partners and customers.Projects:Arcos Dourados (McDonalds): Teradata to Redshift MigrationRede: Sybase and Oracle datawarehouse migration to AWS Serverless Data Lake Framework (SDLF) with modernization and redshift datawarehouse. Linx: New data lake house with AWS Serverless Data lake framework, Data Vault 2.0 in a Data Mesh architecture with AWS Data Zone. Support in customized solutions based on EMR Serverless for data legacy environment.

- DataWarehouse modeling, conceptual, relational and dimensional, logical and physical modeling, to support business requirements and solutions- Design of efficient and robust data pipelines, aiming at the fast processing of large volumes of data and high complexity of business rules- Adoption of good data governance practices- Datawarehouse Modernization and Optimization, Self-Service Data Preparation, Data-Lakes- ETL Architecture Planning for the analytical environment (Haddop and Teradata)- Topology definition and configuration for the analytical environment in ODI (Oracle Data Integrator)- Interpretation of business requirements- ETL development- Development of shell scripts and JCL- Support to ensure the generation, collection and storage of data within the standards- Identification and implementation of improvements in the data process for scalability and automation- Teradata Database Administration (DBA)- Establishment of best practices for Teradata development- Tuning of applications, tableau, microstrategy, alteryx and batch processes when accessing the Teradata database.- Modeling and loading of Datawarehouse Metadata for SLA monitoring and management- Creation of Dashboards for monitoring the environment (Hardware and Software) of Datawarehouse in Tableau and R Shiny- Processing of database logs and application of statistical concepts for database tuning in R language.- Creation of Datawarehouse usage reports in R Markdown language.- Creation and implementation of SandBox Architecture for Data Science / Data Lab- Unit tests, integrated in the Mainframe and data validation- Creation of Views for Microstrategy reports- Tuning in batch processes and Microstrategy reports- Maintenance of DataStage jobs- Definition of quality standards and best practices in Teradata- QA in ETL projects from external suppliers- Creation and Administration of Workloads in TASM/TIWM

- Creation of critical ETL processes in Teradata, for the Cost Engines project - Teradata best practice consultancy- Support development team- Test and QA for new ETL processes

- Teradata DBA - Logical and physical design of the database - Definition of access policies - Definition of the entire DW and ETL architecture - Creation of templates for load routines in Control-M - Encoding of the ETL Core in ShellScript and DataStage Basics Language - Drafting documentation on the architecture and best practices for EDW - Responsible for guidance to Teradata company on how to follow the architecture defined for ETL - ETL Development in Teradata and DataStage - Relational and Dimensional Data Modeling - Creating Views for the Microstrategy - Performance Tuning in ETL processes and Microstrategy Reports - Support 24x7 - Maintenance in migrated processes from DB2 to Teradata - Migration from SAP BW to Teradata - Migration from DW SQL Server to Teradata

- Design,development and maintenance of ETL Processes in Teradata and DataStage - Mapping activities of the BI area, documentation of processes and preparation of manuals on the BI environment and ETL architecture - Responsible for monitoring and quality control of projects with external consultants.

- Development and maintenance of ETL processes in powercenter- Tuning in load processes in the powercenter- Validation of processes after migration to Exadata

- Administration of EDW Teradata Production database- Tuning in Queries, applications and workload- Setting the Priority Scheduler

- Customer: Santander Bank- Development of informatica power center maps for the migration of reconciliation data and Comex from Real Bank to Santander.- Critical Maintenance Planning and Version Upgrade

- ETL Strategy Design for PowerCenter with Teradata- Tuning in SAS Queries and PowerCenter processes for Teradata Access- Definition of ETL Stabilization Strategy - Stabilization and Tuning of ETL processes - Definition of Parameters for Performance Improvement of Teradata - Creation of Data Cleaning Routines - Improvements to the physical data model - Planning maintenance in the environment - Development of ETL (Teradata Tools and utilities and MainFrame JCL)

- Database physical design - Definition and implementation of access and security policy, using profiles and roles - Creation / Maintenance of database (Teradata and SQL - Server) - Administration of Teradata database and SQL Server, with its users - Tuning in user queries and production processes - Data management, relational and dimensional physical / logical modeling (c / Erwin) - Creation of Views to meet the customer characterization model - Creation, maintenance and support of ETL processes in Teradata (utilities TD and shell script) and SQL Server (DTS and Transact SQL) - Migration of historical data from Oracle to Teradata - Extraction of data from SQL Server via DTS and BCP. - Support the application development team - Structuring of the DW and BI area

- Leadership of ETL team and preparation of work plans for maintenance critical. - Consulting in datawarehouse since the beginning of the ETL construction. - Analysis / Development / Implementation / Maintenance of ETL processes in Teradata (Execution in MainFrame - JCL). - Tuning in load processes, user queries and critical maintenance. - Training in Teradata and Datawarehouse for ETL team. - Physical Modeling for Teradata and improvements in the environment. - Teradata Support 24x7. - Analysis of relational and dimensional models for better performance. - Creation and maintenance of extraction and loading specifications. - Homologation and data quality. - Creation of standard documentation for ETL development, taking into account requirements of SOX.

- Development / Maintenance of ETL processes in PowerCenter and Sybase (Transact SQL).- Development of Batch processes in PL / SQL for the generation of database in an Oracle 8i environment for government (Susep).- Maintenance in several processes of data loading in PL / SQL.

- Development and maintenance of systems using VB and Delphi. - Maintenance / Testing of computer equipment; - Installation / Configuration / Maintenance of software and networks

- Testing / Maintenance of PCI's and IT equipment;- Development of Management Systems and Electronic Security.