SUMMARY:

• More than 7+ years of IT Experience in Business Intelligence, Data Modeling and Data Warehousing.
• More than 5 years of Experience in working wif QlikView components such as QlikView Desktop, QlikView Enterprise Management Console(QEMC), QlikView Publisher, QlikView Web Server and Ajax Clients.
• Strong Skills in QlikView 11, 10, 9.0, 8.5/8.0 in designing and creating dashboards and reports wif various graphs and analysis.
• Wide Variety of Functional Experience wif Innovative Solution Design, Information Technology solutions and Passionate Leadership producing consistent results.
• Implementation & Production Support of QlikView Applications.
• Expertise in Full Life Cycle Development including Planning, Analysis, Design, Implementation and Maintenance using Qlikview.
• Installed, Configured and deployed teh application on QlikView server and Imported data from different sources like Oracle, SQL Server, share point files, QVDs and flat files using OLE DB/ODBC.
• Proficient in Designing Data Mart & Data Warehouse of QlikView for BI (Business Intelligence) Reporting Solutions.
• Having noledge on Data Modeling concepts like (Star Schema, Snow Flake Schema) & Loading Data from multiple sources.
• Experience in development of ETL scripts for Data Modeling along wif resolving Synthetic Key and Circular Loop issues.
• Experience in developing User Interfaces and QlikView Dashboards using Chart - Box( Drill Down, Drill up & Cyclic Grouping), List Boxes, Input Fields, Table Boxes, Calendars and Data Islands.
• Comprehensive noledge and exposure to different phases of Software Development Life Cycle(SDLC). Experience in Planning, Analysis, Design, Implementation and Maintenance using QlikView
• Strong Experience in working wif Charts (Table Box, Pivot Tables, Straight Tables, Pie-Charts, Gauge-Charts, Trellis).
• Good Exposure to working wif QlikView Functions and Expression Scripts and Streamlining Reporting operations of QlikView Applications.
• Adept in reviewing and analyzing teh Business Processes, Business Process Flows and implementing QlikView Solutions.
• Interaction wif teh Process Champions & Business users during teh various stages of project lifecycle to identify various KPI’s and designed solutions to enhance business decision making.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance prior to making delivery to end users.
• Proficient in SET ANALYSIS to provide customized functionality in QlikView Applications.
• Implementation of security in QlikView Applications at Document and Server Level.
• Self-motivated and enjoy working in a technically challenging environment. Has excellent Communication and interpersonal skills.
• Excellent work ethics, self-motivated, quick learner and team oriented. Continually provided value added services to teh clients through thoughtful experience and excellent communication skills.

TECHNICAL SKILLS:

Business Intelligence: QlikView 11x/10/9x (Desktop, Server Publisher, Access Point), Nprintingfor Qlikview (14.1.03).

Databases: MS SQL Server, MS Access, Oracle, and Teradata 12x/V2R6

Web Technologies: HTML, XML

Operating Systems: Windows 95/98/2000/XP

Languages: SQL, Oracle, PL /SQL.

Other Tools: Informatica, Tableau, Toad, and Squirrel

PROFESSIONAL EXPERIENCE:

Confidential, TX

Senior QlikView Developer

Responsibilities:

• Involved in Requirement Gathering & Designing QlikView applications.
• Gathering data sources QVD files, Excel, Oracle, SQL Server, binary QVW, Inline & txtfiles in developing teh QlikView Data Models.
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Date Island.
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & Input Fields).
• Developed User Interactive Sheets & Reports as business needs.
• Writing SQL Scripts to load teh relevant Data in QlikView Applications.
• SET ANALYSIS in providing custom functionality to QlikView Applications.
• Implemented & involved in Security Deployment of QlikView Applications.
• Created QVD’s & updated on timely basis upon updates of Database.
• Developed ETL Scripts while loading teh data for resolving loops & ambiguity joins.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to teh end users.
• Implemented security in QlikView Applications.
• Trained End Users on Using QlikView Tools.
• Involved in Production support and Users CAL assignments.
• Experience wif QlikView Enterprise Management Console.

Environment: QlikView 11.0, SQL Server 2008, CSV Files, Windows 2003 Server

Confidential, PA

Sr.QlikView Developer

Responsibilities:

• Extracted data from Oracle database and loaded into QlikView.
• Developed QlikView scripts to load teh transformations and make enhancements to teh user interface of teh desktop application.
• Eliminated synthetic keys using QVD concatenation .
• Used SET Analysis to look back a month or a quarter and get teh required information.
• Participated in Data Modeling meetings to create a suitable data model.
• Used MS Access and QlikView extensively as reporting tools and to create user build specifications.
• Wrote scripts and created batch files for automatic running of QlikView scripts.
• Used ABOVE and BELOW functions to calculate teh variance in PIVOT Tables.
• Developed User Interface for more than one application.
• Created Bookmarks to pre select filters.
• Generated PDF Reports according to user requirements.
• Improved teh overall performance of teh application and redesigned data model applyingQlikViewperformance tuning techniques.

Environment: QlikView 11/10 ((Desktop, Server/Publisher, Access Point), Set Analysis, Oracle 10g, MS Access, MS Excel, MS Visio, VBA, Windows XP and Windows 7

Confidential, MN

QlikView Developer

Responsibilities:

• Developed User Interactive Sheets & Reports as business needs.
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts, and Bookmarks.
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros.
• Implemented Star schema & snow flake schema (confirmed dimensions).
• Developed Linked Tables, Concatenation (Resolving Loops & model ambiguity).
• Gatheird & loaded data into QlikView from various data sources (SQL SERVER 2005, Oracle 10g, .CSV and excel files).
• Generate new QVD files created by ETL logic to feedQlikViewapplications.
• Included teh enhancement scripts to teh existing QV scripts and performed teh actual load to test teh overall functionality of teh application.
• Coordinated wif ETL team and performed integration testing to check data discrepancies.
• AutomatedQlikViewjobs inQlikViewPublisher and rolled out toQlikViewAccess Point and administered Security using Active Directory.
• Analyzed teh existingQlikViewdata model, script logics and teh ETL business logic for teh existingQlikViewapplications.
• Executed teh scripts and checked teh incorporated script changes in teh Application.
• Improved teh overall performance of teh application and redesigned data model applyingQlikViewperformance tuning techniques.
• Published Client application usingQlikViewPublisher and rolled out to Shared Drive wif security permissions using Active Directory features.
• Working noledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Version.
• Developed SQL Scripts in validating data from different data sources.

Environment: Windows 2000 Server, Oracle 10g, MS Access 2005, MS SQL Server 2005, QlikView 10 x, MS Office.

Confidential

QlikView Developer

Responsibilities:

• Developed User Interactive Sheets & Reports as business needs.
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts, and Bookmarks.
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros.
• Implemented Star schema & snow flake schema (confirmed dimensions).
• Developed Linked Tables, Concatenation (Resolving Loops & model ambiguity).
• Gatheird & loaded data into QlikView from various data sources (SQL SERVER 2005, Oracle 10g, .CSV and excel files).
• Generate new QVD files created by ETL logic to feedQlikViewapplications
• Included teh enhancement scripts to teh existing QV scripts and performed teh actual load to test teh overall functionality of teh application
• Coordinated wif ETL team and performed integration testing to check data discrepancies
• AutomatedQlikViewjobs inQlikViewPublisher and rolled out toQlikViewAccess Point and administered Security using Active Directory
• Analyzed teh existingQlikViewdata model, script logics and teh ETL business logic for teh existingQlikViewapplications
• Executed teh scripts and checked teh incorporated script changes in teh Application
• Improved teh overall performance of teh application and redesigned data model applyingQlikViewperformance tuning techniques
• Published Client application usingQlikViewPublisher and rolled out to Shared Drive wif security permissions using Active Directory features
• Working noledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Version.
• Developed SQL Scripts in validating data from different data sources.

Environment: Windows 2000 Server, Oracle 10g, MS Access 2005, MS SQL Server 2005, QlikView 9.0/10.3, MS Office.

Confidential

SQL Developer

Responsibilities:

• Developed complex SQL Queries for data retrieval from various database objects including tables and views.
• Developed PL/SQL Stored Procedures, Functions, Packages, Cursors, Triggers and Records to implement business rules into application.
• Deigned and Created new forms using Oracle Form 6i and fixing of bugs in existing forms.
• Developed new reports from scratch using Oracle Reports 6i.
• Implemented Event Triggers to perform business logics in teh background of Forms and Reports.
• Developed complex stored procedures for making transactions TEMPeffectively transparent.
• Extensively used built in Oracle packages like DBMS SQL and other packages.
• Designed and Developed form layouts as per user specifications.
• Involved in turning several SQL queries by using indexes, hints and EXPLAIN PLAN.
• Used SQL*Loader to load teh data from flat files and CV files into teh database.
• Developed user interfaces, menus and coded different PL/SQL objects for Forms and Reports.

Environment: UNIX, Oracle 8i, SQL, PL/SQL, Oracle Forms, Reports, SQL*Plus, SQL Tuning.