EXECUTIVE SUMMARY:

• Over 18 years of industry experience as an Oracle EBS Developer, primarily in the Financial/Supply Management/Supply Chain Management business environment. 15 years of experience in the setup, configuration and customization of Oracle Supply Chain/Financials/Manufacturing Modules to the business requirements.
• Well versed with complete life cycle development of business application.
• Very strong in the requirement gathering, design, development, and implementation of Financial/Supply Management/Supply Chain Management business applications using the Oracle RDBMS, development tools and utilities. Very good understanding of MPS, MRP, ASCP/VCP and Demand planning modules.
• Detailed understanding of ASCP collection and Demantra collection.
• Worked on the SQL/PLSQL queries on MSC, ASCP and Demantra tables. Understanding of Supply/Demand planning overall.
• Worked in all areas of application implementation such as data conversion, interfaces, production support, application tuning, testing/troubleshooting and documentation. Has extensive experience with:
• Oracle ERP Financials/Manufacturing R11i/R11.5.10/R12.1.3

TECHNICAL SKILLS:

Modules: Demand management/Forecasting (Demantra), Quoting, Sales, Pricing, Purchasing, iSupplier, Shipping, MRP, Order Management, Inventory, BOM, WIP, Cost Management, iPayment, Account Receivables, General Ledger, Account Payables, Application Object Library (AOL), System Administrator, Oracle Workflow Administrator, Applications APIs, Oracle Personalization, SOA console Oracle Enterprise Manager 11g, OSB (Oracle Service Bus) Console, ISG (Integrated SOA gateway)

Oracle RDBMS: 10g/9i, Oracle forms 6i, Oracle Reports 6i, Oracle Workflow Builder PL/SQL, SQL*Loader, UTIL Files, ProC, UNIX Shell Scripting, Autosys Tibco EAI (Business Works), Java, JavaScript, HTML, SoapUIJSP, Struts, EJBs, Websphere

Application Development Studio tool: Oracle SQL developer, Toad, Sql Navigator, CVS, Borland Star team, Business objects Test Director, Quick Test Pro, HP ALM 11 Quality Center Control - m (Scheduling Tool for Oracle Applications), JIRA, STAT Vertex, Adobe designer

Custom Applications: Financial Accounting, Securities Holding System

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Define specifications for new projects and design and develop software according to those specifications.
• Coordinate resources as needed to align the right skills for problem solving, keep users abreast of issue resolution status, and provide regular reporting and communication with the manager to ensure correct and complete coordination of resources and issue resolution and tracking.
• Develop and set up production batch schedules in production/test environments.
• Analyze and suggest implementation strategies for patches.
• Provide user acceptance testing support and conduct integration and system testing;
• Implement Oracle Applications Custom project components utilizing Unix, PL/SQL, SQL, stored packages, procedures, triggers, workflow, Oracle forms and reports Shell Scripting, AIX, and HP-UX. Track the versions using version control software like PVCS and CVS.
• Design and develop interfaces between Oracle Applications and Legacy Systems.
• Assist in performance tuning of interfaces using sqltrace utility. Troubleshoot technical errors and data errors in the environments using Oracle Diagnostic utility.
• Prepare data migration plans and rollout/cutoff plans to the production environment.
• Develop, apply and maintain quality standards for project deliverables with adherence to both internal and external standards.
• Work in conjunction with Oracle Support group.
• Work with Support managers to facilitate process and issues.
• Work on the development of data architectures, data models and entity relationship diagrams.
• Data Analysis/ Data Cleaning/Data Mapping

Confidential, Goleta, CA

Responsibilities:

• Worked on supplier, supplier sites and bank account Conversion. Suppliers and supplier sites added o interface tables and ran import program to convert data. Confidential Travels Brazil data converted to newer version.
• Supported Oracle ERP cloud for GL, AP, iExpense modules. Worked Oracle consultant on Request for change (RFC) and on Service Request (SRs). Had weekly meeting with Oracle consultant on the production issues, enhancements, upgrades, SRs and RFCs.
• Worked on XML publisher reports. Worked on MS word rtf templates as well as XML data definition file. Printed dynamic logo of the company by checking the value of the profile option.

Confidential, Bloomington, MN

Responsibilities:

• Demantra upgraded from 7.3.01 to 7.3.1.4. All the programs are copied from older verion to new version and tested to work with new R12 implementation.
• Worked on new product information functionality. The new items with no sales are created along with new item/location combination in demantra.
• Worked on ASCP/VCP collection, demantra collection, EP load, ABC analysis and auto chaining functionality.
• Worked on items, customer locations tables in MSC schema. Analyzed the ASCP data coming from EBS side. Worked SQL/PLSQL queries.
• Tested converted data for the sales channel hierarchy and duplicate ‘sold to’ locations.
• Written the purge process for demantra for the sales older than 3 years.
• Worked on the performance tuning of vcp/demanatra interface programs
• Knowledge of Demantra Applications data model and workflows.
• Worked with Planners with their inquiries and adhoc reports.
• Exposure to other Oracle VCP products and integration aspects

Confidential, Plymouth, MN

Responsibilities:

• Worked on data mapping from Oracle ERP/SAP to data warehouse for sub-inventory, Monthly/Weekly Inventory Aging buckets and sales orders. Developed PL/SQL scripts to validate data.

Confidential, Bellevue, WA

Responsibilities:

• Worked on defects and tested sales orders interface from licensing portal to EBS, Oracle E-Business suite. XML request, response are verified and the processes monitored in the SOA console, oracle enterprise manager 11g, OSB (Oracle Service Bus) console as well as in ISG (Integrated SOA gateway). SOA testing is done using tool SoapUI.
• Worked on customization to send email to 'Consumer support and repair' group when customer email is not available

Confidential, Bloomington, MN

Responsibilities:

• Customized ASO quote user hooks for various requirements: Created Partners and Sales Reps sales Credit for quotes,
• Created discount roll down sales prices from the bundle items to child items. Created quotes on the Quoting module and tested the above requirements.
• Worked on the Equifax Customer conversion. Created parties, party sites, customer profiles and party relationships.
• Designed and developed tasks and activities conversion. Created activities for Customers, Customer contacts and Opportunities. Also, created campaign references for activities.
• Calculated and updated summarized revenue for customers in the customer profiles.
• Designed direct org transfer and subinventory transfer process in Oracle ERP R12.
• Worked on interfaces to bring Yearbook and eCommerce sales orders into Oracle Order Management. Also written process to send automatic reminder emails to Schools.

Confidential, Minnetonka, MN

Responsibilities:

• Converted Unix script to Linux scripts
• Applied patch to show message to iSupplier portal users to accept all PO lines.
• Written document for "Switch User" functionality so that any other buyer can accept the PO supplier changes. Added need-by date column to the workflow notification going to Buyer.
• Provided feature in the iSupplier portal so that the buyer will decide if the supplier has to Reacknowledge PO changes or not.
• Provided feature to block the workflow notification going to Planner.
• Changed default LOV value to "POs to be acknowledged" from "Last 25 POs" in Order tab of iSupplier portal.

Confidential, Golden Valley, MN

Responsibilities:

• Logged SRs, track, follow-up on issues raised as a result of testing
• Researched issues on Metalink to see if a solution already exists and log findings.
• Worked on upgrade plan for purchasing, iSupplier and other supply management business processes.
• Tested latest patches in procurement area.
• Created cut-over plan and created the migration component list
• Led and Co-ordinated the project on inbound and outbound interfaces between Oracle ERP and SAP. Studied the XML format for the purchase orders, order acknowledgement and the invoices. Understood the SAP interface process between SAP application system using SAP XI and Oracle ERP. Coordinated the activities including requirement gathering, design, development and testing for this project with different teams including UK SAP team, US SAP team and offshore development team.
• Demonstrated the functionalities of Oracle iSupplier portal. Worked with SAP team to create common processes for supply management and worked on the activities to give the overview the current solution and the portal functional review/demo. validated requirements of PO management, PO response, Inventory status reporting and Forecasting. Also worked on GAP analysis and the functionality matrix to compare the functionalities of Oracle iSupplier portal and SAP SCN Supplier collaboration network.
• Designed and mapped Intercompany Invoices and shipping data for Canada Customs interfaces to include direct shipment to Canada and dropship shipments. For Canada entity sales order, drop ship PO created in US entity. In this Intercompany process AR invoices are created in Canada entity and AP invoices are created in US entity. Worked on enhancement of packing slip report.
• Improved workflow communication between iSupplier portal and purchasing application including Purchase Order Approval notifications. Changed the iSupplier email content to show portal URL.
• Worked on iSupplier portal personalization setup to have the PO line flexfield appear on the portal.
• Completed the feasibility study of the private label project including functionalities like creation of requisitions, purchase orders using sales order data of assembly items and modification of Supplier email notification which includes private label data like label position, size, color and WIP job number.
• Automated the life cycle management of Purchase Drop Ship-PDS types of orders. Developed an automated process to communicate the purchase order and the product configuration information to sub-contract manufacturers who produce products for Confidential ECC using a configuration. The information sent must include not only the normal PO order information, but also specific product features, customer drop ship address, product tagging information, coupling, expedite, and special freight requirements. Provided the Portal Supplier a downloaded excel spreadsheet supplier schedule requirements for items that have been sources from them. All data mapped to each supplier’s configuration system data import requirements.
• Worked on project to update print item revisions instead of part revisions on PO, Requisition and Quotation item lines.
• Configured Event Alerts to run for quotation and closed blanket agreements. Notifications are sent to Buyers and commodity managers so that payable invoices are paid. Confidential will not be on credit hold by suppliers and No Line down situation is avoided.
• Worked on MRP open forecast interface to update the forecast data for particular forecast set and name. Responsible to load Mercia forecasting data into Oracle forecasting application. Designed the Line rate exception reports.
• Work on to support, develop and enhance procurement, manufacturing and SIOP projects as defined and prioritized by demand management, manufacturing and procurement. Support the supply management and supply chain management teams in whatever tasks as necessary to have the Oracle Manufacturing/Inventory system/ purchasing/iSupplier available meeting business requirements.
• Line rate planning process changed to show On-hand, In-transit, Sales order demand quantities including dependent and independent demand, MRP Gross requirement, Supply, Safety Stock and consignment quantities. These quantities are shown for three buckets- daily, weekly and monthly. The various interfaces were written to provide the same data with different format to data warehouse.
• Developed the process to constrain the demand from MPS Planned orders under a Line Rate planning Item to the Line rate that has been defined for that planner code.
• The process ‘Supply Chain BOM Indented Cost Summary’ customized to show summary for Actual cost. Summary page shows resource hours, resource rate, overhead rate, total resource, total overhead, total material and total overhead amounts.
• Redesigned and enhanced the auto item obsolescence process to provide Canada the ability to buy and sell obsolete products will the item is in an Obsolete status. Enhanced this process to send the email notifications to CSRs so that there will not be any open sales orders sitting in the system with the obsolete items.
• Written customizations to synchronize Approved Supplier List (ASL) data with the quotations.
• Acquired knowledge on SAP architecture, how different modules like MM, SCN, SRM, SD, APO, BI, SAP PI are structured and how client, company code and plants are set-up.

Confidential, Eden Prairie, MN

Responsibilities:

• Worked on the order pick release, shipping/warehouse management system and fulfillment management system. Also worked on customer expectations project where scheduled ship date calculated using warehouse lead time and freight carrier lead time.
• Designed and developed real time interfaces to create web customers (with addresses, sites, phone numbers, emails) in oracle applications. This customer data can be viewed through CRM, Receivables and order management modules. Oracle has come up with TCA (Trading Community Architecture) in 11i version for the customer’s database design. Researched and used all new 11i API to create the customer data.
• Developed real time interface to add web and phone order data to staging tables. This interface validates the order data, does the authorization, calls the pricing engine, checks the ATP quantity and gives Confidential card & employee discounts.
• Created Customers/Addresses/Sites/Contacts and Orders/Returns inquiry interfaces. Using this interfaces web customer can view his personal profile, the orders/returns status and all orders/returns details through web Confidential web page as well as through automated phone order system.
• Written periodic interfaces to send new Customer and Order data to WEB and created flat file to send one time customer data to WEB before go live date.
• Done enhancement for styles and items interfaces for web and automated phone order system. Written design document for up-sell and cross-sell marketing process for automated phone order system.
• Written functional and technical design document and developed item tax rate exception interface for WEB to calculate tax or specific Items and shipping destinations.
• Written detail level functional & technical design and developed the complete charge correction module. This module does the various processes like unapply invoices, apply credit card refunds, invoices/freight/taxes/coupons/markdowns/credits adjustments and creation of new invoices using auto invoice program. The new charge correction process avoided the double refunds to customers and saved lot of money for Confidential . It also saved the considerate amount of time for CSRs (Customer Service Representatives).
• Developed interfaces to validate customers and payment methods.
• Compiled the technical design using AIM standard template (MD70) for ‘Duplicate VRU Orders’.
• Developed couples of forms and reports in show scheduling modules.
• Designed and developed Yearly Same Store report, which gives the output (Current year Vs Prior Year). Created Cable Affiliation responsibility in production database with reports, forms menus, value sets, flex fields, request sets, users, request groups etc.
• Written technical design and developed ‘Open Value Pay’ form to allow update of the credit cards, credit card expiration dates and Value Pay due dates thru the single form. This module is developed to improve Customer Responsiveness. It gives faster and more accurate information to customers and saves search time for CSRs.
• Developed Customer Snap Shot form for credit department to provide complete snapshot for customer including profile, past dues, adjustments, credits, collections etc.
• Worked on migration activity to convert oracle customized code from version 11.5.3 to 11.5.5. Before go live, migrated all WEB & VRU customized code to production server. Led resolution process for upgrade related Tars/Bugs with Oracle Support and Oracle Development. Used CVS for tracker and source code control.
• Reviewed the interface specifications and tested real time, near real time and periodic web interfaces with TIBCO EAI software.
• Developed forms for J2EE applications using JSP, STRUTS and EJBs in Websphere application development tool.

Confidential, Minnetonka, MN

Responsibilities:

• Understanding the client business organization, operating units, various companies, and their relationship with each other.
• Mapping the business needs of the client in Oracle Applications to identify the areas needing customization and the setup required for implementing Oracle General Ledger
• Handling the gap analysis phase of implementation. Basically what business requirements can and cannot be handled by Oracle Applications.
• Preparing a solution document, and design and technical reference documents in addition to migration documents.
• Setup Oracle General Ledger
• Designed, Developed, and Implemented the Budget, and Actual Account Balance Conversion.
• Designed, Developed, and Implemented the Journal Entries Conversion.
• Followed a migration strategy in converting the existing Legacy Data from as far back as December 1997 through March 1999 over to Oracle Applications.
• Identifying and developing customized Interfaces between the Oracle Applications and Legacy Applications.
• Designed, Developed, and Implemented a Legacy Outbound Reporting Interface
• Identifying the processes to be automated, and writing control m shell scripts for automation of those processes like Automatic Posting, Mass Allocation runs, Interface runs etc.
• Identifying and developing custom forms.
• Identifying and developing custom reports using Reports 2.5.

Confidential, Eagan, MN

Oracle Applications DBA

Responsibilities:

• Worked on GL interface to load Journal Entries in Oracle General ledger.
• Designed and developed auto invoice interface to load invoices in Oracle Receivables.

Confidential, Woodbury, MN

Applications Consultant

Responsibilities:

• Using the autoinvoice interface in Oracle Receivables converted all the transaction information from various sources to invoices, credit memos, debit memos, deduction, and unearned discount. Invoices were created with separate tax and freight lines and sales credit and accounting information.
• Mapped legacy invoice values to Oracle Receivable application autoinvoice interface table columns.
• Set up invoice batch sources, various transaction types such as invoices, credit memos, debit memos, deductions and unearned discounts, standard memo lines of type tax, freight and line, invoice transaction flexfield, line transaction flexfield, link to line flexfield, grouping rules, tax codes, and remit to addresses.
• Created cross reference tables for mapping values of payment terms, invoicing reasons, and credit memo reasons.
• Uploaded data from flat files into the temporary table using SQL*LOADER and consteller hub. Coded and validated imported data before running the autoinvoice program. An error report will be generated which can be used to rectify the errors. Ran the autoinvoice program. Generated reports of failed data.

Confidential, Greensboro, NC

Applications Consultant

Responsibilities:

• Designed, Developed, and Implemented the Customer and Order Entry Interfaces.
• Maintained the Customer data.
• Developed a reconciliation report and PL/SQL scripts to match the Oracle and AS/400 customer data.
• Designed, Developed, and Implemented the Order Entry Conversion.
• Identifying and developing product line extension, freight calculation extension and price list extension.
• Identifying and developing custom forms and reports.

Confidential

Analyst/Programmer

Responsibilities:

• Preparing system requirement specifications (SRS) document and process flow diagrams.
• Preparing a system specifications (SS) document.
• Coding and testing programs.
• Preparing test plans and a user manual.
• Preparing ISO documents.
• Writing installation scripts to install programs at the client site.
• Performing database administration activities using ORAINST Facility and SQL*DBA.
• Import/Export Utility