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.