Shire Pharmaceuticals, Lexington, MA

August 2017 – Till Date

Role: QlikView/Qlik Sense Developer

Key Responsibilities:

·         Worked on deployment of Qlik Sense dashboards from Dev to QA, QA to UAT and UAT to PROD.

·         Implemented 3 Tire architecture in deploying QlikView application.

·         Involved in User requirements and Documentation and Dashboard Prototypes.

·         Involved in Extracting and loading the data from HIVE, Oracle, Netezza and various data sources in to QlikView/Qlik Sense.

·         Trained User’s on Self-service functionality in Qlik Sense.

·         Provided Production support for Qlik Sense applications.

·         Extensively used extensions like Navigation buttons, List boxes, and date picker in Qlik Sense.

·         Experience in converting Tableau reports to Qlik Sense.

·         Experience in converting Cognos reports to Qlik Sense.

·         Implemented Incremental Load, Optimized Load & Binary Loads for performance tuning and for optimized QlikMarts.

·         Expert in proving test Queries and design documents for each work request.

·         Worked on Agile projects and extensively used JIRA for providing the updates and tracking the User stories.

·         Extensively used Service Now for analyzing the Work Requests, raising the tickets and tracking the Incidents.

·         Created multiple POC’s of Qlik Sense applications from flat files.

·         Used Binary load in Qlik Sense to fetch the Data model available in Qlikview.

·         Used QMC for configure tasks and publish the QVF files.

·         Developed dashboards using different Qlik objects like Bar chart, PI chart, pivot table, container etc.

·         Involved in managing data and maintaining the QVDs and QVF’s in Qlik Sense deployment.

·         Created buttons, List boxes, Multi boxes, slider, charts, text objects, bookmarks, Web links etc.

·         Implemented Set Analysis to provide the custom functionality in Qlik Applications.

·         Eliminated circular loops& synthetic keys in the data model.

·         Experience in working with irise proto typing to create mockup dashboards.

·         Involved in training sessions with Business users and prepared documentation.

·         Resolved the client issues spontaneously without any delays.

Environment: QlikView 11.2, Qlik Sense, Hive, Netezza, Oracle, JIRA, ServiceNow, Excel, MS Access, Tableau 10, irise, Cognos.

CVS Health, Woonsocket, RI

September 2016 to July 2017

Role

QlikView Developer

Key Responsibilities :

·           Developed proof of concept to check the functional feasibility of the QlikView implementation.

·         Studied QlikView and its components and worked closely with the QlikView Implementation partners.

·         Dashboard was designed for finance managers to monitor the performance of the employees as per assigned KPIs.

·         Very good knowledge in handling and troubleshooting the Qlikview Issues. 

·         Participated in Installing, configuring and deploying Gather business requirements from business users and developed Application Prototypes.

·         Strong understanding in creating Dashboards for the required KPI’s in QlikView.

·         Deployed the application on QlikView server and imported data from different sources like Oracle 10g, MS Access, XML files and flat files using OLE DB/ODBC.

·         Mainly designed and developed QlikView applications from scratch, to support reporting and Business Intelligence initiatives.

·         Used advanced scripting, set analysis, VBScript and macros, advanced aggregation functions and advanced charts.

·         Converted existing Business Objects reports to QlikView.

·         Developed QV Dashboards using various Chart types (straight, pivot, bar, Pie, gauge, combo, List boxes, Input Field, Table Box, sliders).

·         Experience in using QV Functions related to string, date, color and formatting.

·         Developed User Interactive Sheets & Reports as per business needs.

·         Developed views in DB to load the relevant Data in QlikView Applications.

·         Developed Macros and implemented extension objects to provide custom functionality in QlikView Applications.

·         Used Oracle/SQL Server as backend and QlikView script for ETL Operations for extracting, 

·         Implemented Security using section access.

·         Involved in Deployment of QlikView Applications into the server.

·         Extensively implemented incremental loading to decrease the load time / increase loading performance.

·         Testing Applications using review checklists, Data quality for Quality Assurance before delivering to the end users.

·         Used QMC for configure tasks and publish the QVW files.

Environment: QlikView 11, Qlik Sense 3.0, Teradata 14.0, Excel, MS Access, Tableau 9.0, Oracle, MySQL.

Alliance Inspection Management, Farmington Hills, MI

October 2015 to September 2016

Role

QlikView/Qlik Sense Developer

Key Responsibilities :

·         Involved in requirements gathering, analyzing, and documenting business requirements and data specifications

·         Involved in extracting, transforming and loading data from sources into Qlikview/Qlik Sense applications

·         Worked on deployment of Qlik Sense/Qlikview dashboards from Dev to UAT and UAT to PROD

·         Worked extensively on complex Data models as per client requirements. Eliminated Synthetic keys, ambiguous relationships and closed loops.

·         Created scheduled jobs through Qlik Sense management console (QMC).     

·         Extracted data from the Oracle and stored into QVD files.

·         Created Complex data model with necessary fact tables and dimension tables.

·         Extensively used Qlik functions such as Date and Time, Keep, join, Concatenate, Mapping Load, Inline Load etc.

·         Connected to oracle database using ODBC and OLEDB data sources and tables

·         Analyzed the existing QlikView data model, script logics and the ETL business logic for the existing QlikView applications using Document Analyzer.

·         Executed the scripts and checked the incorporated script changes in the application.

·         Developing Set Analysis to provide the custom functionality in QlikView Applications.

·         Implemented incremental load for the Update of QVD’s.

·         Supported in modifying, testing and implementation of existing reports.

·         Developed different dashboard with a complex database system which includes extracting data from the database, storing into QVD files, write load scripts, and develop UI per user requirements.              

·         Used set analysis to compare performance between varying time periods, geographic region, product lines, etc.

·         Created different templates in nprinting for daily distribution of reports

·         Worked on nprinting trouble shoots.

·         Implemented security using section access that dynamically hides selected areas of dashboard depending up on user privileges

·         Created Objects like List boxes, Multi boxes, slider, buttons, charts, text objects, bookmarks, etc.

·         Developed graphs and pivot tables to summarize the outlying data points to perform exploratory data analysis.

·         Worked with Business Analyst and the Business user to understand the user requirements, layout, and look and feel of the application to be developed.

Environment: Qlik Sense 2.2, Qlikview 11, Nprinting 16.2, Oracle 11g, SQL Server, Informatica Power Center.                                                                                                                                                                                                                       

FannieMae, Reston, VA                                                                                     

January 2014- September 2015

Role

QlikView /Qlik Sense Developer 

Key Responsibilities :

·         Understanding business requirements and translate into application and operational needs using QlikView/Qlik Sense

·         Worked on the documentation for application development. 

·         Installed and configured QlikView Server Small Business Edition. 

·         Involved in extracting, transforming and loading data from sources into QlikView/Qlik Sense applications

·         Generated ODBC Connections to extract from data bases and store them in QVDs.

·         Extracted data from multiple data sources (SQL Server, Excel) and designed data model. 

·         Implemented Star Schema and Snow Flake schema in designing the data model. 

·         Used Link Tables to avoid circular reference and Loop issues. 

·         Implemented Security involved in Deployment of QlikView Applications. 

·         Extensively implemented advanced SET Analysis for aggregation calculations. 

·         Hands on creating templates in Nprinting for daily distribution of reports.

·         Worked on deployment of Qlik Sense dashboards from Dev to UAT and UAT to PROD

·         Modified Existing Login page to Access point to Client Specific Login Page. 

·         Experience in working with Nprinting trouble shoots.

·         Responsible for the performance and tuning of the application, including performing maintenance upgrades on applications programs and systems as required. 

·         Converted Excel and crystal reports to QlikView dashboards. 

·