SUMMARY:

• 11+ years of experience in Design, Development, and Implementation of Oracle Applications 11i/R12 professional as a Senior Functional Consultant.
• Worked on Oracles Applications R12 and 11iinManufacturing,Distribution, Healthcare and Self - Service domains
• Proficient in Warehouse Management(WMS), MSCA, Discrete Manufacturing(ODM), Inventory(INV), Order Management (OM), Advanced Pricing(QP), Shipping Execution(WSH),Depot Repair (DR), Work In Process(WIP), Bills of Material(BOM), Purchasing(PO), Service Contracts(OKS), Configurator(CZ) Spares Management,Costing,iProcurement(ICX), iSupplier(POS), Receivables(AR), Payables(AP) and General Ledger (GL)
• Solid experience in Program Management, Business TransformationConsulting, Oracle EBSImplementation, Product Development and Rollouts
• Good knowledge on Fixed Assets,General Ledger, EBTax and Oracle Transportation Management (OTM)
• Implemented and/or provided functional support as a Supply Chain (SCM)Business Analyst for the R11i and R12Oracle eBusiness/Applications modules
• Functional expertise in Report, Interfaces, Conversions and Workflow customization and testing
• Handled 4 Implementations and 1 Rolloutproject in Oracle Applications
• Responsible for understand and analyze the providedRICEComponent specifications
• Extensive knowledge in documenting technical specifications for RICE components
• Served as liaison for all ERP/EBS application or database projects for internal technical teams and as a point-of-contact between Business and Functional/Technical teams
• Expert in the implementation of Full life cycles of Procure to Pay (P2P) and Order to Cash (O2C) going through Development (DEV), Conference Room Pilot (CRP), User Acceptance Test (UAT) and Production, User Training, go-live and post go-live Support in complex Multi-Org Environment
• Support, execute, and validate customizations, forms personalization, SQL queries, PL/SQL procedures, interface programs and interface scripts
• Extensive in AIM methodology documents such as BR100, BR30, MD50 MD70, MD120 and end user manuals
• Responsible for gathering user requirements, functional design, assistance to developers and testing customizations
• Leading in all phases of theSDLC(Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines
• Developed SQL scripts for issue identification/resolution and data extraction. Extensive experience in PL/SQL procedures, packages and Apps table structure
• Performed functions of project management activities & lead team in size of 5 to 10 and driven the good quality delivery within stipulated project deadlines adhering AIM standards

TECHNICALSKILLS:

ERP: - Oracle Apps R12 and 11i (WMS, MSCA, ODM, INV, OM, QP, WSH, BOM, iSupplier, WIP, PO, iProcurement, Service Contracts,iExpense, AR, AP, OFA, GL, OTM, P2P, O2C cycles

Database: -Oracle 10g, 11g

Tools: - Toad, SQL Developer

Languages: - SQL, basic PL/SQL, Unix

PROFESSIONAL EXPERIENCE

Confidential - Englewood, CO

Senior Oracle Consultant

Responsibilities

• Responsible in design and development of ERP, Trade Managementand legacy systems integration
• Involved in current Business Process, Mapping and regression testing with SCM and Import Business teams
• Designing existing Inbound Process and modifying according to fit for different levels of screening approval process
• Single point of contact for the client and troubleshoot all the related workflows &integrationtouch-points to meet transportation scenarios and requirements including Order Releases
• Involved in creation of functional (MD50), technical design document (MD70), mapping document (RD30) and test scriptsusing Oracle AIM standard
• Identifying and creating Inbound custom process in ERP for Global Trade Screening process

Confidential, Power, Atlanta, GA

EBSIT Lead Consultant

Responsibilities:

• Leading multiple teams with various technologies to support end to end business process
• Gathering the requirements of business, providing the solution of short-term fix and long-term business process improvement/redesign;
• Business process redesign as per the changing requirements of business structure and supporting
• Control over technical and functional implementation/testing of the changes and updating CF250, MD070 documents accordingly
• Close work with Client’s representatives (IM team) on ensuring the on-time delivery and timely resolution of the issue, as well as setting the priorities both from Client’s and organization side
• Responsible in identifying the enhancement areas and will oversee the gathering and analysis of the business requirements through business solution identification, scoping and will prepare enhancement and implementation plans
• Order Management, Advanced Pricing, Shipping Execution, Purchasing, Inventory, Costing, WMS and MSCA requirement gathering and process implementation
• Integration of mobile RFID devices using Oracle Telnet
• WMS Picking and WMS PutAway Rules as per new business requirement
• Gap analysis in development/enhancement of OTM integration with ERP
• Take initiative in process improvements that drives innovation that lower costs, improve data analysis, and meets account needs for clients
• ModifiedERP Shipping Outbound Interface program as per business requirement for change in integration to OTM
• GTM screening issues and changes
• To support the production issues occurring in ASCPfor Supply Commits and Planned orders releasing, sourcing rule, collection and plan runs
• Perform the feasibility study, solution and high level design for any new enhancements as current ERP is integrated with different 3rd party applications. Manage the Team and complete the tasks in an efficient and timely manner and also by reporting progress to stakeholders.
• Supporting day to day Business activities from Atlanta Warehouse in Order Management, Inventory, Purchasing, Depot Repair and WMS
• Handling ERP-SOA-OTM integration issues
• Implementation of process improvement through Lean/Six Sigma Methodology to reduce costs and cycle times

Confidential

Offshore Lead Consultant

Responsibilities:

• Coordination with Onsite Manager
• Distributing the tasks to the team members as per their area of expertise
• Map the requirement and designing the process/implementation steps for Oracle Distribution Modules
• Involved in creation of functional (MD50), technical design document(MD70) and Installation steps document(MD120) using oracle AIM standard
• Application setups for applicable EBS/ERPmodules - Inventory,iProcurement, Purchasing, iSupplier, Order Management, Advanced Pricing, WMS, Costing, Receivables and Quoting functionality
• Designing new LoftWarelabel formats for shipping, receiving and warehouse process
• Creating Operation and Strategies plans according to business requirement and related WMS setup rules
• IntegratingOrderManagement with Purchasing in Drop Ship flow, Internal Sales Order (ISO), Back to BackOrder (B2B)andInternalRequisition andInternalSalesOrder
• Involved in customizing Shipping interfaces according to business needs
• Set up Punchout, Catalogues, iSupplierinvoice creationand approval hierarchy using AME
• Involved inOAFramework Personalization's for iProcurement&iSuppliermodules.Coordinating the review activities for the application/custom objects with the user/business
• Quality control of the user/business testing and defects using HPQC a third party administration tool
• Configured Purchasing options, Receiving Options, Purchasing Approval Groups, Buyers, Jobs, Position Hierarchy, Assignment set, Sourcing Rules and the Approved Supplier list
• Conducting CRP, UAT & Training Sessions and providing solutions or workarounds for the questions raised and ensuring documentation is prepared as per AIM methodology like BR30, BR100, MD50 etc.
• Ensuring GE GDC compliances are implemented in every aspect of the project
• Finalizing the Conversion documentation with technical team in order to get data loaded into various instances

Confidential

Offshore Lead Consultant

Responsibilities:

• Coordination with Onsite ManagerDistributing the tasks to the team members as per their area of expertise
• Map the requirement and designing the process/implementation steps for Oracle Distribution Modules
• Application setups for applicable EBS/ERP modules - WMS, MSCA, Depot Repair, Inventory,Costing, iProcurement,iSupplier, Purchasing and Custom Intercompany process in Order Management
• Designing new LoftWarelabel formats for shipping, receiving and warehouse process
• Creating Operation and Strategies plans according to business requirementand related WMS setup rules
• Understanding business requirements and developed BRS documents for iProcurement, Purchasing andiSuppliermodules
• IntegratingOrderManagement with Purchasing in Drop Ship flow, Internal Sales Order (ISO), Back to BackOrder (B2B)andInternalRequisition andInternalSalesOrder
• Involved in customizing Shipping interfaces according to business needs
• Involved in the implementation ofiSupplierPortal. Automated Supplier Registration Approval usingiSupplierAPIs andOracleAlerts
• Worked on the functional design of customization of Requisition Account generator for iProcurement requisition and functional testing
• Involved in development of Invoices inbound interface program to upload data using EDI into AP,EB-taxand GL tables
• Fixing issues in theEBTaxreports
• Develop theEBTaxCustomer Reports based on the Legal Entity wise
• Set up and data load of Purchasing Categories and Expense Account Rules
• Mobile applications implementation using Oracle Telnet
• Testing warehouse process and recommending changes
• Configured Purchasing options, Receiving Options, Purchasing Approval Groups, Buyers, Jobs, Position Hierarchy, Assignment set, Sourcing Rules and the Approved Supplier list
• Coordinating the review activities for the application/custom objects with the user/business
• Quality control of the user/business testing and defects using HPQC a third party administration tool
• PreparedMD50, BR100, BR030, MD70, MD120, CV040 and test case documents using AIM Methodology
• Conducting CRP, UAT & Training Sessions and providing solutions or workarounds for the questions raised
• Testing and documenting design specs for the business scenarios according to GEHC Process
• Ensuring GE GDC compliances are implemented in every aspect of the project

Confidential

Oracle SCM Consultant

Responsibilities:

• Coordination with Client and offshore Manager in order to get requirement freeze
• Creation of functional specification documents, wherever required explaining the functionality and facilitate the client and identified the key areas and products functionalities
• Application setups for applicable modules - PO and OM with respective Indian Taxation setup
• Regression testing in all applicable environments
• Preparing Test Cases and design documents
• Application setups for applicable modules - Order Management Inventory, Contracts / Service (InstallBase),Field Services, Configurator, Purchasing andiProcurement
• Direct and Indirect transaction mapping setup; customized excel interface
• BI Publisher reports for customer invoices and agreements and various templates as per business needs
• Designed Interfaces for creation of BOMs, Routings, Item Costs,WIPJobs
• Rules, Formula setups for Configurator. Creating BOM items and published them to Configurator
• Define forecast Set and feed as demand schedule forASCP
• ImplementField Service technologiesalong with modifications to Inventory, Order Management and the customer data for the various Product Support groups. Performed all necessary setups in Field Service,Order Managementand Inventory related to implement the use of creating Internal Orders via Field Service
• Releasing the planned orders into Purchase requisition for buy items and internal requisition for transfer items based sourcing rule and Releasing planned orders into WIP Jobs for make items
• Setup for Service contracts- extended warranties programs, Agreements, Pricing and Sales Order Process
• Prepared functional/technical and interface documents as per AIM methodology for Service Contracts
• Good configuration knowledge of Approval Management Engine(AME) setup for iProcurement
• Worked on the functional design of customization of Requisition Account generator for iProcurement requisition and functional testing
• Testing in different scenarios and assisting Tech team in building Custom Forms and Reports in 12i
• Helped the project team prepare the test cases required to do the testing
• Logging issues in HPQC and working with concerned teams for resolving them
• Coordinating with Client or Onsite Manager to get inputs
• Implemented Encumbrance for Reserving Funds against Blanket Purchase Orders and tested them
• Assisting the Tech team in understanding the Business Scenarios and creation of the forms
• Developing the specifications for Custom Forms and testing them to meet the requirements
• Coordinating with the Client for Project Deliverables

Confidential

Oracle Applications SCM Consultant

Responsibilities:

• Attend Business Process and Knowledge Transition Sessions with IT & Business Owners. Mapping Customer's requirements into Oracle
• Raising the SR for applying the Globalization and NLS patches
• Setups done for GL, AP, AR, OM, INV, WMS, iSupplier, iProcurement, Costing, Service Contracts, WIP and BOM
• Designed Interfaces for creation of BOMs, Routings, Item Costs,WIPJobs creation and Updates,Component and Resources Issue
• Set up Catalogues and approval hierarchy using AME
• WMS and MSCA requirement gathering and process implementation
• Integration of mobile RFID devices using Oracle Telnet
• WMS Picking and WMS PutAway Rules as per new business requirement
• Creating Operation and Strategies plans according to business requirement and related WMS setup rules
• Defining accounting class for standard and non-standard jobs andWIPparameters
• WIPassembly return, negative component return
• Preparing functional and technical documentations (MD50/MD70)
• Involved in punchout implementation to vendor ecommerce application
• Prepared BR100 for iProcurement and iSupplier Portal modules
• Designed and set up for field service operations that included spares management, assignment manager and territory management
• Performed setups in Banks, Payment Formats for Canada on par with Multi-Currency
• Setups on Intercompany Invoicing through Inventory Application and testing them to suit Business Scenarios
• Involved in setting up Tax Codes, Locations
• Assisting in developing Custom Report and Forms for CAN Org
• Implemented complex Pricing Functionality and process like Drop Ship, RMA and Order To Cas
• Resolve the Issues logged by the users into the Issue Tracker
• Using TOAD to verify back-end tables while working on Issues
• Raising the SR’s with OSS when critical Bugs are encountered and participating in OWC
• Using SQL+ to run few scripts which are specified by OSS team during issue resolving
• Training the Users if there are not aware of the Process/Navigation
• Interacted with client to understand the requirements and helped the developers in building the Total Care System(Customization)
• Designing and testing integration of TC system
• Regression Testing done on Total Care System
• Found Bugs in Total Care System and helped the Developers in fixing the Bugs
• Participated in preparation of MD50
• Prepared End user training manuals for each process used in Total Care System
• Demonstrated the Total Care System to the Client
• Providing support to users during Go-live by way of problem solving and instructions
• Support for all the process used in System

Confidential

Oracle Applications SCM Consultant

Responsibilities:

• Attend Business Process and Knowledge Transition Sessions with IT & Business Owners
• Involved in setting up of GL, AP, AR, IBY, OM, WIP, BOM, PO, WSH, WMS, MSCA, Costing, Advanced Pricing and INV
• Application setups for applicable Oracle E-Business Suite modules and setup for relevant Profile Option, KFF, DFF, Value Sets and Lookups
• Implemented Cart to Cash, Internal, Drop Ship and RMA process and provided end-user training to the clients
• WMS and MSCA requirement gathering and process implementation
• Integration of mobile RFID devices using Oracle Telnet
• WMS Picking and WMS PutAway Rules as per new business requirement
• Creating Operation and Strategies plans according to business requirement and related WMS setup rules
• Integration of RFID devices and LoftWare label print server
• Designing labels in LoftWare for applicable process
• Involved in setting up of ATP (Data Collection) and maintaining it on daily basis
• Assisting Tech team in Data Uploads
• Defining accounting class for standard and non-standard jobs andWIPparameters
• WIPassembly return, negative component return
• Providing solutions in complicated Pricing using Modifiers to give tough competition
• Worked with Tech team in creating Custom Forms for Pricing, Custom Report for Invoice Printing and testing them to meet the requirement
• Modified Oracle EBS workflows for custom business requirements
• Modifying the existing Functions, Menus for a Responsibility according to the requirement
• Personalized the Sales Order form to restrict few Users from updating fields
• Involved in setting up Organization Structure, SOB, FSG Reports and Security Rules
• Special Calendars, Banks and worked with XML team in Check Printing with relevant setups
• Hands on work experience in setting up IBY: Payee, Payment System and Profile Options
• Worked in setting up Receipt Classes (Manual and Automatic), Countries and Territories
• Performed Setups in defining BOM Parameters, BOM Items and other relevant setups and testing them to meet the functionality
• Coordinating with the Client for Project Deliverables