This profile is written in Spanish
Oracle EBS Procurement Functional Consultant
Experiencia demostrada en SQL / PLSQL.
Experiencia demostrada en Python (Pandas).
Experiencia demostrada en Oracle Developer (Forms, Reports).
Experiencia demostrada en Java (Support).
Experiencia demostrada en Unix.
Oracle EBS Procurement Functional Consultant buscando nuevas oportunidades
Give technical/development solutions to customers. This solutions are focused on Warehouse Management System product from Oracle.. Create datafix and provided analysis to issues reported by customers.. Develop new functionality and/or fixing current functionality according to customer issues, improving WMS product.. Automation of daily or repeat task helping to improve our analysis or datafix generation using Python; this reduced the timing of analysis up to 40% due to processing and analyzing Excel files for thousand of records per customer.. Analysis performed thru PLSQL, Oracle Forms, Java.. Experience working on WMS and modules related to such as PO (PO, Blanket PO, Requisitions), OM (SO, ISO, Picking, Releasing), INV (Item Creation, Material Transactions)
Supported end-to-end development activities across requirement handover, requirement clarification, coding, unit testing, and post-development support during QA and UAT phases.. Collected and clarified business and technical requirements through handover sessions and follow-up meetings; executed development tasks based on confirmed requirements and performed unit testing to validate basic functionality and quality; coordinated with QA and UAT stakeholders to investigate defects, answer functional or technical questions, and support issue resolution; participated in regular meetings to track development progress, confirm new requirements, and align on delivery priorities.. Using Python scripts to help to create the pattern used for database objects creation; this reduced the pattern creation up to 20%. This script only created the pattern to create all objects required at Database level.. Creation database objects such as Package, Procedures, Triggers.
Induction training
Only Some trainings attend: PLSQL / SQL Concepts, Introduction to Python, Introduction to Javascript.. Support Activities for PLSQL objects: Packages, functions, procedures.. Troubleshooting of errors raised by database objects.. Scripting to create PLSQL Blocks for data fixes.
Attention and solution to Technical Issues related to Custom Programs from EBS. These activities include developments related to new functionalities or code fix in order to fix some bugs on Production instance.. Resolving technical issues which are affecting user activities and these are related to Customizations. Analyzing code in order to find RCA for frequent issues which used to be stoppers.. Working on give solutions for some RCA obtained in order to fix those issues and avoiding those one still happen.. Working on coordinate some internal activities in Team (8 Team members).. Using Oracle XML Publisher to create/define some invoices and PO format, create some reports format for month end process, generate export and import documents.. Exposure to modules such as PO, INV, OM, AR, AP - Experience as a techno functional consultance.
Development activities related to new functionalities or code fix in order to fix some bugs on Production instance. Supporting users in order to give solutions and on this way users can be able to continue working on their activities.. Analyzing code in order to find root cause (RCA s) for some frequent issues like: Process failing, bad performance, etc. R12 – These activities are similar to above listed but these ones are related to R12 version for Oracle Applications. Activities involved or related to new functionality or features. Understanding that there are some differences between 11i and R12 versions.. Technical and functional support for the customer related to Oracle EBS products attending most of the modules in EBS such as Inventory, Order Management, Purchasing, Account Receivables, Manufacturing, etc.. Monitoring of automatic process executed in Appworx in order to prevent or fix possible issues that affect to customer/users activities. Support to users: Reprocessing PO, data fix executions, some setups for items.. Working/helping as technical leader inside our team, helping to team to clarify doubts, understand some business process, coaching for some new team members.. Coordinate internal task for the team, i.e. on call rotation, work shift rotations, vacations, tickets assigment.. Participate in customer calls, incident P1/P2 calls, etc.. Creation and support to custom Item creation interface in order to create items according to very specific customer requirements.
Monitoring of computers that execute automatically several applications.. Analysis of applications that usually fail.. Installation of software on computers (robots) in order to improve performance.. Help to create/modify some small PL SQL blocks.. Technical environment: Use HP Tools for monitoring.