SUMMARY

• Around 7+ years of IT industry experience in all aspects of Business intelligence applications with a strong background in Database development, Data Warehousing, and business intelligence tools for developing/Administration of various reports using QlikView
• Over 6+ years of experience in designing, developing and deploying of QlikView Applications and Qlik Sense Development
• Experience in developing different analytical applications using QlikView suite of Products (QlikView Desktop, QlikView Server, QlikView Publisher and QlikView Enterprise Management Console).
• Adept in business process improvement, re - engineering, change request management, review process, and reporting escalation.
• Worked on the Dimensional Modeling techniques, Multi-dimensional database Schemas like Star Schema, Snowflake Schema, Fact and Dimensional tables, Section Access, Set Analysis in QlikView and DW concepts.
• Designed and developed the most suitable User Interface such as dashboards, multiple charts types, trends, KPI's, custom requests for excel export and objects for management dashboard reporting.
• Hands on experience on different versions of QlikView … suite of Products.
• Experience with Qlik Sense Desktop and Qlik Sense Cloud platforms.
• Expertise in QlikView Application Development using QlikView Desktop client 11.2 SR2 using different data sources like Oracle, SQL Server, QVD files, text files, excel, XML, HTML pages and generated dashboard as per the user requirements.
• Experience in QlikView Scripting to add additional features on the data and automate tasks.
• Strong knowledge in designing and developing Data marts, Data Warehouse using Multi-dimensional models such as Snow Flake and Star Schema.
• Expertise in training end users in explaining the functionalities of final QlikView application.
• Involved in Performance Tuning & Deployment of QlikView Applications.
• Experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating database objects like tables, constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Explored intensively and implemented QlikView 11 advanced features like Set Analysis, Alternate states, integrating Google Maps, Dimension Limits and creating Ad-Hoc Reports.
• Extensively worked with SQL Queries, and capable of handling Oracle, SQL Server, MS Access databases and also have good experience in database tuning and performance techniques.
• Extensive experience in gathering, managing and documenting business and functional requirements, communicating effectively with upper management, developers, and QA engineers.
• Experience with QlikView sheet objects including multiple charts types, Trends, KPI's, Bookmarks, Pivoting, custom requests for Excel Export, Fast Change and objects for Management Dashboard reporting and other KPI's.
• Good experience in designing and implementing complex reporting solutions using COGNOS Suite 10.2 / 8.4.
• Expert level with developing OLAP models
• Designed and Implemented new dashboards using Cognos workspace
• Good presentation, summarization, structuring and refinement skills. Proven track record of execution capabilities of strategic as well as tactical plans, both within and through functional boundaries.
• Expertise in working with relational databases such as Oracle … SQL Server … DB2 8.0/7.0.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization using QlikView.
• An organized professional with excellent communication and interpersonal skills. Always worked in close association with customers and a single point of contact for many major implementation projects.
• Written SQL queries to test the OLTP & OLAP Databases based on changes of the functionality.
• Expert in Unit, System and User Acceptance Testing and Performed Data Validation for all the reports and dashboards generated from various database sources.
• Strong Communication, Organizational, and Interpersonal Competencies along with Detail-oriented and problem-solving skills in the technology arena.

TECHNICAL SKILLS

Database: Microsoft SQL Server, Oracle, DB2, Teradata, Access.

ETL Tools: SSIS, Informatica

Reporting Tools: Qlikview 8, 9, 10 & 11, Qlik Sense 2.0.2, Crystal Reports, Cognos

Programming: SQL, PL/SQL, HTML, XML, Java, JScript

Tools: Eclipse, MS BIDS, Toad, Excel, SharePoint, CSS

PROFESSIONAL EXPERIENCE

QlikView Developer

Confidential, Whippany, New Jersey

Responsibilities:

• SharePoint data source access and extraction to build dashboards.
• Developing a Star Schema Data Model that suits the business requirements by eliminating synthetic keys and circular loops.
• Develop Dashboard using Bar Charts, Pie Charts, Text Boxes and List Boxes.
• Interacting with end users to gather the functional requirements and customize QlikView dashboards accordingly and involved in developing, enhancing, re-engineering, maintaining, supporting QlikView applications.
• Involved in analyzing the existing data model, script logics and ETL logics for the existing dashboards.
• Manage schedules and reloading of QlikView data model QVDs and QVWs through QlikView Enterprise Management Console (QEMC).
• Automate and schedule daily data loads of QVW documents using QlikView Publisher
• Connect the Database with the Qlikview application and publish in the QlikView Servers.
• Deploy, Maintain the QV Applications/Dashboards to the Development, UAT and into Production environments.
• Create scripts to meet the user requirements and to load the data efficiently.
• Implement the Section access to the application developed and then deploying it to the server.
• Involved in the enhancement of existing dashboards with new functionalities.
• Oversee the development of Qlikview applications.
• Define and maintain architecture and development standards for the Qlikview environment
• Effectively identify and remediate issues and risks that impact the performance and reliability of the Qlikview solution.
• Ensure consistency across applications as they are developed
• Assisted in demoing QlikView application to users and gather feedback at every phase.

Environment: Qlikview 11.2 SR8, MS Excel, Windows 7, QlikView Server and Publisher, SQL Server.

QlikView Developer

Confidential, New York

Responsibilities:

• User Stories review and requirements aggregation.
• Access the SharePoint data source and extracted required data to build dashboards.
• Developing a Star Schema Data Model that suits the business requirements by eliminating synthetic keys and circular loops.
• Develop Dashboard using Bar Charts, Pie Charts, Text Boxes and List Boxes.
• Interacting with end users to gather the functional requirements and customize QlikView dashboards accordingly and involved in developing, enhancing, re-engineering, maintaining, supporting QlikView applications.
• Create complex Set Analysis expressions to meet business requirements and Script level optimizations.
• Extensive backend scripting to extract, transform and use the source data.
• Manage schedules and reloading of QlikView data model QVDs and QVWs through QlikView Enterprise Management Console (QEMC).
• Automate and schedule daily data loads of QVW documents using QlikView Publisher
• Connect the Database with the Qlikview application and publish in the QlikView Servers.
• Deploy, Maintain the QV Applications/Dashboards to the Development, UAT and into Production environments.
• Create scripts to meet the user requirements and to load the data efficiently.
• Implement the Section access to the application developed and then deploying it to the server.
• Involved in the enhancement of existing dashboards with new functionalities.
• Involve in analyzing the existing data model, script logics and ETL logics for the existing dashboards.
• Oversee the development of Qlikview applications.
• Define and maintain architecture and development standards for the Qlikview environment
• Effectively identify and remediate issues and risks that impact the performance and reliability of the Qlikview solution.
• Ensure consistency across applications as they are developed
• Assisted in demoing QlikView application to users and gather feedback at every phase.

Environment: Qlikview 11.2 SR8, MS Excel, Windows 7, QlikView Server and Publisher, SQL Server

QlikView Developer/Data Analyst

Confidential, New York

Responsibilities:

• Worked with the Business user to identify the requirements, business reporting needs, layout and developed the architecture of prioritized reports.
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications
• Followed DAR (Dashboard, Analysis, Reports) methodology to meet the varying requirements of Client.
• Implemented report development methodology for operational analytics group.
• Provided business intelligence guidance to business operation analyst groups.
• Conduct demonstration for business users and interacted with end users.
• Actively participated in clarification meeting with the Clients.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.
• Maintained 3-tier design in the method of developing the ultimate application.
• Identify, propose and implement enhancements over the existing reports to improve the user experience.
• Configured QlikView Server /Publisher. Scheduled jobs, & Security.
• Created and Scheduled Weekly QlikView reports to distribute on email using NPrinting and Publisher.
• QlikView best practices were used in the implementation of scripting, set analysis and usage of variables.
• Interacting with end users to gather the functional requirements and customize QlikView dashboards accordingly and involved in developing, enhancing, re-engineering, maintaining, supporting QlikView applications.
• Designed and Developed QlikView reports, dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box, and Calendar & Date Island meeting the business requirements.
• Worked with Qlik Sense Desktop to provide service data visualization and business intelligence capabilities for the organization.
• Implemented security using QlikView section access that dynamically hides selected areas of the dashboard depending upon user privileges.
• Hands on Experience with QlikView Architecture in development and deployment.
• Managed schedules and reloading of QlikView data model QVDs and QVWs through QlikView Enterprise Management Console (QEMC).
• Automated and scheduled daily data loads of QVW documents using QlikView Publisher
• Utilized Incremental Load concept for the update of QVD's.
• Deployed, Maintain the QV Applications/Dashboards to the Development, Test, UAT and into a Production environment.
• Created QlikView scripts and SQL scripts to load relevant data and uses VB macro and set analysis to create customized reports for regulatory reporting.
• Created and managed ETL script generation using QlikView Script Builder Application.
• Optimizing existing data models including changing load scripts to load data in an optimized way to achieve reduction of loading time, simplifying complex expressions in the front-end, improving layout structure.
• Assisted in demoing QlikView application to users and gather feedback at every phase.
• Worked closely with different business teams to gather requirements, prepare functional and technical documents and UAT Process.
• Code Stored procedures and PL/SQL scripts to load, update data tables.
• Provided Training to different business users to develop dashboards in workspace and workspace advanced.
• Provided end user and production support after deploying the application into the production environment, also provided extensive support for the users on application usage and trained users in the functionality of the software.

Environment: QlikView 11.2, Qlik Sense 2.0.2, Oracle 11g, QlikView Server and Publisher, MS Excel, TOAD, Nprinting, QlikView Enterprise Management Console. HTML, CSS, NPrinting 12.3

QlikView Developer

Confidential, Irving, TX

Responsibilities:

• Involved in Business requirement gathering and Participated in Joint Application Development (JAD) process with different Business Segments in designing QlikView Applications.
• Worked with business analyst to gather requirements.
• Extracted data from the SQL Server database wrote SQL load scripts and used joins to join the tables.
• Developed a Star Schema Data Model that suits the business requirements by eliminating synthetic keys and circular loops.
• Developed Dashboard using Bar Charts, Line Chart, Text Boxes and List Boxes.
• Used Alternate States and Set Analysis to get the needs of the end users.
• Used QVD generator QVW file to create the QVD's. In the QVD generator file, the data is imported from the SQL Server.
• Used Document level and Field level triggers based on the requirements.
• Good experience in using the QlikView functions (Trim, Match, Like, String etc.)
• Implemented HTML along with CSS to define the web pages.
• Implementing the Section access to the application developed and then deploying it to the server.
• Involved in the enhancement of existing dashboards with new functionalities.
• Involved in analyzing the existing data model, script logics and ETL logics for the existing dashboards
• Oversee the development of Qlikview applications
• Define and maintain architecture and development standards for the Qlikview environment
• Maintain and execute the technology roadmap for the Qlikview environment
• Effectively identify and remediate issues and risks that impact the performance and reliability of the Qlikview solution.
• Ensure consistency across applications as they are developed
• Perform Qlikview Upgrade and fresh Installations
• User and License Management and Server Performance and Health monitoring
• Scheduled Weekly QlikView reports using NPrinting and Publisher and distributed to users in the form of PDF and Excel.

Environment: Qlikview 9.5/10, MS SQL 2005/2008, SAP, CSV files,, Windows NT/2000/XP, SSIS, SSRS, SSAS, MS Access, MS Excel, Visio 2007, DTS, Crystal Reports, HTML, CSS, NPrinting.

QlikView Developer

Confidential

Responsibilities:

• Coordinated meetings with business users and development teams to gather System requirements and data requirements.
• Involved in design, development and documentation in various phases of product life cycle.
• Conducted discussions with Business Analysts (BAs) and end users to create several test scenarios for running the reports.
• Developed QlikView transformation Scripts.
• Use of Jscript to enable features in the presentation web pages.
• Strong Knowledge in designing and developing Data marts, Data Warehouse using Multi-dimensional models such as Snow Flake and Star Schema.
• Implemented Data-Extract, Data-Modeling, and Application Development in QlikView.
• Developed Alerts, Variables, Input boxes, calendar & Macros.
• Gathered & loaded data into QlikView from various data sources (SQL SERVER, Oracle 10g, .CSV and excel files).
• Worked with Installation and Configuration of QlikView.
• Developed QlikView Dashboards and used QlikView Functions.
• Added the access management by creating users, user groups and folders.
• Implemented security features in QlikView using Section Access at the document level.
• Performed unit testing, system testing and user acceptance testing (UAT) for reports

Environment: QlikView v8.5, Oracle 10g, SQL Server Access.

SQL Developer and Qlikview Analyst

Confidential

Responsibilities:

• Experience in designing the layout of the application as per the business requirements of the client.
• Experience in Analyzing all business functionality related to back-end database interfaces.
• Wrote scripts and created batch files for automatic running of Qlikview scripts.
• Generated Qlikview reports using data from multiple sources including Oracle, SQL Server and flat files (text, excel, and XML).
• Hands on experience with Qlikview scripting.
• Altered the Qlikview scripts based on any unusual latency in the response time on the UI.
• Responsible for scheduling BATCH process for reloading the application as per the client's need.
• Analyzed and designed tables based on small and large database transactions.
• Created Materialized Views to reduce query run time for the end user.
• Gathering user requirements and designing Database accordingly which involves creating Logical Data model and Physical Data modeling.
• Used SQL for implementing business rules and do performance tuning procedures.
• Creating many physical objects (table, constraints, index, function) to facilitate the smooth data retrieval
• Designing, Developing & Fine Tuning data-retrieval & data migration scripts.
• Involved in Interacting with users, error fixing by enhancing SQL packages, stored procedures & functions.
• Data conversion from flat file to intermediate tables using SQL*Loader and also created control files for SQL*Loader.
• Developed comprehensive reports, cross reference listings and statistical reports using Oracle Reports/Graphics, complex SQL queries (with all kind of joins and groupings, etc.).
• Created custom folders, item classes in Discoverer Administration, cross tab, page detail reports, conditions, parameters, sharing of workbooks in Desktop edition of 4i.
• Trained End User's to familiarize with Discoverer Plus and Viewer Tool.
• Designed and developed the user interfaces in Forms 6i to maintain sale transactions, receipt generation and dealer wise reports.
• Closely worked with DBA in monitoring the performance related issues using SQL Trace and TKPROF utility
• Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.

Environment: SQL Server 2000 Enterprise Edition, Windows 2000/NT, UNIX, Excel, SQL Profiler, Replication, DTS, MS Access, T-SQL, Crystal Reports, Qlikview, TOAD.

SQL Developer

Confidential

Responsibilities:

• Gathering user requirements and designing Database accordingly which involves creating Logical Data model and Physical Data modeling.
• Used SQL for implementing business rules and do performance tuning procedures.
• Creating many physical objects (table, constraints, index, function) to facilitate the smooth data retrieval
• Loading data into the intermediate tables using UTL FILE and SQL Loader.
• Designing, Developing & Fine Tuning data-retrieval & data-migration scripts.
• Involved in Interacting with users, error fixing by enhancing SQL packages, stored procedures & functions.
• Data conversion from flat file to intermediate tables using SQL*Loader and also created control files for SQL*Loader.
• Developed comprehensive reports, cross reference listings and statistical reports using Oracle Reports/Graphics, complex SQL queries (with all kind of joins and groupings, etc.).
• Created custom folders, item classes in Discoverer Administration, cross tab, page detail reports, conditions, parameters, sharing of workbooks in Desktop edition of 4i.
• Trained End User's to familiarize with Discoverer Plus and Viewer Tool.
• Designed and developed the user interfaces in Forms 6i to maintain sale transactions, receipt generation and dealer wise reports.
• Closely worked with DBA in monitoring the performance related issues using SQL Trace and TKPROF utility
• Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.

Environment: Reports 6i, Forms6i, Discoverer, Windows, Toad, ER Win, SQL Developer and SQL * Loader