SUMMARY

• 8+years of Information Technology & Business Intelligence implementation experience using Oracle Business Intelligence (BI).
• Expertise in OBIEE 10.1.3.4.1/ 11.1.1.5/11.1.1.6 (configuring repository, creating Intelligent Dashboards / reports, Answers.
• Extensive experience in OBIEE Answers, Delivers, iBots, and Siebel Intelligent Dashboards with Siebel Analytics stand - alone/integrated implementation.
• 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.
• Expertise in developing all 3 layers of the Analytics Repository (Physical Layer, Business Model & Presentation Layer).
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Experienced in configuring OBIEE Reports & Dashboards, OBIEE Delivers, Pivot views, advance Reports.
• Experienced in laying roadmap for identifying BI Components based on client’s requirement and Installing, Configuring Oracle BI components.
• Performed configuration of Oracle BI Processes, Data sources, Presentation services and Scheduler.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema modeling, Snowflakes modeling, fact and dimension tables modeling of data.
• Handled both off shore and onsite team.
• Extensive knowledge of the Application development lifecycle, Business Objectives, Business Processes and ability to work in a fast paced environment.
• Good communication skills, technically competent and highly motivated towards working for the goals of the project/organization.
• Quick learner and adaptive to new and challenging technological environments.

TECHNICAL SKILLS

OLAP TOOLS: OBIEE admin experience Analytics OBIEE 11.1.1,Oracle BI AppsPublisher

Languages: Java, SQL, PL\SQL

ETL Tools: Informatica (Power center 8.1/7.1), Oracle OLAP

Analytics: OBIEE 11g, OBIEE 10.1.3.x, Siebel Analytics 7.8Tools/Utilities SQL Loader, TOAD, SQL developer

Tools: Informatica Power Center 9.0.1,OBIEE 10.13.4.1,OBIEE 10.1.3.3,OBIEE 11.1.1.5/11.1.1.6 , Siebel Analytics 7.5, 7.7, 7.8, BI Publisher, ETL, Data Mining, Data mart, OLAP, DAC,Autosys,Salesforce.com

Web Technologies: HTML, DHTML, XML, JDBC JavaScript and VB Script.

PROFESSIONAL EXPERIENCE

Confidential, Oshkosh, WI

Oracle BIEE Developer

Responsibilities:

• Translated Business requirements into technical requirements.
• Customized Purchase Orders, GL, Account Receivables, Account Payables, Procurement and Spend Analytics, Order Management, Inventory reports using OBIEE 11g.
• Worked with OBIA rpd, making use of the existing physical/logical objects, creating reports based on pre- built rpd.
• Created Dashboard prompts and advanced filter criteria.
• Created new connection pools for different data sources and designed from the scratch (physical, business model and presentation).
• Customized reports from BI Apps (OOB-prebuilt) seeded reports.
• Used BI Apps prebuilt Informatica mappings for development.
• Fixed many OOB issues.Created major and important dashboards like Customer Profitability from the scratch including
• The top priority reports like Monthly Net Sales, Customer Profitability, Funds Details, Credit Summary.
• Utilized features like dashboard prompts, pivot tables, column selector, drill down, hierarchy.
• Configured Web Catalog Objects (Dashboards, Pages, Folders, and Reports).
• Implemented various Repository Variables and System Variables depending up on user requirements.
• Extensively worked on Informatica Power Center 8.6 tools - Designer, Workflow Manager, Workflow monitor.
• Designed and developed complicated/complex reports.
• Followed best practices to make sure there was good performance.
• Administered MUD rpd, reviewed developers’ rpd development before merging into MUD server.

Environment: OBIEE-11.1.1.5, OracleBI Apps, Oracle DB 10g, SQL Plus, Oracle SQL Developer, Informatica Power Center 8.6, DAC.

Confidential, Roseland, New Jersey

OBIEE Consultant

Responsibilities:

• Interacting with management, business and users, gathering the business requirements, designed and developed complex dynamic business quality compliance group reports related to audit and early warning.
• Created transformations like Expression builder, joiner, and router.
• Implemented OBIEE solution for ‘Sales’ subject area using various components of OBIEE Suite like Administration Tool, BI Answers, Interactive Dashboards, iBots/Delivers.
• Tuned the performance of the reports by creating various types of indexes wherever appropriate.
• Configured MUD for OBIEE Tool
• Used existing data from Hyperion Essbase for analysis.
• Utilized various building blocks like calculation measures, time series measures, initialization blocks, session and repository variables, fact tables, dimension tables, dimension hierarchies.
• Created variety of interactive dashboards containing charts, graphs and pivot tables using BI Answers.
• Utilized features like narrative views, dashboard prompts to create interactive dashboards.
• Configured BI Scheduler and created simple, conditional and chained iBots to create alerts and deliver them using Oracle Delivers.

Environment: OBIEE-10.1.3.4, Oracle DB 10g, SQL* Plus, PL/SQL, Informatica Power Center 8.6.

Confidential, Newark, DE

OBIEE Consultant

Responsibilities:

• Gathered User requirements, reporting requirements and the document for requirement specifications.
• Used Administration Tool for customizing and modifying the Physical, Business Model & Mapping and Presentation Layers.
• Created dimension hierarchies, aggregates and keys in BMM layer.
• Worked on session variables and dynamic variables along with initialization blocks.
• Created users and groups in the repository and granted privileges and group inheritance.
• Worked extensively on Oracle BI Answers, Delivers and Interactive Dashboards.
• Involved in troubleshooting of Informatica Mappings and Workflows
• Compared data from Hyperion Essbase with the OBI for data validation.
• Created source and target instances and various transformations (Joiner, Aggregator, Filters, and Router).
• Configured many dashboards with different views like Pivot table, Chart, Tabular and View Selector and guided navigation links.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Created highly formatted reports using BI Publisher based on Oracle Database.

Environment: OBIEE 10.1.3.4, Oracle 10g, Oracle BI Publisher, Informatica Power Center 8.1.

Confidential, Warsaw, Indiana

OBIEE Developer

Responsibilities:

• Involved in translating high-level business requirements into logical business dimensional model.
• Development of RPD using Physical, BMM and Presentation layers of BI Administration Tool.
• Imported physical tables and defined relations between Physical tables at the Physical Layer.
• Created Drill down Hierarchies, Levels and implemented logic by creating Level Based Measures at BMM Layer.
• Utilized Aggregation to improve query performance
• Created Reports using different views
• Implemented BI Security using External Table for Authentication and Authorization
• Worked on iBots using BI Delivers for issuing Alerts and setup a Delivery Profile to email reports to various power users at scheduled intervals.

Environment: OBIEE 10.1.3.3, 10.1.3.4, Oracle 10g, MS Excel, Linux, Windows XP, SQL Plus

Confidential, Moline, IL

Obiee Developer

Responsibilities:

• Requirements into logical business dimensional model.
• Development of RPD using Physical, BMM and Presentation layers of BI Administration Tool.
• Imported physical tables and defined relations between Physical tables at the Physical Layer.
• Created Drill down Hierarchies, Levels and implemented logic by creating Level Based Measures at BMM Layer.
• Utilized Aggregation to improve query performance
• Created Reports using different views