Phone - +91-991*******

PremKumar Email -

Aspiring Data Analyst adzdbt@r.postjobfree.com

Location - Kalaburgi,Karnataka.

CAREER OBJECTIVE

Passionate about Data Analysis and equipped with advanced skills in Python, SQL, and

problem-solving, I am an enthusiastic Data Science Analyst. With a proven ability to build

strong interpersonal relationships and a highly adaptable personality, I am actively

seeking a rewarding position in the field of Data Analysis. My goal is to leverage my

expertise and contribute to the organization's success as a skilled and versatile Data

Analyst.

linkedin.com/in/premkumar-bilwar-08a60a16b

SOCIAL TECHNICAL SKILLS

Linked In - linkedin.com/in/premkumar- Python, MYSQL

bilwar-08a60a16b

CERTIFICATION AND TRAININGS

DataScience Bootcamp OdinSchool 6 Months

Fullstack Bootcamp jspider 3 Months

ACADEMICS

The National Institute of Engineering Mysuru.

Bachelor of Engineering(Mechanical) 66%.

2015 - 2018

PROJECT

Project on Python

Project-oriented SQL experience:

1. Designed and implemented an Entity-Relationship (ER) diagram or schema for a given

database.

2. Identified the 5 oldest users in the database to reward the user who has been

around the longest.

3. Developed a strategy to target inactive users in an email ad campaign by identifying

users who have never posted a photo.

4. Analyzed user data to determine the winner of a photo contest based on the number

of likes received.

5. Conducted analysis to calculate the average number of posts per user, providing

insights for investors.

6. Assisted a brand in selecting the most effective hashtag for a post by identifying the

top 5 most used hashtags.

7. Detected potential bots by identifying users who have liked every single photo on

the site.

8. Implemented a query to identify users who created their Instagram ID in May and

selected the top 5 newest joinees from this group.

9. Utilized SQL queries to find users whose names start with "c," end with a number, and

have both posted and liked photos.

10. Generated a report showcasing the top 30 usernames of users who have posted

photos within the range of 3 to 5.

Project on Python

Project-oriented Python experience:

Q1: Developed a program using Python, Google Colab, or Jupyter Notebook to identify

common employees in two lists without using any built-in functions, as part of a bank

project.

Q2: Implemented a program that separates names entered as a common string and

converts them into a list. Additionally, added age information to each name, providing a

comprehensive solution for data management in a project scenario.

Q3: Created a program for a medical store project that calculates the total cost of

different medicines based on the quantity requested by a patient, along with the refund

amount. Utilized Python to handle the calculations and provide accurate results.

Q4: Designed a function that accepts a sentence as input and determines the number of

vowels present in it. This function can be applied to various sentences, making it a

versatile tool for analyzing vowel occurrences in a project setting.

Q5: Developed a website feature as per the election commission's requirements, using

Python. Implemented an eligibility check for voting, providing an appropriate response

based on the candidate's age. This project showcases web development skills and

adherence to eligibility criteria.

Q6: Created a program to find the cumulative sum of elements in a list and store them in

a separate list. This project demonstrates proficiency in working with lists and performing

mathematical calculations, providing a solution for data manipulation requirements.

Contact this candidate