Pedro Pucheta

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.

Oracle EBS Consultant – Valtre

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.

Oracle EBS Consultant – Ataway

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.

Oracle EBS Technical Lead / Consultant – Freelance

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.

Oracle EBS Consultant – Net@ Systems

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.

Earlier Experience (Summary)

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.

Technical leadership and client-facing coordination.

Bachelor of Science in Computer Systems Engineering
Instituto Tecnológico de Veracruz