Oracle APPS technical consultant

Role : Oracle ERP consultant

Experience: 4-8 years

Involves L3 support and Development activities.

Good at Work Order Management, Item/Bill of materials, Quality Assurance, Order Management

Experience Level: 8 Yrs

Oracle EBS Techno Functional

Work from Office

Job Location Hyderabad or Chennai or can be remote for subcons

Tech round+ management + client round

Candidate should be excellent in oracle Finance techno functional role ( oracle apps) with EBS + Finance modules ( AP+AR+GL) + Insurance domain + Production application support project specifically in UAE based project experience.

• Experience in Oracle EBS (Technical) with R12 release.
• • Very good knowledge of R12 financial table structure.
• • Good Hands on Knowledge of SQL, PLSQL, Oracle reports, Oracle form. OAF/ADF, BI publisher reports, Shell scripting.
• • . Should have good Analytical and debugging skills.
• • Should have development experience in the EBS environment in Reports, Interfaces, Conversions, Extensions, Workflow (RICEW) and Forms deliverables.
• • Experience in P2P, Oracle General Ledger (GL), Account Payables (AP), Receivables (AR), Cash Management (CM), Sub-ledger Accounting (SLA), and System administrator modules.
• • Experience of end-user interaction for requirements gathering, understanding customer needs and working with multiple groups to coordinate and carry out technical activities which include new development, maintenance and production support activities.
• • Should have good knowledge of Agile Methodologies

Bachelor's degree in Computer Science, or information technology from an accredited institution; or equivalent experience

Key Responsibilities & Job Duties

● To provide functional support for our ERP

Finance applications (Oracle eBusiness Suite)

○ Assist users in case of question

○ Manage functional requests

● Train users to keep the right level of skill

○ To organize audits of the use of systems

○ Detect and collect issues

○ Implement action plan and coordinate actions

● To manage enhancements in accordance with the procedures which apply in the department

○ Collect enhancements from users

○ Challenge the user requirements

● Define priorities

○ Write functional specifications and coordinate developments with the technical team

● Test and train the users

○ Regularly communicate to the users the status of the enhancement

○ Report activity to the management

○ Collaborate with functional support in other zones to share information

○ Optionally, may manage some projects

Key Technical & Functional Competencies
● Functional competencies

○ Strong Business processes: Finance

● Technical competencies

○ Good Knowledge of Oracle SQL

○ Strong Oracle eBusiness Suite

Modules: AP, AR, GL, FA (At least at a professional for two Modules)

○ Basic knowledge of Oracle eBusiness Suite Modules: INV, PO, OE, WSH is preferable

Required:
1) WebFOCUS BI Reporting
2) WebFOCUS Adminstration
3) Sybase or Oracle or SQL Server or Snowflake
4) DWH Skills

Nice to have:
1) Experience in SAP BO / Crystal report / SSRS / Power BI
2) Experience in Informix
3) Experience in ETL

Responsibilities:

• Technical knowledge regarding best practices of BI development / integration.
• Candidate must understand business processes, be a detailed-oriented person and quickly grasp new concepts.
• Additionally the candidate will have strong presentation, interpersonal, software development and work management skills.
• Strong Advanced SQL programming skills are required
• Proficient in MS Word, Excel, Access, and PowerPoint
• Experience working with one or more BI Reporting tools as Analyst/Developer.
• Knowledge of data mining techniques and procedures and knowing when their use is appropriate
• Ability to present complex information in an understandable and compelling manner.
• Experience converting reports from one reporting tool to another

• 6 - 10 years’ experience in Oracle EBS (Techno-Functional)
• Experience in implementation, Support, and upgrade projects
• Experience at least in 2 R12.2 upgrade projects.
• Experience in Oracle EBS R12.2.7 or Higher versions of R12.
• Strong knowledge in SQL/PLSQL, Reports, Forms, and workflow. OAF is added advantage.
• At least 40% functional knowledge in SCM and Manufacturing (Modules: PO, OM, INV, WIP, BOM, Quality and Engineering)
• Excellent verbal and written communication skills

Excellent knowledge with proven implementation experience of:  Axiom Controller View V9 / V10 (2+ years’ experience).  Building and configuring Axiom workflows to solve complex business problems and mapping to Axiom data dictionaries.   XBRL and template disclosure submission including taxonomy, data point model and validations experience.   Knowledge of EU regulatory reporting requirements (COREP/Statistical) with strong Capital knowledge.  Packaging, deploying, branching Axiom solution including upgrades as part of the software development lifecycle.   Oracle PL/SQL.

• Check the Cmg's and take the requirements from functional consultants and users.
• As per business logic (MD50) do change existing reports and develop the new reports.
• Developing new packages, procedures, functions and updating existing packages and procedures, functions.
• Developing the workflows.
• Developing the API's as per business logic's for data updates.
• Developing the data extraction automation programs (.sql files developments) for data extractions.
• Prepare the test cases and migration documents for migrating objects.

• Bachelor's Degree in IT/ Computers/ Science or Master's in Computer required.
• 2 - 5 years of relevant experience on Oracle Apps Technical.
• Candidates must have hands on experience on Oracle RDF/XML/Pl-SQL Reports, D2k Forms, Workflow, OAF, And functional knowledge on O2C & P2P.