PROFESSIONAL SUMMARY:

• Total 7+ years of IT experience and Total 4+ years of Experience in Business Intelligence and extensively on QlikView.
• Expertise Data modeling, Report designing and Performance Tuning using QlikView.
• Strong knowledge on Qlikview server architecture and building QVDs and QVWs applying business rules.
• Experience in designing & Developing Qlikview Dashboards using various objects & ability to write complex front end scripting or expressions.
• Extensive knowledge in Section Access, Set Analysis in QlikView.
• Complete Life Cycle Development experience including Planning, Analysis, Design, Implementation and Maintenance using QlikView.
• Experience with QlikView sheet objects including multiple charts types, Trends, custom requests for Excel Export, Fast Change and other objects for Management Dashboard reporting.
• Hands on professional with thorough knowledge of scripting, data source integration and advanced GUI development in Qlikview.
• Developed enterprise applications for use in production environments using Qlikview.
• Experience in scheduling jobs in QlikView Enterprise Management Console (QlikView Publisher) and managing user accounts in QlikView Management Console.
• Extensive experience in end - to-end implementation of Business Intelligence (BI) projects, especially in scorecards, reports & dashboards.
• Strong knowledge on Databases like SQL Server2005/2000, and Oracle11g/10g.
• Strong understanding of Dimensional Modeling technique, Multi-dimensional database Schemas like Star Schema, Snow flake Schema, Fact and Dimensional tables.
• Extensive knowledge on Migration Process.
• Having good knowledge on performance techniques, optimizing the reports and, queries.
• Good working knowledge on creation reports using various data providers ex: NPrinting.
• Quick learner and excellent team player, ability to meet tight deadlines and work under pressure.
• Have excellent problem solving skills, analytical abilities and technical skills.
• Energetic, enthusiastic and hard working, result oriented team player inclined towards achieving career goals and enterprise objectives.

TECHNICAL SKILLS:

Databases: Oracle 11g/10g, SQL Server 2008/2005/2000 and Access, JDE

Tools: QlikView (11.20 SR3, 11 SR1, 10 SR4, 9 SR3), Toad, SQL developer

Languages: SQL, PL/SQL, C

Additional Skills: Data Analysis

Data Modeling: Erwin data modeler

ETL: Talend, Informatica

PROFESSIONAL EXPERIENCE:

Confidential, Libertyville, IL

BI Consultant/Qlikview Developer

Responsibilities:

• Extracting normaliz eddata set from Informatica and from various database sources and build a data model with Master Calendar to connect the various fact tables with master tables
• Used QlikView sheet objects including Pivot, List, Multi box, multiple charts types, Trends, KPI's, custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting
• QlikViewbestpracticeswereusedinimplementation of scripting,setanalysisandusageof variables.
• Designed/Implemented Star Schema while loading data from multiple data sources.
• Implemented data level Security using Section Access that hides selected areas of the dashboard and reduces data dynamically depending on user entitlements/privileges.
• Created QVD's & updated on timely basis as database updates.
• Developed ETL Scripts for data cleansing, resolving synthetic keys & circula rloops.
• Included the enhancement scripts to the existing QV scripts and performed the actual load to test the overall functionality of the applications.
• Monitoring of the QVS,QVW'sanduseraccounts for the usage of applications & user access to manage the limited number of licenses.
• Deploying the QlikView reports onto the QlikView servers.
• Worked on Publisher to Automate and scheduled daily/weekly/monthly data loads of QVW documents .

Environment: QlikView 11.2/11, QlikView Informatica Connector, Oracle 10g,DB2, MS SQL Server 2008, Toad, Informatica 9.0.,Windows 2008 R2,Excel,MS Access, Flat files

Confidential, Waukegan IL

BI Consultant/Qlikview Developer

Responsibilities:

• Interacting with end users to gather the functional requirements and customize QlikView dashboards accordingly and involved in developing, enhancing, maintaining, supporting QlikView applications.
• Trained QlikView Users in the company on using QlikView and create objects for the daily Business use.
• Created Excel, Word, Power Point reports from Qlikview Dashboards and distributed to the users using NPrinting.
• Created jobs and scheduled to send daily pdf reports for the user upon reload using NPrinting.
• Used QVSource to generate the Qlikview load scripts to download the data from Cloud system like Google Drives, FTP servers, Dropbox services.
• Hands on writing and implementing Macros to add a custom functionality in qlikview.
• Involved in preparing the Business Requirement Document (BRD).
• Implemented triggers to start the reload task when loading in database completes using batch script.
• Creating Tasks for reloading of QlikView data to QVDs and QVWs through QMC.
• Managed assigning different CALs different to users based on their requirements.
• Created customized gauge charts to show the Actual VS Plan for the KPI scores for all the LOBs.
• Implemented Best Practices & Developed ETL Scripts to resolve Circular Relationships, Synthetic Keys in QlikView.
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box, Statistics Box, Multi Box and Calendar & Date Island.
• Applied mapping function to look up and fetch the required field.
• Developed complex SET ANALYSIS to provide custom functionality in QlikView Applications.

Environment: QlikView 11.20 SR3, NPrinting, JDE, FTP and Microsoft SQL Server 2008 R2.

Confidential, Dallas, TX

BI Consultant/Qlikview Developer

Responsibilities:

• Collecting, Analyzing and Documenting the requirements from the existing reporting system as well as interacting with the client on daily basis.
• Creating qvd generators to build the Tier-3 data model.
• Writing the scripts for transformation layers (Tier-2) to optimize the data model by updating the scripts, removing synthetic keys or circular s.
• Writing scripts for the necessary computations to avoid substantial expressions or calculations in the UI.
• Updating tier-1, 2, 3 data layers to reflect the changes from ETL/DB.
• Extensively worked with the qlikview specialized functionalities like set analysis, aggr functions to optimize the expressions and as well as to increase the performance.
• Collecting the required data for section access from the DWH, users and writing the section access scripts and implementing it in all developing dashboards.
• Writing scripts for incremental load to generate qvds with updated data from the database in different scenarios like - (insert, update) and (insert, update and delete).
• Designing and developing qlikview dashboards using many different sheet objects to fulfill the business requirements and satisfying the user by using advanced qlikview visualization features.
• Providing support for the UAT.
• Scheduling/ Creating QlikView tasks using QlikView Publisher for reloading QlikView application dashboards.

Environment: QlikView 11.20 SR3, Microsoft SQL Server 2008 R2, Microsoft SQL reporting Service, Talend ETL.

Confidential, Redbank, NJ

BI Consultant/Qlikview Developer

Responsibilities:

• Interviewed users to identify problems, reporting requirements and problems in existing systems design.
• Collaborated with Business Intelligence team to learn current processes and practices.
• Identified various KPI’s with businesses users and analyzing existing Business Objects Reports.
• 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.
• Extensively worked on QlikView Set Analysis.
• 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.
• 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.
• Scheduled and managed QlikView jobs using QlikView Scheduler for QlikView application dashboards.
• 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 11 SR1, Oracle 11g, TOAD, Business Objects, Erwin Data modeling, informatica.

Confidential

Qlikview Developer

Responsibilities:

• Extracted data from various sources used ETL load scripts to manipulate, concatenate and clean source data.
• Developed dashboard’s using different components of QlikView like List boxes, Multiboxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Created and managed ETL script generation using QlikView Script Builder Application.
• Created relevant data model, written QlikView Scripts, macros, design Dashboard and Reports for different user groups.
• Created tasks in Publisher for the application from making the QVD’s to the whole application reload.
• Upgraded QlikView Server from QlikView 9.0 SR3 to QlikView 10.0 SR3.
• Worked with QlikView administrator to optimize QlikView performance.
• Provided Production support to existing QlikView Applications.
• Trained the end users effectively to use the reporting tool.

Environment: QlikView 9.0 SR3/10.0 SR3, Oracle 10g, TOAD, SQL Developer.

Confidential

PL/SQL Developer

Responsibilities:

• Experience in Analyzing all business functionality related to back end database interfaces.
• Experience in designing the layout of the application as per the business requirements of the client.
• Wrote scripts and created batch files for automatic running of Qlikview scripts.
• Generated crystal reports using data from multiple sources including Oracle, SQL Server and flat files (text, excel and xml).
• Hands on experience with Crystal Reports.
• Altered the Crystal Reports 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.

Environment: PL/SQL, SQL developer, Crystal Reports, SQL*Loader, TOAD, Oracle 10g.