Name: Kalpesh Patil
Mobile: +91-902*******
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:***********@*****.***
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: