top of page

Vicky Costa

Data Analyst

Email

Address

Barcelona - Catalunya - Spain

About Me

With a solid 5-year background in data analysis, I am proficient in leveraging a suite of tools including SQL, Excel, Power BI, SAP, and Google BigQuery to extract, process, and analyze data. My expertise encompasses creating detailed management reports, ensuring data quality, and optimizing data integration through ETL processes. I am committed to furthering my knowledge in data science, particularly in areas of Machine Learning, with a focus on utilizing frameworks like Pandas, Numpy, Pyspark, and SKlearn.


Professionally, I have a proven track record in roles that required advanced data analytics, performance indicator analysis, and the development of automated data extraction and analysis jobs. My experience at companies such as Collinson Group, Santander, and Riachuelo S/A has equipped me with the skills to drive strategic business decisions and mentor teams in data analysis methodologies.


Note: I currently hold a VISA that allows me to live and work in Spain.

Academic education

University graduate
Institution: Open University of Catalonia - Barcelona (UOC)
Course: Data science

Start:  Feb/2025 

University MBA
Institution: University Paulista(UNIP)
Course: International Marketing and Trade

Start: Jun/2020 End: Apr/2021   

 

University graduate
Institution: Faculdade Metropolitanas Unidas(FMU)

Course: Game Designer
Start: Feb/2017 End: Dec/2019 

In the second semester, we started developing a game in Unity, using Blender to create objects, programming for interactivity, and Photoshop for the visuals. We created an engaging story, developed characters and scenarios, and fine-tuned the game based on our learning. The end result is a testament to our collaboration, skills and passion for creating a unique and engaging virtual world.

  • Facebook

Languages

English: Intermediate

Spanish: Intermediate

Portuguese: Native

Professional Experience

September 2024 to March 2025
Barcelona - Spain
(6 months)

February 2022 to June 2022
São Paulo - Brazil
(
5 months)

​August 2020 to January 2022
São Paulo - Brazil
(
1 year and 6 months)

January 2018 to August 2020 
São Paulo - Brazil
(2 year and 8 months)

August 2022 to January 2023
São Paulo - Brazil
(6 months)

Data HUB at Banc Sabadell

- Analyzing data to support legal and compliance decisions

- Creating dashboards and reports using Power BI

- Managing data in relational and non-relational databases (RDBMS, data warehouses)

- Using SAS for statistical analysis and predictive modeling

- Generating reports using SQL

- Automating processes with Python

- Ensuring compliance with banking regulations

- Collaborating on data governance, data security, and process modernization projects

- Preparing ETL jobs and predictive analysis

    Tools: Python, SAS, RDBMS, Excel, data warehouses, Power BI, PowerPoint, and ETL

Data Analyst at Colinson Group

- Conducted data quality assessments with SQL Server.
- Corrected data issues using SQL to improve accuracy.
- Analyzed performance indicators with Excel and Power BI for strategic decisions.
- Collaborated with teams to unify data quality assurance methods across Dallas and London.
- Created client reports in Power BI to drive insights and engagement.
- Produced management reports highlighting trends via Excel and Power BI.
- Managed ETL pipelines for data integration using Pentaho and SQL scripts.
- Performed data validation in analysis processes with SQL Server and Pentaho.

    Tools: SQL Server, Excel, Pentaho, Power BI, PowerPoint and ETL

Data Analyst at Banco Santander

- Conduct analyses using SQL Server and Excel to assess data quality and meaning.
- Cleanse data by removing corruption and fixing errors, utilizing ETL processes.
- Filter data and troubleshoot code issues through performance reviews, leveraging Jupyter Notebook.
- Automate data extraction from various sources with SQL, Python, and JavaScript.
- Identify patterns and interpret complex data sets using Pandas and Numpy for statistical analysis.
- Analyze data trends to influence business decisions, supported by Azure cloud services.


Tools: SQL Server, Excel, ETL, Python, Pandas, Numpy, Azure, Jupyter Notebook, PowerPoint and JavaScript

Data Analyst at Riachuelo

- Acquire business data using Power BI, SAP, and SQL Server.
Process and analyze data with Python scripts, utilizing Anaconda, Pandas, Matplotlib, and Numpy.
- Collect industry and operational data to enhance analysis, supported by Google Analytics and Google Data Studio.
- Create real-time data reports for management using Power BI and Excel, focusing on business metrics and statistical analysis.
- Analyze business outcomes and develop new reports with actionable insights to improve performance, leveraging ETL techniques.
- Prioritize business objectives in collaboration with management, informed by data-driven insights.
- Mentor new team members, sharing expertise in SQL Server, Excel, and data visualization tools.


Tools: SQL Server, Excel,  Google Analytics, Power BI, SAP, Google Data Studio, PowerPoint and  ETL

 Junior Data Analyst at Bignardi - Industria E Comercio De Papeis E Artefatos

- Analyzed e-commerce data using Excel, Google Analytics, Power BI, and ETL.
- Enhanced customer service strategies through data-driven insights.
- Managed and optimized inventory with ToTVS system analysis.
- Tracked and reported on key account orders to improve fulfillment processes.
- Utilized social media metrics to guide content strategy for business lines.
- Developed concise management reports highlighting performance and trends.
- Produced actionable business analysis via ToTVS reporting.


Tools: Excel,  Google Analytics, Power BI, PowerPoint and ETL

Data Analysis and Reporting Tools:

  • Excel

  • Power BI

  • Google Analytics

  • Google Data Studio

  • Anaconda

ETL Tools:

  • Pentaho

Programming Languages:

  • C#

  • JavaScript / NodeJS

  • Python

  • SQL

Cloud Services:

  • Azure

  • AWS

Frameworks and Libraries

  • Pandas

  • Numpy

  • Matplotlib

Development Tools:

  • Git

  • Visual Studio Code (VS Code)

  • Jupyter Noteboo

Databases:

  • SQL Server

  • MySQL

  • PostgreSQL

ERPs:

  • ToTVS

  • SAP

© 2023 por Vicky Costa.

Networking
Social

  • Facebook
  • LinkedIn
  • Instagram
  • GitHub
  • Pinterest
bottom of page