Summary:

Has an extensive strategic background, including success in a series of SDLC, consulting, project management, turnaround, re-engineering, and re-organization assignments. Proven Project Management and business skills in SCM , Manufacturing with more than 15+ years of working experience in the Functional and Technical, Tax, Export compliance and Trade Compliance areas. In depth knowledge of Distribution, Discrete Manufacturing, Financials including ECO's under Oracle Quoting, Install Base, PLM, Service Contracts, Oracle Receivables, Oracle Configurator, Cost Mgmt, BOM, OBIEE, Oracle Purchasing, Oracle Assets, Oracle Receivables, Oracle Inventory, Siebel, Oracle Order Management, Advanced Pricing, Workflow, AOL, WEBLOGIC, B2B,ETL,BPEL Fusion/SOA architecture.

Strengths: IS Customer End User relations, significant experience in the areas of Systems planning, Analysis, Design, Documentation, Implementation, Management, and Support. Performance and results oriented manager driven by goals, time frames, and quantifiable benchmarks. Molded professional project teams with diverse technical, cultural, and language backgrounds to complete projects on budget and on time.

EDUCATION

Bachelor\'s Degree in Science
Master's in Computer Science and Applications, Pondicherry University
Higher Diploma in RDBMS & Business Intelligence
Oracle Corporation certification in Oracle Discrete Manufacturing (BOM, Quoting, Install Base/SC, WIP, PO) , Oracle Distribution (PO, INV, OM).

ERP SKILLS

ERP: ORACLE APPLICATIONS R12/R 11.5.10.2
(Order Management, Quoting, BPEL/SOA, Configurator Schema PTO/ATO , Bills of Material ,Work In Process, Oracle Payables, Workflow, A/R Billing, ETL, Oracle General Ledger, Inventory)

Training: Oracle Manufacturing Applications (Oracle Corporation, U.S.A)

Oracle Certifications for Oracle Inventory, Oracle Engineering, Oracle Quality, Oracle Bills of Material, Purchasing / WIP, Accounts Receivable, Oracle Base / Services, Order Configurator R 12, Oracle Purchasing, Oracle Costing, Oracle Order Management / Shipping (Oracle Corporation, Dubai, U.A.E.)
UNIX Operating System - Fundamentals and System Administration (Data General)

PROJECT EXPERIENCE

Confidential, San Jose - Dec '09 - till date
Lead Business Analyst

Overall Responsibilities:
Worked closely with clients like Linksys, Tandberg, Webex on identifying their business needs and partnered for developing technology solutions to fulfill their business goals

• Lead Project Teams in Quoting areas to enable client and internal project delivery, coordinates with Client Services, PMs and Department Leads to ensure the project meets client/internal requirements.
• Emphasised the OAM (Oracle Quote Approvals Management) hierarchy need, ATP rules associated with profile validation in R12 Quoting for the XML Pub Quote templates in enhanced PDF & RTF print modes.
• Default Rules logic implementation to define Quotes loaded with the Header template and lines which needs to be in place for Sales credits allocation in external engine.
• Assisted in building logic for the Contracts associated with Quotes with Internal approval models
• where quotes need to be printed or emailed/faxed HTML/XML templates automatically during
• approvals
• Regular customer engagement for feedback on the deliverables and real time corrections to minimize escalations resulting in increased business and satisfaction.
• Created the requirement document plan in Quoting for Quote expiration logics along with configurator sync ups, project plan, and implementation plan and project closure.
• Educated user on the Projected compensation in OIC for deriving the sales credits zone/wise.
• Improve processes, solve issues and achieve goals within the given SLA's and cost constraints.
• Formulate and guide in application design, technical architecture ,guidelines,coding standards in pricing engines and respective pricing attributes.
• Lead virtual teams using communication tools like instant messaging, conference calls, and collaborative team portals and quotes entered by various systems.
• Driving quality and process improvements end to end for better service using Cisco Business Value keeping the customer approach in mind.
• Putting robust performance measures in place for performance management on people and processes. This includes clear goals for individuals and measures based on SMART KPI's.
• Communicate proactively to management any potential issues that may hinder the ability to meet project deadlines.
• Created several FRD\'s for Oracle Configurator R 12 configuration and setups and guided the IT Biz Analysts to run adhoc scripts after approval CAB process via PPM interfaces, Zomax and Gilmore 3rd shipping interfaces
• Multicurrency credit checking setups, profile defining, pricing formulas, modifiers etc.
• Day to day issues with license key, SFM queue and de-queues,IB, OM, service related issues, API customizations with Order Holds, Releasing them.
• New Item Catalog, Revisions, SKU relationships, BOM creation with respect to discounted items, distributor's discounts, price book generations etc.
• Datamart extracts to Bookings database for checking export compliance with RMA's received for last year, GL extracts into Bookings with AR data.
• Designed and coordinated with Item revision, Item manufacturing partner nos, Relationships which includes the VS4, PID Item series , these SKU's are serialized so they generate individual license keys for customer redemptions.
• Order Management Release 12 as the key focus including variety of skilled work in Order imports customizations with TCA for the pricing with PRM (partnership Id's), export of customer relations, for discounting during order imports with IE orders (cork) for various distributors, partner selling programs.
• Install Base issues with products in connection with the middleware portals where license key get sent out to the customer, registration happens followed by service contract creation, termination. RMAs created through a zoom form needs to be expired in IB and Service cancellations requests etc.

Confidential, CA Mar'08 - Nov'09
Business Analyst

Oracle Applications R12 /R11.5.10.2 EBS ( Quoting, Configurator,Oracle Order Management, Receivables, iPayment, 3Party Logistics, Inventory, ATO, Service Contracts, Installed Base)

Prioritizing Planning and Organizing prime time on Production support (critical daily issues for EBS Suite of Manufacturing and /or Finance Applications R12 .

• Solutions catering for Oracle Product(module wise support) irresolvable functional/technical issues with Oracle Gold/ Platinum support for OM, Install Base, Order Import/TCA ,service contracts holds/order booking holds, Siebel, Installed Base areas. AR Invoicing to GL, OBIEE report specs,IB Creations when booking orders until termination. (Serial nos). Oracle Receivables interface, Order Import, BPEL and also troubleshooting with credit memos not generated
• Functional Support for EVAL Orders,Quoting in Global Trade Compliance for Int'l Orders RMAs integrated with FEDEX systems on a regular basis assisting. Problems related to WIP jobs, Items revision issues, Order hold problems, progress orders which are stuck due.
• Order Mgmt Vs WMS Issues related in comparison with container, lot number. Customized the Inventory locator in order to find out whether locator is empty and constantly updating it to let the physical locations to fill them. Temporary and permanent fixes in WMS Dashboard to see the shipping status and dimensions
• Created design directly for Financial Systems Analysts, worked with business users and /or super users to resolve all types of tier 1 , tier 2/ sustained issues helped them to get reports in the systems for all departments including customer problems with software applications including Clear Orbit. Month end activities related to close of Books, managerial reports for End Users / Super Users.
• Served as contact for end-users if business super-users or primary analysts when need arises for them to resolve application issues in Installed Base and Service Contracts(software , oracle form, reports, xml, technical help)
• Developed and Implemented various test strategies and author test plans as required for application releases, enhancements and patches (Readme.txt) assisted in Regression testing
• Solutions delivered to several issues like tax calculation, customer address validations, workflow issues with order booking, ATO not progressing due to WIP jobs and the problems in regards to WIP Job Completions.

Confidential, Aug' 06 - Feb'08

Oracle Applications R11.5.10.2 (Quote, Install Base, SC,AR,OBIEE, Order to Cash, Vastera, WMS, Inventory, Purchasing, Discoverer)

• 24X7 Sales Orders flowing on a regular basis through several systems like AIO(All in ONE, WEB, Events System Registration, Legacy applications Orders to Oracle Open Interfaces get loaded periodically into the OE Schemas and then every 20 mins they get validated and loaded via Order Import while errors get tracked by IMTF (Integrated Message Tracking Framework. Mostly corrections in Negative price, order type exceptions reports on a daily basis on call rotation.
• Canadian and US Orders distinguished by their specific order types, cross border shipments with US Banks & Canadian Bank logics handled in Customer & Sales Order Open Interfaces. The volume load is around 50,000 to 60,000 on peak days. The programs are written in such a way all the Orders have to be pick, shipped , proof of delivery done in 24-48 hrs time slot with trade compliance JP Morgan Vastera.
• PTO/ATO Ordering tool capability through order Configurator (rule development process) , Schema BOM load and assisted with Order Mgmt issue for workflow related activities in Retry, ELA lock qty
• Design creation for Order Management/Quote Q1FY12 (Schedule Order, Change Order, ASN messages) through CIXS file to the eB2B team Cisco Pids, bundle product, star items etc.
• Legacy system migration of existing service contracts, approved/billed and historical data from the system.
• Customizations, Batch processing, redesigning and Shipping interfaces, Quote to cash entire flow with OM for serialized and non-serialized products with existing prior converted bills
• Designed PTO items through the configurator with OM customizations.
• Licensing call failures with middleware BPEL with batch setting issues for generating the flex codes, licenses with Install Base issues not generating a contract and records stuck in the IB interface. Physical shipments being done by zomax shipping interfaces with serialized products. AR Invoice interface issues with tax codes issues invoice splitting troubleshooting problems. Orders troubleshooting with any kind of issues and progressing them with 24X7 support, Q-End support for OM/AR close books.
• Business side troubleshooting OM with Install base (CSI Instance Interface ) with stuck records during the Order Fulfillment process, RMAs, IB Splitting issues, expired IB\'s and Contract generation issues along with license , flex code generations (customizations) for VM ware based products
• Assisted IT with Material transactions cancellations issues due to allocations with pre existing reservations, MMT's & Material temp clearing assisting with Internal Sales Orders, also assisted in building reports 6i and OBIEE plus using for Order contract reports

Confidential, Irvine Mar '06 to July '06
Business Analyst

(OM, Service Contracts, Install Base, Shipping software 3PL's, Custom Pub API's)

• Sustainment role and OM Shipping troubleshooting with SKU's which will not have Item attributes such as Orders Enabled , transactable, stockable. Solutions provided for problem in areas like Picking, Shipping. Permanent fixes provided for move orders problems associated with it.
• Order Mgmt Vs WMS Issues related in comparison with container, lot number. Customized the Inventory locator in order to find out whether locator is empty and constantly updating it to let the physical locations to fill them. Temporary and permanent fixes in WMS Dashboard to see the shipping status and dimensions.
• Order Mgmt Vs Inventory Issues like lot controlled enabled items, opening up period related problems handled on a daily basis. RMA's related problem like Items not on returnable chart, workflow progressing issue resolution with returning to different warehouses.

Confidential, Feb '05 - Feb '06
Business Analyst

Coordinated with Kerr Manufacturing Operation Engineers by providing Functional & Technical help (Production Support) in Oracle Manufacturing including Quality module, Bills of Material, Work in process, Oracle Inventory and Other Oracle Modules.

• Lead Time update MFG: Developed and designed various routines for updating the fixed lead times external upload using SQL*Loader, PL/SQL
• OM Beaver Shipping Extracts Download: Beavers Dental had an external data extract from Oracle 11i run everyday to update all the Shipping / WIP lot controlled data. The Oracle extracts serve as a feeder program in huge volumes of data to Beavers.
• Performed the complete TAR assistance working with oracle support to resolve issues with Sev-1 Issues Order Management, Purchasing, Inventory, Bill of Material
• Designed Beavers Customer Make to Stock / Make to Order Items Interface - Orders where entered into mainframe and loaded as Customer MDS, MPS then gets added into MRP Planning. Trouble shooting performed via Installed base to track all stages of the order in Normal Orders in Order Management, Clean Up the RMA Receipt Issues and straighten out the Hung up ones in the Material Transactions table.
• Oracle Configurator (CZ Schema ) where the Indented Bill of Materials will be configured when the order entry happens, the CTO (configure to order) basically lets the Customer to choose between the products which is suitable for him in order to purchase the SKUs.
• Performed the role of synchronizing both the ATO model, option class, Standard Bills from an Non Oracle system through Interfacing ATO Model component in order for the configurator to pick the right tree structure on the BOM level.
• Also in a scenario where the customer configures a part, this could be corrected before order fulfillment (at the stage before booking) so that the pick release can happen well and the orders can be progressed to the specific customer

Confidential, CA Feb '03 - July '03

As a Senior Consultant, was involved in the Implementation and Customization of Oracle Applications (Oracle Inventory, Oracle Purchasing, Oracle OM, Oracle WIP, BOM's, and was responsible for the following:

• Developed server side PL/SQL Packages, procedures and functions that are used in custom forms and reports.
• Developed packages for inserting transaction data into inventory transactions interface tables.
• Created and maintained database objects like tables, Indexes, synonyms, sequences which are used in custom module.
• Worked under tight time deadliness and at the same time on multiple assignments. Worked constantly for extended hours and sometimes as per global time zones.
• Customization and enhancement of standard Oracle applications reports in purchasing module. Creation of business critical reports that saved a lot of time of buyers and gave them access to relevant information at right time.
• Preparation of functional and design documents.
• Developed Custom Reports in Reports 6i (Inventory value report, Serial numbers transaction reports, Receipt Traveler reports, Inamed Planning detail report, Printed Purchase Orders for Inamed, Pick slip documents, Bills of Material item listing reports, Reorder point and safety stock reports, Inamed Approved supplier reports, Inamed GL detail report.

Confidential, Nov'02 - Jan'03
Oracle Applications 11i (Engineering , PO, INV, OM, BOM, WIP, Oracle Services)

As a Senior Consultant involved in the Implementation and Customization of Oracle Applications (Oracle Inventory, Oracle Purchasing, Oracle OM, Oracle WIP, BOM's, Oracle Engg) and was responsible for the following:

Worked with Users on business requirements in the service provider / service logistics area. Designed training materials to bring users up to speed with the standard system functionality Performed an initial configuration of the system to support training and demonstration activities. These activities where done within the AIM.

• Customer order tracking from Order Management and the planning process done in i2 planner (another Factory planner tool) which will create the work orders based on the demanded sales order & forecast build orders depending upon the Demanded orders (Orders shipped with 24 hours - Fast track orders) including the normal work orders to create the DJ's depending upon the availability and later linking with the WIP to synchronize the created the jobs.
• Created several reports for Order Entry such as Sales order acknowledge reports, Inventory Value Reports, Warehouse Multi organization Quantities reports, Serial number status reports.
• Error tracking support for all failed orders during Order Import phase, checking on the problematic orders help trouble shooting cycle statuses
• Involved in the up-gradation of Oracle Applications 10.7sc, 11.0.3 to Oracle Applications 11i Release.
• Performed the complete TAR assistance working with oracle support to resolve issues in Order Management, Purchasing, Inventory, and Bills of Material.
• Patch validation, regression testing, and done complete up-gradation support on 24X7 with issue tracking skills.

Confidential, SEATTLE, WA Nov'01 - Oct'02
Oracle Applications 11.0.3 (PO, INV, OE, BOM, WIP, Oracle Services)

As a Senior Consultant, was involved in the Implementation of Oracle Applications (Oracle Inventory, Oracle Engg/ Agile, Oracle Purchasing, Oracle OM, Oracle WIP, BOM's, and was responsible for the following:

Merging two set of Books (Terabeam Corp / Terabeam Networks) with major customization of
the following:

• Worked with business users to understand and document business requirements.
• Complete cycle of Order Entry - Entered, Reservations, Approved, Pick releasing of orders, various order cycle tested, setting up of Order cycles, Partial shipments, Full shipments, ATP and Demand quantities and cancellation of shipments at the application level.
• Setup of Price Lists for different Order Cycles, Order types, RMA types with various classes.
• Involved in defining Key flexfields and required Descriptive flexfields
• Setup the various order holds, removal of order holds, checking with items wrongly assigned with their item types such as Purchased item, FG, Manufactured Items.
• Defining Order Cycles - Demand types - Defining RMA - Return from customer's inter-organization transfers.
• Setup of Internal Order Requisitions - Currently set for 3 Organizations.
• Involved in solving critical after Post GO-LIVE issues
• Implementation of Miscellaneous receiving, Account Sub-inventory transfers, Inter-organization transfers, Inter-organization Shipment transfers, Internal requisitions, Normal Purchase order receiving from the various sources like vendors, Inventory correction with Serial Nos of In-transit shipments.
• Setup the Kan Ban Card Process with auto sourcing in Blanket PO's. Automated with the PO Requisitioning process.
• Automated and provided on line support for the MRP /MPS planner to give periodic reports for the Inventory Stock Co-ordinators in reference with open orders (Sales Order Updates)
• Worked extensively with Serial numbers status tracking and their statuses, set up various Inventory Locations / Town coordinators / Warehouse status reports to know the serial transactions like Denver town, Seattle town, Chicago, Dallas networks.
• Activated / deactivated Inventory Organization controls. (i.e run Seed data for new organizations)
• Successfully implemented the Serial genealogy for most of the Terabeam owned parts.
• Completed automated Purchase Receiving process - Receive, Transfer, Insect (Reject /Accept), Delivery into the respective stock locators of the Component warehouse.
• Maintained a high level support with End users time to time to design oracle standard reports / Documentation standards.
• Trained users on Oracle Discoverer Admin / Oracle End user versions to match with Oracle Standard Reports in 6i and educate them to work independently.
• Error corrections with PDT / Oracle Agile items and mostly with Engineering Items like Elliptica, Terabeam Dashboard
• Creation of Purchase requisitions workflow - the whole cycle of purchasing implemented, tested and supported the application level, end user level and the database table level updates.
• Created RFQ's Approval cycle for all Terabeam employees
• Implemented cycle counts which was successfully done with the physical inventories in the various organizations and reorder leveling.

Confidential, MILWAUKEE, WI Nov'00 - Nov'01
Oracle Applications 11.0.3/ 10.7, Configurator,BOM, OM, PO, INV Implementation

As a Senior Consultant, was involved in the Implementation and Customization of Oracle Applications (Oracle Inventory, BOM, WIP, Oracle Engg/ Agile, Oracle Purchasing and was responsible for the following:

• Configurator Setups including the model bills, the Orderable inventory items(OM setup) ,user interfaces, performed troubleshooting at runtime where the configurator defaults at runtime during order entry which allows the user to configure (pick ) on the respective ATO model, catalog elements, model bills, Option class, BOMs which are done prior to Order entry/clerical work is done.
• Setup the Default Receiving transaction Processor, Zebra and Kan Ban labels printing for various organizations like MKE, Anapolis, and IIS - Mt. Prospect, Border Critikon operations, Complex Agile reports (ECO's).
• Most of the Inventory Setups including the transaction sources, locators and their associated flexfields, subinventory organization setups, Shipping inventory locations, operational units, currency declarations. Profile settings for Inventory Item validation organizations MMS Master, MMS Ann, MMS Bop, MMS Set of Books.
• Setup the Error correction system for WIP discrete Jobs and discrepancies with WIP Mass Loads, Functional problems / Technical issues with Serial Numbers and the purge On-Hand Jobs during the finish cycle.
• At GE Medicals, highly involved with Customer Order Management with setting up the Order Cycles, Order types, RMA types with various classes like CAP-RMA GE Marquette Subsids CAP-RMA GEMS CAP-RMA NO CREDIT, ExportRMA mit Gutschrift, Export RMA Gutschrift AUT and also assisting Users in RMA Receipts discrepancies with serial numbers unable to receive them back into MKE-Org, setup the various order holds, removal of order holds, checking with items wrongly assigned with their item types such as Purchased item, FG, Engineering Items / Manufacturing items.
• Setup of Price Lists for different Order Cycles, Order types, RMA types with various classes.
• Assisted the End Users with Legacy system Import in Creation, Updation in MR / ER for various depts. (This includes all Solar Panels, Cardio Items, MARS3000, DashBoard across various locations like Anapolis, Wallingford, Prucka, Milwaukee)
• Created designed documents , test cases, pseudocoding, coding with Oracle coding standards for various INV, BOM, PO, OE Interfaces