Data Analyst

Prajesh Kathane

Philadelphia, PA ***********@*****.***

LinkedIn +1 (267) 881 – 8249

PROFILE

Dynamic and motivated professional pursuing a Master’s in Business Intelligence and Analytics at Saint Joseph’s University. Armed with experience as a Business Analyst at WebCraft IT while pursuing a Bachelor of Commerce (Hons.) degree resulted in an enhanced view towards improvement, efficiency, and data. Seeking opportunities to apply and enhance all my skills to carve them with perfection in a professional atmosphere of data science.

EDUCATION

Saint Joseph’s University Philadelphia, PA

Master of Science in Business Intelligence and Analytics GPA 3.58 May 2021

International Institute of Professional Studies D.A.V.V. Indore, M.P. India

Bachelor of Commerce (Hons.) GPA 7.02/10 July 2019

SKILLS

Programming Languages: Python (Artificial Intelligence & Machine Learning), R, SQL, VBA.

Visualization Tools: Tableau, Power BI, Data Studio, Qlik, PowerPoint

Analytical Tools: MS Excel, JMP, SAS Enterprise Miner, Google Analytics.

PROFESSIONAL EXPERIENCE

Business Analyst June 2018 – June 2019

Webcraft IT Indore, India

Worked on SQL to improve data base of the company and system to collect the data of clients and of the service provided. Which resulted increase in the insightful database by 30% in a year.

Used the clients' database to finalize the priorities of the company and worked on the forecast of the company's short term and long-term goals. Achieved 90% of the short-term goals by increasing client base to 27% by our team.

Used Excel and JMP for analysis and Tableau/Power BI and SQL for data visualizations for reporting.

Kept track of implementations of the changes and presented the analysis to the Upper Management and Founder.

Virtual Internship December 2020 - January 2021

KPMG Data Analytics Consulting U.S.A

Cleaned data using Excel and JMP to provide insights and suggestions on missing data. And later imputed the missing data using JMP. Click here to visit dashboard.

Connected additional data of Census of Australia to get a better understand of data and to provide suggestions on marketing. Click here to visit Census dashboard.

Created Visualization which showed the trend and forecast to create a report on suggestions for increasing profits and sales. Click here to visit forecast dashboard.

In addition to that provided consultation on which data should be collected in future for creating more insightful visualizations.

CERTIFICATIONS

Data Analytics Consulting Virtual Microsoft Excel Microsoft Access

KPMG Udemy Udemy

January 2021 September 2020 September 2020

SQL Essential Training MSBIA Statistics Proficiency IBM Data Scientist

LinkedIn ALEKS Coursera

January 2021 February 2020 September 2020

ACADEMIC PROJECTS

Data Mining: (JMP)

Analyzed on how to improve hospital’s management using variables like beds, rooms, Number of Doctors, and location.

Forecasted crimes of Boston area using data of Boston police department.

Calculated the causes of Hypertension through the data.

Data Visualization: (Tableau and Qlik)

Created dashboard on tableau and Qlik using data on Indian Politicians and their education level to understand the average education level of a politician and the most studied subject.

Cleaned data using Excel and later created Dashboard using Tableau and Qlik which resulted in understanding meaningful insights such as which platform the gaming companies should focus more on, which genre is most popular among different age groups. Also, which genre has growing potential.

Python: (TensorFlow, Pandas, NumPy, and Matplotlib)

-Used different libraries such as pandas, Matplotlib, NumPy, Seaborn and Sci- kit learn for data analysis and visualization.

-Used Natural language Processing for extracting nonnumeric data from website.

-Used Data mining and deep learning to analyze data from CSV files.

Predictive Analysis: (SAS Enterprise Miner)

-Prepared data for Data mining. Imported data in SAS.

-Analyzed using decision tree, normal and stepwise regression, Auto Neural and Neural Network modeling.

-Predicted profit of Avocados as per the variables of data using variables such as: Type of Avocados and bag size, total volume, Past Profit and Sales.

DBMS: (Oracle SQL)

-Worked on Oracle to create and manipulate tables to retrieve data.

-Created a DBMS for McDonald's store.

Web Analytics: (Google analytics Website building)

-Prepared a website about intercontinental food, marketed it and analysed the traffic using Google Analytics and Google Tag Manager.

-Prepared a dashboard using Google Data Studio which helped us understand user’s behaviour and interests such as Asian food, European food, and Mexican food.

Contact this candidate