PROFESSIONAL SUMMARY:

• 7+ Years of experience in designing, developing and implementation of OBIEE 10g & 11g , 3+ years’ experience in 11g .
• Experienced in OBIEE 11.1.1.7,Oracle 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.
• Experience on installation and setup of the Bi Publisher desktop version and OBIEE 11g.
• 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 .
• Designed, Developed, Tested and Maintained BI Publisher reports and supported all aspects of Oracle BIP report development in support of information sharing and application development initiatives.
• Experienced in Simplifying Migration Process - Changing environment specific variables in RPD development, administration, analysis report.
• 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 .
• Experience in developing complex BI Publisher reports and have good Oracle SQL experience.
• Expert ability to trouble shoots and prioritizes issues .
• Excellent interpersonal and communication skills for efficient client interaction.

TECHNICAL SKILLS:

OBIEE Infrastructure: OBIEE 11.1.1.7, OBIEE 11.1.1.6, OBIEE 10g

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

ETL Tools: Knowledge in Informatica Power Center9.0, InformaticaPower center8.6.1, DAC 10.1.3.4.1, ODI 11g

Languages and Web Technologies: SQL, PL/SQL, Java, C, C++ XML, HTML/XHTML, TOAD, SLA

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

RDBMS: DB2 UDB (8.x and 7.x), Oracle11g /10g, MS-Access, SQL-Server 2008, Hyperion System 9 Essbase

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

Methodologies: Software Development Life Cycle (SDLC) -Waterfall ModelAgile Methodology, Rational Unified Process (RUP)

PROFESSIONAL EXPERIENCE:

Confidential, Indianapolis, IN

Sr. OBIEE/BI Publisher Developer

Responsibilities:

• Worked with Business Analysts and key business contacts to translate functional and technical specifications into a comprehensive reporting design.
• Designed, Developed, Tested and Maintained BI Publisher reports and supported all aspects of Oracle BIP report development in support of information sharing and application development initiatives.
• Assessed the customer needs utilizing a structured requirements process (gathering, analyzing, documenting, and managing changes) to assist in identifying business priorities and provided advice on options.
• Experience on installation and setup of the Bi Publisher desktop version and OBIEE 11g.
• Trained the end clients by providing the required material and conducting sessions.
• A key contributor in creating and supporting standard and ad hoc reports to IT and Business Units & Senior Management.
• Designed and developed Data Models, Datasets templates, final reports and documents from multiple data sources.
• Worked with LOV's, Parameters, Bursting and configuration of delivery options for reports.
• Worked extensively with RTF templates and Sub templates for developing the reports as per the business requirement.
• Also worked with the interactive reporting online using BIP tool and extracted the output in various forms like HTML, PDF, excel file.
• Has good Knowledge of scheduling report jobs.
• Designed, programmed, tested, debugged, maintained and documented hardware/software for an advanced level of projects to meet business application needs interpreting policies, procedures and guidelines.
• Experience in developing complex BI Publisher reports and have good Oracle SQL experience.
• Prepared detailed design document for specifications from which the reports are designed, tested, debugged.
• Performed maintenance, tuning and troubleshooting on existing and newly developed BI Publisher Reports.
• Worked with project managers, developers, and end users to ensure BI Publisher Reports and SQL design specifications meet the customer's business requirements support technical design activitiesrelatedtodata,databases.

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. BI Publisher 11.1.1.6.12, Oracle 10g, Windows XP, SQL plus, Toad, Windows 2003, MS Office, Adobe.

Confidential, Westlake Village, CA

Sr. OBIEE Developer

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.

Confidential, Gahanna, OH

OBIEE Developer

Responsibilities:

• Installing OracleBI Analytics and configuring the connection parameters with SQL Server, Oracle 10g.
• Created/Modified Metadata repository (rpd) as per the data requirements by using OracleBI Analytics Server Admin tool.
• Independently Designed and developed subject areas in the RPD(Physical, BMM and Presentation layer)
• Defined appropriate joins, calculations, dimensions and measures in the repository.
• Created Repository Users/ Groups and Web Groups and assigned permissions to the user groups to define security in the repository.
• Involved in Data Modeling, Design Documents, and data warehouse.
• Conducted project planning and work estimations.
• Responsible for supporting and enhancements for the existing projects in OBIEE.
• Updated the RPD layers and OBIEE reports upon modifications.
• Hands on experience in data warehousing technologies including ETL, Oracle BI Server architecture, and metadata management.
• Mapped different data sources to the Physical Layer and created the Business Model and Mapping Layer (design of hierarchies, dimensions, and aggregates).
• Created Snowflakes and Star Schema to perform data modeling for proposed architecture.
• Created and customized various Reports and Dashboards for various user groups.
• Designed various reports as per the requirements for user interface design like Drill Down, Pivot, Break down Reports, Narrative and Nested reports in Answers.
• Created reports with different views (Compound, Chart, Table, Pivot, Ticker and Narrative).
• Created materialized views to fasten slower queries with complex joins in them.
• Identified Data Sources (Oracle BI& Enterprise DW) & Extension columns - Identified OracleBI OLTP tables, fields, Map them with Staging Tables and finally map them to OLAP’s Physical layer tables/schemas.
• Developed and scheduled iBots for delivering personalized reports to users on time.
• Secured Dashboards and Reports by defining user roles.
• Participated in the implementation of any OBIEE product upgrades. Performance tuning ETL mappings and Reports
• Implemented OBIEE security at the data and object levels.
• Manage/modify database security and database schema.
• Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Created/designed functional and technical documentation for Reports, RPD and Informatica mappings.
• Applied Optimization techniques and tuned performance of the reports such as caching and building summary tables.
• Supported business operations via OBIEE including: investigating defects or issues .
• Identified the gaps between user requirements and existing applications - Primarily the Finance App.
• Done data migrations using Import/Export, FTP, Database Links and SQL*Loader.
• Trained End Users to Build Ad Hoc Reports using OBIEE.

Environment: OBIEE 10.1.3.4, Informatica 8.1, PL/SQL, TOAD and Windows.

Confidential, Chicago, IL

OBIEE Developer

Responsibilities:

• Gathered information by interacting with clients and end users.
• Involved in full Life Cycle Implementation of OBIEE.
• Involved in requirement analysis, designing of Data Warehouse, populating Warehouse using Informatica ETL, Design and implementation of custom business intelligence solutions (Metadata and Dashboards/Reports) using the Oracle Business Intelligence (OBI) Analytics platform.
• Performed the detailed design implementation and testing of Reports/Dashboards and Analytical Data Model (Metadata/rpd).
• Designed and built Starschemas/snowflake schemas upon requirements.
• Configured repository (RPD) to use the LDAP authentication.
• Define the mapping from various physical databases to Business Layer to create the various subject areas in Presentation Layer.
• Defined dimensions and facts in the subject areas.
• Implemented OBIEE security for users and groups in administrator tool.
• Created reports by applying views, filters, calculations and conditional formatting in answers.
• Designed Intelligent Dashboards for different user groups to view updated KPIs.
• Created and scheduled iBots as per the business requirements.
• Participated in the Modeling of several multidimensional Data Marts including surrogate key design and index placement.
• Created the source and target instances and various transformations (Joiner, Aggregate, Lookup, Filters and Router Transformations) in Informatica and also created mappings, sessions and workflow to run ETL process using Informatica Power Center.
• Used DAC (Data Warehouse Administration Console) Client to manage, configure, customize and monitor ETL process.
• Applied Optimization techniques and tuned performance of the reports.
• Provided technical and user documentation and . Created Dashboards on Pharma Sales Analytics.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Worked in the development of OLAP Databases and Structures used in the Health Care sector.
• 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.
• Migrated the tested code of Repository, Dashboard reports, and OW Mappings and Workflows from Development to QA and from QA to Production Environments.

Environment: OBIEE 10.x, Informatica Power Center 7.1.3, Oracle 10g, TOAD, Teradata and Windows 7.

Confidential

OBIEE Consultant

Responsibilities:

• Gathered Business Requirements by interacting with IT and documented them unambiguously as System Requirements Specifications (SRS) combination of (FR/NFR).
• Created Highlevel 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 Materialized Views.
• 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.