PROFESSIONAL SUMMARY:

• Experience in gathering Business Requirements, Planning, Analysis, Design, Development, Testing and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence applications (QlikView, Oracle OBIEE)
• Experience in various development Methodologies like SCRUM, AGILE.
• Experience in Application/Production Support.
• Expertise in BI Applications (QlikView, OBIEE) Data Models using data sources - Oracle, Teradata, SQL Server, QVD files, text files and Excel documents.
• Extensive knowledge on Data modeling, Dimensional Modeling, Star/Snowflake Schemas.
• QlikviewNprinting development and integration.
• Experience in BI Application - QlikView objects, including charts types, Trend Lines, KPI’s, Bookmarks, Pivoting, custom requests for Excel Export.
• Experience working on data modeling and developing complex models for business users.
• Creating integrations in QlikSense using QlikSense Web Services/API's
• Connected custom data sources using QlikSense using Qlik data eXchange(QVX).
• Managed all data and configuration information using QlikSense API’s.
• Created QlikSense Extensions to reach to requirements.
• Created various charts like bar chart, combo chart, pie chart and Pivot table in QlikSense
• Upgrade Projects Involved in QlikView upgrade from 10.0 to 11.0 and 9.0 to 10.2 versions, OBIEE Upgrade from 10g to 11g and 11g to 12c.
• Experience in managing QlikView security, architecture, design components, user profiles, and authentication mechanisms.
• Developing SQL queries on Databases as per business data requirements.
• Experience in HP Quality Center (HPQC).
• Developing BI Application - OBIEE Repository(Physical Layer, Business Model & Presentation Layer).
• Working knowledge of QlikSense Extensions for business views.
• Expertise in ETL (Data Extraction, Transformation & Loading), Data modeling, Report designing and Performance Tuning using QlikView
• Experience using QlikView objects - Straight tables, Pivot tables, Containers, Line charts, Bar charts.
• Building QlikView - QVD’s and QVW’s
• Expertise in creating Design Specification Documents to facilitate the development cycle.
• Configured DAC (Data Warehouse Administration Console) for Creating Execution plans, Metadata Management and Monitoring the Informatica ETL Process.
• Security Implementation using Section Access script,dynamically hides selected areas of the dashboard depending upon user privileges.
• Experience in implementing triggers using macros to provide custom functionality in Dashboards.
• Expertise in optimizing the existing QlikView Dashboards with a focus on usability, performance, flexibility, testability, and standardization.
• Expertise in writing test case scenarios.
• Experienced in writing complex SET Analysis expressions.
• Experience in QlikView Server and Publisher maintenance - scheduling and monitoring Incremental Loads and Report Reloads.
• Good understanding in QlikSense features.
• Good Knowledge and experience in Performance Tuning of reports with complex database joins and tuning query logic in reports.
• Data analytical Skills and debugging for data accuracy and data integrity.
• Developing SQL queries, Views and Stored Procedures for BI Applications QlikView, OBIEE.
• Working Experience with parallel development teams in multiple projects.
• Proficient in coordinating and managing the activities between onsite and offshore teams.
• Understanding of QlikView application administration encompassing Planning/ Implementing User, Resource and Password Management, Backup & Recovery Strategies, Performance Tuning, Creation and Configuration of database on Oracle.
• Implemented Data Level Security, Object Level Security and LDAP authentication.
• Designed, implemented and tested security privileges on subject areas, dashboards and reports.
• Experience on OBIEE Administration Tool, Answers, Intelligent Dashboards and Repository (RPD) development.
• Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse.
• Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and Informatica Work Flow Monitor.
• Involved in the full System Development Life Cycle (Analysis, Development, Deployment, Testing and Documentation).
• Work well in teams as well as independently.
• Excellent client facing and strong communication skills.

TECHNICAL SKILLS:

BI Tools: QlikView, QlikSense, OBIEE 11g/10g/9i, OBIA/BI APPS 7.9.6x/7.9.5, Data warehouse Administration Console (DAC) 11g/10g, BI Publisher.

ETL/Data Modeling tools: ODI (Scenarios), Informatica 9.x, ODI 11g (11.1.1.6.0 )

Database: Oracle 12c/11g/10g/9i, MS Access, Teradata, MS SQL Server 2000/2005

Operating Systems: Windows, LINUX, UNIX

Tools: TOAD, SQL*Plus, SQL Developer, Golden Gate, Tortoise, SVN

Languages: SQL, PL/SQL, C, Java, Shell Scripting, XML and PERL

WORK EXPERIENCE:

Confidential, Chicago, IL

BI Consultant (QlikView/QlikSense)

RESPONSIBILITIES:

• Developing QlikView Dashboards using Variousfunctionalities of QlikView - Chart types: Line, Bar, Combo, Trellis and Gauge charts, drill down, drill up.
• Design, develop and test QlikView scripts to import data from source systems and test QlikView dashboards to meet business requirements.
• Implementing web application security and concepts - SSL, LDAP Authentication.
• Managing Data in QlikView application from QVDs excel files, database and external loading files.
• Creating Mashup and integrations in QlikSenseusing QlikSense Web Services/API's
• Working on Qlik Scripting, data analysis, BI Data Models, Nprinting Integration.
• Developing/CreatingQlikSense Extensions to meeting business requirements.
• Developing/building dimensional model for facts and dimensions tables.
• OptimizingQlikView performance by creating QVD’s from DWH and configuring incremental reloads to reduce load on DB Server.
• Performing reload tasks and distribution tasks using the QlikView publisher.
• Business User Engagement for overview of QlikView/QlikSense and performing training sessions for End Business users.
• Managing security layer with access management at the user level.
• Utilizing extensions for QlikSense Apps to meet the business expectations.
• Image Insertion into Pivot table, creating scattered charts based on requirements.
• Reviewing Business requirements and achieving business goals/needs using QlikView reporting tool.
• Modifying existing QlikView dashboards, communicate with the business users in case of any issues with using the applications and providing solutions.
• Performing detailed analysis of source systems, source data and model that data in QlikView.
• Performance tuning of QlikView dashboard in order to reduce the calculation time and improving the overall performance of the dashboard.

Environment: QlikView11, QlikSense, Oracle (11g/12c), SQL Developer, MS Office, Windows, LINUX/UNIX, HPALM/HPQC.

Confidential, Portland, OR

BI Consultant (QlikView/QlikSense)

RESPONSIBILITIES:

• Developed QlikView Dashboards using Various Chart types like Line, Bar, Combo, Trellis and Gauge charts.
• Designing and developing QlikView dashboards to support reporting and Business Intelligence expectations.
• Manipulating QlikSense Extensions.
• Creating integrations in QlikSense using QlikSense Web ServicesAPI.
• Installations and configurations of QlikView Server.
• Perform detailed analysis of source systems and source system data and model that data in QlikView.
• Design,develop,andtestQlikViewscriptstoimportdatafromsourcesystemsandtestQlikViewdashboards to meet customer requirements.
• Business requirements analyzing and developing dashboards and reports.
• Developing and maintaining technical design documentation.
• Performing quality coding to business and technical specifications.
• Coordinated with Team Members in development process to integrate with the Test and Production Servers.
• Configuring and deploying the applications in the access point using QlikView Server/Publisher.
• Identified bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that business needs meet.
• Creating Variables and Triggers to enhance functionality of QlikView
• Creating tasks and deploying applications in access point using QlikView Enterprise Management Console.
• Managing QlikView Server to run and operate in the most efficient manner.
• Work directly with business units to define and prototype QlikView Applications.
• Extracting, transforming and loading data from multiple sources into QlikView applications.
• Building QVD’s from SQL Server Database, Stored procedures and Excel files
• DesigningUser Interface (UI) based on the Business requirements
• Developing QVD scripts to load history and current data using Incremental logic
• Utilizing Stored functions to store QlikView Data into CSV files to create business reports
• Developing/Creating PDF reports and job scheduling to generate PDF’s for business users.

Environment: QlikView 10/11, QlikSense, Oracle 11g, SQL Developer, MS SQL Server, MS Office, Windows, LINUX/UNIX, HPALM/HPQC.

Confidential, Portland, OR

BI Consultant (QlikView/OBIEE)

RESPONSIBILITIES:

• Developing QlikView Dashboards using Various Chart types like Line, Bar, Combo, Trellis and Gauge charts
• Developing,andtestQlikViewscriptstoimportdatafromsourcesystemsandmanaging QlikViewdashboards to meet customer requirements.
• Building QVD’s from Hadoop, Web Services using SOAP request, Teradata, Oracle, and Sales Force.
• Managing onsite team members for develop dashboard and reports.
• Identifying data sources and targets for data modeling.
• POC Activities, ROM Estimation, Scrum estimates for developing dashboards.
• Utilizing Section access and Sheet access to ensure application is available for business users.
• Managing Data from Databases to QlikView and Developing Dashboards to meet business requirements.
• Performing Trainingsessions for users to create dashboards using Qlikviewfunctionality.
• Developing user defined document for Business Analysis.
• Optimizing data models by manipulating loading scripts to load data to improve performance.
• Engaing in QlikView management console activities.
• MonitoringandMaintenanceofall BIcomponentsod DWH and BI.
• Developing SQL Queries to execute data from DB with better performance.
• Exporting and Printing data in QlikView.
• Developing SQL Queries to fetch data for dashboard reports.
• Converted QlikView Dashboard to QlikSense App.
• Created Input boxes, Pivot Tables, Straight Tables, Bar Charts, Buttons, Multi boxes on the UI to make it more accessible to User community
• Developing charts like Bar, Line, Combo, Pie charts to show various KPI’s and Scorecards.

Environment: QlikView 11, QlikSense, OBIEE 11.1.1.7, Oracle 10g/11g, SQL Developer, MS SQL Server, MS Office, Windows, LINUX/UNIX, HPALM/HPQC.

Confidential, Los Angeles, CA

BI/ ETL Consultant

RESPONSIBILITIES:

• Implemented Financial Analytics, Supply Chain and order Management Analytics, Integrated data from Finance and other enterprise systems.
• Extensively used all the features of Informatica Versions 9.1, including Designer, Workflow Manager and Repository Manager, Workflow monitor.
• Setup of Multi User Development Environment (MUDE) in OBIEE.
• Performed the Setup, Installation and Configuration of the complete Analytics platform environment OBIEE, Informatica and DAC.
• Designed and Developed Procurement and Spend and Supplier Performance, General Ledger, Payables, Receivables, Profitability, Dashboards in OBIEE.
• Designed and Developed General Ledger, Payables, Receivables, Profitability Dashboards in OBIEE.
• Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE suite.
• Detailed knowledge in Data warehouse Administration Console (DAC) and Informatica Servers.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and Informatica Work Flow Monitor.
• Analyzed, Designed, and Developed OBIEE Metadata repository (RPD) that consists of Physical Layer, Business Model and Mapping Layer, Presentation Layer.
• SSL, LDAP Configurations on OBIEE and NMS Servers.
• Working with HP quality Center(HPQC).
• Working on Zenoss Application Tool.
• Monitoring Golden Gate Replication.
• SSH Keys Authentication on Linux Servers.
• Migration of OBIEE Reports to another Environments.
• Performance Testing activities on the Servers.
• Analyzed, Designed, and Developed OBIEE Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer and Presentation Layer.
• Worked on Repository manager to create and manage user profiles, and used Repository manager extensively while migration the code from development to production and compared both codes.
• Defined Dashboards, Filters, and Prompts as per user’s requirements.
• Handling larger database queries and applying transformations to make the business solution applicable to project.
• Involving in database Cloning Activites through the Environments.
• Created users in Informatica, assigned them various permissions.
• Setup of Multi User Development Environment (MUDE) in OBIEE.
• Wrote documentation to describe program development, logic, coding, testing, changes and corrections.
• Implemented Financial Analytics, Enterprise Asset Management Analytics, Procurement and Spend Analytics.
• Managed   security privileges   for each subject area and   dashboards   according to user requirements.
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Application level.
• Developed Dashboard pages related to Inventory, Order Fulfillment and Order Management.
• Developed Dashboard pages like Balances, Exceptions, Customer Report, Margin Analysis and Revenue.
• Setup of Multi User Development Environment (MUDE) in OBIEE.
• Involved in Integrating Oracle BI Presentation Services with BI Publisher.
• Working with the Business Analysts and the QA team for validation and verification of the development.
• Designed and Developed General Ledger, Payables, Receivables, Profitability Dashboards in OBIEE.
• Developed complex mappings using corresponding Source, Targets and Transformations like update strategy, lookup, stored procedure, SQL, sequence generator, joiner, aggregate, Java and expression transformations in extracting data in compliance with the business logic.
• Extensively used Informatica Power center and created mappings using transformations to flag the record using update strategy for populating the desired slowly changing dimension tables.
• Querying and analyzing multiple databases and handling the errors as per the client specifications.
• Created server optimized database routing and mappings and focused on performance tuning.

Environment: Informatica9.1,OBIEE 11.1.1.6, BI Apps 7.9.6.4, DAC 11g.Oracle 10g, MS SQL Server, PL/SQL, SQL*Plus, SQL Developer, Unix/Linux, Windows,