We provide IT Staff Augmentation Services!

Oracle Applications (erp) Consultant Resume

Raleigh, NC

Professional Summary:

  • 8 years of extensive IT experience in development, implementation and support of ERP and Custom Applications.
  • E-Business Suite R12 Financials Certified Expert Consultant(OCP) ,Receivables.
  • As a Techno-Functional consultant, 5 years experience in Oracle Applications (Releases 11.5.5/11.5.6/11.5.8/11.5.9/11.5.10 and R12).
  • Good domain knowledge on Distribution, Manufacturing and Financial industries (Labeling, Engineering, Water, Electronic industries). Worked on Oracle Application Implementations at Clients Accenture(NC State E-Procurement),SATO, Panasonic, SAJH, Beyonics Cannon,BTVL and MCH.
  • Strong Techno-Functional experience in Order to Cash Process, P2P ,SCM and more Technical experience in all Financial, Manufacturing and Distribution modules in EBS and Knowledge on OTL and HRMS Modules.
  • Effective in the identification of problem areas, development of alternatives and implementation of creative business solutions.
  • Responsible in the area of analysis, design, development, testing, implementation and production support of complex applications Experience in Oracle e-Business suite applications release 11i (GL,AP,AR,PA(Costing ,Billing, Projects & Resource Management) PO,CM,INV,OM(Order,Shipping,Advance Pricing& Quoting),BOM,WIP,WMS,FA,CM,SCM(Advanced),OCM(TCA,OCO) and CRM(Service Contract and CSF,Field Services,) Modules).
  • Knowledge on Retek Distribution Management(RDM)
  • Expertise in using AOL and System Administrator by creating the user and responsibilities which are required.
  • Having Sound understanding of all phases of end to end ERP implementation such as Business Process Studies, Gap Analysis with respect to as is & To Be, Design, Development and Testing and Go Live and Maintenance.
  • Working with Super Users, End Users and Consultants for RICEW development to resolve business needs.
  • Strong experience and expertise in Oracle Application RICEW (Reports, Interfaces, Conversions, Extensions,Work flow), EDI, FSG Reports and API's development using the Development Suite/tools (like Oracle Forms, Oracle Reports,Oracle Applications Express(Oracle APEX),Jdeveloper(OAF), PL/SQL, Work Flow Builder2.6, OBI/XML Publisher, SQL*Loader, Discoverer, SQL*Plus etc).
  • Experience in Performance tuning of SQL queries using Hints, Indexing and Partitioning of tables.
  • Strong experience and expertise in OBI/XML Publisher and Form Personalization's
  • Worked with API's and Conversions like Item Master, BOM, Item-Category, On-hand quantity, Journal Import,Customer,AP Invoice, Sales Order etc)
  • Worked with language based Reports like Spanish, German, Polish, Dutch etc.
  • Thorough knowledge in AIM Methodology, Implementation and Post-Production Support Procedures.
  • Experience working with the UNIX Shell scripts on various platforms.
  • Experience on TAR's (Service Requests) with Oracle on Demand Team and End users.
  • Worked extensively in team oriented environment with strong Trouble-shooting, Analytical, interpersonal and communication skills.

TECHNICAL SKILLS

Oracle Applications: Oracle Applications Release 11i and R12(General Ledger, Accounts Receivables, Accounts Payables, Cash Management, Oracle Assets, Oracle Purchasing, Oracle Inventory, Oracle Order Entry, Bill of materials, Work in Process,Projects,Contracts,Services,iPayment,iStore,iExpenses,iPayments,AOL,System Administration, XML Publisher and Alerts) Languages: SQL, PL/SQL, Java, C/C++, UNIX Shell Scripting, COBOL, Pascal DATABASES: ORACLE 10g/9i/8i/7.x, Fox Pro, Ms-Access GUI Tools: Oracle Reports 6i, Discoverer 4i, Forms 6i Other Tools: SQL*Loader, Work flow Builder 2.6, Rational Tools, TOAD, SQL Navigator Web Technologies: J2EE, EJB 2.0, Servlets, Java Script, VB Script, JSP, ASP, XML, HTML, IIS OS- Platforms: DOS, Windows NT/95/98/2000, AIX, UNIX, LINUX

CERTIFICATION E-Business Suite R12 Financials Certified Expert Consultant ,Receivables.(OCP)

EDUCATION

  • Masters in Computer Applications
  • Bachelor of Computer Science

Confidential, Raleigh, NC Nov'2008 to Aug'2009 Project NC State Govt. E-Procurement Oracle Applications (ERP) Consultant Oracle Applications : An Enhancements & Support of Oracle Applications Accounts Receivables at NC State Govt. E-Procurement Responsibilities

  • Working as a AR Module Expert Resource at Client site to Review and Define Functional Setups, Development and Enhancements various customizations of Oracle Receivables Module.
  • Worked in preparation of AIM (Application Implementation Methodology) documents for Functional and Technical specifications of Interfaces and Reports customizations.
  • Setup and Created New Aging Report and setup based on client requirements in Collections Work bench ,Create Auto adjustments Setups and Auto Invoice Setups.
  • Created New DFF's and Lookups In Oracle Receivables Module.
  • Resolved functional issues on Transaction Workbench,Receipt's Workbench and Collections Workbench in Oracle Receivables module and resolved production issues.
  • Resolved Monthly Billing Issues in Invoice(Transaction) ,Customer and Receipt Related Issue.
  • Developed New Customized Auto Lock box Interface Program and Related Setup based on client requirement .
  • Developed New Reports Using OBI Publisher.
  • Developed Customized Consolidated Billing Invoice Report and Mass Send Consolidated Billing invoice Report with e-mail&Fax Future using Oracle Report Builder 6i and FOB and Customization on Standard Oracle Receivables Reports.
  • Support For Production issues using Bugzilla maintain version controls using Perforce(P4) and Created Ad-hoc Reports.

Environment: Oracle Applications R12 (Account Receivables Module), Oracle 10g, Reports 6i, Ariba Buyer 8.2,TOAD, Sun Solaris SPARC (32-bit) and Windows NT

Confidential, Charlotte, NC Mar' 2007 to Aug'2008 Project SATO International Oracle Applications (ERP) Consultant Oracle Applications Implementation: An implementation of Oracle Applications General Ledger, Fixed Assets, Accounts Receivables ,Advanced Collections,i Receivables,i Payments,iExpenses,iCollections ,Cash Management, Accounts Payables, Projects, OCM (TCA, OCO), O2C, Purchase Order, Order Management, Inventory, BOM, WIP,OTM, WMS, MSCA modules, CRM Modules and Field Services at SATO America, SATO Germany and SATO Iberia Responsibilities

  • Working as a Techno-Functional Resource at Client site to develop and implement & Enhancements various customization of Financial, Manufacturing, Distribution and CRM Modules
  • Worked in preparation of AIM (Application Implementation Methodology) documents for Functional and Technical specifications of Conversions, Interfaces, Reports and Forms customizations.
  • Implemented Order to Cash modules: OM, Inventory, Warehouse, Purchasing, Receiving and module integrations with OM GL, AP, AR, CM,INV with in EBS System.
  • Integrating iPayments ,iCollections,iExpenses and iRecevables with Oracle Payables,Advanced Collections and Oracle Receivable.
  • Worked in Creating Value sets, DFF's, Lookups, Customer Design using TCA ,Dunning Letters setups and Statement of account Setups customizations in Dunning letters and Statement of accounts.
  • Involved in implementing Inventory, WSH, BOM, WIP, Purchasing, Order Management and Receivables modules in Multi-Org set up including designing, testing and maintaining interfaces from legacy system..
  • Developed language based Reports (Spanish, German, Polish, Denmark, Nether land, Dutch, Italian…Etc) Using Oracle Report Builder ,APEX and Oracle Form Builder in Financial, Manufacturing, Distribution, CRM (Services, Contracts and CSF) Modules.
  • Developed New Reports and Customizations in XML Based reports using OBI/XML Publisher.
  • Customized Standard Forms Using Oracle Applications Frame Work(OAF)
  • Worked in Form Personalization's in Distribution, manufacturing and CRM Modules
  • Developed AP invoice import Interface to import invoices to Accounts Payables
  • Developed Item Master Conversion and Sales order Conversions
  • Developed interface program to upload Bills of materials (BOM) Details.
  • Importing legacy data through journal import and Working with Budget upload interface using SQL * Loader.
  • Data Converted for Matched Open AP invoices and Open AP invoices in Accounts Payables
  • Developed a Control File to load Customer Information from flat file into interim tables using SQL*Loader then validated data and written customized program to insert data into the interface table using Customer Interface Program.
  • Loaded work flows, replace seeded work flows, ran work flow maintenance scripts against database
  • Customized MSCA Label Bar code For Multi language Environment and Developed Scripts using PL/SQL.
  • Have done customizations for Order Header (OEOH) and Order Line (OEOL) work flows
  • Developed New Ad hoc Reports and FSG Reports based on user requirements.
  • Developed Language based Unix shell Scripts.
  • PL/SQL program scripts, related reports and forms, unit level and user acceptance testing.
  • Global support For production issues using check in and checkout using rational tools like Clear case and Clear quest

Environment: Oracle Applications 11.5.10 (General Ledger, Fixed Assets, Accounts Payables, Projects, Accounts Receivables, OCM (TCA, OCO), Order Management, Purchase Order, Inventory, Warehouse, BOM, WIP, MSCA,CRM(Field Services, Services and Contract) Modules), Oracle 9i, Forms 6i, Reports 6i,Work flow builder2.6, Discoverer4i, Oracle 9iAS, TOAD, SQL Loader 8.0, Sun Solaris 5.8(LINUX) and Windows NT

Confidential, New Jersey, NJ Jan' 2006 to Dec'2006 Project Panasonic Oracle Applications (ERP) Consultant Oracle Applications Implementation: An implementation of Oracle Applications General Ledger, Accounts Receivables, Accounts Payables, Purchase Order, Order Management, Order Management, BOM, WIP,WMS, Inventory and CRM (contract, Services, Field Services) modules at Panasonic Responsibilities

  • Worked as a Techno-Functional Resource at Client site to develop and implement various customization of Financial & Manufacturing modules
  • Preparation of functional and technical documents based on AIM (Application Implementation Methodology), discussions with the client regarding the proposed solution, PL/SQL programs scripts, related Reports, Forms, Interfaces, Conversions, unit level and user acceptance testing.
  • Worked for Procure to Pay Process and Order to Cash Processes and module integrations with AR, GL, AP, OM, WMS and INV with in EBS System.
  • Developed AP invoice import Interface to import invoices to Accounts Payables
  • Developed Customer API in Oracle Receivables.
  • Developed inbound interface to upload the Shipping Instruction details from the legacy to Oracle Applications base tables
  • Developed item Import conversion and On-hand Quantity Conversion.
  • Purchase order Inbound EDI Interface (850/Orders).
  • Developed Outbound interface to upload the Shipping Instruction details from the Base Tables to Excel files
  • Developed New Reports and Customizations in standard reports using Oracle Reports,APEX &XML Publisher in Distribution, Finance, Manufacturing and CRM (Services, Contract, and Field Service) Modules.
  • Worked in Form Personalization's in Distribution, manufacturing Modules.
  • Developed extensive modifications to PO Account Generator using work flow builder.
  • Developed New Forms and customizations in standard forms based on user requirements using Oracle Form Builder and OA Frame work in Manufacturing and distribution Modules.
  • Customization Of Self-Service Web Applications Using OA Frame Work.
  • PL/SQL program scripts, related reports and forms, unit level and user acceptance testing.
  • Registering/defining of custom applications, tables, forms, reports, concurrent requests standard report submission, profile options, defining of application users and responsibilities.

Environment: Oracle Applications 11.5.10 (General Ledger, Accounts Payables, Accounts Receivables, Order Management, Purchase Order,BOM,WIP,Inventory), Oracle 9i, Forms 6i, Reports 6i, Discoverer4i, Oracle 9iAS, TOAD, SQL Loader 8.0, Sun Solaris 5.8 and Windows NT

Confidential,Sept' 2004 to Oct' 2005 Project Canon Oracle Applications (ERP) Consultant Oracle Applications Implementation: An implementation of Oracle Applications General Ledger, Fixed Assets, Accounts Payables, Projects, Purchase Order,iSuppliers,Accounts Receivables, Order Management, BOM, WIP and Inventory modules at Cannon Responsibilities

  • Worked as a Techno-Functional Resource at Client site to develop and implement various customization of Financial ,Manufacturing & Distribution modules
  • Performed various setup steps, customizations and developments in GL, AP, PO, PA, AR, FA, OM, O2C BOM, WIP and INV modules.
  • Defining Suppliers, Approval Groups, Distribution sets and quote analysis in Accounts Payables
  • Uploaded the values for all Value sets using Data load in set up steps of General Ledger, Fixed Assets, Accounts Payables ,Order Management, Purchase Order,BOM,WIP and Inventory modules including System Administration set ups.
  • Preparation of AIM (Application Implementation Methodology) Documents for Functional and Technical specifications of Customizations, Interfaces and Conversions.
  • Worked on Order to Cash life cycle implementation and integrating modules.
  • Developed sales order conversions using order import interface .
  • Analyze, Design and Develop Accounts Receivables Auto Invoice Interface. This involved data mapping and developing Conversion programs for converting Invoices, Credit Memos, Debit memos using PL/SQL script.
  • Developed Data migration Scripts like BOM, Item Category, On-hand Quantity and PL/SQL Stored procedures.
  • Customization and Development of reports using Oracle Reports 6i,APEX and forms custom modifications using Forms 6i in all Financial, Manufacturing and Distribution modules.
  • The new product was developed using Oracle Applications Framework (OAF). Primary need of this rewrite was to have a common look and feel for all Oracle self-service products.
  • Developed extensive modifications to AP Account Generator using Work flow Builder.
  • Developed Ad-hoc reports and FSG Reports based on user Requirements.
  • Registering/defining of custom applications, tables, forms, reports, concurrent requests standard report submission, profile options, defining of application users and responsibilities.

Environment: Oracle Applications 11.5.9 (General Ledger, Accounts Payables, Projects, Purchase Order, Account Receivables, Fixed Assets, Order Management,BOM,WIP and Inventory), Oracle 9i, Forms 6i, Reports 6i, Discoverer4i, Oracle 9iAS, TOAD, SQL Loader 8.0, Sun Solaris 5.8 and Windows NT

Confidential, Singapore Aug' 2003 to July' 2004 Project Beyonics Oracle Applications (ERP) Consultant Oracle Applications Implementation: An implementation of Oracle Applications General Ledger, Accounts Receivables, Accounts ,Cash Management ,Payables, Fixed Assets, Cash Management, Order Management, Projects, BOM, WIP and Inventory modules. Responsibilities

  • Worked as a Technical Resource at Client site to develop and enhancements in various customization of Financial & Manufacturing modules
  • Preparation of AIM (Application Implementation Methodology) Documents for Functional and Technical specifications of Customizations, Interfaces and Conversions
  • Developed Purchase order detail report, AP invoice detail report, Credit memo Invoice report, Blanket Purchase Order report, Item average report, Sales order acknowledgment report, User responsibility report, Purchasing requisition report and Inventory item cost report using Oracle Report Builder 6i.
  • Developed Projects budgets, Projects Expenditures, Projects revenue and invoices, Purchasing views using Discoverer 4i
  • Developed AP invoice import Interface to import invoices to Accounts Payables
  • Importing legacy data through journal import and Working with Budget upload interface using SQL * Loader.
  • Data Converted for Matched Open AP invoices and Open AP invoices in Accounts Payables
  • Developed a Control File to load Customer Information from flat file into interim tables using SQL*Loader then validated data and written customized program to insert data into the interface table using Customer Interface Program.
  • Developed Data migration Scripts like Item master, Open PO and PL/SQL Stored procedures
  • Processing of Bank Receipts using Auto Lock box Interface
  • Performed activities like preparation of functional and technical documents, discussions with the client regarding the proposed solution, PL/SQL programs scripts, related reports and forms, unit level and user acceptance testing.
  • Worked in analyzing the legacy data and creation of tables as per specifications.

Environment: Oracle Applications 11.5.9 (General Ledger, Accounts Receivables, Accounts Payables, Projects, Fixed Assets, Cash Management, Order Management, Projects, BOM,WIP and Inventory), Oracle 9i, Forms 6i, Reports 6i, Discoverer4i, Oracle 9iAS, TOAD, Rational Tools, SQL Loader 8.0, AIX and Windows NT

Confidential, Johor Baharu, Malaysia. June' 2002 to July'2003 Project SAJH Oracle Applications (ERP) Consultant Oracle Applications Implementation: An implementation of Oracle Applications General Ledger, Accounts Receivables, Accounts Payables, Fixed Assets, Cash Management, Purchase Order and Oracle Projects modules at Syarikat Air Johor Holdings. Responsibilities

  • Worked as a Techno Functional Resource at Client site to develop and implement various customizations of Financial modules.
  • Preparation of AIM (Application Implementation Methodology) documents for Functional and Technical specifications of reports and forms customizations and Interfaces
  • Preparation of functional and technical documents, discussions with the client regarding the proposed solution, PL/SQL program scripts, related reports and forms, unit level and user acceptance testing.
  • Developed Cash flow summary report, Cash flow detail report, PA_rev_monthly report, PA_rev_monthly_budget report, Inventory aging report, Receipt Summary report, Billing history report, Asset summary by category report and Asset register report.
  • Customized Asset addition by cost summary report, Asset category report, Asset retirement report, Asset additions report, Annual additions report, AR_Inv_Report and AR Transaction register report
  • Developed custom form using forms 6i for AP Invoice Import Interface
  • Developed Purchase Order inbound interface to upload the Purchase Orders details from the legacy to Oracle Applications base tables
  • Developed an Invoice outbound interface to extract all the AP invoice information from the Account Payables base tables into the flat files
  • Developed AP invoice import Interface to import invoices to Accounts Payables
  • Developed PO Requisition Import Interface to import Requisitions to oracle Purchasing.
  • Registering/defining of custom applications, tables, forms, reports, concurrent requests standard report submission, profile options, defining of application users and responsibilities.

Environment: Oracle Applications 11.5.8 (General Ledger, Accounts Payables, Oracle Projects, Accounts Receivables, Fixed Assets, Purchase Order and Cash Management), Oracle 8i, Forms 6i, Reports 6i, Discoverer4i, TOAD, SQL Loader, Sun Solaris and Windows NT

Confidential. June' 2001 to May'2002 Project BTVL Oracle Applications Implementation Oracle Applications (ERP) Consultant Oracle Applications Implementation: An implementation of Oracle Applications General Ledger, Accounts Receivables, Accounts Payables, Fixed Assets, Cash Management modules at Bharti Tele Ventures Limited. Responsibilities

  • Working as a Technical Resource at off-shore to Support and implement various customization of Financial modules
  • Setting up of set of books by developing Chart of Accounts, Account Combinations, Cross Validation Rules, Assigning SOB's to Responsibilities, Defining value sets, descriptive flex fields, Key flex field structure with roll up groups, summary accounts, functional currency, calendar and other related setups using Data Load 4.3.
  • In Fixed assets setting up of Asset Categories, Asset Keys, Locations, Fiscal Years, Book Controls, Calendars, Prorate Conventions, Depreciation Methods, Bonus rules, Ceilings and Security.
  • Defining Suppliers, Approval Groups, Distribution sets and quote analysis in Accounts Payables
  • Uploaded the values for all Value sets using Data load in set up steps of General Ledger, Fixed Assets, Accounts Payables and Cash Management modules including System Administration set ups.
  • Developed New Reports using Oracle Reports6i and Customized Standard Reports based on user requirements.
  • Developed new forms using oracle form builder6i.
  • Registering/defining of custom applications, tables, forms, reports, concurrent requests standard report submission, profile options, defining of application users and responsibilities.

Environment: Oracle Applications 11.5.6 (General Ledger, Accounts Payables, Accounts Receivables, Fixed Assets and Cash Management), Oracle 8i, Forms 6i, Reports 6i, Discoverer4i, TOAD, SQL Loader, Sun Solaris and Windows NT

Confidential, Hyderabad Feb' 2001 to June' 2001 Project MCH Technical Consultant Citizen Oriented Administration of Municipalities: This project is developed for the e-Seva facilities of all Municipalities in Andra Pradesh. This system contains the web enabling database management, Session management, and Roles & Responsibilities management for various dignitaries in municipalities. This package is developed using Oracle and Oracle Developer suit for designing forms and generating reports. Responsibilities

  • Worked as a Project Trainee in the Organization
  • Preliminary investigation of the user requirements
  • Analysis of the requirements and design of the system
  • Designing of the database and Normalizing tables
  • Developed forms and reports using developer 6i and PL/SQL

Environment: Oracle, Developer 6i, PL/SQL and Windows NT

Hire Now