SUMMARY

• Over 8+ years of IT experience with around 4 years of experience in Designing and Development of Business intelligence application using QlikView BI analytical suite.
• Extensive experience in developing different analytical applications using QlikView suite of Products (QlikView Server, Publisher and QlikView Enterprise).
• Expertise in Creating Dashboards using QlikView 9.0/10.0/11.2 using different data sources like Oracle, SQL Server, QVD files, text files, excel and generated dashboard as per the user requirement.
• Designing Data Mart and Data Warehouse and Implementation of Qlikview for BI (Business Intelligence) Reporting Solutions.
• Involved in ETL processing (data cleansing, Joins, Aggregation Tables) using QlikView capabilities.
• Develop Dashboard reports using various QlikView Objects.
• Expertise in Data Modeling (Star Schema, Snow Flake Schema).
• Developed ETL Scripts to resolve Circular Relationships, Synthetic Keys & Modeling Issues.
• Strong Skills in Providing Custom functionality using Macros, Triggers.
• Installation & configuration Of Qlikview components in distributed and singleton setup.
• Experience in Incremental Loading to reduce load on DB and achieve optimal reload time.
• Sound skills in writing SQL Scripts, Pl/SQL Stored Procedures.
• GUI (Graphical User Interface) programming in Visual Basic for desktop application.
• Strong Database Development skills using SQL Server, Oracle, Sybase etc.
• A team player with good interpersonal skills and work independently.
• Strong Skills in providing Training for End Users.
• Analyzed reporting requirements to usable long term dashboard and reporting solutions, develop solutions as necessary.
• Good knowledge and hands on experience in other BI tools like Cognos, Business Objects etc.
• Involved in Optimizing existing QlikView dashboards with a focus on usability, performance, long - term, flexibility, and standardization.
• Conduct validation of existing reporting, User Acceptance testing and new solutions to ensure continuous accuracy and front end ease-of-use.
• Experienced in Training & Supporting end-user reporting needs using QlikView & Cognos products.
• Onsite-Offshore coordination in delivering Business Intelligence Solutions.
• Excellent knowledge in Implementation of Relational Database (OLTP), Data warehousing systems (OLAP) and Data Marts.

TECHNICAL SKILLS

QlikView Tools: QlikView Server, QlikView Publisher, Management Console, QV Ajax Client, QV IE Plug-in and OCX controls.

Other BI tools: Business Objects 6.5/XIR1, Cognos 8 BI

ETL Tools: Informatica, SSIS

RDBMS: Oracle 10g/9i/8i, SQL Server 2000/2005/2008 , DB2, Sybase 11.5, MS Access

Operating System: Windows 2003/2008/XP

Web Applications: IIS 7.5, Web Logic 8, Tomcat 4.0x/ 4.1x.

Languages: SQL, PL/SQL, DHTML, JSP, Shell Scripting, VB-Script, C, C++

Data Modeling: Erwin 4.0, Visio

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. QlikView Developer /Administrator

Responsibilities:

• Communicated with the business users to comprehend the requirements and Designed Functional Specifications for application development.
• Developed QlikView Dashboards using different Chart, Drill through, Cyclic Groups, List, Input Field, Table Box, Container etc...
• Implemented 3 layer architecture different load scripts so that data stored as QVD’s. Many QVD files will be shared between applications build an elaborate structure.
• Performed full QlikView components installation (Versions 10 & 11.2) in a distributed environment and configured all the components in most possible optimal way.
• Implemented customized entitlements security & involved in Deployment of QlikView Applications.
• Integrated QVW within existing windows based .Net application using OCX controls. Preferences have been stored using custom code.
• Created Dashboards style of reports using QlikView components like Slider, Buttons, Charts, and Bookmarks.
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros.
• Developed load script using QlikView Functions (Date and Time, Keep, Join, Mapping, String, Interval match etc...)
• Developed Linked Tables, Concatenation and solved the loops issues.
• Gathered & loaded data into QlikView from various data sources (Netezza, Vertica, Oracle 11g and excel files).
• Used to solve the issues related to the end users.
• Working knowledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Version.
• Implemented advanced SET Analysis for aggregation calculations so that set of records can be defined in an expression.
• Responsible for the performance and tuning of the application, including performing maintenance/upgrades on applications programs and systems as required.
• Responsible to ensure that all assigned systems and application are defined and tested backup and recovery procedures for critical data.
• Involved in Production Support for QlikView applications & Server.
• Used TOAD, Squirrel to run SQL queries and validate the data in Data warehouse and Data Marts.
• Conducted end user training sessions and prepared the training documentation.

Environment: QlikView 10, 11.2, Netezza, Vertica, Oracle 11g, Toad, Squirrel, Informatica 8.6, Autosys, Windows 2008 R2.

Confidential, Hoboken NJ

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 .
• Developed Linked Tables, Concatenation (Resolving Loops & model ambiguity)
• 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 etc...)
• Writing SQL Scripts to load the relevant Data in QlikView Applications.
• Developed Macros, SET ANALYSIS in provide custom functionality in Qlikview Applications.
• Implemented Security & involved in Deployment of Qlikview Applications.
• Created QVD’s & updated on timely basis as database updates.
• Gathered & loaded data into QlikView from various data sources ( Oracle 10g, .CSV and excel files).
• Generate new QVD files created by ETL logic to feedQlikViewapplications
• Included the enhancement scripts to the existing QV scripts and performed the actual load to test the overall functionality of the application
• Improved the overall performance of the application and redesigned data model applyingQlikViewperformance tuning techniques

Environment: Windows 2007 Server, QlikView 9.0, Oracle 10g, MS Office.

Confidential, Commack NY

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).
• Gathered & 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 the enhancement scripts to the existing QV scripts and performed the actual load to test the overall functionality of the application
• Implemented Security & involved in Deployment of Qlikview Applications.
• Created QVD’s & updated on timely basis as database updates.
• Developed ETL Scripts while loading the data, resolving loops & ambiguity joins.

Environment: Windows 2008 Server, QlikView 10.0, Oracle 10g, MS Office.

Confidential, Dallas TX

BI Analyst / Developer

Responsibilities:

• Gathering requirements from business users and developed technical specifications.
• Strong understanding in creating Dashboards, scoreboards for the required KPI’s in QlikView.
• Developed load scripts to work with multiple data sources (SQL, Flat Files, Excel, and MS Access).
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Date Island.
• Writing SQL Scripts to test Data in QlikView Applications.
• Developed SET ANALYSIS in provide custom functionality in Qlikview Applications.
• Involved in Deployment of Qlikview Applications.
• Created QVD’s & updated on timely basis as database updates.
• Developed ETL Scripts while loading the data, resolving loops & ambiguity joins.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Involved in migration of Cognos reports to QlikView dashboards.
• Performed detail analysis on Cognos frame work model, Transformer cubes, Source DB model and prepared functional Qlikview specifications.

Environment: Windows 2005 Server, Oracle 10g, MS SQL Server 2005, Cognos 8, QlikView 9, MS Office.

Confidential, New York NY

Cognos Developer

Responsibilities:

• Involved in gathering and analyzing business requirements
• Created relational and multidimensional models in Framework Manager and created relationships between the query subjects, deployed packages to the cognos connection portal
• Developed list, chart, crosstab, master detail, and dashboard reports using report studio.
• Created reports that involved conditional formatting, drill through, prompts, render variables and conditional blogs.
• Created dash-board and scorecard reports with drilldown and dynamic views according to the user requirements.
• Created query prompts, calculations, and filters in the reports.
• Deployed packages and reports to test environment.
• Tested and validated the report output against the database for performance measurement
• Created multi dimensional cubes, cube groups, power play reports using transformer
• Created prompt pages, cascading prompts, templates in the report.
• Applied drilldown, slicing and dicing operations on the power play cubes.
• Executed scripts to refresh the cubes on weekly and daily basis.
• Created user Prompts, conditions, and filters for various reports to specify the reporting parameters as per business requirements.

Environment: Cognos 8.2(Report Studio, Query Studio, Analysis Studio, Cognos Connection), Cognos 8 BI Modeling, Teradata, Impromptu, Oracle (SQL), SQL Server 2000 and Windows 2000

Confidential

SQL/Cognos Developer

Responsibilities:

• Used Multidimensional analysis for Data Retrieval using PowerPlay structure.
• Created PowerPlay cubes using Transformer.
• Involved in Migrating reports from Impromptu/CRN to Cognos 8.
• Extensively worked on prompts based on the user needs and format required.
• Used Impromptu to create .iqd files and used as source of data in Cognos Transformer to create multi-dimensional cubes to generate PowerPlay reports.
• Designed, Developed & Tested Power Cubes and deployed them in to production.
• Drill down, Slice and Dice and Filtering operations done for all OLAP applications.
• Created and maintained the security of the user classes.
• Used Access Manager to administer security for all the catalogs.
• Defined conditions, calculations and prompts in the catalog.
• Enabled users to access the distributed HTML reports through local network intranet/internet, and via email.
• Used impromptu’s optimizing features like table weighing, governors, bulk fetch.
• Created various reports (List, Crosstab, Mailing Labels, Form Letter, Free Style) using Cognos Impromptu tool by querying the database
• Created standard and Ad-hoc reports (Formats, Layouts, quality data to carry) using Cognos Impromptu tool.
• Creating and executing stored procedures using Sybase.
• Created User Prompts, Conditions and Filters to improve the report generation.
• Production Support which involves solving user problems.

Environment: Cognos Impromptu 7.2, Cognos Power Play Transformer 7.2, Power Play Enterprise Server, Cognos Upfront, Microsoft IIS,Sybase 11.5, SQL Server, HTML, MS-Access, MS-Excel, and Windows NT.

Confidential

BO Developer

Responsibilities:

• Worked on Requirement gathering stage to Reporting stage (End To End)
• Development of Universe using Designer Module in Business Objects 6.5
• Created user response functions, Alerters, Universe level prompts, Merge dimensions, Multiple Data providers in the reports as per user requirements.
• Build the Desktop reports and webi reports using Business Objects Reporting Tool.

Environment: Business objects 6.5, Oracle,HTML, Windows NT.