SUMMARY

• Overall 8+ years of experience in analysis, design, development, implementation and testing of Enterprise Wide Applications, including 5+ years of experience in Installing, Configuring, Administrating and generating reports using QlikView and Qlik Sense. Writing scripts to build a relational data model within QlikView from multiple sources.
• Experience in full life cycle project development, including design, coding, testing and implementation with ongoing product support.
• Designing star / snowflake schema and hierarchies for best practices.
• Writing Macros / Set Analysis / variables to expand QlikView functions, add user - friendly features, and build reusable master framework.
• Setting up QlikView security for applications and data reduction by business sectors.
• Implementing QlikView Desktop and Server, managing user authorization, establishing Publisher tasks, streamlining loading procedures, and reviewing logs.
• Solid understanding of QVD / QVW / QVS usage and QMC / QEMC management.
• Implemented the 3-tier architecture (Data-Extract, Data-Modeling and Application Development) as recommended in QlikView best practices guide.
• Experienced in implementing Incremental Loading for various projects using the QVD Files (QlikView Data Files) which would make the QlikView Dashboards to work efficiently.
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Data Island.
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc.).
• Built customized QVD generator to reload the selected QVD’s & updated on timely basis as database updates.
• Experience in performing detailed analysis of source system data and model that data in QlikView.
• Developed Stored Procedures, Views and Synonyms to support dashboards in QlikView.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Involved in Requirement gathering & designing QlikView applications.
• Training users to use designed GUI and create personal objects
• Good communication, collaboration & team building skills with proficiency at grasping new technical concepts quickly and utilize the same in a productive manner.
• Experience includes involvement in all phases of Software Development Life Cycle. E.g Waterfall model, Agile Methodology etc.

TECHNICAL SKILLS

BI Tools: QlikView 11.2/11.0/10/9 , Qlik Sense, OBIEE 10g

ETL Tools: Informatica Power Center

Databases: Oracle 11g/10g/9i/8i, MS SQL Server, MS Access

Other Database Tools: SQL Developer, Toad

Operating Systems: Windows7/XP/00, Windows Server 03/08, UNIX

Web Technologies: HTML, DHTML and XML

PROFESSIONAL EXPERIENCE

Confidential, Warren - NJ

QlikView/Qliksense Developer

Responsibilities:

• Developed, enhanced, re-engineered, maintained and supported QlikView applications.
• Defined standard themes and color coding schemes to improve the look and feel of 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.
• Designed Executive Sales Analysis Dashboard that offers fast and flexible access to all key information across the enterprise.
• Involved in full project life cycle implementation (requirement gathering to production) of QlikView dashboards.
• Managed Qlik Sense QMC security, setting up groups, streams, and managed resources.
• Built Qlik Sense accelerator applications by defining the re-usable content libraries for Dimensions, Measures and Visualizations.
• Extensively worked with QlikView functions, objects, Set Analysis, Variables to generate different kinds of charts. Also generated QVD files by writing scripts in QlikView applications.
• Integration of QlikView reports with web applications to view dashboards dynamically in the web pages along with the application.
• Implemented security using QlikView section access that dynamically hides selected areas of the dashboard depending upon user privileges
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros
• Worked on Publisher to Automate and scheduled daily/weekly/monthly data loads of QVW documents and error notifications by email to assigned users.
• Published Client application using QlikView Publisher and rolled out to Access point and administered security using Active Directory technology/Access DB integration.
• Writing SQL Scripts to load the relevant Data in QlikView Applications.
• Created QVD’s& updated on timely basis as database updates...
• Integrated QVW within existing windows based, Net application using OCX controls. Preferences have been stored using custom code.
• Migration from QlikView 10 to QlikView 11
• Hands on Experience with QlikView Architecture in development and deployment
• Involved in Production Support for QlikView applications &Server.
• Maintained user guides and documentation for QlikView applications.

Environment: QlikView 11.2/11, Qlik Sense, SQL server, EDW, Microsoft Visual Studio

Confidential - Round Rock, Texas

QlikView Developer

Responsibilities:

• Involved in analyzing existing complex systems to understand and document data elements, relationships, data flow, dependencies and related interfaces.
• Involved in installing the latest versions of QlikView, recently migrated from QlikView 10 to QlikView 11.0 SR2 Release.
• Developed QlikView Dashboards using different Chart, Drill through, Cyclic Groups, List, Input Field, Table Box, Container, etc.,
• Implemented security anddeployedQlikView Applications.
• Created dashboards style of reports using QlikView components like Slider, Buttons, Charts and Bookmarks.
• Developed and implemented the Incremental Loading using QVDs so that instead of reloading the entire data from the database, QlikView would only load the data worth of one day and concatenate it to the Old Data which is already stored in QVDs.
• Developed the Data-Model using various data sources like Oracle 11g/DB2 Database, XML and Excel Sheets.
• Utilized groups, conditional display’s using variables and calculations.
• Performed optimization using incremental load (Insert, update and delete) and field trimming.
• Involved in building QVD's and QVW’s applying business rules and data validations Job.
• Involved in gathering customer business and technical requirements and write high-quality requirements documents.
• Involved in creating Publisher Tasks in QMC for the QlikView Application to Reload and Distribute the QlikView Application on to the Access Point.
• Developed analytical dashboards and reporting that meet customer requirements.
• Performed Knowledge Transfer to the Users.
• Worked with client staff to enable them to utilize theQlikViewapplications

Environment: QlikView 11.0, Oracle 11g, Toad 8.5.1, Windows XP.

Confidential, Minneapolis

QlikView Developer

Responsibilities:

• Involved in Requirement gathering & designing QlikView applications.
• Worked with the team to identify the business reporting needs and studied current reporting practices outside of QlikView through pivot tables.
• Participated on business requirement document preparation.
• Developed different dashboard with a complex database system behind it, which includes extracting data from the database, storing into QVD files, write load scripts, and develop UI according to user requirements.
• 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 QlikView.
• Enhance existing dashboards with new functionalities and Tune ETL scripts for better performance.
• Participated in Scrum stand up meetings..
• Maintained and updated the dashboard reports as required by client.
• Conducted and guided QlikView BI application global roll out, managed QA Testing, User Acceptance Testing, software update, migration deployment and parallel run, stabilizing the server platform and application to achieve the steady state for transitioning.
• Designed dashboards identifying the KPIs and to support the time comparison between budgets and actual.
• Designed Executive Sales Analysis Dashboard that offers fast and flexible access to all key information across the enterprise.
• Implemented security using QlikView section access technology that dynamically hides selected areas of the dashboard depending upon user privileges.
• Maintained user guides and documentation for QlikView applications.

Environment: QlikView 11.0/10.0, Windows 2008 R2 Server, MS Access 2005, Oracle 10g, SQLserver 2008, SQL Server Management Studio, Toad.

Confidential, San Antonio, TX

PL/SQL Developer

Responsibilities:

• Involved in full development cycle of Planning, Analysis, Design, Development, Testingand Implementation.
• Designed logical and physical data models for star and snowflake schemas usingErwin.
• Wrote sequences for automatic generation of unique keys to supportprimary and foreign key constraints in data conversions.
• Created and modified SQL*Plus, PL/SQL and SQL*Loader scriptsfor data conversions.
• Upgraded Oracle 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 with PL/SQL to develop and modify web forms.
• Designed Data Modeling, Design Specifications and to analyze Dependencies.
• Creating in dexeson tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.

Environment: SQL, PL/SQL, Crystal Reports, Business Intelligence, Oracle 9i, UNIX Shell Scripting