Oracle Systems Analyst
job summary:The Oracle EBS Systems Analyst is responsible for the implementation and maintenance of Oracle EBS and iFactory (Production Scheduling, Activity Approval system) EBR Data Collections for the EBR (Electronic Batch Record. This position will ensure proper implementation, functioning and resolution of any issue impacting operation or affecting compliance associated with these systems. This position serves as a liaison between the business users and technical teams and will work on the continuous improvement of the processes involved with those systems. Additionally, manage small to mid-level projects to completion location: Austin, Texasjob type: Permanentsalary: $90,000 - 105,000 per yearwork hours: 8am to 5pmeducation: Bachelors responsibilities:
- Performs technical duties to perform updates, testing, debugging, integration, and analysis.
- Perform data transfers between application instances, operating units and other systems (internal and external), provide user access to data, configure business systems to support user needs, troubleshoot issues.
- Serve as point of contact and subject matter expert in discussions or issues related to business systems including but not limited to iFactory, Oracle, Discoverer, Bartender, Work Order Packets.
- Perform requirement gathering, process mapping, develop system solution strategy, write technical documents, and lead initiatives to completion.
- Capability of writing ad hoc SQL queries against database tables for data gathering, impact analysis and support miscellaneous requests.
- Utilize Change Management controls to implement code changes in Production and non-Production instances.
- Adhere to standards related to documentation, software development methodology, version control testing, and migration.
- Administer the Oracle EBS Collection Plans for Incoming Inspection and iFactory EBR Process to support Quality and Manufacturing Operations in EBS organization.
- Ensure proper completion of the following activities and others associated with these systems:
- Verification and Maintenance of Oracle EBS Collection Plan Data/ ifactory setups.
- Track and manage incidents impacting proper functioning of these systems.
- Troubleshooting and solve events as defined by the approval level of authority.
- Approve and assess change control packages for enhancements and updates.
- Ensure correct creation and implementation of required collection plans.
- Create and maintain the procedures associated to these implementations.
- Define, collect, and report key metrics associated with the progress of projects and the performance prior, during and after implementation.
- Provide shift and non-shift support for Oracle e-Business Suite; Oracle production, test and development instances.
- Lead Implementation of Oracle EBS for Incoming Inspection and iFactory Projects as required for Austin processes.
- Adhere to GMP requirements per 21 CFR 11 and 21 CFR 210/211.
- Experience level: Experienced
- Minimum 3 years of experience
- Education: Bachelors (required)