KANCHAN DENDGE
*************@*****.*** /777*******
https://public.tableau.com/profile/kanchan6317#!/
https://powerbi111672323.wordpress.com/
• Around 4+ years of experience with focus on BI and Analysis solution development.
• Certified Tableau Desktop Specialist.
• Experience in undertaking analysis tasks such as organizing and comparing the Data as per the business requirements, collecting user requirements and converting them into detailed functional requirements, writing data specifications or test cases if required.
• Experience in Data modelling and Database design.
• Good knowledge of BI Concepts. Knowledge of Tableau, QlikView, PowerBI, Qlik sense BI Tools.
• Sound knowledge of SQL Server and Expertise in generating report in different format (EXCEL, PDF)
• Possess keen interest towards BI reporting and Maintenance EXPERIENCE
OCT-2016 – Till Date
SR. SOFTWARE ENGINEER, XORIANT SOLUTIONS
TOOLS USED:
Tableau, Qlik Sense, QlikView, PowerBI
PROJECTS:
CLIENT: Marsh (6Months, Till Date)
Objective of the project was to create Cyber risks, Threat dashboards, Cyber Risk mitigation Strategies for the end users. The project was also about creating the interactive dashboard with all the advanced charts and user-friendly dashboards.
RESPONSIBILITIES:
• Developed Tableau visualizations and dashboards by exploring all the latest/Unique charts like the Radial Charts, the Dumbbell Chart, Scatter plots.
• Added advanced feature of zoom in of the dots in scatter plot via Tooltip to make it more interactive.
• Used toggles to navigate between the dashboard on the website.
• Used actions and Highlights to filter out the data or highlight the similar dimensions.
• Tested the same report with multiple Clients
• Developed Tableau workbooks from multiple data sources using Data Blending. CLIENT: Roche (2Years)
Objective of the project was to create dashboard over details of health kits shipped for sales and operation of a Medical based Company. Data Warehouse was created with Dimensions and Facts and on top of this, dashboards were built in Tableau.
RESPONSIBILITIES:
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Implemented the Write back functionality in the dashboards to make it more interative via Stored Procedures.
• Working with team of developers designed, developed, and implement a BI solution for Sales, Product and Customer KPIs.
• Have implemented Rolling 12 Logics in many of the reports.
• Created Data Queries in SQL Server Developer to make sure on what exactly the data should look like in the report.
• Main responsibilities consulting with business clients, creating Tableau dashboard reports, collaborating with developer teams
• Building, publishing customized interactive reports and dashboards
• Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
• Worked on periodic development/enhancement requests for Tableau Data sources, Workbooks, Dashboards & Extracts
• Built dashboards for measures with forecast, trend line and reference lines
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Generated context filters and data source filters while handling huge volume of data.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis
CLIENT: JBS (6 Months)
JBS is the largest meat producer in the world. There were three business use cases that JBS likes to implement, Meat Type Detection in the plant and Temperature monitor and alerting, scheduling. And Identifying the count of meat types in the box through image processing RESPONSIBILITIES:
• Interacted with Business Analyst, understand the requirements and developed reports and dashboard
• Developed dashboard and deploy into server.
• Monitoring the performance of the application in different scenarios.
• Created dashboards on Alerts, Failures, Thresholds with IOT and ML Team
• Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending. CLIENT: Griddable - Analytics (6 Months)
The NYC Taxi Data was Pre-processed and cleaned before using the dataset effectively for analysis using the ETL tool Talend. Dashboards were designed for the same using all the key KPIs for pickup/Drop up locations by taking time into consideration.
RESPONSIBILITIES:
• Developed dashboard and deploy into server.
• Involved in development and designing of the Dashboard
• Involved in pre-processing of the data.
• Scheduled the dashboards for every 10mins.
• Worked on Dashboard Navigations.
• Created actions, Filters, Context level Filters, extract level Filters, Drill up Drill Down Feature
• Interacted with Business Analyst, understand the requirements and developed reports and dashboard
CLIENT: Symantec (8 Months)
The project was to create the dashboards (Mobile dashboards) in PowerBI related to their finance, Bookings and Billings to C level executives.
RESPONSIBILITIES:
• Created Direct Queries.
• Monitoring the performance of the application in different scenarios.
• Worked on Mobile Dashboards and tried to overcome the limitations of the PowerBI Mobile
• Data modelling, designing and development of the report.
• Interacted with Business Analyst, understand the requirements and developed reports and dashboard
• Overcame the limitations of direct query.
ACHIEVEMENTS:
Certification: Tableau Desktop Specialist
Star Award: Jan -Jun 2020
Star Team Award: September2019 – March2020
Star Award: July-September 2018
Ninja Award: April – Jun 2017
EDUCATION
Bachelor of Engineering (Information technology), Pune University, Pune, 2016 TRAININGS
• QlikView Online Training
• Tableau Training
• Talend Training
• MSTR Online Training
• Python Training