SUMMARY:

• Over 7+ years of experience in designing, developing and implementation of OBIEE 10g & 11g, experience in 11g.
• Experienced in OBIEE BI Applications 7.9.6.x, Siebel Analytics 7.x which include building and configuring repository, creating and managing oracle/Siebel Intelligent Dashboards, oracle/Siebel Answers, oracle/Siebel Delivers and oracle/Siebel iBots (ETL Informatica, Reporting - Siebel Analytics, Scheduling-DAC). Experienced in Data Warehousing Methodologies.
• Experienced in OBIEE solution architecting (OBIEE 11g & OBIEE10g) and have a strong understanding on OBIEE 11g capabilities with Web logic 10.3.5 as an Application server. Knowledge on Tableau 8.1
• Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer. Experienced in working with Oracle Fusion & Web Logic.
• Experienced in designing and developing Data Modeling and Analysis using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables and Physical and Logical data modeling in the OBI Administration tool.
• Highly skilled at configuring OBIEE Metadata Objects including repository, variables, interactive dashboards with Map viewer/Big Maps/Google Maps, reports and three tier OBIEE architecture.
• Experienced in writing, testing and implementation of Stored Procedures and Packages at database level using PL/SQL, Database designs Methodologies.
• Experienced in Integrating OBIEE with Hyperion Essbase 9.x and in developing RPD and reports against multidimensional databases.
• Expert in configuring, designing, development, implementation and using Oracle pre-build RPD's (Financial, HR, Sales, Supply Chain and Order Management, Marketing Analytics, etc.) and ETL Mappings according to business requirements. Experienced in Oracle EBS R12 Financial.
• Expert in building repositories using star schema, developing Subject Areas, and applying security (group, access / query privileges) at object and data level in Administration Tool.
• Hands on experience in customizing reports, filters and charts in Oracle BI Answers, Interactive Dashboards, BI Publisher (Excel) and Delivers. Expert knowledge of report development execution in a complex environment.
• Comprehensive knowledge in general accounting principles, business functions of general ledger, treasury accounting, accounts payable, asset management, billing, cash flow statements and receivables.
• Experienced in Simplifying Migration Process - Changing environment specific variables in RPD development, administration, analysis report.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like OBIEE.
• Extensive experience in OBIEE RPD Development, Answers Intelligent Dashboards, Delivers, iBots.
• Involved in performance tuning at the DB level, OBIEE-RPD, Dashboard Server Level.
• Good Debugging skills in Reporting and SQL.
• Expertise in understanding data model like star and snowflakes.
• Expertise in analyzing business issues and providing possible reporting solutions to end users.
• Created and scheduled iBots using delivers to send alerts, run reports, and deliver reports to the users. Experienced in supporting performance tuning and process tuning at all levels.
• Proficient in using the time-series functions to support historical time comparison analysis and creating requests, adding filters, creating prompts, and creating pivot tables.
• Experienced in configuring Usage Tracking and Multiuser Development Environment (MUDE).
• Experienced in creating Dimensional hierarchies and designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables.
• Experienced in translating business requirements into a business dimensional model, key subject areas, dimensions, hierarchies, attributes and measures.
• Expert ability to trouble shoots and prioritizes issues.
• Excellent interpersonal and communication skills for efficient client interaction.
• Authorized to work in United States for any employer.

TECHNICAL SKILLS:

BI Tools: OBIEE 11.1.x.x/ Siebel Analytics 7.5/7.7, BI Publisher, OBIEE, OBIEE 10g

OBIEE Applications: OBIA7.9.6.3, 7.9.6.1(Financial analytics, HR Analytics, Sales, Service, Marketing)

ETL Tools: Informatica Power Center9.0, Informatica Power center8.6.1, DAC, ODI 11g

Languages: SQL, PL/SQL, Java, C, C++ XML, HTML/XHTML, TOAD, JDBC, Java Script, SQL*Plus, UNIX shell scripts

Applications Servers: Oracle Applications 11i, R12, PeopleSoft 8.9, Oracle Web Logic Server 10.3.5

Operating Systems: Microsoft Windows 8.x, Windows 7, Solaris 5.8, UNIX, Oracle Enterprise Linux 5.7, Mac OS X

Data Modeling: Power Designer, Erwin

Case Tools: MS Visio, MS Project

PROFESSIONAL EXPERIENCE:

Sr. OBIEE Developer

Confidential - Westlake Village, CA

Responsibilities:

• Interacted with Client Services Management business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications.
• Creating and modifying Business Intelligence requests using Oracle Business Intelligence Answers.
• Performing administrative tasks related to the development and configuration of Interactive Dashboards.
• Designed and Built OBIEE RPD at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer level (create presentation catalogs.), test and validate the model.
• Developed the Dimensions and Time Series Objects in the Business Model and Mapping Layer with Security settings using LDAP Authentication to setup groups, access and query privileges
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Utilized OBI reporting features (Navigational, Drill Down, Drill Across, Guided Navigation, and Security. etc.).
• Used Oracle Business Intelligence Delivers to configure, schedule, and deliver personalized alerts to Interactive Dashboards by using Agents.
• Created Data Model Design and Documentation (Facts and Dimensions, Business Users & Security Permissions, Stars with Hierarchies, Business Model Names for Source Columns, Reports and Dashboard Layouts).
• Created Database Report Layouts Using BI Publisher Desktop (Template Builder) in MS Word.
• Integrating OBIEE and BI Publisher and Scheduling BI Publisher reports and Created BI publisher reports based on various data sources.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Managed security privileges for each subject area and dashboards at object level and data level security according to user requirements.
• Migrated to production environment after successful testing is done.
• Developed different levels of Security set-up are for the entities of the application (on both Repository file and Web catalog file).
• Developed and Debugged Interactive Dashboards and Reports relating to Customer Feedback Analytics, with different Analytic Views (Guided Navigation, Pivot Table, Chart, View Selector, Column Selector, Filters, and Dashboard Prompts) using Presentation Services.
• Implemented Object Level Security for the objects like Dashboards and Reports, and Data Level Security for Region and Product dimensions, using Session Variables.
• Developed Performance Tuning Strategies for optimizing the performance.
• Trained End Users and Pilot Users about OBIEE Tools.

Environment: OBIEE 11.1.1.7, OBIEE Financial Analytics 7.9.6.1, Essbase 9, Oracle EBS R12.1.1, Informatica 8.6, DB2 UDB (8.x and 7.x), Oracle Enterprise Linux 5.7, Windows Server 2003, Windows XP.

Sr OBIEE Developer

Confidential - Irving, TX

Responsibilities:

• Interacted with the end users for requirement gathering and defined requirement specifications document by access and retrieval of financial data from one single source.
• Participated in upgrade activities and provide valuable information to CM team for successful upgrade.
• Identified & Created Facts, Dimensions, and Hierarchies of the business model.
• Developed Segment Value Detail, Work Order Detail and OGA Repositories (RPD) by importing metadata into Physical Layer, applied Business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer.
• Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups.
• Configured Interactive Dashboard with drill-down capabilities using global and local Filters, Metadata Objects and Web Catalog Objects.
• Applied Cascading Prompts and Multi Level Prompts on Dashboards.
• Identified issues, performance bottlenecks, and optimized the Business Intelligence Dashboards and Reports.
• Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Wrote Custom SQL Codes for the reports.
• Applied Optimization Techniques for the better performance of the reports.
• Involved in Monitoring and Scheduling different process flows using Oracle Work Flow Manager.
• Used external tables to Transform and Load data from Flat files into target tables.
• Used Debugger to validate Mappings by creating break points to analyze and monitor Data flow.
• Trained End Users and Pilot Users about OBIEE Tools.

Environment: OBIA, OBIEE 10g/11g, ODI 10g/11g, Informatica Power Center 9.1/8.6, Power Exchange 8.1, Oracle 11g, SQL, PL/SQL, TOAD, Erwin, MS SQL Server 2008, T-SQL, Hyperion.

Obiee Developer

Confidential - Denver, CO

Responsibilities:

• Actively participated to implement Obiee to generate high level report for insurance transactions on payment, pending claims, premium and claims. Raw data and other transaction affecting the risk .
• Identified Facts, Dimensions, and Hierarchies of the business model.
• Involved in Analysis, Requirement gathering, function/technical specification, development and testing.
• Identified the granularity level of the business model based on the end user requirements.
• Extensively used BI (OBIEE) for customizing and modifying the three layers of the repository.
• Providing object level security for different web groups based on responsibilities.
• Developed security matrix for dashboards/Answers users based on Individual responsibilities.
• Designed Dimensional Hierarchies for the Drill Down functionality and implemented Business Logics for facts
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created repository and session variables in the RPD development.
• Educated and Trained End Users and Pilot Users about BI Tools (OBIEE).

Environment: OBIEE 11G/10.1.3.x, Oracle Financial Analytics(OBIA), BI Publisher, Oracle 10g, General Ledger, Account Payables, Accounts Receivable, PL/SQL, TOAD.

Sr OBIEE Developer

Confidential

Responsibilities:

• Interacted with Business Analysts and end users to understand and document business requirements.
• Interacted with data modeling team to design start and snowflake schemas.
• Interacted with ETL team to understand the ETL process.
• Coordinated and interacted with data warehousing team to decide upon architecture for OLAP and OLTP databases.
• Used JIRA tool to track all deadlines, schedules, and modifications to reports and dashboards.
• Coordinated with team members and team lead to assess time windows for creating reports and setting deadlines.
• Imported new tables into physical layer of Oracle BI Admin Tool according to new business requirements.
• Created alias tables for existing physical tables so that new joins can be implemented according to data model changes based on new business requirements.
• Modified existing Physical tables by importing new columns from Oracle database.
• Modified existing BMM layer by mapping columns from Physical layer to BMM layer.
• Created numerous hierarchies such as level based and parent child hierarchies, level based measures in BMM layer.
• Created new logical tables, logical table sources and logical columns in BMM layer.
• Implemented inner, right outer and left outer joins in LTS of logical tables in BMM layer.
• Created calculated measures using expression builder and functions in BMM layer.
• Modified existing logical columns and created new logical columns using CASE Statements in expression builder.
• Created level based measures based on previously created hierarchies.
• Created new subject areas, presentation table and presentation columns in Presentation layer.
• Rearranged columns in Presentation layer to order and organize columns in analytics.
• Altered existing OBIEE reports as per the new requirements.
• Renamed columns, reformatted columns and hid columns in OBIEE reports as per new business requirements.
• Used time functions in OBIEE reports for calculating the time gap between two date columns.
• Implemented CASE statements in OBIEE report columns to create new columns based on if then else conditions between existing fields.
• Reordered and arranged dashboard pages in analytics.
• Created new dashboard pages as per business requirements
• Worked with various views like table view, pivot table view, graphs, etc.
• Created aggregate columns for fact fields in reports.
• Created new dashboard prompts in OBIEE.
• Modified existing filters in OBIEE as per new requirements of reports.
• Created new filters in OBIEE as per requirements of new reports.
• Altered existing dashboard prompts in OBIEE Analytics/Answers according to new business requirements.
• Created pivot tables in OBIEE Analytics according to new business requirements.
• Created complex compound layouts by placing views such as table, pivot table, graphs, etc.
• Enables drill down from reports to other reports and web pages.
• Created KPIs and KPI watch lists so that users can observe changes in facts based on dimensions.
• Created and scheduled agents so that reports or other dashboard contents can be emailed to users as per business requirements.
• Assisted BI Admin in creating users and groups and assigning privileges and application roles.
• Implemented object level security at dashboard level.
• Created variables and initialization blocks in RPD using variable manager.
• Created BI Publisher reports from direct OLTP according to user requirements to provide end users with real time data.
• Created test cases for QA team to perform tests on reports and validate them, involved in final testing of reports.
• Assisted in migration of rpd from DEV/TEST environment to Production environment.
• Assisted in migration of OBIEE reports from DEV/TEST environment to Production environment.
• Fixed productions issues on weekends and late nights so that end users can access reports without any disruption.
• Worked closely with DBAs to fix performance tuning of reports by suggesting creation of indexes.
• Provided DBAs with back end SQL queries extracted from OBIEE for performance tuning.
• Modified existing columns in report tables according to new business requirements.
• Provided training to junior level developers and performed KT to new members of the team.

Environment: OBIEE 11.1.1.6.0 , OBIEE 10g, BI Publisher, Toad for Oracle, SQL Developer, MS Word, MS Excel, MS PowerPoint, MS Outlook.

OBIEE Developer

Confidential

Responsibilities:

• Involved in Customization and Development of the OBIEE Metadata Repository (.rpd) using OBIEE Admin Tool in Multi User Development (MUD) Environment.
• Developed managerial hierarchy in the RPD with vertical table structure to identify the direct report employees of a particular manager at certain level. Implemented conditional formatting to identify the employee level of reporting.
• Developed the reports based on Dimension hierarchies and presentation columns to provide the filter at any level of column detail.
• Implemented security on fact table to restrict the organization data limited to their own hierarchy.
• Restricted confidential data to certain groups including top talent associates profile information access to higher level management only.
• Created set of dashboards/reports for talent planning, performance management, competencies, and Executive profiles using OBIEE.
• Developed report with conditional filters, Prompts, Drill Down reports, Drill Reports, different Analytics Views (Pivot Table, Charts)
• Created user level security for intelligence dashboards based on Business Requirement and utilized Oracle Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to subscribed users.
• Security has been considered primarily for the confidential columns data by generating the SQL and gathering the group's information to restrict the data to certain groups only.
• Implemented Workforce planning project to allow users to forecast the Organization metrics data, and displaying the current and forecasted data in a single dashboard by having run time calculations to display forecasted data.
• Provided new design for Associate movement summary as Daily data or monthly data changes. Configured the RPD to switch the sources to provide the flexibility of choosing daily or monthly snap shot data
• Limited the row level data to the certain groups based on inclusive or exclusive access to the organization, Location, Manager and Confidential information. Limited the intersection of row and column by categorizing the confidential columns based on row level data and exclusive or inclusive access to it.
• Provided additional layer of security on physical data base objects to the particular promo group to perform the data base authentication.

Environment: Oracle Business Intelligence (OBI) EE 10.1.3.4.2 , Informatica 8.1.x, Oracle 10g.