Professional Outline:

• Over 8 years of Oracle Applications experience in Design, Setup, Development, Conversions, Customizations, Interfaces, Implementation of business applications using Oracle ERP, Client/Server, EDI and Internet Technologies.
• Over 4 years of R12 experience with 3 full cycle R12 implementations with all major modules Financials and supply chain .
• Specialized in Oracle Financials with sound knowledge of their integration. Detailed knowledge on O2C and P2P transactional flows with experience in related setups.
• Proficient in functional aspects of Financials OM, PO, AP, AR, GL .
• Experience in System Administration activities and Strong knowledge of AOL.
• Expert in custom Form Development and form Personalization.
• Design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces and APIs.
• Extensive experience in designing and developing new reports and customizing standard Reports, Forms and workflows using Oracle Reports 10g/6i, Discoverer 10g, XML Publisher, Forms 10g/6i.
• Expertise in XML Discoverer reporting strategy with hands on experience.
• Proficient in writing PL/SQL Packages, Stored Procedures, Functions, Database Triggers, SQL Loader scripts and shell scripting.
• Expert in developing oracle alerts.
• Expert in R12 upgrade projects.
• Experience in complex EDI Interfaces design, data set mapping, new trading partner's setup and Fallout resolutions.
• Expert in SQL performance tuning.
• Expert in outbound Payments interface integration with Banks using SFTP.
• Experience in supporting the production system and handling day-to-day issues.
• Analyze Troubleshoot Root cause, Fix the Transaction level issues for month end and quarter end support.
• Experience in writing MD70, CV40 and MD120 documents using AIM methodology.
• Strong interpersonal, analytical and communication skills, experienced user Trainer, proven ability as an efficient team member in System Analysis, Design, Development, Migrating and documentation. Result oriented, organized with good Presentation skills.

Technical Skills:

Summary of Projects:

Confidential

Oracle Technical Developer

• Developed inbound interface to import the suppliers from third party as part of upgrade from oracle 11i to R12.
• Developed package to create the Safelite Nacha report for BANK OF AMERICA and created shell script to FTP the NACHA report to BANK OF AMERICA.
• PO Fill Rate Report
• Developed Excel output template for Safelite AP and PO Accrual Reconciliation report
• Developed Text output template for AP and PO Accrual Reconciliation report
• Developed e-text outbound with pipe delimiter to send the AP check information to SunGard
• Safelite AP Check Template which is used for payables printed checks.
• Send Separate Remittance Advice email, which sends the Payment information to suppliers
• Developed below XML BI Publisher reports in R12
• Developed Shell script to FTP the positive pay files and then archive them to achieve folder.
• Upgraded Safelite AP NACHA report RDF reports from 11i to R12
• Worked on 11i to R12 changes in Safelite AP Payment Event and AP Web Expenses Workflow
• Developed PL/SQL packages for Safelite Account Hierarchy and Cost Center Hierarchy in GL Module.
• Developed Safelite AP Invoice Import interface to import the invoices into AP.
• Developed Safelite AR Tax Adjustment download report
• Developed interface to import the Purchase orders into oracle.
• Designed and developed the form personalization for Invoice Workbench form.
• Created the Descriptive Flex Fields for Vendors and Vendor sites.
• Upgraded Employee Load interface from 11i to R12
• Fixed the defects from user testing.
• Expert in SQL performance tuning
• Proficient in writing PL/SQL Packages, Stored Procedures, Functions, Database Triggers, SQL Loader scripts and shell scripting.
• Worked with users to get the requirements and provided solutions to them.
• Designed MD70, MD120 and Conversion mapping CV60 documents for all the development work and for migration to PROD instance.
• Used SVN to maintain the code repository and developed migration scripts to migrate all the development work into new instance.

Environment: Oracle Applications R12 AP, AR, PO, GL and AOL , Reports 6i/9i, Forms 6i/9i, XML Publisher, SQL Plus, SQL Developer, SVN Version Control Software , HP ALM Quality center

Confidential

Oracle Order Management and financial developer

Responsibilities:

• Worked with OM Team to develop an Inbound interface for order import from third party system, which is through XML gateway. As part of this created new custom XGM to accommodate the business needs.
• Resolved many order management issues like issues with order import, booking, pick release, ship confirm and invoice generating issues.
• Worked on Taxware upgrade to modify the custom tax audit report.
• Wrote stored procedures and Functions as needed by Conversion programs.
• Developed a custom form for order management.
• Worked with AP, AR and OM team and developed below BI/XML Publisher reports
• AR Invoice report
• Packing slip report
• Payment Terms Report
• Sales Order Web receipt report
• Worked with Business team and developed R.I.B.S report as part of this created a PL/SQL package to print the XML output and build the template using BI Publisher.
• Worked on customer related setups and any modifications to the existing customers.
• Loaded all the customer information into staging table using SQL loaded as part of Taxware Upgrade.
• Worked on Order defaulting rules to default the Order Header and Order Line level fields like Freight Terms, Warehouse.
• Designed and Developed EMD IBM triplet form.
• Involved in forms personalization as part EPRO IBM cloud project.
• Involved in customization of existing forms.
• Expert in designing customer facing Reports using Optio, as part of this also resolved many issues in optio like order acknowledgements, shipping documents, invoices.
• Supported any issues on PO's that we received from third party systems, These PO's are sales orders in Oracle.
• Designed customer conversion strategy, data mapping and development using APIs.
• As part of the tuning, Tuned PL/SQL packages and Custom Reports to improve the performance.
• Production Support for OM and GL Modules, as part of the team resolved the issues assigned to me with in specified time.
• Wrote MD70, MD120 and Conversion mapping CV60 documents for all the development work and for migration to PROD instance.

Environment: Oracle Applications 11.5.10 AP, AR, PO, OM, GL and AOL , Reports 6i, Forms 6i, XML Publisher, SQL Plus, TOAD, PVCS Version Control Software

Confidential

Oracle Financials Analyst

Responsibilities:

• Worked on conversion from one property to another one.
• Developed automate payment and invoice creation using property manager.
• Form personalization has been done for 3 forms.
• Designed and developed custom form to search for PO as per the user requirements.
• Tuned the SQL queries to improve the performance.
• Used SQL Loader and UTL FILE Packages for data conversion and interfaces in Oracle Financials.
• Developed chase bank XML Check Template for In house check printing.
• Configured Payments module for Check Processing, ACH and WIRE Payments.
• Worked extensively on converting RDF reports to BI/XML Publisher report
• Commercial report
• Invoice print selected invoices
• Customer Statements report
• Wrote stored procedures and Functions as needed by Conversion programs.
• Designed customer conversion strategy, data mapping and development using APIs.
• Developed Interfaces for AP Invoices and AR Invoices from third party systems.
• Developed below XML Reports/BI Publisher.
• Printed Purchase Order
• Packing Slip Report
• Order Acknowledgement
• Wrote MD70, MD120 and Conversion mapping CV60 documents for all the development work and for migration to PROD instance.
• Support and Enhancement works in developed reports and interfaces after Go Live.

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

Confidential

Oracle Technical consultant

Responsibilities:

• Designed and developed open PO transactions conversion, it included standard as well as blanket Purchase order transactions.
• Form personalization's have been done for around 5 forms standard custom forms for all business user requirements.
• Developed custom Receiving Interface to record all receipts coming from a warehouse management system.
• Setup new AME rules for approving inbound AP Invoices coming from third party systems based on Invoice source.
• Developed custom package for importing the invoices form Legacy system into the oracle applications tables using the Payable Invoice Interface.
• Using XML publisher, Sales order Acknowledgement Report have been developed and also customized AR to GL Reconciliation Report.
• Involved in the design of more than 10 reports using Reports 6i and XML Publisher in Order Management, General Ledger, Payables, and Receivables.
• 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 Cycle.
• Customized AR account status Report, and AP Trial Balance report using Report 6i tool.
• 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 Cycle P2P .

Environment: Oracle Applications Suite 12i AP, AR, GL, FA, OM, PO, INV and SAP PI , Reports 10g, Report 6i tool, Forms 10g, XML Publisher, SQL Plus, TOAD, Oracle BI HPSM service manager, ITG Kintana 6.0, PVCS Version Control Software and UNIX.

Confidential

Oracle Technical Developer

Responsibilities:

• Designed and Developed maser data conversions Suppliers for US, Canada, Brazil and Columbia in which many business validations have been taken care before populating data in to systems.
• Worked with GEOK IT team all banks 5 countries 6 banks to setup new check 6 XML check templates printing printers, printer drivers that support various languages like Spanish, Portuguese etc
• Developed of Positive pay outbound Interface for Wells Fargo.
• Developed XML template/BI Publisher for Wells Fargo check format and tested using payment batch processing.
• Modified the BI/XML template for a report to print by the bill to address instead of the site level
• Commercial Invoice
• Printed Purchase Order
• Complex Customized 5 templates, 2 countries Customer Invoice templates.
• Developed the following below BI/XML Reports
• Developed Auto Invoice interface program to validate and import invoices from the legacy system into Oracle Receivables.
• Involved in customization of existing forms.
• Designed and Developed order search form.
• Developed a conversion program to convert the Payables invoice data from legacy system to Oracle AP using Invoice Import Program
• Developed an Extension to bring scanned Invoice Images as Invoice attachments.
• Developed RICE development matrix to support cutover plan and project management planning and status Reports to executives.
• Used tools like MS Projects, SharePoint, PVCS, Test Director to monitor RICE development progress, manage documents, code changes and testing activities.

Environment: Oracle Applications Suite R12 AP, OM, AR, FA, GL, OM, INV, PO, XLA and AOL , MLS, Reports 10g, Forms 10g, EDI Gateway, XML Publisher, OA Framework, SQL Plus, TOAD, Oracle BI Discoverer 10g, PVCS Version Control Software , SharePoint and UNIX.

Confidential

Oracle Financials Consultant

Responsibilities:

• Designed and developed Open Sales Order conversion with numerous business validations for all Sun power entities with 15 Order types.
• Designed and developed Corporate Budget Conversion program which does all business validations before submitting standard Budget Import Program.
• Customized AR to GL Recompilation Report Template and on account Credit memo Gain and Loss Report Template using XML Publisher.
• Involved in customization of ERROR correction form in Order Management.
• Designed and developed a form to check outbound details for particular order.
• Developed Journal Entry interface by writing a custom package to validate the data from the flat file and populate the same into GL interface table.
• Defined DFFs which have been used by all AR and GL interface objects across the implementation.
• Payments outbound interface to Bank of New York. Payment types include Checks, ACHs, USD wires, foreign wires, foreign drafts and EFTs.
• Standard Invoice interface to load all PO and Non-PO Invoice information from various suppliers and internal customers.
• Designed and wrote technical documents for following interface objects.
• Tested Interface and conversion objects and trouble shouted many issues in testing phase and documented the whole process to report to management.
• Migrated numerous RICEW objects using ITG kintana Ver: 6.0.0 tool and PVCS version control software.

Environment: Oracle Applications 11.5.3 GL, AP, FA, AR, XLA and AOL , Reports 6i, Forms 6i, XML Publisher, SQL Plus, TOAD, Oracle BI Discoverer 9i, ITG Kintana 6.0, PVCS Version Control Software

Confidential

Software Engineer

Responsibilities:

• Created PL/SQL and SQL Loader scripts as a part of conversion process to extract the legacy data from existing applications and loaded them into Oracle Application tables.
• Interacted with end users and functional architects for mapping the legacy data to the Oracle tables.
• Mapping documents CV 60 and MD 70 are developed by looking CV 40 and MD 50 documents using AIM 3.0 methodology for GL Journals, AR Customers and OM Open Sales orders.
• Conversion of journal entries, receivables customers and receipt from the legacy system into 11i by creating staging tables and using interface programs.
• Developed code for Conversions to extract legacy journals and to load them to GL Interface tables using Journal import.
• Developed an AR Transaction Detail Invoice History Report that enlists all the invoice related items including the credit memos, receipts and adjustments applied to it
• Interface programs for AR Customers and OM Open Sales orders were written using API and used extensively to import the data into base tables.
• Worked on extracting information from Oracle Applications base tables to Intermediate tables for outbound interfaces.
• Designed and Developed the Back end process for Auto Lock Box Interface to read and write the multiple files coming from Bank.
• Customized several standard reports such as AR Customer Invoice Report, Pack Slip Report, Open Order Report, Purchase Order Report.
• Required Data Extraction from oracle applications base tables in a flat file format using UTL FILE package.
• Registered multiple Responsibilities, Custom Applications, Programs and Reports using System Administration.

Environment: Oracle 11.5.3 GL, AR, AP, OE and PO , TOAD 7.5.2.0, Reports 6i, AIM 3.0, SQL Loader, UNIX AIX -4.3