RISHAV KUMAR

ACADEMIC PROFILE

Degree/Certificate Institution Percentage/CGPA Year

B-Tech Mining Engineering IIT (BHU), Varanasi 8.59 2022 Sem I Sem II Sem III Sem IV Sem V Sem VI Sem VII Sem VIII 7.98 8.60 8.93 8.82 - - - -

CBSE (XII) LB SHASTRI S S SCH SEC - 3 RK PURAM NEW DELHI 93.40 2018 ICSE (X) SAINT JOSEPH'S SCHOOL, JAMUI 92.80 2016

SKILLS

Languages - SQL, Python(Basics)

Software and Tools - MySQL, Tableau, Matplotlib, MS Excel Interests - Business Analysis, Data Analysis, Business Development PROJECTS

An Overview of Analytical Models for Campaign Management April 2020 - May 2020 Position: Research Intern at IIM Ranchi

Project Report

Studied about the shape of the advertising response function. Synergy created in advertising campaigns.

Building customer response models and optimizing contact strategy. Advertisement Effectiveness Measurement

Coursera Guided Projects July 2020

Applied fundamental to advanced SQL commands to analyze the data Retrieving data using single and multiple table queries - used fundamental SQL commands like select, order by, where, and joins for exploring data. Advanced SQL Retrieval Queries - used complex SQL queries like subqueries, aggregate functions, date and time functions, windows, and string functions to solve advanced tasks. CERTIFIED COURSES

The Business Intelligence Analyst Course 2020 by Udemy 20.5 hours Learned how to use complex SQL queries with Tableau, for better understanding of data. SQL for Business Analysts by DataCamp - 20 hours

Learned how to quickly analyze data and excel in real-world business challenges with various functions. POSITION OF RESPONSIBILITY

Co-coordinator at Kashiyatra 2019, IIT (BHU) Nov 18 - Jan 19 Annual Socio-Cultural festival of IIT (BHU)

Worked as Co-coordinator in the Logistics Management team. Managed efficiently, the forward and reverse flow and storage of goods. Successfully managed the distribution of goods and money collection, for around 850 people. Marketing Executive at Minfest' 20, IIT(BHU) Feb 2020 - July 2020 The flagship event of Dept. of Mining Engineering

Worked in a team where we had to collect contacts of mining companies. Successfully managed to brief the concerned companies about the events under Minfest. Managed to bring Mining Giants such as WCL, MCL, etc. as our premium Sponsors. EXTRA-CURRICULAR ACTIVITIES

Participated and organized badminton tournament in Spardha' 19, the annual sports event of IIT(BHU).

In Aagman 2019, mentored a team for an art competition organized by Fine Arts Club IIT (BHU). Qualified for on-campus finals for Prod O Mania, organized by Technex, the annual techno- management fest of IIT (BHU).

Our team secured 2nd rank in Aquadrive'18, where we had to fabricate our boat and to propel it using any energy source of our choice.

Secured 5-star rating in HackerRank SQL problems challenge. Achieved Gold Level Certificate in 2019 WorldQuant challenge. T: 766-***-**** E: adfj3x@r.postjobfree.com Address: ward no - 24, khaira road bodhwan talab, jamui, bihar - 811307