Aravind P

Oracle BI Consultant Email :zyjk5g@r.postjobfree.com

SUMMARY

• Having 5+ years of Strong experience in Complete Software development Life cycle (SDLC) which includes Business Requirements Gathering, System Analysis & Design, Data Modeling, Development, Testing and Implementation of Data Warehouse and Business Intelligence Applications.

• More than 3+ years of experience in Oracle Business Intelligence Enterprise Edition 10.1.3.x and Siebel Analytics 7.x

• Around 2 years of experience in Data integration using ETL tool INFORMATICA PowerCenter 7.0/8.1. Extensive experience in implementation of ETL methodology in Data Extraction, Transformation and Loading by using various Informatica Designer Tools like Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer and Warehouse Designer.

• Strong understanding of Transactional and Dimensional Data Modeling, Data Warehousing Concepts, and Designing Star & Snowflake Schemas for OLAP Systems

• Expertise in developing OBIEE repository with Physical, Logical and Presentation layers build reports/dashboards from the repository using OBIEE (Siebel) Answers and troubleshoot various technical issues and bugs.

• Developed various Dynamic and Interactive Dashboards/Reports with intuitive drilldowns, drill-across and drillable charts using Oracle Answers

• Experienced in BI Publisher, MS Office Plug-in for rich reporting and Oracle BI Scheduler Configuration for Alerts / iBots. Experienced in Upgrade from Siebel Analytics 7.x to OBIEE 10.x

• Expertise in OBIEE/Siebel Analytics features (i.e. Clustering, Cache, Usage tracking, Dimensional hierarchy, Aggregate navigation, Variables/Initialization Blocks configuration etc.)

• Experience in Installation, Configuration, and Administration of Oracle BI Apps 7.9.5, Oracle 10g standalone

• Extensive experience in developing Informatica Mappings / Mapplets using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and Creating Workflows with Worklets & Tasks and Scheduling using Workflow Manager

• Experienced in Performing end to end testing, creating Test Plans including Data Validation, Unit Testing and User Acceptance

• Experience in interacting with Business users to analyze the business process and requirements and writing technical documentation and rolling out the deliverable.

• Excellent Team Management Skills with good business acumen, effective communicator, good team mentoring and training skills, experience in working with Business Users, Controllers, Directors, Senior Managers, Executives, Department Heads and Project Stake Holders.

• Excellent problem solving skills with strong technical background and good inter-personal skills, Quick learner and excellent team player, ability to meet deadlines and work under pressure.

TECHNICAL SKILLS

Business Intelligence

Tools

OBIEE/Siebel Analytics 10.1.3.x( Oracle BI Administration, Oracle BI Presentation, Oracle BI Dashboards, Oracle BI Delivers, Oracle BI Publisher, Catalog Manager) Oracle BI Applications 7.9.5(DAC, OBIEE Platform), OBIEE Plus , OFA

Data Warehousing Informatica 8.1/7.1, Business Object Data Integrator (BODI) Xir2, ODI (Oracle Data Integrator), Mapplet, Transformations, Workflow Manager, Workflow Monitor, Data Mining, DataStage, Datamart, OLAP, ROLAP, OLTP, SQL *Plus, SQL *Loader

Data Modeling Tools ERWIN 4.0, MS Visio, Rational Rose

DATABASES Oracle 8i/9i/10g/11g, SQL Server 2005/2000, MS Access, DB2,

LANGUAGES C, C++, C#, SQL, PL/SQL, Java, J2EE, HTML, XML,VB,UML

OPERATING SYSTEMS Windows 95/98/2000/2003/NT/XP/Vista, MS DOS, LINUX, HP-UX

Tool & IDE DAC (Data warehouse Administration Console), Microsoft Visual Studio 2003/05.

SQL Tools SQL Developer, TOAD.

Application Servers OC4J, Apache Tomcat.

PROFESSIONAL EXPERIENCE

Client : COX COMMUNICATIONS, ALPHARETTA, GA AUG’09 –TILL DATE

Role : SR.OBIEE DEVELOPER

Description:

Cox Communications designs and manufactures the optical communication products like cables and wires. The company mainly deals with four main products like Data, Video, Telephony, Voip. NRSC project main aim is to develop a new data warehouse for the company using Oracle’s out of box solution packaged with OBIEE and Informatica and thereby creating the reporting environment from OBIEE that helps the end users to analyze the reports.

Responsibilities:

• Installed and configured complete suite of OBIEE 10.1.3.4 in test and development environment on windows platform.

• Worked closely with business users in the client side and designed the system accordingly.

• Created the new RPD and detail level drill downs to as per business requirements using Oracle Answers.

• Worked extensively on OBIEE Administration tool and Presentation Services.

• Worked on the different layers in the data model (Physical, Business and Presentation).

• Involved in gathering and analyzing requirements and documenting them for further implementation.

• Created Session variable, Repository variable in RPD and used the same for role based security and Dynamic calculation in OBIEE answers.

• Customized Repository (RPD) to work with other EBI systems. Pulled new physical tables to physical layer of RPD, joined them with dimensional tables, developed hierarchy and presented them to presentation layer.

• Built Time-Series calculations using AGO and TODATE functions on BMM (Business mapping and modeling) layer of repository.

• Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE answers to build the query.

• Used presentation variable in OBIEE Oracle answers to save prompt values and use them for conditional formatting.

• Developed different Dashboards/Reports with different view( Calculation, Detailed, Pivot, Charts, Filters) using the Presentation services.

• Scheduled iBots and seeded server cache using Delivers to improve system performance. Also used iBots to clear server cache using NQCmd utility. Scheduled reports to be e-mailed using iBots.

• Merged two different Repositories using administration tool and Web Catalogs using Catalog Manager. Used job manager to manage and monitor iBots.

• Developed process for object level migration of web catalog, for post production release of - enhanced and bug fixed reports.

• Worked with both migrations of the Development and QA environments.

• Used TOAD for Oracle and SQL Navigator to connect to databases in Oracle.

• Performed Unit Testing and worked with the end user at various stages of the test cycles.

• Conducted meetings with Project Managers, Business Users and Business Analysts during testing and deployment stage of the application development lifecycle.

Environment:

OBIEE 10.1.3.4, Oracle Answers 10.1.3.4, Informatica Power Center 8.1.1, Oracle 9i, TOAD, SQL Navigator, Web Logic 8X, Windows XP Professional.

Client : KELLOGG BROWN& ROOT (KBR), HOUSTON, TX JULY’08- JUNE’ 09

Role : OBIEE Consultant

Description:

KBR Business Intelligence Team delivers Enterprise reporting capability using a powerful combination of Oracle’s business Intelligence Suite (OBIEE), Pre-built analytics of Financial Management and Procurement applications, as well as dashboards, Pre-built reports, and queries for Business Intelligence users that leverage these tools. Reporting and publishing capabilities deliver pre–built reports in support of standardized business processes and decision making activities

Responsibilities:

• To analyze the specifications provided by the client, understanding the business.

• Install, configure, and administer the OBIEE platform

• Involved in RPD Development, Oracle BI Server, Oracle BI Answers, DAC Configuration, ETL Configuration, and Oracle BI Publisher

• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration.

• Designed Star schema for fact & dimensional tables and created alias for the dimensional tables when necessary.

• Extracted data from Various ERP Systems like Siebel OLAP database, Oracle E business Suite (EBS).

• Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle BI Server Administration Tool.

• Specified Dimensional hierarchy, Aggregate levels for the dimensions.

• Involved in Configuration of Web Catalog Security and Cache Management

• Developed different brand level Reports, Filters, and Prompts using Oracle BI Answers.

• Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in the reports

• Created various reports to fulfill the marketing needs and customized the views using Oracle BI Answers.

• Designed and Configured Interactive Dashboards in Analytics for different groups of users which include like Managers, functional heads, Department Heads.

• Managed Security privileges for each Subject area and Dashboards according to user requirements.

• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, criteria filters, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Siebel Analytics Web / Oracle BI Presentation Services.

• Used the Catalog Manager and maintained the Analytics web catalog to manage dashboards & answers.

• Involved in implementation of Pre built OBI analytics (Financial Management and Procurement Analytics)

• Installed and set up Informatica environment and responsible for administration and migration or repositories between various environments

• Configured DAC –Data warehouse Administration console for running of ETL jobs

• Used DAC to schedule and run the Full and Incremental ETL loads and to schedule the Informatica jobs in Oracle Business Analytic Warehouse

• Used Analytics Web Catalog to set up groups, access privileges and query privileges.

• Used various transformations like Source qualifier, Aggregators, Dynamic Lookup, Router, Sequence generator for mappings based upon the requirement.

• Designed and developed Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for extraction, transformation & loading.

• Worked for performance tuning by finding out the bottlenecks in various mappings.

• Trained and worked with the end-users in developing their own ad-hoc reports using OBIEE Answers.

Environment:

Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.4, Oracle BI Server, BI Answers, BI Administration, BI Dashboards, BI Scheduler, BI Publisher, Oracle BI apps 7.9.5, DAC, Informatica 8.1, Oracle 10g, Oracle e-Business Suite (EBS), Siebel CRM 8, PL/SQL Windows XP Prof

Client : PHARMACETICALS - JOHNSON & JOHNSON PVT. LTD, New Brunswick, NJ JAN’ 07 - MAR’08

Role : SIEBEL ANALYTICS DEVELOPER

Description:

Johnson and Johnson is the world’s most comprehensive and broadly based health care products for the consumer, pharmaceutical and medical devices and diagnostics markets. Viewpoint, which is ePharma Siebel 7.8 CRM application integrated with Siebel Analytics. Modules involved are Sales Force Automation (SFA), Managed Markets (MM) and Call Center Customer (CCC). EPharma call capture for handheld solution. Siebel ePharma pre-call planning, call entry and calendaring application designed for the windows that seamlessly integrates with Siebel

Responsiblities:

• Developed Solution Designs and Detailed Design Documents based on Siebel Analytics Requirements and Business reviews.

• Configured Column and Dashboard Filters in Siebel Analytics Requirement validation of the reports and drilldowns.

• Expert in Siebel Analytics Physical, Business and Presentation Layers.

• Extensively worked on physical, business and presentation layers

• Developed Assets, Opportunities, Entitlements, Partner Authorizations, Service Requests subject areas using Siebel Analytics/Answers.

• Expert in Siebel Analytics components – Clients, .RPD, Presentation Services, server, repository and data sources.

• Extensively worked on RPD, Webcat and Dashboards.

• Created logical tables and assigned levels and custom aggregation rules.

• Used Catalog manager to do work between folders.

• Developed Uploading process of the FEA and all data types, field sizes and formats.

• Worked on Siebel Analytics Administration tools – online and offline.

• Analyze the ETL procedures and developed mappings, mapplets, and using most of the transformations.

• Written SQL queried to test the OLTP & OLAP Databases based on changes of the functionality.

• Did ETL – Data Load Process “Full Load and Incremental Load” testing.

• Created logical tables and assigned levels and custom aggregation rules.

• Worked and used most of the Informatica Transformations in Mappings.

• Extensively worked on synchronizing the thin client to the Handheld (palm) and completed successfully.

• Verified logical tables and validated levels and custom aggregation rules.

• Execute various data transfer scenarios and verify the EDI standards and XML formats.

Environment:

Siebel Call Center 7.7, Siebel Integrated Application 7.8.2, Test Director 7.6, Win XP Professional, Oracle 9i, Informatica 7.1.1 and MS Access, TOAD.

Client : HARTFORD INSURANCE, HARTFORD, CT NOV’ 05 – DEC’ 06

Role : SIEBEL ANALYTICS DEVELOPER

Description:

Hartford Insurance is one of the nation’s largest international insurance and financial services operations. The company is a leading provider of automobile and home owner’s coverage’s commercial property and casualty insurance; reinsurance; and a variety of life insurance, investment products, employee benefits, group retirement plans and institutional liability funding products. The project was to centralize decision making system as part of data management which involved integrating and simplifying by dropping unwanted data elements, introducing new elements and combining data using ETL processes by providing composite and meaningful views to users.

Responsibilites:

• Created Campaign Tracking Dashboards, Advisor Dashboards and Management Dashboard.

• Created business reports using Siebel Answers as per requirements.

• Generated various Analytics reports like Formulary Report and Direct Sales Report using global and local filters.

• Involved in modifications of physical, business and presentation layers of metadata repository using Siebel Analytics Administration tool.

• Identified in managing appropriate security privileges on subject areas and dashboards according to business requirements.

• Created iBots and delivers to send alert messages to subscribed user groups.

• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance

• Configured and administered existing subject areas and created new subject areas as per the modified Star schema information.

• Trained the end-users in developing their own ad-hoc reports using Siebel Answers.

Environment:

Siebel Analytics 7.5.3, Siebel Tools, Informatica Power Center 6.0, Oracle 9i, TOAD, Windows NT.

Client : CELGENE CORPORATION, BANGALORE, INDIA MAR’05 - SEP’05

Role : ORACLE DEVELOPER

Description:

Celgene is a multinational biopharmaceutical company committed to improving the lives of patients worldwide. The project involved implementation of Oracle Application Modules INV, GL, AR, AP, OM and PO.

Responsibilities:

• Gathered the requirement from the client and translated the business design into Technical design.

• Monitor performance and changing performance requirements through application of database tuning and performance optimization techniques.

• Triggers, procedures and functions are developed in this reports using PL/SQL.

• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.

• Prepared Mapping documents and design documents for data conversion.

• Developed validation procedures and error reporting on the data in the intermediate tables.

• Created user defined Exceptions while handling exceptions.

• Troubleshooting production problems and worked effectively with other team members to identify and address problem.

Environment:

Oracle 8i, PL/SQL, SQL * PLUS, SQL * Loader, Windows 2000.

EDUCATION

• Bachelor of Technology in Computer Science, Andhra University

Reference:

As per Request

Contact this candidate