S UMAN KAKAR LA

PROFESSIONAL SU M MARY

• Result Oriented IT professional with over 8+ years of experience in analyzing the

B usiness Users Requirements, Application Design & Modeling, Development,

Testing, Implementation, Documentation and Support of Business In telligence using

O racle Business In telligence (OBIEE )/ Siebel Analytics, D atabase Development

using Oracle, E TL methodology for supporting data t ransformations & processing

using Informatica PowerCenter.

• 6+ years of extensive experience in providing end-to-end business intelligence

solutions using O LAP/DSS tools like OBIEE 11.1.1.7.0/11.1.1.6.2/ 10.1.3.2/3.3/3.4 and

Siebel Analytics 7.7/7.8.

• Expertise in User Requirement Gathering and converting the same into Technical

Specifications.

• Worked extensively on OBIEE /Siebel Analytics A dministration Tool, Presentation

Services/ (OBIEE /Siebel) Analytics Web A nswers, OBIEE /Siebel I nteractive

Dashboards, OBIEE Delivers/IBOTS, Cache Management, OBIEE /Siebel Scheduler

Configuration and BI Publisher.

• Proficient in building three layers (Physical Layer, Business Model & Mapping Layer

and Presentation Layer) of OBIEE /Siebel A nalytics Repository using Siebel

A nalytics.

• Expertise in t ranslating high-level business requirements into logical business

d imensional model.

• Extensive experience Defining various logical subject areas and organization of

P resentation Layer metadata ; U nderstanding and defining key metrics, d imensions,

h ierarchies and att r ibutes.

• Experience configuring In teractive Dashboards with drill-down capabilities using

g lobal and local Fil ters, OBIEE/ Siebel Security Setup (groups, access/query

p rivileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders,

Reports).

• Experience in upgrading OBIEE Repository, Presentation Catalog, BI Publisher, BI

Security from OBIEE 10g to OBIEE 11g using U pgrade Assistant wizard.

• Proficient working on various RDBMS (Oracle 8i/9i/10g, SQL Server 2005).

• Extensive experience in Oracle 10g/9i/8i Database Development and hands on

experience in writ ing Oracle SQL queries and creating, testing and implementation

of Oracle Database Objects like Tables, S tored Procedures, Functions, Packages,

Database T riggers, Exception Handlers, Cursors, Views.

• Expertise in complete life cycle of Design, Development, Maintenance and

Documentation of various functionalities of Data Warehouses.

• Experience in integration of various data sources like Oracle 9i, SQL server, Flat

f iles and Excel files i nto staging area.

• Expertise in Performance Tuning of Data Warehouses by implementing the

materialized views, bitmapped indexes and partit ions.

• Practical understanding of the Data modeling (Dimensional & Relational) concepts

l ike Star-Schema modeling, Snowflakes modeling, fact and dimension tables

modeling of data.

• Abili ty to interact effectively with clients, Understanding their requirements and

p roviding optimum solution and production support.

• Strong understanding of Systems Development Life Cycle (SDLC).

• Highly motivated, enthusiastic professional with a high degree of commitment to

succeed.

• Excellent writ ing, analytical, communication and interpersonal skills.

ED UCAT ION

• Bachelor of Engineering in Computer Science, Osmania University,

H yderabad, India.

T EC H N ICAL SK I L LS

• OLAP/DSS OBIEE 11.1.1.7.0/11.1.1.6.2/10.1.3.x., Oracle BI

Reporting :

Publisher 10.1.3.x and Siebel Analytics 7.x

Tools

• Database Tools TOAD 10.6/7.4/7.2, SQL*Plus, SQL Developer, SQL

:

Loader, Forms 6i/6.0/10g, Reports 6i/6.0/10g.

• OLAP/DSS ETL Tools I nformatica Power Center 7.1

:

• Databases O racle 8i/ 9i/10g, SQL Server 2005

:

• Programming SQL, PL-SQL, and C.

:

L anguages

• Scripting Languages Perl and Shell Scripting.

:

• Operating Systems W indows XP/2000/NT/9x, UN IX, Sun Solaris,

:

L I N UX and MS-DOS

• Mar kup Language H TM L, CSS and XML.

:

P ROFESSIONAL EXPER I E NCE

May 2013 – T ill Date Riverbed Technology, San

F rancisco, CA

Sr. OB I EE Developer

Riverbed Technology is a technology company that specializes in improving the performance

of networks and networked applications. Riverbed's main product is the Steelhead

A ppliance, a networking appliance that combines several techniques to optimize data t raffic

and bandwidth utilization across a w ide area network .

• Analyzed business requirements documents .

• Created high-level and detailed design documentation.

• Worked extensively on Physical Layer, Business Modeling & Mapping Layer and

P resentation Layer for Configuring, Creating and developing meta-data using

OBIEE Administration tool.

• Created Database objects, Connection Pools, Schemas, Physical tables, Alias tables,

V iews and defined Fact & Dimensions using the foreign key joins in the physical

layer of the repository.

• Created and modified logical tables, logical columns and defined complex joins.

• Created dimensions, dimensional hierarchies, levels, level based measures and

defined level, att r ibutes level keys.

• Used the expression builder utility to create new logical columns in the BMM layer

and created various calculation measures.

• Customized/created presentation layer catalog folders, to show different views of the

business model to different users and assigned group permissions to the catalog

folders.

• Worked extensively on OBIEE web services to create Reports / Dashboards from a

variety of data sources with different Analytics Views (Tabular, Pivot Table, Chart,

S tatic Text, Column Selector and View selector with global and local Filters) as per

t he client requirements.

• Created mul tiple OBI variables like Repository Variables, Session variables,

and Presentation variables for the implementation.

• Configured iBots to deliver Analytics content based on schedule, automated iBot

queries to obtain daily and weekly reports via email using BI Delivers.

• Involved in the up-gradation of OBIEE repository and web catalog from OBIEE

10.1.3.4.2 to 11.1.1.6.9.using upgrade assistant wizard.

• Implemented and managed security using LDAP and External Authentication.

• Created new Users & user Groups and assigned the users to the groups in OBIEE

11g Administration Console.

• Created Application Roles and mapped them to the User Group in OBIEE 11g

E nterprise Manager.

• Implemented and Managed object level and data level security using custom User

g roups/Application roles.

• M igrated OBIEE Repository from Dev to Test and Test to Support environments

using UDM L.

• M igrated OBIEE web-catalog from Dev to Test and Test to Support using catalog

manager.

• Prepared OBIEE code migration documents and submitted requests for migrations

f rom Support to Prod.

• Coordinated with offshore development team and helped them with the

roadblocks/concerns on the project.

• Used Oracle SQL Developer to debug the SQL query to identify duplicate rows in the

warehouse tables, and to debug SQL query issued during report execution.

Environment: O racle Business Intelligence (OBI) EE 11.1.1.7.0/10.1.3.4.2, W indows 7,

O racle 11g, Oracle SQL Developer .

May 2010 – April 2013 PNC Bank, Pittsburgh,

PA

Sr.OB IEE Developer

The PNC Financial Services Group is one of the U.S based largest financial services

corporation. I t is a diversified financial institut ion, which includes a regional banking

f ranchise operating primarily in 15 states and the District of Columbia. I t offers a wide

r ange of services for all customers, from individuals and small businesses, to corporations

and government entities. I t stands sixth largest bank by deposits and is the third largest

bank off-premise ATM provider in USA.

Responsibilities

• Analysis, functional/technical Requirements Gathering, Design, Development,

Testing, Deployment, Maintenance, Documentation and Support.

• In teracted regularly with Business Users and gathered Report Specifications.

• Created high-level and detailed design documentation.

• Analyzed the logical Data model of the target systems and implemented it on local

machine with sample MS Access data source to build mock up reports using Oracle

SQL Developer tool.

• Created mock-up reports and dashboards for review by the business users.

• Worked extensively on Physical Layer, Business Modeling & Mapping Layer and

P resentation Layer for Configuring, Creating and developing meta-data using

OBIEE Administration tool.

• Created Database objects, Connection Pools, Schemas, Physical tables, Alias tables,

V iews and defined Fact & Dimensions using the foreign key joins in the physical

layer of the repository.

• Created and modified logical tables, logical columns and defined complex joins.

• Created dimensions, dimensional hierarchies, levels, level based measures and

defined level, att r ibutes level keys.

• Used the expression builder utility to create new logical columns in the BMM layer

and created various calculation measures.

• Customized/created presentation layer catalog folders, to show different views of the

business model to different users and assigned group permissions to the catalog

folders.

• Worked extensively on OBIEE web services to create Reports / Dashboards from a

variety of data sources with different Analytics Views (Tabular, Pivot Table, Chart,

S tatic Text, Column Selector and View selector with global and local Filters) as per

t he client requirements.

• Configured Intelligence dashboards by adding included and embedded content such

as sections, Folders, Text, Links/Images, Guided navigation links, HTM L objects for

navigation .

• Created mul tiple OBI variables like Repository Variables, Session variables,

and Presentation variables for the implementation.

• Configured iBots to deliver Analytics content based on schedule, automated iBot

queries to obtain daily and weekly reports via email using BI Delivers.

• Involved in upgration of OBIEE rpd and web catalog from OBIEE 10.1.3.4 to

11.1.1.6.2

• Prepared OBIEE code migration documents and submitted requests for migrations

f rom Dev to QA and QA to Prod.

• Worked closely with the BI Admin team for all code migrations, code validations,

creation & granting required permissions for all users and security groups.

• Worked on Oracle BI Publisher for Pixel perfect reports and integrating them with

Dashboards.

• Customized BI Publisher reports to meet the requirement by creating RTF(Rich Text

Format) Templates using BIP Template Builder for Word.

• Worked closely and supported testing team in preparing test scripts, establishing

test data, executing test scripts, and recording defects in Mercury Quality center/HP

A LM .

• Worked closely with DBA and Data Modelers for all the Database related issues.

• Coordinated with offshore development team for couple of the projects and helped

t hem with the roadblocks/concerns on the project.

• Used Toad to debug the SQL query to identify duplicate rows in the warehouse

t ables, and to debug SQL query issued during report execution.

• Prepared functional & non-functional, Requirement Report Mat rix and RPD

documents by reverse engineering as a part of Production support documentation.

• Trained Users on t he generated reports for the projects.

• Also worked as a Production Support Developer and resolved real t ime issues.

Environment: O racle Business In telligence (OBI) EE 11.1.1.6.2/10.1.3.4, W indows XP, Toad

10.6, Oracle 10g Enterprise Edition, SQL*Plus, Oracle 11g, SQL Server 2005,

O racle SQL Developer, O racle BI Publisher 10.1.3.4, Mercury Quality

Center/HP AL M .

June 2009 – April 2010 A T& T Mobility,

A tlanta, GA

S r.OB IEE Developer

A T&T Mobility is the largest and leading worldwide providers of IP-based communications

services to businesses by combining an innovative, reliable, high-quality products and

services and excellent customer care. T he AT&T network includes extensive wireless and

w ired access capabilities, like one of the nation's most advanced and largest Wi-Fi network

and high speed In ternet access and television services.

R esponsibilities

• Involved in gathering the requirements, performing scope analysis and identifying

gaps.

• In teracted with Business Users for gathering the Reports / Dashboards

requirements and to define business and functional specifications.

• Created mock-up reports and dashboards for review by the business users.

• Involved in the development of Metadata repository (.rpd) as per user requirements

and available information in Data Warehouse.

• Created connection pools, defined joins and implemented authorizations in the

Physical Layer of the repository.

• Imported required physical tables (Dimensions and Facts) with integrity constraints

i nto Physical Layer using connection pool and defined Physical Joins using new

foreign key join.

• Worked extensively on B MM (Business Model and Mapping) layer using S tar

Schema.

• Created Logical Tables, Logical Facts, Complex joins between various D imension

and Fact Tables, additional Metadata in the B usiness Model & Mapping Layer

C reated Drill-Down H ierarchies and set the estimated levels in H ierarchies, Logical

columns.

• Worked on Aggregates, Hierarchies, Calculation wizard i n the Logical Layer.

• Worked on the T ime Series function and implemented time comparison sales.

• Created materialized views and aggregates to improve performance.

• Customized the Presentation layer model objects and Re-named the data as

necessary for the set of users.

• Analyzed and validated the repository file by performing check global consistency.

• Developed many Reports with different Views (Drill-Down / Dynamic, Cascading

S tyle Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local

F il ters) using OBIEE Web A nswers and assigned them to application specific

dashboards.

• Debugged Dashboards/ reports visibility with respect to user’s responsibility and

web groups in an integrated environment.

• Worked on Oracle BI Publisher for Pixel perfect reports and integrating them with

Dashboards.

• Used Toad to debug the SQL query to identify duplicate rows in the warehouse

t ables, and to debug SQL query issued during report execution.

• Configured iBots to deliver Analytics content based on schedule.

• Created proactive agents iBots (BI Scheduler) and interactive Dashboards and sent

A lerts to High Level Client Users.

• Implemented security by creating roles & web groups, checks with External tables

and LDAP.

• Involved in migration of Analytics .rpd and Web Catalog objects from developing

environment to QA environment and to the Production environment.

• Trained Users on t he generated reports for this project and documented t he work.

• Participated in Post implementation reviews with the Project teams.

Environment: O racle Business Intelligence (OBI) EE 10.1.3.4, Oracle BI Publisher

10.1.3.4, Oracle 10g, SQL*Plus, Sun-Solaris UN IX .

Oct 2008 – Ma rch 2009 F edEx,

M emphis, T N

OB IEE Developer

FedEx is a global network of companies that provides integrated business applications

t hrough operating companies competing collectively and managed collaboratively, under the

respected FedEx brand. FedEx has grown to become the world's largest express

t ransportation company, providing fast and reliable delivery to nearly every address by air,

surface and ocean solutions to meet your unique needs. I t provides direct-distribution

services that make it easy to move your goods across borders to customers and retail stores,

bypassing distr ibution centers and cutting fees and t ime to mark et

Responsibilities

• Extensively worked on Answers, Dashboards and Security for users.

• Worked on creating complex reports.

• Modeled the Logical Layer based on the Business requirements in the Business

Model and Mapping Layer and Developed the necessary Star Schemas.

• Created Users, Groups by establishing a Connection to the existing LDAP Server.

• Worked on security for user based on external table authentication.

• Created Ini tialization Blocks and variables to call VPD Functions for establishing

C lient Level Data Security.

• Created various Static and Dynamic variables for different report and Security

requirements.

• Configured and administered existing subject areas and created new subject areas to

i nclude new Star Schema information.

• Managed security privileges for each subject area according to user requirements.

• Used Fil ters and provided Customized prompts appropriately to avoid excessive data

showing up Reports.

• Generated custom reports by using OBIEE report features like Pivot tables, Charts,

T icker, Narrative and View selector.

• Assigned the customized reports to application specific dashboards.

• Maintained effectiveness in creating the Dashboards by appropriately including

g lobal prompts, column selectors, guided navigational links, and automatic drill-

down.

• Created user level security for intelligence dashboards based on Business

Requirement.

• Used Analytics Scheduler to configure Delivers and i Bots to notify the corporate

managers and region managers immediately about the messages. Generated iBot

a lerts for reports to be delivered by email.

• Created groups in the repository and added users to the groups and granted

p rivileges explicitly and through group inheritance.

• Used the Catalog manager and maintained the Analytics web catalog to manage

Dashboards, Answers and Delivers.

• Configured Intelligence dashboards by adding included and embedded content such

as links/images, HTM L objects and folders .

• Worked extensively on various Cache Management techniques to increase the

performance of the both Real-Time and Non Real-Time reports.

• Modeled t ime series and slowly changing dimension (SCD) data in OBIEE Analytics.

• Trouble shooted errors in the BI Server and made backups for RPD’s.

• In teracted regularly with Business Users and gathered Report Specifications.

Environment: O racle Business In telligence (OBI) EE 10.1.3.3, O racle 10g, Windows XP,

O racle SQL Developer.

M a rch 2008 –Aug 2008 Wells Fa rgo,

S FO, CA

OB IEE Developer

Wells Fargo is a diversified financial services company providing banking, insurance,

i nvestments, mortgage and consumer finance through Wells Fargo and Wachovia stores,

Wells Fargo and Wachovia ATMs, the internet and other distribution channels across North

A merica and internationally.

Responsibilities

• Gathered Business requirements by interacting with the business users, defined

subject areas for analytical data requirements.

• Performed gap analysis and feasibility study for the given requirement.

• Designed and developed the Metadata Repository (.rpd) using BI Server Admin tool

by importing the required objects (Dimensions, Facts & Aggregates) with integrity

constraints into Physical Layer using connection Pool.

• Created m ultiple Dimensions (Drill-Down Hierarchies) & Fact objects in Business

Model Layer, and created the Presentation catalogs in Presentation Layer.

• Modified Presentation Layer to add presentation tables and columns to meet the

business user needs.

• Used the security settings in OBIEE Admin tool to setup users, Groups and Access

p rivileges.

• Created materialized views and aggregates to improve performance.

• Setup Usage t racking option to monitor frequently run reports in order to provide

caching for the reports and perform database optimization by analyzing query

performance.

• Customized reporting with OBIEE Answers and integrated them into the

Dashboards.

• Generated Reports and Dashboards by using Report features like Pivot tables,

charts and view selector. Created dashboards with global prompts, column selectors,

navigation, and automatic drill-down.

• Created user level security for intelligence dashboards based on Business

Requirement.

• Customized and Developed OBIEE Analytics Reports Account Activity, Revenue on

business segmentation, Actual Vs Forecast Response rates, and Segment and Offer

responses.

• Created Dashboards with Dashboard prompts, Charts, Pivot tables.

• Involved In Analyzing the ER-Diagrams.

• Optimized/Tuned the database design.

• Performed Data Validation of data in the reports and dashboards.

• Involved in Data migration and Data distribution testing.

• Extensively used SQL Tuning to improve performance.

• Created iBots to send pre-processed reports using OBIEE Delivers.

• Unit, integration and system testing for all components in OBIEE. Test cases have

been prepared and documented the results.

• Worked on evaluation of Oracle BI Enterprise Edition and its new utilities including

B I Server, Answers, Delivers and Publisher.

• Documented the design for intuit ive understanding and future reference.

Environment: O racle Business In telligence (OBI) EE 10.1.3.2, O racle 10g, Toad, SQL*

P lus, L I NUX.

Feb 2006 – Nov 2007 G E Software Solutions,

I N D IA

I nformatica Developer/ S iebel D eveloper

GE Software Solutions (India) provides a wide range of services from implementation, development, and

transition to maintenance and support. The services are in very specific technology domains - that of

Oracle Applications and Siebel. Its customers are the various GE businesses located worldwide.

R esponsibilities

• Worked closely with Business Analyst in understanding the requirements and

created the business model for generating reports as per the requirements.

• Extensively worked on O LAP and OLTP systems existing in different DB systems

l ike Teradata, Oracle DW, and XML files.

• Extensively used Informatica client tools – Source Analyzer, Warehouse designer,

M apping designer, Mapplet Designer, Transformation Developer, Informatica

Repository Manager and Informatica Workflow Manager. The objective is to extract

data stored in different databases such as Oracle, SQL Server, Flat Files and Excel

F iles and to load finally into a single Data Warehouse i.e. Oracle.

• Developed many complex I nformatica E TL p rocess and Oracle Packages i.e.,

M appings & Mapplets using various Transformations (Update Strategy, Fil ter,

Router, Expression, Stored Procedure, Lookup, and Aggregator) and Workflows with

Sessions / Tasks.

• Extensively used Informatica ( PowerCenter Designer, PowerCenter Workflow

manager ) to load data from Flat Files to Oracle 10g.

• Generated Complex queries, Stored Procedures, Functions using SQL, PL-SQL.

• Created the High Level Design Document ( HLD) and Technical detailed design

document (TDD) of Repository.

• Implementing Metadata design document (Physical, Business and Presentation

layer, variables, initialization blocks, dimension hierarchies, level based measures

etc.) in implementation phase.

• Designed and developed the Metadata Repository (.rpd) using BI Server Admin tool

by importing the required objects (Dimensions, Facts & Aggregates) with integrity

constraints into Physical Layer using connection Pool, developing multiple

D imensions (Drill-Down H ierarchies) & Logical & Facts /Measures objects in

B usiness Model Layer, and creating the Presentation catalogs in Presentation Layer.

• Developed many Reports / Dashboards with different Analytics Views (Drill-Down/

D ynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with

G lobal and local Fil ters) using Answers in OBIEE.

• Developed calculated measures and assigned aggregation levels based on dimension

h ierarchies.

• Created Security settings in Administration Tool to set up groups, access privileges

and query privileges and also managed security for groups in Answers.

• Used Fil ters and provided customized prompts (fil tering options) appropriately to

avoid excessive data showing up reports.

• Configured iBots to deliver Analytics content based on schedule, automated iBot

queries to obtain daily and weekly reports.

• Enhance performance of Reports / Dashboards by implementing the Aggregate

t ables, Materialized Views, Table partit ions, Creation / Re-building of Indexes and

managing Cache etc.

E nvironment: Siebel Analytics 7.8.4, Informatica 7.1, Oracle 9i, SQL* Plus, UN IX,

W indows XP

July 2004 - Dec 2005 B ha rat Heavy Electricals Limited (B.H.E.L),

I N D I A.

O racle D atabase D eveloper

BHEL is the largest engineering and manufacturing enterprise in India in the energy-

related/infrastructure sector. I t manufactures products under major product groups and

caters to core sectors of the Indian Economy viz., Power Generation & Transmission,

I ndustry, Transportation, Telecommunication, Renewable Energy, etc. I t promptly serves

customers and provides them with suitable products, systems and services -- efficiently and

a t competitive prices.

Responsibilities

• Involved in gathering business requirements, and designed the process f low.

• Involved in design and re-structuring of the Database.

• Imported data from various file formats into staging tables using SQL*Loader,

perform validations prior to t ransfer ring data into Oracle In terface tables.

• Created Database objects like Tables, Views, Primary Keys, Indexes, Constraints,

G rants, Synonyms and Sequences.

• Designed and developed Stored Procedures, Functions, Cursors, Packages and

T riggers using PL-SQL as per the business process.

• Developed complex procedures to handle errors and exceptions at database level

using PL-SQL.

• Developed Data entry screens, Master screens and t ransaction screens with

T riggers, Alerts, and Mul tiple Windows using Forms 6i.

• Developed Unix Shell Scripts to automate backend jobs, loading data into the

Database using SQL* Loader.

• Generated complex financial Reports, Purchase Order Reports using Reports 6i.

• Generated PDF files for documentation purpose and future references.

• Monitored software functionality.

• Trained end users for effective usage of the software package.

Environment: O racle 8i, SQL, PL-SQL, SQL*PLUS, SQL*Loader, Forms 6i, Reports 6i,

TOAD, UN IX, Windows 2000.

Contact this candidate