Vinodkumar Manickam

Oracle Application Techno Functional Consultant

Mail: acxwec@r.postjobfree.com

Phone: 512-***-****

SUMMARY:

** ***** ** ** ******** experience encompassing a wide range of skill set, roles and industry verticals.

Expertise in Oracle SQL Plus, PL/SQL, Oracle Application Framework(OAF), Oracle Forms6i and Oracle Reports6i, BI Publisher with Burst functionality, Oracle performance management and Workflow.

Strong Experience in data conversions and migrations using Interface tables and APIs from Feeder and Legacy systems to Oracle Application 11i and R12 suite.

Proficient experience with Oracle Purchasing, iProcurement, Inventory, Order Management (OM), Payables (AP), General Ledger (GL), Cost Management, and iStore modules.

Worked in various Onsite-Offshore model projects. Worked as onsite and offshore lead. Lead and managed a team of 15+ members.

Ability to lead and facilitate cross-functional teams to deliver complex projects in 11i and R12.

Proven expertise in Sourcing Rule, Advanced Pricing, Purchasing Hierarchy AND Oracle Approval Management (AME).

Extensively used TCA (Trading Community Architecture) to create suppliers.

Involved in development of RICE components using SQL, PL/SQL, Developer 2000, BI Publisher as per Oracle Applications coding/ Customization/ User Interface standards and Coding techniques in Oracle Applications.

Strong technical skills and extensive experience in Oracle Application AOL objects, Oracle PLSQL, Oracle BI Publisher, OAF, Oracle forms and Reports, including debugging and fine tuning of PLSQL Programs.

Developed test scenarios and performed functional testing and documented test results.

Excellent interpersonal, communication skills and understanding of Business applications. Willing to take up challenging assignments and interested to work in all kinds of modules and emerging technologies.

TECHNICAL SKILLS:

Version :

Oracle Apps 11.5.8 to 12.1.3

Oracle Apps Modules:

Oracle Purchasing, iProcurement, Payables(AP), General Ledger(GL), Fixed Asset(FA), Cost management, Order Management(OM), Inventory, HRMS,

Manufacturing – MRP, BOM, WIP,

Account Receivables(AR), Oracle iStore

Reporting Tools

BI Publisher and Developer 2000

Application Tool

Workflow, JDeveloper

Languages

PL/SQL

Version Control and Migration Tools

Kintana and PVCS

Client: Hertz Corporation

Company: IBM India Private Ltd

Project Title: Hertz Oracle Global Financials

Jul – 2015 to Till Date

Oracle Application Consultant

Environment – Oracle Purchasing, Oracle iProcurement, Oracle HRMS, Oracle Payables, and General Ledger (GL).

Description:

The Hertz Corporation, a subsidiary of Hertz Global Holdings Inc is an American car rental company with international locations in 150 countries worldwide. Hertz is the largest U.S. car rental company by sales. The oracle financial global applications implemented for US and Canada business operations.

Contribution:

Responsible and owner for Purchasing, iProcurement, Payables Modules and developed various objects in Purchasing, Payable modules.

Involved in design and development of oracle application framework (OAF) page to display and process the new supplier data for smart form refund process.

Involved in design and development of smart form check request report that sends purchase requisition PDF copy along with attachment in the mail. The report is implemented through BI publisher with BI bursting technology and oracle BLOB conversion functionality.

Involved in design and development of procurement card (PCard) transaction report in payables using BI publisher report.

Involved in design and development of general ledger extract and trial balance outbound interface program to transfer the data to external server.

Involved in design and development of payable inbound interface program to import data from external system for two suppliers – CINTAS and Good Year.

Involved and resolved field users’ iProcurement access issue and configuration setup.

Involved in iProcurement approval hierarchy setup and resolved approval hierarchy issue due to wrong approval management (AME) setup.

Involved in oracle user form personalization and disabled many critical fields but enabled only password reset field for helpdesk support team.

Involved in design and development of benefit group automation in HRMS module.

Involved in Registration/Migration of concurrent program, executable, Creation of Responsibility, request Group, Menu, value set, Request Set, Forms, Functions in System Administration and AOL.

Prepare the custom functional design document and user guide for all new custom projects and changes.

Involved in all functional and technical production support L1, L2 and L3 activities and resolved the issue through tickets.

Client: Applied Materials, Inc. Austin USA

Company: IBM India Private Ltd

Project Title: Oracle Leap and AKT

Aug – 2011 to Jun 2015

Lead and Technical Consultant

Environment – Manufacturing, Order management, Purchase Order, Inventory, Oracle Sales and Marketing, Account Payables (AP), Account Receivables (AR), General Ledger (GL), Cost Management and custom modules (MSM, BBB) in 12.1.1

Description:

Applied Materials, Inc. it supplies equipment, services and software to enable the manufacture of semiconductor, flat panel display, Glass, WEB and solar (crystalline and thin film) products. The core production unit is running in Oracle manufacturing and distribution modules. The application is integrated with around 10 small applications.

Contribution:

Extensively involved in migration project from the version 11.5.10 to 12.1.1, own and tested the oracle purchasing, order management modules for AKT application.

Fit gap analysis based on the client requirement and R12 functionality change.

Functional setups in the R12 instances during the build activities.

Retrofitting of existing RICE components to R12.

Involved in design, development and testing of outbound interface finance transaction data of AP, AR and GL with SAP application.

Involved in design, development and testing of new custom Quotation report.

Involved in design, development and testing of custom forms such as Quote Analysis form, Award Approval form for MSM custom module.

Involved in design, development and testing of auto sourcing rule creation program and auto population of discrete job attribute values that populated when user releases the DJ from MRP workbench.

Prepare the custom functional design document and user guide for all the new custom application and enhancements.

Perform month end inventory period, purchasing period, and general ledger period closure activities for SGP organization.

Perform all the costing activities such as standard cost rollup, interim cost update and BOR rollup activities.

Involved in all functional production support L1, L2 and L3 activities and resolved the issue through tickets.

Involved and completed functional testing of DRP every year.

Client: Avery Dennison

Company: Sonata Software Ltd

Project: ACEv1

Jul 07 – Aug 2011

Offshore Team Leader (Techno-Functional)

Environment – Order management, Inventory, Account Receivables (AR), iStore in 11.5.8

Description:

ACEv1 is an e-commerce application that allows customer to prepare the order, callout and track the order status in iStore application.

Contribution:

Involved in inbound and outbound interface from Oracle order management to external application for order processing.

Involved in inbound order import interface and data conversion from external applications.

Designed and developed many custom reports in Oracle order management for order tracking.

Designed and configured oracle iStore for each customer and setup the Oracle inventory and customer setup.

Designed and configured oracle CRM for customer relationship among buyer, vendor and factory.

Prepared technical design documentation and user guide for each new iStore customer site.

Client: Symantec, Ireland

Company: Sonata Software Limited

Supply Development project, Oct 04 – Jun 07

Offshore Technical Leader

Environment – Order Management, Inventory in 11.5.8

Description:

Supply development project is fulfilling sales order processing and integrating with custom modules such as Inline Upgrade application, DRM application.

Contribution:

Involved in development of Inline upgrade application interfaces and DRM application interfaces.

Development of custom API’s to call Process order API to create RMA order and applying Receipt for the respective RMA order.

Developed a new program to end date pricing lines.

Technical design for data interface with the customer for RMA- Receipt program.

Walkthrough with the business users on RMA order process.

Coordination to migrate the code to test cycles using Kintana migration tool.

Involved in bug fixes during test cycles.

Client: Applied Materials, Inc.

Company: Satyam Computer Services

KWarehouse Implementation project, Jul 03 – Sep 04

Programmer

Description:

KWarehouse is a Data mart which gets data from different sources like Oracle Applications, SAP and I2. The reports are developed and generated using Brio Tool. There are 300 reports developed using some 500 odd tables.

Contribution:

Design and developed new reports and modified existing reports using BRIO tool.

Worked on performance issue of the BRIO report and view.

Schedule and monitor batch jobs.

Education

Bachelor’s in Electronics and Communication Engineering

Madurai Kamaraj University, India

Contact this candidate