SUMMARY:

• Result oriented professional with 19 years of diverse experience in Managing, Leading, designing, implementation, testing, documentation, and supporting Oracle EBS Application. Experienced in Supply Chain modules of Inventory, WIP, BOM, OM, Purchasing, iProc, iSupplier, VCP/ASCP, Shipping, Quality, Costing, GL, AR.
• Successfully executed several EBS Projects implementation and CRP sessions with Client/End User/ Business team members, performed several production cutover activities & successful go - live execution. Managed On-site, Offshore Technical & Functional Resources and Actively involved in milestone & Leadership Steering committee meetings.
• Principle Supply chain Professional worked in Discrete, Flow, Process, Project Manufacturing Business, having both Functional Expertise and Technical Knowledge. Worked in Defense, Semi-Conductors, Discrete, Flow Manufacturing, Retail Industries.
• Lead the Team comprising of Functional & Technical Professional, Contractors/Vendors.

TECHNICAL SKILLS:

Application: Oracle Applications 12.1.3, 11i(11.5.10, 11.5.9), Oracle Apps 11.0, Apps 10.7

Functional Modules: Inventory, Purchasing, Order Management, WIP, BOM, VCP, Costing, Shipping Execution, Quality, OPM, iProcurement, iSupplier, GL, Demantra, Projects.

QC Tools: Kintana, HP test director, cleartool, Landesk, Tortoise SVN.

Methodology/Tools: OUM, AIM, Lean Six Sigma(SPC), Data Loader, Visio, Oracle Patch Analyser, Excel.

PLM Interfaced: WindChill, Team Center, Enovia, Oracle PIM

Oracle Technologies: PL/SQL, Forms 10g/9i/6i /4.5, Reports 6i, BI Publisher, APCC, Work Flow Builder 2.6, Web ADI, XML Gateway, Application Express-Form.

Fusion Architecture: SOA, OAF, ADF.

Mobile Technologies: Oracle MSCA, BarTender (10.0 SR4), Skipjack (Cipher), P-touch Editor Ver 5.0, Intermac Scanning Guns & Printers, SOTI Pocket Controller-Pro Ver 6.02

Tools: TOAD 11.6.1.6, SQL Developer, TeraTerm, PuTTY

PROFESSIONAL EXPERIENCE:

Confidential

Application: Oracle VCP, Demantra

Responsibilities:

• Executed an Architect role in designing & implementing the key functionalities to fulfill the successful planning for the business. Managed the contractors, Apps DBAs and trained Master Production schedulers, Finite Schedulers to deploy the solution across the Several Sites.
• Designed the nightly MRS(Master Request Set) from collection to Plan Launch & flow of data to APCC. Introduced the concept of Simulation Sets & controlled the PTF(Planning Time Fense), FLM(Fixed Lot Multiplier), etc., Centralized access of functions from dashboard through personalization. Responsibility design, Org access, End-to end Cycle testing, etc.,
• Successfully executed the upload of Planned Orders process by the Planners in MPS, the flow the forecast from MPS to MRP between the Simulation Plan & Main Plans, Forecast Upload Process & allocation of On-Hand quantity for Distribution Planning(DRP).
• Designed APCC dashboard reports for the Item Exceptions, Material Risk Report, Pegging Report, Days of Cover, production report, etc for buy & Make planned orders.
• Coordinated with DBA, external certificate provider team to resolve the Java security Pop-up Issue, instance design, Patching Process, backup strategy, Data flow from Legacy to Oracle VCP instance.
• Guided the team in preparation of the required Training manuals for the MPS, Material planners, and Finite schedulers. Travelled to different sites to train the planners on-site for the seamless implementation of the Planning Project.

Confidential

Application: Oracle Inventory, BOM, WIP, VCP, PO, Shipping, Quality, Projects Mfg

Responsibilities:

• Managed the Full Cycle D2B Project implementation and actively worked with business, contractors / consultants, and resolved critical issues & even brought MSCA back online in production. Earned a reputation of ‘Go-to-Person’ for Oracle SCM process.
• Actively Involved with business to gather Requirements, Gap Analysis, Creation of Requirement documents (BR100, AN100), even guiding the development team to build Unified Label process & successfully implemented the 2D Single-Scan Barcode solution.
• Managing the Project Budget, Preparing the SOW, Interviewing & Finalizing the 3rd Party Vendors & mentoring those Vendors for proper execution of deliverables, monitoring the Vendor POs against the requested deliverables for Payment approval.
• Successfully executed the development & implementation of Oracle interface with Legacy(Delmia) Manufacturing Operations for Project Connect.
• Project Connect - UAT / Regression testing for D2B (Travelled across other US business sites to assist the business & testers to follow the correct Standard process) - successfully got the sign off from business.
• Active Role in CAB Meeting providing Details & Approvals needed for Business Request, Escalating the issues, Time estimates, Resolving resource constraints, updating the project status to the Steering committee Members.
• Guided the team and successfully implemented the Single server consolidation of VCP Project & decommissioned the need for seperate Planning server.
• Successful EXA Sever deployment for MSCA(skipjack) servers: Coordinated with Admin & Infrastructure team to manage all the skipjack configurations, Printer setting, MSCA Scanners, Ventureforth configuration, Testing of MSCA transactions, Coordinating with business testing sign-off, across the Enterprise sites.
• Responsible for interviewing and hiring the new team members, mentoring new team members, Defining the training Requirements for the Team members, etc.,.
• Awarded the Incentive Payment Program to participate as Key Team member in implementing the Managed Services(MSA), Preparation of RFP, Analysis & Transition to managed services.

Confidential, Texas

Application: Oracle Inventory, BOM, WIP, OM, Shipping, PO, Projects Mfg, ASCP

Responsibilities:

• Played a principal role in Directing the entire ERP Project team (Onsite & Offshore teams) in successfully executing the project deliverables on time as per SOW.
• Conducted several CRP sessions with business team to gather the functional specification sign-off from business Leadership & supply chain partners.
• Successfully implemented Oracle PIM module on Oracle 11.5.10.2. Conducted patch analysis using Oracle Patch analyzer tool to study the impact of the PLM Family pack “E” & RUP 22 patch set on Oracle Inventory, BOM, Engineering, WIP modules.
• Designed training kit for Oracle PIM module & successfully trained business users on PIM.
• Process to implement MUE (Model Unit Effectivity) for item in BOM structure, impact of item revision by ECO (Engineering change Orders), part change visibility to the Planners & buyers in supply chain team. Effect of Item substitution & constraints planning in ASCP.
• Played a Architect role in designing the ‘Routing Automation’ process for the newly cloned Assemblies that has hundreds of Sub-Assemblies & thousands of parts, there by achieving millions of dollars in savings to Client.
• Creation of Item & BOM structure for executing test scenarios using the Data Loader tool, creation of the Process flow charts using MS Visio.
• Guided the team to ensure the GE Process is followed and all the Documentation is prepared as per GE Tollgate process for both Technical (TAD), Functional design & testing documents and their related workflow for approval process.
• Mentor offshore team and taking care of their training needs, setting Goals & Appraising performance, also responsible for interviewing and hiring the new team members.
• Lead the CRP session to showcase the OPM (Process Manufacturing) concepts on Formula, Routing, Recipe, Batches and using Mfg Partner Organization to demo the IR&ISO cycle.
• Implemented Item revision process/reporting that depicts the revision details, whenever ECO hits the BOM structure before creation of Work order & after releasing the Work order to production.
• Responsible to deliver & Present the RFI for the clients requirement. Designed several RFP (Request for Proposal) for eNCR process that integrates WIP close with nonconformance data via SOA BEPL Process for data transfer. To Cancel PO Notification process, BOM reporting snapshots.

Application: Oracle Inventory, OM, WIP, Shipping, PO, Contracts, AR.

Confidential, CT

Functional & Business Technologist

Responsibilities:

• Successfully lead, designed and implemented the functionality of Instore Inventory process, which gave the ability for the business to forecast and replenish the inventory for the ‘Instore’ project within the Oracle Application R12, there by eliminated the use of a 3rd party software. This includes new item creation, new Sub-inventory creation, Bill of materials, on-hand qty, Audit transaction, custom UI in forms 10g with the suggestion for planning data.
• Lead role in implementing Oracle Transportation System (OTM). Rolled out the OTM system to several orgs across the nation. Also successfully designed several SOA- BEPL process with database and file adaptors for the Instore category import, Hardware import, Store import which takes data file as input & import data into Oracle custom database. Also sends an email notification to business on successful data import.
• Successfully streamlined the P2P process across the company by decommissioning the Ariba procurement system used in the EAM (Enterprise Asset Management system) into a single Oracle Procure to Pay system. Lead the offshore team in creating the interfaces & Oracle SOA - BEPL process to transfer the requisition data from windows Server used by EAM into Oracle for PO creation and Receipt data there by driving efficiency within their transactions, increasing visibility to spend, and insuring governance over the process.
• Deploying the Offshore Resource to train the Internal Resource in Fusion Technology. Creation of UI in ADF for Graphics Services Extract, that exports the order data into Excel and successfully deployed in the ADF server & launched as a part of menu in WebCenter portal.
• Lead the implementation of ‘Instore OTC’ project for the Instore business. Managing the offshore resources for successful on time deliverables, conducting schedule meetings with Functional & Development team and conducted POC & reviews. Coordinating with the business team on design reviews and finalizing the business requirement specification on functional & integration testing.
• Coordinate with technical team on improving the performance for the several Oracle key concurrent process, so that after performance tuning it’s successfully completing in few minutes, which used to take hours to complete.
• Launched and Successfully conducting the weekly “Learn & Share” sessions to present & demonstrate Functional key topics on Oracle Supply Chain modules and also on various new emerging technologies (SOA, BEPL, ADF, OAF, XML-Pub, etc, there by giving hands on exposure to both development & functional teams.

Application: Oracle Purchasing, Inventory, OM, WIP, MRP, Flow Mfg, BOM, iProcurement.

Confidential, Mid West

Sr. Analyst

Responsibilities:

• Successfully designed the requirements, creation of Functional Document and implemented the Supplier performance process, which gives the ability to the Supply Management to closely monitor the Vendor's Performance on key QCDS (Quality, Cost, Delivery, and Customer Service), attributes for a given supplier. Various custom supplier Performance reports and Report on ‘Supplier Report Card’ aids in achieving this Monitoring Process.
• Designed the Delay receipt detail process that gives the ability to directly email the suppliers with attachments on the details of the delay in the received items with respect to PO & release for a given supplier. This custom correction process enables the supply chain Management to do the corrections on the delay in receipts, whenever the vendor submits the proof for the On Time delivery. Thus it makes a closed loop for Vendor monitoring & controlling process.
• Successfully designed the Process & implemented the Dynamic Quality Collection Trigger process which acts as a foolproof (Poke Yoke) in the manufacturing process and ensures delivery of Quality products to the customers. Future enhancements on quality checks to the manufacturing process can be added, with minimum code change as most of the functionality is dynamically controlled through the set ups.
• Manufacturing Label Generation Process for the finished products. Templates were designed using ‘Jet form designer’ & to modify existing Layouts for Unit label, Shipping and other special label requirements to accommodate the new attribute changes for the end customers.
• Successfully designed and implemented the new flow scheduling process for the cellular manufacturing unit to meet the manufacturing requirements. To process the creation of flow and plan schedules from MRP unscheduled orders. .
• Responsible for Design & Testing of the Custom solution for iProcurement requisition process for additional validation on some specific category of items, Project Number and Task Number, which should stop End-User from creating the requisition for invalid entries. This has also been upgraded to the 11.5.10.2
• Creation of Standard process that allows the users to add various new filtering logic, for the custom process with the use of common Dynamic Where clause.

Application: Oracle Purchasing, Inventory, OM, WIP, MRP, AR, AP

Confidential, San Jose, CA

Responsibilities:

• Designed the functional specification to fulfil the business requirement, creation of test data for development, successfully tested & deployed a new Receiving Transaction Preprocessor for the Inter company shipment data received from the 856 ASN Inbound Feed.
• Personalization on Standard Oracle Receipt Form in both 11i & 11.0.3, to prevent user from doing a standard Receipt of inventory against the Inter company vendor.
• Design, testing & migration of custom reconciliation reports between OM & PO for the Inter Company EDI Receipts and a new ‘Consolidated Inventory Report’, collecting the inventory details from the MRP & Inventory modules.

Application: Oracle 11i Order Management, Shipping, Purchasing, Inventory, WIP, BOM, EDI, AR, CRM Collection

Confidential, Webster, NY

ERP Lead Architect

Responsibilities:

• Collecting the Business Requirements & performing Gap Analysis for implementing the Dropshipment Process for Supplies Project. Design new Requisition Import pre-processor, to validate the Drop shipped sales orders in batches, these purchase released orders will get processed by this pre-processor, with vendor details, blanket PO number, PO line number, unit price, UOM, etc., To process the flow of Order information from OM to Purchasing.
• Worked on customizing Work Flow for the supplies project. Added new custom activities to the existing work flow, included message, notification elements, verify access levels.
• Designed the Functional Specification for Xelus inbound which is a third party planning tool for the Xerox paper supply products, to import the Xelus Replenishment Orders in the D300 format, through SQL loader submitted from Shell script. Also designed outbound interface to generate the D345 Xelus error transactions, for orders deleted from the error correction form.
• Created item substitution form, where item can be updated to the form only at the Substitution Admin Responsibility.
• Worked on building new Oracle Forms, customizing the standard Oracle Forms, and building new Zoom forms, customized CUSTOM.pll. Customized Sales Order entry Zoom form at header and line level, which has fulfilled all the functionality been used across all the Xerox IM projects viz., OFD, OTC, DMO, Supplies Orders using oracle Forms 6i. All the orders have to flow through the form for initial booking of orders. Complete form was build using the ‘tab’ functionality.
• Providing e.max Functional production support & training the users on the functionality.
• Build new custom 6i reports and converted many Oracle 11 reports to the 11i in the Order Management and Inventory modules Xerox Daily Inventory Report, Xerox Orders Not Reserved Report, Xerox Xelus Error correction Report, Xerox Daily Available Quantity Report, etc
• Designed a Process using the Sales order zoom functionality to Displays the job order number for a particular ATO order, for multi configuration order it will display the array of job numbers for each model in the order.
• Customized Universal Work Queue (UWQ) which displays the Customer delinquencies, Broken promises, and Strategy work items nodes in the CRM Collection work bench. Metadata Administration spread table setups were done to accommodate Xerox custom requested attributes like, Collector name, manager name, aging buckets, etc. Build a new custom UWQ refresh which runs, every half hour refreshes the UWQ.
• Worked in the design & development of various custom interfaces for the Oracle ATO Order Import feed preprocessor, Item import, developing GL interface, receiving transactions processor, Apply AR invoice Payment processing etc.,

Modules: WIP, BOM, INV and AOL

Confidential, Austin, TX

Consultant

Responsibilities:

• Customizing some of the standard reports in WIP and INV module according to the client specification, that are supported by the applications viz.,
• Discrete Job Data Report
• Discrete Job Pick List Report
• Item Reservations Report
• Building of new custom report as per client specifications for “Discrete Job Reason Code Variance Report”

Confidential

Environment: Oracle 8.0 and Developer 2000, Forms 4.5, Reports 2.5, Windows 95

Manager (Information Systems)

Responsibilities:

• As a part of core Cross functional Task force Team, working closely with all the functional Departments including manufacturing to implement MSD(Manufacturing System Redesign) mentored by Lucas TVS, U.K.,.
• Preparing Industrial production system unit cellular Layout using AutoCAD. Training the shop floor personnel on the Six sigma tools, TQM and Lean production system principles.
• As an “Internal Quality Auditor” raising the NCRs for any non conformity found in the process for the ISO 9001 Quality Systems.
• The aim of this project is to enhance the ‘Digital Manufacturing’ initiative, by completely eliminating the maintenance of the hard copy of “NCR” which is very important under the two ISO 9001 clause 4.05 “Document & Data Control” and clause 4.16 “Control of Quality Records”.
• During ISO Internal quality audits whenever the auditors finds a non-conformance he can automatically book the NCR Online & details will be stored at Oracle database, also auditees of the respective departments can view their NCR received from their respective department terminal.
• The entire package is divided into: