Gustavo Araújo
Data Analyst
Fortaleza - Zone 1, Fortaleza - CE, Brasil
2
Followers0
Following💡 Business and Data Analyst with more than 6 years of experience, and a proven track record of developing and implementing innovative solutions with a strategic and financial view with a focus on improving business results. 🚀 Previous accomplishments include the successful creation of dashboards using Data Visualization and Data Storytelling that led to the identification of over R$ 6 million in potential savings. 🎲Successfully executed ETL processes using Python and Databricks to extract and transform over 40 million rows of data within a star schema data model. Highlights ● Microsoft Power Bi Data Analyst Certified ● 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. ● 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. ● 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.
Careers
Data Analyst
Eleflow Big Data
Full time contract02/2022 - 09/2023
- 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.
Business Intelligence Analyst
Instituto Nordeste Cidadania
Full time contract09/2016 - 02/2022
- 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 evaluation, pinpointing goal attainment, and guiding targeted actions for achieving weekly objectives, resulting in a remarkable 30% performance enhancement
Business Consultant
Valor Soluções Empresariais
Full time contract12/2014 - 09/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.
Education
Fundação Getulio Vargas (FGV
MBA in Financial Management, Controllership
01/2015 - 12/2016Master's DegreeClass of 2016
Federal University of Ceará. UFC
Federal University of Ceará. UFC
01/2007 - 01/2014Bachelor's DegreeClass of 2014
Skills
PythonSQLData analysis and explorationData VisualizationMicrosoft ExcelPresentation skillsStatistical knowledgeData cleaningStatistical AnalysisAgile methodologies
ExperienceMid-level5-8 years
Hourly rate$30/hr
Welcome to Outdefine
A free tokenized community dedicated to connecting global tech talent with remote job opportunities. Our platform is designed to help you connect, learn, and earn in the tech industry while providing the chance to collect DEF tokens. Join our vibrant community today and explore a world of possibilities for your tech career!
Join for free