Magesh Kumar Email & Phone Number

Virginia, United States

Durham, North Carolina, Us

 Involved in designing a custom module(OAF) in Oracle Projects with JDeveloper to manage milestone events. The custom UI would allow the user to Search for and display existing events from EBS, create new events, update events, approve or reject events. All the Eligible events will get picked by the workflow program for sending notifications to the project managers for Approval. Events on getting approved will get picked by the Invoice program for generating invoices in AP and AR. Involved in designing oracle webadi interfaces to upload data from excel sheets to the oracle seeded table for creating events with milestones on Oracle Projects. Involved in designing a custom UI(OAF) to provide the ability to review Unbilled Pass Thru (PT) Transactions through an online web tool, capture PL approval, Review comments and report an Audit Trial, review the view the associated AP invoice copy, Employee Expense report, ability to adjust the expenditures. Involved in designing a custom UI(OAF) to provide the ability to review Unbilled Labor Transactions through an online web tool, ability to review the Daily time sheet comments associated with the labor transaction, ability to capture PL approval, review comments and record an Audit Trial, ability to review Cost and Revenue generated on the labor trans actions

Boston, Massachusetts, Us

 Involved in Reimplementation of R12 from 11i instance for all the financial modules, with in- depth analysis of the current 11i instance with lots of gap analysis and building of various custom components that would serve the same business purpose as the legacy system. Involved in the design of custom OAF pages for loading AP/AR Invoices into the system using standard import programs after pre-validation for inbound files. Involved in designing GL outbound interface for finding out the balances for ledgers for a particular account combination for a period. Involved in design of AP/AR/GL interfaces to load data from third party vendors through a shell script and import them into the seeded tables using seeded import programs. Involved in design of ADF custom application for search of legacy invoices used as a repository for legacy data for reconciliation Involved in designing various AP/AR BI Publisher reports used for data reconciliation purposes. Involved in designing a custom form ‘OOPS’ for creating payable invoices which on running a concurrent program would create AR invoices that gets posted to General Ledger.

San Jose, Ca, Us

Involved in designing a whole new custom module for allocating bonus to Cisco employees by using metrics and KSO plans. Involved in studying the whole legacy system for the re implementation process. Designing new pages from scratch built on top of oracle workflows that calls the Pl/Sql packages on the back end.

Paris, France, Fr

Involved in various OAF customizations like VO Extension, Controller extensions, AM extensions and designing new custom OAF pages for various modules like HCM, Finance, SLM and OM.Involved in designing a whole new custom module for Advanced Pricing for Order Management module which helped in setting up the prices for all the commodities from the client side.Involved in resolving various support tickets both in business logic and the front end framework of the custom screens developed for online shopping of Texas Smartbuy. The complexity involves in understanding 11i upgrade to R12.Needed constant interaction with the client team understanding various upgrade features and new customizations that were needed.Involved in designing a custom workflow for EAM module which routes approval to a set of approvers based on certain scenarios and this involves understanding the seeded workflow and various business scenarios attached to it.Involved in developing a MPA report for accounts payable division user needs in Excel (XML) in a prescribed format to know the outstanding accruals (pending transactions) accounting.Involved in designing various conversion interfaces used for loading of legacy data into R12 instances for modules like HCM, SCM, OM.Involved in designing a concurrent program which updates the leave balance of an employee when there is a change of holiday calendar

Aliso Viejo, Ca, Us

Involved in the enhancement of adding Related Contracts column in custom contracts advanced page search results. This column would display Yes (with hyperlink) if the contract has any related contracts else it would display No (without hyperlink). If user clicks on Yes, new form would open and display the related contracts number and relationship code. The related contract number would be having hyperlink to redirect to contract details page.Involved in creating a new OAF pages for validation of QMSR status in the Iprocurement module (i.e.)When the User creates a requisition and when he checks out, depending on the category of the item he selects, a questionnaire page would appear which on answering would validate the qms functionality of the requisition.Involved in creating custom module called GEOHR responsible for creating mapping rules for particular business units. It involves creation of screens responsible for creating, updating and display of the mapping rules along with the respective operating units.Involved in many customizations and personalization with the various flows of Iprocurement pages with OAF in various businesses of GE.Involved in resolving few technical issues regarding a custom screen developed by GE called Document Viewer which is used for searching any document regarding the purchasing modules.

Austin, Texas, Us

Involved in the customization of a custom page used for validating the timesheet entries made by the employers working in the organization. This page basically validates all the entries made by the employees in the timesheet and informs them of all the possible time entries for a particular project. The extensions include extending the View Object, Changing the Controller code, AM code and overall business logic of the screen.Using this custom application one can Mobilize, Demobilize time entries for a particular project for the employees working under the project. It also has the provision for Over time entries and approval of the sameInvolved in the customization of a custom page used for validating the timesheet entries made by the employers working in the organization. This page basically validates all the entries made by the employees in the timesheet and informs them of all the possible time entries for a particular project. The extensions include extending the View Object, Changing the Controller code, AM code and overall business logic of the screen.Using this custom application one can Mobilize, Demobilize time entries for a particular project for the employees working under the project. It also has the provision for Over time entries and approval of the same

Kuala Lumpur, My

Involved in development of custom oracle module for medical system from the legacy system using oracle forms10g.This medical module was used for registering invoices collected from the employees and checking the validity of the invoices and repaying them directly or repaying it to the concerned hospitals. This involved the understanding of the complex medical legacy system they were actually using.Involved in development of Maintenance System of the Medical Billing system, used for adding he Panel Clinics and HospitalsInvolved in the Generation of a Custom Medical report with OA Framework using JDeveloper9i.This is the utilization report of the medical benefits of the CIMB Employees and their dependents. This report was made available to every employee using their log in ID’s.This report also had the Clinic/Hospital details through which the medical claims were made.Involved in development of custom oracle reports used for checking the validity of the medical claims and summary of the claims made by the employee for a particular year. This report was used by the users to see whether he/she has actually crossed his claim limit for a particular year.Involved in the Generation of the Summary report of the Medical Invoices based on the Cost Center associate with each invoice.Involved in the Generation of an interface file of Employees and Dependents on a weekly basis to a third party administrator ‘PMCare’ for allocating Medical Benefits.Involved in the Generation of an Inbound interface used for loading files from a third party administrator ‘PMCare’ and create an interface for generating GL Interface File and an Autopay file.

Noida, Uttar Pradesh, In

· Extensive experience in designing, development, testing and implementation of Stored Procedures, Packages, Functions in PL/SQL, Shell Script· Extensive technical experience in Data Conversion & Interfaces, Customization & Development of Reports, Forms, Oracle Workflow, OA Framework· Basic Functional knowledge in General Ledger, Oracle Payables, Oracle Order Management (OM), Oracle Process Manufacturing (OPM), Procurement, Purchasing.· Extensive technical expertise in Oracle HRMS with core HR,Payroll and Self Service as main modules. Involved in the configuration of Payroll setups required for running the Oracle Payroll.· Was part of the onshore (client site) R12 custom module team. Extensively involved in the RICE development