Senior Oracle ERP Business Analyst
About the role
The Senior Oracle ERP Business Analyst at Allegion is responsible for leading the design, configuration, testing, and support of Oracle EBS supply chain modules. This role acts as the primary bridge between supply chain stakeholders and IT/technical teams to deliver solutions that improve order-to-cash, procure-to-pay, and inventory/manufacturing processes.
Responsibilities
- Partner with supply chain leadership to understand business processes and pain points.
- Lead requirements gathering, process mapping, gap analysis, and identify configuration vs. customization decisions.
- Create functional specifications for integrations, interfaces, reports, conversions, and extensions (FBDI, SQL, PL/SQL, APIs, Web Services, flat-file, EDI).
- Collaborate with developers and integration teams to ensure solutions meet functional requirements; review technical designs and participate in code/solution walkthroughs.
- Define and execute test plans: unit testing, integration testing, user acceptance testing (UAT); coordinate defect triage and resolution.
- Prepare and deliver training materials, run training sessions, and produce user documentation and SOPs.
- Support cutover planning and execution for deployments and upgrades.
- Analyze production issues, perform root-cause analysis, propose fixes and process improvements.
- Maintain knowledge of Oracle EBS patches and module-specific enhancements; recommend upgrades or new features where beneficial.
- Mentor junior analysts and provide guidance on best practices and governance.
Requirements
- Bachelor’s degree in Information Systems, Computer Science, Business Administration, Supply Chain Management, or related field.
- 6+ years’ experience implementing/supporting Oracle EBS Supply Chain modules; 3+ years in a senior or lead analyst role preferred.
- 30% travel and up to 50% during project execution.
- Ability to identify customer needs, and understand how to deliver business value through the design of strong solutions.
- Excellent verbal and written communication skills.
- Experience in manufacturing and/or distribution industry.
- Experience in Oracle EBS 11i and R12.
- Deep functional expertise in at least four of the following: Inventory, Order Management, Purchasing/Procurement, WIP/BOM, Costing, WMS, ASCP/MRP.
- Strong understanding of end-to-end supply chain processes: order-to-cash, procure-to-pay, demand planning, inventory management and fulfillment.
- Hands-on experience producing functional designs, test scripts, user guides, and training materials.
- Experience with integrations, familiarity with Oracle Adapter frameworks and middleware is a plus.
- Able to use Oracle SQL for troubleshooting and data analysis.
- Experience with Oracle EBS upgrade projects, patching and module enhancements is preferred.
Qualifications
- Must have ability to identify customer needs, and understand how to deliver business value through the design of strong solutions.
- Excellent verbal and written communication skills.
- Experience in manufacturing and/or distribution industry.
- Experience in Oracle EBS 11i and R12.
- Deep functional expertise in at least four of the following: Inventory, Order Management, Purchasing/Procurement, WIP/BOM, Costing, WMS, ASCP/MRP.
- Strong understanding of end-to-end supply chain processes: order-to-cash, procure-to-pay, demand planning, inventory management and fulfillment.
- Hands-on experience producing functional designs, test scripts, user guides, and training materials.
- Experience with integrations, familiarity with Oracle Adapter frameworks and middleware is a plus.
- Able to use Oracle SQL for troubleshooting and data analysis.
- Experience with Oracle EBS upgrade projects, patching and module enhancements is preferred.
Skills
- Technical: Oracle EBS modules. Oracle SQL, basic PL/SQL, Oracle Forms/Apps knowledge, knowledge of reporting tools (BI Publisher, OTBI) is a plus, data conversion and integration approaches.
- Analytical: strong problem solving, process modeling, gap analysis and requirements translation skills.
- Communication: excellent written and verbal communication; ability to engage at business and technical levels.
- Project skills: experience with Agile and Waterfall delivery methods, ability to manage competing priorities and stakeholder expectations.
- Leadership: mentoring experience, ability to lead workshops and facilitate cross-functional alignment.
Benefits
Allegion offers health, dental, and vision insurance coverage, a 401K plan with a 6% company match and no vesting period, and unlimited PTO. The company also provides employee discounts through Perks at Work and community involvement opportunities. Allegion is committed to providing accommodations for persons with disabilities.
Pay
The expected Base Salary Range: $109,000 - $190,000. The actual compensation will be determined based on experience and other factors permitted by law.
Why Work for Us?
- We are a Great Place to Grow your Career.
- We invest in your professional development.
- We promote work-life balance.
- We are an award-winning company that invests in its people.
- We celebrate who we are and are committed to building a diverse, inclusive, and authentic workplace.
- We provide accommodations for persons with disabilities.
Apply Today!
Join our team of experts today and help us make tomorrow’s world a safer place! Not sure if your experience perfectly aligns with the role? Studies have shown that some people are less likely to apply to jobs unless they meet every single qualification and every single preferred qualification of a job posting. At Allegion, we are dedicated to building a diverse, inclusive, and authentic workplace. So, if you’re excited about this role but your past experience doesn’t align perfectly with every item in the job description, we encourage you to apply anyway. You may be just the right candidate for this role.
Remote Location
Arizona, Remote Location California, Remote Location Indiana
We Celebrate Who We Are!
Allegion is committed to building and maintaining a diverse and inclusive workplace. Together, we embrace all differences and similarities among colleagues, as well as the differences and similarities within the relationships that we foster with customers, suppliers and the communities where we live and work. Whatever your background, experience, race, color, national origin, religion, age, gender, gender identity, disability status, sexual orientation, protected veteran status, or any other characteristic protected by law, we will make sure that you have every opportunity to impress us in your application and the opportunity to give your best at work, not because we’re required to, but because it’s the right thing to do.