SUMMARY

• 6 years of IT industry experience in all aspects of Business intelligence applications with a strong background in Database development, Data Warehousing/ Decision support systems and Business Intelligence (BI).
• Five Plus years of experience in Designing and Development of Business intelligence applications with Qlikview 11.2/10.0/9.0 as BI tool.
• QlikView Developer experience in all aspects of Business Intelligence applications with a strong background in Database development, Data Warehousing/ Decision support systems and Business Intelligence (BI).
• 2+ Years of experience in preparing dashboards using Qliksense 3.1/3.0.4/2.2/2.0 extension objects.
• 2+ Years of experience in generating reports using Nprinting.
• Experience in Nprinting QlikView/QlikSense Reporting as NPrinting is the most advanced report generation, distribution and scheduling application for Qlik.
• Installed and configured the NPrinting into the environment and publishing the reports through the NPrinting.
• Worked with Nprinting Reports/Tasks/Schedules in 16.3 and 17.2.
• Experience in using QVW, QVD, QVX and QVF (Qliksense) files effectively.
• Experience preparing dashboards using Qliksense extension objects.
• Expertise in design/development of Business Intelligence Applications with QlikView 12.10/ 11.2/10.0/9.0 as BI tool.
• Strong knowledge/experience in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production support.
• Strong experience in QlikView Product family such as QlikView Desktop Client, QlikView Management Console, QlikView Server.
• Strong experience in Scripting, developing and designing Dashboards using QlikView by extracting data from multiple sources (Oracle, Flat files, Excel, Access).
• Created scheduled jobs for QVD extracts and report reloads.
• Created extension objects in QlikSense/QlikView using JavaScript, AngularJS files for creating visualization extensions in Filters, Directives, Templates, Data Binding etc.
• Hands on experience in SDLC processes and methodologies in Business Intelligence domain.
• Developed business requirements, Dashboard development, and data verification and analysis.
• Deployed QVWs on the production server, Created Reload and Distribution tasks on QlikView Server/publisher.
• Experience with Multiple Relational Databases including Oracle, MS SQL Server, DB2 and MS Access.
• Experience with QlikView sheet objects Pivot, List, Multi - box, multiple charts types, KPI’s, custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting.
• Experience in using ETL Tasks such as data cleansing, joins aggregation tables using QlikView.
• Designing Data Mart and Data Warehouse and Implementation of QlikView for BI Reporting Solutions.
• Extensive use of Set Analysis expressions in the charts for achieving complex logics.
• Implemented Best Practices to resolve Circular Relationships, Synthetic Keys in QlikView and designing an optimized Data Model.
• Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas.
• Strong experience in writing SQL Queries, Views, and Stored Procedures.
• Self-Starter with excellent communication and interpersonal skills.

TECHNICAL SKILLS

Reporting Tools: QlikView 9/10(SR3/4)/11.2(SR2)/11.2(SR10)/11.2(SR12),12.10, Qliksense- 3.1/3.0.4/2.2/2.0, Nprinting-17.2

Operating Systems: Windows 98/NT/XP/2000/ 2003, 2008, Linux

Databases: Oracle 12c/11g, MS SQL Server 2008/2005, DB2, MS-Access-

Database Tools: SQL * PLUS, Toad for Oracle Base (10.6.1.3)

Other Tools: Hyperion Essbase, Planning, Smart view, 9.2/9.3.1/11.1.2.1

Office Tools: MS Word, Excel, Power Point

PROFESSIONAL EXPERIENCE

Confidential - Detroit, MI

QlikView Developer

Responsibilities:

• Gathered customer requirements from Business Analyst and understand the data from different source systems.
• Extracted data from the database, stored into QVD files, and wrote Load scripts.
• Implemented QlikView three tier architecture Data Model.
• Eliminated Synthetic keys and circular loops.
• Created link tables on the needed basis and as per the data.
• Created Master Calendar and worked with date fields as per the user needs.
• Applied mapping function to look up and fetch the required field
• Created User Interface of reports and designed the Dashboard according to the requirements.
• Created Dashboard style of layouts using various components of QlikView like List boxes, Multi - boxes, Slider, Current Selections Box, Buttons, Charts, Text Objects, and Bookmarks.
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping).
• Constructed various graphs such as Straight table, Bar graphs, Pie charts, Line charts Gauge charts.
• Implemented Pick Dimensions and Pick Measures as Custom reports tab at the Dashboard.
• Extensively used variables to meet various requirements.
• Worked on set analysis and advanced aggregation functions.
• Implemented document event trigger and field event triggers.
• Implemented secure environment using QlikView Section Access.
• Worked on QlikView server and publisher to automate the QlikView jobs and define the user security and data reduction.
• Deployed QVW s on the production server, Created Reload and Distribution tasks on QlikView Server/publisher.
• Troubleshot issues and reviewed log files to resolve the issues.
• Managed user s access to the QlikView Server and QlikView Access Point.

Environment: QlikView11.2, QlikView Server and Publisher (QMC).

Confidential - Charlotte, NC

QlikSense Developer

Responsibilities:

• Actively participated in Production meeting for requirement gathering working closely with business users and stakeholders.
• Involved in full project life cycle implementation (requirement gathering to production) QlikSense dashboards.
• Participated on business requirement document preparation.
• Responsible for Self-Business analysis tool Qlik Sense initial setup and end to end development of Qlik Sense applications.
• Involved in designing the data models, extract & transform the data from heterogeneous data sources like QVD files, Excel, SQL Server, Oracle, binary QVW, Inline & txt files in creating the QlikSense dashboards.
• Connected to different ODBC, OLE DB data sources (SQL Server, Oracle) and flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components of QlikSense.
• Created multiple tab dashboards. Created Pivot tables, Trend graphs, Bar graphs, Stacked Graphs, containers and so on.
• Created SQL Stored Procedures and Views to fetch the data from database to build reports.
• Extensively worked with QlikSense functions, objects, Set Analysis, Variables to generate different kinds of charts. Also generated QVD files by writing scripts in QlikSense applications.
• Used a KPI/gauge object which has built in color switching to color code the fonts.
• Extracted data from multiple complex hierarchies from cross table excel files.
• Created Line Charts to show different trends of finance information over years using set expressions, year function, max() function etc.
• Built several Dashboards with current year statistics and trending information with ability to toggle between different metrics and drill down sheets and report detail charts for further analysis.
• Worked as QlikSense administrator to optimize Qliksense performance.
• Trained users to build their own apps in QlikSense.
• Worked on Qlik sense new objects Maps, KPI and object and document extensions for wire frames, and proof of concept applications.
• Implemented optimized loadings and performance tuning with the help of qlik support.
• Security and mobile ability enabling and taken care of QlikSense QMC, repository and hub access.
• Used Set Analysis in the Line and Bar charts (Combo Charts) to show the user different trends of product sales over years.
• Used RequireJS to add the local JavaScript file as a dependency for loading local JavaScript files into QlikSense.
• Loaded external JavaScript files to load resources from a Content Delivery Network (CDN) in several visualization extensions since the browser does not have to load the resource all over again.
• Installed and configured the NPrinting into the environment to publish the reports.
• Worked on NPrinting Tool and created Pixel Perfect customized reports as per the client requirements using the rich NPrinting reporting features.
• Distributed QS reports using NPrinting in the form of Excel/PDF/Power Point/Word etc. to users.
• Create, manage, clone, and delete nodes in Qlik Sense sites that are deployed in cloud computing environments.
• Installation of IE plugins and worked with business analysts to train the end users to use the reports effectively to build and customize their ad-hoc reports.

Environment: Qlik Sense 3.1, Nprinting 17.2, Data Modeling, Oracle 10g, DB2, MS SQL Server 2016, Windows 2008 R2, Excel, MS Access, Flat files.

Confidential - Miami, FL

QlikView/QlikSense Developer

Responsibilities:

• Understanding source systems and customer requirements.
• Implemented Multi-Tier Architecture to create QVDs, Data Models, and reports.
• Used SQL query’s extensively to retrieve the required data from SQL Server.
• Created a Data Model for an application by using various functions.
• Eliminated Synthetic keys, ambiguous relationships.
• Assisted in performance of QlikView & Qliksense applications for faster data reloads and efficient respond times.
• Applied mapping function to look up and fetch the required field.
• Involved in converting the existing QlikView applications to Qliksense.
• Used Set analysis to write complex logic according to requirement.
• Worked with Sheets and Sheet Objects in QlikView.
• Created dashboards using Qliksense extension objects and mashups.
• Worked with Section Access so that the data security defers to each user.
• Worked with Variables to hide/show the necessary objects and perform logics according to requirement.
• Optimized existing Data Models like changing Load scripts to load data in optimized way to achieve reduction of loading time, simplified complex expressions in the front-end and improved layout structure.
• Developed applications and manage security for all required applications.
• Worked on deployment of QlikView Applications in the production.
• Maintained an environment for the authoring of QlikView reports in QMC.
• Created tasks and reduce, reload, and distribution of Publish the Reports using QMC.

Environment: QlikView 11.2 (SR12), QlikView Server/Publisher (QMC), SQL Server 2008 R2 Enterprise, Windows 2008 Enterprise, Qliksense.

Confidential - Boston, MA

QlikView Developer

Responsibilities:

• Gather customer requirements from Business Analyst.
• Understand the data from different source systems.
• Extract data from the database, stored into QVD files, and wrote Load scripts.
• Identify Dimensions/Fact Tables form of source tables and implement Multi-Tier Architecture to create QVDs, Data Models, and reports.
• Create link tables on the needed basis and as per the data.
• Develop executive Dashboards in QlikView delivered through the web.
• Work with Sheets and Sheet Objects in QlikView.
• Use layout conditions to meet various requirements.
• Develop Set Analysis to provide custom functionality in QlikView applications.
• Implement Document Event Trigger and Field Event Triggers.
• Extensively use variables to meet various requirements.
• Use different color schemes for charts according to meet requirements.
• Create daily, weekly, monthly and quarterly reports according to the customer requirements.
• Back tracking QlikView Data Issues by comparing QlikView Reports with Database Tables output using SQL Queries through TOAD.
• Work on QlikView Server/Publisher to automate the QlikView Jobs and define the user security and data reduction.
• Deploy QVWs on the production server, create Reload and Distribution tasks on QlikView Server/Publisher.
• Manage user’s access to the QlikView Server and QlikView Access Point.

Environment: QlikView 11.2 (SR10), QlikView Server/Publisher (QMC), TOAD for Oracle Base (10.6.1.3), MS Excel, Windows 2008 Enterprise

Confidential - Englewood, CO

QlikView Developer

Responsibilities:

• Gathered the requirements from Business Users and passed on the requirements to the team.
• Worked on designing the Data Model and Construction of the Data Model and implemented the Star schema for QV better optimization.
• Installed, configured and deployed the application on QlikView server and Imported data from different sources such as Oracle, SQL Server, MS Access, XML files and flat files using OLE DB/ODBC.
• Created Dashboard reports to track all the way through 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.
• Created Dashboards with complex sheets which include List boxes, Statistic boxes, and containers, different charts (bar charts, scatter charts
• Heat charts, and Block charts and pie charts) to show the statistics of the sales held on different products in different years.
• Created static reports using straight tables and pivot tables with spark lines and mini charts
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView Publisher.
• Worked on upgrade of QlikView environment from QV 10.0, QV 11.0 versions.
• Designed, developed, implemented and tuned multiple QlikView applications for the Sales, IT.
• Used advanced scripting, Alternate states for comparative analysis, set analysis, VBScript and JavaScript macros, advanced aggregation functions, advanced charts for applications and Document chaining
• Created Layout themes and applied it to several QVW’s
• Involved in performance tuning of Dashboards to improve the response time for the users accessing the documents via access point by reducing the size of the QVW
• Good understanding in the area of monitoring the various services in QMC, Task setup, Managing client licenses
• Mounting folders, session collaboration, enable session, performance and audit logging, type of authorization (NTFS and DMS), loop and reduce and Section access management in PAT

Environment: QlikView 11.0 (SR2), QEMC, SQL Server, DB2, Windows 2008 Server, HTML, VBScript, JavaScript, Qviewer, MS TFS, MS Excel

Confidential

SQL DBA

Responsibilities:

• Converted Data Transformation Services (DTS) application toSQLServer Integrated Services (SSIS) as assigned.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using ofSQLServer 2005 Integration Services (SSIS).
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Configured load balancing, backup/recovery, sizing and space management, PL/SQLtuning, diagnostics, and proficient with the use of Oracle's Enterprise Manager Tool.
• Worked on Migration of packages from DTS usingSQLServer Reporting Service (SSRS).
• Generated reports usingSQLReporting Services (SSRS) for customized and ad - hoc Queries.
• Involved in creating calculated members, named set, advanced KPI'S for the SSAS cubes.
• Experience with configuration, load balancing, backup/recovery, sizing and space management, PL/SQLtuning, diagnostics, and proficient with the use of Oracle's Enterprise Manager Tool.
• Designed and created the table schema and stored procedures that will be used in Data QC.
• Integrated SharePoint Server with SSRS and deploying SSRS reports on to SharePoint Server.
• Created and Maintained SharePoint Site for Issues Tracking and Reporting Weekly & Monthly Status & Metrics.
• Responsible for documentation of system related activities.
• Setup replication within the SQL databases.

Environment: DB2,SQLServer, Enterprise, Windows Enterprise Server, BizTalk Server, Erwin, IIS 6.0, .NET, Erwin, Microsoft Visio, SFTP, Microsoft Reporting Service