SUMMARY

• More 8.6 of IT experience in all aspects of Business Intelligence applications with a strong background in Database development, Data warehousing/Decision Support Systems and Business Intelligence.
• Over five years of experience in QlikView alone.
• Experience in Full Life Cycle development including Planning, Analysis, Design, Implementation and Maintenance using QlikView.
• Good at working with Data Warehousing and other business intelligence tools for developing various reports usingQlikView BI.
• Excellent knowledge in designing and developing dashboards using QlikView by extracting the data from multiple sources (Oracle, Flat files, Excel, Access)
• Experience in Coding/developing for code reusability including the use of variables in QlikView.
• Maintained Three - Tier architecture across all QlikView dashboards.
• Extensive experience with QlikViewsheet objects like Straight tables, Pivot tables, Containers, Line charts and Bar charts, scripting and building qvd’s and qvw’s
• Experienced in consolidation of multiple QlikView applications into one
• DAR (Dashboard, Analysis and Reporting) approach is maintained throughout dashboards.
• Experience in designing QlikViewDocument/User Setting, Layouts to make consistent and professional optimized look to clients.
• Developed various user interactive charts using QlikView advanced futures like Set Analysis and Alternate States.
• Experience with QlikView sheet objects including multiple charts types, Trends, KPI’s, custom requests for Excel Export and objects for Management Dashboard reporting.
• Experienced in all kinds of loads incremental, generic, partial, binary, preceding, mapping and resident
• Experienced in implementation of QlikView security by authentication, authorization at document level and data level to the end users.
• Experienced in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables and Physical and Logical data modeling in the OBI Administration tool, ERWIN 7.2.
• Explored intensively and implemented QlikView 11 advanced features like Set Analysis, Alternate states, integrating Google Maps, Dimension Limits and creating Ad-Hoc Reports.
• Working knowledge in writing SQL queries to test the OLTP & OLAP Databases based on changes of the functionality
• Designed and implemented incremental load using QVD’s.
• Developed Ad-Hoc reports as per user requirements.
• Good in validating the BI reports/dashboards by preparing the Test Plans& Cases.
• Experienced in writing UNIX shell scripts, SQL Loader, Performance &Tuning of Database.
• Strong knowledge in Oracle 11g/10g/9i/8i database programming using/SQL (Stored Procedures, Functions, Triggers, Cursors) and standard Built-in Oracle Packages.
• Created test plans, test objectives, test strategies and test cases in the QA testing phase.
• Excellent work ethics, self-motivated, quick learner and team oriented. Continually provided value added services to the clients through thoughtful experience and excellent communication skills.

TECHNICAL SKILLS

BI tools: QlikView10/11, OBIEE 11g.

Databases: Oracle 11g/10g/9i, SQL Server 2000/2005, DB2 8.0/7.0, MS Access.

Data Modeling: ERWIN 7.2.

Languages: SQL, PL/SQL, UNIX, HTML.

ETL tool: Informatica.

Other tools: SQL* Plus, SQL Developer, Toad, SQL Server Management Studio.

PROFESSIONAL EXPERIENCE

Confidential, Collegeville, PA

Sr.QlikView Developer

Responsibilities:

• Extensively worked to confirm and clarify requirements and business logic.
• Analyzed the reporting requirements with the business users and came up with the technical specifications.
• Created Dashboards, scoreboards for the required KPI’s in QlikView.
• Developed production-grade QlikView reports and dashboard to meet business requirements in timely manner.
• Worked on data modeling and developed different complex models as per given user requirement by eliminating circular loops, Synthetic tables and ambiguous relationships.
• Managed schedules and reloading of QlikViewdata model QVDs and QVWs through QlikViewserver.
• A master calendar was used for time related dimensions and a strong source control methodology was used for tracking changes.
• Implemented security using QlikViewsection access that dynamically hides selected areas of the dashboard depending upon user privileges.
• Designed applications for to support the dashboard style of layouts using different components of QlikView like List boxes, Multiboxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Developed load scripts to work with multiple data sources (SQL, Oracle, Excel, and Oracle).
• Implemented the Incremental Loading feature in QlikView.
• Developed SET ANALYSIS to provide custom functionality in QlikView Applications.
• Developed Macros, Set Analysis to provide custom functionality in QlikView Applications.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView Publisher.

Environment: QlikView 11, QlikView Management Console, SQL Server 2008, Excel, CSV files, Flat files, MS Excel, MS Access, Toad, Nprinting.

Confidential, St, Louis Park, MN

QlikView Developer

Responsibilities:

• Consolidated two existing QlikView Application.
• Created POC’s, proposed and documented the requirements to the user for consolidated application.
• Did the analysis of the application regarding user experience (Front end), QlikView data model change, volume estimation, QVW size estimation, BI processing time saved after consolidation.
• Did testing in two different servers and validated the data.
• Resolved the failure issue of existing publisher job in Production server.
• Validated the data of the reduced QlikView files.
• Executed the job in Publisher.
• Implemented security using QlikViewsection access that dynamically hides selected areas of the dashboard depending upon user privileges.
• QlikView best practices were used in implementation of scripting, set analysis and usage of variables.
• Involved in performance tuning of dashboards to limit the response time and enhance the functionality.
• Designed and developed QlikView software applications and server-based QlikView dashboards from scratch to support BI initiatives.
• Implemented Section access and hidden scripting for the Application Security.
• Hands-on experience in setting up new task and troubleshooting existing task setup and other issues.
• Identified data sources and targets for data modeling and solution architecture.

Environment: QlikView 11, Oracle, SQL Server, Toad /SQL Developer, SQL Loader, QlikView Server and Publisher

Confidential, Santa Clara, CA

QlikView Developer & Analyst

Responsibilities:

• Involved in requirements gathering & delivering QlikViewapplications for Confidential, Inc. Point of Sale (POS) division.
• Imported data sources like QVD files, Excel, Oracle & SQL server 2008, Binary QVW, Inline & text files in developing the QlikView Data Models.
• Developed ETL Scripts in loading the data, resolving loops & ambiguity joins
• Created QVD’s & updated on timely basis as database updates.
• Efficiently used Hierarchy and Interval match for grouping
• Implemented Incremental load for the update of QVD’s
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & Input Fields etc.)
• 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
• Testing applications, reports using review checklists, data quality for quality assurance before delivering to the end users
• Performance tuning by analyzing and comparing the turnaround times between SQL and QlikView
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports
• Facilitate system enhancements requirements and design sessions
• Execute complex SQL Queries using COALESCE and multiple JOINS to validate data across multiple systems.
• Composed new MS-SQL stored procedures modified existing procedures to increase speed of nightly reporting process by 50% through use of Temporary Tables and Common Table Expressions.
• Follow a structured approach to organize requirements into logical groupings of essential business processes, business rules, and information needs, and ensures that critical requirements are not missed.

Environment: QlikView 10, SQL Server, SQL Loader, QlikView Server and Publisher

Confidential

Business Analyst / QlikView Developer

Responsibilities:

• Analyze and review Business Requirement and Specification documents.
• Coordinate with business team to provide and receive feedbacks on the business requirements.
• Create Functional Design documents, and hold the reviews with business and IT team.
• Created SQL Server database to responsively handle complex queries (T-SQL, DTS, triggers, stored procedures, functions, and optimization) and .NET data access components
• Participated and proposed new business analysis for data which has no prior reports
• Extracted data from the database, stored into QVD files, and wrote load scripts
• Eliminated Synthetic keys, ambiguous relationships and closed loops.
• Designed proficient dashboards according to the requirements.
• Established a secure environment using QlikView Section Access.
• Optimized existing data models like changing load scripts to load data in optimizedway to achieve reduction of loading time, simplified complex expressions in the front-end and improved layout structure.
• Adapted Kimball’s approach for building data marts.

Environment: QlikView v10/9, SQL, .Net, Access, DB2, .CSV Files.

Confidential

SQL Developer

Responsibilities:

• Installed SQL Server 2000 Servers, multi instances.
• Database Programming in Visual Basic 6.0, MS SQL Server 2000
• Planned and Scheduled the Online/Offline Backups, Maintained Backups andRestore.
• User Management creating groups and policies in Active /directory, Maintained
• User data and File System.
• Created and maintained mail and database accounts with client user support.
• Configured and maintained servers with Active Directory integration.
• Created SQL Server database to responsively handle complex queries (T-SQL, DTS, triggers, stored procedures, functions, and optimization) and .NET data access components.
• Individually designed MS SQL Server 2000 database, coded stored procedures (T-SQL).
• Developed / modified Oracle PL/SQL codes like stored procedures, functions, triggers based on technical and functional specification documents.
• Developed / modified scripts to rectify data errors and executed them using SQL Plus.
• Developed / modified scripts to create tables, views and executed them using SQL Plus.
• Ran batch jobs for loading database tables from flat files using SQL Loader.
• Prepared unit test cases and executed the same.
• Good understanding of TOAD and OOPS concepts.
• Oversaw installations, upgrades of SQL 2000, SQL 7.0 to SQL 2000.

Environment: MS Outlook, MS SQL Server 2000, Microsoft Visio, MS Office, XML