SUMMARY

• 18 Years of Oracle Applications experience in Implementation, Customization, Developing Interfaces and Conversions in GUI version of Oracle Applications. Involved in analysis of existing business systems and Implementing Oracle Applications.
• Includes all the aspects of software projects such as client interaction, business process analysis and re - engineering, gap analysis, system analysis & design, data modeling, preparing specifications, developing software, data migration, porting, documentation and user training.
• High degree of interest in utilizing and furthering experience in Oracle Applications and related tools.
• Extensive experience in deployment/customization of Fixed Assets, General Ledger, Accounts Receivables, Accounts Payables, Cash Management, Oracle Order Management, Advance Pricing, Shipping and Execution, Purchasing, Inventory and CRM (Contracts Core, Field Service, Service Contracts, Install base).
• Major work till now included performing GAP analysis, transferring data from legacy system to Oracle Applications or interfacing clients’ existing system with Oracle Application
• Experience in Oracle Workflow Builder (2.5/2.6). Experience in defining custom workflow and customizing standard Oracle Workflows.
• Proven success in problem analysis and problem solving with emphasis on problem identification and project planning.
• Demonstrated success in working with users in defining and documenting business requirements. Understanding of multiple functional areas and business processes.
• In-depth understanding of Manufacturing, Distribution and CRM business processes.
• Implementation experience, technical and functional expertise in Order Management, Advance pricing and Shipping, E-Commerce Gateway, Accounts Receivables (AR), Purchasing and Supplier Scheduling, Inventor, Bill of Materials (BOM) and CRM modules (Contracts Core, Service, Service Contracts, Installed Base)
• Proven ability to identify impact of project on technical environment and other applications.
• Experience working with development methodologies, proven ability to apply project methodologies and the ability to TEMPeffectively use project management tools.

TECHNICAL SKILLS

ERP: Oracle Application R12, 11i, 11.03, 10.7 SC16.1

Modules: General Ledger, Fixed Assets, Accounts Receivables, Accounts Payables, Cash Management, Purchasing, Oracle Order Management, Oracle Project Accounting, Oracle Project Contract, Oracle Workflow Builder (2.5/2.6), CRM (Contracts Core, Field Service, Service Contracts, Installed Base), Oracle Purchasing, Oracle Inventory, Oracle Alerts, FADI, System Administration and noledge of Bill of Materials (BOM) and Work in Process (WIP), Advance Planning and Scheduling Modules (APS)

HARDWARE: IBM-PC compatibles, SUN E-10000 with RISC Technology, HP-9000

OPERATING SYSTEMS: UNIX SVR4, SUN SOLARIS-5.5.1 and Windows

RDBMS & Tools: Oracle 10g, Developer /2000, Forms 9i, 6i, OA Framework, Reports 9i, 6i, Forms 4.5, Reports 2.5, Workflow Builder 2.6 / 2.5, SQL* FORMS 2.3, Discoverer 9.x, 4.x, BI Publisher,OBIEE, Cognos 6.0, Excel 2.0, Crystal Reports, Toad and SQL Navigator

Other LANGUAGES: PL/SQL, SQL*PLUS, COBOL

CASE TOOLS: Designer 2000

PROFESSIONAL EXPERIENCE

Confidential, MO

Tools Used: Oracle Applications R12, Oracle 10g, Forms 6i, Reports 6i, Workflow 2.6.2, BI Publisher

Sr. Oracle Application Techno Functional Consultant

Responsibilities:

• Customized Subledger Accounting (SLA) with Multi-Fund Accounting (MFA) for Accounting Receivable, Fixed Assets and Project Accounting.
• Designed and Developed AR Invoice Interface from third party billing system.
• Designed and Developed Custom functions to derive the Revenue, Tax Account for Invoice, CM, DM, Adjustment based on LE, Transaction type, Source etc in SLA.
• Setup the US Tax Regime with default rate in Oracle EB Tax with Vertex as Tax provider.
• Customized EB Tax - Vertex Tax Link program for O2C and P2P to pass the Tax driver values, Tax except etc.
• Setup and Loaded Tax driver values, tax rates in Vertex O series.
• Developed various views and queries in AR, AP, GL, PA, PO and FA during UAT and go-live for validation.

Confidential, OH

Tools Used: Oracle Applications R12, Oracle 10g, Forms 6i, Reports 6i, Workflow 2.6.2, BI Publisher

Sr. Oracle Application Techno Functional Consultant

Responsibilities:

• Designed and Developed Interface between third party Micro system to Oracle ERP, which includes Sales Order, Shipping, Receiving, Inventory Adjustment, Cycle Count etc.
• Designed and development Oracle reports, XML Publisher and BI Publisher reports.
• Developed multiple outbound interface with Micro System,
• Designed and Developed Advance Pricing interface using WebService SOA Gateway. .
• Developed multiple reconciliation programs and reports.

Confidential, NY

Tools Used: Oracle Applications R12, Oracle 10g, Forms 6i, Reports 6i, Workflow 2.6.2, BI Publisher

Sr. Oracle Application Techno Functional Consultant

Responsibilities:

• Designed and Developed Projects, Tasks, CWIP, Project Billing, Contract Conversion programs, and Project & Task update programs.
• Designed and Developed Fixed Assets Conversion from legacy to Oracle Fixed Assets for CORP and TAX books.
• Designed and Developed Project and Payable accrual programs.
• Customized Project and Contract approval workflows, and developed approval history reports.
• Developed the PA Draft Invoice and Revenue conversion programs.
• Designed and Developed interface between Oracle Apps and Fastpic Shipping and Receiving system for PO Receipt, Ship Confirmation, and Inventory Adjustments etc.
• Developed interface between Oracle and WAWF system, developed multiple forms to support this interface.
• Customized Project Transaction Extension as per the business need.
• Customized Project approval, FA account generator workflow process.
• Designed and Developed views and data extract programs for Hyperion reporting tool.
• Developed multiple reports in Oracle Reports and Discoverer.

Confidential, PA

Tools Used: Oracle Applications R12, Oracle 10g, Forms 9i, Reports 9i, Workflow 2.6.2, BI Publisher

Sr. Oracle Application Techno Functional Consultant

Responsibilities:

• Setup the new Tax Regime with default rate in Oracle EB Tax,
• Customized P2P and O2C client extension as per client requirements,
• Designed and Developer BI publisher reports to support Vertex Tax Link.
• Developed Vertex Tax link program for Oracle EBS Inventory Adjustment and Asset Movement.

Confidential, TN

Tools Used: Oracle Applications R12, 11i, Oracle 10g, Forms 6i, Reports 6i, Workflow 2.6.2, BI Publisher

Oracle Application Technical Team Lead

Responsibilities:

• Designed and Developed AR Open Invoice, Fixed Assets, AP Invoice, Open PO Conversion programs.
• Designed and Developed Projects, Tasks, CWIP, Project Billing Conversion programs, and Project & Task update programs.
• Developed multiple PL/SQL programs for Data clean-up, mapping and data loading.
• Prepared technical documents, interface feed mapping, designed and developed automated interface programs between Oracle EBS and Maximo for PO outbound, PO Receipts inbound, AP invoice inbound and Inventory Adjustments.
• Designed and Developed AR Automated Receipt Interface and AR prepayment Interest calculation program.
• Customized Project Transaction Control, Billing, PA Draft Invoice and Project status change extensions.
• Designed and Developer various Project Billing and Costing Reports.
• Designed and Developed Federal Fixed Asset Retirement Tool, Section 13 Reporting Tool with multiple custom forms and reports.
• Prepared technical document, Designed and Customized Project Approval Workflow with more than 30 approval status, and developed report using the custom approval status history table.
• Customized Project Contract Approval Workflow with multiple approvers, and captured approval statuses, and developed report using the custom approval status history table.
• Customized FA Account Generator, AP remittance Advice workflow process, Journal Entry Approval Workflow
• Designed and development Oracle reports, XML Publisher and BI Publisher reports.
• Designed and Developed Custom workflow and captured approval status for Project Expenditure batch approval.
• Prepared technical document and develop conversion extract and interface programs between Oracle e-business and PowerPlant Asset Management tool.
• Customized expense line validation extension, custom calculation and expense approval workflow for iExpense implementation.
• Worked on Upgrade Project from 11i to R12 on various tasks.
• Designed and Developed customer screen and reports using Oracle APEX.
• Designed and Developer Discoverer reports.
• Worked various production support issues.
• Personalized Forms and OAF pages using personalization.

Confidential, Konxville,TN

Tools Used: Oracle Applications 11i, Oracle 10g, Forms 6i, Reports 6i, Workflow 2.6.2, BI Publisher. Discoverer 9i.

Sr. Oracle Application Technical Consultant.

Responsibilities:

• Prepared functional and technical documents, interface feed mapping, designed and developed automated interface programs between Oracle EBS and Third party Warehouse system for PO outbound, PO Receipts inbound, sales Order outbound, AR Invoice outbound, Shipping Inbound, AP invoice inbound.
• Customized Sales Order Acnoledgement, Pick Slip, Packing slip, Sales Order etc reports.
• Designed and development Oracle reports, XML Publisher and BI Publisher reports.
• Worked on the development of Interfaces, Data Conversions, Developing new Forms, Reports, Customizing Oracle Reports in Order to Cash Cycle touching various modules such as GL, AR, INV, OM, BOM & SHIPPING.
• Personalized Forms and OAF pages using personalization.
• Developed custom interface program to load inventory Adjustment data from external system into MTL TRANSACTION INTERFACE and MTL TRANSACTION LOTS INTERFACE tables as Account Alias Receipts and Account Alias Issues

Confidential, Atlanta, GA

Tools Used: Oracle Applications R12, 11i, Oracle 10g, Forms 6i, Reports 6i, Workflow 2.6.2,. Oracle OWB 2.6, BI Publisher

Oracle Application Techno Functional Consultant

Responsibilities:

• Developed extract and conversion programs to migrate GL segments, Customers, Vendors, Open PO, Accounting setup data from 11i to R12.
• Prepared functional and technical documents, interface feed mapping, designed and developed automated interface programs for PO Receipts inbound, sales Order outbound, AR Invoice outbound, Shipping Inbound, AP invoice inbound.
• Prepared technical document, Designed and developed Custom application for Sales Order Promotions based on customer profile, order type, item category etc,
• Designed and Developed Custom Forms and Reports, customized CUSTOM.pll for EDI, promotions, Sales credit, Order Correction, Credit Hold etc.
• Customized OM Order Process workflow for Order Booking, Approval and Return.
• Prepared technical document, Designed and developed batch cost variance Report dat includes Actual, Plan and Standard cost for OPM and GL.
• Developed HR benefit changes employee email notification using workflow process, and benefit extract for healthcare provider Aetna, Wausau.
• Design and Developed various Business Areas, Folders and reports in Discoverer using Discoverer 4i, 9i.
• Design and created various Mapping and Process Flows using Oracle OWB from ERP, Sqlserver, datafile etc to Oracle Datawarehouse,
• Worked various production support issues,

Confidential, Jamesburg, NJ

Tools Used: Oracle Applications 11i, Oracle 8i, Forms 6i, Reports 6i, Discoverer 4i and 9i, Workflow 2.6.2

Oracle Application Technical Team Lead

Responsibilities:

• Prepared functional/technical documents, interface/conversion mapping, designed/developed programs for AR Invoices, Customers, FA Assets, Open Sales Orders, Resources and Sales reps Conversion from various sources,
• Coordinated with users to prepare and develop requirements gathering documents on the current business practices.
• Worked on lockbox transmission setups and Payment interfaces for various banks.
• Setups Asset Categories, Asset Locations, Asset Keywords and Value Sets for Asset conversion.
• Customized Oracle Account Generator in FA for Asset cost, clearing, deprn, intercompany account using Workflow builder.
• Prepared functional/technical document, Designed and Developed Automated interface program between Oracle Order management and Warehouse for Shipping, Receiving and Inventory Adjustment,
• Customized AP Remittance email notification workflow using workflow builder,
• Prepared test plan and test script for sales order, shipping, inventory and contract unit testing,
• Design and Developed various summary and detail GL reconciliation reports like Revenue by Region, Sales by Product, sales by inter company etc
• Designed and Created Business Areas in Discoverer4i and 9i, created more than 50 Workbooks for AR, FA, GL, AP, OM, Contracts, Services and Installbase.
• Designed and Developed Contract billing Service and Usage programs,
• Design and developed Sales Manager and Service territory hierarchy for reporting,
• Created apps mode EUL in Discoverer 4i and 9i, and involved in granting privileges and defining security roles.
• Worked on various custom programs, interfaces and reports
• Working On upgrade from 11.5.5 to 11.5.9.

Confidential, CT

Tools Used: Oracle Applications 11i, Oracle Ver. 8i, Forms 6i, Reports 6i, Oracle Designer 6.0, Discoverer 4i.

Oracle Application Techno Functional Consultant

Responsibilities:

• Customized Custom.pll for more than 40 Application forms using third party Ring Master REM software.
• Developed different lockbox interfaces from various banks for various business units.
• Customized Aging, Postscript Invoice print, statement and Dunning Letter Reports.
• Creates and Update new service request using API.
• Designed and Developed new forms using Oracle Application TEMPLATE.fmb for Customer security.
• Creates New Task and Update Task with various options using APIs.
• Updates Service Request status using API
• Designed and Developed Repository for Services, Order Management and Invoices for Discoverer Reports.
• Created apps mode EUL using Discoverer Administration 4i, and involved in granting privileges and defining security roles.
• Created Scheduler script and scheduled Discoverer workbook using Windows scheduler.
• Created interface to display Installbase counter reading and history to customer on web and updates meter reading on oracle application install base tables using API.
• Designed and Developed extract program for Customer Invoices.
• Desgined and Developed views for Contracts, Order Management and Installbase interfaces.

Confidential, Melville, NY

Tools Used: Oracle Applications 11i, Oracle Ver. 8i, Forms 6i, Reports 6i, Discoverer 4.1, IBM AIX RS 6000 Server, Unix.

Oracle Application Technical Team Lead

Responsibilities:

• Implemented Oracle 11i with FDC across 15 states domestically and with nine international sites (UK, Canada, Germany, Austria, Honk Kong, Australia, Mexico & Costa Rica). Converting data from three disparate legacy systems (11.03, 10.7 and GEAC/SQL Financials).
• Successfully managed Team as a Team Lead on this Global Multi lingual 11i implementation.
• Went live in 6 Countries in just over a year. Implemented in 3 different languages (NLS).
• Successfully performed duties like analyzing the functional and Technical specs, providing estimates, preparing the Project plans, base lining the Project, tracking status etc
• Design and development of Customer conversion programs to pull data from 10.7and 11.03 environments using Database Link, Validated customer related setups.
• Prepared a complete design document, technical design, testing methods and implementation strategy.
• Converted Customer, addresses and site use information to the 11i environment.
• Design and development of Transactions conversion program to pull data from 10.7 and 11.03 environments using Database Link, Validated the invoice related setup information.
• Converted Open Debit Memos, Credit Memos and Invoices.
• Standard Validation program to validate the invoices and Migration program to move the validated invoices to the open-interface tables.
• Developed four different lockbox interfaces from various banks for various business units.
• Implemented and maintained these lockbox interfaces after live.
• A standard process to reconcile the converted transactions.
• Customized Aging, Postscript Invoice print, statement and Dunning Letter Reports.
• Created workbooks based on the Custom Folders with multiple parameters and calculations using Discoverer Plus.
• Designed and Developed Automated AR Invoice load Interface Program between Oracle Receivable and non-Oracle system.
• Designed and Developed Automated AR Customer Balance Interface between Oracle and other non Oracle IBM system.
• Designed and Developed Global Programs for Fixed Assets Conversion from BEST Financial system to Oracle Fixed Assets for USA and International Sites.
• Developed Programs to load FA setups data Asset Categories, Asset Locations, Asset Keywords and Value Sets through backend.
• Migrated (Extracts and Conversion) Assets Data for CORP and four TAX books from 10.7SC to 11i Oracle Applications.
• Migrated (Extracts and Conversion) Assets Data for two CORP and three TAX books from 11.03 to 11i Oracle Applications.
• Designed and Developed Custom FA Property Tax Reports in 6i.
• Customized Asset Reserve ledger, Asset Addition, Asset Project Summary, Asset Depreciation Projection Reports
• Customized Oracle Account Generators in FA using Workflow builder.
• Worked on FADI to load Assets for International sites.
• Designed and Developed Global Programs for Vendors and Vendor Sites Conversion.
• Designed and Developed Global Generic Invoice Upload Programs for Domestic and International Sites.
• Designed and Developed EFT File Programs for Domestic and International banks.
• Worked on AP Bank branches and Bank account conversions.
• Worked on AP Remittance workflow using workflow builder.
• Design and Developed Program for Bank Statement Import and AutoReconciliations.
• Designed and developed a complex interface from Oracle GL to Hyperion GL. The interface had to take care of all the security rules, cross validation rules and alot of other business rules.
• Worked GLADI to load Journals.
• Created workbooks based on the Custom Folders with multiple parameters and calculations using Discoverer Plus.
• Developed FSG reports using the row set, column set.

Confidential, St.Petersburg, FL

Tools Used: Oracle Applications 11i, Oracle Ver. 8i, Forms 6i, Reports 6i, Discoverer 3.1, IBM AIX RS 6000 Server, Unix.

Oracle Application Technical Team Lead

Responsibilities:

• Designed and Developed Programs for GL Journal Entry Conversion and Validates Gl code combinations using Fnd Flex Keyval API.
• Designed and Developed Interface to load HR ADP files to Oracle GL as journal Entry.
• Prepared documents and developed programs to generate formatted EFT data file to bank with different criteria.
• Designed and Developed program to generate formatted printed check information from AP to Bank.
• Developed Programs to load Vendor, Vendor sites and Vendor Contacts.
• Design and Developed Program for Bank Statement Import and AutoReconciliations.
• Developed Programs to convert Customer, customer Site, Customer Site Uses and Customer Contacts using multiple APIs.
• Prepared Mapping and Developed Programs to convert more than a million AR Invoice lines and taxes with GL Distribution Accounts.
• Performed Transmission formats and lockbox set up to convert AR Receipts and also daily lockbox process.
• Developed Programs to convert AR Sales reps from HR Employee using APIs which includes create resource and create sales reps.
• Developed Programs to load Inventory Item, On hand quantity and Serial number for multiple Warehouse Organizations.
• Developed Programs to load Open Sales Order in Order Management.
• Prepared Mapping and Developed programs to convert Customer Installed Base Item and contact information using Oracle APIs which includes create product, contact resource, counter group and counters.
• Developed Programs to convert Service Request, Resource and Task for CRM
• Customized Reports for AR Invoice, OM Packing Slip, OM Pick Release and Installed base counter.
• Designed and Developed Service Contract report for SERVICE and USAGE based on Contract and Ship to locations.
• Designed and developed multiple Interface Programs for Order Management to Warehouse and Warehouse to Order Management using Oracle Application APIs and Interface table which includes
• Sends Expected Receipts from Vendor and RMA from Customer to Warehouse which uses third party software to send and receive Inventory Item.
• Receives Receipts and RMA from Warehouse to Purchasing and Order Management using Interface table.
• Sends Customer Sales Order to Warehouse from Order Management after pick release from Inventory.
• Receives Ship Confirmation from Warehouse and loads to Oracle Shipping using multiple APIs to update shipped quantity, tracking number and Ship Via.
• Receive Inventory Adjustment from Warehouse to Oracle Inventory to adjust on-hand quantity to adjust damaged quantity in Warehouse.

Designed and Developed Interface programs between Oracle Application and Lexmark System Which includes following tasks in CRM

• 1. Creates new Customer location, sites, contacts using Customer interface APIs.
• 2. Creates and Update new service request using API.
• 3. Creates New Task and Update Task with various options using APIs.
• 4. Updates Service Request status using API
• 5. Adjusts Inventory using Inventory Interface Table and Interface Programs
• 6. Sends feedback data back to Lexmark in a flat file using UTL.FILE Programs.

Confidential, Billerica, MA

Oracle Applications Techno Functional Consultant

Responsibilities

• Developed the Open Order conversion from legacy system. The open order conversion will move the order backlog from old global operating unit to the newly created operating units based on the ship to address. The reconciliation of order backlog quantities and cancellation of orders from the old global organization is taken care in conversion procedure.
• Development of Price List Conversion for pricing the newly created items.
• Developed On Hand quantity conversion for issue and Receipts of quantity. The On hand quantity conversion is developed to issue quantity from global inventory organization and receive dat quantity to new created organizations.
• Developed Bill of Material Conversion for newly converted items from legacy system. The conversion takes care of primary as well as alternate bill of materials.
• Developed Programs to load Inventory Item, On hand quantity and Serial number.
• Involved in major Conversions like Items, PO, Open Orders and On Hand in Oracle Manufacturing.
• Designing and developing Error Reports for Item Conversions and Interface.
• Customized Pick Slip, Packing List, Commercial Invoice, Standard Purchase Order Print Report, AR Invoice Print and Dunning Letters.

Confidential, Minneapolis, MN

Oracle Applications Techno Functional Consultant

Responsibilities

• Performed set ups for the BOOKS, categories, fiscal years, calendars, Prorate Conventions, locations, asset keys, Depreciation Methods, natural Accounts and code combinations for Fixed Asset.
• Designed functional and technical documents for customizations, interfaces and conversions following the AIM (Application Implementation Methodology) of Oracle.
• Prepared Functional and Technical Documents for transferring single and group of assets between books.
• Designed and developed multiple Forms, Reports and SQL Programs to implement asset transfer functionality.
• Designed and developed interface for AR transaction conversion.
• Customized Age Trial balance reports as per the client’s requirements.
• Extensive Development of new Reports and modification of the existing Oracle Applications reports in Developer/2000.
• Designed and developed Bitmap Invoice format reports

Confidential, Jacksonville, FL

Responsibilities

• Implemented Oracle Fixed Assets, Oracle Projects, and Oracle Receivables modules. Job responsibilities include Conversions, Performing GAP analysis, Coding and testing for all the GAPS from mainframes legacy system to Oracle Applications.
• The project involved huge conversions, interfaces and lots of customizations and was a multi million Dollar implementation.
• Performed the GAP Analysis for bringing legacy Assets data to Oracle Applications from seven different sources. Designed the logic to convert the assets and later build transaction history after Mass Copy for the different Legacy systems.
• Designed the structure for categories and asset key Flex fields and also designed the Descriptive Flex fields based on the context values.
• Performed set ups for the BOOKS, categories, fiscal years, calendars, Prorate Conventions, locations, asset keys, Depreciation Methods, natural Accounts and code combinations.
• Developed PL / SQL Packages to load all assets from temporary tables to FA Mass Additions Interface table. Developed codes to populate the Descriptive Flex fields after running the post mass additions. Designed and Developed Forms and Reports to view invalid Assets.
• Worked on various gaps, which included SUBLEDGER functionality.
• Involved in the data conversion for loading the Customers from legacy system to Oracle Applications. Also developed procedures to load all the transactions to interface tables.
• Customized Invoice formats reports and Age Trial balance - 7 Buckets reports as per the client’s requirements.
• Designed and developed multiple Bitmap Invoice format reports

Confidential, Cincinnati, Ohio

Tools Used: Oracle Financials 10.7 SC, Oracle Ver 7.3 PVCS, AppWorx Scheduling tool, Developer 2000 and Designer 200 on SUN Solaris.

Responsibilities:

• Designed functional and technical documents for customizations, interfaces, and conversions, following the AIM (Application Implementation Methodology) of Oracle.
• Set up Flexfields, Alerts, and Registration of Reports, Forms, and PL/SQL programs in Application Developer. GAP analysis for the GE AE international sites.
• Developed interfaces from Oracle Applications to the legacy system, and legacy system to Oracle Applications.
• Developed new and modified existing Oracle Applications reports in Developer/2000.
• Developed customization programs (PL/SQL) and reports.
• Prepared unit and integration test plans and tested all programs.
• Fully automating the process involved for processing the journal entries from the legacy IBM systems and the entire daily, weekly, monthly, quarterly and yearly financial processes using the AppWorx scheduling tool.
• Defined accounting, item, territory key flexfields, descriptive flexfields. Defined payment parameters, lockbox transmission formats, distribution sets, payments rules, banks, payment methods, receipt class, receipt source. Defined parameters, collectors, approval limits, aging buckets and statement cycles.
• Entered and maintained customers, territories, customer relationships, classes and credit profile classes.
• Processing invoices
• Maintenance of invoices, commitments and credit memos in functional and foreign currencies. Created recurring invoices. Managing collections.
• Reviewed open invoices, transaction history, customer account data, customer payments and creation of Dunning letters.
• Maintenance of Customer Receivables Debit and credit memos. Re-application of payments, on-account credits and credit memos. Created and reviewed adjustments and reversed payments.
• Designed and Customized Oracle Reports Statement and Dunning to Bitmap Reports.
• Loading the invoices and receipt data (lockbox).
• Developed FSG reports using the row set, column set.
• Loading the legacy data to the GL INTERFACE using PL/SQL. This code converts the legacy account numbers to the Accounting Flexfields and does the validation of the data.
• Loading the operational details as well as the master data from the Oracle General Ledger to FDW. Rolling over the balances for OGL periods. This process is now completely integrated with the Oracle General Ledger period closing process. The reporting tool used is IQ Objects.