Magaly del Carmen Fonseca Medrano (Maggie)
S Linkedin: www.linkedin.com/in/maggie-f-researcher
➊3
https://github.com/mfm2174/
Professional Summary
Data Scientist with experience in statistical analysis, machine learning, and integration of large
datasets. Skilled in ETL, predictive modeling, hypothesis testing, and development of interactive
dashboards to support decision-making. Ph.D. in Environmental Sciences, currently pursuing an
MBA in Data Science and Analytics (USP/Esalq) and a Bachelor’s degree in Data Science
Technology (UFMS). Strong interest in applying data science for market supervision, anomaly
detection, prevention of illicit activities, and ensuring financial operations integrity. Proficient in
Python, R, SQL, Power BI, and cloud tools (Azure/AWS, Databricks).
Technical Skills
• Languages & Libraries: Python (Pandas, Scikit-learn, NumPy, Seaborn, Statsmodels,
Plotly), R, SQL/PostgreSQL
• Statistics & Machine Learning: Hypothesis testing, linear regression, ANOVA, PCA,
clustering (K-Means), supervised and unsupervised learning
• ETL & Automation: Pipeline development, automated scripts, and database integration
• Visualization & Dashboards: Power BI, Tableau, Seaborn, Matplotlib, Plotly
• Version Control Tools: Git/GitHub
• Cloud Computing: Knowledge of Azure and AWS
• Big Data & Advanced Analytics: Databricks
Professional Experience
Data Scientist – Federal Institute of Brasília (IFB)
Gama, DF |
Nov/2024 – Present
- Taught Applied Statistics with R and Python; used PostgreSQL for handling educational
datasets.
- Applied skills: Python (pandas, scikit-learn), R (dplyr/ggplot2), SQL/PostgreSQL, Power BI, ETL
(merging/cleaning), K-Means, PCA. Data pipelines with Databricks and cloud integration with
AWS/Azure (S3, Blob Storage, Data Factory).
- Relevant Project: IFB Educational Indicators Dashboard (enrollment, dropout, course offerings)
in Power BI connected to PostgreSQL, with a Python-based ingestion/transformation pipeline
and descriptive plus clustering analyses to support academic decision-making.
Data Scientist – SEST SENAT
Brasília, DF |
May/2024 – Nov/2024
- Conducted hands-on training in Python and Power BI for data analysis and decision-making.
- Applied skills: Python (pandas, matplotlib/seaborn), Power BI, PostgreSQL, Git/GitHub
versioning, ETL building.
- Relevant Project: Operational Research workshops with real data, including a mini-pipeline
(ETL → K-Means → visualization) to demonstrate performance segmentation and operational
costs.
Data Scientist – LAPIG/UFG (Geoprocessing and Image Processing Lab)
Goiânia, GO |
May/2023 – Apr/2024
- Conducted geostatistical analyses and integrated climate/agricultural data using Python and R.
- Applied skills: NumPy/SciPy/pandas, R (caret, ggplot2), QGIS/GeoPandas, collaborative
notebooks.
- Relevant Project: Exploratory productivity model with PCA and regressions, consolidated into
an interactive dashboard.
Data Scientist – Ministry of Agriculture / IFGoiano
Brasília, DF |
Oct/2021 – Dec/2022
- Developed ETLs and database integrations; BPM processes and Power BI dashboards.
- Applied skills: SQL, Power BI, process automation (Python), process documentation.
- Relevant Project: Institutional data consolidation pipeline (ingestion, processing, key metrics,
and executive report).
Data Scientist – Embrapa / University of Brasília
Brasília, DF |
Jan/2016 – Apr/2020
- Applied statistical modeling to agriculture; managed georeferenced databases.
- Applied skills: R (experimental statistics, time series), SQL, QGIS, technical communication with
interactive graphics.
- Relevant Project: Georeferenced pest database with logistic regression and time series analysis
to support monitoring.
Relevant Projects
•
Cloud Data Pipeline: Configuration of AWS S3 and Azure Blob Storage buckets for storing
and integrating public data, with processing in Azure Databricks and statistical analysis
in Python.(IFB)
•
Anomaly Detection: Application of clustering and supervised learning algorithms to
identify anomalies in historical datasets, simulating financial market supervision
practices.(IFB, LAPIG, SEST SENAT)
•
Data Process Automation: Built ingestion and transformation pipelines using AWS
Lambda and Azure Data Factory, optimizing ETL workflows and ensuring continuous
monitoring.(IFB, LAPIG, SEST SENAT)
•
KPI-Oriented Analytical Dashboards: Developed Power BI dashboards integrated with
Azure SQL Database to track institutional indicators and support decision-making. (IFB)
Education
•
•
•
•
•
MBA in Data Science and Analytics – USP/Esalq (2024 – 2025)
Bachelor's in Data Science Technology – UFMS (2024 – Ongoing)
Ph.D. in Environmental Sciences – University of Brasília (2016 – 2020)
M.Sc. in Sustainable Development – University of Brasília (2005 – 2007)
Bachelor’s in Business Administration – University of Brasília (2000)
Languages
•
•
•
🇧🇷 Portuguese: Fluent
🇪🇸 Spanish: Fluent
🇺🇸 English: Advanced
