Radhika Patnala

acri3l@r.postjobfree.com

678-***-****

Conversions Interfaces Reports Forms XML Reports Developments Customizations Upgrades

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 Developer 2000 and Discoverer

Well experienced in the following modules:

oFinancials: Accounts Payable (AP), Accounts Receivables (AR), General ledger (GL), Project Accounts (PA), Fixed Assets (FA), Cash Management (CM)

oSupply Chain Management (SCM): Inventory (INV), Purchasing (PO), Order Management (OM), Costing (CST), Advanced Pricing (QP), Shipping (WSH)

oManufacturing & Distribution: Bill of Materials (BOM), Work in Process (WIP), Warehouse Management Systems (WMS), Mobile Supply Chain Applications (MSCA)

oOthers: 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

Education

Bachelor of Engineering in Computer Science from Nagarjuna University, Guntur India.

Oracle Certified Professional (OCP) & Oracle Certified Associate (OCA)

Professional Experience

Company : Priam Inc Feb ‘14 – Till Now

Company : Quantum Infotech Inc Mar ’11 – Jan ‘14

Client : Prince George’s County, Upper Marlboro, MD Jul’12 – Till Date

Senior Oracle Applications Technical Consultant

Prince George’s County Public Schools (PGCPS), one of the nation’s 25 largest school districts, having 204 schools, approximately 124,000 students and nearly 18,000 employees. The district serves a diverse student population from urban, suburban and rural communities. PGCPS Board of education IT Support is implemented Oracle Applications R12 and also the having school max system,Apex system.

Oracle applications R12, Upgraded from 11.5.10.2 to R12

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

Company : Quantum Infotech Inc Mar ’ 11 – Jan ‘14

Client : OTSUKA Pharmasuticals, Rockville, MD Jan’ 12 – May’ 12

Oracle Applications Technical Lead

Otsuka Group is striving to cultivate a culture and a dynamic corporate climate reflecting our vision as a healthcare company. small-scale manufacturer of chemical raw materials, in 1946 the company began producing and selling intravenous solutions, marking its entry into the pharmaceutical products market. OTSUKA Pharmaceuticals inc is the best Pharmaceuticals Company and manufacture of MDD instruments, and they are shipping t all the products through UPS, and implemented the Oracle in 2003, now they are converting the business from UPS to SPS.

Migration of business from UPS to SPS for all the EDI’s

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

Company : Quantum Infotech Inc Mar’ 11 – Jan ‘13

Client : Michelin NA Inc, Greenville SC Apr’ 11 – Dec ’11

Oracle Applications Technical Lead (Onsite, Offshore Model)

Michelin North America Inc is the world's leader in the design and manufacture of tires, including aircraft and automobile. They started out as a family business in 1963 focusing solely on the manufacture of automobile tires. Next Michelin entered into manufacturing the Aircraft tires. As such, the Purchase-to-Pay process is being modernized. Part of this modernization involves both systems (Oracle P01) and processes (POLARIS project). Thus, business practices are being realigned through-out the world.

Migration or Upgradation of Oracle E-Business Suite 11i to R12

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

Company : Redeem Soft Solutions Inc Sep ‘10 - Mar ' 11

Client : Pride Mobility Products Corp, Exeter PA Oct ‘ 10 - Mar ‘11

Oracle Applications Techno functional

Pride Mobility Products Corp. is the world's leader in the design and manufacture of mobility products, including power lift chairs and mobility scooters. They started out as a family business in 1986 focusing solely on the manufacture of power lift chairs. In the coming years Pride extended its product line to include scooters with options and accessories. Next Pride entered the powered wheelchair market with the release of their highly-successful Jazzy with its exclusive mid-wheel drive. In time, Pride entered the rehab market with their Quantum division. Pride product lines now include their Synergy Seating cushion line, TRU-Balance Power Positioning systems, and the Go-Go Travel Mobility Scooter line.

Production Support in Oracle E-Business Suite 11.5.10.2

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

Company : Satya Marg Solutions Inc Nov‘ 09 - Sep '10

Client : Motorola Inc, Schaumburg, IL Nov ‘09 - Aug ‘10

Oracle Applications Technical Lead (Onsite, Offshore Model)

Motorola, Inc. is an American-based, multinational, telecommunications company based in Schaumburg, Illinois. It is a manufacturer of wireless telephone handsets, and also designs and sells wireless network infrastructure equipment such as cellular transmission base stations and signal amplifiers. Motorola's home and broadcast network products include set-top boxes, digital video recorders, and network equipment used to enable video broadcasting, computer telephony, and high-definition television.

Migration or upgraded from Oracle E-Business Suite 11.5.8 to Oracle E-Business Suite 11.5.10.2

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

Company : OSI Consulting Inc,Hyderabad May ‘07 - Nov '09

Client : Rogers and Holland’s, Rolling Meadows, IL Aug ‘08 – Nov ‘09

Sr. Oracle Apps Techno-Functional Developer

Rogers & Holland’s has been Chicago's largest family owned and operated jeweler since 1910. They have grown to become the largest family owned jeweler in the nation.

This was a conversion project consisting of converting data from the existing mainframes IBM AS/400 to Oracle E-Business Suite (Oracle EBS) 11.5.10.2 & Productions Support

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

Company : OSI Consulting Inc. May ‘07 - Nov '09

Client : Robbins Brothers Jewelry Inc, HoffmanEstates, IL May '07 - Aug '08

Sr. Oracle Apps Technical Developer

Robbins Brothers Jewelry Inc. is a California-based jewelry store specializing in engagement rings. Robbins Brothers describes itself as “the world’s biggest engagement ring” store.

Production Support in Oracle E-Business Suite 11.5.10.2

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

Rapidigm (India) Ltd Feb ‘06 - Mar' 07

XETA Technologies, Broken Arrow OK Feb '07 – Mar '07

Oracle Apps Techno-Functional Developer

XETA Technologies, founded in 1983, has been a participant in the continuing evolution of how people communicate. The company started in a time in which the telephone was a relatively simple, hardwired device, the personal computer was in its infancy and few knew about the Internet. XETA helped usher in the on-site PBX system and call accounting practices for businesses and institutions, participated in the convergence of voice and data through IP telephony, and helped customers develop data networks and applications to navigate the dotcom boom and bust. Mobile phones, application-rich smartphones and the emerging importance of social networking and dynamic applications are just a few of the challenges our customers face today.

Production Support & Upgradation in Oracle E-Business Suite 11.5.10.2

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

ERP Services Inc. Feb ‘04 - Feb'06

Prudential Financial Inc, NY Jul '05 – Feb '06

Oracle Apps Technical Developer

Prudential Financial, Inc. is a financial services leader with approximately $750 billion of assets under management as of September 30, 2010, has operations in the United States, Asia, Europe and Latin America

Production Support in Oracle E-Business Suite 11.5.10.2

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

ERP Services Inc. Feb ‘04 - Feb'06

Client worked for Tektronix Telecomminucation Feb ’04 - Jun’05

Oracle Apps Technical Developer

Tektronix, Inc. is a North American company best known for its test and measurement equipment such as oscilloscopes, logic analyzers, and video and mobile test protocol equipment. As of November 2007, Tektronix is a subsidiary of Danaher Corporation.

They were implementing Oracle E-Business Suite 11.5.9

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

Scripts, Putty, WinSCP, Microsoft Office Suite 2003, Microsoft Outlook, Windows XP Professional

Contact this candidate