Radhika Patnala
acri3l@r.postjobfree.com
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