Miguel Pacheco Soares
Summary
Positive problem-solver with knack for uncovering insights through data-driven analysis. Well-versed in statistical methodologies and proficient in tools such as SQL and Python, with solid understanding of data visualization techniques. Capable of leveraging analytical skills to drive impactful business decisions.
Overview
3
3
years of professional experience
Work History
Data Analyst Intern
Analyst builder
11.2024 - Current
- Cleaned and processed data using SQL and Python (Pandas) to prepare datasets for analysis, addressing key business questions such as the most popular courses, user engagement by difficulty (Easy/Medium/Hard), and retention rates over time
- Performed a time series analysis to identify trends in user behavior, including active usage times, course completion rates, and average time spent on the platform each month
- Created interactive dashboards and visualizations in Tableau to present key insights, such as user activity by hour, subscription usage, and geographic distribution, enabling stakeholders to make data-driven decisions
- Conducted spatial analysis (location analysis) to map user demographics by country and region, and used segmentation models to categorize users based on activity patterns and engagement, supporting targeted marketing and retention strategies
Application Developer
Prolacto
09.2021 - 10.2021
- Developed a mobile application using the OutSystems low-code platform to enable factory workers to input inspection data in real-time, improving data accuracy and streamlining reporting processes during daily factory inspections.
- Worked closely with clients throughout the development process to gather feedback, ensuring that final products met their expectations.
- Collaborated with stakeholders regarding project capabilities and limitations to deliver optimal functionality.
Education
High School Diploma -
ENTA
São Miguel, Portugal10.2021
Skills
- SQL (MySQL, PostgreSQL)
- Tableau
- Excel (VLOOKUP, Conditional Formatting, Pivot Tables)
- Python (Pandas)
- ETL processes
- Geospatial analysis
- Time-series analysis
- Problem-solving abilities
- Data Interpretation
- Data Visualization
Projects
Instacart Targeted Marketing Project, August-October 2024
- Preprocessed and integrated data in Python by cleaning, merging, filtering, sorting, and aggregating datasets to address key business questions posed by the executive team.
- Delivered a comprehensive report highlighting insights on the most profitable customer segments for targeted marketing efforts, helping to guide future strategy.
- Ingested and organized data into a relational database management system (RDBMS), creating a detailed data dictionary and an entity relationship diagram to define the data structure.
- Utilized PostgreSQL to develop queries and common table expressions (CTEs) that answered critical business questions, providing actionable insights for decision-making.
Timeline
Data Analyst Intern
Analyst builder
11.2024 - Current
Application Developer
Prolacto
09.2021 - 10.2021
High School Diploma -
ENTA
Similar Profiles
Shametrics GibbsShametrics Gibbs
Ga Secretary of State at License AnalystGa Secretary of State at License Analyst
Brian WarrenBrian Warren
Medical Transportation Management at Senior Systems AnalystMedical Transportation Management at Senior Systems Analyst
Betül KuruBetül Kuru
Healthcare Data Analyst at Freelance Healthcare Data AnalystHealthcare Data Analyst at Freelance Healthcare Data Analyst