Rahul_Iyer_Data_analyst
PROFILE
� Excellent programming skills using Python & JavaScript
� Extensive data management skills using MYSQL
� Excellent data cleaning skills using Python libraries such as Numpy and Pandas
� Excellent data visualization skills using Python libraries such as Matplotlib, Plotly and Seaborn
� Additional data visualization skills using Tableau, Power BI and D3.js
� Good statistical knowledge with excellent communication and analytical skills
EDUCATION
Master of Engineering � Mechanical (Robotics & Automation) December 2018
University of Windsor, Windsor, ON
Bachelor of Engineering � Mechanical June 2016
University of Mumbai, Mumbai, India
RELEVANT A PROJECTS
Customer Data Analysis for a Music Application April - May 2019
� Cleaned data containing over 100,000 rows and 38 features while maintaining the integrity of the dataset in pandas
� Applied statistical analysis techniques such as plotting box-plots and Histograms to identify the degree of data distribution as part of preliminary analysis using the Matplotlib library
� Visualized critical data using Tableau to identify important customer groups likely to opt for a yearly subscription
� Carried out customer segmentation to identify customer groups with the most reach for maximum marketing potential to future subscribers
� Applied the K-NN, SVM and Random Forest machine learning techniques on test data to correctly classify subscribers based on selected features with K-NN proving to be the most useful with an accuracy of 91%
Financial Statement Analysis of Sears Canada Inc. May 2019
� Diligently compiled relevant data from real company annual reports from 1997 to 2017 into one comprehensive MS Excel file
� Conducted extensive analysis of features that signified the company�s health such as Total Revenues, Diluted Earnings Per share, Assets & Liabilities and Operational, Investment and Financial cashflows
� Identified mistakes in capital allocation and senior management strategies that led to company bankruptcy using Tableau for data visualization
� Conducted analysis of strategies applied by competitor companies such as Walmart & Costco that drove Sears out of business
Visualization of Data Science Jobs across Canada May 2019
� Created an extensive job bank for data analyst and data engineer jobs that appeared on Linkedin from February to May 2019
� Visualized the acquired data by plotting job locations on a geo-spatial map using Tableau
� Successfully embedded the google maps into the data dashboard using Google API for real-time navigation to actual job locations
Visualization of FIFA 19 Dataset & Canadian Automobile Data April 2019
� Successfully cleaned datasets containing over 18,000 rows and 92 columns
� Successfully visualized data using Tableau for identifying the current best young players as compared to the five best players in world football
� Identified the most polluting cars and also the most fuel consuming vehicle classes of cars currently on the road in Canada
PROFILE
� Excellent programming skills using Python & JavaScript
� Extensive data management skills using MYSQL
� Excellent data cleaning skills using Python libraries such as Numpy and Pandas
� Excellent data visualization skills using Python libraries such as Matplotlib, Plotly and Seaborn
� Additional data visualization skills using Tableau, Power BI and D3.js
� Good statistical knowledge with excellent communication and analytical skills
EDUCATION
Master of Engineering � Mechanical (Robotics & Automation) December 2018
University of Windsor, Windsor, ON
Bachelor of Engineering � Mechanical June 2016
University of Mumbai, Mumbai, India
RELEVANT A PROJECTS
Customer Data Analysis for a Music Application April - May 2019
� Cleaned data containing over 100,000 rows and 38 features while maintaining the integrity of the dataset in pandas
� Applied statistical analysis techniques such as plotting box-plots and Histograms to identify the degree of data distribution as part of preliminary analysis using the Matplotlib library
� Visualized critical data using Tableau to identify important customer groups likely to opt for a yearly subscription
� Carried out customer segmentation to identify customer groups with the most reach for maximum marketing potential to future subscribers
� Applied the K-NN, SVM and Random Forest machine learning techniques on test data to correctly classify subscribers based on selected features with K-NN proving to be the most useful with an accuracy of 91%
Financial Statement Analysis of Sears Canada Inc. May 2019
� Diligently compiled relevant data from real company annual reports from 1997 to 2017 into one comprehensive MS Excel file
� Conducted extensive analysis of features that signified the company�s health such as Total Revenues, Diluted Earnings Per share, Assets & Liabilities and Operational, Investment and Financial cashflows
� Identified mistakes in capital allocation and senior management strategies that led to company bankruptcy using Tableau for data visualization
� Conducted analysis of strategies applied by competitor companies such as Walmart & Costco that drove Sears out of business
Visualization of Data Science Jobs across Canada May 2019
� Created an extensive job bank for data analyst and data engineer jobs that appeared on Linkedin from February to May 2019
� Visualized the acquired data by plotting job locations on a geo-spatial map using Tableau
� Successfully embedded the google maps into the data dashboard using Google API for real-time navigation to actual job locations
Visualization of FIFA 19 Dataset & Canadian Automobile Data April 2019
� Successfully cleaned datasets containing over 18,000 rows and 92 columns
� Successfully visualized data using Tableau for identifying the current best young players as compared to the five best players in world football
� Identified the most polluting cars and also the most fuel consuming vehicle classes of cars currently on the road in Canada