Rajesh Kasaragadda

acuq8r@r.postjobfree.com

732-***-****

Over 7 years of experience in Business Intelligence solutions and expertise in gathering requirements, analyzing, developing, testing, deploying Business Intelligence (OBI) applications with OBIEE/OBIA, BI Publisher, ODI, SQL/PLSQL.

Subject Matter Expert on OBIEE tool, worked as BI Administrator/Developer in designing and developing end-to-end BI solutions according to standard OLAP methodologies which includes Design, development and implementation of using OBIEE 10/11g, OBIA 11g, ODI 12C.

Implemented custom requirements of Oracle BI Applications for various modules like Finance, Manufacturing, HR analytics and SCM modules with integrating the ERP Systems like Oracle E-business Suite R12, PeopleSoft 9.1 and SAP BW Cubes to OBIEE.

Experience in Customizing the Oracle OOTB objects based on the reporting requirements.

Expertise in setting up Development, Test and Production environments in Windows and LINUX/UNIX environments for DWH requirements for the business needs and customize existing schemas as well develop new Subject Areas to suit business needs.

Expertise in Installation, Configuration, Up-Gradation, Customization, Migration of Oracle BI Apps 7.9.X, OBIEE 11.1.1.7.0, ODI 12.1.3.0.0, Oracle DB 11.0.2.3 in windows server 2008/Linux 5.9/Oracle Enterprise Linux.

Expertise in developing & Customizing BI Publisher reports and0 deliver using different delivery channels like E-Mail, FTP and File.

Expertise in design and implementation of security framework including Authentication and Authorization of OBIEE by integrating external authentication providers (Microsoft LDAP, Oracle Identity Manager, Database authentication, External table Authentication etc.) and also implement CA Site Minder Single Sign On(SSO) integration.

Experience/Exposure with Interfaces, Packages, Variables, Load Plans, Data Sets, updates strategy, Knowledge Modules (KM) and various other features of Oracle Data Integrator (ODI) tool.

Deep understanding and technical skills in Oracle BI Platform and Applications, including dimensional & multi-dimensional data modeling, designing of star schema and Snowflake for large data warehouses, implementation of complex reports.

Strong background in Data warehousing, Data Modeling & Business Intelligence concepts and design techniques.

Expertise in design and development of dynamic & interactive Dashboard reports with drill-across capabilities for trend analysis.

Experience in setting up Authentication and Authorization for users and groups.

Experience in demonstrating POC’s for business proposals at customer locations directly.

Expert in implementing and handling complex environments which include clustering of servers, back up and Failover Strategies with connected and disconnected analytics.

Experience in developing ODI Mappings for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows with Worklets & Tasks and scheduling using both Workflow Manager and Unix Shell scripts.

Experience in performance tuning at the Database level by creating Aggregate tables, Indexes and RPD level by creating Database hints in Physical Layer, Tuning Reports.

Strong leadership skills and the ability to train, mentor, direct, and validate the work of team members.

Self-motivated, Proven Communication skills, presentation Skills and Leadership Qualities.

BI Tools Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.x, OBIEE 10.1.3.x, Oracle BI Apps 11.1.1.x

ELT Oracle Data Integrator (ODI) 12.1.3.x, 11.1.1.x.

OBI Applications OBIA 11g - Financials, HR, Manufacturing, SCM

People tools PeopleSoft 8.9/9.0

Operating Skills UNIX, Linux, Windows.

Developer Tools SQL Developer, SQL Plus, Toad.

Web Tools HTML, DHTML, XML, Web Portals.

ERP Oracle EBS, PeopleSoft ERP, Siebel CRM.

Dimensional Data Modeling Star Schema Modeling, Snow-Flake Schema Modeling

Bachelors’ degree from Jawaharlal Nehru Technological University, Anantapur, India.

LA Care, LA, CA.

Sr. OBIEE Developer July’ 15–Till Date

Responsibilities:

Interacting with end users for requirement gathering and define requirement specifications document by access and retrieval of financial and personnel data from one single source.

Identify & Create Facts, Dimensions, and Hierarchies of the business model.

Prepare Solution and Technical design documents for the client requirements on customizing OOTB reports for Financial Analytics.

Configure BI APPS 11.1.1.7/8 (ODI/ETL, Configuration/Functional Setup Manger and OBIEE/RPD/Reports/Dashboards) on distributed environment and implement Oracle out of the box Prebuilt Analytics.

Implement the Slowly changing dimension scheme (Type II) for most of the dimensions.

Review the logical model with Business users, ETL Team, DBA’s and testing team to provide information about the data model and business requirements.

Create Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups.

Design and Test Reports in the Dashboards for the Financial Analytics modules like GL, AP, and AR and create the Ad-hoc report according to the client needs.

Configure Interactive Dashboard with drill-down capabilities using global and local Filters, Metadata Objects and Web Catalog Objects.

Apply Cascading Prompts and Multi Level Prompts on Dashboards.

Identify issues, performance bottlenecks, and optimize the Business Intelligence Dashboards and Reports.

Extensively Implemented & Configured MUD Environment to be able to work on different Projects and merging changes to the Master RPD.

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

Support test execution and resolution of technical issues identified during test phases prior to deployment of new reporting enhancements required for Liquidity Program projects.

Import data from OLTP/OLAP to the Physical layer of OBIEE.

Write Custom SQL Codes for the reports.

Apply Optimization Techniques for the better performance of the reports.

Use external tables to Transform and Load data from Flat files into target tables.

Use Debugger to validate Mappings by creating break points to analyze and monitor Data flow.

Involve in troubleshooting the load failure cases, including database problems.

Implement Security by authenticating against the LDAP and external table.

Performance tuning the mappings by using SQL Override, session override, Lookups, Caching.

Analyze business process and develop ELT procedures to move data from various source systems to target systems.

Involve in Testing, Debugging, Data validation and performance Tuning of ETL process which helps to develop optimum solutions for data warehouse deliverables.

Train End Users and Pilot Users about OBIEE Tools.

Environment: OBIEE 11.1.1.7.1, ODI 12.1.3.0.0, OBIA 11.1.1.9.1(Finance), Oracle 11g,

Windows and Linux

Renew Financial, Portland, Oregon.

Sr. OBIEE Developer May‘14 – June ‘15

Responsibilities:

Interact with Business Analysts in understanding the Analytics requirements and create business model for generating reports as per the requirements.

Responsible for Analysis, Design, Development and Testing for the business requirement.

Installing and configuring OBIEE, OBIA and ODI 12C.

Customizing the data models as per business requirements.

Building the various levels of RPD (Physical, BMM and Presentation Layers) and configuring hierarchies and Checking RPD for inconsistency and resolving if any.

Developing Reports / Dashboards with different Analytics Views.

Scheduling IBots/Agents based on user requirements.

Setup the visibility of Dashboards to employees with respect to their responsibilities.

Monitor permissions and privileges for Dashboard visibility and modifications to users based on their groups or responsibilities.

Integrate LDAP authentication with AD servers and responsible for deploying the OBIEE code across the Stage and Production servers.

Design and Developed General Ledger, Payables, Receivables, profitability (OBIA 11g) Dashboards in OBIEE.

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

Develop and customize executive level dashboards and reports in various views such as Pivot Views, Charts (Graphical charts, pie charts), View Selectors, Column Selectors, catering to provide insight into the Sales / Marketing / Financial data.

Implementation of User Level and Data Level Security for OBIEE Dashboard Reports.

Create Dimensions and Facts for Star and Snowflake schema designing, calculation of measures in the business model using Time series functions and derived measure by existing columns.

Use Aggregation Navigation, Repository Variables, Session Variables, Presentation Variables, and Request Variables.

Build ODI Interfaces/mappings as per custom requirements and Built ODI Packages as per custom requirements.

Build ODI Procedures as per custom requirements and Generated ODI Scenarios as per custom requirements.

Analyze and fix for any bugs identified during analysis of service tickets and worked on Reports Enhancements.

Create users and groups and assigning permissions based on responsibilities/roles, giving security permission privileges to the user and Worked on performance tuning of the custom reports.

Involve in developing the Incremental ELT process Interfaces using various Knowledge modules (KM).

Environment: OBIEE 11.1.1.7.1, BI Publisher, ODI 11.1.1.7.0, OBIA 11.1.1.9.1, Toad, SQL,

Windows XP

DTCC, New York City, NY.

OBIEE Developer Jan’13 - April’14

Responsibilities:

Install and configure the OBIEE 11g, RCU Utility and deal with the installation issues.

Work closely with Business Users, involve in discussing and gathering the requirements from different user groups.

Build the Physical layer, Business Model and Mapping Layer (BMML), and Presentation layer of a repository.

Extensive experience in designing dimensional models such as Star Schemas, Snow Flake Schema.

Create Dimensional Hierarchies for the Drill Down functionality and implement Business Logics for Facts.

Responsible for creating custom columns in the BMM layer to calculate the percentage changes in the sales.

Use multiple data sources to logical tables in a business model while building a repository.

Create calculation measure using Answers, Physical Columns, Logical Columns and Calculation Wizard.

Configure Oracle BI scheduler in an application and server that manages and schedules the job.

Develop reports using BI Dashboard and Answers, views & charts, created filters to obtain weekly sales for each region & send alerts to upper management.

Use the Aggregate Persistence Wizard to create and model aggregate tables for faster query processing in decision support systems.

Knowledge in Usage tracking in determining user queries that are creating performance bottlenecks, based on query frequency and response time.

Involve in Data level and object level security model in OBI presentation catalog to view their report according to the user level/position and permission.

Create various Ad-hoc reports for day-to-day business requirements making use of global and share filters with different views in accordance with the requirements.

Configure and Schedule BI Publisher scheduler for report bursting to File and email locations and use advanced reporting features such as Online Analyzer, Excel Analyzer and report security options.

Use Oracle EBS as a source system.

Perform Repository Testing and validation before exposing Business Models in the Presentation layer.

Generate Agents using the Deliverables to send notifications to the management.

Conduct training sessions for users on how to Subscribe/Unsubscribe for the reports.

Environment: OBIEE 11.1.1.6.6, Oracle 10g, Oracle BI APPS (OBIA) 7.9.6, Windows XP, SQL, Toad

GE Corporate, Albany NY

OBIEE Developer Dec’11 - Dec’12

Responsibilities:

Create connection pools, physical tables, schema folders and catalog folders in the physical layer of the repository.

Define Primary key-Foreign key relationships, complex joins between dimension tables and Fact tables. Create Opaque views for complex queries.

Create Business model with logical tables in the Logical Display folders.

Create Dimension Hierarchies in Business layer for Drill down functionality.

Create Preferred Drill Down Path.

Define static and dynamic repository variables to modify metadata content dynamically to adjust to a changing data environment.

Design various reports with Drilldown, Navigation.

Created Pie Charts, Pivot Table, Narrative Views, Static Views etc.

Maintain effectiveness in creating the Dashboards by appropriately including guided Navigational links and drilldowns.

Review of Unit test cases, Integration test cases of all the assigned modules.

Testing individual modules of the software against the Unit test cases.

Create canned Report using “Combine Similar Request” feature.

Create Complex Filters for Date Selection.

Use Presentation Variables for passing values from prompts to reports.

Worked on Object Level Security.

Involved in validating the functionality of reports.

Implement data level security on OBIEE RPD.

Study the Source system and created high level Design document.

Worked on OBIEE Answers and Dashboards to replicate the existing reports on OBIEE.

Worked on BI-Publisher to create pixel perfect reports expected by the Client.

Environment: OBIEE10.1.3.4, Oracle 10g, SQL Developer, UNIX, TOAD, Web Logic Server

KOEL, Inventory Analysis, India

OBIEE Developer Jun ‘09 – Nov ‘11

Responsibilities:

Designed and developed the Metadata Repository (.rpd) using OBIEE Admin Tool by importing the required data base objects both Facts and Dimensions with integrity constraints into physical layer using connection pool Designed and developed Web catalog objects - Reports/Dashboards.

Modeling activities include building star schemas as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns in Business Model Mapping (BMM) layer.

Establish the logical joins/keys required to support drill-down aggregation.

Design and Configure Dashboards in Analytics for different groups of users to view figures across regions, products with the facility to drill down to individual customer relationship manager.

Develop Role-Based Dashboards for Managers and Business Heads to review the Forecasts vs. Revenues and Contact Relationship Management (CRM) to analyze the financial service center statistics for different campaigns, Customize pre-built dashboards.

Used TOAD to find, understand, and report on data in record time. This supports multiplatform data discovery capabilities at ease.

Made use of variables for faster report generation.

Develop custom reports in OBIEE Answers using Filters.

Conduct Unit and System Testing and Performed Data Validation for all the reports.

Used Joiner, Aggregator, Expression, Router, Sequence Generator, Update Strategy and Lookup Transformation to manipulate data related to customers.

Extensively worked on confirmed Dimensions for the purpose of incremental loading of the target database.

Environment: OBIEE 10.1.3.4, ODI, Oracle 10g, SQL Developer, SQL*Plus, Windows-XP

MTS, Hyderabad, India.

Oracle Developer OCT’08 – APRIL’09

Responsibilities:

Develop Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.

Involved in creation of Conceptual Modeling covering all the business requirements.

Involved in logical modeling and physical modeling of application.

Load data into database tables using SQL*loader from external files.

Develop SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.

Develop SQL scripts, packages and procedures for Business rules check to implement business rules.

Used bulk collections, indexes, materialized views to improve the sql and plsql performance.

Automate routine jobs using DBMS_JOB. On completion of these jobs an email will be sent out automatically with the help of UTL_MAIL.

Develop SQL and PL/SQL scripts to transfer tables across the schemas and databases.

Load Data from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.

Develop Procedures for efficient error handling process by capturing errors into user managed tables.

Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS_SQLTUNE.

Used Toad for creating PL/SQL (trigger, sequence, stored procedure).

Environment: Oracle 11g, SQL, PLSQL, SQL*Loader, SQL developer, Windows XP.

Contact this candidate