We provide IT Staff Augmentation Services!

Oracle Applications Technical Lead Consultant Resume

Cincinnati, OH

SUMMARY:

  • Around 12 years’ experience in the analysis, design, development, testing and support of Oracle based applications.
  • Over 10 years of experience as Technical and Techno Functional Analyst in the Implementation, Upgrade and Support of Oracle ERP Applications (12.1.3, 12.1.2, 12.1.1, 12.0.6, 11.5.10 and 11.5.9).
  • Strong Application Implementation and Support experience in Financial, SCM, HRMS and CRM modules.
  • Experience with OTC (Order - to-cash) and PTP (Procure-to-pay) business process scenarios with 7 full cycle implementations, 2 Release 12 upgrade and 3 support projects.
  • Expert in Oracle Applications User Interface Customizations using Forms 6i (oracle 11i), 10g Forms (EBS Release 12), Forms Personalization’s, 9i JDeveloper (Oracle EBS 11i), 10g JDeveloper (EBS Release 12) and Oracle Applications Framework Personalization’s.
  • Extensive experience in writing SHELL Scripts for tasks Automation, Inbound and Outbound Processes.
  • Highly involved in Oracle AME/Workflow Customizations, Vertex TDM Integrations, Auto Lockbox Process, e-Commerce Gateway Process, EBS Check Printing, Creating and Customizing Oracle, Discoverer and XML Publisher reports.
  • Worked extensively using TOAD, SQL*Plus, SQL Developer, Workflow Builder and Sql*Loader.
  • Wide exposure on developing Technical design specifications and Setups for Conversions, Interfaces, User Interface Customizations and various other business requirements.
  • Well versed in Oracle AIM Methodology in creating Application extensions technical and functional documents MD070’s, MD050’s, TE020’s and Conversion Design Documents CV060’s.
  • Hands-on involvement in business requirement gathering, GAP analysis, data mapping, solution design, configuration and setups.
  • Extensive Experience in creation of TARs/SRs for Client issues, report bugs in EBS modules and working with Oracle Support to resolve issues with Oracle applications standard functionality.
  • Excellent overall project life cycle experience, Conceptual and Logical Thinking, Teamwork, Goal oriented.

SKILL:

Oracle Applications R12, 11i: (E-Business Suite) General Ledger (GL), Accounts Receivables (AR), Advanced Collections (IEX), Accounts Payables (AP), Cash Management (CE), Sub ledger Accounting (SLA), Trading Community Architecture (TCA), Fixed Assets (FA), Order Management (OM), Inventory (INV), Bill Of Materials (BOM), Quoting (ASO, Telesales (AST), Purchasing (PO), iProcurement (ICX), Grants Accounting (GMS), Project Accounting (PA), iSupplier (POS), Sourcing (PON), iExpenses, Oracle Approvals Management (AME), Electronic Data Interchange (EDI), Human Resources (HR), Service (CS), Field Service (CSF), Oracle e-Commerce Gateway, Applications Object Library (AOL) and Multiple Organization Access Control (MOAC)

RDBMS: Oracle Database 11g, 10g, 9i, DB2.

Development Tools: Oracle Forms & Reports 10g/6i, JDeveloper 10g/9i, XML Publisher (BI Publisher) 5.6.3/5.6.2/10.1.3 , Workflow Builder 2.6/2.5, Discoverer 10g, Application Express 3.2, SQL * Plus, TOAD 9.1, SQL Developer 3.2 and SQL Loader

Programming Languages: SQL, PL/SQL, UNIX Shell, PERL and PYTHON Scripting, C, C# and JAVA

Scheduling Tools: $U

Version Control Tools: Star Team, Clearcase, SharePoint, TortoiseSVN and Visual Source Safe

Operating Systems: UNIX SUN OS 5.8, IBM AIX (64 Bit),, HPUX RISC (64 Bit), WINDOWS and MS-DOS

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, OH

Oracle Applications Technical Lead Consultant

Responsibilities:

  • Imported Standard Purchase Orders and Blanket Purchase Agreements using Oracle standard Interface programs.
  • Imported Contract Purchase Agreements and Blanket Releases into Oracle EBusiness using private API’s.
  • Performed Approved Supplier Lists conversion using Oracle API’s and imported Requisitions using Requisitions Import program.
  • Implemented Approvals Management Engine (AME) for Purchase Requisitions and Purchase Orders. Created required AME Attributes, Conditions, Approval Groups, Rules and Action Types.
  • Developed SQL queries to derive AME approval hierarchies for Purchase Orders and Purchase Requisitions.
  • Customized Purchase Requisition Approval Workflow as per Confidential requirements. Integrated OAF Notifications with Oracle Workflow.
  • Implemented FND File attachments functionality on iSupplier OA Framework pages.
  • Extended iProcurement OA Framework pages to default purchase order types into document builder region.
  • Extended Requisition notification pages to indicate requisition lines for approvers in an AME derived approval system.
  • Extended iProcurement OA Framework pages to show Blankets and Quotations based on User access profiles.
  • Performed OA framework personalization’s to set initial values, remove buttons, change prompt descriptions, mark attributes as required/read-only columns and display View Object Attributes.
  • Used iProcurement POR CUSTOM PKG package for defaulting of values and validating fields in requisition header/line/distribution lines.
  • Converted Account Payables Suppliers (Vendors), Supplier sites and Site Contacts using Supplier open Interfaces Import Programs.
  • Created new Parts Specification Forms using Forms 10g to capture and store Confidential information for processed products.
  • Customized BI Publisher Reports, PO output for Communication Report and Requisitions Report to include Confidential requirements.
  • Designed and developed EDI solutions to send Remittance Advice to suppliers through Oracle e-Commerce gateway.
  • Implemented Concurrent Requests multi-threading to import large volumes of data into Release 12.
  • Used 11g Database new feature, external table post processer scripts to show files in an operating system directory as ‘value set’ values.
  • Wrote Shell scripts to automate custom Application Object Library (AOL) components deployment process. Used FNDLOAD, WFLOAD, XDOLoader, Forms Compile, JPXImporter and XMLImporter as shell script components.

Environment: 12.1.3 Purchasing, iProcurement, iSupplier Portal, Sourcing, Oracle Approvals Management, Account Payables, TOAD 9.1, Workflow 2.6, 10g JDeveloper, BI Publisher 10.1.3, 10g Forms and Reports, EDI, Oracle e-Commerce Gateway .

Confidential, Morgantown, WV

R12 Techno Functional Consultant

Responsibilities:

  • Implemented Check Printing for Confidential developed Check templates needed for Huntington Bank. Configured Internal Banks, Payment and Printer setups needed for check printing.
  • Redeveloped oracle reports based AP electronic payment formats using XML Publisher e-text templates for R12 implementation.
  • Customized R12 Payment Process Request’s (PPRs) ‘Document Selection (Invoice Auto Select)’ phase programs to select Invoices based on custom table information.
  • Assisted WVU to use PPR’s for payments processing in R12. Created Payments module Payment Process Profiles, Payment templates, Payment Formats and XML publisher formats needed for Confidential .
  • Implemented R12 Payments Separate Remittance Advice process for WVU. Developed remittance advice templates, created xdo delivery configuration file, setup application messages and payment process profiles.
  • Implemented Payables Invoice Import process using interface programs for project related Invoices and Purchasing Invoices. Performed setups needs for Invoice Import.
  • Implemented Cash Management Bank Statements Import process for WVU using Oracle interface programs. Performed setups for Transaction Codes and Mapping Rules.
  • Modified PO output for Communication Report to include WVU changes and communicated PO’s automatically to Suppliers using the Purchase Order Window.
  • Modified R12 Printed Requisitions report and Original Invoice report to include custom WVU changes.
  • Performed UMX Role Based Access Control (RBAC) setups to provide user access based on roles.
  • Performed Multi Org Access Control (MOAC) changes on required procure to pay and grants accounting wrapper programs.
  • Assisted WVU in General Ledger, Sub ledger Accounting and Payables reconciliation process. Worked with Data Warehousing team to modify OLAP Processes for R12 upgrade.
  • Well versed in Sub ledger Accounting SLAM, AAD, Entity, Event Class, Event type, Journal Line Definition, ADR, JLT and JED’s.
  • Modified R12 Account Analysis report to provide account and accounting segment totals across multiple periods required by WVU.
  • Created new subscriptions on Concurrent Program Business Events to automate file transfer process with external systems.
  • Extended Supplier OA framework pages to implement WVU business requirements. Extended View Objects and Controller Classes.
  • Upgraded 6i Oracle forms and reports using 10g Developer Suite for R12 compatibility.

Environment: 12.1.3 Receivables, Payables, Payments, Purchasing, iexpenses, Sub Ledger Accounting, Fixed Assets, TOAD 9.1, Workflow 2.6, 10g JDeveloper, BI Publisher 10.1.3, 10g Forms and Reports.

Confidential, Pittsburgh, PA

Techno functional Analyst

Responsibilities:

  • Implemented Check Printing for Confidential using oracle XML Publisher. Developed CMU Check print template for BNY Mellon Bank, setup payment formats, payment process profiles and payment templates needed for check printing.
  • Redeveloped oracle reports based AP electronic payment formats using XML Publisher for R12 implementation.
  • Implemented R12 Positive Pay Process for Negotiable and Voided Checks. Developed customizations to process R12 voided checks and external system checks.
  • Implemented R12 Payments Separate Remittance Advice process for CMU. Developed remittance advice templates, created xdo delivery configuration file, setup application messages and payment process profiles.
  • Performed UMX Role Based Access Control (RBAC) setups to provide Concurrent Requests output file access to other users.
  • Performed MOAC changes on Cash Management Bank Statement Open Interface wrapper programs and Fixed Assets, Asset Import programs.
  • Imported Grants Accounting Budget data using GMS API’s.
  • Modified Project Supplier Invoice Account generation workflow to derive General Ledger accounts from PTA (Project Task ) strings.
  • Modified CMU Employee Supplier Update program to include Release 12 changes.
  • Performed OAF personalization’s and extended GL Launch Budget Wizard OAF pages to include frozen budgets and display custom data. Implemented forms personalization’s on GL Journal screens.
  • Modified Purchase requisition Workflow notification pages as per Carnegie Mellon requirements.
  • Performed OAF personalization’s and implemented Oracle Applications Framework extensions on Buyers Workbench Purchase Order pages using 10g JDeveloper.
  • Upgraded 6i Oracle forms and reports using 10g Developer Suite for R12 compatibility.
  • Assisted CMU in General Ledger, Sub ledger Accounting and Payables reconciliation process.
  • Created programs to protect organization sensitive information in non-production instances.
  • Created new subscriptions on Concurrent Program Business Events to automate file transfer process with external systems.
  • Wrote Shell scripts to automate Application Object Library (AOL) components deployment process.

Environment: 12.1.3 Receivables, Payables, Payments, General Ledger, Purchasing, Sub Ledger Accounting, Grants Accounting, iexpenses, Fixed Assets, TOAD 9.1, Workflow 2.6, BI Publisher 10.1.3, 10g JDeveloper, 10g Forms and Reports.

Confidential, Chicago, IL

Techno Functional Consultant

Responsibilities:

  • Implemented Order Management Internal Orders process for Nicor.
  • Used Order Management Order line API’s to update Order Line information.
  • Created Order Management holds using API’s.
  • Imported OM Sales Orders from legacy systems into Oracle.
  • Imported AR credit memos using Oracle standard API’s. Used Receipts API’s to reverse Receivables receipts.
  • Customized Account Receivables Aging report as per client requirements.
  • Created custom business event subscriptions for standard Oracle TCA business events.
  • Created custom programs to identify unbalanced journal entries and create reverse journals to balance General Ledger Accounts.
  • Implemented Purchasing Position based Approval Hierarchy.
  • Imported Inventory Items, and Item categories using Oracle standard Interface programs.
  • Imported Item Costs and Inventory On hand Quantities from Legacy Systems.
  • Customized standard Oracle Auto Accounting package to populate accounts as per Nicor requirements. Well versed in month end closing procedures.
  • Designed and developed Inbound and Outbound Interfaces for transfer of AR Payments, Adjustments and credit memos with trading partners.
  • Performed Oracle Forms and Oracle Applications Framework personalization in Receivables, Purchasing, Payables, Telesales and Field Service modules.
  • Created Oracle on Demand RFC’s for Testing and Production code migration.
  • Created Request Sets, Concurrent Programs, Value Sets and Profile Options. Resolved performance tuning issues.

Environment: 11.5.10 Receivables, TCA, General Ledger, Fixed Assets, Order Management, Inventory, Advanced Pricing, Purchasing, Field Service, TOAD 9.1, Workflow 2.6, 9i JDeveloper, Forms and Reports 6i.

Confidential, Memphis, TN

Oracle Applications Techno Functional Analyst

Responsibilities:

  • Converted AR Receipts using Oracle Seeded API’s to apply at Invoice and Invoice line level.
  • Automated Lockbox Process to load daily payments received from external systems. Defined Lockboxes, Lockbox Transmission Formats, Control Files, Data Files, Receipt Classes, Receipt Sources, Banks.
  • Customer Conversion from CHEERS to Oracle AR using Trading Community Architecture (TCA) public APIs
  • Created the Mapping Documents to map the legacy Customer record fields to Oracle TCA Registry fields for Customer Conversion.
  • Redesigned and developed the Customer Interfaces to support Party Merge, Customer Account Merge, Party Relationships and Customer Account Relationships.
  • Created Commitments (Security Deposits) using Oracle Standard API’s.
  • Imported Adjustments and Disputes using API’s.
  • Imported Receivable Invoices using Auto Invoice Open Interfaces. Performed Auto Invoice setups, created Grouping Rules, Line Ordering Rules, Transaction Batch Sources, Transaction Types, Tax Codes for Asia Pacific and Canadian Operating Units.
  • Implemented MOAC concepts in all Custom Interfaces and Conversions.
  • Created new Oracle Forms to show receipt application line level details and Confidential Custom data. Added new DFF Flexfields to Oracle Forms.
  • Customized Receivable Forms. Performed Forms Personalization’s. Created new PL/SQL libraries (pll’s) to be used in various new Oracle Forms.
  • Implemented GL Monthly rates program for Confidential .
  • Created Cash Refund Extract Report, Receivables Extract and Customer Balances Report using XML Publisher.
  • Setting up Scoring Components, Scoring Engines, Work Items and Collections Strategies in Advanced Collections.
  • Involved in High Level Design and Detailed Design documents, Test Case and Test Data Documents, Migration Scripts and Implementation Plans.
  • Generating Trace files and TKPROFs and analyzing them to tune the performance of the conversions and interfaces.

Environment: R12 12.1.2 Receivables, Trading Community Architecture, General Ledger, Sub Ledger Accounting (SLA) and Advanced Collections, TOAD 9.01, Oracle 10g, SQL, 10g Forms, AIM 3.0, SQL *Loader, XML Publisher 5.6.

Confidential, Newport Beach, CA

Oracle Applications Techno Functional Analyst

Responsibilities:

  • Converted Account Payables Suppliers (Vendors), Supplier sites and Site Contacts using Supplier open Interfaces Import Programs.
  • Performed Supplier (Vendor) Conversion Setups Payment methods, Tax Types, Payment Terms, and Pay Groups etc.
  • Imported Inventory Items and Item Categories using open interface programs.
  • Imported Item Costs and Inventory On hand Quantities from Legacy Systems.
  • Created Packing List Report, Warehouse Work Order and Pick Order Reports using XML Publisher.
  • Converted US and Canadian Employees, Employee Addresses and Employee Assignments using Oracle HRMS API’s. Performed setups for employee Jobs, Positions and Locations.
  • Created Purchasing Attachment Forms and Addition Rules similar to Order Management.
  • Imported Purchase Order requisitions and Purchase Orders from legacy systems.
  • Implemented Position based Approval Hierarchy mapping in Oracle Purchasing.
  • Customized PO Requisition Approval Workflow as per Confidential requirements.
  • Performed OA Framework personalization’s on iProcurement pages.
  • Imported Fixed Assets data from legacy system using Mass Additions Interface.
  • Created new forms in Fixed Assets to display custom data.
  • Created Heat Information Form and Physical Properties Form to capture Inventory lots information.
  • Created Parts Specification template Form to capture and store customer specific information for processed products.
  • Created Part Specification Data Form. Part Specification Data Form can be attached to sales orders, sales quotations, blanket sales agreements, purchase orders, planned purchase agreements, scheduled releases, blanket purchase agreements, blanket releases and production batches.
  • Defined and created error handling mechanisms for all conversion Processes.
  • Developed shell scripts for Automatic loading of Legacy files for Conversions and Interfaces.
  • Created Request Sets, Concurrent Programs, Value Sets, Profile Options

Environment: 12.1.1 Accounts Payables, Assets, Purchasing, iProcurement, Oracle HR, Order Management, Inventory and Bill of Materials, Workflow 2.6, XML Publisher 5.6., Oracle Forms and Reports 10g.

Confidential, Dallas, TX

Oracle Technical Analyst

Responsibilities:

  • Imported Payable Invoices using Payables Open Interface Import program.
  • Worked on Oracle Approvals Management (AME) and AP Invoice Approval Workflow to approve manual and imported Invoices.
  • Modified Fixed Assets Account Generator workflow as per Confidential requirements.
  • Imported Fixed Assets data from legacy system using Mass Additions Interface.
  • Imported PO Requisitions using PO Requisition Open Interface.
  • Imported Standard Purchase Orders and Blanket Purchase Agreements using Purchasing Open Interface.
  • Implemented Dun and Bradstreet Interface to query Customer Profiles.
  • Implemented Positive Pay out Bound Interface for Chase Bank.
  • Implemented Sales Order Out bound interface from Confidential to Confidential Inc.
  • Imported OM Sales Orders from legacy systems into Oracle 11i. Performed setups needed for the conversion process.
  • Created Order Management workflows for new Confidential specific order types.
  • Worked on Order Management Drop Shipment Process.
  • Created Oracle Pricing Qualifiers, Modifiers and Pricing Contexts.
  • Imported Price Lists into Oracle 11i using Advanced Pricing API’s.
  • Created Advancing pricing formulas, used Pricing API’s.
  • Modified COGS (Cost of Goods Sold) workflow to populate custom accounting information.
  • Customized Requisition on Cancelled Order Report using Reports 6i.
  • Wrote Shell Scripts for Automating Lockbox Process.

Environment: 11.5.10 Advanced Pricing, Order Management, Inventory, Fixed Assets, Payables, General Ledger, Workflow 2.6, Oracle Forms and Reports 6i, Vertex Q Series.

Confidential, Memphis, TN

Oracle Applications Developer

Responsibilities:

  • Imported Customers using TCA API’s. Converted Parties, Locations, party Sites, Party Site Uses, Contact Points, Org Contacts, Customer Accounts, Customer Account Sites, Customer Account Site Use Codes and Customer Profiles.
  • Worked with R12 Sub Ledger Accounting (SLA) Process.
  • Created Commitments (Security Deposits) using Oracle Standard API’s. Imported Adjustments and Disputes using API’s.
  • Imported GL journals from legacy systems using GL Interface. Implemented GL Daily Rates Import program for Confidential .
  • Created Collections notes and tasks using Collections API’s.
  • Created new OA Framework pages using JDeveloper to show receipt application line level details and Confidential Custom data.
  • Customized Receivables OA Framework pages to in corporate Confidential custom data.
  • Called OAF pages from Oracle Forms and integrated OAF Notifications with Oracle Workflow. Performed OA Framework Personalization’s.
  • Customized Standard Oracle Reports using XML Publisher and 10g Developer Suite to meet Confidential requirements.
  • Created Custom line level cash applications report, Aging by Account Report and Receivables Extract Report using XML Publisher.
  • Implemented Concurrent Requests multi threading to handle large volumes of data.
  • Defined and created error handling mechanisms for all conversion Processes.
  • Developed shell scripts for Automatic loading of Legacy files for Conversions and Interfaces.
  • Troubleshooting production issues in Oracle Financial modules.
  • Used System profile options, lookup values, FNDLOAD.

Environment: R12 12.0.6 Receivables, General Ledger, Sub Ledger Accounting (SLA) and Advanced Collections, TOAD 9.01, Oracle 10g, SQL, 10g JDeveloper, AIM 3.0, SQL *Loader, XML Publisher 5.6.

Confidential, Memphis, TN

Oracle EBS Technical Analyst

Responsibilities:

  • Used Shipping API’s to perform Shipping transactions. Implemented Order Management Drop Shipment Process.
  • Imported Inventory Items and Item Categories from legacy systems to Oracle Item Master.
  • Imported Bill of Materials Headers and Components, Routing Headers and Operations from legacy Systems.
  • Created Oracle Pricing Qualifiers, Modifiers and Pricing Contexts. Imported Price Lists into Oracle 11i using Advanced Pricing API’s.
  • Created Customer relationships using TCA API’s.
  • Created quotes and quote lines using Oracle Quoting API’s.
  • Customized Order Management Workflows. Created new Processes, Attributes, Functions, Notifications and Messages.
  • Modified Sales Order workflow to wait for approvals. Created workflow PLSQL CLOB documents to add Custom table’s information to Workflow notification messages.
  • Customized Oracle Telesales eBusiness Center Form and Quote Form. Made changes to the Header layout, Organization tab, Account tab, Relationship tab, Lead Tab, Opportunity tab, Task tab, Quote Header Tab and Quote Lines Tab.
  • Customized Quoting forms to capture additional information and synchronized with Telesales forms.
  • Converted Supplier, Supplier sites and Site Contacts using Supplier open Interfaces and Import Programs. Performed Supplier Conversion Setups Payment methods, Tax Types, Payment Terms, and Pay Groups etc.
  • Created new forms to capture ILS Custom information. Worked with AOL FORMS features Context Sensitive DFF’s, Value Sets (SPECIAL). Added new DFF Flexfields to Oracle Forms.
  • Customized Sales User OA Framework pages. Created new OA Framework pages to capture ILS Custom information. Implemented OA Framework Partial Page Rendering and SPEL.
  • Developed Custom Reports using Reports 6i.
  • Implemented the complex company tree view which represents the hierarchical Parent, Bill To, Supplier and Home Office relationships.
  • Extensively used FND tables for setting lookup Values, profile options, form and concurrent program registrations.

Environment: Oracle 11.5.10 Oracle Telesales, Oracle Quoting, Sales User, Order Management, Inventory, BOM, Advanced Pricing, Receivables, Payables, Purchasing, Oracle Forms and Reports 6i, TOAD 8.1, Workflow 2.6, JDeveloper 9i.

Confidential, Jersey City, NJ

Oracle 11i Technical Consultant

Responsibilities:

  • Implemented Order Management Drop Shipment Process.
  • Imported Sales Order into Order Management from Legacy System.
  • Customized Order Management Workflow to meet Client requirements.
  • Imported PO Blanket Purchase Agreements.
  • Imported PO Requisitions using PO Requisition Open Interface.
  • Imported Purchase Orders using Purchasing Documents Open Interface.
  • Converted Payables Invoices from Legacy System using Payables Open Interface.
  • Imported General Ledger Journals using Journal Import Program.
  • Developed shell scripts for Automatic loading of Legacy files for Conversions and Interfaces.
  • Involved in information gathering and setting test instances for Auto Lockbox Process, Data Warehouse interfaces and C2B Interfaces for Migration.
  • Interacted with JPM Chase Bank for setting test instance for Positive Pay Interface and Bank Reconciliation Interface.
  • Interacted with PaymenTech Solutions for setting test instance for IPayment Server.
  • Worked with TSI warehouse for setting up UPS interfaces for AICPA.
  • Interacted with Vertex Inc to test Vertex Sales Tax Q Series from MI Services, the new hosting partner.
  • Designed and developed OUT BOUND Interfaces.
  • Developed PL/SQL program for the outbound interface of rejected receipts.
  • Excellent knowledge of Flex fields, Multi-Org and Multi-Currency.
  • Developed a PL/SQL procedure to extract the invoice information from Oracle Receivables and to dump the invoice data into flat files.
  • Extensively used FND tables for information gathering.

Environment: Oracle 11.5.9 GL, AR, AP, OE, PO, TOAD, Workflow.

Confidential

Oracle ERP Technical Consultant

Responsibilities:

  • Interacted with end users and functional architects for mapping the legacy data to the Oracle tables.
  • Written Sql*loader Program to load Employees Credit card information into temp tables.
  • Written Program to transfer the data from temp tables into AP tables after validating the data in the temp table.
  • Converted Receivable receipts from bank files using Auto Lock Box Interface.
  • Imported Invoices and Credit Memos using Auto Invoice Import Program. Used Invoice, Line, Link-to and Transaction Flexfield.
  • Designed mapping documents for converting Receivable customers.
  • Converted the entire customer Addresses, sites, contacts, phones, relationships from one organization to another organization.
  • Imported Receivables Adjustments and Disputes.
  • Imported Invoice Remarks.
  • Imported General Ledger Journals.
  • Imported Purchase Orders using Purchasing Documents Open Interface
  • Customized Receivable Forms to in corporate custom requirements.
  • Created new forms to capture ABC Custom information.
  • Implemented Zoom features using custom.pll
  • Interacted with the users about the different service requests and involved them in performing the testing.
  • Involved in preparation of MD50s, MD70s, Test Cases and Migration Documents.
  • Following reports are developed using report builder
  • AP Check Format Report
  • AP Expense Distribution Detail Report
  • PO Report By Buyer
  • GL Account Analysis Report
  • Open Order Report

Environment: Oracle 11.5.9, OM, PO, AP,GL, AR Oracle 8i, Reports 6i, Forms 6i, PL/SQL, Stored Procedures, Data base triggers, SQL*Plus, Windows 2000, UNIX, AOL.

Hire Now