ÍCaro P.
Data Analyst

Skills

Looker

Sql

Microsoft Excel (Advanced Analytics Add-ons)

Python

Amazon Aws

Trello

Jira

ÍCaro is available for hire

Hire ÍCaro P.

All Howdy Candidates are vetted for skills and english proficiency.

Bio

A statistician with more than a decade of industry experience, including five years focused on data analytics. Expertise in generating technical reports using R and SQL, visualizing data with tools such as Power BI, Metabase, and Google Looker, and developing machine learning models. Proficiency in database management. Known for a methodical and analytical approach to business problem-solving, coupled with a willingness to acquire new skills and a strong ability to excel in collaborative environments. Available for freelance contract engagements within structured company frameworks.

Data Analyst
9/1/2023 - Present

Developed proficiency in managing and structuring databases to handle large volumes of structured and unstructured data from diverse sources. Utilized advanced research tools and BI resources for calculating various KPIs and aiding decision-making processes. Supported the publication of reports in Power BI within Petrobras' Workspace. Executed SQL queries to collect, transform, and prepare data from Oracle, PostgreSQL, and SQL Server databases. Contributed to projects including the Order Book Report and Purchase Request Entry from the supply area. Played a key role in creating KPIs such as average total purchase time, progress tracking, and identifying top 5 longest duration projects. Provided support in producing a detailed dossier describing the steps involved in report issuance processes. Developed and maintained dashboards in Power BI to visualize and communicate data insights effectively.
Data Consultant
12/1/2022 - 8/1/2023

Excelled in the development of data collection systems and conducting data analysis to optimize statistical efficiency. Created dashboards for guided analytics using Power BI (DAX) and Metabase, which facilitated better decision-making processes. Identified and interpreted trends or patterns within complex data sets, enhancing the overall understanding of the data. Demonstrated competence in analyzing and disseminating relevant information with a high degree of accuracy and attention to detail, utilizing the R language. Served as the point of contact with management to prioritize business and information needs, ensuring alignment with organizational goals.
Data Analyst
4/1/2022 - 11/1/2022

Performed statistical analyses, both descriptive and diagnostic, using R and SQL languages. Created comprehensive dashboards for guided analytics using Looker and Metabase, and acted as the primary point of contact for business teams, squads, and leadership. Specialized in demand prioritization through agile methodologies utilizing tools such as Jira and Trello. Conducted in-depth profile analysis and developed views and automated reports. Developed key customer experience metrics, including NPS and CSAT, to support business monitoring. Provided support for data capture and ingestion into the Data Lake, specifically using AWS Redshift.
Planning Analyst
6/1/2021 - 4/1/2022

Developed proficiency in conducting statistical analyses, both descriptive and diagnostic, using R and SQL. Created dashboards for guided analytics with Power BI to support decision making. Served as a key contact point with business teams, squads, and leadership, facilitating effective prioritization of demands. Conducted in-depth profile analysis and customer behavior studies, including conversion funnel analysis and A/B testing. Generated accurate sales projections and developed metrics for ongoing business monitoring. Provided support to Product Owners by accessing data necessary for testing new features.
Planning Analyst
7/2/2020 - 6/1/2021

Developed proficiency in SQL, Python, and Excel for stock replenishment analysis. Conducted extensive data analysis and forecasting using statistical methods and machine learning algorithms. Demonstrated expertise in inventory management systems and ERP software, optimizing stock levels and reducing excess inventory. Utilized data visualization tools such as Tableau and Power BI to present findings and actionable insights to management. Implemented data-driven strategies that improved inventory turnover rates and service levels. Ensured seamless collaboration with cross-functional teams using JIRA and Confluence for project management and documentation.
Demand Planning Analyst
9/2/2014 - 5/2/2020

Specialized in estimating future consumption demand to ensure product availability, aligning with production capacity and revenue expectations through Sales and Operations Planning (S&OP). Developed proficiency in creating statistical analyses and projections based on historical data for demand forecasting. Validated future demand plans with production planning, finance, marketing, and sales departments while considering the company's tactical plans. Collaborated in developing demand forecasts for new product launches and participated in monthly events concerning the product life cycle. Constructed and analyzed forecast accuracy indicators, and conducted thorough studies to identify opportunities for process improvement and the enhancement of indicator results.
Data Analyst
5/2/2012 - 5/2/2014

Developed expertise in managing Cosmetovigilance indicators with a focus on consumer safety. Proficient in handling databases, including data loading, ensuring consistency, validation, composing historical databases, and creating variables. Conducted thorough analyses utilizing advanced statistical techniques. Created comprehensive spreadsheets and presentations to effectively communicate results obtained from analytical processes. Documented all analytical procedures meticulously. Supervised schedules and coordinated various studies to ensure timely and accurate completion.