Karim Darrag
Data Analyst
Striving to be the best me that I can be.

Education 

I am a Computer Science graduate from the Lassonde School of Engineering at York University (BSc). I was born in Cairo, Egypt, and I left to go to Canada while I was in elementary school. I stayed in Canada until middle school, where I went back to Egypt and stayed until the end of high school. Afterwards, I left to go back to Canada to study Computer Science at York University at the age of 18 and graduated at the age of 22.

Personal Life 

I am Karim Darrag. A passionate and motivated Data Analyst, Microsoft Certified: Power BI Data Analyst Associate, and Computer Science graduate. My professional work experience includes several data-related software programming projects as well as using industry leading BI tools to manage, analyze, and visualize data, draw conclusions, and apply data-driven decision making. My curiosity greatly fuels my passion to learn many different skills that I can apply to tackle new challenges and provide efficient solutions.

Goal 

To better the world as much as I can.

My skillset from my journey so far
Ranked from strongest to weakest

SQL
SQL (Excellent Proficiency)
Microsoft Power BI (Excellent Proficiency)
Microsoft Excel (Excellent Proficiency)
Google Data Studio (Excellent Proficiency)
Google Cloud Platform (Excellent Proficiency)
Google BigQuery (Excellent Proficiency)
Python (Excellent Proficiency)
Laravel (Working Proficiency)
PHP (Working Proficiency)
Jupyter Notebook (Working Proficiency)
React.js (Working Proficiency)
JavaScript
JavaScript (Working Proficiency)
Tableau (Working Proficiency)
SAS (Working Proficiency)
Microsoft Azure (Working Proficiency)
MongoDB (Working Proficiency)

Reliving my

Experiences

2020

York University - BSc. Computer Science


Graduated from York University with a Bachelor of Science in Computer Science.

Software Engineer Intern at Delve Health - 2021

Data Analysis
Utilizes: [SQL, Google Cloud Platform, Google Data Studio]


Developed 11 data dashboards using SQL, Google Data Studio, and the Google Cloud Platform for business operations and pharmaceutical clients. The data dashboards were utilized for conducting evaluations, identifying engagement issues, and finding areas that can be improved.

2021 - Software Engineer Intern at Delve Health

Programming
Utilizes: [Laravel Framework, PHP, JSON, MVC, SQL, Google Cloud Platform, Firebase]

Programming tasks in this role:
Built a notification system for involved personnel using the Laravel framework and SQL that would be applied after certain conditions were met. The involved personnel would be provided a form to fill out, and then the system would store the data from the form to be later reviewed for relevant insights.
Built a system that gathers data from provided JSON files stored in an SFTP server, parses the files into a relevant structure, and stores them in Firebase and the Google Cloud Storage using the Laravel framework, SQL, and the Google Cloud Platform.

Software Engineer Intern at Delve Health - 2021

Software Validation

Led the software validation team in the creation and execution of test scripts and review of a system requirements specification document and a system validation plan.

2022 - Ongoing

YouTube Content Creator

Achieved over 200,000 total views for my videos on my YouTube channel.

2022

Microsoft Certified: Power BI Data Analyst Associate Certificate
Links: Certification Details

Achieved the Microsoft Certified: Power BI Data Analyst Associate Certificate on September 8, 2022.
Certification Number: I406-1043

Projects

Nov. 2022
Machine Learning Data Analysis using Python to predict House prices

Performed data wrangling, exploratory data analysis, model development, including simple and multiple linear regression models, and model evaluation and refinement, including polynomial transformations and evaluation of R-squared values, to analyze and predict housing prices using attributes including square footage, number of bedrooms, and other attributes included in an imported dataset for house sales in King County, USA between May 2014, and May 2015. Utilizes the Pandas, NumPy, sci-kit-learn, Matplotlib and seaborn Python libraries, as well as Jupyter Notebook.

Nov. 2022
Hotel Bookings Data Dashboard using SQL and Microsoft Power BI

Utilized Microsoft SQL Server Management Studio along with SQL and Microsoft Power BI to analyze and visualize over 100 thousand rows of hotel booking data in Microsoft Power BI in order to create a data dashboard that answers common stakeholder questions relating to revenue growth and trends in data.

Feb. 2022 | Github repository link
Social Media Website using the MERN stack

Using the MERN stack, which includes MongoDB, Express.js, React.js, and Node.js, along with Google OAuth and JSON web tokens for authentication, this project allows users to register, then login either through the website or through Google to create memories that show instantly with a name, title, message, picture, and tags, and have the option to like the memories that they and others post as well.

green iguana
Sep. 2021 - Oct. 2021| Github repository link
Pokémon Battle Simulator Browser Game using Laravel

Developed a locally hosted video game battle simulator based on the popular Pokémon series using Laravel. It is a browser-based game tested with a preset of characters from Pokémon that can battle each other and level up. This project utilized the PHP framework, Laravel, as well as HTML, CSS, and SQLite.