PROFESSIONAL SUMMARY:

• 8+ years of IT industry experience in all aspects of Business intelligence applications with a strong background in Database development, Data Warehousing/ Decision support systems and Business Intelligence (BI).
• Experience in Designing and Development of Business intelligence applications with Qlikview 11.2/10.0/9.0 as BI tool.
• Strong experience in Qlikview Product family such as Qlikview Desktop Client, Qlikview Management Console, Qlikview Server.
• Expertise in using complex multiple data sources such as SQL, Flat Files, Excel and Access for designing and modeling of Qlikview.
• Experience in using ETL Tasks such as data cleansing, joins, aggregation tables using Qlikview.
• Designing Data Mart and Data Warehouse and Implementation of Qlikview for BI Reporting Solutions.
• Extensive knowledge with Dimensional data modeling, star schema, snow flake schema, Fact and dimensional tables.
• Created scheduled jobs for QVD extracts and report reloads.
• Hands on experience in SDLC processes and methodologies in Business Intelligence domain.
• Developed business requirements, dashboard development, and data verification and analysis.
• Experience with Multiple Relational Databases including Oracle, MS SQL Server, DB2 and MS Access.
• Experience with Qlikview sheet objects Pivot, List, Multi box, multiple charts types, KPI’s, custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting.
• Experience with Oracle Application Modules - Account Payables, Order Management, Purchase Order, Account Receivables, General Ledger.
• Excellent technical, analytical, and problem solving skills. Strict attention to detail and ability to work independently as well as within a team environment.
• Expertise in implementing Oracle BI Apps like implementing Out of order Box prebuilt mappings, Creating Oracle provided Data Warehouse, OBIEE RPD development, OBIEE reports and Dashboards, Upgrading the versions.
• Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas. 3 layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill-down capabilities using global & local Filters.Excellent written, oral communication and interpersonal skills.

TECHNICAL SKILLS

Business Areas: Applications & Systems Analysis, Design and Development

Business Functional Areas: Sales and Marketing, Finance, Operations

Operating Systems: Windows

Reporting Tools: QlikView 11.2/10.0/9.0, OBIEE 10

ETL Tool: Informatics 8/9.x (Source Analyzer, Data warehousing designer, Mapping, Designer, Mapplet Transformations)

Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling

PROFESSIONAL EXPERIENCE:

Confidential, Peoria, IL

QlikView Developer

Responsibilities

• Gathered the requirements from Business Users and passed on the requirements to the team.
• Involved in designing the Data model and Construction of the Data model and implemented the Star schema for QV better optimization.
• Created Dashboard reports to track all the way through ship to final acceptance phases.
• Developed executive dashboards in QlikView delivered through the web, enabling to measure the performance of the business with analytical capabilities.
• Installed, configured and deployed the application on QlikView server and Imported data from different sources such as Oracle, SQL Server, MS Access, XML files and flat files using OLE DB/ODBC.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView Publisher.
• Involved in up-gradation of QlikView environment from QV 10.0, QV 11.0 versions.
• Designed, developed, implemented and tuned multiple QlikView applications for the Sales, IT.
• Created dashboards with complex sheets which include List boxes, Statistic boxes, containers, different charts (bar charts, scatter charts, Heat charts, and Block charts and pie charts) to show the statistics of the sales held on different products in different years.
• Created static reports using straight tables and pivot tables with spark lines and mini charts
• Dynamically creating the WHATIF analysis reports by modifying the input data though slider object and input boxes
• Created Layout themes and applied it to several QVW’s
• Used advanced scripting, Alternate states for comparative analysis, set analysis, VBScript and JavaScript macros, advanced aggregation functions, advanced charts for applications and Document chaining
• Involved in performance tuning of dashboards to improve the response time for the users accessing the documents via access point by reducing the size of the QVW
• Good understanding in the area of monitoring the various services in QMC, Task setup, Managing client licenses, Mounting folders, session collaboration, enable session, performance and audit logging, type of authorization (NTFS and DMS),loop and reduce and Section access management in PAT

Environment: QlikView10, QlikView11.0, QEMC, SQL Server, DB2, Windows 2008 server, HTML, VB Script & Java Script, QViewer, Microsoft TFS, MS Excel, Geoqlik.

Confidential, Atlanta, GA

QlikView Developer

Responsibilities

• Project requirement gathering, coordination with business analyst and pre sales teams
• Involved in designing of Qlikview solutions & full lifecycle implementations
• Implemented the QVW files in a 3 tier architecture by loading the data from various external data sources thereby creating optimized QVD’s and then building applications using transformed QVD’s
• Develop efficient Qlikviewdata models using flat files, SQL 2005, MS access and Oracle
• Setting up of tasks, reloading data and refreshing the applications on a scheduled basis using Qlikview Management Console
• Implemented section access for the applications
• Developed Qlikview Dashboards which comprises various charts, Objects, Drill down & Cyclic grouping, Alerts, Variables, Input boxes, Calendar & macros
• Experience in using Qlikview functions (AGGR, PICK, MATCH, Date and time, Keep, Join, Mapping)
• Developed User Interactive Sheets & Reports as business needs.
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts and Bookmarks.
• Experienced incremental loading, PDF report generation and auto emailing of reports
• Extensive use of SET analysis expressions in charts and shown the critical KPI’s in gauge charts
• Implemented binary load and hidden script
• Implemented security and involved in deployment of Qlikview applications, used windows scheduler, batch files for refreshing QVD and QVW
• Utilized QlikViewPublisher andQlikViewServer capabilities though QEMC tool

Environment: Qlikview10, QEMC, Oracle, SQL Server, Toad 9.6.1/SQL Developer, SQL Loader and Windows 2007.

Confidential, Charlotte, NC

Qlikview Developer

Responsibilities:

• Strong understanding in creating Dashboards for the required KPI’s in Qlikview.
• Created various Flags based on users requirements.
• Dashboards included customer detail drilldowns, threshold gauges, alerting mechanisms and pop report.
• Developed load scripts to work with multiple data sources (SQL, Flat Files, Excel, and MS Access).
• Performed different tasks such as repeat tasks, reload tasks and distribution tasks using the Qlikview Publisher.
• Trained End Users on Using Qlikview Tools.
• Designed application for Sales & Marketing Modules that Generates GUI Report for easy access through the data.
• Created dashboard style of layouts using different components of Qlikview Enterprise such as Listboxes, Multiboxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Performed testing of dashboards for functionality, data, performance, look and feel.
• Managed schedules and reloading of QlikView data model QVDs and QVWs through QlikView Enterprise Management Console (QEMC).
• Involved in Script development, script functions, script variables, inline load, QVWs, QVDs, set analysis and section access.
• Installed IE plugins and trained the end users to use the reports effectively, to build and customize their ad-hoc reports.

Environment: Windows 2000 Server, Qlikview10.0, Oracle 10g, SQL Server 2005, MS Office.

Confidential, Boca Raton, FL

QlikView Consultant

Responsibilities:

• Gathered the requirements from Business Users and passed on the requirements to the team.
• Involved in designing the Data model and Construction of the Data model and implemented theStar schema for QV better optimization.
• Created QVDs by importing data from the database tables using QlikView load script.
• Expert in Working with Charts such as Table Box, Pivot table, Straight table, Pie, Gauge etc.
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc.)
• Implemented Macros, Filters, Variables, Set Analysis, Aggregate functions and Mapping functions to achieve user requirements.
• Created reports using QlikView functionalities like combined queries, include KPI formula.
• Performed functional testing of the application.

Environment: Qlikview9,SQL Server 2005 Enterprise, Windows Enterprise Server 2003, Visual studio 2005,SQL Server, HTML, MS-Access and MS-Excel.

Confidential

OBIEE Consultant

Responsibilities:

• Translated the business requirements into conceptual and detailed technical design documents.
• Identified the granularity level of the data required to be available for analysis.
• Worked as an Application Designer for Mapping & Designing RPD and ETL development.
• Documented Application Design Mapping & ETL Mapping, which helps Developers to implement ETL and RPD.
• Designed and Developed Custom Business Intelligence Solutions (Metadata and Dashboards/Reports) using OBIEE platform.
• Developed the OBIEE Metadata repository (.rpd) model with the necessary logic that involved creating the Physical, BMM layers with aggregates, dimensions & time series functions, Presentation layer with catalogs & folders and external table security using Siebel Server Admin tool. Also created hierarchies, variables, and event poll strategies in the repository.
• Designed report sand dashboards in Siebel/OBI Answers as per the user requirements.
• Configured Interactive Dashboards with drill-down capabilities using global and local Filters.
• Implemented Dynamic Navigation to allow the system to pass parameters from the summary dashboards to the details dashboards.
• Managed OLAP databases in development, test, staging and Production Environments.
• Implemented Groups and Hierarchy Level Based security to dashboards based on Role.
• Configured and automated iBots to deliver daily and weekly reports based on schedule.
• Performance Tuning of Reports by implementing the aggregate navigation, Cache and Oracle Materialized Views.
• Involved in the Development of Custom Mappings, Sessions and Workflows using Informatica.

Environment: Oracle 9i, Oracle Enterprise Manager, Oracle Developer 6.0/6i, SQL, Informatica8.6.1, SQL*Plus, Windows 2000, UNIX (Sun Solaris), TOAD.

Confidential

PL/SQL Developer

Responsibilities:

• Interacted with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
• For complex business queries involving multiple tables from different databases used Joins, correlated and non-correlated sub-queries
• Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of requirements.
• Enforced business rules via checks and constraints.
• Developed SQL queries to fetch data as per the business requirements with proper tuning techniques.
• Created checks and constraints to maintain data integrity across the data in the database.
• Created Stored Procedures to generate various Drill-through reports and functions to support efficient data storage and manipulation.
• Migrated actuate code of data extract to PL/SQL equivalent and Created PL/SQL functions, packages, procedures and joins.
• Worked on various back-end Procedures and Functions using PL/SQL.
• Wrote necessary PL/SQL API scripts for successful running of the programs.
• Created required technical documents, technical specifications, test results.
• Scheduled SQL Server Agent Jobs to run every day to update changes in the base tables.
• Used Exception Handling for handling errors of programs, scripts and procedures.
• Analyzed the pros and cons of migration and conveyed the same to the Business Analyst.
• Followed company guidelines and processes to complete the tasks.
• Complete responsibility of deliverables as well as the production support.

Environment: Windows 2000, TOAD, SQL Developer, UNIX, Windows XP.