SUMMARY:

• Over 8 years of experience in the IT industry mainly implementing Oracle ERP systems primarily using, PL/SQL, Workflow Builder, Developer 2000/6i/9i, SQL* Loader, Discoverer, Java and Oracle Applications (Manufacturing, Financials and Sales and Distribution modules).
• Successfully completed 4 Full life cycles projects with Oracle Applications (R12.1.3, 12.0.6, 11. .5.9, 11.5.6 and 11.0.3).
• Good Functional and Technical Knowledge in implementing Order to Cash and Procure to Pay Modules
• Experience in Oracle Applications Technical Development. Having worked across the different modules of Oracle Applications including Order Management (OM), Advanced Pricing, Inventory Management (INV), General Ledger (GL), Account Receivables (AR), Account Payables (AP), Purchasing (PO), Fixed Assets (FA), Alerts, AOL and System Administration.
• Proficient in PL/SQL programming, writing Stored Procedures, Functions, Packages and Database Triggers. Create reports include formatting optionssuch as Charting, Mapping, Grouping, Sorting,Alerting, Field highlighting, Drill - down, Parameter prompts.
• Expertise in working with all the RICE components (Reports, Interfaces, Conversions and Extensions, SYSADMIN).
• Involved in Implementation, customization of several Oracle Financial Applications, Data mapping of Oracle functionality with Business requirements, historical conversions, interfaces and customizations.
• Identified product gaps, coordinated with Development Team by creating TARs and obtained one-off fixes. Managed and monitored TARs for several P1 Issues. Provided on site solutions and resolved showstopper issues.
• Extensive experience in source/existing/legacy system business functionality and preparing the functional and Technical Design Documents using Oracle AIM Methodology (MD050, MD070, TE20, BR100, and MD120).
• Extensively worked with Oracle 9i/8i, PL/SQL, SQL Trace and UNIX Shell scripts.
• Experience in creating SQL*Loader control programs and PL/SQL validation scripts.
• Worked on Customizing the Standard Workflows.
• Worked with different kinds of reporting like Oracle Reports, XML Publisher, Discoverer
• Extensively writing test scripts and making sure the entire test scripts are executed without any error and working with all the possible Unit testing and Regression Testing.
• Worked on AOL, registration and customization form through CUSTOM library, Standard packages and reports in Oracle Applications as per business needs.
• Have knowledge of different Source Controls like VSS, CVS, Kintana, PVCS.

SKILL:

ERPOracle Applications: Oracle Financials (GL, AP, AR), PO (Oracle Purchasing), OM (Order Management), INV, WIP, BOM (Bill of Materials) and AOL (Application Object Library).

Internet: JSP, JAVA, Servlets, JAVA Beans, EJB, JDBC, Java Script, HTML, XML.

APPLICATION SERVERS: Oracle 9iAS, JRun, Web Sphere, Tomcat, Web Logic.

Languages: SQL, PL/SQL, C, Visual Basic

Database: Oracle 7.x, 8.i, 9i, 10G, SQL Server, and MS Access 97

Operating Systems: UNIX, Solaris (7/8), DOS, Windows 98/NT/2000, MAC

GUI / TOoLS: Developer2000 (Forms 6i/9i, Reports6i/9i, and Graphics 2.5, Crystal Reports 6.0/8.0, Visual Cafe, Visual Source Safe.

PROFESSIONAL EXPERIENCE:

Confidential, Cherry Hill, NJ

Oracle Techno-Functional Consultant

Responsibilities:

• Interacted with Information Technology Directors, Managers, Full time employees, off shore team and key Business Users to gather requirements and capture present business process flows to communicate solutions.
• Involved with flow of existing system, preparing the Functional (MD50) Documents, Technical (MD70) design documents and Conversion Mapping Documents (CV40) to extract data from legacy Process into Future processes.
• Developed PL/SQL Scripts/Packages for Payables Invoice Import, AR Auto-Invoices Interface.
• Designed, developed and documented inbound interface between third party billing system and Oracle Receivables for AR Invoices.
• Developed Dunning Letters using XML Publisher and sent as an email to customer. Created Data Definitions and Data Templates.
• Developed custom Report and customized existing reports according to the functional specifications including daily Inventory Transaction Report, Packing slip.
• Created a Custom Program to Load Daily FX rates.
• Modified Sub Ledger Analysis Report For Specific GL Accounts
• Implemented the barcode fonts in Pick slip report using XML publisher in O2C process.
• Customized Purchase Order Approval workflow for changed PO lines.
• Worked on extracting the data from flat files using a shell script and Packages to load the data into staging tables.
• Worked with Auto Invoice executions in O2C process during production support
• Did daily support to Financial, Purchasing, Manufacturing and Planning departments interacting with end users.
• Did support for Month-End close, Period-End Close fixed lot of issues, got patches and applied patches interacting with apps DBA and resolved issues.

Environment: Oracle Applications R12 (12.1.3), GL, AR, AP, FA, BOM, PO, OM, INV, AOL, PL/SQL, SQL Navigator, Forms 10g and Reports 10g, SQL*Loader, SQL*Plus, UNIX, Shell scripts and Solaris 8.

Confidential, Fort Lauderdale, FL

Oracle Techno-Functional Consultant

Responsibilities:

• Wrote MD70, CV40 documents for Customer Import, Order Import, Suppliers, Suppliers Sites, Bank Branches and Bank Accounts.
• Designed and developed interface for EDI between Intuit applications to Procurement for Purchase orders.
• Designed and developed Custom PLSQL API to create Customers, Parties, Party Sites, Party Accounts and Party Contacts using TCA.
• Designed and developed Conversion routines (SQL Loader Scripts), Custom API’s for Conversion of Customers, Order Import, Suppliers, Suppliers Sites, Bank Branches and Bank Accounts.
• Customization of Order Header and Shipping workflow to kick of a notification to customer when order is booked and shipped in O2C.
• Developed a PL/SQL program, which reconciles the Reply Bank file data (Lockbox) and calls Receipt API to reverse the receipts for which credit card status is declined.
• Developed PL/SQL custom API to validate staging table invoice data and load the data into Auto Invoice Interface tables.
• Designed, documented and developed Billing to GL Inbound Interface and validated the data before creating the journal entries.
• Fixed accounting issues with Accrued Reconciliation Report and write offs with lot of analysis.
• Designed and Developed Asset Retirements report and sorted data by Cost center.
• Customized Printed Purchase Order Report, Invoice Printing Report, Aging - 4 Buckets Report, Trail Balance Aging Report.
• Created EUL using Discoverer Administration and gave privileges and security roles to all users.
• Created Business Areas, Workbooks, Folders, Items built on SQL, PL/SQL Functions and joins.
• Did the configuration for Bill of Material Components(BOM), BOM routings

Environment: Oracle Applications R12.1.3 GL, AR, AP, FA, PO, BOM, OM, INV, HRMS, AOL, PL/SQL, TOAD, Forms 9i and Reports 9i, SQL*Loader, SQL*Plus, UNIX, Shell scripts and Solaris 8.

Confidential, Chicago, IL

Oracle Techno-Functional Consultant

Responsibilities:

• Customized Order Line Work Flow (OEOL) as part of the business requirement.
• Created PL/SQL Packages for Workflow functions to control the flow of the Order Line. Created workflow notifications, lookups.
• Worked with the following Standard API’s qp qualifier rules pub.process qualifier rules - to update the secondary price list csi item instance pub.update item instance - to update the Instances in Install Base cs servicerequest pub.create servicerequest - to create new service request in tele-services module
• Worked with Service Request ZOOM Form and Expedite and Negotiate Orders Form (Fixing the Issues and Enhancements).
• Customization of Oracle forms & Reports of Supply Chain Module.
• Worked with Form Personalization to enable or disable the standard behaviours based on specific customer requirements - In Suppliers Form, AP Invoice Form and Payments Form.
• Implementation for capturing real time freight cost by integrating with 3rd party freight database like UPS and Con-way in O2C process.
• Worked in developing New Reports and Customizing Standard Reports
• Pick List Report ( customized)
• SR Turn Around Report (XML Publisher)
• SR Activity Report (XML Publisher)
• Expedite and Negotiate Orders Report
• PEC Validation Report
• Customized - Item Where Used Report, Department Report(BOM)
• Got expertise working with Prepayments, Recurring Invoices, and Expense Reports in Oracle Payables
• Created business areas, designed views and workbooks and transferred them to discoverer custom folder.
• Developed and debugged pl/sql package using TCA API’s
• Updated the Existing Price Lists and Created Secondary Price Lists.
• Created Installation documents, Technical design Documents.
• Written Test Cases for the objects modified.

Environment: Oracle E-Business Suite 11.5.9 (OM, AR, CS, IB, Sales-Online, Customers-Online, PO, AP, BOM) residing on HP-Unix, SQL*Loader, UTL File, PL/SQL, Toad, Reports6i, Forms6i, Workflow2.6, Discoverer4i.

Confidential, CA

Oracle Techno-Functional Consultant

Responsibilities:

• Wrote Technical specifications, Conversion-mapping documents for Item Import and Payables open Interface Import.
• Designed and Developed Conversion routines, custom PL SQL API’s for Item Import and Payables Open Interface Import (Invoice Import)
• Designed and developed custom PL SQL program to assign categories, cross references, sourcing rules and locations to items.
• Designed, documented and developed Bank Reconciliation interface between Wells Fargo Bank to Oracle Cash management Interface.
• Customized NACHA file format for Wells Fargo and BANK One.
• Designed and Developed Sales Orders Items shortages report, Daily Inventory Transaction Report.
• Customized Packing slips report, MRP Detail Planning Report.
• Did Security Profile Setups, created new Responsibility, New Menus, New Functions, New Users and Supported User community interacting daily.
• Designed and developed workflow email alerts for Item and BOM updating.
• Customized PO Work flow to included requested information into the Purchase Order.
• Customized Reports like Employee Benefit Eligibility Listing, Employee Benefit Enrollment Register

Environment: ORACLE Applications 11i (11.5.9), Oracle 8i, Forms 6i, Reports 6i, SQL*Plus, Toad, SQL Navigator, PL/SQL, Sun-Solaris 7.

Confidential, CA

Oracle Techno-functional Consultant

Responsibilities:

• Design, Documented and developed Conversion routines, Custom PL/SQL API’s for Purchase Orders (Headers, Lines, Distributions) from legacy mainframe applications.
• Design, Documented and developed Conversion routines, Custom PL/SQL API’s for Item Conversion and successfully loaded the items.
• Design and Developed Detail Payment reports with reference to Salesperson, Branch Level Transaction report and Customer’s outstanding report.
• Customized the Backorders Detail Report, Backorder Summary Reports in O2C Process.
• Fixed bugs and resolved issues related to Key Flexi field Security rules, Cross validation rules, Item property rules, etc.,
• Designing of Conversion/Interface project’s Implementation Strategy for Accounts Payable and Accounts Receivable and General Ledger
• Designing and developing Proto Type Data Migration Process to test load legacy sample data.
• Design and development of migration scripts for all activates of GL and sub ledger migration.
• Researching and analyzing the AP and AR legacy volume transactions and possible impact on one time Conversion Process under existing data transport mechanism.
• Developing Generic Packages using PL/SQL to build flat files to manage transmissions across Legacy and Oracle Systems.
• Developing Flexible PL/SQL Scripts/Packages for Data Objects Creation such as Tables to store legacy data and to maintain data for staging interim phase.
• Developing SQL Loader control scripts to process the legacy data and to load them into Temp Staging Area.
• Developed PL/SQL Scripts/Packages for Payables Invoice Import, AR Auto-Invoices Interface
• Wrote MD70, CV40 documents forProject Transactions.
• Designed and developed conversion routines, Custom API’s forProject Transaction Import

Environment: Oracle Applications 11.5.6, GL, AR, AP, AOL, Forms 6i and Reports 6i, PL/SQL, SQL*Loader, SQL*Plus, TOAD, UNIX, Shell scripts.

Confidential

Oracle Technical Consultant

Responsibilities:

• Responsible for importing data from numerous sources for companies acquired by client, into Oracle AR.
• Defined the new customers, address information including the EDI location codes and imported the legacy customer info into customer tables using the standard customer interface program.
• Developed multiple interface programs to convert legacy data from external sources. This included converting customers and their related transactions (invoices, payments, etc.)
• Wrote custom Oracle Financial reports to meet client specifications.
• Developed custom forms for use in custom billing system.
• Partially involved in the design of custom billing system that was interfaced into Oracle AR.
• Used AOL & Sys Admin to register new reports, forms, functions, menus and created validation sets, request sets and concurrent programs.
• Work closely with functional and development team to implement Oracle Financial Modules (AP, GL, AR), create Applications Users, Responsibilities, Report Sets, Menu and Functions.

Environment: Oracle Applications 11.0.3(General ledger, Fixed Assets, Account Payables, Accounts Receivables, Purchasing, System Administration and Alerts, Oracle 8.0.5, HP UNIX), Forms 6i/ Reports 6i/Oracle 8i, SQL * Loader, SQL Navigator