SUMMARY

• Over Seven years’ experience in teh 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, Maryland

OBIEE Lead

Responsibilities:

• Gathered Business requirements by interacting with teh business users, defined subject areas for analytical data requirement.
• Customized teh RPD (physical, BMM, and presentation layers).
• Created dimension hierarchies, aggregates, and keys in teh BMM layer.
• Modified Presentation Layer to add presentation tables and columns to meet teh business user needs.
• Worked on repository and session variables.
• Customized reporting with Analysis and integrated them into teh 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 teh reports and dashboards.
• Performed production support for teh project.
• Perform some ETL task of taken data from source, transform teh data and then load to teh target.

Confidential

SR OBIEE Lead

Responsibilities:

• Gathered Business requirements by interacting with teh Business Analysts and teh 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 teh project is done in a timely manner.
• Customized teh Repository (physical, BMM, and presentation layers).
• Created dimension hierarchies, aggregates, and logical sources in teh BMM layer.
• Worked on repository variables and session variables.
• Used teh security settings in teh 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 teh reports.
• Performed production support for teh project.
• Update status every week so upper management is aware with ongoing projects

Confidential, Michigan.

OBIEE Consultant

Responsibilities:

• Worked closely with teh business users and developers to make sure that business requirements are correctly translated into database schemas and ultimately into teh application.
• Requirement validation of teh reports and drill downs with business users.
• Creation and Customization of teh 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 teh BMM layer.
• Worked on repository and session variables.
• Customized reporting with OBIEE Analysis and integrated them into teh 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 teh reports and dashboards.
• Performed production support for teh project.

Confidential, San Jose California

OBIEE Consultant.

Responsibilities:

• Gathered Business requirements by interacting with teh Business Analysts and teh business users and created mockup reports.
• Customized teh Siebel Analytics Repository (physical, BMM, and presentation layers).
• Created dimension hierarchies, aggregates, and logical sources in teh BMM layer.
• Worked on repository variables and session variables.
• Used teh security settings in teh Console and Enterprise Manager to setup users, Groups and Access privileges.
• Involved in teh upgrade task force as well as verifying teh 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 teh reports.
• Performed production support for teh project.

Confidential, Chicago, IL

OBIEE Consultant

Responsibilities:

• Gathered Business requirements by interacting with teh business users, defined subject areas for analytical data requirement.
• Customized teh Siebel Analytics Repository (physical, BMM, and presentation layers).
• Created dimension hierarchies, aggregates, and keys in teh BMM layer.
• Modified Presentation Layer to add presentation tables and columns to meet teh business user needs.
• Worked on repository and session variables.
• Customized reporting with Siebel Answers and integrated them into teh 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 teh reports and dashboards.
• Created iBots to send pre-processed reports using Siebel Delivers.
• Performed production support for teh project.

Confidential, Arden Hills, MN

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 teh test cases to test teh application and evaluate teh result
• Analyzed and reported teh defects to teh developers using Mercury Quality Center
• Reported teh bugs, emailed notifications to teh developers using teh Mercury Quality Center.