SUMMARY

• Over 7 years of IT experience with extensive experience in Data Warehousing solutions using Siebel e - Business Applications, Siebel Analytics/OBIEE and Informatica.
• Expertise in designing and development of Repository (OBIEE/Siebel analytics).
• Experience in End-to-end implementation of OBIEE Applications.
• Extensive experience in Siebel Analytics 7.x, OBIEE 10.1.3 including configuring repository, creating/managing OBIEE Intelligent Dashboards, Answers, Delivers and IBots.
• Extensive hands on experience in Metadata Modeling at all three layers (Physical, Business Model and Presentation) using the Siebel Analytics Administration Tool.
• Proficient in Installing and Configuring Oracle Business Intelligence, both stand-alone & Enterprise Applications, Knowledge in DAC Client/Server installation and configuration.
• Experience in creating Metadata Objects and Web Catalog Objects (Dashboards, Pages, and Reports) using Admin Tool and Siebel Analytics Web.
• Experience in creating reports based on requirements.
• Worked on Caching mechanisms, aggregations for better performance.
• Experience in Metadata Modeling at all three layers (Physical, Business Model and Presentation) using the Siebel Analytics Administration Tool.
• Experience in Debugging, Optimizing and Performance Tuning of Oracle Bi Dashboards/ Reports.
• Have extensive experience in Oracle back-end programming using PL/SQL.
• Experience in creating customised reports like adding colours, text and peronal widgets.
• Experience in creating Metadata Objects and Web Catalog Objects (Dashboards, Pages, and Reports) using Admin Tool and Siebel Analytics Web.
• Extensive experience in creating IBots using OBIEE Delivers to create alerts based on results.
• Ability to work in-groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.
• Experience in creating Metadata Objects and Web Catalog Objects (Dashboards, Adhoc Reports, and IBots) using OBIEE Admin Tool and Siebel Analytics Web UI
• Extensive experience on assigning Data security & UI level security to the users using OBIEE repository objects & external database.
• Experience in creating reports with drill-down Capabilities using hierarchies.
• Extensive experience in dimensional modeling schemas like star schema and snow flake schema.
• Strong knowledge of Data Warehousing, Data modeling, Stored Procedures, functions, schemas and views.
• Extensive experience in Data Warehousing development and ETL methodology Using Informatica Power Center / Power Mart 7.x/ 6.x /5.x
• Experience using Informatica Power Mart, Informatica Power Center (Source Analyzer, Data Warehousing Designer, Mapping Designer - data Transformation and mapping issues, Mapplet s, Transformations).
• Expertise in building complex business rules by creating complex mappings/ mapplets, shortcuts, reusable transformation.

TECHNICAL SKILLS

BI, OLAP, Reporting: Oracle Business Intelligence 10x, Informatica 7.x/8x (Power Center Power Mart), Siebel Analytics 7x

RDBMS: Oracle 8i/9i/10g, SQL Server

DB Tools: TOAD, SQL*LOADER, IMPORT/EXPORT, ODBC/JDBC, ER Studio, Erwin.

Programming Languages: SQL, PL/SQL, Java, JavaScript, HTML

Data Modeling: Physical, Logical, Relational, Dimensional (Star, Snowflake, FactsDimensions), OLTP/OLAP.

Operating Systems: Windows 98/NT/XP, HP UNIX, Sun Solaris.

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Sr OBIEE Developer

Responsibilities:

• Worked on building Siebel Analytics / OBIEE Repository at 3 layers i.e., Physical Layer, Business Model and mapping Layer and Presentation Layer.
• Create/Modify Metadata repository (.rpd) as per the data requirements by using Oracle BI Analytics Server Admin tool.
• Worked with Business Groups to identify, analyze, and document Business Requirements.
• Created Business Facts, Dimensions and defined Logical relation between them at the Business model and mapping layer.
• Worked on setting up Dimensional Hierarchy.
• Extensively worked on IBots using OBIEE Delivers to create alerts based on results.
• Identified and created aggregate tables to improve query performance.
• Created Aggregate level and level based measures.
• Created Web-groups for security purpose with access privileges.
• Created Dashboards & Answers.
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
• Involved in setting up ibots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.
• Created dimensions in the Business model & Mapping layer.
• Assigned Data level & UI level security to the Users.
• Managed security privileges for each subject area and dashboard according to user requirements.
• Customized Reports look and Feel using Column Formatting, Conditional formatting.
• Customized Dashboard reports using drill-down capabilities.
• Worked on cache purging strategy using event-polling table cache purging technique.
• Created filters using repository variables, Presentation variables. Also created saved filters that can be reused by multiple reports.
• Migrated Analytics RPD and Web catalog from one environment to another.
• Designed and Developed Custom Mappings and Workflows in Informatica to bring the data from other data source systems and Integrated using Universal Adapters in DAC.
• Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and Informatica Workflow Monitor.
• Involved in Integrating Oracle BI Presentation Services with BI Publisher.

Environment: Siebel Analytics 7.x / OBIEE 10.x, Informatica 8.x, BI Publisher, DAC, Oracle 10g, SQL, PL/SQL, TOAD, Windows.

Confidential, Los Angeles, CA

OBIEE Developer

Responsibilities:

• Worked closely with the business experts to understand the source data.
• Assigned Data level & UI level security to the Users.
• Customized Reports look and Feel using Column Formatting, Conditional formatting.
• Customized Dashboard reports using drill-down capabilities.
• Created Report, dashboards, Answers Query.
• Worked on integrating and configuring BI Publisher with OBIEE.
• Create/Modify Metadata repository (.rpd) as per the data requirements by using Oracle BI Analytics Server Admin tool.
• Identified and created aggregate tables to improve query performance.
• Extensively worked on IBots using OBIEE Delivers to create alerts based on results.
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBot queries to obtain daily and weekly reports.
• Developed Custom reports/ Ad-hoc queries using answers and assigned them to application specific dashboard.
• Experience configuring interactive Dashboards with drill-down capabilities using global and local Filters, OBI Security Setup (groups, access / query privileges), Metadata objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Worked on cache purging strategy using event-polling table cache purging technique.
• Created reports using different views like Compound Layout, chart, line graph, tabular view, pivot table, View Selector etc.
• Involved in creating Dashboard Prompts / Page prompts.
• Created web-groups for security purpose with access privileges.
• Created RTF templates in MS Word by connecting to BI Publisher and publish these templates for the reports to view data in BI Publisher.
• Created Metadata Objects and Web Catalog Objects (Dashboards, Adhoc Reports, and iBots) using Admin Tool and Siebel Analytics Web UI
• Developed ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center 7.1.

Environment: Siebel Analytics 7.x, Informatica 7.x, OBIEE, DAC, BI Publisher, Toad, Perforce and Oracle 9.

Confidential, Atlanta, GA

OBIEE Developer

Responsibilities:

• Collaborated with Business contacts & Business Analysts in the analysis and preparation of OBI data requirements
• Worked on cache purging strategy using event-polling table cache purging technique.
• Created reports using different views like Compound Layout, chart, line graph, tabular view, and pivot table, View Selector etc.
• Involved in creating Dashboard Prompts / Page prompts.
• Created web-groups for security purpose with access privileges
• Created Session & Repository Variables to achieve desired functionality.
• Created web-groups for security purpose with access privileges.
• Created Dashboards & Answers.
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBot queries to obtain daily and weekly reports.
• Created reports using different views like Compound Layout, chart, line graph, tabular view, pivot table, View Selector etc.
• Customized Reports look and Feel using Column Formatting, Conditional formatting.

Environment: Siebel Analytics 7.x, OBIEE, Oracle 9i, PL/SQL, SQL, SQL *Plus, Erwin, TOAD

Confidential

Data Warehouse Programmer

Responsibilities:

• Documented business requirements, functional specifications and test requirements
• Used Informatica PowerCenter 7.1.1 for extraction, transformation and loading (ETL) of data in the data warehouse.
• Implemented logical and physical data modeling with STAR and SNOWFLAKE techniques using Erwin in Data warehouse.
• Created Informatica Mappings with different transformations including Source Analyzer, Lookup, Filter, Expression, Rank, Aggregator, Stored Procedure, Look up Transformations and more.
• Developed mapplets, mappings and configured sessions.
• Created and monitored workflows and tasks using Informatica PowerCenter Work flow Manager.
• Worked Efficiently with Designer tools including Source Analyzer, Warehouse designer, Mapping and Mapplet Designer, Transformations.
• Extracted data from different sources like Oracle, SQL Server and Flat files implemented business logic and loaded into the target Warehouse (Oracle).
• Handled slowly changing dimensions type 1, 2 and 3.
• Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse (Oracle 8i).
• Created reusable transformations and mapplets to use in multiple mappings.

Environment: Informatica Power Center 6.2, Oracle 8i, SQL, PL/SQL, Windows NT.