Jonathan Masalonga

Jonathan Masalonga

Objective

To have a decent job that is suitable to my course for the benefits of the company.

To work efficiently and harmoniously with colleagues. To increase knowledge, skill and abilities by working with trained or experience contemporaries. To dedicate my service to the company I am working.

Summary

More than 5 years of experience in IT (technical & database) and administrative support. Strong background in report analyst, database development and maintenance specializes on a manufacturing, materials management and maintenance setup. Experience in major programming languages, operating hardware and software.

Work History

Work History
Aug 2009 - Present

MIS Administrator

Education Development Center

MIS

  1. Be the accountable officer for the proper functioning of the EQuALLS2 database system
  2. Develop, when necessary, and maintain the following:
    • system for validating data, tracking changes in data, and recording reasons for changes;
    • additional programming modules to address M&E (monitoring and evaluation) requirements of EQuALLS2;
    • tools and templates to capture data for program specific needs which are outside and independent  of the EQuALLS2 database system
  3. Assist the COP in preparing discussion papers, work plans, and briefs of M&E activities/results;
  4. Coordinate with program and finance staff on information required from their end for USAID’s TraiNet Web, and encode the required information in TraiNet.
  5. Provide periodic assistance to the administration and HR unit by developing database management programs, such as, but not limited to, inventory and HR information management systems; coordinate with and provide technical guidance or advice on related matters to the DoA and other concerned staff.

IT

  1. Procurement
    • Assess the need for new ICT equipment and the systems that would best meet the requirements of the Reading Program; define appropriate specifications of commodities to be procured;
    • Coordinate with the DoA and the administrative staff responsible engaged for procurement on ICT-related requirements; coordinate with vendors, as required by the DoA;
    • As may be required, provide advice on the appropriateness of price quotations; submit recommendation on service provider that best meets the requirements;
    • Ensure that delivered items are in accordance with specifications.
  2. LAN Design, Installation, and Configuation
  •  
    • Determine the appropriate LAN design suitable for the Project office(s);
    • Install or supervise the installation of the LAN system; and
    • Configure all ICT commodities to available systems (e.g., server, LAN, etc.) to ensure portability, compatibility, and accessibility of essentially shared documents and systems.

3.  Hardware and Software Installation and Maintenance

 
  •  
    • Install new hardware and software systems and observe compliance with license requirements;
    • Maintain a specific inventory of hardware and software, in coordination with the administrative staff in charge of overall inventory of Project commodities.
    • Troubleshoot and repair hardware problems, and software or systems malfunctions;
    • Share updated information and preventive maintenance advisory on virus and similar risks;

  4.Database and Systems Design or Maintenance 

  •  
    • Design, as may be required, programs that will meet database systems requirements, and which ensures security and confidentiality of files or systems;
    • Assist with the updating and maintenance of database systems; and
    • Coordinate with the EDC home office on matters related to email account set up and other ICT-related matters, as required.
Feb 2009 - Aug 2009

Demand Planning Analyst

American Power Conversoin

Essential Duties and Responsibilities

  1. Working closely with North America (NAM) Sales Operations Team
  2. Responsible for the fulfillment of ad-hoc data project development.
  3. Facilitate process improvement within the S&OP process
  4. Monitoring NAM Inventory level.
  5. Creating initial forecast data.
Jun 2008 - Dec 2008

Administrative Officer / CMMMS Systems Operator

Bonatti

Essential Duties and Responsibilities

  1. Responsible for the re-creation of new database from the old structure to the new sets of data.
  2. Defines and updates the Bill of Materials, drawings, technical specifications and other datasheets related to materials for maintenance.
  3. Involve in daily transactional activities like Work Order & Purchase Order creation, stock receiving.
  4. Working closely with the warehouse superintendent in monitoring inventory of all spare parts (repairables and consumables).
  5. Also prepares monthly and weekly report for the CMMMS department.
Feb 2005 - May 2008

Technical Assistant

ITT Corporations - Water Technology International, Inc.
  1. Parametric part database population & vendor maintenance (PRMS).
  2. General product & part related data analytics and reporting.
  3. Maintain engineering preferred parts library.
  4. Bill of Materials (BOM) analytics.
  5. Miscelleneous product and part related data loading and database cleasing.
  6. Create all RDAC transfer pricing workbooks/worksheets as database for all products inclusive of each of its order numbers, description, multipliers, and transfer prices. RDAC Worksheets are precursor to the Price Books for all regional sales groups.
  7. Provide technical definition for all RDAC order numbers.
  8. Maintain these RDAC worksheets and advise in a timely manner adjustments, deletion or revision of products that would affect sales margin.
  9. Managing and maintaining our pricing portal and closely part of the annual standard costing.
Jan 2003 - Feb 2005

Secretary I

International Rice Research Institute (IRRI)
  1. Maintain an adequate filing system and ensure completeness of records, agreements and contracts.
  2. Monitor outgoing mails and prepare correspondence for cash management transactions.
  3. Process and ensure accuracy of the following payments and claims for reimbursement, such as SSS maternity benefits and SSS sickness/EC benefits.

  4. Perform secretarial works such as receives and records incoming mails, sorting and distributions.
  5. Responsible for the following reports/certification requested by NRS, certification for Fund A loan, SSS premium certification (resigned/separated), SSS loans certification and other SSS related reports.

  6. Assist the accountant in NRS payroll production.
Mar 2002 - Dec 2002

Data Encoder

International Rice Reserch Institute (IRRI)
  • Encodes journal entries in the period processing of journal entries of both Premier Ledger and Bank Book modules of the Platinum Financial System and General Ledger of E-Back Office by Epicor, promptly and accurately as to apply date, description, amount (natural and home).
  • Prepares edit list for journal vouchers and provides the same to Accountant-in-charge for validation and correction to ensure an error-free entry.
  • Observes established guidelines and procedures for data entry of Premier Ledger and Bank Book transactions in Platinum and General Ledger and Cash Management Modules in E-Back Office.
  • Classifies Journal Vouchers by Corporation, files in numerical sequence, transfers and endorses to Property and Assets Section for microfilming and maintenance.
  • Generates and prints monthly transaction listing of al project by Scientists and provide Accountants copies for analysis and distribution to respective Program Leaders, Project Leaders and concerned Scientists.

Education

Education
Jun 2007 - Mar 2008

Post Baccalaureate Diploma

University of the Philippines Open University
  • Acquired the necessary background in information systems and computer science in preparation for advanced studies.
  • Gained knowledge and skills in information systems and computer science as applied in their field of work.
  • Developed and improved techniques in the practice of proper design and development of application software.

Acquired 2 unit only

Jun 1997 - Mar 2001

Bachelor of Science

Laguna College of Business and Arts

Skills

Skills

Software Literacy

Office Application MS Excel (Advance) with macro programming using Visual Basic for Applications (VBA), MS Access with external Database links (ODBC, MS Office links), MS Word , PowerPoint and InfoPath. Database Application DB Studio, PL/SQL, Oracle 9.1, AS/400 Database GUI Coswin, PRMS, SAP (AP) Database Report Utilities Repstar, Business Objects WebIntelligence 6.5, Crystal Report Hardware / Peripherals PC(workstation / server), Laptop, Scanner, Network Printer, Network periperals (hub, switch,   router) Programming Languages VB6, VBA, Turbo C/C++ Desktop Publishing Adobe Photoshop CS, Corel Draw 12, Adobe Acrobat 8.0 Forms Financial systems SAP(AP), Platinum, eBack Office, Prime Payroll Multimedia Ulead 8.0, Pinaccle Studio, Adobe Premier. Server/Web Technology             MS Server 2003 Standard edition, MS Share Point Portal, PHP and MySQL  

Hardware/Peripherals Troubleshooting

Router, PC, Laptop, Scanner, Network Printer.  

Certifications

Certifications

Civil Service Eligibility Exam - Sub Professional

Civil Service Commission - Philippines)

Civil Service Eligibility Exam - Professional

Civil Service Commission - Philippines
May 2011 - May 2011

PHP and MySQL Fundamental

UP ITTC – Up Diliman Campus
Oct 2010 - Oct 2010

Life of Project Environmental Compliance and Environmentally Sound Design and Management Workshop

USAID Philippines
Jul 2007 - Sep 2007

Training : Business Objects WebIntelligence 6.5

ITT Water Technology International - Systems Department
Apr 2007 - Apr 2007

Managing and Maintaining a Microsoft Server 2003 Environment

New Horizons Learning Center, Makati City