SUMMARY:

• Real time IT experience in Analysis, Design, Development and Implementation of Database/BI applications in QlikView and QlikSense.
• Around 6 Years of QlikSense and QlikView Development Experience.
• Worked on QlikView and QlikSense all the updated versions.
• Expertise in QlikSense and QlikView development, administration, data modelling and architecture.
• Expert to optimize existing QlikSense and QlikView reports to improve business productivity.
• Expert in using different dimensional data models (Star, Snowflake, Data islands) based on need.
• Proficient in creating data models, QV objects, Ad hoc reports and Data visualizations using different data sources like SQL Server, QVD files using incremental load, flat files, excel workbooks, Cross tables etc. as per the user requirement.
• Experience with NPrinting 17, 18 and built the NPrinting reports and templates.
• Expertise in creating the Qlik Apps.
• Handled big data and performance optimization for large data sets.
• Experience in using extensions in Qlik environments.
• Optimized many dashboards to give good user experience.
• Expertise in Advanced Set Analysis, created complex set expressions in load script to improve the calculation time in UI charts.
• Strong SQL experience and query tuning.
• Building the QlikSense Governance dashboard using APIs.
• Expertise in the JMETER setup and Scalability Tests of QlikSense and dashboards.
• Strong experience in Performance optimization, Improved the existing application performance by using best practices.
• Expertise in QlikView and QlikSense Extensions.
• Built the auto load scrips in QMC using batch files to data in to Qlik applications.
• Experience in integrating the version control like SVN and GIT for QlikSense.
• Thorough understanding on QlikView and QlikSense Security, Architecture and Design components, User Profiles, and Authentication Mechanisms.
• Implemented all levels of security at data level, Sheet level, and row level.
• Expertise in implementing the Qlik dashboard security model using Section Access.
• Experience in dimensional modelling using star and snow flake schemas.
• Very strong knowledge on data warehouse and data base concepts.
• Experience in error handling and debugging of QlikView & QlikSense applications.
• Expert in handling production issues like report failures, missing counts in reports, resolving synthetic keys, Loops.
• Well Versed with QlikView/QlikSense reporting using NPrinting.
• Created Apps and Connections in NPrinting from QlikSense and QlikView.
• Developed different static reports in NPrinting, like Excel, Pixel Perfect, PPT and CSV reports.
• Delivered NPrinting reports to the user through email, folder location, NewStand, QlikSense Hub.
• Automating the Monitoring of the server and Fog light monitoring.
• Scheduled Data Extractions, Data Model and Dashboard Reloads using Qlik Management Console (QMC).
• Defining and implementing the Best Practices and Excellence.
• Performed Quality checks in Qlik applications before production deployment.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Experience with Full Software Development Life Cycle (SDLC) from inception to delivery of product including requirements gathering, functional specification, design, estimation, implementation, debugging, documentation, Project Release and Production support.
• Highly motivated self - starter team player who is organized and methodical.

TECHNICAL SKILLS:

BI Tools: QlikSense Feb 2019, QlikView Sep 2018, NPrinting Feb 2019 versions, Tableau, SQL, BI.

Operating Systems:: Windows, UNIX, Linux.

Database: SQL Server, Oracle, AWS, Hadoop, IBM DB2, Postgres DB, Teradata.

ETL Tools: SSIS, SSRS, Informatica.

Other Skills: MS Access, MS-Excel, MS InfoPath, Visio

SDLC: Agile, Scrum

PROFESSIONAL EXPERIENCE:

Sr. BI-Qlik/NPrinting Consultant

Confidential, Iowa

Responsibilities:

• Leading, developing the QlikSense and QlikView environment and supporting the business decision process.
• Creating the Qlik dashboards and charts like KPI, Bar, Pie, Combo, Gauge chars, Pivot and Straight tables etc.
• Implemented best practices for Qlik performance optimization and improved reload time.
• Qlik Data modelling and advanced set analysis in load script level and UI objects.
• Refactoring the existing dashboards for better performance and usability.
• Security and section access implementation at data level, sheet level, App level and Stream level.
• Used QlikSense and QlikView extensions.
• Handled big data in QlikSense.
• Integrating the version control like SVN and GIT for QlikSense.
• QlikSense Attribute based access control and role creation using security rules.
• Building the NPrinting reports with QlikView and QlikSense applications.
• Building the NPrinting advanced reports using the templates.
• JMETER setup and Scalability Tests for QlikView and QlikSense dashboards.
• Performance tuning of SQL Queries.
• Move to Integration & Move to Production of QlikSense Apps.
• Involved in Migration of single node to multi node environments.
• Expertise in QlikSense SAML implementation and Security Rules.
• Configured the QlikView Governance Dashboard.
• Configured the Multi-node built-in Apps (License monitor, and operations monitor) with in the QlikSense.
• Data modelling, analysis, design, testing, development and implementation.
• Implementing the Security as per the user authentication.
• Building the Self-service Model Creating dashboards by extracting data from database write and externalize the load scripts, store the data as QVD files and designing the UI based on business/user requirements.
• Use of Set analysis and aggregation functions for sheet objects.
• Governing data connections within the QlikSense.
• Worked on Qlik Web Connectors and Qlik Data Connectors.
• Experience with Salesforce, Oracle, SAP Net weaver Application server and supporting Hadoop platform team with hive database.
• Installed and configured N-Printing 17, Feb 2019 versions on Multi-node setup.
• Expertise in NPrinting Creating Apps, Connections, task, Users, generating reports and publishing and importing.
• Excellent knowledge on Security rules and Custom properties in QlikSense.
• Hands on experience in setting up QlikSense for external users/providers.
• Developed dashboard for manual testing as complexity index which is integrated with QlikSense Monitoring Dashboard.
• Developed dashboard Performance index where it shows the values of CPU and RAM of all servers in one dashboard
• Installed and Configured QMC utilities.
• Created the external triggers in QlikSense and QlikView like QlikSense Task runner form Qlik Branch.
• Expertise in Creating certificates using OPEN SSL and importing them into servers.
• Experience with virtual proxy’s setup with SAML integration.
• Expertise on creating security rules.
• Familiar with PGADMINIII tool and connecting to POSTGRES Data Base checking the number connections and running SQL Quires within the tool to trouble shoot the logs from QSR.
• Worked on bulk volume of data sets and different data sources like .csv files, oracle tables, excel files, images, etc.
• Tune/Optimize QlikView and QlikSense applications in order to meet enterprise performance standards.

Sr. QlikView/QlikSense Consultant

Confidential, MA

Responsibilities:

• Actively participated with business users and functional team to understand the reporting requirements and worked on all phases of the project.
• Supported in rebuilding, testing, deployment and implementation of existing QlikView and QlikSense Dashboards.
• Extensive experience in creating data models, Qlik objects, reports, graphical interactive UI and dashboards using QlikView and QlikSense from multiple data sources like SQL, Oracle and Flat Files (XML, CSV, Excel).
• Developed automated scripts for data reload form different data base sources and created tasks in QMC.
• Experience in writing scripts for mapping and transformation by using joins, concatenations, resident loads and temporary tables.
• Performed redesign of the existing QlikSense BI associative model to improve availability, scalability and performance by eliminating synthetic keys and circular loops in the data model.
• Optimized existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in the front-end, improving layout structure.
• Migrated existing QlikView applications to Qlik Sense environment.
• Developed GUI using Extension Objects from Qlik Branch, Variables, charts, Filter pane, Text objects, KPI etc. on Qlik Sense.
• Implemented Incremental load for the update of QVD's, used Set Analysis for aggregations at granular levels.
• Creating binary loads for quick reloading of applications and security purpose.
• Hands-on experience in implementing new features like Creating Stories, Pivot Table, KPI Object etc. in QlikSense.
• Configured QlikView and QlikSense environments with NPrinting tool.
• Expertise in creating NPrinting Apps, connections, task, Users, generating reports and publishing and importing.
• Distributed static reports form NPrinting like Excel, Pixel Perfect, PPT and Qlik entity reports to user through email and QlikSense Hub.
• Created and Scheduled Daily, Weekly, Monthly reports from QlikView and QlikSense reports to distribute on email and Hub using NPrinting.
• Conducted training sessions to users about the functionality and usage of application.
• Experience in creating tasks in QMC and providing access to the Users through QMC as per the user privileges.
• Trouble shooting QMC/Server log files to fix task failure errors.
• Flexible to work on weekends for Server upgradations and deployment process.

QlikView/QlikSense Developer J anuary

Confidential

Responsibilities:

• Experience in publishing of various kinds of live, interactive data visualizations, dashboards, reports to Qlik servers.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the QlikView BI suite.
• Functional Lead role in defining the dashboard requirements and providing the best practices/approach to perform ETL and publish data to the reports/dashboards.
• In charge of the team that builds architecture and dashboards using Qlik desktop, Qlik Server versions.
• Working with User for requirements and part of the team developing the software.
• Publish QlikView workbooks to cloud and schedule the refresh of data. Specialized in analyzing the incremental refresh scenarios.
• Participated in Preparing Detailed technical documents from the functional specifications.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Executed and tested required queries and reports before publishing dashboards.
• Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes.
• Extensively worked on Tableau Desktop, by creating Sears & Kmart Complex reports & Dashboards.
• Created QlikView scorecards, dashboards, Heat maps using show me functionality.
• Good Experience in publishing reports and dashboards to Tableau server
• Created complex data Views Manually using multiple measures also used sort, Filter, group, Create Set functionality.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.
• Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.
• Developed and created classes with Dimension, Detail & Measure objects and developed Custom hierarchies to support drill down reports
• Troubleshoot issues with existing reports in the production environment.
• Created Views, Stored Procedures and validated data for the Performance.
• Developed various types of complex reports like Standard reports, Group reports, Detail and Summary reports, Crosstab reports, Graphical reports, drilldown reports, on Demand and Linked sub reports, tables, views, stored procedures, business views.
• Provided daily production support and administration of portal operations, such as problem resolution.
• Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and capable of solving issues to meet the user goals.
• Worked closely with Data Modelers in designing various data warehouse schema techniques.
• Worked on the data provider that forms the basis of the ad-hoc analysis.
• Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualizations generated thru Qlik applications.

Report Analyst

Confidential

Responsibilities:

• Involved in Gathering requirements, analyzing the business specifications and the reporting issues provided by the End users and Developed specification documents for reports as per client requirements.
• Interacted with Development and Management Teams.
• Used Framework Manager to import metadata from multiple data sources, to Design and Develop the Framework Manager models.
• Created Packages and published to the Cognos Connection.
• Scheduling and distributing the reports using Cognos administration.
• Designed and developed the reports using Cognos 8 Report Studio, Query Studio, and Analysis Studio.
• Knowledge on creating and maintain reports in OBIEE and Business objects.
• Involved in testing the reports and enhanced the performance of the reports by writing Complex SQL queries.
• Involved in moving to Deployment, UAT and Production.

Environment: Cognos 8.3/8.4 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Cognos Office Connection), Oracle 10g, Cognos Access Manger, SQL Server 2005