PROFESSIONAL SUMMARY

• Result Oriented IT professional with around 9 years of progressive experience in the IT field and 7 years' experience in Oracle Business Intelligence projects that span the full life cycle implementation of Oracle Business Intelligence/Siebel Analytics, Informatica and Data Warehousing.
• Expertise in Developing Oracle Business Intelligence Solutions, gathering Business Requirements and implementing them using BI Tools such as Siebel Analytics/OBIEE.
• Expertise in providing end-to-end business intelligence solutions using OBIEE.
• Extensive experience in OBIEE Answers, OBIEE Intelligent Dashboards, BI Publisher, OBIEE Administration Tool, Delivers and iBots with OBIEE Applications.
• Experience in installation and configuration of OBIEE, DAC and administering permissions, privileges to users based on their groups and responsibilities.
• Extensive experience in OBIEE/Siebel Analytics, Oracle BI applications and Informatica.
• Worked on upgrading OBIEE 10g to 11g.
• Upgraded the Informatica repository from version 8 to 9.
• Expertise in handling all phases of Software Development Life Cycle SDLC of the BI Projects.
• Sound knowledge of database architecture for OLTP and OLAP applications, Data Analysis, ETL processes in developing data marts and Enterprise Data Warehouse.
• Practical understanding of the Data modeling Dimensional Relational concepts like Star-Schema modeling, Snowflakes modeling, fact and dimension tables modeling of data.
• Expertise in design and development of three layers Physical, Business model and Presentation of an OBI Metadata Repository using Oracle BI Administration tool.
• Configured Answers ad-hoc querying, reports , Interactive Dashboards with drill-down capabilities charts/tables/graphs , Delivers/iBots alerts administered Web Catalog Objects pages, folders .
• Involved in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series and Cache Management.
• Participated in Security Setup at both Object and Data levels, which involved creation of users/groups, LDAP authentication setup Single- Sign-On of OBIEE.
• Actively involved in using Repository, Session variables and Initialization blocks.
• Customized Oracle BI Applications and modified prebuilt solutions according to the requirements.
• Extensively used the four basic Informatica Power Center client tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor
• Actively involved in Installing, configuring and customizing DAC execution plans, subject areas, tables, and task and monitoring ETL process using DAC Informatica workflow manager.
• Proficient in working on production, development test environments in different RDBMS in Oracle 8i/9i,10g,11g, SQL Server, IBM DB2 8.2 and strong troubleshooting skills
• Worked on Installation and up gradation of OBIEE 10.1.3.4.1 to 11.1.1.6.0.
• Strong experience in back-end programming with Oracle PL/SQL and SQL.
• Soft skills include excellent communication, ability to understand and analyze the client requirements and have the ability to work in a team as well as independently.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

OBIEE/BI Publisher Architect

Responsibilities:

• Interacted with the business users for gathering the Reports/ Dashboards requirements and to define business and functional specifications.
• Involved from scratch to building the reports for Phoenix IFB Project as part of health care reform.
• Designed and developed the OBIEE Metadata Repository .rpd using Oracle Business Intelligence Admin tool by importing the required objects Dimensions, Facts Aggregates with integrity constraints into Physical Layer using connection pool, developing Dimensions Drill-Down Hierarchies Logical Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Developed reports using BI Dashboard and Answers, views charts.
• Configured metadata objects Subject Area, Table, and Column and Web Catalog Objects Dashboard, Pages, Folders, and Reports .
• Developed many Analytical and Operational reports using different Analytics Views Pivot Table, Chart, Column Selector, and Narrative View , Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters. Extensively used iBots.
• Analyzed the Health-Rules Application Data and created reports and BI Publisher Templates for IFB business unit.
• Converted Crystal reports in to OBIEE Reports.
• Converted SAS Reports in to OBIEE Reports.
• Created several BIP word Templates for Provider validations.

Environment: OBIEE 11.1.1.6.5, BI Publisher, Oracle 11g, SQL Developer, AQT,SQL, PL/SQL, Toad 10.1,UNIX.

Confidential

BI Apps Architect

Responsibilities

• OBI Apps, DAC and Informatica.
• Interacted with the business users for gathering the Reports/ Dashboards requirements and to define business and functional specifications.
• Responsible for setting up the environment including installation of OBIEE, BI Apps and Informatica.
• Worked in a multi user development environment
• Designed and developed the OBIEE Metadata Repository .rpd using Oracle Business Intelligence Admin tool by importing the required objects Dimensions, Facts Aggregates with integrity constraints into Physical Layer using connection pool, developing Dimensions Drill-Down Hierarchies Logical Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Managed presentation catalog groups and users settings to web group folders.
• Developed reports using BI Dashboard and Answers, views charts, created filters to obtain weekly sales reports and send alerts to top management.
• Configured metadata objects Subject Area, Table, and Column and Web Catalog Objects Dashboard, Pages, Folders, and Reports .
• Developed many Analytical and Operational reports using different Analytics Views Pivot Table, Chart, Column Selector, and Narrative View , Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters. Extensively used iBots.
• Development of many complex Informatica mappings and mapplets to build key interfaces using transformations and reusable transformation units Update Strategy, Filter, Router, Expression, Lookup, Aggregator for loading data into Data Warehouse.
• Performed Data Validation of data in the reports, Fixed all the errors and warnings in the repository and web catalog.
• Worked on upgrading OBIEE 10 g to 11g.
• Created custom Reports in Usage tracking reports User Acceleration.
• Worked on Migration of OBIEE 10g to 11g and deployments of web app for customizations.
• Worked closely with Oracle in resolving the bugs related to product.
• Worked extensively in Oracle BI Security, Web Object Security and Data Level Security.
• Effectively managed migration of RPD and presentation catalog changes across environments through catalog manager
• Modified Pre-built OBI Applications dashboards, Answers, Repository for Sales, Finance, Supply Chain and Order Management Analytics
• Monitored the informatica jobs, which will load the data from OLTP to OLAP.
• Upgraded the Informatica repository to Informatica 8 to 9.
• 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 Siebel Analytics Repository.
• Performed the Performance Tuning of Dashboards/Reports and made required changes to repository and database.
• Performed Unit, Integration and Regression testing to validate reports and mappings.
• Created the RPD, Reports and Dashboards for source JDA Forecasting against OLTP with several BI functionalities to support forecast reporting. And thus avoided development time and efforts.
• Integrated the custom EPAATS source with BI for reporting.

Environment: OBIEE 10.1.3.4.1,OBIEE 11.1.1.6.0, BI Apps 7.9.6, DAC 10.1.3.4.1, Informatica PC 8.6.1, Oracle 10g, SQL Developer, SQL, PL/SQL, Toad 10.1,UNIX.

Confidential

OBIEE Developer

Responsibilities:

• Oracle Business Intelligence OBIEE , Informatica DAC
• Interacted with business representatives for requirement analysis and to define business and functional specifications
• Actively interacted with project managers team members to discuss timely deliverables, project status documented technical specifications from functional specifications in reporting point of view.
• Involved in gathering the requirements, performing scope analysis and identifying gaps.
• Developed OBIEE Repository as per user requirements and available information in Data Warehouse.
• Interacted with Business Users for gathering the Reports / Dashboards requirements and to define business and functional specifications.
• Designed and developed the Metadata Repository .rpd using OBIEE Server Admin tool by importing the required objects from the database using connection pool.
• Developed many Reports / Dashboards with different Views Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with Filters using OBIEE Presentation services.
• Configured iBots to deliver Analytics content based on schedule, automated iBots queries to obtain daily and weekly reports.
• Implemented OBIEE Security, both Object level and Row level by creating roles web groups, checks with external tables and LDAP.
• Implemented data level security by Creating Users and Groups with required Privileges and limited the Access to Subject Areas and Dashboards
• Involved in the Cache management, to improve the overall system performance
• Developed and debugged Dashboards/reports visibility with respect to user's responsibility and web groups in an integrated environment.
• Involved in performance tuning of the Informatica ETL mappings like increasing the caching size, overriding the existing SQL.
• Used Informatica Workflow manager and Workflow monitor for Workflow sessions and database connection management and workflow monitoring.
• Create Update and tested customization DAC ETL execution plans.
• Identified and solved numerous technical and operational problems in the Data mart design and ETL implementations.

Environment : OBIEE 10.1.3.4.1, Informatica Power Center 8.6.1,DAC, Oracle 10g, Oracle BI Apps 7.9.X, Toad, DB2,Flat files, Windows 2003 Server.

Confidential

Informatica Developer

Responsibilities:

• Oracle Business Intelligence, Informatica DAC
• Gathered and analyzed reporting requirements for the sales and marketing departments
• Interacted with operations and billings subject matter experts SME business analysts in gathering and analyzing the report requirements for the sales managers.
• Involved in the business user meetings and subject area layouts.
• Involved in developing and documenting technical specifications from business requirements
• Configured metadata objects Subject Area, Table, and Column and Web Catalog Objects Dashboard, Pages, Folders, and Reports .
• Worked on Answers to build Interactive Dashboards with drill-down capabilities
• Created reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics.
• Assisted in creation of pivot table request allowing manager to analyze the business from different perspectives using column selector.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain weekly reports, delivery of reports through email, hand-held devices and mobile phones.
• Implemented Security through external database table authentication and authorization through session system variables, Initialization blocks and groups.
• Involved in Data and Dimensional modeling creating Facts, Dimensions and Measures
• Used Informatica Power Center tools for analysis, design, mapping and workflow.
• Performed extraction, transformation, and loading ETL for data warehouses by consolidating data from heterogeneous data sources.
• 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 Repository.

Environment: OBIEE 10.1.3.4,10.3.3.x, Informatica Power Center 8.6/8.5.1/8.1.1, Oracle 10g, Oracle BI Apps 7.9.X, DAC,MS SQL Server 2005, DB2 Flat files, Toad, Windows NT.

Confidential

BI Developer

Responsibilities

• Siebel Analytics, OBIEE, Informatica
• Interacted with functional technical leads, SME's, marketing, finance, and other business groups to identify, analyze, and document business requirements.
• Designed and implemented custom business intelligence solutions Metadata and Dashboards/Reports using the OBIEE platform
• Developed Metadata Repository .rpd with multiple business layers using complex joins, presentation catalogs with access validations and external table security repository and repository migration in BI Server.
• Designed and developed many Dashboards/Reports that are Dynamic Interactive with intuitive drilldowns, drill-across flash-based drillable charts bar-charts, pie-charts, radars, and bubble-charts , and local global filters and cache monitor using Siebel Analytical Web.
• Used Smart View import, manipulate, distribute and share data in Microsoft Excel, Word and PowerPoint interfaces, there by accessing data from Relational or Multi-Dimensional sources.
• Configured iBots to deliver Analytics content based on scheduler, automated iBot queries to obtain daily and weekly reports.
• Performed the Security management for users, groups and web-groups using the various authentication systems.
• Enhance performance by requesting Aggregate tables, Indexes and managing Cache after Benchmarking performance tuning strategies with business model-level calculations versus database level pre-computations and aggregations.