SUMMARY:

• IT professional with 12 years of experience as an Oracle ERP Technical Apps Consultant.
• Strong background in Upgrades, Data Conversions, Interfaces, Workflows and Customizations.
• Successfully Completed four full life cycle implementations using oracle applications.
• Extensive experience in using SQL, PL/SQL, Developer 2000/6i/9i, SQL Loader, Discoverer3i/4i/9i, EDI 810/850, Workflow, Oracle R12,11i,9i/8i/8/7.x, Unix, Linux, and Shell Scripts and Oracle Applications (Financials, Manufacturing and Sales & Distribution modules).
• Worked in Oracle Financials (GL, AP, CE, AR, FA, PA), Advanced Collections, Manufacturing (INV, WIP, BOM), PO (Oracle Purchasing), OM (Order Management/Advanced Pricing), HRMS, Payroll, OTL (Oracle Time and labor), OAB (Oracle Advanced Benefits) and AOL (Application Object Library).
• Extensive experience identifying product gaps coordinated with development team by creating TAR/SR and obtained one - off fixes.
• Experience in set-up, configuration, and functionality checks.
• Experience in building Forms, generating Reports and registering them as concurrent programs in Oracle applications using AOL involving Forms 4.5/6i, Reports 2.5/6i.
• Extensively worked on AIM documents like Business Requirement Definition RD, Business Requirement Mapping BR, Build and Module Design MD, Documentation DO, Business System Testing TE .
• Expertise in developing object oriented applications based on Java and C++ along with web development using HTML, XML and JavaScript and UNIX shell scripts.
• Experience in writing user stories, test scenarios, test cases, etc.
• Experience in conducting meeting with stakeholders, business user, IT teams.
• Experience in Conversions, Interfaces and Report Customization in oracle modules GL, AP, AR, FA, PO, INV, BOM, PA, OM, HR, OTL, OAB, Payroll, Oracle Discoverer.

TECHNICAL SKILLS:

ERP Applications: Oracle Applications R12, 11i (11.5.10/11.0.3 ), PA, AR, AP, GL, FA, OM, PO, INV, WIP, BOM

Oracle Tools: Reports 2.5/6i/9i, Forms 4.5/6i/9i, Discoverer 3i/4i/9i, Developer 2000/6i/9i, Oracle 8i/9i, JDeveloper, Workflow Builder

Databases: Oracle 11i,9i/8i/8.0/7.3, MS SQL Server 6.5/7.0

Database Tools: SQL*PLUS, PL/SQL, SQL*LOADER, TOAD TE.020

Languages: SQL, PL/SQL, Visual Basic, JAVA, HTML, C, PERL, Shell Scripting, JSP, JDBC, XML, UNIX Shell script

Application Servers: Oracle10g Application Server, Websphere Application Server

Version Control: PVCS, Subversion

Operating Systems: UNIX, Solaris 7/8, Linux, Windows NT/2000, MS - Dos

EXPERIENCE:

Confidential, Woburn, MA

Oracle EBS Consultant

Responsibilities:

• Develop, enhance and fix various reports like Summary reports and Detail Reports for Lease Accounting to match the standards of FASB and IFRS using the BI Publisher and XML template for reporting.
• Fix defects for all Lease accounting issues within PL/SQL package, reports.
• Work with PL/SQL queries used for OBIEE reporting.
• Develop and create forms, reports, pl/sql functions and packages for all the Lease Accounting process involving the data integration with OBIEE and posting data to Oracle GL process.
• Co-ordinate with Offshore resources on critical requirements.
• Work with code fixes and data fixes for the Lease related components including PL/SQL packages, Reports, Forms.
• Work with development and enhancements of WEBADI components for Oracle modules.
• Work with business and team for requirements and drafting MD50, BR100 and MD70 technical documents.
• Work with set ups like Value Sets, Menus, Functions, lookups, concurrent programs, request sets loading data into tables and update GL rates, corporate rates.

Confidential

Oracle Apps Consultant

Responsibilities:

• Designed, developed and tested the Purchasing programs for Approved Supplier List process, Sourcing Rules and Item Price Update, Remittance advice program etc., using Oracle API’s.
• Developed a trigger on the Ship Confirm form to kick off the freight updates in backend and performed end-to-end testing involving business team.
• Worked on form personalization for Order management and Purchasing custom forms like Sales order form, Ship Confirm form.
• Worked on the SLA issues for Invoice to populate correct code combination in the Accounting Field using a PL/SQL package.
• Worked with business in analyzing and setting up the Oracle Application Object Library (AOL) features like Value Sets, Descriptive Flex fields, Concurrent Programs, Profile Options with respect to the requirement.
• Working on the Bug fixes and enhancements, personalization for Oracle Reports, Forms, OAF pages for modules such as AP, GL, OM, PO.

Confidential, Boston, MA

Oracle Apps Consultant

Responsibilities:

• Worked as a lead bridge between the offshore and onsite team on gathering Requirements, to collaborate with development team and test with the User team for Papervision application.
• Prepared a design document for End-tend flow of Concur to Papervision process and involved in the process end-to-end testing for AP Invoicing.
• Prepared the Technical Specification MD070 and Migration documents MD120 for the client.
• Involved with Production support team and Development team for AP, AR, Oracle Projects,
• PO and OTL and HRMS objects.
• Developed Outbound Integration for client to generate employee data file and send email notifications to users.
• Worked on multiple lift and shift custom objects involving 11i to R12 re-implementation process for AP, AR and HRMS components.
• Involved with the customization of custom OAF page for client payroll process using Jdeveloper.
• Involved with custom Discoverer reports to display required timesheet data for employee.
• Involved with the setup of AOL objects for Concur-Papervision Integration process including the reporting for AP Invoices and Expenses using BI Publisher.
• Involved in Data Analysis & Mapping to track all data elements used in the application from the user interface through different interfaces to the target databases in which they are stored.
• Responsible for production support and administration and configuration of Papervision application.

Confidential

Oracle Apps Consultant

Responsibilities:

• Responsible for Co-ordination activities, prepare requirement documents, Gap analysis.
• Responsible for writing user stories, testing, data validation, conduct user testing.
• Prepared user manuals, data flow and business flow documents for custom functionality.
• Prepared documents using AIM methodology.
• Assisted development team in data mapping and preparation of test scenarios.
• Conducted meeting with Business users, development team for clarifications and technical challenges.
• Resolved issues related to AP, AR, GL, iProc, PO, iExpenses as a part of Production support team.
• Worked on RICE (Report, Interface, Conversions and Extensions) Components related to Oracle applications.
• Personalized, extended and fixed OAF pages and issues for iExpenses, Commitments, Procurement, OTL and HRMS modules such as adding new tabs, modifying Payslip and Tax forms.
• Queried multiple databases to develop reporting to streamline functions, assist in QA, data validation with different teams, ad hoc reports.
• Involved with System design and development required for business process and worked with technical staff to create, interpret, and implement business requirements into technical specifications for AP Processes involving the Payments, Suppliers and Invoices.
• Worked with BI Publisher reports in modifying the RTF templates according to Client requirement such as integrating BIP reports with OAF page for Faculty, modifying template to add new fields.
• Extended View Objects of seeded OAF page to add extra columns on the OTL page.
• Involved in creating validations at the View Object level for Custom OAF pages in OTL.

Confidential

Oracle Apps Consultant

Responsibilities:

• Worked with IT Analysts in gathering requirements and in engineering Technical approach for Integrations related to AP, GL and in preparing Functional (MD50), Technical (MD70) design documents.
• Involved with development of PL/SQL packages for Integrations in AP, AR,GL,PO.
• Worked on Interfaces for importing Hyperion Planning to Oracle EBS GL.
• Worked with Value Sets, Descriptive Flex fields, Concurrent Programs, Profile Options, standard request submissions (SRS) and parameters during development for AP, AR, and GL.
• Worked with TJX specific MKS source control to track defects for every build.
• Involved in designing and developing new Project Costing Report in PA reports to suit business requirement.
• Designed Interface/Conversion mapping related documentation by gathering information from business and working along with the Functional team to meet Client requirement.
• Designed and developed staging tables, conversion routines, custom PL/SQL on AP, GL.
• Explored with the options of RTF and PDF template for the OAF compatible report as per requirement for I9 enhancement process.

Confidential

EBS Consultant

Responsibilities:

• Responsible in handling the offshore development team and coordinating with Analysts and - Technical team in proposing/developing new objects.
• Worked on the Cisco Custom Payments for Country enablement with different banks.
• Involved in preparing the Functional (MD50), Technical (MD70) design document and for the Cisco specific Payments-Unified Payments for different Countries.
• Developed PL/SQL packages for different components in AP, AR, GL, CE, OM, PO, and WIP.
• Developed PL/SQL scripts for Payment formats for different banks (JPM, BoFA, and CITI) within respective entities.
• Worked on RICE (Report, Interface, Conversions and Extensions) components for both custom and oracle applications.
• Involved with the scheduling tool Dollar U for daily/weekly/monthly loads for various Concurrent programs such as Journal Import, Auto Posting, Create Accounting, Invoice Validation, Employee Load, and Supplier Load.
• Worked with Value Sets, Descriptive Flex fields, Concurrent Programs, Profile Options, standard request submissions (SRS) and parameters during development.
• Created project structure to maintain versions on PVCS and used it to track defects for every build.
• Designed customizations, interface/conversion mapping, reproduction testing, and related documentation. Involved with defining AR Setups, Designing Invoices, and DFF for Invoices, Payment methods and Document Sequences.
• Involved in Code Development, Unit Testing, Business Testing and Reconciliation of reports-developed and executed test cases.
• Designed and developed staging tables, conversion routines, custom PL/SQL on AP, AR.
• Worked with AP, AR, PO reports like Returns report, Purchase Orders received not invoiced-Product; Purchase Orders received not invoiced-Non-Product, Check Register report, JRC Receipt Balancing report. Developed OA Framework Extensions for creating Expense reports.
• Used BI publisher to print, email and fax the reports and worked with e-text templates for the Payment format. Worked with RTF templates for custom reports.

Confidential

Technical Consultant

Responsibilities:

• Retrofitted and Customized the Invoice workbench in R12 upgrade project reflecting the functionality of 11i with major inclusion of lines and Invoice types in R12 form.
• Customized and personalized AP, AR forms like HUAP Expense Report Post Audit Report, HUAP Withholding Tax Invoices Exceptions Report, and Heap Invalidated Invoices Report and HU Bottom-line Check format for HU Payments process.
• Created shell scripts to load data into staging tables of expenditures, tasks, events and projects of project accounting using SQL*Loader direct path.
• Configured AP, AR, and GL to perform the accounting for third party applications in Oracle EBS R12 module.
• Analyzed requirements of the client for various legacy applications that needed migration and integration with Oracle Applications.
• Involved in configuring Order to Cash process including inquiry, quotation, sales order, shipping and billing information system.
• Used Oracle Application Object Library (AOL) features like Value Sets, Descriptive Flex fields, Concurrent Programs, Profile Options, standard request submissions (SRS) and parameters in the process of development of RICE components.
• Involved with System design and development required for business process and worked with technical staff to create, interpret, and implement business requirements into technical specifications for AP Processes involving the Payments, Suppliers and Invoices.
• Written PL/SQL script to handle the Supplier data for the Supplier Merge Window in Suppliers (AP), custom process of implementing Purchase Orders (PO) and Invoice Matches (AP), OM, AR.
• Worked with the Web Reimbursements, Web Vouchers, and Web Advances Credit memo components within AP module.
• Maintained all the work done using PVCS. Also documented the work by creating various manuals for by future testers and users.
• Developed a BI Publisher report to extract the list of Customers and Suppliers for AP AR Netting Report to output in PDF, RDF and EXCEL on RTF using Desktop Client for BI Publisher version 11g.
• Involved with the Functional team to design MD050 specifications and Technical specifications MD070 along with Installation guidelines and Unit testing processes for developed items following the standards of the Harvard University.
• Involved in customization of several reports to serve important business processes very specific to the client - Payment Distribution Report, Payment Batch Control Report, 1042s/1099 Vendors and Invoice Exceptions Report, AP 1099 Post Audit Report, NACHA Report for banks in AR using e-text template.
• Involved in Code Development, Unit Testing, Business Testing and Reconciliation of reports-developed and executed test cases.

Confidential

Technical Consultant

Responsibilities:

• Created staging tables and control files to upload data from the legacy system using the SQL*Loader utility program.
• Involved and worked with migration team for all admin tasks.
• Experience in System Administration activities like Managing Concurrent Programs and Responsibilities.
• Developed and customized Financial Modules (GL, AR, AP, PO, OM, BOM), Interacted with end users to gather requirements and Draft specifications for development Phase.
• Designed, developed and documented an Inbound interface for AP Invoices.
• Developed a PL/SQL procedure to submit orders via the new EDI 850 process in place between Wholesalers, a third-party VC and Biogen Idec’s Order Management system.
• Customized revaluation status report and responsibility report in General Ledger (GL).
• Designed and developed the Reconciliation process for GL module.
• Involved in Code Development, Unit Testing, Business Testing, Functional, Performance and Regression testing.
• Created Custom LOV region in iExpense Details Page to replace the existing MessageInputText (Textfield) on the page using JDeveloper (OA Framework).
• Involved in configuring the RBAC Security Administration in R12 for ASCP requests.
• Worked with Business Events and Subscriptions to trigger different functions for engineering items in Product Data Hub (PDH).
• Worked with the development team to research Metalink, log SR/TARs and resolve outstanding software issues related to latest patch set.
• Designed XML Templates, XML Publisher reports. These are Customized Dunning Letter report to use XML Publisher to mail the letters to customers in AR.
• Used Bursting technique to email the XML publisher output file.
• Designed and developed a report to compare the migration details of the order processing flow through a third party on an EDI platform.
• Designed and developed a BI Publisher 11g Report for End Users to review purchasing related ASCP Action messages fetching data from Oracle ASCP in combination with OPM and discrete Inventory master, AR Dunning Letters Generate report, AR Invoice Receipts.
• Designed and developed a custom report for printing Selected Delivery notes for Pick Release orders in Order Management system.

Confidential

Technical Consultant

Responsibilities:

• Written an API for Converting the Supplier Banks (AP) and Bank Branches from legacy system into Oracle database. Created staging tables and control files to upload data from the legacy system using the SQL*Loader utility program.
• Developed PL/SQL package for converting the legacy Suppliers and Projects and tasks based on Project creation API’s to R12 database.
• Developed PL/SQL procedures for the Supplier Interface in Accounts Payables.
• Designed the Application Extension Technical Design Specification (MD070), Conversion Mapping (CV040) and Migration Instructions (MD120) documents for RICE items.
• Developed a SQL report to extract the Applied and On-account receipts in AR.
• Responsible for designing, developing and documenting an Outbound Interface for AP Suppliers from windows based applications to extract data to Supplier Answer Key.
• Imported data from legacy system into staging tables using SQL*Loader, perform validations prior to transferring data into OM Open Interface tables.
• Developed SQL*Loader control file and PL/SQL package (with Validations) for GL conversion.
• Created SR/TAR in metalink, got fixes from oracle support and applied patches with coordination of Apps DBA for Bug fixing. Involved with creation of background element sets in Core HR, Payroll and Projects and transferred those element sets into OTL.
• Development of new (Finance and Oracle Time and Labor (OTL)) reports using Reports 10g.
• Developed outbound interfaces to export Project/Task Lists from Oracle PA to external systems.
• Experience in extending self-service applications using Oracle Applications Framework (OAF).
• Involved in production support for Integration, System, and User Acceptance Testing (UAT).
• Involved in the design document for the RAR120 SWAT Analysis used to verify all db/apps level set up for migration.

Confidential

Technical Consultant

Responsibilities:

• Designed customizations, interface/conversion mapping, pre-production testing, and related documentation.
• Developed and customized Financial Modules (GL, AR, AP, PO), Interacted with end users to gather requirements and Draft specifications for development Phase.
• Did Accounts Payable set up and covered Vendor Maintenance, Invoice Processing, Payments, Payment Reconciliation and Period Close Process.
• Developed PL/SQL Procedures for Customer interface using TCA in Accounts Receivables according to Client Requirements.
• Strong Oracle RICE development experience in all AP, AR, GL, PO and OM Modules.
• Wrote Functional Specification (MD050), Technical Specification (MD070), Conversion Mapping (CV040) documents for converting Vendors, Vendor Sites and Vendor Contacts.
• Configured AP, AR, and GL to perform the accounting for third party applications in Oracle EBS R12 module.
• Designed and developed Asset Conversion by running Mass Additions Concurrent Program to transfer the data from interface to base tables in Fixed Assets (FA).
• Imported the journal entries from legacy system to Oracle General Ledger using SQL*Loader, PL/SQL package and populated the data into the GL interface.
• Customized forms using CUSTOM.PLL file to meet the specific requirements.
• Utilized Forms Personalization utility to call a PLSQL procedure and updated the AR Descriptive flex fields with Depot Repair flex field data.
• Designed and developed complex Discoverer reports by communicating and interpreting end-user business requirements. Involved in the BIP server setup administration on the Unix box.
• Designed and developed complex BIP reports by working on RTF using Desktop Client for BI Publisher. Designed BI Publisher reports including RTF templates to meet the end user requirement.
• Developed custom reports Merchant Detail report, Tax Audit report, Opportunities report, Activity List report, Campaign Current Query report etc., by communicating and interpreting end-user business requirements. Registration of concurrent programs, defining value sets and parameters for customer reports specific to Applications.

Confidential

Technical Consultant

Responsibilities:

• Designed customizations, interface/conversion mapping, pre-production testing, and related documentation. Invoked standard API’s within custom packages for creating and updating Customer, Sites and Contacts. Designed, documented and developed Bank Reconciliation interface to Oracle Cash management Interface.
• Design the new model for intercompany transactions with AR and Advanced Collections.
• Used Work in Process (WIP) API to populate the data into various base tables.
• Involved in Workflow administration for processing Requisition and Purchase orders.
• Developed an interface program to load data from custom tables to interface tables and then created journals into Oracle General Ledger as per business requirements.
• Extensively used AOL and System Administrator modules for set up of various Concurrent programs, Request sets, Value sets and Descriptive flex fields.
• Developed JSP pages for the Time sheet entry using OAF (Oracle Applications Framework), where the entered information will be moved to OTL by running a request in the EBS.
• Creating staging tables required for loading the legacy data and loading the staging tables with the legacy data using SQL Loader. 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.
• Used Oracle Application Object Library (AOL) features like Value Sets, Descriptive Flex fields, Concurrent Programs, Profile Options, standard request submissions (SRS) and parameters in the process of development.
• Used BI Publisher to mail the Dunning letters to customers for Receivables Management.
• Customized Transaction register, Adjustment report, Receipts Register, Aging 7 buckets or 4 buckets Reports in Account Receivables (AR).
• Customized Account Payables (AP) Reconciliation Reports like Accounts Payable Trial Balance report, Posted Invoice Register, Posted Payment Register, Unaccounted Transactions report

Confidential

Technical Consultant

Responsibilities:

• Designed and developed conversion routines, custom PL/SQL APIs to convert Employees, Employee Addresses, Positions and Jobs.
• Involved in preparing the Functional (MD50), Technical (MD70) design document and Conversion Mapping Document (CV40) to extract data from legacy system into open interface tables.
• Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API to validate and import the Suppliers (AP), Supplier Sites (AP), Open Purchase Orders (PO), Open Payable Invoices (AP), Item Import (INV), Bill of Materials (BOM), Work Orders(WIP).
• Designed and developed an Outbound Interface between Interlace Systems (Supply-Chain Management tool) and Oracle Applications for Customers, Items, On hand Quantity etc.
• Involved in customization of several standard reports Purchase Order Detail Report in PO, Vendor, Payments, and analysis reports in AP, and also Customer, receipts, invoice, and adjustment reports in AR.