Rohan Mali

+1-815-***-**** adkdf2@r.postjobfree.com Greater Chicago Area, Illinois – 60115

LinkedIn: www.linkedin.com/in/rohanmali1/

EDUCATION:

MASTER OF SCIENCE, MANAGEMENT INFORMATION SYSTEMS, G.P.A: 3.8/4.0 Dec 2020 Northern Illinois University, DeKalb, Illinois, USA Specialization in Business Analytics: Big Data Analytics, Applied Statistics in Analytics, Social Media Analytics BACHELOR OF ENGINEERING, INFORMATION TECHNOLOGY, G.P.A: 3.6/4.0 May 2017 Savitribai Phule Pune University, Maharashtra, INDIA TECHNICAL SKILLS:

Certifications: AWS Certified Cloud Practitioner, R Programming Certified - IBM, Post COVID-19 Crisis Leadership Program (May-July 2020) - University of South Florida Programming Languages: SQL, R, Python

Databases: MySQL, MongoDB

Tools & IDE: Tableau, Power BI, MS Excel, SAP BW, SSAS, MS Visual Studio Packages: Tidyverse, Dplyr, ggplot2, NumPy, Pandas, Matplotlib Web Technologies and Frameworks: HTML, JavaScript, Apache Spark Methodologies: Agile, SDLC

AWS Skills: EC2, S3, ECS, EBS, SNS, VPC

WORK EXPERIENCE:

Data Analytics Consultant, The Shelby Group, Schaumburg, IL, USA Jan 2020-May 2020

• Worked with a team of Data Analyst Consultants assigned to Investigate and analyse Procurement Operations Team, with the final analysis and suggestions predicted to affect the future of $1.5 million annual budget of the team.

• Determined business objectives by producing project plan, business case, risk and contingency plans to perform analysis on data generated for 100K+ tickets.

• Performed data exploration by looking for distribution of key attributes, relationships between pairs or small number of attributes and also verified data quality. Also used data preparation techniques such as merging/Aggregation to clean and visualize data on Power BI dashboards.

• Recommended statistical Predictive Modelling such as Regression model, Monte Carlo simulation & Factor analysis to help determine future data results.

• Deployed final project in the form of a final project report with emphasis on pitfalls in current data recording practices, detailed suggestions on effective models for predicting future profits and costs of the procurement operations team. Graduate Teaching Assistant, Northern Illinois University, DeKalb, IL, USA Aug 2019-Dec 2020

• Promoted as a Lead Graduate Teaching Assistant to supervise a team of GA’s by providing Leadership on IT related queries to Faculty and Students in School of Nursing’s main IT Lab.

• Helped faculty in Data Collection, creating applications for ad-hoc data survey’s in Qualtrics, Doodle, Zotero.

• Tracked class and student metrics including exams, labs, reports, attendance for faculty.

• Proctored monthly Exams for 500+ students.

• Prepared materials for reports, presentations and submissions to peer reviewed journal publications. Process Executive, Infosys, Pune, INDIA Aug 2017-Sept 2018

• Worked on Relational Database Service to store, operate, scale and analyse data for British Multinational Telecom Client.

• Utilized company statistical software to track and analyse large size datasets.

• Examined and reconciled errors in client data to ensure accurate business requirements.

• Succeeded in interpreting MIS data from cross functional teams in order to draw conclusions for managerial action and strategy.

• Assisted with tier-2 support.

RELEVANT PROJECTS:

• Sentiment Analysis & Topic Modelling of Flight Reviews on Skytrax.com (Academic project 2020): Performed Data Analysis on a data set with 14k+ records consisting of reviews of customers about their flying experience. Performed Sentiment Analysis by calculating polarity scores and visualizing other attributes. Topic modelling was performed and 30+ dominating keywords were analysed from topics across the corpus. Used Tableau for creating data visualization dashboards.

• Social Media Analytics for Live Twitter Network Data (2019): Scrapped live twitter dataset for #HIAC (Hell in a cell) event by WWE using Twitter’s API keys. This was number one trending #tag on twitter that day. The dataset included 2k+ nodes. Derived inferences by finding modularity, Degree Centrality to recommend WWE to make maximum use of the #tag to increase ticket sales revenue.

Contact this candidate