Oracle Application Developer
Resume:
RAJESH BANDARU
Summary:
• Over Seven years of experience in Designing, Developing, Converting, Implementing and Upgrading of Oracle Applications 11.5.10/11i/10.7 using ORACLE 8i/9i, SQL, PL/SQL, Forms 6i, Reports 6i, Discoverer 4i/10g.
• Extensive experience in Implementation, Migration, Customization, Production and Support of Oracle Receivables (AR), Oracle Payables (AP), Oracle General Ledger(GL), Order Management/Order Entry (OM/OE), Oracle Inventory (INV), Oracle Purchasing (PO), Application Object Library (AOL), System Administration modules of Oracle Applications.
• Experience with RICE components.
• Experiences in tables, Indexes creation, Roles, user setups and security.
• Experience in Dynamic SQL, Records, Arrays and Exception Handling.
• Worked extensively in Application development using Forms and Reports 6i, Discoverer 4i/10g, SQL, PL/SQL in Client Server architecture using UNIX/ LINUX/ Windows.
• Proficient in Data conversions between Modules via interfaces and APIs, using stored procedures, functions, packages and triggers.
• Have a fair knowledge on ELECTRONIC DATA INTERCHANGE (EDI).
• Expertise in handling XML PUBLISHER in customizing reports.
• Developed PL/SQL procedures and used SQL*loader to transfer data from Legacy systems.
• Very well versed with PVCS (Version Control Systems) and Migration Tools such as Kintana.
• Experience in Application System Administration activities like managing concurrent managers, application user setup, defining responsibilities, value sets, flex fields, registering menus, forms, reports, concurrent programs, and printers.
• Use and development of FND API’s like FND_PROFILE, FND_SUBMIT, FNDLOAD. Also wide use of Oracle Apps features like Flex fields, Security, Menus, and Functions
• Exceptional problem solving and analytical skills, highly motivated and positive oriented, excellent verbal, written, communication and presentation skills.
• Ability to learn and adapt to new technologies, good team player in dynamic work group environments.
EDUCATION:
• Bachelor of Technology, India.
• Oracle 9i PL/SQL Developer Certified.
Technical Skills:
• Applications: ORACLE FINANCIALS 11i - Oracle General Ledger, Accounts Payable, Accounts Receivable, Oracle Inventory, Oracle Order Management, Oracle Assets, Oracle Purchasing, Cash Management.
• Oracle Manufacturing/Distribution: Inventory, Purchasing, Order Management
• Oracle CRM/Service: Install Base, Service Contracts
• Oracle AOL: Architecture and Data Model, Concurrent Processing, Registering of Forms/Reports,
• Tools: Developer 2000 Forms 4.5i/6.0i, Reports 2.5i/6.0i, Oracle Discoverer 3i/4i, SQL Navigator, SQL*PLUS, SQL LOADER, TOAD.
• Data Base: ORACLE 8i/9i, Microsoft Access 2000/XP, Sybase, SQL Server 2000.
• Programming Languages: C, C++, SQL, HTML, XML, PL/SQL, Java, UNIX Shell Scripts, Pro*C.
Professional Experience:
Hercules Offshore, Houston, TX Dec’07 – Till Date Role: Oracle Apps Techno functional Consultant
Implementation, Customization and Support of Oracle Financial Modules GL, AP, AR, FA, Project Accounting, OM, INV and System Administration.
Responsibilities:
• Involved in design, development & implementation of Oracle Application modules. Modules include GL, AP, AR, FA and Project Accounting.
• Developed a custom program to import data related to cross validation rules from production instance to test instance.
• Developed control files for SQL*Loader and PL/SQL programs for loading and validating the data into the interface tables from the Legacy system
• The development included the conversion of the data (Budget Upload) from legacy systems to the oracle database and also creating the custom reports for the client
• Developed an outbound interface to transfer GL balances into custom staging tables.
• Worked Extensively on Discoverer 9i/10g Admin, Desktop and Plus Editions to develop various reports in GL, AP, AR, OM, INV, Shipping, HRMS modules.
• Created Business Area’s and Custom Folders in Discoverer Admin version.
• Created APPS mode EUL and enabled seeded Business Areas and workbooks.
• Developed New Hires Report to generate list of all new hire employees (by desired date range).
• Developed Benefit Senses Report to reconcile billing; and to maintain enrollment rosters.
• Developed Terminations Report to generate list of terminated employees (by desired date range).
• Developed Daily Sales Dollars Report. The purpose of this report is to capture the total sales dollars shipped for a given date range.
• Developed Item Cost Audit Report. The purpose of this report is to confirm item cost setup, accounts, and categories.
• Developed Inventory Transactions by Account Report to track the query on an account to summarize the quantity and cost of on assorted inventory transactions i.e., scrap, cycle count adjustments, misc cost. Total reconciles to account balance.
• Developed On hand Inventory Value Report to report the quantity and cost of on hand inventory.
• Worked on Vendor, Invoice Conversions in AP and Customer, Invoice Conversions in AR.
• Worked on Check Printing, AP Cleared Checks, Supplier Mailing Labels Report, Invoice Aging reports for payables to accomplish customization according to business requirements.
• Customized Transaction Register Report, Invoice Aging Report in receivables according to user requirements to group the invoices at different levels.
• Developed a package to import vendor information into purchasing base tables.
• Involved in Customization of reports using Discoverer 10g.
• Used SETPARAM.GETPARAM Function in custom folder.
• Trained End User’s and Power User’s to familiarize with Discoverer Plus and Viewer Tool.
• Customized Standard Oracle Outstanding Hold report according to the requirements.
• Developed several reports using Oracle Reports to meet the business requirement.
• Developed item classes and item hierarchies according to client report requirements.
• Developed and customized Reports using XML Publisher like Tax Audit Trail Report, Matching Detail Report and credit hold reports.
• Raised several TARS’ to resolve issues with Oracle support.
• Work with OOD to resolve issue’s by raising several TAR’s (Technical Assistance Request).
• Raised highest priority TAR’s i.e. severity 2.1 to resolve urgent issues.
Environment: Oracle Applications 11i (AP, GL, AR, FA), Database 10g, UNIX, TOAD, SQL*Plus, SQL*Loader, PL/SQL, Discoverer 9i/10g.
Masco Contractor Services, Daytona Beach, FL Mar’07 –Nov’07
Role: Oracle Apps Techno functional Consultant
Implementation, Development and Customization of Oracle Financials & Distribution Modules GL, AP, AR, PO, Quoting, OM and INV.
Responsibilities:
• Designed and Developed Custom Reports for Quote to order Conversion, Closed PO Report, Sales Analysis Report, etc., using Discoverer 10g.
• Involved in Production Support for the Tickets raised, Change requests and Enhancements for Discoverer Reports.
• Designed and developed Invoice print Reports, PO Print Report using XML Publisher.
• Development includes interface and conversion of data from legacy systems to the Oracle database. Developed SQL*Loader and PL/SQL programs as a part of the development.
• Validated and interfaced AP Invoice information from Legacy system into Oracle.
• Validated and interfaced GL Journal information from Legacy system into Oracle.
• Developed a Custom program to assign Items from Master Organization to Other Inventory Organizations based on hierarchies.
• Developed a Custom Utility Program, which is used by multiple programs, to derive Division Name, Address, etc.
• Involved in Forms Customizations. Added Validation Logic in the triggers on custom forms.
• Customized the Requisition Account Generator Workflow to populate one of the segment values based on business requirements.
• Interacted with end users to gather requirements and draft specifications for the development phase.
• Created MD-50, MD-70, MD-120 and Unit Test Plan for all the above requirements.
• Involved in preparing User Manuals for Oracle Standard and Custom Reports.
Environment: Oracle Applications 11.5.10, IBM - UNIX, Oracle 10g, SQL, PL/SQL, SQL*Loader, Reports 6i, Discoverer 10g, XML Publisher and AOL.
Western Digital, Lake Forest, CA May ‘06 – Feb ‘07
Role: Oracle Apps Technical Consultant
Implementation, Customization and Support of Oracle Financial Modules GL, AP, AR, FA and System Administration.
Responsibilities:
• Developed Customer Interface, Auto Lockbox Interface and Auto Invoice.
• Developed a feeder program to load external data from legacy system using SQL*Loader.
• Wrote a package containing different procedures and functions using PL/SQL to cross validate invoice information and load automatically invoices into auto invoice interface tables.
• Used Customer Interface to transfer and validate Customer data from legacy system into AR.
• Created procedures and SQL*Loader Scripts to populate Customer interface tables with data such as Customer Profiles, Phone Contacts at various levels, Payment Method data & Customer Bank data.
• Used SQL*Loader to import receipt data into AR_Payments_Interface table after defining Lockbox, and Transmission Format and running Lockbox interface form transferred data into Oracle Receivables.
• Imported AR invoices through ELECTRONIC DATA INTERCHANGE (EDI).
• Involved in the design, development, and import of invoice information into Oracle Receivables.
• Customized reports in GL like Trail Balance (Assets & Liabilities, Expenses & Revenues).
• Worked extensively in production support Issues in Oracle Receivables and Payables.
• Worked with Administration Edition of Oracle Discoverer. Created layer of metadata for End User Layer for hiding the complexity of the database from the users, created various business areas, user views, custom folders and joins for reporting.
• Worked with User Edition of Oracle Discoverer, developed various financial analysis reports (for all modules) written for AP, GL and AR.
• Used XML PUBLISHER to develop customer order status report and credit hold reports.
• Customized multiple reports and forms in AR, AP and OE modules according to the requirements.
Environment: Oracle Applications 11.5.9, Sun Solaris - UNIX, Oracle 9i, SQL, PL/SQL, SQL*Loader, Reports 6i, Discoverer 4i, Oracle Applications 11.5.9, AOL, GL, AR and AP.
GE Energy, Houston, Texas Mar ’05 – Apr ‘06
Project Name: Oracle 11i Applications Implementation
Role: Technical Consultant
Responsibilities Include:
• Involved in design, development & implementation of Oracle Application modules. Modules include GL, OM, AR, AP, INV
• Developed PL/SQL programs using TCA API’s to validate and import customers from legacy system into base tables.
• Developed control files for SQL*Loader and PL/SQL programs for loading and validating the data into the interface tables from the Legacy system
• The development included the interface and conversion of the data from legacy systems to the oracle database and also creating the custom reports for the client
• Interacted with end users to gather requirements and draft specifications for the development phase
• Worked on Order Import interface in OM
• Extensively worked on customer interface in Receivables
• Developed many new reports like Customer Order status Report, Backlog Detail Report, Backlog Summary Report, Backlog by Item Report, Cycle Status Report, Open Work Order Report, Sales Rep Commission Report, Customer Profiles Report etc.
• Performed the whole Order Cycle, which includes Booking, Pick Release, Ship Confirming, and Interfacing to Receivables, Complete Line and Complete Order.
• Customized a report ‘On time Delivery Analysis Report which gives detailed output of how many orders are shipped early, late and on time for each customer using XML publisher.
• Achieved excellent understanding of AOL & Sys Admin, developed new reports, forms, functions, validation sets, request sets and concurrent programs
Environment: Oracle 11i, OM, GL, AP, AR, Logistics, Windows 2000/NT 4.0, SQL*Loader, PL/SQL, Forms 6i, Reports 6i
Telmar Network Technology, Irvine, CA Dec ‘04 – Feb ’05
Role: Technical Consultant
Enhancements/Customization of Oracle Applications GL, AP, AR, PO, FA and OM Modules
Responsibilities:
• Developed a custom API to generate error, data files and import data from Vendors into OM
• Written custom package for Purchase Order Interface, to import vendor information into purchasing base tables PO_VENDORS, PO_VENDOR_SITES_ALL, and PO_VENDOR_CONTACTS.
• Modified Reports like Expected Receipts Report and PO Status Report in Purchasing.
• Developed a custom API to generate data files for shipping to gather information and report in specific layout for shippers.
• Created technical and migration documents for enhancements for Customers.
• Using the Admin edition and User edition of Discoverer, created workbooks for management based on AP tables. The work involved creating hierarchy (rollup) reports using application security as defined in Oracle Applications.
• Used XML PUBLISHER for developing shipping reports such as pick slip reports and packing slip reports.
• Creating technical documents using VISIO and test documents.
Environment: HP UNIX, Oracle Apps 11.5.9(OM, Oracle Shipping, AR, AOL, SYSADMIN), Discoverer 4i, Oracle 9i, TOAD, PL/SQL, Reports 6i
Hibbertgroup Trenton, NJ Oct ‘03 - Nov ‘04
Role: Technical Consultant
Implementation, Upgrading and Customization of Oracle Application Modules AP, AR, GL, CM and INV
Responsibilities:
• Responsible for converting the invoice data from legacy system to Oracle Applications.
• Imported the Data from the external system into temporary interface table using PL/SQL.
• Customized report Inventory Listing by Item in Inventory.
• Developed data validation using PL/SQL package/triggers/procedures, SQL Plus for various objects.
• GL Interface that automates the processes of posting revenue and statistical data from a billing system to GL. AP Interface that uploads Tax information to the payables system.
• Each of these interfaces carries an error report.
• Writing stored procedures for loading orders to INV material Interface tables and running Item Imports.
• Developed Item Interface conversion script for importing item information from Legacy System to Item Base tables through MTL_SYSTEM_ITEMS_INTERFACE program in INV.
• Inter-Company Transaction Register Reports, to keep track of inter company revenues Developed Several Reports in General Ledger and Payables.
Environment: Oracle Financials 11i AP, AR, GL, INV, UNIX, Oracle 8i, Forms 6i, Reports 2.5, SQL*Loader, PL SQL developer, TOAD, SQL
TechOrbit, Inc., Dallas, TX Jan ‘03– Sep `03
Role: Technical Consultant
Implementation and Customization of Oracle Financials & Distribution Modules OM, PO, AR, AP and GL
Responsibilities:
• Developed a feeder program to load external data from legacy system using SQL* Loader into AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE Interface Tables.
• Developed SQL*loader script to load customer data and written PL/SQL script to validate customer data.
• Involved in customization of several standard reports to serve important business processes very specific to the client. These Reports were developed since the already existing Oracle Report was not friendly enough to suit the client needs. Such reports include Purchase Order Detail Report in PO, Invoice on hold report, vendor, payments, and analysis reports in AP, and also Customer receipts, invoice, and adjustment reports in AR.
• Worked extensively in production support Issues in Oracle Order Management, Oracle Receivables and Payables. Performed Analysis and Design of Key Flex fields and Descriptive Flex fields.
• Used Custom PLL to implement change in behavior of Standard Oracle Applications forms in Order Entry.
• Design and development of Auto Lockbox interface so that the bank file will be automatically imported into Accounts Receivables.
• Interacted with users and analyzed their requirements to develop custom code, forms and reports as per their need and registered with application.
Environment: Oracle Applications 11i, OM, PO, AR, AP, GL, Reports 6i, Discoverer 4i, PL/SQL, Windows NT, Oracle 8i
Kirloskar Chemicals, Bangalore Jun ‘01 – Sep ‘02
Role: Technical Consultant
Creation of various data base objects and wrote pl/sql procedures.
Responsibilities:
• Responsible for creating the Database tables, indexes, constraints in Oracle8i.
• Created Stored Procedures, Functions, Packages, Triggers using SQL, PL/SQL.
• Invoices are ported from the Excel sheets to the Oracle Database using SQL * LOADER.
• Involved in creation of SQL scripts.
• Meeting with management for enhancement of the system.
• Trained end users.
• Involved in creation of Technical Docs & User docs as well.
Environment: UNIX, Oracle 8i, PL/SQL, SQL* Loader
Contact this candidate