SUMMARY:

• Oracle 11g/9i Administration, SQL Server Administration, SQL, PL/SQL Development, Visual Basic .Net, Web Based Technologies and Client Server Technologies.
• Over seven years of experience in Software Development and Expertise in OBIEE 10.1.3.3.2 / 7.7
• In which 7 + year of experience in OBIEE 10.1.3.3.2, Oracle BI Applications 7.9.4, Siebel Analytics 7.7 which include building and configuring repository, creating and managing oracle/siebel Intelligent Dashboards, oracle/siebel Answers, oracle/siebel Delivers and oracle/siebel iBots.
• Responsibility includes gathering business requirements, analysis, design, data modeling, development, Client Interaction, and Compiling Specifications from client, Modification and Testing.
• Team player and an individual contributor with steep learning curve and good interpersonal skills.
• Experience in Installation, Configuration, and Administration of Oracle BI Apps 7.9.4, OBIEE 10g standalone, Informatica Power Center 8.1.1/7.1.4,
• Stand Alone and Enterprise editions (SAS/SAW), Experience in DAC Client/Server Installation and configuration.
• Hands on experience in administrating oracle 10g/9i and SQL Server 2005/2000 databases in DEV and TEST Environments.
• Experience with repository development, configured metadata objects (Subject Area, Table, and Column) and web catalog objects (Dashboards, Pages, Folders, Reports). Added Metadata changes to the OBI/Siebel Analytics .rpd
• Responsible for Unit, System and Integration Testing and Performed Data Validation for all the ETL’s and reports that are generated from Informatica and OBI/Siebel Analytics.

TECHNICAL SKILLS:

Operating Systems: Unix, Windows 2003/2000 Server, XP Professional.

Business Intelligence: CRM (Siebel Analytics)OLAP CubesOracle Business Applications 7.9.4, OBI EE - Dashboards, Answers,Ibots, BI Publisher.Siebel Analytics 7.7 Siebel tools.: Hyperion Essbase 9.3.1

Databases: Oracle 11g & 10G/9.2/8i/, MS SQL Server 2005/2000, MS Access.

Database & Office Tools: TOAD, SQL Loader, DTS, MS Office Enterprise, MS-Visio

Languages: SQL, PL/SQL, .Net VB/ASP, and HTML

EXPERIENCE:

Oracle Business Intelligence Developer

Confidential, Dallas, TX

Responsibilities:

• Worked closely with Business Analyst in understanding the Analytics requirements and created the business model for generating reports as per the user requirements.
• Configured OBIEE Repository like implementation of physical data model as per requirements, importing the tables and having the physical joins/keys required and changed the physical joins/key on the existing tables.
• Modeling activities which included building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns in Business and Mapping model layer. Established the logical joins/keys required to support drill-down aggregation.
• Created dimension hierarchies and assigned levels for each level.
• Designed and Configured 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.
• Developed 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, Customized pre-built dashboards.
• Developed custom reports/Ad-hoc queries using OBI Answers and Filters.
• Implemented the delivery of iBots using OBI Delivers to alert the associated teams.
• Responsible for Unit and System Testing and Performed Data Validation for all the reports that are generated from OBIEE.
• Performed Testing of the IT Defects and CR raised by the Testing team.

Confidential, allas, TX

Oracle Applications Developer

Responsibilities:

• Worked closely with Business Analyst in understanding the Analytics requirements and created the business model for generating reports as per the user requirements.
• Configured OBIEE Repository like implementation of physical data model as per requirements, importing the tables and having the physical joins/keys required and changed the physical joins/key on the existing tables.
• Modeling activities which included building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns in Business and Mapping model layer. Established the logical joins/keys required to support drill-down aggregation.
• Created dimension hierarchies and assigned levels for each level.
• Designed and Configured 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.
• Developed 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, Customized pre-built dashboards.
• Developed custom reports/Ad-hoc queries using OBI Answers and Filters.
• Implemented the delivery of iBots using OBI Delivers to alert the associated teams.
• Responsible for Unit and System Testing and Performed Data Validation for all the reports that are generated from OBIEE.
• Performed Testing of the IT Defects and CR raised by the Testing team.

Environment: Oracle Business Intelligence suite (OBI EE), Oracle 11g, Toad 9.0, Windows Adv Server 2003, SQL, PL/SQL, MS Visio 2007 professional.

Oracle Business Intelligence and Oracle BI Apps Developer

Confidential, Dallas, TX

Responsibilities:

• Involved in preliminary source system analysis to the collected Business requirements from the BSA.
• Involved in meetings/interviews with users, BSA’s, and data analysts, and examined the business, functional and technical requirement documentation.
• Used simple to complex analytical SQL queries against the source databases to identify and analyze the authenticity of the data before importing to build the OBI repository.
• Involved in laying out a strategy with senior management and technical team for building the metadata that presents the business model to support the business requirements.
• Involved in creating POC’s (proof of concepts) for the repositories and business functionalities with the architect team and business users.
• Identified the appropriate facts, metrics, hierarchies, and territories to structure the initial conceptual model of the business from the requirement documentation.
• Identified the source and target schemas and the ER relationships to support the business reporting model.
• Identified the lowest level of detail (Grain) and rollups drill mechanism.
• Created a repository using OBI Administration tool by importing tables into the physical layer and created the business and mapping model to in corporate the business logic.
• Add calculated measures that involve operations on existing columns.
• Add time series calculations (for example, percent change in a measure compared to same period in previous year).
• Created presentation catalog which allows exposing the business model to users in Oracle BI Answers so that users can build requests to analyze the data.
• Created presentation folders and test with Answers.
• Use the query log to verify query results and debugging issues if any.
• Created Dashboard Pages, Creating a New Interactive Dashboard Page by using answers from presentation catalog.
• Created Prompts to Filter Interactive Dashboard Data and Configuring Guided Navigation Links
• Created Pivot tables, views, charts.
• Created and Delivering an iBot

Environment: Sun E3500, IBM, Oracle 9i, SAS 9.0, PL/SQL, SQL*PLUS, Dollar Universe Scheduler,