Synopsis:

Over 5 Years of experience in Oracle BI 11g/ 10g Analytics Administration Tool, Presentation Services, Answers, Interactive Dashboards, Security Implementation (LDAP & Default Security),BI Publisher,WriteBack,obiee11g external integration with J2ee Integration and also FMW (Weblogic Console and Enterprise Manager).
EXPERIENCE SUMMARY
Has over 5 years of experience in DW Software applications

• Strong technical skills in SQL Server and MySql Database enhanced with Onsite (SAAC –OBIEE) Airlines Project and Banking (Treasure, TI, and T&M) Implementation Experience.
• Good Hands on experience on OBIEE11g/10g.

- Designing and developing Repository ‘. rpd’ (Physical, business (logical), Presentation layer)
- Providing Object and Data level security (Administration Functionality).
- Create users, assign roles and privileges
- Generate Report /dashboard using Filters and prompts (Design).

• BI Publisher Report Generation.
• Write Back in OBIEE 11g&10g Implementation
• MSAD(LDAP) Implemented in obiee11g
• Configuring Scheduler, IBOTS.
• Expert in OBIEE11g&10g Installation and Configurations.
• Working with Briefing books and giving access to the users.

QUALIFICATION
Bachelors of Engineering

CERTIFICATION

Oracle Business Intelligence Foundation 11g Essentials

Organization1 : Confidential,Chennai from Jun 2007 to Nov 2008
Tenure : Java Developer
Designation : Software Engineer
Organization2 : Seventh Sense Technologies (P) Ltd, Chennai, from Nov 2008 to Sep 2010
Tenure : OBIEE Developer and Implementation
Designation : Software Engineer
Organization3 : Working with Hexaware Technologies Ltd. From September 2010 – Till date
Tenure : OBIEE Developer and Implementation
Designation : Senior Software Engineer

PROJECT EXPERIENCE

Project Name:

:GPC (Treasury Investment,TLM,T&M)

Role:

:Module Lead

Environment:

: Oracle Business Intelligence 11g,SQL 2008, Windows 2008

Duration:

:Oct-2010 to Till Date.

Tools Used:

:OBIEE(11.1.1.5.0),SQL2008,Java1.6,Weblogic 10.3.5,MSAD(LDAP)

Client:

: Confidential,Singapore
Team Size: 2 ( I am taking care OBIEE11g end and another guy is taking care MS SQL DB 2008 )

Description: This project was developed for Banking Industry for their Treasure Investment, Treasury & Market and Treasury Liquidity Management activities. we have provided PL& Risk analysis, AFS, GLAO, Balance Sheet report to analysis the user. The primary objective of this project is to provide enterprise wide data warehousing solutions for top-level executives and to a large extent for operational users also.

Roles and Responsibilities:

• Configuring the OBIEE11g repository modeled the physical, business and the presentation layer.
• Created Dimensional Hierarchies in Business model layer and Logical Calculation.
• Implementing WriteBack function for User Comments in Presentation Layer.
• Developing analytics reports using Filters and Prompts, Presentation variable.
• Providing navigation between reports and dashboards.
• Table, Pivot, Narrative and chart reports in Answers
• Provide the security in OBIEE11g server (Administrative Functionality).
• MSAD(LDAP authentication) and default security implemented in obiee11.1.1.5.0
• Default Security and External authentication

: Confidential,

Role:

: Module Lead (team size :3)

Environment:

: Oracle Business Intelligence, My SQL, Windows 2003

Duration :

: JAN 2009 to Till Date.

Tools Used:

: OBIEE (10.1.3.3.2), My SQL 5.0,SqlYog522,Java 1.6

Description: This project is developed for Saudi Airlines Catering Industry for their transaction activities. The primary objective of this project is to provide enterprise wide data warehousing solutions for top-level executives and to a large extent for operational users also.

Roles and Responsibilities:

• Configuring the OBIEE repository modeled the physical, business and the presentation layer.
• Created Dimensional Hierarchies in Business model layer.
• Worked on Aggregations and Fragmentations.
• Creating and modifying Intelligence Dashboards.
• Developing analytics reports using Filters and Prompts.
• Providing navigation between reports and dashboards.
• Pivot, Narrative and chart reports in Answers
• Provide the security in OBIEE server (Administrative Functionality).
• Allow users with appropriate access to the reports
• Developed detail reports for the business users.

Project Name:

: Confidential,KSA

Role:

: Team Member(team size :3)

Environment:

: Oracle Business Intelligence, My SQL, Windows 2003

Duration :

: NOV 2008 to JAN 2009.

Tools Used:

: OBIEE (10.1.3.3.2), My SQL 5.0,SqlYog522,Java 1.6

Description: This project is developed for a Saudi Arabia Airlines, which is having many branches in various Locations and maintains all the information. It intended to maintain financial information of a company for both external reporting and as well as internal controlling. Separate set of accounting Books can be generated for each accounting units within the company. The results can be consolidated in multilevel hierarchy.

Role and responsibilities:

• Created various types of reports using OBIEE Answers.
• Created various reports in deferent table views like Pivot views, Charts view (Graphical charts, pie charts).
• Developed Dashboards and Answers by using Prompts and Filters.
• Creating and managing Web Groups and Reports Security using OBIEE Web Administration.
• Build Repository all the 3 layers Physical Layer (connecting Data sources & import schema), Business Model & data mapping (create Logical tables & data source mapping) & Presentation layer level (create presentation catalogs), create presentation folders & tested.

Project Name:

: HR System

Role:

: Team Member

Environment:

: JAVA, My SQL, Windows XP

Duration :

: OCT 2007 to OCT 2008.

Tools Used:

Description: Payroll gives you the complete control you need to effectively manage payroll-related activities. Unlimited pay, deduction and benefits records for each employee allow you to accommodate diverse compensation and benefits packages.

Role and Responsibilities:

• Created queries for the ‘Employee Leave Details’ module
• Created queries for the ‘Attendance Process of the Company’ module
• Created queries for the ‘Payroll Process of the Company’ module
• Developed various reports for the entire project using Actuate Report Designer