Simera Professional Key (SPK)

Gustavo A

Data Analyst

$ 3,700/month

10+ yrs exp

Skills

  • Business Intelligence
  • Cloud Computing
  • Communications
  • Data & Analytics
  • Data Analysis
  • Data Analytics
  • data visualization
  • ETL
  • Jira
  • Microsoft Excel
  • Problem Solving
  • Python
  • Spark
  • SQL
  • DataBricks
  • ETL Processes
  • HR Analysis
  • Phyton
  • Power BI
  • Communication

Gustavo A

Data Analyst

$ 3,700 /month

10+ yrs exp

Intro Video

Skills

  • Business Intelligence
  • Cloud Computing
  • Communications
  • Data & Analytics
  • Data Analysis
  • Data Analytics
  • data visualization
  • ETL
  • Jira
  • Microsoft Excel
  • Problem Solving
  • Python
  • Spark
  • SQL
  • DataBricks
  • ETL Processes
  • HR Analysis
  • Phyton
  • Power BI
  • Communication

Data Analyst

Eleflow Big Data
February 2022 - present

W2 contract in a Fintech with more than R$ 8 billion in TPV and 12 million monthly active users. ● Utilized advanced Data Visualization and Data Storytelling techniques to create impactful dashboards, resulting in the identification of over R$ 6 million in potential savings. ● Implemented a Python-based alert system using advanced statistical techniques, resulting in a 70% improvement in case analysis by accurately determining and assigning criticality levels to these cases. ● Successfully executed a large-scale ETL process using Databricks and Python to extract and transform over 40 million rows of data within a star schema data model, ensuring efficient data integration and optimal performance. ● Implemented a dynamic Power BI dashboard with variable input and forecasted value, successfully tracking over R$ 2 million in savings from a feature implementation, allowing for dynamic analysis and accurate projections. ● Conducted an in-depth data mining study (using SQL) , revealing a significant 54% reduction in fraud cases through the implementation of a specific feature. •

Business Intelligence Analyst - Operations Management

Instituto Nordeste Cidadania
September 2016 - February 2022

OSCIP (Civil Society Organization of Public Interest) operationalized the BNB Agroamigo and Crediamigo microcredit programs. These programs facilitated the lending of over R$ 16 billion to 3.8 million active customers in 2021. ● Implemented an automated workflow utilizing Power Automate and Power BI to streamline the rendering of accounts. The implementation resulted in an impressive 80% reduction in task time, improving efficiency and productivity. ● Implemented an efficient ETL flow using Knime to consolidate and concatenate over 20 Excel spreadsheets into a centralized database. The streamlined process significantly reduced task time by 90%, enabling seamless data integration and enhancing the performance of the Power BI dashboard. ● Developed an impactful Power BI report enabling comprehensive weekly performance data analysis, pinpointing goal attainment, and guiding targeted actions for achieving weekly objectives, resulting in a remarkable 30% performance enhancement. ● Developed a Power BI report with Row-level security (RLS) implementation to track campaign costs and budgets, providing secure access for over 30 users while ensuring data analysis, accuracy, and confidentiality. ● Facilitated an extensive Power BI training program for a cohort of 60+ students, enhancing their proficiency in utilizing the tool effectively and optimizing its application throughout the organization. ● Implemented efficient process for meal voucher benefits rendering (R$ 1,8 million monthly), resulting in an impressive 80% reduction in execution time and a remarkable 96% decrease in errors. ● Developed an accurate rewards campaign check flow using Excel, consolidating over 30 sheets, resulting in 99% accuracy for a campaign worth R$ 1.4 million per semester, benefiting 5k+ employees.

Business Consultant

Valor Soluções Empresariais
December 2014 - September 2016

● Implemented VBA-integrated Excel spreadsheets integrated with SQL databases, enabling comprehensive cost control for architecture projects across multiple clients, optimizing financial management and ensuring project profitability. ● Developed a Balanced Scorecard (BSC) strategic plan for a credit recuperation company, implementing KPI indicators to a dashboard in Excel. Integrated system-generated CSV files and utilized Power Query for efficient data import and analysis. ● Implemented VBA automation to streamline the treatment of sales report sheets, resulting in a remarkable 95% reduction in task time. ● Developed an Excel Dashboard to effectively track and analyze key financial metrics, empowering informed management decisions for enhanced business performance.

Smart Scores

Communication
80
Role Fit
95
Adaptability
80
Problem-solving
95

Smart Skills

beta