SUMMARY:

• Overall 24 years of total experience, 17 years of business applications systems experience in Oracle Distribution & Manufacturing modules and 7 Years in Oracle PIM Master Data Management
• Currently Working as Business Process Analyst at Confidential
• Worked 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 VMware
• 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 MDM - PIM - Item Hub at Confidential
• Sr.Business Solution Architect for QTC, SC, Install base Configurator modules Support at Confidential
• Sr.Solution Architect for R12 PIM (Advance Product Catalog) implemention and Configurator Support at Confidential
• Sr.Solution Architect for R12 OTC,MFG,PTP,FINANCE Datawarehousing using Oracle & Qlikview at Confidential .
• Sr.Solution Architect for R12 OTC Implementation & Production Support at United Health Care Group
• Sr.Principal Solution Architect (For R12 upgrade and R12 Implementation Project) at California Department of Motor Vehicles
• Sr.Principal Consultant - Track Lead For Oracle ERP - Windchill PLM ESI at Confidential
• Sr Business & IT Analyst ( MDM - PIM & Pricing Track Solution Lead) at Confidential
• Senior Business Systems Analyst (OTC- R12 Implementation
• 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 Solutions Integrated Ltd, Madras.
• BS Engineering, Bharathiyar University, INDIA
• Well conversant with Oracle PIM, Distribution, Mfg and Financials modules and their interfaces.
• Lead Oracle MFG - Winchill PLM Enterprise System Integration
• Functional and Technical understanding of Oracle Applications including underlying table structures and database procedures and APIs.
• Experienced in leading projects.
• Understanding/Analyzing complex business processes and configuring them to Oracle ERP applications including development of interfacing solutions.

TECHNICAL SKILLS:

Business Applications: Oracle ERP Release 10.7,11. 03 11 i (11.5.10), R12

EDW: Oracle SOA Suite, Oracle Accelerator, Oracle Product Information Management Rel 12.1.1, Windchill PLM, TIBCO PDM Link ESI

Data Visualization: : SAP Business Object, Web Intelligence, Universe Designer, Tableau Dashboard, Qlickview

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), Oracle AOL, 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, OAF /ADF, Workflow 2.6, Toad, QTP, Oracle XML/ BI Publisher, Oracle EDQ

Version Control Software: Harvest,Kintana,Perforce

PROFESSIONAL EXPERIENCE:

Confidential, CA

Business Process Analyst

Responsibilities:

• Re-engineered existing GSP support process
• Create decision matrix using current business rules
• Automate routine and repeated support tasks
• Report support process trends using data visualization tools dashboard

Confidential, NY

Sr.Oracle PIM -EBS Solution Architect/Lead/PM

Responsibilities:

• Worked as Sr.PIM Solution Architect to end client Avery Dennision’s Oracle ERP and MDM implementation Project requirement and solutions RFP at Cleveland Ohio
• Worked as PIM Solution Architect to end client Humana at North Carolina
• Worked as onsite Stibo PIM Solution and Support Lead to end client Staples at Denver Colorado
• Worked as PIM Solution Architect to end client Petco at San Diego California
• Responsible for delivering Complete Solution to enable eCommerce business model into existing PIM system
• Responsible for delivering solution to ongoing integrations from PIM to WCS and OMS new downstream systems

Confidential, Minnetonka, MI

Sr.EBS Solutions Architect for a Hi-Tech Datacard Company to enable their new Software Licensing Business Model into Oracle EBS

Responsibilities:

• 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

Worked as Sr.Solutions Architect and EBS Project Manager

Responsibilities:

• 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, Redwood City, CA

Sr.Business Solution Architect

Responsibilities:

• 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, Sunnyvale, CA

Sr.Solution Architect

Responsibilities:

• Working in R12 Order Management integration with SFDC to create Oracle Sales Order automatically from SFDC opportunity.

Confidential, San Jose, CA

Sr.Solution Architect

Responsibilities:

• 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

Responsibilities:

• 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

Responsibilities:

• 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, Boston, CT

Sr.Principal Consultant

Responsibilities:

• Responsible for Implementing PIM for Pricing Track
• Responsible for leading and Providing Business and IT Solutions in PIM for Pricing Track
• Leading Onsite and Offshore Teams

Confidential, CA

Senior Business Systems Analyst

Responsibilities:

• 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

Responsibilities:

• 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 R 12 / 11 i / 1.103, Toad, Sql*loader, Forms, Reports, and Workflow 2.6

Confidential, PALO ALTO, CA

Senior Business Systems Analyst

Responsibilities:

• 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 VMware 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 VMware 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

Responsibilities:

• 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

Responsibilities:

• 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 11 i 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.

Senior Systems Analyst

Confidential

Responsibilities:

• Analyzed, Designed, Developed, Tested and Implemented 11. 03 to 11 i 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.

Systems Analyst

Confidential

Responsibilities:

• 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 11 i 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, BOCA RATON, FL

Techno functional Consultant

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, MOUNTAIN VIEW, CA

Techno functional Consultant

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

Techno functional Consultant

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)