We provide IT Staff Augmentation Services!

Oracle Consultant Resume

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,NCNov’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,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,NJ Jan’ 2006 to Dec’2006 Project Panasonic 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

Hire Now