Shiva kumar Pelimelly

ac48lr@r.postjobfree.com

813-***-****

Sr. OBIEE/ODI Developer

SUMMARY:

* ***** ** *********** ********* in design, configuration, development, testing and implementation

Of Oracle Business Intelligence, Informatica and Data Warehousing.

Highly pro-active individual with a ‘Can Do’ attitude, having 8yrs. of IT experience spanning across data warehousing, software development and Oracle Financials

Expertise in developing Oracle BI and consisting of three layers. Complete knowledge working with Informatica Administrative Tool to build Meta data, Analytics security and caching.

Experience in implementing and configuring pre-built OOTB Analytics (Financials, HR, Sales) of Oracle BI Applications (OBIA), Informatica and DAC and Retail Analytics

Experience in Complete life cycle of Business Intelligence with Star and Snow flake Schema Methodologies.

Expertise on technical areas of Metadata Design (RPD) and Dashboard Development.

Expertise in BI Publisher, Developing and designing the template in rich text format (RTF) and portable document text format (PDF).

Expertise in Topology, Designer, Operator in (ODI) Oracle Data Integrator.

Hands on experience in Authentication and Authorization of OBIEE by using LDAP, Database authentication, External Authentication and also implemented Single Sign on (SSO).

Expertise in configuring Multiuser Development Environment (MUDE) and Usage Tracking.

Experience in OBIEE features (i.e. Cache, Usage tracking, Dimensional hierarchy, Aggregate navigation, Variables/Initialization Blocks configuration etc.); converting Snow-Flake Schema to Star Schema, Dim Hierarchies, Dim Extensions, and Physical & Logical Data Modeling.

Proficient in defining key metrics, dimensions, hierarchies, attributes.

Expertise in OBIEE Installations, Migrations and Upgrades. Created BI Publishers in OBIEE Repositories.

Administration of OBIEE and the OBIEE Web Catalog. Performance tuning using Cache management techniques.

Expertise working with dimensions and fact tables in the BI Apps and experience with understanding universal adaptors in order to load into BI.

Expertise in providing end-to-end business intelligence solution by dimensional modeling design, building business models, configuring Analytics Metadata objects (Subject Area, Table, Column), Answers (ad-hoc querying, reports), Variables (Repository/Session/Presentation), Interactive Dashboards with drill-down/drill across capabilities (charts/tables/graphs), Delivers (Agents/iBots), Administering Web Catalog Objects (Dashboard, Pages, Folders, Reports), Cache monitor, Job Manager, Catalog Manager.

Experienced in developing Web Intelligence, Desktop Intelligence and Crystal Reports using different Data Sources.

Extensively Worked on OBI Publisher importing data from multiple data sources and delivered Reports, common dashboards, metadata, security, calculation, caching and intelligent request generation services.

Experienced in Integrating OBIEE with Hyperion Essbase 9.x and in developing RPD and reports against multidimensional databases.

Expert in configuring, designing, development, implementation and using Oracle pre-build RPD’s (Financial, HR, Sales, Supply Chain and Order Management, Marketing Analytics, etc.) and ETL Mappings according to business requirements. Experienced in Oracle EBS R12 Financial.

Experienced in designing and developing Data Modeling and Analysis using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables and Physical and Logical data modeling in the OBI Administration tool.

Highly skilled at configuring OBIEE Metadata Objects including repository, variables, interactive dashboards with Map viewer/Big Maps/Google Maps, reports and three tier OBIEE architecture.

Experienced in Simplifying Migration Process - Changing environment specific variables in RPD development, administration, analysis report.

Proficient in using the time-series functions to support historical time comparison analysis and creating requests, adding filters, creating prompts, and creating pivot tables.

Experienced in configuring Usage Tracking and Multiuser Development Environment (MUDE)

Experienced in creating Dimensional hierarchies and designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables

Experienced in translating business requirements into a business dimensional model, key subject areas, dimensions, hierarchies, attributes and measures.

Excellent interpersonal and communication skills for efficient client interaction.

TECHNICAL SKILLS

OBIEE Infrastructure

OBIEE 11.1.1.9, OBIEE 11.1.1.7, OBIEE 11.1.1.6, OBIEE 10g

OBIEE Applications

OBIA7.9.6.3, 7.9.6.1(Financial analytics, HR Analytics, Sales, Service, Marketing)

ETL Tools

Knowledge in Informatica Power Center9.0, Informatica Power center8.6.1, DAC 10.1.3.4.1, ODI 11g

Languages and Web Technologies

SQL, PL/SQL, C, C++

ERP and Applications Servers

Oracle Applications 11i, R12, PeopleSoft 8.9, Oracle Web Logic Server 10.3.5

RDBMS

DB2 UDB (8.x and 7.x), Oracle11g/10g, MS-Access, SQL-Server 2008,Hyperion System 9 Essbase

Operating Systems

Microsoft Windows 8.x, Windows 7

Methodologies

Software Development Life Cycle (SDLC) -Waterfall Model,

Agile Methodology, Rational Unified Process (RUP)

Work Experience

Sony, San Mateo, CA 01/17 – Till now

OBIEE/BI developer

Responsibilities:

Interacted with Subject Matter Experts (SME), Business Analysts and users in gathering and analyzing and designing the Business report requirements.

Designed and Developed the RPD by importing metadata into Physical layer, applied Business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer.

Designed and developed OBIEE/Metadata Repository(.rpd) using OBIEE Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool, developed Calculated Measures, dimension hierarchies & Logical Facts/Measures in Business Model Layer, and creating the presentation catalogs in Presentation Layer.

Created connection pools, physical tables, made joins and implemented authorizations in the rpd.

Created Requirements Traceability Matrix and Mapping Document to trace requirements in the BI implementation.

Creating variables, sequences, user functions, scenarios, procedures, interfaces and packages in ODI.

Designed, Created and Tested Reports in the Dashboards as per the client needs.

Designed, Developed and Tested Data Security and Dashboard Security in OBIEE.

Created Chart, Column Selector with global and local filters using Oracle BI Presentation Services

Implemented Security by authenticating against an LDAP server.

Migrated the tested code from Dev to QA and QA to production.

Configured Interactive Dashboard with drilldown capabilities using global and local Filters, Metadata Objects and Web Catalog Objects.

Installed and Configured OBIEE, DAC and Informatica on Unix/Windows Environment

Performed Performance Tuning of Dashboards / Reports by aggregate navigation, cache management, and Oracle materialized views and making changes to reports.

Designed and developed ETL Processes based on business rules, job control mechanism using Informatica Power Center.

Created Customized application roles for restricted access to OBIEE Objects and assigning them to securing groups in AD for designated OBIEE Users

Designed packages, interfaces, Procedures, KM's and scenarios in ODI (Oracle Data Integrator).

Customized OOTB OBIA packages for ETL using ODI studio based on the business requirements.

Created and customized various data models in ODI using Oracle EBS source system objects.

Manage and Monitor Daily ODI incremental loads using BIACM and ODI Console for any issues.

Maintain and manage the LINUX server platform for effective operations of the OBIEE and ODI applications.

Environment: : OBIA release (11.1.1.10, 11.1.1.9, 11.1.1.8,12), ODI 12.2.1.0/11.1.1.9.x (Repository Manager, Designer, Load Plan Generator, and Operator), BI Publisher 11.1.1.5, OBIEE 12c, 12.2.1.0/11.1.1.9.0, OBIA 11.1.1.10.1/11.1.1.8.1, Oracle 12c/11g, SQL Developer 4.x, Toad 10.x, SQL Loader, PLSQL, SQL, Tableau, Hyperion System9, Smart View, Excel VBA.

AmTrust Financial, New York, NY 03/15- 12/16

BI APPS Consultant

Responsibilities:

Identified Facts, Dimensions, and Hierarchies of the business model.

Involved in Analysis, Requirement gathering, function/technical specification, development and testing.

Identified the granularity level of the business model based on the end user requirements.

Installed OBIAPS 11.1.8.1

Configured OBIAPS (HR Analytics,Project Analytics, Financial Analytics)

Configured OBIAPS to sources Such as EBS and R12.

Extensively used OBIEE for customizing and modifying the three layers of the repository.

Migrated reports from Hyperion to OBIEE and Did UAT testing.

As worked with Hyperion, having good knowledge with brio reports.

Made use of OBIEE Answers and Dashboards to create the reports as per the client requirements.

Worked extensively on various Cache Management techniques to increase the performance of the both Real-Time and Non Real-Time reports.

Designed ETL mappings for bringing in data from various data sources using ODI.

Modify existing ETL jobs in Oracle Data Integrator (ODI).

Develop data extracts from the data warehouse environment using ODI.

Creating variables, sequences, user functions, scenarios, procedures, interfaces and packages in ODI.

Prepared technical design documents for the dashboards developed.

Created groups in the repository & added users, granted privileges explicitly through group inheritance.

Attended weekly meetings to make the project more productive.

Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.

Created corporate standard variables in the metadata to ensure standard measures and best practices are followed.

Created Intelligent Dashboards for different groups of users to view across regions, Customer demography with the facility to drill downs and charts.

Providing object level security for different web groups based on responsibilities.

Made Dimensional Hierarchies for the Drill Down functionality and implemented Business Logics for Facts.

Environment: Oracle 11.1.1.8, SQL, Hyperion BRIO, Data Warehouse Administration Console (DAC), MUDE, Oracle BI Deliveries

Cross Country Healthcare, Boca Raton, FL 09/13 – 02/15

OBIEE/OBIA Consultant

Responsibilities:

Interacted with Business Analyst, data Modelers in understanding the Analytics report requirements.

Installed, Configured and Upgraded OBIA and OBIEE and resolved the issues across the environments.

Worked extensively on Customizing Physical Data Layer, BMM layer and Presentation Layer in Admin Tool.

Involved in creating Star schema as per the business requirements to store the business attributes and measures and configured the Logical Layer, Logical tables, dimensions and columns and created the logical joins required to support drill-down aggregation.

Having very good understanding of the business requirements and transforming the requirements into subject areas.

Developed various custom reports/Ad-hoc Reports for querying and Filters and prompts.

Configured the Dashboard and Saved requests in Answers for drill down features.

Involved in merging changes of Repository and Web catalog from development to test and production environments.

Migrated Repository and Web Catalog files between development, test and production environments.

Worked with the Security settings in Oracle Business Administration Tool to set up users, groups, access privileges.

Good experience in understanding & creating source and target definitions, mappings, and working with sessions.

Configured the scheduler which runs the IBots and delivers the content.

Extensively worked on the Informatica Power Center tools –Designer, Workflow Manager, Workflow monitor.

Developed filters, calculations, prompts, conditions, for various reports, using Cognos Report Studio for users.

Involved in Integrating Oracle BI Presentation Services with BI Publisher.

Created Dashboards to present critical company data in a single report. Analyzed existing transactional database schemas and designed star schema models to support the users reporting needs and requirements using Cognos

Extensively used Dashboard, Pages, Sections, Add Column, Dashboard Prompts including View Selector, Column Selector, Pivot Tables, Charts, Presentation Variables, Permissions on Shared Folders via Catalog Manager etc.,

Participated in weekly team meetings and reviews meetings.

Environment: OBIEE 11.1.1.7, BI Publisher Enterprise, Informatica 9.2, SQL Developer, Cognos 8 & 10 BI

Club Corp, Dallas, TX 01/12 – 08/13

OBIEE Developer

Responsibilities:

Designed and Developed the RPD by importing metadata into Physical layer, applied Business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer.

Configured Interactive Dashboard with drilldown capabilities using global and local Filters, Metadata Objects and Web Catalog Objects.

Constructed multiple sub-sites, pages, and libraries with the deployment of the new SharePoint 2010 sites

Performed Performance Tuning of Dashboards / Reports by aggregate navigation, cache management, and Oracle materialized views and making changes to reports.

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

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.

Developed and scheduled IBots using BI delivers to deliver Analytics content based on schedule, automated IBot queries to obtain daily and weekly reports.

Upgraded the 10g rpd to meet the 11g standard and rolled out OOTB reports for in current DWH.

Installed and configured OBIEE 11g as a kick-start for current upgrade process of our current 10g version of OBIEE in Sandbox.

Involved in Merging the RPD and Web Catalog folder with OBIEE Admin tool and Catalog Manager.

Extensively worked on the Informatica Power Center tools –Designer, Workflow Manager, Workflow monitor.

Implemented slowly changing Dimensions (SCD, Both Type 1 & 2).

Involvement with ETL (Extract-Transform-Load) development team to communicate the specification for the required dimensional, aggregate and indexed data tables.

Created custom Mappings, Mapplets to load the new tables and the new information into the warehouse.

Used Informatica to load data from Flat Files to Oracle using various transformations.

Performed Unit, Integration and Regression testing to validate and mapping functionality.

Environment: OBIEE 11.1.1.6.0 / 10.1.3.4.1, Informatica Power Center 9.x/8.x, ODI 11g, Oracle Business Intelligence Data Warehouse Administration Console v10.1.3.4.1, PL/SQL, Oracle11g, Teradata, Erwin, Control-M.

Aviva Life Insurance, India 06/10 – 12/11

OBIEE Developer

Responsibilities:

Involved in translating high-level business requirements into logical business dimensional model.

Designed and developed the OBIEE Metadata Repository (.rpd) using OBIEE 10.1.3.x Admin Tool by importing the required data base objects both Facts and Dimensions with integrity constraints into physical layer using connection pool.

Worked on building OBIEE Repository at 3 layers i.e., Physical Layer, BMM Layer and Presentation Layer.

Mapping in data sources using OBIEE Admin tool to create repository.

Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in BMM layer.

Identified and created aggregate tables to improve query performance.

Developed different kinds of Reports (pivots, charts, tabular) using global and local filters.

Created Session & Repository Variables to achieve desired functionality.

Created OBIEE Intelligent Dashboards, & Answers & also Assigned Data level & UI level security to the Users

Customized Reports look and Feel using Column Formatting, Conditional formatting.

Created and used Siebel Delivers and iBots extensively also Worked on OBIEE retail metrics.

Involved in developing ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center 7.1.x/8.x also involved in fine-tuning of Informatica Mappings.

Integrated data into Hyperion cubes and helped in the implementation of Hyperion planning application.

Environment: OBIEE 10.1.3.4.1, Power Center 7.1.x/8.x, MS Office, Toad

Education: Bachelor’s in Electronics from Aurora, 2011.

Contact this candidate