k10sj02 Goto Github PK

I'm Stann, a passionate Data Analyst leveraging my strategic finance and politics background to unlock data insights.

• 👨🏽‍💻 Currently diving deep into SQL, Python, Data Visualization, and Analytics Engineering. Open to full-time and consulting opportunities in Data Analytics/Science.
• 💻 I have been honing my skills through various self-guided data projects that I will be displaying on my Github.
• 🧑🏽‍🔬🥼 Trained as a Political Statistician (MSc Political Science).
• 🇺🇸🇫🇷🇪🇸 Fluent in English, French, and Spanish.

🛠️ Languages and Tools

• SQL (PostgreSQL - Docker, pgAdmin4 for spatial SQL), Transact-SQL - Microsoft SQL Server, SQL Server Management Studio (SSMS) & Azure Data Studio, MySQL, Google BigQuery, Redash, SQLite)
• Data Prep OpenRefine
• Visualization Tableau, PowerBI, Google Analytics, Microsoft Excel, Flourish, Datawrapper
• Spreadsheets Microsoft Excel, GSheets
• Python (Libraries - SQLAlchemy, NumPy, pandas, matplotlib, seaborn, scikit-learn, NLTK, geopandas)
• R (Packages - dplyr, ggplot2, tidyr, data.table, caret, tidyverse)
• GIS (Mapping) QGIS, PostGIS
• Data Engineering Apache Airflow, dbt
• DevTools Git, Terminal, Visual Studio, vim, Docker, Docker Compose, Github Actions
• Cloud Computing Microsoft Azure, GCP
• Front-End HTML/CSS, Wordpress, Hugo
• CRM Salesforce
• Document Preparation LaTeX

• Understanding the Cohort Table: A Step-by-Step Guide The article delves into cohort tables, showcasing their role in understanding customer behavior. It explores reading methods and insights derived from the data, highlighting opportunities and limitations for business decisions.

This is my project portfolio.

• SQL Web Analytics for Political Advocacy Utilized SQLite for in-depth exploratory data analysis, covering user behavior, device segmentation, and referral sources. Employed Joins, Window Functions, and comparison operators to derive actionable insights and guide strategic decisions.
• SQL Online Commerce Cohort Analysis Utilized SSMS and Azure Data Studio to uncover insights into customer behavior, including cohort retention analysis and percentage breakdowns over time for online commerce database. Techniques such as CTEs, Temporary Tables, Window Functions, and the PIVOT function are employed to handle data transformation, calculation, and presentation. Created cohort dashboard in Tableau. Ideal for understanding online commerce trends and optimizing business strategies.
• Global Covid Tracking Project Utilized MySQL and MySQL Workbench to implement an ETL pipeline. Leveraged SQLAlchemy in Python to transform, clean, and upload data to a MySQL data warehouse. Conducted exploratory data analytics to uncover global COVID-19 trends from the data warehouse. Created dashboard in Tableau
• 8 Week SQL Challenge (Data with Danny) PostgreSQL with Docker: Utilised PostgreSQL to clean and analyze eight different data from banking and sales, to name a few. Implemented various SQL techniques including window functions and CTEs. Incomplete

• Real Estate Analytics for King County, WA: Housing Sales Dashboard Built an interactive dashboard with calendar widget as main filter and multiple visuals including a line chart, histograms, a map, and a heatmap. Compiled a report detailing insights of each visual component of dashboard.
• Online Commerce Cohort Dash Loaded data from Azure Data Studio to build dashboard that visualizes the time-series retention rates and dynamic percentage breakdowns of customer cohorts, enabling stakeholders to identify trends and patterns in customer retention, engagement, and churn.
• Global Covid Tracking Dashboard Integrated SQL server data into a dynamic dashboard featuring a diverse array of visualizations, including interactive line charts, histograms, and geographic maps, illustrating COVID-19 trends.

• Predicting Gender Self-Perception: An Analysis of American Masculinity Preprocessed national US masculinity survey dataset, including data loading, mapping, cleaning, and exploration. Employed predictive analytical methods such as regression analysis, random forest, and XGBoost as well as advanced machine learning techniques such as feature engineering, hyperparameter tuning to predict gender self-perception of respondents. Packages utilized include: pandas, matplotlib, sklearn, geopandas.

• British Columbia Labor Market Research Imported, cleaned, and merged CSV datasets on Canadian provincial labor market statistics. Visualized monthly employment changes across Canadian provinces, with a focus on sectors like accommodation, food services, and retail trade. Packages utilized include: tidyverse, dplyr, lubridate.

• Pending

• Tableau profile

• Serious SQL (Data with Danny by Danny Ma)

• Introduction to Python, Seneca College

• Excel Essentials for the Real World Certificate

• Tableau A-Z: Hands-On Tableau Training for Data Science Certificate

• Salesforce Administrator Course, Achēv

• Data Analytics Bootcamp, General Assembly
• Strategy & Operations Bootcamp, The Commons
• Strategic Finance Bootcamp, The Commons

• Microcredential, Data Science, Sheridan College, Toronto, Canada 🎓📊
• MSc, Political Science, Universitat Pompeu Fabra, Barcelona, Spain 🎓🌍
• BA, International Studies, Kalamazoo College, Kalamazoo, USA 🎓🌐

• LinkedIn social

From Humanitarian Impact to Data-Driven Insights: 🌍📊

My career journey began in the world of social impact, where I leveraged financial and accounting expertise to support diverse organizations across the Middle East, Latin America, and the Caribbean. This included working with:

• 🌱 Social impact investing organizations: Assisting them in analyzing investments that create positive social and environmental change.
• 🕊️ Human rights campaigning organizations: Utilizing data to amplify their voices and drive impactful advocacy. My work even contributed to documentary film projects, which won prestigious awards like the Oscars (The White Helmets) and BAFTA Awards (For Sama), highlighting the power of storytelling and data combined.

Transitioning to Data - Bridging the Gap: 🚀

Drawing on this diverse experience, I transitioned to the world of data. My proven ability to optimize business initiatives:

• 🔍 Blends technical skill with business acumen: I'm proficient in Excel, SQL, Python, and R, alongside a strong understanding of UX/UI design principles and mastery of Tableau.
• 🤝 Bridges the gap between stakeholders: I effectively communicate insights to diverse audiences, empowering business leaders to make data-driven decisions.
• 🌟 Fosters collaboration: My collaborative nature, proactive approach, and high emotional intelligence enable me to seamlessly integrate into dynamic teams.

Impactful Results - Driving Growth and Sustainability: 💼✨

My passion for utilizing data for good has yielded tangible results. Through dynamic financial and data analysis, I've:

• 💰 Designed business initiatives raising over USD$120 million for 300+ tech startups and nonprofits.
• 👥 Contributed to the creation of 5,000+ jobs and positively impacted over 19 million lives across multiple regions.