Renan S.Data Analyst
Skills
A seasoned Data Analyst with five years of diverse experience, including two years concentrated in data analytics and engineering. Proficient in leading high-scale projects such as data migrations and the implementation of KPIs across multiple countries with varied business requirements, honing excellent project management capabilities. Expertise in Python and SQL as primary tools, with extensive use of Office applications throughout professional endeavors. Seeking to advance in data analytics by further integrating project management, business intelligence, and technical data analysis.
IT Intern
2/1/2018 - 12/1/2018
Collaborated with multidisciplinary teams in the USA and across Latin America, including the Andean region, Argentina, Mexico, Panama, and Venezuela, to configure and structure roles/privileges in SAP Identity and Access Management (SAP IDM) systems. Engaged directly with local Logistics and Manufacturing managers to restructure IDM roles, identify Segregation of Duties (SOD) issues, and correct improper user permissions. Automated and enhanced IT SOX controls in Brazil, focusing on security access, computer operations, and change management to align with global policies and standards. This involved updating local narratives, creating Microsoft Access applications utilizing SQL queries, macros, and VBA coding, and developing specified guides and instructions for control execution. Established a SharePoint page for evidence storage and provided efficient guidelines and instructions.
Managed IT Service Management (ITSM) tickets, analyzed common user issues, and implemented solutions to reduce recurring problems. Provided follow-up support and problem-solving instructions to internal users regarding the Identity and Access Management tool. Contributed to cross-functional projects by gathering requirements and creating SharePoint pages, workflows, and access control permissions. Translated internal training materials and business documents, and participated in financial training sessions offered by the organization.Data Analyst
6/1/2022 - Present
Led the quality migration of datasets from AWS to Azure. Developed data investigation scripts in Python and SQL for a complex business application operational in over 9 countries. Conducted analyses to assess the impact of database migrations and created data quality dashboards and visualizations. Performed data analysis to investigate data quality trends, identifying outliers and gaps in historical sales data. Automated the data quality monitoring process for multiple countries using Power BI and a Slack bot.Continuous Improvement Specialist
4/1/2021 - 6/1/2022
Mapped and automated 49% of the team’s operational activities using Python and Power Automate. Developed four dashboards in Celonis, a process mining tool, for internal process monitoring, becoming the platform focal point for Internal Controls in six South American countries. Planned and led the implementation of internal controls monitoring KPIs across six countries in South America, resulting in a faster and more reliable data-driven monitoring concept. Developed a centralized Power BI dashboard, utilized by six countries in South America, with automated data refreshing. This impacted over 500 end users, significantly reducing their time spent on emails and platform messages.Risk Assurance Associate
2/1/2019 - 3/1/2021
Developed proficiency in IT external auditing, specializing in ISA and PCAOB-SOX clients. Conducted detailed soy seed multiplication royalty auditing, ensuring compliance and accuracy. Expertly mapped risks and controls within IT environments, leveraging deep knowledge of ISA and PCAOB-SOX standards. Offered consulting services on the General Data Protection Law (LGPD), navigating the complexities of Brazilian data privacy regulations effectively.
Computing Science at Federal University of Lavras
2013 - 2018
Scrum Team Member at Scrum Inc.
6/1/2022Blockchain advanced at FIAP
3/1/2022Celonis Data Engineer at Celonis
9/1/2021Celonis Analyst Track at Celonis
8/1/2021
Renan is available for hire
Hire Renan S.All Howdy Candidates are vetted for skills and english proficiency.