We provide IT Staff Augmentation Services!

Oracle Ebs & Oracle Apex Developer Resume

3.00/5 (Submit Your Rating)

CharlottE

SUMMARY

  • 7+ years of experience in Design, Coding, Testing, Implementation, Customization and Interfacing of Oracle based business applications in IT industry.
  • Expertise in Oracle E - Business Suite R12/11i development methodologies coupled with R12 Upgrade, Implementation, Customization and Production support with two full life cycle Implementations.
  • Experience in all aspects of Software Development Life Cycle (SDLC) including System Analysis, Software Design, Development, Implementation and Testing.
  • Techno functional knowledge on Oracle Supply Chain as well as Oracle Financials modules such as Order Management, Inventory, Bill of Materials, Warehouse Management, Shipping, General Ledger, Purchasing, Payables and Receivables.
  • Hands on experience in coding functions, procedures, packages, triggers using PL/SQL and writing and tuning complex SQL Statements for Enterprise Business Systems ensuring compliance with development standards and best practices.
  • In depth hands-on experience using the development tools like Oracle Apex, Oracle Reports, Oracle Forms, XML/BI Publisher reports, Discoverer reports and Workflow builder.
  • Extensively worked on building Oracle Apex Forms/reports/web services using JavaScript, Ajax processes and jQuery libraries to enhance user friendliness & Web 2.0
  • Strong experience on shell scripts and good understanding of LINUX/UNIX tops, directory structure and system architecture.
  • Major work till now included migrating data from legacy system to Oracle EBS, interfacing the Clients existing system with Oracle EBS using API’s, Interfaces or Custom built programs and PL/SQL validation Scripts, developing RICE components and implementing a complex application in Oracle Apex (125 pages) end to end.
  • Experience in Application System Administration activities like application user setup, defining responsibilities, value sets, registering menus, forms, reports and concurrent programs and assigning them to request groups and responsibilities.
  • Thorough understanding of EBS data structures like (ER) Entity Relationship diagrams and schema design.
  • Good knowledge on various Technical as well as Functional documents like MD070 and MD050 and conversion mapping CV060 using oracle AIM Methodology.
  • Helping end users in solving the issues logged and obtaining closures.

TECHNICAL SKILLS

  • Oracle e-Business Suite (R12 & 11i)
  • Order Management Inventory BOM/WMS/WSH
  • Oracle APEX (4.1/4.2)
  • Oracle 11gR2/10g/9i SQL & PL/SQL
  • BI/XML Publisher Forms & ReportsSQL*Loader
  • Java
  • J2EE
  • XMLJDBC Discoverer
  • Java Concurrent Programs
  • Jdeveloper
  • UNIX
  • Shell Script
  • TOAD SQL Developer
  • OA Framework
  • Oracle Workflows
  • JSP
  • Servlets Designer 2000
  • LINUX
  • UNIX
  • Windows 7/XP/NT
  • Ms Dos.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte

Oracle EBS & Oracle Apex Developer

Responsibilities:

  • Actively involved in the complete life cycle of Oracle EBS upgrade project (11i to R12).
  • Working with business partners to understand their processes and needs to design and build extensions accordingly.
  • Developed/Migrated around 20+ RDF reports, BI/XML publisher reports as part of the Upgrade.
  • Developed/Migrated around 30+ PL/SQL packages and created the underlying database objects like custom tables, view and indexes as required.
  • Developed multiple interfaces and worked with business partners to transfer the files via NDM a method used in Confidential to transfer files between servers.
  • Created the concurrent programs, value sets and profile options according to the new business requirements.
  • Replaced the third party software “IRIS” with Oracle Apex reports, cost effective.
  • Hands on experience in Linux/Unix shell scripting to support the business process.
  • Always inclined toward Performance: Involved in tuning sql and suggesting/ implementing the latest Oracle database techniques like bulk collect and for all to improve the performance in numerous plsql packages.
  • Expert in Analysis, design, develop, document, test and implement the Oracle APEX (4.1+) application as required, developed upon decommissioning a java based application and built 50+ forms/reports. Played a significant/crucial/major development resource role in the success of this application.
  • Developed SOAP xml request to implement UPS & FedEx Web service to track the live shipping packages via Oracle Apex application and written the parsing code to show the xml response results as per the business need.
  • Thorough understanding of the documentation methodology involved in the project and created the SDLC documents to comply with the business requirements.
  • Actively involved in the project meetings to discuss the timelines which streamlines the process and enhances the project progress.
  • To increase the productivity, Leveraged and made the best use of UAT in enhancing the requirements in this phase requested by the users as per the business needs.
  • Expertise in Ticketing/QC tool: HP Application Life Cycle Management software, Code Repository tool: Harvest and Deployment tool: CAMS used in Confidential .
  • Received appreciation letters for smoothly and efficiently pipelining the business processes and efficiently implementing the user needs (refer to my LinkedIn).

Confidential

Oracle EBS Developer

Responsibilities:

  • Actively participated in the full life cycle of the upgrade project from 11i to R12.
  • Studied the existing system, reviewed it and implemented/enhanced the changes as per the new business process upon approval.
  • Migrated/Developed and tested the custom PL/SQL packages to develop interfaces.
  • Migrated/Developed new reports RDF as well as XML publisher as per the client requirement.
  • Created SQL*Loader control programs and PL/SQL validation scripts.
  • Designed & developed the custom interface program to create and update an item with database validations.
  • Developed SQL queries to obtain specific information as per requirements.
  • Developed reports like Pick Slip, Packing Slip, and Mailing Label for Shipping and Credit Order Detail, Orders by Item, Order Detail & Summary Reports for Order Management.
  • Customization and Extension of Forms using personalization.
  • Application System Administration activities like application user setup, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs.
  • Registering reports, custom packages as concurrent programs to run from SRS form.
  • Prepared Technical specifications for the functional specifications received from the functional team following AIM methodology: MD070 and CV060.
  • Customized invoice form through personalization: If invoice is approved then we cannot update quantity and price.
  • Customized invoice form through personalization: If invoice is approved then payments should be disabled.
  • Customized PO form through personalization: Not to raise purchase order on weekends.
  • Developed normal query find form with dff.

Confidential

Technical Consultant

Responsibilities:

  • Understand the requirements or issue and develop or fix respectively with respect to the Oracle E-Business suite application.
  • Responsible for all the queries and any other technical work in the testing team.
  • Creating queries to assist users in performing User acceptance testing.
  • Writing custom PL/SQL packages as per the business requirements.
  • Developed SQL*Loader control programs and PL/SQL validation scripts.
  • Preparing the Technical Design Documents after completion of component and updating the Tar’s.
  • Developed PO Vendor Report, Vendor ledger report using XML Publisher
  • Involved in customizing and developing the Reports, Registration of Custom Tables and Concurrent Programs.
  • Used custom.pll extensively for example to restrict the user responsibility access and restrict the usage of some of the management units for approval process.
  • Involved in System Administration activities of creating the value sets, registering concurrent programs and assigning them to request groups and responsibilities.
  • Handling assignments that demand ability to create data extracts, reports and other extensions to standard Oracle Apps functionality.

Confidential

Associate Consultant

Responsibilities:

  • Developing PL/SQL validation Scripts.
  • Developing Custom Interface Programs, Discoverer Reports and XML Publisher reports.
  • Creating value sets for report parameters and registering them in applications.
  • Developing conversion programs and reports that are registered as concurrent programs and which are run from SRS form.
  • Writing SQL*Loader Scripts to create CTL files to load the data into oracle base tables.
  • Writing custom packages to develop conversion programs.
  • Developed several programs as part of the change requests submitted by the users and approved by the IT team.
  • Development of Reports as required by the client’s IT team from time to time.
  • Developed, personalized and customized forms according to business requirements.
  • Preparation of Technical Documents like CV060, MD070 from the functional specifications, which are based on the client’s requirement.
  • Assisting the users in testing the programs by providing them with the test scripts.

Confidential 

Associate Consultant

Responsibilities:

  • Experience in technical development, maintenance and other support aspects of oracle applications.
  • Worked in the testing team, doing manual testing of programs developed by following the test scripts and recording the test results.
  • Responsibilities were helping the users in solving the issues logged and obtaining closures.
  • Worked with Oracle Support using Metalink for issues related with bugs, raised SR’s.
  • Supporting the custom developments and modifying the custom programs for improving the performance.
  • Extensively worked on UTL FILE Packages in reading data from data files and put them in database tables.
  • Creation of Packages, Stored Procedures & triggers using PL/SQL.
  • Load the data using SQL*Loader.
  • Registration of Program: Registered Reports, SQL*LOADER, PL/SQL Packages, UNIX Shell Script with Oracle AOL.
  • Prepared design documents (MD050) and technical documents (MD070) for all the customizations.

We'd love your feedback!