SUMMARY

• Around 9 years of professional IT experience with 5 years of rich experience in Qlikview/Qliksense designing, development and reporting, along with good exposure to different Qliksense 1.0/2.04/3.0 .
• Full Software Development Life Cycle (SDLC) experience including Analysis, Design and Review of Business and Software Requirement Specifications.
• Involved in designing, developing, testing, publishing, maintaining and supporting Qlikview and QlikSense applications
• Developed applications in QlikSense Desktop as well as in the QlikSense Hub and shared the apps with the team through QlikSense Cloud.
• Good knowledge of deploying QlikSense dashboards on the QlikSense Server.
• Maintenance of data in form of QlikSense data files, pulling the data from relevant database
• Created QlikSense Dashboards as a Migration Project and Source change as well, including extension Object.
• Wrote SQL Scripts with preceding Loads to extract relevant data in Qlikview Applications.
• Extensively worked with SQL Queries, and capable of handling SQL Server, MS Access databases and also have good experience in database tuning and performance techniques.
• Excellent understanding and expertise in writing complex SQL queries to perform backend testing and strong Database Development skills using SQL Server 2008.
• Installed, Configured and deployed the application on QlikView server and Imported data from different sources like Oracle, SQL Server, Teradata, QVDs and flat files using OLE DB/ODBC.
• Created Dashboards and developed reports using various QlikView/Qliksense procedures Experience in Incremental Loading & QlikView /Qliksense document Versioning.
• Experienced in working with QlikSense 1.0.1 and 2.1 versions.
• Involvement in bettering existing QlikView/Qliksense dashboards with a focus on user friendliness, performance, long term usability, flexibility, as well as standardization.
• Experience with QlikView/Qliksense sheet objects including multiple charts types, Trends, KPI’s, custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting.
• Expertise in working with Data Warehousing and business intelligence tools for developing various Dashboards using QlikView/Qliksense BI.
• Strong experience in implementing dashboards in Qliksense using latest features like Data market and data profiling.
• Administered QlikView/Qliksense 10/11 server and client environments including environment optimization and troubleshooting for Access Point, Publisher, server and client installations as needed.
• Solid experience in creating POC(Proof of Concepts) and train the Business users “On How to Interpret” the data in Qlikview/Qliksense during the initial phase of the Project.
• Implemented security in QlikView/Qliksense Applications at Document and Server Level.
• Gathered fair understanding of Qlikview/Qliksense application administration encompassing Planning/ Implementing User, Resource and Password Management, Backup & Recovery Strategies, Performance Tuning, Creation and configuration of database on Oracle.
• Created Master Library with the dimensions, Measures and Visualizations.
• Experience in working with various types of charts (Line chart, Bar chart, Pie chart, Gauge charts, Straight/Pivot Tables, Scatter Plot etc.).
• Implemented Applications with QlikMap(Points & Polygon), using extension objects of QlikView and compared with the map features ofQlikSense.
• Experience in creating Data Extraction scripts for creating QVD’s, QlikView/Qliksense Scripting variables, file, date, system, Mapping and Table functions.
• Experienced in working with many complex SQL queries with Joins, Date functions, Inline functions, and Sub - queries to generate reports..
• Prepared QlikSense proof of concepts as per the requirements and specifications.
• Superior knowledge of relational databases and data modeling
• High organizational and project management skills.
• Exceptional analytical and time management skills.
• Excellent ability to translate client requirements into effective solutions
• Sound ability to interact with end users and craft clear technical requirements from business language

TECHNICAL SKILLS

Business Intelligence: QlikView 10/11, Qliksense 2.1.1

Database: Oracle 10g, MySQL, MS Access

Operating System: Windows 7/XP

Database: MS SQL Server 2005,2008,R2,2012,2014 MS Access 2000, 97, Teradata, Oracle

Languages: C, C++,TSQL, PL SQL

Web Technologies: HTML, XML, Java Script

Others: Microsoft Products MS Word, MS Excel, MS Access, MS Power Point, MS Visual Studio, Visual Basic 6.0

PROFESSIONAL EXPERIENCE

Confidential - Norwalk, CT

Sr. Qlikview/QlikSense Developer

Responsibilities:

• Involved in gathering the Business requirements and developing the dashboards.
• Implemented and managed section access and security by implementing Section Access and tested the module in production.
• Created story board, user stories and documented for existing apps.
• Worked on Qlikview Server and Publisher, to manage user access, schedule refreshing of documents, mount completed applications. Applications were refreshed on a monthly basis and used by a group.
• Worked in both ETL and UI of QlikSense.
• Populated Metrics in the master library required for developing the apps.
• Migrated existing apps in QlikSense 2.2 to QlikSense 3.0 and tested their performance.
• Developed different kinds of widgets using HTML & CSS in QlikSense 3.0.
• Installed all the extensions in QlikSense 3.0 in the QMC and used them in creating various visualizations in different apps.
• Developed ETL Scripts while loading the data, resolving loops & ambiguity joins.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Developed SQL script through Oracle Toad and exported the data for loading into QlikSense.
• Worked on the front end of Micro strategy for creating users, providing access and pulled data to the Qlik Schema.
• Developed various apps, published and moved to production for testing purpose.
• Involved in preparing the Business Requirement Document (BRD).
• Creating Tasks for reloading of Qlikview data to QVDs and QVWs through QMC.
• Developed QlikSense Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box, Statistics Box, Multi Box and Calendar & Date Island.
• Applied mapping function to look up and fetch the required field.
• Developed complex SET ANALYSIS to provide custom functionality in QlikSense Applications.
• Prepared applications in Sense Desktop as well as in the Qlik Sense Hub and shared the apps with the team through Qlik Sense Cloud.
• Worked with QlikView/Qliksense administrator to optimize QlikView performance.
• Prepared Qlikview proof of concepts as per the requirements and specifications.
• Involved in Dashboard migrations from QlikView to QlikSense.

Environment: QlikSense 3.0, Oracle TOAD, HTML, CSS, Micro Strategy, QlikSense Server/ Publisher, Windows 2003 Server/XP, PL/SQL, MS Excel 2013.

Confidential --Waukegan, IL

Sr. Qliksense Developer

Responsibilities:

• Worked on Qlikview Server and Publisher, to manage user access, schedule refreshing of documents, mount completed applications. Applications were refreshed on a monthly basis and used by a group.
• Managed all changes to data models and created data models, solution designs and data architecture documentation for complex information systems including synthetic keys and circular reference.
• Migrated existing apps in QlikSense 2.2 to QlikSense 3.0 and tested their performance.
• Developed different kinds of widgets using HTML & CSS in QlikSense 3.0.
• Installed all the extensions in QlikSense 3.0 in the QMC and used them in creating various visualizations in different apps.
• Developed ETL Scripts while loading the data, resolving loops & ambiguity joins.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Developed SQL script through Oracle Toad and exported the data for loading into QlikSense.
• Prepared applications in Sense Desktop as well as in the Qlik Sense Hub and shared the apps with the team through Qlik Sense Cloud.
• Creating Tasks for reloading of Qlikview data to QVDs and QVWs through QMC.
• Developed QlikSense Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box, Statistics Box, Multi Box and Calendar & Date Island.
• Developed Qliksense Dashboard using KPI’s and set analysis expression.
• Performed unit testing for each requirement and made corrections writing SQL queries.
• Performance tuning by analyzing front end and backend of Qliksense Server.
• Created various types of charts(Line chart, Bar chart, Pie chart, Gauge chart, Straight table/Pivot table, Scatter plot, Map, etc)
• Experience in Incremental loading&Qliksense Versioning.
• Created Master library with the dimensions, Measures and Visualizations.
• Worked with many complex SQL queries with Joins, Date functions, Inline functions and sub queries to generate reports.
• Experience on publishing QVF files through QMC.
• Experience in Qliksense development of ETL scripts for Data Modeling along with resolving Synthetic Key and Circular Loop issues.
• Experience in Qliksense Management Console in adding users, assigning tokens, creating security rules, streams, upgrading license and etc.
• Proficient in SET ANALYSIS to provide customized functionalityin Qliksense Applications
• Took part in installation of QlikSense Server with administration team.
• Automated and scheduled daily/weekly/monthly data loads of QVF documents using Qliksense Publisher.

Environment: QlikSense 3.0, Oracle TOAD, HTML, CSS, Micro Strategy, QlikSense Server/ Publisher, Windows 2003 Server/XP, PL/SQL, MS Excel 2013

Confidential, NYC, NY

Qlikview Developer / Admin

Responsibilities:

• Designed different sets of reports and interacting with client for requirement analysis and delivery project of QlikView application.
• Written complex expressions using Set analysis and various QlikView functions.
• Designed and developed dashboards with various levels of complexity including different kinds of charts and extensions
• Created Dashboard using different components of QlikView like listboxes, multiboxes, slider, buttons, charts (Bar, Line, Combo, Gauge, Scatter, Straight/Pivot table).
• Designed an applications for to support the lending process and dashboard style of layouts using different components of QlikView Enterprise like List boxes, Multiboxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView Publisher
• Scheduled QVW reloads on Server/Publisher by creating tasks in the Source Documents. Used Loop and reduce concept for creating multiple apps based on the field.
• Creating QlikView applications for analysis reports from multiple data source.
• Maintenance of data in form of QlikView data files, pulling the data from relevant database.
• Handled the end-to-end implementation of QlikView dashboard deployment.
• Implemented incremental load by creating QVDs and optimized the periodic data additions.
• Scheduling the automation of QV jobs using QlikView Management Console.
• Worked with QlikView/Qliksense administrator to optimize QlikView performance.
• Prepared Qlikview proof of concepts as per the requirements and specifications.
• Created Master Library with the dimensions, Measures and Visualizations.

Environment: QlikView 11x/10(Desktop, Server/Publisher, Access Point),Nprinting for Qlikview (14.03.), SQL Server/ 2008/12, AS400 (I series), Windows XP/7.

Confidential, NYC, NY

Qlikview Developer

Responsibilities:

• Involved in business requirement gathering and development of functional and technical specification Documents.
• Gathering data sources like QVD files, Excel, Cloudera HIVE, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing the QlikView Data Models.
• Connected to different ODBC, OLE DB data sources (SQL Server, MSAccess, Oracle, Teradata) and flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components of QlikView.
• Created weekly PDF report distribution for a set of users using PDF Distribution functionality in QV Publisher.
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Data Island.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView publisher.
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc...)
• Developed User Interactive Sheets & Reports as business needs.
• Developed SQL Scripts to load the relevant Data in QlikView Applications.
• Developed Macros, SET ANALYSIS to provide custom functionality in QlikView Applications.
• Performance tuning by analyzing and comparing the turnaround times between SQL and QlikView.
• Enhance existing dashboards with new functionalities and Tune ETL scripts for better performance.
• Build reusable macros to control QlikView objects for ease of use by the users.
• Research and troubleshoot technical problems and provided ongoing QlikView consultation to the development team.

Environment: QlikView 11.2,SQL Server 2005/2008, MSAccess, Oracle, Cloudera HIVE, Teradata, Windows 2008 R2 server, HTML, Excel

Confidential 

SQL Server Developer/SSIS/ SSRS

Responsibilities:

• Developed complex T SQL code for the application.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables
• Conducted performance tuning by using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Design and developed reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
• Involved in the full development cycle process of Planning, Analysis, Design, Development, Testing and Implementation.
• Implemented star schema & snow flake schema (confirmed dimensions)
• Migrated databases among the servers using copy, attach/detach, copy/restored utilities.
• Developed Linked Tables, Concatenation and solved issues with loops.
• Executed Test cases manually Using Quality Center.
• Actively participated in full life cycle of QlikView application implementation and was responsible for design, development and delivery.

Environment: SQL, PL/SQL, Crystal Reports, Business Intelligence, Oracle 9i, UNIX Shell Scripting.