PROFESSIONAL SUMMARY:

• An accomplished Oracle Applications Technical Architect/Manager with around 9 years of proven expertise in Software Lifecycle Development of Oracle Applications Design, Development, Testing and Implementation and good Project management and Team Management experience.
• Experienced Strong Technical Project Manager for the Oracle Apps Implementations.
• Worked as a Good Liaison between Implementation Partner and Client.
• Provided weekly Project Progress report with Achievements, Issues, Concerns and Milestones to the Implementation Partner and Client.
• Provided man - hour estimates with resource count for the needed development Accomplishments.
• Worked as a Team Lead for Technical Developers for Oracle Apps Implementations starting from requirements gathering to Go-live.
• Worked with Offshore Team for development of objects and with DBA for several DBA activities.
• Experience in different phases of Oracle Implementations from Start to Go-Live and involved in several organizations Go-Live.
• Experience and ability to co-ordinate and work closely with various project teams involving Business Users/End Users, Developers, Functional Team, Project Managers for successful implementations.
• Ability to interact with Functional users and Business analysts to gather requirements and to architect Industry standard feasible solution.
• Expertise in Designing solutions for complex business requirements and designed several customizations in Manufacturing and Supply Chain modules in Oracle Applications.
• Good experience in study/audit of existing business process and preparation issue logs, collection of functional/technical requirements, client/user interaction, GAP Analysis, technical data mapping analysis and design of technical/functional data process flow charts. 
• Hands on experience in development and extension RICE components using SQL and PL/SQL, Customization of forms using Custom.pll, reports using Report builder 6i, XML Publisher and exposure to Workflow, Oracle Discoverer, OAF using JDeveloper512 9i and development of business reports using OBIEE.
• Strong Hands on Implementation and Support projects in the functional & technical areas of Manufacturing (INV, WIP, BOM), Supply Chain Management (OM, WSH, PO, WMS, QP, CFG, MSCA), Financials (GL, AP, AR), and Application Object Library (AOL, SYS).
• Good functional knowledge in designing and configuration of Order-to-Cash (O2C) and Procure-to-Pay (P2P) life cycles.
• Designed and Hands-on experience in Data Conversion, Data Migration from different Legacy systems into Oracle and Developing Interfaces, Extensions from Oracle with other 3rd Party Systems.
• Designed and developed different inbound and outbound interfaces with oracle e-business suite. Developed several interfaces for 3rd party applications with Oracle E-business suite.
• Extensively involved in design, configuration, development and deployment of custom Process integration packs (PIPs) to support additional and unique requirements of Client business.
• Good knowledge and understanding of Oracle E-Business Suite PIP components.
• Extensive experience in administering SOA Suite 10/11g Servers, Web Logic and Oracle Application Servers.
• Developed API’s in Oracle Applications to support B2B Applications.
• Knowledge on Oracle Mobile Supply Chain Applications, Oracle Configurator and TCA Architecture.
• Strong programming Technical experience in creating Procedures, Packages, Functions, Triggers, UNIX shell scripts and other database objects using SQL and PL/SQL.
• Experience in customizing standard Oracle forms with the use of CUSTOM.PLL, Forms Personalization and OA Framework Personalization and Developing new forms using OA framework and Forms Builder.
• Extensive experience in developing Business requirement specification (BR100), Functional Specifications (MD50), Technical Specification Documents (MD70), Conversion Specifications (CV40, CV60) and other testing documents in AIM Methodology standards.
• A well-organized, detail-oriented team member with excellent analytical, troubleshooting, and problem-solving skills.

TECHNICAL SKILLS:

ERP Applications: R 12/11.5.10.2/11.5.10/11.5.9/11.0.5/11.0.3.

E-Business Suite Modules: INV, OM, WSH, WMS, MSCA, QP, CFG, TCA, GL, AP, AR, PO, BOM, WIP, SYS.

Languages: SQL, PL/SQL, C, C++, Java

Tools & Utilities: Forms 9i/6i, Reports 9i/6i, Discoverer 4i/10g, XML Publisher, SQL*PLUS, SQL*Loader, Workflow Builder 2.5, TOAD, SQL Developer, JDeveloper, SQL Navigator, Discoverer, OBIEE, MS Visio, FTP, Data loader etc.,

Database: Oracle 11i/10g/9i/8i/8.x.

Operating Systems: Sun Solaris, HP-Unix, IBM AIX, Windows XP/NT/2000

PROFESSIONAL WORK EXPERIENCE:

Confidential, Canton, MI

Techno Functional Architect

Responsibilities:

• Created Weekly Project status Report to the Implementation Manager and Client to keep track of overall project status with the Miles stones provided.
• Schedule meetings with the client to update the Project status and to discuss necessary steps to meet client deadlines for the Development.
• Conducted Daily status meetings with Functional, Technical and DBA involved in the Implementation.
• Worked with Functional team to carve out the Technical architecture for the GAP Analysis.
• Co-ordinate Offshore team status with Client to meet client deadlines.
• Worked on Technical Designs for the Business requirements provided. Hands on Experience in designing the Technical Architecture for the complex business requirements.
• Development of Technical Designs with the offshore team and keep track of progress with status calls.
• Involved in gathering requirements for the Business Users and extracting detail Specifications from the Integration partners.
• Understanding the Business requirements and perform GAP analysis with Oracle E-business Technical Architecture.
• Worked on Technical Designs architecture for the Implementation.
• Worked on critical development objects
• Resolved issues encountered in testing with Business users at client site.
• Worked with WAMAS team to understand and gather the detail specifications of the Interface.
• Designed and developed Interface Program has been developed to send all the picking information (Items, locations, routes and sales orders) to Wamas as soon as pick release is completed in oracle.
• C51ustom Interface program sends data to Wamas and waits to get the acknowledgement for the data being sent. Label print API has been developed to call based on the acknowledgements received from WAMAS.
• Items, locations and routes information will be sent to Wamas periodically and Sales order information will be sent as soon as the Sales order has been pick released and replenishments completed.
• Programs has been developed to update the item attributes information in Oracle.
• Onhand quantity load program has been developed to load initial on hand balances.
• Prepared documentation for MD50 and MD70 documents for this Interface.
• Worked with Offshore team to develop and completes the tasks as per deadlines.

Integration of Oracle with Kewill:

• Involved in gathering requirements for Kewill Interface with Kewill Team.
• Installed Kewill Adapters (Java and PLSQL) in Oracle for this Interface.
• Designed API’s to send required information to Kewill using Kewill provided adapters for different carriers.
• Waybill number is received back from Kewill and updated against the delivery in Oracle.
• API’s has been designed to perform SHIP, PSHP and CSHP transactions in Kewill.
• Worked on Technical design document and prepared documentation on this Interface.

Integration of Oracle with Cipher:

• Developed label API as per the carrier requirements in Oracle.
• API sends information to the Cipher label system and populates the information as designed in the Layout.
• API has been developed to print based on label type, printer and Ship method associated with the delivery.
• Labels will get printed automatically as soon as the pick release is completed for a given sales order.

Automated Pick processing inside Oracle:

• Picking information received back from WAMAS system will be automatically pick confirmed in oracle.
• Developed LPN Full pick, LPN Partial Pick and Pick None API’s to perform Pick Confirmation in Oracle.
• Alerts has been developed to notify the users for the processing Errors in Oracle.

Confidential, San Mateo, CA

Techno Functional Architect

Responsibilities:

• Providing the weekly Project status to the Implementation Manager and Client to keep track of overall project status with the Miles stones provided.
• Involved in discussions with the client on the Project status and taking necessary steps to meet client deadlines for the Development.
• Development of Technical Designs with the offshore team and keep track of progress with status calls.
• Involved in gathering requirements for the Business Users and extracting detail Specifications from the Integration partners.
• Understanding the Business requirements and perform GAP analysis with Oracle E-business Technical Architecture.
• Worked on Technical Designs architecture for the Implementation.
• Worked with Functional team to carve out the Technical architecture for the GAP Analysis.
• Co-ordinate Offshore team status with Client to meet client deadlines.
• Worked on critical development objects
• Resolved issues encountered in testing with Business users at client site.

Implementation of Oracle R12.1.3 SCM with DWMS:

Integration of Oracle WMS with PeopleSoft: Worked on Integration of Oracle WMS with PeopleSoft through ODI (Oracle Data Integrator). Interfaces have been developed to transfer the Master Data and Transactional Data between two systems using ODI. Messaging approach has been used for the interfaces.

• Designed and Developed Interface programs to load Items, Customers, Suppliers, Departments, Locators, Item cross references, Categories, Unit of Measures conversions, Sales orders, Purchase orders data into WMS.
• Designed and developed several triggers and API’s to send Inventory adjustments and receiving transaction data from WMS to PeopleSoft.
• Designed and developed a picking interface between Lucas and Oracle WMS system.
• Developed custom API to perform pick confirmation, partial picks and pick none transactions in Oracle.
• Developed a custom program to pick release the sales orders as per the client requirement and call the pick slip documents once the order has been pick released.
• Developed custom program to load On hand quantity from legacy system into Oracle WMS.
• Developed custom API’s to create deliveries, assign deliveries, Pack, Unpack, and Split transactions among child and parent LPN as per client requirements.
• Developed a custom program to print freight documents for a delivery as per client needs.
• Designed and developed custom Pick slip and Pack slip report as per client requirements.

Confidential, Duluth, GA

Application Manager/Team Lead/Consultant

• Involved in 3 full cycle Implementations of oracle applications from start to Go-live.
• Took 8 organizations go live in both Big Bang (All organizations at once) and phase rollout (One organization at a time) methods of Go-Live approach.
• Created executive summary of 4 block charts to present the benefits and risks of several Implementations.
• Involved in discussion with business in gathering requirements and documentation of BR100. Good understanding of AIM methodologies.
• Designed and managed developers to convert data from different legacy systems into Oracle using Oracle standard open interfaces and API’s. Conversion data includes Items, Item cross references, Item Categories, Unit of Measures, Customers, Customer Item Cross references, Vendors, BOMS, Resources, Routings, Pricelists, Factor lists, Item Costs, Blanket Purchase Agreement, Approved supplier list, Bill of Distributions, Open sales order, On hand Quantity etc.,
• Developed an outbound shipping interface to send Delivery and Trip stop information to Ryder TMS system.
• Involved in designing various customer facing, manufacturing shop floor and Financial Analysis reports. Reports designed Includes Sales Order Acknowledgement, Worksheet, Picking List, Pack list, Bill of Lading, Invoice, Production Traveler, Skid label, Work Order, Snag Report etc.,
• Customized several Oracle seeded forms using cutom.pll and Oracle forms personalization. Designed and Developed new forms using forms builder and OA Framework from scratch.
• Customized sales order workflow to have a notification and approval process for Credit orders. Customized COGS account generator workflow to derive the GL segments as per the company segment definition.
• Created several Event based and Periodic alerts to send a notification emails using Alert Manager in Oracle.

Upgrades:

• Managed DBA’S in upgrading database from 9i to 10g and 10g to 11i. Changed few reports and applied several post patches for the issues appeared after the database upgrade.
• Created new indexes on few tables as recommended by oracle for few concurrent programs that are running longer after database upgrade.
• Prepared execution plans to load Technology update patches, Cumulative and Rollup patches for different modules.
• Lead the initial requirements gathering and understanding of R12 upgrade process from 11.5.10.2.
• Good understanding of server configuration and requirements for Oracle E-business suite installation.

Production Support:

• Performed analysis to identify the root cause for helpdesk requests and assign the request to developers for code changes.
• Addressed new enhancement requests and provided industry standard solutions for the user to choose and then assign the request to the developer for development.
• Planning of outage with the business for up keeping the oracle application with the latest patches. Involved in patch analysis and Designed testing plan for roll up and cumulative patches.
• Planning, Scheduling and prioritization of requests for the Development.
• Prepared proposals for migration and version control tool.
• Worked with functional team in resolving the production support issues.
• Worked with DBA’s in resolving several performances related issues.
• Worked with Oracle on SR for issue resolution on several Severity 1 issues. Interacted with Duty Manager and Support Engineer on several service requests.

Inventory, BOM, WIP (Manufacturing)

• Done all set ups required for Item Import, Item Categories, Category sets, Organizations, Unit of Measures etc.,
• Involved setup changes and data migration in Implementation of Non WMS enabled organization to WMS enabled organization.
• Good understanding of Interface managers in Oracle Applications.
• Imported on hand quantity for every organization go-live using Account Alias Issue Transaction Type.
• Resolved issues in pending transactions for month end closing.
• Developed a custom program to calculate Metal Weight per piece for every item in the inventory.
• Designed and Developed a Custom FIFO calculation program to calculate the FIFO value for the on hand quantity.
• Customized Metal Coil Usage report according to the Business requirements.
• Done Unit of Measure conversions for both Inter Class and Intra Class Conversions for items.
• Good understanding of pending transactions and Open transactions interface in Inventory.
• Defined set ups required to import Boms, Routings, Resources, Departments, Lead Times.
• Knowledge on steps involved in Completion of discrete jobs and worked on resource workbench.
• Worked on Metal weight calculation program to calculate the weight of each Individual Item and all the components present in a BOM.

Order Management, Shipping, Advance Pricing, Purchasing, Warehouse Management, Mobile (Supply Chain Management)

• Created a custom Skid Label form and Zoom form to update the ordered quantity according to the Sales order forms.
• Involved in picking process customization based on LPN in Oracle WMS.
• Designed and developed a new mobile page in Oracle WMS to be able to submit pack slip and pack slip exception report from hand held devices.
• Enhanced existing oracle mobile pages with pick more functionality and populated default values.
• Designed and developed logic in custom.pll for users able to enter the order quantity as fixed box multiplier for specific items.
• Designed a logic in custom.pll for orders to go on hold as soon as order is booked If credit authorization number is not populated.
• Designed logic to default some values into Order Header DFF as soon as user selects the customer on Order.
• Designed a shipping outbound interface to send delivery information to Shippers Common wealth TMS system. Designed a shipping Inbound Interface to load Trip Stop information from Shippers TMS into Oracle. Created an Interface to send XML tags to Loftware system for generating coil tags and Skid labels.
• Defined Transaction types in OM and assigned corresponding workflow for different types of transaction types.
• Customized order header workflow to send a notification to an email distribution group as soon as an order is booked with a specific transaction type.
• Modified Order header workflow to send a approval notification for credit orders types.
• Resolved issues in Order Import correction window.
• Designed and developed a custom program to reset the error flag for multiple sales order in order interface to resubmit the Order Import program.
• Defined a custom program to attach documents to the sales orders.
• Good knowledge on process and setups involved in importing sales order through E-Commerce Gateway.
• Expertise in setups involved in Shipping. Defined Ship Confirm rules, Document sets, Carriers, Ship methods etc.,
• Worked on Territory Sold to Customer report to analyze salespersons sales by market and regions in a particular period of time.
• Defined regions and zones for transit times in oracle for shipping of the orders in particular days for each region.
• Defined Under and Over Shipping tolerances at Item level.
• Designed logic to make waybill number required on Delivery Tab in Shipping Transaction form.
• Good understanding of Pricelists, Qualifiers, Modifiers, Factor lists and Pricing formula setups.
• Resolved issues for the transactions that are stuck in receiving transaction interface.
• Good understanding of Supplier Base architecture in 11i and R12.
• Defined custom templates for Purchasing document types.
• Designed and Developed an RTF template for Purchase order document types in 11i.
• Created a custom program to mass accrual write off that matches PO with Receipts.
• Involved in customization of mobile supply chain application (MSCA) for picking, receiving and physical counting using mobile handheld devices.
• Supported production issues related to Advance supply Chain Planning (ASCP). Good knowledge of planning manager and other concurrent programs in ASCP.

Account Receivables, Account Payables, General Ledger (Financials)

• Developed an XML template for 1099 pre-printed forms report.
• Created custom programs to calculate discounts on the invoice amount in AR Transactions Interface.
• Designed a custom program to resubmit EDI invoices.
• Good knowledge on customer setups and their relationships with the customer sites in Trading community architecture (TCA).
• Resolved error transactions in the AR Transaction Interface.
• Created a custom program to update sales tax rates in oracle every month.
• Worked on Outbound program to extract General Ledger Trial Balances and Transaction Details data into a flat file from Oracle.
• Developed a program to update the Customers Contact Details through Open Interface.
• Customized Cost of Goods Sold Account Generator Workflow according to the requirement
• Worked on Daily sales flash report to give all the sales in the given region on a particular time period and helps in predicting the future sales.
• Customized many reports like Sales Order Acknowledge report, packing Slip, Invoice Statement report, Customer Invoice report, Matching Hold by buyers report, Custom production travelers report for Order Management and also created new reports as per client requests.
• Worked on SQL tuning to reduce the performance issues for the concurrent programs.

E-Commerce Gateway (EC)

• Worked on trading partner setups and assignment of transactions in E-commerce Gateways.
• Worked on 850 Purchase order Inbound, 810 Invoice outbound, 856 Remittance Advice, Advance ship notice (DSNO).
• Created a custom edi outbound program to send bill of lading information in a flat file.

System Administration, Workflow Administrator, XML Publisher Administrator (AOL, SYS, XDO, APPL)

• Created users, responsibilities, menus, sub menus, functions.
• Registered Concurrent programs, executables, request sets, Descriptive flex fields DFF, Value sets, lookups etc.,
• Created exception menu list for view only responsibilities.
• Scheduled several concurrent programs based on the requirement.
• Re-assign and rewind workflows using workflow administrator responsibility.
• Able to view workflow activity and status diagram for all employees.
• Defined XML Template, Data Definition in the XML administrator responsibility.
• Defined different types of executables and attached executables to concurrent programs.
• Created value sets for the parameters to the concurrent programs to display list of values.
• Worked on XML template to produce the output of some reports in EXCEL and PDF form. Used Sub template technology to switch between templates based on conditions.
• Developed packages, procedures and functions using PL/SQL. Worked on Interface/Conversion and also developed and customized Reports and Forms. Well versed with SQL*LOADER.

Environment: Oracle Applications 11.5.10.2

Confidential, Seymour, IN

Oracle Apps Techno-Functional Consultant

Order Management:

• Customized RMA line flow in OE OL workflow according to the client requirement.
• Customized Account generating process in OECOGS workflow according to the requirement.
• Worked on Order Import to convert all open orders from Legacy to Oracle.
• Worked on Oracle Order Import API to validate and load the PO information from the interface tables into Oracle Order Entry (OE/OM).
• Worked on Process Order API for the sales order data in Order Management.
• Involved in Importing the Order Management data from legacy system to Order Entry Interface tables using SQL*Loader, validating the data using PL/SQL Script and Creating Orders using Order Import Program.
• Developed procedures, functions and database triggers using PL/SQL. Worked on Interface/Conversion and also developed and customized Reports and Forms. Well versed with SQL*LOADER.
• Customized many reports like Pick Slip, packing Slip, Mailing Label for shipping and Credit Order Detail, Orders by Item, Order Detail & Summary Reports for Order Management and also created new reports as per client requests.

Inventory:

• Worked on a custom Item Interface program to get the Country of Origin.
• Written interface scripts for importing part numbers from legacy systems to Oracle inventory.
• Written conversion scripts to import lot numbers and on hand quantities.
• Developed custom interface program to load Inventory Adjustment data from external feeder system into MTL TRANSACTION INTERFACE and MTL TRANSACTION LOTS INTERFACE tables.
• Customized Inventory reports like Sub inventory Report and Inventory Receipt and Issue Report involving inventory transactions.
• Reviewed MD50 functional design document & Prepared MD70 Tech design for development work done.

Bill of Materials:

• Developed a conversion script to convert the Models, Options and Option Classes over to Oracle from legacy system.
• Worked Designed, Developed and Implemented Interface program between Oracle BOM and an external configuration system.
• Developed a script using the BOM Explosion program to take a part number as the input and give its indented BOM in a report form.

Environment: Oracle Applications 11i (OM, BOM, MRP, WIP, INV, AR), PL/SQL (Stored Procedures, Functions), Oracle 8i, SQL, TOAD, Reports 6i, Oracle OAF, Oracle Workflow Builder 2.6.3, SQL*Loader and Sun Solaris 8.

Confidential, Plymouth MI

Oracle Technical Developer

Purchasing:

• Developed a conversion program for the Purchase Orders Outbound Interface.
• Imported Requisition Details (Requisition Import) using SQL * Loader and PL/SQL.
• Developed an Interface program for the Costing Interface to Import and calculate the actual material cost of Items.
• Developed custom reports using Oracle Discoverer and Customized standard reports.

Order Management:

• Designed and developed Order Import interface to import sales orders from legacy system.
• Designed and developed a shipping interface to integrate oracle shipping with an external Shipping warehouse.
• Designed and developed interface to extract and transfer sales order information from Oracle OM to a Logistics system.

Inventory:

• Written interface scripts for importing part numbers from legacy systems to Oracle inventory.
• Developed a script to import inventory transactions from an external system into Oracle.
• Written conversion scripts to import lot numbers and on hand quantities.
• Developed custom interface program to load Inventory Adjustment data from external feeder system into MTL TRANSACTION INTERFACE and MTL TRANSACTION LOTS INTERFACE tables.
• Customized Inventory reports like On Hand Balance Report, Daily Transaction register, etc.
• Reviewed MD50 functional design document & Prepared MD70 Tech design for development work done.

Environment: Oracle Applications Release 11.5.8/11i, Oracle 9i, INV, BOM, MRP, OM, Forms6i, Reports 6i, SQL, SQL*PLUS, SQL*Loader, UTL Scripts, TOAD, Discoverer4i, PL/SQL, and UNIX.

Confidential

Technical Consultant

Responsibilities:

Purchasing:

• Validated the data and populated the Payables interface table through a Concurrent program which in turn submits a standard Payables Interface program.
• Designed and developed complete Vendor Interface for import of vendor information into the system. Used SQL*Loader for import into interface tables, and PL/SQL block for complete validation of data and inserting into base tables.
• Imported Requisition Details (Requisition Import) using SQL * Loader and PL/SQL.
• Modified the Reports like Invoice History, Invoice Aging, Prepayment Status, and Invoice on Hold Reports.

Order Management:

• Developed several Reports in Order Management.
• Customized the Shipping reports in Oracle like Bill of Lading, Mailing Label report, and Commercial Invoice and Packing Slip report.
• Designed and developed an Order Import process using the Process Order API to import sales orders into Oracle from an external iStore system.
• Used open Interface to Shipping transactions into Oracle Shipping.
• Defined form to the function menus and attached those to user-defined Responsibility.

Environment: Oracle Application 11i, PO, OM, BOM, Shipping, Pricing), PL/SQL (Stored Procedures, Functions), SQL, Oracle - Developer 2000/6i (Forms, Reports), Toad 6.0/8.0, Oracle Utilities like SQL*Loader