SUMMARY

• Around 9 years of IT experience in developing cost effective solutions as Technical Consultant using Oracle Applications and related technologies Including Implementations, Upgradation, Data Conversions, Interfaces, Workflows and Customizations.
• Successfully Completed four full life cycle implementations using oracle applications 11.5.10/11.5.8/11.5.4/11.0.3/10.7 SC.
• 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 MD050, MD070 and MD120.
• Expertise in developing object oriented applications based on Java and C++ along with web development using HTML, XML and JavaScript and UNIX shell scripts.
• Recent 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, GLFA, OM, PO, INV, WIP, BOM

Oracle Tools: Reports 2.5/6i/9i, Forms 4.5/6i/9i, Discoverer 3i/4i/9iDeveloper 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 ServerVersion Control PVCS, Subversion

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

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Oracle Apps Techno Functional Consultant

Responsibilities:

• Involved with Production support team and Development team for Oracle Projects and HRMS objects.
• Developed Outbound Integration for client to generate employee data file and send email notifications to users.
• Involved with custom Discoverer reports to display required timesheet data for employee.
• Worked on multiple lift and shift custom objects involving 11i to R12 re-implementation process.
• Involved with the setup of AOL objects for Integration process.
• 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.
• Worked with the Technical Specification MD070 and Migration documents MD120 for the client.
• Worked on gathering Requirements and collaborate with development team for Papervision application.
• Responsible for production support and administration for Papervision application.

Confidential, CT

Oracle Apps Consultant

Responsibilities:

• Resolved issues related to AP, AR, GL, iProcurement and iExpenses modules as a part of Production support team.
• Personalized, extended and fixed OAF pages and issues for iExpenses, Commitments, Procurement and HRMS modules such as adding new tabs, modifying Payslip and Tax forms.
• Queriedmultiple databases to develop reporting to streamline functions, assist in QA, and 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.
• Developed PL/SQL packages for creating vendor files for bank in AP using a XSL template to write data to file by mapping xml data.
• Worked with Oracle reports and forms for AP, GL in resolving production issues.
• Worked in enhancing the existing functionality of Invoice Approval Worklist page using Mod PL/SQL like adding new features and lockdown editing of lines for Invoices.
• Worked closely with functional team in resolving issues related to Procurement and Financial modules for various processes involving modification of packages, forms, OAF pages.
• Within iExpenses
• 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.
• Worked with Value Sets, Descriptive Flex fields, Concurrent Programs, Profile Options, standard request submissions (SRS) and parameters during development.
• Worked with Service Now for creating support tickets.
• Involved with a team in setting up Work Structures for defining HRMS User and Responsibility and Key Flex fields for HRMS, Payroll.
• 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.
• Fixed iExpense issues in AP using script to update expense report with various reasons such as difference in amount for distribution lines, additional distribution lines.

Environment: Oracle Applications R12- AP, AR,GL, Oracle 10g/11g, JDeveloper 10g,Oracle 9i, Forms 6i/10g,Reports 10g SQL*Loader, BI Publisher, PL/SQL developer, TOAD,PPM

Confidential, Marlborough, MA

Oracle Apps Techno functional 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, GL.
• 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 Confidential 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.

Environment: Oracle Applications R12- AP, AR,GL, Oracle 10g/11g, JDeveloper 10g,Oracle 9i, Forms 6i/10g,Reports 10g SQL*Loader, BI Publisher, PL/SQL developer, TOAD,MKS,PPM

Confidential

IT Consultant

Responsibilities:

• Responsible in handling the Offshore development team and co-ordinating 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,WIP.
• Developed PL/SQL scripts for Payment formats for different banks (JPM,BoFA,CITI) within respective entities.
• Involved with the scheduling tool Dollar U for daily/weekly/monthly loads for varoius Concurrent programs such as Journal Import,Auto Posting,Create Accounting,Invoice Validation,Employee Load, 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, 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, Cambridge, MA

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, Huap Unvalidated Invoices Report and HU Bottomline 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, 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.
• 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.
• 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, Web Advances Credit memo components within AP module.
• Maintained all the work done using PVCS. Also documented the work by creating various reference manuals for reference 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 Confidential .
• 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 f reports-developed and executed test cases.

Environment: Oracle Applications R12,11i - AP, AR,GL, PO, OM, Advanced Collections Service Contracts, Oracle 10g/11g, JDeveloper 10g,Oracle 9i, Forms 10g,Reports 10g SQL*Loader, BI Publisher, PL/SQL developer, TOAD

Confidential, Weston, MA

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 thirdparty 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.

Environment: Oracle Applications R12,11i - AP, AR,GL, PO, OM, Advanced Collections Service Contracts, Oracle 10g/11g, JDeveloper 10g,Oracle 9i, Forms 6i/10g,Reports 10g SQL*Loader, BI Publisher, PL/SQL developer, TOAD

Confidential, Arlington, VA

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.

Environment: Oracle Applications R12,11i - AP, AR,GL, PO, OM, Advanced Collections Service Contracts, JDeveloper 10g, Oracle 11g/10g, Forms 6i, SQL*Loader, BI Publisher, PL/SQL developer, TOAD

Confidential, Portland, ME

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,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.

Environment: Oracle Applications R12,11i - AP, AR, PO, OM, BOM, Inventory, Advanced Collections Service Contracts, Oracle 9i, Forms 6i, Reports 6i, SQL*Loader,Perl, BI Publisher, PL/SQL developer, TOAD.

Confidential, North Canton, OH

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

Environment: UNIX, Oracle Applications (11i) - AP, AR, Purchasing, GL, FA,OM, TCA, Advanced Collections, OAF, Oracle 9i, Forms 9i, Reports 9i, Discoverer 4.1/9.0.2,Perl, XML publisher, SQL*Loader, PL/SQL developer, Java, JDK, J2E, TOAD.

Confidential, Milwaukee, WI

Apps Technical Consultant

Responsibilities:

• Analyzed requirements of the client for various legacy applications that needed migration and integration with Oracle Applications.
• Created shell scripts to load data into staging tables of expenditures, tasks, events and projects of project accounting using SQL*Loader direct path.
• Designed and developed an interface custom package to create and Update vendor/vendor sites implementation according to BR which is not provided by standard API’s.
• Developed Return to Vendors (RTV) report using XML Publisher.
• Was actively involved in designing and developing new AP,AR,GL,PO reports using Reports 6i to suit business requirement.
• Used XML publisher to print, email and fax the reports.
• Created project structure to maintain versions on PVCS and used it to track defects for every build.
• Involved in customization of several standard reports Invoice on hold report, Vendor, Payments, and analysis reports in AP, and also Customer and invoice reports in AR.
• Involved in creating business areas, user views, custom folders and joins for reporting using Oracle Discoverer 4i in Administrative edition as per the user requirements.

Environment: Oracle Applications 11i - PA, AR, AP, CE, Oracle 9i, Forms 6i, Reports 6i, SQL*Loader, XML Publisher, BPEL, PL/SQL developer, TOAD.

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.

Environment: Oracle Applications 11i (11.5.6/11.5.8 ), GL, AR, AP, PO, CM, INV, OM, HRMS, Oracle 8i, Forms 6i, Reports 6i, Discoverer4i, PL/SQL, SQL*Loader, SQL*Plus, TOAD, UNIX, Shell scripts, HP-UX