Sales Oracle

Maddigapu, Purna Chandra

Contact No: 732-***-****

Email: ********@*****.***

SUMMARY

. Over 7 years of extensive experience in Complete Software development

Life cycle SDLC which includes Business Requirements Gathering, System

Analysis, Design, Development, Testing and Implementation of Data

warehouse and Business Intelligence Applications.

. Expertise in complete lifecycle Implementation of Business

Intelligence with Star and Snow flake Schemas using Kimball

Methodology.

. Implemented Oracle BI solutions in various domains such as Oracle

Financial Analytics, HR Analytics and Marketing Analytics and worked on

implementation of Oracle BI APPS which include OBIEE, INFORMATICA and

DAC.

. Implemented Oracle Prebuilt BI Apps for Financial Analytics, Marketing

Analytics with integrating the ERP Systems like Oracle EBS.

. Strong experience in OBIEE 10.1.3.3/10.1.3.4.x/Siebel Analytics, Oracle

BI applications 7.9.5 which includes creating, configuring, customizing

and managing metadata repository and Presentation services (Answers,

Dashboards & Delivers), OBI/Siebel iBots (BI Scheduler), BI(RPD and Web-

catalog) administration and Oracle BI publisher.

. Experienced in Data warehouse Administration Console DAC to Configure,

Monitor and Schedule ETL routines of Full and Incremental ETL loads of

the Oracle Business Analytics Warehouse.

. Experienced in Data Modeling using Dimensional Data Modeling, Star Schema

modeling, Fact and Dimensions tables including Physical, Logical data

modeling in the OBIEE Administration tool.

. Experience in developing all the layers (physical layer, business

model and mapping or logical layer and presentation layer) of the

OBIEE repository.

. Developed many Reports / Dashboards with different Analytics Views

(Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular

with global and local Filters) using OBIEE.

. Hands on experience in implementing External Table Authentication in

OBIEE.

. Implemented and extensively worked in Multi User Development MUDE and

performed some Administration tasks such as Creating users, groups,

Projects and provide required authentication as needed.

. Involved in managing appropriate security privileges on subject areas

and dashboards according to business requirements.

. Experience in upgrading OBIEE 10g repository and catalog to OBIEE 11g

. Installed and configured different versions of Data warehouse Admin

Console (DAC), Oracle Business Intelligence Enterprise Edition (OBIEE)

and Informatica.

. Extensively used the four basic Informatica Power Center tools -

Repository Manager, Designer, Workflow Manager and Workflow Monitor.

. Experience in Extraction, Transformation, Loading (ETL) of data from

various sources into target Data Warehouse and Data Marts using

Informatica Power Center 8.1.1 / 8.6.x.

. Responsible for Unit, System and Integration Testing and Performed

Data Validation for all the ETL's and reports that are generated from

Informatica and OBIEE.

. Good experience in UNIX and writing shell scripts for execution of the

work flows and scheduling the tasks.

. Expertise in Oracle SQL and database Performance Tuning by implementing

Parallel Execution, Table Partition, materialized views with query

rewriting, creating appropriate indexes, usage of hints, rebuilding

indexes.

TECHNICAL SKILLS

Business Intelligence Tools : Oracle BI Apps 7.9.5/7.9.6, OBIEE

10.1.3.x/11g

ETL : Informatica Power

Center 8.1.x/8,6.x

Scheduling Tools : Data warehouse

administration console (DAC)

Relational Databases : Oracle 8i/9i/10g, SQL Server

2000, MS Access

Database Languages : SQL, SQL*Plus, PL/SQL

Tools : TOAD, Oracle SQL

Developer, SQL*Loader

Web Technologies : Java Script, HTML, XML

Operating Systems : Windows XP/2003/NT, UNIX

Dimensional Data Modeling : Star Schema Modeling, Snowflake

Schema Modeling

EDUCATION

Bachelor of Technology, JNTU, India

PROFESSIONAL EXPERIENCE

Humana, Louisville, KY

Nov'10- Till date

Sr. OBIEE / BI Apps Developer

Responsibilities:

. Involved in the documentation of functional design document and technical

design document ensuring that it meets the business requirements and

performance goals of the application.

. Used the OBIEE 10.1.3.x Administration tool to develop and enhance

metadata repository.

. Involved in design and modifications of physical, business and

presentation layers of the metadata repository using OBIEE Administration

Tool.

. Gathered the requirement, Designed, Developed and Tested Physical Layer,

Business Layer and Presentation Layer of OBIEE

. Developed custom reports using OBIEE Answers and assigned them to

application specific dashboards

. Developed many Answers and Dashboard Reports with different Analytics

Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector,

Tabular with global and local Filters) using OBIEE.

. Add users to the new group and apply the data level and object level

security at the repository and Web catalog.

. Involved in managing appropriate security privileges on subject areas and

dashboards according to business requirements.

. Created groups in the repository and added users to the groups and

granted privileges explicitly and through group inheritance.

. Created Catalog Groups and set permissions for items in the presentation

catalog and privileges and rights to users.

. Implemented external table authentication using session variables and

validate using OBIEE Admin tool.

. Involved in the migration of OBIEE repository from DEV to QA and QA to

Production environments.

. Created proactive agents IBots and interactive Dashboards to alert the

business team about business changes.

. Involved in the installation and configuration of OBIEE, Informatica and

DAC in DEV environment.

. Implemented and Customized Oracle Pre-packaged Analytics such Oracle

Financial Analytics

. Performed full load and incremental load execution steps manually

required to populate the ware house in DAC

. Maintaining the Full and Incremental loads through DAC on different

environments like Development, test and production environment

. Involved in developing the Incremental ETL process by Informatica

Mappings & Mapplets using various Transformations

. Worked on transformations like Source Qualifier, Expression, Filter,

Lookup, Router, Aggregator and normalizer transformation

. Debugged and implemented the best practices in mappings, sessions, and

workflows for data extraction and loading from source to target databases

. Involved in the migration of informatica repository using informatica

power center admin console and DAC

. Involved in developing the mappings, sessions and workflows in

informatica power center for the Hedis monthly process

. Involved in the design sessions of the Hedis automation process and

created the design document for the different modules.

. Involved in all the phases of hedis automation process which includes

design, development, unit test, documentation, code review and UAT

. Provided knowledge transfer to client team

Environment: OBIEE 10.1.3.x, Oracle BI Apps 7.9.5/7.9.6(OBIA), Oracle 11g,

OBIEE 11G, Oracle 10G, DAC, TOAD, Informatica 8.1.1/8.6.x, Windows 2003

server, Unix, PL/SQL, Oracle SQL Developer

Citigroup,Warren,NJ

Jan'10- Oct '2010

OBIEE / Informatica Developer

Responsibilities:

. Business requirement gathering, understanding business objectives and

analysis

. Get the database connectivity and design the Physical Layer, Business

model and Mapping layer and the Presentation layer in the

repository(.rpd)

. Creating reports and publishing them in the dashboards using answers

. Customized and developed repository, configured metadata objects(Subject

area table column)and Web Catalog Objects(Dashboards, Pages, Folders,

Reports)

. Involved in creating ibots/Delivers for various requests.

. Used Filters (Global and Local) and provided customized prompts to avoid

excessive data showing up in the reports

. Add users to the new group and apply the data level and object level

security at the rpd and Web cat.

. Extensively used ETL Informatica to load data from Teradata, Excel

spreadsheet, flat files and XML files into the target Oracle 10g database

. Involved in the analysis of the existing system reports and modification

of the reports, created new reports based on the user requirements.

. Designed and developed Informatica Mappings, Mapplets, Sessions,

Workflows and Worklets for extraction, transformation & loading.

. Supported the application and did fine tuning any long running queries by

using aggregates specifying economical source content and level based

measures.

. Worked on transformations like Source Qualifier, Expression, Filter,

Lookup, Update Strategy, Joiner transformations.

. Performed OBIEE Administration - including creation of Users and cache

management

. Used DAC for high performance execution and monitoring and Load balancing

across multiple Informatica Servers

. Used DAC to set the level of Informatica session concurrency and to

Restart the execution plan from point of failure

. Created hierarchies based on the territory level for territorial level

sales and contact reports

. Used constrained filters, column filter prompts and various views such as

Pivot tables

. Developed interactive Dashboards using OBIEE Answers

. Scheduled reports and delivered the same to the end-users through

Delivers.

Environment: Oracle Business Intelligence 10.1.3.4.x, Informatica Power

center 7.1/8.1.1, Oracle 10g, BI Publisher, UNIX, HTML, XML, JavaScript .

FitchRatings,NY

Mar '09 - Nov '09

OBIEE Developer

Fitch Ratings is a global rating agency committed to providing the world's

credit markets with independent and prospective credit opinions, research,

and data. The Fitch Group also includes Algorithmics, a world leading

provider of enterprise risk management solutions. It has the Data in SAP-

ECC.

Responsibilities:

. Business requirement gathering, understanding business objectives and

analysis

. Involved in Capturing User Requirement using technical specs.

. Creating reports and publishing them in the dashboards using answers

. Worked extensively on OBIEE Administration tool and Presentation

Services.

. Involved in creating ibots/Delivers for various requests.

. Involved in the analysis of the existing system reports and modification

of the reports, created new reports based on the user requirements.

. Get the database connectivity and design the Physical Layer, Business

model and Mapping layer and the Presentation layer in the

repository(.rpd)

. Involved in the removing the duplicate hierarchies and duplicate fields

in the business layer when extract a query from the physical layer

. Performed OBIEE Administration - including creation of Users and cache

management

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

Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global

and local Filters) for performing the customer insights / trends using

Presentation Services

. Configured iBots to deliver Analytics content based on schedule,

automated iBot queries to obtain daily and weekly reports.

. Implemented caching to improve performance

. Granting access to users and maintain security by using database

authentication and authorization.

. Organize Presentation Layer in a format that is easy for end-user to use

as a basis for reporting

. 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.

. Involved in Creating OBIEE reports such as WBS Snapshot Internal Reports

using BI Publisher.

. Developed various report templates for different types of formatted

reports.

Environment: Oracle Business Intelligence 10.1.3.4.1, HTML, ODBC, XML,

JavaScript, BI Publisher, SAP-BW, Putty, Linux, windows XP

Pearson Technologies, old Tappan, NJ Mar 08 - Dec 08

OBIEE Developer

Pearson is a British publishing company having presence in more than 16

countries. It manufactures and sells books, magazines, newspapers, novels

etc. It has enterprise data warehouse system and OBIEE; the higher level

management can view the sales score cards Revenue generated and the

Competitor's information in different subsidiaries. The management will

receive the unsalable information through delivers on a weekly basis.

Responsibilities:

. Involved in the full life cycle implementation of Invoices Tracking

Analytics Application used by Accounting Team to monitor the invoices

made to Point-of-Sale (POS) customers, Commercial / Business customers

and third-parties.

. Involved in preparation of technical documents and end user training.

. Interacted with Billing and Account Receivables Subject Matter Experts

(SME), Stake Holders, Business Analysts and Key Business Users in

gathering the Analytics / Reports Requirements.

. Participated in the installation and configuration of Oracle BI EE 10.x

in the windows as well as the Linux environment.

. 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.

. Developed Dashboards / Reports using different Views (Pivot Table, Chart

and Column Selector), with drill-down and drill across capabilities,

guided navigation and dashboard and page prompts.

. Created dimension hierarchies aggregates and logical sources in the BMM

layer.

. Configured the security settings in Siebel Analytics Admin tool to setup

users Groups and Access privileges.

. Performance Tuning using optimization efforts such as re-organizing the

data, aggregate navigation, Cache Management, indexes, Oracle

materialized views and reports changes.

. Involved in Reconciliation Process Oracle BI Reports output with Excel

Reports.

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

Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global

and local Filters) for performing the customer insights / trends using

Siebel Analytics Web.

. Configured iBots to deliver Analytics content based on schedule,

automated iBot queries to obtain daily and weekly reports.

. Worked with ETL Team for enhancement to Facts / Dimensions in developing

the Initial and Incremental ETL process.

. Developed mappings/Reusable Objects/mapplets by using mapping designer,

transformation developer and mapplet designer in Informatica Power Center

7.1

. Migrated mappings, sessions, and workflows from development to testing

and then to Production environments.

Environment: Oracle Business Intelligence (OBI) EE 10.x, Oracle 9i, Toad,

Teradata, Putty, Linux, Informatica Power center 7.1/8.1.1

HarrisBank,Chicago,IL

Mar '07-Feb '08

OBIEE Developer

Harris bank is a Major Chicago-based bank providing retail banking in the

Chicago area and corporate banking services to corporations, institutions,

non-profit organizations. It has database in oracle database; there I used

to develop different types of reports for their merchants and customers.

Responsibilities:

. Interacted with business analysts for requirements gathering,

understanding of the business logic and translate it to ETL

specifications & Business reports.

. Involved in Designing Logical and physical data models using Erwin

following Star Schema methodology.

. Created detailed design documentation (mockup of reports in excel and

presented to user to get approval).

. Created reports on Sales Objectives(Target Vs Actual Rx Volumes call

distribution), Sales Effectiveness(Direct Sales Vs Indirect sales)

. Customized and developed repository configured metadata objects (Subject

Area Table Column) and Web Catalog Objects (Dashboard Pages Folders

Reports).

. Created hierarchy based Sales Card Dashboards for different Business

units and end users using Seibel Analytics web.

. Created modified and administered analytics intelligence interactive

dashboards answers with links to web sites; HTML text; links to

documents; and embedded content such as images text charts and tables

. Configured different types of Reports like guided navigation reports and

embedded links for reports.

. Configured Dashboard and page prompts for various departments supporting

the global organization structure and Configured drill down reports to

provide insight into Sales..

. Set automated iBots queries to obtain customized reports and send alerts

to related managers and secured team members.

. Created dimension hierarchies aggregates and logical sources in the BMM

layer.

. Configured the security settings in Siebel Analytics Admin tool to setup

users Groups and Access privileges.

. Created materialized views and aggregates to improve performance.

. Modified the InstanceConfig.Xml in order to configure the maximum number

of rows requires on the report.

. Customized and Developed Siebel Analytics reports Consumer Segment

Summary Budget request and Transfer Budget by Consumer Segment Region

Sales Summary and few other reports.

. Identified all the conformed dimensions to be included in the target

warehouse design and confirmed the granularity of the facts in the fact

tables.

. Verified target definitions based on star schema design and developed

transformation logic for loading data into target data warehouse.

. Managed the entire "ETL process" involving the access, manipulation,

analysis, interpretation and presentation of information from both

internal and secondary data sources to customers in sales area.

. Developed complex mappings using Informatica Power Center Designer to

transform and load the data from various source systems like Oracle and

DB2 into the Oracle target database.

. Created application-specific Data Marts so that users can access

personalized dashboards of information that is specific to their

department and business unit.

. Responsible for monitoring all the sessions that are running, scheduled,

completed and failed. And also to debug the mapping when the session

failed.

. Involved in the entire SDLC (Software Development Life Cycle) process

that includes documentation, development, testing, deployment,

Implementation, training and maintenance.

. Developed documentation, such as business requirement statements using,

logical data design and process designs in Rational Requisite Pro

Environment: Oracle Business Intelligence (OBI) EE 10.x, oracle 8i, UNIX,

Windows NT platform, ER-win 4.0.

HDFCBank,India

Sep '05-Jan '07

SQL server Developer

HDFC Bank offers a wide range of banking products and financial services to

corporate and retail customers through a variety of delivery channels and

through its specialized subsidiaries and affiliates in the areas of

investment banking, life and non-life insurance, venture capital, asset

management and information technology.

Responsibilities:

. Involved in Creating tables with different types on constraints

. Involved in writing T-SQL queries to do the operations on the database

objects

. Using all kinds of SQL Server Constraints like Primary, Foreign, Unique,

and Check etc...

. Involved in database programming in writing stored procedures, triggers

and indexes very frequently.

. Installation and configuration of SQL Server 2000 components

. Created groups, roles, users and assigning access privileges to users.

. Managing the security using different server roles and database roles.

. Designed, implemented the Metadata, Reports and Dashboards for the Gross

Margin, Sales, and Inventory subject areas using the OBIEE tool

. Extensively worked on creating reports and dashboards.

. Configured the Scheduler and created iBots, which were sent out to the

users on a daily basis.

Environment: MS SQL 2000, Windows 2000/XP, SQL Query Analyzer and

Enterprise Manager, MS Access 2000 & Windows NT platform, Siebel Analytics

NationalInsuranceCo. India

Jan '04-Aug '05

SQL Server Developer

Description: Multi Access Integration (MAI) is designed to get online auto

insurance quotes. Customers can log onto the website and get their auto

quote. They can look up their premiums and can retrieve their quote at any

time through new business model (NBM), from the date and can do their

payments. Automated Testing Tool Win Runner was used to test the

application

Responsibilities:

. Performed Database design and development.

. Developed Reports such as consolidated trial balance, Balance sheet,

Party wise outstanding, Funds flow statements, Cash flow statements, Bank

reconciliation statements

. Developed Graphical charts for balance sheets, profit & loss account,

investments, Current assets and loans and advances etc., Manufacturing &

other costs.

. Designed the Entity-Relationship model and normalized database.

Environment: SQL server 2000, PL/Sql, Windows 2000, TOAD, FTP

Contact this candidate