Sriram Rangan

My Name is Sriram.

I am passionate about data analysis and software development. Welcome to my site!

My projects and resume can be found on this site. Feel free to check them out and contact me in regard to any of the content posted on this website, or full-time opportunities related to data.

Follow me on social media
hero

Projects

portfolio
Python

Weapons Analysis in The Legend of Zelda: Breath of the Wild

View Details
portfolio
R

Employee Attrition Exercise

View Details
portfolio
R

Cyclistic Bike Share Case Study

View Details
portfolio
SQL

COVID Data Exploration

View Details
portfolio
Python

Pokemon Correlation Project

View Details
portfolio
Python

Movie Correlation Project

View Details
portfolio
Python

Nashville Housing Data Cleaning Project

View Details
portfolio
SQL

Amazon Web Scraping Project

View Details
portfolio
Laravel, Tailwind.css, Alpine.js

Portfolio Website

View Details
portfolio
Unity Game Engine, Angular

Capstone Project: Virtual Lab Tour

View Details
portfolio
Tableau

Tableau Dashboards

View Details

Resume

Skills

Languages


SQL R PHP HTML CSS Python C++ Ruby

Frameworks and Libraries


Laravel Alpine.js Tailwind.css

Visualization Programs


Tableau Power Bi

AI and Machine Learning


Matplotlib Jupyter Notebook MATLAB

Office


MS Office MS Project

Hardware Programming and Other


Raspberry Pi Arduino MQTT Oracle VM (Ubuntu)

Certifications

Google Data Analytics Professional Certificate

Coursera

Bachelor of Technology - Automation Engineering Technology

McMaster University

Chemical Engineering Technology - Process Automation Advanced Diploma

Mohawk College

Business Management Certificate

Mohawk College

Fanuc CERT Level 1 Certificate

Mohawk College

Education

Google Data Analytics Professional Certificate

Coursera

Sep 2022


  • Learned key analytical skills and how to clean and organize data for analysis and complete analysis and calculations using spreadsheets, SQL, and R.
  • Visualized and presented data findings in dashboards and presentations with visualization platforms such as Tableau.
  • Capstone Project: Used R Studio to analyze ride patterns of 6 million users of a bike sharing company to model a new marketing strategy aimed at converting casual riders into annual members.

Bachelor of Technology (Co-op) - Automation Engineering Technology

McMaster University

Jun 2021


  • Technical background with controls and hardware automation such as electric sensors, motors and PID controllers as well as web development, OOP, data manipulation, and IoT.
  • Business background in quality assurance, operations management, and project management.
  • Capstone Project: Developed a virtual tour of the McMaster University Learning Factory using Unity game engine to showcase the use of virtual reality (VR) in a lab setting.

Professional Experience

Bed Allocator

Michael Garron Hospital

Oct 2023 - Present


  • Coordinate patient transfers, both living and deceased, across 15 hospital units comprising over 300 beds.
  • Interface with Clinical Operations Manager and Patient Flow Team streamline patient movement.
  • Oversee the transfer of deceased patients with sensitivity and attention to detail to funeral homes; ensuring process adheres to guidelines between hospital staff and funeral home courier.
  • Maintain communication with unit Charge Nurses and managers, demonstrating adaptability in managing staff needs and competing tasks.

Registration Clerk - Emergency Department

Michael Garron Hospital

Jan 2022 - Present


  • Process 100-150 patients daily by coordinating with Nurses, EMS, and Law Enforcement in a dynamic ER environment to oversee patient flow efficiently.
  • Effectively prioritize and manage multiple competing tasks while communicating with relevant staff and patients.
  • Conduct patient data collection, data cleaning, and produce charts with adherence to data ethics.

Lab Development Assistant - Machine Health and Remote Monitoring

McMaster University, Faculty of Engineering

Jun 2020 - Aug 2020


  • Edited and re-wrote instructions for 5 projects to be repurposed for a virtual environment at the onset of the COVID-19 pandemic.
  • Learned to integrate Raspberry Pi, Arduino, and MQTT for IoT applications from scratch within a 1-week period to develop 4 new lab projects demonstrating their applications; optimized project development process resulted in 40% cut in production time.
  • Documented newly developed projects into detail manuals to be reproduced by students in a virtual environment.
Follow me on Social Media