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 IntegrationMust be expert in Oracle OICMust 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 effortsAbility 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 ERPCollaborate 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.