Oracle Cloud Techno Functional Financial Analyst

Must have hands on experience:

3+ years experience as Oracle Cloud Techno Fucnional Consultant.
(70%- Technical , 30% - Functional)
5-7 years’ experience in IT Field.
Strong Hands on Experience in Oracle SCM or Oracle Financial modules as a technical Consultant.
Should be strongly experienced working with Oracle cloud ERP application particularly on reporting (BI and OTBI)
Advanced understanding of Oracle PAAS offerings and architecture.

Must have knowledge on: 

1) Experience in creation and customization of reports/forms and XML Publisher.
Should have worked in Functional modules (SCM/ Finance)
2) Experience in developing or customizing reports using BI templates.
3) Experience in building Oracle BIP reports, Analysis reports, OTBI and
reports using data models.
4) Should have hands-on experience in BI Publisher (RTF design/ eText/Scheduling/ Parameter Handling/ Bursting/ backup and migration of reportsto different pods).
5) Strong knowledge of writing SQL queries using Oracle Financial or Oracle SCM database tables.
6) Very Strong SQL/PLSQL skills to create custom queries in BI Publisher, Oracle Fusion environment
7)Proficiency in creating reports using templates like RTF, Excel, Pipe delimited, stylesheet, e-text, etc
8) Expertise in working with the Cubes and how to extract data from cubes and joins etc
9) Hands-on experience in converting the reports to ESS jobs for scheduling reports
10)Hands-on experience in migrating the reports between environments
11)Excellent Communication Skills

Good to have Knowledge on:

1) Expertise in Conversions and Integrations via FBDI, Webservices
2) Experience in AP Check printing, Positive pay templates, PO
Printing, AP Printing, automated AR Invoice. Lockbox Processing
/ Bank Statementintegration.
3) Solid understanding of performance tuning best practices and
experience improving end-to-end processing times.
4) Additional Reporting Tools: Analysis Dashboard / ESS Base
Financial reporting studio (FRS) and Smartview reports.
5) Knowledge on Integrations and the OIC module.