SUMMARY

• Over 8 years of experience in the IT industry involving requirement analysis, design, development and implementation of reporting tools, RDBMS and Client Server applications under different environments.
• Experience in OBIEE 11g, 10.1.3.4.1 Oracle BI Applications 7.9.6.1, Siebel Analytics 7.8 which include building and configuring repository, creating and managing Oracle/Siebel Intelligent Dashboards, Oracle/Siebel Answers, Oracle/Siebel Delivers and Oracle/Siebel iBots ETL Informatica, Reporting-Siebel Analytics, Scheduling-DAC .
• Experience with gathering business requirements, analysis, design, data modeling, development, Client Interaction and compiling specifications from client, modification and testing.
• Expertise in providing end-to-end business intelligence solutions using OBIEE/Siebel Analytics.
• Worked extensively on OBIEE/Siebel Analytics Administration Tool, Presentation Services/ OBIEE/Siebel Analytics Web Answers, OBIEE/Siebel Interactive Dashboards.
• Proficient in building three years Physical Layer, Business Model Mapping and Presentation Layer metadata Understanding and defining key metrics, dimensions, hierarchies and attributes.
• Experience configuring Interactive Dashboards with 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 .
• Extensive experience working with Oracle Business Analytics Warehouse and creating Star Schema, Snowflake data structure, slowly changing dimensions and dimensions and fact tables in the BI Apps and experience with understanding universal adaptors in order to load into BI
• Practical understanding of the Data modeling Dimension Relational concepts like Star Schema modeling, Snowflakes modeling, fact and dimension tables modeling of data.
• Experience with Hyperion Essbase, and Integrated Essbase with OBIEE
• Hands on experience in ETL process using Informatica Power Center for various transactions and loading data from disparate data sources.
• Worked with MS Project, Excel, Visio and MS Word.
• Ability to interact effectively with clients, Understanding the requirements and providing optimum solution and production support.
• Highly motivated, enthusiastic professional with a high degree of commitment to succeed.
• Excellent writing, analytical, communication and interpersonal skills.
• Quick learner and excellent team player.

TECHNICAL SKILLS

• Reporting/Data Warehouse Tools: OBIEE 11g, Informatica 8.6.1, BI Apps and DAC 10.1.3.4.1
• Dat abase Languages: SQL, SQL Plus
• OLAP/DSS ETL Tools: Informatica Power Center 7.1, Siebel Tools
• Siebel Applications: Siebel Sales, Forecasting, Energy
• Methodologies: Data Modeling Logical/Physical, Star/Snowflake Schema

PROFESSIONAL EXPERIENCE

Confidential

Sr. OBIEE Consultant

Responsibilities:

• Worked with functional and technical project leads, marketing, sales, finance, and other business groups to identify, analyze, and document business requirements.
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Oracle Business Intelligence web GUI Dashboards development.
• Extracted the pre-built BI solutions of tables by using Oracle BI Apps, OBI Admin tool to configure and create repository .rpd and prepared a detail design document.
• Developed many Reports in Oracle BI Analysis and created interactive Dashboards using features like Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with Global and local Filters.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas.
• Added Aggregate measures using Aggregate Persistence Wizard.
• Implemented Multiuser Development Environment MUDE Using Oracle BI Administration Tool.
• Designed and developed BI Apps Metadata for Sales Order Management.
• Migrated Analytics RPD and Webcat from one environment to another.
• Enabled Usage Tracking Table and Dashboards.
• Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.
• Designed and implemented the single sing on SSO functionality.
• Developed automation tool to seed and purge the cache in Admin tool.
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level the Siebel Application level.
• Involved in setting up Ibots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.
• Created Presentation catalogs, and Folders in Presentation Layer and Performed Global Consistency Check in Oracle BI Administration Tool.
• Migrated the Repository from Development to Production using UDML Utilities.
• Designed Interactive Dashboards and created dashboard prompts with multiple selections.
• Involved in Integrating Oracle BI Presentation Services with BI Publisher.
• Set up BI publisher Security to control access given to business users.
• Experienced in working with BI XML Publisher, Data Templates, RTF, and XSL Templates.
• Involved in customizing out of the box reports to support the business requirements.
• Involved in setting Report Repository, Server and scheduler Configuration for BI Publisher.
• Designed and developed Detailed Credit/Unsaleables Analysis Report using BI Publisher which extracts the Markdown reasons and multiple credit requests.
• Involved in configuring sources, targets, tasks and execution plans using DAC.
• Have developed requests/custom reports using Oracle Answers based on Sales, Retail Execution Time and mileage and credit/unsaleables subject areas in order to analyze and understand the Sales Opportunities and Promotion details by Cycle.
• Involved in Query Tuning to maximize the performance of reports and Dashboards.

Environment: Oracle Business Intelligence suite 11g, Informatica 8.1.1, OBI Apps 7.9.6/7.9.5, Oracle10g, Informatica 8.0, DAC, Toad 9.7, Linux, Putty, File-Zilla, Hummingbird 7.0, Neteeza.

Confidential

Sr. OBIEE Consultant

Responsibilities:

• Interact with Business Owners to know Dashboard/Reporting requirements, Design Develop Dashboard/Subject Areas - Pharma Contact Call Effectiveness Call reach, Frequency , Pharma Objective achievement by Product, Patient age, zone, region territory, Ranking/Deciling Physician Rx effectiveness Specialty, Prescriber and TRx / NRx .
• Create Functional FRS , Technical design doc SDS , Perform data mapping between reporting requirements and Siebel OLTP tables/columns Siebel Pharma - Facts/measures, Dimension/attributes.
• Execute Informatica SDE/SIL ETL mappings to populate Siebel Pharma facts/dimensions, create Customize Informatica ETL mappings/workflows to capture Siebel OLTP Extension columns in Siebel Pharma OLAP table groups/subject areas.
• Designed Star schema for fact dimensional tables and created alias for the dimensional tables when necessary.
• Developed Physical Layer, Business Model Mapping and Presentation Layer using Siebel Analytics Administration Tool.
• Specified dimensional hierarchy, aggregate levels for the dimensions.
• Developed different brand level Reports, Filters, and Prompts using Siebel Analytics Web.
• Used Filters Global and Local and provided customized prompts to avoid excessive data showing up in the reports.
• Created various reports to fulfill the marketing needs and customized the views using Siebel Answers.
• Used DAC to schedule and run the Full and Incremental ETL loads and to schedule the Informatica jobs.
• Configured DAC Data warehouse Access control for running of ETL jobs.
• Installed and set up Informatica environment and responsible for administration and migration or repositories between various environments.
• Designed and Configured Intelligent Dashboards in Analytics for different groups of users which include sales executive, sales manger, sales representatives, sales operation.
• Used Analytics Web Catalog to set up groups, access privileges and query privileges.
• Performed the Incremental ETL process to populate the Data Warehouse.
• Configured DAC Data warehouse Access control for running of ETL jobs.
• Used various transformations like Source qualifier, Aggregators, Dynamic Lookup, Router, Sequence generator for mappings based upon the requirement.
• Designed and developed Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for extraction, transformation loading.
• Worked for performance tuning by finding out the bottlenecks in various mappings.
• Handled operating system tasks by generating Pre and Post-Session UNIX Shell Scripts.

Environment: Oracle Business Intelligence suite 10.1.3.2.1 OBIEE , Siebel CRM 7.8,Siebel Pharma Analytics 7.9.5, Oracle 10g, Sybase, Toad 9.0, Windows Adv Server 2003, SQL, PL/SQL, Informatica PowerCenter 8.1.1/ 7.1.4, MS Visio 2007 professional.

Confidential

Sr. OBIEE Consultant

Responsibilities:

• Design and development of repository Creating / Modifying objects in Physical, Business and Presentation layer and the process of repository migration.
• Created Dashboards by embedding reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics.
• 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.
• Developed/Bench-Marked performance tuning strategies with business model-level calculations versus Data warehouse level pre-computations and aggregations.
• 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.
• 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: OBIEE, Informatica PowerCenter 6.2, Oracle 9i, Sun Solaris

Confidential

OBIEE Consultant

Responsibilities:

• Interacted with Case Services Management business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications.
• Identified the GAP's by analyzing the CS Datamart instance and provided alternative solutions as well recommended changes to database.
• Designed and developed the OBIEE Metadata Repository .rpd using Oracle Business Intelligence Admin tool by importing the required objects Dimensions, Facts Aggregates with integrity constraints into Physical Layer using connection pool, developing Dimensions Drill-Down Hierarchies Logical Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Implemented security by creating roles web groups, External tables and LDAP.
• Created Dashboard prompts global filters and combined similar requests in Siebel Answers
• Created Service Request reports based on call and email resolution
• Configured Briefing Books and used Excel Office Plug in to download and refresh reports
• Involved in troubleshooting and debugging of report errors and metadata inconsistencies
• Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment.
• Performance Tuning of Dashboards/Reports and made recommendations for changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the sql execution path by making use of hints etc.,
• Performed Unit, Integration, and Regression testing of various Dashboards / Reports and Repository.

Environment: Oracle Business Intelligence EE 10.x, Oracle10g, HP Unix, Window NT

Confidential

OBIEE / Siebel Analytics Consultant

Responsibilities:

• 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.

Environment: Siebel Analytics 7.8.4, Oracle 9i, SQL Plus, Windows XP

Confidential

Siebel Analytics Consultant

Responsibilities:

• Worked in a multi user development environment.
• Automated all manually generated SQL based reports to run from OBIEE.
• Designed pivot table reports setting aggregation rules sort orders and formulas.
• Created dashboard pages for dynamic drilldown guided navigation embedded contents images.
• Developed roll-based dashboards for production support operations evaluations and executive personal.
• Managed presentation catalog groups and users settings to web group folders.
• Managed privileges and permissions to Answers Dashboards Subject Areas Catalog using Object level and Data level security.
• Modified Cascading style sheets and XML message files.
• Customized Physical Business Presentation layers according to business needs.
• Worked extensively on OBIEE Answers Dashboards Delivers.
• Used External Table Authentication method to provide access to users.
• Created requests in Answers added filter prompts formatted views and charts.
• Created column filter prompts column selector views pivot table views title views tabular views and static views in compound layout.
• Developed many Case Solutions Time Series objects for comparing the various case types' service requests between the quarters.
• Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters using OBIEE Presentation Services.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.

Environment: Siebel Analytics 7.8 Siebel Data Warehouse Administration Console DAC Informatica Power Mart 6.2.1,Tableau, MS SQL Server 2005 Windows XP

Confidential

Informatica Developer/Siebel Developer

Responsibilities:

• Extensively worked on OLAP and OLTP systems existing in different DB systems like Teradata, Oracle DW, and XML files.
• Worked closely with Business Analyst in understanding the requirements and created the business model for generating reports as per the requirements.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager. The objective is to extract data stored in different databases such as Oracle, SQL Server, Flat Files and Excel Files and to load finally into a single Data Warehouse i.e. Oracle.
• Developed many complex Informatica ETL process and Oracle Packages i.e., Mappings Mapplets using various Transformations Update Strategy, Filter, Router, Expression, Stored Procedure, Lookup, and Aggregator and Workflows with Sessions / Tasks.
• Extensively used Informatica PowerCenter Designer, PowerCenter Workflow manager to load data from Flat Files to Oracle 10g.
• Generated Complex queries, Stored Procedures, Functions using SQL, PL-SQL.
• Created the High Level Design Document HLD and Technical detailed design document TDD of Repository.
• Implementing Metadata design document Physical, Business and Presentation layer, variables, initialization blocks, dimension hierarchies, level based measures etc. in implementation phase.
• Designed and developed the Metadata Repository .rpd using BI Server Admin tool by importing the required objects Dimensions, Facts Aggregates with integrity constraints into Physical Layer using connection Pool, developing multiple Dimensions Drill-Down Hierarchies Logical Facts /Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Developed many Reports / Dashboards with different Analytics Views Drill-Down/ Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with Global and local Filters using Answers in OBIEE.
• Developed calculated measures and assigned aggregation levels based on dimension hierarchies.
• Created Security settings in Administration Tool to set up groups, access privileges and query privileges and also managed security for groups in Answers.
• Used Filters and provided customized prompts filtering options appropriately to avoid excessive data showing up reports.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Enhance performance of Reports / Dashboards by implementing the Aggregate tables, Materialized Views, Table partitions, re-building of indexes, Creation / Re-building of Indexes and managing Cache etc.
• Performance Tuning of Dashboards/Reports and made recommendations for changes to database by implementing the materialized views, partitions, re-building of indexes.

Environment: Siebel Analytics 7.7, Informatica 7.1, Oracle 8i, SQL Plus, UNIX, Windows 2000