SUMMARY

• Complete Software Development Life Cycle implementation experience of Data Warehouse/Data mart and Business Intelligence using ORACLE Business Intelligence OBIEE , Oracle BI Apps, Enterprise wide Data Warehouse and Informatica Power Center.
• Over 6 Years of strong experience in OBIEE Administration tool, Presentation Services and Scheduler.
• Worked with client implementations including Cisco Systems Inc, Brocade and Netapp Inc. Have Knowledge of Cisco business and processes.
• Expertise in converting and using Oracle pre-build Rpd's Financial, HR, Sales, Supply Chain, Order Management, Marketing Analytics, etc. according to business requirements.
• Experience in configuring in Data Warehouse Administration Console DAC and ETL Informatica Power Center Jobs.
• Proficient in building analytical repository, and customizing the Oracle BI Apps repository business models, generating reports, and creating dynamic Dashboards using OBIEE.
• Experience in providing end-to-end business intelligence solution by dimensional modeling design, building business models, configuring metadata, Answers, Delivers/iBots, creating Reports/Dashboards, cache monitor, and building Siebel Analytics/OBIEE Repository consisting of three layers Physical Layer, Business Model Presentation Layer using OBIEE.
• Worked on OBIEE Administration Tool, OBIEE Answers ad-hoc querying, reports , OBIEE Dashboards, OBIEE Delivers alerts and Oracle BI Applications that are complete pre-built BI solutions.
• Expert in configuring the Dimensional modeling Star Schemas, Snowflakes and Aggregates , Metadata Configuration, and design ETL data extraction processes apart from prebuilt.
• Expertise in configuring and scheduling BI publisher reports based on ORACLE database.
• Experience configuring Interactive Dashboards with drill-down capabilities using global and local Filters, OBIEE Security Setup groups, access/query privileges , Metadata Objects and Web Catalog Objects Dashboard, Pages, Folders, Reports .
• Used various sources like Oracle, DB2, SQL Server and Flat files.
• Strong understanding of CRM and ERP transactional data model and dimensional modeling/Data warehousing concepts and designing of Star/Snowflake schemas.

Technical Skills:

Professional Experience:

Confidential

Sr OBIEE Consultant

Environment: OBIEE 11.1.1.7.1, SQL Server Management Studio, Redhat, Toad, Putty, Filezilla, Windows Server 2008 R2.

Responsibilities:

• The objective of the project was to move the Confidential Remedy manage, maintain, and support the Business Intelligence Reporting Platform using Oracle OBIEE. As senior OBIEE Consultant developed reports based on their Confidential facilitating company executives to take key business decisions.
• As a Sr OBIEE consultant worked in coordination with business analysts to estimate, understand and finalize the reporting requirements which are intended to be developed within the OBIEE scope.
• Was part of concert project team, used to participate in Agile meetings, support and involved in end to end RPD Design and deployment.
• Working along with the ETL developers on the data loading process to ensure that the final data in the warehouse meets the reporting requirements. granularity, dimensions and facts etc
• Worked extensively on components like Oracle Enterprise Manager EM , Oracle Weblogic server administration console and application presentation services .
• Customization of OBIEE report interfaces using custom skins and styles and also the logging home page of presentation services.
• Support for the code which already passed the development and testing phases on a daily basis.
• Created custom metrics based on the existing facts and dimensions as requested by the customers with appropriate aggregation rules.
• Worked along with the migration team to ensure there are no hiccups during the code migration between development, testing and production environments.

Confidential

Sr OBIEE/Informatica Admin

Environment: OBIEE 11.1.1.6.6, Informatica 9.5, Oracle SQL, Perforce, Toad, AIX, Windows Server 2008 R2.

Responsibilities:

• The objective of the project was to manage, maintain, and support the Business Intelligence Reporting Platform using Oracle OBIEE, Informatica and Oracle Database.
• Applied patcheson OBIEE 11g 11.1.1.6.6 on Dev, Test and Prod.
• Configured MUD in Dev and prepared the documentation.
• Migrated RPD and Catalog from DEV to Test and Prod.
• Designed, implemented and developed ETL process against data sources.
• Managed Security settings in OBIEE Administration Tool.
• Configured LDAP security in all the environments.
• Managed PowerCenter 9.5 instances. Performed Backup / Recovery of Informatica Workflows, Mappings.
• Coordinated with UNIX and Database Administrators.
• Provided technical support for the Informatica environment.
• Managing documentation of application administrator duties.
• Involved in migrating Mappings, Workflows from one environment to other.

Confidential

Sr OBIEE Developer

Environment: OBIEE 11.1.1.6, Oracle 11g, TOAD, Oracle SQL, Windows XP, Windows Server 2008.

Responsibilities:

• The objective of the project was to create reports and dashboards using integrated commerce platform Confidential. Where a partner can register opportunities for special pricing. This provides increased collaboration between partners and cisco sales team.
• Was part of Confidential Team.
• Upgraded OBIEE from 10g to 11g and configured the Security in web logic. Implemented object
• level security and data level security.
• Executed OBIEE administrative tasks such as OBIEE server installation, migration and user maintenance.
• End to End repository creation, reports creation, prompts, dashboards and data modeling in OBIEE 11g.
• Provide support in the implementation of OBIEE components. Configured different types of Reports
• Drilldown techniques, Aggregation rules to meet client requirements.
• Created Reports, Graphs, Pivot Table and View Selector, dynamic dashboard prompts and guided
• navigation link in Deal Management Reporting DMR .
• Worked on BI Publisher to create corporate standard report layouts.
• Worked on Reports including Top Deals, Service Reports, Sales Usage Reports, Deal Lookup.
• Worked on Multi-user development environment MUDE and created different projects.
• Involved in merging and migrating applications from development to production for Deployment.
• Implemented OBIEE Security Object level and Data level Security in the OBIEE repository and
• answers using repository variables, session variables and initialization blocks.
• Created security settings in Oracle Administration Tool to set up groups, access privileges and query
• privileges and also manages security for groups in BI Answers.
• Developed different kinds of Reports Pivots, Graphs using Global and local filters.
• Performed performance tuning of dashboards/reports and made recommendations for changes to database.
• Involved in the Development of Informatica mappings and mapplets and also tuned them for
• Optimum performance, Dependencies and Batch Design.

Confidential

Sr OBIEE Developer/BI Analyst

Environment: OBIEE 11.1.1.5, Informatica 8.6.1, DAC 10.1.3.4, Oracle BI Apps 7.9.6.3, Oracle 11g, oracle SQL, Toad, Windows XP.

Responsibilities:

• The objective of the project was to implement dashboards and troubleshoot production issues, identify root cause and migrate fixes.Merging data coming from two sources SAP and Oracle to create reports and dashboards.
• Responsible for gathering business requirements meeting with business users and stakeholders and transform requirements in to functional/technical requirements.
• Extensively worked on OBIEE Administration tool to develop and enhance metadata.
• Involved in modifications of Physical, Business and Presentation layers of metadata repository using OBIEE Administration Tool.
• Configured Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Worked on Sales Analytics, Financial Analytics and Executive Analytics Dashboards.
• Involved in customizing Account Recievables, Accounts Payables and Oracle GL Subject Areas and
• corresponding dashboards as per user requirements.
• Worked on Reports including Booking Trend Analysis, Sales Booking Analysis Trend, and
• Booking Forecast by Sales Territory.
• Worked on OBIEE Answers to build Reports and Interactive Dashboards according to Functional Specific Documents.
• Resolved production issues. Implemented the business rules such has Dimensional Hierarchies,
• Aggregate Navigation, Level Based Measures and Cache Management in Business Model and Mapping Layer.
• Worked on Multi-User Development Environment MUDE and created different projects.
• Worked closely with users, developers and administrators to resolve ongoing production problems by reviewing design changes made to production systems.
• Experience in using DAC to configure, monitor and schedule ETL routines.
• Experienced in deploying Informatica workflows to the DAC and build dependency and dependent hierarchical tasks

Confidential

Sr BIApps Consultant

Environment: BIAPPS 7.9.6.3, Informatica Power Center 8.6, DAC 10.1.3.4, Oracle 10g, Oracle R12, TOAD, MS SQL Server 2005

Responsibilities:

• Scope of the project includes the development of interactive Dashboards which provide access to strategic business information from the company-wide data warehouse analytical information assets in Brocade. Familiarization with existing reporting, understanding the business requirements and replicating existing reports from a new ledger environment.
• Installed BIAPPS OBIEE, DAC and ETL on Dev and Test server and configured Active Directory with user and group authentication in web logic.
• Created Pages Trends, Revenue, Margin analysis and Customer reports in Order management Dashboard.
• Designed and Tested Reports in the Dashboards for the Oracle HR Analytics modules like Compensation, HR performance, Retention and Workforce Profile.
• Worked with Financial Analytics Subject Areas:-
• Financials - AP Balance, Financials - AP Invoice Aging, Financials - AP Transactions, Financials
• GL Balance Sheet, , Financials - GL Cash Flow, Financials - GL Detail Transactions.
• Lead the offshore team in Development of ETL and OBIEE.
• Corrected some reports and dashboards which were showing improper data and logic.
• Designed Star Schema and Informatica mappings and imported new tables in to the RPD.
• Created OBIEE Repository .rpd which involved Schema Import, Implementing the business logic by customization, Dimensional Hierarchies, Aggregate Navigation, Level Based Measures, Security Management Data level/Object level security , Variables, Initialization blocks and cache management.
• Used the Expression Builder Utility to create new logical columns in the BMM layer and created various calculation measures.
• Extensively used ETL to load data from multiple sources to Staging area Oracle using Informatica PowerCenter.
• Also participated in developing ETL mappings using Informatica 8.6, used Transformations like Aggregator, Update, Filter, Lookup, Sorter.
• Worked in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets
• Maintained the Full and Incremental loads through DAC on different environments like Development, QA and Production environment.

Confidential

OBIEE Developer/Admin

Environment: Oracle Business Intelligence Enterprise Edition 11.1.1.3, Hyperion 9.3.1, SQL Server 2005, Toad, Windows server 2008R2 Scope of the project was to install OBIEE 11G and to convert the existing Hyperion reports in to BI Reports.

Responsibilities:

• Installed OBIEE 11g on Dev and Test server and configured Active Directory with user and group authentication in web logic.
• Created BI support schemas and domains using RCU Repository Creation Utility .
• Developed reports for Proof of Concept and deployed RPD's in Weblogic.
• Use to monitor the performance of the reports.
• Created new subject areas as per the requirement for the business users and exposed the subject areas at presentation layer.
• Worked with Oracle BI Server, Presentation Server, Oracle BI Administration Tool.
• Developed Reports/Dashboards with different Analytics Views using Oracle Business Intelligence Presentation Services.
• Created guided navigation links to help files within the dashboards to help the end users.
• Created many pivot table requests allowing manager's to analyze the business/data from different perspectives.

Confidential

Sr OBIEE Developer

Environment: OBIEE 10.1.3.4/10.1.3.3, XML/BI Publisher 5.6.3, SQL PLUS, Oracle 10g, TOAD, Unix

Responsibilities:

• Involved in full project life cycle.
• Worked with Revenue Fact and Geography Dimensions using Oracle BIEE 10.1.3.4 for generating reports for managers, executives and individuals.
• Worked with the physical layer to create Connection pools and imported physical tables and defined joins.
• Worked on Oracle BIEE Administration tool for customizing the Physical layer, Business layer, Presentation layer and modifying it according to the business requirements.
• Worked and developed Repository .rpd , configured metadata objects Subject Area, Table, Column and Web Catalog Objects Dashboard, Pages, Folders, Reports .
• Developed and modified reports in BI publisher. Designed, developed, test, document, and deployed.

Confidential

OBIEE Developer

Environment: OBIEE 10.1.3.2, Siebel Analytics 7.8.4 , Oracle 9i, Informatica PowerCenter 6.x, UNIX, Siebel Marketing Analytics, Siebel Contact Center, SQL Plus

Responsibilities:

• Interacted with Marketing Team, business analysts/ users in Requirements Gathering meetings, and performed GAP Analysis, to identify missing elements in Data Marts and Data Warehouse.
• Designed, Developed, Migrated and Tested Siebel Analytics Web Catalog .webcat objects from
• Development to Testing, and then to Production Environments.
• Developed many Case Solutions Time Series Wizard objects for comparing various Marketing
• Campaigns' related Current, Previous and Year Ago Quarter / Month Requests.
• Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic,
• Narrative View, Pivot Table, Chart, View/Column Selector, Tabular with global and local Filters .
• Configured and Automated iBots to deliver Analytics Reports to Users, based on Schedules.
• Implemented Data Level and Object Level Security, by creating Session/ Dynamic Repository
• Variables, and Initialization Blocks.

Confidential

Siebel Analytics/Oracle BI Consultant

Environment: OBIEE 10.1.3.1, Siebel Analytics 7.8.4, Siebel Pharma Analytics 7.8.4, Oracle10g, DB2, Informatica 7.1, UNIX

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
• Configured and Created repository using Siebel Analytic Admin tool.
• Created numerous executive level reports. 'Dashboards' were generated to provide insight into the sales/marketing/financial data.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Built Business model and established relationships Foreign Keys Physical Logical between tables.
• Developed custom reports/Ad-hoc queries using Seibel Answers and assigned them to application specific dashboards.

Confidential

Oracle Developer

Environment: Oracle8i, SQL, PL/SQL, SQL Loader, Sun Solaris

Responsibilities:

• Communicated with clients regarding system requirements, ensuring the development and implementation of customized products to customer satisfaction.
• Prepared functional specifications for user requirements.
• Developed and modified applications, authored database procedures and triggers for data processing.
• Developed PL/SQL Packages, Procedures, Database Triggers, and Functions to implement business l Logic.
• Created Entry Forms/Reports for various modules. Created Databases, Loaded Initialization Data,
• Generated Users, and assigned Roles and access.