U.S. Pharmacopeial Convention Jobs

Job Information

The U.S. Pharmacopeial Convention (USP) Senior OBIEE Developer in Hyderabad, India

Senior OBIEE Developer

Information Technology

Hyderabad, AP

ID:IND 283


The U.S. Pharmacopeial Convention (USP) is a scientific non-profit organization that sets standards for the identity, strength, quality, and purity of medicines, food ingredients, and dietary supplements manufactured, distributed and consumed worldwide. USP’s drug standards are enforceable in the United States by the Food and Drug Administration, and these standards are used in more than 140 countries.

USP promotes Diversity & Inclusion at Workplace and encourages Equal Employment Opportunity and Affirmative Action

This is a professional hands-on IT position in which the incumbent is responsible for Oracle Business Intelligence Enterprise Edition (OBIEE) to design, develop, document, and support reporting, analytics, dashboards and repositories. The incumbent works closely with the Associate Director, to ensure core IT tasks are completed on schedule and with high quality for internally and externally facing applications ranging in complexity to support USP’s priorities and mission.

Roles and Responsibilities

  • Responsible for Analysis, design, development, customizations, validations, deployment and post-implementation support for OBIEE components including Oracle BI Admin, Interactive Dashboards, BI Publisher, Scheduler, and Interactive Reporting using OBIEE 12c.

  • Work closely with stakeholders, developers and database administrators to plan, design, develop and implement applications, scripts, procedures and metadata for relational databases.

  • Responsible to create, maintain and enhance Business Intelligence components (metadata, reports, metrics, dashboards) and manage the overall BI ecosystem

  • Responsible for working with the Business Intelligence (BI) team members and business stakeholders to deliver reporting and analytics solutions within the data warehouse.

  • Responsible for developing re-usable OBIEE frameworks such as logical layers and metadata mappings

  • Collaborate to work closely with the test teams to complete BI development activities and resolve defects, develop and unit test OBIEE repositories and multidimensional databases, monitor and remediate System Integration and Business User Testing software issues

  • Lead BI application change control management by performing Impact Analysis to drive changes

  • Responsible for performing analysis, design, development, testing and performance improvements of complex queries based upon the specific needs of USP

  • Collaborates with Associate Director to obtain necessary resources and provide expert technical solutions to support long-term technology strategy.

  • Facilitates problem solving and collaboration.

  • Nurtures and enforces best practices for development activities within assigned staff

  • Coordinate work efforts with the DBA team for application changes and system performance issues

  • Assist with testing OBIEE functionality for deployment of upgrades to keep application release level current

  • Pursue innovative ways to improve the process of delivering solutions to OBIEE users

  • Proactively work through service requests with Oracle support as needed.

  • Perform other related duties as assigned

Required Skills

Basic Qualifications

  • Bachelor’s degree in computer science or relevant field with 9 years of professional OBIEE/Datawarehouse experience

  • At least 5 years’ experience in ODI administration, ODI development, OBIEE development, Data analysis, and Business Intelligence

  • Excellent knowledge of Oracle Business Intelligence Enterprise Edition (OBIEE) from both a functional and technical perspective.

  • Demonstrated involvement in end-to-end deployments of two of the following: ODI Administration, OBIEE Administration, OBIEE repositories, Oracle BI applications, Data Warehousing preferably ODI

  • Good understanding of at least three of the following: multi-dimensional analysis, Oracle BI Applications (Financials or supply chain/Order management) and ETL/ELT tools like ODI

  • 3+ years proven expertise with Oracle EBS business subject areas (Sales, Financials, Accounting/GL) in R12.x Oracle EBS environment

  • SQL proficiency with experience in constructing/deconstructing complex reports and queries

  • Good understanding of Master Data Management (MDM) concepts

  • Solve complex issues using methodical troubleshooting based on expert knowledge of Oracle OBIEE applications functionality and technology

  • Ability to identify technical risks, present solutions to non-technical personnel and influence technical decisions.

  • Ability to interact successfully with all levels of the organization. Deals with conflicts, confrontations, and disagreements in a positive manner.

  • Experience in Hyperion Planning and budgeting (PBCS), Enterprise Analytics (ASO), or financial reporting, a plus

  • Understanding of Oracle EBS from a functional user perspective, a plus

  • Must have worked on end to end implementation of a minimum two ODI projects

  • Should have good querying skills on Oracle database with ability to understand & debug PL/SQL procedure

  • SQL proficiency with experience in constructing/deconstructing complex reports and queries

  • Experience in performance tuning of mappings

  • Experience in error handling, testing, debugging, troubleshooting skills and migration of objects

  • Experience in managing Files, Oracle DB, XML's through ODI

  • Experience in developing Load Plans, Scheduling Jobs

  • Experience in integrating ODI with multiple Source / Target

Required Experience

Preferred Qualifications

  • Excellent verbal and written communication skills.

  • Skilled problem-solver and detail oriented.

  • Demonstrated experience leading large software development projects.

  • Manage work assignments of the member(s) within the team and contractors.

  • Has ability to influence without direct authority.

  • Requires ability to work on assigned tasks independently with limited direction

  • Takes accountability for projects and deliverables and escalates appropriately and in a timely manner as needed

  • Takes personal responsibility for the quality and timeliness of work and achieves results with minimal oversight.

  • Must be a team player and work well in a deadline-driven environment with multiple priorities.

  • Ability to manage multiple projects, take direction, and produce defined results.

  • Able to work flexible hours when needed.

Job Category Information Technology