ORACLE ERP Support Lead Techno Functional
Industrial Gases Co. LLC
Total years of experience :17 years, 9 Months
• Providing multiple levels of support on all the Modules both Functional and Technical.
• Implemented Inventory to Asset cycle.
• Workflow mailer has been configured and made to send workflow notifications through mail.
• Created system alerts in several modules for the smooth and user friendly process.
• Involving on the process extensions and customizations and customized several processes in various modules.
• Developed several XML Reports using XML Publisher for getting the report outputs in Excel, PDF and word formats.
• Successful in completed several projects in using Oracle Apps to the maximum level to reduce the user works.
• Got reward in accomplishing the project of linking Driver & Vehicle details with Delivery documents directly in Oracle and automated the generation of delivery ticket and gate pass.
• Attending on day today issues on ORACLE Apps.
• Involving in month end processes opens & closes the periods.
• Handling Setup level issues and SR maintenance.
• Preparing various types of Financial reports using FSG( Financial Statement Generator)
• Trained SCM & Finance users to be thorough on their process and prepared several user guides using UPK( User Productivity Kit)
• Extensively uses the Form Personalization in various forms as per user requirement for security and easy use.
• Purchasing Hierarchies have been defined using Approval Management Engine.
• Developed Several Reports using Oracle Reports Builder and registered them in ORACLE.
• Providing multiple levels of support on the Financial Modules.
• Providing Second level Support on SCM Modules.
• Implemented Inventory to Asset cycle.
• Succeeded in implementing a roll out project on ORACLE Property manager.
• Involving on the process extensions and customizations.
• Developed several XML Reports using XML Publisher.
• Analyze and troubleshoot the ORACLE issues on Financial Modules.
• Check printing format creations and new check creations in ORACLE apps
• Bank Creations, Account Creations, Payment Process Profile creations, Payment Documents and methods creations, Supplier and Site.
• Responsible for data pushing from legacy systems to ORACLE GL.
• Attending on day today issues on ORACLE Apps.
• Involving in month end processes and opens & closes the periods.
• Handling Setup level issues and SR maintenance.
• Implemented FA for an operating unit single handedly and got appreciation.
• Preparing various types of Financial reports using FSG( Financial Statement Generator)
• Trained SCM & Finance users to be thorough on their process and prepared several user guides using UPK( User Productivity Kit)
• Did many form personalization in several financial forms.
• Redesigned the purchasing hierarchies prepared as per the organization policy.
• Worked on developing interfaces between legacy systems and Oracle Applications. Developed programs to load Receipts (AR) and Item Information (INV) files from external systems to APPS modules.
• Developed Several Reports using Oracle Reports Builder and registered them in ORACLE.
• Configured the entire procure to pay cycle
• Involved in importing of standard PO into Oracle Purchasing using Purchasing Document Open Interface.
• Requirement Gathering, Design and Development.
• Prepared Technical Specification Documents.
• For all the customizations and Process mapping extensions coordinating with relevant consultants and the clients.
• Prepare relevant AIM documents for the process mapping, Technical extensions, Requirement gathering etc.
• Need to work along with technical consultant on developing interfaces between legacy systems and Oracle Applications.
• Mapping Oracle Item code and Customer part code.
• Need to do Form Personalization
• Worked productively in developing an interface program to import Items from legacy systems into Oracle apps interface tables.
• Defining concurrent programs for reports and PL/SQL programs.
• Involved in the following Oracle seeded Workflow Customizations:
o PO Account Generator Workflow
o PO Requisition Account Generator Workflow
o Project Budget Account Generator Workflow
o Project Supplier Account Generator Workflow
• Involved in design and development of following Reports:
o Store Ledger Summary Report
o Creditors Invoice Aging Report
o Prepayment Status Report
o Creditors Combined Report
o Balance Confirmation Report
• Successfully completed a Rollout project on ORACLE Finance modules AP, AR, GL, CM and FA.
• Participated in several Process mappings. Handled several extensive process studies, arranged several analysis studies and successfully completed the Process mappings.
• Responsible for the first level support to the production entry done in the shop floor.
• Involved in Forms development and Reports developing technically.
• Created several Matrix Reports on customized Manufacturing modules and registered them in the application.
• Analyze and troubleshoot the ORACLE issues on Financial Modules.
• Developed End to end solution on customized manufacturing modules in Oracle Apps.
• Extensively used several technical tools TOAD, PL/SQL Developer, Oracle Forms Builder, Oracle Reports Builder, Workflow Builder and UPK tool for documentation.
• Handling all front end and backend issues in the Production screen in ORACLE Apps.
• Used XML Publisher extensively to convert several text reports to get output in various other formats.
• Training the users on ORACLE Apps to make them understand the Process flow.
• Configured Label printers in ORACLE and monitored for smooth functioning.
• Used Reports builder to develop Matrix reports in production.
• Created several MD050, converted them to MD070 and created other AIM documents as per the ORACLE Standard.
• Provided support on the ORACLE Customized production application.
• Lead a team on Functional Process extension in Oracle Apps.
• Developed complex Reports in ORACLE and made available for the users.
• Configured the Approval hierarchies for several Operating Units.
• Receipt to Issue Process
• Defining and maintaining items with Inventory Controls
• Transaction Concepts, Issue and Transfer of materials
• Procure to Pay Lifecycle
• Invoices and Payments
• Order to Cash Life cycle
Did the master's degree through correspondence.
