PROFESSIONAL SUMMARY:

• Over 7 years of expertise in OBIEE 12c, OBIEE 11G/10G, BI Publisher and BI administrator
• Implemented Object Level Security for the objects like Dashboards and Reports, and Data Level Security using Session Variables.
• Configured LDAP security in Console for the newly created provider as per as the business rules.
• Played major role in upgrading from OBIEE 11.1.1.6.12 to OBIEE 12C.
• Valuable knowledge 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.
• Strong experience in configuring and developing the Analytics/OBIEE Repository (RPD), which involves Schema Import, Implementing the Business Logic by customization, DimensionalHierarchies, Utilities, Subject Areas etc.
• 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.

TECHNICAL SKILLS:

OBIEE Infrastructure: OBIEE 12c, 11.1.1.7, OBIEE 11.1.1.6, OBIEE 10g OBIEE Applications OBIA7.9.6.3, 7.9.6.1(Financial analytics, HR Analytics, Sales, Service, Marketing)

ETL Tools: Knowledge in Informatica Power Center9.0, Informatica Power 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 - Dallas, TX

Sr. OBIEE/ODI Developer

Responsibilities:

• Worked on Oracle Enterprise Manager to activate and Deploy RPD.
• Extensively used Catalog Manager for migrating Web Catalog.
• Worked in developments of analytics Reports using OBIEE Answers and assign them to specific Dashboards with Oracle Financials EBS as source of data from the modules like AP, GL and FA
• Experience in installing, maintaining, upgrading and patching Golden Gate.
• Worked on the RPD for the new Subject area design for the Cash flow Metrics Created Reports, Dashboard Prompts and Dashboard Pages like - Budget and Actual, Balance Sheet.
• Responsible for designing, developing and testing of the ETL strategy to populate the data from various source systems (Flat files, Active Directory-LDAP, SQL Server and Oracle).
• Created Repositories, Agent, Contexts and both of Physical & Logical Schema in Topology Manager for all the source and target schemas.
• Installing ODI 11.1.1.6 on all the environments and configuring ODI.
• Patching ODI 11.1.1.6.0 to 11.1.1.6. and Upgrading ODI from 10.1.3.4 to 11.1.1.6.4.
• Testing the newly upgraded ODI 11G and ODI 12C fixing issues related to upgrading and running ODI jobs as per schedule.
• Created ODI Procedure, ODI Package, ODI Variables, ODI Scenarios, ODI Functions, ODI Mappings, ODI Load Plans.
• Created the users, profiles using the ODI security manager.
• Financial Planning Manager and other developers
• As an administrator, I was responsible for security across multiple users and groups.
• Created Packages, Scenarios and Load Plan Components, Load Plans using ODI.
• Generated Load Plans and Executed Integrated Testing over Payroll Subject Area using ODI.
• Provide ad hoc ability in the OBIEE system for query and build reports.
• Configured the OBIEE repository (Physical, BMM and Presentation layer)
• Created dimension hierarchies and aggregates in the BMM layer.
• Customized reports in OBIEE answers and integrated them into the Dashboards according to the Business requirements.
• Performed Data Validation of data in the reports and dashboards.
• Unit, integration and system testing for all components of ETL and reporting. Prepared test cases and documented the results.
• Created PL/SQL stored procedures, functions and triggers for change data capture(CDC).
• Creating standalone agent on windows server.
• Implemented CDC through ODI Journalization Knowledge Modules (KMs).
• Developed Expressions, filter, joins, Split, Variables, user functions Using ODI
• Developed interfaces for loading the lookup and transactional data.
• Developed interfaces to load the data from flat files, SQL Server to stage and from stage to Oracle HUB.
• Created Dynamic and Session Variables and Performance tuned the ODI interfaces.
• Changed knowledge modules using Java code for AP/AR for General Ledger tables in ODI.
• Performance Tuning of Reports and made required changes to repository and database.
• Complete responsible for preparing the END to END Document.
• Working on UAT data and hierarchy issues.
• Worked with the team and a DBA to communicate and negotiate data needs.

Environment: ODI 11.1.1.5.0 , ODI12c, WebLogic Server 11.x, OBIEE 11.1.1.6.5 , OBIA 7.9.6.3, Oracle EBS, Oracle 12c, SQL*PLUS, SQL Developer, Windows XP.

Confidential, Westlake Village, CA

OBIEE/ODI DEVELOPER

Responsibilities:

• 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.
• 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.
• 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, EBS,Toad, Putty, Linux

Nordstrom - Seattle, WA

OBIEE Developer

Responsibilities:

• Worked with Business analysts as well as other business teams on requirement gathering. Installed OBIEE 11g on Oracle Solaris 10. Configured Single Sign On (SSO) on OBIEE 11g
• Involved in deploying OBIEE 11g objects from one environment to another environment.
• Involved in Creation & Configuring of the OBIEE Repository from scratch using best practices (physical, BMM, and presentation layers). Involved in creation of Level Based Hierarchy & Parent child Hierarchy to meet business requirements.
• Designed & Created Agents, Delivers for the purpose of scheduling OBIEE Reports via Email to End Users. Involved in creation of Logical Columns, Hierarchies, Aggregate columns & tables, Level Based Measures, Multiple LTS.
• Created Time- Series calculations using AGO and TODATE functions on BMM layer of Repository.
• Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE Answers to build the query.
• Developing Calculated Measures and assigning these Aggregation levels based on Dimension Hierarchies.
• Involved in writing complex SQL queries in SQL Developer for Data Analysis & Validation.
• I supported all the technical issues of Interactive Voice Response (IVR) which offers AT&T customers a self- service system for obtaining account balances and last payment recorded, make payments, obtain technical assistance, and listen to instructions on voice mail.
• Ability to work independently, self-motivated, with excellent verbal communication skills.

Environment: OBIEE11.1.1.X, Oracle 11g, Web logic 10.1.X, Informatica 8, BI Publisher, Unix/Solaris, TOAD, MS Visio, SQL plus, PL/SQL.

Confidential, Chicago, IL

OBIEE Developer

Responsibilities:

• Worked closely with Business Users and Functional Analytics in understanding the Analytics requirements and to identify and refine business requirements and translate Design Specifications in to Design Document.
• Created/Modified Metadata repository (. rpd), Customized BI Repository, defined/developed Physical Data Layer, Business Model and Presentation Layer using BI Administration Tool.
• Configured OBIEE Repository like implementation of physical data model as per requirements, importing the tables and having the physical joins/keys required and changed the physical joins/key on the existing tables.
• Configured facts, dimensions and Hierarchies and do the following calculation in Logical layer
• Developed Time Series Objects using Ago and to Date functions for time series comparisons
• Created aggregate tables for Fact at Brand/Plan-to Party/ Period level in database and imported and configured it in Admin tool.
• Created reports and Dashboard as per the business requirement.
• Installed OBIEE 11g in Dev& Functional Test Box.
• Configured Agents to deliver Analytics content based on schedule, automated agents query to obtain daily and weekly reports.
• 10g Rpd & Web-Catalog has been upgraded to 11g.
• Modified all the OBIEE Security that has been completely changed from the9i previous Versions 10g to the newer version of 11g.
• According to the new security setup - Refreshed all the (GUI's) Global Unique Identifiers of the users to login to the OBIEE 11G Analytics.
• Created all the users and groups in the Web Logic Administration console, assigned all the users to the required groups.
• Created Application Roles and policies in the Fusion Middleware Enterprise Manager and added the users.
• Created multiple roles and added for all the WFS customizations dashboards.
• Performance Tuning of Repository and Reports by setting Cache, limiting the number of initialization blocks, limiting select table types, pushing the calculation to the database, setting the NQSConfig.ini parameters
• Localized Oracle BI for business users to support globalization for deployment (Development/QA /Production).
• Performed Unit testing and System Integration Testing to Validate the Report

Environment: OBIEE 11.1.1.5.0 , Web Logic Server 10.3.3, OBIEE 10.1.3.4.1 , Informatics Power center 8.6.1, Oracle 11g, SQL Developer, Windows XP, Linux

Confidential

OBIEE Developer

Responsibilities:

• Requirement gathering from Business user's /end-users and develop a layout plan.
• Work extensively for supporting and enhancements of OBIEE.
• Involved in project planning, work estimations, Architecture design and development methodology.
• Test Dashboard's functionalities and validated data before publishing reports to users.
• Customize and created permission to dashboard per employee to their responsibilities.
• Analyzed, diagnose and provide helpful insight to improve security.
• Worked extensively on OBIEE Answers to create the reports as per the Business Requirements.
• Created new reports and troubleshoot OBIEE issues at the Report, rpd and modified existing Reports, to meet new requirements.
• Responsible for unit testing, integration testing of the generated reports.
• Involved in improving the performance of the Dashboards and Reports by modifying rpd.
• Preparation of Reports standards, report templates, and prepared custom made BI solution according to the plan using BI applications.
• Work with DBAs and System Support personnel in elevating and automating successful code to production.
• Designing custom web portal architecture to display the report in web report viewer using visual studio 2010.
• Train and manage developers, advising other groups in organization on ETL development and Data Warehouse development.
• Conduct code walkthrough and reviewing and approving code and documentation for project manager review.
• Conducting weekly project meeting to analyses the technical issues.
• Provide on-call support to production system to resolve any issues.
• Version control through Visual Source Safe / Team Foundation Server.
• Object Export and Import from development to testing environment.
• Proof-of-Concept development, documentation and presentation to the client.

Environment: OBIEE, Informatica Power Center 9.1/8.6, DB2, Power Exchange 8.1, Oracle 10g/11g, SQL, PL/SQL, TOAD, Erwin