Professional Summary

• 9 years of experience in Oracle BI/Siebel Analytics Dashboards, Answers, Delivers, iBots, BI Publisher, Oracle BIApps 7.9.5 ETL-Informatica 9.x/8.x/7.x, Reporting-OBIEE platform, Scheduling- DAC , interacting with multiple data sources like Oracle 9i, 10g,11g SQL Server and various other miscellaneous sources.
• Participating in problem solving and troubleshooting for the applications implemented with ODI.
• Proficient in creating Interactive Dashboards with drill-down and drill-across capabilities, Web Catalog Objects Dashboard, Pages, Folders, Reports , Scheduler, Catalog Manager.
• Extensive experience in designing Star Snowflake Schema, Slowly Changing Dimensions, Facts, Dimensions tables.
• Installed and configured different versions of OBIEE, Informatica, DAC on standalone and dev., staging, production servers.
• Strong experience in creating Logical tables and columns, Dimensional Hierarchies with drill down, Level Based Measures, Time series wizard, and Repository Variables.
• 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 Presentation services.
• Implemented Security by creating roles web groups, checks with External tables LDAP
• Expertise in configuring various analytics for Finance, Automotive and Insurance industries.
• Experience in extracting data from Siebel, Oracle EBS, OLTP, flat files and integration and loading data to OLAP systems.
• Strong expertise in Implementing MUD Multi User Development Environment.
• Experience in Informatica concepts like Source Analyzer, Target Designer, Work Flow Designer and Task Developer.
• Expertise in developing Informatica Mappings/Mapplets using various Transformations Filter, Expressions, Router, Aggregative, Lookups, Update Strategy .
• Experience in Informatica DAC Tool for Customizing Data warehouses and Creating Task and Task Groups in it.
• Extensive experience with various databases Oracle 11g/10g/9i/8i, SQL Server 2000/2005/2008.

Technical Skills

Professional Experience

CONFIDENTIAL

Role: Sr. OBIEE BI Apps Consultant/developer

• CONFIDENTIAL data services team provides personalized, focused insights at various levels of decision-making by applying leading-edge thinking and best business intelligence practice every step of the way.
• Various projects I was involved in here were -
• Project 1 : Oracle Applications R12 To Support the Business Intelligence and Data warehousing
• Project 2: Workforce Analytics Business Objects to OBIEE Conversion
• Project 3: KTC Know the Customer Informatica
• Project 5: Infonet - SQL Server to Oracle Migration
• Project 6: Order Management Analytics - OBI Applications 7x

Responsibilities:

• Performed requirements gathering by interacting with business users at all levels focusing on Sales and Procurement groups and Margin Improvement projects.
• Designed and developed custom OLAP data model for overall project based on Sales and Purchasing data from GAPS and WPS systems.
• Developed Business Model as per the required metrics by creating multiple sources for logical table source, Created calculation, Derived, Time-series, Rank and Share Measures and passed and dimension based aggregation rules.
• Implemented HR Analytics and Financial Analytics and I am involved in Account Payables, Workforce and US Statutory Compliance Analytics
• Worked with key project stakeholders and business people to formulate and communicate the business vision for the project and mapping out the initial requirements and the scope of Workforce module in HR Analytics and Accounts Payable Financial Analytics
• Analyzed and documented the gaps on pre-build Star schema, ETL, metadata repository and front end UI-reports and dashboards Workforce profile designed for analysis and reporting on workforce HR data
• Analyzed and Documented the new custom confidential reports and also involved and helped the development team in customizing the tables in OBAW and OBIEE Metadata repository as per the reporting needs
• Using Answers, created Analytic reports including Charts, Pivot tables, and Compound layouts and assigned to specific dashboards.
• Created user manual, conduct end user trainings, and application improvement enhancement.

Environment: OBIEE 11.1.1.5, 10.1.3.4, BI Applications 7.9.6.3 ,BI Publisher, Informatica 9.1, Oracle 11g, SQL, TOAD, Windows 2008 Server, Linux.

CONFIDENTIAL

Role: Sr. OBIEE Consultant

CONFIDENTIAL its financial performance to stay competitive, maintaining liquidity. With the help of the financial data analysis and BI solutions it manages to achieve its strategic financial goals.

Responsibilities:

• Customized the existing BIApps Metadata Repository .rpd using OBIEE Admin tool by adding new measures into BMM layer.
• Upgraded the Repository from existing OBIEE 10g to OBIEE 11g.
• Designed and developed Web catalog objects - Reports/Dashboards
• Configured Web Catalog Objects Dashboard Pages, Folder and Reports .
• Worked extensively on various Cache Management techniques to increase the performance of the both Real-Time and Non Real-Time reports.
• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes.
• Implemented security by creating users and roles in LDAP.
• Managed Security privileges for each Subject area and Dashboards according to business requirements. Implemented data level security based on Project, and Chartfield security.
• Implemented various Repository and Session variables depending up on user requirements.
• Configured Usage Tracking which allowed the Business to analyze the frequently run reports and long running reports to identify performance issues.
• Configured Agents to deliver Reports content based on schedule to obtain weekly reports through email and sent notification Alerts.
• Extensively worked on the Informatica Power Center 9.1 tools Designer, Workflow Manager, Workflow monitor.
• Expertise in Oracle Data Integration Suite Oracle Data Integrator ODI and OWB Oracle Warehouse Builder to Extract Load and Transform E-LT for high performance and faster responsiveness Created custom complex Informatica Mappings which used to bring the data from MTA tables to staging tables and then to Facts and Dimensions.
• Implemented slowly changing Dimensions in the ETL mappings SCD, Both Type 1 2 .
• Used Oracle Data Integrator ODI to improve inter-application dialog by having interfaces executed asynchronously
• Used Deployment group for migrating the mappings and sessions from Development to QA and from there to Production.
• Involved with Creating Tasks in the DAC for both OOB Out of Box and custom Informatica Workflows also configured new Bitmap Indexes and Btree Indexes
• Used DAC to configure domain values for Oracle financials like Budget, General Ledger, Journals, and MTA.
• Extensively worked in data Extraction, Transformation and loading from source to target system using Bteq, FastLoad, MultiLoad.
• Did error handling and performance tuning in Teradata queries and utilities
• Involved in importing and exporting DAC metadata in the process of migration from one environment to another.

Environment: OBIEE 11.1.1.5.0, OBIEE 10.1.3.3, Informatica 9.1, Teradata v2R5, 12 Oracle BIApps Financial Analytics 7.9.6, DAC 10.1.3.4, PeopleSoft 9.x, Oracle 11g , SQL developer, Windows 7, Linux.

CONFIDENTIAL

Position: OBIEE Consultant

CONFIDENTIAL provides software, software as a service, and professional technical services worldwide. It operates in six segments: Application Performance Management APM , Mainframe, Changepoint, Uniface, Professional Services, and Covisint Application Services.

Responsibilities:

• Participated in gathering and analyzing the Business Requirements in collaboration with the Sales, Marketing and Finance Subject Matter Experts SMEs , Business Analysts and Users.
• Extensively used OBIEE Administration Tool for customizing and modifying the Physical layer, BMM and Presentation layers of the repository .rpd .
• Responsible in designing and introducing new FACT or Dimension Tables to the existing model and decide the granularity of fact tables.
• Created dimension hierarchies level based measures in BMM layer based on requirements.
• Developed Month Ago, Year Ago measures for comparison of sales and used Time Series Functions extensively.
• Developed several dashboards and reports, which are used by managers to identify most profitable customers and analyze revenue trends by customer to identify opportunity/risk.
• Used Filters global and local and provided customized Prompts to avoid excessive data showing up in the reports.
• Configured Intelligence dashboards by including embedded content such as links/images HTML objects.
• Used BI Publisher to create reports from an Answers Request, and from BI Server data.
• Created Aggregated Tables and configured the content in Business Model Layer to use the Aggregate tables for better performance.
• Implemented security by creating users groups, setting up LDAP Authentication, creating Session Variables and Initialization Blocks and associated catalog objects and Web modules with the created groups.
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes. Managed day-to-day rpd, Scheduler iBots.
• Utilized Oracle Delivers for sending real-time personalized alerts via intelligence agents iBots to subscribed users.
• Worked extensively on Oracle BI Publisher and provided the capability to download the reports in the user defined formats.
• Involved in preparing/executing Test scripts for User Acceptance Testing, establishing Test Data, and recording defects.
• Coordinated the OBIEE and Web Catalog objects migration from Development environment to QA environment and then to the Production environment.
• Conducted user training to familiarize them to the new reporting environment
• Provided extensive UAT support, trained and inducted the business users to the tool

Environment: Oracle Business Intelligence Enterprise Edition OBIEE 10.1.3.4.1, Informatica Power Center 8.1, Data Warehouse Administration Console DAC , Oracle BI Publisher, Oracle Delivers, Windows XP, UNIX/LINUX, Oracle 11g/10g, SQL, PL/SQL, and TOAD 6.3/7.0.

CONFIDENTIAL

Position: OBIEE/ETL Consultant

This project involved developing data warehouse reports for CONFIDENTIAL. The system monitors the claims and policy transactions including coverage like theft, collision damage and personal liability. The most and least profitable coverage, profit over time measurement, covered item, country and employees are measured and they are stored in different fact and dimension tables. Finally various reports are created to understand what happens during the life of a policy, when a claim is processed.

Responsibilities:

• End to End Implementation of OBIEE
• Extensively involved in requirement gathering and Business Analysis using the Use-cases, functional specifications and business rules.
• Involved in planning, building, and managing successful large-scale Data Warehouse decision support systems.
• Used the OBIEE 10.1.3.3/10.1.3.4 Admin tool to develop and enhance meta-data
• Performed the detailed design of Reports / Dashboards and Analytical Data Model Metadata / .rpd .
• 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 polling strategies in the repository.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Developed different kinds of Reports pivots, charts, tabular using global and local Filters.
• Involved in managing appropriate security privileges on subject areas and dashboards according to business requirements.
• Managed security privileges for each subject area and dashboards according to user requirements
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes.
• Viewing report data in BI publisher using templates
• Creating reports with parameterized and list of values
• Creating reports based on BI Answers request
• Monitoring Incremental Full load through DAC
• Designed the Logical and Physical model of the database using Erwin. Extensively used Erwin for Dimensional Data Modeling.
• Involved in Data Loading Sequence and Populated Data into Staging Area and Warehouse.
• Involved in the Development of Informatica mappings and Mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level. Created different mappings using transformations like Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• Designed ER diagrams, logical models relationship, cardinality, attributes and candidate keys and physical databases object creation and aggregation strategies as per business requirements.

Environment: OBIEE 10.1.3.2, Informatica 7.1.3, DAC, Oracle 10g,Siebel CRM, SQL Developer, SQL Plus, Windows-XP

CONFIDENTIAL

Position: OBIEE Developer

CONFIDENTIAL is an online dating company which reportedly has more than 20 million members. Web site serves 25 countries in more than 8 different languages. Its headquarters are in CONFIDENTIAL and the company also has offices in CONFIDENTIAL.

Responsibilities:

• Worked with the conversion of Business Objects to OBIEE, Enhancing EDW and Migrating SQL Server to Oracle.
• Worked with 5 other developers and 1 admin.
• Customized the OBIEE Repository physical, BMM, and presentation layers .
• Helped create connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Created dimension hierarchies, aggregates, and keys in the BMM layer.
• BMM layer - created logical tables, whole diagram using complex joints, dimensional modeling design, and building business models defined drill- down time series other dimension hierarchies.
• Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
• Created repository and session variables.
• Implemented user security configurations in the repository, Security setup users/group, access/ query privileges .
• Used the security settings in OBIEE Admin tool to setup users, Groups and Access privileges.
• Customized Activity and Revenue star schemas.
• Deployment of the OBIEE RPD to the BI Presentation Services.

Environment: OBIEE, Informatica, Oracle 10G, SQL Server.

CONFIDENTIAL

Position: Siebel Analytics Developer

CONFIDENTIAL Specializes in providing Customer Relationship Management Business Intelligence solutions to their client base in Telecom, Media, Finance and Retail business domains across CONFIDENTIAL.

Responsibilities:

• Gathered and analyzed the business requirements and defined their relationships with existing
• Business entities
• Involved in installation, configuration and administration of Siebel Analytics Server and Client components
• Created and customized Physical, Business Model and Presentation Layers in a Repository Using Siebel analytics Administration Tool
• Configured Repository using Siebel Analytics Administration Tool
• Granted users with appropriate access to the Subject Areas and Reports
• Performed Administration tasks such as assigning privileges for the users at the Answers level
• Configured and customized Presentation Services in Siebel Analytics Answers
• Developed different views like chart, ticker, narrative, column selector, view selector, legend, funnel views for the result set returned by the request to visualize data in many different ways
• In the Answers created Is Prompted reports which are linked to another report or dashboard page for the details of that particular item
• Implemented advanced features like adding Bins, Combining filter with similar requests, using filter based on another request and converting a filter to SQL
• Implemented various Dashboard Objects like Link or Image, Embedded Content, HTML and Guided navigation Link
• Implemented the data and object level security using Siebel Analytics

Environment: Siebel Analytics v7.5.2, Oracle Warehouse Builder v9.0.4, Oracle 8i, MS SQL Server 2000 and Windows 2000 server

CONFIDENTIAL