InfoExperts

/ 111 W. Spring Valley Road, Suite 150
Richardson, TX75081
Tel: 972-671-1500 Fax: 972-671-1505
Email:

PP

SUMMARY

Over Five years of experience as a Technical Consultant in implementing various ERP Oracle Applications modules like General Ledger(GL), Accounts Receivables(AR), Accounts Payable(AP), Inventory(INV), Order Management(OM) and Oracle Purchasing(PO).

Expertise in Interfaces, Customizations, Conversions and Extensions in Oracle Applications 11i (GL, AP, AR, PO, OM, INV).

Extensive experience in Oracle 9i/8i, Developer 2000/6i, PL/SQL, SQL and SQL*Loader.

Have extensive experience in Customization of Oracle Application modules, which involved the development of Forms 4.5/6i and Reports 2.5/6i.

Experience in building Forms, generating Reports and registering them as Concurrent programs in Oracle applications using AOL.

Exposure to TCA Architecture.

Extensively worked on AIM documents such as MD50 AND MD70.

Knowledge of Unix Shell Scripting.

Experience in EDI implementation for Inbound and Outbound.

Knowledge of Discoverer 4.0

Experience in implementing business process systems through Workflow Builder.

Experience in Performance Tuning to optimize SQL Statements.

Excellent communication skills, team player, quick learner and self-motivated.

Exceptional analytical and problem solving skills.

TECHNICAL SKILLS

ERP Package: / ORACLE APPLICATIONS 11i - Oracle General Ledger, Accounts Payable, Accounts Receivable, Oracle Purchasing, Oracle Inventory, Order Management.
Operating Systems: / UNIX, Linux, WINDOWS, MS-DOS.
Software: / PL/SQL, C, C++, Java, HTML, ASP, Unix shell scripting, Dreamweaver, Microsoft FrontPage, Microsoft Visio.
Databases: / ORACLE 8i/9i, MS Access, SQL Server 2000.
Oracle Tools: / Oracle Forms 4.5/6i, Reports 2.5/6i, Discoverer 4.0, Workflow Builder 2.6,TOAD, SQL*Plus, SQL*Loader, SQL Navigator

EDUCATION:

Masters Degree in Computer Science.

PROFESSIONAL EXPERIENCE

MBNA America, DE JULY’04 TO AUG’05

Role: Techno Functional Consultant

Description: MBNA is aninternational financial services company, providing personal and business lending and deposit account products to millions of Customers worldwide. The project involved implementation of Oracle Applications 11i (GL, AP, AR, PO).

Responsibilities:

  • Designed and Developed the interface program to Import Journals into General Ledger using SQL*Loader, PL/SQL package and Journal Import Concurrent program.
  • Designed and Developedthe interface program to load the Invoices from a legacy system into Oracle Payables using SQL*Loader, PL/SQL package and Payables Open Interface Import Concurrent program.
  • Used Auto Invoice Interface to import Standard invoices from a legacy system into Oracle Receivables using a control file, PL/SQL packages/procedures and Auto Invoice Import program.
  • Customized standard reports such as Account Analysis Report,Journal Batch Summary report (GL Transaction report), Past due Invoice report and AGING BUCKETS in General Ledger and Accounts Receivable.
  • Developed custom reports such as Detailed Expenditure Report and Journal Detail Report in General Ledger.
  • Developed custom reports such as Inactive Vendor Sites Report and Invoice Payment Summary Report inOracle Payables.
  • Created value sets for the new reports developed and registered them using AOL.
  • Worked on MD-70 document for Development work done.
  • Customized the CUSTOM PLL library according to the client’s requirement to enable the ZOOM functionality.
  • Registered forms and reports in oracle applications using Application Object Library.
  • Extensively used TOAD for database access and PL/SQL Development.
  • Developed Ad-hoc reports as per the requirement in Discoverer.
  • Used descriptive Flexfield to capture additional information in standard forms.
  • Wrote Unix Shell Scripts for job Automation.
  • Worked on Performance Tuning to optimize SQL Statements.

Environment: Oracle Applications 11.5.9 (GL, AP, AR, PO), Oracle 9i, SQL*Loader, TOAD, Forms 6i, Reports 6i, Windows 2000, UNIX.

SOLECTRON, SC JUL’03 TO JUN’04

Role: Technical Consultant

Description: Solectron Corporation is a leading global provider of electronics manufacturing and integrated supply chain services. It is one of the world's most innovative companies that rely on high-tech electronics.This project is an implementation of Oracle Applications 11i.The project involved implementation of General Ledger, Receivables, Inventory, Payables, Purchasing and Order Management.

Responsibilities:

  • Developed Customer Import process to validate and transfer the Customer data
    from the legacy system into Accounts Receivable using APIs.
  • Used SQL*Loader to import receipt data into Interface table in Accounts

Receivable after defining Lockbox and Transmission Format, and running Lockbox
interface form transferred data into Oracle Receivables.

  • Developed a Conversion program to Import Requisitions into Oracle Purchasing using SQL*Loader, PL/SQL package and the Requisition Import concurrent program.
  • Developed the Interface program to Import Item quantity (Open Transaction Interface) into Oracle Inventory using SQL*Loader and PL/SQL package.
  • Developed a Custom Report called On-Hand-Quantity for all the items in every sub-inventory, which belonged to a particular Organization in the Inventory module.
  • Customized COGS Account Generator Workflow in Order Management.
  • Customized order line workflow in Order Management according to the client’s requirement.
  • Developed new forms as per the business requirement and registered them using AOL.
  • Registered customized reports using Application Object Library.
  • Customized standard reports such as the Incomplete Invoices Report,and Customer Credit snapshot report.
  • Designed Technical specs in MD70 by using AIM methodology.
  • Customized the Standard Invoice Aging Report in Accounts Payables.
  • Created value sets for report parameters and registered them in apps using Application Object Library.
  • Involved in Performance Tuning of SQL queries using EXPLAIN PLAN utility.
  • Performed various Sys Admin responsibilities such as defining and registering concurrent programs and subsequently assigning them to their respective Request Groups.

Environment: Oracle Applications 11.5.8 (General Ledger, Accounts Payables, Inventory,Accounts Receivable, Order Management and Purchasing), PL/SQL, Oracle 8i, Forms 6i, Reports 6i, TOAD and UNIX

VIEWSONIC CORP, FL OCT’02 TO JUL’03

Role: Technical Consultant

Description: Viewsonic Corp is one of the largest manufacturers of visual display products. It has implemented oracle financials and manufacturing application for efficient operation of the company. The project involved implementation of General Ledger and Oracle Purchasing.

Responsibilities:

General Ledger

  • Developed SQL scripts to transfer data from the Legacy system into the staging tables.
  • Developed PL/SQL packages to validate and load the data into the Interface table.
  • Imported journals through Journal Import, which imported the data into the base tables.
  • Developed custom reports according to the requirement.

Oracle Purchasing

  • Developed SQL*Loader scripts to load the legacy system data into the custom
    staging table for Requisition interface.
  • Developed packages to validate and move the data from the staging table into
    the interface tables.
  • Developed the Purchasing Requisition open interface to load the data into the
    base tables.
  • Involved in SQL Tuning using the TKPROF Utility.
  • Customized various Oracle Reports in PO.
  • Worked on MD-70 documents for Development work done.

Accounts Payable

  • Developed custom reports such as Top Ten Supplier report and Cancelled Invoices Report in Oracle Payables.
  • Enabled Descriptive Flex fields on Invoice Distributions to capture additional information.
  • Configured EDI for 810 Inbound Invoice transfer and EDI for 820 Outbound Payment Order.

Environment: Oracle Applications 11.5.8 (AP, PO, GL) Reports 6i, Forms 6i, PL/SQL, Windows NT, Oracle 8i, TOAD and UNIX.

MACROMEDIA, CA JAN’02 TO SEP’02

Role: Technical Consultant

Description: Macromedia is one of the leading companies, which provide tools for design and development of Websites. The project involved implementation of Accounts Payable, General Ledger and Oracle Purchasing.

Responsibilities:

Accounts Payable

  • Developed SQL*Loader scripts to load the legacy system data into custom staging tables for Auto invoice interface.
  • Developed packages to validate data and load it from staging table to interface tables.
  • Developed Payables open interface import to load the data to the base tables
  • Involved in optimizing the performance of SQL Scripts, and improved reports such as Receipt Register report.
  • Worked on AOL for registering the Custom Programs. Concurrent programs were defined and assigned to report groups. Registration of concurrent programs implemented PL/SQL method for calling concurrent programs, defining value sets and parameters.

Accounts Receivable

  • Developed AUTOLOCKBOX Interface to load data that is received from bank in to
    interface tables (AR_PAYMENTS_INTERFACE_ALL), from interface table to the Base Interim tables and finally to the base table.
  • Developed Customer Import process to transfer and validate Customer data from
    legacy system into Accounts Receivable using APIs.
  • Developed various custom reports according to client’s requirement.

Environment: Oracle Applications 11.5.8, AOL, AR and AP, Oracle 8i, Forms 6i, Reports 6i, SQL, PL/SQL, SQL*Loader, TOAD, UNIX

Danka office Imaging, FL JUN’01 TO DEC’01

Role: Technical Consultant

Description: Danka Business Systems PLC is an independent supplier of office imaging equipment and related services, parts and supplies. This project involved implementation of Inventory and Purchasing.

Responsibilities:

  • Developed control files for SQL*Loader and PL/SQL program for loading and validating the data into the interface tables from the Legacy system.
  • Imported the Journal entries from legacy system to Oracle General Ledger using SQL*Loader, PL/SQL package and populated the data into GL base table.
  • Developed a feeder program to load external data from legacy system using SQL* Loader into AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE Interface Tables.
  • Developed new reports, forms, functions, validation sets, request sets and concurrent programs.
  • Developed new reports and forms, request sets and concurrent programs.
  • Customized Oracle Standard Reports in Accounts Payables, Oracle Purchasing and General Ledger.
  • Developed custom reports and customized various reports in AP and PO.
  • Customized the CUSTOM.PLL library according to the client requirements.
  • Worked on Performance Tuning to optimize SQL Statements.

Environment: Oracle Applications11i (General Ledger, Accounts Payable, Oracle Purchasing), Oracle 8i, PL/SQL, Forms 4.5 and Reports 2.5

CHICK-FIL-A, GA AUG’00 To MAY’01

Role: Technical Consultant

Description: The project involved the implementation of Account Payables, General Ledger, Order Management, Accounts Payable, Oracle Purchasing and Inventory

Responsibilities:

  • Wrote custom PL/SQL programs to perform importsfrom legacy system and registered them in Oracle Apps as concurrent programsusing AOL module.
  • Developed Custom reports and forms in modules such as General Ledger, Accounts Payable, Purchasing Order, and Inventory.
  • Modified standard oracle reports in Order Management, Purchasing and Inventory modules as per the requirement.
  • Designed, developed and registered custom forms and reports using AOL.
  • Worked extensively on all AOL features like Concurrent programs, Executables, Request Groups, and Request sets.

Environment: Oracle Applications 11.0.3 (General Ledger, Accounts Payable, Purchasing Order, Order Management and Inventory), Oracle 8i, Reports 2.5, Forms 4.5, PL/SQL, SQL*Loader, Windows NT.

References:

Available on request.

1