Oracle Sr Functional Analyst

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 Service Now process for Code Migrations, System Configurations.

• 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 life cycles 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