Open To Work
PEDRO H. ANDRADE
São Paulo
Summary
Data Analyst experienced in delivering data-driven insights through predictive and prescriptive analysis, leveraging machine learning and ETL processes. Developed impactful data visualizations with Power BI, creating actionable dashboards that improved decision-making and optimized processes. Additionally, engaged in game and graphics development using C++.
Overview
6
6
years of professional experience
6
6
Certifications
Work History
Data Analyst
SPREAD TECNOLOGIA
São Paulo
04.2022 - Current
- Consolidated data from multiple sources, including Excel, text files, and databases.
- Utilized machine learning with Azure Databricks and Python for data analysis.
- Executed ETL processes to enhance data integration and accessibility.
- Developed database models to support application requirements.
- Performed DDL and DML queries in Oracle databases to manage data effectively.
- Optimized queries to improve database performance and reduce execution time.
Data Analyst
LILY SOLUÇÕES
02.2021 - 03.2022
- Developed analysis routines utilizing machine learning and Python to enhance anomaly detection in financial fraud.
- Executed ETL processes using Python and Julia to prepare data for comprehensive analysis.
- Generated management and financial reports leveraging Excel and Power BI; optimized SQL queries for APIs.
- Created financial dashboards and automated processes using Excel and Power BI for SPTrans.
Sales Data Analyst
PAGSEGURO PAGBANK
09.2020 - 02.2021
- Formulated sales strategies from competitive analysis and market insights to drive targeted initiatives.
- Analyzed financial data to support strategic decision-making processes.
- Enhanced reporting capabilities in Power BI to provide actionable insights for management decision-making.
- Developed reports in Power BI to monitor trends and inform management strategies.
- Executed ETL routines using Python for efficient data processing.
- Streamlined data workflows with Python ETL processes for improved efficiency.
- Collaborated with cross-functional teams to optimize project outcomes.
- Conducted competitor studies to pinpoint market opportunities and threats for proactive strategic planning.
Education
Bachelor of Science - Data Science
UNIVESP
São Paulo - SP, Brasil07-2026
Bachelor of Science - Economics
FMU
São Paulo - SP, Brasil07-2021
Skills
- Data manipulation
- Data visualization
- SQL queries
- Predictive analysis
- Machine learning techniques
- ETL routines
- Database modeling
- Python programming
- C proficiency
- System programming
- CMake expertise
- Real-time systems
- Problem solving
Certification
C++ Developer Training, 140 Hours, Educative.
Languages
English
Upper Intermediate (B2)
B2
Spanish
Upper Intermediate (B2)
B2
Portuguese
Native
Native
Work Preference
Job Search Status
Open to workWork Type
Full TimeLocation Preference
RemoteSalary Range
$45000/yr - $200000/yrTimeline
Data Analyst
SPREAD TECNOLOGIA
04.2022 - Current
Data Analyst
LILY SOLUÇÕES
02.2021 - 03.2022
Sales Data Analyst
PAGSEGURO PAGBANK
09.2020 - 02.2021
Bachelor of Science - Data Science
UNIVESP
Bachelor of Science - Economics
FMU