Profile:

• Five Years of experience with ERP implementation and Enterprise Applications Practice with proven experience in Developing, Customizing, Maintain and Supporting Oracle Applications 11i (AP, GL, PO, OM, AOL, FS).
• Strong programming experience in creating Procedures, Packages, Functions and other database objects using SQL and PL/SQL.
• Proficient at writing SQL, PL/SQL, SQL *PLUS, TOAD, and other related tools and techniques on Oracle Database in Windows 2000/2003 environments.
• Involved in projects, involving requirements analysis, design and customization as per the business rules and needs.
• Experience in writing Unix Shell Scripts.
• Experience in Interfaces in Oracle E-business suite Applications.
• Have good working experience with custom inbound and outbound interfaces.
• Experience in documenting (Functional, Design, Test, and User Manual) using Client Methodology and Standard AIM Methodology.
• Used Client Specific Change Control.
• Experience in generating reports using Oracle Report and Discoverer 10g.

Skills:

Oracle Applications: Oracle Applications 11i, R12
Oracle Financials: Accounts Payables (AP), Accounts Receivables (AR),
General Ledger (GL), Purchasing (PO)
Oracle Manufacturing: Order Management (OM), Shipping, Inventory (INV)
Methods: Oracle Applications Implementation Methodology (AIM)
Tools: SQL* Plus, PL/SQL, SQL* Loader, TOAD
Development Tools: Developer2000 (Reports 2.5/6i, Discoverer 10g)
Languages: SQL, PL/SQL,
Database: Oracle 9i/ 8.x, 10g, MS Access,
Operating Systems: MS-DOS, UNIX, and Windows NT/XP/2000/2003

Educational Qualification:

• Master in Computer Science

Certification:
Oracle PL/SQL Developer Certified Associate (OCA).

Professional Experience

Confidential,Jun 05 –Present

• Developed some Ad-hoc reports for Audit Information.
• Developed a Concurrent Program to Extract Vendors and Vendor Sites which were created or modified on daily basis and ftp it to the remote server so that the third party tool Sequentra can pick it up and loads data .
• Created a Concurrent Program to Extract all Incomplete Subcontract PO’s and to send the information to the Buyer or the Requestor. Email will be sent to Buyer only if the Requestor Email Address does not exist.
• Developed Supplier Statistics Discoverer Workbook. This Workbook lists number of Open PO’s and number of Open Invoices for a given supplier.
• Developed a Discoverer Report with Three worksheets Invoice Information, PO Information, and Payment Information for the given Contract Number and the Vendor Number.
• Enhancements to the Discoverer Reports like adding columns, Parameters.
• Created value sets for the new reports developed and registered them using AOL.
• Registered concurrent Programs (Host, SQL, SQL * Loader, Oracle Reports, PL/SQL Stored Procedures) in oracle applications using Application Object Library.
• Developed reports using Discoverer10g, Created custom views, new folders, conditions and joins based on user requirements. Exported And Imported Folders and Workbooks.
• Written shell scripts to ftp the files between two different servers.
• Written Shell Scripts to send e-mails to the Users with the error reports of the Processes they run.
• Written Materialized view, registered a concurrent program to refresh the view.
• Involved in Supporting on Must load Days (Month End).
• Day-to-Day Support of Finance Modules.
• Added new value to existing Value Set.
• Involved in design of AIM (Application Implementation Methodology) Functional and Technical documents. Developed required documents for various works such as inbound/outbound and Discoverer Reports.
• Training the End-Users in using New Automated Processes and helping them for testing by creating test data and running queries to gather the same.
• Modified Oracle Report to add new column.
• Written sql script to update Supplier and Supplier site Payment terms and priority.
• Written some scripts to create view, index, table, and synonym and materialized view.
• Created Service Request (TAR) and worked with Oracle Support to resolve daily production support issues.
• Created User Manual for new Automated Processes for End user.
• SQL *Loader and UTL_FILE Packages were used for interfaces.
• Used Change Control to migrate the code from Development Instances to Test and Production Instances.
• Experience in reviewing the Functional Documents and preparing and modifying the Technical Design Document for the development work done.
• Involved in Upgrade Testing from 11.5.7 to 11.5.10 for PO Module.
• Involved in Upgrade Testing from 11.5.10 to R12 for PO Module.
• Worked on Receipt Interface Process in Purchasing for Drop Ship Sales Order.
• Created custom table, registered the table and columns in Oracle Application,
• Created key flexfield for custom table.
• Created value set type special and attached the value set to DFF.
• Developed and Enhanced Daily Rates Import Process.
• Developed a Common Process to Load Journals to GL_Interface.
• Developed a Common Concurrent Process to take sql file name as a parameter and process the sql file and ftp the output to destination server.
• Developed a Process to bring in the Fixed Assets Information like (Depreciation, Additions, Assets, and Retirements) to GL.
• Provided Production Support for WEB ADI in GL.
• Developed a vendor Interface Process in AP.
• Involved in interface to load the supplier site in PO .
• Modified the OE Order Line workflow to update the RA Invoice in interface tables for Field Service Implementation.
• Involved in Field Service Implementation.
• Created script to update the Requisition interface table for Spare (Field Service Orders).
• Created Receipt Interface for Spares PO.
• Created script to import AP invoice from different sources.
• Created script to import Quotation, Approved supplier list and sourcing for PO to be autocreated.
• Modified the PO Create Document workflow to auto approve the PO based on business rule.
• Created a Package to integrate Oracle with Web Base Application.
• Wrote UNIX Shell Scripts for FTP the files from remote server to our server and then Process the Files and load the data into staging tables.
• Created a Program to send email to all the suppliers with the wrong information they have provided for the invoice like Duplicate Invoice Number, PO Number, and Project Number branch Information etc.
• Defined new Value set for report parameters and registered them in apps using AOL.
• Created Discoverer report for PO related to Open Contract for given PO number and Org ID.
• Created Discoverer report for all open invoices for given PO.
• Created Ad hoc Report all Incomplete PO.
• Developed a Process to Import the Purchase Order from AOMS.