• The Programmer Analyst is responsible for the development of simple to medium complexity application design, programs and related facilities according to approved business specifications, regulatory and company standards.
• Provides high level assessment for application system change requirements and technical inputs for user requirements during the preparation of impact document and business case documents
• Collaborates with the Business Analyst to provide design inputs and estimates in the preparation of requirements document.
• Documents system design and program specification in technical design document.
• Writes programs and codes based on approved technical design document.
• Develop prototypes as needed
• Conducts unit testing on written codes to ensure program perform per design at the unit level.
• Coordinates with vendor or conducts own investigation and resolution of errors reported during SIT and UAT.
• Maintain the systems once they are up and running in production, and perform production fixes or application enhancements as needed.
• Performs the above function in compliance with software development lifecycle standards of the company.
• Creating summaries or reports that can be used by the leads during presentations.
• Communicating with the client regarding changes request and sub-leading in supporting applications.
• Creating Deployment manuals and conduct actual deployment in Production Environment.
• Providing support and conduct Knowledge Transfer to other members as an SME of the system.
• Analyzing, Modifying and developing existing PL/SQL packages based on change requests.
• Handling and providing technical support and respond to inquiries about E-Business Suite System.
• Creating and executing Unit tests and System tests for the Programs developed.

• Bachelor's Degree in IT or Related course.

• Minimum 3 years of experience in Oracle PL/SQL programming/development. 

• Must have experience in monitoring and supporting the client’s database using SQL Developer and UNIX. 

• Must have experience in monitoring Oracle Batch Processes (Morning and Night Batch Processing) using UC4 AppworX and Oracle Data Integrator Facilitates reports using SQL Server Reporting Services (SSRS) 

• Must have 3 years of experience in PL/SQL language and Oracle E-business Suite R12 

• Must have experience in SQL Developer, SQL * Plus, and MySQL database

• Must have experience in Web Development using PHP, MySQL, CSS, Bootstrap/Java Script 

• Must have experience in Software Development Life Cycle 

• Must have good communication skills. 

TECHNICAL SKILLS: (Non-negotiable)

• Oracle RMS
• Oracle SIM
• Oracle WMS
• Oracle RPM
• Bi-Publisher
• UNIX/LINUX
• Apache
• Oracle Forms and Reports
• SAP
• Oracle 12g
• Oracle PL/SQL