We provide IT Staff Augmentation Services!

Obiee Administrator Resume

Houston, TexaS

SUMMARY:

  • Over 10 years of experience in Administration, Design, Development and Maintenance of Enterprise Application using OBIEE solutions, Clinical Data Analytics(CDA2.0), and Oracle Health Sciences Clinical Development Analytics (OHSCDA 2.1), CRM.
  • Proficiency in Software Methodologies, Software Life Cycle Models, Implementation and Maintenance of Application Modules using high end Qualified Technologies and Quality measures in place.
  • Extensive experience in OBIEE 10.1.3.4, OBIA 7.9.6, OBIEE 11.1.1.5, Siebel Analytics 7.8.4, Informatica 7.1.4, Informatica 8.6.1, Informatica 9.0.1, DAC 7.8.4. DAC 10.1.3.4.1
  • Experience on Agile Methodology. Implemented and documented Project road map and Strategy
  • Involved in all the SDLC phases of Data warehouse project, Requirement Gathering, Solution design, Work Flow modeling. Involved in Solution design team (HLD and LLD documentation and design board interaction) in providing multiple solution approaches and development plan.
  • Experience in reviewing functional requirements and specification documents.
  • Worked as an Onsite coordinator and OBIEE Lead, Interacted with Design Board and Offshore team.
  • Experience with OBIEE MUDE (multiple user development environment).
  • Experience in developing OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill - down capabilities using global & local Filters, Security Setup (groups, access / query/report privileges), configured Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBot,
  • Security (data level and object level)
  • Involved in OBIEE Administration. Cache management, User authentication, Role based Permission and Security (data and object level).
  • Performed Installation, Up-grade and Configuration of OBIEE, DAC and Informatica. Implemented change execution request on OBIEE webcat, RPD and ability to debug issues in different OBIEE server components. Extensive experience in customizing Oracle BI Apps, OOTB ETL adaptors and prebuilt analytics
  • Implemented and configured custom and OOTB mappings supporting incremental and full ETL process. Modify the OOTB SDE and SIL mappings to bring the custom fields to the data warehouse
  • Assist testing team with test planning, test conditions, and obtaining test data related to break Point.
  • Lead the team, Mentored the team members as and when required and help them out in technical difficulties
  • Excellent communication, Part of technical interview team, Business Analyst and client facing skills with presentation knack.

TECHNICAL SKILLS:

Source: Siebel7.8, PeopleSoft HR and Financial

Environment: -- Windows 95/98/NT/2000/XP, UNIX, Linux, IBM Compatibles

Database: Oracle 11g/10g/9i/8i MS SQL Server 2005/2000

Programming: SQL, PL/SQL, Embedded SQL, UNIX Shell Scripting, C, HTML 4.0

Domain: Telecomm, Banking and Siebel CRM On Demand

Presentation Tool: Microsoft Power point, Microsoft Excel, Microsoft Visio.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, Texas

OBIEE Administrator

Responsibilities:

  • Involved in upgrade of existing OBIEE version system to the Latest version.
  • Involved in setup, installation, configuration of OBIEE 11g in Linux operating system also integrating with the existing environment. Involved in trouble shooting of errors encountered. And worked with Oracle support to analyze the issue.
  • Prepared the OBIEE webcat and repository. Created security groups and application roles.
  • Worked on Active directory configuration and setup and refreshed GUID’s.
  • Worked on BISQLGroupProvider configuration and setup for group inheritance from external tables.
  • Worked on Weblogic Admin server and clustered weblogic managed servers.
  • Administration of the existing environment with respect to changes and the development changes and implementation feasibility.
  • Worked on Oracle http server, Oracle weblogic, Analysis, installation, configuration and deployment.
  • Worked on the environment setup and automation scripts of development, Test, Production, servers.
  • Implemented and documented the best practices.
  • Worked on the Test, Production environment and configured the clustered environment on the Linux system.
  • Worked on LDAP setup in weblogic console. Analyzed stuck thread, managed servers, created default authenticated user and configured settings through weblogic console.
  • Created and assigned Application roles in weblogic EM. Worked on Trace level settings for weblogic managed servers.
  • Implemented Agents for Production assigned users.
  • Configured BI publisher roles and policies for campus solutions template in the report.
  • 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 executive users and board members in understating and implementing the security feature. Using Object level and Data level Security.
  • Worked on development and engineering team to make application ready to deploy. Migration of repository, webcat and required objects across the environment.
  • Worked on various layers of OBIEE architecture Application layer, Presentation layer, and Database layer.

Environment: OBIEE 11.1.1.7.0 , OBIEE 11.1.1.7.1 , Data stage 8.5, Oracle 11g (Database), SQL Developer, Windows 2003 server, Oracle-HTTP-Server/2.2.22 (Unix),Oracle WebLogic 10.3.5.0

Confidential, Rahway New Jersey

Programmer Analyst/OBIEE Administrator

Responsibilities:

  • Involved in upgrade of existing Oracle Clinical Development Analytics (OCDA2.0) system to Oracle Health Sciences Clinical Development Analytics (OHSCDA 2.1) in test, UAT, production, break fix and environment.
  • Involved in CDA2.1 upgrade where OBIEE 10 g was replaced by OBIEE 11g in spectrum along with the existing environment.
  • Involved in setup, installation, configuration of OBIEE 11g in Linux operating system also integrating with the existing environment. Involved in trouble shooting of errors encountered. And worked with Oracle support to analyze the issue.
  • Implemented BI publisher patch and DAC patch as part of CDA 2.1 upgrade.
  • Executed the run installer for Data ware house and Informatica mappings as a standard process. Emplacing the Oracle Health Sciences Clinical Development Analytics (OHSCDA 2.1) help and image files and folders.
  • Prepared the OBIEE webcat and repository. Created security groups and application roles for OHSCDA.
  • Worked on installation and configuration of Weblogic application server for Oracle Healthcare Master Person Index (OHMPI).
  • Worked on Weblogic Admin server and clustered weblogic managed servers.
  • Administration of the existing environment with respect to changes and the development changes and implementation feasibility.
  • Worked on Oracle application server, Apache web server, Oracle weblogic, Analysis, installation, configuration and deployment.
  • Worked on the environment setup of development, Test, Production, UAT, and break fix servers.
  • Implemented and documented the best practices which are followed during the application installation and configuration.
  • Worked on the Production environment and configured the clustered environment on the Linux system.
  • Worked on LDAP setup in weblogic console. Analyzed stuck thread, managed servers, created default authenticated user and configured settings through weblogic console.
  • Created and assigned Application roles in weblogic EM. Worked on Trace level settings for weblogic managed servers.
  • Implemented and configured iBot on development, Test, Production and UAT assigned users are groups and also masked the data and restricted users.
  • Configured BI publisher and implemented the pharmaceutical template in the report.
  • 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.
  • Worked on creating deadlines for the development and engineering team to make application ready to deploy. Migration of Repository, OBIEE OBIEE webcat and Informatica mapping across the environment.
  • Create new tables and schemas as a part of Fusion middle ware setup. As part of Oracle Health Sciences Clinical Development Analytics (OHSCDA 2.1) upgrade new Informatica mappings were created and synchronized by creating new database tables in the Data ware house.
  • Created shell scripts to automate the start and stop services of the Weblogic Admin server, node manager, Managed server and OBI server component services.
  • Worked on various layers of OBIEE architecture Application layer, Presentation layer, and Database layer.

Environment: OBIA 7.9.6, OBIEE 11.1.1.5.5 , Informatica 9.0.2, DAC 10.1.3.4.1 . Oracle 11g (Database), SQL Developer, Windows 2003 server, OAS 10.1.3.3.0 , Oracle Weblogic 10.3.5.0

Confidential, Richmond, Virginia

OBIEE Technical Specialist/OBIEE Administrator

Responsibilities:

  • Coordinate with the business team to identify the change request to be implemented along with the source system upgrade. Identify the changes in the source table and its impact on ETL process.
  • Prepared functional design and technical design documentation. Considering the impact analysis on reports, dashboards and the ETL process.
  • Prepared and documented test cases for Unit and Integration and system testing phase.
  • Developed new source image mappings from source to staging area. Remediated the existing mapping considering the source system change. Implemented the mapping in the DAC execution plan created and assigned index for the individual task.
  • Worked extensively on reports and dashboards to minimize the source system upgrade impact and data availability.
  • Extensively worked on RPD, Physical and logical diagram to identify the join conditions and synchronize it with the data availability and the change request as a part of HCM Upgrade
  • Created new dashboard and reports as a part of new change request.
  • Migrated RPD, OBIEE webcat, Informatica mappings, and DAC repository from development environment to QA environment.
  • Executed test cases in Unit and Integration and system testing in HP quality center. Worked on the defects raised remediated and closed the defect.

Environment: OBIEE 10.1.3.4, Informatica 8.1.1, DAC 10.1.3.4.1 . Oracle 10 g (Database), SQL Developer, Windows 2003 server

Confidential

Programmer Analyst/OBIEE Administrator

Responsibilities:

  • Worked as a On Site Coordinator and OBIEE Lead.
  • Worked closely with the business users, gathered the business and analytic requirements from different user group and customer advocates.
  • Worked on Repository (.rpd), customized the RPD with the requirements of the End User. Designed and Developed the three layers (Physical, BMM, Presentation)
  • Developed Dashboards, Reports, drillable charts, pivot table views, guided navigation, prompts, and compound layout.
  • Implemented Dimensional hierarchies, Level based measures, Fragmentation content, Aggregation, Complex joins in rpd, Configured Repository and Session variables and Initialization block for Dynamic, Customized, Prebuilt reports.
  • Implemented Delivers using iBots for delivery of report through email, hand held 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 Dash board / Report level Security.
  • Installation, Upgrade, Configuration, and Migration of OBIEE, DAC, and Informatica on the POD’s for the new assigned Customers.
  • Customized OBIA OOTB RPD to facilitate reporting, Effectively modified the OBIA reports and dashboards as per the custom requirement and business logic
  • Effectively migrated the RPD and Web catalog changes across environment through catalog manager.
  • Involved in development of ETL process using OOTB and Custom Fact and Dimension table
  • Using various transformation, Workflows, Adaptors
  • Involved in HR, Finance, Supply Chain Management Analytics, Order management customization of reports and dashboard. Understanding the prebuilt data mart and workflow logic
  • Involved in Customizing the Supply chain Management pre built report and dashboard, develop and administration of Supply chain management OOTB ETL.
  • Worked on Order management custom data loading and reporting requirements, extensively worked on Order management Data mart and the workflow
  • Ensure the overall health and performance of OBIEE, Informatica and DAC to ensure environment reliability and availability, system recoverability. Involved in Diagnoses of application bottlenecks and performance issues through performance tuning.
  • Understand the Siebel CRM on Demand options with management and create Technical, Functional, Tracking documentation procedures to determine requirement, gather requirement, Gaps, Functional Design.
  • Lead of analytics tier in disaster recovery activity. Activity objective is to bring the application live after complete disaster of the environment. Involved in cross to the new employees to understand the Application and responsibilities.

Environment: OBIEE 10.1.3.4, Informatica 8.6.1, DAC 10.1.3.4.1 . Oracle 10 g (Database), SQL, PLSQL procedures, SQL Developer, Windows 2003 Server

Confidential

Technical Associate

Responsibilities:

  • Analyzed user stories provide by the customer.
  • Studied the effort estimation required for the project.
  • Worked as an Onsite coordinator and Offshore team Lead , interacted with the design board, offshore .
  • Responsible for interacting with the design Board weekly, where updated regarding development phases , challenges faced, Gaps in the requirement and the actual design and the deviation in the developed application was discussed.
  • Communicate the Design Board suggestion on the Development to the Offshore team and make them understand the deviation tolerance if any gaps are identified in the requirement and the Developed application.
  • Interacting with Testing, Database, ASG (Application support Group) to keep the Delivery on time.
  • Interaction with team and between Testing, Database, ASG (Application support Group) to meet the delivery date and time.
  • Analyzed and gathered requirement with respect to SL/IL/DL EIP-EDW database
  • Checked the data availability in accordance to the user stories available in the database.
  • Developed OBIEE webcat and built RPD during the development phase.
  • Managed Physical, BMM and presentation layer in RPD.
  • Developed customized reports using charts, pivot table and compound view utilities for better user interface.
  • Responsible for setting up security and variables in RPD.
  • Performed unit and peer testing after development to minimize cosmetic and functional defects.
  • Presented the functional project to the customer.
  • Optimized performance of dashboard, reports and requests.
  • Scheduled iBots and configured user and group permissions.
  • Performed pre and post implementation testing of Dashboard, Answers and validated Repository.
  • Performed the Test cases to test the developed report are in sync with the Requirement.
  • Performed cosmetic testing, UAT testing till the deployment phase of the Developed application.
  • Technical assistance for the al Modules
  • Requirement analysis and development of the software for Professionals and Engineering industries

Environment: Oracle 8, Developer 2000, MSOffice

Hire Now