SUMMARY:

• Over six years’ experience in the Business Requirements Analysis, Application Design, Data Modeling, Development, Testing and
• Implementations of Oracle Business Intelligence: Building Oracle Repository using Administration tool, Creating and formatting reports and dashboards using analysis/answers and finally using BI Publisher for developing reports in 10g/11g.
• Good business skill, Analytical skill as well as team player

TECHNICAL SKILLS:

Applications / Modules: OBIEE 10g/11g, BI Publisher 10g/11g

Languages: SQL, HTML, XML

Methodologies: Oracle AIM, SDLC

Operating Systems: MS Windows, UNIX

Software: Microsoft Office Suite, including MS Project, XML, WebServices

Databases / Tools: Oracle SQL Developer, Toad

Informatica Power Center 8.6 & 9.1

OBIEE Versions: 11.1.1.x.x, 10.1.3.4.1, 10.1.3.2.1

PROFESSIONAL EXPERIENCE:

Confidential

OBIEE Developer

Responsibilities:

• Gathered Business requirements by interacting with the business users, defined subject areas for analytical data requirement.
• Customized the RPD (physical, BMM, and presentation layers).
• Created dimension hierarchies, aggregates, and keys in the BMM layer.
• Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
• Worked on repository and session variables.
• Customized reporting with Analysis and integrated them into the Dashboards.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.
• Created dashboards with global prompts, column selectors, navigation, and automatic drill - down.
• Created user level security for intelligence dashboards based on Business Requirement.
• Created Dashboards with Dashboard prompts, Charts, Pivot tables.
• Performed Data Validation of data in the reports and dashboards.
• Performed production support for the project.

Confidential

SR OBIEE Developer/Business Analyst

Responsibilities:

• Gathered Business requirements by interacting with the Business Analysts and the business users and created mockup reports.
• Do estimates for projects and submit final functional documents for approval.
• Work with other developers and DBS’s to make sure the project is done in a timely manner.
• Customized the Repository (physical, BMM, and presentation layers).
• Created dimension hierarchies, aggregates, and logical sources in the BMM layer.
• Worked on repository variables and session variables.
• Used the security settings in the Console and Enterprise Manager to setup users, Groups and Access privileges.
• Spend more time with end users to better understand their needs.
• Generated Reports by using Report features like Pivot tables, charts and view selector.
• Created Dashboards with Dashboard prompts, Charts, Pivot tables.
• Performed Data Validation of data in the reports.
• Performed production support for the project.
• Update status every week so upper management is aware with ongoing projects

Confidential

OBIEE Consultant

Responsibilities:

• Worked closely with the business users and developers to make sure that business requirements are correctly translated into database schemas and ultimately into the application.
• Requirement validation of the reports and drill downs with business users.
• Creation and Customization of the OBIEE Repository (Physical, Business and Presentation
• Knowledgeable in cache management, Repository migration, data level and object level security in OBIEE Analytics.
• Created dimension hierarchies, level based measures, Time Series metrics and derived columns of business metrics in the BMM layer.
• Worked on repository and session variables.
• Customized reporting with OBIEE Analysis and integrated them into the Dashboards.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.
• Created dashboards with global prompts, column selectors, navigation, and automatic drill-down.
• Created user level security for intelligence dashboards based on Business Requirement.
• Performed Data Validation of data in the reports and dashboards.
• Performed production support for the project.

Confidential, San Jose California.

OBIEE Consultant

Responsibilities:

• Gathered Business requirements by interacting with the Business Analysts and the business users and created mockup reports.
• Customized the Siebel Analytics Repository (physical, BMM, and presentation layers).
• Created dimension hierarchies, aggregates, and logical sources in the BMM layer.
• Worked on repository variables and session variables.
• Used the security settings in the Console and Enterprise Manager to setup users, Groups and Access privileges.
• Involved in the upgrade task force as well as verifying the new environment.
• Defined ibots/agents and delivers for various request.
• Generated Reports by using Report features like Pivot tables, charts and view selector.
• Created Dashboards with Dashboard prompts, Charts, Pivot tables.
• Performed Data Validation of data in the reports.
• Performed production support for the project.

Confidential, Chicago, IL.

OBIEE Consultant

Responsibilities:

• Gathered Business requirements by interacting with the business users, defined subject areas for analytical data requirement.
• Customized the Siebel Analytics Repository (physical, BMM, and presentation layers).
• Created dimension hierarchies, aggregates, and keys in the BMM layer.
• Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
• Worked on repository and session variables.
• Customized reporting with Siebel Answers and integrated them into the Dashboards.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.
• Created dashboards with global prompts, column selectors, and automatic drill-down.
• Created user level security for intelligence dashboards based on Business Requirement.
• Created Dashboards with Dashboard prompts, Charts, Pivot tables.
• Performed Data Validation of data in the reports and dashboards.
• Created iBots to send pre-processed reports using Siebel Delivers.
• Performed production support for the project.

Confidential

Seibel Quality Assurance Analyst

Responsibilities:

• Verified business requirements and functional specifications
• Conducted system functionality testing as well as performance testing: developed and executed test cases, produced problem reports, suggestions, system test logs, and test incidents reports
• Execute the test cases to test the application and evaluate the result
• Analyzed and reported the defects to the developers using Mercury Quality Center
• Reported the bugs, emailed notifications to the developers using the Mercury Quality Center.