We provide IT Staff Augmentation Services!

Sr. Oracle Apps Developer Resume

4.00/5 (Submit Your Rating)

Winston Salem, NC

SUMMARY

  • Over 13 years of experience in teh IT industry in Software Systems Development, Implementation and Customization using Oracle Technology and Applications in teh Client - Server, 3-tier architecture.
  • Technical developer with expertise in Oracle financial modules, Purchasing, Inventory, Order Management, Property Manager, Service Contracts, System Administrator and AOL modules.
  • Good expertise in RICE (Reports, Interfaces, Conversions, Extensions) components.
  • Proficient in developing PL/SQL program units using Procedures, Functions. Packages and Triggers, public API’s.
  • Well versed with client server environment & tools like SQL*Loader, TOAD and UNIX Shell Scripts/ Linux Scripting.
  • Very good working Experience in SQL, PL/SQL, Forms 6i/10g, Reports 6i/9i, Oracle 9i/10g/11g.
  • Worked with business team for creating functional (MD050) and technical (MD070) design documents for customizing various modules in Oracle Applications using AIM Methodology.
  • Knowledge on creating ODI procedures to create and populate in target systems. Have good knowledge in building BPEL processes and SOA composites.
  • Extensive experience in creating and customizing existing reports using Reports6i and XML/BI Publisher tools
  • Extensive Experience with AOL to develop Flex fields, Reports, and Value sets and Concurrent programs and registered in AOL.
  • Ability to interact effectively with clients, understanding their requirements and providing optimum solution and support.
  • Excellent Analytical, interpersonal and communication skills.
  • Quick learner with ability to develop proficiency and adapt to new technologies and methods in a short period of time.
  • Experienced in all stages of documentation in teh implementation life cycle using AIM.

TECHNICAL SKILLS

ERP: Oracle EBS 11i/R12

Languages: SQL, PLSQL, Shell Scripting, C, C++, JAVA

GUI: Oracle Developer Suite- Oracle Reports/Forms 10g

Database: Oracle 9i/10g/11g

Version Control: PVCS, Vault, SVN, GIT Lab

Software Tools: TOAD, SQL Developer, BI Publisher, OBIEE

PROFESSIONAL EXPERIENCE

Sr. Oracle Apps Developer

Confidential, Winston Salem NC

Responsibilities:

  • Translated business user concepts and ideas into design documents.
  • Worked in R12 upgrade project. BCP planning and execution of each module in Oracle EBS.
  • Created project plans in accordance with project management framework standards and procedures. Identified ongoing issues and gaps within project plans, in order to eliminate implementation issues.
  • Planned, facilitated and reported on quality assurance testing efforts.
  • Manage User Acceptance Testing of new applications and new versions of existing applications.
  • Used Oracle Data Integrator ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database and Oracle EBS interface tables.
  • Design and develop Oracle PL/SQL batch and real time processes for loading data from internal and external systems using SQL Loader and External tables.
  • Use Dynamic SQL and Execute Immediate functionality to perform DDL in PL/SQL blocks and procedures
  • Monitored/ alerted and corrected routine and complex technical issues using Oracle/Ksh/Perl.
  • Created Unix/Oracle tools to speed up teh process of handling teh tickets.
  • Design and create entity relationship diagrams (ERD) for Oracle based applications and interfaces.

Environment: Oracle E-Business Suite 11i and R12, General Ledger, Accounts Payables, Account Receivables, Inventory, Purchasing, Order Management, Distributor Management, Oracle 10g, XML/BI Publisher 5.6.3, PL/SQL, SQL*Plus, TOAD, Reports 10g, Forms 10g,ADF, SOA, ODI,UNIX, OBIEE Reports.

Sr. Oracle EBS Consultant

Confidential, Santa Monica CA

Responsibilities:

  • To efficiently plan for teh cutover process in a manner that will mitigate issues as teh business transitions.
  • Assist in creation of data conversion and cutover plans including cleansing and verification and in teh execution of data conversions mock and trial loads with data verification procedures including data verification requirements, reports, steps for signoff of data conversions including internal/external audit needs
  • Define go/no-go criteria for both technical release and business cutover, assess which criteria have or have not been met.
  • Define and communicate technical release and business cutover plans with relevant cutover steps and communications needed with external business partners and stakeholders
  • Monitor execution of all business cutover steps according to cutover plan.
  • Determine which processes / sites are stable enough to transition to production support
  • Managing, allocating and tracking of issues and resolution (planning, organizational skills)
  • Producing statistics and status/dashboard reporting on progress of various test cycles.
  • Work with teh Change, Test & Technical Lead as necessary.
  • Automated teh deployment process of EBS components.

Environment: Oracle E-Business Suite R12, Order Management, Oracle 10g, Discoverer 10g, XML/BI Publisher 5.6.3, PL/SQL, SQL*Plus, TOAD, Reports 10g, Forms 10g, UNIX.

Sr. Oracle Apps Developer

Confidential

Responsibilities:

  • Worked extensively on Distributor Management and Order Management.
  • Developed technical components for HDMS project, Distributor Management and Oracle order Management were integrated before with HDMS DM is an independent application.
  • Supported ARQ (Annual requalification Project) for four consecutive years. When HDMS was in place ARQ was also moved from HMS to HDMS.
  • Was a part of SLC project DM module which involved updating teh cut over plan from DM activities like migration, execution, testing and support after go-live.
  • Developed several BI reports.
  • Worked a PM for ARQ Project which includes preparing teh cut over plan, execution, and post production support.
  • Coordinate with Onsite team for clarifications and work load sharing.
  • Worked closely with cross functional teams for design and solution.
  • Development of technical specifications, modifications to custom forms and reports,
  • Work on incidents raised by end user support for multiple applications in multiple geographies.
  • Responsible for teh support of Oracle Applications. It included Business analysis, Business Flow documentation, Process Mapping, implementation and setup, developing test strategies of teh Oracle Application and user training.
  • Used Oracle Application Object Library (AOL) features like Value Sets, Descriptive Flex fields, Concurrent Programs, Profile Options, standard request submissions (SRS) and parameters in teh process of development.

Environment: Oracle E-Business Suite 11i and R12, General Ledger, Accounts Payables, Account Receivables, Inventory, Purchasing, Order Management, Distributor Management, Oracle 10g, XML/BI Publisher 5.6.3, PL/SQL, SQL*Plus, TOAD, Reports 10g, Forms 10g,ADF, SOA, ODI,UNIX, OBIEE Reports.

Oracle Technical Consultant

Confidential

Responsibilities:

  • Design and development of custom interfaces to upload teh data from legacy sytem to oracle Lease Management custom tables.
  • Responsible for creating teh Database tables, indexes, constraints in Oracle 9i.
  • Created Stored Procedures, Functions, Packages, Triggers using SQL, PL/SQL.
  • Developed Inbound and Outbound Interfaces to ensure teh proper flow of data in both Oracle Receivables and 3rd party tools.
  • Extensively utilized teh Application Object Library (AOL) to register SQL*Loader programs, Shell Scripts, PL/SQL procedures.
  • Involved in teh preparation of Technical document (MD70) based on teh business requirement.
  • Testing of teh units developed and preparation of Test Case Documents(TE20)

Oracle Technical Consultant

Confidential, Boston MA

Responsibilities:

  • Developed a Multi-Unit Store Development Agreement Amendment report in Service Contracts using XML Publisher.
  • Developed an interface program to validate and apply credit memos to receipts and import invoices into Oracle Account Receivables.
  • Developed a custom report for pre-dunning and post-dunning process in Accounts Receivables.
  • Designed and developed reports for teh Cash Receipt Collection and Cash Receipt Application for customer invoices in Accounts Receivables.
  • Developed custom packages to populate values in custom tables and calculate teh amount for teh Lease Year End Reconciliation Process in Property Manager.
  • Responsible for creating custom menus, responsibilities, values, value sets, report groups and new printer styles.
  • Developed a custom program to calculate teh net amount payable of all teh available leases over a particular period and transfer to Receivables.
  • Worked closely with end-users/clients through complex problems involving deployment, testing and conversion in teh Property Manager (PN).
  • Worked in Postproduction Support for Service Contracts. Resolved Severity tickets and made changes in existing reports from production.
  • Made changes to existing code in Accounts Receivables and tested it with business and functional users before moving it back to production through change management.
  • Involved in Building Customizations and Enhancements using Reports.
  • Involved in bug fixing reported from QA and End users.
  • Involved in Functional document (MD50) review and preparation of Technical document (MD70) based on teh business requirement.
  • Prepared teh Installation document MD120 and Involved with teh functional user in preparing teh TE020.

Environment: Oracle E-Business Suite 11.5.10, Property Manager, Service Contracts, Install Base, Oracle 10g, XML/BI Publisher 5.6.3, PL/SQL, WorkFlow SQL*Plus, TOAD, Reports 6i, Forms 6i, UNIX, Discoverer Reports.

Sr. Oracle Developer

Confidential

Responsibilities:

  • Involved in teh implementation and support of RICE components of various Oracle financial modules like AP, GL, AR and Purchasing and Inventory.
  • Designed and developed several RICE components for teh implementation of Oracle 11i.
  • Used FND REQUEST API to submit concurrent Programs from PL/SQL program.
  • Invoices are ported from teh Excel sheets to teh Oracle Database using SQL * LOADER.
  • Wrote Functional Specification (MD050), Technical Specification (MD070), Conversion Mapping (CV040) documents for converting
  • Open Invoices and Open Purchase Orders
  • Suppliers, Supplier Sites, Supplier contacts.
  • Supplier Additional Information like PAN number etc.
  • Developed Conversion program to import Vendor/Supplier Information into Purchasing by loading data into staging tables from legacy system, validating data using PL/SQL and then loading teh data into Vendor information Base tables.
  • Developed a procedure to load additional information for valid vendors into base tables.
  • Developed GL Account Analysis report using XML Publisher, which would display teh opening balance, transactions and closing balance depending on teh given parameters.
  • Generated Bank Payment, Payment Advice, and Vendor Ledger, Vendor Trial Balance reports using XML Publisher, Reports 6i, and PL/SQL.
  • Designed and developed a single report to generate Journal Voucher, Bank Payment, Bank Receipt, Cash Payment and Cash Receipt for different operating units depending upon teh parameters.
  • Developed Interface Program for loading Standard Purchase Orders information from legacy system to PO interface tables using SQL*Loader and PL/SQL and subsequently ran Import Standard Purchase Orders program to populate teh PO Base tables.
  • Created complex validation units based on Value Sets and list of values (LOV).
  • Extensively utilized teh Application Object Library (AOL) to register SQL*Loader programs, Shell Scripts, PL/SQL procedures, Forms and reports.
  • In addition, also used teh System Administrator responsibility to create users, assign responsibilities, Value Sets and Request Sets
  • Analysis of teh specifications provided by teh clients.

Environment: Oracle E-Business Suite 11.5.10, General Ledger, Accounts Payables, Account Receivables, Inventory, Purchasing, Property Manager, Service Contracts, Install Base, Oracle 10g, XML/BI Publisher 5.6.3, PL/SQL, SQL*Plus, TOAD, Reports 6i, Forms 6i, UNIX.

Oracle Technical Consultant

Confidential

Responsibilities:

  • Involved in teh development of a conversion in Accounts Payable module. This conversion program converts 1099 supplier invoices from legacy systems to oracle. 1099 invoices include items that are considered taxable wages by teh IRS miscellaneous code for non-employee income, etc.
  • Customized two interfaces in GL. Journal entries from both Utility Worksheet System and sales validation system will be interfaced to oracle.
  • Developed a Custom outbound interface it General ledger module to publish teh list of valid and existing code combinations from all sets of books in teh oracle applications environment.
  • Developed an outbound interface in Property Manager (PN) Module. Leases and Buildings records will be interfaced to teh E-property system through this outbound interface.
  • Customized ADS Format payments program. Oracle provides ‘Format Payments (Evergreen, Laser)’ for printing of laser checks.
  • Involved in teh Customization of AP Account Analysis Report. Teh required customizations were reporting DFF on PO and Vendor screens. Teh report TEMPhas user security.
  • Involved in creation of PL/SQL stored procedures, Packages, Procedures, Functions, Cursors, Triggers.
  • Responsible for documentation of Technical Specifications. Utilized teh Oracle AIM (MD070) templates for generating teh documents.
  • Developed Test Scripts for testing interfaces which include Unit Testing, Module Testing and System Testing.
  • Developed shell scripts to call teh interfaces, FTP teh files generated to teh FTP server, registering teh scripts as concurrent programs and scheduling them using oracle scheduler to run at pre-determined intervals.

Environment: Oracle E-Business Suite 11.5.10, General Ledger, Accounts Payables, Account Receivables, Oracle 10g, XML/BI Publisher 5.6.3, PL/SQL, SQL*Plus, TOAD, Reports 6i, Forms 6i, UNIX.

Software Engineer

Confidential

Responsibilities:

  • Responsible for creating teh Database tables, indexes, constraints in Oracle 9i.
  • Created Stored Procedures, Functions, Packages, Triggers using SQL, PL/SQL.
  • Used FND REQUEST API to submit concurrent Programs from PL/SQL program.
  • Invoices are ported from teh Excel sheets to teh Oracle Database using SQL * LOADER.
  • Involved in Unit Testing and Performance Testing for reports.
  • Created temporary tables and developed SQL*Loader control files to load teh legacy data into teh temporary tables for all teh conversions.
  • Generated a number of reports for management to review for system functionality as against teh old legacy system.
  • Designed and created error handling tables that are been updated when error rises during teh conversion process.
  • Worked on optimizing existing procedures and functions using PL/SQL.

We'd love your feedback!