SUMMARY

• Over 8+ years of IT industry experience in all aspects of Business intelligence applications with a strong background in Database development, Data Warehousing /Decision support systems.
• 5+ years of most recent experience in QlikView Desktop, QlikView Server & QlikView Publisher in aspects of development, deployment and administration.
• Expertise in Full Life Cycle Development including Planning, Analysis, Design, Implementation and Maintenance using Qlikview. Good at working with Data Warehousing and business intelligence tools for developing various reports using Qlikview BI.
• Experienced in data - modeling. Data-marts and data-warehouses.
• Extensive experience in QlikView Scripting using with best practices, used to create complex data cleansing, transforming functions for achieving an effective data model.
• Experience in scheduling jobs in QlikView Enterprise Management Console (QlikView Publisher)and managing user accounts in QlikView Management Console.
• Explored intensively and implemented QlikView 11 advanced features like Set Analysis, Alternate states, integrating Google Maps, Dimension Limits and creating Ad-Hoc Reports for end user easy analysis
• 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.
• Business Analysis experience with excellent communication & interpersonal skills and broad understanding of business operations and requirements
• Experience in developing User Interfaces and QlikView Dashboards using Chart-Box (Drill Down, Drill up, & Cyclic Grouping), List Boxes, Input Fields, Table Boxes, KPI’s, Bookmarks, Calendars, and Date Islands.
• Good Exposure to working with QlikView Functions and Expression Scripts and Streamlining Reporting operations of QlikView Applications
• Strong understanding of Dimensional Modeling technique, Multi-dimensional databaseSchemas like Star Schema, Snow flake Schema, Fact and Dimensional tables
• Strong Experience in working with Charts(Table Box, Pivot Tables, Straight Tables, Pie-Charts, Gauge-Charts, Trellis)
• Created QVD’s& updated on timely basis as database updates.
• Developed ETL Scripts while loading the data, resolved Circular Relationships, Synthetic Keys.
• Proficient in creating QV data models, QV objects, reports, graphical interactive UI using various data sources like Oracle, SQL Server, Access, text files, Excel documents etc.
• Experience in development of ETL scripts for Data Modeling along with resolving Synthetic Key and Circular Loop issues.
• Good understandings in Financial statements, Derivatives and Structured Fixed Income
• Developed QVdatamodels,QVobjects,reports,graphicalinteractiveUIusingvarious datasourceslikeOracle,SQLServer,Access,textfiles, Excel documentsetc.
• Used advanced scripting, set analysis, VBScript and JavaScript macros, advanced aggregation functions and advanced charts for applications.
• Implemented Section Access, Binary Loads and abstracting the data layer using QlikView library and QVX filesImplementation of security in QlikView Applications at Document and Server Level.
• Team oriented individual with a results driven attitude, strong interpersonal and communication skills in effective information exchange and interaction with clients at all levels of management.

TECHNICAL SKILLS

QlikView: QlikView Development (Version 10/11), QlikSense desktop, QlikView Server (Version 10/11)/Publisher.

Databases / DB Tools: SQL Server 2000/2005, DB2 8.0/7.0, Oracle 8i/9i/10g/11g,DB2, Teradata, MS Access 2003, MS Excel, JDE.

Languages: QlikView Scripting, SQL, HTML, C, C++, JAVA.

Front end tools: Microsoft Project, MS Visio, HP Quality Center

MS Office Tools: MS Outlook, MS Word, Ms Excel, MS Access, MS PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr QlikView Developer/Business Analyst

Responsibilities:

• Analyzed requirements and gathered data for designingQlikViewapplications.
• Working knowledge with QlikView Server Administration
• Experience with QlikView Management Console (QMC)
• 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 method of developing the ultimate application.
• Identify, propose and implement enhancements over the existing reports to improve user experience.
• Configured QlikView Server /Publisher. Scheduled jobs, & Security.
• QlikView best practices were used in implementation of scripting, set analysis and usage of variables.
• Involved in gathering data from sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing theQlikViewData Models.
• Proposed and created new business analysis for data, which has no prior reports.
• Experience in creation of QVD's for theQlikViewapplications following two-tier architecture.
• Wrote, Edited and Debugged ETL Scripts for data cleansing, resolving synthetic keys & circular loops.
• Monitoring of the QVS, QVW's and user accounts for the usage of the applications.
• Created User-friendly Interactive Sheets & Reports as per the business needs and requirements.
• Created KPI's and set analysis applications, according to user needs.
• Designed and developed different types of charts Bar charts, Straight Tables, Pivot Tables, Pie charts and Radar charts etc.
• Used different functions such as counter, date and time, conditional, aggregation functions etc., for data transformation.
• Performance tuning by analyzing and comparing the turnaround times between SQL andQlikView.
• Sound knowledge of various functions ofQlikViewtechnology.
• Installed IE plugins and trained the end users to use the reports effectively, to build and customize their ad-hoc reports.
• Assisted the end users if there were any problems very effectively and efficiently.

Environment: QlikView 11/11.2, Oracle 10g,SQL Server 2005, MS Access, MS Excel, .CSV Files, Windows XP.

Confidential, Miami, FL

QlikView Developer/Business Analyst

Responsibilities:

• Provided complex KPI’s (Penetration) using set analysis.
• Requirements gathering, Impact Analysis and solution designing to in corporate the Business requests.
• Understanding the business functionality & Analysis of business requirements.
• Creating mock up with the sample data.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Assist with schema design and development of ETL processes.
• Implemented Incremental Load, Optimized Load & Binary Loads for performance tuning and for optimized QlikMarts
• Implemented Data Modeling by using Star Schema and Snowflake Schema
• Designed best suitable UI to achieve user requirement in simple and user-friendly interface of reports
• Used QlikView Scripting and Complex SQL coding for loading, and transforming
• Designed and developed QlikView dashboards using different Charts (Drill Down, Cyclic Field grouping), Sheet Objects (List Box, Input Field, Table Box, Calendar & Date etc.) and extensions
• Used QlikView Functions (Date and Time, Join, Aggregation, Range, Ranking, Peek, Previous etc.) and Created Variables using LET, SET or control statements in the scripts
• Developed Set Analysis providing custom functionality in QlikView Applications
• Designed and developed the incremental loading where applicable
• Created QVDs, QVW files and scheduled the tasks in Publisher to reload them
• Developed required user interactive Sheets/Reports & categorized as per business need
• Implemented Data Level Security, Object Level Security & Document Data Level Security
• Created model with Extract, Transformation and Data Model in QlikView.
• Enhancements to existing reports/analytics.
• Executing the Test scripts and maintaining the Log files.
• Deploying the code from Development environment to test environment and provide developer support for UAT teams till the code moves to production.
• Identifying feasible areas of project for improvement.
• Updating the test cases as per the review comments.
• Preparing required documents related to the project
• Resolving the client issues spontaneously without any delays.

Environment: and Development Tools:QlikView 11.2/11/10.0 , Oracle 10g,DB2, MS SQL Server 2008, Toad,Windows 2008 R2,Excel,MS Access, Flat files.

Confidential, Madison, WI

QlikView Developer

Responsibilities:

• Been part of several meetings with users to identify problems, reporting requirements and problems in existing systems design.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Identified various KPI’s with businesses users and analyzing existing Business Objects Reports.
• Extensively worked on QlikView Set Analysis.
• Collaborated with Business Intelligence team to learn current processes and practices.
• Created batch scripts to process the data periodically as per the business requirements.
• Applied metrics in the data via QlikView scripts and transformed QVDs to cater the business needs.
• Generated new QVD files from the EDW by writing scripts in QlikView applications. Eliminated synthetic keys using QVD concatenation and/or Qualify based on the nature of synthetic keys.
• Scheduled and managed QlikView jobs using QlikView Scheduler for QlikView application dashboards.
• Created batch scripts to process the data periodically as per the business requirements.
• Designed and Developed QlikView dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box, and Calendar & Date Island meeting the business requirements.
• Published Client application using QlikView Publisher and rolled out to Access point and administered security using Active Directory technology/Access DB integration.
• Monitor computer systems to minimize unscheduled downtimes and ensured availability of resources.
• Involved in performance tuning to optimize the functionality of dashboards.
• Provided production support to the existing QlikView applications.

Environment: QlikView 10(Desktop, Server/Publisher, Access Point),Nprinting for QlikView (14.03.), Oracle 11g, Windows XP/7.

Confidential, Cleveland, OH

QlikView Developer

Responsibilities:

• Collaborated with Business Leaders to share and gather QlikView Planning requirements
• Implemented Star Schema & Snow Flake for Dimensional Data Modeling in QlikView
• Created user interface reports using QlikView sheet objects like List Box, Input Box, Buttons, Text Input, Slider, Bookmarks, Charts (Pivot/Straight tables, Pie, Bar, Line etc.)
• Created QVDs and developed Dashboard style of reports as per business needs
• Developed extensively Variables, Input boxes, Triggers, Macros
• Created Set Analysis for Comparison analysis eliminating additional complex coding
• Wrote SQL Scripts to load relevant data in QlikView Applications
• Created and schedules tasks for reloading and distribution of Data in QlikView Publisher
• Automated jobs in Publisher & rolled out to QlikView Access point & maintained security
• Gathered & loaded data into QlikView from various sources of data like SQL SERVER 2005, Oracle 10g, .CSV and excel files
• Maintained both File and Data Level Security and implemented Data Reduction
• Used to train and solve the issues related to the end users
• Involved in Performance Tuning & Deployment of QlikView Applications
• Intense knowledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Management Console

Environment: QlikView 10, QlikView Server 10, QlikView Enterprise Management Console, SQL Server 2005, Windows Server 2003, Salesforce (.d11 adaptor), Oracle 10g, SQL Scripting

Confidential

Oracle Developer

Responsibilities:

• Create Users and Responsibilities for Security.
• Involved in design of the application system.
• Involved in developing E-R diagrams, creating tables.
• Enhanced and developed several forms and reports using developer 2000
• Designed and developed library files (PLL) that are commonly used across the application
• Involved in design and development of Menu module
• Created database triggers to validate the complex integrity.
• Created stored procedures, functions and packages for implementing major functions of the system.
• Wrote scripts for populating the database tables with test data.
• Testing and documentation.
• Involved in design and development of Menu module
• Created database triggers to validate the complex integrity.
• Created stored procedures, functions and packages for implementing major functions of the system.
• Involved in design and development of Menu module
• Created database triggers to validate the complex integrity
• Wrote scripts for populating the database tables with test data.

Environment: Oracle 7.3, SQL, PL/SQL, SQL*Net, Windows NT/95, SQL*Loader, Import, Export.