Daniel Garay Monroy

• Coordinated with the front end design team to provide them with the necessary stored procedures, packages interfaces and the necessary insight into the inventory, purchasing, order management and project creation and billing.
• Generated custom packages and procedures to send and receive information from 3rd party application (Sales Force) using Oracle Middleware and CPI to read all data in XML format, to create inventory transactions, requisition creation, project creation and updates, customer sync.
• Generated custom packages and procedures to send and receive information from 3rd party application (CPQ), to create inventory on hand and reservation transactions
• Attending defects on JIRA for every integration / interface developed, coordinated with all users to solve and approach the best solution (code changes, enhancements)
• Migrated custom forms from R12 to 11i, redeveloped the logic and implemented best practices to improve performance
• Involved in the continuous enhancements and fixing of production problems, giving strong analysis
• Generated multiple reports using XML Publisher, shipments, receptions, invoices, inventory, requisitions and on hand inventory information
• Collaborated with cross-functional teams to develop high-quality business applications, resulting in increased operational efficiency.
• Conducted thorough code reviews to maintain consistency, improve code quality, and adhere to industry best practices.
• Optimized database performance by implementing efficient SQL queries and PL/SQL procedures.
• Developed custom Oracle XML Reports for improved decision-making and strategic planning within the organization for Inventory InTransit information.

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the inventory and order management data
• Generated scripts for data manipulation, data transformation and data validation for Receiving process.
• Generated custom packages and procedures to send and receive information from 3rd party application (IPACS) and Oracle Golden Gate, to create a material receptions and rejections (RCV) using standard interface.
• Involved in the continuous enhancements and fixing of production problems, giving strong analysis
• Created custom tables for faster retrieval of the data to enhance database performance in XML publisher reports
• Involved in data loading for projects information using PL/SQL and SQL procedures
• Loader calling UNIX scripts to download and manipulate flat files and insert all information into custom temporary tables
• Created scripts to extract huge amounts of requisition data from the operational database into flat text files using UTL_FILE package and send them to 3rd party partners to review and process.
• Generated a custom process to massive update and close projects (PA) and related project tasks
• Conducted data modeling, performance and integration testing.
• Optimized database performance by implementing efficient SQL queries and PL/SQL procedures.
• Streamlined data migration processes for seamless system upgrades and reduced downtime.
• Increased application reliability through rigorous testing efforts that identified potential bugs before entering production environments.
• Collaborated with cross-functional teams to develop high-quality business applications, resulting in increased operational efficiency.
• Enhanced user satisfaction by providing timely support, resolving technical issues, and offering solutions to complex problems.
• Conducted thorough code reviews to maintain consistency, improve code quality, and adhere to industry best practices.
• Mentored junior developers on Oracle technologies, promoting a culture of continuous learning within the team.
• Followed standard methodologies on coding to write clean and self-documenting code.
• Estimated work hours and tracked progress using Scrum methodology.
• Actively participated in project planning, resource allocation, and project management activities to ensure timely delivery of high-quality solutions.

Tip Mexico:

• Oracle implementation from scratch R12.2.7
• Created multiple reports using advanced xml publisher (multi tab excel reports), OM, EAM, INV, OLFM, AR, AP
• Generated custom packages and procedures to send and receive information from 3rd party applications and old transactional databases and process bulk information into inventory management
• Created all the custom packages and procedures to upload customer information (sites, site uses, contacts, bank accounts, receipt methods) using standard customer interface
• Created all the custom packages and procedures to upload supplier information (sites, contacts) using standard supplier API

Engenium Capital:

• Implemented a new purchase order document (PDF output) using XML Publisher and XML Bursting to send all the documents automatically to every customer
• Support after successful implementation (3 months)
• Extraction for new and updated employee data in XML format from Oracle Cloud
• Generated a new procedure to read employee, person and payroll information, validation of data and creation of employees in Oracle R12 db using the seeded oracle API's.
• Creation for new employees and payroll information in Oracle Cloud, based on extracted information from R12 db.
• Actively participated in project planning, resource allocation, and project management activities to ensure timely delivery of high-quality solutions.
• Translated technical concepts and information into terms parties could easily comprehend.
• Corrected, modified and upgraded software to improve performance.

• Created and implemented a new detailed report using XML Publisher with all the brokers, agreements and customer relationship information (multi tab excel report)
• Coordinated with the Canadian and US users to provide them with the necessary stored procedures and packages and the necessary insight into the broker and customer data
• Generated a new interface for massive update and reassign customer brokers, agreements, customer relationships, locations and categories
• Personalization on a custom receivable invoices form (Brazil) to select only one type of credit in credit memo cancellations, based on the responsibility used (super user)
• Updated custom WMS form to select only orders that have all the attributes available and send them to a 3rd party database with a web service
• Implemented XML Bursting general procedure (utility) to send actual and new reports via email
• Created a new multi tab report to gather all the errors during WMS interface import and send them to the inventory area for re-processing or reviewing
• Implemented a new procedure to read a flat text file, upload all the information to custom tables and receive purchase orders using standard open interface, validating correctly all the inventory, sub inventory and organization information
• Generated multiple reports using XML Publisher, shipments, receptions, invoices, inventory, requisitions and on hand inventory information by subinventory and SKU
• Extensively used bulk collection in objects for improving the performance, created tables, collections (nested tables and arrays) for improving query performance by reducing context switching and used the advanced features of PL/SQL like object types and dynamic SQL.
• Optimized database performance by implementing efficient SQL queries and PL/SQL procedures.
• Evaluated emerging technologies relevant to the organization''s needs, recommending appropriate tools and techniques when necessary to drive innovation in product development.

• Oracle full migration from Release 11 to Release
• Created a new procedure to extract all the customer information from R11 based on a layout
• Generated a new procedure for initial customer load in R12, customer information, sites information, site use information and contact information
• Created a new complex report using discoverer for billing history, balances and account statements
• Implemented electronic invoicing, creating xml files, spool files and send them to Signature Portal (XDOC), generated a new procedure to read the UUID information and upload it to stage invoice tables using standard API
• Used SQL
• Loader as an ETL tool to load data into the staging GL tables
• Creation, monitoring and tracking of RFC & Service Request directly with the Oracle support team (conferences, coordination and application of changes, patches or data.