Candidates About

SUMMARY:

·         A dynamic professional with 10+ years of experience in design development, setup, support, customization and testing in Oracle ERP Applications.

·         Extensive experience as Technical consultant in implementation of Oracle Applications 11i/11.o.x, R12 in Supply Chain & Manufacturing modules like purchasing, Inventory, Order Management, Work in process, Bill of Materials, Shipping, Material Resource Planning & Financials modules like Receivables, Payables, Project Accounting ,General ledger.

·         Extensive knowledge of Business Processes across the E- Business Suite, Order to Cash (O2C) and Procure to Pay (P2P).

·         Experienced in Oracle Financial Application upgrades from 11.5.7, 11.5.9, 11.5.10.2 and R12

·         Experience in customization of form personalization and creating forms.

·         Experience in designing new reports and modifying existing Reports using Oracle Reports, XML Publisher and Discoverer.

·         Developed several Oracle Alerts as per the business requirement

·         Experience in Oracle Application Implementation Methodology (AIM) MD-50, MD-70 Documentation.

·         Good knowledge on customization of workflow.

·         Experienced in UNIX and shell scripting.

·         Good Experience in using SQL*loader to import data into staging tables form legacy system.

·         Expertise in design and development of RICE (Reports, Interfaces, Conversions and Extensions) components.

·         Expert in writing stored procedures, Packages and functions using SQL & PL/SQL.

·         Extensive Experience in using Application Object Library (AOL) concepts.

·         Very good understanding of Multi org & TCA (Trading Community Architecture) architectures.

·         Good Knowledge in Performance Tuning and Troubleshoot issues.

·         Extensive knowledge on AppLOAD, AppMIGRATE and AppEXTRACT tools.

·         Excellent communication, leadership, interpersonal skills. Dedicated and Motivated in accepting various challenges imposed on me and showing enthusiasm in group work assigned to the team.

 

EDUCATION:

•          Bachelors in Information Technology & engineering

 

TECHNICAL SKILLS:

 

ERP	Oracle Applications EBS (Versions 11.0.2/11.5.7/11.5.9/11.5.10.2/R12)
Modules	General Ledger (GL), Accounts Payables (AP),Project Accounting(PA) Accounts Receivables(AR), Advanced Pricing(QP), Inventory (INV), Work in Process (WIP), Bills of material(BOM), Order Management (OM), Purchasing (PO), Material Resource Planning(MRP),Shipping(WSH), Application Object Library (AOL).
Processes	Order to cash, Procure to Pay
Operating Systems	UNIX, Linux, Windows NT/2000/2003/Vista/XP. Windows 7
Database	Oracle 8i / 9i / 10g
Tools	Discoverer, XML Publisher, SQL * Loader, Toad, SQL *plus
Languages	C, C++.SQL, PL/SQL, Java
Web Languages	HTML, XML, XHTML, JavaScript
Packages	Ms-Office

 

 

 

PROFESSIONAL EXPERIENCE:

 

Client Name:       Applied Materials Austin, TX

Duration:              April ‘15 –Till Date

Role:                      Oracle Applications Techno Functional Consultant

 

Applied Materials, Inc. is the global leader in nano-manufacturing technology solutions with a broad portfolio of innovative equipment, service and software products for the fabrication of semiconductor chips, flat panel displays, solar photovoltaic cells, flexible electronics and energy efficient glass. It's one of the fortune 500 companies. It has a global presence and has locations all across the world.

IBM India Pvt. Ltd. was engaged to provide end to end production and development support to all the applications and databases available within AMAT

 

Responsibilities:

 

·         Worked on Production Support Service-now Raised by Business Users.

·         Have extensive experience on resolving production issues related to Supplier, Approved Supplier List, Sourcing Rules, PO’s, PR’s, INV and OM modules of Oracle Applications.

·         Involved in the post production support. Handling Problem reports (PR’s) and production issues.

·         Set-up Approval Hierarchy based on position and also set-up Approval Groups and Assign them to the related positions.

·         Worked in resolving the technical related issues related to order to cash (O2C) and procure to pay (P2P) cycle.

·         Defining and setting up of complete Procure To Pay (P2P) cycle setups from entering the requisition in Purchasing PO to support business requirements.

·         Worked on the development of Interfaces in Purchasing modules.

·         Set up of Pricing for Order Fulfillment based upon the items, their hierarchy etc., price lists, qualifiers.

·         Customized the existing forms with descriptive flex fields.

·         Involved in the migration activities using Kintana and PVCS.

·         Also used PVCS to modify the existing pl/sql scripts and to push the new code to the testing databases. The PVCS is mainly used to keep the history of all the code changes that have been made to an original codebase.

·         Registered the Concurrent Programs, Forms, Reports and Request Sets in AOL and System Administration

·         Extensively used AOL and System Administrator modules for set up of various Concurrent programs, Request sets, Values sets and Descriptive flex fields’ Registered concurrent programs, request groups for reports and concurrent requests.

 

 

Environment:  Oracle Applications R11.0.2/R12(AR, OM, GL, PO, INV) oracle 10g database, PL/SQL, Forms,Reports, workflow, PVCS, Kintana and UNIX.

 

 

 

 

 

Client Name:       General Electric Company Louisville, KY  

Duration:              July ‘14 –March ‘15

Role:                      Oracle Applications Techno Functional Consultant

 

General Electric Company is a leading provider of lighting and electrical appliances. The company has a staff of more than 48,500 employees in over 100 locations. Its appliance division deals in the manufacture and sale of several home appliances, including refrigerators, freezers, dishwashers, washing machines, dryers, microwave ovens and air conditioners, as well as water filtration, softening and heating systems. The company provides a range of electrical distribution and control solutions.

 

Responsibilities:

·         Involved in Requirement gathering, Analysis and Client interaction. This involves analyzing MD20 (Functional Spec) and then writing CV040 (Technical Spec).

·         Worked extensively on ChRM, Item Orderability Rules, Pricing, On-hand Inventory and Sales Agreement CV040 documentation.

·         Good knowledge on SIPOC (Suppliers, Inputs, Process, Outputs, and Customers) creation.

·         Involved in review of several CV040 documentations and SIPOC.

·         Extensively worked with the Business Owners and IT project leads to fulfill their requirements.

·         Extensive knowledge on AppLOAD, AppMIGRATE and AppEXTRACT tools.

·         Performed data load for On-hand Inventory, Regions & Zones, PO Modifier & Qualifier, QP Modifier & Qualifier using AppLOAD tool.

·         Extensive knowledge on AppLOAD, AppMIGRATE and AppEXTRACT. 

·         Involved in converting legacy system data into the respective PO, INV and OM modules of Oracle Applications.

·         Extensively used AOL and System Administrator modules for set up of various Concurrent programs, Request sets, Values sets and Descriptive flex fields’ Registered concurrent programs, request groups for reports and concurrent requests.

 

Environment:  Oracle Applications R12.2.3 (OM, ChRM, INV, PO, QP, AR, AP, GL and Regions & Zones) oracle 10g database, PL/SQL, AppLOAD, Forms, workflow and UNIX.

 

 

 

 

 

Client Name:       Salter labs Arvin, CA

Duration:              Sept ‘13 – Jun ‘14

Role:                      Oracle Applications Techno Functional Consultant

 

Salter Labs Inc., develops, manufactures, and supplies products for medical device and pharmaceutical market customers. It offers oxygen delivery products, such as nasal oxygen cannulas and tubing connectors; and oxygen masks, humidifiers, conservers, regulators, and indicators, as well as accessories. The company serves hospitals, home care and nursing facilities, as well as companies seeking production of private label/OEM products. It offers its products through a network of dealers and sales professionals worldwide.

 

Responsibilities:

·         Involved in Requirement gathering, Analysis and Client interaction. This involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).

·         Developed PL/SQL procedures, functions, packages, triggers to validate the data and insert the data into Oracle Standard interface tables.

·         Developed the custom program to feed Customer data from the external source to the standard tables.

·         Developed Inventory Outbound Interface Program to extract the inventory item data from base tables to flat file using UTL_FILE package.

·         Automated custom Data Cleansing packages to normalize, cleanse, validate, extract, de-duplicate and interface the legacy Supplier and Customer data into the pre-staging tables of Oracle custom conversion programs.

·         Developed an interface program to integrate third party system to Oracle GL for importing journals.

·         Developed conversion programs for validating and importing Open AR Transactions (Invoices) from legacy system to Oracle interface tables. Used Auto-invoice Master Program to load the interface table data into Oracle AR base tables

·         Designed and developed wrapper program for BOM Components Interface using bom_comps_interface.

·         Imported BOM data from Legacy system to Oracle through Open BOM Interface. This process includes loading data from flat file to temporary table using the SQL * Loader, validated the temporary table data and moved to the Interface table.

·         Involved in converting legacy system data into the respective PO, INV and OM modules of Oracle Applications.

·         Worked on developing the check template for payments using XML Publisher and in the process communicated with the bank for testing and finalizing the check template.

·         Developer several reports in PO, AP, AR and GL modules using Oracle Report and XML Publisher.

·         Provided the production support for ongoing issues which are related to Order to cash and Procure to pay cycles.

·         Extensively worked with Oracle support to Resolve SRs for Production issues.

·         Extensively used AOL and System Administrator modules for set up of various Concurrent programs, Request sets, Values sets and Descriptive flex fields Registered concurrent programs, request groups for reports and concurrent requests.

·         Involved with study of existing system, preparing the Functional (MD50), Technical (MD70) design document and Conversion Mapping Document (CV40) to extract data from legacy system into Oracle Applications open interface tables. Used AOL and System Administrator modules for registering the developed and customized reports.

 

Environment:  Oracle ApplicationsR11 (OM/OE, INV, WSH, WIP, AP, AR, GL) oracle 10g database, PL/SQL, SQL Loader, Forms, Reports, workflow and Unix.

 

Client Name:       Johnson Controls Inc, WI, USA

Duration:              Sept ‘12 –Aug’13

Role:                      Oracle Applications Techno Functional Consultant

 

Johnson Controls is a global diversified technology and industrial leader serving customers in more than 150 countries. It specializes in creating quality products, services and solutions to optimize energy and operational efficiencies of buildings; lead-acid automotive batteries and advanced batteries for hybrid and electric vehicles; and interior systems for automobiles.

 

Responsibilities:

·         Worked on SQL* Loader to load all the data given in flat files with various special characters and comma delimiters.

·         Worked on the development of Interfaces, Conversions, personalizing Forms, developing Reports, customizing Oracle Reports in Order to Cash, Procure to Pay Cycles touching various modules such as INV, OM, SHIPPING, AR, PO and AP.

·         Involved in Customer Conversion to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them in to base tables using TCA APIs.

·         Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import program and populated into the Base Tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.

·         Worked on GL journal import to import legacy journals into Oracle GL.

·         Worked on Auto lockbox process to import receipts into Oracle AR.

·         Developed Scripts for the Transaction Open Interface to load all items into a particular Inventory & Sub inventory and loading all the serial numbers for the items which are serial controlled in INV.

·         Developed a custom program to Generate Receipts for all the Standard PO’s which are received into the INVENTORY with the help of RECEIVING OPEN INTERFACE IN PO.

·         Involved in importing Sales Orders from legacy system to Oracle Application base tables using the standard API. Validated data using packages, before loading it into the corresponding base tables.

·         Worked on Open Resource Transaction Interface to load resource transaction information into the oracle WIP from external source. The Cost Manager is launched to load the data in interface table into oracle WIP base tables.

·         Extensively used AOL and System Administrator modules for set up of various Concurrent programs, Request sets, Values sets and Descriptive flexfields Registered concurrent programs, request groups for reports and concurrent requests.

·         Extensively developed reports using XML Publisher and Oracle Reports in several modules.

·         Worked on production support tickets supporting existing Oracle 11i system.

 

Environment: Oracle Applications 11i/R12 (AP, AR, GL, OM, PO), BI/XML Publisher, Discoverer, Forms 9i/10g, Reports 10g/9i, Reports 6i, Workflow Builder 2.6.3, PL/SQL, TOAD, Web ADI, KINTANA, PVCS.

 

 

Client Name:       Meritor, KY          

Duration:              Nov ‘11 –Aug’12

Role:                      Oracle Apps Techno-functional Consultant

 

Meritor, Inc. is a leading global supplier of drive train, mobility, braking and aftermarket solutions for commercial vehicle and industrial markets. With more than a 100-year legacy of providing innovative products that offer superior performance, efficiency and reliability, the company serves commercial truck, trailer, off-highway, defense, specialty and aftermarket customers around the world.

 

Responsibilities:

·         Involved in interacting with functional leads, technical lead and data management team in order to document the technical and development specifications using standard AIM documents like MD070, CV060, MD120 and resolve certain data requirement issues.

·         Worked extensively, in and out on conversions. Involved in conversion process right from design, pre-conversion/data-cleansing, reconciliation of converted data to deployment of conversion packages onto go-live sites.

·         Developed WIP open Move Transaction Interface to load data from external data collection devices (like Manufacturing Execution Systems, Automated Test Equipment).

·         Worked on Open Resource Transaction Interface to load resource transaction information into the oracle WIP from external source. The Cost Manager is launched to load the data in interface table into oracle WIP base tables.

·         Defined Work in Process (WIP) Parameters, Accounting Classes, Profile Options, Production Lines, Repetitive Assemblies, Schedule Groups, Labor Rates, Shop Floor Statuses, Planning Parameters, Demand Class, Planners, Forecast Sets, Forecast Rule, MDS, MPS, MPS Options, MRP, MRP Options, Bills of Distribution.

·         Developed conversion programs for validating and importing Open AR Transactions (Invoices) from legacy system to Oracle interface tables. Used Autoinvoice Master Program to load the interface table data into Oracle AR base tables.

·         Developed a custom wrapper program (Inbound Interface) to validate and import the legacy Open AR Receipts data into Oracle base tables using standard API: ar_receipt_pub.create_cash().

·         Involved in development of TCA Customer Conversion program which includes data validation and API calls.

·         Developed custom program(Inbound interface) to validate and load the PO documents from Orgill (a third party supplier site) into Oracle Purchasing interface table. Used Purchasing Document Open Interface program to load the data into Oracle base tables.

·         Involved in customization of Standard Oracle Reports in Purchasing (PO) and Order Management (OM) as per client requirement, using Oracle Reports and XML/BI Publisher.

·         Involved in customization of schedule order form and moved Promise Date from one canvas to another, using Oracle Forms. Involved in customization of Standard Oracle Reports in Purchasing and Order Management as per client requirement, using Oracle Reports.

 

Environment: Oracle Applications 11i/R12(AP, AR, GL PO, INV, WSH, OM), Oracle 9i, Discoverer, Reports, PL/SQL, Stored Procedures, Windows 2000, UNIX, AOL.

 

 

Client Name:       NEW Corporation, VA, USA

Duration:              Nov ‘10 –Oct’11

Role:                      Oracle Apps Techno-functional Consultant

 

With an uncompromising commitment to outstanding customer care, N.E.W. Customer Service Companies, LLC., with its affiliates and member companies (NEW), has been the industry’s leading provider of extended service plans (ESPs) and product protection programs for consumer products since 1983. Today, NEW protects the products of more than 150 million consumers worldwide.

 

Responsibilities:

•          Designed, developed and tested Oracle PL/SQL packages, stored procedures, functions to track the budgets, return orders at the order level and the line level.

•          Developed interfaces like supplier, commission, item price, on hand Qty update, shipping data update (back to legacy system).

•          Loaded Legacy Journals data into GL_INTERFACE table using SQL*LOADER and custom wrapper program.

•          Converted Legacy Chart of Accounts Data and Mapping Values Data into Oracle 11i Mapping tables, While loading data need to compare with Segment structure, segments Mapping values, rules etc.

•          Involved in Project Accounting conversion, designed and developed the programs to convert Projects, Tasks, Budgets, Agreements and funding, Events and Cost

•          Developed Profitability Report in PA (Project Accounting), showing the details of Costing, Revenue, Budgets, Variance and profit/loss for a project. The report also created to work for Organization hierarchy

•          Developed Utilization Report breaking it down by Organization, Department and the Project Manager in Project Accounting.

•          Involved in the Implementation of P2P life cycle

•          Developed Interfaces to load the accrual data from Purchasing into PA and GL.

•          Developed new reports and modified existing reports for PA AP, AR, and GL.

•          Worked on developing FA reports as per client requirements.

•          Performed System Administration functions like Created Custom Menus, responsibilities, Concurrent executable, concurrent program.

•          Worked on AOL objects, updating and loading data into Lookups, Creating Descriptive Flex fields, defining new Messages.

•          Developed reports using Oracle reports and Discoverer4i to analyze data OM and PO modules.

•          Customization of Forms in Oracle Applications as per client requirement in OM, INV and PO modules.

 

Environment: Oracle E-Business Suite R11 (INV, OM, PO, AP, AR, GL, FA and PA), Oracle 9i, PL/SQL, Forms, Reports, Work Flow, Discoverer, UNIX, Apache Tomcat, TOAD.

 

 

 

Client Name:       Kelley Blue Book CA, USA

Duration:              Jan ‘10 –Oct’10

Role:                      Oracle Apps Techno-functional Consultant

 

Kelley Blue Book, The Trusted Resource®, is a vehicle valuation and information source trusted and relied upon by both consumers and the industry. The company provides vehicle pricing and values through various products and services available to car dealers, auto manufacturers, finance and insurance companies, as well as governmental agencies. KBB.com is a leading provider of new-car prices, used-car values, car reviews, new cars for sale, used cars for sale, and car dealer locations.

 

Responsibilities:

•          Involved in the requirement gathering, analysis and design of the interfaces and reports.

•<s