Oracle Sr Functional Analyst - TechDigital

Duties:

· Design, Implement and support a large-scale Oracle E-Business Suite & Oracle Fusion ERP

· Analyze, Design and Implement comprehensive application solutions for EBS and ERP cloud platforms.

· Utilize creative and cost -effective approach to deliver high quality application solutions

· Design and solution Interface/conversion activities to import data from legacy systems and integrate into Office Depot EBS & Cloud Applications.

· Develop design documents, set up/config guides, Unit test plans using AGILE/SDLC methodologies.

· Responsible for leading Enterprise Scheduling Platform (ESP) Automation of batch jobs

· Provide critical cross-functional support for IT projects and IT portfolio management including Demand Management and Integration Management.

· Analyze, Validate, Retrieve JSON Payloads by executing API's for various project initiatives.

· Writing SQL queries, adhoc reports for financial reconciliation, reporting purposes using development tools like SQL Developer, Toad, OTBI & PostgreSQL.

· Work with Product owners to capture user stories in Agile Framework and translate into technical requirements.

· Configure IT technology set ups, migration plans, test plans and execute basic changes while following standard operating procedures and change/release management policies.

· Create and support Oracle support Service Requests as and when required.

· Apply ITIL based best practices to implement and improve IT service management processes.

· Support Oracle Database Cloud Infrastructure migration upgrade in Functional Testing.

· Support Oracle Financial data conversion activities.

· Review Technical design approach, Technical solution documents for Projects, Enhancements, Bugfixes.

· Ensure process integration across ITIL process areas, documenting IT tooling requirements, IT development/refinement of process, IT procedures, and IT work instructions.

· Follow IT Change Management ServiceNow process for Code Migrations, System Configurations.

Minimum Requirements: Bachelor's degree in Computer Science, Computer Engineering, Electrical Engineering, or related field, plus 5 years of experience in designing, developing, and implementing SDLC in Oracle EBS Applications R12, and demonstrated experience in:

· Full implementation lifecycles of project deliveries for Oracle EBS/ERP Fusion Financial including Account Payables, Account Receivables, TCA Architecture, Cash Management & Bank Reconciliation, Treasury, iReceivables & iExpense Modules, Fixed Assets, Project Accounting, HR.

· Requirement gathering, fit gap analysis, designing/implementing RICEW Components.

· Knowledge of daily cash handling to include cash drawer balancing, opening and closing the day at a point-of-sale system, credit card daily reconciliations.

· Oracle web center image processing.

· Oracle EBS Applications and Oracle Cloud database architecture and database tables, integration points and technology processes.

· Ability to lead the discussion in applying Oracle EBS technology to solve complex implementation issues and provide cross functional support for multiple systems that meet with Oracle EBS.

· Developing FBDI templates and uploads for data conversions and batch imports.

· Analyze data and translate business requirements into Functional specifications.

· Planning and execution of system Integration, Functional Testing, Regression Testing, Performance & UAT Testing.

· OTBI reports and smart views for financial reporting and reconciliation.

· Execute data conversion activities, perform deep dive sessions to map legacy systems data elements to new cloud applications.

· Working understanding of SQL, PL/SQL queries using development tools Toad, SQL Developer, XML/BI Publisher.

· PaaS, SOA/EAI, REST, RTO API's and file transfers using FTP Servers for SIT, UAT.

· Design and solution Interface/Conversion programs to import data from legacy systems using API's.

· AGILE methodology and JIRA tool to plan, manage and track

Mandatory Skills: Oracle E-Business Suite & Oracle Fusion ERP