Candidates About

 

Dipti Kandkurte

                                                                                                                                                        

 

Career Snapshot

 

·          Total 8+ years of experience in IT.

·          5+ years of experience in QlikView Dashboard Development involving UI design, Qlik scripting and Data Modelling.

·          3 years of experience in QlikSense Development.

·          Good experience in Healthcare and Pharma and investment banking domain.

·          Good experience in using claims data from FACETS.

·          Well Versed with QlikView/QlikSense reporting using NPrinting.

·          Complete life cycle development experience including Requirements gathering, Planning, Analysis, Design, Implementation and Maintenance using QlikView/QlikSense.

·          Proficient in creating QV data models, QV objects, custom reports and data visualizations using different data sources like SQL Server, QVD files using incremental load, Access, text files, excel documents etc. as per the user requirement.

·          Proficient in QlikView ETL, Document chaining, Actions, Triggers using QlikView/QlikSense.

·          Proficient in Set Analysis using complex expression, Section Access.

·          Experience using different dimensional data models (Star, Snowflake, Data islands) based on need.

·          Used Dimensions tables and Fact tables in data modelling.

·          Knowledge of Extension Objects.

·          Experience working with large data sets.

·          Good experience in Web Integration.

·          Experience on creating mashups using multiple applications.

·          Expertise in SQL queries, OLAP Cubes and data marts.

·          Experience of using QlikView and QlikSense Publisher.

·          Successfully worked on multiple projects simultaneously single handed.

·          Experience in working directly with business users.

 

Technical Skills:

 

BI Tool	QlikView 9/10/11,  QlikSense 2.1/3.2, N Printing 16.2.0.0 SR2
Database	SQL Server 2005/2008/2012, Netezza, SAS, OLAP Cubes
OS	Windows XP, Windows 7, Windows Server 2008/2012
Programming Language	C,C++
Defect Tracking Tool	Quality Center, Mantis 1.1.8
Test Case Management Tool	Test link 1.8.5, Quality Center

Professional Experience

 

 

Project: Flexi pool Reports

      Environment: QlikSense 3.2, SQL, Spreadsheets

      Description: This project is to convert the existing reports created for Flexi-van management into QlikSense

                           Dashboards. Created mashups using objects from few report/Application.

                           Some of the KPI’s these dashboards shows are:

·          Activities of the chassis.

·          Equipment details, Inventory details

·          overdue, Summary

·          In Gate, out gate Activities

·          Invoicing details

·          Management Overview

 

 

 

Role and Responsibility:

·          Gather the requirement from the user.

·          Fetched the data from different sources.

·          Got detail understanding of existing reports.

·          Created a data model.

·          Designed the dashboard using extensions.

·          Published the application.

·          Trained business users on how to use the QlikSense dashboard.

 

Project: Mega pool Reports

       Environment: QlikSense 3.2, QlikView, SQL, Spreadsheets

       Description:  This project is to convert existing QlikView reports into QlikSense dashboards.

                             Some of the KPI’s these dashboards shows are:

·          Pool Spending by Week

·          Pool Spending By Vendor

·          Daily Pool Inventory

·          Monthly Pool Invoices   

 Role and Responsibility:

·          Gather the requirement from the user.

·          Fetched the data from different sources.

·          Got detail understanding of existing reports.

·          Created a data model.

·          Designed the dashboard using extensions.

·          Published the application.

·          Trained business users on how to use the QlikSense dashboard.

 
 Project: Pipeline Report

Environment: QlikSense 3.1, Salesforce

Description: This dashboard is created to meet the business need to gain insight into the Salesforce data. Converted existing Salesforce report into QlikSense report. Mashup creation using objects from some applications.

Some key features of the tool:

·         Provides insights into target meetings and Actual meetings happened.  

·         Enable Comparative Analysis for above metrics.

·         Provides insights into target calls and Actual calls happened.  

·         Enable Comparative Analysis for above metrics.

·         KPIs showing Meeting related data.

 

Role and Responsibility:

·          Gather business requirements from users directly.

·          Fetched data from different sources including excels, Salesforce.

·          Worked on this project from scratch single handed.

·          Worked on Requirement analysis, Data analysis, Data modelling, Scripting, UI Design, Performance tuning.

·          Trained business users on how to use the QlikSense dashboard.

 

 

      Project: Usage Dashboard

Environment: QlikView 11.2, SQL Server 2008, Server logs

Description: This dashboard was created to show the usage of QlikView platform as well as “Sales book” .NET application. Sales book is the flagship application of Fixed Income division, which is used extensively by sales and trading team. Some of the KPIs this dashboard shows are:

·          Top QlikView user list

·          Top QlikView dashboards being used

·          Session and Audit history

·          Trades booked from Sales book vs other trading systems.

·          Trades by salespeople over period

·          Trend analysis on both QlikView and Sales book usage.

 

Role and Responsibility:

·          Gather business requirements.

·          Performed data modelling

·          Developed QlikView application based on incremental Load strategy using QVD files.

·          Trained business users on how to use the QlikView dashboard.

·          Created dashboard style of layouts using different sheet objects like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.

 

Project: Time Tracking Dashboard

Environment: QlikView, SQL Server

Description: This dashboard is created to enable management to track the time spent by IT on different projects. Some features:

·          Distribution of actual work by Task Type, Project name etc

·          Trend analysis of efforts by Task Type, Project name etc

·          Drill down on efforts by a specific project, Resource etc

 

Role and Responsibility:

·          Gather business requirements.

·          Consolidated data into QlikView from time tracking database.

·          Trained business users on how to use the QlikView dashboard.

·          Created dashboard style of layouts using different sheet objects.

 

 

 

 
 Project: SPARTA (Strategic Pharmacy Advisor, Reporting & Trending Application)

Environment: QlikView 11.2, SQL Server 2012, Netezza, SAS 9.3, MS Excel, NPrinting

Description: This dashboard is created to meet the business need to gain insight into the Pharmacy claims data. It serves as an analytical tool, which combines data from multiple data sources. Some key features of the tool:

·         Provides insights into various KPIs set by the business around Utilization, Drug Spend, Amount Paid, Pricing Performance, Day’s Supply, Specialty Drug, Specialty Pharmacy etc.

·         Enable Comparative Analysis for above metrics

·         Reads claims data from FACETS System (FACETS allows providers to comprehensively meet their business requirements across claims processing, network management, customer service etc.) deployed in Healthfirst.

·         Show top drug and class trends.

·         Daily Paid and Reject Counts with ability to drill down into reject details.

·         Special tabs around Chronic and Behavioural diseases.

·         Automated reports using NPrinting.

 

Role and Responsibility:

·          Gather business requirements from users directly.

·          Fetched data from different sources including excels, data warehouse.

·          Worked on this project from scratch single handed.

·          Worked on Requirement analysis, Data analysis, Data modelling, Scripting, UI Design, Performance tuning.

·          Trained business users on how to use the QlikView dashboard.

 

Project: Enrollment Dashboard

Environment: QlikView 11.2, SAS 9.3, MS Excel

Description: This dashboard is created for the Enrollment team within Health first. Some key features of the tool:

·          It enables the users to analyse timelines required for the different phases of effectuation life cycle which enables them take decision to improve their process such that the cycle finishes in quicker manner.

·          Provides bucket analysis around effectuation timelines

·          Shows trend of effectuations done within 15 days

·          Automated the excel reports users used to create manually every month by spending 12 hrs per month.

 

Role and Responsibility:

·          Gather business requirements from users directly.

·          Worked on this project from scratch single handed.

·          Worked on Requirement analysis, Data analysis, Data modelling, Scripting, UI Design, Performance tuning.

·          Trained business users on how to use the QlikView dashboard.        

 

Project: Release Management Dashboard

Environment: QlikView, SQL Server

Description: This dashboard is built around the project release data. It gives users the ability to analyse the releases of different projects in order to do better planning and utilize the development and QA teams efficiently. This dashboard shows breakdown of releases by different projects, Utilization of operations team who does PROD releases, Completed vs Rolled back releases, Approval analysis.

 

Role and Responsibility:

•     Gather business requirements.

•     Consolidated data into QlikView from QC database.

•     Trained business users on how to use the QlikView dashboard.

•     Created dashboard style of layouts using different sheet objects.

 

Project: Competitive Analysis Dashboard

Environment: QlikSense 2.1 SAS 9.3, MS Excel

Description: This dashboard is created to allow the management to react to the changing competitive environment. Some key features:

·          Enables management to compare Healthfirst performance against the competitors in the markets Healthfirst deals in.

·          Compare Healthfirst to the other plans using following metrics:

o    Enrollment

o    MoM and YTD growth

o    Market share

o    Membership Rank

·          Enable Comparative analysis for above metrics

Role and Responsibility:

·          Gather business requirements from users directly.

·          Worked on this project from scratch single handed.

·          Pulled data from data warehouse.

·          Worked on Requirement analysis, Data analysis, Data modelling, Scripting, UI Design, Performance tuning.

·          Trained business users on how to use the QlikView dashboard.

 

 

 

Project: Enterprise Manager Suit
Environment: Mantis, Test Link and SQL.

Description: Enterprise Manager Suit (EMS) is an application which manages the inventory of the SME (small and Medium) Enterprise which mainly are manufacturing companies. Often Inventory Managers or site technicians in the SME manage equipment lists through a variety of means, such as spread sheets, documents, drawing files etc.EMS is intended to replace all the ad-hoc methods with a system which is intended to give a clear picture of the entire inventory of the manufacturing organization.

 

Responsibilities:

·          Involved in Peer Review of the written Test Cases.

·          Participated in analyzing of Requirement Document, Design Document and Technical Specification document and getting clarification on the requirements if required.

·          Participated in preparing Test Scenarios, writing positive, negative and boundary value level test cases based on the given Requirement, Design Document, Technical Specification Document, Prototype or wireframes.

·          Performed Smoke Test on each new Environment/Build.

·          Involved in Execution of Regression Test C