SUMMARY:

• 13+ Years of experience as Oracle Applications (EBS) Technical Consultant in implementation, upgrade and customization of Oracle e - Business Suite Applications. This includes system study, design, development, post implementation maintenance and support of Oracle EBS.
• Extensive experience as Oracle Applications e-Business Suite Consultant and Technical Developer in Design, Development and Implementation of Oracle Applications R12/11i.
• Strong understanding of business flows, underlying technical architecture and table structure of Oracle E-Business Finance Suite.
• Extensive experience in Implementation, Migration, Customization, Production and Support of various modules in Oracle Applications with major focus in Purchasing (PO), Accounts Payables (AP), Accounts Receivable (AR), General Ledger (GL), Sub Ledger Accounting (SLA), Cash Management (CE), Fixed Asset (FA), Order Management (OM), Property Manager (PM), Inventory (INV), I-Expenses, I-Procurement.
• Extensive experience in Oracle Business flow in Order to Cash (OTC) and Procure to Pay (PTP).
• Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.
• Technically proficient in RICEW components (Reports, Interfaces, Conversions, Extensions, Workflow).
• Extensively experienced in Oracle PL/SQL Development i.e. Stored Procedures, Packages, Functions & Triggers.
• Have good knowledge and experience using Oracle Application Framework (OAF) & Personalization’s
• Experience working on SQL*Loader, SQL* Plus, Oracle Import/Export utilities and SQL* Navigator.
• Strong knowledge of Application Implementation Methodology (AIM), Application Object Library (AOL) implementation standards, Trading Community Architecture (TCA) and Software Development Life Cycle (SDLC).
• Worked with the business functional areas to research and identify the best technical solution to support business processes.
• Proficiency with tools used to support Oracle Applications development including PL/SQL, Forms, Reports, Workflow Builder.
• Extensive experience of Oracle Apex 4.0/4.2 and integration with Oracle Application
• Extensive experience in using Oracle hidden packages like DBMS SQL, UTL FILE, DBMS OUTPUT, DBMS UTILITY, UTL HTTP, UTL SMTP
• Experience in creating Technical Design document (MD070), Technical Test Document (TE020), Conversion (CV050), Migration Document (MD120).
• Experience in designing, developing, testing, performance tuning and supporting data base applications using Developer Tools (Reports 6i/9i/10g, Discoverer4i/9i/10g, XML/BI Publisher), PL/SQL on UNIX and Windows platforms.
• Expertise in installing, configuring, and administering WebLogic Server 10.x/12.x in various environments.
• Experience in Confidential Capture 10.0 and Confidential Transformation Module 6.0 for document capture and data Extraction for Invoice creation in ERP system.
• Experience in Installing and Configuring Confidential MarkView 8.2 for AP Automation.
• Excellent in team collaboration, quick adaptation and problem solving with good communication skills.
• Excellent interpersonal skills and an innate ability to provide motivation, and open to new and innovative ideas for best possible solutions.
• Provided on-call and day-to-day support and worked as a part of team in 24x7 production environment.
• Interaction with the offshore development team for development of reports and changes needed in the requirements.

TECHNICAL SKILLS:

ERP: Oracle E-business suite R12/11i/ 11.0.3/11.5.10.2 version Modules worked on: Oracle Purchasing (PO), Accounts Payable (AP), Accounts Receivable (AR), Oracle General Ledger (GL), Sub Ledger Accounting (SLA), Order Management (OM), Oracle Inventory (INV), I-Expenses, I-Procurement, Cash Management (CE), Fixed Asset (FA)

Languages: SQL, PL/SQL, XML, HTML, JavaScript, Shell Scripting.

Databases: Oracle 10g, 11g, 12c, MS Access, MYSQL.

Others: Confidential Capture 10.2, Confidential Transformation Module 6MarkView 8.2, WebLogic Server 10.x/12.x, MS-Word, MS-Excel

MS: PowerPoint

Tools: Oracle - Developer 2000/6i, 10g (Forms, Reports), Toad 9.X, Oracle Utilities, Oracle, Workflow 10g, XML/BI reports, APEX 4.0/4.2, JDeveloper.

Operating Systems: Windows 2000/XP/7, UNIX, MS-DOS.

WORK EXPERIENCE:

Confidential, Bethpage, New York

Sr. Oracle EBS Technical Developer/Lead

Responsibilities:

• Worked on developing custom package to populate a custom table with Posted GL entries with AP and PO details which in turn will be used for OBIEE Reporting Purposes.
• Worked on Enhancing the existing employee update process to removal of the access by disabling responsibilities if there is Job change or report to employee changes of an employee by storing and comparing the information with DFF values in EBS.
• Worked on developing custom views to with open PO information, AP invoices information which are posted to GL and JE information to feed Clarity PPM so that project managers can forecast the project budget.
• Worked on developing custom oracle event alert to send email to the higher management whenever there is an GL suspense account added or updated.
• Worked on custom packages to modify the logic to accommodate multiple requisitions on a single Purchase order in EBS.
• Worked in migrating the custom process of sales performance engine of residential commission form PeopleSoft to Pentaho by developing custom packages and procedure in Oracle database.
• Involved in day to day issues for Oracle EBS and Non-EBS as they arise.
• Worked on Oracle AR Inbound Interface to load the AR transactions to staging table, validate the data and populate the interface table to create invoices in AR using Auto Invoice Master Program.
• Worked on development of custom OAF page to display the Investment Committee Information which will sit on Requisition form to display the amount available to create the requisitions in Purchasing module.
• Developed custom program to update the attributes of serialized items in Inventory by validating and updating the attribute columns in mtl serial number table according to the custom process of mapping the items in the appropriate categories.
• Worked on building OBIEE report for the AP to GL reconciliation by modifying the RDP creating Business Model Mapping layer and eventually showing the values in presentation layer which in turn will be used for creating report in OBIEE.
• Build Custom XML/BI Publisher report to Print AR Invoices containing all the custom DFF values of distribution level in the invoices.
• Worked on performance tuning of custom view by modifying the complex queries and modified packages using blk collect with PL/SQL tables.

Environment: Oracle Applications, R12.1.3 (AP, PO, GL, CM, FA, AR, INV, I-Expense, I-Procurement) Reports 9i/10g, Forms 9i/10g, Oracle 10g, Workflow Builder, SQL*Loader, Toad, UNIX, XML Publisher, OBIEE, Hyperion.

Confidential, Westborough, Massachusetts

Sr. Oracle Technical Consultant

Responsibilities:

• Worked on custom form to add additional fields on the canvas and map the fields to the columns of the custom table in data block using forms builder.
• Worked on outbound interface by writing custom PL/SQL Procedure to create a flat file using UTL FILE package which will contain the general ledger info like default accounting segments for different stores and FTP the flat file from outbound directory to Hyperion using shell script.
• Worked with off-shore team for 11i to R12 upgrade for retrofitting of the custom objects and testing of the different Inbound and outbound Interfaces in Oracle EBS environment.
• Customize the GLBATCH Oracle Workflow for the GL Journal approval process for sending the Notifications to the users according to the approval limits before the GL batch posting.
• Develop the custom Oracle form to add the users and set the approval limits for the users. This information will in turn used by the GLBATCH workflow for the GL batch approval process.
• Worked on Oracle Non-EBS Inbound Damage room goods billing Interface to move the current process from mainframe to Oracle Non-EBS by building the shell script which will pick the file from the FTP server and load the file into the staging table using SQL*LOADER also wrote a custom PL/SQL Package which will load the transactions from staging table into the base Damage room transaction table and calculate the cost of the items using db links to the cost tables from different Oracle Non-EBS environment.
• Build PL/SQL Procedure to create the invoices in Oracle EBS account payables by inserting the data into the staging table for billable items from the Damage room transaction table.
• Build custom concurrent request sets in Oracle EBS to create flat files using UTL FILE package for Reflexes system reporting for different store Information like store timings, attributes, cost of the returnable goods and then FTP files to the Reflexes server using shell script.
• Developed PL/SQL scripts to load data from external system to Fixed Assets FA MASS ADDITIONS interface tables and developed asset interface
• Build Shell scripts to SFTP the files for AMEX, Chase, WEX and Discover from banks SFTP server and FTP the files according to the file names to the appropriate PDI FTP server.
• Developed PL/SQL Package in Oracle Non-EBS environment to create the reports by writing them down to the outbound directory and then FTP the files to the vendors like Pepsi, coke and Swedish match weekly.
• Worked on PL/SQL Performance tuning to improve the performance of the different scheduled jobs in EBS environment.
• Involved in the Oracle EBS and Oracle Non-EBS Production support for day to day issues by working on the tickets raised by users.

Environment: Oracle Applications, 11i.5.10, R12.1.3 (AP, PO, GL, CM, FA, AR, Property Manager (PM)), Reports 9i/10g, Forms 9i/10g, Oracle 10g, Workflow Builder, SQL*Loader, Toad, UNIX, XML Publisher

Confidential, Bedford, Massachusetts

Oracle Financial Techno-Functional Consultant

Responsibilities:

• Worked on Implementation of Confidential Capture 10.0 and Confidential Transformation module 6.0 for MarkView 8.2 with Oracle 11i and R12 application to complete AP Automation solution.
• Conducted requirements gathering session’s onsite with the client to establish functional specifications for the MarkView implementations and document network environment.
• Implemented the MarkView solution at the client site, in conjunction with Oracle DBAs, UNIX administrators, and OAS application server administrators.
• Worked on Installation, Configuration of the MarkView Systems on WebLogic Server 12.1.3.
• Worked on Payables Open Interface Import by Populating the AP Interface tables using MarkView custom package to import the invoices in Payables coming from KTM Validation according to the business needs.
• Rigorously involved in database related activities that involves modelling PL/SQL queries, functions, stored procedures, cursors and scripts.
• Customized the AP invoice approval workflow to send notifications to the coders and approvers.
• Developed an API to pull the next approver information for a given invoice.
• Customized the use of CUSTOM.pll to work with MarkView Application.
• Modified AP invoice workbench form, FND Attachment and Quick Invoice form to add MarkView functionality.
• Designed & Developed AP Invoice Audit Report to pull the invoices created from MarkView using BI Publisher.
• Provided summarized information on demand to business by writing complex SQL statements.
• Customize the Working Folder to achieve the get next image functionality in Confidential so that AP user can Retrieve Work item in the Working Folder form in Oracle ERP systems.
• Worked on Electronic invoice routing for approvals and reviews, Business controls audited throughout entry and approval processing which will help in monitoring capabilities throughout the invoice processing cycle
• Used Auto categorization in KTM by customizing the Script variables so that document can be automatically categorize as Non-PO Invoice, Pre-Approved Invoice or PO Invoice.
• Update Look-up Dictionaries to include translation for Spanish and Portuguese languages in KTM Validation for Invoice data Extraction
• Working with multiple teams like Network team, SA team, Backup Team for getting the new server for MarkView 8.2 Implementation
• Provide effective and focused technical training on Confidential Capture and Transformation for MarkView for AP system usage, administration, applications implementation and usage and process improvements.
• Supported client testing efforts including integration testing and user acceptance testing.
• Led Go-Live activities as the final tested and accepted product was migrated to production for the user community.

Environment: Oracle Applications R12.1.3,11.5.10.2 (AP, PO, GL), Forms 9i/10g, Oracle 10g/11g, Toad, UNIX, Confidential Capture 10.2, Confidential Transformation Module 6, MarkView 8.2, WebLogic 10.x/12.x. SQL*Loader, Toad, Workflow, UNIX, XML Publisher

Confidential, Ramsey, New Jersey

Oracle Apps Technical Developer

Responsibilities:

• Worked on Implementing HSBC MasterCard Travel and Expense Credit card for employees in R12 Environment
• Developed Custom Program using Shell script to pull the CDF3 format files which have been placed by HSBC bank at FTP2 server to our Local server.
• Worked on the custom Program which will update the Content of the CDF3 files as per the business requirement and then pass it to the standard Program i.e. MasterCard CDF3 Transaction loader and validation program to populate ap credit card trxns all table so that transactions are available in I-Expense for the Employees to create Expense Report.
• Developing the custom Package to populate the custom log table which will be used for the business reporting purposes.
• Worked with AMEX to resolve issues related to credit card transactions.
• Modified Alert message of Invoice on Hold alert by removing the duplicate statement.
• Worked on Performance Tuning and Issues which were raised by business users in day to day business scenarios
• Worked with Oracle for critical issues related to payable invoices and migrated the fixes given by Oracle into production.
• Worked with Invoice Processing team on issues related to payment batches and on issues related to invoice corruption.
• Simulate, analyze the reported Problem and provide detailed analysis and solution for the change requests and production issues. This usually involves a code walkthrough of Interfaces, Reports and SQL Scripts.

Environment: Oracle Applications R12.1.3 (AP, PO, GL, INV), Reports 9i/10g, Forms 9i/10g, Oracle 10g, SQL*Loader, Toad, Workflow, UNIX, XML Publisher

Confidential, Cuyahoga Falls, Ohio

Oracle Apps Technical Developer

Responsibilities:

• Troubleshooting the technical and functional issues pertaining to customizations on OM, AR, PO, and AP modules as they arise.
• Retrofitted Various Custom Reports and Packages in R12 Environment, When Upgrading from 11i to R12
• Developed Electronic Fund Transfer (EFT) XML Publisher Template Format For the Firstmerit Bank for the Payments to the Vendors by Uploading the e-text Output File to the Bank site.
• Developed Custom Check Format for the Bank of America Leveraging 11i and replacing the 11i tags with R12 Tags of XML Publisher Template.
• Developed Custom Program using SQL * Loader to Load Data into Oracle Database and developed the Custom Code to Validate the data before inserting it into the Interface table to Update the Item Attributes according to the Business needs.
• Developed PL/SQL Procedures, Functions, Triggers and Packages to implement business logic, and making sure the functionality should be intact moving from 11i to R12.
• Retrofitted Custom Reports and XML Publisher Templates in Oracle Process Manufacturing (OPM) to R12 Discrete Inventory as per the business Requirement.
• Expertise in Creating and managing customers Using TCA (Trading Community Architecture) in AR module.
• Developed Auto Invoice Interface for AR by Integrating the Standard and Custom Programs in the Request set which will validate the data such as lot number, Order Quantity, PO etx. In the ra interface lines table before running the Auto Invoice master program to create the Invoice in the AR, and Printing the new Invoices Using the Custom Report.
• Developed the AP Automated Use Tax Invoice Interface to load the Payables Invoice Interface with Invoice Records for Tax Liabilities accrued on Supplier Invoices in a month into the ap invoice interface and running the Payables Open Interface Import to Create an Invoice in Payables only for liability tax amount for a month.
• Developed the Custom Program to Populate the Custom Table which contains all the Sales Information of the Organization in certain Period after doing all the validations according to the business accounting Group needs.
• Developed the Custom Program to send E- mail and alert the Finance and Order management Users whenever a Credit Hold is placed on the Order.
• Retrofitted the Custom Process of Costing from 11i to R12 by making the required Changes to the Package as per the business specification to bring in the Lab, Labor and Overhead Cost.
• Worked on the Various Custom End of Month Reports to Analyze the Cost and onhand quantity of the Item in an organization and also calculating and displaying the Lab, Labor and Overhead Cost.
• Development of stored procedure that extracts data from AR, AP and GL modules according to business requirement.
• Interacted with users to resolve technical issues during the production, development and enhancement phases.
• Responsible for developing new & customizing existing reports in Oracle XML/BI publisher. As Per the Business Requirement.
• Extensively used AOL and System Administrator modules for set up of various Concurrent programs, Request sets, Values sets and Descriptive flex field’s registered concurrent programs, request groups for reports and concurrent requests.

Environment: Oracle Applications R12.1.3, 11.5.10.2 (AP, PO, AR, OM, GL, INV), Reports 9i/10g, Forms 9i/10g, Oracle 10g, SQL*Loader, Toad, Workflow, UNIX, XML Publisher

Confidential, Atlanta, Georgia

Oracle Apps Technical Developer

Responsibilities:

• Developed PL/SQL package to convert Vendors with Banks and Bank Account information from legacy system to R12
• Involved in Conversion of AP Invoices, using SQL*Loader to load legacy open Invoices data in to the staging tables and PL/SQL Program to validate and load in to Payables Standard Tables.
• Designed process to convert Open PO’s from legacy systems and developed validation logic to make sure PO’s are imported with Approved status. Handled un-received and partially received PO conversion as per business requirement.
• Automated custom Data Cleansing packages to normalize, cleanse, validate, extract, de-duplicate and interface the legacy Supplier, Customer and Open AR Transactions data into the pre-staging tables of Oracle custom conversion programs.
• Developed Wells Fargo credit card transactions Inbound Interface for different card programs using Standard Programs to Validate & Load the data into ap credit card trxns all. These transactions are used by employees while creating an expense report. Payable invoice for Wells Fargo will also generated by the process.
• Developed conversion programs for validating and importing Open AR Transactions (Invoices) from legacy system to Oracle interface tables. Used Auto-invoice Master Program to load the interface table data into Oracle AR base tables
• Developed format for Check in R12 AP using the XML Publisher Template for JP Morgan Chase.
• Developed the JP Morgan Bank Positive Pay outbound interface by creating the custom RTF template as per the JPM Positive Pay file format specifications.
• Developed Electronic Fund Transfer (EFT) Formats for JP Morgan, TD bank and Bank of America outbound interface by creating the custom rtf from US NACHA standard template as per the bank specification and transmitting the e-Text output to the bank from Filezone to the bank FTP server using ODI Synchronization Process.
• Build UK RBS EFT Format by creating the XSL-XML file as per the bank specification to generate the output with custom XML tags. File will be transmitted to the bank using ODI for supplier payments.
• Created the XML Publisher templates using XML Publisher Responsibility and created new Payment formats using the new XML template and updated the Payment process Profile with the newly defined format and also defined a Payment document for disbursement bank from which the payments have to be made to the invoices in the Payables which maintains the check number
• Developed the inbound interface for the JPM and Bank of America acknowledgement files which will be generated after the successful receipt of the EFT e-text file on there server, decrypting the acknowledgment file with the GPG keys provided and sending the email to the users by using the Email API.
• Worked on the PO’s: Printed PO Format for US and International. Build the Custom Format by changing the xsl Files according to the sample Output specified in the business Requirement.
• Developed the Alert notification to suppliers for the missing PO number in the AP invoice which is on Hold.
• Build the custom report for the Initial Client order form and Add on Form using Quoting super user as per the business Requirement from the Client side

Environment: Oracle Applications R12.1.3, 11.5.10.2 (AP, Purchasing, AR, OM, GL, INV), Reports 9i/10g, Forms 9i/10g, Oracle 10g, SQL*Loader, Toad, Workflow, UNIX, XML Publisher

Confidential, Glendale, AZ

Oracle Apps Technical Developer

Responsibilities:

• Worked on SQL* Loader to load all the data given in flat files with various special characters and comma delimiters.
• Worked on the development of Interfaces, Data Conversions, Developing new Forms, Reports, Customizing Oracle Reports in Order to Cash, Procure to Pay Cycles touching various modules such as INV, OM, SHIPPING, AR, PO and AP.
• 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 PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import program and populated into the Base Tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
• Developed Order Import Interface for business applications to load header and line details by creating Staging Tables and performing validations by writing PL-SQL package into the Order Import (OE) headers and line interface tables and then to OE base tables.
• Imported Items from legacy system into Oracle Inventory using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories.
• Involved in development of inbound interface custom package to validate and import Order details data into Oracle Applications OM Order interface tables from external system.
• Created new concurrent request set and scheduled the Order Import interface program to run periodically.
• Developed SQL Loader scripts to populate staging tables.
• Involved in the conversion of Inventory (INV) Items and Item Category data from legacy to Oracle ERP.
• Worked on Open Item Interface to convert Purchased Item Information from Custom Purchasing System to Oracle INV module.
• Part of the Implementation team for Order to Cash life cycle.
• Implemented Auto Lock Box by importing data into staging table by writing control file according to bank transmission format.
• Customized various transactions in Accounts Receivables (Invoices, Receipts, and Credit Memos and Debit Memos etc).
• Developed Discoverer Reports to get the employees information Period wise, monthly and yearly.
• Developed workbooks using Discoverer to develop custom reports for business analysis.
• Developed UNIX Shell Scripts. Customized and developed Oracle Forms and Oracle Reports using Oracle Forms 9i/10g and Reports 9i/10g.
• Customized standard reports such as AR Customer Invoice Report, Pack Slip Report, Open Order Report, Purchase Order Report.
• Developed new reports using Report Builder 9i and also customized seeded reports in purchasing (PO) module.
• As per the company requirements, created and implemented XML/BI Publisher reports for different products like PO, AP and GL.
• Creation of new custom reports using Oracle XML/BI Publisher.
• Developed AR Credit memo and AR Customers forms.
• Built custom forms using Oracle Forms 9i/10g Builder to fulfill the business requirements of the client.
• Customized existing forms to define system Profile Options, Descriptive and Key Flex fields.
• Developed technical design and test documents complying with Oracle AIM standards.

Environment: Oracle Applications R12, 11.5.10.2 (GL, AR, AP, Purchasing, OM, INV, BOM), Reports 9i/10g, Forms 9i/10g, Oracle 10g, SQL*Loader, Toad, Workflow, UNIX, XML Publisher, Discoverer

Confidential, Columbus, Ohio

Oracle Apps Technical Consultant

Responsibilities:

• Migrated GL and AP custom interfaces and reports from 11i to R12.
• Developed Data Conversions and Interface Programs. Used SQL * Loader to Load Data into Oracle Database
• Imported Items from legacy system into Oracle Inventory (INV) base tables using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories
• Worked with P2P (Procure to pay) business flow including modules PO (purchase order), AP (accounts payable) and GL (general ledger)
• Developed custom reports in Oracle General Ledger that gives a listing of all accounts balances according to the financial calendar.
• Imported Legacy Journals data into GL using Journal import interface
• Wrote PL/SQL packages for different validations, for processing data in order to create Valid POs and Receipts and for populating the PO interface tables and called the Seeded import programs to populate the base tables.
• Designed and Developed and Outbound Interface to send the Order details for a given customer
• Created requisition to procure goods and service with supplier information, delivery instructions, multiple accounting distributions, and notes to buyers, approvers, and receivers.
• Create standard purchase order, BPA and blanket releases.
• Developed PL/SQL scripts to load order data from external system to OM
• Developed Order Management, Inventory, Receivables queries to compare summary information of the standard and custom reports.
• Have done mapping 11.5.10 reports to R12 XML/BI templates, writing Extent and Validation rules, plugging Validation and extends to Payment Process.
• Customized Standard AR Receipt Register Report using Reports6i/10g.
• Designed and developed data storage procedures, functions and underlying views used for discoverer reports and developed discoverer Reports as per the requirement.
• Involved in Performance tuning of various queries and stored procedures.
• Designed and Developed Stored procedures, Functions and Triggers in PL/SQL to implement complex business rules.
• Involved in Customization of Standard Trail balance Report using Reports builder as per the business Requirements.
• Customized Inactive Item Report and Cancelled Sales Order Report.
• Extensively worked on Report Triggers and Formula Columns.
• Design and development of several PL/SQL packages, procedures and functions that were used in Custom Reports and Forms development.
• Developed various reports using Discoverer according to business needs.
• Used CUSTOM.PLL extensively to modify the functionality provided by standard forms according to client requirements and created custom forms using zoom functionality.
• Register generated reports, forms, Flex fields. Defined Descriptive Flex fields, value sets and also registered PL/SQL stored procedures, SQL*Plus scripts etc.
• Designed the frame work which would evaluate the details collected for customer instances and then generate various reports.
• Worked on Tuning of queries of the Custom Reports to improve the performance utilizing diagnostic tools (Explain Plan, TK Prof).
• As per the company requirements, created and implemented XML/BI Publisher reports for different products like PO, AP and GL.
• Registered the Templates and Data Definitions using XML/BI Publisher Administrator responsibility.
• Developed various reports as of the user specifications using XML/BI Publisher.
• Proficient in generating Forms using Oracle Forms meeting variety of Business needs including custom Reports. Modifying Forms to accommodate new functionality like adding Buttons and Texts.
• Conversant with both offshore and onsite development models.
• Involved in post-production support.

Environment: Oracle Applications R12, 11.5.10.2 (PO, GL, AR, AP, CM, FA, OM, INV), Reports 6i/10g, Forms 6i/10g, Oracle 9i, SQL*Loader, Toad, UNIX, Oracle Workflow 2.6, Explain Plan, XML Publisher, Discoverer 10g.

Confidential

Oracle Applications Technical Developer

Responsibilities:

• Involved in the customization of reports as per the clients requirement.
• Creation of value-sets, registering the reports and running the reports using the System Administrator Module.
• Developed Technical documents for the modifications performed as per the requirement.
• Modified Inventory item Locator report, Sub inventory quantities report, Receiving Transactions Register report and many more.
• Defined Executables, Concurrent Programs, Request Groups, Users, and Responsibilities.
• Designed reports in Discoverer based on the business requirements in AP, AR, and GL modules.
• Performed Various System Administrator activities like defining a concurrent program, creating users, creating menus, creating responsibilities.
• Migrated the Oracle Forms 4.5 to Oracle 6i and made necessary changes to the PL/SQL Code and made necessary changes to the tables.
• Implementation and up gradation of Oracle financials Suit. (AP, GL, AR)
• Written a Segment extraction program to extract the Chart of Accounts segment values and related information. This program Written in PL/SQL and made it as concurrent program.
• Designed and developed two custom data entry forms to maintain data in custom tables. Modified existing reports.
• Migrated GL and AP custom interfaces and reports, during oracle financials upgrade project.
• Developed test cases and templates to test the custom report migration process.
• Customizing Accounting Flex Fields, Cross Validation Rules and Security Rules Setting of profile options at various levels.
• Evaluation of organization structure, reporting needs, business needs to plan the chart of accounts as well as defining them
• Frequently worked with defining accounting and descriptive flex fields, writing validations to custom forms.
• Developing Adhoc reports using Discoverer to analyze data and compare with General Ledger.
• Helping financial service people to understand and reconcile data between custom module and Oracle financials. Also designing and developing custom procedures and Reports (Pl/SQL, Reports 6.0).
• Writing scripts to automate reports to run in batch for given time period.
• Perform changes to meet 11i application coding standards.
• Preparation of Test Cases and Test Plans and System Testing.

Environment: Oracle Applications 11.5.9, AOL, INV, AP, AR, GL, PL/SQL, Oracle 9i, JDBC, SQL plus, Developer 2000, UNIX.