Oracle programmer analyst job description

Under supervision of the Manager of Financial Systems, Oracle Analyst is responsible for participating in the deployment project for Oracle ERP/EPM and providing ongoing business support for enhancements, issues, and data/configuration updates within the tool. This includes, but is not limited to, GL, AR, AP, Inventory, Manufacturing, Planning, and Reporting modules. This position requires a high degree of accuracy and attention to detail along with experience in financial system support, project management, and reporting writing. This position will work closely with Inmar's Systems Implementer & Support Partner and have an active hands-on role with business teams during initial ERP deployment, training, and post-launch support.

Oracle ERP/EPM Administration, Configuration, Support, and Training. A proven working knowledge of ERP, Planning, and Reporting systems (Preferably Oracle) with experience in writing business requirements, development and documentation of UAT processes, direct set up of master data, updating configurations, creating complex reports and data updates within an ERP environment. This position will also play a role in the company-wide strategy, planning, execution, and support of ERP and Planning process integration for acquisitions.

Maintain and improve ERP/EPM process documentation, requirements, architectural diagrams, and enhancements roadmap

Direct engagement with Inmar's Systems Support Partner to learn configuration and participate in all workshops and design sessions Quality of the ERP/EPM deployment by participating in Quality Assurance (QA), User Acceptance Testing (UAT) and end-user training activities Conceptualizes, designs, and administers business processes, changes, and updates, while maintaining appropriate internal controls. Self-educates to maintain overall system understanding, researches and understand new capabilities provided through recurring feature releases, and proactively pursues any relevant training or certifications

Conducts multiple phase, customized training for new hires and ongoing, role-based associate training workshops

Functions as Tier 1 and Tier 2 ERP/EPM Support contact with the ability to handle advanced requests Work closely with support partner for any Tier 3 support needs or system enhancements
ERP/EPM Data Management and Reporting
Uses ERP/EPM and other resources to provide meaningful reports and ad hoc analysis to finance, executive leaders and others as needed Using multiple data sources, this position will use their advanced SQL, ODBI and Excel skillset to regularly develop complex reporting, trending, and analysis Designs, implements and maintains dashboards for finance leaders, executive management, and other departments for fast, timely, and actionable insights to company performance and metrics Provides end user support to finance team on ERP/EPM in their planning processes and report development Plays a role in the development and execution of ERP/EPM integration plans for new acquisitions Performs acquisition data integration analysis, cleanup, and designs data migration strategy Proactively provides reporting as new initiatives arise Leads efforts to maintain system wide data cleanliness for accurate reporting

ERP/EPM Tool Development
Leads implementation, administration and conducts training on related ERP/EPM tools Research, develop, recommend and administer new ERP modules to improve functional efficiency and effectiveness, while maintaining internal controls.Work closely with IT teams to design, build, and maintain efficient API and file based integrations to ERP/EPM tools Leverages advanced SQL skill set to develop any needed database queries

Special Project Management & Support
Helps with cross-team process improvement or reporting projects as needed by leveraging business process expertise and overall company understanding Manages special projects, reporting, analysis, processes and assignments between finance and other departments (operations, marketing, sales, HR, etc.) Leads training and support for ERP/EPM tools across user groups Cross train on Workday, Salesforce, and other back office applications

III. Education/Qualifications/Experience
Bachelor's degree (technical or business preferred) Oracle Cloud experience preferred Advanced knowledge of ERP systems and business processes (5+ years) Advanced knowledge of report building and SQL queries required. Oracle Smartview and Oracle ODBI experience preferred Advanced knowledge of Microsoft Office suite (Word, PowerPoint, with emphasis on Excel) GSuite experience (preferred) Project Management Experience (2+ year) Financial analysis experience a plus

The physical demands described here are representative of those that must be met by an associate to successfully perform the major job responsibilities (essential functions) of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the major job responsibilities.

While performing the duties of this job, the associate is:
Regularly required to use hands to finger, handle or feel objects, tools or controls, and reach with hands or arms.Regularly required to talk or hear and read instructions on a computer monitor and/or printed on paper.Occasionally required to stand, kneel or stoop, and lift and/or move up to 25 pounds.Frequently required to view items at an extremely close range and must be able to adjust and readjust focus.

IV. Safety:

Support a safe work environment by following safety rules and regulations and reporting all safety hazards.

An Equal Opportunity/Affirmative Action Employer
E.O.E/M/F/H/V

#LI-JM1
#LI-REMOTE

The Oracle Cloud Analyst will be responsible for the on-going support and enhancement of TTX's Oracle Cloud SaaS applications, focused on Payroll under Human Capital Management (HCM), and Enterprise Resource Planning (ERP) modules. This Finance Systems Team position will work closely with members of the Finance Department, as well as partner with HR and IT on system solutions. A deep understanding of Payroll and Finance business processes, both conceptually and how they apply within the Oracle Cloud tools, will help to identify efficiencies, insights, and best practices in these areas. This role requires hands-on experience and a solid understanding of Oracle integrations between modules as well as to external (non-Oracle) applications.
Responsibilities

Responsible for the on-going support and progression of the company's Oracle Cloud platform focused on Payroll under HCM and Financial modules.
Understand dependencies and interrelationships between Oracle Cloud Payroll and Oracle HCM modules.
Understand business processes, how the application supports the business processes, and apply this knowledge to best solve problems
Execute Oracle quarterly upgrade testing
Partner with Oracle CoE members to identify opportunities to enhance the process and system, with the ability to effectively communicate ideas to the team
Engage with IT Managed Services on break-fix and enhancement solutions
Provide alternatives and recommendations based on best practices and application functionality
Keep abreast of Oracle roadmap and key functionality to identify opportunities where it will enhance the current process within the entire Financials ecosystem
Develop and maintain company's Oracle training documents
Support and document configurations, customization, reports and interfaces, testing and user training
On exception basis, act as backup to Payroll personnel and be able to process standard payroll, following user guides
Help to define and maintain a data governance process to provide stability and data integrity across financial systems

Qualifications: Required

3+ years of experience implementing and/or supporting Oracle Cloud Payroll, HCM, and ERP
Bachelor's Degree (Finance or Accounting degree preferred)
Hands-on configuration experience and ability to create elements and define balance feeds
Experience working in, or directly supporting, U.S. payroll operations
Strong problem solving and troubleshooting skills with the ability to exercise mature judgement
Proven ability to collaborate with internal clients in an agile manner, leveraging design thinking approaches
Experience conducting testing (e.g., system, integration, performance, and user acceptance testing), and preparing deliverables including design documents, test documentation, training materials, and administration/procedural guides
Demonstrated ability to create and maintain system documentation, both functional and technical
Ability to support training of internal team members
Committed to a continuous learning environment to build expertise in Oracle technologies
Ability to collaborate with other members of Finance, HR and IT
Excellent Excel skills
Strong oral and written communication skills

Qualifications: Preferred

Oracle Cloud certifications
Experience integrating Oracle Cloud Payroll with external applications
Experience creating Fast Formulas
Experience building custom reports and data extracts to meet regulatory and compliance requirements
Experience leading a project and participating on a project team
Working knowledge of 401K plans
Working knowledge of US Payroll Taxation, including reciprocity
Working knowledge of accounting principles and financial statements
Knowledge in Controllership processes including account reconciliations, accounting operations, and month end close, according to US GAAP
Change Management: Ability to help people and teams with the transition or transformation of an organization's or function's goals, processes, tools or technologies.
Process Mapping: Skills to visually describe the detailed flow of a process, using flowcharts.
Data Interpretation: Skills to correctly extract, analyze and intuit meaningful information or data from the various data sources, such as structured and unstructured dataset, charts, tables, graphs, etc.
MBA, CPA, FPC, CPP certification

Physical Job Requirements

(The physical demands and work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform the essential functions.)

General office environment; may be required to travel. While performing the duties of this job, the employee is regularly required to talk or hear. The employee frequently is required to sit (remain stationary within work area) and use hands to finger, handle, feel and reach. The employee is occasionally required to move about (stand, walk). The employee must occasionally lift and/or transport up to 10 pounds.

The above job description is intended to describe the general content of and requirements for the performance of this job. It is not to be construed as an exhaustive statement of duties, responsibilities or requirements.

ESSENTIAL FUNCTIONS

* Is a key team member on the multi-year Oracle ERP with excellent knowledge in SCM modules like Inventory, BOM, WIP, MRP, Purchasing, WMS, and Order Management.
* Reviews and analyzes the effectiveness and efficiency of existing business processes/ systems/ technologies used in/for Supply Chain Management and develops strategies for improving or leveraging these systems.
* Considers business implications of the application of technology to the current business environment. Defines functional and system requirements accordingly.
* Ensures that any new software integration meets functional/ end user requirements, compliance and interface specifications, and proper documentation are maintained.
* Creates technical design and implementation documentation
* Develops effective test scenarios, scripts and use cases with consideration to cross functional and process stream impact.
* Development and Improvement of in-house tool set used by business user based on Oracle Forms, Reports, OAF, Java, and UNIX.
* Strong experience with Oracle Forms/Reports, SQL, PL/SQL, Open Interfaces, and APIs.
* Analyzes formal test results in order to discover and resolve defects, bugs, errors, configuration issues, and interoperability flaws.
* Performs application system administration functions specific to application setup, configuration and maintenance.
* Oversees small projects and/or tasks and phases of larger projects. Responsible for coordinating activities of teams, schedules and resources for assigned tasks or projects.
* Performs system, process and application monitoring and gathers metrics.
* Carries out procedures to ensure that all information systems products and services meet quality, organization standards and end user requirements
* Manages and mentors junior and offshore team members

POSITION QUALIFICATIONS

* Excellent Knowledge of the business enterprise functions and processes.
* Excellent analytical and problem-solving skills
* Ability to adapt to a fast and dynamic environment.
* Ability to effectively translate between functional and technical teams
* Ability to follow procedures and produce/maintain supporting documentation.
* Resolves simple to complex system problems in creative ways.
* Excellent written, oral, and interpersonal communication skills.
* Excellent time management
* Highly self-motivated, self-directed, and attentive to detail.
* Ability to effectively prioritize and execute tasks in a high-pressure environment.
* Extensive experience working in a team-oriented, collaborative environment
* Ability to produce exceptional quality output.
* Ability to suggest technological solutions.
* Ability to communicate effectively with senior management
* Adapts readily to changes in workload, staffing and scheduling.

Technologies:

* Oracle eBusiness Suite- Inventory, BOM, WIP, MRP, Purchasing, WMS, and Order Management.
* Oracle Advanced PLSQL, Forms, report, OAF
* Unix shell scripting
* Java development/support experience a plus.
* Knowledge of Oracle Financial applications a big plus (AP, AR, GL, Fixed Assets, Cash Management, etc.)

Additionally, the candidate should be vendor and product agnostic and have the ability to adapt and absorb new and emerging standards in the software development environment such as Open Source, etc. The candidate must display the ability to lead discussions and encourage thought on enabling business value and growth through rapid integration and delivery.

EDUCATION & EXPERIENCE

* Candidates should have completed a US or Foreign equivalent Bachelor's degree in Computer Science, Engineering or related technical faculty and at least 5 additional years of experience in similar field OR Masters in Computer Science, Engineering or related technical faculty and at least 4 year of experience in similar job.
* At least 5 years' relevant experience in the specific function's business processes, supporting systems and 3 - 5 years' experience in Oracle EBS R12 - Supply Chain Management (Inventory, BOM, WIP, MRP, Purchasing, WMS, and Order Management).
* Commensurate Technical experience to perform the job duties.

INDCH

About Harry & David

Since 1934, Harry & David has been America's premier choice in gourmet food gifting. Headquartered in Southern Oregon, Harry & David owns and operates 20 different orchards, spread over 100 square miles, featuring fresh yearly crops of handpicked delicious fruit, including peaches, Bosc pears and the iconic Royal Riviera pears. Harry & David offers a wide variety of options for everyday sharing and entertaining, including Moose Munch premium popcorn, Wolferman's Bakery , Cushman's and Stock Yards branded products. Harry & David is part of the 1-800-FLOWERS.COM, Inc. family of brands. Shares in 1-800-FLOWERS.COM, Inc. are traded on the NASDAQ Global Select Market, ticker symbol: FLWS.

Our Commitment to Diversity

At 1-800-FLOWERS.COM, Inc., we seek to inspire more human expression, connection, and celebration -- for everyone. This means fostering a culture of inclusion where our team members, customers, and partners feel respected, valued, and empowered. We believe that embracing diversity, and celebrating the uniqueness of every individual, makes us a better company.