Systems Consultant Ii
Greensboro/Winston-Salem, North Carolina Area
• Used functional knowledge to perform Oracle 11i setups and test various business scenarios• Developed and enhanced PL/SQL stored packages, procedures, and various stored database objects• Created ad hoc queries for orders, shipping transactions, purchasing receipts, customer master, customer prices, on-hand inventories, and inventory transactions in Oracle 11i• Supported Oracle 11i Applications – Order Management, Advanced Pricing, Inventory, Manufacturing, Purchasing, Custom Workflows and Quality Plans• Supported Custom Applications – credit systems, warehousing applications, fleet management systems, and freight billing systems in a 24/7 manufacturing environment• Worked with Oracle Support via Metalink to create and resolve iTAR’s • Created solution / technical design documents and business process flow diagrams to help business users achieve organizational objectives and document business processes• Managed the Order to Cash cycle – ensured orders were entered accurately; managed shipping transactions for order completion and inventory fulfillment; and ensured invoicing cycle occurred for each transaction• Managed inventory material transactions, pending shipping transactions, and costing transactions within Oracle to ensure transactional integrity for month-end closings• Maintained PL/SQL packages and procedures, and Pro*C programs for warehousing systems• Conducted maintenance on Oracle Forms and Reports in Oracle 11i format and 6.0 format• Developed and implemented end-user training documentation and programs