Bruna Garcia

I am a dedicated and results-driven data analyst with a passion for leveraging SQL and ETL (Extract, Transform, Load) techniques to unlock valuable insights from complex datasets. With a proven track record of delivering impactful solutions, I excel in developing efficient SQL procedures to transform data into actionable information.

My expertise lies in designing and implementing ETL processes to streamline data flows, ensuring the availability of clean and consistent data for analysis. I have hands-on experience with popular ETL tools and frameworks, and I continuously stay updated with emerging technologies and industry trends.

In addition to my technical skills, I possess strong analytical and problem-solving abilities, allowing me to identify patterns, detect anomalies, and extract meaningful insights from data.

Proficiency with dashboarding, performance tracking, Pandas, Excel, SQL, Tableau, Power BI and Python to transform data into meaningful and easily understood visualizations and presentations. Fluency in Portuguese and English. Advanced Spanish skills.
 

Data Analyst

SDNA - Smart Data and Analytics

SQL Procedure Development: Created SQL procedures to assess and maintain the quality of customer data. These procedures involved using SQL statements to validate, clean, and analyze data. Implemented checks, cleansing techniques, and calculations to ensure accurate and reliable data. 
• Data Manipulation and Maintenance: Utilized SQL to manipulate and maintain the database. This included tasks such as creating and modifying tables to optimize data storage and retrieval. Also used SQL statements to update, delete, and manage data, ensuring data consistency and efficient database management.

 • EBX Structure Creation: Played a key role in building the structure within EBX, a comprehensive data management platform. Used my knowledge of data modeling and database design to define entities, attributes, relationships, and hierarchies, creating a solid foundation for effective data management. 

• Interactive Data Visualization: Enhanced clients' data visualization capabilities by extracting and transforming data using SQL. In EBX, I leveraged visualization features to create interactive charts, graphs, and reports. These visualizations provided clients with clear and insightful representations of their data, helping them identify patterns, trends, and areas for improvement.

Data Analyst Student

Thinkful 

Produced and presented professional projects and presentations from concept to completion focused on business forecasting, price modeling, and statistical analysis. 

• Developed skill sets in data analytics systems including Pandas, Excel, PostgreSQL, Tableau and Python, as well as methodologies including dashboarding, performance tracking, data wrangling, cleaning, and analysis.

 • Produced professional projects from concept to completion including: Statistical Significance in Python – Analysis of gasoline and electricity prices in the year of presidential election in US 

• Ran t-tests to determine the statistical significance between price in the year of presidential election and one year before. 

• Created visualizations in Python and presented data in PowerPoint to highlight how the presidential elections in US affects the gas prices.