SUMMARY:

• 7+ Years of experience in Design and Development of QlikView involving UI design, Qlik scripting and Data Modeling.
• Complete life cycle development experience including Requirements gathering, Planning, Analysis, Design, Implementation and Maintenance using QlikView/QlikSense.
• Expertise in Creating QV data models, QV objects, Adhoc Reports and Data Visualizations using different data sources like Oracle, SQL Server, QVD files using incremental load, Access, text files, excel documents as per the user requirement.
• Experience in designing different Dimensional Data Modeling techniques (Star & Snow Flake Schema’s) based on need.
• Worked on multiple Full Life Cycle Developments including Planning, Data Warehousing, Analysis, Design, Implementation, Testing and Production Support for QlikView applications.
• Excellent knowledge in Implementation of Relational Database (OLTP), Data warehousing systems (OLAP), FACT & Dimensions tables, Physical & Logical data modelling, Data Marts.
• Strong experience in developing QlikView Applications by following multi - tier architecture.
• Worked on different complex data models by eliminating closed loops, synthetic keys and ambiguous relationships.
• Experienced in designing interactive dashboards and customized on demand reports using QlikView.
• Experience with QlikView Sheet objects including like multiple Chart types, Bookmarks, Buttons, Containers, Trends, KPI’s, custom reports for Excel Export, Fast Change, Data Islands, variables, calculated expressions and aggregated functions for Management Dashboard reporting.
• Expertise in using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc) and subroutines.
• Implemented data level security using Section access that dynamically hides selected areas of the dashboard & filters data dynamically depending upon user privileges.
• Experienced in Incremental Loading using QVD files for optimizing data models.
• Created Expressions using Set Analysis to improve the calculation times on the UI.
• Expertise in Optimizing QlikView Dashboards with a focus on usability, performance, flexibility, testability, and standardization using Document Analyzer.
• Experience in QlikView Server and Publisher maintenance - scheduling and monitoring Incremental Loads and Report Reloads.
• Expertise in optimizing, debugging and testing SQL queries.
• Developed QlikView Macros/ Triggers in customizing applications using VBScript.
• Experienced in Reduce Data, Distribute QlikView applications on to the Access Point using QlikView Management Console(QMC).
• Expertise in QlikView reporting using NPrinting.
• Worked in environments using Agile and Scrum methodologies.
• Knowledge of Extension Objects.
• Developed QlikSense applications using various Qlik Sense extensions to reach the expectations.
• Excellent analytical, co-ordination, interpersonal, leadership, organizational and problem-solving skills, ability to adapt, learn new technologies and get proficient in them very quickly.

TECHNICAL SKILLS:

Tools: QlikView 10.0/11.0/12.0, QlikSense 2.2/3.1, NPrinting

Databases: SQL Server, Oracle 9i/10g/11g, Teradata

Languages: SQL, C, JAVA

Web Applications: HTML, CSS, Java Script

Operating Systems: Windows XP/Vista/7/8, MS-DOS, Windows 2003, Windows Server 2007.

Test Case Management Tool: HP Quality Center

Methodologies: Agile, Scrum, Waterfall

Others: MS Access 2005, MS-Excel 2013, MS PowerPoint 2007.

PROFESSIONAL EXPERIENCE:

Confidential, Norfolk, VA

QlikView Developer

Responsibilities:

• Evaluate business requirements & perform impact analysis design and develop Qlikview dashboards as per the business requirement.
• Preparing system and unit test plan to ensure all the business logic and implemented correctly.
• Implemented Section access and hidden scripting for the Application Security.
• Designed various types of reports with Complex formulas and Custom Functions.
• Designed reports with conditional formatting, Set analysis etc.
• Monitoring of the QVS (Access Point), QVW’s and user accounts for the usage of the applications.
• Wrote SQL Scripts to load relevant data in Qlikview Applications.
• Implemented the 3-tier architecture (Data Extract, Data Transform, Data model & Application) to develop different dashboards with a complex database system behind it which includes extracting data from the SQL Database and flat files, storing into QVD files, write load scripts, and develop UI according to user requirements.
• Loaded the Extract QVDs into Transform QVWs and performed necessary transformations such as renaming the columns, Apply Maps, text to number or number to text conversions. Also performed Inner Joins, Left Joins and Right Joins to attain the desired resultant Data Set and stored it into Transform QVDs.
• Loaded the Transformed QVD into a QVW and designed the Data Model as per the business requirement.
• Used Apply Maps, Right Joins and Left Joins wherever necessary to reduce the no of tables in the Data Model to aid better performance of the Dashboard.
• Resolved and removed any Circular Loops, Synthetic Keys by renaming or removing unwanted columns, using Qualify statement, performing Join operations and by concatenating the tables, using data islands.
• Designed the Dashboard with various objects such as Pie Charts, Line Charts, Bar Charts, Combo Charts, Gauge Chart, Table Object, Straight Table, Pivot Table, List Box, Multi-Box, Current Selection Box, Buttons, Slider Object, Text Objects, Bookmarks, Calendar Object, Search Object etc.
• Aggregated the day level (Report Date) data to the month level (Report Month) to improve the Performance of the Dashboard.
• Used Drill Down and Cyclic groups in Charts for better Data analysis. Used Set Analysis in the Expressions for various charts.
• Followed best practices by documenting the Field Names and the Expressions in an Excel sheet.
• Involved in Performance Tuning of QlikView dashboard.
• Wrote an Include Script to rename the columns into proper business names for the better understanding of the users.
• Experience in handling large applications with over 20M rows and associated with 98% density.
• Interacted actively with the Testing Team and performed Data Validation, Identified and analyzed the data irregularities and pointed out key solutions.
• Implemented Section Access on the QlikView Application.
• Scheduled Data Extractions, Data Model and Dashboard Reloads using QlikView Management Console (QMC).
• Published the reports to QA environment for the Users to Test.
• Interacted with the Users on a weekly basis to get their feedback and made the requested changes.
• Created and Scheduled Weekly QlikView custom reports extensions to distribute on email using NPrinting.

Environment: QlikView, NPrinting, MS Office, Windows 2008, SQL Server.

Qlik Sense Developer

• Actively involved in requirement gathering sessions with business analysts for Document preparation.
• Involved in designing the data model by gathering data from different data sources like QVD files, Excel, XML, SQL & binary QVW, Inline & txt files in developing QlikSense Dashboards.
• Developed GUI using Extension Objects from Qlik Branch, Variables, charts, Filter pane, map, KPI etc. on Qlik Sense.
• Used a KPI/gauge object which has built in color switching to color code the fonts.
• Used QlikSense Functions (Date and Time, Join, Aggregation, Peek, Previous, Class, FirstSortedValue etc.) and Created Variables using LET, SET or control statements in the scripts.
• Worked with various Sheet Objects, Charts (including Drill Down and Cyclic field grouping), Treemap and Master Calendar.
• Implemented Incremental load for the update of QVD’s, used Set Analysis for aggregations at granular levels.
• Considered best practices of QlikSense and created heat map and KPI graphs.
• Created binary loads for quick reloading of applications.
• Migrated applications from Qlikview environment to Qlik Sense.
• Hands-on experience in implementing new features like Creating Stories , Pivot Table, KPI Object etc. in QlikSense.
• Conducted training sessions to users about the functionality and usage of application.

Environment: QlikSense, MS Office, Windows 2008, SQL Server.

Confidential, WASHINGTON, D.C.

QlikView Developer

Responsibilities:

• Gathered requirements from business users and developed technical specifications.
• Worked on data modeling by extracting data from different data sources like SQL Server, MS Access and flat files as per the business requirements.
• Wrote, Edited and Debugged ETL Scripts for data cleansing, resolving synthetic keys & circular loops.
• Developed dashboard with a complex database system behind it which includes extracting data from SQL Database and flat files, storing into QVD files, write load scripts, and develop UI according to user requirements.
• Developed straight table and bar charts for computing Year Ago, YTD, MTD, WTD measures.
• Designed and developed different types of charts such as bar charts, straight tables, pivot tables, pie charts and gauge chart etc.
• Created different types of sheet objects like list boxes, Buttons, Multibox etc.
• Developed SET ANALYSIS and used macros to provide custom functionality in QlikView Applications.
• Implemented section access, section authorization and sheet access to make the application available to desired users.
• Configured and deployed the applications in the access point using QlikView server/publisher.
• Scheduled jobs for incremental and full loads using publisher.
• Involved in production support for various applications - Failure Analysis using error logs.
• Improved the overall performance of the application and redesigned data model by applying QlikView performance tuning techniques using document analyzer.
• Supported in modifying, testing and implementation of existing reports.
• Communicated and trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.
• Created daily, weekly and monthly reports for the management team based on the client requirements.

Environment: QlikView, NPrinting, MS-Access, SQL Server, MS-Excel, VB Script.

Confidential, RTP, NC

QlikView Developer

Responsibilities:

• Involved in Requirements Gathering, Analysing and Documenting Business and Functional Requirements and Data Specifications for Data Visualization Analytics using QlikView.
• Documented report requests in the form of Functional and Technical specifications.
• Adopted Scrum methodology in the system development process.
• Involved in Optimizing, Debugging and testing SQL queries written in Oracle.
• Created Dynamic & customizable data visualization Models using QlikView against data sources including QVD, MS Excel, SQL Server and Oracle.
• Designed QVWs to generate QVDs for faster and efficient data reloads.
• Created different Metrics, Dimensions, Filters, Search objects, document and field event triggers, multiple charts (scatter, combo, pie, bar, straight, pivot using Drill down & Cyclic groups) and security filters allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales .
• Used QlikView Functions (Date and Time, Keep, Join, Mapping & String etc.) for creating dashboards, and designing the User Interface based on business/user requirements.
• Implemented multiple levels of hierarchies.
• Created User groups & data reduction to apply the data security for users.
• Improved the overall performance of the application and re-designed data model by applying QlikView performance tuning techniques.
• Converted Cognos reports to QlikView dashboards.
• Manage, Schedule and Distribution of QlikView applications using QlikView Management Console (QMC).
• Assisted less experienced Business users in using QlikView applications.
• Tested QlikView Applications and reports using review checklists before delivering to the end users.
• Allowed users with an ability to export/print PDF reports from the application.

Environment: QlikView, SQL, Oracle 11g, CSV files, MS Office.

Confidential, Foster City, CA

QlikView Developer

Responsibilities:

• Worked with business user to understand the user requirements, layout, and look and feel of the application.
• Gathered & loaded data into QlikView from various data sources (SQL SERVER 2008, Oracle 10g, CSV, XML and Excel files).
• Worked on large scale and data volume based applications.
• Provided executives and operational users with powerful analytic capabilities and detailed information on their operational performance.
• Dashboards were served to track inventory and sales as well as to monitor various KPIs. Dashboards included customer detail drilldowns, threshold gauges.
• Developed QlikView Dashboards using Chart Box (Drill & Cyclic Grouping), List, Input Field, Table Box, Buttons and Bookmarks.
• Used Apply Maps, Right Joins and Left Joins wherever necessary to reduce the no of tables in the Data Model to aid better performance of the Dashboard.
• Implemented advanced SET Analysis for aggregation calculations so that set of records can be defined in an expression.
• Used extension objects for creating custom charts in Dashboards.
• Performance tuning by analyzing the QlikView application using document analyzer.
• Developed User Interactive Sheets & on demand Reports as per the business needs.
• Communicated and trained the end users effectively to use the QlikView application, to build and customize their ad-hoc reports.
• Performed different tasks like reload and distribution tasks using the QlikView publisher.
• Scheduled QVW reloads on server and handled troubleshoot errors.
• Rectified irregularities in existing mappings by analyzing the data flow. Redesigned and made necessary changes for improving the performance.
• Migrated existing QlikView 10 dashboards to QlikView 11 environment, also added new QV11 features to the Dashboards.
• Successfully passed through the QA Environment and implemented on Production and worked as post production support.

Environment: QlikView, SQL Server, Oracle, MS Office, HP Quality Center, HTML & Java Script.

Confidential

QlikView Developer

Responsibilities:

• Gathering and documenting requirements from the users and developed Complex Graphical User Interactive reports using various QlikView Objects.
• Strong Skills in Data Modeling & Loading data from multiple data sources.
• Worked with Incremental Loading & QlikView document Versioning.
• Developed executive dashboards in QlikView delivered through the web, enabling to measure the performance of the business with analytical capabilities.
• Experienced in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• Worked on requirement specifications for the strategic KPI's that drive performance and profitability in the division. Waterfall methodologies were followed during course of the project.
• Performed analysis, documentation for calculation of various attributes.
• Performance tuning of dashboards was carried out to limit the response time to well under 2 seconds.
• Implemented Section access and hidden scripting for the Application Security.
• Performed testing of dashboards for functionality, data, performance, look and feel.
• Promoted dashboards to production environment and manage user access.
• Developed Heat map charts with Alternate state for data visualization.
• Developed KPI's, User Interactive Sheets as needed by the business.
• Identified the highly memory consumption objects and performed necessary steps to reduce memory used by objects.
• Analyzed end user requirements and developed technical solutions.

Environment: QlikView, Oracle, MS Access, MS Office.