Caio Kawahara

Data Engineering & Process Automation with Python Experience in Data Engineering, focusing on automation of operational and financial processes using Python, pandas, and SQL. Key Achievements: - Developed Python scripts and routines to automate processes across multiple departments. - Implemented API integrations for data ingestion and delivery. - Designed and automated the end-to-end workflow for delinquent client collections. - Focused on data processing and analysis using pandas, including cleaning, transformation, and manipulation of data. Database Refactoring & ERP Migration Experience in refactoring stored procedures and migrating database environments, ensuring data integrity, consistency, and ERP updates. Key Achievements: - Updated and migrated ERPs from NewconPlus to Newcon4, ensuring operational consistency. - Replicated and adapted business rules for the consortium operational area to the new environment, maintaining data integrity. Scrum & Process Management Experience as Scrum Master, responsible for agile process management, team monitoring, and workflow documentation, ensuring quality and project efficiency. Key Achievements: - Led a team of 5 analysts as Scrum Master. - Developed the theoretical base for agile methodology, documented Kanban workflows, and used Jira for task management. Documentation & Standardization Experience in documenting and standardizing processes using Confluence software, ensuring organization, traceability, and compliance with audits. Key Achievements: - Developed layouts and documentation structures for operational processes. - Monitored and submitted documentation for audits, including inventory, missions, and FMEA.

I had great pleasure in participating in Crani's projects, a company that was fundamental to my professional development. During my time there, with the support of my team, I carried out various activities, such as developing dashboards for the logistics performance of carriers, monitoring data loads, and providing support to logistics analysts. Activity Details: Report Development and Customization: Development and customization of logistics and financial reports for transport companies using Power BI. Procedure Development: Creation and optimization of procedures in SQL Server to standardize routines and feed new reports. Data Load Monitoring and Validation: Tracking and validating data loads and processes. Support and Assistance: Providing support to Logistics Analysts in daily operations and issue resolution. Business Rule Development: Developing business rules using DAX. Pipeline Orchestration: Managing and orchestrating pipelines in Microsoft Azure with Azure Data Factory. Project Versioning -- GitHub Project Management with Scrum: Participating in task organization and tracking in a Scrum environment using Bitrix.

I was a BI Analyst Intern, where I developed fundamental knowledge in data analysis, created my first metrics using DAX, and learned to perform simple ETL processes using Google Sheets and Power Query for data processing. I also gained knowledge in Scrum and technology project management. During this period, I created my first Power BI report (simple internal reports) but they sparked my motivation and interest in entering the world of Analytics.