SUMMARY:

• Over 7+ years of involvement in planning, creating and execution of OBIEE 10g, 11g & 12c and 3 years in ODI 11g
• Strong experience in configuring and developing the Analytics/OBIEE Repository (RPD), which involves Schema Import, Implementing the Business Logic by customization, Dimensional Hierarchies, Utilities, Subject Areas etc.
• Experience of OBIEE 11g and also having hands on experience in OBIEE 10g in integration with BI publisher Extraction, Load and Transformation (ELT) using Oracle Data Integrator (ODI) 11g, Informatica 9.x/8.x/7.x and SQL, PL/SQL.
• Making and tweaking dashboards and reports to meet client prerequisites. 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.
• Administration of OBIEE and the OBIEE Web Catalog.
• Experience in incorporating BI Publisher with OBIEE.
• Installation, configuration of ODI in Unix/Linux environments.
• Proficient in Oracle, SQL, MS/SQL.
• Excellent relational abilities, administration aptitudes, group abilities with result arranged mentality.
• Excellent communication skills, strong architectural skills, hardworking and a good team player.
• 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 supporting performance tuning and process tuning at all levels.
• Experienced in configuring Usage Tracking and Multiuser Development Environment (MUDE).
• Good Exposure in dimensional demonstrating.
• 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.
• Expertise in installing, configuring, and administering WebLogic Server in various environments.
• Implemented the extraction, loading, and transformation (EL - T) of data using Oracle Data Integrator.
• Expertise with all ODI graphic tools - Topology, Security Manager, Designer and Operator and configuring the ODI master and work repositories, ODI models defining and organizing the ODI project including interfaces, packages, procedures, variables and user defined-functions.
• Hands on experience working with ODI Knowledge Modules- LKM, IKM, RKM, JKM and CKM. Customized versions for the existing ODI Knowledge modules which can be re-used in data integration projects.
• Expert ability to trouble shoots and prioritizes issues.
• Excellent interpersonal and communication skills for efficient client interaction.

PROFESSIONAL EXPERIENCE:

Confidential,Milwaukee,WI

Sr. OBIEE Developer

• Performed the gap analysis, Identified Facts and Dimensions (with levels & hierarchy) and made required changes to the Data Model(Physical,Business and Presentation layer) .
• Implemented Write back functionality for GDW Project.
• Proposed road map for Oracle BI Application Analytics, Custom BI Analytics and OBIEE.
• Designed Oracle BIEE/Siebel Analytics CRM/EBS/PeopleSoft solutions on projects, three end to end Oracle BI project.
• Drove requirements to work effort estimation, project planning and implementation.
• Experienced in Out of the Box implementation Oracle BI Applications, implemented and deployed out-of-box OBIEE Analytics against Oracle EBS R11, R12 and PeopleSoft HCM 9.1
• Experienced in Extract, Transform, and Load (ETL) for prebuilt EBS Adaptors, full and incremental load to Oracle Business Analytics Warehouse (OBAW) .
• Experienced in configuring ETL metadata, including Informatica Source Analyzer, Designer, Mapplets, mappings, and workflows and DAC metadata.
• Experienced Informatica developing Source Objects and Target Objects including Source.
• Dependent Extract (SDE) and Source Independent Load (SIL) mappings.
• Performed preload configuration steps for BI Applications.
• Use Data Warehouse Administration Console (DAC) to configure execution plans, manage, and run ETL routines to populate the OBAW and monitoring the results.
• 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 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.
• Trained End Users and Pilot Users about OBIEE Tools.
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns .
• Used presentation variable in OBIEE Answers to save prompt values and use them for conditional formatting.
• Created Aggregate Level facts to improve the performance in the reporting needs.
• Worked with Cache persistence Wizard to efficiently handle cache.
• Developed Master Detail Report in OBIEE.
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
• Built the Physical Layer /Business Model and Mapping Layer of the Repository by using Star and snowflake Schemas.
• Defined dimensional hierarchies and associated the proper level of granularity to the fact table.
• Created new logical measures required as per the business requirements.
• Actively involved in OBIEE Admin activities .
• Created catalog folder in the presentation layer and setup visibility of the presentation catalog to users with respect to their responsibilities.
• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.
• Implemented different Caching techniques to improve the performance of BI server and performance tuning done at Database level, Repository level and Dashboard level to improve the efficiency of the system .
• Specified permissions that determine the folders and objects that users can view.
• Sorted data values, applied sorts to members, measures, and rows in views such as tables, pivot tables, graphs, and maps.
• Enhance performance of reports/dashboards by implementing the aggregate tables, and cache management .
• Developed Requests (Reports) in Oracle Answers for various KPIs i.e. market share, weekly bookings, year over year revenue.

Environment: OBIEE 11.1.1.7.1, OBIEE 11.1.1.6.2, BI Apps 7.9.6.4,Informatica 9.1,DAC 10.1.3.4.1, Oracle 11g, ODI 11g/12c, Bugzilla, Win XP Professional, UNIX - Solaris.

Confidential,Minneapolis,MN

OBIEE Developer

• Worked on the development of the Answers for the different executive dashboards.
• Developed Solution Designs and delivered to Development team after reviewing the solutions with Business.
• Actively involved in Administration activities (Repository and Catalog Migration from Dev to QA and QA to Prod environments, Security Setup and Installation setup).
• Developed OBIEE Data Marts (Ad hoc Reporting) for different clients based on the different business logics.
• Involved in OBIEE 10g to OBIEE 11g upgrade for both Repository and Catalog and ensure all the reports and dashboards running on OBIEE 10g is up and running on OBIEE 11g.
• Involved in patch upgrade of OBIEE 11g.
• Implemented security by creating users & groups, setting up External Table Authentication, creating Session Variables and Initialization Blocks and associated catalog objects and web modules with the created groups.
• Implemented Financial Analytics, Supply chain, Procurement and Spend Analytics.
• Integrated data from Finance and other enterprise systems and transformed data using ODI (ETL) .
• Managed and customized the ETL ODI loads, RPD and Web catalog metadata according to the reporting needs of the client.
• Designed the collections for AR Transactions, Claims, Disputes, Cash On Account, Credit Memo, Receipts at Risk information using Oracle BI.
• Designed the Month End Closing Mechanism for Accurate Finance Reporting of AR Credit using Oracle BI
• Assisted in setting up in ETL Solution to bring the data from Source system (AS400/SQL Server) to Oracle Data ware house.
• Used Heterogeneous sources in ODI like flat files and Oracle apps tables.
• Customized Dashboard pages like Overview, Asset usage, Financial Structure, Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard.
• Designed and developed mapping Interfaces using Oracle Data Integrator and directly pulling the data from AS400/DB2 and converting into RDBMS format.
• Worked on ODI Designer for designing the interfaces, defining the data stores, interfaces and packages, modifying the ODI Knowledge Modules (Reverse Engineering, Journalizing, Loading, Check, Integration, Service) to create interfaces to cleanse, Load and transform the Data from Sources to Target databases, created mappings and configured multiple agents as per specific project requirements.
• Created ODI Packages, Jobs of various complexities and automated process data flow.
• Used ODI Operator for debugging and viewing the execution details of interfaces and packages.
• Configured multiple Initialization Blocks with help of Repository variables for integrating the OBIEEwith an external application.
• Configure Ibots for sending alerts to different clients and users based on the access level
• Active interaction with the Business for driving through the project at various phases of the project.
• Installed OBIEE 11.1.1.5.x/ 10.1.3.4.1 across multiple environments supporting various clients.
• Setup Oracle BI Presentation and BI servers in windows environment.
• Configured Column and Dashboard Filters in OBIEE Requirement validation of the reports and drilldowns.
• Extensively worked on OBIEE/Siebel Analytics, Web catalog administration, and developed business reports and dashboards based on business requirements.
• Performed and used OBIEE data level securities - (RW) Row-Wise initialized Non system Session variables and a Logical Table Source (LTS) filter feature.
• Created logical tables and assigned levels and custom aggregation rules.
• Created group accesses and privileges for the Siebel Analytics Web reports.
• Created and managed different functionalities of Siebel/OBIEE such as Answers (combined reports, action link, Navigation link etc.) Catalog, Dashboard, Delivers (iBots), briefing book etc.

Environment: OBIEE 11.1.1.6.2, OBIEE 10.1.3.4, BI Apps 7.9.6.4, ODI 11g,DAC 10.1.3.4.1, Oracle 11g, Bugzilla, Win XP Professional, UNIX - Solaris

Confidential,Columbia,MD

OBIEE/ODI Developer

• Involved in complete life cycle implementation of Invoices Tracking Analytics Application made for the Accounting Team to monitor the invoices made to Point-of-Sale (POS) customers, Commercial / Business customers and third-parties.
• Interacted one on one with SME from Billing and Account Receivables departments and other key Business Users in gathering the Analytics / Reports Requirements.
• Worked with business analysts to understand and document business needs for decision support data.
• Played an active role strategizing the migration of development objects from the development server to production server.
• Worked closely with ETL Team for enhancement to Facts / Dimensions in developing the Initial and Incremental ETL process.
• Developed many Reports using different Analytics Views (Pivot Table, Chart, and Column Selector), Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer. Also created hierarchies, variables, and event poll strategies in the repository.
• Debugged the issues by capturing the SQL issued for the reports in manage sessions.
• Developed Performance Tuning Strategies for optimizing the performance.
• Involved in the installation and configuration of Oracle BI EE 10.x in the windows as well as the Linux environment.
• Organized testing schedules and test scripts. Managed execution and sign-off tests and also played an active role in product rollouts.
• Integrated DRM with ELT/ETL Tools
• Involved actively in understanding knowledge modules for the current business process and rewriting them in ODI.
• Involved in managing the data describing the information systems physical and logical architecture by using ODI Topology Manager graphical tool.
• Created database connections, schemas, etc., using Topology Manager
• Involved in ETL process of loading the data from XML file to database to build the performance by using ODI.
• Worked extensively in creating and modifying ODI Knowledge Modules (RKM, LKM, JKM, IKM, CKM, and SKM).
• Created documentation of details that is implemented in ODI objects such as interfaces, procedures, variables, packages.
• Performed Designing, Developing and implementing tasks of multiple ODI interfaces.
• Involved in developing and maintaining various Packages, Interfaces, Variables, and Models, which populated the Data into the Target Star Schema on Oracle Instances using ODI.
• Managed users and permissions in ODI Security manager.
• Worked with Oracle DBAs when creating master and work repositories for ODI.
• Configured ODI Agents on Windows server and tested them to execute and schedule ODI Scenarios.

Environment: OBIEE 10.X, ODI 10G, Siebel Analytics 7.x, Oracle 10g/9i, Toad, Putty, Linux

Confidential

OBIEE Developer

• 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 training. 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