Welcome to my portfolio! My portfolio guide is a summary of my projects. I have grouped my projects based on the predominant technical skill used.
| Project Link | Skills/Areas of Knowledge Used | Project Description |
|---|---|---|
| Pewlett Hackard Analysis | SQL, Data Modeling, PgAdmin | I analyzed employee retirements to assist with forecasting future vacancies using data modeling, SQL (postgreSQL) and pgAdmin. |
| Luna Ecommerce Platform Dashboard | DAX Queries, Data Visualization, Defining KPIs, SQL, Data Modeling, PgAdmin, ETL | I defined KPIs, created a dashboard and visualized data using Power BI & DAX queries to help executives decide which product categories to invest in, which ones to monitor, and which ones to divest from. |
| Project Link | Skills/Areas of Knowledge Used | Project Description | Libraries |
|---|---|---|---|
| Instabasket Analysis | Python, Excel, Tableau, Exploratory Data Analysis, Data Wrangling | My team and I selected the top 1000 products to create an aisle for Instabasket shoppers to improve efficiency, customer satisfaction and profits and provided recommendations for implementation. | matplotlib, scipy, numpy, pandas |
| Neural Network Charity Analysis | Python, Data Wrangling, Machine Learning (Deep Learning) | I developed a neural network model to predict which non-profits an organization should donate to. | pandas, tensorflow, scikit-learn |
| Amazon Vine Analysis | Python, Exploratory Data Analysis, ETL, AWS | I determined whether reviewers who are a part of Amazon's Vine program (i.e. being paid) are biased and writing more favourable reviews than unpaid reviewers. | PySpark |
| Credit Risk Analysis | Python, Data Wrangling, Machine Learning (Supervised) | I developed supervised machine learning models to predict credit risk. | numpy, pandas |
| Cryptocurrencies | Python, Data Wrangling, Machine Learning (Unsupervised) | I found and grouped similar cryptocurrencies that were being traded using clustering. | pandas, path, plotly, sklearn |
| Pyber Analysis | Python, Data Wrangling | I performed an exploratory analysis and visualized rideshare data to provide insights that could be used to help improve access to ridesharing services and determine affordability for underserved neighbourhoods. | matplotlib, pandas |
| Election Analysis | Python | I automated the generation of a report summarizing the results of a U.S. Congressional election using Python, ensuring accuracy and efficiency in certifying the election results. | csv, os |
| Project Link | Skills/Areas of Knowledge Used | Project Description |
|---|---|---|
| MechaCar Statistical Analysis | R, Statistical Analysis, Linear Regression, T-tests | I performed statistical analyses on the MechaCar prototype production data to gain insights on the production issues for the manufacturing team and created a linear regression model to predict miles per gallon. |
| Project Link | Skills/Areas of Knowledge Used | Project Description |
|---|---|---|
| Citi Bike Trips Analysis | Python, Tableau, Data Visualization, Data Wrangling | I visualized the Citi bike rides in NYC dataset to provide insights on the bikesharing business so that it could be used to help develop a business case for launching a similar venture elsewhere. |
| Luna Ecommerce Platform Dashboard | DAX Queries, Data Visualization, Defining KPIs, SQL, Data Modeling, ETL | I defined KPIs, created a dashboard and visualized data using Power BI & DAX queries to help executives decide which product categories to invest in, which ones to monitor, and which ones to divest from. |
| Project Link | Skills/Areas of Knowledge Used | Project Description |
|---|---|---|
| Lululemon Merchandising Job Simulation | Pivot Tables & Excel Functions e.g. IF, Merchandising, Financial Planning, Market Research | I completed a job simulation where I assisted the lululemon merchandising team in planning for inventory of lululemon's shorts capsule, which involved using Excel functions and creating pivot tables, summmarizing these findings to assist with inventory management and financial planning and analyzing the product-type business strategies of their competitors. |
| Project Link | Skills/Areas of Knowledge Used | Project Description |
|---|---|---|
| PRKR App | Business Analysis, Digital Marketing, Entrepreneurship | My team and I brainstormed startup ideas and developed a digital app solution aimed at streamlining the process of finding, reserving, and renting privately-owned parking spaces. We crafted a comprehensive digital marketing plan to promote the app, outlining strategies for online advertising, social media engagement & user acquisition, and we pitched the solution to industry mentors. |
| Juniper Analysis | Strategy & Operations Analysis, Tableau, SQL, Excel | Under the mentorship of an industry mentor working in BizOps, my team utilized strategic thinking and analytical skills to identify the issues with the performance of a delivery startup's new launch and identified key opportunities for expansion and revenue enhancement ($22k increase in revenue per month). |