SUMMARY:

• Over Six years of IT experience in Analysis, Design, Development, Testing and Implementation of Business Applications using Oracle Applications 11i/R12.
• Hands on Experience with Developer 2000 (Forms10g/6i, Reports10g/6i), Discoverer 10g, Oracle 10g/9i/8i, SQL* Plus, SQL loader, TOAD, Workflow Builder 2.x, BI Publisher (XML Publisher), Jdeveloper and BPEL.
• Extensive experience in Customization and implementation of Oracle Application modules which includes AP (Account Payable), AR (Account Receivables), GL (General Ledger), FA (Fixed Assets), PO (Purchasing Order), IP (Internet Procurement), INV (Inventory).
• Extensively worked on Inbound/Outbound Interface. Work includes writing pre-import validation programs for Oracle out of the box import programs and developed custom inbound and outbound interfaces for various jobs.
• Proficient in Customization of Oracle Applications using Forms, PL/SQL Packages and Triggers.
• Expertise in Customizations of RICE (Reports, Interfaces, Conversions, Extentions) items.
• Experience in implementation, customization/upgrade of Oracle Applications versions 11i/R12
• Extensive experience setting up Flex fields which includes Defining Key flex field structures and enabling Descriptive flex Fields for adding the new fields.
• Experience in System Administration tasks like registering menus, forms, reports, concurrent programs, Profile options, user setup, defining responsibilities, values sets by using Application Object Library (AOL)
• Proficient in tuning SQL statements using Explain Plan, Auto trace, SQL Trace and Tkprof.
• Expertise in Writing SQL*Loader programs to load the data into tables by reading flat files.
• Experience in working with Functional teams to gather Business requirements and implementing solutions.
• Experience in writing MD50, MD70, MD120 documents by following Oracle AIM Methodologies.
• Strengths include excellent communication skills and interpersonal skills, good analytical skills and logical approach to problem.

TECHNICAL SKILLS:

ERP: Oracle Applications R12, 11.5.10, 11.5.8, 11.5.7 and 11.5.5
(AP, AR, GL, FA, PO, IP and INV).
GUI: Developer 2000, Forms 10g/6i/4.5.
Languages: SQL, PL/SQL, JAVA, WSDL, XML, BPEL.
Databases: Oracle 10g, 9i, 8i.7.x
Tools: Reports 10g/6i, SQL* Loader, TOAD and Oracle Discoverer 10g/4i.
Operating Systems: Windows XP,Windows 95, Windows NT, MS DOS and HP UNIX.

EDUCATIONAL QUALIFICATION:

• Bachelor Degree in Computer Science and Engineering.
  
  PROFESSIONAL EXPERIENCE:
  
  Confidential,Princeton, New Jersey Apr ’11–Till
  Oracle Application Production Support & Development
  Responsibilities:
  Developed a customized AutoRate program in AP to enter exchange rates for foreign currency invoices and payments for all the operating units at one shot rather than submitting the Autorate program for each operating unit.
• Enhanced custom Credit Suisse Payment Log Interface program to display Bank account information in the log file.
• Developed custom program using TCA Location API to update the Supplier sites Address Information.
• Customized AP check print templates as per the Tyco check format layout.
• Developed GL Daily Rates Interface program to import daily exchange rates into

Oracle General Ledger Module.

• Created new Discoverer Report Budget and Forecasting for Quarterly Variance version.
• Personalized Invoice Workbench form in Accounts Payable for not allowing users to create, update or delete invoices when using Hold/Release Responsibility.
• Enabled the Descriptive Flex Field on the Locations form to store third party address identifier information.
• Modified various Discoverer reports to add new Columns, Titles and Date/Time Stamp to the Title headers.
• Developed Journal import inbound interface to import journals into General Ledger module from different external sources.
• Developed Extensions and Interfaces as part of Procure to Pay Implementation(P2P).
• Developed new Xml publisher reports for Suppliers and customers banking details.
• Prepared detailed MD70’s for all the new requirements and updated the existing documents with changes.
• Developed MD120 migration documents to migrate the changes from one instance to another instance.
• Wrote Sql Scripts to fix the Data Issues in Production.
• Worked closely with Oracle support on various tasks such as raising SR’s, requesting patches and data fixes.
• Provided 24*7 production support.
  Environment: Oracle Financials (AP, AR, GL, PO) R12, Oracle forms 10g, Oracle Reports 10g, PL/SQL, SQL*Loader, Oracle 10g, BI Publisher.
  
  
  Confidential,Atlanta, GA Aug ’10 – Mar’11
  Oracle Application Developer
  
  Responsibilities:
• Developed custom Account analysis Report to display sub ledger transaction details.
• Created Asset conversion program to bring active CIP assets from 11i to R12 for each asset book as part of R12 upgrade.
• Developed BPEL Payroll journal interface to import journals into General Ledger module.
• Purchase order form has customized to display the error message when funds are not available in the general ledger budget account.
• Customized Invoice workbench form to implement confidential invoice functionality.
• Implemented Invoice Maker/checker functionality in the Invoice Workbench form to make sure the person who entered the invoice should not allow him to validate that invoice.
• Developed programs to load PO Receipts files from external systems to APPS modules.
• Customized all custom reports in General Ledger module to make R12 compliant.
• Upgraded discoverer reports to R12 to support multi org access control feature.
• Developed new xml publisher reports for Suppliers and customers banking details.
• Developed custom Inbound/Outbound interfaces from E-business applications.
• Provided Production Support after Upgraded to R12.
• Prepared the Technical Design Specifications (MD70s).
• Wrote Sql Scripts to fix the Data Issues in Production.
• Troubleshooting failed Inbound and Outbound Interfaces, Reports and provided fixes.
• Raised Service Requests with Oracle when there is an Issue in Oracle Code.
• Interacted with the business users, fixed the conversion data issues and prepared scripts to fix incorrect conversion data.
• Developed extract scripts for extracting the data from 11i instances.
• Environment: Oracle Financials (AP, AR, GL, PO) R12, Oracle forms 10g, Oracle Reports 10g, PL/SQL, SQL*Loader, Oracle 10g, BI Publisher and BPEL.
  
  Confidential,Louisville, KY Apr ’09 – Jul ‘10Oracle Application Developer

Responsibilities:

• Customized bank accounts tab of Vendor form to force the user to enter banking details if payment method is Electronic.
• Wrote the validations for bank account details and bank branch address details.
• Customized AR aging 7 bucket report to display buckets information by terms rather than customer.
• Customized Payable transfer to GL program to carry the Dff information to GL module.
• Developed AR Monthly Customer Statement report by customizing the AR aging 7 bucket report. New report displays aging 5 buckets, previous statement balance, and current statement balance.
• Implemented Positive pay file outbound interface with the banks for verifying the vendor checks against the company funding account.
• Developed GL Account Balance Analysis report to analyze Balances and Activities for selected accounts for specific companies, business units and departments with in range of accounting periods.
• Customized Printed purchase order report with client specific format.
• Developed GL pre-import validation program for performing the validations like sources, categories, set of books, currencies, periods and loading journal into interface tables.
• Extensively used XML Publisher to design the layout of the report for different output formats like PDF, HTML and EXCEL.

Environment: Oracle Financials (AP, AR, GL, PO) 11.5.10 and 11.5.8, Oracle forms 6i, Oracle Reports 6i, PL/SQL, SQL*Loader, Oracle 9i, Sql Station.

Confidential,Tampa, Fl Mar ‘08 – Mar ’09
Oracle Application Developer
Responsibilities:
Developed pre-import validation program for Payable open interface import. Pre-import validation program checks the invoices against vendor and payable option setups and correct the distribution code combinations. Logic to update document category based on the corp code of the invoice and checks the unique corp code at the distribution level.

• Modified the Invoice Register report to include the invoice hold information and included accounting date as parameter to bring the invoice between accounting dates instead of period.
• Involved in implementation of Procure To Pay modules across citi group business globally.
• Developed Journal Outbounds for various external systems based on the country specific requirements.
• Wrote pre-import validation program to validate source, category, set of books, currency, period, balances and DEAL information and also this program copies the DEAL related information from invoice distribution table to gl interface table if the journal source is payables for Journal import process.
• Customized Depreciation Projection report to include YTD and NBV column.
• Modified Asset Workbench form to display warning message after changing the default life of the asset.
• Performed set-ups, which include financial, payable, Functions, Value sets, Profile options, Lookups and DFF.
• Responsible for Writing Database level Triggers for checking validations during the transaction processing.
• Extended the functionality of Oracle application forms using the CUSTOM.pll.
• Developed Payment Outbound Interface for Payment Service Providers (PSP). Service providers are responsible for distributing the funds for Vendors.

Environment: Oracle Financials (AP, GL, FA, PO, EDI) 11.5.10, Oracle forms 6i, Oracle Reports 6i, PL/SQL, SQL*Loader, Oracle 9i, Kintana, Autosys, Sun Solaris.

Confidential,Tampa, FL Apr ‘07 – Feb ’08
Oracle Application Developer

Responsibilities:

• Worked on Purchase order import, requisition import and receipt import interfaces to bring the data from external sources and loading into respective interface tables.
• Created Quotation saving report to analyze and compare the buyer winning quotation against re-negotiated quotation amount.
• Developed outbound interfaces for purchase order extract, requisition conformation extract and receipt conformation extract.
• Wrote pre-import validations for lock box interface program in account receivables.
• Developed generic external file upload feature by using oracle provided attachment functionality.
• Wrote conversion program for loading the on hand quantity items into inventory interface tables.
• Responsible for writing validation program for Item Upload interface.
• Customized oracle out of the box forms using Descriptive Flex field and Cusotm.pll
• Developed custom form for mapping the external identifiers to local identifiers.
• Developed OFAC inbound/outbound interfaces.

Environment: Oracle Financials (PO, INV, AR) 11.5.4, Oracle forms 6i, Oracle Reports 6i, PL/SQL, SQL*Loader, Oracle 8i, HP UNIX.

Oracle Application Developer

Responsibilities:

• Mapping of data elements in the source system to facilitate GL Import Process. Analyze various required, conditionally required columns of GL_INTERFACE table.
• Upload of payment receipt through Auto Lockbox Interface in AR.
• Worked on Mass Addition Interface in FA. Built PL/SQL programs to perform Mass additions to load conversion of assets from legacy system.
• Developed custom reports which includes Global Extract Report, Expense GL Outbound Feeds Report, Inactive Descriptive Flex field Report and Single Payer Extract report etc
• Worked on Auto Invoice to bring the legacy invoices in to Oracle in AR.
• Customized the Invoice Aging & Customer Balance Report in AR.
• Developed Item Interface conversion script for importing item information from Legacy System to Item Base tables through Open Item Interface program in INV.
• Customized Oracle delivered reports in Oracle Inventory Application such as Serial no transaction register, Serial number detail reports, and Missing item report as per the client’s specifications.
• Developed and Customized Reports in AR namely Invoice Exception Report, Customer Credit Report, List of Checks Report, Invoice Listing by customer Report.
• Oracle public HZ APIs has used to load the Customer Information into TCA tables.
• Developed Custom Interface to import vendor’s information from legacy system to Oracle Application
• Designed, developed and registered reports using AOL.

Environment: Oracle 11i (GL, AR, INV, FA) UNIX, Windows 2K, Oracle 8i, TOAD, PUTTY, Forms 4.5, Reports 2.5, PVCS.

Responsibilities:

• Developed forms using Oracle Forms2.3 and 4.5
• Extensively written PL/SQL program units and stored procedures.
• Used Pro*C for file processing and data validation during data loads and Developed various reports.
• Involved in Data Transfer (SQL*Loader) between Org-Super Max (Unix) and PCs.
• Developed reports using Reports1.1 and 2.5
• Written database triggers for capturing audit logs.
• Conducted user-training sessions for all the systems.
• Regular Database Maintenance tasks like backups, table space management, and performance tuning.
• Involved in Designing and Developing of the systems mentioned below:

PROJECT: Material Accounting System (MAS)
In addition to the primary objective of Inventory Control, MAS also aims at reducing the redundancy of data across different user departments. Providing accurate status of every item in the stores and assembly line. Controlling of excess inventory, Identification of non-moving obsolete items. Scrap accounting and control, Vendor rating, Compare figures of inventories for different periods (quantitative and value wise), generating stores ledger on weighted average, and FIFO (First-In First Out) method.

• Environment: Oracle 7.x, PL/SQL, SQL* Plus, Forms 4.5, Reports 2.5, SQL* Plus, SQL* loader, Unix