Professional Summary:

• 9 years of experience in Information Technology which includes experience in Business Requirement Gatherings, Analysis, Design, Data Modeling, Development, Testing and Implementation of Data warehouse/Business Intelligence using OBIEE 11.1.1.x/10.1.3.x, Siebel Analytics 8.x/7.x, Informatica 8.x/7.x, Oracle 8i/9i/10g.
• Over 6 years ofBusiness Intelligenceexperience usingOBIEE 11.1.1.3.0/5.0/6.0/7.0, 10.1.3.2/3.3/3.4 and Siebel Analytics 7.5/7.7/7.8.
• Experience in analyzing, designing and modeling data warehouses and star schema data marts for various business verticals like Retail sales, Health Care Pharmacy , Financial and Insurance, Good at Database Design, conceptual, logical and physical Data Modeling, Star Schema, Snowflake FACT and Dimensions tables, slowly changing dimensions SCDs .
• Experience in installation and configuration of OBIEE 11.1.1.7.1/7.3. Upgrading from OBIEE 11.1.1.6.5 to 11.1.1.7.3
• Experience in interacting with Business Users, Business Analysts, IT Leads and Developers in analyzing business requirements and translating requirements into functional and technical design specifications.
• Strong Experience in Design, Development, Analysis, Implementation, Administration, Maintenance and Support of Siebel Analytics/OBIEE 10g and OBIEE 11g
• Very strong experience in developing OBIEE / Siebel Analytics Repository .rpd at three layers Physical Layer, Business Model and Mapping Layer Presentation Layer , Answers, Interactive Dashboards with drill-down capabilities, BI Publisher, Delivers, Security Setup groups, access/query/report privileges , configuring Analytics, Metadata Objects Subject Area, Table, Column , Web Catalog Objects Dashboard, Pages, Folders, Reports and scheduling IBots
• Experience in creating RTF Templates to support Structured BI Publisher reports. Created Customized charts using XSLT code in MS Word
• Hands on experience in the configuration of OBIEE and Siebel Analytics Delivers, IBots, Jobs Manager, Cache Manager, Variable Manager and Security Manager Object level security and Data level security
• Experience in configuration of SMTP server and setting the System delivery profile to enable Ibots to deliver reports/Dashboards to email of Users automatically. Created Nested Ibots
• Hands on experience in developing OBIEE repository development, configuring metadata objects Subject Area, Table, and Column and web catalog objects Dashboards, Pages, Folders, Reports .
• Experience in creating dimensional hierarchies, time hierarchies, level-based measures and adding multiple sources to business model objects.
• Experience in implementing Functionalities such as Act As Proxy , Custom links, Type ahead, Write back. Converted OBI Services to work as windows services in order to keep up with the server maintenance cycle and also to eliminate the risk of OBI Shutdown when the services are manually started and stopped from a specific log in.
• Experience in modeling aggregate tables using Aggregate persistence wizard to speed processing and building calculated measures for the fact tables and Cache seeding/Purging using NQCMD command line tool to improve performance
• Experience in managing users and setting up their privileges and profiles using LDAP External Table Authenticationusing Database authentication Providersinweblogic. Customized the database adapters in XML that map Weblogic LDAP credentials to database groups
• Experience in implementing Single sign on SSO
• Expertise in creating Filters, Prompts in Dashboards, PresentationVariables, and NarrativeViews to filter the data.
• Experience in implementing security in OBI using Repository Variables, Initialization Blocks, Session Variables and Single Sign-On through LDAP.
• Experience in setting up a Multi-User Development Environment MUD
• Experience in using the Time-Series functions to support historical time comparison analysis and creating requests, adding filters, creating prompts and creating pivot tables using OBI.
• Proficiency in SQL, PL/SQL programming like creating Triggers, Procedures, Stored Procedures, Cursors.
• Good Communication and Interpersonal skills. Technically sound, Result-Oriented with strong Problem solving skills. Innovative efficient. Capable of working as a Team Member or Individually with minimum supervision.Expertise in working extensively with senior level managers, developers and end users across multiple disciplines.

Technical skills

Professional Experience

Confidential

Lead OBIEE Developer

Responsibilities:

• Installation and configuration of OBIEE 11.1.1.7.1 / 7.3. Upgraded all the environments from 11.1.1.6.5 to 11.1.1.7.3.
• Created various dashboards using with multiple views and reporting techniques. Created union reports, BI Publisher reports.
• Implemented several Java/HTML based UI customizations as per requirement.
• Worked on guided navigation using Action Links, Go-URL's and Javascript / HTML based navigations. Created Encoded GO-URL's for hassle free navigations and proper application of filters.
• Migrated repository and catalog objects across all the environments.
• Created Level based and Parent Child hierarchies, calculated columns in the repository.
• Worked with different variables such as repository Dynamic Static , Session System Non System , Presentation and request variables.
• Implemented usage tracking in OBI to get Usage statistics of all the dashboards at various levels, to get a better understanding of user preferences.
• Worked on Performance tuning. Designed Cache purging seeding mechanism. Created efficient and smart queries to seed the cache using NQCMD command line tool. Created Nested ibots to schedule Purging and Seeding of the cache in a timely manner.
• Created Aggregate tables using NQCMD tool for better performance. Aggregate persistence wizard was used to generate the optimized query for creating the aggregate tables
• Implemented Write back functionality in OBI to support use of comments from users. Created different write back templates to facilitate write back in various scenarios
• Implemented Various UI functionalities in OBI such as ACT-AS, Type Ahead, Write back, custom links.
• Implemented OBI Services to work as windows services in order to keep up with the weekly server maintenance cycle
• Configured SMTP server and set up System delivery profile for appropriate functioning of ibots. Created multiple ibots to seed the cache and to schedule delivery of reports according to various requirements.
• Was responsible for designing the framework for the database security model and implement single sign on SSO . Created and maintained the tables/views needed for for database authentication.
• Created Oracle SQL server data sources in weblogic, customized the database adapters and configured the credential store in the fusion middleware enterprise manager to implement SSO and for other system administration activities.
• Created and maintained the database tables / Views related to security, Write back, System Delivery Profile Act As Proxy User .
• Worked Extensively on BI Publisher reports. Created different RTF templates to facilitate structured reporting. Also, created Customized charts for BI Publisher reports using XSLT code in MS Word.
• Worked with Apptio to generate an alternate Bill of IT on par withOBIEE Also, worked with Informatica team on building data feeds for Apptio.
• Responsible for all the Admin Production support activities related to OBIEE.

Environment: OBIEE 11.1.1.7.1/7.3/6.5, BI Publisher 6.5, Apptio Bill of IT / Studio, Oracle 11g/10g, SQL Server, DB2, AquaStudio, Informatica,SRS, Sharepointe, Windows server/7

Confidential

Lead OBIEE Consultant

Responsibilities:

• Implementing and installing OBIEE 11g in dev, test and production environments.
• Upgrading the Oracle BI repository and catalog from OBIEE 10g to 11g.
• Importing SSAS cubes in to OBIEE using Analysis services and MSMD pump
• Configuring IIS server for better performance.
• Imported the cube in to Physical Layer and created BMMLayer, Presentation Layer using Admin Tool as per the requirements.
• Created various session variables and initialization blocks based on the requirement
• Developed different kinds of Reports pivots, charts, tabular using global and local Filters.
• Created Interactive Dashboardswith different views like Table view, Pivot Table,Charts etc
• Implementeddrill downand guided navigationto navigate to multiple sub requests based on the requirements.
• Created Direct Database Requests using MDX queriesfor some of the requirements
• Designed the security model for the product and Implemented Object and data level security for different user groups. Managed security privileges for each subject area and dashboards according to user requirements.
• Migration of presentation catalog across different environments like Dev, QA and Production
• Designed the login page by modifying the login page style sheet login.css according to the requirement
• Implemented cube and OBIEE cache management to enhance performance.
• Implemented OBIEE security using external table authentication.
• Involved in gathering business requirements from the business users.
• Conducted User training Programs to educate business users about the tool.

Environment: OBIEE 11.1.1.6.0/10.1.3.4, Oracle 11g/10g, SQL Developer, Microsoft Analysis services MSSAS , SSAS cubes, IIS, Windows server

Confidential

Sr OBIEE Consultant

Responsibilities:

• Implemented and installed OBIEE 11g
• Involved in Business Requirement gathering with multiple business users.
• Involved in sessions with Data Modeler for the designing the Data Model.
• Created Physical Layer, Business Model and Mapping Layer and Presentation Layer using Admin Tool based on the requirements.
• Most of the columns which require calculations are determined first and are calculated in ETL using Informatica.
• Involved in configuring and scheduling ETL tasks using Data warehousing Console DAC .
• Defined Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
• Modeled the Logical Layer based on the Business requirements in the Business Mapping and Modeling Layer and Developed the necessary Star Schemas, and Dimensional Hierarchies.
• BMM layer is developed using functionalities like Aggregates, Hierarchies, Calculation Wizard and Time Series.
• Various Initialization Blocks and Variables are created based on the necessity.
• Created Interactive Dashboards by building the report request using Answers in different views like Table format, Pivot Table,Charts etc .Implemented Guided Navigation and drill down to navigate to multiple sub requests based on the requirements.
• Created different kind of YTD and Quarterly reports
• Created Direct Database Requests for some of the requirements.
• Provided Object level and Data level security for different user groups based on their requests With the Security settings in Administration Tool to set up groups, access privileges and query privileges.
• Used Analytics Scheduler to configure Delivers andiBots to notify the corporate managers and region managers immediately about the messages. Generated iBot alerts for reports to be delivered by email.
• Migration of presentation catalog changes across various environments like Dev, Test and Prod are done through catalog manager.

Environment:OBIEE 11.1.1.3.0/10.1.3.4, Oracle 10g, SQL Developer, Toad, Windows XP, Informatica 8.6.0, DAC, HTML.

Confidential

Sr OBIEE Developer

Responsibilities:

• Used Metadata Design Principles to design Repository based on business requirements and followed best practices.
• Localized Oracle BI for business users to support globalization for deployment Development/QA/Production
• Set up Analytics Multi-User Development environment for developers.
• Set up LDAP Authentication, used Row-Wise Initialization Blocks, and set up Web Groups.
• Installed and Deployed Oracle BI on separate Multi Servers.
• Built the Physical Layer/Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas.
• Configured Facts, Dimensions and Hierarchies.
• Implemented Aggregate Tables for better analytics performance.
• Implemented reporting cache to faster response time.
• Assisted in creating Reusable and Non-Reusable Mappings and Mapplets using Filters,
• Aggregator, Lookups, Expression Aggregator, Sequence Generator, Sorter, Joiner and
• Update Strategy Transformation.
• Involved in developing tasks, created sessions and worklets in Workflow Designer, ran and monitored sessions using Informatica Server Manager
• Performance and fine tuning of PL/SQL stored procedures.

Environment: OBIEE 10.1.3.2, Informatica 7.1.4, Oracle 9i, TOAD, UNIX, Windows XP.

Confidential

OBIEE Consultant.

Responsibilities:

• Used the OBIEE 10.1.3.3.x 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.
• Created views and Aliases in physical layers for performance tuning.
• Integrated Java Scripts to store daily reports in automated generated folders by date and month.
• Configuring mappings with BPM systems to data base.
• Understanding the Business from pre built Oracle BPM Systems for report development.
• Configuring IBOTS and Delivers.
• Implemented SA System Subject to give access of Dashboards to NON OBI users.
• Identifying and Retrieving Business Data sources from Oracle EBS Financials Apps.
• Configured and Created repository using OBIEE 10.1.3/ Siebel Analytic Admin tool.
• Worked extensively with Physical Layer, BMM Layer and Presentation Layer.
• Created numerous executive level reports. 'Dashboards' were generated to provide insight into the sales/ /financial data.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.
• Built Business model and established relationships Foreign Keys Physical Logical between tables.
• Created highly formatted pre- built reports with BI- Publisher.
• Created business reports using Siebel Answers as per requirements.
• Involved in modifications of physical, business and presentation layers of metadata repository using Siebel Analytics Administration Tool.
• Developed custom reports/Ad-hoc queries using Seibel Answers and assigned them to application specific dashboards.
• Developed different kinds of Reports pivots, charts, tabular using global and local Filters.
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes.
• Managed security privileges for each subject area and dashboards according to user requirements.

Environment: OBIEE 10.1.3.3, BI Publisher, Oracle 10g, Toad, Windows XP, Siebel CRM, HTML

Confidential

Siebel Analytics Developer

Responsibilities:

• Worked closely with Business Analyst, during the JAD sessions and gathered the Analytics requirements.
• Installed Analytics Application in Dev, Test and UAT Environments.
• Imported the Physical Meta Data from Various Data marts into the Physical Layer by defining the connection pool settings.
• Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
• Modeled the Logical Layer based on the Business requirements in the Business Mapping and Modeling Layer and Developed the necessary Star Schemas.
• Worked on Aggregates, Hierarchies, Calculation wizardin the Logical Layer.
• Worked on the Time Series Wizard and implemented time comparison measures.
• Used Column Filter Promptsand provided Dashboard Prompts appropriately to avoid excessive data showing up Reports.
• Managed security privileges for each subject areas anddashboards according to user requirements.
• Have worked on different financial modules like AP, PO, GL, FA, iExpense and AR.
• 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 Siebel Answers to create the reports as per the client requirements.
• Defined additional views narrative, pivot, chart views of the data returned by the request to visualize data in different ways.
• Configured Intelligence dashboards by adding included and embedded content such as links/images, HTML objects and folders.
• Maintained effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns.
• Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers.
• Created intelligent bots iBots to send Alert messages to subscribed users.

Environment: Siebel Analytics 7.8.2, Siebel Call Center, Siebel Tools, Informatica 6.2, Peoplesoft, Oracle 9i, Windows 2k.

Confidential

Oracle/PL/SQL Developer

Responsibilities:

• Worked on a trading project for a client to develop an application to trade coal, gas and power.
• Gathered user requirements and created the business requirements documents.
• Documented the technical specification for the reports and tested the generated reports.
• Created and managed Database.
• Used the technical document to design tables.
• Generated SQL and PL/SQL scripts to install create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Created Database triggers to maintain the database security.
• Created stored procedures and functions to be called by the application.
• Created Packages to be called by Visual Basic modules
• Created trading reports using Crystal Reports.
• Optimized the SQL queries for improved performance.
• Used SQL loader to import data from large flat files and Excel sheets to Oracle tables.
• Prepared test plans for various modules.
• Prepared user manual and technical support manuals.
• Entered static data into the application.

Environment: Oracle 8i, SQL Loader, PL/SQL, Crystal Reports 7, Windows NT.