SUMMARY:

• IT experience of over 8 years , including responsibilities like gathering Business Requirements, System Analysis, Design & Data Modeling, Development, Client Interaction, Oracle Business Intelligence and Data warehousin.
• Five years of experience in OLAP tools like Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.x, Oracle E - Business suite and Siebel Analytics 7.x, Informatica and Data warehousing
• Expertise in OBI Applications (Sales, Service, Marketing, Financial, Supply chain\Orders, Procurement Analytics)
• Worked extensively on OBIEE/Siebel Analytics Administration Tool involving all the 3 layers namely Physical Layer, BMM Layer and Presentation Layer
• Extensive experience in OBIEE/ Siebel Analytics Presentation Services including Answers, Interactive Dashboards, Delivers/IBOTS, Cache Management, Scheduler Configuration, BI Publisher
• Excellent aptitude in translating high-level business requirements into logical business dimensional model, building business models, configuring metadata, Answers, Delivers / iBots, creating reports / Dashboards, cache monitor
• Expertise in Business Model development with various functionalities like Dimensional Hierarchies, Measures, Aggregation Rules, Time Series. etc
• Skilled with Caching & Mapping, data- level and object-level security, MUD, Integration Variables/Initialization Blocks configuration
• Highly skilled in building Interactive Dashboards with drill-down & drill-across capabilities using global & local Filters, Business Rules with User Identity & Roles, Profiles & Personalization
• Very good with implementing the Oracle BI / Siebel Security Setup (groups, data access/query privileges), Metadata Objects (Subject Area, Table, and Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports)
• Well versed in Debugging, Optimizing and Performance Tuning of OBI (Siebel Analytical) Dashboards / Reports to improve performance at Database
• Proficient in working on production and development environment in different RDBMS (in Oracle 8i/9i/10g/11i, SQL Server, Netezza) and strong troubleshooting skills
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema modeling, Snowflakes modeling, fact and dimension tables modeling of data
• Strongly motivated, enjoy team work and capability of mentoring others
• Excellent writing, analytical, communication and interpersonal skil

TECHNICAL SKILLS:

Reporting Tools: OBIEE 10.1.3.x, OBIEE 11g, Siebel Analytics 7.8.4/7.7.1/7.5

Languages: SQL, PL/SQL, HTML, XML, C

Databases: Oracle 8i, 9i, 10g, 11i, SQL Server and Netezza

ETL Tools: Informatica Power Center 8.x, 7.x, 6.x, Datastage

Operating Systems: Windows 2000/XP/Vista, Unix, Linux

PROFESSIONAL EXPERIENCE:

Confidential,San Francisco,CA

Sr OBIEE Developer

Responsibilities:

• Involved in requirement gathering from user through meetings, understanding the business from end user and technical perspective.
• Built prototype reports from excel spreadsheets during the requirement-gathering phase to visualize the reports and clarify requirements.
• Used the OBIEE Admin Tool to develop the three layers in the Repository.
• Created connection pools, physical tables and defined Primary key, foreign key joins, complex joins in the physical layer of the repository.
• Created and modified logical tables, logical columns and defined Foreign-keys and complex joins.
• Created dimensions, dimension hierarchies, levels, level based measures and defined level, attributes level keys.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Customized/created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Worked extensively on OBIEE Answers to create the reports as per the client requirements.
• Defined additional views (compound, table, chart views) of the data returned by the request to visualize data in many different ways.
• Maintained effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns.
• Created Proactive agents (iBots) and configured Interactive dashboards to alert the employees as per the requirements.
• Built parameter page using image prompts that enables users to visually select the input parameters.
• Created groups in the repository and added user to the groups and granted privileges explicitly through group inheritance.
• Enabled Single Sign On for OBIEE to allow authorized users to login automatically to OBIEE without entering user credentials.
• Worked extensively on performance tuning including creating aggregate tables, caching and event polling tables.
• Created custom CSS classes and styles, java scripts and HTML scripts to enhance the dashboard functionality and produce reports that meet user requirements.
• Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers and Delivers.
• Worked on improving the dashboard performance, readability, and security.

Environment: Oracle Business Intelligence 10.1.3.4, Informatica, Oracle 10g, Oracle SQL developer, Toad, Unix.

Confidential,Canton,MA

Sr.OBIEE Developer

• Configured OBIEE Repository (Physical, business and presentation layer) to provide Analytical Reporting solutions to business.
• Implemented Dimensional Hierarchies, Aggregate navigation, Fragmentation content, and other various features.
• Created Repository, system and non - system session variable and initialization blocks for various reporting needs.
• Created role based dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts.
• Used several OBI reporting features (Navigational, Drill Down, Drill Across, Guided Navigation, Security?.etc).
• Analyzed requirements, implemented prebuilt business intelligence solutions using the Oracle Business Intelligence Analytics platform
• Identified granularity level of the Financial data required to be available for analysis
• Worked extensively on OBIEE Answers to create the Financial Statement reports and Intelligence Dashboards (Financials) as per the detailed design requirements
• Extensively used page prompts and dashboard prompts for filtering data values in financial reports
• Created drill down charts and drill down tables to gather more information on Financial Analytics and Supply Chain using navigation
• Used LDAP Server for Security Authentication.
• Created security settings to setup groups, query privileges and access privileges
• Coordinated the OBIEE RPD and Web Catalog objects migration from Dev environment to QA environment and to the Production environment.
• Created reports with PDF, RTF and Excel templates using the BI Publisher.
• Delivers (IBots) are created and scheduled.
• Performance tuning on the Dashboards and Answers.
• Worked extensively to customize DAC (Execution Plans, Subject areas, Task Definitions and Tables) for OBIEE Financial Analytics.
• Designed and tested Reports in the Dashboards for the Oracle Financial Analytics and created the Adhoc report according to the client needs.
• Successfully configured OBIEE EBS for oracle BI Applications.
• Configured the Extract date, Global Currencies, Exchange Rate Types, Fiscal Calendar.
• Implemented Object level security and data level security.
• Training business users.

Environment: OBIEE 10.1.3.4, Oracle BI Apps 7.9.5/7.9.6, DAC, BI Publisher, Siebel CRM, Informatica 7.x, Oracle 10g, Windows

Confidential, IL

OBIEE Developer

• Developed OBIEE Repository per user requirements and available information in DW.
• Implemented security by creating roles and web groups, checks with External tables and LDAP.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• All the jobs are integrated using complex Mappings including Mapplets and Workflows using Informatica power center designer and workflow manager. Version 8.6
• Extensively used OBIEE Admin tool to import the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool
• Developed multiple Dimensions (Drill - Down Hierarchies) and Logical and Facts / Measures objects in Business Model Layer, and has successfully created the Presentation catalogs in Presentation Layer.
• Developed Dashboards such as Default Dashboard for the users when after login directed to a default dashboard based on the department they work
• Successfully developed row based calculations in a pivot table for the reports based on sales RPD.
• Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE answers to build the query.
• Had developed chart and tabular reports for the total sales for Quarterly, half-yearly and annually using global and local filters.
• Scheduled iBots and seeded server cache using Delivers to improve system performance.
• Developed iBots such as Purge to clear server cache using nqcmd utility and had developed Scheduled reports to be e-mailed using iBots.
• Developed and debugged Dashboards/ reports visibility with respect to user's responsibility and web groups in an integrated environment.
• Coordinated the Analytics RPD and Web Catalog objects migration from Dev environment to QA environment and to the Production environment.
• Have used Administration Tool configure Multiuser Development Environment (MUDE) for multiple users for the development environment.
• Con ducted meetings with Project Managers, Business Users and Business Analysts during testing and deployment stage of the application development lifecycle.

Environment: OBIEE 10.1.3.x, Netezza, Oracle 10g, SQL, Oracle SQL developer, data stage, Linux

Confidential,Irving, TX

OBIEE Consultant

• Gathered Business requirements by interacting with the business users, defined subject areas for analytical data requirements.
• Created mockup reports and dashboards for review by the business users.
• Customized the OBIEE 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.
• Used the security settings in OBIEE Admin tool to setup users, Groups and Access privileges.
• Created materialized views and aggregates to improve performance.
• Customized Activity and Revenue star schemas.
• Customized reporting with OBIEE 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, navigation, and automatic drill - down.
• Created user level security for intelligence dashboards based on Business Requirement.
• Customized and Developed OBIEE Analytics Reports Account Activity, Revenue on business segmentation, Actual Vs Forecast Response rates, and Segment and Offer responses.
• Created Dashboards with Dashboard prompts, Charts, Pivot tables.
• Performed Data Validation of data in the reports and dashboards.
• Extensively used SQL Tuning to improve performance.
• Creat ed iBots to send pre-processed reports using OBIEE Delivers.

Environment: OBIEE10.1.3.3, Informatica Power Center 7.1.2, Oracle 9i, SQL*Plus, Windows

Confidential,Columbus,OH

Siebel Analytics Consultant

• Worked with functional and technical project leads, marketing, sales, finance, and other business groups to identify, analyze, and document Business requirements.
• Identified and worked with various application areas in identifying, analyzing, and documenting various information sources solutions to meet the business requirements.
• Worked extensively on Siebel applications (Siebel Answers, Delivers, and Dashboards).
• Created Dashboards by embedding reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics.
• Involved in design and development of repository (Creating / Modifying objects in Physical, Business and Presentation layer) and the process of repository migration.
• Development of interactive drillable charts such as bar - charts, pie-charts, radars, bubble-charts, etc
• Implementation of Siebel Delivers using iBots for delivery of reports through email, hand-held devices and mobile phones.
• Security management for users, groups and web-groups using the various authentication systems such as LDAP, OS, Database and Database table authentication using Session Variable features, as well as Dashboard / Report-level security.
• Analytics Application Response-time Performance management using optimization efforts such as aggregate navigation, indexes and Oracle materialized views.
• Implementation of criteria filters to narrow-down the result set from the analytics requests.
• Developed/Bench-Marked performance tuning strategies with business model-level calculations versus Data warehouse level pre-computations and aggregations.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduled them to run at specified time with required frequency. Developed and executed test plans and played an active role in product rollouts.
• Life-cycle support for migration efforts from development to QA to production analytics.
• Involvement with ETL (Extract-Transform-Load) development team to communicate the specification for the required dimensional, aggregate and indexed data tables.
• Involved in development of many complex Informatica mappings and mapplets to build key interfaces using transformations and reusable transformation units (Update Strategy, Filter, Router, Expression, Lookup, Aggregator) for loading data into Data Warehouse.

Environment: Siebel Analytics 7.8.4, Informatica Power Center 6.x/7.x, Oracle 9i, Toad, UNIX

Confidential

Siebel Analytics Consultant

• Created and administered the Physical Layer, Business Model and Mapping Layer and Presentation Layer in Siebel Analytics Repository using Siebel Analytics Administration Tool.
• Developed calculated measures and assigned aggregation levels based on dimension hierarchies.
• Worked extensively on Siebel Answers, Siebel Delivers, and Siebel Intelligent Dashboards for Compliance department using Siebel Analytics stand - alone/integrated implementation.
• Responsible for developing different kinds of reports/Ad-hoc queries using Siebel Answers and assigned them to application specific dashboards.
• Configured presentation layer used by different user groups and also established the various standard queries, in order to support the presentation layer.
• Created Security settings in Siebel analytics Administration Tool to set up groups, access privileges and query privileges and also manages security for groups in Siebel Answers.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Used Filters and provided customized prompts (filtering options) appropriately to avoid excessive data showing up reports.
• Worked on the Time Series Wizard and implemented time comparison measures.
• Responsible for unit testing, integration testing of the reports generated using Siebel analytics.
• Involved in user trainings on the generated reports for this project.
• Participated in Post implementation reviews with the Project teams.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) for performing the customer insights / trends using Siebel Analytics Web.
• Configured IBots to deliver Analytics content based on schedule, automated IBot queries to obtain daily and weekly reports.
• Implemented security by creating roles & web groups, checks with External tables.
• Performed query optimizations / tuning in physical layer as well on database.
• Imple mented the session partitions (Database and Informatica) for performance issues.

Environment: Siebel Analytics 7.x, Informatica Power Center 6.x / 7.x, Oracle 9i, HP.