We provide IT Staff Augmentation Services!

Obiee Administrator Resume

Rosemont, IL

SUMMARY:

  • Overall 7+ years of IT experience with expertise in Analysis, Design, Development, Implementation, Modeling, Testing, Reconciling, and support for Data warehousing applications.
  • Over 6+ years of IT experience in delivering Business Intelligence solutions by gathering requirements, analyzing, developing, testing, deploying Business Intelligence (BI) applications using OBIEE/Siebel Analytics and OBIEE Apps.
  • Very Strong Administration experience in OBIEE 12C/OBIEE 11.1.1.x/10.1.3.3.x, Oracle BI applications 7.9.5/7.9.6.
  • Extensive experience in OBIEE 12C/OBIEE 11.1.1.x/10.1.3.3.x, Oracle BI applications 7.9.5/7.9.6 which includes creating, customizing and managing repository and Presentation services (Answers, Dashboards & Delivers), OBI/Siebel iBots (BI Scheduler), BI publisher, BI(RPD and Web - catalog) administration.
  • Strong understanding of Data Warehouse concepts ETL, OLAP, Star Schema, Data Modeling using Normalization, Business Process Analysis, Dimensional Data Modeling, FACT & Dimensions tables, Physical & Logical Data Modeling, Aggregate persistence wizard.
  • Strong working knowledge in Metadata modeling in all three layers (physical, BMM, presentation).
  • Experience in using Presentation, Repository and Session variables and Initialization blocks in OBIEE.
  • Experience in administering various OBIEE environments with large number of users and providing optimum system uptime and performance; designing security matrix, configuring authentication and authorization architecture, and providing permissions to users according to their role.
  • Experience in developing various dynamic and interactive complex reports/dashboards with intuitive drilldowns, drill-across and drillable charts using Answers
  • Worked Extensively on OBIEE Administration Tool, OBIEE Presentation Services, Answers, Interactive Dashboards and BI Publisher.
  • Strong knowledge of RDBMS databases like Oracle 10g/11g, MS SQL server 2000, IBM DB2 8.2
  • Good Communication, Co-ordination and team skills. Well organized with excellent leadership skills and commitment to deliver on schedule.
  • Enthusiastic team oriented member with good communication skills. Ability to work in tight schedules and on different applications concurrently.

TECHNICAL SKILLS:

Reporting Tools: OBIEE 10G/11G/12C, OBIA 7.9.6.4/ 11.1.1.8.1, Tableau

ETL Tools: Informatica Power Center 10.x/9.x/8.x, ODI 11.1.1.x, Pentaho

Databases: Oracle 11g, MS SQL Server Teradata, DB2

Database Utilities: Toad, sql developer, SQL*Loader, Embracedo Rapid SQL, DBArticianLanguages: SQL, PL/SQL.

Operating Systems: Windows HP-UX, Unix, Red Hat Linux, Ubuntu Linu

PROFESSIONAL EXPERIENCE:

Confidential, Rosemont, IL

OBIEE Administrator

Responsibilities:

  • Installed and configured of OBIEE 12.2.1.2.0 on RHL7 configuring teradata with OBIEE configuring sql server with OBIEE installing and configuring ODI 12c troubleshooting ODI Agent
  • Monitor the day-to-day activity of the data warehouse, Informatica jobs, BI Tools and reporting
  • Used Administration tool for developing, customizing and modifying the Physical, Business and Presentation layers of the metadata repository,
  • Worked with functional and technical leads, business groups to identify, analyze, and document business requirements.
  • Implemented User access, authentication and authorization following best practices in the Repository.
  • Creation of Application roles and users in OBIEE Admin EM and setting permissions and privileges
  • Migrating OBIEE 11g to OBIEE 12c

Confidential, Atlanta, GA

Senior OBIEE Administrator

Responsibilities:

  • Installed and configured of OBIEE 11.1.1.7.1 with OBIA 7.9.6.4 to build a Test server adding up to the existing stack.
  • Cluster build activity involves Installation and configuration of OBIEE11g in different Linux boxes.
  • Administering and Monitoring WebLogic servers, web server-Apache and Enterprise Manager.
  • Setting up SSL certificates at WebLogic and web server layer for different clusters.
  • Implementing OBIEE security from Security Infrastructure setup (WLS Console and EM) i.e. LDAP and Data -Object level security setup thru RPD.
  • Used MSAD to configure Oracle Business Intelligence Enterprise Edition (OBIEE 11.1.1.7) as a Single Sign-on mechanism (SSO) as part of security configuration for OBIEE applications with SSL.
  • Deployment of RPD and BI Presentation Catalog.
  • Designing/Modifying new Subject Areas, working on creating new tables in existing Subject areas in a RPD as per the requirement
  • Customizing and development of dashboards according to the requirement by the business users
  • Setting up Usage tracking in all environments Development, Test and Production.
  • Merge and import objects from different repositories with 3- way and 2-way merge in a Multi User Development Environment (MUDE).
  • Setting up BI publisher in several environments.
  • Setting up ODBC drivers like DB2, Teradata, Oracle, Informix, SQL server and Informix as per clusters
  • Configure multiple LDAP hosts and update passwords for security compliance using WebLogic Scripting Tool (WLST).
  • Installing latest patch as per recommendation by oracle.
  • Worked on Remedy tool to resolve incidents created by users in case they are facing issues' related to dashboard, data, reports or performance.
  • Completed POC for upgrading OBIEE11g to OBIEE 12c, as part of process installed and configured OBIEE12c in one of test environment
  • Monitor the day-to-day activity of the data warehouse, Informatica jobs, BI Tools and reporting.
  • Promoting/rollback of deployment groups from development to QA and to prod
  • Worked on (start and stop) automation shell scripts for Weblogic Server, Managed Server and System Components in Linux environment.
  • Provide user training including creation of training documentation
  • Provided continuous support in weekdays and weekends.
  • Provided 24x7 on-call support for production / non production environments. worked for more then 1+ years on pentaho

Confidential, Raleigh, NC

Senior OBIEE/OBIA Administrator

Responsibilities:

  • Assist to Lead the effort of conforming and de-normalizing a Teradata EDW into an optimal ODS for OBIEE 11g’s semantic and presentation layer in order to develop reports and dashboards that leverages the latest capabilities and functionalities.
  • Installed and upgraded multiple OBIEE 11.1.1.7.1 along with OBIA 11.1.1.8.1 environments - Development, UAT and Production.
  • Designed and Upgraded OBIEE BI Apps (HR Analytics & Financial Analytics) from OBIEE 10G to OBIEE 11G.
  • Installed and configured of Oracle BI Publisher on Red hat 5.0.
  • Installed and configured OBIEE on Red hat 5.0
  • Configured UCM with BIPublisher/OBIEE
  • Prepared the webcat and repository. Created security groups and application roles.
  • Administration of the existing environment with respect to changes and the development changes
  • And implementation feasibility.
  • Configured and created JMS queues & topics, Connection Factories, Data sources, connections pools & multi
  • Connection pools.
  • Extensively involved in tuning the server.
  • Set up Secure Sockets Layer (SSL) communication between iPlanet and the WebLogic Application Server.
  • Writing various posting scripts for log rotation, log analysis.
  • Migrated WebLogic Server applications from existing version to 10 to 11g
  • Involved in performance tuning of JVM and used Garbage collection Algorithms for better performance.
  • Monitor and managing the weblogic server instances using WSLT and also for the automation purpose.
  • Involved in troubleshooting and fixing day-to-day problems of the applications in production, production-Fix and testing environments.
  • Configured LDAP using directory Server for user authentication
  • Worked on the memory utilization and reports using report optimization technique.
  • Implemented User access, authentication and authorization following best practices in the Repository.
  • Coordinated with business users in understating and implementing the security feature. Using Object level and Data level Security.
  • Implemented Delivers using iBots for delivery of report through email, handheld devices and mobile phones.
  • Worked on administration of OBIEE Cache management, Security Management for Users, groups and web groups using the various authentication system such as LDAP Authentication using Session variable as well as Dashboard / Report level Security.
  • Implemented Row Level Security.
  • Analyzed and determined merchandise mix and related product performance. Recommended adjustments for location business trends, seasonal selling peaks and physical location capacity.
  • Partnered effectively with Sales and planning to ensure that most accurate sales plans are captured each quarter.
  • Estimated and calculated Quarterly Incentives for Retail Development team.
  • Implemented various Repository Variables and System Variables depending up on user requirements.
  • Designed and developed complicated/complex reports.
  • Followed best practices to make sure there was good performance.
  • Administered MUD rpd, reviewed developers’ rpd development before merging into MUD server.
  • Provided 24x7 on-call support for production / non production environments.
  • Scheduled meetings with Senior Data Leads and analyzed the data.
  • Documented processing times for each module, developed test cases and used them to run through each process.

Confidential, Parsippany, NJ

Senior OBIEE Administrator

Responsibilities:

  • As OBIEE Administrator, managed the installation and configuration of OBIEE tool in Linux environment.
  • Install, upgrade and configure all components of OBIEE
  • Used Administration tool for developing, customizing and modifying the Physical, Business and Presentation layers of the metadata repository,
  • Creation of Application roles and users in OBIEE Admin EM and setting permissions and privileges
  • Design and implement data in various layers including physical, business and presentation
  • Assist the teams in generating dashboards and reports properly
  • Worked on various L3 tickets like Evolution/Request for information/Anomaly and resolved accordingly,
  • Apply Latest Bundle Patch 11.1.1.7.1 50120 with installation and configuration bug fixes.
  • Testing and Ensuring all the migrated reports and Deliverers for proper functioning, Testing the Adhoc reports of production with development to crosscheck the modifications done
  • Handled production issues and outlined backup of Informatica environment.
  • Reducing maintenance needs, improving reliability, reducing execution time and performance tuning and monitoring
  • Assist with the definition of 'service level' requirements from all areas of the organization, as they relate to the business Intelligence including application availability, acceptable downtime, data integrity, user support, issue resolution, etc.
  • Responsible to monitor and keep the health of Informatica services, OBIEE services
  • Worked with session logs, Informatica Debugger, and Performance logs for error handling when we had workflows and session fails.
  • Configured usage tracking for helping the development team to understand the most fired queries and generated reports.
  • Ensure daily repository backup is taken and did performance tuning tasks using aggregation, enabling cache, etc
  • Perform testing and validation of various application running shell scripts as part of production support
  • Experience working on Installation and configuration of Financials Analytics, Supply chain and Order management Analytics, HR Analytics, and Procurement and Spend Analytics.
  • Created variables, initialization blocks, logical columns as per business requirement.
  • Customizing and development of web portal according to the requirement,
  • Killing sessions and revoking user privileges and roles
  • Migrating/merging Repository and web-cat and documented migration procedure and best practices to be followed during migration from development to test and then to production.
  • Documented processing times for each module, developed test cases and used them to run through each process.

Confidential, Santa Clara, CA

Senior OBIEE/ODI Administrator

Responsibilities:

  • Worked with functional and technical leads, business groups to identify, analyze, and document business requirements.
  • Prepared Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
  • Installed and Configured OBIEE11g (11.1.1.6) server on UNIX (Linux).
  • Upgraded OBIEE 10g Reports to OBIEE 11g (11.1.1.6).
  • Administered Web logic for OBIEE.
  • Involved in setting up Ibots (Agents) to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.
  • Designed and developed Security Strategy and worked with Middleware to implement this in FMW.
  • Modified NQSConfig, NQServer, Instanceconfig.xml files for Server configurations and troubleshooting reports performance.
  • Setup LDAP authentication and SSO for OBIEE 11g.
  • Debug and tune the Systems (BI Server, Presentation, and Scheduler) and java components.
  • Monitor the Business Intelligence performance using Enterprise Manager (EM).
  • Migrate RPD, Web catalog, DAC repositories between environments.
  • Configured the Oracle BI Management Pack (part of Oracle Enterprise Manager Gid Control) to manage the Oracle BI systems.
  • Setup Oracle Configuration Manager (OCM) and Remote Diagnostic Agent (RDA), the data captured provides Oracle Support with a comprehensive picture of the environment which aids in faster problem diagnosis.
  • Implemented Data Level Security and Object level Security using LDAP and External Tables.
  • Involved in Integrating Oracle BI Presentation Services with BI Publisher.
  • Installed, Configured ODI 11.1.1.5.0 in all the 5 instances like Dev, ST, QA, Prod and DR.
  • Developed the migration process required to migrate the ODI configuration through various test environments including the production and contingency environments.
  • Implemented and maintained multiple instances and repositories for multi-user environment.
  • Managed and monitored ODI resource using Weblogic and OEM
  • Migrated Code between environments and synchronizing repositories.
  • Deployed and configured J2EE, stand-alone, col-located agents for load balancing.
  • Configured ODI to integrate with third-party LDAP authentication.
  • Implemented ODI security, managed user profile and privileges.
  • Integrated ODI with golden gate for real-time change data capture.
  • Documented processing times for each module, developed test cases and used them to run through each process
  • Set up BI publisher Security to control access given to business users.
  • Provide user training including creation of training documentation
  • Provided continuous support in weekdays and weekends.
  • Created highly formatted reports using BI Publisher based on Oracle Database.

Hire Now