SUMMARY

• More than 8+ Years of IT experience in Business Analysis and Business Intelligence Projects, along with 4+ years of Qlikview and Qliksense Development/Admin.
• Expertise in working with Data Warehousing and business intelligence tools for developing various reports using Qlikview/Qliksense BI.
• Experience in full life cycle project development, including design, coding, testing and implementation with ongoing product support.
• Strong analytical database design and Data Modeling (Star Schema, Snow Flake Schema) skills in Qlikview.
• Experience on MS SQL Server (BI) and SQL Programming.
• Expertise in ETL (Data Extraction, Transformation Loading), Data modeling, Designing Visualizations and Performance Tuning using Qlikview
• Good Understanding of Relational and Dimensional Database Concepts.
• Excellent understanding of data warehouse specific Architecture, Design and Procedures, ETL and Workflow Development, data cleansing, data quality validation and unit testing.
• Expertise in Installing and Configuring Qlikview Desktop, Qlikview Server and Qlikview Publisher
• Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.
• Interacted with Customers for requirement gathering and effective analysis.
• Supported all phases of a project life cycle including analysis, design, development, testing, deployment of solutions, and postproduction support/maintenance functions.
• Developed User Interactive Sheets & Reports as business needs.
• Developing SQL Scripts to load the relevant Data in both Qlikview and Qlik Sense Applications.
• Developed Macros, set analysis to provide custom functionality in Qlikview Applications
• Developed Qlikview Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Data Island
• Experience in designing Qlikview Document/User Setting, Layouts to make consistent and professional optimized look to clients.
• Experience in data migration between homogenous and heterogeneous system using various tools (Data Transformation Services (DTS), SSIS, BCP and Bulk Insert).
• Proficiency in developing SQL with various relational databases like Oracle, SQL Server.
• Expert in Data warehousing concepts - Star Schema, Extended Star Schema, Snowflake Schema, Multi-Dimensional modeling & Entity-Relationship modeling.
• Exceptional analytical, troubleshooting and communications skills to communicate directly or remotely with business partners/clients to identify key areas where Business Intelligence can solve business problems by delivering pertinent and timely information.

TECHNICAL SKILLS

DASHBOARDING/ANALYTICS: Qlikview 10.x, 11.x, 12.x, Qliksense 2.x, 3.x, Feb 2018, June 2018 Tableau, Microsoft SSRS, Cognos.

Others: Informatica, Teradata.

Operating Systems: Windows NT XP/2000, Windows 2003, 2008 R2, Windows 7

Web Technologies: HTML, CSS, XML, Java Script/jQuery

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

User interface: HTML, CSS, XML, Java Script/JQuery

PROFESSIONAL EXPERIENCE

Confidential

Sr. Qliksense Admin/Developer

Responsibilities:

• Qlik view and Qlik sense point of View developing, performance tuning, capacity planning and Problem solving.
• Extensive Experience in working with Qlik Sense sites and the Qlik Management Console (QMC), to provide IT and data governance, library of QVD maintenance, as well as user and application security.
• Architected the design of Multi-layered QVD architecture across the functional.
• Actively part of business requirement elicitation and discovery workshops to gather the functional & non-functional requirements.
• Responsible to create the Access control list (ACL) & security rule provisioning.
• Responsible to maintain the Qlik Sense operations, license, log and session monitors.
• Qlik Sense Installation/Upgrades and Migration and Defining Guidelines for Migration.
• Part of design team to provision High Availability (HA) architecture with fail-over clusters.
• Administered multiple Qlik sense and Qlik view farms consisting of load balanced dashboards and Mashups external Back end application Servers (Dev/QA/UAT/ PROD) monitoring via Dynatrace Monitoring tool.
• Custom Mashup Solutions to retrieve the business data from Qlik view applications Into Qlik sense.
• Troubleshooting capabilities to research Qlik Sense audit logs to resolve & remediate issues.
• Responsible to replicate Qlik sense application installation and upgrades in various pipelines (Dev, QA, UAT, & Prod Environments).
• Working experience with Middle ware team for certificates, Ping federate team for SAML Integration and F5 team for load balancing multiple servers.
• Managing and allocating Qlik sense tokens and Access pass.
• Monitoring of the Qlik Sense server platform for performance and availability with HP performance monitoring tool.
• Installation of NPrinting - April 2018 and implemented on demand functionality with Qlikview.
• Installation/Configuration of Qlik GeoAnalytics to connect Qliksense and QlikView.
• Installed Web connector and configured SMTP Connector to send email notification for Qliksense success/failure jobs.
• Managing of all Qlik Sense server configurations.
• Management of the reload schedule for all QlikView/Qlik Sense documents.
• Good experience in Qlik view Publisher (QMC) - creating tasks, access granting to Users, EDX triggers, troubleshooting.
• Manage deployments of Qlik applications / Create a stream and publish the application and deploy the data files.
• Create deployment strategy for the Mashups of the development, quality assurance and staging and Production environments.
• Handled the administration responsibilities for 10 Qlik admin team members & handled requests of external team on-boarding into the Qlik farm.
• Knowledge of networking and Active Directory configuration, proxies, intermediate web servers etc.

Environment: Qlik view 11 SR2/11.2/12.1 SR11, Qlik sense September 2018 /June 2018 Patch 3, MS Office, SQL server 2016, Windows server 2008, Windows server 2012, Windows 7, and Windows 10.

Confidential

Sr. Qliksense Admin/Developer

Responsibilities:

• Extensively worked with different QlikSense components like charts, Maps, filters, KPIs
• Extension Objects and created master Visualizations and dimensions.
• Extensively worked with QlikSense Extensions for Qlik Charts, buttons and filters.
• Developed and maintained Qlikview/QlikSense Load Scripts across multiple data sources.
• Identified data sources and prepared data for QlikView/QlikSense applications, managed existing and new projects.
• Created and maintained user guides and documentation for Qlikview/QlikSense applications.
• Analyzed the existing QlikSense data model, script logics and the ETL business logic for the enhancements and further developments.
• Qlik Sense Installation and Migration and Defining Guidelines for Migration.
• Performance tuning for big data sets dashboards by analyzing and comparing the turnaround times between SQL and Qlikview.
• Automated and scheduled daily/weekly/monthly data loads of QVW documents using Qlikview.
• Installed and configured NPrinting and built reports to replace QlikView macros / SAS code to generate reports.
• Generated Qlikview/QlikSense reports using NPrinting and scheduled to send reports as email to users.
• Qlik view and Qlik sense point of View developing, performance tuning, capacity planning and Problem solving.
• Created NPrinting Task dependencies in Qlikview Management Console using triggers.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView publisher.
• Built a dashboard and assisted in integrated with Enterprise Salesforce CRM application.
• Extensive experience in creating Pixel Perfect reports, Excel reports, Word reports, PowerPoint reports using NPrinting designer and automating the jobs in NPrinting Server.
• Involving in creating hierarchies from providing drill down options for the end user.
• Publishing and deploying the dashboards based on business requirements.
• Active involvement in production support.
• Participated in design review meetings and analytical solution development.
• Providing training to users who are new to Qlik.

Environment: Qlik view 11 SR2/11.2/12, Qlik sense 2.0/2.2/3.0/11.24.1 , MS Office, SQL server 2016, Web UI, Windows server 2008, Windows server 2012, Windows 7, and Windows 10

Confidential

Sr. Qlikview/Qliksense Developer/Admin

Responsibilities:

• Understanding the requirements from the business users and their reporting needs. Suggested better way of presenting layout /Sheet Objects and developed the architecture of prioritized reports which were accepted and successfully implemented in the dashboards.
• Installation and configuring of Qliksense Desktop on Windows Server 2008 R2 Enterprise/cloud.
• Developed the report by passing a Parameter Value to navigate from one KPI in Dashboard to another.
• Analyzed the source data coming from various heterogeneous data sources to be consumed in the ETL procedures to load data into data warehouse.
• Used a KPI/gauge object which has built in color switching to color code the fonts.
• Scripted using dollar sign expansion which is a text replacement that happens before the actual statement is parsed and evaluated.
• Developed executive dashboards in Qlikview delivered through the web, enabling to measure.
• Performance the performance of the business with analytical capabilities.
• Dashboards were served to track inventory and sales as well as to monitor various KPIs. Dashboards included customer detail drilldowns, threshold gauges and alerting mechanisms.
• Implemented performance tuning techniques both in the scripting and UI.
• Created Line Charts to show different trends of Product Sales over years using set expressions, year function, maxfunction etc.
• Involved in the business requirement gathering and development of functional and technical specification documents.
• Created connections and Extracted data from multiple complex hierarchies from cross table excel files.
• Worked on modeling data as per business requirements. Eliminated Synthetic keys, ambiguous relationships and closed loops.
• Multiple levels of Hierarchies are implemented such as Cohorts, Sales, Products, Partner, Customers and Service Hierarchy etc.
• Provided custom functionality in Qliksense Applications.
• Developed Fast Change Charts by using both Cyclic Groups (merged Expressions and also the fields) and Drill Down groups.
• Developed Bar Charts to show the total/Average sales of products for the current and previous years.
• Frequently used statements/functions while developing were Where Exists), Get selected functions, If, Distinct, Join, Concatenate, Resident, AutoNumber, Mapping load, Apply Map, ceil Len, calendar functions.
• Used Set Analysis in the Line and Bar charts (Combo Charts) to show the user different trends of product sales over years.
• Used Calendar/Slider Object to set a custom Date in the Adhoc tab, a tab which is specially designed where the users can create their own graphs/charts.
• Created Dashboard reports to track all the way through the ship to final acceptance phases.
• Developed executive dashboards in Qlikview delivered through the web, enabling to measure the performance of the business with analytical capabilities.
• The Process was Agile and strict time line oriented. Worked closely with Project manager.
• Performed technical leadership in dashboard application design, visualization, automation, e - mail alert and notification, data modeling and the integration with the Portal platform.
• Used Data Model Optimizing techniques to reduce the size of the application, improve the performance/speed of the application and was involved in performance tuning of dashboards to limit the response time and enhance the functionality.
• Created List boxes, Statistic boxes to show the statistics of the sales held on different products in different years. Also showed the statistics in bar charts and pie charts as per the client needs.
• Converted A Pivot Table into a Static Selection table box using some techniques like conditional Show, Multiple Dimensions imposed with conditional calculations etc.
• Developed heat maps (Google Maps and also Picture embedded text objects) with alert mechanism to show US State wise and scatter maps. Also Various KPI graphs were drawn. Kept eye on Qlikview best practices.
• Used svg map with qar extensions to design a web view heat map/Choropleth using Qlikview.
• Developed an Ad hoc sheet where the users have the freedom to select their own dimensions and metrics to create their own personalized Pivot/straight table.
• Developed nsq files to export the excel reports based on the business requirement.

Environment: Qlikview 11.2 - SR12, Qliksense 3.0, Printing, Oracle SQL Developer 3.2.20 TSQL, HTML, CSS, JQuery, JSFiddle, Windows 2012 Enterprise server, Excel.