Resume
Oracle Apex Pl Sql, DevelopeR
PROFESSIONAL SUMMARY:
- Over 7 years of programming experience as an Oracle Apex/PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS) in a variety of applications including insurance, healthcare, telecommunications and business applications.
- Experience with various technologies such as Oracle12c/11g/10g/9i, SQL, PL/SQL, Oracle APEX 3.0/3.2/4.0/4.2/5.0 , Oracle Forms 6i/10g and Oracle Reports 6i/10g, SQL*Loader, Dynamic SQL, TOAD, PL/SQL Developer.
- Extensive experience in developing complex SQL Queries, Triggers, Materialized Views, Stored Procedures, Functions, Packages and other database objects.
- Developed several types of forms and reports using Oracle APEX such as form on a table, view, master detail reports, tabular forms and others.
- Developed several application processes, computations, validations, LOVS, LISTS, shared components for code reusability.
- Implemented security features for authentication at different levels using the LDAP, SSO Authentication and authorization schemes in APEX that are custom at data levels.
- Extensively worked with JavaScript’s, Jquery, Bootstrap and Ajax calls for rich look and feel of the Apex pages with minimum page refreshes.
- Experience in developing the forms and reports using Oracle Apex for the business logic implementation and automation of workflows with rich UI.
- Experience in developing Forms 6i/10g and generating Reports in Report 6i/10g.
- Experience with writing SQL queries for data validation and data integrity testing.
- Experience with performance testing for data loading process in DWH environment.
- Experience in Tuning using various types of Hints, Partitioning, Indexes, Explain Plan and TKProof.
- Expertise in Operating Systems like Sun Solaris, HP UNIX, Windows XP/NT/2000.
- Involved in database designs, functional design and collection of user requirements.
- Experience in functional design of the application specific modules and other core areas.
- Experience in Team Management, Quality Assurance, Software Testing, and Reverse Engineering etc.
TECHNICAL SKILLS:
Database: Oracle 12c/11g/10g/9i/8i, Oracle Express, Oracle APEX 3.0/3.2/4.0/4.2/5.0 , MS SQL Server 2000, Microsoft Access, ODBC, JDBC.
Languages: SQL, PL/SQL, Dynamic SQL, T - SQL, UNIX/Linux Shell Scripts, Java, Visual Basic.Net, C++/C, JSP, ASP, VB Script, PHP, Perl, JavaScript, XML.
Web: HTML, DHTML, CSS, JavaScript, Ajax, Jquery, Bootstrap, VBScript, ASP, PHP, Core Java, Java Servlets, J2EE, Apache Tomcat
Development Tools: Oracle APEX 3.0/3.2/4.0/4.2/5.0 , Oracle Forms 6i, Oracle Reports 6i, Visual Studio.Net, Visual Studio 6, Microsoft Access, Oracle SQL *Plus, Visio, TOAD, PL/SQL Developer, SQL Developer, OBIEE, UNIX/Linux Utilities.
Methodologies: ER Diagram, OOP, OOA, UML, Structured Analysis, Agile
Operating Systems: UNIX, Linux, Windows XP/2000/NT/98
PROFESSIONAL EXPERIENCE:
Confidential
Oracle Apex/PL/SQL DeveloperResponsibilities:
- Extensive experience in developing complex SQL Queries, Triggers, Materialized Views, Stored Procedures, Functions, Packages and other database objects.
- Developed several types of forms and reports using Oracle APEX such as form on a table, view, master detail reports, tabular forms and others.
- Developed several application processes, computations, validations, LOVS, LISTS, shared components for code reusability.
- Implemented security features for authentication at different levels using the LDAP, SSO Authentication and authorization schemes in APEX that are custom at data levels.
- Extensively worked with JavaScript’s, Jquery, Bootstrap and Ajax calls for rich look and feel of the Apex pages with minimum page refreshes.
- Experience in developing the forms and reports using Oracle Apex for the business logic implementation and automation of workflows with rich UI.
- Experience in developing Forms 6i/10g and generating Reports in Report 6i/10g.
- Experience with writing SQL queries for data validation and data integrity testing.
- Experience with performance testing for data loading process in DWH environment.
- Experience in Tuning using various types of Hints, Partitioning, Indexes, Explain Plan and TKProof.
- Expertise in Operating Systems like Sun Solaris, HP UNIX, Windows XP/NT/2000.
- Involved in database designs, functional design and collection of user requirements.
- Experience in functional design of the application specific modules and other core areas.