11/16/2025 updated
100 % available
Oracle EBS R12 Developer | PL/SQL & AWS Cloud | 10 Years Enterprise Experience
Pasig, Philippines
Worldwide
BS Information TechnologyAbout me
Specialized Oracle EBS developer with proven track record delivering mission-critical enterprise solutions. Based in Manila, available for remote contracts worldwide with flexible timezone coverage (APAC, EU, US). Strong communicator with experience managing cross-regional stakeholder relationships.
Amazon Web ServicesAmazon S3TelecommunicationsDatabasesExtract Transform Load (ETL)Incident ResponseFinancesHealth CareManufacturingOracle ApplicationsVenta al por MenorSupply Chain ManagementPL-SQLStock ControlSQL Optimization
Oracle EBS R12 Specialist with 10 years optimizing enterprise databases and delivering high-performance solutions across Financials (AP/AR/GL), Supply Chain (PO/Inventory), and HR modules.
Core Expertise:
• Database Performance Tuning - SQL optimization, AWR analysis, execution plans, indexing (50% execution time reduction)
• PL/SQL Development - Packages, procedures, functions, triggers, bulk operations
• Oracle EBS R12 - RICE objects (Reports, Interfaces, Conversions, Extensions)
• AWS Cloud - Glue ETL pipelines, Lambda, CloudWatch monitoring, S3
• Workflow & Reporting - Oracle Workflow Builder, BI Publisher custom solutions
Industries: Healthcare, Telecom, Retail, Logistics, Manufacturing, Government
Key Achievements:
• 50% reduction in query execution times (SQL tuning, cursor optimization, indexing)
• 60% workflow efficiency improvement (Oracle Workflow redesign)
• 40% faster incident response (OpenSearch/Kibana monitoring)
• 30% ETL failure reduction (AWS Glue proactive alerting)
Experience
Professional experience10+ years
Freelancer since2025
Languages
EnglishFluent
Project history
Data Automation and ETL Pipeline Stabilization
• Monitored AWS Glue pipeline for LATAM data ingestion, reducing failure rate by 30% through proactive CloudWatch alerting
• Reduced incident response time by 40% by implementing OpenSearch/Kibana dashboards for real-time log analysis
• Developed Python/Selenium automation for encryption/decryption validation
• Built and deployed Oracle schema changes supporting CI/CD workflows via GitHub Actions and Jenkins
• Enhanced PL/SQL queries for data integrity checks and batch alignment
• Provided L3 incident triage and root cause analysis
Result: Improved data integrity and doubled personal ticket closure rate (3→6 daily)
Technologies: AWS Glue, Lambda, CloudWatch, OpenSearch/Kibana, Oracle Database, PL/SQL, Python, Selenium, GitHub Actions, Jenkins
Enterprise Notification Workflow Optimization
• Partnered with VP and functional manager to analyze Oracle Internet Expense Workflow logic
• Diagnosed bottlenecks and redesigned PL/SQL/Workflow Builder processes to eliminate duplicate alerts
• Reduced redundant notifications by 60%, cutting approval burden for senior executives
• Accelerated workflow turnaround by 25%
Result: Significant efficiency gains for executive-level approvals and faster expense processing
Technologies: Oracle EBS R12, Workflow Builder, PL/SQL, Oracle Forms
National-Scale Web Portal and API Integration
• Developed PL/SQL packages and Oracle APEX modules for government portal serving 10K+ daily users
• Implemented REST API integration, SMS gateway, and reporting features
• Optimized queries and indexing for performance
• Ensured security through parameterized queries and input validation
Result: Improved page load times by 35%, ensuring secure data transactions for national-scale government portal
Technologies: Oracle APEX, PL/SQL, REST APIs, Oracle Database, SMS Gateway