SUMMARY

• Over 7 years of working experience in Oracle E Business Suite specialized in Supply Chain Management with diverse experience in discrete Oracle Financials and Manufacturing modules and also hands on Engineering and Manufacturing processes.
• Excellent skills in Design, Development, Implementation, Customization and Support of Payables, Receivables, Inventory, Purchasing and Order Management modules.
• Extensive knowledge of functional flow of Order - to-cash & Procure-to-Pay life cycles with full life cycle implementations.
• Expertise with Six Sigma methodologies on shop floor for continuous improvement of processes and supply lines.
• Thorough knowledge of manufacturing flows, accounting behind the flows, Value Added Methodology, Lean/Process Manufacturing.
• Good experience in PL/SQL coding, stored procedures and UNIX Shell scripting.
• Very Good Understanding of hierarchical structure of Multi Org and TCA (Trading Community Architecture) concepts.
• Extensive experience in writing PL/SQL Packages, Stored procedures, Triggers and Functions.
• Involved in data conversions and writing validations before transferring data from temporary table to interface tables using SQL*Loader, PL/SQL.
• Experience in registering Concurrent Programs, Form Functions, Reports, Applications, Creating Users and Defining Profile values by using Application Object Library (AOL), System Administration.
• Worked on Various Technical and Functional Documents using AIM (Application Implementation and Methodology).
• Excellent data analysis skills, system review skills and situation assessment for prompt solution backed by good communication and ability to perform independently as well as a team.

TECHNICAL SKILLS

MODULE EXPERTISE: Oracle Account Payables (AP), Oracle Purchasing (OP), Oracle Inventory (INV), Oracle Order Management (OM), Oracle i-Procurement, Oracle Shipping, Oracle General Ledger, Oracle Accounts Receivables

MODULE EXPOSURE: Oracle System Admin, Oracle Work in Process (WIP), Oracle Enterprise Asset Management (CAM), Oracle Bill of Materials (BOM), Oracle i-Expense

TOOLS: Toad, SQL Loader, Data Loader, iSetup, Quality Center, Workflow

LANGUAGES: SQL & PL/SQL

OPERATING SYSTEM: Windows 98/NT/2000/XP/Vista, Windows 7, UNIX, LINUX

PROFESSIONAL SUMMARY

Confidential, San Antonio

Sr. Oracle Apps Functional Consultant

Responsibilities:

• Worked on upgrading Oracle applications from 11i to Release 12.
• Developed Payables Invoice Interface program to Interface Oracle AP Invoices using the Payables Open Interface Import program.
• Defined Payment Terms, Locations, Invoice Approvals and Setting up Bank Account information in Oracle Financials AP.
• Worked on Payables Open Interface Import to create invoices from external systems into AP Invoice Base tables.
• Customized AP Check report in accordance to clients check printing stationary. Customized Report for Cash/Bank Book Report.
• Successfully implemented the Auto-Invoice in Oracle AR.
• Designed and Developed AR Invoice Import interface program to load AR Invoices into Oracle E Business Suite.
• Customized several standard and custom reports in AP, AR and GL.
• Authored a few MD-70’s and also assisted in documenting MD-50’s using AIM.
• Extensively worked on i-Expense for Integrating Master Cards and loading credit card transactions into Oracle system, which will later be converted as expense reports.
• Performed System Administrator role, which involved creation of Users, Responsibilities, and assigning Responsibilities to Users, defining Executables, Concurrent Programs and administering Concurrent Managers.
• Involved in upgrading Markview for Oracle Apps from 6.4 to 8.2.
• Worked on implementing Debit cards to replace checks for small business vendors.
• Led the team on customizing the R12 BI Publisher Payment Reports - Scheduled Payment Selection Report, Payment Process Request Status & Payment Instruction Register.

Confidential, Atlanta

Sr. Oracle Apps Functional Consultant

Responsibilities:

• Involved in Customization of various Financials Modules and supply chain modules. Successfully Interacted with Functional Consultants, QA team, DBA team and development teams.
• Worked on all of the Order Management module including setting up of Transaction Types, Defaulting Rules, Processing Constraints, Shipping Rules, Modifiers and Qualifiers in Advance Pricing, etc.
• Lead the solution team for the Order to Cash business flow.
• Involved in implementing various business process extensions of Order-to-Cash and Procure-to-Pay cycles as per the business requirements.
• Creating the items, shipping Network, Locations, Conducted Miscellaneous transactions, internal customers, price list, Requisitions, pick release against sales orders, ships confirms for sale orders. Defined Sales Credits setups.
• Designed general setups like defaulting rules, processing constraints, pick release rules, shipping setups, DFFs and Transaction types.
• Designed price lists for different currencies, Modifiers and qualifiers.
• Define pricing formulas. Attaching pricing attributes to modifier lines.
• Define a price list and adding items to price list. Define a multi currency conversion list. Define modifiers list.
• Worked on Order Cycle, which includes Booking, Pick Release, Ship Confirming and Interface to Receivables, Invoice/Credit memo generation.
• Loading Catalogs into i-Procurement. Actively participated in the implementation of Punch-out.
• Workflow customizations in Purchasing Module i.e. PO Requisition Approval and PO Approval.
• Worked on the setups of i-Supplier module setting up the Supplier responsibilities, supplier invitation lists, supplier registration process etc.
• Worked on all of the Test Cycles SIT, CRP and CAT.
• Worked on the Inventory module setting up the Item Master, Templates, Inventory Orgs, defining sub inventories, locators, serial number controls, Min Max and Reorder Point planning, Cycle Counting and ABC Analysis, etc.
• Worked on customization for Oracle Order Management, Shipping, Purchasing, Distribution and Custom applications.
• Prepared BR 100 Documents, Functional and Technical specifications for reports.
• Customized existing Material transactions Form and Purchase Order Forms.
• Involved with business users and functional people for understanding business requirements and converting it into technical requirements.
• Involved in writing the mapping and process Documents of Journal Import in GL and Invoice Interface in AP, for daily interfaces from the Legacy Mainframes System.
• D eveloped and Customized Forms, Reports, PL/SQL Procedures, Triggers and Functions.

Confidential, Ohio

Order to Cash Functional Consultant

Responsibilities:

• Key setups like Flex fields, Organization, Inventory Parameters, UOM, Sub inventory, stock locator, Item Attribute control, Item Template and Transaction Type.
• Established a Item Category and Item Cataloging for their products.
• Defined a ABC Analysis and Cycle Count.
• Established Customer Item and Customer Item Cross Reference.
• Established a process for smooth month end closing procedure in Inventory.
• Lead the solution team for the Order to Cash business flow.
• Liaise between the users and the business owners throughout the entire project.
• Performed Gap analysis hence identified issues and suggested workaround solutions.
• Coordinated in closing periods and generated trail balance reports for different Operating Units of the company.
• Worked on the setups of i-Supplier module setting up the Supplier responsibilities, supplier invitation lists, supplier registration process etc.
• Implemented Enter Advanced Shipment Notices (ASN) in i-Supplier to acknowledge the delivery status and Shipping schedules.
• Integrated key purchasing functionality including Vendor Punch-out, XML Purchase Orders, Procurement Cards (P-Card), Emergency PO requisitions, Hosted Vendor Catalogs, and Automated PO Creation.
• Prepared BR 100 Documents, Functional and Technical specifications for reports.
• Trained the business users for purchasing the Click to Requisition, PO to invoice, Return Material Authorization (RMA’s) and Invoice to payment flows.
• Worked on new and customizing standard forms like AP/PO Taxability Inquiry, Purchase Order, Purchase Order Summary, AP Invoice Workbench and Supplier Form.
• Integrate Service modules with ERP for Inventory depletion and successfully complete test cycles of process flow from each module and finally recognize revenue in AR.
• Involved in support of Production and worked tickets raised in Oracle financial modules.
• Worked on the Test Cycle setup environment for SIT, CRP and UAT testing

Confidential, NJ

Oracle Apps Technical Consultant

Environment: UNIX, Oracle 11i, PL/SQL, SQL*Loader

Responsibilities:

• Creation of BOM, resources for sub assemblies and finished goods and also created routings standard operations for routings. Created documents for system enhancements and worked with development team to explain them requirements.
• Responsible for creating the Database tables, indexes, constraints in Oracle8i.
• Created Stored Procedures, Functions, Packages, Triggers using SQL, PL/SQL.
• Invoices are ported from the Excel sheets to the Oracle Database using SQL * LOADER.
• Involved in creation of SQL scripts.
• Meeting with management for enhancement of the system.
• Trained end users.
• Involved in creation of Technical Docs & User docs as well.

Confidential, Atlanta

Oracle Apps Functional Consultant

Responsibilities:

• Involved in implementation of Order Management (OM) Module.
• Developed brand new order interface as part of the data conversion from legacy system (easy route).
• Enabled descriptive flex fields to store legacy order numbers for troubleshooting.
• Worked on Order Import in Order Management (OM), Purchase Order conversions for PO.
• Developed stored procedures to populate the interface tables in the process of importing customer’s information into AR and Purchase Order information into PO.
• Registered Concurrent Program Executable, Defined Concurrent Programs attached to Request Groups and attaching Request Groups to Responsibilities.
• Developed shell scripts to load data from staging tables into the Interface Tables and call the Concurrent Programs to populate the base tables as part of the conversion.
• Customized several standard and custom reports in AP, PO, OM and GL
• Successfully imported the Quotation and PO from the legacy through standard API and Set up the system to Generate Sourcing Rules, Assignment Sets, and Approved Supplier’s List
• Validated set up for Oracle Purchasing and Sourcing like Purchasing Options, Financial Options, Receiving Options, Document types, Updated Position Hierarchies, etc.
• Performed the Bills of Materials (BOM) setups like defining parameters, routings, alternatives, departments etc. Designed documents for customized Quote to billing process and consolidated billing statements
• Involved in designing the customizations for the workflow based on the business process requirement. Defined Order import sources, Transaction types, Defaulting types, processing constraints, invoicing rules.
• Created gap closure analysis documentation. Created functional mapping for to-be analysis. Involved in analysis, business requirements and GAP analysis for BOM, WIP, PO and OM modules.

Confidential

Manufacturing Engineer

Responsibilities

• Process/product development, SPC, cost analysis, root cause analysis, feasibility study, resolving manufacturing problems, interacting with customers/clients and continuous improvement with ERP maintenance/customization, BOM generation, WIP Inspection and business analyst responsibilities.
• Designed mold cavities and inserts for injection molding using Pro/E and UG. Created and reviewed assembly drawings, tolerances and process flow diagram. Aided in generating & executing detailed project plans, performed changes to part drawings (ASME Y14.5 (GD&T)) to meet customer requirements.
• Designed mold cavities and inserts for injection molding using Solid Works. Created and reviewed assembly drawings, tolerances and process flow diagram. Aided in generating & executing detailed project plans, performed changes to part drawings (ASME Y14.5 (GD&T)) to meet customer requirements.
• Supported the development cycle, worked closely with technical resources to ensure complete testing and ultimate migration to the Production instance. Supported the integration with other manufacturing applications such as BOM, Costing and Purchasing.
• Coordinated with the client and upper level management, as well as cross-functional teams like BOM/WIP/Purchasing/OM to test the solutions for Production issues and customizations.
• Conducted studies pertaining to cost control, cost reduction, inventory control, and production record systems. Generated reports and mapped out meetings to review and examine Production run, efficiency, obstacles, problem resolution, timeliness, recommendations and conclusions.
• Collected data on cycle times, production, material used and scrap quantities to identify most recurring product orders. Plotted control charts for µ, USL, LSL for cycle times based on key performance indicators. Null hypothesis testing to identify best product-machine, product-product, machine-routing combinations for better production outputs.
• Assisted manufacturing, quality and maintenance departments to investigate and find the root cause of problems and resolving design related issues for process improvement. Drafted business flow charts for process control, control charts from ERP data for inventory control, generated preventive action reports to reduce cycle time, scrap & rework.
• Supervised personnel in production on material database and instructions on process inputs. Documented standard operating procedures (SOPs) in compliance with OSHA standards. Actively participated in production scheduling meetings.
• Conducted/Supervised weekly assessment meetings. Generated weekly reports using Microsoft word & excel to analyze production efficiency, performed root cause analysis and provided recommendations to managers.