ORACLE APPS TECHNO FUNCTIONAL
LNT INFOTECH
Total years of experience :16 years, 2 Months
• More than 12.3 years of IT experience, which comprises total software experience on various oracle Technologies. Currently working with ennVee Solutions., and more than a year of Technical Lead.
• Executed processes for response and resolution of production support services through service level
Agreement.
• Over 1.5 years of experience on OAF with extensively worked in new page creation. (implemented
• Page development(Search and Detail Pages)
• LOV creation
• Calling the Subledger drill down from P&L page
• Export report details to excel
• Back to the P&L Page
• Advance Table
• My experience spreads across Implementations, Version upgrades, data conversions, Customization of Reports in Oracle AR, AP, INV, OM, PO, HRMS and payroll.
• Proven expertise with PL/SQL, Java, XML, OAF page development, Web ADI, BI Publisher, Concurrent Programs, AOL objects
• Development of various applications using Oracle technologies like Interfaces, Forms customization, Forms development, ODI, Concurrent program, AOL, Flex fields, Alerts, workflow, AME(Approval Management), WEB ADI and Reports.
• Worked on investigating and fixing production issues in Oracle EBS 12.1.3. It was possible to fix some of the issues using OAF personalization and for the remaining ones worked on the Controller Extensions.
• Experience in customizing Oracle workflows such as the PO Approval process, Order/Line Flow to send user notifications based on the business requirement. Created Attributes, Conditions, Rules, approver groups in AME.
• Extensively used Workflow to build and launch business processes.
• Expertise in designing and implementing Oracle Alerts and Lookups.
•Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.
•Experience in importing data from legacy systems to Oracle Applications using Oracle Interfacing, SQL LOADER, UTL_FILE, Oracle packaged APIs, etc.
•Worked with Oracle Utilities like SQL*Loader, ODI
•Strong Knowledge of Application Implementation Methodology (AIM).
•Prepared MD 70 for technical Design, MD120 for Installation Instructions, Test cases, Deployment document and Change Management Request Form for projects
•Involved in System Administration work such as report registration, form registration, create request set, scheduling the request, scheduling the request set, created user, responsibility, request group, assigning responsibility and register the table in the application
•Peer review studied the requirement from MD 50 and involved in Change Control Meeting
•Good experience in exploring backend SQL, SQL* Plus, triggers, packages, procedures, functions, forms6i and reports6i
•Personalization in Seeded oracle OAF pages.
•Customization seeded Oracle OAF pages.
•Involved personalization and extending of OAF pages
•Developed Controller and view object extensions on seeded OAF pages to achieve the Business requirement.
•Fixing Oracle application Framework Issues.
ResMed is a leading developer, manufacturer and marketer of products for the screening, treatment and long-term management of sleep-disordered breathing (SDB) and other respiratory disorders.
Oracle ERP (R12):
•AR Invoice Print Report:Created custom templates with Data Definitions for XML Publisher and Developed reports using report builder and registered as XML reports in applications.
•Worked on Form Personalization in various forms.
•Personalization in Seeded oracle OAF pages.
•Created report for patient information extraction.
•And registered in oracle apps
•Running from the shipment form.
Developed AP Supplier interface:
•Developed SQL scripts to create a staging table and Imported data from data template into staging table using SQL*Loader control files.
•Used Custom PL/SQL to validate staging table data, implemented business logic and loaded data into interface tables respectively like AP_SUPPLIERS_INT, AP_SUPPLIER_SITES_INT and AP_SUP_SITE_CONTACT_INT.
•Insert error message and update flag into staging table at the time of validation.
•Prepared report for those error records to validate.
•Loaded supplier, supplier site and supplier contact information into oracle using ‘Supplier Open Interface Import’ program and ‘Supplier Sites Open Interface Import’ and ‘Supplier Site Contacts Open Interface Import’.
After this it gone to the appropriate base table.
•Using AME in 'PO Requisition’, ‘Work Confirmation’, and Invoice approval, and HRMS, PAYROLL and OTL workflow.s in AP.
•Created custom templates with Data Definitions
•Developed and customized various payable report for XML Publisher and Developed reports using reports and registered as XML reports in applications.
•Personalized Oracle standard and custom Forms using oracle forms builder as per the Client requirements.
•Customized forms using custom.pll to change the functionally of the standard forms.
•Developed Master Detail forms using TEMPLATE.FMB and registered them in Oracle Application.
•Worked on Form Personalization in various forms.
•Personalization in Seeded oracle OAF pages.
•Customization seeded oracle OAF pages.
•Developed Controller and view object extensions on seeded OAF pages to achieve the Business requirement.
•Fixing Oracle application Framework Issues.
Role & Contribution
The Organization delivers competitive advantage to the world's leading semiconductor, electronics, automotive and network systems companies.
It is a leading supplier of Automatic Test Equipment.
Subsidiary Order And Additional Freight Attachment Form will be a newly customized form which would be available through ZOOM functionality from Sales Order Header Form and Shipping Transactions form. Typically, this freight attachment form will be used for Shippable orders alone.
This form helps to capture the additional Sales Order Information which are not captured in standard Sales order (like Freight Carrier Information, Goods movement details (Leg Information’s), Financial information’s like FERF Dates, FERF Rate,
Teradyne Inc. delivers competitive advantage to the world's leading semiconductor, electronics,
Automotive and network systems companies.
Teradyne is a leading supplier of Automatic Test Equipment.
FORM:
Subsidiary Order And Additional Frieght Attachment Form:
Subsidiary Order & Additional Freight Information process is that process by which all the relevant information that is required by various entities is available at one place. This Subsidiary Order & Additional Freight Information Process helps shipping department by providing inputs to print Customer facing documents while for the Finance Confirmation Process by giving certain inputs which is used by that process further down the line.
This Subsidiary Order & Additional Freight Information Process helps serve not only the above mentioned purpose but also in other related process. By looking at this Subsidiary Order & Additional Freight Information the business users will be able to get information like the Freight Terms, Intercompany Accounting etc. This Subsidiary Order & Additional Freight Information Process is not limited to Subsidiary Orders but also to all the Shippable Orders that is being created by various Teradyne subsidiaries like Teradyne Europe, Teradyne Japan etc.
Subsidiary Order And Additional Freight Attachment Form will be a newly customized form which would be available through ZOOM functionality from Sales Order Header Form and Shipping Transactions form. Typically, this freight attachment form will be used for Shippable orders alone.
This form helps to capture the additional Sales Order Information which are not captured in standard Sales order (like Freight Carrier Information, Goods movement details (Leg Information’s), Financial information’s like FERF Dates, FERF Rate, Broker Details etc., ).
These informations which are captured is used for
1. Generating Export and Import documents for Transportation department
2. Finance Confirmation Process by providing informations like Conversion Rate, Conversion Type, Conversion Date and Billing Currency.
Primarily the new records would be created through Sales Order. This form has got two Tabs. One is ‘Additional Subsidiary’ and another is ‘Freight Details’. There are totally two ways in which the data will be populated in this form. It has lot of validations.
An International underwriter of specialty insurance and reinsurance products in the property and casualty market. It holds assets in excess of $5 billion.It mainly focuses on various commercial lines of business.
Offers a full line of high-quality products and services designed to meet the unique coverage and claims handling needs of businesses in three primary segments: Excess and Surplus Lines, Select Markets, and International Specialty.
Forms and Reports Migration:
This is a pilot migration of forms and reports from lower version into 10g. The whole system divided into two subsystems based on geographically. One is AIS and another one is GCIS. Again each subsystems divided into claims and premium based on functionality. Each subsystem has their own database, server, separate operational unit. One is claims and premium. Migrated all forms and reports into 10g and tested in new environment for both systems. Both systems have more than three hundred forms and more than hundred reports. The migrated forms and reports are resides on Linux server. Migrated perl, pro*c, sql, pl sql and shell scripts along with forms and reports. We tested the major functionality of the system in various Line of Businesses. For ex
Claim Coverage Selection,
Claim Medical Only,
Claim Reserve Change,
Medical only to Indemnity conversion,
Issues payments
Yamama Cement Company is one of the leading cement companies in KSA.
Oracle ERP (R12):
Involved AP Techno Functional Tasks:
•Create a Payment Format in Payments Administrator setup.
•Create a Payment Process Profile and attach it to the Payment Format:
•Customized ‘AP Invoice Approval Workflow’ using the workflow and AME.
•Developed and Enhanced various finance reports like ‘AP EFT Summary Report’, 'AP Check Payments to Suppliers’, 'AP Check Payments to employee', ‘Foreign Currency Payment Report’, ‘AP EFT Covering Letter’, ’ Supplier Open Balance Report’, ’ Customer Open Balance Report’
•Using AME in 'PO Requisition’, ‘Work Confirmation’, and Invoice approval, and HRMS, PAYROLL and OTL workflow.
•Developed and customized various payable reports in AP.
•Created custom templates with Data Definitions for XML Publisher and Developed reports using reports and registered as XML reports in applications.
•Personalized Oracle standard and custom Forms using oracle forms builder as per the Client requirements.
•Customized forms using custom.pll to change the functionally of the standard forms.
•Developed Master Detail forms using TEMPLATE.FMB and registered them in Oracle Application.
•Worked on Form Personalization in various forms.
•Personalization in Seeded oracle OAF pages.
•Customization seeded oracle OAF pages.
•Developed Controller and view object extensions on seeded OAF pages to achieve the Business requirement.
•Fixing Oracle application Framework Issues.
Role & Contribution
courses: Oracle Application Certificate in ERP