Sachin

Qlikview & Qliksense

 Worked with multiple data sources like Oracle, Excel, QVD, XML, MS Access, flat files etc. for QlikView & QlikSense Dashboard development by making connection through ODBC and OLEDB.

 Used different kinds of loads (Inline, Resident, Preceding, Binary and Buffer) to load the data into the QlikView data model.

 Used different ETL script statements like Qualify & Unqualify, Keep, Mapping Load & Apply map, Interval Match, Info Load etc.

 Solved multiple issues which came while building the data models like Synthetic keys and Circular references using different techniques (Joins, Concatenations and Link table).

 Developed multiple data models (Star schema and Snowflake schema) based on the data for different clients which answered the questions raised by them in a better way

 Created QVDs and used those QVD's (Optimized/Un optimized) for the dashboard development for reusability and performance.  Used Incremental load (insert, Insert & Update, Insert & Update and Delete) for loading the incremental data and to reduce the reload time of different applications.

 Implemented Alternative states and What-if Analysis to provide custom functionality in QlikView Applications and Hands-on experience on Set Analysis and Link Table.

 Implemented security by using Section access in row/column level, object level & sheet level.

 Used different backend functions like, Peek (), Previous (), Match (), Wild Match (), Mix Match (), Exists (), Auto Number (), Subfield (), if () etc.

 Developed Qlik Sense Dashboards using various Qlik Sense objects like Charts, Filter Pane, Tables, KPI’S, User Interactive Sheets & Reports as business needs.

 Used different optimization techniques to improve the performance of the application for the end users.

 Extensive experience in end-to-end implementation of QlikView lifecycle

 Basic knowledge on N-Printing in QlikView and Qlik Sense.

 Migration from tableau to Qlik experience.

 Developed multiple dashboards using QlikView Extension object.

 In QlikView QMC, Created the tasks, Scheduling the triggers.

 Created Tasks/Triggers to schedule QVW tasks for reload and distribution in Qlik Management Console for different QlikView applications.

 Deployment of QlikView Application through QMC

 Automated and scheduled daily data loads of QVW documents using QlikView Publisher

 In Qlik sense QMC, Publish, Delete, Duplicate the apps. And give the ownerships to others

 Troubleshooting technical issues with QV by analyzing the log files.