PROFESSIONAL SUMMARY

• Oracle certified EBS functional SME with 20 years of experience spreading 13 years in Oracle EBS and 7 years domain experience in manufacturing industry.
• Hands on experience in various roles like solution architect, project manager, team lead, Functional consultant, test lead, application developer, data migration lead for implementation, rollout, upgrade, application maintenance and enhancement projects in EBS 11i and R12.
• Deep Functional experience in P2P, OTC and PTM flows of various domains like Manufacturing, Automobile, Financials, Services, Communications, Data storage, life sciences, retailing, constructions, energy solutions etc.
• Experienced in all phases of the SDLC for implementation and support projects like Requirement Gathering, Gap analysis, Solution design, Estimations, Application configuration, proof of concept, Customizations, Functional, technical design documents, Test case preparation, Testing, Reviewing, Cut over, Data migration, User training and Support
• Worked extensively in the distribution and manufacturing streams covering the modules Order Management and Shipping Execution, Purchasing, Advanced Pricing, Inventory management, Costing, Bills of material, Work in process, Advanced Supply Chain Planning, me - Procurements, Warehouse Management, Process manufacturing, Process Quality, ERES, Accounts Payables, Accounts Receivables, Approval Management Engine, Business Events, Governance and risk compliance
• Hands on domain experience in the production, planning functions covering prototyping, shop floor management, capacity and production planning.
• Able to build POCs, custom solutions, configurations quickly in the manufacturing and distribution modules owing to the deep functional and technical skills
• Good experience in conducting CRP, Review UAT and user trainings
• Sound knowledge on EBS 11i and R12 Architecture covering AOL, MOAC and system administration
• Proficient with AIM methodology and authored various documents like BR100,MD50, MD70, TE40 etc.
• Expert in designing in configuring distribution flows, intercompany transactions and AGIS for multi Legal entity implementations
• Good understanding on the data model and technical architecture of TCA
• Experience in designing new work flows, extending the functionality of existing work flow, and work flow administration tasks
• Experience in self services modules like me-procurement, approval management engine, procurement contracts.
• Design and implementation with e-signatures for various standard business transactions and Master data management activities in Oracle applications
• Good exposure to the regulation requirements of the life sciences business process

TECHNICAL SKILLS

Technical skills: SQL PL/SQL, Work flow, Forms and Reports, XML and BI Publisher, UNIX Shell scripting, SQL Loader, EDI, SOA, Proc* C and other Oracle utilities

Project Management: Achieved cost, schedule and quality goals in rollout, enhancement projects. Led teams of functional and technical consultants to achieve project targets

Other Tools: SQL developer, Toad, HP Quality Center, Service Now, Data Loader, Visual Source Safe, Kintana, more4apps, Tracelink, IBM Sterling

PROFESSIONAL EXPERIENCE

Confidential, Summit, NJ

Onsite coordinator and EBS SME

Responsibilities:

• Designed and implemented end to end automated Canada 3PL sales interface involving set up of new order types, shipping networks, AR transactions types, Order holds, ship sets, Price lists, order line types, processing constraints.
• supported EDI transactions for multiple parties
• Key member in the EB TAX implementation
• Designed and implemented the Lot retirement extension in addition to Expiration date and which is used in entire applications from ASCP to Shipping
• Designed and implemented custom extension in shipping execution to trigger automatic shipping process when the LPN is picked in MSCA
• Managed end to end EBS testing for critical flows (around 400+ test scripts) during major upgrades
• Revamped existing concurrent managers to facilitate priority processing certain critical operations
• Designed and implemented the Inbound interface for Item, Lot import through external table.
• Build several Poof of concepts for custom extensions in Inventory optimization, shipping execution, MSCA which and are delivered successfully through enhancement project
• Designed and delivered multiple enhancement requirements in Shipping execution, ware house management, Order management and Inventory
• Conducted multiple trainings for Support team covering all SCM modules
• Managed multiple conversions during implementations and acquisitions
• Re designed the LSP interface process fixing various bugs and improving the performance and concurrency drastically
• Re designed the ASN out bound custom interface to resolve the missing receiving transactions in the out bound
• Re Designed the DQSA compliance interface from EBS to accommodate product changes and fix existing bugs
• Supported multiple issues in intercompany transactions and AGIS set ups
• Supported SIT and UAT for PTM project implementation
• Designed custom extension to automatically notify the Key IT and business users when critical schedules requests fails or takes more time than expected
• Customized MSCA transactions in LPN receipts
• Migration of the master data like Process Items, Formulas, Recipes, Routings, Resources and Specifications
• Resolved the calculation logic in the ASCP custom hook extension for the custom fields in the horizontal plan
• Supported in fixing / creating new modifiers in the price lists to accommodate the new business requirements
• Implemented the new COGS account updates changes as part of key business requirements
• Designed the custom solution for the failure of PO change requests during the WIP quantity updates of Lot based OSPs
• Supported multiple EB TAX issues
• Designed and implemented the custom extension to resolve the global ship confirming issue in the LSP order processing
• Designed the functional security through MOAC and security profile in providing controlled access to Canada Operation user group
• Revamped Material statuses to be used at Lot, Sub inventory and Organization levels to suit complete business requirements.
• Supported multiple GRC custom extensions in implementing controls for MDM, setup and other transactional data governance.

Environment: Oracle applications R12.1.3 with all the SCM, Financial, Manufacturing, VCP and HRMS modules and Oracle Demantra

SME for SCM stream.

Confidential, Atlanta, USA

Responsibilities:

• Involved right from project kickoff meeting with Global Process Owners, System owners, Functional SMEs, Data Governance team, Validation teams.
• Completed AS is Study of SCM stream functions for Canada operations and documented
• Prepared system understanding documents for the custom objects for which no functional document exists
• Re designed the item category setup and mapping for Canada re implementation to comply with existing structure in US instance
• Configured the order types, line types, shipping networks, Picking rules, internal locations, intercompany flows
• Compiled the BR100 documents for Inventory, Purchasing, Order Management, Approval Management Engine, Advanced Pricing
• Configured receipt tolerances, line type defaults, Freight carriers for the Canada operations
• Set up new security profiles to ensure data security
• Reviewed the technical design documents and halped development team on the progress of development
• Re designed the responsibility structure and introduced role based security access
• Prepared test cases on the RICE developments
• Revamped the purchasing approval structure to facilitate global procurement team requirements
• Configured Order management Document sets, Document assignments to seamlessly merge the existing Canada transactions
• Documented and reviewed the existing forms personalization and customization in the both the instance and studied the impact of merging into single instance
• Designed the strategy along with other cross functional teams to merge the existing forms personalization and customizations and merged into US upgrade instance.
• Studied the impact and incorporated the custom.pll entries from Canada instance into US upgrade instance
• Performed Impact analysis for SCM custom components in the US upgrade
• Prepared functional specification documents and designed custom interfaces and extensions as required for the re implementation.
• Redesigned multiple custom objects and authored functional design documents in the upgrade instance.
• Designed and estimated the Conversion efforts of CANADA re implementation for Items, categories, on hand quantities, sales orders, price lists, purchase orders and attachments

Environment: Oracle Applications R12.1.3 (INV, PO, OM, AP, AR, GL, Project Billing, Project Costing, Advanced Pricing, HRMS)

Confidential, Wolverhampton

Project Lead

Responsibilities:

• Studied and documented the Confidential EBS instance for existing organization structure, setups, defaulting rules, processing constraints
• Analyzed the source legacy system data for the conversion.
• Designed the conversion strategy, resource requirements and conversion project plan
• Set up new operating unit, locations, inventory organizations organization parameters
• Configured new security profile, responsibilities and request groups to accommodate new acquisitions
• Configured the new categories and category sets and item templates
• Performed 2 mock conversions into a test instances and got client sign off as part of conversion plan
• Managed successful conversion of Inventory, Purchasing, General Ledger, Accounts payables, Accounts Receivables and Projects data in very short span of time
• Reviewed all the Functional, technical design documents and test scripts
• Documented the RCAs, set up changes, configurations employed for bug fixing during conversion testing
• Authored multiple Functional, technical design documents and test scripts
• Designed multiple templates, scripts to detect format issues and major data integrity issues in the input data
• Coordinated constantly with client team for correcting the input data for any data issues
• Got Client appreciation for completing conversion ahead of target date
• Conducted daily calls with on site team on Issue log, data issues, code issues, sign offs.
• Maintained daily status reports, mile stone details, process reviews and published them to all the stake holders regularly.
• Documented and bundled all the design documents, code bundle, test cases, Setups to re use for future conversions

Environment: Oracle Applications 11.5.10 (Oracle Projects, PO, INV, AP,AR,GL, OM, Advanced Pricing)

Confidential, CA

Environment: Oracle applications R12.1.3 (INV,OM,AP,AR,GL,CM,XML Gateway)

Responsibilities:

• Worked closely with Oracle support to get one of patch for the bug in tax rounding error in AR and performed impact testing of the patch on all key flows before applying the production
• Designed and delivered the custom reports in very short span of time to accommodate a change in billing system
• Enhanced the web services and xml message messages to fix multiple bugs and performance issues
• Worked on SABRIX integration for tax calculation on customer invoices
• Configured relevant setups in Oracle Receivables like Receipt methods, transaction types, payment system, routing rules etc to support the solution
• Provided solutions to regular business processes related to Receipt creation, Remittance, Refunds, Credit Card updates
• Designed multiple solutions for credit card authorization, tax interface using used PL/SQL WEB SERVICES, SOAP UI, XML, Oracle Advanced Queues (AQ)
• Provided solutions to regular business processes related to Receipt creation, Remittance, Refunds, Credit Card updates etc
• Performed billing report enhancements from in the bill presentment architecture
• Supported the reconciliation report problems due to tax rounding issue

Confidential

Environment: Oracle Applications R12.1.1 (INV, PO, OM, AP, AR, GL, Project Billing, Project Costing, Advanced Pricing, BOM,WIP, Costing, AME)

SCM functional lead

Responsibilities:

• Part of the R12 implementation team since project kick off as SME for distribution modules covering P2P and O2C flows
• Performed AS IS study for Analyzing the requirements, risk analysis for mapping the business processes. Understanding the gaps, recommended the necessary customizations.
• Prepared BR100 Designed work flow extensions for Project Supplier Invoice Account Generation
• Designed work flow extensions for COGS Account Generator
• Configured PO approval setups Configured OSP, resource setups
• Configure Item categories and Category sets
• Part of implementation team from day one for the R12 implementation covering Manufacturing, distribution and finance modules
• Performed AS is Study of SCM stream functions and documented current client business process and requirements
• Configured the Unit of measurements, intra and inter class conversions, locations, Inventory picking rules and shipping methods
• Set up operating units, Inventory organizations, Sub inventories and locators as documented for the manufacturing facilities, distribution centers, warehouses and logical entities
• Designed and Configured item categories, category sets and context sensitive DFFs
• Configured multiple custom item templates and disabled seeded templates
• Reviewed and configured new material statuses and item types
• Configured custom responsibilities, request groups and security profiles
• Set up custom role based access control for better user management and maintenance
• Configured shipping networks and transfer costs for inter org transfers
• Configured intercompany transaction flows, transaction types and intercompany pricelists
• Set up Internal location association for performing internal requisitions and sales order
• Configured the order types, line types, shipping networks, Picking rules, internal locations, intercompany flows
• Compiled the BR100 documents for Inventory, Purchasing, Order Management, Approval Management Engine, Advanced Pricing
• Configured receipt tolerances, line type defaults, Freight carriers for the Canada operations
• Set up new security profiles to ensure data security
• Reviewed the technical design documents and halped development team on the progress of development
• Re designed the responsibility structure and introduced role based security access
• Prepared test cases on the RICE developments
• Implemented Cycle counting functionality for multiple warehouses
• Customized the Project Supplier Invoice Account Generator according to the Project based procurement transactions
• Designed the solution and implemented the spend transference initiative through requisition line DFFs and the custom hook POR CUSTOM PKG
• Customized the PO Charge account generator to accomplish custom business rules in deriving charge account for project based procurement
• Designed and implemented the change order auto approvals as per procurement policies through Configuring Auto Approval tolerances for the Change orders
• Designed and implemented the custom extension in the Order header work flow to implement custom business logic to build revenue account for specific sales orders
• Setup approval groups, approval assignments as to build corporate approval structure
• Configured the Receipt, Invoice tolerances for different business entities
• Designed and implemented the custom defaulting logic for Buyer, Line type using categories and custom hook package POR CUSTOM PKG
• Review of Functional specs, technical specs and test cases for the SCM stream
• Supported UAT and completed signoff for all RICE components in the SCM stream as per project plan
• Developed User Training KIT and trained super users
• Supported cut over, Go live activities and assisted Client SMEs and process owners in assessing business readiness completeness
• Provided post go live support and resolved the process, data and user errors

Confidential, Denver

Environment: Oracle Applications 11.5.10 (INV, PO, OM, AP, AR, GL, Advanced Pricing, WMS, Web services)

SCM Lead

Responsibilities:

• Analyzed all SCM enhancement requirements documented the estimations and delivery time lines
• Designed solutions for the enhancements and authored the functional design documents for RICE components
• Authored the test case documents for all enhancements in the P2P and O2C stream
• Re designed multiple reports to include user configurable elements dynamically in the reports avoiding the need to perform code changes for frequent changes.
• Designed the custom solution and implemented in customizing the sales order header work flow to facilitate the Provisioning process so dat the orders utilizing custom holds and web services from external systems
• Designed the solution to automatically copy the attachments attached to the sales order header to the corresponding service contract in the install base.
• Configured freight carries and cots and integrated with specific order types and specific warehouses
• Designed the solution to automate the process of attaching documents to the sales orders and order lines at various stages of order progression and during the subsequent export to service contracts
• Configured the drop shipment flows across operating units and set up intercompany flows as part of enhancements after upgrade
• Modified the existing ship confirm rules and configured new ones to support the various business requirements from shipping and provisioning teams
• Designed the custom interface for contract management initiates to process the RMA and terminate the contract automatically through PL/SQL Web services, SOAP User interface.
• Configured new processing constraints to implement the various business requirements during sales order Modifications
• Designed and implemented order line work flow customization to support various holds on the sales order line through web services from external systems
• Designed the end to end custom solution to extend the order progress process for incorporating additional maintenance and installation charges during the provisioning
• Configured multiple processing constraints for specific order types to implement various business requirements
• Implemented the business rule of restricting the partial shipments in the sales order configuring Ship sets for specific order types
• Implemented the credit checking enhancements to stop order processing for specific class of customers and order types
• Worked for the WMS initiatives to support LPN transactions in the stock receiving, shipping and inventory optimization operations
• Reviewed the existing pick release rules and configured custom rules to implement the business requirements for sales order fulfillment specific to the business entity and order types

Confidential, Denver, USA

SCM Consultant

Environment: Oracle Applications 11.5.10 (INV, PO, OM, AP, AR, GL, Advanced Pricing, WMS, Web services)

Responsibilities:

• Part of the upgrade team since project kick off as SCM lead for the upgrade project and involved in planning the Upgrade strategy, scope, cut over, mile stones of the upgrade project
• Studied the existing custom objects in the SCM stream for documenting list of potential components to be analyzed the impact of upgrade
• Analyzed and documents the impact, risks and the efforts to the fix for the custom components which will be effected due to upgrade like TCA re design.
• Analyzed the existing business process, requirements documents and prepared test cases covering all the critical business flows in the implementation in consultation with Client process owners.
• Deigned the plan, strategy for the migration of forms personalization and custom.pll
• Maintained the delta document to record the setup, code changes and patches applied to the existing instance for critical issues and recorded the same in BR100 and delta migration document accordingly
• Estimated the development and testing resource requirements as per project plan.
• Re designed the existing CUTOM.pll library and modularized to facilitate concurrent development on the same component at a time by multiple developers.
• Trained and mentored the testing and development team in the functional flows complete the extensive testing on time
• Performed the critical flow testing and documented the issues, resolutions
• Updated and maintained the versions of the BR100 documents, migration documents and further enhancements required.
• Configured the attachment functionality to map key documents between order management and service contracts
• Designed the extension to implement order hold management through web services
• Worked with Oracle Support for the resolution during upgrade patching and testing for various issues
• Supported UAT with business users and completed signoff for all critical flows in the SCM stream as per project plan
• Supported cut over, Go live activities and assisted Client SMEs and process owners in assessing business readiness completeness
• Provided post go live support and resolved the process and setup issues

Confidential, Chicago, USA

Environnent: Oracle application 11.5.10.2, INV, OM, AR, AP, Service contractas, Portal, PL/SQL

Responsibilities:

• Performed AS IS study for the existing current Standard Parking business processes and documented the business requirements from the client process team
• Build the POC on mapping the individual parking slots service items in Oracle Inventory
• Configured the parking garages with inventory locators
• Designed the solution to reserve/allocate/ release the parking slots online though Oracle portal
• Conducted CRP for the implementation solution on the parking slot management, billing, contract management and receivables
• Configured the sales order, service contract flow for the monthly billing contracts
• Configured Price lists for various geographies, customer classes
• Designed the Garage administrator dash board reflecting online parking lot status, customer wise parking status for Corporate plans using the custom Oracle view
• Configured the pricelist modifiers to accommodate various discounts and surcharges for geographic, seasonal and customer specific transactions
• Designed custom extension for Garage administrators for enabling disabling the discounts and surcharges for the specific Garage and order types using Oracle portal and standard APIs
• Designed custom form and enabled through ZOOM functionality for Garage administrators to manage the parking slot status
• Designed and Configured item categories, category sets and context sensitive DFFs
• Configured custom item templates and disabled all seeded templates
• Reviewed and configured new material statuses and item types
• Configured custom responsibilities, request groups and security profiles
• Configured the sales order types, line types for various parking Lots and plan types
• Documented BR100 for Inventory, Order Management, Service contracts, Accounts Receivables, Advanced Pricing
• Reviewed the technical design documents and halped development team on the progress of development
• Supported UAT and completed signoff for all RICE components as per project plan
• Developed User Training KIT and trained Garage administrators for EBS and Portal usage
• Supported cut over, Go live activities and assisted Client SMEs and process owners in assessing business readiness completeness
• Configured Auto Lock Box processing for multiple Banks
• Supported SIT and UAT
• Provided post go live support and resolved the process, data and user errors

Confidential, Michigan, USA

Environnent: Oracle application 11.5.9, Oracle Configurator, PL/SQL, UNIX

Responsibilities:

• Part of the team in Analyzing the enhance requirements and Documentation of AS IS in the data load process and Configurator set ups
• Studied the GM Legacy systems for the data structure and mapping performed to the Oracle Configurator in the existing project
• Involved in the Design of enhancement approach, test plans and the estimation of resources
• Studied the existing documents and prepared the test case documents for the new enhancement project covering the existing functionality and the enhancement requirements
• Identified the individual components consisting of UNIX loading scripts, PL/SQL packages and Java Classes which requires modifications as per the enhancement approach.
• Created functional design documents on Oracle Configurator and Order management components
• Assisted technical team in designing the technical flow for the enhancements
• Involved in modularizing the technical development of key components to support parallel development by multiple resources to reduce the development time
• Analyzed multiple UNIX shell scripts, PL/SQL packages to reduce the data loading process which was running for more than a day.
• Used TKPROF, SQL Tracing and identified multiple components causing the performance issues
• Introduced Dynamic SQL in various PL/SQL program units and gained the performance benefits resulting significant reduction in the data loading process time
• Worked with testing and development team for the resolution of issues/bugs raised during unit testing and documented the changes, fixes performed
• Involved in designing the scripts to identify the issue cyclic reference in the data and to cleans the same to avid data load failure which was identified during unit testing.
• Assisted the client process owners from legacy system to build scripts to identify the data causing Cyclic reference
• Performed Extensive testing to verify various enhancement changes and documented the issues
• Worked for the resolution of all the issues raised during integration testing
• Supported the UAT and resolved the tickets raised during the user testing
• Fixed the various bugs/issues raised during UAT

Confidential

Environment: Oracle application 11.5.9 (GL, AP, AR, BOM, INV, Costing, MRP, WIP, PO and OM)

Responsibilities:

• Prepared BR100 for BOM, WIP, Costing and INV modules
• Set up custom Item templates, new material status, work day calendars
• Configured WIP accounting classes and WIP parameters for multiple organizations
• Set up resource groups, resources, Standard Operations, departments and item
• Configured the OSP resources and set up Bills of materials for the execution of out work in the work order processing.
• Set up multiple DFFs, Alerts for custom extensions for various business needs
• Setup Bills of materials Parameters for multiple organizations
• Implemented Standard costing for multiple inventory organizations
• Authored functional Designed documents for the conversion of Items, Bills of materials, Routings, Item Costs, Lead times, Open purchase orders, Blanket agreements, releases, sales orders and Price lists
• Set up Sourcing Rules and configured the sourcing assignments
• Configure Item categories and Category sets
• Developed User Training KIT and trained end users on Work in progress and Bills of materials module
• Extend order line work flow to suit business requirements
• Review of Functional specs, technical specs and test cases from
• Implemented Cycle Counting for multiple warehouses
• Configured shipping networks, internal customer associations for the internal sales order set up

Confidential

Environment: Oracle application 11.5.9 (INV, PO, OPN, OM, AP, AR, GL, Advanced Pricing)

Responsibilities:

• Participated in the product, implementation partner evaluation process as part of core team member in the ERP implementation project
• Member of the core implementation team from day one of the project kick off.
• Process owner for the Inventory, Purchasing and Order management functions
• Involved in requirement analysis, As is, to be and gap analysis of the project implementation
• Involved in configuring various flex fields, contexts for item, categories, purchase orders, sales orders, and other setups
• Supported the implementation partner team in understanding the project business requirements by taking through the team members on the actual business process and existing legacy system mappings.
• Participated in the CRP1 and CRP2 during project implementations
• Supported the implementation team in configuring the menus, responsibility structure by exploring them to the existing user security structure in the legacy system.
• Raised request for multiple custom reports on pending receipts, daily production reporting, Outstanding aged report and assisted implementation team in the functional designs
• Planned and executed the data Conversion strategy, cut over activities.
• Supported implementation team in building test cases to include various business cases to support existing business operations
• Supported the version control for the various project deliverables including, code, design, setup, Test cases, UAT sign off documents,
• Developed scripts for complete data migration from legacy to new ERP system covering items, formulas, recipes, item costs, pricelists
• Developed scripts for complete opening balances uploading from the legacy including on hand quantities, purchase orders, sales orders
• Underwent the super user training from the implementation team on the implemented modules and trained the end users
• Performed extensive UAT and documented the results, gaps and bugs for the purchasing, order management and inventory functions
• Has been point of contact for end users on post go live support in assisting the users for the initial system usage and the issue resolution from the support team
• Enhanced multiple Custom reports in Purchasing, Costing and inventory management modules post go live to accomplish user requirements

Confidential

Environment: Oracle 7.3, SQL Forms, SQL Reports, UNIX

Responsibilities:

• Part of the IT team for application supporting and enhancements on the daily business operations
• Owner for inventory and purchasing streams
• Performed requirement analysis, application design, development and testing roles in the support team
• Developed multiple reports for the business users using SQL, PL/SQL, Proc *C for user requirements
• Enhanced, developed new forms to support new business requirements in the Character user interface through Oracle Forms 3.0
• Extended the existing system functionalities to support growing business needs though SQL Loader, SQL Menu and PL/SQL packages
• Performed Oracle table Re organization regularly to improve system performance
• Developed multiple schedule jobs through UNIX cron jobs for regular business requirements
• Configured the document sequence allocation every year for all the transactions in the system.

Confidential

Responsibilities:

• Product Design
• Prototyping
• BOM and Routing setup
• Capacity and resource Planning
• Production Management
• Tools, consumable planning
• Productivity initiatives,
• Physical Verification activities
• WCM Implementation in the plant
• The KANBAN setup