PROFESSIONAL SUMMARY:

• 9+ years of IT professional experiencewith 5+ years of rich experience in Designing and Development of Business Intelligence application with QlikView.
• Strong Knowledge & experience in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production support.
• Expertise in Installing and Configuring Qlikview Desktop, Qlikview Server and Qlikview Publisher.
• Expertise in Creating Documents using QlikView 9.0/10.0/11.2 using different data sources like SAP BW, Oracle, SQL Server, QVD files, text files, excel and generated dashboard as per the user requirement.
• Ability to write complex front end QV scripting and expressions
• Developed Proof of Concept for 10+ customers
• Extensive knowledge with Dimensional data modeling, star schema, snow flake schema, Fact and dimensional tables.
• Experience in designing different types of charts (drilldown, cyclic groups) such as Bar charts, Line charts for Trend Analysis, Straight Tables, Pivot Tables, Pie charts etc.
• Ability to handle complex calculations and point in time reporting using Set Analysis (Set Expressions).
• Strong experience in UI Design by using different QlikView sheet objects including multiple charts types, Trends, KPI’s, custom requests for Excel Export, and Fast Change.
• Experience in working with extension objects.
• Performance tuning QlikView Applications for faster data reloads& efficient response times.
• Experience in Creating and scheduling jobs using Qlikview Publisher.
• Involved in Optimizing existing QlikView dashboards with a focus on usability, performance, long - term, flexibility, and standardization
• Implemented data and object level Security in Qlikview applications with section access method.
• Was actively involved in server migration and the fresh QlikView installation process
• Created Triggers and Distributed QV applications to production using QEMC.
• Excellent working knowledge in BI Analytics,Data Warehousing Models, RDBMS concepts, SQL, PL/SQL.
• Strong data analytical and debugging skills to ensure accuracy and data integrity.
• Ability to adapt quickly to different project environments, work in teams and accomplish difficult tasks independently within time frame.
• Quick learner and excellent team player, ability to meet tight deadlines and work under pressure
• Excellent analytical, co-ordination, interpersonal, leadership, organizational and problem solving skills, ability to adapt, learn new technologies and get proficient in them very quickly

TECHNICAL SKILLS:

Business Intelligence Tools: QlikView 12.0,11.2,10, 9.0, QlikSense

Languages: SQL, PL/SQL, C, Java

Database Technologies: SAP BW,Oracle 12c/11g/10g/9i, SQL Server 2008/2005, MS Access 2005, DB2

Operating Systems: Windows, UNIX

Scripting Languages: HTML,XML

IDE: Visual Studio, Eclipse

Domains: Healthcare, Sales, Pharmaceutical, Services, Financial

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

WORK EXPERIENCE:

Confidential, Fort Worth, TX

QlikView Consultant

Environment: Qlikview 11.2/12, SAP BW, Oracle, Windows Server 2008 SR2, MS Excel

Responsibilities:

• Was responsible for interactions with business users and gather requirements.
• Worked on creating reports, analysis, Dashboards both for sales and finance team.
• As a part of Support team was involved in supporting the existing QlikView applications and worked on complex enhancements and delivered them in time.
• Developed load scripts using functions like For loop, Apply Mapetc.
• Worked on Document chaining to link one application to other.
• Implemented Incremental loads to improve the load time.
• Worked on using extension objects in the front end for better visualizations.
• Implemented advanced SET Analysis for aggregation calculations so that set of records can be defined in an expression.
• Optimized existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in the front-end, improving layout structure.
• Managed schedules and reloading of Qlikviewdata model QVDs and QVWs through QlikviewEnterprise Management Console (QMC).
• Involved in writing test scripts and documentation of the applications.

Confidential, Phoenix

QlikView Developer\Administrator

Environment: Qlikview 11.2 SR5, SQL Server 2008, Windows Server 2008 SR2, MS Excel

Responsibilities:

• Communicated with the business users to comprehend the requirements and Designed Functional.
• Developed different dashboards with a complex database system behind it, which includes extracting data from the database, storing into QVD files, write load scripts, and develop UI according to user requirements.
• Worked on Incremental loads which updates the QVD’s with new data to improve the load time in live data and also worked on large data warehouse.
• Developed load script using QlikView Functions (Date and Time, Keep, Join, Mapping, String, Interval match etc...)
• Developed Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Date Island
• Setting up tasks using QEMC and created architecture for the interdependent applications and executed in proper order
• Created document chaining, linking to navigate from one application to another
• Also distributed respective pdf files from QVW’s to respective users through PDF Distribution
• Implemented data level and object level security with section access method
• Involved in Production Support for QlikView applications & Server.
• Performing Unit and Integration testing, validation and sanity checks on the deliverables
• Work with existing systems to track and manage requests and issues. Pro-active monitoring to ensure performance on the server

Confidential, Green Bay, WI

QlikView Developer

Environment: QlikView 10.0/11.2,Windows 2000 Server, Oracle 12c/11g, MS Access 2005, SQL Server 2008, MS Excel

Responsibilities:

• Connected to different ODBC, OLE DB data sources (SQL Server, Oracle) and flat files to create and schedule different complex reports
• Worked on creating reports, analysis, Dashboards both for sales and finance team.
• Worked on Incremental loads in qlikview which updates the QVD’s with new data to improve the load time in live data and also worked on large data warehouse.
• Designed models by mapping business needs using Qlikview and created multidimensional cubes.
• Implemented Macros, Filters, Variables, Aggregate functions and Mapping functions to achieve user requirements.
• Sound skills in developing hide/Show Objects, on activate/On leave sheet based on Condition & Triggers and worked on Document based triggers like documents event triggers, fields event triggers and variables event triggers.
• Involved in up gradation of QlikView environment from QV 10.0, QV 11.2 versions.
• Implemented Security & involved in Deployment of Qlikview Applications

Confidential, Chicago,IL

QlikView Developer

Environment: Windows 2000 Server, Oracle 11g, MS Access 2005, SAP BW QlikView 9.0/10.2

Responsibilities:

• Extracted the data from various data sources such as databases, CSV files, and Excel documents transforming the data into standard format (QVDs) and load the data so that it is available for analyzing and creating reports.
• Designed Schema using dimensions, fact, logical, physical, alias and extension tables.
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc...).
• Developed Link Tables, Concatenation and solved the loops issues.
• Installed and configured QlikView 10.2 Assisted in upgrading from QlikView 9.0 to version 10.2.
• Application processed tables with over 10 million records. Experience in scripting QlikView Set Analysis and Macros.
• Worked on SET ANALYSIS using functions like min, count, sum, conditional functions, range, color functions, images, variables, fields etc.
• Converted the huge tables into multiple QVDs, so that only the recent ones needed to be refreshed for data accuracy.
• Eliminated synthetic keys using QVD concatenation and by renaming the fields.
• Worked on Partial reload, incremental loads...etc in Qlikview
• Involved in giving Qlikview applications access to the end users using Qlikview IE Plug-in.
• Designed user interface and prepared layouts for the system using QlikView.
• Involved in the developing of star schema and snow flake schema dimensional data model.

Confidential

SQL PL/ SQL Developer

Environment: Oracle 10g, TOAD, SQL Developer, UNIX, Windows XP

Responsibilities:

• Modified report wherever needed as per the suggestions given by business analyst and Analyzed the existing Actuate and SQR reports.
• Migrated actuate code of data extract to PL/SQL equivalent and Created PL/SQL functions, packages, procedures and joins.
• Coordinated with the client to make sure that there is not much change during the migration of the reports.
• Extensively used SQL to create Insert programs for loading data. 
• Modified existing procedures according to new enhancements.
• Performed data partitioning. 
• Assessed the pros and cons of migration and conveyed the same to the Business Analyst.
• Developed complex Stored Procedures,Triggers, and Functions.
• Written stored procedures for those reports which use multiple data sources.
• Worked on Joins for many tables in SQL (Self joins, Left joins, Right joins….etc).