Candor IT Lab Sep **** – Oct ****

Data Analyst

Project: - Data Quality Management

Objectives of the project was to analyze a data storage process . It has gone through various checks and catch a data efficiency and shows it by using KPI and charts. In a result to find almost 1% of data deficiency and successfully tried to maintain at avg 0.05%. Tools: - Power BI, Tableau, PsSQL server, DBeaver, Excel Project: - Inventory management

This study was belonged to sales & demand planning. Objectives of the project is to be gap analyze between in-stock and sales inventory. Creates a seasonal analysis, line trends, find out over stoking and out of stock conditions. Use a geographic and product wise granularity. In a result saving company revenue around 8% and cost cutting in various products.

Tools: - Tableau, MySQL server, Excel

Project: - Banking Loan/Lending Analysis

Analyzing loan amount given by bank to its customers over the country on various types of segments and collected in day of outstanding. Monitor bad loans and risk management analysis, mortgage amount, loan amount, outstanding days. In a result decreasing a risk and increasing no. of clients.

Tools: - Tableau, MySQL server, Excel

Project: - Sales Analysis of Children toys and products Design VBA interface for data entry & analysis of sales of Children toys and its related products. KPI shown for daily, weekly, monthly and yearly sales report. Experienced with creating a multiple dashboard by using different types of charts & strong hands on with VLOOKUP, HLOOKUP and data sorting and filtering.

Tools: - Advance Excel, VBA Macro.

Sep 2017

Oct 2020

Nov 2020

TATA Technologies(Advent Biztech Solution Pvt. Ltd.) Nov 2020 – Nov 2021 Data Analyst

Project: - Vehicle Condition Tracking

The study was belonged to analyze condition of stock and monthly inspection. Provide various KPI to show performance of dealers. Give a future date predication to do a maintenance in time. In a result doing an inspection on time and performance increased to 100%.

Tools: - Tableau, Oracle server, Excel

Project: - Offtake sales

Objectives to shows and understand a sale of spare parts. Created YTD, MTD and LMTD KPI. Provide trend line to understand trend of sales compared with last financial year. In a result increase in sales.

Tools: - Tableau, Oracle server, Excel

Project: - Back Order

The study was belonging to understand back order of spare parts. Provide bucketing of parts. Find out higher back rate of parts and dealer. In a result back-order rate is maintained at 30%.

Tools: - Tableau, Oracle server, Excel

Project: - Sales Detailed Report

Objective is to represent a very fine and granulated data of sales. Showing 70 columns data in a report.

Tools: - OBIEE, Oracle server, Excel

Project: - Real Time Dashboard

Handling a maintenance of mobile version dashboard. Tools: - Tableau

Till Date

Rows Work Experience Month(Year)

Prasad Kiran Kanse

Data Analyst

(Tableau Developer)

adp2wi@r.postjobfree.com

+91-959*******

/in/prasad-kanse-09041995

/app/profile/prasad.kanse

Data analyst with 4+ years of

experience in business dashboard

development, data visualization, data

interpretation, data warehousing.

Identify a requirement and problems of

client, find a loophole in data and deliver

an optimum solution by using BI tool.

Skills : -

Tableau

Power BI

OBIEE BI

SQL

Functional

Excel

Achievements : -

• Earned two badges on by Tableau

LLC

• Basic course on Scrum by Certiprof

https://www.credly.com/users/prasad-

kanse.a6c737df

Education Details : -

B.E in Automobile Engineering CGPA

Saraswati Coll. Of Engg, 6.75

Kharghar 2014 - 2017

Mumbai University

Contact this candidate