Name: Kalpesh Patil

Mobile: +91-902*******

+91-827*******

Professional Summary:

Professional Summary

·Very good knowledge in Business Intelligence concepts and process.

·Having work experience on Retail Domain.

·Experience in creating aggregates, hierarchies, charts,filters, quick filters, table calculations, trend lines calculated measures.

·Excellent knowledge in Data Warehouse concepts and multidimensional data.

Employment History :

Organization :Gut Lernen Technocraft Pvt, Ltd, Pune.

Designation :Software Engineer

Duration : Sept 2015 to till date.

Projects:

1. Retail Stores Reporting System

Role : Tableau Developer

Tools : Tableau Desktop, Tableau online/public

Overview of the Project:

Design, development and implementation of Super Stores Reporting System using BI Reporting and Analytics Tool using Tableau for Business Executive. We are analyze sale and profit data for particular state as well as city. Report generation as per yearly, quarterly, monthly, weekly sales and profit

As a Tableau Developer performed the following responsibilities:

·Understanding the KPIs and Requirements Documents.

·Working with Data Warehouse teams and understanding Sales Data Mart.

·Designing and Developing reports using Tableau.

·Testing and validating the generated reports in collaboration with Business Users.

·Restricted data for particular users using Row level security and User filters.

·Experience in creating aggregates, hierarchies, charts,filters, quick filters, table calculations, trend lines calculated measures.

Tools and Technologies Used: Tableau, SQL, Excel.

2. Project Name : Delivery Notes Application

Role : Tableau Developer

Tool : Tableau Desktop, Tableau online/public

Description:

Delivery Notes Dashboard is a project, which keeps track of operations process from placing of order to shipping of the that order to the proposed address to analyze efficiency of the Delivery Plants responsible for delivery of the product to the end customer . This is a real time solution, has functionality to integrate Events like Production lunch or one day event, provides capability to understand and manage demand-supply on special occasions.

This application is built to keep information up to the granularity of order and corresponding delivery and keeps track of different status of the order and corresponding deliveries up to the most granular level .

Responsibilities:

·Understand Requirement, Analyzing Systems and Source Databases.

·Designed, developed and implemented Tableau Business Intelligence reports.

·Experience in creating parameters, aggregates, sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, parameters and worked on complex data sets

·Representing data using the visualizations such using Charts.

·Use Trend Lines, Reference Lines and statistical techniques to describe the data.

·Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

·Responsible for dashboard design, look and feel and development.

Project 3:

Role: SQL Developer

Roles and Responsibilities

• Understanding the existing SQL logic written in database.

• Involved in coding utilizing various components like transformation, tasks etc.

Developed SQL s to create database objects like Tables, Views.

Educational Qualifications:

EDUCATION

INSTITUTION

UNIVERSITY

YEAR OF PASSING

MCA

NBN Sinhgad College

Pune University

2014

BCA

Metropolitan College

Pune University

2011

Personal Profile:

Name : Kalpesh Patil

Father's name : Yuvraj

D.O.B :11/10/1990

Nationality : Indian,

Languages : English, Hindi,Marathi

Declaration:

I hereby certify that all the information provided above is true to the best of my Knowledge.

Place:

Date:

Email:ac891k@r.postjobfree.com

Career Objective:

To join an organization that will recognize and utilize my skills fully and offer me a position requiring innovative and creative ideas, where continuous growth and learning are a way of life.

Responsibilities:

Responsibilities:

Contact this candidate