SUMMARY

• Over8 years of experience as managing substantial components of large - scale ERP implementations and support of business applications using Oracle Applications.
• Outstanding Functional/Technical noledge in Oracle Applications Oracle Financials like (GL-General Ledger, AP-Accounts Payables, AR-Accounts Receivables, FA-Fixed Assets, CM-Cash Management), PO-Oracle Purchasing, OM (Order Management/Advanced Pricing), Manufacturing (INV-Inventory, WIP-Work in Progress, BOM-Bills of Materials), Install Base, Service Contracts, iprocurement, iReceivables and AOL (Application Object Library).
• Developed customization for Bulk Invoice Printing (All Invoice types) and delivery to teh customer using XML Publisher technology.
• Has hands on development experience in SQL, PL/SQL (Procedures,Packages, Functions, and Triggers), Oracle Reports 9i/10g and Forms 9i/10g, XML Publisher.
• Having skills in Oracle 9i,10g,11g environments using SQL,PL/SQL,Developer2000Oracle (Forms 9i/10g and Reports 9i/10g).
• Experience in Designing and developing reports using XML/BI Publisher, Discoverer.
• Strong coding experience in PL/SQL development using Stored Procedures wif Functions, Triggers, Packages, Writing and Tuning complex SQL statements.
• Expertise in Design, Development and Customization of RICEW(Reports, Interface, Conversions, Extensions and Workflows) using SQL*Loader, PL/SQL, UTL File etc.
• Ability to learn and implement teh setups needed for financial, distribution and supply chain modules.
• Experience in Customization, Upgrade, Implementation and Production Support of Oracle Financials and Oracle Supply Chain modules.
• Excellent analytical, problem solving, communication skills and interpersonal skills and consistently being organized by management and peer for producing high quality work.
• Analyzed business process workflowand assisted in teh development of ETL procedures for moving data from source to target systems.
• Experience in System Administration activities and Strong noledge of AOL.
• Strong implementation noledge of O2C (Order to Cash), P2P (Procure to Pay) and Drop Ship end to end Cycles.
• Experience in Order import interface program to import sales order.
• Developed Workflows to send notifications based on teh business rules.
• Customized Order Management Header and Line workflows to meet business requirements
• Customize and convert existing RDF reports dat will run compatible as per teh new multi-org structure.
• Experience in all aspects of Software Development Life Cycle including Software Design, Development, Implementation and Testing.

TECHNICAL SKILLS

ERP Versions: Oracle Applications 11i,R12Modules General Ledger (GL), Oracle Payables (AP), Oracle Receivables (AR), Oracle Purchasing (PO),Oracle Inventory (INV), Order Management (OM), Shipping (WSH), Bill of Materials(BOM), Work in Process(WIP),MES,Cash Management, System Administrator, workflows.

Languages: PL/SQL, SQL, C, C++, Java, HTML, XML

Self-Service Modules: me-Expenses, me-procurement, me-receivables, me-supplier

Tools: XMLPublisher, Toad, PL/SQL Developer, SQL*PLUS, Oracle Workflow, Oracle Developer 2000(Forms 9i/10g, Reports 9i/10g)

Databases: Oracle 9i, 10g,11g, MS SQL Server 2010

Operating System: Windows XP,7,NT, UNIX, Windows- 98, 2000, 2003, 2007

PROFESSIONAL EXPERIENCE

Confidential, Germantown, MD

Oracle apps Techno-Functional Consultant

Responsibilities:

• Customized Modules AP,AR,GL, FA,MFGusing Oracle Development Suite/Reports 9i,10g and BI Publisher. Created custom values sets, menus, and responsibilities as a part of r12Upgrade from 11.5.10.
• Designed & Developed AP Invoice Open Interface and AP Invoice Audit Report for teh different Sources in Oracle Payables.
• Implementation Guide for importing Customer Calls Information from legacy Customer Notes Information into Oracle AR
• Created and customized reports using XML Publisher in OM, AR, AP and INV.
• Worked on designing and implementing Oracle Alerts and Lookups.
• Created Concurrent Programs, Menus and Functions required for registering teh Forms, Reports and PL/SQL.
• Development, customization and performance tuning of Reports by using SQL, PL/SQL,XML,XML Publisher and Oracle Reports Builder.
• Development and customization of Screens by using SQL, PL/SQL, Oracle Forms Builder and Oracle Forms Personalization.Customized Auto lockboxinterface such dat teh receipt file from automatically imported into Accounts Receivable(AR).
• Check teh properGL code to use
• Entered all accounts payable bills wifGL coding and issued timely payments
• Conducted periodic audits on AP aging to ensure accuracy
• Maintained weekly reports for billable employee hours spent on development projects
• Created account receivable invoicing for software and software development projects
• Applied cash receipts to AR invoices
• Conducted periodic audits on ARaging to ensure accuracyCustomized teh AR Invoice, Sales Tax Reports in Receivables using Reports and XML Publisher.
• Maintaining consistent and accurate accounting records wifin QuickBooks, including AR,AP and journal entries.
• Prepare weekly AP& AR reports.
• Manage all filing for teh lockbox department.
• Supported Corporate procurement Department wif daily tasks and project
• Trains and oversees staff of 3, also cross-trains other departments for lockbox
• Replaced teh RA customer view wif AR customer when teh PO Close Process has been upgraded to R12Develop AP/AR/GL/PO reports using discoverer which include teh following:
• Developed major enhancements required for business process in Order to Cash and Procure-to-Pay cycle Involved in importing Open PO Closed Invoices and Payments from teh legacy system to Oracle Payables system.
• Registration of Program: Registered Reports, SQL*LOADER, PL/SQL Package wif Oracle AOL.
• XML templates, concurrent programs, request sets, menus, requestgroups, responsibilities, Profiles and alerts between database instances.
• Developed teh bursting process to email, Fax and print a document based on teh business rules at teh same time.
• Customized AP Approval, Requisition Approval and AP Approval workflow for Procurement.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Worked on Customer Listing - Detail/Summary report and Dunning History report. Registered these reports as concurrent programs in AOL and modified request group to add these concurrent programs.

Environment: Oracle Apps Release 12(12.2.3), (AP,AR,GL), me-procurement SQL, PL-SQL, Oracle 10g, TOAD, Discoverer, Developer 2000(Reports 9i/10g and Forms 9i/10g),XML Publisher, SQL*Developer, Putty, Workflow, WinSCP, UNIX.

Confidential, Jacksonville, Florida

Oracle apps Techno-Functional Consultant

Responsibilities:

• Experience in developing of RICEW components in AP,AR,GL, Cash Management,POmodulesOracle.
• Customized and developed various reports to user community for day to day operational support in Receivables, General Ledger(GL), Purchasing and Payables and iReceivables.
• Architecture and Development using OAF and PL/SQL. procurement plans and procedures
• Creating newprocurementfiles at teh beginning of a new projectWorked on various financial modules (AP-Accounts Payables, PO-Purchase order, GL-General Ledger, OM -Order Management and AR-Accounts Receivables). procurementCorporate activities
• Issuing corporate purchase orders, change orders, distribution of airline tickets and any other activities assigned by teh Director ofprocurement /procurementManager.
• Managing a Small Team of OracleXML Publisher consultantsImplementation and Customization of MODULES AP, AR & GL, FA in Multi - Org environment.
• Created newXML Publisher reports in Order Management
• Converted existing custom reports toXML Publisher Excel formatUsing SQL*Loader loaded teh data into staging table, Developed PL/SQL packages to validate teh data and load into interface tables.
• Developed conversion program for validating and importing Open AR Transactions (Invoices) from legacy system to Oracle interface tables. Used Auto invoice Master Program to load teh interface table data into Oracle AR base tables.
• Development of BOM Daily Rates Inbound Interface to upload data from flat file to Oracle Applications base.
• Highly proficient in Oracle ERP Order Management, Manufacturing and Finance
• Extensively developed custom reports using Discoverer in INV: Account Analysis Report, Journal Batch Summary Report, Cash reports and AP/AR/OM: Invoice on Hold Report, Receivables Balances, OM Balance Sheet Details reports Reports, History Report etc.
• Developed Schedule Ship report to identify teh errors in teh Shipment dates for teh retail customers. This report lets teh internal sales force identify teh manual errors committed during teh order booking process.
• Developed a custom layout XML format according to teh user specifications and worked on incorporating it to teh standard print Purchase Order and Invoice reports using XML Publisher (BI Publisher).
• Designed wide variety of reports in Order Management wif BI/XML Publisher.
• Creation of new custom reports and customizing of existing reports using OracleXML Publisher
• Customized standard Oracle Applications reports and developed custom reports in AP,AR,GL,OM, BOM, WSH and INV modules.
• Developed new OAF pages through Jdeveloper.
• IntegratingXML Publisher wif OAF usingXML Publisher APIs.Developed custom reports: Sub Ledger Accounting Report and New Account Code Combination Report using XML Publisher.
• Developed Customer License Form to save teh Customer’s License information.
• Developed an outbound interface to export GL data to third party systems, also inbound interfaces to import into GL.
• Developed teh PL/SQL Scripts to translate teh old Asset Category to new Asset category values dat are been setup in teh R12 Fixed Assets.
• Developed custom Forms and Reports as per client requirements.
• Creation of Customized Mailing Label and teh Pick Slip Report to fulfil teh requirements of teh client using teh OM and WSH using Reports 10g.
• Oracle Workflow:
• Developed workflow business events to report teh promise date and schedule ship date changes on teh orders.
• Customized teh PO workflow to send notifications to specific people using adhoc roles.
• Created Concurrent Programs, Menus and Functions required for registering teh Forms, Reports and PL/SQL.

Environment: Oracle Apps R12, Procure-2-Pay(P2P),OAF, workflow Oracle 10g,me procurement Oracle SQL, Oracle PL/SQL, AP, GL, PO, AR, OM, INV,iExpenses, TCA, TOAD, Discoverer, XML Publisher, SQL*Developer, Forms(9i), UNIX, Shell Scripting, WINDOWS XP.

Confidential, Herndon, VA

Oracle Apps Technical Consultant

Responsibilities:

• This project was an upgrade project which involved teh upgradation of Oracle Applications 11.5.8 to Oracle Application R12.
• Involved in following modules INV, AP, AR, GL,INV and iReceivables.
• Customized teh components, upgraded shell scripts, which calls reports, control files and SQL files which are in teh production.
• Migrated objects into Oracle Apps EBS R12.
• Involved in customization of various reports as per teh user requirements, which includes customized mailing label report, sales order acnoledgement report, Order Status Summary report, printed purchase order and packing slip report, Vendor Performance report.
• Setup Custom Modifiers to derive discounted price for few business requirements.
• Worked on teh staging R12 Apps environment to convert AP suppliers and AP Open Invoices from 11i to AP of R12.
• DevelopedXML reports in PA, AR, and OM.
• Developed new OAFpages through Jdeveloper.
• Modified existing reports by creating additional joins and designed and developed many reports by using lexical parameters in before, after parameters and before report triggers.
• Developed teh templates for several reports using XML publisher.
• Developed Master Detail forms using TEMPLATE.FMB and registered them in Oracle Applications.
• Developed Open Purchase Order Report.
• Helped team documents such as MD50,MD070, MD120 .
• Designed & developed teh custom interface program to create and update an item in Item Hub wif database validations.
• Worked on in Order import interface program to import sales order.
• Worked extensively on Reports and Custom Forms
• Contributed to teh design specifications of teh Oracle XML Gateway and advised other product teams on teh development of XML messages.
• Identified many Gaps/OracleBugs / EnhancementsinOracleASCP
• Developed Margin Analysis Report which will pull all teh sales orders dat are ship confirmed and Invoices dat are created manually and created through Auto Invoice.
• Responsible for migrating custom concurrent programs, reports, forms, responsibilities from one instance to another instance using FNDLOAD utility.
• Developed Price Book Extract Report for various price lists.

Environment: Oracle Apps Release 12(12.1.3), SQL, PL-SQL, Oracle 10g, Forms & Reports, Putty, Workflow, WinSCP, UNIX.

Confidential, San Jose, CA

PL/SQL Developer/oracle Form & Reports Developer.

Responsibilities:

• Analyzed and mapped business processes before migrating to R12.
• Impact analysis of RICEW components and prepared test scripts to test them..
• Upgrade 11i Technical Components to R12.
• Developed custom Requisitions and Purchasing Documents Interface to import requisitions information from legacy system. Used SQL* Loader, PL/SQL packages to validate teh data before inserting into base tables.
• Customized teh Print Purchase Order Report based upon user requirements.
• Worked on auditing activities such taxation, Accounts payable.
• Handling audit of clients and preparing reports of teh same.
• Reviewing invoices and checking teh requests of teh same so as to avoid any errors.
• Matching invoices and setting up same for teh payments.
• Preparing accounts payable cheese and processing teh same through net transfers.
• Reconciliation of teh payments and monitor accounts to ensure payments are made up to date and resolve any discrepancies.
• Migrated Business Area/Item Classes from one Instance to teh other in Discover 10g.
• Customizes teh pick and ship Delivery Option Using Form Personalization.
• Helped team documents such as MD050, MD070, MD120.
• Developed Reports Like Weekly reports, Daily Stock status reports, Weekly, Monthly.
• Developed Conversion script in Inventory module by using SQL*Loader, PL/SQL stored procedure, UNIX and Oracle standard API.
• Developed XML Publisher Reports Based on PL/SQL Stored Procedures to provide different output formats.
• Developed interface program and conversion program to load teh legacy data into AP INVOICES INTERFACE and AP INVOICE LINES INTERFACE tables.
• Crated customer aging report using customer invoice date.
• Helped customers to get reports in excel formats like customer aging report using XML publisher.

Environment: Oracle 9i, Oracle APPS-11i (PA, OGA), XML Publisher Report, TOAD.

Confidential, WI

Oracle Developer

Responsibilities:

• Performed daily monitoring of databases for availability and performance metrics.
• Reviewed log files from overnight and batch processes for significant events.
• Review SQL and PL/SQL for Production and sub-environments to ensure accuracy and optimization.
• Created Database tables, views and indexes.
• Creation of functions using PL/SQL.
• Creation of DML, DDL, DRL, TCL, DCL using SQL.
• Creation of Joins, Equijoin, Sub quires in SQL.
• Invoices are imported from teh Excel sheets to teh Oracle Database using SQL * LOADER
• Developed Reports as per client requirement.
• Involved in creation of SQL scripts.
• Involved in creating customer invoice reports.
• Creation of Packages, Stored Procedures & triggers using PL/SQL.
• Load teh data using SQL*Loader.
• Prepare teh unit test cases and responsible for execution.
• Review enhancements made by peers in teh team.
• Preparing High level and Low level design documents.

Environment: Oracle 9i, Developer 2000, SQL, XML, Windows NT 4.0, MS Access 2000.

Oracle Developer

Responsibilities:

• Developed reports using Oracle Discoverer (D2k) by creating EUL, Business area, custom views, new folders, custom folders, complex folders, conditions, joins and building discoverer workbooks.
• Participated in analysis, design, development, testing, and implementation of various financial Systems using Oracle 11i, Developer 2000 and PL/SQL.
• Coordinated between management, users and technical teams forRequirement Gathering.
• Worked wif various functional experts to implement their functional noledge into business rules in turn as working code modules like procedures and functions.
• Imported data from numerous sources for companies acquired by client, into Oracle AR.
• Work closely wif functional and development team to implement Oracle Financial Modules (AP, GL, AR), create Applications Users, Responsibilities, Report Sets, Menu and Functions.
• Involved in generation of custom XML reports incorporating client’s emblems and other JPEG images for teh fancy and quality facilitated reports.
• Upgraded of Custom Reports in payables. EMP ADD/BANK Exception report-(list teh employees who are vendors and got incomplete address or bank details), Vendor information report (display vendor information), AP extract summary report (display sum of amount by vendor & account).
• Used AOL & Sys Admin to register new reports, forms, functions, menus and created validation sets, request sets and concurrent programs.
• Developed new and modified existing packages, Database triggers, stored procedure and other code modules using PL/SQL in support of business requirements.
• Developed Shell Scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
• Defined database structure, mapping and transformation logic. Creation of External Table scripts for loading teh data from source for ETL (Extracting Transforming and Loading) Jobs.
• Used SQL *Loader to load teh data.
• Generated UNIX shell scripts for automating daily load processes.
• Developed Pre and Post SQL scripts, PL/SQL stored procedures and functions.
• Used TOAD and SQL navigator extensively.

Environment: SQL Developer, UNIX, SQL, AOL, PL/SQL, XML, Forms 6i/10g, Discoverer (d2k), SQL*Loader, Reports 6i/10g, TOAD.