PROFESSIONAL SUMMARY:

• Over 8 years of IT Experience as a Business Intelligence Developer involved in analysis, maintenance, production support and knowledge transfer with good analytical skills. More than 4 years of experience in Designing and Development of Business intelligence application with QlikView as BI tool.
• Extensive experience in developing different analytical applications using QlikView 8.x/9.0/10.0/11.0 suite of Products (QlikView Server, Publisher and Qlikview Enterprise)
• Experienced in creating customized reports, filters and charts in Qlikview.
• Strong knowledge in developing highly informative dashboards using QlikView objects like ListBoxes, MultiBoxes, Tables, Charts, Current Selection Boxes, Buttons, etc and variables, fields, calculated expressions, basic and aggregated functions.
• Experienced in importing data to QlikView from databases, QVD files, text files and connecting to external data sources to generate different dashboard style reporting user interfaces.
• Importing Metadata from different data Sources, creating dimensions and hierarchies, determinants using Star Schema Grouping.
• Expertise in designing data models from multiple data sources in QlikView.
• Experienced in optimizing existing QlikView reports with a focus on usability, performance, flexibility, testability, and standardization.
• Involved in QlikView Administration, Installation and upgrading the Qlikview Server and Publisher, QlikView Web Parts.
• Experienced in creating QlikView Access point for Client application rollout and administrator security by Active Directory technology using QlikView Publisher.
• Design of QlikView applications using QlikView Data (QVD) files generated by ETL logic.
• Good knowledge of Data Warehousing Models, RDBMS concepts, SQL, PL/SQL, Oracle and SQL Server.
• Expertise in optimizing, debugging and testing SQL queries.
• Good working knowledge in Data Modeling including Dimensional Data modeling, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling.
• Worked in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS).
• 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

Tools: QlikView 9.0/10.0/11.0, Tableau, Toad, SQL Developer

Databases: Oracle 9i/10g/11g, R12 EBS, SQL Server, MySQL

Languages: SQL, PL/SQL, Transact SQL, ANSI SQL, PHP, C

ETL Tools: Microsoft SQL Server Integrated Services, Informatica

Web Applications: HTML,CSS, AJAX, Java Script

Operating Systems: Windows XP/Vista/7/8, MS-DOS, Windows 2003, UNIX, Windows Server 2007.

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

Database backup Tools: Red-Gate SQL Backup Pro

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, TX

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 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.
• 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
• Assisted less experienced Business Objects and QlikView users on building their own reports.
• DesignedQVWsto generateQVDs for faster and efficient data reloads.
• Manage Schedule QlikView applications using QlikView Management Console (QMC) QlikView Enterprise Management Console (QEMC).

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

Confidential, Jersey city, NJ

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.
• Designed and implemented the Incremental Load using QVDs.
• Implemented the 3-tier architecture, Data Extract, Data transform and Data model & Application.
• Extensively implemented section access for row, object, column and sheet level security.
• 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.
• Migrated existing QlikView 10 dashboards to QlikView 11 environment, also added new QV11 features to the Dashboards.
• DevelopedQlikViewapplications based on Incrementally Load Transactions using QVD files.

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

Confidential, Dallas, TX

QlikView Developer

Responsibilities:

• Developed proof of concept to check the functional feasibility of the QlikView implementation.
• Studied QlikView and its components and Worked closely with the QlikView Implementation partners.
• Strong understanding in creating Dashboards for the required KPI’s in QlikView.
• Deployed the application on QlikView server and Imported data from different sources like Oracle 10g, MS Access, XML files and flat files using OLE DB/ODBC.
• Mainly designed and developed QlikView applications from scratch, to support reporting and Business Intelligence initiatives.
• Used advanced scripting, set analysis, VBScript and macros, advanced aggregation functions and advanced charts.
• Involved in Deployment ofQlikViewApplications into the server.
• Performed different tasks like extraction, reload tasks, distribution tasks, reduction, deploying apps, scheduling, User management, license management, Clustering and licensing using QMC.
• Testing Applications using review checklists, Data quality for Quality Assurance before delivering to the end users.

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

Confidential, Sacramento, 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 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.
• Extensively used Profiler to identify and repair database lockups, deadlocks, and other issues.
• 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:

• 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 and when required, modified already existing stored procedures, triggers, views, indexes.
• Created SSIS Packages and used OLEDB Source as an existing Oracle Database.
• Involved in Performance tuning and Query Optimization.
• Used SQL Developer to Load / Extract data into and from Excel files.
• Cleaned the data and created fact and dimension tables, performed calculations required for the reports using SQL Server environment and accomplished data modeling.
• Created dynamic Reports from the cube using SSRS 2005, and stored procedures.
• Collaborated with Data Warehouse in impact analysis to crystal reports.
• Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.

Environment: MS SQL Server 2005/2008, SQL server Reporting Services 2008, SQL Integration Services 2008, SQL Analysis Services 2008,Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, ERWIN.