Pedro Pucheta

Senior Oracle E-Business Suite Developer with 20+ years of experience translating business requirements into secure, scalable application code for Oracle Financial modules. Expert in PL/SQL, Unix shell scripting, XML Publisher, WebADI, Workflow, OAF, and Business Events, with strong experience in LATAM localizations. Proven ability to perform code reviews, performance tuning, unit testing, documentation, and provide on-call production support in enterprise environments. Strong communicator with experience collaborating with cross-functional and offshore teams.

PROFESSIONAL EXPERIENCE

Senior Oracle EBS Developer – Tata Consultancy Services (TCS)

Apr 2022 – Nov 2024

• Provided Level 2/3 production support for AP, PO, AR, FA, GL and PA modules.
• Designed and developed custom PL/SQL solutions and interfaces for AP, AR and PO.
• Supported Month-End Close activities for AP, ensuring data accuracy and compliance.
• Analyzed and tested Oracle patches impacting standard and custom processes.
• Developed custom Fixed Assets reports using XML Publisher.
• Resolved production incidents leveraging Oracle SRs and root cause analysis.
• Translated business and functional requirements into technical design documents and application code.
• Prepared Technical Design Documents (TDD), Functional Specifications and Unit Test documents.
• Participated in code reviews to ensure compliance with architectural and SSDLC standards.
• Provided after-hours and on-call production support for critical financial processes.

Jul 2020 – Jul 2021

• Designed and implemented custom AP Supplier processes integrated with Oracle RMS.
• Authored technical documentation and supported Go-Live and post-production stabilization.

Jul 2020 – Jul 2021

• Developed custom AR, AP and GL financial reports for invoicing and reconciliation.
• Enhanced AR interfaces to automate customer creation using Oracle APIs.
• Defined and registered new concurrent programs and request sets.

Jun 2019 – Oct 2019

• Led migration of custom developments from Oracle EBS R12.1.3 to R12.2.7.
• Managed a development team and coordinated technical migration activities.
• Designed data mappings and developed interfaces to Oracle Leasing and Financial Management (OLFM).
• Supported Go-Live and post-migration stabilization.

Jun 2018 – Jan 2019

• Developed PL/SQL packages for contract extraction to OLFM from legacy systems.
• Led migration of database custom objects from R12.1.3 to R12.2.7.
• Built data extraction programs for Inventory, Purchasing, AP and HR modules.

Senior Oracle EBS Developer / Consultant – Multiple Clients (2003–2017)

Oracle Mexico, Metalsa, AT&T, LATBC, Nubaj, Sukarne, Quadrantix, Alpura, Gates USA, Bimbo USA, Alsea, GE Transportation, Televisa, Xerox Mexicana

• Oracle EBS implementations, upgrades, and production support.
• Development of custom Forms, Reports, Interfaces, APIs and Conversions.
• Performance tuning and database optimization.

Bachelor of Science in Computer Systems Engineering

Instituto Tecnológico de Veracruz