Oracle Fusion Finance Technical Consultant
Job Description-
- Generating data and reporting requirements to support solution design and future business requirements
- Build Oracle BI Publisher (BIP) reports using data models.
- Assist with data mapping between Oracle Fusion data tables and current database table structures in Snowflake
- Create business reports, info tiles, and related dashboards with Oracle Fusion
- Design and implement custom reports using Oracle Fusion reporting tools to address company needs and business requirements
- Maintain expert product knowledge and use an analytical approach to identifying opportunities for enhancements; understand the Oracle out-of-the-box standard reporting options
- Create documentation and maintain custom reports, dashboard, and info tiles throughout quarterly upgrades; develop test scripts and manage execution
- Create and maintain standards and controls around productivity metrics and reporting for consistency across the department; maintain documentation for report creation and procedures
- Monitor and analyze key performance indicators to assess reports, performance, user engagement, and impacts on business outcomes
- Assist users with personalization, mobile features, report scheduling, and processing
Required Knowledge, Skills & Experience-
- 3-5 years of experience in Oracle Cloud ERP Financials applications, including General Ledger, Payables, Expenses, Assets and Receivables
- Hands-on experience in building Oracle BIP, OTBI reports, and Analysis reports using data models.
- Proficiency in creating templates such as RTF, e-text, Excel, etc.
- Expertise in Oracle technologies such as OTBI, BIP/XML Publisher, SQL, PL/SQL, and Oracle Reports
- Experience in customizing reports using BI templates.
- Familiarity with using SOAP UI
- Bachelor's degree in finance, Accounting, IT, Computer Science or related field
- Excellent problem-solving skills with experience in solutioning and troubleshooting
- Strong analytical skills and ability to think in a complex and rapidly changing environment
- Excellent oral and written communication and interpersonal skills, with the ability to effectively collaborate with diverse stakeholders, both technical and non-technical
- Extensive experience in working with reporting software, including knowledge of SQL and basic table structures
- Strong business acumen and the ability to translate business requirements into technical specifications and vice versa
- Deep understanding of corporate reporting standards
- Project management skills to coordinate and oversee reporting strategies for current and future implementations
- Training and presentation skills to effectively educate and support employees in utilizing the dashboards, info tiles, and reports
- Analytical mindset and problem-solving abilities to identify process inefficiencies and propose effective solutions
- Proficient in Office 365 Suite with emphasis on Microsoft Excel
- Proficiency in data analysis tools (e.g., Sigma, Python, R, SQL) and data visualization tools (e.g., MicroStrategy, Tableau, Power BI)
