Ajesh Nambiar

Email:e0ca0v@r.postjobfree.com

Mobile: +91-939*******

|OBJECTIVE: |

Seeking an oracle apps technical consultant position to work closely and

characterize the architecture and implementation of the platform where my

knowledge in consulting can effectively contribute to the successful and

advantageous operation of the firm.

|Skill Set |

Oracle Applications

ERP Tool : Oracle Apps 11i (11.5.10.2, 11.5.9)

Modules : PO, OM, INV, AP, AR and GL

Database : Oracle 9i/10g

Languages : SQL, PL/SQL,XML

Tools/Utilities : TOAD, FTP, SQL *Plus, SQL *Loader, Putty, Fnd loader

GUI Tools : Developer 2000 (Reports 6i)

Deployment Tool : Kintana,Serine Changeman

Operating Systems: Windows, UNIX

Knowledge on: XML Publisher, Release 12

Excellent technical and business problem solving capabilities

|Time line : |

|Enrich It |From Aug 2011-till |

| |date |

|Ust-Global Trivandrum |From July 2010-Aug |

| |2011 |

|Samphire technologies |From Feb 2009-Jun2010 |

|Paramonous consulting |From Aug 2006-Jan 2009|

|Summary: |

. Around 5+ years of experience in Oracle Applications.

. E-Business Suite Supply Chain Modules and financials

. Experience in development, customization and implementation of

various business applications involving Oracle Applications

11.5.10/11.5.9, SQL, PL/SQL, SQL*Plus, Oracle 10g/9i/8i, Reports

6i, Forms 6i, XML Publisher on UNIX and Windows platforms.

. Involved in 2 full life cycle implementation, customization of

Oracle Applications and having very good understanding of

Purchasing, Inventory, Order management, Payable and General Ledger

with major focus on Rice components design and development.

. Good knowledge of Functional Multi org architecture and o2c and P2p

cycles.

. Experienced in interacting with users, gathering requirements,

drawing up business/system requirements study, designing,

development, system analysis, unit testing, system integration

testing, documentation, production support and troubleshooting.

. Coordination with onsite / offshore team and client.

. Extensive experience in Data Conversions/Interfaces, development of

procedures, functions and packages using PL/SQL.

. Developed XML interface for business specific data

. Experience includes System Administration activities like managing

concurrent managers, application user setup, defining

responsibilities, values sets, flex fields, registering menus,

forms, reports, concurrent programs and providing support to apps

users for any technical or functional issues.

. Strong knowledge and understanding in interface tables and base

tables of Oracle Purchasing, order management, Oracle Inventory,

Accounts Payables, General Ledger, Accounts Receivable

. Extensive Hands-on experience in Data Conversions, Data Migration,

Developing Inbound and Outbound Interfaces, Customizing and

developing Reports, in various Oracle application modules.

. Familiar with standard documents MD70 and MD120, CV40, CV60, TE20,

CV70.

. Have worked extensively on Oracle Purchasing and order management

(11.5.10 ).

|Professional Experience |

Company: Enrich IT

Project #1

Client : Global Payments

Role: Oracle apps consultant

Description: Global Payments has more than four decades of industry

experience in electronic payment processing. Global Payments acquired DolEx

in 2003 and set up a high profile joint venture with HSBC in Asia covering

ten markets. Global payment processors with its merchant services offering

across North America, Western & Eastern Europe and Asia.

. Added new card type for fall compliance for VISA.

. Multi layout report to meet the custom requirement.

. Worked on creating business specific out files using UTL FILE Type

. Worked in Balance forward billing report customization.

. Worked on rollback functionality to rollback the transactions in GL

for the file not accepted by the HSBC bank

. Worked on performance tuning of loader program to reduce the load time

considerably.

. Worked on quarterly audit reports for management requirement.

. Worked on automating the regular process quired to validate the data

. Modifying form FMB to handle miss outs during R12 migration

. Customized MM541 reports to handle wrong calculations of discount

rates for merchants

. Customized on merchant bank form to display multiple banks associated

with the same merchant

. Changed merchant seller update to handle creation date to handle the

logic of update program for other schema.

|Software Engineer |

Company:UST-Global

Project #1

Client : Ge-SSS

Designation: Software Engineer

Role : senior Developer

Description: GESSS project is mainly used for indirect procurement across

the global through GE corporate. it is intermediate among the GE companies

GECIS-SSS is a project of GE corporate services to provide Oracle apps

reports development to all its organizations across the globe for purchase

to pay cycle where oracle application is not implemented and these

organizations are using oracle apps of GECORP through EDI. As a part of

development team we have to provide technical and functional support to

development of new reports and customization of existing reports,

development of AdHoc queries etc

. Development and design analysis for reports and Customizing of

reports.

. Developed XML interface for business specific data

. Development and design analysis for interface and conversions.

. Developing Procedures, Functions and Packages using SQL and PL/SQL.

. Registering PL/SQL Stored Procedures in Front End using Concurrent

Program.

. Developing AdHoc queries.

. Coordination with onsite / offshore team and client.

. Prepared Technical Design Documents (MD200).

. Coordination with onsite / offshore team and client.

. Code Review of peers RICE components.

. Prepared UTC Documents for the Project.

. Coordinating weekly status call with the client and businesses

. Prepared Migration Documents for the Project.

. Preparation of Test Scripts in P2P Cycle.

. Created & Registered Concurrent Programs, Request sets.

. Client coordination for requirement gathering and further

customization of PO Print report

. Writing, testing and deploying business specific data fixes based on

the requirement.

. Creating update scripts and based on the business requirement to

populate the business specific data in the report output.

. Developed outbound interface to extract the data from the Oracle Apps

Tables to the Flat file using UTL_File utility in purchasing module.

ACHIEVEMENT

. Received certificate of appreciation from GE for consistent

performance in implementation and automation of business specific

process

|Technical Consultant |

Company:Samphire consulting

Oracle Applications R11

Responsibilities:

. Designing the Interfaces respectively for the upstream and

downstream systems and providing the necessary inputs and

guidelines for the development team.

. Analyzing the Interfaces performances and providing the Short-term

Fix as well as Long-term Fix if there is any issue.

. Writing the SQL scripts to deploy into the Production Instance

[Production Data Fix].

. Worked with the performance fixes in interfaces.

. Actively involving in Long Term Fixes of Business Critical

Application issues.

. Developed reports using XML publisher.

. Unit and integration testing of objects.

. Development and Validation of PL/SQL Packages and SQL Loader

scripts.

. Involved Modules OM and INV,

. Creating effective solutions in Modules (OM, POand AP) using

PL/SQL.

. Developed report to display PO Num for Receipt Num.

. Developed sales order acknowledgement Report

. Purchased Order Approved Report (Vendor Wise)

. Pick slip report customization.

. Involved various report customization and form customization as per

the business requirement.

. Developed outbound interface to extract the data from the Oracle

Apps Tables to the Flat file using UTL_File utility in Payables

Module.

. Developed Purchase Order Interface to upload the Vendor Details

Transactions information into Legacy Flat file.

. Worked in item conversion

. Customized various reports to support for India localization also

worked Pre-printed stationary report.

. Developed INV interface Program to synchronize the data between

existing Legacy system and Oracle Database..

. Developed OM Interface Program to synchronize the data between

existing Legacy system and Oracle Database.

|Technical Consultant |

Company- Paramonous

Technical consultant,

Oracle Applications: Release: 11.5.10

Description:

It is an International privately held, U.S. $2 billion corporation with

diverse

interests including agriculture, consumer packaged goods, floral services

and the other Roll subsidiaries are pistachio producer Paramount Farming

Co., citrus grower and packer Paramount Citrus, processor and marketer

Paramount

Farms, and Bundy Properties, which owns and managescommercial properties in

Los Angeles and Pennsylvania.

. Analyzed existing RICE objects from Bahwan and tailored them as per

the SAP requirement. This involved Reports 6i, PL/SQL Packages

(Extensions, Conversions and Interfaces)

. Was involved in Deployment of RICE objects to new system.

. Performed all the Conversions for cutover for four countries.

. Development and customizing of Reports.

. Creation of Value Sets.

. Enabling of Descriptive Flex fields.

. Registration of Database Procedures.

. Customization of database Objects.

. Involved in the Developing Reports.

. Writing PL/SQL Procedures, Functions, Packages, Triggers.

. Handling the Issues (Tickets) & Analysing the root cause of the

problem and giving fixes.

. Preparation of set up documents to migrate the fixes into

production

. Preparation of MD-70 documents for Dev Tracks & Reports and other

activities / programs

. Preparing scripts for Data Fixes & Data Pulls

. Creation of Service Requests (TAR) and diligently following with

Oracle support for problem resolution

. Actively participated in Defects resolutions.

. Raising & Tracking SR's for weekly, Daily Migrations Refresh.

. Successfully Prepared Remigration Builds of different instances

with no issues.

. Checked log reports & Took immediate action for all types of

issues.

. Actively participated in client interaction and meetings.

. Maintained Quality Centre up to date for all Migrations &

Remigrations Successfully

. Designed Validation Scripts to validate the required setup. Fixed

issues during the conversion processes and redefined the process

wherever there was any scope of improvement to get the smoother

data Migration.

. Conversions worked on: Item Creation, Assigning Item categories,

Item update, Cross references, Assigning Sub inventory, Assigning

transaction Default, Assigning stock Locators, Purchasing Documents

(Standard Pos, BPA and Blanket Releases), PO Receipts, Onhand

Balances, Customers, Unapplied AR Receipts AR Open Transactions,

Item Attachments, PO Attachments.

. Analyzed and fixed issues during UAT and post Go-Live.

|Education: |

> Master of business Administration from Osmania University -2006

> Bachelor of science (Computers) from Osmania University -2004

|Personal Details: |

Nationality: Indian

Status: Married

|References: |

Available upon request.

Contact this candidate