OBIEE Developer with ETL, 6+ exp

Ashwini Prasad E-mail : ***************@*****.***

Cell : 408-***-****

Experience Summary

• Around 6 years of expertise in all aspects of Business Analytics Applications including analysis, design, development, configuration, Customization, validation and deployment.

• Created, modified, and administered analytics Intelligence Dashboards with links to web sites; HTML text; links to documents; and embedded content, such as images, text, charts, and tables

• Designed and developed the Siebel Analytics Metadata Repository (.rpd) using Siebel Analytics Server Admin tool by importing the required objects (Dimensions, Facts & Aggregates) with Referential Integrity constraints into Physical Layer using connection pool, developing multiple dimensions (Drill-down Hierarchies) & Logical & Facts Measure objects in Business Model Layer, and creating Presentation Catalog in Presentation Layer.

• Experience in Configuring Interactive Dashboards with Drill-Down capabilities using Filters and Dashboard prompts, Siebel Security Setup (groups, access privileges), Metadata objects and Web Catalog objects (Dashboard, Pages, Folders, Reports).

• Developed many Reports / Dashboards with different Analytics Views (Drill-down / Dynamics, Cascading style sheets, Pivot table, Chart, Column Sector, Tabular with local and global filters) using Siebel Analytics Web.

• Utilized Siebel Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to intelligence dashboards for subscribed users.

• Implemented Security by creating roles & web groups, checks with External tables & LDAP

• Hands on experience in ETL process using Informatica PowerCenter for various transactions and loading data from various legacy data sources.

• Expertise in debugging and optimizing Siebel Analytics Dashboards / Reports.

• Good understanding of Software Development Life Cycle (SDLC).

• Ability and aptitude in scheduling, tracking and prioritizing activities

• Excellent analytical, interpersonal, problem-solving, trouble-shooting skills

• Ability to set and achieve goals, work well independently or in team, skills in identifying problems and meeting goals

Technical Skill

Area Skills

Oracle - Siebel Enterprise Oracle Business Intelligence 10.x, Siebel Analytics 7.5\7.7\7.8.

Databases Oracle 8I/9I/10G, SQL Server 2000

ETL Informatica 8.x/7.x/6.x

Operation System Windows 2000/03/ NT/XP, Linux

CRM Application Siebel 7.x

Languages C, C++, Core Java, J2EE, SQL, PL/SQL

Project Experience

AXA Equitable Aug 2008 – May 2009

OBIEE Consultant

AXA Equitable Life Insurance Company is a leading financial protection company and a premier provider of life insurance, annuity, and investment products and services. The project involved creating business intelligence solutions for the various work streams (compensation, compliance, finance) by comparing and contrasting data from various sources and then consolidating them at the report/dashboard level.

Responsibilities:

• Involved in analysis and requirements gathering of the various work streams by meeting with the business user and base lining the details.

• Designed and implemented custom business intelligence solutions (Metadata and Dashboards/Reports) using the Siebel/Oracle BI Analytics platform.

• Involved in the detailed design of the reports/dashboards and data model.

• Participated in the installation and configuration of Oracle BI EE 10.1.3.4.1 in the windows as well as the Linux environment.

• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer. Also created hierarchies, variables, and event poll strategies in the repository.

• Enhance performance by creating Aggregate tables, Indexes and managing Cache.

• Modified some of the existing reports and dashboards, and fixing some of the issues related to performance, data quality etc., during production support.

Autodesk Dec 2007 - June 2008

Siebel Analytics Consultant

Autodesk is the world leader in 3D and 2D Design and Engineering Software. The main objective of the project is to model customer profile, sales and trend analysis.

Responsibilities:

• Used Siebel Analytics for generating Sales reports, which provides web-based reports for executives, managements and individuals.

• Developed business models conforming to functional mapping, defined logical and complex joins for the dimension tables

• Extensively used Siebel Analytics Administration Tool for customizing and modifying the Physical, Business and Presentation layers of metadata repository.

• Created connection pools to retrieve data from Oracle Database.

• Specified aggregate levels for each source and created dimension sources for each level of aggregates.

• Created custom mappings to accommodate customized fields. Utilized Intelligent Dashboards, Siebel Answers for reporting requirements.

• Worked Extensively on Siebel Answers to create reports as per the client requirements.

• Used Filters and provided Customized prompts appropriately to avoid excessive data showing up Reports.

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

• Created iBots and Delivers to send Alert messages to subscribed users.

• Created Analytics Reports including Charts, Pivot tables and Compound layouts using Siebel Answers.

• Implemented ETL process to load data into target Oracle tables.

• Responsible to tune ETL procedures and STAR schemas to optimize load and query performance

Abbott Laboratories Aug 2006 – Nov 2007

Siebel Analytics Consultant

Abbott Laboratories is a diversified pharmaceuticals and health care company. The purpose of this project is to model customer profile, sales and trend analysis of marketing campaign seeking a customer centric solution In order to maximize performance and effectiveness and identify opportunity for continuous improvement using reporting tool Siebel Analytics.

Responsibilities:

• Used the Siebel Analytics Administration tool to develop and enhance meta-data.

• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.

• Worked extensively with Physical Layer, Business Layer and Presentation Layer.

• Designed Schema using Fact, Dimensions, Physical, Logical, Alias and Extension tables.

• Enhanced existing Business Models & created customized Dashboards for revenue ratio reports for North America and Asia Pacific regions.

• Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements.

• Built Business model and established relationships & Foreign Keys (Physical & Logical) between tables.

• Developed custom reports using Seibel Answers and assigned them to application specific dashboards.

• Developed different kinds of Reports (pivots, charts, tables/compound layout) using global and local Filters.

• Implemented both Object and Data level security as part of the project.

• Worked on Informatica Mappings for enhancement to Facts/Dimensions in developing the Initial and Incremental ETL process.

Alpharma Nov 2005 - July 2006

Siebel Analytics Consultant

Sales Comparison Analytical System was implemented to keep track the variations in sales of pharmaceutical products for humans and animals.

Responsibilities:

• Interacted with the business users to gather reporting requirements focusing on Sales groups mainly focusing on Service Requests and Sales Analytics.

• Designed and Built Sales Comparison Siebel Analytics Repository at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer level (create presentation catalogs), create presentation folders, test and validate the model.

• Developed reports in Siebel Answers.

• Developed different kinds of Reports, pivots, Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.

• Developed the Dimensions and Time Series Objects in the BMM Layer with Security settings in Siebel Analytics Admin Tool to setup groups, access and query privileges.

UTSTAR Sept 2004 – Oct 2005

Siebel Analytics Developer

UTStarcom is a global leader in the manufacture, integration and support of IP-based, end-to-end networking and telecommunications solutions. The company sells converged broadband wireless and wireline products, an integrated IPTV solution, and a comprehensive line of handset and customer premise equipment to operators in both emerging and established telecommunications markets worldwide. The main Objective was to perform Sales Analytics on the company’s sales data to further improve the growth of the company’s Sales

Responsibilities:

• Customized Physical Layer, Business Model and Mapping Layer and Presentation Layer using Siebel Analytics Administration Tool.

• Created Dimensions, Aggregations and Keys using admin tool.

• Created presentation layer tables by dragging appropriate BMM layer logical columns.

• Developed Global prompts, Filters, Customized Reports and Dashboards using Siebel Analytics Web.

• Created Users and Groups and managing the object level and data level security.

• Managing the intelligent dashboards by using dashboard, page and report level security.

Electronic Data Systems July 2003 - Aug 2004

Siebel Analytics Developer

Electronic Data Systems (NYSE:EDS) is a global business and technology services company headquartered in Plano, Texas. General Motors acquired the company in 1984, spun it off again as an independent company in 1996, and became an EDS client. A pilot project with a focus on leveraging the best of the Siebel Analytics tool and create an internal knowledge base that could be leveraged for similar projects.

Responsibilities:

• Responsible to gather and document reporting requirements.

• Understanding the design considerations for star schemas and its relationships.

• Created Initialization Blocks, Repository and Session Variables.

• Worked extensively on Metadata Modeling at all three layers (Physical, Business Model and Presentation) using the Analytics Administration Tool.

• Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in Analytics business model & mapping layer.

• Designed/Developed reports in Siebel Answers/Dashboards and trained the Business/ Power Users to create reports in Analytics

Contact this candidate