Guilherme C.
Data Analyst

Skills

Microsoft Excel (Advanced Analytics Add-ons)

Guilherme is available for hire

Meet Guilherme C.

All Howdy Candidates are vetted for skills and english proficiency.

Bio

Senior BI Analyst
3/1/2023 - Present

Conducted in-depth analysis and performance monitoring of social networks including Facebook, Instagram, Twitter, YouTube, and LinkedIn. Performed qualitative and quantitative analysis of audience engagement metrics and brand image on digital platforms. Engaged in scenario analysis and generated insights with actionable conclusions and recommendations. Developed comprehensive dashboards and reports using industry-leading tools.

Demonstrated advanced analytical skills and insight generation capabilities. Proficient as a Power BI Developer with strong expertise in Business Intelligence (BI), Excel, and other BI tools. Specialized in data modeling, database management, DAX, Supermetrics, ETL processes, and PowerQuery. Exhibited strong command of data analysis tools such as Google Sheets, Microsoft Excel, and Google Data Studio. Proved adept in problem-solving and showcased significant analytical capacity in delivering meaningful data-driven strategies.
BI Analyst
9/1/2022 - 3/1/2023

Responsible for business intelligence in a global beverage sector company, performing data analysis extracted from diverse sources including CRMs, databases, and market collection management platforms. Provided simplified and visually appealing insights using Power BI and Excel to aid in decision-making. Actively participated in strategic meetings with both clients and internal teams. Developed expertise in data extraction and analysis, proficiency in Power BI, and advanced skills in Excel.
BI Analyst
7/1/2022 - 10/1/2022

Handled responsibilities for the BI area of the purchasing department with a focus on creating and maintaining projects and structuring the data area. Emphasis placed on data automation and analysis for strategic decision-making. Demonstrated expertise in strategic planning, UX design for data visualization products using Excel and Tableau, and data segmentation for strategic decision making. Developed and maintained BI projects and data infrastructure, as well as ETL processes. Gathered requirements and defined metrics for new KPIs, while also ensuring data maintenance and modeling.
BI Analyst
9/1/2021 - 4/1/2022

Developed, constructed, and maintained ETL processes while gaining experience with various trade marketing solution platforms. Mapped, documented, and supported projects, gathering requirements for and developing business intelligence and data infrastructure initiatives. Designed UX products focused on data visualization, specifically dashboards, and structured new BI and Excel projects. Ensured the accuracy and maintenance of internal databases. Acquired basic knowledge of Python and MySQL.
Market Intelligence
12/1/2020 - 12/1/2020

Managed information flow for the largest site of a significant commemorative action in São Paulo, overseeing the processing of over 30,000 reports with 3,500 hires within 12 days. Developed expertise in collecting, validating, and analyzing data through a specific application. Utilized and maintained the Promo Marketing Report information system while coordinating closely with Trade and Selection teams. Conducted training sessions for more than 1,000 promoters and stockers, ensuring seamless operation and data integrity throughout the project.