Oracle Developer with over 3+ years of experience specializing in database development, application programming, and cloud solutions. Skilled in Oracle Database, SQL optimization, and data integration with a strong background in analysing, implementing, and enhancing application systems. Proven ability to identify and resolve technical issues, optimize performance, and deliver innovative solutions aligned with organizational objectives
• Developed and optimized integrations using Oracle Integration Cloud (OIC) to connect Oracle ERP Cloud with third-party applications, ensuring seamless data exchange.
• Designed and implemented REST and SOAP web services, integrating ERP Cloud with various external systems using OIC technology adapters (File/FTP, DB, REST, SOAP, and ERP Cloud adapters).
• Designed and optimized database tables and indexes, establishing relationships to ensure data integrity, and support efficient data retrieval.
Increased database query performance by 25% through optimization techniques.
Enhanced system uptime to 99.9% by implementing proactive monitoring tools and regular system audits.
Reduced database response time by 40% by optimizing SQL queries and enhancing index efficiency.
• Implemented database optimization strategies, resulting in a 25% reduction in query processing time.
• Designed and implemented cloud-based solutions using Oracle Cloud Infrastructure (OCI), optimizing system performance and reducing operational costs.
• Developed and managed integrations in Oracle Integration Cloud (OIC), leveraging REST and SOAP web services for seamless data exchange between Oracle ERP Cloud and third-party applications.
• Created and managed OCI Object Storage Buckets, enabling secure and cost-efficient data storage, resulting in a 30% reduction in storage expenses.
• Built custom REST APIs in OIC to enhance real-time data processing and facilitate smooth integration across enterprise systems.
• Developed and customized Oracle APEX applications, improving workflow automation and increasing productivity by 25%.
• Implemented ERP Cloud data migration strategies using FBDI and HDL templates, ensuring efficient bulk data processing and reducing manual effort.
• Optimized SQL queries and PL/SQL procedures in MySQL and Oracle Databases, enhancing system responsiveness and supporting cloud-based application development.
• Resolved various real-time production issues, ensuring uninterrupted system operations.
• Provided technical support by addressing and resolving 50+ support tickets monthly, delivering timely and effective solutions to critical issues.
• Monitored server and application health using Geneos software, maintaining optimal performance and enabling proactive issue resolution.
• Conducted regular monitoring, troubleshooting, and root cause analysis of system alerts, reducing downtime by 30% and improving overall system reliability.
• Created and maintained comprehensive documentation for new and recurring issues in Confluence, improving knowledge sharing and reducing issue resolution time by 20%.
• Created and optimized various database tables, indexes, and established relationships between them to ensure data integrity and efficient querying.
• Developed stored procedures, functions, and packages to automate key operations, reducing manual effort by 40%.
• Optimized query performance, reducing execution time by 40% and improving reporting efficiency by 25%.
• Used Docker to containerize application components, enhancing scalability and deployment.
• Enhanced Oracle EBS HRMS and ERP functionalities, improving system performance by 30% .
• Automated data processing tasks, reducing manual effort by 20% • Developed 50+ customized reports tailored to client requirements.
• Utilized knowledge of business and system processes to deliver innovative application solutions, adhering to industry standards.