Job Description
Job Description
Position Summary : This critical role at Sunnen Products Company involves the design, development, maintenance, and support of our Oracle E-Business Suite (EBS) applications. The Senior Oracle E-Business Suite Developer / Engineer will be a key contributor to Sunnen's EBS environment, requiring a deep understanding of Oracle EBS architecture, strong PL / SQL programming skills, and the ability to work effectively with cross-functional teams. A unique and essential aspect of this role is to understand the characteristics of the specialty tools we make for customers in commercial Automotive and Aerospace industries which requires the candidate to have an understanding on Mechanical and Metallurgical properties of the product to design SKU optimization for our IT systems and understand the Manufacturing processes to identify opportunities for improvement through data analysis and reporting.
ESSENTIAL FUNCTIONS OF THE JOB :
Application Design and Development :
- Analyze user requirements to develop detailed application designs and system flows
- Design, develop, and test web-enabled Graphical User Interfaces (GUIs) using Oracle Forms and Reports, adhering to Oracle development standards
- Modify, develop, and test web scripts using Unix shell and Unix tools
- Collaborate with business analysts and users to gather requirements and translate them into detailed technical specifications
- Enhance current business processes to accommodate changes and improvements suggested by users
- Develop custom objects to enhance or provide functionality not available as standard Oracle EBS functionality
- Develop new or modify existing formats, reports, database triggers, ERP packages, and ERP database views
Project Management and Implementation :
Design and manage implementation and upgrade projects, including scheduling, coordinating meetings, developing project plans, tracking progress, and providing updates to managementSupport upgrades of existing systems, including analyzing new functionality and reviewing the impact on current enhancements and customizations; rework customizations as requiredManufacturing Process Improvement and Collaboration :
Work closely with the Engineering team to gain a deep understanding of manufacturing processes and identify areas for improvementAnalyze manufacturing data from EBS and other sources to identify trends, bottlenecks, and opportunities for optimizationDevelop reports and dashboards using Oracle Reports, BI Publisher, or other reporting tools to communicate findings and recommendations to the Engineering team and managementMust have knowledge on Manufacturing forecasting tool Demand Solutions and VSEMEBS System Support and Maintenance :
Support daily processing and reporting needs, including concurrent requests, concurrent managers, data issues, error remediation, and interface troubleshootingAct as an intermediary between Sunnen users and 3rd party software / hardware support services / vendorsTrain users on customized processesDocument all processes and customizations being developedContinuous Improvement :
Stay current with the latest Oracle EBS technologies and best practicesQualifications :
Bachelor's degree in computer science, Information Systems, a related field, or equivalent experienceExtensive knowledge or degree in Manufacturing / Metallurgy or Materials Science is required7+ years of experience in Oracle E-Business Suite development and supportExtensive experience with PL / SQL programming, including stored procedures, functions, triggers, and packages within the EBS contextStrong understanding of Oracle EBS architectureExperience with Oracle EBS development tools, including Forms, Reports, and WorkflowExperience with SQL optimization and query tuning within the EBS environmentPrevious experience of working in IT for Manufacturing customers is preferredExcellent analytical and problem-solving skillsStrong communication and interpersonal skillsAbility to work effectively in a team environmentSunnen offers a wide variety of benefits for our employees, such as :
Competitive Insurance Coverage, eligible on the first of the month after hire date :Medical (PPO and High Deductible Plan with Employer HSA Contribution)
DentalVisionLife and AD&DAccidentCritical IllnessHospital Indemnity401(k) Eligibility with Employer MatchCompany Paid Benefits :Group Life and AD&D Insurance
Short Term DisabilityLong Term DisabilityEmployee Assistance ProgramCompetitive Vacation PolicyWeekly onsite Nurse Practitioner and ChiropractorTuition ReimbursementPaid Plant Closure Between Christmas and New Year's DayWe require a background and SSN check, drug test, and physical for pre-employment.