Oracle Sales
Resume:
Kumar
****.******@*****.***
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