PROFESSIONAL SUMMARY

• Total 4 plus Years of experience in IT including OBIEE, Informatica DAC and Siebel CRM.
• Experience in PL/SQL concepts
• Experience in complete life cycle of an Enterprise Data warehouse.
• Good knowledge in Dimensional Data Modeling.
• Strong experience in using OBIEE Administrator, Answers, Delivers and Dashboards.
• Extensive Experience in Metadata Modeling at all three layers Physical, Business Model and Presentation using the Oracle BI Administration.
• Extensive Business Intelligence experience using OBIEE 11.X
• Extensive Experience on Delivers iBots / Scheduler.
• Security and creating User's Groups and setting Privileges.
• Worked on debugging and optimizing the Oracle BI/Dashboards/ Reports.
• Good Knowledge on OBIEE 11g.
• Have good knowledge on BI publisher.
• Experienced in writing SQL queries, strong knowledge of databases.
• Quick learner and adaptive to new and challenging technological environments.
• Extensive use of BI Administration, Middleware EM , Console, Web catalog to restrict the
• view and data access
• Informatica experience working on transformations depending on requirements Join, Filter, Lookup, Union etc.
• Hands on experience with Informatica power center, repository manager, workflow clients
• Working with different clients, DB and flat file, xml etc.
• OBIEE troubleshooting and performance tuning using sql query tested against DB
• Using SQL in OBIEE to create reports
• Working with ETL team to work on tables/entities to make sure requirements can be fulfilled.
• Gather the requirements from end users depending on their needs and come up with some prototype models to walk through them with the OBIEE features
• Design the OBIEE as per the requirements and documents the solutions which could be helpful to end users
• End to end life cycle designing of OBIEE.
• Admin skills in setting up the usage tracking , settings for EM related to cache, reading logs, changing different config files and skins and styles
• Assigning policies or changing policies for BI roles, assigning groups to roles
• Setting the Act as feature which is for impersonate the user
• Admin console for creating users, groups etc
• Deploying the Java applications o through console
• Manage servers and clusters in console
• JMS servers and modules set up through console
• Setting up the databases through console
• Setting up the users security using database sql through console

Trained in below tools but no hands on:

INFORMATICA:

• Informatica Power centre architecture
• Power centre components, Power centre Clients, Power centre components, Power centre Clients, Designer
• Workflow manager, Work Flow monitor, Workflow manager, Repository manager, Power center repository
• Administrative tool, Repository services, Integration services, Power center domain, Application services
• Creating Repository Users and Groups, Creating a Group, Connecting to the Repository.
• Creating a Group, Assigning Privileges to a Group, Creating a User, Creating a Folder, Folder Permissions, Creating shortcuts
• Types of Transformations, Connected and Unconnected Transformations, Active and Passive Transformations
• Creating Source Tables, Creating Target Definitions, Creating Target Tables, Creating source definitions
• Creating a Mapping, Connecting Transformations, Transformation Creation

DAC:

• Set Up DAC client, design, execute, tools, administration
• Creating Source System Folders, Tables, Indexes, task, task groups, configuration tags
• Execution plan and scheduler to run workflows and tables
• DAC rpd management, DAC server management, ETL management,
• Working in source system container
• Setting up the preferences for task manually
• Debugging

TECHNICAL SKILLS

• Reporting tool : OBIEE10,11g
• RDBMS : Oracle 10g/11g, SQL Server.
• Languages : SQL
• Operating System : Windows, UNIX
• Microsoft suite : Excel, Outlook, Word and PowerPoint, MS Project and MS Visio
• Siebel : Siebel 7.7x, 8x
• OBIEE : OBIEE 11x
• Informatica: : 9.0x
• DAC : 7.9
• Tableau : 8x

PROFESSIONAL EXPERIENCE

Confidential

Role: OBIEE Consultant

Environment: OBIEE11g, Oracle10g, SQL/TOAD,UNIX

Responsibilities:

• Involved in requirements gathering, analysis, design, development and implementation of project.
• Ad-hoc reporting depends on user requirements.
• Resolving the performance issues by taking the query from Manage sessions and fire it in TOAD
• Working on break fix and other new development depending on the requirements by following the monthly release cycle.
• Developed complex reports that were built on session variables and User role/Group.
• Developed reports using BIP and display it as a PDF on dashboard.
• Also created the Custom excel sheet depending through BIP and used that excel page in OBIEE via some .Net code.
• Understanding the data dependency with other teams and reach out to them to find the data issue. In Finance we have data coming from SAP, Insight etc and all data were stored in Oracle DB and from there we were sourcing it.
• Other Development work like working on RPD and Reports/Dashboards.
• Working with presentation variables, Session variables, Request Variables etc.
• Creating new security roles and updating the security sql's in Console and update the BI roles in EM.
• Working on Usage tracking to track user's activity and some issue related to server slow performance. To pull the monthly usage tracking for particular report/Dashboard/SA or even the Application.
• Worked on Migration of 10g-11g for HR applications. Involved in Testing, Migration, and entire release process after upgrading to 11g.
• Extensively worked on Security, Permissions for catalogs and data.
• Worked on custom date formats, custom sql queries
• Getting log files from BI server and work on the issues related to Server
• Worked on custom view/Opaque views in the rpd

PROFESSIONAL EXPERIENCE

Confidential

Role: OBIEE Consultant

Environment: OBIEE11g, Oracle10g, SQL developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development and implementation of project.
• Ad-hoc reporting depends on user requirements.
• Resolving the performance issues.
• Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Defined static and dynamic repository variables to modify metadata content dynamically to adjust to a changing data environment.
• Worked on creating Reports and Dashboard and Creating Dashboard prompts and filters.
• Created iBots in Delivers and scheduled reports to Email daily to the selected User List.
• Worked closely with Users, Developers and Administrators to resolve ongoing production Problems by reviewing design changes made to production systems and made corresponding changes to Obiee Analytics Repository.
• Customized the home page with the company info using customlink.xml file and working with user preferences.
• Developed Metadata repository .rpd , configured metadata the Business Model Layer Physical Data Model and Web Catalog Objects as per the reporting requirements using OBIEE Admin and Web tool.
• Working with ETL team to work on Entities and relationships between them to make requirements feasible.

Confidential

Role: OBIEE Consultant

Environment: OBIEE11g, Oracle10g, Toad, Win XP

Responsibilities:

• Involved in requirements gathering, analysis, design, development and implementation of project.
• Involved in configuration of the BIApps.
• Involved in customization of BIApps.
• Ad-hoc reporting depends on user requirements.
• Resolving the performance issues.
• Has implemented security both at repository level and at catalog level.
• Created connection pools, schemas in Physical layer of the repository.
• Created business model with logical tables in the logical display folders.
• Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Defined static and dynamic repository variables to modify metadata content dynamically to adjust to a changing data environment.
• Designed various reports like Table view, Pivot, Narrative view, Ticker, and View Selector Reports, drilldowns, Bar charts, pie charts, Legends and Guided Navigation by using Answers and Dashboards.
• Worked on creating Reports and Dashboard and Creating Dashboard prompts and filters.
• Created iBots in Delivers and scheduled reports to Email daily to the selected User List.
• Creation of ETL Routines and Dealing with mapping using Warehouse and Mapping Designer, workflow manager and scheduling it through DAC.
• Debugging the OBIEE generated query and verify the same with backend.
• Preparation of technical design documents, unit testing at the ETL, RPD and report level as per the requirement.
• Created the High Level Design Document HLD and Technical detailed design document TDD of Repository and Webcat reports/dashboards .
• Worked closely with Users, Developers and Administrators to resolve ongoing production Problems by reviewing design changes made to production systems and made corresponding changes to Obiee Analytics Repository.

Confidential

Role: OBIEE Consultant

Environment: OBIEE10g,11g Oracle10g, SQL, Win XP, UNIX

Responsibilities:

• Understanding the requirements of the client, business scenario s and the application.
• Involved in configuration and customization of BIApps.
• Involved in resolving performance and data mismatch issues.
• Improved of the reports by creating aggregated tables at database level and by setting aggregation context at repository level.
• Has enabled cache to improve performance of the reports
• Has built OBI reports showing comparison between current measures and historical measures
• Requirement analysis, Designed and implemented custom business intelligence solutions Metadata and Dashboards/Reports using the Oracle Business Intelligence OBI Analytics platform.
• 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.
• Designed various reports like Table view, Pivot and View Selector Reports, drilldowns, Bar charts, pie charts and Guided Navigation by using Answers and Dashboards
• Created iBots in Delivers and scheduled reports to Email daily to the selected User List.
• Creation of ETL Routines and Dealing with mapping using Warehouse and Mapping Designer, workflow manager and scheduling it through DAC.
• Enhance performance of Reports, Dashboards by implementing the Aggregate tables, Materialized Views, Table partitions, re-building of indexes and managing Cache etc

Confidential

Role: OBIEE Developer

Environment: OBIEE10g, Oracle10g, Toad, SQL, Win XP

Responsibilities:

• Understanding the requirements of the client, business scenario s and the application.
• Created connection pools, schemas in Physical layer of the repository.
• Created business model with logical tables in the logical display folders.
• Created Dimension Hierarchies in Business Model layer for Drill down functionality.
• Defined static and dynamic repository variables to modify metadata content dynamically to adjust to a changing data environment.
• Implemented Prompts to facilitate dynamic filter condition to End-users.
• Designed various reports like Table view, Pivot, Narrative view, Ticker, and View Selector Reports, drilldowns, Bar charts, pie charts, Legends and Guided Navigation by using Answers and Dashboards.
• Created iBots Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.
• Generated various Analytics Reports like Formulary Report and Direct Sales Report using global and local filters
• Developed Metadata repository .rpd , configured metadata the Business Model Layer Physical Data Model and Web Catalog Objects as per the reporting requirements using OBIEE Admin and Web tool.
• Developed different kinds of Reports pivots, charts, tabular using global and local Filters.
• Managed day-to-day rpd, Scheduler iBots.
• Use of console and Middleware, BI administration, web catalog to control data access and provide security.

Technical Skills:

Applications: ePharma, eSales, eMarketing, ePharma, CRM with marketing and Sales

CRM Tools: Siebel eCRM 7.x,8.0 8.1.1

Operating Systems: Windows 95/98/2000/2007, UNIX

Languages: C, Java

Programming Languages: eScript, JAVA, XML

Databases Tools: MS-SQL, Oracle, Tools, Toad