SUMMARY:

• Over 8+ Years of progressive experience in design, configuration, development, testing and Implementation of Data warehousing and Business intelligence Applications.
• Deep understanding of Information Technology Software Development Life Cycle (SDLC) methodologies and project management principles.
• Worked extensively in the analysis and development of Data warehousing applications using Siebel Analytics 7.x/OBIEE 10.1.3.x.
• Experienced in creating KPI, KPI Watch lists, and Scorecards.
• Extensive experience in OBIEE, Oracle BI applications, and Siebel Analytics which includes creating, configuring, customizing and managing repository and Presentation services.
• Strong experience in developing OBIEE/Siebel Analytics Repository (.rpd) - three layers (Physical Layer, Business Model & Presentation Layer).
• Experienced in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Facts and Dimensions tables and Physical and Logical data modeling in OBIEE Administration tool.
• Hands on experience in customizing reports, filters, charts agents and conditions in Oracle Answers.
• Experienced in usage of Disconnected Analytics and Siebel/Oracle Delivers for sending alerts via intelligence agents (iBots) to the dashboards for the end users.
• Comprehensive knowledge in Debugging, Optimizing and Performance Tuning of Oracle BI/Siebel Analytics Dashboards/Reports by implementing Aggregate navigation, cache management and materialized views.
• Executed OBIEE administrative tasks such as OBIEE server installation, migration and user maintenance.
• Proficient with BI Publisher reports and using various templates to publish the reports as per user requirements.
• Experienced in writing, testing and implementation of Stored Procedures and Packages at database level using PL/SQL.
• Strong working knowledge in design and development of ETL Process, Data modeling for Data warehouse and scheduling DAC.
• Proficiency in security management of all aspects of OBIEE (Siebel Analytics).
• Good experience in Oracle Data Integrator 10g/11g.
• Hands on experience with Data Extraction, Transformation and Data Loading in Data Warehouse environment using Oracle Data Integrator (ODI).
• Experienced in Configuring Oracle BI Applications (OBIA) such as Sales, Marketing, HR, and Financials Analytical Applications.
• Knowledge in extracting data from Siebel CRM, Oracle EBS, PeopleSoft, OLTP, flat files and integration and loading data to OLAP systems.
• Knowledge in Data Warehousing development using ETL tools such as Informatica Power Center 8.x/7.x/6.x and developed Informatica Mappings and Workflows with Worklets and Tasks using various Transformations for ETL of data from Multiple Sources to Data Warehouse.
• Excellent problem solving skills with strong technical background having the ability to meet deadlines, work under pressure and quickly master new technologies and skills.
• Excellent interpersonal and communication skills for efficient client interactions.

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 - Sunnyvale, CA

Responsibilities:

• Gathered Business requirements by interacting with the business users, defined subject areas for analytical data requirements.
• Performed gap analysis and provided a timeline for the requirements.
• Configured the Data warehouse Administration Console (DAC) according to the OBIA 7.9.6.3financial analytics.
• Modified the Source system parameters in the DAC according to the Business requirements with their respective currencies and exchange rates.
• Built custom execution plans as to pull data from two different People soft sources simultaneously in a single run.
• Scheduled the Custom Execution plan for a weekly run in the DAC scheduler.
• Built custom mappings in Informatica SDE, PLP and SIL folders according to the Business Tree structures.
• Included the custom mappings in DAC Execution plan.
• Custom data mart is built with dimensions and facts in order to retrieve the necessary measures and attributes.
• Provide ad hoc ability in the OBIEE system for query and build reports.
• Automated ETL process is set up using Informatica and DAC scheduling tool to gather all the required data.
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Configured the OBIEE repository (Physical, BMM and Presentation layer)
• Created dimension hierarchies and aggregates in the BMM layer.
• Worked with the repository (PRD) and session variables. Created Initialization blocks to provide Object level security for the users.
• Designed developed new subject areas and modified according to the requirements. Created answers page/dashboards/prompts/Analysis on requirement.
• Used the security settings to setup users, Groups in Web logic Console and Access privileges.
• Built materialized views to solve complicated joins and improve performance.
• Customized reports in OBIEE answers and integrated them into the Dashboards according to the Business requirements.
• Created prompts, Drill down and navigation for the Business to view data at different level of granularity.
• Generated reports using the OBIEE features like pivot tables, charts and view selector.
• Performed Data Validation of data in the reports and dashboards.
• Performed production support activities/trouble shooting the issues.
• Prepared and maintained documentation for all new or modified RPD objects and ETL mappings.
• Unit, integration and system testing for all components in OBIEE. Prepared test cases and documented the results.

Environment: OBIEE 11.1.1.6, OBIEE Financial Analytics 7.9.6.3, Oracle EBS R12.1.1, Informatica 8.9, Oracle 11g, Oracle Enterprise Linux 5.7, Windows Server 2008 R2, Windows XP.

OBIEE Developer

Confidential - Riverside, CA

Responsibilities:

• Effectively interacted with the end users for requirement gathering and defined requirement specifications document by access and retrieval of financial and personnel data from one single source.
• Worked extensively on OBIEE Answers and Dashboards to create the reports as per the Client requirements.
• Used Informatica power center for extraction, transformation and loading data from heterogeneous source systems and to create mappings, mapplets transformations, re-usable transformations, etc.
• Involved in design and development of complex ETL mappings and stored procedures in an optimized manner.
• Implemented partitioning and bulk loads for loading large volume of data
• Extensively used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading
• Used third party tools like Control-M for scheduling along with Informatica Power Center and Oracle10i 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.
• Worked with business analyst and users (Financial Advisors or FAs) to gather analytics requirements and created the business model using star schemas.
• Trained End Users and Pilot Users about OBIEE Tools.

Environment: OBIEE 10.1.3.4, Oracle BI Applications 7.9.4(Financial analytics, HR analytics), Informatica 9.1, DAC, Oracle 10g, Oracle EBS, SQL Developer, SQL*Plus, Informatica Power Center 7.1, Windows-XP

Sr. OBIEE Developer

Confidential - New York, NY

Responsibilities:

• Responsible for design and development of interactive business operational reports, scorecards, KPI dashboards, and automated reports used for measuring productivity and performance.
• Designed and developed many dashboards/reports that are dynamic & interactive with intuitive drilldowns, drill-across & flash-based drillable charts (bar-charts, pie-charts, radars, bubble-charts). Capabilities split reports for summary & details information, local & global filters and cache monitor.
• Developed several reports/dashboards with different analytics views (drill-down/dynamics, CSS, pivot table, chart, column sector, tabular with local and global filters) using OBIEE Analytics Web by creating real-time customer call volume reports to handle better IVR (Interactive Voice Recording).
• Developed complex reports by using the different views like Table, Pivot, Chart, Column Selector, View Selector and Combined with similar requests.
• Used repository, session and presentation variables to obtain user requirements and generate reports.
• Created complex reports using time series functions to show data.
• Enhanced 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.
• Provided full-lifecycle support for migration efforts from development to QA to production analytics
• Worked on end-to-end SDLC process.
• Delivered trainings by creating and providing training documentation to end-users.
• Configured Oracle BI Scheduler configuration for alerts/iBots.
• Created workflows for full load and incremental loads to be used by DAC.
• Assembled subject areas and created execution plan and accommodated the new Informatica mappings.
• Monitoring Incremental & Full load through DAC. Performance tuning done to all jobs.
• Used ETL Informatica Mapping Designer to create/update SIL/SDE mappings using different transformations required to move data into data warehouse.
• Performed unit, integration, and regression testing to validate report and mapping functionality.
• Generating the results in Toad by using the SQL generated behind the report in order to determine the behavior of the generated report in OBIEE.
• Created training documents associated with the dashboards & reports.

Environment: OBIEE 11.1.3.0,DAC 7.9.6,, OBIA 7.9.5, TOAD, Oracle 10g, Windows, Red Hat Linux, Web Logic Server 11gR1 PS3, Financial Analytics, HR ( Human Resources) Analytics.

OBIEE Consultant

Confidential

Responsibilities:

• Gathered Business Requirements by interacting with IT and documented them unambiguously as System Requirements Specifications (SRS) combination of (FR/NFR).
• Created High level Design Documents (HLD) according to the Business System Requirements (FR/NFR)
• Worked as an Application Designer for Mapping & Designing RPD and ETL development.
• Documented Application Design Mapping & ETL Mapping, which helps Developers to implement ETL and RPD.
• Designed and Developed Custom Business Intelligence Solutions (Metadata and Dashboards/Reports) using OBIEE platform.
• Developed the OBIEE Metadata repository (.rpd) model with the necessary logic that involved creating the Physical, BMM layers with aggregates, dimensions & time series functions, Presentation layer with catalogs & folders and external table security using Siebel Server Admin tool. Also created hierarchies, variables, and event poll strategies in the repository.
• Developed Dashboards for each of Metrics by embedding Reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics in providing summary and detail reports.
• Implemented Dynamic Navigation to allow the system to pass parameters from the summary dashboards to the details dashboards.
• Implemented Groups and Hierarchy Level Based security to dashboards based on Role.
• Configured and automated iBots to deliver daily and weekly reports based on schedule.
• Performance Tuning of Reports by implementing the aggregate navigation, Cache and Oracle Worked on DAC, Pharmacy Analytics for creating Auto Execution and Scheduling Tasks.

Environment: OBIEE 10g, Oracle 10g, Oracle Enterprise Manager, Oracle Developer 6.0/6i, SQL*Loader, SQL*Plus, PL/SQL, Windows 2000, Autosys, UNIX (Sun Solaris), TOAD, PL/SQL Developer.