SUMMARY:

• Senior Functional Consultant / Solution Architect with more than 17 Years of IT experience.
• Extensive experience as solution architect to implement Oracle applications in Order to Cash, CRM and Procure to Pay.
• 11+ Years of strong experience as Functional Lead.
• 15+ Years with Oracle Applications - Strong experience in customization, design, localization 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, Service Request, Warranty), AR, AP, Applied Technology (Workflow, Alerts, Bizrules, Application Data Warehouse, E-Commerce Gateway, XML Gateway, SOA Gateway, Personalization)
• 16+ years with Oracle Technologies.
• 1+ year with JAVA related technologies.

EXPERTISE AREA:

• Excellent functional knowledge in Order to Cash, CRM and Procure to Pay cycles. Specialization in Order Management, Shipping Execution (Pick Release and shipping process), Inventory, BOM, Install Base, Service Contracts, Costing, iProcurement, iSupplier and Purchasing/Receiving Modules.
• Extensive experience with designing interfaces and integrations between Oracle and SFDC/Other systems. Designed and configured integrations with other systems using Boomi, EDI gateway, XML Gateway, SOA gateway etc.
• Worked on Requirements gathering, functional gap analysis, application design, configuration module setup, test script generation, writing training guides, training end users, and production support.
• Worked closely with users to support Period End Closing.
• Extensive experience in interfacing with users, identifying functional and technical gaps, estimating work, architecting system interfaces, designing custom solutions, programming, leading developers, scheduling, producing documentation, and providing production support.
• As both functional and technical lead, participated in full lifecycle of client implementations including Project Scope definition, Requirements Gathering, gap analysis, Business Analysis, System Configuration, Design, Development, Testing, and Support.
• Expertise in designing and developing Interfaces, forms, Reports, and Data Conversions.
• Able to clearly articulate and effectively communicate ideas, problems, and solutions with individuals at all levels.
• Working experience in Application Implementation Methodologies (AIM).
• Attended Six Sigma trainings and have been involved in customization/development of processes to comply with SOX requirements.

SKILLS/TOOLS:

Oracle Applications Versions: 12.1.3, 12.1.2, 11.5.4, 11.5.6, 11.5.8, 11.5.9, 11.5.10

Oracle Modules: Order Management (OM, ONT), Install Base (IB), Service Contracts (OKS), Service Requests, Inventory (INV), WMS, Receiving (RCV), Shipping Execution (WSH), Purchasing (PO), Costing (CST), Work in Process (WIP), Bill Of materials (BOM), AR, AP, GL, Advanced Pricing, iProcurement

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

Database: Oracle 11g/10g/9i/8i/8.x

GUI: Forms 6i/5.0/4.5,Reports 6i/2.5

Languages: SQL, PL/SQL, UNIX, Java, HTML

Internet Technologies: Java Server Pages, Servlets, JDBC, JavaScript, XML

Reporting Tools: Application Desktop integrator (ADI 7.0), Noetix, XML publisher

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

Tools: SQL*Loader, SmartFTP, Telnet, Toad, Query Builder, Data Loader, UPK, VSS, PVCS, Sharepoint, Visio

PROJECT EXPERIENCE:

Confidential, Petaluma, CA

Functional Lead

Responsibilities:

• Confidential brings a system-based, high-tech approach to solar energy, leveraging expertise in semiconductor integration, power electronics and networking technologies. Currently Enphase is implementing Interfaces to deliver and receive documents to/from Vendors and Warehouses.
• Working in capacity of Functional Lead.
• Worked as Supply Chain and CRM Functional Lead during previous engagement with Confidential to implement Oracle Applications R12.
• Responsibilities include requirement gathering, gap analysis, application design, configuration, test scripts generation, writing training guides and technical support.
• Responsible for creating functional specification docs 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.
• Automated Purchase Order delivery and acceptance/promise dates between Enphase and vendors using XML gateway, Boomi and Elementum.
• 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 Confidential warehouses.
• Designed and developed AP invoice automation using data from SFDC integration.
• Work with users to resolve and issues pertaining to period end closing.
• To perform setup/configuration documentation for XML Gateway / SOA Gateway and associated modules.
• Responsible for user training and support for users through CRP and UAT sessions for Major Enhancement projects.
• Responsible of Enhancements and day to day SCM, Install base, WIP, Service Contracts, AR, AP, GL Production Support.

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, Fremont, CA

Supply Chain Functional Lead

Responsibilities:

• Confidential was implementing Oracle Applications R12 to integrated Supply Chain and finance system.
• Worked in capacity of Supply Chain Functional Lead.
• Responsibilities include requirement gathering, gap analysis, application design, configuration, test scripts generation and writing training guides.
• 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.
• Performed setup/configuration documentation (BR-100) and oracle setups/ configurations for Order Management, Purchasing, Receiving, Inventory, Bills of Materials, WIP, Shipping and iProcurement, iSupplier modules.
• Also responsible for user training and support for users through CRP and UAT sessions.
• Responsible for post Go-live production support.

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

Confidential, Petaluma, CA

Supply Chain and CRM Functional Lead

Responsibilities:

• Worked in capacity of Functional Lead.
• Responsibilities include requirement gathering, gap analysis, application design, configuration, test scripts generation and writing training guides.
• Responsible for creating functional specification documents for Interfaces, conversions and reports.
• Created multiple Discoverer queries and Reports in Supply Chain and Install Base and Service Contract Modules.
• Designed RMA Automation and integration between SFDC and Oracle.
• Responsible for interacting with users to understand requirements and configure oracle applications accordingly. Also responsible for designing conversions and custom programs.
• To perform setup/configuration documentation (BR-100) and oracle setups/ configurations for Order Management, Configurator, Purchasing, Receiving, Inventory, Bills of Materials, WIP, Costing, Shipping, iProcurement, Install Base, Service Contracts and Warranty modules.
• Also responsible for user training and support for users through CRP and UAT sessions.
• Responsible for post Go-live production support.

Environment: Oracle Applications 12.1.3 (Order Management, Shipping Execution, Purchasing, Inventory, BOM, WIP, ASCP, IB, Service Contracts, Warranty)

Confidential, Fremont, CA

Supply Chain Functional Lead

Responsibilities:

• Worked in capacity of Supply Chain Functional Lead.
• Responsibilities include requirement gathering, gap analysis, application design, configuration, test scripts generation and writing training guides.
• Responsible for creating functional specification documents for conversions and reports.
• Responsible for interacting with users to understand requirements and configure oracle applications accordingly. Also responsible for designing conversions and custom programs.
• Scope includes configuring and testing Cycle counts and physical Inventory process.
• To perform setup/configuration documentation (BR-100) and oracle setups/ configurations for Order Management, Configurator, Purchasing, Receiving, Inventory, Bills of Materials, WIP, Costing and Shipping modules.
• Responsible for user training and support for users through CRP and UAT sessions.
• Responsible for post Go-live production support.

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

Confidential, Petaluma, CA

Supply Chain Functional Lead

Responsibilities:

• Worked in capacity of Supply Chain Functional Lead.
• Worked with Confidential business Super-users to define project scope during initial scope definition phase of the project. Project scope included data conversions, enhancements and reporting. Project includes PO, ONT, INV, WSH, BOM, RCV, AP, AR and GL modules.
• Worked on gathering business requirements and gap analysis. Prepared functional specification documents for conversions, reports and customizations.
• Gathered data conversions requirements. 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, RCV, INV, BOM and CST modules.
• Provided user training 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.
• Responsible for post Go-live production support.

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

Confidential, San Jose, CA

Supply Chain and CRM Functional Lead

Responsibilities:

• Worked with Force10 business owners/SME’s to define project scope during initial scope definition phase of the project. Project scope included data conversions, process integration, systems integration, B2B interfaces, enhancements and reporting. Project includes PO, ONT, Configurator, INV, WSH, BOM, RCV, OKS, IB, Oracle Service, Service Requests, AP, AR and GL modules.
• 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 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 developed interfaces to integrate oracle with SFDC (SalesForce.com) and other systems to transfer information.
• 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, Service Contracts, Install Base, PO, RCV, INV, BOM, CST, WIP and WSH modules.
• Provided user training 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.
• Provided post Go-live production support.

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

Confidential, Boulder, CO

Supply Chain and CRM Functional Lead

Responsibilities:

• Initially worked on Project scope definition. This project includes data conversion, process integration, custom EDI transmission to/from vendors, interfaces and reporting.
• During initial stage of project, gathered functional requirements and studied business processes. Prepared AS-IS understanding document for Order Management, Service Contracts, Install Base, Service Requests, Purchasing, Receiving, Shipping, Inventory and BOM processes.
• Performed technical and functional gap-analysis based on approved as-is documents.
• 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, Pack slip, Pick Slip and Order Acknowledgement report.
• Designed and developed Backlog, Service Contract and Install base report
• Created Functional Setup document (BR-100) for OM, Configurator, PO, RCV, INV, Service Contract, Install Base and WSH modules.
• Defined and setup various RMA processes like Repair and Return (R&R), Advance replacement (ADVR) and Credit Return.
• Responsible to provide post Go-Live Production Support.

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

Confidential, TROY, MI

Techno-Functional Lead

Responsibilities:

• Responsibilities included interfacing with Confidential Functional Experts, users, identifying functional and technical gaps, estimating work, architecting system interfaces, designing custom solutions, programming, leading developers, scheduling, producing documentation, and providing production support
• As single point of contact for any development/support for order management, Purchasing and Inventory modules. Participated in Requirements Gathering, Business Analysis, Functional Design and Development.
• Prioritize, manage, and report progress for project tasks assigned to the technical team.
• Created concurrent program to bulk load/transfer inventory.
• Created program to make an order re-releasable even after its allocation, delivery creation and pick confirmation has completed.
• Actively involved in Physical Inventory support, monitoring/resolving pending transactions and ship confirm errors.
• Order Management is biggest customization in this project. Major customization includes customizing pick release form to give users flexibility to release orders using various criteria’s.
• Customized Pick release form and pick release process to meet client’s business requirements.
• Developed and supported standalone automated ship confirm process. Actual shipping process happens in legacy system (AS400) and shipping data is routed to oracle applications. Ship confirms process uses data from AS400 to ship confirm orders.
• Developed custom outbound ASN (EDI 855/856) processes to send 855/856 to customers.
• Customized Manual Schedule Request form to rank items and locators based on the locator range and compilation criteria.
• Responsible for the design and development of discoverer reporting for supply chain.
• Designed and customized ETL interfaces and SCM (Purchasing and Inventory) reports in MIS part of project.
• Customized ETL interfaces to enable collect & load programs to successfully collect & load non-costed items.
• Interacting with client to gather requirements and conduct demos & testing.
• Used Discoverer 4.0.x to develop bespoke reports (14 numbers) using Manufacturing, Purchasing and Supply-Chain Intelligence Areas.
• Developed custom reports using Reports 6i for OM, INV, AP and PO modules.
• Created custom EUL, Business areas, workbooks and worksheets for SCM requirements.
• Responsible for import/export of EULq, Business areas from one environment to another.
• Involved in Integration, UAT and user testing. Also involved in raising TAR’s, creating test scripts and test data.

Environment: Oracle Applications11.5.6 (OM, INV, PO, AP), Discoverer 4.1.44, EDW 4.0, Reports 6i, Oracle 9i, SQL, PL/SQL, HP-UX

Confidential

Technical Lead

Responsibilities:

• Worked in the capacity of Technical Lead for Interfaces/Reports.
• Responsible for the Oracle Applications development and deliverables of offshore team.
• Coordinated tasks with developers. Worked closely with on-site for any technical/functional queries.
• Responsibilities included interfacing with functional leads at onsite, identifying technical issues, estimating work, architecting system interfaces, leading developers, scheduling, producing documentation, and providing production support.
• Lead the team developing outbound and inbound EDI interfaces (26 interfaces) for AR, INV, E-Commerce Gateway and Service modules.
• 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, INV and Service modules.
• Developed new reports for INV, AR and Oracle Service modules.
• Developed interfaces to collect Oracle Service and custom data for the use of data warehouse.
• Implemented and customized Oracle applications 11i for GL, AR, AP and INV modules.
• Developed custom programs to load and cancel bulk orders in the system using various parameters and validations.
• Designed and developed Managed customer returns (RMA) Interface in OM module.
• Developed import programs using PL/SQL to import and validate current and historical customer information from legacy systems into Receivables Customer Interface Tables.

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