Kumar

972-***-****

ab7f5d@r.postjobfree.com

SUMMARY:

. Around Eight Years of professional experience in Complete Software

development Life cycle (SDLC) of Database, Data warehouse and Business

Intelligence Applications.

. Experience developing and implementing OBIEE as enterprise wide

reporting solution in Government, Insurance and Banking clients.

. Strong experience in OBIEE 11.1.1.6/10.1.3.x/Siebel Analytics 7.x,

which includes Administration tool, Intelligent Dashboards, Answers,

Delivers, Oracle BI Publisher, and Oracle BI Applications 7.9.5 (DAC).

. Installed and configured different versions of OBIEE, Oracle BI Apps

(DAC), & Informatica

. Very strong experience in building Siebel Analytics/OBIEE Repository

(.rpd file) at three layers (Physical Layer, Business Model and

Mapping Layser & Presentation Layer).

. Good hands on experience in using BI Publisher 11g/10g to create

reports from BI Answers, BI server.

. Strong working experience in configuring and scheduling actionable

intelligence and BI Delivers.

. Created and designed complex reports using Oracle BI Publisher and

delivered them to user in various formats (PDF, EXCEL, Interactive

Viewer, and RTF).

. Extensive experience in using OBI Answers for creating different

Requests, Filters, Views, Charts, Interactive Dashboards with page and

dashboard Prompts.

. Strong experience in creating Logical tables and columns, Dimensional

Hierarchies, Level Based Measures, Time series data, and Repository

Variables.

. Experience on bursting and scheduling BI Publisher reports.

. Experience in using Aggregate tables, Partitions & Fragments to

improve performance.

. Expert in writing complex SQL queries, creating different PL/SQL

Objects, Fine Tuning the code.

. Experience in security tasks like creating user groups, users and

managing users by setting up their privileges and profiles.

. Strong expertise in Implementing MUD (Multi User Development)

Environment.

. Experience in data warehousing such as dimensional modeling, star and

snowflake schemas, data marts, fact and dimension tables

identification.

. Experience in preparing Technical Documentation & Training Users on

DW/BI Products.

. Worked on Test Scripts, Test Cases to perform Unit testing, System

Testing and Load testing.

. Worked with Business Analysts /Users to identify information needs and

business requirements for reports and finalizing Requirement

Specifications, Design Specifications.

. Business Analysis experience and broad understanding of business

operations and requirements.

. Good Communication and Interpersonal Skills, resulting in excellent

rapport with employees and executive management.

. Ability to understand new concepts and applications and experience

working with business user's community and leads/managers.

TECHNICAL SKILLS:

. Reporting Tools : OBIEE 11G & 10G (10.1.3.x, 11.1.1.x), Oracle

BI Publisher (10.x/11.x), Siebel Analytics

7.8.4/7.7.1/7.5, Crystal Reports, EXCEL

. ETL : Informatica 9.0.1/ 8.x/ 7.x/6.x, ODI

11.1.0

. Database/Tools : Oracle 11g/10g/9i/, DB2, People Soft 9.0, DB2,

SQL Server 2008/2005/2000, MS Access,

TOAD, SQL Navigator

. Languages : SQL, PL/SQL, C, C++, Java

. Operating Systems : UNIX, Linux (Red hat enterprise) and WINDOWS

98/2000/2003/2008/NT/XP

. Other : Erwin, Java Script, VB Script, HTML, XML,

MS Word, Excel

EDUCATION:

. Bachelor of Technology, JNTU, India

PROFESSIONAL EXPERIENCE:

Cisco Systems Inc, San Jose, California

Jan'2013 - Till Date

Role: OBIEE Developer

Description: This project is to provide the Quarterly Business Review for

the client side business. The reports are developed in this projects are

for Services, Products and Order families for users.

Responsibilities:

. Participated in gathering and analyzing the Business Requirements.

. Developed complex Teradata SQL queries as per the business

requirements.

. Extensively used BI Publisher 11.1.1.6 for generating various types of

reports from different data sources

. Developed Business Views (BVs) from the 3NF tables used for the

reporting purpose and created BVR document.

. Provided the capability to download the reports in the user defined

formats from BI Publisher.

. Worked on creating templates, reports and prompts for/within BI

Publisher.

. Developed the reports for Services, Orders, Products and Repair

Orders.

. Performed Unit testing, integration testing to verify the report

functionality and debugged dashboard reports to verify data matches as

expected.

. Trained the off-shore resources on how to develop the reports using BI

Publisher.

. Trained users on using the BI Publisher for running the reports in the

web.

Environment: OBIEE 11.1.1.6/10.1.3.4, BI Publisher 11g/10g, DAC 10.13.4,

Informatica Power Center 8.6.1, Teradata SQL Assistant, Oracle 10g, SQL,

TOAD, Windows7

OHIO Department of Aging, Columbus

Aug' 2011 - Dec'2012

Role: OBIEE Developer

Description: This project is to provide the technological needs for various

departments and the aging network. Staff design, implement and support the

department's primary network as well as specialized information

infrastructures (i.e., databases, applications, T1 communications) for

agency programs and entities.

Responsibilities:

. Conducted jad sessions with users, analyzed business requirements and

checking the technical feasibility of the requirement from various

sources, ensuring the needs and delivery feasibility.

. Developed OBIEE 11G based reporting solution against Peoplesoft ERP

table sources

. Extensively used OBIEE 11G for customizing and modifying the Physical

layer, BMM and Presentation layers of the repository (.rpd).

. Developed the repository model for the different work streams with the

necessary logic that involved creating the Physical, BMM and the

Presentation layer. Also created hierarchies, variables, and event

poll strategies in the repository.

. Responsible in designing and introducing new FACT or Dimension Tables

to the existing model and decide the granularity of fact tables.

. Created dimension hierarchies & level based measures in BMM layer

based on requirements.

. Used Filters (global and local) and provided customized Prompts to

avoid excessive data showing up in the reports.

. Developed reports/ dashboards against HR, SCM and FIN data marts.

. Configured Intelligence dashboards by including embedded content such

as links/images & HTML objects.

. Used BI Publisher 11G to create reports from an Answers Request, and

from BI Server data.

. Created Aggregated Tables and configured the content in Business Model

Layer to use the Aggregate tables for better performance.

. Implemented security by creating users & groups, setting up External

Table Authentication, creating Session Variables and Initialization

Blocks and associated catalog objects and Web modules with the created

groups.

. Involved in preparing/executing Test scripts, establishing Test Data,

and recording defects.

. Coordinated the OBIEE .rpd and Web Catalog objects migration from

Development environment to QA environment and then to the Production

environment.

. Conducted user training to familiarize them to the new reporting

environment.

. Developed packages for processing data in the staging tables according

to the Clients requirements.

. Worked on creating templates, reports and prompts for/within BI

Publisher and integrated these with web application.

. Scheduled the reports as per the requirement using BI Publisher and

represented them in Web Application (dynamic/static scheduling).

Environment : OBIEE 11.1.1.6/10.1.3.4, BI Publisher 11g/10g, DAC 10.13.4,

Informatica Power Center 8.6.1, Peoplesoft 9, Oracle 10g, SQL, PL/SQL, TOAD

6.3/7.0, Windows XP, UNIX/LINUX, Shell Scripting.

SYNERMED, Monterey Park, CA

Jan' 10 - Jul' 11

Role: OBIEE Developer

Description: SynerMed is a leading Medicaid Managed Service Organization

(MSO). SynerMed manages and maintains the data of its Individual Providers

(IPA's) database, processes claims etc. Reports for different departments

(Claims, Case Management, Authorizations, Finance, Eligibility and Customer

Care) were developed using Oracle business Intelligence Enterprise Edition

Reporting system

Responsibilities:

. Requirement analysis, Designed and implemented custom business

intelligence solutions (Metadata and Dashboards/Reports) using the

Oracle Business Intelligence (OBI) Analytics platform.

. Designed and Developed OBI Repository at 3 layers i.e., Physical Layer, Business Model and Presentation Layer level, create presentation

folders, test and validate the model.

. Designed custom star schemas and ETL mappings to meet user

requirements.

. Developed many Reports / Dashboards with different Analytics Views

(Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart,

View/Column Selector, Tabular with global and local Filters) using

Presentation Services/Siebel Analytics Web.

. Extensively used all the transformations like source qualifier,

aggregator, filter, joiner, Sorter, Lookup, Update Strategy, Router,

and used transformation language likes transformation expression,

constants, system variables etc.

. Extensively used presentation variables to develop the logic for the

reports.

. Implementation of different views of report i.e. Pivot table, Titles,

Graph, Filters etc.

. Extensively worked on workflow manager and workflow monitor to create,

schedule, monitor workflows, work lets, sessions, tasks etc.

. Identified Facts and Dimensions (with levels & hierarchy) and made

required changes to the Data Warehouse per gaps.

. Implemented the session partitions (Database and Informatica) for

performance issues.

. Written Technical design Specs and converted functional to Technical

Specs and Production Support document.

. Worked on the testing and validating the Repository in OBIEE 10G.

. Migrated the Tested Code from Dev to QA and QA to Production of

Repository and Web Catalog.

Environment: OBIEE 10.1.3.4, Oracle BI Publisher 11g/10g, Informatica

Power Center 8.6/8.5.1/8.1.1, Oracle 11g/10g, Oracle EBS R12 SQL, PL/SQL,

TOAD, Erwin 4.3, UNIX Shell Scripting, Windows NT

StateFarm, Bloomington, IL

Jul' 08 - Dec' 09

Role: Siebel / OBIEE Developer

Description: StateFarm Bloomington has various departments like Financial,

Sheriff, Insurance, Fire and Transportation, etc. The reports such as

Financial, planning and budgeting and HRM (SAP HR) are created using

Siebel/OBIEE Analytics on a day-to-day basis and performance is measured

against the productivity. Financial reports include quarterly, periodical,

and Fiscal reports.

Responsibilities:

. Participated in gathering and analyzing the Business Requirements.

. Worked on Siebel Analytic repository/Oracle BI EE Administration tool

for customizing the Physical layer, Business layer, Presentation layer

and modifying it according to the business requirements.

. Created Connection pools, imported physical tables and defined joins

in the Physical layer.

. Developed and customized some of the existing Dimensions (Drill-Down

Hierarchies) & Logical objects in Business Model Layer, and created

the Presentation catalogs in Presentation Layer.

. Created Global/Local Prompts, Narrative Views, Filters, Charts, Pivot

Tables, Compound layouts to design the dashboards.

. Developed Dashboards for each of metrics by embedding reports and

provided intuitive drill-downs and links to exploit the full benefit

of Analytics in providing summary and detail reports.

. Performed Dimension modeling, Identified Fact tables & Measures,

Identified Dimension Tables to store business attributes, Identified

Aggregate tables & their definitions

. Created materialized views to fasten slower queries with complex joins

in them.

. Implemented Type-II Slowly Changing Dimension (SCD) logic in OBIEE

environment.

. Used Workflow Manager for Creating, Validating, Testing and running

the sequential and concurrent Sessions and scheduled them to run at

specified time with required frequency and Used Workflow Monitor for

monitoring the performance of the Jobs.

. Performed Unit testing, integration testing to verify the report

functionality and debugged dashboard reports to verify data matches as

expected.

Environment : Oracle Business Intelligence Enterprise Edition (OBIEE)

10.1.3.4, Informatica Power Center 7.8.4, Windows XP, UNIX/LINUX, Oracle

10g, SQL, PL/SQL, and TOAD.

Chase Bank, Chicago

Oct' 07 - Jun' 08

Role: Siebel Analytics Developer

Description: This project deals with the flow of data from various sources

systems, which consists of four streams such as premiums, claims, expenses

and contracts. The primary objective of this project is to get data from

different sources and perform the necessary integration service on the data

as per the user requirements.

Responsibilities:

. Created and administered the Physical Layer, Business Model and

Mapping Layer, Presentation Layer in a Siebel Analytics repository.

. Created connection pools, physical tables, defined joins and

implemented authorizations in the physical layer of the repository.

. Developed custom reports/Ad-hoc queries using Siebel Answers and

assigned them to application specific dashboards.

. Managed day-to-day Rpd, Siebel Delivers, Scheduler and iBots.

. Managed security privileges for each subject area and dashboards

according to user requirements.

. Developed Reports/Dashboards with different Analytics Views (Drill-

Down & Drill-Across, Pivot Table, Chart, View Selector, and Column

Selector, with global & local Filters using Oracle BI/Siebel Analytics

Web.

. Created Filters and provided customized prompts appropriately to avoid

excessive data.

. Worked extensively on Oracle BI Publisher and provided the capability

to download the reports in the user defined formats.

. Performed Tuning of Dashboards/Reports by aggregate navigation, and

cache management.

Environment: Siebel Analytics 7.5.2, Informatica 6.1, Oracle BI

Publisher, Oracle 8i, Toad, SQL server, Windows NT 2000.

Life Insurance Corporation, India

May' 05 - Sep' 07

Role: Oracle Developer

Description: The Aim is to provide a Decision Support System, which helps

Top Management to make decision about their sales, purchase and channels.

To identify the key factors like the total sales revenue in week wise,

month wise, quarter wise and year wise based on the region, sales channels

and sales amount various reports were created using warehouse data.

Responsibilities:

. Developed complex SQL queries for data retrieval from various database

objects including tables and views.

. Developed PL/SQL Stored procedures, Functions, Packages, Cursors,

Triggers, and Records to implement business rules into the

application.

. Extensively used built in Oracle packages like DBMS_SQL and other

packages.

. Resolved many database integration issues for technical

infrastructures of all complexities.

. Designed and developed form layouts according to user specifications.

. Involved in tuning several SQL queries by using indexes, hints and

EXPLAIN PLAN.

. Used SQL*Loader to load the data from flat files and CSV files into

the database.

Environment: Oracle 8i, SQL, PL/SQL, Oracle Forms, Reports, SQL*Plus, Toad,

Windows XP

Contact this candidate