SUMMARY

• QlikView developer with almost 7 years of experience involving various aspects in Business Intelligence tools.
• Expertise includes gathering requirements to fulfill business needs & delivering design documents for developing solution.
• Excellent knowledge in designing and developing dashboards using QlikView by extracting the data from multiple sources (Oracle, Flat files, Excel, Access)
• Extensive experience with QlikView sheet objects like Straight tables, Pivot tables, Containers, Line charts and Bar charts, scripting and building qvd’s and qvw’s.
• Experience in setting up server, publisher configurations and security/authorization at different levels.
• Installed and configured QlikView versions 10 SR4 and 9.
• Implemented ETL - Extraction Transformation and Loading by using QlikView three-tiered QVD architecture.
• Good at identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that business needs meet.
• Expertise in Performance Tuning & Deployment of QlikView Applications.
• Expertise in Business Objects enterprise Products (Universe Designer, Desktop Intelligence, Web Intelligence, Info View, Crystal Reports, Xcelsius, CMS, CMC & CCM) and its deployment.
• Expert in creating Dashboards, Scorecards using BO Dashboard Designer/Xcelsius 2008.
• Extensively worked with SQL Queries, and capable of handling Oracle, SQL Server, MS Access databases and also have good experience in database tuning and performance techniques.
• Good presentation, summarization, structuring and refinement skills. Proven track record of execution capabilities of strategic as well as tactical plans, both within and through functional boundaries.
• An organized professional with excellent communication and interpersonal skills, always worked in close association with customers and a single point of contact for many major implementation projects.
• Enthusiast and experienced QlikView Developer which is a pioneering in-memory tool.
• IT Industry experience in Supply-Chain Management, Manufacturing, Insurance, and Internet Security with functional knowledge in daily operations of these industries.
• Experience in complete project life cycle including analysis, documentation, development, and testing.
• Capable of working with and solving complex problems through systematic approach with project management principles to maximize return on investment.
• Worked with customers and single point of contact for many major implementation projects.

TECHNICAL SKILLS

BI Tools: QlikView 9.0/10.0/11.0 , Toad

Databases: MS SQL Server, Oracle 9i/10g/11g, SAP BW, MS Access

Data Modelling Tools: Visio 2000, Microsoft Office, Erwin

Operating Platforms: Windows 95/98/2000/XP/NT/7/8.1, Sun Solaris

Other Tools: Informatica, HTML

PROFESSIONAL EXPERIENCE

Confidential, Racine, WI

Qlikview Developer

Responsibilities:

• Design Involved in Gathering, Analyzing and Documenting Business and Functional Requirements and Data Specifications for Data Visualization Analytics using QlikView for Credit Risk Management Reports.
• Created functional specification documents, based on the technical specification documents for universes and reports.
• Created and Maintained Views, Materialized Views, Indexes and Aggregate tables for SQL tuning to increase reports performance.
• Created Dynamic & customizable data visualization Models using QlikView and Xcelsius 2008 against data sources including QVD, MS Excel, SQL Server and Oracle.
• Involved in configuring QlikView Access to set up access levels for various users.
• Used various QlikView inbuilt functionalities including Peek, Concatenate, Resident, Set Analysis, Index and others to develop complex QlikView reports.
• Developed data analytics using QlikView and Deployed to QlikView Access Point.
• Converted existing Business Objects reports to QlikView.
• Worked on SQL and executed them for Reports validation and resolved if any issues with reports.
• Efficient in Optimizing, Debugging and testing SQL queries written in Oracle
• Developed strategies and plan for migration of the reports from BO XI R2 to BO XI R3 and later BO XI R3.1
• Production Support and data validation of Business Objects reports and QlikView models.
• Assisted less experienced Business Objects and QlikView users on building their own reports.
• Designed dashboard using the various sheet objects Current selection, list boxes, search, Straight table, Pivot table, Bar chart, Combo chart and so on.
• UsedSetanalysis, Setmodifiers. Created macros.
• Published dashboards on Access point. Migratedqvw’sto the source document folder. Created distribution and reload tasks on Publisher.
• DesignedQVWsto generateQVDs for faster and efficient data reloads.
• Manage Schedule QlikView applications using QlikView Management Console (QMC) QlikView Enterprise Management Console (QEMC).
• Successfully completed the development cycle, migrated dashboards across Development, QA and Production servers.

Environment: QlikView 11.x/10.x, Oracle 11g, MS Office, Windows 2008 R2 Server, Toad, Bo XI.

Confidential, Bellevue, WA

QlikView Developer

Responsibilities:

• Interacted with end-users to collect requirements and acquire the necessary domain knowledge to become a subject matter expert. Trained and provided support to end users.
• Performed analysis, documentation, for calculation for various attributes.
• 3 Executive Dashboards depicting Sales and Inventory data were created during the stint. Dealt with a data volumes ranging from 20 to 50 million records.
• Worked on Qlikview Server and Publisher, to manage user access, schedule refreshing of documents, mount completed applications.
• Created PDF push reports and setup email distribution on QlikView Publisher 9.
• Reviewed QlikView error logs and provided production support.
• Performance tuning of dashboards was carried out to limit the response time to well under 5 seconds.
• Helped end users to design test cases and worked through multiple UAT cycles.
• Promoting dashboards to production environment and manage user access.
• Calculation and defining server sizing for optimal performance of QlikView dashboards.

Environment: QlikView, MS Office, Windows 2008 Server, Informatica Power Center

Confidential, CT

Qlikview Developer

Responsibilities:

• Analyzed the reporting requirements with the business users and came up with the technical specifications.
• Actively participated in full life cycle of QlikView application implementation and was responsible for Design, Development and Delivery.
• Extracted data from different systems transformed and integrated in the QlikView.
• Designed the Data-Model using data from various sources like Oracle 10g Database and flat files.
• Developed a standard/optimized theme which is further used across the system.
• Extensively used set analysis to calculate/aggregate the fact data as per the requirements.
• DevelopedQlikViewDashboardsusing Charts (Straight table, pivot table, Line, combo Chart etc.), List Boxes, Multi Box, Input Field, Table Box, Statistics Box etc.
• Resolved synthetic keys using various techniques such as aliasing, join, concatenation, dropping fields, etc.
• Done metadata management by implementing the governance Dashboard.
• Extensively done business user support, resolved various issues for accessing dashboard and enhanced the dashboard as per user needs.
• Designed and implemented the Incremental Load using QVDs.
• Implemented the 3-tier architecture, Data Extract, Data transform and Data model & Application.
• Data Extract would load the Data from the data sources into the QVDs.
• Data transform will transform the data and Application layer is User Interface Design layer where we layout all our Charts, Tables and List Boxes.
• Implemented section access for row, object, column and sheet level security.
• Developed Dashboards included customer detail drilldowns, threshold gauges and alerting mechanisms.
• Extensively worked on performance (DB, Design and UI level) for fast response of the application/dashboard based on the end user selection.
• Deployed the QlikView applications in the server. Created Publisher Tasks in QMC for the QlikView Application to Reload and Distribute the QlikView Application on to the Access Point.
• Scheduled the Publisher Tasks Daily/ Weekly/ Monthly on various Dashboards based on the Database updates.
• Involved in setting up the Development and Production Environments for QlikView. Responsible for user and server management.
• Helped end users to design test cases and worked through multiple UAT cycles.
• DevelopedQlikViewapplications based on Incrementally Load Transactions using QVD files.
• Involved in daily standup with business analysts and data architect to resolve the business issues and Data challenges.
• Worked independently and capable of multitasking & prioritizing in a fast paced and agile work environment.

Environment: QlikView 11.x/10.x, Oracle 11g, MS Office, Windows 2008 R2 Server, Toad, Informatica Power Center.

Confidential, San Francisco, CA.

SQL Developer

Responsibilities:

• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• Wrote several VB programs for a new application to receive price data from an external vendor and integrate this data into the existing asset databases.
• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa
• Designed and created Microsoft Excel spreadsheets to implement mathematical data analysis models and to provide an attractive and functional user interface.
• DesignedSSIS packages to extract data from different sources like SQL server 2008, MS Excel, MS Access, transform and then load intoDimension and Fact tables in Data Warehouse using SSIS.
• Involved in Performance Tuning activities including Query Tuning and Index Maintenance.
• Created Triggers to monitor activities on server as well as database and generate alerts and notifications.
• Extensively used Profiler to identify and repair database lockups, deadlocks, and other issues.
• Involved in preparing unit testing, System integration testing, implementation and maintenance.
• Responsible for data conversion activity for System Integration and User acceptance testing.
• Involved in Production Support to resolve end-users data related reports issues.
• Testing and debugging the existing procedures.
• Assisted in documentation of the Tech Specification and Use Case Specification.
• Implemented database triggers based on the business rules and requirements.
• Used exception-handling methods along with RAISE APPLICATION ERROR in order to associate our own created exception names.
• Involved in Performance tuning and Query Optimization.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations

Environment: MS SQL Server 2008R2, SQL server Reporting Services 2008R2, MS SQL Server Integration Services, MS Visual Studio 2008/2010,MS Access.

Confidential

SQL Developer

Responsibilities:

• Involved in analysis, design and development of the system.
• Created database Objects Tables, Indexes, Views, Synonyms
• Tested queries to optimize the procedures and triggers to be used in production.
• Involved in Performance tuning and Query Optimization.
• Used SQL Developer to Load / Extract data into and from Excel files.
• Used Hints, Explain Plan, and Indexes for query tuning and optimizations.
• Conducted impact analysis and designed structures to enhance performance.
• Involved in data cleaning, merging and conversion.
• Created stored Procedures, Functions, and Triggers by generating the specified reports.
• Tuning of the SQL queries using Explain Plan, SQL*Trace.
• Created the database from full export for the Table space point in time recovery.
• Modifying the database design and structure, as necessary, from time to time upon information given by application users and developers.
• Implemented integrity Constraints on database tables.
• Involved in preparing documentation, Testing and debugging.

Environment: Sun Solaris 7, Oracle9i, Oracle Enterprise Manager, SQL*Trace, Erwin Data Modeler.