SUMMARY:

• Overall Twenty three years of industry experience, Fifteen years of business applications systems experience in Oracle Distribution & Manufacturing modules and Seven Years of Oracle PIM Master Data Management
• Working as Sr.PIM - EBS Solution Architect/Lead/PM for various end clients like Avery Dennision, Petco Animal Supplies, Staples, Humana
• Worked as PIM Lead Analyst / PIM Solutions Architect at Confidential
• Sr. Solutions Architect and EBS Project Manager for all Oracle EBS Projects OTC, PTP, MFG, RTR and MDM tracks at Gilead
• Sr. Business & IT Architect for Confidential
• Sr. Business Solution Architect for QTC, SC, Install base Configurator modules Support at Confidential
• Sr. Solution Architect for implemention and Configurator Support at Confidential
• Sr. Solution Architect for Data warehousing using Oracle & Qlikview
• Sr. Solution Architect for R12 OTC Implementation & Production Support.
• Sr. Principal Solution Architect at Confidential
• Sr. Principal Consultant at Confidential
• Senior Business Systems Analyst at Art. Confidential
• Business Systems Analyst with Confidential US, a leader in Virtualization software Industry, Confidential US, a growing company in wireless and Confidential US,a contract manufacturing organization for seven years .
• Have NON-IT Functional leadership background in India, almost 7 Years worked as Project Engineer (Project role started from Scratch that is started from ground digging, Technology selection, erection and commissioning of Machines to deliver product ) and Production Engineer in Indian Textile Process Manufacturing and Flow Manufacturing Companies . Managed over 500 operators and 25 engineers in shop floor and responsible for over all productivity and quality of products approximate worth about one 1 Million USD per day ( Over 150 tons of polyester/day capacity )
• Master in Oracle Application implementation (Manufacturing) certified from Confidential .
• Diploma in RDBMS-Oracle 7.x from Software Confidential.

TECHNICAL SKILLS:

EDW: Oracle ERP Release 10.7,11.03 11i (11.5.10), R12,Oracle SOA Suite, Oracle Accelerator, Oracle Product Information Management Rel 12.1.1, Windchill PLM, TIBCO PDM Link ESI,SAP Business Object, Web Intelligence, Universe Designer

Application Modules: Oracle Distribution ( OE, OM,SHIPPING,PO,Advance Pricing),Oracle CRM ( Service Contracts, Install Base),Oracle Manufacturing(INV,COSTING,BOM,WIP,SCM) Demantra and their interfaces, Oracle Financials (AP,AR,GL) SAP (PP)

RDBMS: Oracle 7.x, 8.1.3, 9 i,10g,11g

Operating systems: SUN Solaris and HP UNIX, Windows 98/2000/XP/NT

Programming Tools: SQL,PL/SQL,Reports2.5/6i,10g Forms 4.5/6i,10g SQL*Loader,Workflow 2.6, Toad, QTP, Oracle XML/ BI Publisher, Oracle EDQ

Version Control Software: Harvest,Kintana,Perforce

PROFESSIONAL EXPERIENCE:

Confidential,Minnetonka, MI

PIM Lead Analyst / Solution Architect

Responsibilities:

• responsible for successful Oracle Product Master Implementation and its Integration with downstream systems end to end
• Re-engineered existing NPI process by implementing PIM change management with complex workflows
• Solution design and Configuration Governance of Attributes and Attribute groups, Display Formats, Change Policy, Life Cycle etc
• Responsibility includes Design and Development Solutions to several BI Reports
• Solution designed for Converting existing data to PIM, Managing ongoing data creation in PIM and Publishing PIM Data to downstream systems
• Managed Onsite and Offshore Analysts teams and Development Teams of various tracks
• Closely work with Business Team Leads to gather requirements and to mentor them in PIM

Confidential,Foster City,CA

Sr. Solutions Architect and EBS Project Manager

• responsible for solution delivery and development of all Oracle EBS Projects in OTC,PTP,MFG,RTR and MDM tracks at Gilead
• Single point of contact for Business-IT coordination and onsite and offshore team coordination

Confidential, CA

Senior Business & IT Architect

• Responsible for Implementing and Supporting PIM Item Hub MDM
• Responsible for leading and Providing Business and IT Solutions in PIM - Item Hub MDM
• Leading Onsite and Offshore Teams
• Responsible to provide solution and to do Analysis to find out Root Cause for various production issues like Technical, Functional and Business issues faced by user when creating new Items or updating existing item attributes in Oracle PIM using Custom UI and Item Approval Workflow process in Oracle BPEL and issues related to Items and Items attributes replication to downstream systems.
• Utilized Remedy and SAP BOBJ tools to Categorize various types of Production issues also created various web intelligence reports to analyze issues.

Confidential,CA

• As a Sr. Business Solution Architect for QTC, Configurator, SC, Install base and Teleservice Support Track
• Responsible for resolving all production issues in QTC, Configurator and Teleservice track issues
• Responsible for enhancement, new business process implementation in quarterly major releases.
• Co-ordinate End to end testing and responsible for defect free deployment and implementation of solutions.

Confidential,San Jose,CA

• As a Sr. Solution Architect, I am responsible for design and architectural solutions to Sunpower’s New Data Warehouse using Qlickview and Oracle in the areas of OTC, PTP, MFG, Finance.
• Configured Oracle Demantra to support the client's Demand Planning Process.

  Integrated Demand Planning Process with Oracle E-Business Suite

  Conducted thorough impact analysis on existing setups

Confidential,CA

Sr. Functional / Solution Lead

• Responsible for Implementing new features in existing business process using R12 OTC and Custom Workflow modules to replace existing Rx Order system.
• Leading Onsite and Offshore Teams

Confidential

Sr. Principal Solution Architect

• Responsible for Implementing new intercompany business process using R12 OM, IPROC and AME modules.
• Responsible for leading and Providing Business and IT Solutions in upgrading existing P2P business process to R12 from Rel 11.5.8.
• Leading Onsite and Offshore Teams
• Responsible for implementing a P2P model within a rapidly expanding manufacturing and production environment
• Author of procurement and inventory procedures.
• Establishing a supplier management process to shorten production and fulfillment time for customer orders

Confidential,CA

Senior Business Systems Analyst

• worked on Oracle EBS R12 implementation .
• Responsible for Managing all ART Business flows with respect to R12 Implementation.
• Relevant implementation experience with Oracle EBS R12 and Oracle SOA Suite platforms Understanding of Service Oriented Architecture based architecture approaches
• Thorough understanding of extending Oracle functionality for customizations
• Worked on EBTax module implementation

Confidential,SEATTLE

Senior Business Systems Analyst

• Managing Concur’s various billing, pricing business processes and Concur’s IT technical and functional teams. Interacting with all Concur’s business leads for existing business processes enhancements and new project initiatives and responsible for driving and delivering projects.
• Identify gaps by Analyzing existing Service Contracts and Billing Processes and provide business solution for the gaps by Design, Develop.Test and Implemented the automated custom solutions to update existing Service Contracts price change needs of the customer.
• Implemented ireceivables and Advanced Collection.
• Implemented Oracle E-business Suite Release12 using Oracle accelerators for CRP’s .
• Full lifecycle implementation of Oracle 11.5.10 Purchasing, iProcurement, and subcontractor management (ENCE Extension) modules along with a late scope change to integrate Markview (170 Systems) for AP invoicing
• Develop and deliver documentation in accordance with Oracle’s AIM methodologies
• Post production techno-functional support
• Lead development and delivery of materials and end user training on general navigation, Purchasing, iProcurement, A/P and ENCE Extension
• Develop and deliver Discoverer Reports in support of business requirements

Environment: Oracle Applications R12 / 11i / 1.103, Toad, Sql*loader, Forms, Reports, and Workflow 2.6

Confidential

Senior Business Systems Analyst

• Identify gaps by Analyzing existing Revenue Recognition processes and provide business solutions for gaps by Design, Develop,Test, Implement the interfaces between various revenue sources of the company and Integrating the Softrax Revenue Manager and Oracle E-Business
• Suite of Applications using SOA Technologies into Oracle Fusion .
• Analyzed, Designed, Developed and Deployed Revenue Data mart. This is newly build automated custom business process which collects and stores Confidential revenue data from OM, SC,IB and AR modules using series of giant custom tables and by running sequence of scheduled Concurrent processes which executes several custom PLSQL Stored Procedures, Functions and Packages.
• This Revenue Datamart interfaces with Softrax Revenue Manager which is third party Revenue recognition tool uses BPEL and Web services to calculate complex contract revenues.
• Designed and Developed several Revenue reports build in Oracle Reports6i and Oracle Discoverer using this Revenue Datamart based on Confidential needs.
• Designed, Developed and Deployed Sales Order booking and Shipping Dashboard by using
• Sales Order booking and Shipping Dashboard developed multiple Booking and Shipment reports.
• Very good experience in business requirements gathering, business process design, requirements documentation (BRDs,FRDs etc) and system analysis in a highly matrix and cross-functional organization.
• Analyzed by studying various business systems and integrating new business critical Order to Cash applications using SOA technologies in Oracle Fusion Middleware.
• Techno functional lead role in Order to Cash implementation.
• Testing Order to Cash business flows, interfaces, using QTP and Oracle accelerator
• Relevant implementation experience with Oracle EBS R11i and Oracle SOA Suite platforms Understanding of Service Oriented Architecture based architecture approaches
• Thorough understanding of extending Oracle functionality for customizations

Environment: Oracle Applications 11i, SOA, Toad, Sql*loader, Forms, Reports, and Workflow 2.6

Confidential,CA

Senior Systems Analyst

• Understanding business problems and resolving them as well as testing and implementation of application programs in support of them
• Playing a key role in defining data conversion requirements and procedures and maintaining them while upgrading Oracle ERP from 11.0.3 to 11i.
• Act as onsite primary point of contact for all client requirements and lead offshore development team .
• Designed, developed several Data migration process which includes data extraction from 11.03 and loads the data into 11i after converting and validating 11.03 data into 11i accepted formats. Import validated data using Standard Oracle API and standard import process to import Items, Item categories, Item Revisions, Onhand quantities, Subinventories, locaters, Bill of Materials, Routings, Sales Orders, Price lists, Invoices, Purchase Orders etc…
• Performed analysis and preliminary design for future iProcurement and ireceivables implementation

Confidential,SAN JOSE,CA

Senior Business Systems Analyst

• Analyzed, Designed, Developed, Tested and Implemented New Automated Inter-company Process by designing New Business Process in Oracle Workflow which includes Standard and Expense ASN. This New Inter-company Process covers both Procure to Pay and Order to Cash business processes.
• Analyzed, Designed, Developed, New Customer Credit Check Process.
• This Global Credit Check process checks Credit limit of each customer exists 3 different production instances (Oracle 11.03, Oracle 11i and Oracle Brazil 11i) based on orders booked and 90 days forecasted goods value.
• Worked extensively in Brazil Localization, EMEA & APAC Localization requirements.
• Worked 11i Implementation for Brazil (Sanmina’s separate instance - for Brazil ) implementation Modules - OM, PO, INV, WIP, BOM, AP, AR, GL, FA, and ( Brazil Localization Modules- IR, eComex, BR-PAC and MasterSaf ) which includes setup, conversion, Business driving Key documents like (Imported Goods - Enty Invoice) Nota Fiscal Entrada customization in compliance with Brazil local tax requirements.
• Working Exposure in Customer Data Hub and Product data Hub creation projects.
• Designed and Developed several Oracle Alerts to advice credit department to approve or decline newly booked orders based on Global Credit Check process credit limit check.
• Very good experience in business requirements gathering, business process design, requirements documentation (BRDs,FRDs etc) and system analysis in a highly matrix and cross-functional organization.
• Configured OM, Advanced Pricing, Inventory modules for almost 50+ SCI plants implementations located globally. Designed, developed and deployed data migration processes for 50 + plants and lead the post implementation production support team for all legacy to 11i and 11.03 to 11i upgraded plants.
• Managed teams offshore, onsite oracle development team and oracle functional team.
• Lead production support team and worked as primary point of contact for all Oracle Distribution modules related production issues for global organization.
• Analyzed, Designed, Developed, Tested and Implemented 11.03 to 11i Upgrade & Consolidation Project and Plant Consolidation Project.
• Worked extensively with Business Users to support/resolve Production issues in OM, OE, Shipping, and Inv.
• The Sales Dashboard Project was aimed to create a comprehensive view of the company wide sales data integrated from all the various systems employed in the plants across the world. My responsibilities included understanding management requirements for data, interfacing sales data from legacy systems to Oracle and development, testing and implementation of the Project.
• Designed and developed standard oracle Configurator interface to load Configuration Rules from text file to Oracle Configurator (Selling Point). Other activities include creating concurrent programs, many PL/SQL programs to create and delete projects in Oracle Configurator.
• An integral part of development team responsible for customizing and optimizing the various reports and forms in Oracle Manufacturing and Oracle Financials modules and load legacy system data into oracle for Stamina’s acquired plants like Lucent, Sweden Manufacturing facility, SCI etc.
• Responsibility includes supporting Sanmina’s 10.7 NCA to Release 11.03, 11.03 to 11i upgrade production environment and 10.7NCA Sun to 10.7 NCA HP hardware migrated production environment for various problems in day today order transactions.
• Played vital role in Sanmina’s (SUN to HP) Hardware migration project, 10.7 NCA to Release 11.03 upgrade projects my responsibility includes functional and technical testing of all migrated standard, custom reports and forms. Design, Developing new Custom forms and Reports based on business requirements and integrate them into Oracle Applications. Test and document Custom forms and Reports.
• Helped management in securing highly confidential cost information reports by restricting confidential cost information access to unrelated users. Also assisting to automate business process.
• Supported production environment with impromptu reports, data migrations, patches & sysadmin responsibilities.
• Optimized the invoice, sales order, and Pack slip documents according to the requirement of different plants in different countries. Also created new reports to know the weekly planning cost and quantities of items procured from various vendors needed for production.

Environment: Oracle Applications 10.7, 1103, 11i, Toad, Sql*loader, Forms, Reports, and Workflow 2.6

Confidential

Oracle Applications

Responsibilities:

• Optimizing various procurement cycles reports and management tools, viz. Supplier scheduling, Component level forecast determination, price variance alerts and reporting.
• Helped shop floor with recommendations and custom reporting tools to eliminate communication gaps between planners and shop floor personnel.
• Supported production environment with impromptu reports, data migrations, patches & sysadmin.

Environment: Oracle Applications Manufacturing 11.03 (INV, BOM, OE, WIP, MRP & PO modules)

Confidential,CA

Oracle Applications

Responsibilities:

• Worked as a consultant to Design and Develop various custom reports in Inventory, Bill of Materials and Order Entry Modules.
• Also prepared Technical Design Document and User Training Document and interact with users to understand their requirements and convert them into requirement and design document.
• Some of the reports that I developed are
• Billings Report, Backlog Report by Product, Backlog Report by Schedule Date
• Unscheduled Backlog Report by Product, Item Setup Detail Report
• Designed, Developed, Documented and Tested Custom Reports in OE, BOM, INV modules.

Environment: Oracle Applications Manufacturing 11.03 (OE, BOM, INV, WIP modules)

Confidential

Oracle Applications

Responsibilities:

• Re-engineering of inventory system, Centralized Purchasing and Sales order entry.
• Prepared and created functional requirements for inventory, Purchasing, Order Entry, and BOM.
• Prepared / Incorporated program specification.
• Involved in requirement review for the design and requirement specification.
• Developed reports various MIS reports like Material shortage report etc...
• Creation of items, BOM, Routing

Environment: Oracle Applications Manufacturing 11.03 (INV, PO, OE, BOM, WIP, MRP modules)

Confidential

SAP Consultant

• Selection of proper production strategy, processing the SOP, creation of rough-cut plan, demand management program and MPS, developing the MRP for the production plan, developing the work center with suitable shift sequences, capacity planning and leveling.
• BOM for the planned products with relevant routings. Creation and execution of production orders, issue of goods for production and receipt of the finished products after production. BDC programs for data transfer from a legacy system were generated.
• As a Functional analyst for PP modules I was involved in customizing the functions of PP MODULE - SOP, Creation of DEMAND MANAGEMENT PROGRAMME, MRP, Work centers, BOM, Routing, Capacity planning, Production order processing and related functions.
• Various requirements like IMG settings, Creation of companies, business organizations, purchase organizations, purchase groups, plants, storage locations, cost centers etc. have been created.
• Creation of material master, Purchase requisitions, RFQ (request for quotation) price comparison, Rejection of offers, purchase order creation, goods receipt, goods issue, Invoice verification.
• Created ABAP/4 reports, BDC programs for material master and vendor master.Wrote SAP script for purchase order.
• This is a project for polyester filament yarn manufacturing industry using ABAP/4 features. Creation of various reports on total issues, total supplies during a period, Interactive Reports for displaying supplier details and his products have been created.
• A report for chosen product giving three-year consumption pattern, issue details and supply details using nested internal tables have been created.
• Printing of Purchase order for any selected order is being implemented using SAP script.
• Transferring of legacy data on purchase requisitions, request for quotations etc. is implemented by using BDC programs.
• Various other features like extract datasets, process on help, and process on value request, creation and usage of logical Database has been implemented in this project.

Environment: SAP R/3 Version 3.0 F, ABAP/4