SUMMARY

• 12+ Years of IT industry in Oracle design & development and implementation and been through all the modules SDLC and apex experience
• Extensively developed Oracle packages, procedures, functions and triggers and creating tables, views and materialized views, external table using Oracle SQL and PL/SQL .
• Build applications using Oracle application express (APEX) using JQuery/CSS/HTML5/Jscript
• Upgraded applications in APEX from 3.2 to 4.2 and 5.0
• Worked with Agile frame work tools such as JIRA and interfaced with GIT and trained CMM methodologies to a team of developers and testers
• Used Oracle development tools such as SqlDeveloper, Pl/Sql Developer and Toad.
• Used SQL*Loader and csh/bsh Unix scripts in the data conversion projects
• Developed JavaScript utilities and deployed on the webserver and used against applications express for page validation and alert messages.
• Developed War files using JDeveloper for Soap xml Rest/JSON web - services
• Developed advanced queueing and xml payload propagation through the dbms scheduler
• Extended eBusiness modules using Oracle forms and reports, BI Publishers and provided interface to the core eBusiness modules in the customer, AR and Inventory modules
• Developed Beans using Java
• Used the language C/Pro*C on Unix/Linux platforms
• Upgraded the Oracle databases form 8i/9i/10g and oracle forms/reports from 6i to 11g
• Maintained large databases and acted as Oracle DBA used RMAN and UNIX scripting, created the recovery procedures and stand by databases.
• Prepared development standard documents for Pl/SQL and APEX developments
• Strong trouble-shooting, problem solving, analytical and design skills
• Good Communication, presentation skills
• Willingness to learn new technologies/tools.

TECHNICAL SKILLS

Development Tools: Application Express (Oracle APEX)/Forms 11g/BI publisher/Reports11g/JDeveloper

Internet Development: Jquery/JScript/ApEx 50/HTML/CSS/SoapUI

Development Languages: Java/C/COBOL

Database: Oracle 12c/11g/10g/Postgres/RDB/FoxPro

Database Tools: Pl/Sql Developer, Toad, SqlDeveloper

OS: Linux/Hp-Ux/Windows/

Version Control: GIT/Cvs/Pvcs/BitBucket

Other tools: Ms-Office, Word/Excel/PowerPoint/Notepad++

PROFESSIONAL EXPERIENCE

Confidential

Environment: Oracle 12c/11g e-Business/Forms11g/Reports 11gBI-Publisher/Apex 5.0.3/Apex 4.2/ Apex 5.0/script/JQuery/HTML 5/JDeveloper

Responsibilities:

• Creating new applications, enhancements of business modules, providing interface to EBS through the customization of E-Business using forms/reports/BI publisher
• Providing effective business solutions in APEX technologies.
• Interfacing with E-Business (Using JDeveloper and Soap Xml, xml tables, JSon).
• Used Oracle database utilities such as dbms scheduler, dbms lob, utl file n PL/SQL development
• Developed using Dynamic SQL, Ref Cursors, Bulk Collections, Pipeline tables and external tables
• Simulated larger data for testing with real-time data in the lower environments, analyze existing PL/SQL code, Debug, Test and enhance the package codes.
• Tuned larger SQL and re-designed some of the modules using AQ interface and Pl/Sql to improve the performance of the modules
• Converting business requirements into optimal technical solution in Oracle technologies, technical and user guide documents.
• Providing the testing document and doing unit testing of the development.
• Configuring and deploying the code changes into higher environments using GIT and CVS.
• Developing user and technical guides.
• Using Pl/Sql for creating packages functions and procedures, and triggers i n the databases.
• JQuery/Jscript in Apex pages.
• Creating and modifying reports in BI publisher and reports.
• Changing forms in the extension of E-Business.
• CSS/HTML 5 changes for layout changes in the html pages for apex.
• Used Agile process and Jira for moving code into higher environments
• Deploy WAR files in the development servers and check the status of WebLogic server in the lower environments
• Used SoapUI to interface with other systems using War files

Confidential

Environment: Oracle 11g/J2EE/Eclipse IDE/Oracle 11g/Forms 11g/Reports 11g/6i/PLSQL/Unix shell scripting

Responsibilities:

• Prepared technical reports and documentation.
• Supported the existing systems under above platforms, liaise with the users, support officers convert their requirements into Business, Technical and user documents.
• Developed the new enhancements or fix the problems in the existing system and promote to test and production systems through change management.
• Introduced new functionality using Forms 6i/Reports 6i/ Forms 10g/Reports 10g .
• Supported APEX (Oracle) application small applications of up to 150 pages.
• Broken a single application of 150 pages into multiple applications and separated their modules so that easy to maintain such large applications
• Converted the some of the apex applications Authentication into LDAP and removed the username and passwords from those applications
• Developed Java application using Eclipse IDE/JSF 2.0//Oracle 11g.
• Supported Java application using Eclipse IDE/ JSF 2.0 /Oracle 11g.
• Developed Packages/functions/procedures using PL/SQL.
• Maintained few Java interfaces using Oracle Database JVM and application server.
• Fixing defects in Production and testing environments.
• Tuning the Sql Queries to have better performance while running in reports and forms.
• Upgraded the APEX from 3.2 to 4.2
• Upgraded the Oracle database from 8i to 11g and the forms and reports from 6i to 11gR2
• Converted Oracle forms and report based system into a Java based system using Java and JSPX.

Confidential

Environment: Oracle 9.2.x/Forms 6i/Reports6i /ApEx 4.2/Linux

Responsibilities:

• Designed, Developed and deployed few systems using the Application Express Tool
• Re-Developed the system in mod-plsql into Application express 3.2
• Developing Packages/functions/procedures using PL/SQL
• Interact with Business Analyst and key stakeholders to gather requirements for developing new database programs .
• Prepare and manage documentation on functional specification, Design diagrams, Technical Specifications, Unit Test cases and other Quality Control Documents.
• Involved in developing project plans, schedules and progress tracking.
• Responsible for new database interface development using PL/SQL Database Programming Language and status reporting to key stakeholders
• Expertise in Dynamic SQL, Bulk Collections and Exception handling
• Analyze existing PL/SQL code, Debug, Test and enhance the package codes.
• Supporting the existing system using Forms/Reports
• Interact with business Team, developed business requirement, technical and UAT testing documents
• Prepared testing documents/user guide/release documents

Confidential

Environment: s: Oracle 9.2.x/PLSQL

Responsibilities:

• Developed Packages/functions/procedures/Triggers using PL/SQL
• Responsible for new database interface development using PL/SQL Database Programming Language and status reporting to key stakeholder
• Experienced in Database Design and Modeling using Erwin.
• Design and creation of schema objects.
• Expertise in Dynamic SQL, Bulk Collections and Exception handling
• Development of PL/SQL Packages, Procedures, Functions, Views and Triggers.
• Analyze existing PL/SQL code, Debug, Test and enhance the package codes.
• Created modules to transfer data using XML and SQL*Loader
• Created interface with different systems like SAP with the core system Normalized and de-normalized some of the tables to improve the performance of system
• Used Oracle JVM to transfer data between SqlDeveloper database to Oracle

Confidential

Oracle Developer

Environment: s: Oracle 9.2.x/Forms 6i/Reports6i 2000/PLSQL/PRO*C

Responsibilities:

• Developed Packages/functions/procedures using PL/SQL
• Introduced the new functionality using Forms 6i/Reports 6i/Pro*C
• Provided technical assistance in production and testing environments
• Tuning the SQL Queries for better performance while running in reports and forms
• Creating Shell scripts/Perl scripts in Unix environment
• Converting data from mainframe to Oracle database using shell scripts and SQL*Loader and Oracle packages.
• Interacted with the business team and service team the issues/problems in the part of supporting the system.
• Other documentation such as test scripts, test results, config and promotion documentation.
• Used Macroscope metrologies for developing business and technical documentation