SUMMARY

• Over 7 years of Oracle Applications experience in Design, Setup, Configuration, Development, Conversions, Customizations, Interfaces, Implementation of business applications using Oracle ERP, Client/Server, EDI and Internet Technologies.
• Over 5 years of R12 experience with 2 full cycle R12 implementations with all major modules (Financials and supply chain).
• Well experienced in application development tools, specifically Development and Customization of Oracle Financials & Oracle Manufacturing Applications (OE, BOM, WIP, INV, Purchasing, AR, AP, GL, AOL, System Administration, Alerts).
• Experience in development using Oracle ERP technology (Oracle - Business Suite Application, Oracle Reports & XML Publisher Reports, Workflow Builder and Oracle Application Framework).Exposure to backend system using PL/SQL with Relational databases such as Oracle 9i, 10g.
• Experience in Oracle Applications Modules - Accounts Receivables (AR), Accounts Payables (AP), General Ledger (GL), Order Management (OM), Oracle Inventory (INV), Oracle Purchasing (PO), Work in Progress (WIP), Oracle Pricing (QP), iProcurement, System Administration, Application Object Library (AOL) and Bill of Material (BOM).
• Detailed knowledge on Order to Cash (O2C) and Procure to Pay (P2P) transactional flows with experience in related setups.
• Work experience in Oracle Customer Relationship Management (CRM) modules- Oracle Contracts and Services, Oracle Billing and Oracle Projects.
• Expert in custom Form Development and form Personalization.
• Generated Reports in XML Publisher in different modules.
• Experience in Development, Customization of RICEW (Reports, Interfaces, Conversions, Extensions and Workflow) Objects, Concurrent Programs, Application Programming Interfaces (APIs) and creation of Technical Design Documents.
• Extensive Experience in development of Conversions, Open Interfaces, Concurrent Programs and Request Sets.
• Design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces and APIs.
• Excellent knowledge of Flex fields and Multi-Org.
• Extensive Experience in Implementation and Product development of Oracle Applications.
• Perform Production support activities for Oracle R12 Application.
• Expertise in OA Framework customizations in R12, XML & Discoverer reporting strategy with hands on experience.
• Excellent development and customization experience using Oracle R12/11i, SQL*PLUS, PL/SQL, SQL*Loader.
• Expertise in Preliminary System Requirements Study, System Analysis & Development, Test Plan Preparation, Unit Testing, System Integration testing and documentation.
• Strong knowledge of Application Object Library (AOL), Trading Community Architecture (TCA) and knowledge of System Administrator activities.
• Proficient in writing PL/SQL Packages, Stored Procedures, Functions, Database Triggers, SQL * Loader scripts and shell scripting.
• Responsible for design and development of Interface Programs.
• Worked on writing technical design documents for conversions, extensions, interfaces, reports and Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs).
• Responsible for development of Data Conversion Scripts.
• Preparing both Functional and Technical documentations like MD50, MD70 based on requirements.
• Responsible for Fit-Gap analysis and documenting the Fit Gap documents. Analyzing the Gaps and fixing the Gaps which also need coordination with Oracle Support.
• Worked on Error Handling System in storing all the errors that occur during interfacing and loading data from Flat Files.
• Written several PL/SQL packages to validate the data in the process of data conversion.
• Responsible for performing systems analysis and application configuration on the Oracle ERP application.
• Extensive knowledge in analyzing business process and identifying opportunities for improvement.
• Support team members and help to troubleshoot application issues and develop creative solutions to support business needs.
• Tuned the application code using the Tkprof, SQL Trace and Explain Plans.
• Experienced in Baseline, Integration, Installation, Business Functionality, Performance, Regression, System, User Acceptance, and Volume & Stress Testing manually.
• Used Bulk Collect feature to improve performance.
• Experience in UNIX Shell Scripting, XML, HTML, VBScript and Java Script.
• A good team player and a quick learner adaptable to new technologies.
• Interact with people at all levels; possess excellent communication skills, problem solving skills and work ethics.

TECHNICAL SKILLS

Languages: C, C++, PL/SQL, SQL, .NET, JAVA, Java Script

ERP: Oracle Applications R12/11i, RICE

Application Modules: GL, AP, AR, PO, OM, INV, BOM, WIP, OFA, AOL, Sys Admin, AIM, iProcurement

Database: Oracle 10g/9i/8i, SQL Server 2000

Operating Systems: Windows XP/NT/2000/98, Unix, Linux, Sun Solaris

Packages: MS-Office 2007

GUI: Reports 6i/10g, Forms 6i/10g, XML Publisher

Reporting Tools: Discoverer 9i/10g

Source Control: Visual Source Safe (VSS)

Other Tools: Toad, SQL *Developer, SQL *Plus, SQL *Loader(Export/Import), Work Flow Builder, WinSCP, Reflections, File Zilla

Web Technologies: HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Oracle Applications Technical Developer

Environment: Oracle Applications Suite R12 (AP, AR, GL, iProcurement, INV, PO and AOL), Reports 10g, Forms 10g, XML Publisher, SQL*Plus, TOAD, SharePoint, LINUX and RDMS 11g.

Responsibilities:

• Worked on Financial modules like (GL-General Ledger, AP-Oracle Payables, AR-Oracle Receivables, CM-Cash Management and FA-Fixed Assets).
• Worked in preparation of AIM (Application Implementation Methodology) documents for Functional and Technical specifications of Interfaces and Reports customizations.
• Experience in developing custom Oracle Forms using Oracle Forms 10g.
• Involved with business users in the process of recognizing revenue by Revenue Accounting in Account Receivables (AR).
• Setting up of the Options - Purchasing / Receiving / Financials.
• Provide solutions based on business requirements.
• Implemented interfaces to a third party application using application API’s. These interfaces where used to provide seamless access to a third party application from within our application. This resulted in utilizing the processing abilities of another application without modifying it or redeveloping it.
• Responsible for preparing implementation strategy for smooth implementation of Oracle Applications, preparing process flows, preparing implementation documents, specifications, Business Requirements documents, Functional Mapping Documents, Module Limitation documents and Functional gap documents. Constructed a Design Document for present state and future state.
• Experience in developing inbound and outbound Interfaces for Oracle General Ledger, Accounts Receivables, Purchasing and Inventory modules.
• Trouble shooting in critical issues in AR, GL and AP Modules in R12 environment.
• Setup Project users, Setup roles, role lists, project roles for orgs. Setup Project and Organization security, responsibility, role based security. Setup Project security extension. Setup Task statuses, task types and priorities.
• Worked on R12 AP Payment process changes.
• Used TOAD for application development. Registered Forms and Reports using AOL.
• Strong knowledge in Development and Customization of Forms/Reports with sound understanding of Application Object Library (AOL).
• Developed reports and customized standard Oracle reports using Report Builder 10g, Discoverer and BI/XML Publisher.
• Migrated data from legacy system to Oracle Apps using standard API’s and PL/SQL procedures.
• Used the System Administrator responsibility to create users, responsibilities, Value Sets and Request Sets.
• Designed customer conversion strategy, data mapping and development using API’s.
• Extensively used DBMS, UTL packages and collections to develop PL/SQL code.
• Worked with Customer Interface in Oracle Receivables to load multiple addresses and Multiple Contacts for customers.
• Zoom feature is enabled using custom.pll, and whenever user in sales order form clicks the zoom button. It displays the discount amount calculated for that order basing on the payment terms of the order.
• Developed several PL/SQL packages, procedures, functions, triggers from UI events or database triggers, to implement complex business logic.
• Modified and created new concurrent programs as well as executable files when new reports were created.
• Involved in maintaining and writing several PL/SQL Stored procedures and SQL queries for populating the daily and historical tables.
• Extensive experience in Database query tuning, Performance tuning (Explain Plan and TKPROF utility)
• Raising Oracle TAR's (P1, P2, P3) and worked for solving the problems.
• Handling functional issues related to Oracle Accounts Payables and Oracle Purchasing related to Requisition, PO, Invoice, GL, Receipt, etc.
• Designing and development of custom interfaces in the Oracle AR and Oracle AP.
• Trouble shooting the Reports10g and Discoverer issues in R12.
• Imported Invoices from various feeds into Oracle AP using standard interface process.
• Did testing and documentation of the reports.

Confidential, Columbus, OH

Oracle Applications Technical Developer

Environment: Oracle Applications Suite 12i (AP, AR, GL, OM, QP, PO, INV), Reports 10g, Forms 10g, XML Publisher, SQL*Plus, TOAD, SQL*Developer, Discoverer 10g and UNIX.

Responsibilities:

• Responsible for implementation of Order Management, Account Payables, Account Receivables, General Ledger, Oracle Pricing, Oracle Purchasing and Inventory.
• Worked on Oracle Order to Cash (O2C) cycle.
• PL/SQL procedures and functions necessary for Purchase Order validations before loading records into Purchase Order Interface tables.
• Modified the Oracle reports, SQL reports, PL/SQL programs for changes in Payables and General Ledger module tables.
• Using XML publisher, Sales order Acknowledgement Report have been developed and also customized AR to GL Reconciliation Report.
• Created flex fields as required in the forms of various modules like AP, AR and GL.
• Developed a report, which showed requisition details, purchase order details, receiving details, invoicing details and payment details in Oracle Procure to Pay (P2P) Cycle.
• Developed Mapping Documents and Conversion Program to validate Vendors and Account Payables Invoices before loading into base tables.
• Involved in developing the functional requirements and technical design documentation for OM and PO modules.
• Technical Design and Developed Data Conversion Scripts for CRM conversion objects (Service Contracts, Systems and Installed Base).
• Developed several custom reports as per the requirements of the users in Receivables and Payables. Such as Credit Memos applied to invoice report, Receipt and Payment report by Receipt and check date sales by category report.
• Modified Invoice before Purchase Order report.
• Developed Reports like Individual price list, Product Financial Analysis and Market compare list in Reports 10g.
• Used Order Import to import data into Order Entry/Shipping for processing.
• Worked on Payables Open Invoice Interface in AP.
• Experience in creating master detail forms and adding alerts.
• Worked on Data Conversions for Matched Open AP invoices and Open AP invoices in Accounts Payables.
• Customized XML Publisher Pick Slip and Pack slip reports.
• Developed Various Error Correction forms in the interface process. These forms are used in correcting the error records in staging tables and interface tables.
• Worked extensively to import sales orders to oracle applications using sales order conversion i.e., order import interface.
• Setting the System Profile options at Site, Responsibility and User level for INV& OM modules.
• Involved in Interfaces to import Items from the Legacy System.
• Extensively worked on RICEW objects to view, transfer and modify the data in the same or different system.
• Developed new forms using Template.fmb (AU TOP/forms/US).
• Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
• Developed a package containing different procedures and functions using PL/SQL to cross validate invoice information and load automatically invoices into auto invoice interface tables.
• Diagnostics for troubleshooting application and SQL issues.
• Involved in performance tuning of custom PL/SQL programs and reports.
• Developed several PL/SQL packages, procedures, functions, triggers from UI events or database triggers, to implement complex business logic.
• Worked extensively with tools such as EXPLAIN PLAN, SQLTRACE.
• Resolve crucial issues related to Accounts Receivables by coding customized PL/SQL programs to populate the missed billing data in interface tables.
• Coordinate with Business analysts, onsite and offshore team to complete deliverables.
• Setting Up Auto Invoice.
• Collecting the requirements from other organizations’ heads for Costing tool implementation.
• Provide solutions based on business requirements.
• Involved in Interface designing and Documentation and implementation of these as per AIM.
• Migrated data from legacy system to Oracle Apps using standard API’s and PL/SQL procedures.
• Analyzed existing elements for pre-conversion processing.
• Performed data mapping for the Legacy Systems to Oracle and identified API’s needed for conversion.

Confidential, Columbus, OH

Oracle Applications Technical Developer

Environment: Oracle Applications Suite R12 (AP, OM, QP, AR, GL, iProcurement, INV, PO and AOL), Reports 10g, Forms 10g, XML Publisher, SQL*Plus, TOAD, Oracle BI Discoverer 10g, SQL*Developer, SharePoint and UNIX.

Responsibilities:

• Responsible for implementation in Order Management, Inventory, Account Receivables, Account Payables and General Ledger, Purchase Order, Costing, BOM and WIP.
• Developed code for Conversions to extract legacy journals and to load them to GL Interface tables using Journal import.
• Worked on Procure to Pay and Order to Cash Processes.
• Built custom forms using Oracle Forms 10g Builder to fulfill the business requirements of the client.
• Experienced in validation and defaulting, processing constraint checks and releasing order holds and scheduling of shipments using Order Import interface on OE ORDER HEADERS ALL, OE ORDER LINES ALL.
• Populated data into table OE HEADERS IFACE ALL which is a multi-org table for Sales Order Headers Open Interface.
• Worked on the customization of forms, which included development of new forms and customization of the existing forms in Order Entry and Inventory, AP and PO.
• Designed and developed a single interface program to import invoices into Oracle Payables from three different sources and registered this as a single concurrent program which was used by these sources.
• Involved in customization of several standard reports to serve important business processes very specific to the client which include Invoice on hold report, vendor, payments, and analysis reports in AP, and also Customer receipts, invoice, and adjustment reports in AR.
• Used the features of BI Publisher such as Sort, Group, Total, Subtotals to make data intense operations happen at the template level.
• Created customer invoices, credit memos, debit memos and account credits using auto invoice interface in account receivables.
• Involved in Customer Conversion to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them in to base tables using TCA APIs.
• Developed a report, which showed requisition details, purchase order details, receiving details, invoicing details and payment details in Oracle Procure to Pay Cycle (P2P).
• Developed data entry forms, complex and template forms in Forms 10g.
• Developed control files to transfer data to staging table using SQL*Loader and validate the date for the Standard Items in INVENTORY and load the data using item import interface to MTL SYSTEM ITEMS B table.
• Extensively used of advanced PL/SQL concepts such as collections and bulk processing to achieve best performance. These were used in large data conversion scripts, to process records within a procedure or package before updating them to the database.
• Tested Interface and conversion objects and trouble shouted many issues in testing phase and documented the whole process to report to management.
• Writing and review of functional and specs for purchasing objects including Purchase orders conversion and Interface and PO Receipts Interface.
• Developed RICEW development matrix to support cutover plan and project management planning and status Reports to executives.
• Enhanced performance of large complex SQL queries using SQL performance tuning methods such as explains plan and hints. Based on the results of explain plan, appropriate Index were created and joining clauses used.
• Designed and Developed Custom Reports for Quote to order Conversion, Closed PO Report, Sales Analysis Report, etc., using Discoverer 10g.
• Involved in design and testing of RICEW objects from Purchasing, Project Accounting, Inventory, BOM and AP.
• Preparation of project plans, estimates and other technical documents.
• Resource allocation to the project.
• Communication with other units like Finance, Corporate Services, Collaboration Units for requirements gathering for new customizations.
• Define functional requirements and develop functional and Technical design for custom modules.
• Preparing both Functional and Technical documentations like MD50, MD70 based on requirements.
• Provide solutions based on business requirements.
• Setting up of the Requisition Templates/Document Types - Blanket PO/Freight Carrier etc.
• Setting up Payment Terms, Transaction Types & Sources, Standard Memo Lines, Accounting & Invoicing Rules.
• Defining Shipping, Picking - Defining Pick Slip, Grouping Rule, Defining Release Sequence Rule, Container Load, Carrier Ship Method, Freight Cost Type.
• Setting up of Customers, Customer Profile Classes.
• Setting up Payment Terms, Transaction Types & Sources, Standard Memo Lines, Accounting & Invoicing Rules.
• Coordinate with Business analysts, onsite and offshore team to complete deliverables.
• Provide solutions based on business requirements.
• Customized Print Requisition Report by adding one more field Accounting Id description only then End User may identify under which the Account is distributed.
• Involved in Interface designing and Documentation and implementation of these as per AIM.
• Analyzed existing elements for pre-conversion processing.
• Performed data mapping for the Legacy Systems to Oracle and identified API’s needed for conversion.
• Responsible for Fit-Gap analysis and documenting the Fit Gap documents. Analyzing the Gaps and fixing the Gaps which also need coordination with Oracle Support.
• Perform data conversion and provide data validation support during data conversion.
• Support team members and help to troubleshoot application issues and develop creative solutions to support business needs.
• Developed appropriate systems and user documentation to support deployment of applications.

Confidential, Covington, LA

Oracle Applications Technical Developer

Environment: Oracle Applications 11i (GL, AP, OM, INV and AR), Reports 6i, Forms 6i, BI/ XML Publisher, SQL*Plus, TOAD, SQL *Developer, Discoverer.

Responsibilities:

• Responsible for of General Ledger, Account Payables, Order Management, Oracle Inventory and Account Receivables.
• Interacted with users and analyzed their requirements to develop custom code, forms and reports as per their need and registered with application.
• Developed Interface Anonymous PL/SQL blocks for loading Orders to Oracle Order Management tables and importing the Orders using standard API program, Order Import.
• Worked on customization of reports such as AR Customer Invoice Report, Pack Slip Report, Open Order Report and Purchase Order Report.
• Responsible for the technical design, program development, unit testing and migration of AP Invoice Interface.
• Defining Shipping, Picking - Defining Pick Slip, Grouping Rule, Defining Release Sequence Rule, Container Load, Carrier Ship Method, Freight Cost Type.
• Customized the following workflows: PO Approval Workflow: Implemented notification reminder and Timeout needs for the PO Approval workflow PO Account Generator Workflow.
• I have got good exposure in different technologies like Oracle SQL, PL/SQL, Oracle Applications and Oracle Forms.
• Interface programs for AR Customers and OM Open Sales orders were written using API and used extensively to import the data into base tables.
• Created custom packages and procedures using PL/SQL in AR, OE and PO and registered under the concurrent.
• Developed conversion program to load AR invoice transactions.
• Worked on Employee, Assignments, Addresses, Phones, Contacts, Payment Methods and Salary Conversions along with their history using API’s and PLSQL Scripts.
• Extensively used PL/SQL to implement cursors, triggers and packages and to develop stored procedures, functions and critical reports.
• Used TOAD, SQL Developer and SQL Navigator for code development, executing queries.
• SQL Performance tuning was done using Explain plan, correct Index creation, Analyzing table stats and creating the right data model.
• Developed dynamic SQL Scripts within the procedures to create process specific SQL statements. This ensured that SQL generated was optimized for the options selected for that process. This has greatly helped in the performance of the application.
• Used Oracle SQL loader to load large group client’s information provided in a formatted text file to the database.
• Interacted with clients understanding the operational requirements, troubleshooting data and application issues, reporting bugs and following it up to resolution.
• Creation of new responsibilities and new menus based on the type new report and form customizations.
• Preparation of Technical Documents MD 50, MD70, Install guides and User Manuals.
• Define functional requirements and develop functional and Technical design for custom modules.
• Writing Technical specs based on functional specs on various Interface and conversion objects inclusive of Account Payables, Purchasing and Project Accounting.
• Performing Quality reviews and Code reviews and Debugging Activities.
• Interface designing and Documentation and implementation of these as per AIM.

Confidential

Oracle Technical Developer

Environment: Oracle Applications 11i (OM, AP, INV), SQL, TOAD, PL/SQL, SQL * PLUS, SQL *LOADER, SQL*Developer, Forms 6i and Reports 6i.

Responsibilities:

• Created Custom reports using Reports 6i.
• Created stored procedures, Packages, Functions and triggers using SQL & PL/SQL.
• Involved in user meetings regarding integration of Oracle Applications with the existing Legacy systems.
• Developed Program to load item information coming from legacy systems using SQL * Loader and PL/SQL.
• Handled various custom reports and customized standard Oracle reports like Vendors on Hold Report, Employee Listing as per the business requirements.
• All the security roles and privileges are stored in the database tables and the logic is implemented using functions and views. Promoted the security feature to the existing reports with a very minor code change in the actual reports.
• Required Data Extraction from oracle applications base tables in a flat file format using UTL FILE package.
• Development of new reports using Reports 6i and SQL*Plus. Extensively used several Oracle supplied packages for the different types of report and data extraction.
• Designed and developed Interfaces using PL/SQL and SQL*Loader and UNIX Shell Scripts, to load the data into Oracle Applications from legacy systems.
• Performance Tuning: Analyzing, tuning and optimizing for Oracle Server Applications by using performance monitor.
• Worked on Error Handling System in storing all the errors that occur during interfacing and loading data from Flat Files.
• Mapping documents MD 70 are developed by looking MD 50 documents using AIM methodology.