Data Analytics Assistant
• Data Optimization: I was responsible for preparing data for migration in the Necton-BTG integration project, which facilitated the safe and efficient transfer of large volumes of data between systems, using SQL, Excel and Tableau. I worked on data integration and workflows using SSIS and SSMS, optimizing data integration processes that resulted in significant time savings.• Advanced Management: I integrated workflows with AWS Glue, optimizing processes and reducing execution times. I implemented storage solutions using Amazon S3 and Redshift, ensuring data integrity, accessibility and efficient management.• Queries and Automation: I developed complex queries that supported faster and more efficient decision-making with Amazon Athena and SQL; I automated reporting and email processes using Python, improving productivity and consistency.• Innovation in Applications and Catalogs: I developed an application that automated the registration of asset purchase and sale orders (registration of invoices) with Power Apps; I created data catalogs in Tableau and Excel that improved the accessibility and clarity of information for business areas.• Validation and Compliance: I worked on data validation for HR and Registration, ensuring accuracy in critical processes; I led a project to identify structured operations ensuring compliance and risk mitigation in the Risk and Compliance areas.
