SUMMARY

• Around 7 years of IT industry experience as Database Developer with level of competency in SQL, PL/SQL and QlikView BI tool.
• Around 5+ years of QlikView experience in QlikView Desktop/Server/Publisher in aspects of development, deployment and administration.
• Expertise in designing, implementing and maintaining QlikView Applications and test QlikView dashboards to meet customer requirements.
• Experienced in QlikView Scripting resolving Circular Relationships, Synthetic Keys and good hands on QVD s, Calendar Object, custom scripting to implement SQL Functionalities.
• Worked extensively on extracting data from various data sources like QVD files, Oracle - EBS, Excel, CSV File, Flat files and Web.
• Strong experience in UI Design by using different QlikView sheet objects in creating user friendly and interactive Pie charts, Bar charts, Line charts, Detail tables, Buttons, Slider Objects etc.
• Worked extensively on Set Analysis, wrote and resolved complex macros issues with Excellent logical, analytical & debugging skills and Updated QVD's on timely basis as database updates using Incremental Load Concepts.
• Expertise in using Applied Mapping Function to eliminate certain dimension tables and reduce the clutter in the QlikView data model.
• Good at identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so dat business needs meet.
• Expertise in Creating QlikView Reports for Claims, Finance, Sales and Production modules.
• Good noledge on providing several levels of security using Section Access & Publisher.
• Good at Performance tuning, by analyzing and comparing the turn around times between SQL and QlikView.
• Has clear understanding of Data Warehousing concepts with emphasis on star and snowflake schemas, Fact and dimensional tables.
• Experience in MS SQL Server Installation, Configuration, Upgrading, Performance Tuning, Query Optimization, Backup/Recovery.
• Experienced in creating sophisticated Packages and Stored Procedures supporting complex design requirements.
• Possesses good leadership qualities, good Interpersonal skills, team-working attitude, takes initiatives and very proactive in solving problems and providing best solutions.
• Excellent written, oral communication and interpersonal skills.

TECHNICAL SKILLS

Databases: Oracle 9i/10g/11g, R12 EBS, SQL Server 2008, Netezza.

Tools: QlikView 10.0/11.0,11.2 SR6, SQL Developer.

Languages: SQL, PL/SQL, Transact SQL, ANSI SQL, C, C++.

Web Applications: HTML, CSS, AJAX, Java Script.

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

Others: MS Access 2005, MS-Excel 2013, MS Visio 2010.

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

QlikView Developer

RESPONSIBILITIES:

• Effectively collected reporting requirements from business users via one - on-one or group sessions, authoring Business Requirements Document and functional documents and work directly with BI team members in defining needs and reporting requirements.
• Successfully shared findings with executives for business and data analysis by creating QlikView dashboards and ad-hoc reports.
• Extensively worked with Script development, script functions, script variables, inline load, QVWs, QVDs, set analysis and section access.
• Successful in QlikView Server setup, security implementation and management, operational source data connectivity.
• Successfully developed Expressions, Variables, Triggers and Macros.
• Effectively utilized advanced scripting, alternate states for Comparative Analysis, Set Analysis, VBScript and JavaScript macros, advanced aggregation functions and advanced charts for applications.
• Effectively enabled End Users/Business Process Analysts/Functional Analysts to leverage the benefits of Business Intelligence tools and also involved in conducting training sessions.
• Worked successfully with QlikView Enterprise Management Console (QEMC) and also managed scheduling and reloading of QlikView data model, QVDs and QVWs.
• Participated effectively in performance tuning of dashboards to limit the response time and enhance the functionality.
• Hands on experience in QlikView Server management like Managing QlikView Console operations, application distribution, creating and scheduling reload jobs, security management, and License management.
• Successfully created section access code and binary loads for un-compromised security and quick reloading of applications.
• Successfully created Testing applications, reports using review checklists, data quality for quality assurance before delivering to the end users.

ENVIRONMENT: QlikView 11.0, Oracle 10g, SQL Developer, Oracle Database, QlikView Server, QlikView Publisher and QlikView Developer.

Confidential, IL

QlikView Developer

RESPONSIBILITIES:

• Worked effectively to confirm and clarify the business requirements and came up with the technical specifications.
• Developed dashboards related to Claims and Finance.
• Worked extensively in creating tasks, scheduling reloads and deployed Qlikview applications into access point and performed GUI testing.
• Worked extensively and implemented performance tuning dat offers fast and flexible access to all key information across the enterprise.
• Worked effectively to develop load scripts with multiple data sources (SQL, Excel, MS Access and .CSV Files, macros).
• Implementing Extraction, Transformation, Loading and Trouble shooting as hierarchy model.
• Used different components of QlikView Enterprise, like List boxes, Multiboxes, slider, current selections box, buttons, charts, text objects and bookmarks to develop different applications to support the lending process and dashboard style of layouts.
• Extensively used QlikView Publisher and performed different tasks like repeat tasks, reload tasks and distribution tasks.
• Successful in developing SQL Scripts, database objects, procedures, functions and packages to check supplied data for sense, consistency and accuracy.
• Imported data from different sources like DB2, Oracle, SQL Server, MS Access, XML files, QVDs and flat files using OLE DB/ODBC/ and deployed the application on QlikView server.
• Effectively Scheduled QVD reloads on server using Incremental Load and eliminated errors and failures using troubleshoots.
• Developed different complex data models as per user requirement by eliminating closed loops, Synthetic tables and ambiguous relationships.
• Successful in implementing dashboards for Date and time analysis on Sales Data like Present Year-to-Date, Previous Year-to-Date, Present Month-to-date, Previous Month-to-date and Quarter-to-Date and Previous Quarter-to-Date as per client requirement.
• Automated QlikView jobs in QlikView Publisher and rolled out to QlikView Access-Point and administered Security using Active Directory.
• Effectively used performance tuning techniques and improved the overall performance of the application.
• Presented QlikView applications to various levels of user.
• Performed issue analysis for the modules developed in Learning Management System.
• Optimized QlikView performance using QlikView administrator.
• Successful in creating positive impact on the business by understanding and developing the architecture of prioritized reports.
• Successfully generated GUI Report for easy access by developing application for Claims and Finance Modules.
• Created technical manual for the end users illustrating the back end information of relative tables and fields based on the application they use.
• Performed QlikView Server tasks such as developing tasks, assigning license, creating user groups etc.
• Performed functional quality control testing in several modules.
• Developed applications using advanced scripting, set analysis, advanced aggregation functions and advanced charts.

ENVIRONMENT:, QlikView 11.2 SR6, Windows Server 2007, Oracle 11g, MS Access 2005, MS Office, .CSV Files, SQL Server 2008, R12 E-Business Suite (EBS).

Confidential, IL

Lead/QlikView Developer

RESPONSIBILITIES:

• Successfully involved in full life cycle implementation of project and developed QlikView dashboards for Sales Analysis and Production over time and deployed applications into access point, created and scheduled tasks based on requirement and monitored sever and publisher.
• Worked effectively and created complex reports by connecting it to various data sources like Oracle, MS Excel, CSV files and flat files.
• Successfully retrieved external data to QlikView Dashboard in terms of QVDs by making connection through ODBC and OLEDB.
• Effectively developed QlikView Dashboards using Drill down and Cyclic Grouping (Charts), List Box, Input Field, Table Box and Calendar & Date Island.
• Successful in reducing the clutter in the QlikView data model using Applied Mapping Function to eliminate certain dimension tables.
• Worked with various QlikView functions such as Date and Time, Keep, Join, Mapping, peek, pick etc.
• Developed QlikView Documents, Layouts to make consistent and professional outlook to clients.
• Successfully created reports like Open Purchase Order Detail Report, Open Requisition Purchase Order Detail Report using Straight Table and Pivot Table as per client requirement.
• Effectively used Business views and created dynamic and cascading prompts.
• Successfully created simple and complex end user reports like hierarchies and Cross tab.
• Good understanding of relational, object and dimensional databases.
• Successfully created and modified Macros automating Microsoft Excel and Access.
• Worked on multiple queries and merged common dimensions by using Web Intelligence reports.
• Successfully provided QlikView consultation to the development team.
• Worked extensively with Dimensional data modeling, star schema, snow flake schema, Fact and dimensional tables.
• Successful in providing custom functionality in Qlikview Applications, by creating Macros and SET ANALYSIS.
• Successfully tested QV server environment by Designing, Building and Debugging the Qlikview application.
• Strong experience using SQL, PL/SQL and T - SQL in development of reports, analyzing data in tables, cardinality between tables and joining tables.
• Participated in daily scrums meeting.
• Strong team player working on all the areas of the project.

ENVIRONMENT: QlikView 11.0, MS Excel 2013, Windows Server 2007, Oracle 10g, SQL Developer.

Confidential, CA

QlikView Developer

RESPONSIBILITIES:

• Successful in eliminating the data which doesn't suit the requirement and then find and understand the essential data.
• Effectively worked with dimension data and fact and successfully created the data model as per requirement.
• Successfully created dashboards by creating analytical expressions for the different KPIs.
• Effectively Participated in migration of QlikView server from one physical server to another.
• Successfully calculated various attributes by performing analysis and documentation.
• Successfully manage user access and promoted dashboards to production environment.
• Successfully performed functionality, data, performance, look and feel for testing of dashboards.
• Successfully used Field and Bookmark criteria.
• Extensively utilized Loop and Reduced functionality for creating multiple documents and distributed based on Section Access user privileges.
• Successful in using multidimensional pivot table by adding multiple dimensions to a bar chart.
• Successful in testing the application by creating test case scenarios for developers and power users.
• Successfully gatheird feedback at every phase and also assisted in demoing QlikView application to users.
• Successfully remediated issues with complex database joins and also refined the query logic in reports without compromising on the reporting results and functionalities.
• Performed production support to the existing QlikView applications.
• Monitoring project progress as per scheduled deadlines for various tasks and taking necessary steps to ensure completion within time and effort parameters.
• Successfully performed transition of products from onsite to offshore.

ENVIRONMENT: QlikView 10.0/11.0, Excel, PL/SQL, Windows Server 2007, Oracle 10g, MS Access 2005.

Confidential, NJ

Qlikview Developer

RESPONSIBILITIES:

• Successfully designed Functional by Communicating with the business users to comprehend the requirements.
• Successfully deployed QlikView Applications and involved in creating security based on user requirement.
• Successfully utilized Linked Tables, Concatenation and also solved the loops issues.
• Efficiently improved the performance by redesigning the existing mappings.
• Successfully performed Activities like Data refresh, Job Scheduling and Data validations.
• Successfully completed Server maintenance, Bug fixes, New User Access, enhancements followed by testing and deployment.
• Performed Process - analysis to design Key Performance Indicators (KPI), to improve performance.
• Successfully integrated with the Test and Production Servers and halped creating use cases by coordinating with Team Members in development process to.
• Involved in Production Support for QlikView applications & Server.
• Used SQL Server to run SQL queries and validate the data in Data warehouse and Data Marts and also conducted end user training sessions and prepared the training documentation.

ENVIRONMENT: QlikView 10.0, Oracle 10g, Windows 2007, XP, Oracle 8.0, SQL Server, HTML, MS-Access, MS-Excel.

Confidential

SQL/PLSQL Developer

RESPONSIBILITIES:

• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Designed logical and physical data models for star and snowflake schemas using Erwin.
• Involved in the design and implementation of database.
• Used DDL to create the database objects and created Master and Transaction table package.
• Wrote validation scripts to check the data integrity and packages for other entitlement programs as per guidelines and Gained noledge in handling Bulk data.
• Involved in coding, unit testing, and end - to-end testing of the developed modules.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling and Designed Data Modeling, Design Specifications and to analyze Dependencies.
• Worked on XML along with PL/SQL to develop and modify web forms.
• Creating indexes on 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 and created some Custom reports and Forms for the end users to check the details and errors.

ENVIRONMENT: Oracle 9i, SQL* LOADER, Forms 6i, Reports 6i, Discoverer 10g, XML Publisher.