Oracle EBS/Cloud Techno-Functional Consultant

Job Title: Oracle EBS/Cloud Techno-Functional Consultant 

Roles & Responsibilities:

Strong functional understanding of Oracle Cloud SCM and FIN business processes including Procure-to-Pay (P2P), Order-to-Cash (O2C), Inventory, Procurement, Payables, Receivables, General Ledger, Fixed Assets, Cash Management, and Projects. 

• Collaborate closely with business stakeholders, functional consultants, SMEs, and client teams to gather requirements, perform solution analysis, and deliver scalable solutions. 
• Understand business requirements and translate them into technical design documents, data models, reports, integrations, and analytics solutions. 
• Develop and support BI Publisher Reports, SQL/PLSQL components, and Oracle reporting solutions. 
• Work on data extraction, transformation, and loading activities using Oracle data models and integration frameworks. 
• Participate in data pipeline concepts understanding for reporting, analytics, and downstream integrations.

 • Strong understanding of Oracle data models, and transactional data flow across SCM and FIN modules.

 • Support analytics and reporting initiatives by enabling business insights through dashboards, KPIs, OTBI, BI Publisher, and data analysis solutions. 

• Optimize PL/SQL code and SQL queries to enhance performance and troubleshoot technical issues. 
• Work closely with cross-functional teams, business users, and support teams during implementation and support phases. 
• Lead small to medium-sized teams and mentor junior team members in technical and functional areas. 
• Handle client communications independently and manage expectations across business and IT teams. 
• Conduct requirement workshops, status meetings, solution walkthroughs, and user training sessions.

 • Participate in testing activities including SIT, UAT, deployment, cutover, and post-go-live support. 

• Prepare and maintain technical documentation, functional specifications, solution design documents, and support artifacts. 
• Ensure adherence to Oracle Cloud best practices, coding standards, governance, and security guidelines. Knowledge and Skills: Required: 
• 8+ years of strong techno-functional experience in Oracle EBS/Cloud across SCM, FIN and Projects modules. 
• Strong functional expertise in Oracle SCM and FIN modules with good understanding of end-to-end business processes. 
• Hands-on experience in Oracle BI Publisher, OTBI Reports, SQL & PL/SQL with analytics/reporting tools and enterprise reporting frameworks 
• Experience in understanding data pipeline concepts, data transformation/migrations and integration processes. 
• Knowledge of analytics, KPI reporting, dashboards, and business intelligence concepts. 
• Proficiency in performance tuning and optimization of SQL/PLSQL code. 
• Strong knowledge of Oracle database architecture and database objects.

 • Ability to analyze complex business requirements and provide effective techno-functional solutions. 

• Experience in client handling, stakeholder management, and coordination with onsite/offshore teams. 
• Experience leading small project teams and mentoring junior resources. 
• Strong analytical and problem-solving capabilities.

 • Excellent communication, presentation, and interpersonal skills across all organizational levels. 

• Self-driven with the ability to work independently with minimal supervision. 
• Strong team player with a proactive and positive attitude. 
• Ability and willingness to learn new technologies and adapt based on project needs.