· Set up primary ledger to allow document sequencing at the legal entity level instead of at the ledger level.

· Setup Merged Distributions feature in AR

• Setup automated receipt handling for credits
• AR Aging Buckets
• Setup dunning plan Limitations

• Improved effectiveness and accuracy of system generated MRP messages
• Reduced the need to expedite orders to meet delivery dates
• Enable production scheduling in Oracle EBS
• Delivered overview presentation and suggested ASCP and Demantra (DM) application for Forecast and plan engine.
• Delivered Demo/Presentation in the terms of Demantra (DM) and Advanced Supply Chain Planning (ASCP) applications and received positive feedback in the terms of approval in next phase.
• Migrated from an Infinite to Finite production capacity including the definition of the Rough Cut Capacity Plan (RCCP) and Capacity Resource Plan (CRP)
• Oracle Field Services
• Improve plant utilization and smooth the demands on the production facility
• Reduce per unit overhead cost
• Increase consistency of material cost for individual items
• The business processes, data cleansing, data governance, system configuration, training and change management
• Enhancing the Materials Requirements Planning (MRP) and Master Production Scheduling (MPS) will help optimize the operations and provide a better opportunity of reaching these goals.
• Improvements in MRP will compress the lead-time for raw materials and sub-assemblies.
• Enhancing the Master Production Scheduling (MPS) will provide better insight into capacity utilization and help drive better decisions on Make vs. Buy and outsourcing decisions.

• Designing business processes in Oracle e-Business R12 applications specific to Manufacturing.

• Coordinate with Supply chain and Finance users to understand requirements and issues pertaining to Oracle ERP.
• Coordinate with IT staff to resolve Oracle ERP related functional issues
• Assisted IT in new developments related to Oracle ERP and developed training materials (SOP) process
• Provide training to Oracle ERP users
• Responsible for gathering business requirements /system requirements.
• Working on ERP (Order Management, Discrete Manufacturing/MRP/Inventory, Outside Processing, Purchasing, Payables, Receivables, GL, Cash Management)

Managed several portfolio of initiatives that multi customers with different lines of business with a budget over $6.5MM
Responsible for the planning and execution of projects for Oracle Cloud Financial & Supply Chain solutions with delivery of business processes, systems and infrastructure improvements to achieve organizational goals and strategic objectives.

• Improve understanding of EBS capabilities and implement rough cut capacity planning (RCCP)
• Ensure clear information from MRP to allow supply to meet demand and reduce manual interactions post MRP run
• Establish best practice for master production schedule creation and management
• The expectations from the project is to achieve the following objectives:

· Improve effectiveness and accuracy of system generated MRP messages

· Reduce the need to expedite orders to meet delivery dates

· Enable production scheduling in Oracle EBS

· Migrate from an Infinite to Finite production capacity including the definition of the Rough Cut Capacity Plan

· Improve plant utilization and smooth the demands on the production facility

· Reduce per unit overhead cost

· Increase consistency of material cost for individual items

• This project will address the business processes, data cleansing, data governance, system configuration, training and change management required to achieve the objectives stated above.

Scoping and Planning

• Define project charter
• Define Scope & high level deliverables
• Define Project Team and Roles
• Define Project timeline and Milestones
• Refine project Scope, Deliverables, Timeline & Finalize Project Team
• Refine project Scope, Deliverables, Timeline & Finalize Project Team
• Define Project Plan

Visioning and Targeting

• Define Business Requirements - Requirements Workshops
• Define Reporting requirements

Design

• Define To-Be Processes and Procedures
• Business Sub Process for Item Creation and Maintenance for Purchased Item
• Business Sub Process for Item creation for manufactured item
• Rough Cut Capacity Planning development
• Develop Data Governances standards
• Define Data Cleansing Plan
• Develop Custom Reporting Functional Specifications
• Define system configuration Gaps

Build

• 'Define and Approve Oracle EBS Design
• 'Configure the Development Environment
• 'Develop UAT Scripts, Scenarios and Schedule
• 'UAT Sign-Off - Report UAT Results and Issues
• 'Develop Change Management/Training Schedule

Implementation

• Execute Change Management/Training Plan
• 'Develop Cutover Plan and Schedule
• 'Go-No Go Decision
• Production Support
• Improve understanding of EBS capabilities and implement rough cut ccapacity planning (RCCP)
• Ensure clear information from MRP to allow supply to meet demand and reduce manual interactions post MRP run
• Establish best practice for master production schedule creation and management

• In house project (Globally) using OUM Methodology
• Created Chart of Account (COA), Ledgers & Multi-Currency
• Oracle (AP, AR, GL, CE, FA)
• Working AGIS environment
• Created Data Access Sets
• Ledger Sets & Definition Sets
• Worked on Demantra collaborator workbench to create worksheets.
• Worked on Demantra business modular to create series and levels.
• Worked on Demantra Integration Interfaces
• Oracle Field Services
• Demantra Trade Promotion Optimization applications (TPO)
• Demantra Predictive Trade Planning experience (PTP)
• Created Levels
• Created Series
• Worked on Integration Interface
• Load Promotions and Promotion Data
• Configured Analytical Engine
• (TPO) Configuring Promotion Optimization for Predictive Trade Planning (TPO)
• Worked on Claims come into DSM through the accounts payable (A/P) department. Deductions and off-invoice settlements come into DSM through in the Accounts Receivable (A/R) department. In all cases, the settlement is loaded into DSM automatically.
• Maximize revenue, Maximize profit & Maximize units
• Configured Optimization Steps
• Created the columns on the Retailer level
• Facilitate data loading in PTP with options.
• Defined rules and conditions
• Automated workflow imports settlement data from external corporate systems.
• Setup Sales Team & Strategies
• Flawless, Compensation etc
• Worked on Settlements Trade and Non-Trade
• Defined General Levels-group data according to characteristics of promotions
• Exported Demantra Final Forecast to ASCP
• Integrate and Interface eBusiness Suite.
• Created users and user groups and provided privileges
• Involved in development of Customer Hierarchy Interface.
• Involved in development of Sales Channel Hierarchy Interface.
• Developed different types of workflows
• Worked on worksheet performance management
• Worked on Forecast engine.
• Configure & worked on De-Centralized/GOP environment
• Dealing with Sales Force/Sales & Marketing Strategies
• Specified the Organization & Responsibilities for managing the work and delivering the products
• Defined a project plan?
• The Project plan model of the process that the project team intends to follow to realize the project objectives to brings together a number of important aspects for the process including scope, timing, cost, and associated risks.
• Defined Benefits of planning to lead to success and is more cost-effective than a “just do it” approach.
• Defined Key elements of a plan, Products, Budget – are the time Phased Resource requirements and financial costs?
• Defined the planning process (Stages)
• Defined Scope and Responsibilities
• Defined the responsibilities of individuals or teams in the Organizational Breakdown Structure (OBS), (With respect to Elements of the Work Breakdown Structure (WBS) using a Responsibility Assignment Matrix (RAM).
• Project Control Cycle (PCC): Identified the objectives and constraints, and developed a plan.
• Oracle Projects (Billing & Costing)
• Labor billing client extension
• Create an Approved Revenue Budget for the Project
• Order Management (OM) to Oracle Projects Integration
• Oracle Financials and Supply Chain Management (SCM)
• Order to Cash (OTC) and Procure to Pay (PTP) Processes
• IR to ISO (Internal requisition to Internal Sales Order)
• AGIS – SLA Integration
• Working on AR/AR Netting, Project Costing.
• Setup Distribution Rules, Adjustments etc.
• Working on Projects costing enhancement with Labor Costing.
• Order Management (OM) to Oracle Projects Integration
• Outside Processing (OSP)
• Setup: Assemble-to-Order (ATO)
• Setup: Assemble-to-Order (ATO)
• Back to Back Order (B2BO)
• Drop Ship Order (DSO)
• AP Special Expense
• Auto Lockbox, Receivables Refund
• Receivables Line Item Receipts
• Subledger Accounting (SLA), Control Accounts etc.
• Worked Oracle Data Integrator (ODI) tool.
• Published Forecast To ASCP
• Published Forecast from Legacy To ASCP
• Created new data profile and Integration Type as “Export”.
• Created Worksheet etc

• Oracle Functional Track Lead-Before and After going LIVE

• Work on Core Financials Oracle Procure to Pay (P2P) and Order to Cash (OTC), Oracle General Ledger (GL), Oracle Accounts Payables (AP), Oracle Accounts Receivables (AR), Oracle Fixed Assets (FA), Oracle Internal Accounting Management Systems (IAMS), Oracle Budget, Oracle Grants, Oracle iExpense etc.
• Monitored and managed contract manufacturer’s performance and execution. Resolved tactical and strategic issues from customer demand, production, capacity, materials, engineering and quality.
• Interface Expense Reports from Payables
• Strong contract negotiations and administration to develop new contract manufactures.
• Interface Assets process sends capital asset lines to Oracle Assets to become fixed assets.
• Bank Statements not importing into IAMS: Every month Chase Bank sends a file containing the check images and bank statements. Load the data into IAMS so that the data is available for reconciliation.
• Participated in new product launch development teams to assure that all requirements were reflected in product design, manufacturing and marketing programs.
• Worked on Ledger Detail Reports: Internal Accounts, A/R and Unapplied Cash, A/P and IPM, iExpense

Oracle Functional Track Lead

Setting up CRP and solution design:

• Oracle Distribution Applications Warehouse Management Systems (WMS), Mobile Supply Chain(MSCA), Shop Floor, Purchasing (PO), Discrete Manufacturing (BOM, WIP, SF, ENG) and Oracle Inventory Applications
• Study of current business processes, future business flows and identification of gaps and workarounds in order to provide the best solution in Inventory Management.
• Business Requirements Mapping for Inventory
• Implemented of Oracle Inventory (and assistance in WSH) in the Procure to Pay and Order to Cash business flows.
• Implemented metric reporting platforms, which included line fill-rate performance at the supplier sku level and internal manufacturing sites, lead-time calculating functionality, lines-on-time and complete reporting by supplier and safety stock optimization tools
• Team work with OM, WSH, INV key users and consultants in order to design inventory organizations structure according with the business group (distribution centers, warehouses)
• Solution design ASCP related to VCP
• Oracle Procure to Pay (PTP) and Order to Cash (OTC) End to end process. Global Intercompany (AGIS), Purchase Requisition to Oracle Accounts Payable to Oracle General Ledger to Oracle Cash Management.
• Interface Invoice to Receivables
• Interface Intercompany Invoices to Receivables
• Interface Expense Reports from Payables
• For the Personalization/Customization recommended, shared the WO screen to capture the requirement. Map these to the TO-BE Oracle Flows.
• Implemented Shipping, Return Material Authorities (RMA’s), Available to Promise (ATP), Assemble to Order (ATO), Configure to Order (CTO), Pick to Order (PTO) etc.
• OM: Sales Order (Reservations, Pick Release, Pick Confirm, Receipt, Exceptions: Unreserved, Backordering, Drop Ship, Return (RMA Process), Available to Promise (ATP), Configure to Order (CTO) etc.
• Developed a Supply Chain educational training program within my organization in effort to improve skill levels in inventory and demand planning concepts.
• Finalize the Roles and Responsibilities for each Business unit
• Verified Data setup templates for CRP1 and check the Data Setup needs that it meets Oracle Standards/ Best Practices
• Meeting with SMEs, Modeling BOM, Open BOMs
• Restrictions, Exclusions, Ranges, Definitions, Conditions
• Tested with Oracle Quoting, OM and iStore
• Configuration & Setup Configurator, CDL, UI
• Configuring, Validating, Setting Rules, Interfacing, Defining Standards
• Defining Models, Options, UI definitions
• Use of Configurator CIO, APIs for integration & extensions
• Importing BOMS, defining Extensions, Publication
• Testing Models, Publishing
• Finalized Reporting Needs
• Identified new Interfaces, especially Fuel Force and write a Functional Requirement(MD50)
• Identified all other interface needs
• Recommend/Verified the Training Requirements.

Oracle Functional Track Lead

• As a Procure to Pay (P2P) Functional Consultant implemented the P2P Business flows including i-Procurement, PO, Pricing, INV, AP and GL applications and supporting Project Billing and Costing.
• Worked EMEA Localization, EMEA Localizations, India, Budapest, Philippines, Japan etc
• Provide clear and specific feedback back to the vendor and track down any quality issues accordingly
• Global environment, worked on AGIS
• Created Chart of Account (COA), Ledgers & Multi-Currency
• Working AGIS environment & eBtax
• Created Data Access Sets
• Ledger Sets & Definition Sets
• Managed the Demand Planning department and provided, leadership, direction and development opportunities to the demand planning team
• Created scoring components, tasks (alerts, workflows, dunning letters), and strategies.
• Worked in the configuration of i-Procurement modules.
• Performed Requirement and Gap analysis.
• Configurations and Setups for i-Procurement, PO, AP and GL.
• Worked on the Functional Mappings for data for all Distribution and Financials modules.
• Preparing BR100, MD050, TC200, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Worked on setting up the Approval Hierarchies in Purchasing Module.
• Worked on setting up Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module. Also worked on setting up Line and Header transaction flex field in AR for Auto Invoice to work.
• I procurement: Designed workflow customization and punch-out catalog. Define requisition template and system profile options. Extract catalog and item data. Setup of approval hierarchy, approval groups and approver assignment.
• Pre-upgrade testing and Post upgrade production live support.
• Support Production issues on a day-to-day basis including month end closure issues.
• Implementation and support of General Ledger (GL), Oracle Assets (FA), Oracle Purchasing (PO) and Account Payable (AP) Module.

Oracle Application Release R12 (12.1.3)

• Responsibilities: Oracle Project Applications (Oracle Enterprise Assets Management (eAM), Oracle Inventory Management (INV), Oracle Fixed Assets (FA).
• Order to Cash (OTC) end to process.
• Interface Intercompany Invoices to Receivables.
• Interface Invoices to Receivables.
• Interface Supplier Costs.
• Managed manufacturing/inventory planning activities
• Transfer Journal Entries to GL.
• Prepared relevant documents provided to identify key players in each of the Pace Business units.
• Worked TO-BE Business Flow.
• Go through the GAP Analysis document for each PACE business being mapped in Oracle EAM & Inventory. The requirements need a business Sign Off
• Requirement Gathering/Finalization Workshop with each Business mainly Fixed Route, Preventive Maintenance, Unplanned Maintenance etc.
• For the Personalization/Customization recommended, share the WO screen to capture the requirement. Map these to the TO-BE Oracle Flows.
• If needed, document AS-IS system flows especially for Vanpool, Para transit businesses.
• Finalize the Roles and Responsibilities for each Business unit.
• Verify Data setup templates for CRP1 and check Data Setup needs that it meets Oracle Standards/ Best Practices.
• Finalized Reporting Needs.
• Identified the new Interfaces especially Fuel Force and write a Functional Requirement(MD50).
• Identified all other interface needs.
• Recommend/Verified the Training Requirements.
• Provided Future Recommendations Configured a new 12.1.3 instance using existing Inventory Orgs that would need to be EAM enabled.
• Helped with test scripts execution.

Oracle Application Release R12 (12.1.3)

Worked on Oracle Application Warehouse Management Systems & Distribution & Planning (WMS),Mobile Supply Chain (MSCA), Advanced Supply Chain Planning (ASCP), Oracle Demantra Management (DM)

and Oracle Inventory Applications:

• Worked on Demantra collaborator workbench to create worksheets.
• Worked on Demantra business modular to create series and levels.
• Worked on Demantra Integration Interfaces
• Managed manufacturing/inventory planning activities
• Created users and user groups and provided privileges
• Involved in development of Customer Hierarchy Interface.
• Involved in development of Sales Channel Hierarchy Interface.
• Developed different types of workflows
• Worked on worksheet performance management
• Worked on Forecast engine.

• Setup and prepare workshop for Inventory Material Management and Warehouse Management Systems
• Implemented is pointed to extract the maximum benefit available in the Oracle Applications Functionality, and all the gap was handled with customizations when the functional solutions were not available.
• Provided Level2 production support for a Global Implementation (PHP, THAI, and ALGE etc).
• Provide extendedsupportduring Inventory month end close process.
• Customizing and personalizing approvals usingOracleApproval Management (AME)
• Worked with technical/ SysAdmin team for analyzing patches provided by Oracle Product Support.
• Created BR-100 and BR-110 documents for WMS, Purchasing, iProcurement and Inventory.
• Worked on set-ups for WMS replenishment tasks. Created WMS picking rules.
• Worked on customizations in WMS
• Worked on set-ups for WMS replenishment tasks. Created WMS picking rules and all WMS set ups.
• Worked on customizations in WMS.
• Created new functional design documents MD50, Business Requirement Documents for the enhancements.
• Identified Test Scenarios and developed Unit Test case documents.
• Performed Demo about Oracle WMS to the business users.
• Worked and designed new label formats (LPN labels and Material labels).
• Integrated Mobile scan guns with oracle using Telnet.
• Provided WMS solution to the business based on client requirements.
• Receiving, Put Away, Cost Groups, Labeling, Reservations, Picking, Tasks Management, Rules Engine, LPN Transactions, Shipping and Setups.
• Device Setup, Customizations and extensions on mobile pages, custom bar code scanning, DFI Setups for out of order scanning, and application debugging.
• Item Replenishment: Setup out of box items and how auto replenishment works within Oracle. Need to setup reorder point planning.
• Item Setup: Setup item Manually, Copy from another item, Copy from Template.
• Org Assignment. To setup Sub inventory and Locator.
• Receiving item into Inventory. Showing the RTV process.
• Cycle Counting.
• Physical Count.
• Set item status to “Discontinue”. The item setup should not allow item to be purchased but be transacted.
• Inter Org and Sub Inventory Transfer.
• Restrictions, Exclusions, Ranges, Definitions, Condition
• Configuration & Setup Configurator, CDL, UI
• Configuring, Validating, Setting Rules, Interfacing, Defining Standards
• Defining Models, Options, UI definitions
• Use of Configurator CIO, APIs for integration & extensions
• Importing BOMS, defining Extensions, Publication
• Conducted Presentation, interviews, analyzed current system.
• Provided system designed solutions, worked around the issues and filled the gaps.
• Worked on Inbound and outbound (Receiving to Shipping) etc.
• Setup parameters (Configurations), prepared testing documents and conducted CRP.
• Developed training materials and trained them as well and also trained them how to use.
• Handheld equipment and troubleshoot.

Order to Cash (O2C)Led implementation of the design, testing and Pre-Validation interface including integration. Supported enhancement of the Global Model solution to include updates to the business process.

• Worked as Lead for the Order to Cash (OTC) business process implementation.
• Worked and Configured General Ledger (GL), AGIS
• Involved in requirement gathering for the setup of Order Management and Oracle Receivable Modules.
• Performed GAP analysis and business process mapping for PO, AR and AP.
• Implemented is pointed to extract the maximum benefit available in the Oracle Applications Functionality, and all the gap was handled with customizations when the functional solutions were not available.

• Worked on developing custom cash book application to facilitate POS nature of sale operations of SBL Developed the interface between cash book and Oracle Receivables and Oracle Inventory.
• Performed setups, created setup, Unit testing (CRP), Integration testing (SIT) and Unit Acceptance testing (UAT) documents and testing based on the user requirements/ business processes.

• Conducted Presentation, interviews, analyzed current system
• Provided system designed solutions, worked around the issues and filled the gaps
• Setup parameters (Configurations), prepared testing documents and conducted CRP

Release Oracle R12 (12.0.6), (12.1.1)

• Project Planning and Control (PP&C)
• Created Chart of Account (COA), Ledgers & Multi-Currency
• Working AGIS environment
• Created Data Access Sets & Definition Sets
• Ledger Sets
• Specified the Organization & Responsibilities for managing the work and delivering the products
• Defined a project plan?
• The Project plan model of the process that the project team intends to follow to realize the project objectives to brings together a number of important aspects for the process including scope, timing, cost, and associated risks.
• Defined Benefits of planning to lead to success and is more cost-effective than a “just do it” approach.
• Improved inventory planning processes, optimization of safety stock levels and developed forecast accuracy reporting.
• Defined Key elements of a plan, Products, Budget – are the time Phased Resource requirements and financial costs?
• Defined the planning process (Stages)
• Defined Scope and Responsibilities
• Defined the responsibilities of individuals or teams in the Organizational Breakdown Structure (OBS), (With respect to Elements of the Work Breakdown Structure (WBS) using a Responsibility Assignment Matrix (RAM).
• Project Control Cycle (PCC): Identified the objectives and constraints, and developed a plan.
• Integrated the key planning and control functions (Scope, Quality, Cost, Time, Risk) at different levels of management.

• Implemented Oracle Billing, Oracle Costing and developed ppt slides and delivered presentation also to client about the Oracle Enterprise Assets Management (eAM) and implemented.

• Lead Project Costing/ Project Billing business process implementation
• Designed Accounting Flexfield Structure
• Prepared general ledger power point presentation and demonstrated to client about AFF,

Accounting Key Flexfield concept.

• Did presentation about Oracle Project (PA) overview and concept., Integration with other Oracle Applications like (Inventory, Purchasing, Contract, Receivables, General Ledger, Payables and Fixed Assets) etc
• Overview key features about Oracle Billing, Oracle Costing and Oracle Contract.

• Responsible for requirement gathering and BPR for Project costing and billing.
• Completed Current System Study, Business Requirements and Process mapping stages of the Project with the Business team
• Functional design for PA to OLM integration for tracking course / class cost and revenue.
• Setup the Oracle Project module in Demo Instance according to the business requirements, Set up the system to conducted CRP1
• Business requirements map /gap analysis configured and conducted CRP1.
• Completed setups in CRP1, SIT and UAT instance and developed training docs, user training material (with Navigation & Screenshots), conducted training.

• Worked as Functional Lead involving in Oracle Fixed Assets enhancements.
• Interface with Fixed Assets to PA and PO applications.
• Responsible for project scope, proof of concept, cut over planning, business requirement gathering, AIM documentation, Setups, data conversion, localization, Testing, user support and Training. Participated in System stabilization for General Ledger, Fixed Assets, Accounts Payables, Purchasing, Inventory and Project Costing.
• Did major categorization with Gas and non-Gas properties. Setup and Maintain Book Controls (Corp and Tax Books).Defined and implemented Depreciation Methods, Prorate Conventions like Mid-Month and Half Year.
• Configured, tested and Implemented Group Depreciation, Impairments and Security by Book. Tested and executed Initial Mass Copy, Periodic Mass Copy and Upload Tax Interface. Also tested all transactions like Asset additions, Adjustments, Transfers, Re-classifications, Partial Retire (Unit, Cost), Retirement, Full Retirement, Mass Retirement, Reinstatements.
• Assets Account Generator customization
• Bar Code solution and Bar Tender for label printing.
• Developed AIM documents like BR100, MD50 and TE40’s. Documented and demonstrated Depreciation and Mass copy with closing books of walk forward process, Group Depreciation, Asset Organization structure with Security by Book.
• Interacted with clients, Created a Contract Project, Defined a Rate Schedule Review, Defined an Agreement Type, Defined an Agreement and Fund a Project, Cost and Revenue Budgets and Created Baseline, Defined an Event Type for Revenue, Customized and Defined a Report Type, Customized Reporting Views, Reporting with Project Status Inquiry, Oracle Grants Accounting Related Payables and Purchasing Financial Options, Defined an Expenditure Category, Defined an Expenditure Type, Defined a Non-Labor Resource, Defined a Burden Structure, delivered the presentation in very large group, Defined a Project Role Type, Defined an Award Type, Created an Award, Fund a Project, Created a Grants-related Supplier Invoice, Defined Standard Unit Costs for Asset Cost Allocations, Configured the requirement application, Defined an Organization Labor Costing Rule and a Labor Costing Override, Worked with Reports and Folders, Worked with Graphs, Customized the EPB Home Page, Worked with Business Process Dimensions, Added Tasks to the Business Process, Created Reports, Run some standard Reports, etc. Setup CRP, Setup, SIT and Setup UAT and helped on to proceed GO LIVE.
• Post Production Support: Worked on standard Reports

• Worked as Lead for the Order to Cash (OTC) business process implementation
• Requirement gathering for the setup of Order Management and Oracle Receivable Modules
• GAP analysis and business process mapping for OM and AR
• Implemented is pointed to extract the maximum benefit available in the Oracle Applications Functionality, and all the gap was handled with customizations when the functional solutions were not available.
• Implemented Shipping, Return Material Authorities (RMA’s), Available to Promise (ATP), Assemble to Order (ATO), Configure to Order (CTO), Pick to Order (PTO) etc.
• OM: Sales Order (Reservations, Pick Release, Pick Confirm, Receipt, Exceptions: Unreserved, Backordering, Drop Ship, Return (RMA Process), Available to Promise (ATP), Configure to Order (CTO) etc.
• Trained all users on how to utilize the system. Developed training manuals for OM, AP, AR, FA, INV and CM.
• Worked on developing custom cash book application to facilitate POS nature of sale operations of SBL Developed the interface between cash book and Oracle Receivables and Oracle Inventory.
• Performed setups, created setup, Unit testing (CRP), Integration testing (SIT) and Unit Acceptance testing (UAT) documents and testing based on the user requirements / business processes.
• Provided functional specs for Customers & Open Invoice conversions. Created specifications for custom reporting requirements, worked with technical team for development & testing of the custom reports (OM, AR, INV & Cash Book).
• Post production support for OM, AR, CM & Cash Book (Custom Application).

• Oracle Applications include Oracle Advanced Supply Chain Planning (ASCP), Warehouse Management Systems (WMS), Oracle Procure to Pay and Order to Cash processes and Oracle Implemented is pointed to extract the maximum benefit available in the Oracle Applications Functionality, and all the gap was handled with customizations when the functional solutions were not available.
• Configured rules, strategies as per the business logic.
• Configured printers, label formats under ClearOrbit application for xml data processing and Barcode label printing.
• Developed Barcode labels using Bartender Software.
• Developed scripts to prioritize the tasks with rules defined by Business criteria.
• Worked on set-ups for WMS replenishment tasks. Created WMS picking rules.
• Worked on customizations in WMS.
• Configure new product pricelist, customer specific qualifiers.
• WMS / 3PL Continuous Process improvement in the Warehouse management area.
• Gap analysis of Business requirements and changes.
• Ongoing process improvements / implement for Purchasing, Order Management and Third Party Distribution System.
• Resolving production support issues (Supply chain modules)
• Gap analysis of Business requirements and changes.
• Prepare Functional / Technical specifications on new customizations.
• Resolving production support issues (Supply chain modules).
• Regression testing and issue resolution as a result of new configuration / Code changes going into production.
• Handling Critical and High severity support requests and worked as initial point of contact for business and end users.
• Coordinated & Assisted with the off-shore teamfor development requirements
• Trained and assisted user groups
• Developed alert mechanism for troubleshooting LABEL process
• Setup Global Intercompany Account (AGIS)

• Worked as Oracle Lead Functional Consultant and implemented Oracle Inventory, BOM, Purchasing, WIP, Costing and MRP. The project is to implement Oracle for the newly acquired manufacturing unit. Client has a Global ERP instance.
• Worked on implementation of Oracle Inventory. Client has multi-org discrete manufacturing environment. Studied, analyzed and prepared BR100 setup document. Setup legal entity, operating unit, inventory organizations, sub-inventories, locations and locators. Designed item-templates and item Categories.
• Created logic to identify and remove obsolete items. Create logic to identify duplicate part numbers.
• Created data-mapping document to migrate items and on-hand stock from legacy system.
• Implemented Oracle PO. Studied, designed and done complete setup. Setup Document approvals. Setup approved vendors and sourcing rules.
• Done user training of creation of Standard and Blanket POs and Requisitions.
• Implemented Receiving. Setup Receiving options in PO. Done user training for PO & RMA Receiving, Inspection, Receiving transactions and Deliver to Warehouse.
• Implemented BOM. Setup standard BOM, ATO Model BOMs and Routings. Setup Operation codes, Departments and Resources for Routings. Create data mapping document CV60 to convert BOM and Routings.
• Implemented Oracle BOM/Engineering. Client has standard BOMs, ATO BOMs and routings. Created data mapping for conversion of BOM. Implemented Engineering. Setup ECO categories and Approvals. Trained users to create ECO approve and implement
• Configuring, Validating, Setting Rules, Interfacing, Defining Standards
• Defining Models, Options, UI definitions

Use of Configurator CIO, APIs for integration & extensions

• Importing BOMS, defining Extensions, Publication
• Conducted Presentation, interviews, analyzed current system.
• Provided system designed solutions, worked around the issues and filled the gaps.
• Implemented Oracle WIP. Client has discrete manufacturing for customer configured items. Setup WIP parameters. Done user training and support.
• Implemented MRP. Setup MRP parameters, setup Approved Vendors, Sourcing Rules and Assignment sets. Defined and uploaded Forecast, run MDS, MPS, Launch MRP and used Workbench.
• Implemented Oracle Cost Management. Studied and setup Average cost and cost elements. Prepared conversion document for cost upload along with Item load. Worked on cost rollups and cost update.
• Enter Expenditure Types, Task, Generate, Approve, and Release Invoices, Mission Elements, Performed Adjustments and Regenerate Invoices, Defined and Assign a Billing Extension, Customized and Defined a Report Type, Reporting with Project Status Inquiry, Customized Reporting Views, Batches etc.
• Under OXLY environment, (Accounting Audit based environment)
• RICE environment.
• Assets Account Generator customization
• Bar Code solution
• Using BarTender for labels printing.
• Used Mercury as testing tools.
• Prepared Knowledge Transfer (KT) Documents and ppt for clients.
• Worked on Production Support.Work involved solving logged defects, trouble shooting, monitoring interfaces and Oracle Tar/SR logging.

• Project Planning and Control (PP&C)
• Specified the Organization & Responsibilities for managing the work and delivering the products
• Defined a project plan?
• Defined Chart of Account, Ledgers

• Ledger Sets & Data Access Sets
• Setup Global Intercompany Account (AGIS) for client
• The Project plan model of the process that the project team intends to follow to realize the project objectives to brings together a number of important aspects for the process including scope, timing, cost, and associated risks.
• Defined Benefits of planning to lead to success and is more cost-effective than a “just do it” approach.
• Defined Key elements of a plan, Products, Budget – are the time Phased Resource requirements and financial costs?
• Defined the planning process (Stages)
• Defined Scope and Responsibilities
• Defined the responsibilities of individuals or teams in the Organizational Breakdown Structure (OBS), (With respect to Elements of the Work Breakdown Structure (WBS) using a Responsibility Assignment Matrix (RAM).
• Project Control Cycle (PCC): Identified the objectives and constraints, and developed a plan.
• Integrated the key planning and control functions (Scope, Quality, Cost, Time, Risk) at different levels of management.

• Responsible for Operations, Finance Interfaces implementation. Functionality mapping, Process designing and setups. Coordinated between onsite and offshore teams.
• Did requirement gathering, Development, implementation, Data Conversion, Testing, Support and User Training. Also did Process Flows Design, Development of BR100’s and TE40’s. Performed Unit and Integrating testing. Reviewed and finalized technical documents.
• Order to Cash & Order to Fulfill (OTC & OTF) (End to End Process): (Order Management): Box and Volume – Interfaces like Customers and Orders, Pick Release and Shipment confirmation. Developed initial documents, designed interface processes. Customer cum order interface designed for a brand new customer who is coming with an order. Also configured Accounts Receivables, TCA , iPayments and Shipping process.
• Procure to Pay (End to End to Process): Purchase Order Interface. Modus standard Purchase orders in “Approved” status will import into Oracle PO against contract PO’s. Oracle Payables: Payables Open Invoice Upload. Invoices from multiple vendors. Decision factors like Common template for all the vendor invoices. Also another interface like Positive pay check extract to bank. Oracle Cash Management: Bank statement Loader Interface.

Comex, Mexico City, Mexico.

Working on project with release R12 (12.0.4)

• Oracle Core Financial Applications, Oracle General Ledger (GL), Oracle Receivables (AR), Oracle Payables (AP), Oracle Fixed Assets (FA), Oracle Enterprise Assets Management (eAM).
• Enterprise Assets Management (eAM) is also known as Maintenance application.

Interacted with client, Designed Powerpoint and presented to client about Chart of account structure etc. gathered information and configured the required applications, run dry run testing, setup CRP’s, analysis the system, designed, validated and tested. Prepared necessary test TE040 documents and BR100.

• Worked on Project Costing/ Project Billing business process implementation
• Created AGIS account for the environment
• Responsible for requirement gathering and BPR for Project costing and billing.
• Did presentation about Oracle Project (PA) overview and concept, Integration with other Oracle Applications like (Inventory, Purchasing, Contract, Receivables, General Ledger, Payables and Fixed Assets) etc.
• Completed Current System Study, Business Requirements and Process mapping stages of the Project with the Business team
• Functional design for PA to OLM integration for tracking course / class cost and revenue.
• Set up Oracle Project module in Demo Instance according to the business requirements, set up the system to conduct CRP1. Completed setups in CRP1 instance and set up docs, user-training guide, conducted training in the basic navigation, projects
• Business requirements map /gap analysis configured and conducted CRP2
• Oracle Applications implemented include Oracle Project Billing, Project Contract and Project Costing Applications, Oracle General Ledger (GL), Oracle Payables (AP), Oracle Receivables (AR), Oracle Fixed Assets (FA) Designed Accounting Flexfield Structure.
• Prepared general ledger PowerPoint presentation and demonstrated to client about AFF, Accounting Key Flexfield concept.
• Gap Analysis, System standard Setups, Configuration, Conversion Planning, Conversion setups and CV40 documents. CRP2/CRP3, BR100 updates Test Script TE040 preparation for BPA and Lockbox. UAT and Post Conversion activities. Vertex integration. Post Live Issue resolution, Production user Support for AR and Advanced Collections.
• Interfaced with other Oracle Applications: Oracle Purchasing (PO) Oracle Fixed Assets, and Oracle Receivables also Customized and Defined a Report Type, Customized Reporting Views, Reporting with Project Status Inquiry, and Release R12.
• Designed power point and presented to client about the structure of Accounting Flexfield etc.
• OM: Sales Order (Reservations, Pick Release, Pick Confirm, Receipt, Exceptions: Unreserved, Backordering, Drop Ship, Return (RMA Process), Available to Promise (ATP), Available to Order (ATO), Configure to Order (CTO) etc.
• INV: Ship Orders, Update Inventory, on Cycle Counts, Physical Inventory, Sub-Inventory, Create/Manage Sales Orders, and Interfacing with Receivables.
• QP: Item Validation Organization, Created Pricing Formulas, Created Incompatibility Groups, Created Modifiers, And Created Qualifiers etc.
• AP: Create Suppliers, Invoices Entry, and Validate, cancel, Apply/Unapply, Prepayments, Credit Cards Clearing Process, Invoice Register and setup default printer for user.
• AR: receivables Transactions Processing, Credit Memo Processing, Adjustment Processing,
• eAM: Tracking Assets, Planning, Assets Maintenance, Work Order Billing etc.
• FA: Transfer Assets From Invalid Employee to Valid Employee the Preview and look at the output to make sure the assets being transferred are correct
• Create Few Assets and attach to the employee, Create Mass Addition, Run Depreciation, Transfer to GL (Import and Post etc.)
• Add assets through ADI when some of the segments of the Location Flexfield are enabled
• FA: Manual Additions, Quick Additions etc
• Prepared Test scripts and testing oracle applications mentioned above.
• Troubleshoot their issues and identified the patch number (#).

• Oracle Applications include Applications Oracle Payables (AP), Oracle Receivables (AR), Oracle General Ledger (GL), Oracle Cash Management (CE), Oracle Fixed Assets (FA), Oracle iPayments (IBY), Oracle iExpense (OIE).
• AP: Create Suppliers, Invoices Entry, Validate, cancel, Apply/Unapply, Prepayments, Credit Cards Clearing Process, Invoice Register and setup default printer for user.
• AR: receivables Transactions Processing, Credit Memo Processing, Adjustment Processing, Lockbox Processing etc.
• FA: Transfer Assets From Invalid Employee to Valid Employee the Preview and look at the output to make sure the assets being transferred are correct
• Create Few Assets and attach to the employee.
• FA: Manual Additions, Quick Additions etc
• Add assets through ADI when some of the segments of the Location Flexfield are enabled
• IBY: Transactions in Receivables, Receipts Batches, etc.
• ICX: Process Credit Card Payments in Receivables, Define Remittance (Internal Bank Account), Define Receipts Class etc
• Worked on ADI and WebADI.
• Changed Color to the Oracle Application system, Added printer to Oracle System and Added Defaulted printer to the users.
• Trouble shoot there issues and identified the patch number (#),

• Set up the WMS system under Oracle to comply with the new warehouse facility.
• Deliverables included need analysis, functional mapping, gap analysis, finding solutions, setup and testing.
• New system to have flexibility to handle high / low value items along with other categories.
• Configured two of the inventory organizations for shipping capability along with integration with Boundary applications for shipping manifesting.
• Managed the Demand Planning and Supply Planning departments and provided direction, development and leadership to three demand planners , two planning managers and a distribution analytical team
• Configure new product pricelist, customer specific qualifiers.
• WMS / 3PL Continuous Process improvement in the Warehouse management area.
• Gap analysis of Business requirements and changes.
• Ongoing process improvements / implement for Purchasing, Order Management and Third
• Party system.
• Resolving production support issues (Supply chain modules)
• Gap analysis of Business requirements and changes.
• Prepare Functional / Technical specifications on new customizations.
• Resolving production support issues (Supply chain modules).
• As an Onsite coordinator to coordinate with the offshore team for sizing and scheduling, interact
• with end users and
• offshore team, participate in meeting with customers as needed, meet SLA’s for issue resolution,
• provide guidance to the
• offshore team for issue resolution
• Suggesting and executing configuration changes as and when needed which is acceptable by the business and does not affect the business.
• Regression testing and issue resolution as a result of new configuration / Code changes going
• into production.
• Handling Critical and High severity support requests and worked as initial point of contact for
• business and end users.
• Coordinated & Assisted with the off-shore teamfor development requirements
• Trained and assisted user groups.

• Functionally globally implemented multiple countries and multiple currencies including Thailand, Philippines, and Poland. Order to Cash (OTC) and Procure to Pay (PTP) Process (AS Is Process), Oracle Applications 11i (11.5.9): Multi-Org (MO) and Multi Currencies (MRC). Oracle Applications (APS, INV, Order Management (OM), Shipping (WSH), Pricing, Applications, Used Data load to load data, identified the gaps and mapped the gaps. I was directly involved with multi countries production setups like Thailand, Philippines, Poland etc. Prepared the setup steps document, Setup test scripts and tested, Wrote training materials for users in power point and words as well, Mapped the requirements, Wrote a Training Materials for users and trained the

users.

• Prepare functional designs, test scenarios, BR100
• Prepared conversion document CV060 and converting the legacy data to the existing oracle system
• Working with team, key users, super users, functional manager, project managers, developers and testers.

• Supporting the functional team during User Acceptance Testing (UAT). Performing integration testing and reviewing the unit test results from offshore team.
• Improving the performance of processors as a routine maintenance activity.
• Carry root cause analysis on issues and provide solutions.
• Configured rules, strategies as per the business logic.

• ACM/Order to Cash: Implemented Oracle Advanced Collections (Promise to Pay, Adjustments, Customer Disputes and Credits). Fine-tuned ACM with all the latest patches along with a roll-up patch RUP4. Developed MD50’s for custom reports like Orders on hold, Cash Fore Casting, Workflow status, Metrics and Customer Dispute work flow process. Configured Interaction center. Customized the Collections form. Enabled zoom to navigate to Order Management (OM) and see the customer orders on Hold. Conducted test cycles for Order to Cash flow. Also configured Universal Work Queue/Interaction center, Promise to Pay, Dispute to Resolution. Enabled dunning process through Strategies. Used XML publisher to create dunning templates. Dunning letters processed to customers through mailer.
• AR and VERTEX: Tax Localization for commercial invoice and calculating Sales Tax, State and Central Tax. Involved in Testing. Implemented Auto lockbox interface with Bank of America

• Responsible for Operations, Finance Interfaces implementation. Functionality mapping, Process designing and setups. Coordinated between onsite and offshore teams.
• Project Planning and Control (PP&C)
• Specified the Organization & Responsibilities for managing the work and delivering the products
• Defined a project plan?
• The Project plan model of the process that the project team intends to follow to realize the project objectives to brings together a number of important aspects for the process including scope, timing, cost, and associated risks.
• Defined Benefits of planning to lead to success and is more cost-effective than a “just do it” approach.
• Defined Key elements of a plan, Products, Budget – are the time Phased Resource requirements and financial costs?
• Responsible for all production, demand planning and distribution requirement planning activities for manufacturing facilities.
• Defined the responsibilities of individuals or teams in the Organizational Breakdown Structure (OBS), (With respect to Elements of the Work Breakdown Structure (WBS) using a Responsibility Assignment Matrix (RAM).
• Project Control Cycle (PCC): Identified the objectives and constraints, and developed a plan.
• Integrated the key planning and control functions (Scope, Quality, Cost, Time, Risk) at different levels of management.
• Did requirement gathering, Development, implementation, Data Conversion, Testing, Support and User Training. Also did Process Flows Design, Development of BR100’s and TE40’s. Performed Unit and Integrating testing. Reviewed and finalized technical documents.
• Order to Cash: (Order Management): Box and Volume – Interfaces like Customers and Orders, Pick Release and Shipment confirmation. Developed initial documents, designed interface processes. Customer cum order interface designed for a brand new customer who is coming with an order. Also configured Accounts Receivables, TCA and Shipping process
• Procure to Pay: Purchase Order Interface. Modus standard Purchase orders in “Approved” status will import into Oracle PO against contract PO’s. Oracle Payables: Payables Open Invoice Upload. Invoices from multiple vendors like UPS, American express, Adecco, and Corporate Express. Decision factors like Common template for all the vendor invoices. Also another interface like Positive pay check extract to bank. Oracle Cash Management: Bank statement Loader Interface.
• Also involved in WMS and HRMS like Advance Benefits and Payroll. CRM like Contracts and Sales Order Tracking system.

Developed Order to Cash (OTC) Process

Developed and worked on Systems Operation Process (SOP) for users and worked on some issues as well. (Reservations, Pick Release, Pick Confirm, Receipt Exceptions: Unreserve, Backordering, and Drop Ship, Return (RMA Process).

• Responsible for Operations, Finance Interfaces implementation. Functionality mapping, Process designing and setups. Coordinated between onsite and offshore teams.
• Did requirement gathering, Development, implementation, Data Conversion, Testing, Support and User Training. Also did Process Flows Design, Development of BR100’s, MD50’s and TE40’s. Performed Unit and Integrating testing. Reviewed and finalized technical documents.
• Order to Cash: (Order Management/Account Receivables): Box and Volume – Interfaces like Customers and Orders, Pick Release and Shipment confirmation. Developed initial documents, designed interface processes. Customer cum order interface designed for a brand new customer who is coming with an order. Also configured Accounts Receivables and Shipping process
• Configuring, Validating, Setting Rules, Interfacing, Defining Standards
• Defining Models, Options, UI definitions

Use of Configurator CIO, APIs for integration & extensions

• Importing BOMS, defining Extensions, Publication
• Conducted Presentation, interviews, analyzed current system.
• Provided system designed solutions, worked around the issues and filled the gaps.
• Procure to Pay: (Purchasing/Payables): Purchase Order Interface. Modus standard Purchase orders in “Approved” status will import into Oracle PO against contract PO’s. Oracle Payables: Payables Open Invoice Upload. Invoices from multiple vendors like DHL Express Service, Adecco, and Corporate Express. Decision factors like Common template for all the vendor invoices. Also another interface like Positive pay check extract to bank. Oracle Cash Management: Bank statement Loader Interface.

• Implemented Oracle Applications Inventory, Warehouse Management Systems (WMS)
• Responsible for Oracle Advanced Supply Chain (APS, WIP, BOM, INV, MRP, COSTING, QUALITRY etc.) Oracle Inventory (INV), Oracle Order Management (OM), Oracle Warehouse Management Systems (WMS)
• Worked on Cycle Counts, Physical Inventory, Mobile Warehouse Management
• Gathered information from client.
• Created Snapshots
• Generated Tags
• Prepared the setup steps document
• Setup test scripts and tested
• Prepared and Performed the Training setup steps for Cycle Counting, Physical Inventories and Mobile warehouse Management, and Work in Process (WIP)
• Wrote training materials for users in power point and words as well.

Oracle Applications 11i (11.5.9),

Oracle Applicationsmodules

• Responsible for Oracle Order Management (OM),Oracle Supply Chain Demand Planning & Scheduling, Sales and Marketing, and Incentive (Sales) Compensation
• Gathered Information from Client and based on information
• Redesigned workflow etc
• Reviewed Business Processes
• Mapped the requirements
• Led a cross-functional team that implemented a successful corporate-wide Sales and Operation Planning process.
• Configuring, Validating, Setting Rules, Interfacing, Defining Standards
• Defining Models, Options, UI definitions

Use of Configurator CIO, APIs for integration & extensions

• Importing BOMS, defining Extensions, Publication
• Conducted Presentation, interviews, analyzed current system.
• Provided system designed solutions, worked around the issues and filled the gaps.

Functionally implemented Oracle Applications 11i (11.5.9):

Oracle Applications modules

• Responsible for Oracle Public Sector Purchasing (PO), Public Sector Payables (AP), General Ledger (GL) and Fixed Assets (FA)
• Gathered information from the client and based on information and
• Setup Configurations, Agenda, Designed Workshops etc
• Wrote Test Script
• Setup CRP (AD10 Environment)
• Reviewed Business Processes
• Determined set-up values

Functionally implemented Oracle Applications 11i (11.5.7, 11.5. 8):

Oracle Applicationsmodules

• Responsible for Oracle Advance Supply Chain Planning (ASCP), Oracle Order Management (OM), Oracle (Advanced) Pricing (QP), Incentive (Sales) Compensation (CN), Shipping (WSH), Inventory (INV)
• Worked on End to End Process Order to Cash (OTC) Process
• Setup Configurations, Agenda, Designed Workshops etc,
• Setup planning parameters etc.
• Wrote Test Script, Setup CRP, Reviewed Business Processes, Determined set-up values
• Interfaced the Master Items etc
• Mapped the requirements
• Wrote a Training Materials for users and trained the users

Functionally implemented of a full cycle of Oracle Applications 10.7 & 11i (11.5.3), (11.5.6):

Oracle Applicationsmodules

• Project Planning and Control (PP&C)
• Specified the Organization & Responsibilities for managing the work and delivering the products
• Defined a project plan?
• The Project plan model of the process that the project team intends to follow to realize the project objectives to brings together a number of important aspects for the process including scope, timing, cost, and associated risks.
• Defined Benefits of planning to lead to success and is more cost-effective than a “just do it” approach.
• Defined Key elements of a plan, Products, Budget – are the time Phased Resource requirements and financial costs?
• Defined the planning process (Stages)
• Defined Scope and Responsibilities
• Defined the responsibilities of individuals or teams in the Organizational Breakdown Structure (OBS), (With respect to Elements of the Work Breakdown Structure (WBS) using a Responsibility Assignment Matrix (RAM).
• Project Control Cycle (PCC): Identified the objectives and constraints, and developed a plan.
• Integrated the key planning and control functions (Scope, Quality, Cost, Time, Risk) at different levels of management.

• Responsible for Oracle Receivables (AR), Oracle Inventory (INV), Oracle Purchasing (PO), Oracle Order Management (OM),
• Worked on Order to Cash Process (OTC)
• Review the business process and determine the requirement; Examine those requirement and determine the oracle prerequisites, mapped a requirement to Oracle Application and determine the gaps; examine the required application to determine the prerequisite. Determined input the needed Setup Values; wrote Test Scripts, and monitored testing.
• Determine setup values; Such as Sales Order, Ship Confirm Orders, Release Sales Order, Price List, Discounting Strategy, Header - Level discounts, Line – Level Discounts, etc.
• Created Flowcharts for the Sales Process, Picking and Shipping Flows and Apply Holds to Orders, etc. used Microsoft Office (Bitmap).
• Implemented Shipping, Return Material Authorities (RMA’s).
• Trained all of the users on how to use the system. Developed training manuals for OM and APPO.
• (QP) Created Pricing Formulas, Created Incompatibility Groups, Created Modifiers, Created Qualifiers etc.