Mohit Shukla Data Analytics | Business Intelligence

About · Work Experience . Projects . Resume
Avatar

I am a December 2020 Graduate student at Rutgers University pursuing a Master's degree in Information Technology & Analytics. My Commendable Skills are in R, Python, SQL, Excel, Tableau, Statistics and Data Analytics. My passion for Data Analytics has given me a boost to complete two internships in a Data Science related field and passionately work on almost 6 projects where I used various Softwares and enhance my analytics skills.

I am looking for a perfect Full time opportunity to use my technical knowledge in real world data which will directly affect the companies performance, which will be very motivating for me to work on and achieve my professional goals.

Analyzing

Statistical analysis & the know-how of leveraging power of computing frameworks to mine-process and present the value out of unstructured bulk of data is the most important technical skill I have acquired for my passion to become a data scientist.

Developing

Development is important in Data Science, I have completed my internship as a Data Analyst Intern this summer. I strongly believe that Development , Stats and Analysis are three main pillars of Data Science.

Communicating

Whats the use of analyzing millions of rows of data if one can't visualize it. Tableau and Power BI are the best tools to tell a story from any given data. I'm also able to present complex results to a non-technical audience.

Work Experience

Data Analyst Associate I | Johnson & Johnson (ThreeBridge Solutions) | Raritan, NJ | March 2021 - Present

Built Strategic data and reporting capabilities for J&J’s global Technology Services organization, including Tableau dashboards and datasets in Cloudera Data Lake environment. Developed dashboards for IT operations reporting, strategic supplier management, technology lifecycle, Scrum & Agile processes, finance, project management and other key domain areas across the organization. Utilized Agile development methods and Design Thinking principles to prioritize work, obtain requirements and build dashboards and reports. Drove increase in users from approximately 300 regular users to over 1200 by following a product-focused approach to team’s data assets

Graduate Teaching Assistant | Rutgers University | New Brunswick, NJ | September 2020 - December 2020

Advocated in creating Tableau Dashboard used for university Enrollment, Retention and Graduation (ERG) Analysis. Extracted, transformed, and loaded data on more than 6,500 students enrolled in Rutgers education programs. Employed MS Excel for maintaining, analyzing student’s information and summarized each semester results

Data Analyst Intern | TWG Companies | Newark, NJ | May 2020 - August 2020

Streamlined daily sales data of the company; managed daily, weekly, monthly data analysis statement and data process monitoring. Delegated and maintained database of 3GB at a fixed period and analyzed existing client data to supply the foundation for marketing decision. Monitored and pre-processed 10 years of client data using SQL and utilized regression models to analyze factors. Integrated trend analysis and graphic representation of each product using 5 + Tableau dashboards

Projects

movie

Movie Industry Visualization | Tableau

Will Animated (CGI) based movies ever replace reality movies? Visualized data of past 30 years of movies on Tableau, performed EDA, built 5 dashboards Predicted if Animation genre movies will be dominating real-life films in 15 years

Check it out

tmobile

Network Carrier: T-Mobile Expenses | Python, Visual Studio Code

  • Constructed a python application to calculate the monthly expenses of mobile carrier service
  • Integrated Gmail API service to send an automated email to users reducing the overall manual work to 80%
  • Build Up several cases using Pytest module, Integrated Venmo API to send transaction requests to 10+ users

    • Check it out

    microsoft

    Microsoft Stock Price Prediction | R, RStudio

    Predict Stock price of Microsoft.

  • Performed data scraping & envisioned the trends, stationarity parameters with ACF, PACF of 7 years stock price of Microsoft
  • Implemented ARIMA, SES, Holt’s Winter’s method. SES model fits data set correctly because of its 1.09 RMSE score

    • Check it out

    youtube

    YouTube Trending Video Data Analysis | Python, AWS

    What makes a Youtube video go on its trending page? Are there any specific parameters such as upload day, time or anything else which would help the video go trending? Lets find out:

  • Performed data scraping & envisioned the trends, stationarity parameters with ACF, PACF of 7 years stock price of Microsoft
  • Implemented ARIMA, SES, Holt’s Winter’s method. SES model fits data set correctly because of its 1.09 RMSE score

    • Check it out

    nobel

    Visual History of Nobel prize winners | Python

    The Nobel Prize is perhaps the world's most well known scientific award. Let's visualize the data of nobel prize winners of past 100 years. I have used the following:

  • Data Manipulation with pandas
  • Intermediate Data Visualization with Seaborn
  • The dataset used in this project is from The Nobel Foundation on Kaggle

    • Check it out

    tvshow

    TV, Halftime Shows, and the Big Game | SQL

    After exploring a Dataset containing game info and cleaning our data a little, we're going to answer questions like:

  • What are the most extreme game outcomes?
  • How does the game affect television viewership?
  • How have viewership, TV ratings, and ad cost evolved over time?
  • Who are the most prolific musicians in terms of halftime show performances?

    • Check it out