PROFESSIONAL SUMMARY:

• 11+ 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 wif expertise in General Ledger (GL), Accounts Payables (AP), Account Receivables (AR), Purchasing(PO), Inventory(INV), Order Management, Property Manager(PN), 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 wif client server environment & tools like SQL*Loader, TOAD and UNIX Shell Scripts.
• Very good working Experience in SQL, PL/SQL, Forms 6i, Reports 6i/9i, Oracle 9i/10g/11g.
• Worked wif business team for creating functional (MD050) and technical (MD070) design documents for customizing various modules in Oracle Applications using AIM Methodology.
• Expertise in design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using Open Interfaces and APIs.
• Extensive experience in creating and customizing existing reports using Reports6i and XML/BI Publisher tools
• Extensive Experience wif AOL to develop Flex fields, Reports, and Value sets and Concurrent programs and registered in AOL.
• Wrote Technical Documents on Reports developed.
• Ability to interact effectively wif clients, understanding their requirements and providing optimum solution and support.
• Excellent Analytical, interpersonal and communication skills.
• Quick learner wif 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:

MS: DOS, UNIX, Windows 98, Windows XP.

Languages: SQL, PL/SQL, C, C++, JAVA.

Databases: Oracle 9i/10g/11g

GUI: Developer 6i/9i (Forms & Reports).

Tools: & Utilities: SQL*PLUS, SQL*Loader, TOAD, XML/BI Publisher

ERP Packages: Oracle Applications11i (GL, AP, AR, INV, PO, PN, OM) Application Developer, System Administration.

PROFESSIONAL EXPERIENCE:

Confidential, Winston-Salem, NC

Sr Oracle Applications Developer

Environment: (wif skill versions) ERP: Oracle Applications 11i (11.5.10.2)/R12 Languages: SQL, PL/SQL. Developer 11g Database: Oracle 11g Tools: TOAD, SQL*PLUS, XML Publisher O/S: Windows XP, SUN Solaris

Responsibilities:

• Design and development of custom interfaces to upload teh data from legacy system to oracle Distributor Management custom tables.
• Responsible for creating teh Database tables, indexes, constraints in Oracle 10g/11g.
• 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.
• Developed reports in Order Management (OM) for sales orders generated.
• Worked closely wif functional team and business to resolve bugs and defects and UAT.
• Developed several OBIEE reports
• Developed ADF Pages for custom applications.

Confidential, Boston, MA

Oracle Applications Consultant

Environment: (wif skill versions) Software Module: GL, AP, AR, PO, PN, OKS.

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 wif 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 wif business and functional users before moving it back to production through change management.
• Involved in Building Customizations and Enhancements using Reports.
• System Administrator activities like Creation of Concurrent programs, responsibilities, User management, Printer Setup at OS and Application level.
• Developed Inbound and Outbound Interfaces to ensure teh proper flow of data in both Oracle Receivables and 3rd party tools.
• In addition, also used teh System Administrator responsibility to create users, assign responsibilities, Value Sets and Request Sets
• Worked closely wif functional team and business to resolve bugs and defects and UAT.
• Designed and Developed functional and technical documentation (MD50, MD70, MD120) using AIM Methodology.

Confidential

Sr. Oracle Technical Consultant

Environment: (wif skill versions) Software ERP: Oracle Applications 11i (11.5.10.2) Languages: SQL, PL/SQL. Database: Oracle 10g Tools: TOAD, SQL* Loader, Reports/Forms6i, XML Publisher O/s: Windows XP, SUN Solaris

Responsibilities:

• Involved in development of RICE (Reports, Interfaces, Conversions, and Extensions) components.
• Imported AR Invoices from legacy system into applications using SQL*Loader script, Import Sources and AR Interface tables.
• Involved in conversion of legacy Purchase orders in to Purchasing and applied taxes.
• Involved in Item conversion of legacy data into Oracle Applications using PL/SQL packages and Shell Scripts. SQL * Loader was used to load data into custom tables.
• Developed PL/SQL Packages, Procedures, Functions for validating teh invoices and payment information from teh legacy system and imported into Oracle Application using teh Payables Open Interface Import program and populated into teh Base Tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
• Involved in customization of Stores Receipt Voucher Report and Inspection of Purchase Order Report using Report 6i.
• Developed an interface for loading new item on hand quantity information for teh imported items from legacy system into oracle using SQL*Loader and PL/SQL.
• 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
• Automated teh process of migrating Data Definitions and Templates from Instance to Instance.
• Responsible for teh implementation of Oracle Applications. It included Business analysis, Business Flow documentation, Process Mapping, implementation and setup, developing test strategies of teh Oracle Application and user .
• 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.
• Involved in application management services like help desk support, technical support to teh users.

Confidential

Sr Oracle Apps Technical Consultant

Environment: (wif skill versions) Software ERP: Oracle Applications 11i (11.5.10.2) Languages: SQL, PL/SQL. Database: Oracle 10g Tools: TOAD, SQL* Loader, Reports/Forms6i, XML Publisher O/s: Windows XP, SUN Solaris

Responsibilities:

• Involved in teh implementation and support of RICE components of various Oracle financial modules like AP, GL, AR and Purchasing and Inventory.
• Responsible for creating teh Database tables, indexes, constraints in Oracle 9i.
• Created Stored Procedures, Functions, Packages, Triggers using SQL, PL/SQL.
• 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
• 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.
• Developed an interface program to load tax information for valid purchase orders into localization tables.
• Customized and developed numerous reports in General Ledger Module.
• Solved help desk tickets.
• 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.
• Understanding teh requirements for teh modules.
• Involved in development of Custom Reports and Interfaces.
• Testing of teh units developed.

Confidential

Oracle Apps Technical Consultant

Environment: (wif skill versions) Software ERP: Oracle Applications 11i (11.5.10) Languages: SQL, PL/SQL. Database: Oracle 9i Tools: TOAD, SQL*PLUS, SQL* Loader, Reports/Forms 6i O/s: Windows XP, SUN Solaris

Responsibilities:

• Customized ADS Format payments program. Oracle provides ‘Format Payments (Evergreen, Laser)’ (APXPBFEL.rdf) for printing of laser checks. This interface will has to be customized to fit ADS needs. Remittance advice will be printed on teh pay-stub and also will has to be customized to add/remove few columns mentioned in subsequent sections. Customizations were like displaying payment handling code DFF etc., A unix shell script concurrent program is submitted from teh After Report trigger which extracts teh output file of teh report from, renames it and places it in outbound.
• 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.
• Developed Custom Accounts Payables Outbound Interface to teh Fireproof. Teh vendor invoices created in oracle will be interfaced to teh Fireproof. Fireproof provides scanning services to ADS to provide document management and storage solutions as well as cost-effective outsourced scanning production. Invoices of all types except wif T & E pay groups (“T&E DIRECT DEPOSIT”, “T&E CHECKS”) shouldn’t be considered for teh data extract. Teh extracted data file will be moved to teh Fireproof FTP server using a shell script.
• Developed a Custom Accounts Payables inbound interface. Invoice data from teh Freight Management System (FMS) in teh current legacy BPCS environment will be communicated to teh Oracle ERP system. FMS uses Nistevo freight software package and ADS modified their BPCS FMS to accommodate teh Nistevo invoice file processing. Teh Nistevo product was initially justified for “Time and Cost Savings” and its potential to provide “Better data for better decision making”. Teh program is scheduled to run only once in a day.
• Prepared teh Installation document MD120 and Involved wif teh functional user in preparing teh TE020.
• 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.
• Created temporary tables using PL/SQL and developed SQL*Loader control files to load data from Legacy system into temporary tables
• Apart from working on teh above specified tasks and involved in analysis of teh change requests by teh clients and getting them incorporated in teh objects.

Confidential

Oracle Apps Consultant

Environment: (wif skill versions) Software ERP: Oracle Applications 11i (11.5.10) Languages: SQL, PL/SQL. Database: Oracle 9i Tools: TOAD, SQL*PLUS, SQL* Loader, Reports/Forms 6i O/s: Windows XP, SUN Solaris

Responsibilities:

• Involved in teh development of a conversion in Accounts Payable module. This conversion program converts 1099 supplier invoices from FMS and Infinium legacy systems to oracle. 1099 invoices include items dat are considered taxable wages by teh IRS miscellaneous code for non-employee income, etc. On teh day of teh cutover to Oracle there will be invoices in teh legacy systems dat are closed (paid). Since 1099 reporting to teh IRS is performed at teh end of teh year, we need to make sure dat teh reported amounts include invoices paid through teh legacy systems before teh cutover as well as
• Calculate a quarter to date value for each of teh 4 Arby’s bonus plans and teh Area Supervisor bonus plans. Teh calculated value is posted to each unit’s bonus expense and accrual accounts. Teh prior period’s entry is reversed in teh current quarter’s period and a new quarter to date calculated value is posted to teh those processed through Oracle after teh cutover.
• 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. Some E-property related information captured on DFFs in teh property managers is send to teh E-property system. Teh outbound file is placed in teh custom outbound directory on teh UNIX directory structure.
• Apart from these, also involved in Unit test case and document preparation and testing of teh units developed.

Confidential

Software Engineer

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 dat are been updated when error rises during teh conversion process.
• Worked on optimizing existing procedures and functions using PL/SQL.

Environment: Oracle Applications 11.5.10, SQL* Loader, SQL* Plus, TOAD, Forms 6i and Reports 6i, SQL, PL/SQL, Oracle 9i, Windows 2000.