Sales Data

STEVE UNDAG

815-***-****

**********@*****.***

Summary:

• Eight years of experience as a Computer Operator/Inventory Control Assistant.

• Monitor System from messages errors and alerts from servers and silos.

• Scans incoming and outgoing IBM/Oracle tapes backups.

• Daily printing of reports from incoming and outgoing tapes.

• Data Entry and Handles Data Collection of Orders from Stores.

• Logging and Updating all Data Transmittal/Collection Summary Sheet.

• Follow-up Store to Complete Data Collection.

• Updating Store I.T. Database.

• Assisting Stores on Application Related Problems.

• Conducting Training of Users on New I.T. Solutions.

• Analyzes and improves existing processes

• Providing Reports to Operations on Status of Data Collection per Store.

• Coordinating with Warehouse,Purchasing,Systems and Logistics Department in Handling of Store Orders.

• Back-Up all Order Data Daily.

• Executing Store Order Data Processing.

• Preparing Oracle Inventory Transfer functions

• Providing Oracle Inventory Reports.

• Creating Inventory Adjustments.

• Basic Knowledge on Unix Scripting and UDP/TCP/IP.

• Experience in Playing Key Team Leadership roles including Store Daily Deliveries, Access to Store Order Information and Customer Interaction,

• Experience in Offshore-Onsite Coordination.

Technical Experience:

Languages: Progress 4GL, Visual FoxPro, ORACLE 11i

Databases: Mainframe/AS400, Microsoft Access, SQL, Oracle 11i, SQL Server

Operating Systems: Windows 98/2000/XP/NT, UNIX, Linux

Tools: Excel, Word, PowerPoint, MS Project, Microsoft Visio 2000.

Education/Training:

• Associate in Computer Science, Philippines

• 2007 The 7 Habits of Highly Effective People

• 2006 5S for Commissary Employees

Experience:

Blue Cross Blue Shield / Kelly Services – IL, USA Nov. ’11 – present

Computer Operator

Daily Operations for Data Center of Blue Cross Blue Shield in Waukegan, IL.

Roles:

• Monitor Systems Mainframe and AS400 systems

• Replies, messages pending, tape and platter mounts

• Reply to nine daily server eject requests received via E-mail

• Daily Ejecting tapes from Production & Test Mainframe system

• Daily Entering tapes from IM put back in Prod & Test System

• Verify all distribution D/R open systems tapes listed were ejected from the SL8500.

• Create and send via E-mail to Iron Mountain four files Picking, Distribution, Inventory & Build files

• Eject and scan mainframe tapes from SL8500.

• Create Daily Exception report to verify using Qwikscan, Outgoing/Incoming tapes ejected match tapes on

- Distribution file.

• Receive Incoming shipments

• Send email replies to customers

• AS400 System - Offsite procedure for all backup tapes. Daily and Weekly (on Friday)

• Scan mainframe incoming tapes received from IM and enter them inside the SL8500

• Incoming mainframe tapes coming in from IM match tapes on Picking file.

• ECS department sends an E-mail to our department PC listing which Distribution

- D/R tapes are Incoming from IM.

• We scan the tapes and create a file: (scantapein/out) that ECS uses to match the incoming/outgoing tapes.

Environment: MAINFRAME, ORACLE, AS400 & UNIX

Chowking Food Corporation - PHILIPPINES Oct ’98 – June ‘07

Inventory Control Assistant

Daily Operations for Chowking Company, Specializing in Customer Management, Order Management, Logistics, Commissaries, Sales analysis and Accounting.

Roles:

• Help the programmers to conduct interviews with the users as part of their data gathering for the requirements specification

• Testing and debugging the new programs developed by IT Group

• Involved in the deployment and cutover of the enhanced application system

• Provide support/assistance to users in the use of the new system

• Test and Process the new Transaction Entry module wherein the orders of the stores were inputted to produce a Sales Order; Inquiry module to inquire for all the orders and deliveries made; Sales Order Processing module and Report Generation

• Coordinate with Supervisor and programmers in preparing output requirements specifications, data flow diagram and entity relationship diagram

• Analyze Order output requirements

• Creates inventory models utilized for planning inventory

• Communicates with department heads in terms of planning inventory, forecasting sales, and approving inventory order requests

• Reconciles report such as order items vs. inventory stocks

• Lead Ordering team in conducting user training program and familiarization to the new application

• Act as Supervisor of Order Management

• Prepare the documentation for new user and technical manual

• Involved in some data administration using UNIX

• Conduct user training for new employee in Order Management Group and Chowking VISMIN Commissaries

• Prepare Sales Order, Purchasing Order and Receipt Report

• Handles Lot/Sublot Change & Adjust Immediate for Dummy Stocks

• Prepare & Printing Insufficient Stocks Report

• Resolve & Reprint Insufficient Stocks Repost

• Shipping & Releasing all Sales Order for Picking

• Checking Unreleased Sales Order

• Printing Weight and Volume per Route,Store

• Printing Picklist Report by Summary and Location

• Printing Loading Guide

• Performs other miscellaneous duties as assigned

Environment: PROGRESS versions 8 & 9.1b, Oracle 11i, Visual Foxpro, Windows 98/XP, UNIX, Microsoft Visio & Excel

Contact this candidate