SUMMARY

• A distinguished IT professional with 8+ years of Professional experience on Oracle Applications as a Technical consultant in Oracle ERP Application (R12, 11i)
• Worked on System Study, Design, Development, and Post implementation maintenance and support of Oracle Applications E - Business Suite.
• Outstanding Technical knowledge 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), Supply Chain Management (SCM) Manufacturing (INV-Inventory, WIP-Work in Progress, BOM-Bills of Materials), Install Base, Service Contracts, iExpenses, iProcurement and AOL (Application Object Library).
• Extensive experience in designing, developing and testing the RICE components (Reports, Interfaces, Conversions, Extensions) as per Oracle Standards.
• Main focus on Implementation, Upgrade, Support and tuning of Oracle Financials, Oracle Manufacturing and Oracle Purchasing, Order Management and Supply Chain modules.
• Experienced in ERP Applications & Client Server Technologies, along with Development, Testing, Support, Upgrade and Tuning of Oracle Financials, Oracle Manufacturing, Oracle Purchasing, Order Management and Sales.
• Experience in all phases of the Software Development Life Cycle (SDLC) in an ERP environment.
• Involved inrequirement gathering, design and development ofcustom applicationsinOracle Applications Framework(OAF)environment.
• Strong implementation knowledge of O2C (Order to Cash), P2P (Procure to Pay) and Drop Ship end to end Cycles.
• Excellent skills in SQL, PL/SQL, Developer 6i/2000 (Oracle Forms and Reports), Discoverer Reports
• Created and maintained Database Objects like Tables, Views, Indexes, Constraints, Sequence, Synonyms, Database link, Roles and privileges.
• Designed Reports based upon specifications and also determined reporting needs based upon specifications.
• Hands on experience in implementing RICE (Oracle Reports 6i/Forms 6i, Interfaces, Conversions, Extensions) components, workflows, Oracle Alerts, Lookups, OA Framework (OAF), XML Publisher Reports.
• Involved in Oracle Application Framework (OAF) applications,customization ofOAF pages, extension and creation of new OAF pages in JDeveloper 9i and 10g environment.
• Extensive experience in design, development, customization and implementation of various business applications in different platforms using Client-Server Technologies.
• Created a lot of Complex, Optimized data queries and performed constant QA checks.
• Hands on experience in using various Oracle technologies to effectively implement an end-to-end solution to an organization's strategic goals and objectives including: Oracle 11i E-Business Suite, Oracle Discoverer, Oracle Application Server and Oracle PL/SQL and SQL and Oracle RDBMS, Oracle Developer (Oracle Forms and Reports Developer)
• Possess good expertise in developing programs using SQL*loader, Toad and PL/SQL procedures to transfer data from legacy systems with knowledge in Unix Shell Scripting.
• Good Knowledge of Multi organization Access control (MOAC) architecture and understanding of MOAC Impact on custom programs development like report, forms, and workflow PL/SQL packages.
• Experience in development of concurrent programs, customization and modifications of reports.
• Possess good project management skills and also have lead in many projects.
• Strong familiarity with AIM methodology in creating BRD, MD-50, MD-70, MD-120 and also testing documents throughout multiple Projects.
• Knowledge and Experience of TCA (Trading Community Architecture).
• Expertise in developing custom reports in XML Publisher.
• Demonstrated ability to identify root causes/ debugging of problems and troubleshoot, considering both long and short-term impact of proposed solutions and developed workable solutions
• Onsite coordination experience and work with the offshore team to knowledge transfer and development support.
• Excellent verbal and written communication skills with leadership qualities, analytical and problem solving skills and open to innovative ideas to develop a creative solution for challenging client needs.
• Highly efficient in working under pressure with focus on meeting deadlines on top priority. Comfortable working in a team or as an individual when required.

TECHNICAL SKILLS

ERP: Oracle E-Business Suite Versions 12i/ 11.5.10/11.0.3

Modules: Order Management (OM), Inventory(INV), Bills Of Materials(BOM), Account Receivables(AR),Purchase Order(PO),Fixed Assets(FA), Account Payables(AP),General Ledger(GL), Cash Management (CM), Application Object Library(AOL), Work In Process (WIP), Material Resource Planning (MRP), Flex fields, TCA, CRM, Service Contracts, Service Fields, SYSADMIN, INSTALLBASETools Toad, SQL * Loader, PL/SQL Developer, Discoverer, Data LoaderBI/XML Publisher, Load Runner

GUI: Developer 6i, Developer 2000, Forms 6i/10g/11g, Reports 6i/10g/11g, ADF and OAF

Programming Languages: SQL, PL/SQL, C, C++, Java, HTML5, PHP, UNIX Shell Scripting

Database: Oracle 9i/10g/11g, Microsoft SQL Server 2010, MS Access

Operating Systems: Windows 98/2000/NT/XP/7/8, UNIX (Solaris, HP-UX), Linux.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Oracle E-business Technical Consultant

Responsibilities:

• Worked on various financial modules (AP-Accounts Payables, PO-Purchase order, GL-General Ledger, OM -Order Management and AR-Accounts Receivables).
• Worked on Development, Unit Testing, Implementation and Documentation of Claims & Incentives, OM to TDW Projects and AP, AR, OM Oracle E-business Modules.
• Customized MODULES AP, AR & GL, FA in Multi - Org environment.
• Migrated AP Invoice interface to load data from legacy system to AP interface tables.
• Loaded the vendor’s information from the legacy system to oracle Purchasing. Developed a PO interface to generate Purchase Orders through an interface conversion program as per the data received from Legacy System.
• Involved in numerous requirement gatherings, designing, documenting and unit testing of various RICE components.
• Imported new, changed and completed sales orders from legacy system to oracle using order import (order management open interface).
• Migrated custom interfaces on the Oracle AR and Oracle AP from oracle 11i to R12.
• Worked with AP Team to reconcile AP with General Ledger by running Accounts Payable Trail Balance report, Posted invoice register report, posted payment register report and Unaccounted Transaction report.
• Imported Open Payables Invoices from legacy system into Oracle AP using Ap-Invoices-Interface and Ap-Invoice-Lines-Interface tables.
• Worked on the Budget Upload Open Interface to load the data from legacy systems to the GL-Budget-Interface table using SQL*Loader.
• Worked on the Customization of PO Account Generator workflow depending on the auto accounting rules set by the client for charge, accrual and variance accounts for standard purchase orders in PO and IProcurement.
• Worked on the Customization of PO Requisition Account Generator Workflows depending on the auto accounting rules set by the client for charge, accrual and variance accounts for standard purchase orders in PO and Iprocurement.
• Troubleshooting of the Order Management (OM) and Inventory (INV) modules within Oracle Applications.
• Worked onrounding customizationsof dollar amount in iExpense usingOAF.This involves customizing and extending controllerCO andentity objectEO.
• Worked on Oracle Order Import API to validate and load the PO information to the interface tables.
• Involved in Requirement Analysis, Design and Develop custom applications inOAF. This involves analyzingMD50(Functional Spec) and then writingMD70(Technical Spec).
• Modified Inventory item Locator report, Sub inventory quantities report, Receiving Transactions Register report and many more.
• Develop AP/AR/GL/PO reports using discoverer which include the following Daily Deposit Cash reports, GL Balance Sheet Details reportsAR Receivable Balances Report, Med flow Credit Memo details ReportAP Balance sheet details report
• Developed Business Areas, Custom folders, Item classes, Hierarchies in Discoverer Administration Edition
• Modified Workbooks based on the Custom Folders with parameters, cascading parameters, conditions, calculations using Discoverer Plus and Discoverer Desktop.
• Involved in Performance tuning of the discoverer reports.
• Worked on Oracle Discoverer Admin for creating item classes, custom folders and parameterized reports for OM, AR, AP and PO modules.
• Developed reports for Order management, BOM modules.
• Development/modification of custom reports in purchasing and payables.
• Developed PL/SQL procedures to validate the data and insert the validate data into Oracle Standard interface tables.
• Gathered requirements, wrote functional (MD050) and technical (MD070) specifications, provided recommendations for user concerns and implement process and system modification.

Environment: Oracle Applications E-business R12/11.5.10, Reports 6i/10g/11g, SQL, PL/SQL of Oracle 9i/10g, PL/SQL on UNIX, Windows 2000/NT environment, Java, JSP, Forms 6i/10g/11g, Discoverer10g, XML/BI Publisher, Toad, SQL*Loader.

Confidential, Syracuse, GA

Oracle E-business Technical Consultant.

Responsibilities:

• Involved in the complete Order to Cash, Procure to pay cycle, Oracle Grants and Projects implementation.
• Involved in the development of SCM modules Oracle Inventory, Purchasing, and Order Management.
• Provided solution with delete reservations in Oracle Order Management (OM)
• Involved with the study of existing system, preparing the Technical design document to extract data from legacy system into Oracle Applications E-business open interface tables.
• Worked on the XML reports like Pick slip report, Packing slip report, Sales Order Acknowledgement report, Invoice reports, quotation reports, Purchase Order reports and Discoverer reports to make sure they are upgraded from 11 to R12 and displaying the same output as in 11.
• Involved in the Order management -Landed Costing Custom module-Inventory-Account Payable and Purchase-Landed Costing Custom Module-inventory-Account Payable.
• Key user Training for the landed Costing custom Module and Integration with Oracle Purchase, Inventory, Order Management and Account payable.
• Import Work Orders from various legacy systems to Oracle Enterprise Asset Management and Oracle Order Management (OM) system.
• Migrated Order Management, Inventory, Receivables queries to compare summary information of the standard and custom reports from 11i to R12.
• Extract program for Open orders information (Requisitions, Purchase orders, Internal Sales orders, Move orders information which are not materialized) and corresponding stock amounts program, which shows the costing information for those open orders in the SCM modules Purchasing (PO) and Order Management (OM).
• Replaced the RA customer view with AR customer when the PO Close Process has been upgraded to R12.
• Designed and Developed and Outbound Interface to send the Order details for a given customer
• Interacted with business owners, functional consultants and subject matter experts effectively to understand business requirements, functional designs, process flow and data flow.
• Involved in PO Requisition Import program to import requisitions into oracle applications.
• Involved in Standard PO Import Program to import purchase orders into oracle applications.
• Assisted functional team to identify the setups required for implementing the oracle Inventory, AR, OM, Shipping modules.
• Developed Inventory “Items Conversion” & “Items Category Conversion program” to load Inventory data from into interface tables.
• Customized the AR Invoice, Sales Tax Reports in Receivables using Reports 6i and XML Publisher.
• Converted Fixed Assets Data from Legacy System to Mass Additions Table using SQL Loader and developed programs for Conversion of Tax Data from flat Files to Tax Interface Tables.
• Extensively utilized the Application Object Library (AOL) to Register PL/SQL Procedures, forms and reports.
• Customized the Print Purchase Order Report based upon user requirements and added bitmap image of company logo to the report.
• Wrote UNIX shell scripts to automate the conversion from the legacy systems and also to ftp the files to the legacy systems and to send error message notifications to the user groups.
• Worked closely with the team responsible for Setups and Customization of self service modules like iProcurements, iExpenses, iPayment, iReceivables, Modified XSL, JSP, XML files for additional functionality and GUI enhancement.
• Updated MD50, MD70 and MD120 documents according to the R12.

Environment: Oracle Apps E-business 11.5.8/10.2, GL, AP, AR, PO, OM, Oracle 9i, Pl/SQL, SQL*Plus, SQL*Loader, Reports 6i, Forms 6i, XML Publisher, Discoverer, Oracle Configurator, Shell Scripting, TOAD, PVCS, UNIX.

Confidential, Columbus, Ohio

Oracle E-business Technical Consultant.

Responsibilities:

• Worked as an Oracle Technical Consultant in Migration project.
• Implemented multi-org financial systems using Oracle E-Business modules such as GL, AR, AP, and FA.
• Worked on SQL*Loader scripts to migrate the invoice data from the flat files and populate the staging tables before implementing auto invoice interface.
• Worked on various financial modules (AP-Accounts Payables, PO-Purchase order, GL-General Ledger, OM -Order Management and AR-Accounts Receivables).
• Designed and Written Documents for Technical Designs (MD070), Unit Test Plan and Implementation Guide for importing Customer Calls Information from legacy Customer Notes Information into Oracle AR
• Developed PL/SQL procedures, functions and packages for validating the invoice data before importing it into Account Receivables interface tables.
• Designed and developed the customer creation process using TCA API’s, when the customers from SFDC are consumed.
• Developed interfaces for Bank Reconciliation and Positive Pay transactions through Oracle Cash Management.
• Worked on journal import interface program to import journal data from legacy system into GL base tables.
• Worked with GL tables, AR Interface, Customer Interface and GL interface (GL INTERFACE, GL BUDGET INTERFACE).
• Worked on Auto Lockbox Open interface for automatic processing of receipts in AR module.
• Migrated an Item Conversion to import legacy inventory item data into Oracle base tables.
• Involved in Open Transaction Interface to import transactions from legacy system to Oracle Inventory and set up Transaction Manager as background program to import validated data from interface table periodically.
• Conversion of Credit Card holders master data from legacy into Oracle AP for IExpenses.
• Created Alerts in Oracle IExpenses module.
• Customized the reports for Financial Module (GL, AP, and AR) using Report Builder.
• Migrated Order Management, Inventory, Receivables queries to compare summary information of the standard and custom reports from 11i to R12.
• Involved in migrating developed objects between instances. Developed custom shell scripts to create synonyms and grant necessary permissions for the objects which are being migrated into new instances.
• Registered customized reports and concurrent program/sets using System Administrator and Application Developer responsibilities.
• Worked on performance tuning of existing reports and PL/SQL programs.
• Developed customized reports using XML Publisher & Discoverer.
• Customized AR-CE Bank Reconciliation Batch Info Report.
• Developed/Converted most of the existing text reports to excel format usingXML/BI Publisher
• As per the company requirements, created and implementedXML/BI Publisherreports for different products likePO, APandGL.
• Customized Oracle standard reports like AP and AR Aging Reports, Open PO report and changed the output format to XML and created new templates for XML Publisher to display in pdf or excel format.
• Used the Totals/Subtotals/group/sort features of BI Publisher to make data intense operations happen at the template level.
• Developed Custom Reports such as PO Expediting Reports, PO Totals by months report and other reports to conclude the PO Requisition and PO facts per operating units using XML Publisher.
• Developed Summary Cash Requirement Report, Detailed Cash Requirements Report and Invoice Register Report using XML Publisher (BI Reports) Reporting Tool.
• Modified custom templates for the invoice reports by calling sub templates in XML/BI Publisher.
• Designed and developed Customer Invoice, Purchase Order Report using XML Publisher.
• Converted custom forms using Forms 6i in Installed base for global update of instance.
• Developed Forms, Menus, Object Libraries, and PL/SQL Library using Oracle Form Builder 6i.
• Customized sales order form using Form personalization.
• Developed Unix Shell scripts to automate repetitive database processes and maintained shell scripts.
• Documentation using AIM methodologies of MD50’s, MD70’s and MD120’s.

Environment: Oracle Applications E-business 11i, GL, AR, AP, PO, Reports 6i, PL/SQL, SQL*Loader, SQL*Plus, TOAD, Discoverer, SOA,UNIX, JDeveloper, Shell scripts

Confidential, NJ

Oracle E-business Technical Consultant

Responsibilities:

• Understanding the existing system and working in a Confidential ERP implementation project as an Oracle Applications Technical Consultant.
• Worked with the technical team while extracting non-Oracle data and Converting to Oracle with validations.
• Upgraded Oracle E-Business Suite from Release 11i to 12, and custom development activities after the upgrade.
• Designed & Developed AP Invoice Open Interface and AP Invoice Audit Report for the different Sources in Oracle Payables.
• Work with functional setups to create AP invoice sources, Accounting flex field, Chart of accounts.
• Implementation and Customization of MODULES AP, AR & GL, FA in Multi - Org environment.
• Responsible for creation of MD070s for AP Invoice import.
• Responsibilities included technical design, development and support for “Order to Cash” and “Procure to Pay” business processes.
• Developed an outbound interface to export GL data to third party systems, also inbound interfaces to import into GL by populating GL Interface Table.
• Customized and developed various reports to user community for day to day operational support in Receivables, General Ledger, Purchasing and Payables and Fixed Assets Module.
• Worked with the GL Journal Import, AP Invoices, AR Invoices, Item conversions.
• Using SQL*Loader loaded the data into staging table, Developed PL/SQL packages to validate the data and load into interface tables.
• Involved in Developed Advanced Shipment Notice (ASN) process and printing.
• Developed a custom layout XML format according to the user specifications and worked on incorporating it to the standard print Purchase Order and Invoice reports using XML Publisher (BI Publisher).
• 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 the interface table data into Oracle AR base tables.
• Created new custom reports in XML/BI Publisher and used Template, sub Template method for a creating single report with multiple Layouts
• Used the Totals/Subtotals/group/sort features of BI Publisher to make data intense operations happen at the template level
• Developed custom templates for the invoice reports by calling sub templates in XML/BI Publisher.
• Developed custom forms and reports to correct interface errors and send the error messages to legacy system owners.
• ADF Page design and development using Oracle ADF, BPM workspace 11g.
• Code review and checking ADF code standards.
• Extensively involved in developing Technical Design Documents (MD70) using Application Implementation Methodology (AIM).
• Developed new and customized existing Oracle and Discoverer reports as per the user request.
• Involved in testing existing FSG reports.
• Developed AIM Documentations for the components.
• Involved in Peer review and Unit testing.
• Involved in resolving daily business issues in Quick time.

Environment: Oracle Apps E-business 11i, Procure-2-Pay, Oracle 10g, Oracle R.I.C.E, Oracle A.I.M, Oracle SQL, Oracle PL/SQL, AP, GL, PO, AR, OM, INV, TCA, JDeveloper, TOAD, Discoverer, XML Publisher, SQL*Developer, Forms(6i), UNIX, Shell Scripting, WINDOWS XP.

Confidential

Oracle E-business Technical consultant

Responsibilities:

• Actively involved in full implementation of E-business suit including gathering the requirements from the user and understanding their business model.
• Worked on various financial modules (AP-Accounts Payables, PO-Purchase order, GL-General Ledger, OM -Order Management and AR-Accounts Receivables).
• Worked in getting the requirements from the users and involved in functional setups in financial modules.
• Defined the descriptive flex fields on Sales orders and Invoices to facilitate additional information.
• Support the users when loading AP Invoice and other payment activities like printing payment registers and checks.
• Involved in writing interface program to load the data from external systems into Oracle purchasing (PO) interface tables.
• Developed AP Invoice Conversion and vendors conversion programs.
• Customization of PO Approval workflow process to ensure the notification is send to next in hierarchy if the first approver doesn't respond using workflow builder and also to stop sending emails upon update of PO for second time onwards.
• Tuned customized application including reports and back end programs by using different application tuning techniques.
• Worked on items in Inventory.
• Imported Bills and Routings through BOM Interfaces.
• Developed Work Order Interface to import discrete job information into oracle apps base tables.
• Customized the PO entry form to ensure Revision field is not null when item is entered.
• Customized seeded reports as per the requirement like Customized the standard Purchase Requisition Status report in purchasing and scheduled payment report.
• Involved in generation of FSG reports according to the client requirement and consolidated automated financial statements using Financial Statement Generator (FSG).
• Defined request sets with concurrent programs to run in stages depending on the output generated by each request.
• Developed PL/SQL Packages, Procedures and Functions for validating the invoices and payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import program and populated the base tables.
• Created new reports and customized standard reports in PO such as Expected Receipts Report, Printed Requisitions Report and Purchase Order Detail Report.
• Develop AP/AR/GL/PO reports using discoverer which include the following PO requisition reportsAR sales profit report with cost of goodsGL Summary Report.
• Developed Interfaces for Oracle Applications modules, XML Publisher, Oracle Discoverer, OA Frame work etc in co-ordination with the functional consultants.
• Developed Documentation Templates such as Data Mapping, Functional, Technical and Testing like CV60, MD70 using AIM .

Environment: Oracle Applications E-business 11i, GL, AR, AP, PO, Reports 6i, PL/SQL, SQL*Loader, SQL*Plus, TOAD, UNIX, Shell scripts.

Confidential

Oracle Technical consultant

Responsibilities:

• Worked as an Oracle Technical Consultant in Confidential Telecommunications.
• Used SQL*Loader for import into custom tables and PL/SQL for complete validation of data and inserting into interface tables.
• As a Techno Consultant, responsible for Analysis, design, development, testing and implementation of customized Oracle ERP solutions for new implementations and upgrades
• Preparation of SQL *Loader Control Program and PL/SQL script with validation to upload data from flat file to oracle Applications base tables.
• Involved in the requirement gathering, analysis and design of the interfaces and reports.
• Developed new Custom Oracle 6i, SQL, PL/SQL Reports as per the business requirement.
• Preparing the MD070 Documents based on MD050 for each component.
• Developing Custom Interface Programs and XML Publisher reports.
• Extensively utilized the application object library to register SQL*LOADER programs, PL/SQL procedures, forms and reports.
• Create and define template and data definitions for Open Purchase Order report. Conditionally display company logo information based on run time parameters. Worked actively with the Reports Development Team in creation of specific customized reports according to user needs.
• Was primarily involved in the design and development of certain reports like Income Statement with Variance, AI (Annual Income) Budget Statement, Cumulative Balance Sheet (CBS) and Budget/Actual Report, CBS and Income Statement consolidated report.
• Developed various Form letter reports and Mailing list reports using Reports 6i.
• Customized Supplier Paid Invoice History Report, Supplier Merge Report, Supplier Audit Report, Chart of Account Detail Listing Report and Supplier Payment History Report in Account Payables using Oracle Reports 6i.
• Generated Inter Company Transaction Detail Report, Open-Debit Memo Report in General Ledger using Reports 6i.
• Worked with performance tuning tools like Explain Plan and TKPROF to improve the performance of various custom PL/SQL Packages developed.

Environment: UNIX Shell Scripting, Developer (Forms & reports 6i, XML publisher), PL/SQL, SQL*Loader, TOAD, Oracle Apps (OM, WSH, INV, BOM, WIP, PO, AR, GL).