PROFESSIONAL SUMMARY:

• Analytical and highly adaptable IT professional with more than 15 Years of IT experience
• Extensive experience as Techno - Functional Lead / Solution architect to implement applications in Procure to Pay, Quote to Cash and CRM
• 15+ Years experience with Oracle Applications - Strong experience in customization, design, localization, upgrade and enhancement of Oracle Applications R12/11i Supply Chain (Order Management, Shipping Execution, Pricing, Inventory, Costing, Purchasing, iProcurement, iSupplier, Receiving, BOM, WIP), CRM (Install Base, Service Contracts, Teleservices, Warranty, Trading Community Architecture), FA, AR, AP and GL
• 8+ years of experience designing B2b integrations between Oracle Application and various systems using EDI, E-Commerce Gateway, XML Gateway, SOA Gateway etc.
• Worked with large Oracle integrators like Confidential (as Employee), Confidential, KPMG, CSC and Intelenex.
• 13+ years’ experience as functional Lead / Business Analyst in Quote to Cash, CRM and Procure to pay cycles.
• Specialization in Order Management, Shipping (Pick Release and shipping process), Inventory Management, Install Base, Service Contracts, Costing, Purchasing, MRP, iProcurement, iSupplier, AP and AR Modules.
• Extensive experience with architecting/designing/mapping interfaces and B2B integrations between Oracle and SFDC/Legacy/vendor systems. Designed and configured integrations such as PO, RCV, SO, RMA, Inventory Transactions, Shipping, WIP, MRP, Service Contracts with other systems using EDI, Boomi, EDI gateway, XML Gateway, SOA gateway etc.
• Worked closely with Major Manufacturing and distribution (3PL) companies like Flextronics, Sanmina, CTDI, Expeditors and FedEx to integrate Oracle Applications with their systems.
• Worked as Functional Lead with Hi-Tech Manufacturing companies like Confidential, Volterra Semiconductors, Confidential, Carrier Access, Confidential etc. during last 8+ years.
• Helped clients optimizing/streamlining RMA, Shipping, Inventory, Service Contract Renewal and New Product Introduction (NPI) processes.
• As both functional and technical lead, participated in full lifecycle (SDLC) of client implementations including Project Scope definition, Requirements Gathering, gap analysis, Business process reengineering, process mapping, System Configuration, setting up Proof of Concept (POC) demos, application Design, Development, test script generation, writing guides, end users, and Production Support.
• Extensive experience in interfacing with users, identifying functional and technical gaps, estimating work, architecting system interfaces, designing custom solutions, SLA’s, Triage, Change/Release Management, leading developers (Onsite and Offshore), scheduling, producing testing and functional documentation.
• Expertise in custom designing and automatic notifications of customer facing documents like Order Acknowledgements, Packing Slips, Ship Confirmation, Commercial Invoices, and AR Invoices.
• Expertise in designing Interfaces, Integrations, forms, Reports, and Data Conversions.
• Excellent communication skills, interpersonal, collaboration, organizational, proactive, leadership vision and problem solving skills. Immensely enjoy navigating all aspects of complex projects.
• Developed functional / technical specifications, test plans and test scenarios using AIM methodology.
• Experience with Agile Project Management Methodology.
• Attended Six Sigma s and have planned / implemented processes to comply with SOX requirements.

TECHNICAL SKILLS:

Oracle Applications (EBS) Versions: R12 (12.1.3, 12.1.2), 11i (11.5.4, 11.5.6, 11.5.8, 11.5.9, 11.5.10)

Oracle Applications Modules: Order Management (OM, ONT), Advanced Pricing (QP), Install Base (CSI), Service Contracts (OKS), CRM Foundation (JTF), TeleService / Service Requests, Inventory (INV), WMS, receiving (RCV), Shipping Execution (WSH), Purchasing (PO), iProcurement, iSupplier, Costing (CST), Work in Process (WIP), MRP, Bill of materials (BOM), Trading Community Architecture (TCA/HZ), FA, AR, AP, GL

Other Oracle Apps Components: Workflow Builder, Alerts (ALR), Application Object Library (AOL/FND), Concurrent Manager, Flexfields, Biz-rules, Form Personalization

Reporting Tools: Reports 10g/6i/2.5, XML Publisher, Discoverer 10g/9i/4.1, Oracle APEX 4.1, Noetix

Languages: SQL, PL/SQL, UNIX, Shell Script, Java, HTML, XML

GUI: Forms 10g/6i/5.0/4.5

Databases: Oracle11g/10g/9i/8i, MySQL, MS Access

Data warehouse Tools: Discoverer Admin, Discoverer User, Discoverer Viewer

Utilities / Tools: SQL*Plus, SQL Developer, SQL*Loader, SmartFTP, Telnet, TOAD, Putty, WinSCP, Query Builder, Data Loader, UPK, VSS, PVCS, Sharepoint, Agile

Operating Systems: MS Windows NT/Vista/XP/2000/98/95, UNIX, Linux

Computer Software: Microsoft Word, Excel, Visio, PowerPoint, Access, Outlook

PROFESSIONAL EXPERIENCE:

Confidential

Techno-Functional Lead

Responsibilities:

• Responsibilities include requirement gathering, gap analysis, application design, configuration, test scripts generation, writing guides and technical support.
• Responsible for creating functional specification docs for B2b Integration.
• Designed and defined mapping of B2b Integrations for Purchase order (Outbound and Inbound), Vendor ASN, PO Receipts, WIP (Work order-less Completion, work orders), RMA Receipts, Sales Order (Outbound to 3PL warehouse), Shipping (Inbound) and Inventory Transactions (from Warehouse).
• Automated Purchase Order delivery and acceptance/promise dates between Enphase and vendors using XML gateway, Boomi and Elementum (3rd party real time Platform).
• Responsible for setting up SOA gateway for Receiving, Order management, Shipping, Inventory and WIP Modules using Boomi. Designed SOA gateway interface programs to facilitate transactions between Enphase and 3PL warehouses.
• Designed and developed AP invoice automation using data from SFDC integration.
• Work with users to resolve and issues pertaining to period end closing and reconciliation.
• Performed setup/configuration documentation for XML Gateway / SOA Gateway and associated modules.
• Responsible for user and support for users through CRP and UAT sessions for Enhancement projects.
• Responsible for Enhancements, Production Support and SLA’s for day to day SCM, Install base, WIP, Service Contracts, AR, AP, GL issues.

Environment: Oracle Applications 12.1.3 (Order Management, Shipping Execution, PO, INV, BOM, AR, AP, GL, WIP, ASCP, IB, Service Contracts, Warranty, XML Gateway, SOA Gateway)

Confidential

Supply Chain Techno-Functional Lead

Responsibilities:

• Designs, develops and markets proprietary, high-performance analog and mixed-signal power management semiconductors for the computing, storage, networking and consumer markets. Volterra was implementing Oracle Applications R12 to integrated Supply Chain and finance system.
• Responsible for requirement gathering, gap analysis, application design, configuration, test scripts generation and writing guides. Planned and implemented the data conversion methodology and programs to bring Sales Orders, items, BOM’s, Item Cost, PO’s, and Vendors.
• Responsible for creating functional specification documents for Interfaces, conversions and reports.
• Responsible for interacting with users to understand requirements and configure oracle applications accordingly. Also, responsible for designing conversions and custom programs.
• Planned and implemented Outside Processing process (OSP) for external services.
• Performed setup/configuration documentation (BR-100) and oracle setups/configurations for Order Management, Advanced Pricing, Purchasing, Inventory, BOM, WIP, Shipping, iProcurement, iSupplier modules.
• Responsible for user and support for users through CRP and UAT sessions.

Environment: Oracle Applications 12.1.3 (Order Management, Shipping Execution, Purchasing, Inventory, BOM, WIP, iProcurement, AP, AR, GL)

Confidential, Petaluma, CA

Supply Chain and CRM Functional Lead

Responsibilities:

• Performed requirement gathering, gap analysis, application design, configuration, test scripts generation and writing guides.
• Planned and implemented the data conversion methodology and programs to bring Install base, Sales Orders, items, BOM’s, Item Cost, On-hand, PO’s, Warranties and Vendors.
• Created multiple Discoverer queries and Reports in Supply Chain, Install Base and Service Contract Modules.
• Defined RMA Order types and Streamlined RMA processes.
• Designed RMA Automation and B2B integration between SFDC and Oracle.
• Designed customer facing documents like Order Acks, Packing Slips, Ship Confirmation & Commercial Invoices.
• Responsible for interacting with users to understand requirements and configure oracle applications accordingly. Also, responsible for designing conversions and custom programs.
• Performed setup/configuration documentation (BR-100) and oracle setups/ configurations for Order Management, Configurator, Advanced Pricing, Purchasing, Receiving, Inventory, Bills of Materials, WIP, Costing, Shipping, iProcurement, Install Base and Service Contracts modules.
• Responsible for user and support for users through CRP and UAT sessions.

Environment: Oracle Applications 12.1.3 (Order Management, Shipping Execution, Purchasing, Inventory, BOM, WIP, ASCP, Install Base, Service Contracts, Warranty, AP, AR, GL)

Confidential

Supply Chain Techno-Functional Lead

Responsibilities:

• Planned and implemented the data conversion methodology and programs to bring Sales Orders, items, BOM’s, Item Cost, On-hand, PO’s and Vendors.
• Responsible for interacting with users to understand requirements and configure oracle applications accordingly. Also, responsible for designing conversions and custom programs.
• Configured and tested Cycle counts and physical Inventory process.
• Performed setup/configuration documentation (BR-100) and oracle setups/ configurations for Order Management, Advanced Pricing, Purchasing, Inventory, BOM, WIP, MRP, Costing and Shipping modules.
• Responsible for user and support for users through CRP and UAT sessions.

Environment: Oracle Applications 12.1.1 (Order Management, Shipping Execution, Purchasing, Inventory, BOM, MRP, AP, AR, GL)

Confidential, Petaluma, CA

Supply Chain Functional Lead

Responsibilities:

• Confidential is a wholesale distributor and systems integrator of solar electric and solar thermal systems. Confidential has been designing and supplying solar energy systems for residential, commercial, and industrial applications. As part of IT plan, Confidential and ‘DC Power Systems’ implemented Oracle Applications R12.
• Worked with Confidential & ‘DC Power Systems’ business Super-users to define project scope during initial scope definition phase of the project. Project scope included data conversions, enhancements and reporting.
• Gathered business requirements and performed gap analysis. Prepared functional specification documents for conversions, reports and customizations.
• Planned and implemented data conversion methodology and programs to bring Suppliers, Items, Item Categories, BOM, Cost and On-hand conversions from legacy system into Oracle application.
• Configured and defined Cycle counting and physical Inventory process.
• Created setup/configuration documentation (BR-100) and performed oracle setups/ configurations for PO, INV, BOM and CST modules.
• Provided user and support for users through CRP and UAT sessions.
• Created TE-040 document to provide test scenarios and steps that needs to be tested in CRP/UAT.

Environment: Oracle Applications 12.1.2 (Order Management, Quoting, Shipping Execution, Inventory, Purchasing, Receiving, BOM, AP, AR, GL)

Confidential, San Jose, CA

Techno-Functional Lead

Responsibilities:

• Confidential is a technology leader that provides reliable infrastructure required to build and secure intelligent services networks. Confidential and Turin merged and combined entity is now Confidential . Integration project required Force10 legacy systems to be integrated with Oracle Applications 11i.
• Worked on gathering and documenting Force10 as-is process, business requirements and gap analysis. Prepared functional specification documents for conversions, interfaces, reports and customizations.
• Gathered data conversions requirements. Planned and implemented data conversion methodology and programs to bring Sales Orders, Install Base, Service Contracts, Items, Item Categories, BOM, Cost and On-hand conversions from legacy system into Oracle application. Performed all these conversions and related setups in production.
• Designed integration from oracle to SFDC (SalesForce.com) to transfer information related to Service Contracts and shipping details.
• Designed and mapped B2B Integrations between Oracle applications and Flextronics (Red Prairie) and Flash Logistics using Biztalk. B2B Integrations were designed for PO (outbound) to Flextronics and Sales order (Outbound) / Shipping details (Inbound) to/from Flash Logistics.
• Designed views to interface items, item categories, and sales order information from Oracle to ‘MS CRM’. In cost view, cost of shippable parts was rolled up to bundle level.
• Configured and defined Cycle counting and physical Inventory process.
• Created setup/configuration documentation (BR-100) and performed oracle setups/ configurations for OM, Shipping, Advanced Pricing, Service Contracts, Install Base, PO, RCV, INV, BOM, MRP, WIP and WSH modules.
• Provided user and support for users through CRP and UAT sessions.
• Created TE-040 document to provide test scenarios and steps that needs to be tested in CRP/UAT.
• Involved in Upgrade from 11i to R12.

Environment: Oracle Applications 11. .1.1 (Order Management, Shipping, Inventory, Purchasing, BOM, Install Base, AGILE, Service Contracts, Teleservices, WIP, AR, AP, GL, BizTalk)

Confidential, Boulder, CO

Functional Lead

Responsibilities:

• Confidential, Inc. is a leading global provider of Carrier Ethernet solutions for wireline and wireless network operators. In early 2008, Turin acquired Carrier Access (CAC), which provides consolidated access technology designed to streamline communication network operations of wireless and wireline carriers, cable operators, enterprises and government agencies.
• Worked on Project scope definition, gathered functional requirements and studied business processes.
• Prepared AS-IS document for Order Management, Service Contracts, Install Base, Service Requests, Purchasing, Receiving, Shipping, Inventory and BOM processes.
• Planned and implemented data conversion methodology and programs to bring Sales Orders, Install Base, Cases, Service Contracts, Items, Item Categories, BOM, Cost and On-hand conversions from legacy system into Oracle application. Performed all these conversions and related setups in production.
• Designed and created mapping for EDI integrations for Shipping, Receipt, RMA’s between Oracle Applications and CTDI (3PL).
• Prepared functional design document for report requirements. Reports designed includes Backlog report, BOM report (to include on-hand), Inventory report, Move Order report, Service Contract waterfall report, install base report Pack slip, Pick Slip and Order Acknowledgement report.
• Created Functional Setup document (BR-100) for OM, Configurator, Shipping, Advanced Pricing, PO, RCV, INV, MRP, Service Contract, and Install Base modules.
• Defined and setup various RMA processes like Repair and Return (R&R), Advance replacement (ADVR) and Credit Return.

Environment: Oracle Applications 11.5.10 (Order Management, Shipping Execution, Inventory, Purchasing, Receiving, BOM, AGILE, Install Base, Service Contracts, Teleservices, AR)

Confidential, TROY, MI

Techno-Functional Lead / Solution Architect

Responsibilities:

• Worked in capacity of Techno-functional Lead. Responsible for Oracle Applications development, upgrade, production support/maintenance and deliverables of onsite and offshore.
• Responsibilities included interfacing with Confidential Functional Experts, users, identifying functional and technical gaps, estimating work, leading developers, and providing production support. As single point of contact for any development/support for order management, Purchasing and Inventory modules.
• Lead offshore team of 22 to provide production support to the client. Managed SLA’s, lead triage and were involved in war-room sessions in case of critical production issues.
• Performed Physical Inventory support, monitoring/resolving pending transactions and ship confirm errors.
• Customized Pick release form and pick release process to meet client’s business requirements.
• Developed and supported standalone automated ship confirm process. Developed custom outbound ASN (EDI 855/856) processes to send 855/856 to customers.

Environment: Oracle Applications 11.5.6 / 11.5.8 (Order Management, Shipping Execution, WMS, MRP, WIP, INV, PO, Receiving, BOM, AR, AP, GL), Mainframe, Oracle 8i, Forms6i, Reports 6i, Windows NT, AIX

Confidential

System Architect / Developer

Responsibilities:

• Responsible for the design and development of discoverer reporting for supply chain.
• Designed and customized ETL interfaces and SCM (AP, AR, GL, Purchasing and Inventory) reports in MIS part of project. Customized ETL interfaces to enable collect & load programs to successfully collect & load non-costed items. Used Discoverer 4.0.x to develop bespoke reports (14 numbers) using Manufacturing, Purchasing and Supply-Chain Intelligence Areas. Created custom EUL, Business areas, workbooks and worksheets for SCM requirements.

Environment: Oracle Applications 11.5.6 (OM, INV, PO, AP), Discoverer 4.1.44, EDW 4.0, Reports 6i, Oracle 9i

Confidential

Technical Lead (Interface/Reports)

Responsibilities:

• Worked in the capacity of Technical Lead for Interfaces/Reports. Responsible for the Oracle Applications development and deliverables of offshore team. Responsibilities included interfacing with functional leads at onsite, identifying technical issues, estimating work, leading developers, task scheduling. Lead the team developing outbound and inbound EDI interfaces (26 interfaces) for AR and Service modules using EC Gateway.
• Involved in customization of Service Request form. Interacted with client for discussing functional requirements and issue resolution. Prepared technical documentations for Interfaces, Reports, Data Conversions and form modifications. Designed and developed six EDI invoice interfaces for insurance companies and banks (Darva, Natwest, Barclays’) for AR and Service modules.

Environment: Oracle Applications11.5.6 (OM, AR, AP, PO, INV, Service), Forms 6i, Reports 6i, Oracle 8i, SQL

Confidential, Atlanta, GA)

Technical Lead

Responsibilities:

• Implementation & Customization of Oracle Applications 11i

Environment: Oracle Applications11i (AR, AP, GL), AOL, Reports 6i, Oracle 8i, SQL, PL/SQL, SQL* Loader