Kalkidan Alemayehu.

Transforming analyzed data into visually comprehensible information.

Thank you for visiting.

I am an enthusiastic data analyst with a passion for understanding data trends and creating interactive visuals using different technologies.

HTML

Excel & VBA

JavaScript

Python

Git

More about Me

Resilient and driven data analyst with experience in Excel, VBA, Python, Jupyter Notebook, APIs, SQL, Flask, and Web Scraping with HTML/CSS. I started out my career development in the social sciences and during my four-year university education, I evolved into a person who is passionate for analyzing all types of data to understand and apply the trends to real-life problems. I am currently completing two certificate programs in policy analysis and data analysis respectively; to further my knowledge and my analytical skills.

Technologies I use:

HTML5, CSS3, Git, Bootstrap, JavaScript Python, Pandas, Anaconda, VS Code, Excel, VBA

Recent Projects

These are just a few of the projects that have helped me enhance my analytical skills.

UFOS

In this project I learned how to create filters on websites with data using javascript. I redesigned the website I built into a more user friendly and flexible website.

Code Overview

Mission to Mars

Using a specific method of gathering the latest data: web scraping, data was pulled from multiple websites, stored in a database, then presented the collected data in a central location: a webpage.

Code Overview

Surfs Up

This project focuses on finding a few key aspects of Oahu’s seasonal weather data. Because the weather can be variable in the summer and winter. The investors want to ensure that there are enough customers between seasons to sustain the business throughout the year.

Code Overview

Pewlett Hackard Analysis

In this project I organize a company’s database department by using tools such as PostgreSQL and pgAdmin. I use Postgres to create a database, and pgAdmin to work with the data I will be importing.

Code Overview

PyBer Analysis

This assignment is focused on creating visualizations of rideshare data for PyBer (a rideshare company) to help improve access to ride-sharing services and determine affordability for underserved neighborhoods. I used the Python graphing library Matplotlib, which is a favorite tool among data scientists and data analysts because of its robust visualization features to create a visual representation of the analysis.

Code Overview

VBA of Wall Street

Instead of using excel to perform data analysis of stocks by applying the calculations manually and using Excel formulas for calculations, I use Visual Basic for Applications, which is typically referred to as "VBA,". With VBA we can write code that will automate these analyses for us. Often used in the finance industry, VBA provides essentially infinite extensibility to Excel. Using code to automate tasks decreases the chance of errors and reduces the time needed to run analyses, especially if they need to be done repeatedly.

Code Overview

Education

University of Toronto Continuing Studies

Data Analysis and Visualization | Feb 2020 - Jul 2020

Bootcamp designed to teach data analysis and visualization utilizing real-life data and scenarios. This program allows for career development and enhancing our skills related to technologies.


York University

Policy Analysis Professional Certficate | Jan 2020 - May 2021

This program focuses on writing skills and drawing analytical conclusions to develop better policy and law. I was honoured to have participated in an analytical and descriptive research for the United Nations High Commisioner for Refugees highliting Canada's participation in aiding refugees in the span of 70 years. I have prepared a legal memorandum and a factum related to current news and policies being developed in regards to change in our societies.


University of Toronto Scarborough

Honours Bachelor of Sciences | Sep 2015 - Aug 2019

Throughout my 4 and a half years at UTSC I have developed many skills and learned valuable lessons that have helped me grow intellectually. I understand team player skills are essential for applying my knowledge in the "real-world". I have participated in my student union, in student associations, clubs and extra-curricular classes. This is where I found myself and what my goals look much more clearer.

I'm available for work.

Actively contributing to new projects and seeking a full-time role in a fast-paced, agile environment. Get in touch!

Contact Me