U.S. Pharmacopeial Convention Jobs

Job Information

The U.S. Pharmacopeial Convention (USP) OBIEE Developer in Serilingampally Mandal, Ranga Reddy District, India


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

  • Collaborate with development team to design and implement data extraction programs that integrate seamlessly into BI solutions to meet the needs of the end users

  • Ability to create both logical and physical data models, with emphasis on data preparation, data profiling, data cleansing, and data auditing

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

  • Work closely with stakeholders, developers, and database administrators to 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 by resolving defects in timely manner

  • Responsible for troubleshooting, debugging, optimizing and performance tuning of Oracle BI reports.

  • Responsible to develop re-usable OBIEE frameworks such as logical layers and metadata mappings

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

  • Proactively work through service requests with Oracle support as needed

  • Perform other related duties as assigned

Basic Qualifications

  • Bachelor’s degree in computer science or relevant field with 8+ years of professional OBIEE experience in OBIEE development, customizations, and support

  • 8+ years of experience in with: OBIEE Administration, OBIEE Repositories, Oracle BI Applications in an Oracle environment

  • Excellent knowledge in building metadata repository, designing business and presentation layers, creating interactive dashboards and reports using OBIEE

  • Experience on OBIEE development with a minimum of two end to end project lifecycle implementations

  • Experience in SQL constructing/deconstructing complex reports and queries

  • Experience in developing reusable framework and components

  • Experience in tuning performance of dashboard and SQL

  • Experienced in understanding the flow of data between source and target database, Data analysis and analytical skill

  • Experienced in using OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience

  • Experience in debugging skills and able to troubleshoot issues from reports down to data

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

  • Understanding of BI security models

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

  • Exposure to HTML and Java Scripting will be an additional advantage

Preferred Qualifications

  • Excellent verbal and written communication skills

  • Skilled problem-solver and detail oriented

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

  • 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.

  • Able to work flexible hours when needed. In addition to normal business hours of 2:30 p.m. to 11:00 p.m. Monday through Friday, serves on a team to provide 24 hour a day, 7 days a week response to emergency alarm calls and can be available on short notice to support requests during unusual hours, especially early or late in the day during the business week.

Supervisory Responsibilities



USP provides you with the benefits you need to protect yourself and your family today and tomorrow. From company-paid time off, comprehensive healthcare options to retirement savings, you can have peace of mind that your personal and financial wellbeing are protected.

About USP

The U.S. Pharmacopeial Convention (USP) USP is an independent scientific organization that collaborates with the world's top experts in health and science to develop quality standards for medicines, dietary supplements, and food ingredients. USP brings together more than 1,100 talented professionals across five global locations to deliver its mission to strengthen the supply of safe quality medicines and supplements worldwide. USP is proud to be an equal employment opportunity employer (EEOE) and affirmative action employer. Employment selection and related decisions are made without regard to sex, race, age, disability, religion, national origin, color, veteran status, sexual orientation, gender identity or any other protected class. We are committed to working with and providing reasonable accommodation to individuals with disabilities. USP does not accept unsolicited resumes

Note: As a condition of employment with United States Pharmacopeia- India Private Limited’s(USP), duty to provide and maintain a workplace that is free of known hazards, all employees and contingent staff hired after November 1st, 2021 are required to be fully vaccinated unless reasonable accommodation is approved.

Job Type Full-Time

Job Category Information Technology

Job Type Full-Time