Renin Sebastian
PL/SQL Developer
Summary
Dedicated IT professional with over 5.10 years of hands-on software development experience. Expertise in Oracle technologies, including Oracle PL/SQL, Oracle E-Business Suite (EBS), and Oracle Apex. Excelled in analyzing, designing, and implementing robust business applications that leverage the power of the Oracle Relational Database Management System.
Overview
6
6
years of professional experience
2019
2019
years of post-secondary education
Work History
Senior Analyst
Aspire Systems
01.2021 - Current
- Designing and developing customization and extensions to Oracle EBS modules to meet specific business requirements
- Developed and optimized PL/SQL stored procedures, triggers, and packages for Oracle EBS modules.
- Creating stored procedures, functions and packages to support custom process and integration
- Data loading using autonomous data base after creating OCI object buckets
- Work as part of an Agile SCRUM team in the planning, scoping, estimation, and execution of technical solutions
- Analyze performance and develop improvements to performance of web application
- Writing optimized PLSQL code in Oracle database
- Develop and maintain database models, schema, and designs
- Skilled in advanced PL/SQL performance tuning, leveraging query optimization, partitioning, and indexing strategies to deliver efficient, high performance database solutions
- Experienced in ERP modules, including Inventory Management, Procurement, CRM, Sales and Order management and Financial management Systems
- Advanced expertise in Oracle Database 10g, 11g, 12C
- Performance Optimization: Query Optimization, Partitioning, Indexing.
- Version Control & Agile: Git, Jira, Agile Scrum
Oracle APEX Developer
Oges Infotech
01.2019 - 01.2021
- Creating and optimizing stored procedure, functions, triggers and packages to support application functionally
- Designing, developing and maintaining web applications using Oracle Apex
- Developed custom PL/SQL scripts for data integration and workflow automation.
- Created and optimized SQL queries for improved data retrieval and performance.
- Tuning SQL queries and PL/SQL code to enhance database performance and reduce response time
- Performing testing and debugging of APEX applications to identify and resolve issues
Education
Master of Computer Application -
Marian College Kuttikkanam
Bsc. - Computer Science
College of Applied Science
Skills
PL/SQL Programming
Oracle Fusion Expertise
Oracle Workflow Management
Performance tuning
Database design
Oracle 10g, 11g, 12C, 19C
Oracle EBS Expertise
Oracle APEX Development Expertise
Effective Communication
Analytical Problem Solving
Collaborative Teamwork
Critical Analysis
Timeline
Senior Analyst
Aspire Systems
01.2021 - Current
Oracle APEX Developer
Oges Infotech
01.2019 - 01.2021
Bsc. - Computer Science
College of Applied Science
Master of Computer Application -
Marian College Kuttikkanam