Renato Rossi Email & Phone Number

Chile

Chile

Continued the work from Cornershop, working with Data Engineering inside the Groceries and Stores vertical.- Created standard tests for hundreds of tables and improved coverage from 0% to 98%.- Managed integrations between Cornershop and Uber: developed dynamic pipelines to sync data automatically in minutes.- Served as the link between business teams and technology solutions.- Created a report that calculated dozens of KPIs for managers.- Created comprehensive documentation for new and existing processes to ensure clarity and consistency.- Ensured data observability and monitoring to maintain data quality and resolve any issues promptly.Tools used: Python, Hive, Apache Airflow, Git / Github, Presto, Spark, Beeline, Hadoop, JIRA, Amazon Web Services (AWS), Redshift, Redshift Spectrum, S3, JIRA

Chile

Part of the Ops Controlling team. Provided support and facilitated clean and pre-processed data access to the business intelligence teams and other groups.- Processed data in Redshift and Redshift Spectrum, using Apache Airflow as an orchestrator and AWS services.- Developed new and existing process documentation and performed multiple Q&A sessions to facilitate their integration.- Observed and monitored data.- Controlled data migration and sync between Cornershop and Uber. Made validations and reduced failures and reprocessing.- Developed reports using Presto and Hive.Tools used: Python, Apache Airflow, Git / Github, AWS (Redshift, Redshift Spectrum, Lambda, S3), Spark, Presto, Hive.

Viña Del Mar, Valparaíso Province, Chile

Part of the Risk, Compliance Data and Analytics team, supporting a leading US financial services firm.- Identified business challenges and translated them into solutions.- Worked in business and technical teams to deliver appropriate solutions.- Developed, maintained, and managed break-fix and enhancements of complex business reports.- Collected insights from data, building Tableau dashboards.- Performed data processing (ETL) using SSIS / Python.- Managed code using Git.- Participated in Agile projects, using JIRA as a tracker.- Developed a system to track the team's bandwidth, using C# .NET to build an app, JIRA, and SharePoint integration through Python SSIS and Tableau for reporting.- Performed report analysis and assisted end-users remotely.- Contributed to operational excellence by sharing knowledge and adhering to quality standards and best practices.- Participated in Evalueserve initiatives related to Mind + Machine projects, innovation, training, and development.* Developed a proof of concept related to the automation of regulatory requirements and another related to data management and validation.* Trained internal teams in Tableau and Data Science Program.* Served as Innovation Technology pillar leader, providing development environments and tools to several teams using Docker containers.- Won the Star of the Month award in 2019 and Performance award in 2020.Tools used: SSIS, Python, Teradata, SQL Server, Git, Tableau, Docker, Docker compose, JIRA, C#. Net, SharePoint

São Paulo Area, Brazil

Part of the data team, providing data for the entire company. - Collected KPIs and data necessities through all areas of the bank.- Optimized existing processes, data centralization, and rules standardization.- Tuned queries to improve the performance.- Identified and integrated data sources using Alteryx (ETL).- Structured data using star schema optimized for reports.- Created data visualization and dashboards in Tableau and Tableau Server: Acquisition funnel, cohort analysis, customer clustering, financial revenue and cost by product, and performance per attendant.- Controlled and organized activities backlog.- Created indicators alert.- Trained internal teams on Tableau to give flexibility and scalability.- Collected data for behavior analysis.Tools used: Redshift, Tableau, Alteryx, Asana, SQL Server

São Paulo E Região, Brasil

- Automated and centralized all corporate reports of strategic marketing areas, reducing their generation time by 70% and improving maintenance and data governance.- Developed and managed a loan forecasting system that started as a single-department initiative and is currently used by different bank areas, from agency managers to executive committees.- Suggested and created an internal collaborative tool using all existing infrastructure and technology, significantly saving the license structure.- Gathered requirements, created and maintained data structures in SQL Server, and data manipulation using SQL Server Integration Services to extract, transform, and load lots of information, besides data cleansing and other operations.- Implemented a customer prospecting system by agency's actuation radius, using geographic data on SQL Server.- Monitored the DB environment to ensure the reliability and stability of applications and imports.- Achieved a promotion to CRM / BI full analyst in 2014.Tools used: SSIS, SSAS, SSRS, IBM Cognos, SQL Server, C# .NET, VB, and .NET.

Brazil

- Management and improvements on data sync between our customer (B2W Inc) and theirs partners (B2B).- Improvements and implantation of B2B stores on Submarino's web store platform.- Implementation monitoring, testing and deploying packages on production enviroment.- Promoted in 2012

São Paulo E Redondezas, Brasil

- Enhancements and maintenance in a system to perform data loads to partners- System maintenance and new developments to our customers (SIS and HUGHES)- Responsible for generating and testing the backup routines.