PROFILE SUMMARY

• Senior Oracle SCM Techno - Functional Lead wif over Ten years of IT experience in System Analysis, Design, Development, Production Support, Customizations, Implementations and upgrades of business applications using ERP, Client/Server and Internet Technologies. Specialized in Oracle e-Business Suite versions 11.5.x, 12.0.x, and 12.1.3 Experienced in Supply Chain and Distribution, Manufacturing modules, Advanced Supply Chain Planning, WMS/MSCA, Procure-to-Pay (P2P) cycle, Order-to-Cash (OTC) cycle, Financials and HRMS.
• Extensive exposure in ERP implementation using Oracle Applications comprising functional areas in Order management, Inventory, Warehouse Management (WMS), Mobile Warehouse Management (MSCA), Material Planning, Advanced Supply chain Planning (ASCP), Material Forecast, Oracle Receivables, Oracle Payables, General Ledger, Purchasing, Cash Management, HRMS, Payroll, I payment, core HR,I recruitment, Payroll, Learning Management.
• Worked on versions R12, 11.5.10 and 11i/11.0.x of Oracle Applications e - business suite Implementation, Maintenance and Upgrade.
• Experience in Collection of Business requirements, GAP analysis, designing of customizations, designing of technical components, Doing Setup’s, Administration, Security and Aim methodology.
• Expertise in working wif tools like Oracle Forms and Reports, Discoverer, XML publisher and processes like data conversions, API’s, migrations, interface programming, workflow, customization, System, & BI Discover and concurrent programs.
• Expensive expertise wif PL / SQL, SQL coding, performance tuning and Data Quality Management.
• Expertise in using version control and code promotion software’s like Kintana, Clear-case, Clear-quest, Serena version control system.
• Experience in creating and resolving Service Requests in Oracle Metalink.

PROFESSIONAL EXPERIENCE

Senior SCM Techno-functional Lead

Confidential, Cupertino, CA

Responsibilities:

• Handled end to end implementation for 2 distribution centers and 2 manufacturing plans.
• Designed, Developed and maintained all WMS and MSCA customizations.
• Worked as IT point of contact for complete Distribution center day to day production issues, customization requests, process improvements and user training.
• Worked on improving shipping efficiency by creating custom process to handle case pack, inner pack, each in shipping process by scanning respective labels.
• Created various rules and strategies, labels and documents to meet custom needs for picking, Transfers, labels.
• Handled supply chain planning revamp for the whole company.
• Stabilized inbound interfaces designed and developed reports various reports as needed.
• Supported business in complete revamp of forecasting and provided wide range of forecasting reports.
• Handled the yearend cost update process for the whole company.
• Designed and developed load programs to do mass update to item properties and status, BOM and WIP Documents.Account Receivables, Account Payables and General Ledger
• Supported month end process and worked wif finance team to create and modify various reconciliation reports to halp the month end process.
• Designed and developed OBIEE dashboards and XML Reports, Executive reports, MTD sales by customer report.

Oracle Techno-Functional Lead

Confidential

Responsibilities:

• Managed WMS team to handle all WMS and MSCA customizations.
• Designed and developed a custom waving process to handle custom business logic and to interact wif Cartonization Process, P - 800 and PTL system.
• Designed and developed custom packing station forms to support packing process.
• Designed and developed code to generate ZPL code for Label printers.
• Updates for MDM to other systems are carried using SOA process. Designed and developed PL\SQL packages used by SOA process to Fetch information in the system created and create or update information in counterparts.
• Worked on Developing PL|SQL code for updates through SOA between oracle apps, cartonization system Cube IQ, Pick to light (PTL) and SEAYCO.
• Worked on Designing and Developing Create, update and get utilities for various EBS items like Resources, Salesperson, Item and category.

Oracle Techno-Functional

Confidential, San Diego, CA

Responsibilities:

• Modified all the existing Custom Packages, Reports to work according to the new R12 table structure.
• Designed and developed a custom process to import journals from various 3rd party systems like banner, CS glod and T3 and populated GL Interface tables.
• Developed a 2-way interface between Oracle, In house Identity management Starrez and Banner.

Confidential, San Diego, CA

OBIEE Techno-functional Analyst

Responsibilities:

• Designed and implemented custom business intelligence solutions (Metadata and Dashboards/Reports) using OBIEE.
• Involved in developing the custom repository model for the different work streams wif the necessary logic that involved creating the Physical, BMM and the Presentation layer.
• Developed many Reports / Dashboards wif different Analytics Views (Drill-down / Dynamics, Cascading style sheets, Pivot table, Chart, Column Sector, Tabular wif local and global filters).

Oracle Techno-functional Analyst

Confidential, Lake Forest, CA

Responsibilities:

• Worked on designing various reports, interfaces and extensions across SCM and financials.
• Supported Warehouse WMS and MSCA operations.
• Worked Extensively on Multi-org.
• Developed scripts to create setups for operating units across 18 modules.
• Dealt wif Identifying of duplicate customers based on methods of DQM (Data Quality Management).
• Created several levels of TCA information using HZ API’s
• Developed different kinds of Audit scripts and verification scripts.
• Worked as Oracle Applications Technical resource for different clients of Satyam Computer Services Limited.
• Developed components like reports, interfaces, customizations and extensions in HRMS, GL AND SCM areas.
• Created several GL Reports and Handled Data flow from 3rd party systems to GL via Interfaces.
• Designed and developed Vendor, Open PO, AP Invoices and PO requisition data conversion.