PROFESSIONAL SUMMARY:

• Over 11+ years of experience in Oracle Technology focusing on analysis, design, development, customization and implementation of various businesses applications using Oracle Applications E Business Suite R12 / 11i, Oracle D eveloper 2000 and Discoverer
• W ell experienced in the following modules:
• Financials: Accounts Payable (AP), Accounts Receivables (AR), General ledger (GL), Project Accounts (PA), Fixed Assets (FA), Cash Management (CM)
• Supply Chain Management (SCM): Inventory (INV), Purchasing (PO), Order Management (OM), Costing (CST), Advanced Pricing (QP), Shipping (WSH)
• Manufacturing & Distribution: Bill of Materials (BOM), Work in Process (WIP), Warehouse Management Systems (WMS), Mobile Supply Chain Applications (MSCA)
• Others: iExpenses, iProcurement, Human Resources Management Systems (HRMS), Install Base, Workflow, Application Data Interface (ADI) and Electronic Data Interface (EDI) modules
• Experienced in full life cycle implementations, conversions, upgrades and support of Oracle E - Business Suite 11i / R12 environments
• Experience in Procure to Pay (P2P) and Order to Cash (O2C) cycles
• Experienced in Federal Financials Year-End closing process.
• Experienced in training to the stakeholders which include customers, end users, junior developers in Procure to Pay, Order To Cash and SQL,PL/SQL
• Expertise in designing functional & technical specification documents
• Expertise in developing MD-50, MD-70, BR-100, CV-60 documents using AIM methodology
• Proficient in performing FIT / GAP analysis, designing Reports, Interfaces, Conversions and Extensions (RICE) Objects. Expertise in Forms and Form Personalization’s
• Commendable experience in data conversions, interfaces, migrations, import and export using tools like SQL*Loader
• Experienced in Mobile Supply Chain Applications (MSCA)
• Demonstrated expertise with Application Upgrade and Security Administration
• Excellent verbal and written communication skills. Work well under pressure. Meet ambitious deadlines. Works well in a team as well as by self.

TECHNICAL SKILLS:

ERP: E-Business Suite R12, 11.5.10, Multi-ORG, Multi Reporting Currency (MRC)

Tools: Microsoft FrontPage, Dreamweaver, Microsoft Visio, Rational Suite, Microsoft Project, FSG, Report Manager, Discoverer, HP Quality center

Languages: SQL, PL/SQL, Shell Scripting, UNIX, C & C++, Java, COBOL

Reporting Tools: Reports 6i, Forms 6i, Discoverer, XML Publisher (BI Publisher), SQL Reports

PROFESSIONAL EXPERIENCE:

Confidential, Upper Marlboro, MD

Senior Oracle Applications Technical Consultant

Responsibilities:

• Expertise in designing & developing functional & technical specification documents like MD-70, MD-50, IQP, RMP,SSIP using AIM methodology
• PCard Interface is Credit Card Technology Process which the data will be provided by UN Bank,and finally converted to Journals- Developed the whole Interface
• Modified the FSG Reports ..based on the Current Environment.
• Developed the TDC Interface, for the TDC fee for all the Requisitions who are buying ay computers or laptops from the schools system.
• Developed interface for Asset management system from APEX environment to Oracle Applications.
• Worked on Pl/Sql package to automatically populate the ship to location on a PO item.
• Worked on Discoverer report for the GL actuals data..
• Worked on Pl/Sql package to resolve the issues getting creates as sales orders from TDC package.
• Worked on Alert when users are overwriting the locations on PO for the ship to Location.
• Created custom tables, Triggers, Sql scripts for the unclaimed Report, Grants Report.
• Involved on code migration from one instance to another instance, and using FND load commands for the AOL objects.
• Add validation for default account when you create PO and posting the General Ledger ..
• Involved in Unit Testing, Staging and User Acceptance testing (UAT)
• Practiced change control using FND Load for moving developed/tested code and objects into production.
• Documentation of each object specifying business need of the object and its functionality in detail . Environment: Oracle E-Business Suite R12, 11.5.10(Financials: PO, GL, OM, CM, AP, INV), Toad 9.6.1, tables, views, packages, procedures, functions, triggers,
• Oracle E-Business Suite R12,11.5.10(Financials: AP, AR, PO, GL, HRMS), Toad 9.6.1, tables, views, packages, procedures, functions, triggers, PL/SQL, Oracle Reports 6i, Oracle Forms 6i, Oracle Configurator, XML, MSCA Gun, Unix, Shell Scripts, Putty, Microsoft Visual Source Safe 6.0, STAT, EditPlus 3, WinSCP, SFTP, Microsoft Office Suite 2007, Google Mail, CISCO VPN and Windows XP Professional

Confidential, Rockville, MD

Oracle Applications Technical Lead

Responsibilities:

• Expertise in designing & developing functional & technical specification documents like MD-70, MD-50, IQP, RMP,SSIP using AIM methodology
• Bank of America will provide the Credit Card Transactions data and it will be converted to EDI format Developed interface (945 EDI), Auto Invoice to create Auto Invoice.
• Developed interface for (823 EDI), Auto lockbox to create Receipts.
• Developed interface (945 EDI) for the Ship Confirm Interface.
• Developed interface for (944 EDI)
• Developed outbound program to generate the sales order file EDI 940, suing UTL FIle
• Worked on loading the customer data, using Customer Interface.
• Worked on Initial balance and reconciliation process for 945,823 when switching from one business to other business for UPS to SPS
• Created shell scripts, control files, custom tables, Triggers
• Involved on code migration from one instance to another instance, and using FND load commands for the AOL objects.
• Involved in Unit Testing, Staging and User Acceptance testing (UAT)
• Practiced change control using FND Load for moving developed/tested code and objects into production.
• Documentation of each object specifying business need of the object and its functionality in detail . Environment: Oracle E-Business Suite R12, 11.5.10(Financials: AR, PO, OM, GL, CM, AP, INV), Toad 9.6.1, tables, views, packages, procedures, functions, triggers.
• PL/SQL, Oracle Reports 6i, Oracle Forms 6i, Oracle Configurator, XML, MSCA Gun, Unix, Shell Scripts, Putty, Microsoft Visual Source Safe 6.0,EditPlus 3, WinSCP, SFTP, Microsoft Office Suite 2007, Google Mail, CISCO VPN and Windows XP Professional

Confidential, Greenville, SC 

Oracle Applications Technical Lead (Onsite, Offshore Model)

Responsibilities:

• Gathered requirements from the stakeholders and worked alongside them to convert their business requirements into technical solutions successfully
• Expertise in designing & developing functional & technical specification documents like MD-70, MD-50, BR-100, CV-60 documents using AIM methodology
• Providing the solutions to the offshore team on the individual extracts for the modules General Ledger, Projects
• Developed interfaces to convert data the Oracle EBS for the following objects: Vendors, Vendor Sites, Receipts
• Developed PL/SQL packages to extract Suppliers, Supplier Sites, Supplier Contacts, Supplier Banks Data.
• Developed complex PL/SQL packages to extract Purchase Orders, Global Blanket Agreements.
• Developed complex PL/SQL packages to extract HRMS Employees, Employee Assignments and Employee Address Data.
• Developed complex PL/SQL packages to extract GL Budgets,GL Balances data
• Giving guidelines to the tem members for developing the other module objects data extraction process.
• Developed complex PL/SQL packages to extract AP Transactions
• Creation of Table Scripts, Migrating the objects to other instance.
• Worked on to retrieve the data for General Ledger budgets, General ledger Account Balances.
• Responsible for developing shell scripts to call the packages and automatically transfer data files to different servers by passing appropriate credentials as parameters using file transfer protocol (ftp)
• Involved in creating staging tables. Used SQL *Loader to load the data into tables
• Practiced version control using SVN.
• Involved in unit testing, staging and User Acceptance testing (UAT)
• Practiced change control using FND Load for moving developed / tested code and objects into production
• Documentation of each object specifying business need of the object and its functionality in detail

Environment: Oracle E-Business Suite R12,11.5.9(Financials: AP, AR, PO ,GL, HRMS), Toad 9.6.1, tables, views, packages, procedures, functions, triggers, PL/SQL, Oracle Reports 6i, Oracle Forms 6i, Oracle Configurator, XML, MSCA Gun, Unix, Shell Scripts, Putty, Microsoft Visual Source Safe 6.0, Zentrack, EditPlus 3, WinSCP, SFTP, Microsoft Office Suite 2007, Google Mail, CISCO VPN and Windows XP Professional

 Confidential , Exeter PA 

Oracle Applications Techno functional

Responsibilities:

• Developed Warranty Orders Report and scheduled it to run periodically using the concurrent program manager
• Develop Credit Memo Report and scheduled it to run periodically using the concurrent program manager
• Developed Deliveries Report which shows on hand quantity of pick release or ship confirms items. It was scheduled to run daily using spooling functionality
• Developed PL/SQL packages to generate a waybill number automatically for the Canadian Org
• Developed PL/SQL packages and procedures to calculate item cost rollup for REFKIT (Reference KIT) assembly items
• Developed Vendor Report for the newly created vendors by vendors, which will have vendors, Vendor Sites, Receipts
• Implemented a PL/SQL package and procedure to extract the Bill of Ladings (BOL) file and ftp the file to external clients
• Responsible for developing shell scripts to call the packages and automatically transfer data files to different servers by passing appropriate credentials as parameters using file transfer protocol (ftp)
• Involved in creating staging tables. Used SQL *Loader to load the data into tables
• Practiced version control using in Microsoft Visual Source Safe
• Involved in unit testing, staging and User Acceptance testing (UAT)
• Practiced change control using FND Load for moving developed / tested code and objects into production environment
• Expertise in raising Technical Assistance Request’s (TAR) & Service Request’s (SR) in Oracle Metalink
• Delivered solution to various issues raised by end users in Zentrack

Environment: Oracle E-Business Suite 11.5.10.2 (Modules: INV, OM, PO, AR, AP, WMS), Toad 9.6.1, tables, views, packages, procedures, functions, triggers, PL/SQL, Oracle Reports 6i, Oracle Forms 6i, Oracle Configurator, XML, MSCA Gun, Unix, Shell Scripts, Putty, Microsoft Visual Source Safe 6.0, Zentrack, EditPlus 3, WinSCP, SFTP, Microsoft Office Suite 2007, Google Mail, CISCO VPN and Windows XP Professional

Confidential , Schaumburg, IL 

Oracle Applications Technical Lead (Onsite, Offshore Model)

Responsibilities:

• Gathered client specifications and provided comprehensive solution scenarios there by empowering them to make decisions that match their business needs
• Experienced in developing requirements documents, design documents and short form documents
• Defined the Aliases, Set up of Recurring Journals, Stat Journals & Mass Allocation Journals
• Monitoring cash application process through lockbox and manual receipts
• Worked on Year-End Closing process, Budget Execution open Interface.
• Developed complex PL/SQL packages and procedures to extract party, party sites, party site uses and contacts data in Trading Community Architecture (TCA)
• Developed complex PL/SQL packages and procedures to extract items, item catalogs, item buyers, item cross references, items weight(s), item UOM and item costs data in Inventory (INV) module
• Developed complex PL/SQL packages and procedures to extract vendor, vendor sites and vendor bank account information data in Account Payables (AP) module
• Developed complex PL/SQL packages and procedures to extract Approved Suppliers List items (ASL) data in Purchasing (PO) module
• Developed complex PL/SQL packages and procedures to extract pricelist items, price lists qualifiers, dynamic pricelists data in Advanced Pricing (QP) module
• Responsible for developing shell scripts to call the packages and automatically transfer data files to different servers by passing appropriate credentials as parameters
• Practiced source code control using Rational Clear Case
• Responsible for migration of objects from one instance to other instance using Kintana
• Involved in creating staging tables. Used SQL *Loader to load the data into these tables
• Conducted rigorous unit testing of all objects, participated and supported User Acceptance Testing (UAT)
• Expertise in raising Technical Assistance Request’s (TAR) & Service Request’s (SR) in Oracle Metalink
• Prepared help files, technical documentation and user manuals

Environment: Oracle E-Business Suite 11.5.10.2 (Modules: AR, AP, PO, GL, INV, OM, QP, BOM, WIP), Toad 9.6.1, tables, views, packages, procedures, functions, triggers, PL/SQL, Oracle Reports 6i, Oracle Forms 6i, XML ,Unix, Shell Scripts, Putty, Rational Clear Case, Microsoft Outlook , SFTP, Microsoft Office Suite 2007 and Windows XP Professional

Confidential , Rolling Meadows, IL

Sr. Oracle Apps Techno-Functional Developer

Responsibilities:

• Prepared technical specification documents
• Worked on conversions for items, vendor items, item aliases, catalog items and categories in Inventory (INV) module, BOM items, WIP items
• Imported Orders from the existing system into the Oracle EBS using Order Import API (OE Order Pub)
• Imported Price Lists from the existing system into the Oracle EBS for all the items with their custom individual price list names like current retail, sale and VIP. Created look up values to call the price lists dynamically by using a trigger
• Enhanced adding vendor number, sequence number using a custom PL/SQL package, ORSK2B.
• Created a materialized view and price list trigger on qp list lines table to update the prices for the Point of Sale (POS) application
• Developed a new item form which contains catalogs, categories, vendor items, price list information; Wrote the procedure to create items, catalogs, categories automatically and store them in the corresponding appropriate base tables
• Developed, tested and implemented a new Custom Form using Forms 6i to check for the min / max quantities of an item
• Developed new matrix report using Reports 6i to display on hand quantity and average quantity details of the items with in a particular duration. Created a PL/SQL Procedure to call this report
• Developed a new form for Tag Printing and Tag Report as well.
• Created a shell script program to call the SQL*Loader program that transfers data in data file to staging tables and runs the custom concurrent program to transfer data from staging tables to interface tables
• Created new request sets, consisting of different concurrent programs, to submit automatically to the concurrent manager
• Practiced version control using Microsoft Visual Source Safe
• Expertise in raising Technical Assistance Request’s (TAR) & Service Request’s (SR) in Oracle Metalink.
• Delivered solution to various issues raised by end users
• Provided training to site’s super users

Environment: Oracle E-Business Suite 11.5.10 (Modules: INV, PO, BOM, WIP, AP,AR,QP, BOM, AR,AP), Toad 8.2, tables, views, materialized Views, packages, procedures, functions, triggers, PL/SQL, Oracle Reports 6i, Oracle Forms 6i, XML ,Unix, Shell Scripts, FTP, Putty, Microsoft Office Suite 2007, Microsoft Outlook and Windows XP

Confidential , Hoffman Estates, IL

Sr. Oracle Apps Technical Developer

Responsibilities:

• Involved in designing technical specification documents
• Gathered requirements using MD-70 and MD-50 documents. Developed complex PL/SQL procedures to extract the warranty and insurance information data and ftp it to LGI Corp., N.E.W Corp. using shell scripts.
• Developed a custom report: RBAR multiple cycles report
• Developed a new custom form: RECAP form. Customized it to display the images
• Customized RBTRANS transaction form by adding lookup values for transaction type
• Customized Receipts form using ZOOM feature
• Experienced in forms personalization: OM Unable to create external source line (line in ship/arrival set)
• Developed a materialized view on mtl secondary inventories table. Created a trigger on this materialized view and the inserts scripts to load data into a temp table when a record is either created, deleted or modified
• Developed a materialized view on mtl descr ele val table. Created a trigger on this materialized view and the inserts scripts to load data into a temp table when a record is either created, deleted or modified
• Created a shell script to call the SQL*Loader program that transfers data in the data file to a staging table and runs the custom concurrent program to transfer data from the staging table into the interface tables
• Practiced change control using FND Load for moving developed / tested code and objects into production environment
• Prepared setup documents and uploaded them into Microsoft Visual Source Safe
• Delivered solution to various issues raised by end users
• Prepared help files, technical documentation and user manuals

Environment: Oracle E-Business Suite 11.5.9 (Modules: INV, PO, AP, AR), Toad 8.2, tables, views, materialized views, packages, procedures, functions, triggers, PL/SQL, Oracle Reports 6i, Oracle Forms 6i, Oracle Forms 10g, XML ,Unix, Shell Script, Microsoft Office Suite 2003, Microsoft Outlook and Windows XP Professional

Confidential , Broken Arrow, OK

Oracle Apps Techno-Functional Developer

Responsibilities:

• Gathered requirements from the stakeholders and worked alongside them to convert their business requirements into technical solutions successfully. Prepared technical specification documents
• Performed Application Object Library (AOL) tasks like creating responsibilities, users, request groups, attaching responsibilities to users, defining concurrent programs, creating request sets and creation of executables
• Customized standard check print report from 2 stubs to 3 stubs, which includes 2 invoices and a check using reports 6i and XML Publisher
• Customized printed purchase order report to add ship to address and bill to address fields through API at the header level
• Customized of consolidated billing invoice report to add ship to address and bill to address fields through API in the header level
• Extensively used SRW packages in Oracle Reports
• Developed new report in check printing: APEAT CHECK GT 50K RPTAP
• Customized various reports in Accounts Receivables (AR) related to aging, invoicing, customer balances
• Expertise in Administrator and User Edition’s of Oracle Discoverer. In Administrator Edition, created layer of metadata for End User Layer for hiding the complexity of the database from the users. In user edition, created various business areas, user views, custom folders and joins for developing reports
• Practiced version control using Microsoft Visual Source Safe
• Practiced change control using FND Load for moving developed / tested code and objects into production environment
• Expertise in raising Technical Assistance Request’s (TAR) & Service Request’s (SR) in Oracle Metalink
• Delivered solution to various issues raised by end users

Environment: Oracle E-Business Suite 11.5.9 (Modules: INV, PO, AP, AR), Toad 8.1, tables, views, materialized views, packages, procedures, functions, triggers, PL/SQL, Oracle Reports 6i, Oracle Forms 6i, Unix, Shell Script, Putty, WinSCP, Microsoft Office Suite 2003, Microsoft Outlook and Windows XP Professional

Confidential , NY 

Oracle Apps Technical Developer

Responsibilities:

• Prepared technical specification documents based on the functional specification documents
• Defined setups for functional currency in Project Accounting
• Developed a new Form for Billing Extensions
• Customized Correction forms ( Inter Department, Web Money)
• Developed Journal import interface using an API
• Developed a Utility (UTL) Files Package to generate various files like sales orders, UPC, TICF & over-pack labels and email the same to end users
• Developed and customized Check Printing Report using XML Publisher and Reports 6i
• Developed GL Cost Interface Report
• Developed custom Report RMA to execute for the required set of books.
• Expertise in development, customization, deployment, maintenance & support of Reports
• Created Concurrent Programs for executables like SQL Script’s, PL/SQL package & procedures, Reports and SQL*Loader
• Developed test scripts and test plans
• Performed unit testing, integration testing and supported user acceptance testing (UAT)
• Expertise in raising Technical Assistance Request’s (TAR) & Service Request’s (SR) in Oracle Metalink
• Delivered solutions to various bugs encountered and raised by end users
• Provided off hours and weekend support by being on call
• Experianced in training to the stakeholders in GL, AP, AR, Forms, Reports which include junior developers

Environment: Oracle E-Business Suite 11.5.9 (Modules: AP, AR, GL), Toad 8.1, tables, views, materialized Views, packages, procedures, functions, triggers, Oracle Reports 6i, Oracle Forms 6i,Unix, Shell Scripts, Putty, WinSCP, Microsoft Office Suite 2007, Microsoft Outlook and Windows XP

Confidential

Oracle Apps Technical Developer

Responsibilities:

• Converted business requirements documents (BRD) / functional specification documents (FSD) into technical specification documents
• Defined Setup’s in General Ledger (GL) like Accounting Flex Fields, Cross Validation Rules and Security Rules
• Customized Customer Interface report, Receipts Interface report, Vendor Conversion report and Sales Tax report
• Created , Developed & and Modified packages, procedures and functions
• Expertise in development, customization, deployment, maintenance & support of Reports
• Created Concurrent Programs for executables like SQL Script’s, PL/SQL package & procedures, Reports and SQL*Loader
• Practiced version control using Microsoft Visual Source Safe
• Practiced change control using FND Load for moving developed / tested code and objects into production environment
• Provided off hours and weekend support by being on call

Environment: Oracle E-Business Suite 11.5.9 (Modules: INV, PO, AP, AR, QP, BOM, AR, AP), Toad 8.1, tables, views, materialized views, packages, procedures, functions, triggers, PL/SQL, Oracle Reports 6i, Oracle Forms 6i, XML, Unix, Shell