SUMMARY

• About 21 years of total IT experience in Oracle software with 15 years of experience as lead functional and technical analyst for initiatives in Oracle Release 12 and 11i Applications in Supply chain, financial, Order to cash modules performing the tasks of leading the projects, being a liaison between the business users and the design and development teams, analyzing the gaps, gathering business requirements, defining the process, designing, developing, administering, testing, reviewing documents and programs, deploying and providing continual production Support for business.
• About 5 years of recent experience as lead functional and technical analyst in Value Chain planning with 2 years of experience in Oracle Demantra implementation using Demand Planning, Demantra workbench, Business Modeler and Demantra workflow and three years in the implementation of a custom demand planning system that got replaced by Demantra.
• About 3 years of experience as lead functional analyst in iSupplier implementation. Excellent Communication and Interpersonal Skills and two Master’s degrees.

TECHNICAL SKILLS

Oracle E - business suite: Oracle Applications Releases 12.2.4, 12.0.4, 11.5.10, 11.5.9, 11.5.8, 11.5.7, 11.5.5, 11.0.3 and 10.7 in Value Chain Planning (Demantra - Demand Management, CTO, Worksheets, Business Modeler, ASCP, APCC), iSupplier, iProcurement, Purchasing, Inventory, Bill of Materials, Shipping, Order Management, Accounts Receivables, Accounts Payables, General Ledger, EDI Gateway, Advanced Pricing, CRM (Contracts and Services), OTL (Time & Labor), Project Accounting, Cost Management, Fixed Assets, Cash Management, Workflow, Application Object Library, Application Implementation Methodology(AIM)

Languages: SQL, PL/SQL, C, C++, Pro*C, UNIX Shell Programming, Java, JSP, Java Servlets, XML, Java Script, VB Script, ECMA Script, HTML, DHTML

ORACLE: Oracle (12c,11g,10g,9i,8i,7x), Oracle Forms 9i/6i/4.5, Reports 9i/6i/2.5, PL/SQL, SQL Developer, Pro* C, SQL*Loader, SQL*Menu, Export, Import, SQLab Vision, TOAD

TIBCO: Business Works, Business Connect, Integration Manager, Database adapter, file adapter, Rendezvous, Adapter SDK, Message Broker, Hawk, Inconcert

PROFESSIONAL EXPERIENCE

Confidential, NJ

Senior Supply Chain Functional IT Analyst

Responsibilities:

• Functional and technical lead for the implementation of demantra.
• Implemented Oracle Demantra to replace the custom oracle legacy system called demand planning system.
• Defined requirements for loading CTO (configure to order) structures into Demantra from oracle R12 product bill of material product structures.
• Identified and defined all the product related setups required on the item master and bill of materials hierarchies.
• Defined requirements for custom data load of booking and shipment demand history into demantra.
• Debugged and fixed issues from oracle seeded demantra collections and workflow.
• Defined requirements and reviewed code for the custom series in demantra.
• Defined requirements for various levels in demantra for products and locations.
• Configured levels, series and parameters using Demantra business modeler.
• Created custom demantra workflow processes.
• Created worksheets according to the requirements of planning users.
• Provided training to the planning users on Demantra.
• Conducted CRPs (conference room pilots), end to end testing and user acceptance testing with users.
• Used HP quality control tool to record and track the test results.
• Tested the demantra item chaining functionality for product transitions.
• Created Service Requests and worked with oracle on Demantra issues.

Environment: Oracle EBS R12.2.4, Oracle Demantra 12.2.4, APCC, ASCP, OBIEE 11.1.1.7, PL/SQL, Windows servers 2008, IBM AIX

Confidential, NJ

Senior Supply Chain Functional IT Analyst

Responsibilities:

• Functional lead for Mobile D&A project that is implemented to provide drivers with most up-to-date delivery details on the mobile and give the drivers the ability to update the shipping status on the mobile and automate D&A capture.
• Gathered requirements and created design documents for below objects
• EDI 204 Interface to transmit a trip sheet to shipping company so the drivers can load the schedule in the handheld’s mobile app
• Same EDI 204 Interface to transmit the updates and cancellations on the deliveries/RMAs to the handheld on a near real time basis.
• EDI 214 Interface for receiving the status updates and customer signature from the drivers of the shipping company for the deliveries.
• Customization for constructing the D&A documents.
• Coordinated the end to end and user acceptance testing activities between the shipping company and the internal business users and the development team.

Environment: Oracle EBS R12.2.4 (Order Management, Shipping and OTM), PL/SQL, EDI, SOA, Windows Servers 2008, IBM AIX

Confidential, NJ

Senior Supply Chain Functional IT Analyst

Responsibilities:

• Functional lead for the implementation of iSupplier module.
• Conducted requirements gathering meetings with business users
• Defined requirements for customizations on iSupplier portal pages and iSupplier workflows.
• Lead the efforts to automate purchase order creation, purchase order acknowledgements, purchase order approvals via iSupplier portal
• Lead the efforts to automate submission of ASNs and invoices via iSupplier portal pages including the upload of bulk of ASNs and invoices.
• Tested the iSupplier module with all the customizations
• Created Service Requests and worked with Oracle on the issues from the seeded software.
• Tested the patches from oracle and got them installed in all environments.
• Tested the system and recorded the test results in the quality control tool.
• Prepared training documents for buyers and suppliers.
• Conducted training for all buyers in the purchasing group.

Environment: Oracle EBS R12.2.4 (iSupplier, Purchasing, Accounts Payable), PL/SQL, Windows NT, IBM AIX

Confidential

Senior Supply Chain Functional IT Analyst

Responsibilities:

• Involved in the capturing and maintenance of the source data for three years of order history
• Involved in the configuration of product family groups and calendars related to the forecast periods.
• Used the Extract, transform and load (ETL) tool called Oracle Warehouse Builder (OWB) to transform data to multi-dimensional in analytical workspace.
• Used OWB to define dimensions, levels, hierarchies and cubes for time, products and locations.
• Used OWB mapping editor to transform relational source data into single/multiple dimensions in the OLAP schema.
• Assisted with custom analytical workspace programs using OLAP DML to perform aggregations at various dimensions and cubes.
• Designed and developed the customization to calculate attach rate of the accessories to the corresponding machine in the BOM that is used for the forecast of the accessories.
• Implemented a user interface using Oracle Forms for maintenance of the product transitions.
• Configured parameters such as periodicity, trend, seasonality etc. for the oracle forecasting engine.
• Provided Support for the system and tuned the programs and configurations for improving performance.

Environment: Forms/Reports 10g, Oracle Warehouse Builder 10g, Analytical Workspace Manager 10g, Discoverer 10g, Oracle Database 10g, Oracle Application Server 10g

Confidential

Senior Supply Chain Functional IT Analyst

Responsibilities:

• Customer Value Development One Company One System project transitions legacy systems to Oracle 11i platform.
• Assisted with the design and development effort on RICE (reports, interfaces, conversions and enhancements) objects for supply chain group.
• Designed and developed customization of purchase order and requisitions forms and their corresponding lines and shipments.
• Customized the requisition approval workflow and purchase order approval workflow
• Performed configurations under purchasing and inventory modules in supply chain oracle.
• Customize Service Request form to integrate with interactive voice response (IVR).
• Involved in the design, development and support of EAI (Enterprise Application Development) interfaces for transfer of data between non-oracle systems, ERP and CRM modules.
• Used TIBCO Business Works to perform any transformation of the data and mapping the data to required message formats to publish the messages to TIBCO adapters.
• Used Tibco oracle adapters to read data from oracle tables and write data into oracle tables from the subscribed messages
• Used file adapters to read data from files and publish data into JMS messages and to subscribe to the messages and create files.
• Involved in the implementation of pick release interface for sending delivery details from oracle e-business suite to third party warehouse management system.
• Involved in the implementation of real time shipping interface.
• Involved in the implementation of purchase order interface with Japanese system for loading purchase orders and for creating dropship orders.
• Involved in the implementation for interfacing expected receipts for purchase orders, internal sales orders and RMAs.
• Involved in the implementation of interfacing items, categories, cost and other item related information and any inventory adjustments from Japan.
• Fixed the shipping interface and receiving interface bugs so warehouses can get orders quickly and correct to ship the products to customers.
• Involved in the implementations and support of EDI (Electronic Document Interchange) interfaces between several trading partners and oracle 11i and R12 systems.
• Used TIBCO Business Connect, business works, file adapter and Oracle EDI Gateway to implement the EDI 850 interface to load the inbound purchase orders from several trading partners and EDI 810 interface to send invoices from oracle to the trading partners.
• Provided functional and technical support on Confidential supply chain systems.
• Performed unit testing, end to end testing, conference room pilots and regression testing.
• Used the HP quality control tool and created test cases and plans and recoded test results.
• Involved in the testing of supply chain functionalities during to upgrade from Oracle 11.5.10 to Oracle R12.0.4 and during the upgrade from R12.0.4 to R12.2.4. Also provided solutions to resolve the gaps and issues identified during the testing.

Environment: ORACLE applications R11.5.10, R12.0.4, R12.2.4 (Purchasing, Inventory, AP, GL, BOM, AR, HR), Forms 6i, Reports 6i, PL/SQL, SQL *Loader, Tibco ADB and IM, Toad, PVCS, Remedy, Windows 2000, Sun Solaris

Confidential, Illinois

Oracle Consultant

Responsibilities:

• Managed the offshore development team for several enhancement projects.
• Assisted with design and implementation of inbound interfaces to create contracts, customer product references, customer sites, customer contacts using APIs.
• Involved in various outbound general ledger interface and outbound payables interfaces.
• Involved in the configurations of Confidential time reporting system.
• Designed the EDI 856 (Advanced Shipment Notice), 855 (PO acknowledgement report) and 850(Purchase Order Outbound) customizations.
• Involved in the setup of EDI vendors, trading partner groups, code conversions.
• Coordinated with the offshore team for development and testing efforts for enhancements.
• Assisted with production support of various custom reports and forms in Oracle Time and Labor.
• Assisted with the production support and enhancements on customizations in HR, Payroll, Services and Contracts and Oracle Time Entry.

Environment: Oracle Applications11.5.9 (CRM (Services, Contracts), HRMS, Time & Labor, Payroll and Benefit, EDI Gateway, Payables, General Ledger, Inventory and Purchasing), UNIX, Oracle9i, Forms6i, Reports9i, Workflow Builder2.6 SQL*Loader, TOAD, Kintana, Test director, changeman.

Confidential, Georgia

Responsibilities:

• Assisted with the implementation of a custom purchase order report on the predefined stationary
• Customized PO Approval workflow to create the purchase order report and fax it to the vendors
• Created an outbound interface for purchase orders and blanket releases to Cox’s New age transportation.
• Assisted with the HR employees and assignments conversion from peoplesoft to oracle
• Assisted with inventory items and categories conversion from JDE to oracle.
• Assisted with PO requisition templates and requisitions conversion.
• Customized autocreate documents workflow to create releases against contract purchase orders.
• Involved in implementation of journal entries interface from various source systems to Oracle
• Used Kintana for version control of the deliverables. And test director for defect logging.

Environment: Oracle Applications11.5.9 (Purchasing, Inventory, AP, GL, HR), UNIX, Oracle9i, Forms6i, Reports9i, Workflow Builder2.6 SQL*Loader, TOAD, Kintana, Test director, changeman.

Confidential, New Jersey

Oracle Consultant

Responsibilities:

• Assisted with analysis for configuration requirements and customization of revenue recognition process for receivables accounting to create invoice number and distributions of invoices, credit memos and debit memos, credit card processing,
• Implemented the customization of accounting process in costing for the inventory material, payables, purchasing transactions.
• Performed configurations and setup the lookups in AR.
• Designed and developed the Order Acknowledgement Report that will provide automated printing of order acknowledgements when orders are created.
• Assisted with functional designing of custom returns processing from order to credit memo generation to the accounting process. Since returns are interfaced through TIBCO into oracle from the legacy system called OPIM.
• Configured descriptive flex fields according to requirements.
• Assisted with functional and technical designing on inbound and outbound interfaces and custom oracle programs between Oracle AP, GL, BOM and Lawson financial system through Tibco using database, file adapters and integration manager.
• Assisted with functional and technical designing on interfaces to Oracle vendors in the purchasing module from the Lawson system through TIBCO.
• Assisted business users on the month end close for Canada and US operating units to go smoothly
• Assisted the users daily by analyzing the stuck transactions in the inventory, AR and GL modules and resolved the accounting issues.
• Troubleshoot the errors in auto invoicing, receipts creation, and accounts analysis reporting.
• Investigated patches on Oracle metalink and communicated potential benefits with business users.
• Analyzed the impact of TAR fix testing and applied TAR fixes to appropriate environments

Environment: ORACLE applications 11.5.8 (AR, Inventory, AP, GL, BOM), Forms 6i, Reports 6i, PL/SQL, SQL Loader, Tibco ADB and IM, Toad, PVCS, Remedy, Windows 2000, Sun Solaris

Confidential

Oracle Consultant

Responsibilities:

• Involved in the support of customizations for order management, manufacturing and financial systems.
• Unix Administration which involved installation and configuration of several software products used by Agere which are TIBCO (Enterprise Application Integrator), Appworx (an enterprise job scheduler), SQL Navigator (SQL development Environment). SQLab Vision (Application tuning product), which involved creation of server side, objects in the database Metric Stream (Monitoring Application).
• Worked with Confidential Global Support Center to proactively fix various types of functional and technical problems for the worldwide Lucent Technology and their customers.
• Developed the SQL scripts for Monitoring for any long running Processes, any locks on the databases, and Heavy I/O this hit as part of performance tuning.
• Also involved in EAI project for transferring information among several systems using TIBCO RV, Adapter SDK, ADB, MB, IM, Oracle, Teradata, ODBC, Terajdbc drivers, TIB Repository.
• Also worked with Oracle on the patches and their applications on the bugs.

Environment: Oracle Applications 11i, Developer 2000 (Oracle Forms 3.0, 4.5,6i, Report 2.5, 6i) suite, TIBCO (RV, IM, ADB, MB), PVCS, Remedy. SQL*Loader, UNIX, Oracle 8.1.7.4, Appworx, SQL Navigator, TOAD