We provide IT Staff Augmentation Services!

Obia/obiee Consultant Resume

Los Angeles, CA

PROFESSIONAL SUMMARY:

  • I am a Senior OBIEE/OBIA/ODI Consultant with 7+ years of experience in gathering requirements, designing, implementation, building, testing and customizing the OBIEE 10g/11g/12c and OBIA 7.9.6.x, OBIA 11.1.1.8.1 , Oracle Data Integrator 10g/11g/12c. I have around 5 years of experience in implementing the OBIA/ODI finance and HR analytics modules using E - Business suite as source system. I have good experience as an OBIEE Technical which includes managing the releases in the recent projects. I also have vast experience writing Technical documentation as a Technical Analyst as well as preparing and presenting the User Training Manuals. I have experience in managing the offshore teams as a mentor and in setting up and training the offshore team. I am a very good team player and a quick learner. I have good communication and interpersonal skills. I am a quick learner and am open to new ideas. I not only remain motivated all the time but also motivate the team members by my abilities.
  • Good working experience in Upgrade OBIEE environments from lower version to higher version. i.e. OBIEE 10g to 11g, 10.1.3.4 to 11.1.1.5, 10.1.3.4 to 11.1.1.6, 11.1.1.3 to 11.1.1.5 and 11.1.1.5.4 , 11.1.1.7, 11.1.1.9. To 12.2.1.0 and and WebLogic server.
  • Experience in implementing end-to-end of various functionalities of Data Warehouse, Data Marts, and Business Intelligence and Transactional applications.
  • Good experience in web logic administration for system management and fusion middleware control for monitoring the java and system components.
  • Deploy the RPD files, enabled/disabled cache parameters, performance setting and restart the OPMN services in EM.
  • Worked on cache management which deals with purging & seeding the cache, enable the cache etc.
  • Migrate the repository and presentation catalog between different environments like Dev, test, QA and maintenance.
  • Worked with maintenance team by creating scripts like kill the process, moving the logs, Restart services, Load average, long running queries and also setting up the Cronjobs for every week to recycle the OBIEE server.
  • Configured active directory to the shared services and import all the users from the directory by using filter.
  • Enabled usage tracking in OBIEE 11g which would help to track the Application usage.
  • Supports 24*7 and coverage weekend outage (DB, Linux, patching) Activities.
  • Expertise in design and development of Oracle Business Intelligence (OBI) Administration tool Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, configuring Interactive Dashboards with drill-down capabilities using global and local Filters, Security Setup (Data Level and Object Level using Oracle BI repository security), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
  • Extensive experience in providing end-to-end business intelligence solution by dimensional modeling design, building business models, configuring metadata, Answers, Delivers/iBots, creating Reports/Dashboards, cache monitor, and building OBIEE Repository.
  • Performed OBIEE System Administration Tasks like granting privileges, creation of custom, complex and summary folders, linking folders for Drill-to detail, Configuration of system for deployment, Starting and Stopping services, managing and resolving services, migration of rpd and web catalog from test to production, backing up metadata.
  • 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. Extensively used OBIEE Delivers and iBots.
  • Configured LDAP server to Authenticate users and implemented both object level and data level security based on roles and responsibilities.
  • Implemented Data Level Security, Object Level Security and LDAP authentication.
  • Worked on OBIEE security like configuring LDAP authentication, creating users and groups etc
  • Worked on security management for users, groups and web groups using the various authentication systems such as LDAP, OS, Database and Database Table Authentication using Session Variable features, as well as Dashboard/ Report level security.
  • Experience in RPD, Data Modeling, ETL, OBIEE/BI Publisher, Siebel Analytics, Web Catalog. and OBIEE star schema.
  • Experience in Security Setup at both Object and Data levels, which involved creation of users/ groups, Access privileges.
  • Administering the OBIEE Dashboards and Reports, Data Visibility.
  • Extracted data from different sources like Oracle Tables, views and flat files, Hyperion implemented Business logic and loaded into target warehouse (Oracle).
  • Good understanding of ODI architecture and installation of Topology, Security Manager, agents, Designer, Operator, Master repository and Work repository.
  • Experience in ODI designer, Topology, Operator, Master repository and work repository creation.
  • Worked in Interface creation, Packages, Scenarios, Variables, Sequences, Procedures and User Functions in ODI.
  • Worked for different concepts like pivoting and parallel job execution in ODI, scheduling jobs and load balancing in ODI.
  • Experience in ETL Informatica 8.x/9.x mappings and ODI 11g Interfaces.
  • Used ODI 11g/12c for extraction, loading and transformation ETL of data in the data warehouse.
  • Used Yellow Interfaces Reusable mappings in ODI 12c for developing most complex interfaces.
  • Design and implement ODI Extract, Load and Transform (ELT) processes, programs and scripts.
  • Strong development experience in ODI11g, 12c, Oracle SQL and PL/SQL.
  • Implemented Single Sign On (SSO) on the existing OBIEE environment by integration with Site Minder, Editing the credentialstore.xml files and getting the rpd groups in sync with Database roles was part of it.
  • Successfully implemented Windows Authentication, SSO for OBIEE.
  • Configured and implemented the AD External Authentication using SSO.
  • Worked on providing SSO access to BI Publisher reports on OBIEE dashboards.
  • Performed configurations for OBIEE Multi User Development MUD, Usage tracking, iBot scheduling, Security Model using LDAP authentication.
  • App. Servers: WebLogic Application Server, Oracle Application Server.
  • Worked on WebLogic in obiee 11g to create users and groups.
  • Experience in OBIEE11g Security LDAP Security Implementation with Microsoft Active Directory and configuring the OBIEE Scheduler to deliver the emails.
  • Configured OBIEE security with active directory in security manager.
  • Worked in SCD TYPE1, TYPE 2 and CDC implementation.
  • Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
  • Worked on designer tool for developing the mappings using Transformations like Source Qualifier, Expression, Filter, Aggregator, Lookup, Update Strategy, Sequence generator, joiner and Router Transformations etc.
  • Created Informatica Mappings and Mapplets using active and passive transformations.
  • Developed mappings using Informatica Power Center Designer to load data from various source systems to target database.
  • Worked on Data Warehouse Administration Console (DAC 10.1.3.4) for scheduling and executing Incremental ETL loads.
  • Experience of Oracle Data Integrator 11.1.1.7.1 , Business Intelligence Application Configuration manager 11.1.1.8.1 and Functional setup manager.
  • Excellent problem solving skills with strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet deadlines and work under pressure.

TECHNICAL SKILLS:

Oracle Business Intelligence: EE 10x/11x/12c (Administrator, Presentation Services, Delivers, iBots).

Oracle Business Intelligence Applications: 11.1.1.9.x, 11.1.1.8.1 , 7.9.6.X. SSO Authentication.

Oracle Data Integrator: 11g, 12c, Informatica 9.1 (Power Center). Active Directory.

Data warehouse Administration: Console (DAC) 10g/11g, Oracle 12c/11g/10g/9i/, SQL Server. WebLogic Server 11gR1 PS3, SQL, PL SQL, TOAD, SQL plus, Windows 95/98/NT/2000, UNIX, Linux.

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

OBIA/OBIEE Consultant

Responsibilities:

  • Gathered the business requirements by interacting with the business users for the Points System.
  • Installation and Configuration of OBIEE 11G, 12C, OBIA, ODI, OBIEE applications.
  • Involving the Application development, Application configuration, setting up Application, Migrating Applications.
  • Co-Ordination with DBA/other support teams for planned/unplanned outages.
  • Log Monitoring on OBIEE Analytics, BI Scheduler Server and Presentation Servers Include WebLogic Server.
  • Raising and tracking service requests with Oracle Corporation on BI related issues.
  • Applied oracle patches to fix the existing bugs in application.
  • Providing support to user in order to resolve system and application related issues.
  • Monitoring the obiee server components.
  • Taking server performance report for all OLTP servers daily hourly basis.
  • Designed and developed the OBIEE Analytics Metadata Repository (.rpd) using OBIEE Server Admin tool by importing the required objects (Dimensions, Facts & Aggregates) with Referential Integrity constraints into Physical Layer using connection pool, developing multiple dimensions (Drill-down Hierarchies) & Logical & Facts Measure objects in Business Model Layer, and creating Presentation Catalog in Presentation Layer.
  • Involved in the Metadata Designing which includes customizing like design, configure, and document logical and Physical Data Models, Presentation Layer the repository according to the business requirements.
  • Design and Implement data in various layers including physical, business and presentation.
  • Implemented comprehensive security functionality - created users & web groups, external table security using session variables, tested and validated model using BI Admin tool and associated catalog objects & Web modules with the created users / groups to data and object level security.
  • Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.
  • Setup ODI 12c - upgrade existing ODI 11 -- Integrate with OWB.
  • Backing Up Your Existing ODI 11g Environment
  • Upgrading the Database Containing the ODI Repository.
  • Cloning Existing Master and Work Repositories ODI 11G.
  • Installing Oracle Fusion Middleware ODI 12c Products.
  • Upgrading Your Master and Work Repository Schema.
  • Created ODI design documents from the existing Informatica mappings. Used these design documents in development of ODI interfaces/packages.
  • Created ODI (Sunopsis) interfaces for loading the data from Sybase to CDW and from CDW to different Marts.
  • Participated in code reviews. Did code promotions from dev to test, staging and production environment using ODI.
  • Wrote unit test cases, test scenarios, unit test documents and also verified the test scenarios of the QA team. Unit tested for all the possible test scenarios.
  • Helped QA team in writing the appropriate test scenarios.
  • Did error analysis for continued improvement of the system by catching data anomalies and code issues.
  • Planning and prioritizing the tasks to meet the deliverable deadlines.
  • Participated in all the phases of project - development, testing, deployment and support.
  • Used Oracle analytic functions, global temporary tables, etc
  • Worked extensively with ODI Designer, operator and metadata Navigator.
  • Used ODI 11g/12c for extraction, loading and transformation ETL of data in the data warehouse.
  • Worked on Web logic in obiee 11g to create users and groups.
  • Implemented Single Sign On (SSO) on the existing OBIEE environment by integration with Site Minder, Editing the credentialstore.xml files and getting the rpd groups in sync with Database roles was part of it.
  • Successfully implemented Windows Authentication, SSO for OBIEE.
  • Configured and implemented the AD External Authentication using SSO.
  • Configured LDAP server to Authenticate users and implemented both object level and data level security based on roles and responsibilities.
  • Implemented Data Level Security, Object Level Security and LDAP authentication.
  • Worked on OBIEE security like configuring LDAP authentication, creating users and groups etc
  • Worked on providing SSO access to BI Publisher reports on OBIEE dashboards.
  • Worked in connecting the system to an external set of database tables that contain the group membership for users authenticated through Active Directory.
  • Experience in OBIEE11g Security LDAP Security Implementation with Microsoft Active Directory and configuring the OBIEE Scheduler to deliver the emails.
  • Configured OBIEE security with active directory in security manager.
  • Supports monthly schedule activities for moving the code from dev to stage and production Environments.
  • Raising/Attending techinical discussions through bridge calls along with other teams for root cause analysis including identification, resolution, escalation, referral and follow-up with vendors.
  • Monitoring the OBIEE server and components.
  • Experience in trouble shooting issues on the server side and presentation side.

Environment: OBIEE 12.2.1.0, 11.1.1.9.0 , BIAPPS 11.1.1.9.x, Oracle Data Integrator 11.1.1.9.0 , Active Directory, Siebel 8.1, Linux.

Confidential, Rockville, MD

OBIA/OBIEE CONSULTANT

Responsibilities:

  • Installation and Configuration of OBIA/ODI/OBIEE 11G and 12C.
  • Built EL-T ODI processes to demonstrate ODI functionality.
  • Worked with the business analysts to identify and refine business requirements, create the technical architecture, environment necessary to support the business requirements and lead offshore team for development and testing.
  • Planning the implementation, documenting the functional specification documents, technical specification documents and test case documents for the business processes identified.
  • Designed and developed the OBIEE Analytics Metadata Repository (.rpd) using OBIEE Server Admin tool by importing the required objects (Dimensions, Facts & Aggregates) with Referential Integrity constraints into Physical Layer using connection pool, developing multiple dimensions (Drill-down Hierarchies) & Logical & Facts Measure objects in Business Model Layer, and creating Presentation Catalog in Presentation Layer.
  • Created Oracle BI Answers Requests, Oracle BI Interactive Dashboard Pages and Prompt
  • Implemented comprehensive security functionality - created users & web groups, external table security using session variables, tested and validated model using BI Admin tool and associated catalog objects & Web modules with the created users / groups to data and object level security.
  • Extensive Experience on Topology Navigator with developing ODI Physical and Logical Architecture, Contexts and Configuring Agents.
  • Setup ODI 12c - upgrade existing ODI 11 -- Integrate with OWB.
  • Backing Up Your Existing ODI 11g Environment
  • Upgrading the Database Containing the ODI Repository.
  • Upgrading Your Standalone Agent Environment (no WebLogic Domain).
  • Upgrading Your Standalone Agent Environment (with WebLogic Domain).
  • Troubleshooting Your Upgrade.
  • Primary responsibility includes installing and configuring the Oracle Data Integrator ODI software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ETL.
  • Created and Configured ODI Repositories, Interfaces, Packages, Procedures and Scenarios.
  • Extensively used ODI to load data from Oracle, XML files and flat files
  • Increased performance of loads by applying proper Hints, Indexes, and Analyzing master tables and explain plans to check cost.
  • Worked closely with the end users/business and designing the documents to the track changes.
  • Coordinated with the on-site and off-shore team and working on service requests as team.
  • Used Oracle Data Integrator ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database and Oracle EBS interface tables.
  • Experience in ODI designer, Topology, Operator, Master repository and work repository creation.
  • Prepared detailed design for the ELT & PLSQL part of the system
  • Worked in Interface creation, Packages, Scenarios, Variables, Sequences, Procedures and User Functions in ODI.
  • Worked for different concepts like pivoting and parallel job execution in ODI.
  • Involved in Performance tuning for the jobs in ODI.
  • Scheduling jobs and load balancing in ODI.
  • Extensively involved in production issues.

Environment: OBIEE 11.1.1.9.0 , BIAPPS 11.1.1.9.x, Oracle Data Integrator 11.1.1.9.0 /12C, EBS R12.1.3, Oracle 11g, Oracle E-Business Suite, UNIX, Windows.

Confidential, Woodbridge, NJ

Sr. OBIA Consultant

Responsibilities:

  • Gathered requirements, documented and delivered functional specification documents and configured CRM to meet requirement.
  • Interacted with business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications.
  • Design and implement ODI Extract, Load and Transform (ELT) processes, programs and scripts.
  • Design of data warehouse tables, including source to target mappings, configuration of ODI knowledge modules…etc.
  • Develop and document the ODI ELT process. Help in Creation and maintenance of the source to Client data mappings.
  • Extracted data from different sources like Oracle Tables, views and flat files, Hyperion implemented Business logic and loaded into target warehouse (Oracle).
  • Experience in ODI designer, Topology, Operator, Master repository and work repository creation.
  • Prepared detailed design for the ELT & PLSQL part of the system
  • Worked in Interface creation, Packages, Scenarios, Variables, Sequences, Procedures and User Functions in ODI.
  • Worked for different concepts like pivoting and parallel job execution in ODI.
  • Involved in Performance tuning for the jobs in ODI.
  • Scheduling jobs and load balancing in ODI.
  • Created different schemas in database using oracle 11g to configure the different objects implementation.
  • Worked in SCD TYPE1, TYPE 2 and CDC implementation.
  • Performed OBIEE System Administration Tasks like Configuration of system for deployment, Security privileges like Object level & Data level, Starting and Stopping services, managing and resolving services, migration of rpd and web catalog from test to production, backing up metadata.
  • Worked on OBIEE Object Level Security by creating users, Groups & Roles.

Environment: OBIEE 11.1.1.7.1 3, OBIA 11.1.7.1, Oracle data Integrator 11.1.7.1, EBS R12.1.3, SQL Developer, Red Hat Linux.

Confidential, Clifton, NJ

OBIEE Developer

Responsibilities:

  • Gathered the business requirements by interacting with the business users for the Points System.
  • Involved in rationalize and identify report and KPI requirements and develop in respective platforms.
  • Working with migration of repository (.rpd) and cache management.
  • Worked on OBIEE Predefined work related to development of S&OP analytics (RPD, Reports & Dashboards etc...).
  • Automation of schedule scripts to ease of server administration.
  • Providing support to user in order to resolve OBIEE system and application related issues.
  • Review the migration request from various project teams and perform the migrations of the object across environments.
  • Configured Usage Tracking.
  • Responsible for contributing to overall project objectives and specific team deliverables.
  • Involved in creation of Reports using different Analytics Views (Pivot Table, Chart, and Column Selector).
  • Implementation of data level and object level security.
  • Enhancing the subject areas as and when suggested by the business analyst.
  • Involved in Organizing Presentation layer in a format that is easy for end users to use as basis for reporting.
  • Created complex dashboards and reports.
  • Developed multiple reports and used value interaction to navigate to other reports.

Environment: OBIEE 10.1.3.4.1 , Informatica Version 8.6, DAC Version is 10.1.3.4.1 ), Source System is EBS (11G), Oracle DB 11g, Red Hat Linux.

Confidential

OBIEE Developer

Responsibilities:

  • Gathered the business requirements by interacting with the business users for the Points System.
  • Providing support to user in order to resolve system and application related issues.
  • Supported Monthly scheduled activities.
  • Review the migration request from various project teams and perform the migrations of the object across environments.
  • Experience in trouble shooting issues on the server side and presentation side.
  • Daily performing check list activities monitoring / maintenance of BI servers.
  • Experience in troubleshooting issues on server and presentation side.
  • Experience in migration techniques for OBIEE components into various test and production environments.
  • Extensive knowledge of Merging the RPD’s from different teams.
  • Designed and developed the OBIEE Analytics Metadata Repository (.rpd) using OBIEE Server Admin tool by importing the required objects (Dimensions, Facts & Aggregates) with Referential Integrity constraints into Physical Layer using connection pool, developing multiple dimensions (Drill-down Hierarchies) & Logical & Facts Measure objects in Business Model Layer, and creating Presentation Catalog in Presentation Layer.
  • Involved in the Metadata Designing which includes customizing like design, configure, and document logical and Physical Data Models, Presentation Layer the repository according to the business requirements.
  • Developed Dimensional Hierarchies for Drill Down, Level Based Measures and Time Series Functions (AGO and TODATE functions) based on the Requirements.
  • Implemented Security by creating roles & web groups, checks with External tables and LDAP.
  • Testing the repository by using various techniques for yielding the correct results or not. Performed the regression testing on the Subject areas, dashboards and validated the build in production environment.
  • Manage Tickets raised in Service center (Internal Server which was developed by Peregrine Systems, Inc. )

Environment: OBIEE 10.1.3.4.1 , Informatica 8.6, DAC Version 10.1.3.4.1 , Oracle Database 10 G, Source System is EBS (11G), windows server 2000.

Hire Now