Oracle Analyst Job Description
Oracle analyst
provides financial insight for Controllers by developing accurate reports against ERP data stored in Oracle and SQL databases.
Oracle Analyst Duties & Responsibilities
To write an effective oracle analyst job description, begin by listing detailed duties, responsibilities and expectations. We have included oracle analyst job description templates that you can modify and use.
Sample responsibilities for this position include:
Small bit of travel will be required
Create and execute test plans for regression testing for patches, enhancement request, configuration changes
Implement and develop experience across processes financial reporting, order to cash, procure to pay, cash management, configuration management (GRC maintenance experience desirable)
Codes, tests, debugs, benchmark tests, documents and maintains programs
Competent to work on most phases of applications programming activities, but requires instruction and guidance in phases
Provide query construction/modification services using Oracle Business Intelligence Discoverer middleware supporting Corporate enterprise Training Activity Resource System CeTARS Program of Record (POR)
Train customers to build & run queries or use all modules of CeTARS
Provide training data analysis project support
Manage incoming data / training requests in NETC's workflow management program (REMEDY)
Create Standard Operating Procedures (SOP) and other CeTARS POR related artifacts as directed
Oracle Analyst Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Oracle Analyst
List any licenses or certifications required by the position: DEC, PMP, ITIL, DBA, HCM, SQL, R12, BA, CX, APCIS
Education for Oracle Analyst
Typically a job would require a certain level of education.
Employers hiring for the oracle analyst job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and University Degree in Computer Science, Business, Information Systems, Engineering, Education, Finance, Technical, Business/Administration, Accounting, Information Technology
Skills for Oracle Analyst
Desired skills for oracle analyst include:
API’s
Oracle Forms & XML
Oracle Reports
PL/SQL
Project management techniques and processes
Setups
ASCP
Creating complex reports and data updates within an ERP environment
Data modelling
Development and documentation of UAT processes
Desired experience for oracle analyst includes:
Must have hands-on functional and technical knowledge of Project Accounting, Fixed Assets, Purchasing and iProcurement in Oracle eBusiness 11i and R12
Working 3 years in a high caliber consulting company is essential
Ability to create AME rules for requisition approval
Working knowledge of logical apps (11i) and GRC tools (R12)
Experience with EBS 11 and/or 12
Been there, done that and excited to do more business process analysis and redesign
Oracle Analyst Examples
1
Oracle Analyst Job Description
Job Description Example
Our company is looking to fill the role of oracle analyst. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for oracle analyst
- The present job description is not exhaustive
- Work closely with Instance Owners, Business Applications CoE & CIO teams to ensure support is sustainable for all projects/enhancements moving into production
- Analyze patterns in incoming production issues & identify root cause issues
- Coordinate the reconciliation results of data integrations to assure the data integrity of the system
- Respond to user inquiries regarding data, job status, and calculations
- Perform routine maintenance to support the planning and forecasting cycles including manual updates to dimension members, processing of substitution variable changes, maintenance of period and fiscal year open dates, and management of dimension security to open data for edit
- Provides customer service to the assigned business groups and ensures escalated operational needs are met
- Break down the base lines requirements into business and functional requirements
- Prepare high level and low level design and share with supervisor for approval
- Share the design document with the functional team post supervisor review
Qualifications for oracle analyst
- Bachelors degree in Computer Science / Information Systems, required
- Oracle e-Business Suite financials analyst wth 5 years of experience
- Thorough understanding of finance systems and best practices
- Knowledge of core business concepts/components for ecommerce
- You thrive in fast-paced team environments
- Experience in Oracle EBS R12 required
2
Oracle Analyst Job Description
Job Description Example
Our innovative and growing company is searching for experienced candidates for the position of oracle analyst. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for oracle analyst
- Resolve user requests in a timely manner
- Reviews assigned tasks and ensures that alternatives were considered
- Intermediate to advanced understanding of Core HRMS
- Software design, development, and maintenance of applications
- Development Experience in designing / creating data model for data warehouses
- Requirements analysis and development, web systems development, improvements and corrections in Java
- Driving resolution of production support issues predominantly in Order to Cash and Procure to Pay cycle
- Regularly ensuring good health of production systems and data integrity with upstream/downstream systems
- Effectively resolve problems and roadblocks as they occur, consistently following through on details while driving innovation issue resolution and anticipates and prevents problems before they occur
- Debug complex issues and present their impact along with recommended solution to users and management
Qualifications for oracle analyst
- Knowledge of EBS System Administration
- Experience with Process Manufacturing (Inventory, Product Development, Process Execution, Process Costing, MES, Process Quality) will be a differentiator
- Expert in in P2P Modules and Supply chain modules (Purchasing, Payables, iProcurement, Demantra)
- Very good knowledge in AME, Workflow, Sub-ledger Accounting, iSupplier, iExpense
- Working knowledge in other Oracle modules and Purchasing integration with Vertex a plus
- Must be authorized to work for any employer in the US without Visa sponsorship
3
Oracle Analyst Job Description
Job Description Example
Our growing company is looking for an oracle analyst. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for oracle analyst
- Be integral member in signing off the design and solution developed by development teams before accepting the change in Production
- Supporting key business processes/activities including but not limited to Month end and Yearend support activities to Business users
- Utilizing past experience to implement innovative approaches to help improve business processes and system performance
- Improve the enterprise systems by leveraging existing solutions when building new technology
- Collaborate with non ERP development teams to design efficient, supportable and scalable solutions
- Collaborate with Developers, Program Managers and Testers to ensure smooth knowledge transfer for any new project or enhancements going live
- Respond to questions/issues raised by business users regarding Oracle software function
- Write/maintain end user documentation
- Maintain module configurations to tailor software functions to best meet the needs of the business
- Develop test plans, perform and document system testing of software patches and custom enhancements
Qualifications for oracle analyst
- High school diploma or GED and six years experience will also qualify
- UNIX / RHEL
- MQ / IBM / Oracle
- Candidate must be able to read log files and follow complex logical patterns in order to find or troubleshoot issues
- This candidate must be a US Citizen
- Ability to setup and configure related order management modules such as iStore, Configurator, scheduling, ATP, Shipping Management, iSupplier
4
Oracle Analyst Job Description
Job Description Example
Our company is growing rapidly and is looking to fill the role of oracle analyst. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for oracle analyst
- Support, troubleshoot, test and maintain Oracle PL/SQL and Unix Script code and functionality
- Troubleshoot/Maintain effective and efficient PL/SQL packages, procedures, triggers and functions according to design specifications
- Produce “ad-hoc” reports over Oracle data
- Attend Oracle conferences and/or user group meetings, as deemed appropriate by manager
- Continually research Oracle functionality, looking for opportunities to improve configurations and/or business processes
- Follow all current department policies, especially regarding the use of workload management tools
- Train users on software functionality
- Initiate Oracle SR’s (service requests), and monitor to satisfactory resolution
- Serve as liaison between business users and technical resources (developers / database administrators)
- Reviews, analyzes and evaluates customer needs
Qualifications for oracle analyst
- Bachelor’s degree in Engineering/Information systems (B.E./B
- Analyse functional/non-functional requirements and seek clarifications for better understanding of requirements
- University Degree in Computer Science, Information Systems, Engineering, Business Administration, or the equivalent combination of education, training, and experience
- You will have experience in a Oracle Business Analyst or similar role, supporting the Manufacturing applications, using Oracle’s E-Business Suite (EBS), Release 12+ preferred
- Experience in at least three large-scale Oracle implementation projects, particularly in a global environment, including one in a leadership role
- Demonstrated solid understanding of business processes
5
Oracle Analyst Job Description
Job Description Example
Our growing company is looking to fill the role of oracle analyst. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for oracle analyst
- To provide the highest level of customer assistance giving advice and guidance on all issues, dealt with in accordance with the Support Code of Practice and Maintenance contracts
- Manage assigned Incidents effectively and efficiently in accordance with Support processes and procedures
- Keep customer information systems (Jira) up to date with all incidents and any other relevant customer contact activity
- Share information with other team members on key trends and new issues, responding quickly to requests for assistance
- Provide regular updates to knowledgebase ensuring information gathered is relevant and informative
- Review functionality changes to the product proposed by the product management and delivery departments
- Take responsibility for and manage regular updates on service and priorities with specific customers
- Responsible for providing timely and thorough application user support, which includes user training, guidance on navigating through issues in Oracle ERP and issue management / resolution
- Design solutions for the assigned application in support of product development projects and implementation of deliverables
- Design, develop, modify, debug and implement solutions per business requirements
Qualifications for oracle analyst
- Demonstrated ability to document clear business requirements and solutions needed to meet business requirements and to translate the requirements into functional designs for Oracle, 3rd party add-ons, extensions and interfaces
- Proficiency in Oracle E-business Suite in GL, AP, AR, Cash Management
- Oracle eBusiness Suite (Oracle 11i, 12x) technical knowledge/configuration skills
- OSupplier Management and Invoicing Process
- OTax Configuration in E-Business Tax
- OTax Integration with AR and AP