SUMMARY:

• 9+ years of professional IT experience wif 5 years of rich experience in Qlikview designing, development and reporting, along wif good exposure to different Qliksense 1.0/2.04.
• Excellent understanding of data warehouse specific Architecture, Design and Procedures, ETL and workflow development, data cleansing, data quality validation and unit testing.
• Expertise in QlikView 11.0 SR1/10.0 SR3 installation and upgrading existing version.
• Installed, Configured and deployed teh 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 and Objects.
• Experience in Incremental Loading & QlikView /Qliksense document Versioning.
• Involvement in bettering existing QlikView dashboards wif a focus on user friendliness, performance, long term usability, flexibility, as well as standardization.
• Experience wif 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 wif Data Warehousing and business intelligence tools for developing various Dashboards using QlikView/Qliksense BI.
• 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 teh Business users “On How to Interpret” teh data in Qlikview/Qliksense during teh initial phase of teh Project.
• Implemented security in QlikView/Qliksense Applications at Document and Server Level.
• Gatheird 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.
• Experience in working wif various types of charts (Line chart, Bar chart, Pie chart, Gauge charts, Straight/Pivot Tables, Scatter Plot etc.).
• Experience in creating Data Extraction scripts for creating QVD’s, QlikView/Qliksense Scripting variables, file, date, system, Mapping and Table functions.
• Experienced in working wif many complex SQL queries wif Joins, Date functions, Inline functions, and Sub - queries to generate reports.
• Hands on experience on MS Visio, MS Project, MS Outlook, MS Power point, MS Excel (pivot tables and pivot charts), MS Word and MS Access.
• Hands on experience in analyzing, testing, gathering and documenting requirements.
• Experience in MS SQL Server (BI) and SQL Programming.
• Implemented Conditional Reporting (Ad Hoc Reports to give users teh flexibility to choose what they want to see) which is new QV feature.
• Implemented Alternate states, to perform comparative analysis and derive insights into teh data.
• Identify, propose and implement enhancements over teh existing reports to improve user experience.
• Prepared QlikSense proof of concepts as per teh requirements and specifications.
• Involved in Dashboard migrations from QlikView to QlikSense.
• Created Master Library wif teh dimensions, Measures and Visualizations.
• Developed applications in Sense Desktop as well as in teh Qlik Sense Hub and shared teh apps wif teh team through Qlik Sense Cloud.

TECHNICAL SKILLS

Business Intelligence: QlikView 10/11, Qliksense 1.0/2.0/2.04

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

Sr.Qliksense Developer

Responsibilities

• Gatheird data sources like QVD files, Excel, Inline & txt files in developing teh Qliksense Data Models.
• Worked on modeling data as per business requirements. Eliminated Synthetic keys, ambiguous relationships and closed loops.
• Developed Dashboards by creating KPI’s and set analysis expressions.
• Developed Qliksense Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Data Island.
• Performed Task set up using QMC and created architecture for teh interdependent applications and execute in proper order.
• Created Dashboard using different components of Qliksense like listboxes, multiboxes, slider, buttons, charts (Bar, Line, Combo, Gauge, Scatter, Straight/Pivot table).
• Performed troubleshooting teh technical problems and provided ongoing Qliksense consultation to teh development team.
• Developed User Interactive Sheets & Reports as business needs.
• Created Master Library wif teh dimensions, Measures and Visualizations.
• Enhance existing dashboards wif new functionalities and Tune ETL scripts for better performance.
• Supervised adhoc tasks sent by client.
• Provided production support and solved production issues after application gets published.

Confidential

Sr.Qlikview Developer

Responsibilities

• Reversed complex expressions using Set analysis and various QlikView functions.
• Designed dashboards wif various levels of complexity including different kinds of charts and extensions
• Designed an applications for to support teh lending process and dashboard style of layouts using different components of QlikView Enterprise
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using teh QlikView Publisher
• Analysed scheduled QVW reloads on Server/Publisher by creating tasks in teh Source Documents. Used Loop and reduce concept for creating multiple apps based on teh field.
• Debugged QlikView applications for analysis reports from multiple data source.
• Implemented tasks of QVD generation at regular intervals and appropriate dependencies.

Confidential

Sr. Qliksense Data Architect

Responsibilities

• Hands on experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc...)
• Designed User Interactive Sheets & Reports as business needs.
• Developed SQL Scripts to load teh relevant Data in QlikView Applications.
• Performed SET ANALYSIS to provide custom functionality in QlikView Applications.
• Automated and scheduled daily/weekly/monthly data loads of QVW documents using QlikView Publisher and notified load status by email.
• Carried performance tuning by analyzing and comparing teh turnaround times between SQL and QlikView.
• Handled existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in teh front-end, improving layout structure.

Confidential, Jersey City - NJ

Sr Qlikview - Developer

Responsibilities

• Designed different sets of reports and interacting wif client for requirement analysis and delivery project of QlikView application.
• Written complex expressions using Set analysis and various QlikView functions.
• Designed and developed dashboards wif 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 teh 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 teh QlikView Publisher
• Scheduled QVW reloads on Server/Publisher by creating tasks in teh Source Documents. Used Loop and reduce concept for creating multiple apps based on teh field.
• Creating QlikView applications for analysis reports from multiple data source.
• Implemented tasks to schedule QVD generation and Dashboard refreshes at regular intervals and appropriate dependencies.
• Built complex expressions using set analysis and functions in support of teh dashboards.
• Maintenance of data in form of QlikView data files, pulling teh data from relevant database.
• Process analysis and process mapping wif respect to project.
• To supervise adhoc tasks sent by client.
• Contribute to high levels of professionalism and intellect necessary for continuous improvement of project.
• Dashboard analysis portfolio by profit low to high and doing research for poor performance for revenue growth.
• Handled teh end-to-end implementation of QlikView dashboard deployment.
• Implemented incremental load by creating QVDs and optimized teh periodic data additions.
• Scheduling teh automation of QV jobs using QlikView Management Console.
• Designed application for Sales & Marketing Modules that Generates GUI Report for easy access through teh data.
• Worked wif QlikView/Qliksense administrator to optimize QlikView performance.
• Prepared Qlikview proof of concepts as per teh requirements and specifications.
• Involved in Dashboard migrations from QlikView to QlikSense.

Confidential - Jersey City, NJ

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 teh QlikView Data Models.
• Involved in optimizing teh existing data models and load scripts to improve teh performance.
• 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 teh basic components of QlikView.
• Created weekly PDF report distribution for a set of users using PDF Distribution functionality in QV Publisher.
• Implemented Direct Discovery Feature extensively in order to fetch teh Live Data from a huge fact table that consist of Detail grain of data.
• Task set up are done using QMC and created architecture for teh interdependent applications and execute in proper order.
• Ad hoc excel reports are created based on teh business user requirements.
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Data Island.
• Developed Dashboards by creating KPI’s and set analysis expressions.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using teh QlikView publisher.
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc...)
• Developed SQL Scripts to load teh relevant Data in QlikView Applications.
• Developed SET ANALYSIS to provide custom functionality in QlikView Applications.
• Automated and scheduled daily/weekly/monthly data loads of QVW documents using QlikView Publisher and notified load status by email.
• Performance tuning by analyzing and comparing teh turnaround times between SQL and QlikView.
• Optimizing existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in teh front-end, improving layout structure.

Confidential, Boston - MA

PL/SQL Developer

Responsibilities:

• Involved in performance tuning of stored procedures and SQL queries.
• Wrote sequences for automatic generation of unique keys to supportprimary and foreign key constraints in data conversions.
• Created and modifiedSQL*Plus, PL/SQLandSQL*Loader scriptsfor data conversions.
• UpgradedOracle 9i to 10gsoftware in different environments for latest features and also tested databases.
• Developed and modifiedtriggers, packages, functionsandstored proceduresfor data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• WroteSQL, PL/SQL, SQL*Plusprograms required to retrieve data using cursors and exception handling.
• Worked onXMLalong wif PL/SQL to develop and modify web forms.
• Designed Data Modeling, Design Specifications and to analyzeDependencies.
• Creatingindexeson tables to improve teh performance by eliminating teh full table scans and views for hiding teh actual tables and to eliminate teh complexity of teh large queries.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases usingOracle Hints, for Rule based optimization.

Confidential - Bridgewater, NJ

Business Analyst

Responsibilities:

• Documented teh requirements and prepared various Business Requirement Documents.
• Worked on teh Requirements Gathering phase for all teh Health Care Transactions.
• Worked extensively on MS Access database and maintained and updated requirements
• Prepared Test Scripts and Test Scenarios to validate teh requirements gatheird.
• Performed Manual Testing to validate that all teh requirements were met and implemented.
• Created Business Flow Diagrams, UML Activity diagrams and USE case diagrams.
• Used Microsoft Visio to create various use case models, use cases and UML diagrams.
• Maintained Change Request forms and issues on teh Access Database.
• Prepared User Manuals for better understanding of teh application by its users.
• Organized in Joint Application Development (JAD) sessions, presentations and participated in interview sessions to collect information.
• Prepared Business Requirements and General System Design Documents and presented them to teh clients.
• Trained New Employees on teh project as their mentor/ new hire support for teh first few weeks of new employees.
• Documented teh Functional Specifications for all teh Requirements as well as teh Test Scripts on teh Access Database.
• Review, analyze and extract system information from technical and business documentation to develop functional and data requirement.