Melanie T. Rodas
Lot ** Blk * Cribs Subd Magkaisa St. Brgy. San Roque Antipolo City • ************@*****.*** • Cel # 09774706081l# mobile # 0920-7061884884
Objective
I would like to pursue a career in the field of information technology. One that enhance both in management and technical skill.
Employment History
JTG Trading Inc.
(Homeworks the Homecenter) Retail Sept. 3, 2012 - Present
Technical Support (MIS Dept)
Do the connection thru IP-VPN, gathering and updating of WINPOS data
Generating the items for promotion, price change and new items in server database.
Maintenance of Item master file in Store Unlimited System (back-end) of POS system.
Database analysis for the transferred sales data that would be migrated to the backend system (MySQL database) and generate reports at Crystal
Assist the branch to fix database error and some minor technical problem.
Do the inventory Reports of the Store branches.
Database administer for some system updates and changes.
Checking discrepancy occurs in DSR and the store POS.
Generating Weekly Sales report of all branches.
Do some querying in MYSql for some reports.
Lifestyle Concept Co. Inc
(Gingersnaps) Retail Sept. 10, 2011- Aug. 17, 2012
Inventory Analyst/IT Dept.
Preparing reports for the delivery discrepancy of the store branches.
Analyze the summary discrepancy report of the store thru physical count.
Monitoring and adjust the discrepancy.
Monitoring of Repair and Damage items of the store.
Do the report of semi monthly discrepancy of the encoder at the dispatching area.
Conduct physical inventory (quarterly) at the store branches.
Modem connection for downloading of data file from head office.
Analyze and fixed data errors.
Wellcom Telecom Supermarket Inc. July, 2000-March 2007
Electronic Data Processing (EDP) / MIS Staff
Prepare the Stock Status report of the branches.
-Every end of the month we’re getting the backup data of the store namely: itemmast.dbf and cdx, these 2 data is from the file transferred by the branches during connection. From that file we are able to generate the month-end stock status report of the particular branches.
Modem connection using AWLAN or PCANYWHERE, for downloading of data file from store to head office, uploading of new item/change price.
Administering the in house POS system database for the end user
-Any system update or utility modification, we should demonstrate to the user for the effective usage of POS system
Train the cashier for their function and workflow using POS transaction for the store operation.
-Aside from training for cashiering function, we also teach them the back-end of the system or the FULLMENU wherein all the necessary reports needed by the head office are being processed.
Prepare the Discrepancy report of the branches.
-Discrepancy report is based from the physical inventory from the store.
Head Office POS server maintenance.
-Maintain the POS server architecture / folder corresponding to branches.
Conducting the monthly inventory at the store.
-Every first week of the month we conduct the physical inventory to the selected branches, and to those branches which is not scheduled they are responsible to submit their month-end inventory to the EDP Department. As much as possible they must submit their inventory on or before 5th day of the month.
Assist the branches and Head office end user.
-For the branches we fix the database file if there is an error occurred in POS system in particular branches.
Generate the duplicate SKU and ITEMCODE report.
-Thru AIMS we print the duplicate Itemcode and SKU report per branch. With this report we were able to delete the duplicate items in the branches.
Inventory Controller Feb, 2000-June, 2000
Monitoring of Delivery receipt of the stores. Generating the monthly report of Supplier Delivery. Reconciliation of The DR's and the POS system as encoded by the store. Printing of the everyday profit report of the branches. Conducting a monthly inventory at the different store branches.
Educational Attainment
Technological Institute of The Philippines (T.I.P)
Bachelor of Science in Computer Science (B. S. C. S.), March, 1998
Coursework includes: System Analysis and Design, Management Information System, and Programming System.
Rizal College of Agriculture and Technology (R. C. A. T.)
Secondary Education March, 1994
School Address: Sampaloc Tanay, Rizal.
Additional Skills
Windows 95/98/2000, Microsoft Word, Microsoft Excel, Foxpro Application use for POS (Point of Sales).
Knowledge and experience in providing technical support.
Knowledge and experience to train for the cashiering function of POS (Point of Sale).
Knowledge in My SQL scripting.
References
1.Alvin Ramos
MIS Manager
Homeworks The Homecenter
2.Mrs. Gay Mantua
Audit Manager
Wellcom Telecom Supermarket Inc.