We provide IT Staff Augmentation Services!

Oracle Wms Functional Consultant Resume

Scottsdale, AZ

SUMMARY

  • Over Eight years of professional experience, that includes Oracle ERP experience - particularly in Order to Build, Release to Ship, Procure to Pay, and WMS Applications.
  • Excellent experience in Order to Cash, Procure to Pay and Record to Report functional processes
  • Extensive experience in Requirement gathering, performing Gap Analysis between standard Oracle EBS functionality and current business practice, Solution design, Set up, Configuration, Testing, Data Migration, Specifications for Customization, Documentation, Period End closing and Post implementation support.
  • Functional Oracle ERP (EBS R11i and R12) experience in WMS, OM, 3PL Logistics, Pricing, Shipping, BOM, WIP, Inventory and Configurator.
  • Experience in managing Oracle Service Requests (SR), escalating with Oracle as needed for resolution and researching Oracle patching requirements and assesses impact to common global objectives.
  • Extensive experience in implementation of various Oracle Application versions (1103, 1155, 1158, 11510 and R12) Upgrade from 107 SC to R12.
  • Involved in the Case Study and Client Presentation with Oracle Consulting on R12 upgrade project
  • Well experienced in Multi-Org, Multi-Operating Units, Multi-Currency, Intercompany/Interbiling, Global Oracle Applications environment
  • Merging and Roll out of different OU/Organizations into Single instance
  • Excellent Business Analysis and Documentation Skills.
  • Worked extensively with RedPrairie WMS System.
  • Designed the common error handling mechanism for SOA and EBS RICEW.
  • Strong knowledge in Data Conversion from Legacy systems to Oracle Applications for GL Balances, Suppliers, Customers, Items, Open AP and AR balances, Fixed Assets
  • Have very good knowledge of various Software Development Life Cycle (SDLC), QA and Agile Methodologies
  • Expertise in preparing Designing Process Flows, Test Plan, Business Case, Test Cases, Use Cases and conducting Functional Testing, GUI Testing, Regression Testing, Web Application Testing and System Testing of new/modified application modules
  • Extensive experience working on Quality Center for tracking issues
  • Involved in the Conference Room Pilot (CRP) to install, evaluate, and configure the functionality of the applications, identified gaps, determined solutions and tested modifications
  • Designed and developed RF screens within RedPrairie's WMS application to enable enhanced functionality, meet business requirements, and improve operational processes.
  • Participated in System and User Acceptance Testing
  • Provided training to key users, end users and prepared documentation for Functional Specifications and Standard operating procedures
  • WMS Implementation & upgrade with onsite team and offsite.
  • Aware of Oracle AIM implementation methodology

TECHNICAL SKILLS

Oracle Applications: 11i & R12 (11.5.4, 11.5.7, 11.5.8, 11.5.9, 11.5.10.2, 12.0.4, 12.0.5, 12.0.6), Oracle Financial Analyzer, Application Desktop Integrator ver 7.2 (ADI), Oracle Web ADI

ERP Methodology: AIM

Forms & Reports: Oracle Financial Statement Generator (FSG) Reports, ADI Report Wizard and OBIEE,Oracle ERP (EBS R11i and R12), WMS, Order to Build, Release to Ship, Procure to Pay, Oracle AIM,, OM, 3PL Logistics, Pricing, Shipping, BOM, WIP, Inventory and Configurator, SQL RDBMS DataLoad, TOAD,, SQL, PL/SQL, SQL Mercury Quality Center SPSS MS Excel, Word, Powerpoint, RedPrairie,Visio and Project, Purchasing Costing, i-Supplier, MSCA, Quoting Advanced Pricing

Operating Systems: MS-Windows 95/ 98/ NT 4.0/ 2000/XP, Microsoft Windows Server 2003, Linux, Solaris

Database: Oracle RDBMS 8i/9i/10g/11g

Utility Tools: TOAD, SQL Developer, & Data Loader

Programming Language: SQL, PL/SQL

Project Plan Tools: MS Projects, MS Visio, and MS Office

PROFESSIONAL EXPERIENCE

Confidential, Scottsdale, AZ

Oracle WMS Functional Consultant

Responsibilities:

  • Study of exiting business process of GL aorderccounting
  • Designed the Chart of Accounts Numbering of Cost center and Natural Account values
  • Actively participated in implementation, configuration of Oracle WMS for client, and also provide post go-live support
  • Used the Consolidation feature in Oracle GL for Account Mapping of Legacy Accounts and Oracle Accounts.
  • Provided customized solutions for customers using RedPrairie's Digital Logistix applications.
  • Developed modifications using RedPrairie's MOCA
  • Created new and modified stardard RedPrairie Integration transactions
  • Extensive experience as Oracle Applications e-Business Suite Consultant and Technical Developer in Design, Development and Implementation of Oracle Applications R12/11i.
  • Attend client meetings and working with middle level client staff to assist in their configurations and testing of RedPrairie WMS.
  • Responsible for interface creating, monitoring and maintenance of data between Ross ERP, RedPrairie WMS system and JDA TMS.
  • Strong experience in writing T-SQL, PL/SQL programming artifacts such as stored procedures, Triggers, Indexes, Views, Cursors, UDF using SQL server and Oracle Databases.
  • Designed and developed (BR100) documentation based on the system analysis done on the current 11.5.10 Application. BR100 & CF250 setups consisted of Modules from both OTC and P2P - Order Management, Shipping Execution, and Purchasing.
  • Experienced in backend skills increasing SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers(DDL&DML), User Defined Data types and Functions(UDF).
  • Developed data model, SQL Coding, SQL Query tuning process and Schema
  • Created database objects like tables, views, procedures, packages using Oracle tools like SQL* Plus, PL/SQL and TOAD.
  • Developed Interface Programs and Extensive experience in Oracle backend objects like: Database Triggers, Stored Procedures, Functions, and Packages using PL/SQL.
  • Understand the various legacy system business processes in GE Aviation and their interactions, from warehouse perspective. Client has multiple warehouses located at different locations. Understood the multiple complex warehouse business processes, by working with the client warehouse managers
  • Conducted business requirement gathering sessions with business users, identified gaps, and provided solutions via business process changes and applied best practices. Interacted with client POCs to gather develop and formulate key business requirement documents.
  • Process weekly and bi-monthly statement commissions to all agents
  • Educate agents regarding commissions' calculations, corrections and adjustments
  • Process and post Agent, GA and MGA commissions for several carriers
  • Utilize analytics to develop marketing strategies for AOL mobile applications.
  • Implemented features: Cleaned up entire supplier database in Oracle and associated configurations, prepared a procedure for performing Supplier deactivation, performed mass migration of data related to items, forecasts, quotations, stock locators, discrete job material requirements, ASLs, sourcing rules, WMS rules, paper based pick
  • Conducted JAD Sessions periodically with various stakeholders at various phases of the Software Development Life Cycle (SDLC) to discuss open issues and resolve them.
  • Prepared business requirement documents (BRD), Functional Design Documents (FDD) utilizing AIM methodology and naming convention, as part of key deliverables.
  • Developed PIM Ricew components.
  • Provided high level design / approaches for setting up the complex warehouses in Oracle application.

Environment: Oracle EBS R11i WMS,BOM, WIP, Order Management, MSCA, WMS, Costing, i-Supplier.

Confidential -Fremont, CA

Lead Oracle WMS Functional consultant

Responsibilities:

  • Analyzed current 'distribution' business process running on legacy ERP system and establish a future business process that will be based on Oracle ERP system
  • Implemented Oracle distributed inventory organization and interfacing with 3PL system (Manhattan WMS) for all receiving, shipping and inventory management activities.
  • Retrofitted Custom Reports and XML Publisher Templates in Oracle Process Manufacturing (OPM) to R12 Discrete Inventory as per the business Requirement.
  • Coordinate transportation for shipping parts between multiple facilities.
  • Successfully implemented a new portal that more efficiently takes customer orders.
  • Worked with client managers, end users and other track leads to manage deliverables, timelines and issues related to Logistics track, related to WMS and 3PL processes
  • Developed functional requirement documents (MD 50), configuration setup documents (BR-100) and test scripts for the various customizations involved in the project.
  • Designed and developed RF screens within RedPrairie's WMS application to enable enhanced functionality, meet business requirements, and improve operational processes.
  • Implemented RedPrairie's DLx/Discrete (WMS) for over 30 customers and over a number of projects
  • Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
  • Validating the BR100,CF250 and actually entered data in DV1OMR if there is discrepancy- reaching out and getting the clarification from cross flows.
  • Responsible to support SQL Servers with ever-changing workloads, and achieving some level of predictable performance.
  • Involved in setting up SQL Server Agent Jobs for timely updating of the tables on the linked servers to through SSIS and SQL store procedures.
  • Manage ten employees who provide operational and technical expertise focused on configuring and customizing RedPrairie applications
  • Performed extensive unit testing, system integration testing through various phases of the project.
  • Process daily mail/calls on Agents, MGA's client's commissions, policies
  • Performed detailed testing and logging/ tracking of defects in Mercury Quality Center tool.
  • Good understanding of Oracle databases, Strong in Inventory, WMS, AR and AP modules. Knowledge in Purchasing and MRP (Materials Requirement Planning).
  • Good Expertise in Query and Performance tuning in Oracle. Having working experience in analyzing the Oracle SQL Raw Trace and TKPROOF Trace files in working query and database performance issues.
  • Provided Post Go-Live support for Logistics related issues that involved day-to-day communication with the 3PL provider
  • Process and post Agent, GA and MGA commissions for several carriers
  • Specialized in building various business applications using Oracle Relational Database Management System (RDBMS), implementing, solving break/fix issues, or by providing design, development, and support knowledge of RICEW objects and Java technology.
  • Worked with business users, DBAs & Oracle support (TAR) to address various issues related to design, implementation & support.
  • Constantly searches the AOL On database for click-worthy videos that will engage our video viewers and our demographics.
  • Worked in a team setting to develop designs and customizations for RedPrairie's
  • Digitial Logistic applications
  • Active participation in cleaning up Oracle transactions for smooth period end closing, during Post Go-Live support
  • Conducted JAD Sessions periodically with various stakeholders at various phases of the Software Development Life Cycle (SDLC) to discuss open issues and resolve them.
  • Worked on TOAD for querying important ERP data for project and business
  • Developed user manual documents for business users and trained them
  • Implemented key features: XML gateway setups for 3PL logistics, Supplier Instance workflow monitoring, custom programs for synchronizing receiving, shipping and inventory transactions between 3PL system and Oracle

Environment: Oracle Applications R12, 11.5.10.2 (AP, Purchasing, AR, OM, GL, INV), Reports 9i/10g, Forms 9i/10g, Oracle 10g,RedPrairie, SQL*Loader,Oracle EBS R12 WMS / 3PL Logistics, OM, Inventory, Purchasing

Confidential, Iselin, NJ

Lead Oracle WMS Functional consultant

Responsibilities:

  • Experience in preparing business requirement documents (BR150), As-Is business process flows (BP040), To-Be business process flows (BP080), functional design documents (MD-050), creating and execution of test scripts (TE 20), develop and deliver end-user training materials such as user manuals, prepare and perform functional set-ups (BR-100s) in accordance with Oracle AIM methodology, and interact with Oracle Support via TARs to implement solutions. Tested patches to be ready to promote into Production environment through elaborate approval process.
  • Functional Oracle ERP (EBS R11i and R12) experience in WMS, OM, 3PL Logistics, Pricing, Shipping, BOM, WIP, Inventory and Configurator.
  • Involved with Business teams and worked closely with the Oracle Order Management sales Admins, Purchasing Admins and Contract Manufacturers.
  • Worked on creating POC Drop Shipment Proposed Plans for a direct shipment process in Oracle from CM's to the Customers.
  • Design and Developed data validation, load processes using PL/SQL, Stored Procedures, Functions, and Triggers using Oracle 9i.
  • Hands on experience in developing custom reports using SQL Server Integration Service (SSIS) in Business Intelligence Development Studio (BIDS)
  • Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Functions.
  • Process daily mail/calls on Agents, MGA's client's commissions, policies
  • Worked on cross functional teams for resolving various oracle functional issues and gathering appropriate requirements.
  • Process weekly and bi-monthly statement commissions to all agents
  • Invovled in the development of Interfaces, Data Conversions, Developing new Forms, Reports, Customizing Oracle Reports in Order to Cash, Procure to Pay Cycles touching various modules such as INV, OM, SHIPPING, AR, PO and AP.
  • Experience in working with Automotive (Commercial Vehicle) industry served as background knowledge for understanding the business requirements and processes
  • Exhaustive knowledge in conducting business solution design workshops with key business process owners, integrate, and in corporate Oracle best business practices with existing processes and within ERP application bandwidth.
  • Maintain solution design within standard Oracle out-of-the-box capabilities and curb extensive enhancements to the ERP applications by proposing business process changes to client's satisfaction.
  • Setting up SQL Server Agent jobs for timely updating the tables on the linked servers through SSIS and SQL stored procedures.
  • Worked on T-SQL for the retrieval of the data and involved in performance tuning of T-SQL queries and stored procedures.
  • Rendering complete support and maintaining and implimentation of Oracle R12 financials modules.
  • Implemented RedPrairie's EMS (Event Management System) and LENS softwares.
  • Utilize analytics to develop marketing strategies for AOL mobile applications.
  • Role included active interaction with Leads for Development, Technical, DBA, Configuration Management, Interfaces, Production Support, and entire Project management team. Primary POC providing daily and weekly status for functional testing via status calls, and status reports to Client and internal PMO team.
  • Works with the AOL On Sales Team to best advertise appropriate branded content on AOL On.
  • Worked with RICEWF components involving creation of Reports that are not available as standard reports, creation of the Interfaces to external systems, creation of Conversion programs to transfer data from a legacy system to the new system and Enhancements to the existing system to add additional functionality to existing system without disturbing the core software functionality of the system.
  • Developed PIM Ricew components.
  • Documentation: BR30, BP40, BR80, BR100 and TE050.
  • Performed production support and maintenance of client applications
  • Excellent Communication, Interpersonal, and Organizational skills.
  • Ability to work effectively in cross-functional team environments and experience of providing training to business users

Confidential -Chicago, IL

Lead Oracle WMS Functional consultant

Responsibilities:

  • WMS Implementation & upgrade with onsite team and offsite.
  • Project Manager, WMS Software upgrades and installations. Track and report weekly on percentage complete.
  • Well rounded WMS Project Manager and BA Implementation, Upgrades, Account Management, resource development, worked with diverse organizations, Project initiation, Project Planning, Project Execution, and Project Closure.
  • WMS Modules implemented QA, Receiving, Order Processing, Order Filling, Pallet Movement & Shipping and invoicing.
  • Serves as acting supervisor on bi-monthly basis overseeing shipping and receiving operations, compiling a detailed daily report of order and delivery times
  • Arranges shipping trailers using Navis, a computerized yard operating system, to optimize loading and receiving processes, meeting target delivery times to stores and maintaining a constant flow of inventory.
  • Monitors best practices in the order fulfillment environment for quality, performance and maintainability.
  • Acted as a functional and technical oracle consultant to understand the business process, create design and implement the project in Oracle R12.1.3.
  • Worked on various P1 and P2 issues. Raised SR's to oracle to resolve various oracle issues.
  • Worked in a team setting to develop designs and customizations for RedPrairie's
  • Digitial Logistic applications
  • Worked as Techno-functional consultant integrating Oracle CRM, iSupport with third party application using SOA, BPEL and Web Services, Customized Workflows in CRM
  • Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Views, Indexes, User profiles query writing and SQL joins.
  • Implemented T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
  • Lead implementation projects end-to-end providing management, functional, and technical
  • Rendering complete support and maintaining and implimentation of Oracle R12 financials modules. expertise for customers using RedPrairie's Digital Logistix applications.
  • Identified any inefficiencies in current operational processes and address this through configuration/customization of RedPrairie's application(s).
  • Oracle Benefits Reports for Basic Life and Supplemental Life Insurance Reports, HMO, PPO, COBRA, AD&D, LTD, Reports.
  • Used ODI as a data integration (ETL) tool, integrating Hyperion planning with flat files & Oracle DB.
  • Works with the AOL On Sales Team to best advertise appropriate branded content on AOL On.
  • Assures PMO practice methodology is followed and adapted for each approved WMS project.
  • Request set for automatic FTP process of generated flat files. Configured Oracle HR application as per ADP requirements.
  • Leader in WMS Project Team, create team environment, Monitors project performance against schedules.
  • WMS Project reviews and approves resource allocations across the project portfolios to ensure that all projects are completed within committed time, scope and budget.
  • Streamlined operations i.e. Warehouse Operations Management communication, WMS software, Operational Change Management, work flow areas in various industries.
  • Created New Custom Oracle Work flow Process and integrated them with seeded one.
  • Provide weekly metrics for open issues with RICEW development objects
  • Implemented WMS, TLM's and PROCESS IMPROVEMENTS & CHANGES i.e. RedPrairie, Manhattan, Sage, & Oracle resulting in savings of time, expenditures and personnel.

Environment: Oracle EBS R11i WMS,BOM, WIP, Order Management, MSCA, WMS, Costing, i-Supplier,Oracle, DB2, Sybase,SQL Server Reports,,ETL, WinRunner, LoadRunner,Oracle Data Integrator (ODI) 10.1.3.4, RedPrairie, Oracle Database 10g, Windows Server 2003, Linux, Windows XP, MS Excel 2003.

Confidential, Waukegan, IL

Oracle WMS Functional consultant

Responsibilities:

  • Evaluating, and adjusting where appropriate, the company setup tables relative to the client business practices
  • Responsible for functional design, configuration change, setup, test and implementation
  • Standard General Ledger reports and Oracle Payables reports such as Trial Balance, Payment Register and Invoice Register using FSG as per the functional specifications.
  • Provide weekly metrics for open issues with RICEW development objects.
  • Modified Sub Ledger Accounting (SLA) definition as per client's requirement and resolve problems with SLA.
  • Invovled in the development of Interfaces, Data Conversions, Developing new Forms, Reports, Customizing Oracle Reports in Order to Cash, Procure to Pay Cycles touching various modules such as INV, OM, SHIPPING, AR, PO and AP.
  • Monitors best practices in the order fulfillment environment for quality, performance and maintainability.
  • Generated database SQL scripts and deployed databases including installation and configuration.
  • Installed SQL Server Management tools using SQL server setup program. Tested the installation of SQL Server and implemented different security modes.
  • Rich experience in writing SQL Queries, Views, Materialized Views, PL/SQL Procedures, Functions, Packages, Triggers, Cursors, Collections, Ref Cursor, Cursor variables, System Reference Cursor, Dynamic SQL, Exceptions.
  • Knowledge on various base tables on Oracle R12 in WMS, INV, Accounts Receivable and Order Management.
  • Created SSIS Packages using Pivot Transformation, Execute SQL Task, Data Flow Task, etc to import data into the data warehouse.
  • Setup Payroll group procedures for running Oracle Payroll and Quick Pays.
  • Managing a team for functional implementation of Oracle Financials (GL, AP, CM and FA modules) with localization across the organization
  • Responsible for implementation of FSGs, AGIS and consolidations
  • Rendering complete support and maintaining and implimentation of Oracle R12 financials modules.
  • Team up with functional teams and customer's staff and produce desirable results.
  • Utilize analytics to develop marketing strategies for AOL mobile applications.
  • Streamlined operations, departments in process and procedures i.e. Warehouse Operations Management communication, Operational procedures, SOP's, Supply Chain, and WMS applications.
  • Streamlined operations, departments in process and procedures i.e. Warehouse Operations Management communication, Operational procedures, SOP's, Supply Chain, and WMS applications.
  • Translate business/functional requirements to technical team
  • Performed fit/gap analysis between the client's business processes and their intended use of the software, identified and communicated the solutions for the problems to the client.
  • Provided customized solutions for customers using RedPrairie's Digital Logistix applications.
  • Developed modifications using RedPrairie's MOCA
  • Created new and modified stardard RedPrairie Integration transactions
  • Well rounded and Business Analyst with Good understanding of various WMS software (i.e. RedPriarie, Sage, Priya, Manhattan) and implementation stages, other software and processes that it effects in configuration, and maintenance.
  • Contributed to the overall strategic vision, and integrated a broad range of ideas regarding implementation and support.
  • Customized the seeded Oracle Workflow by incorporating the desired changes as per business control flows.
  • Approving as well as correcting the accounting entries transferred from Oracle Payables to cover receipt accruals, invoice distributions (expense, Work in Process), payables liability and disbursements.
  • Defined the auto-invoice in Accounts Receivable and confirmed the auto applications.
  • Assists in obtaining the approved/signed "Final Acceptance Sheet" from the client on his/her own module(s) within the project
  • Attended to, researched and fixed issues that emerged from production environment.
  • Conducted JAD Sessions periodically with various stakeholders at various phases of the Software Development Life Cycle (SDLC) to discuss open issues and resolve them.
  • Implemented WMS, TLM's and PROCESS IMPROVEMENTS & CHANGES i.e. RedPrairie, Manhattan, Sage, & Oracle resulting in savings of time, expenditures and personnel.

Hire Now