ThiagoBrandao (1)
ThiagoBrandao (1)
ThiagoBrandao (1)
SUMMARY
With over 3 years of experience in Business Intelligence, with expertise in data analysis, data visualization, and ETL
processes. I am highly proficient in SQL, Python, T-SQL, and Power BI, with strong knowledge in data modeling, statistical
analysis, and process automation.
My technical expertise also includes data pipeline development, statistical testing, and advanced Excel for sales and
operational analysis.
EXPERIENCE
Business Intelligence Analyst
PGL Adventures September 2023 - July 2024, Paris - France
• Automated internal operational processes using Power Query/Excel for data ingestion in local server .
• Developed interactive dashboards in Power BI for operational performance analysis.
• Performed statistical methods and forecasting techniques to help optimizing resource allocation.
• Optimized workforce allocation using Trend Analysis based on demand and seasonality.
• Collaborated with other departments on communicating insights and recommendations.
PROJECTS
Revenue Analysis and Forecasting
Geovictoria Revenue Portfolio • December 2022 - December 2022
• Applied concepts from course to build a prediction model to enable users to forecast revenue for upcoming year.
• Performed data wrangling on a dataset with outliers and missing data using SQL and Excel.
• Employed statistical and trend analysis techniques such as geometric and arithmetic mean, probability, dispersion
measures and seasonality.
• Carried out revenue forecasting in Excel. Overall, the model achieved 73% accuracy of prediction.
EDUCATION
Associate's Degree - Data Science
UNINOVE • Rio de Janeiro, Brazil • 2024
• Expected Graduation: December 2024
SKILLS
Technical Skills: Python, SQL, PowerBI, Office365, Statistics, Database Design, Data modelling, ETL, Snowflake, SISS,
CRIPS-DM, DataViz, Power Query, DAX, Git, GitHub, AWS, Azure
Areas of Interest: Data Cleaning, Data Visualization, Machine Learning, ETL, Statistical Analysis, Business Intelligence,
Data Science