SUMMARY:

• IT professional wif about 8 years of experience in analyzing teh Business Users Requirements, Application Design & Modeling, Development and Implementation of Business Intelligence using Oracle Business Intelligence (OBIEE) / Siebel Analytics. Experience in dataware house wif good understanding of teh architecture.
• Ability to interact effectively wif clients, Understanding their requirements and providing optimum solution and production support.
• Extensive experience on OBIEE / Siebel Analytics Administration Tool, Presentation Services / (OBIEE / Siebel) Analytics Web Answers, OBIEE / Siebel Interactive Dashboards, OBIEE Delivers / IBOTS, Cache Management, OBIEE / Siebel Scheduler Configuration.
• Proficient in building three layers (Physical Layer, Business Model & Mapping and Presentation Layer) of OBIEE / Siebel Analytics Repository using Siebel Analytics.
• Expertise in translating high - level business requirements into logical business dimensional model.
• Expertise in handling all phases of Quality Assurance Life Cycle and Software Development Life Cycle(SDLC) of teh BI Projects.
• Hands on experience in defining key metrics, dimensions, hierarchies and attributes, Aggregate Navigation, Aggregates based on dimension, Level Based Measures, Variables, Initialization blocks, Cache Management.
• Experience in configuring Interactive Dashboards wif drill-down capabilities using global and local Filters, OBIEE / Siebel Security Setup (groups, access/query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Expertise in complete life cycle of Design, Development, Maintenance and Documentation of various functionalities of Data Warehouses including Testing and Code Migration.
• Experienced in Configuring and publishing teh iBots to deliver analytics content based on schedule, automated iBots queries to obtain daily & weekly transactions to all teh departments in teh organization by Emails
• Very good in Debugging, Optimizing and Performance Tuning of Oracle BI Dashboards/Reports.
• Strong knowledge of RDBMS databases like Oracle 10g/11g, MS SQL server .

TECHNICAL SKILLS:

BI Tools: OBIEE 11g/10g, Siebel Analytics 7.8 / 7.7.

ETL Tools: Informatica Power Center 9.1/8.6.0 / 8.1.1 / 7.1.1.

Databases: Oracle 11g/10g / 9i, MS SQL Server 2005 / 2000, MS Access.

Languages: SQL, PL/SQL, Core Java.

Operating Systems: Windows XP / NT, Linux Red Hat, Solaris.

Applications: MS Word, MS Excel, Outlook, FrontPage, Data Modeling, PowerPoint.

Utilities: Toad 9.0/8.5.1, SQL *Loader, Putty, SQL Navigator 5.5.

GUI: OBIEE, Business Objects, Oracle Reports.

PROFESSIONAL EXPERIENCE:

Confidential - Denver, CO

Sr. OBIEE Developer

Responsibilities:

• Worked wif Business Analyst and analysed teh business requirements for developing teh repository and extraction of reports.
• Analysed teh specifications provided by teh client, understanding teh business.
• Install, configure, and administer teh OBIEE platform.
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers and Scheduling AGENTS (IBOTS) in OBIEE 11g.
• Designed Star schema for fact & dimensional tables and created alias for teh dimension and fact tables when necessary. Created teh mapping documents based on teh data model and teh client requirements.
• Monitoring of teh loads of ETL, verification of teh code.
• Created Views and alias for complex queries in teh physical layer of OBIEE 11g in order to improve teh performance of teh reports and to implement complex reports.
• Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle BI Administration Tool.
• Specified Dimensional hierarchy, Aggregate levels for teh dimensions.
• Developed different brand level Reports, Filters, and Prompts using Oracle BI Answers.
• Created various reports to fulfil teh marketing needs and customized teh views using Oracle BI Answers.
• Using teh Cache Seeding option to increase teh performance of dashboards.
• Migrated repositories and catalogs from Dev environment to QA and Production environments.
• Upgraded 10g Repositories into 11g.
• Designed and Configured Intelligent Dashboards in Analytics for different groups of users, which include like Managers, functional heads, Department Heads.
• Developed and debugged many Dashboards using different Analytics Views (Pivot, Table, Chart, and Column Selector, View Selector), Dynamic / Interactive Dashboards wif drill-down capabilities, charts, tabular using global and local Filters.
• Built reports wif action links
• Managed Security privileges for each Subject area and Dashboards according to user requirements.
• Used teh Catalog Manager and maintained teh Analytics web catalog to manage dashboards & answers.
• Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in teh reports.
• Created Initialization Blocks, Repository and Session variables.
• Performance Tuning of Dashboards/Reports and made changes to database by implementing teh materialized views, Creating Indexes etc.
• Used SQL tools like TOAD 9.5 and SQL Developer to run SQL queries and validate teh data in warehouse.

Environment: (Oracle Business Intelligence Suite) OBIEE 11.1.6/11.1.5, Oracle 10g/11g, BI Publisher, TOAD, SQL, SQL Server 2000/2005, Windows 7, Unix, Linux and Windows 2003.

Confidential - Petaluma, CA

Sr. OBIEE Consultant

Responsibilities:

• Worked closely wif teh business users and developers to make sure dat business requirements are correctly translated into database schemas and ultimately into teh application. Interacted wif end users and developers to validate teh data model, reports.
• Analysis of existing OLTP system and Identification of required dimensions and facts from teh Database.
• Creation and Customization of teh OBIEE Repository (Physical, Business and Presentation layer) and Added extension columns in fact and dimension tables.
• Monitoring of teh loads run on ETL and verification of teh code.
• Worked on Oracle BI Answers to build Interactive Dashboards wif drill-down capabilities.
• Time Series Objects, Interactive Dashboards wif drill-down capabilities using page and dashboard prompts, OBIEE Security Setup (groups, object and data level),configured Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Expert in cache management, Repository migration, data level and object level security in OBIEE Analytics.
• Worked on MUD environment.
• Built test cases and tested teh Reports / Dashboards by comparing teh SQL Output on teh Data warehouse to teh values in teh Reports/Dashboards, documented teh test results.
• Created connection pools, imported physical tables and defined joins in teh physical layer of teh repository.
• Created pivot table along wif different kinds like charts, tabular allowing manager to analyze teh business from different perspectives, and provided optimized Analytics requests using column selector and using global and local filters.
• Involved in Reconciliation Process while testing loaded data wif user reports.
• Responsible for overall Business models and Reporting needs.
• Build all user and group level securities including data level.
• Created UAT (user acceptance test) cases
• Assisted in production support. Specified teh aggregate levels for each source and created dimension sources for each level of aggregated fact data in teh BMM layer.
• Assisted in creating a dashboard user guide for new users.

Environment: OBIEE 10.1.3.3.3, Putty, Web logic 10.X, OLAP, SQL, TOAD, UNIX, Solaris.

Confidential - Reston, VA

Sr. Oracle BI Developer

Responsibilities:

• Involved in gathering teh requirements, performing gap analysis, and documenting them into business reporting.
• Created reports and dashboards for review by teh business users.
• Created metadata repository (.rpd) as per business requirements at three layers in Oracle BI Administration Tool.
• Defined Physical Diagram by defining foreign key Joins and developed Business Diagram in BMM layer to define Business Model and requirements.
• Defined multiple Dimensions (Drill-Down Hierarchies) & Logical & Facts /Measures objects in Business Model Layer, and created teh Presentation catalogs in Presentation Layer.
• Developed calculated measures and assigned aggregation levels based on dimension hierarchies in BMM layer.
• Developed many Reports in Oracle BI Answers and created interactive Dashboards using features like Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular wif Global and local Filters.
• Worked on Security settings in Administration Tool to set up users, groups, access privileges and query privileges and also managed security for groups in Answers.
• Implemented both object level and row level security based on roles and responsibilities of end user.
• Dynamically used Filters and provided customized prompts appropriately to avoid excessive data showing up reports using variables.
• Worked on Aggregates, Hierarchies, Calculation wizard in teh Logical Layer.
• Worked on teh Time Series function and implemented time comparison using To Date and Ago functions.
• Worked wif materialized views and aggregates to improve performance.
• Tested reports and dashboards for data integrity.
• Maintained iBots to alert messages and group mails to teh business users.
• Involved in migration of Analytics .rpd and Web Catalog objects from developing environment to QA environment and to teh Production environment.
• Trained Users on teh generated reports for dis project and documented teh work.
• Participated in Post implementation reviews wif teh Project teams.

Environment: OBIEE 10.1.3.2, Oracle 10g, Windows 2003 Server, OLAP, Oracle E-Business Suite 11i (11.5.9), SQL, PL/SQL, Informatica 8.6.0, SQL Loader, Red Hat Linux.

Confidential - Campbell, CA

OBIEE Consultant

Responsibilities:

• Worked closely wif Business Analyst and Gathered Analytics Requirements from different user groups performing GAP Analysis between teh current reports and teh requirements gathered.
• Modified teh existing reports wif necessary configuration changes in frond end as well as in teh back end (.rpd)
• Changes from teh Business Users, incorporate those in Functional Design Documents, and work wif delivery team at offshore.
• Slowly Changing Dimensions are implemented to track teh entire activity of Vendors.

Environment: OBIEE 10.1.3, Oracle 9i, Windows 2003 Server, OLAP, Oracle E-Business Suite 11i (11.5.9), SQL, PL/SQL, Informatica 8.6.0, SQL Loader, Red Hat Linux.

Confidential, NH

OBIEE Developer

Responsibilities:

• Meeting wif business and technical users to understand their data warehousing data needs on a regular basis
• Performed detailed source data analysis to determine grain and data quality characteristics
• Associated wif interfacing teams from Siebel perspective to provide information on Data Mapping relating to Siebel
• Along wif teh ETL team, participated in teh design documentation of teh ETL loads
• Created teh new analytics reports and modified teh already existing ones
• Used conditional formatting in teh reports
• Created reports wif table, pivot, ticker, filter, chart and narrative views wif filters, prompts and also dashboard prompts.
• Created intelligence dashboards and mapped teh Reports
• Worked on metadata repository .rpd enhancements
• Performed project and application level data migration and delivery dat support business information requirements ensuring effective data organization and maximizing re-usability of data
• Worked extensively wif complex mappings using Expression, Aggregator, Filter, Router, Joiner, Sorter and Rank Transformations
• Used Workflow Manager for Creating, Validating, Testing and running teh sequential and concurrent Batches of sessions and workflows
• Provided end user support by addressing their issues

Environment: OBIEE 10.1.3, Oracle 9i, Windows 2003 Server, OLAP, Oracle E-Business Suite 11i (11.5.9), SQL, PL/SQL, Informatica 8.6.0, SQL Loader, Red Hat Linux.

Confidential

Siebel Analytics Developer

Responsibilities:

• Designed/Created/Installed Informatica ETL to load Staging tables in customized Siebel OLAP SQL Server database.
• Extracted data from MS Excel, SQL Server 2000 and flat files and loaded to Data warehouse
• Created teh mapping documents based on teh data model and teh client requirements.
• Designed mappings by using teh Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Created customer hierarchy dimension tables and Analytics metadata for drill down functionality for dashboards
• Created front end reports, Intelligence dashboards by using Siebel Analytics Reporting tool and also worked on few .rpd components to meet teh business requirements
• Debugged and tuned final released production dashboards

Environment: Siebel Analytics 7.5 & 7.7, Siebel Answers, Siebel Dashboard, Siebel iBots, Windows NT, Oracle 9.2.05.