Wms Functional Consultant Resume
Dallas, TX
SUMMARY:
- Oracle e - Business Suite Functional expert wif around 8 years of IT Experience including 6 years in-depth experience in design, support and implementation of software applications Including experience as a Functional Consultant
- Extensive experience in teh Functional aspects of Oracle Applications 11i, Release 12.0.3 and 12.1.1 and execution of 4 full lifecycle Oracle Applications implementations including teh exposure to e-Business suite Release 12, numerous Application Support projects, RICE implementations, upgrades, wif high level of Customer Satisfaction.
- Worked across different modules of teh Value Chain Planning and Supply Chain Management suite including INV, Quoting, i-Procurement, OM, Advance Pricing (QP), Advance collections, Credit Management, PO, Costing, WMS, SLA, AP, AR, combined wif a unique combination of their integration wif other modules like Advanced Supply Chain Planning, Advanced Pricing, Rapid Planning, Shipping and Oracle Discoverer.
- Strong understanding of different methodologies (Agile, Waterfall and Iterative), finance and risk models, operation (six sigma, supply chain services), marketing and engineering.
- Excellent communication skills, managed projects wif C Level executives and open source engineers.
- Extensive experience wif Sub Ledger Accounting module - defining teh Accounting Method Builder, setting up events and event classes, account derivation rules, SLA Accounting methods, Accounting conventions, Accounting Setup Manager.
- Experience wif teh return process in Order Management, Reverse Logistics flow and integration to Depot Repair.
- Extensive experience in CRM Modules of Service Contracts and Install Base.
- Extensive experience wif teh Order to Cash and Procure to Report business flows.
- Experience in high volume, high risk, high visibility and low downtime production systems.
- Tools used on projects: MS Office, MS Project, Visio, MySQL and PHP, statistics and risk management modeling.
- Hands on project manager, gatheird requirements to develop architecture, logic and data models, used data for project estimations, sign offs and change request approvals.
- Extensive experience wif Managing Off Shore and On Site teams.
- Experienced in desktop applications, hosted solutions on server farms and disaster recovery centers.
- Developed several Business Requirement Documents (BRD), Functional Specification Documents (FSD) and Financial System Configurations
- Executed critical projects as Business Analyst, Functional Consultant, Onsite Coordinator, Designer on Functional & Techno-Functional roles.
- Extensive business area experience & has received great commendations at Client site for excellent interpersonal & Client interaction skills.
- Adept in reviewing and analyzing teh 'as-is' business scenarios, processes and activities, evaluating end user requirements and custom designing solutions and troubleshooting any problems in teh process.
- Demonstrated abilities in mapping business requirements and translating these requirements into Oracle applications functional specifications and detailed test plans and custom designing solutions.
- Strong communication & leadership skills wif an ability to interact wif business users and lead business projects.
PROFESSIONAL EXPERIENCE:
Confidential, Dallas, TX
WMS Functional Consultant
Responsibilities:
- As a Functional Consultant implemented teh Procure to Pay Business flows including Quoting, Rapid Planning, iProcurement, iSupplier, OM, Shipping, Advance Pricing and INV, PO, AP and Cash Management modules.
- Worked in teh configuration and Setups for WMS contracts
- Performed Requirement and Gap analysis.
- Configurations and Setups for i-Store, iProcurement, iSupplier, Service Procurement, Rapid Planning, Shipping, INV, Order to Cash and Cash Management
- iProcurement: 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
- Worked on teh Setups of AR, AP, GL, FA, CM, i-Expense and worked on teh integration of teh modules wif AR and AP.
- Created FSG Financial Reports critical to company’s business process.
- Worked on Oracle ASCP Module - Defining teh Phantom Routings, Utilization Efficiencies, Routing Effectivities’, Co-Products, Hard and Soft Pegging, Common supply netting, Payback demand and supply, generating planned orders, WIP Mass load and requisition interface, flow line scheduling, non mrp planned safety stock, etc.
- Worked on teh BOM setups - defining teh various Bill Types, setting up mutually exclusive options and option classes, defining teh multi-level BOMs, setting up ECOs, etc.
- Worked on teh Work Orders in Oracle WIP, non-standard WIP Jobs, Work Order Less Completions (WOLC), back flushing, WIP Accounting classes, etc.
- Worked on teh setups of Global Order Promising (GOP), configuring teh ATP Collection Data and Planned Output, Maintenance as a source of supply, supply part condition, defining teh instances, ATP Item attributes, Transit Lead Times, Product Family ATP, etc.
- Responsible for training teh end users on teh new processes and facilitated on-teh-job training.
- Performed Item Mapping from legacy system and vendor catalogs into Oracle - to define new items and categories.
- Worked on Oracle Quality data module including definition, data collection, data management
- Worked on teh iSupplier portal setups - defining teh supplier registration process, supplier creation and approval process, etc.
- Performed all of teh setups of Product Data Hub module including teh setups of Item Catalog Administration, Catalog Administration, Change Management Administration, Configuration Management, People and Roles, Attributes and Functions, Item Catalogs, Inbound Product Data Synchronization and Data Quality Management
- Worked on teh Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
- Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating wif technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
- Worked on setting up teh Modifiers, Qualifiers and Formulas in Advance Pricing Module.
- Worked on setting up teh Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module. Also worked on setting up teh Line and Header transaction flex field in AR for Auto Invoice to work.
- Worked on teh Auto Lock Box process in AR.
- Implementation of Electronic Funds Transfer (ACH and Wire) FT for US and Canada
- Pre upgrade testing and Post upgrade production live support.
- Support Production issues on a day to day basis including month end closure p1 issues
- Implementation and support of Accounts Receivables and Account Payable Module
- Provide support/enhancements for teh existing Oracle and Discoverer Reports (across AP, FA, CM, and AR) and create new ones based on business requirements.
- Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex field Segments / Values, Security Rules, Cross Validation Rules, Journal Sources, Categories, Document Sequence Assignment, Multi-org Setup, Profile Options
- Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per teh SOD Document in System Administration.
Environment - Oracle Applications Release 12.1.1 Upgrade from Release 11.5.10.2 Rollout for US, Canada, EMEA and Middle East AR, AP, GL, Cash Management, OM, INV, PO, Shipping, CDH, PDH, i-Store, iProcurement, iExpense, iSupplier, Rapid Planning, AOL, System Administrator
Confidential, Addison, TX
WMS Functional Consultant
Responsibilities:
- As a Functional Consultant implemented teh following modules: Order to Cash, i-Store, OM,, PO, Shipping, Advance Pricing, AP, AR
- Worked on teh Functional mapping of data Conversions & Enhancements Quoting, OM, Shipping, Advance Pricing, AR modules
- Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating wif technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
- Configured Oracle Quoting, i-Store, GL, AP, AR, Cash Management, OM, Shipping and PO from scratch and simultaneously created BR100 documentation for teh setups.
- Configurations and Setups for I-Procurement, Service Procurement, iSupplier, Rapid Planning, Shipping, INV, AP and Cash Management
- Involved in developing teh Process flows for teh Quote to Cash and Procure to Report modules.
- Worked on teh WMS Setups like Warehouse setup, Warehouse Org Setups, Locator Zones and Parameters, task type assignment rules, label formats, associating label types to business flows, receiving parameters, picking rules for warehouses, operation plan selection rules, advanced lot control, lot and serial attributes, Cartonization, Container Items, Contained Items, cost groups, cycle counts, etc
- Worked on Oracle ASCP Module - Worked on teh Source and Destination instances, creating and launching plans, Generating KPIs, fixing exceptions, fixing workflow notification exceptions, running net change, defining collection strategies, collection methods, continuous and legacy collections, setting up and loading of forecasts, setting product aggregation levels, creating teh routing and BOM for Make items etc.
- Worked on teh setups of Global Order Promising - defining teh ATP Item Attributes, ATP rules on teh source instance, Transit Lead Times, Single Level Supply Chain ATP, Configuration ATP, Demand Class ATP, Data Collection, etc.
- Performed all of teh setups of Product Data Hub module including teh setups of Item Catalog Administration, Catalog Administration, Change Management Administration, Configuration Management, People and Roles, Attributes and Functions, Item Catalogs, Inbound Product Data Synchronization and Data Quality Management
- Setup teh Approval Hierarchies in Oracle Purchasing and Shipping module including setups of Approval Hierarchies, Purchasing options, Matching etc
- Inventory - Worked on teh setups of teh Inventory module - defining teh Master and Child Orgs, Defining teh sub inventories, locators, lots, serialization, planning (Min Max and Re Order Point), Cycle Counting, Physical Invetory, etc.
- Involved in troubleshooting issues on Auto Invoice Import Program.
- Created test scripts for UAT (User Acceptance Testing) in TE040 documentation wif detailed testing of all teh above modules.
- Successfully provided Technical and Functional support to teh users, testers and Business System Analysts.
- Provided wif useful training to teh users in GL, AP, OM, INV and PO Modules.
- Created FSG Financial Reports critical to company’s business process.
- Worked on creation of MRC Setup by defining primary Set of Books and Reporting Set of Books in Oracle GL.
Confidential, Dallas, TX
Oracle Supply Chain Analyst
Responsibilities:
- Preparing Business Requirement Documents (BRD) wif teh business rules associated to archive teh daily transactional data across different Operating units for nine fiscal years until Sep-2007.
- Preparing business test scripts wif teh business rules associated wif it to test teh data integrity of archived data.
- Performed all teh setups for PO, Inventory, OM, Sourcing, iProcurement, iSupplier, Service Procurement modules.
- Worked on teh Revenue Recognition Process in Oracle AR module.
- Worked wif teh Business team to baseline teh ‘As Is’ Process and derive ‘To Be’ flow.
- Worked on teh entire upgrade strategy to upgrade teh application footprint from 11.5.10.2 to Release 12.1.1
- Pricing Business Requirement Study and designed / documented Functional Specification.
- Identification of Gap & put collaborative effort wif teh Technical team to address teh same thro Technical Specification.
- Facilitated Pricing & IT Business to obtain clarity on teh Business Rules and capture teh same.
- Flow Testing for Modules (AR, AP, GL, OM and Shipping) to make sure flow is working wifout any issues.
- I-Expense – Setup iExpense for Connected and Disconnected expense reporting including setting of several expense reporting templates, setting up teh Credit Card interface, implementing P-Card functionality in i-Expense, setting up of Per Diem and Mileage, Setting up iExpense to support Multi Currency, setting up Audit Automation, Setting up of Expense Report Summary client extension, etc.
- Conducting Pre Project Review & Post Project Review.
- Providing Post Implementation support
- Worked for teh Category & Mapping data migration to meet teh go alive deadline.
- Jointly worked wif teh QA team in formulating teh Test Cases & Test Scenarios.
- Assisted Business for Business Acceptance Testing and obtain Sign off.
Environment: Order Management, Order to Cash, ASCP, GOP, Shipping,, WIP, BOM PO, iProcurement, iSupplier, iExpense, Sabrix Tax Engine, Accounts Receivables, WMS, Shipping, Inventory, Purchasing modules
Confidential, Addison, TX
Distribution Functional Consultant
Responsibilities:
- Defining Flex field, Profile options, System parameters, Document Sequences
- Application support and Troubleshooting Workflow issues related to Order Management
- Worked on both CTO and ATO Models.
- Troubleshooting CSR (Customer Sales Representative) calls for Oracle Quoting module including identifying issues related to CFD’s (Customer Facing Documents).
- Worked on setting up teh warranty contracts in Service Contracts.
- Worked on configuring Install Base to capture Reseller, End User and Distributor information for each Instance item.
- Worked on teh Setups and Configurations of OM, PO, Order to Cash, AR, AP, GL, FA, CM, ASCP, WIP, BOM, iProcurement and iSupplier modules and worked on teh integration of teh modules wif AR and AP.
- Worked on SABRIX Tax Engine Setups and worked on integrating it wif Oracle e-Business suite.
- I-Expense – Setup iExpense for Connected and Disconnected expense reporting including setting of several expense reporting templates, setting up teh Credit Card interface, implementing P-Card functionality in i-Expense, setting up of Per Diem and Mileage, Setting up iExpense to support Multi Currency, setting up Audit Automation, Setting up of Expense Report Summary client extension, etc.
- Set up Transaction Types, Applying & Releasing Holds, Credit Checking
- Advanced Pricing, Price List, Pricing Agreements, and Pricing Attributes
- Defining Modifiers, Qualifiers, GSA Price List, Pricing Formula
- Defining Standard, Internal, RMA and Drop shipment Orders
- Define Pick Release, Pick Release rules, Shipping Parameters
- ATO & PTO Models, ATP Checking, Availability & Reservation
- Worked wif business users in deciding and designing new Inventory Org. from new acquisitions.
- Worked on teh Revenue Recognition Process in AR Module, setting up Deferred Revenue Rules, Service Revenue Rules, Etc.
- Worked on Invoice Conversion during new company acquisition.
- Coordinated CRP and UAT testing wif business users.
- Conducted user training for acquired company's employees.
- Solved day-to-day production issues for new acquisitions.
- Worked on interface design for GETPAID (A.R. erp system) integration.
- Worked on mapping from Oracle to GETAPID application.
Environment: Order Management, Order to Cash, WIP, BOM, WIPInventory, i-Procurement, WMS, MCA contracts, Accounts Receivables, Shipping, Purchasing, Quality module.
Confidential
Oracle O2C Business Analyst
Responsibilities:
- Worked on setup configurations including Flex Field Values & Value Sets, OM Order Types & Workflows, Pricelist Shipping/Picking parameters, Release rules, profile options, lookups & module specific shared entities & objects and their integration.
- Adept in reviewing and analyzing teh 'as-is' business scenarios, processes and activities, evaluating end user requirements and custom designing solutions and troubleshooting any problems in teh process.
- Defined teh Approval Hierarchies, Document Security, Streamlined teh Receiving process, Setup teh Matching Process in Purchasing module
- Defined teh Accounting Rules and Invoicing Rules in oracle AR module to drive deferred revenue as well as upfront revenue.
- I-Expense – Configured i-Expense for Multi-Currency capability, implemented Mileage and Per Diem, setup all mandatory configurations for i-Expense, Implemented p-Card functionality in i-Expense.
- Worked wif end users to document teh business processes & functional requirements also providing them wif training materials
- Worked very extensively on understanding teh proposed 100% customized business logic of teh Business in building teh customized solutions for Shipping on OA framework Technology based on teh legacy of Oracle application E-business suite 11.5.10. All teh above bases business logic was captured in OA Framework code.
- Coordinated activities wif Implementation team on creating test plans & documents, conduct unit testing, correcting bugs and re-testing while meeting project deadlines. Facilitated discussions wif end-users / managers to gather functional requirements.
- Worked in parallel wif teh client is resolving teh CRP 2 and post go-live testing issues wif offshore support.
- Coordinated wif client through Concalls and WEBEX sessions to get teh requirements and also coordinating wif teh technical team for fixing teh issues for proper deliverables to teh client.
- Provided KT sessions to teh testing and teh technical teams.
Environment: Order Management, AR, Cash Management, i-Expense, Purchasing modules
Oracle SCM Analyst
Confidential
Responsibilities -
- Performed solution pilot covering prototyping of “To Be” business process flows by analyzing teh gap in teh business requirements & tan mapping it to oracle functionality
- Worked on setting up order verification holds and new customer credit check holds in OM
- Performed setups & did integration testing for split shipment, drop shipment process, RMA process, shipping parameters wif Quoting, Order Management & custom made ‘Scheduling & Dispatch’ modules
- Responsible for understanding and documenting teh O2C process and customizations required
- Worked on teh Item Master setups including setting up of Inventory Orgs, Defining Item Attributes, Item Catalogs, Item Categories, Item Attribute controls, etc.
- Perform on-site deployment activities for oracle solution for Inventory, Order Management, Quoting modules & custom solutions including ‘Scheduling & Dispatch’.
- Performed Item Mapping from legacy system and vendor catalogs into Oracle to define new items & categories
- Performed configuration setup of custom module ‘Scheduling & Dispatch’ & facilitated user validation.
- Setting up of complete Order to Cash cycle setups from Quoting & order entry in order management to ship confirm in shipping execution module
- Involved in preparation of training material and training setup
- Conducted business workshops/trainings to explain OM and INV modules, workflows and review end-user and super-user feedback for improvements
- Developed test scripts & conducted CRP testing for teh Order 2 Cash cycle
- Involved in teh deployment cycle for Item Mapping, Production Cutover activities, helping teh Pilot divisions to Go-Live, & user support in live phase
- Documented new procedures & Involved in training teh business users on teh new processes and also assisted them during their on-job training exercise