Enterprise Resource Planning Advisor

Oracle  Saas Developer & Integration Consultant

• 10+ years’ Experience on multiple implementations, version upgrades, maintenance, and support projects, including designing, developing processes that fuel swift corrective actions, significant cost savings, and fault-free deliverables.
• Excellent experience of the following Oracle technologies: BI Publisher, OTBI, ATP, Redwood changes, Oracle cloud integration.
• Must be expert in Oracle PL/SQL – should have written complex packages, procedures and functions in Oracle ATP and invoke them through Oracle Cloud Integration
• Must be expert in Oracle OIC
• Must be expert in designing and development of complex customer facing transactional reports using BI-Publisher and OTBI.
• Experience in screen development using VBCS.
• Strong Knowledge of Oracle Fusion Database Tables, Integrations.
• Good knowledge of the following Oracle tools: Oracle FBL, FBDI, ADFDI & SMARTVIEW.
• Perform multiple performance fine-tunings on frequently utilized long running reports queries.
• Good knowledge of the EBS/Oracle Fusion Functional and Database knowledge.
• Extensive expertise in interface development utilizing PL/SQL within Oracle.
• Migrating legacy Integration solutions to Oracle Cloud Integration, resulting in improved scalability and reduced maintenance efforts
• Ability to create various Inbound and Outbound Integrations in Oracle Cloud Integration.
• Proficient in Oracle Rest Data Services (ORDS), Oracle SQL, PL/SQL, and Shell Scripting, with a demonstrated ability to develop new workflows and effectively implement AME in workflow approval processes.
• Excellence in analysing business requirements and designing solutions using AIM/OUM methodology, including meticulous documentation such as MD050, MD070, MD120, CV060, AN050, and DS140, among others.
• Proven ability to handle multiple tasks and collaborate effectively in team environments, with strong interpersonal and communication skills.

Additional skill required on Oracle Security:

• Define and implement robust enterprise security policies within Oracle ERP
• Collaborate with compliance teams to address regulatory requirements (e.g., GDPR, SOX).
• Proactively identify vulnerabilities and remediate risks.
• Manage user role hierarchies and segregation of duties (SoD).
• Creating custom role and privileges as per client requirement.