SUMMARY

• 7 years of experience in architecture, development, and deployment of information delivery systems with extensive focus on Data Warehouse/Business Intelligence using QlikView Business Objects.
• Domain experience includes Retail, Insurance, advertisement and Banking.
• 4+ years of experience in Full Life Cycle Development including Analysis, Design, Implementation and Maintenance of different analytical applications using QlikView Products (QlikView Server, Publisher and QlikView Desktop).
• Developed QlikView Dashboards using Chart (Drill down & Cyclic Grouping), List Box, Input Field, Table Box and Calendar & Date Island.
• Extensive experience in Prototyping Qlik Sense dashboards using Story Telling, Beta maps integrations, Pivot Table, KPI Object etc. For evaluation to Business.
• Solid hands on experience designing mobile friendly dashboards using Qlik Sense.
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc.
• Hands on retrieving of external data to QlikView Dashboard in terms of QVDs by making connection through ODBC and OLEDB.
• Hands on experience in formulating KPI's within Qlikview using functions and set analysis.
• Experience in designing QlikView Document/User Setting, Layouts to make consistent and professional optimized look to clients.
• 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.
• Created QVD’s & updated on timely basis as database updates. Developed ETL Scripts while loading the data, resolved Circular Relationships, Synthetic Keys.
• 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
• Developed Complex Graphical User Interactive reports using various QlikView Objects.
• Experience in Data Modeling along with resolving Synthetic Key and Circular Loop issues.
• Outstanding ability to translate business requirements into effective business intelligence solutions.
• Good at performance tuning by analyzing and comparing the turnaround times between SQL and QlikView.
• Strong Database development experience in writing functions, packages, procedures, triggers and views in PL/SQL.
• Experience in implementing and supporting production of Qlikview apps.
• Experience in Unit, System and User Acceptance Testing and Performed Data Validation for all the reports and dashboards generated from various database sources.

TECHNICAL SKILLS

Reporting Tools: QlikView 9.x, 10.x, 11.x seriesLanguages C, Visual Basic, Unix Shell scripting and SQL

Databases: GreenPlum, Teradata, DB2, MS SQL Server 2012 and Oracle

Tools: / Utilities Pg. Admin, TOAD, Visio, Jira, Wiki

Scheduler: OPSWise, Cronacle

Configuration Mngt Tools: VSS

Operating System: UNIX, Linux, WINDOWS ... server

Software Development: Agile Methodology

PROFESSIONAL EXPERIENCE

QlikView Developer

Confidential - Mahwah

Responsibilities:

• Understanding the requirements from the users. Suggested better way of presenting charts, which are accepted and successfully implemented in the dashboards.
• Providing executives and operational users with powerful analytic capabilities and detailed information on their operational and marketing performance.
• Involved in designing, developing, testing, publishing, maintaining and supporting QlikView and Qlik Sense applications
• Involved in designing and construction of the Data model and implemented the Star schema for QV better optimization.
• Created dashboard style of layouts using different components of QlikView Enterprise such as List boxes, Multi boxes, slider, current selections box, buttons, text objects, bookmarks, etc.
• Developed different KPI's as per requirement using advanced set analysis.
• Good knowledge of deploying Qlik Sense dashboards on the Sense Server.
• Involved in Dashboard migrations from Qlikview to Qlik Sense.
• Created dashboards using various sheet objects such as pie charts, bar charts, trend analysis, and Straight tables.
• Developed dashboards pertaining to Revenue and Sales monitoring using QlikView 11 SR2.
• Connected to different ODBC, OLE DB data sources (SQL Server, Oracle, and RDW) and flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components of QlikView.
• Developed complex SET ANALYSIS to provide custom functionality in QlikView(TM) Applications.
• Closely worked with the release management team to facilitate smooth deployments of QlikView documents in addition also helped with database administration and development.
• Extracted data from multiple complex hierarchies from cross table flat files and websites.
• Incremental reloading is implemented.
• Created Document for the project planning and production Interface Documentation.
• Four dashboards were created, along with helping other team to create QlikView reports.
• Successfully passed through the QA Environment and implemented on Production and currently working as post production support.

Environment: QlikView 11 SR2, Netezza, Toad, Windows 7, Windows Server 2008.

QlikView Developer/ Consultant

Confidential - NY

Responsibilities:

• Worked with Business Analyst and Business user to understand the user requirements, layout, and look and feel of the application to be developed.
• Two Dashboards were developed and served to track all the way through Ship to Final acceptance phase, which include Installation.
• Developed Proof of Concepts (POC) for various projects using QlikView and Qlik Sense.
• Gained experience in creating mobile friendly applications using Qlik Sense.
• Presented the Dashboard to Business users and cross functional teams, define KPIs (Key Performance Indicators), and identify data sources.
• A master calendar was used for time related dimensions and a strong source control methodology was used for tracking changes.
• There were 4 million records with incremental loading on daily basis.
• Enhancement and translation of the existing Dashboards in micro strategy into QlikView.
• Extensively worked with Set Analysis.
• Implement Actions/Triggers in the QlikView interface.
• Used conditional statements, dynamic actions, conditional show or hide of objects or fields.
• Involved in Performance Tuning & Deployment of QlikView Applications.
• Worked with QlikView 10.x, SQL Server, Oracle, DB2, Excel, flat files.
• Helped end users to design test cases and worked through multiple UAT cycles.

Environment: QlikView 10.x, flat files, Oracle 11g, Access, Windows XP Professional.

QlikView Developer/ Consultant

Confidential - NY

Responsibilities:

• Interacted with End Users and Documented the Requirements.
• Developed various internal prototypes for acceptance testing. Followed the agile pattern of working and work execution.
• Worked on data model according to the user requirement and successfully created an optimized QlikView application.
• Played a part a Business support solution provider and closely work under the environment of WAR room meeting, complete brain storming.
• Connected to multiple data sources such as Oracle, DB2, Flat files, Excel Spreadsheet's and prepared close to business requirement like model. (Especially star model and snowflake).
• Established a Standard structure for Test and working files (QVW) and version controlling to maintain clarity between production and Test environment.
• Implemented 3-Layer architecture, Binary loads and Incremental Loads for optimal performance of the Dashboard reloads, rescaling and to adhere to data retention standards.
• Incorporated necessary log files and failure mailing mechanisms for smooth day to day operations.
• Developed dashboards and KPI's using set analysis, variable creation.
• Performed testing of dashboards for functionality, data, performance, and UI design.
• Created weekly PDF report distribution for a set of users using Loop and Reduce functionality through QV Publisher.

Environment: QlikView 9, Oracle 9i/10G/11G, SQL Server 2008, Access, CSV Files, Windows 2008 Server.

Confidential

SQL Developer

Responsibilities:

• Supported all production operation activities, with focus on integration and development of new and existing products and services.
• Liaised with project management and development teams to identify and implement reporting, control, and automation opportunities to improve overall access to information.
• Assisted new and existing clients with integration and data conversion activities.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Provide database coding to support business applications using Sybase T-SQL.
• Perform quality assurance and testing of SQL server environment.
• Identified data issues and provided recommendations for resolution to ensure optimal performance.
• Aided in development, execution, and maintenance of disaster recovery plans for all data services.

SQL Developer

Confidential

Responsibilities:

• Created, manipulated and supported the SQL Server databases.
• Involved in the Data modeling, Physical and Logical Design of Database
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Stored procedures and triggers were used to implement business rules.
• Helped in integration of the front end with the SQL Server backend.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Imported & Exported data from one server to other servers using tools like Data Transformation Services(DTS)
• Explored the use of User Defined Functions to encapsulate commonly used logic in the stored procedure and maximized the readability of such Stored Procedures.
• Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries and Stored Procedures. Optimized query performance by creating indexes.
• Performed daily database backup & restoration, monitored the performance of the Server.
• Handled development and production support, document reviews, test plan, integration of the system.

Environment: MS SQL Server 2000, Windows server 2003, Enterprise Manager, MS Access, MS Excel, MS Word, Windows 98/NT/2000, T-SQL, DTS, Query Analyzer, SQL Profiler