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 4 years of R12 experience with 3 full cycle R12 implementations with all major modules in Financials.
• Specialized in Oracle Financials with sound noledge of their integration. Detailed noledge on O2C and P2P transactional flows with experience in related setups.
• Proficient in Technical aspects of Financials (OM, INV, PO, AP, AR, GL), and HCM (GL, AP, IBY, AR, XLA, FA and OAB) modules and preliminary setups.
• Experience in System Administration activities and Strong noledge 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 OA Framework customizations in R12, 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.
• 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.
• Expertise in AME(Oracle Approvals Management)
• 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

ERP: Oracle Applications R12/11i:

Tools: JDeveloper, Forms 10g/6i, Reports 10g/6i, XML & EDI Gateway, HFM, FDM, OBIEE, TOAD, Oracle Discoverer4i/10g, SQL *Loader, PL/SQL Developer, SQL navigator, XML Publisher, GRC, Quality Center, Load Runner, SharePoint and PVCS.:

RDBMS: Oracle 11g/10g/9i, SQL Server:

Languages: PL/SQL, C, C++, HTML, XML, DHTML, Core JAVA and Shell Scripting.:

OS: UNIX, Sun Solaris, Windows NT/XP/Windows7 and Linux:

E-Mail: MS Office Outlook and IBM Lotus Notes:

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Oracle Order Management Production Support 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 dis 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.
• Developed XML report for sales order report in order management.
• 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.
• Expert in designing customer facing Reports using Optio, as part of dis also resolved many issues in optio like order acnoledgements, shipping documents, invoices.
• Supported any issues on PO’s dat we received from third party systems, These PO’s are sales orders in Oracle.
• Worked with Business team and developed R.me.B.S report (BOM module) as part of dis created a PL/SQL package to print the XML output and build the template using BI Publisher.
• Supported and enhanced the outbound interfaces for sending ASN’s (Advance shipping notification), Invoices using XML gateway.
• Worked on Workflow issues and enhancements.
• Designed customer conversion strategy, data mapping and development using APIs.
• 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 (GL, AP, AR,OM and AOL), Reports 6i, Forms 6i, XML Publisher, OA Framework, SQL*Plus, TOAD, Oracle BI Discoverer 9i, Hyperion, Mercury Quality Center, Test Director, ITG Kintana 6.0, PVCS (Version Control Software)

Confidential, Red banks, NJ

Oracle Financials Analyst

Responsibilities:

• Developed Interfaces for AP Invoices and AR Invoices from third party systems.
• Developed customer conversion strategy, data mapping and development using APIs.
• Wrote stored procedures and Functions as needed by Conversion programs.
• Built an Interface between HR and iExpenses to load all employee approval limits based on their role
• Developed interface between VISA card and iExpenses to load all employee expenses from a flat file and tested End to End process
• Load catalogs into iProcurement using bulk loader.
• Worked on punchout to access the store information from direct link.
• Involved in catalog management, shopping, checkout and requisition tracking in iProcurement.
• Configured Payments module for Check Processing, ACH and WIRE Payments.
• Designed and developed ACH/ WIRE outbound Payment Interfaces to Bank of America.
• Developed chase bank XML Check Template for In house check printing.
• Designed and Developed positive pay outbound Interface for Chase Bank.
• Worked with chase and Bank of America support teams for integration testing of payment outbound Interfaces.
• Used SQL* Loader and UTL FILE Packages for data conversion and interfaces in Oracle Financials.
• Developed automate payment and invoice creation using property manager.
• Defined approval rules dat determine the approval process for oracle applications. Rules are constructed from conditions and approvals.
• Designed and developed lease conversion in oracle property manager.
• Worked on conversion from one property to another one.
• Developed below XML Reports.
• 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, iProcurement, OM, INV, PO, XLA and AOL), Reports 10g, Forms 10g, XML Publisher, SQL*Plus, TOAD, SharePoint, LINUX and RDMS 11g.

Confidential, Houston, TX

Oracle Technical consultant

Responsibilities:

• Customized PO account generator workflowto generate charge account based on Project and task details.
• Designed and developedopen PO transactions conversion, it included standard as well as blanket Purchase ordertransactions.
• Setup new AME rulesfor approving inbound AP Invoices coming from third party systemsbased on Invoice source.
• Developed custom Receiving Interface to record all receipts coming from a warehouse management system.
• Created PO from iProcurement requisition without using user intervention.
• Developed rules from account generation for iProcurement requisition.
• Developed outbound GL balances Interface to send monthly GL balances data to Hyperion FDM system for financial reporting needs.
• Form personalization’s have been done for around 10 forms (standard custom forms) for all business user requirements.
• 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 Acnoledgement Report have been developed and also customized AR to GL Reconciliation Report.
• Involved in the design of more than 10 reports using Reports 6i, Discoverer 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 Custom Discoverer reports like Monthly customer sales report, Monthly region sales report.
• 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, CN, iExp, OM, PO, INV), Reports 10g, Report 6i tool, Forms 10g, XML Publisher, OA Framework, FSG, SQL*Plus, TOAD, Oracle BI Discoverer 10g, ITG Kintana 6.0, PVCS (Version Control Software), UNIX, and Test Director.

Confidential, Houston, TX

Oracle Technical Developer

Responsibilities:

• Designed and Developed maser data conversions (Suppliers, Customers 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 ( dat support various languages like Spanish, Portuguese etc )
• Developed of Positive pay outbound Interface for Wells Fargo.
• Developed XML template for Wells Fargo check format and tested using payment batch processing.
• Developed a conversion program to convert the Payables invoice data from legacy system to Oracle AP using Invoice Import Program
• Developed GL Outbound Interfaces which extracts data from Oracle General Ledger and send them to Hyperion reporting team for Confidential Reporting purposes.
• Developed Auto Invoice interface program to validate and import invoices from the legacy system into Oracle Receivables.
• Developed the following below XML Reports
• Order Acnoledgement
• Complex Customized (5 templates, 2 countries) Customer Invoice templates.
• Printed Purchase Order
• Custom performance measures(Project costing& Management Custom Report)
• Commercial Invoice
• Modified the XML template for a report to print by the bill to address instead of the site level
• 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, IBY, FA, GL, iProcurement, 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, San Jose, CA

Oracle Financials Consultant

Responsibilities:

• Developed Open Sales Order conversion with numerous business validations for all Confidential 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.
• 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.
• Designed and wrote technical documents for following interface objects.
• Standard Invoice interface to load all PO and Non-PO Invoice information from various suppliers and internal customers.
• Payments outbound interface to Bank of New York. Payment types include Checks, ACHs, USD wires, foreign wires, foreign drafts and EFTs.
• Defined DFFs which have been used by all AR and GL interface objects across the implementation.
• 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, CN, AR, XLA and AOL), Reports 6i, Forms 6i, XML Publisher, OA Framework, SQL*Plus, TOAD, Oracle BI Discoverer 9i, Hyperion, Mercury Quality Center, Test Director, 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 dat 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