SUMMARY:

• Around 9 years of Experience of IT experience with 3+ years of experience in Designing and Development of Business intelligence application with Qlikview 9.0/10.0/11.0 as BI tool
• 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.0 using different data sources like Oracle, SQL Server, QVD files, text files, excel documents and generated different dashboard as per the user requirement.
• Experience with Qlikview sheet objects including multiple charts types, Trends, KPI’s, custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting.
• Designing Data Mart and Data Warehouse and Implementation of Qlikview for BI (Business Intelligence) Reporting Solutions.
• Involved in ETL Tasks (Data cleansing, Joins, Aggregation Tables) using QlikView.
• Strong knowledge on Data ware housing concepts like Star & Snowflake schemas, Views, Procedures and much more ETL transformations.
• Developed ETL Scripts to resolve Circular Relationships, Synthetic Keys & Modeling Issues.
• Experience in Incremental Loading & QlikView document Versioning.
• Hands on experience installing & configuring Qlikview Server & Publisher in both clustered and non clustered environments using different types of load balancing techniques.
• Expertise in using QEMC & QMC for creating tasks, Managing schedules and triggers.
• Experienced in Reduce Data, Distribute Qlikview applications.
• Extensively used SET analysis expressions to develop different KPI’s like MTD, QTD...etc over accountable time periods.
• Extensively used section access incorporating row level security.
• Sound skills in writing SQL Scripts, Pl/SQL Stored Procedures.
• Hands on experience working with different kind of databases like Oracle, Sqlserver, SAP BW…etc.
• Experienced in & Supporting end - user reporting needs using QlikView & ETL 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 Developer, QlikView Publisher, Enterprise Management ConsoleManagement Console, QV Ajax Client, QV IE Plug-In.

Business Intelligence: Business Objects XIR2, Cognos 8 BI, QlikView 9.0/10.0/11.0

ETL Tools: Informatica 8x

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

Web Applications: IIS 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, PA

QlikView Developer

Responsibilities:

• Developed Qlikview applications creating expressions using set analysis.
• Created and scheduled Complex reports by leveraging the basic components of Qlikview.
• Participating in business requirements and design review sessions.
• Imported data from multiple data sources including SAP BW (DSO’s, Tables) and MS Excel through OLEDB and ODBC connections and modeling data as per user requirements.
• Creating complex data models without synthetic tables and circular loops.
• Worked on set up and configuration of Qlikview application on I-Pad.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the Qlikview publisher.
• Automated and scheduled daily/weekly/monthly data loads of QVW documents using Qlikview Publisher and error notifications by email to assigned users.
• Created applications using Qlikview Data File (QVD) technology.
• Currently assigned to create dashboards by extracting data from multiple databases, storing into QVD files, write load scripts, and develop UI according to user requirements.
• Optimizing 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
• Providing support analyst when internal teams have enquiries.
• Research and troubleshoot technical problems

Environment: Qlikview 10/11, SAP BW, Oracle 10g, HTML, VB Script, I-OS.

Confidential, Jacksonville, FL

QlikView 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).
• Involved in Requirement gathering & designing QlikView applications.
• Gathering data sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing the QlikView Data Models.
• 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...)
• Developed User Interactive Sheets & Reports as business needs.
• 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.
• 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.
• Implemented security in QlikView Applications.
• Trained End Users on Using QlikView Tools.
• Experience with QlikView Enterprise Management Console (QEMC).
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView Publisher.
• Developed QlikView Applications using SAP Data.
• Involved in up-gradation of QlikView environment from QV 8.5, QV 9.0 versions.

Environment: QlikView 10, QlikView 9.0, Windows 2003 Server, Oracle 10g, SAP BW, Teradata, MS SQL Server 2005, MS Office.

Confidential, Franklin Lakes, NJ

QlikView Developer

Responsibilities:

• Worked with Business Users for requirement gathering and passing on the information to team.
• Connected to Oracle using OLE DB and ODBC data sources connector and tables of SD, inventory, etc. to create and schedule adhoc reports by leveraging the basic components of QlikView.
• Extracted data from various sources (SQL Server, Oracle, text files and excel documents), used ETL load scripts to manipulate, concatenate and clean source data.
• Created and managed ETL script generation using QlikView Script Builder Application.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView publisher.
• Created dashboard style of layouts using different components of QlikView Enterprise like Listboxes, Multiboxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Presented QlikView applications to various levels of user.
• Designed application for Sales & Marketing Modules that Generates GUI Report for easy access through the data.
• Worked with QlikView administrator to optimize QlikView performance.

Environment: Windows 2005 Server, Qlikview 8.5, BOXI 3.1, Oracle 10g, SQL Server 2005, MS Office.

Confidential . Memphis, TN

Cognos Developer

Responsibilities:

• Involved in analyzing, documenting business requirements, functional requirements for developing universes and reports.
• Involved in preparing Business Requirement Documents and Functional specification documents.
• Used Framework Manager to build models, Segments, Security (Object, Data, and Package), set Governors, resolved complex cardinalities and integrated VSS.
• Developed new reports using Report Studio that include master-detail reports, drill-through, prompts, bursting reports, crosstab, charts.
• Good Experience with MDX Functions in Report Studio using Multi-dimensional Sources.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Converted financial reports from MS Excel to Transformer Power cubes and created reports in Cognos Analysis Studio.
• Responsible for definition, deployment and monitoring of important organizational metrics using Cognos Metrics Manager.
• Built models using Framework Manager and power cubes using Transformer.
• Developed Standard Reports, Charts, Drill Through Reports, Master Detail Reports, Bursting Reports and Multilingual Reports Using Report Studio and Query Studio.
• Extensively worked on Analysis Studio to develop multi dimensional reporting.
• Migrated numerous existing Cognos 7.4 impromptu catalogs and Impromptu Reports (IMRs) to Cognos 8 series.
• Worked with ETL team to load data into Data Warehouse/Data Marts using Informatica.

Environment: Cognos 8.3/8.4 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Transformer, Cognos Office Connection), Oracle 10g, Cognos Access Manger, Informatica, Windows Server 2003,MSProject,MSVisio.

Confidential

SQL/Cognos Developer

Responsibilities:

• Developed / modified scripts to create tables, views, rectify data errors and executed them using SQL Plus.
• Ran batch jobs for loading database tables from flat files using SQL Loader.
• Creating oracle instances and maintaining on Windows platform.
• Prepared full set of DDL and DML scripts.
• Involved in performance tuning activities like Optimizing SQL queries, explain plan, creating indexes.
• Developed / modified Oracle PL/SQL codes like stored procedures, functions, triggers.
• SQL Development & Troubleshooting included file groups, data access, ODBC, indexes, stored procedures, triggers and table structures for application behavior manipulation.
• Involved in troubleshooting oracle related issues.
• Day-to-day activities such as backups to the disk and restore the databases and transaction log on production/development servers as per business / IT needs.
• Prepared unit test cases and executed the same.
• Was involved in coordinating between the development and the database team.
• Involved database related technical writing.
• Wrote PL/SQL procedures/packages/triggers for various application purposes.
• Created standard and Ad-hoc reports (Formats, Layouts, quality data to carry) using Cognos Impromptu tool.
• 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, Oracle 8.0, SQL Server, HTML, MS-Access, MS-Excel, and Windows NT.

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.
• Created User Prompts, Conditions and Filters to improve the report generation.
• Production Support which involves solving user problems.

Environment: Cognos Report Net 1.1, Impromptu 7.2, Cognos Power Play Transformer 7.2, Power Play Enterprise Server, Cognos Upfront, Microsoft IIS, Oracle 8.0, SQL Server, HTML, MS-Access, MS-Excel, and Windows NT.