Job Posting Title: Oracle System Analyst
Person Type: Regular
Posting Category Information Technology
Job Summary and Essential Functions:
Known for its scientific and operational excellence, Regeneron is a leading science-based biopharmaceutical company
that discovers, invents, develops, manufactures, and commercializes medicines for the treatment of serious medical
conditions. Regeneron markets medicines for eye diseases, colorectal cancer, and a rare inflammatory condition and
has product candidates in development in other areas of high unmet medical need, including hypercholesterolemia,
oncology, rheumatoid arthritis, allergic asthma, and atopic dermatitis.
Responsible for day to day support and maintenance of company's Oracle Process Manufacturing (OPM) application - R12.1.2. Part of the Oracle Applications team that will be responsible for application maintenance and enhancements. Provide technical support services for future Oracle based projects.
Essential Duties and Responsibilities include, but are not limited to, the following:
•Works as part of a team to provide technical support for day to day Oracle application issues.
•Responsible for documenting the system in compliance with FDA regulations relating to computerized systems.
•Works closely with IT Business Analyst to review and discuss open issues and provide resolution.
•Support and maintain Oracle Applications which includes assisting in trouble shooting, functional errors, issue resolution, etc.
•Work with Oracle support services to resolve customer open issues.
•Work closely with company's Oracle DBA(s) to resolve technical issues and request patches.
•Participates in the design of solutions primarily within Oracle Process Manufacturing (OPM) modules (Quality, Product development, Process design, Batch Execution, Inventory Tracking, Genealogy).
•Other duties as necessary.
Experience and Required Skills:
Knowledge and Skills:
•EBS(Oracle 11i, 12x) technical knowledge/configuration skills.
•Must be proficient at SQL, PL/SQL and workflow development
•Technical understanding of data modeling, design and architecture principles and techniques across master data, transaction data and derived/analytic data (e.g., KPIs),
•Must have solid organizational skills.
•Experience with XML a plus.
•Experience in report development and data extracts using other Oracle development tools including BIPublisher, Oracle Reports, SQL Loader, etc.
•Experience in integration of Oracle EBS across functional areas and other source systems
•Experience in data mining, scrubbing and modeling, and Extract Transform and Load (ETL) is a plus.
•Development experience with multiple applications in Oracle EBS versions 11i and/or 12x.
•Experience building schemas, developing stored procedures and database triggers in PL/SQL.
•Proficient in the Software Development Lifecycle.
•Experience in at least one full Implementation of Oracle Process Manufacturing modules in 11i,12.X
•Experience with Mobile Technology ' Barcodes, labeling, Data field identifiers
•Strong Knowledge of Oracle Forms, Reports, XML Publisher, Work Flow, AME, Interfaces
•Experience with SDLC, designing and developing CEMLIs (Configuration/Customization, Extension, Modification, Localization and Integration.
•Requires BS/BA in related field with 3 years of relevant experience; will substitute relevant experience for education.
•Experience in Biotech/Pharmaceutical Manufacturing environment is a plus.
This is an opportunity to join our select team that is already leading the way in the Pharmaceutical/Biotech industry.
Apply today and learn more about Regeneron’s unwavering commitment to combining good science & good business.
To all recruitment agencies: Regeneron is using the agency management company, Candex -www.candex.com. Please, no phone calls or emails to any employee of Regeneron about this opening. All resumes submitted by search firms/employment agencies to any employee at Regeneron via-email, the internet or in any form and/or method without a valid written search firm agreement in place for this position will be deemed the sole property of Regeneron. No fee will be paid
in the event the candidate is hired by Regeneron as a result of the referral or through other means.
Regeneron is an equal opportunity employer.