Manager Developer
Resume:
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