Systems Supervisor cum Payroll Executive
Utmost Building Materials
Total years of experience :18 years, 6 Months
SAP - ERP
*Implementation Phase-Work with SAP consultants, users and colleagues to create and prepare business/system requirements
Provide Business Blue Print.
*HR
Create and Maintain positions for new and existing employees Manage Organizational Management/Structure
*Payroll for Assistant Manager and Below Category
Employees up to 280+
*IXP120 & IXP220 / FingerTec - Time Attendance System
*All Data Processing and Secretarial Jobs
*Create Purchase Requisition, Purchase Order, Service Entry Sheets and Goods Receipt Note and Material Issuance of the department in SAP
*Configure Internet Access and Email Account to workstations
*IT Support for all users
*Handles SLA’s/Create Email Addresses as required
*Conduct Physical Audit of servers, workstations and printers across company
*Monitor Printer Consumables closely and raise LPO’s required
*Handles SAP Backup through transaction code DB13 under IBM Systems Storage TS3100 Tape Library in IBM JS12 Blades Server 7998 Model
*Check Scheduled Backups in our Windows 2003 Server under Backup Utilities
*Do Routine SAP transaction codes checking of server & databases
*Create SAP Transaction Codes and Transport the same to Quality & Production Server.
*Test new developed Transaction Codes or New Procedures Implemented/ELT/UAT/EUT
*Create/Modify SAP User’s Manual and other Documentation.
*Fully support Administration and Finance departments in relation to HR.
*Assist and Support the Network Engineer in whatever task at hand.
*Projects created with MS Access 2007
->Utmost PC Inventory Database System
->Utmost Properties Maintenance Service Database
SAP - ERP ECC 6.0, Microsoft Office 3.11 to 2013, Sun Micro System Star Office 5.0, Open Office
Org., MS Visio, Ulead Video Studio, MS FrontPage, Adobe Photoshop, Powerterm
Hardware and Network: Troubleshooting, Installation OS and other application, LAN connections and patch cord crimping
Others: Video making and cropping using Ulead VideoStudio, Front End and Back End Database Design,
Relational Database Management System, System Analysis and Design & ISO Documentation.
Seminars and Trainings Attended
Seminar: IQA Seminar on ISO 9001:2000
Given by: Philippine Society for Quality
Date: June 26, 2002
Seminar: Towards Supervisory Success
Given by: The PHINMA Group Development Foundation, Inc.
Date: August 12, 2003
Company: Philippine Long Distance Telephone Company - Bacolod, Philippines
Position: Trainee
Level: On the Job Training
Industry: Telecommunication
Date Joined: April 1997 Date Left: May 1997
SKILLS
Operating System: MS-DOS+, Macintosh OS, Windows 3.11, 95+, ME, XP to Windows 8, Novell and AIX (Basic)
Programming Languages: Pascal, Dbase, FoxPro 2.6, Visual Dbase, Visual FoxPro, MS Access 2002+ and VB.Net (Basic)
Company: Utmost Building Materials - Dubai, United Arab Emirates
A member of Suhail Bahwan Group
Position: Systems Supervisor cum HR - Payroll Executive
Level: Supervisory
Specialization: IT Support / SAP - HCM / HR-Payroll / Data Processing
Industry: Manufacturing (Steel/Timber/Plywood)
Inclusive Dates: April 19, 2007 to present
* SAP - ERP
o Implementation Phase
* Work with SAP consultants, users and colleagues to create and prepare business / system requirements
* Provide Business Blue Print for Organizational Structure and all other information required by Human Resource Department to maintain Employee data.
* Create detailed Process and Document Flow Charts / Diagrams
* Data Mapping for SAP-Human Capital Management module
* Prepare Legacy data for SAP upload and execute it through SAP - Legacy System Migration Workbench
* Design and Create Reports for Administration/Human Resource department through SAP Quick Viewer and Ad Hoc Query
* Involved in the Matrix Preparation of User Roles and Profiles
* Performs ELT (Entry Level Training) & UAT/EUT
* Create User Training and Systems Implementation Documents
o HR
* Create and Maintain positions for new and existing employees if required
* Manage Organizational Management/Structure and Employee Information
* Ensure all data required for Payroll is met after hiring a new employee
* Handles employee Transfers, Termination and Separation
* Provide Administration/Human Resource standard reports or as required
* Create Ad Hoc Queries as needed
* Assist and Support Administration/Human Resource Personnel
o Payroll (for Assistant Manager and Below Category)
* Encode, Maintain, Analyze and Verify FI / HR / Payroll data of 280+ Employees
* Process Overtime, Attendance, Absences, Loans and Advances
* Process Monthly Trip/Outstation and Air Passage Allowances
* Verify Loan eligibility of an Employee before sending for approval
* Process, Leave, Final Settlements and Work Schedules
* Intimate Cashier for payments and prepare TT (Telegraphic Transfer) for Bank
* Maintain Employee Leave Provision, Balances and Absences
* Create WPS - Wages Protection System (U.A.E. Labour Ministry Requirement) files for all Companies / Prepare WPS Tally Sheet for all Companies
* Close Payroll and Create FI entries / Postings (Closing, Loans, Bank Transfers)
* G/L Account Posting, Loan Reconciliation, Clearing Employee Vendor Account
* Liaise between Managers and Employees regarding Leave, Air Passage, Loans, Trip Allowance, Overtime and Absences
* Answer to Employees queries regarding Leave, Air Passage, Loans, Trip Allowance, Overtime and all other Payroll related queries
* Provide Payroll information to the Management as required
* Maintain Head Count Report per Company per Payroll Area per Month
* Prepare all required Monthly Payroll Reports, Tally Sheets and Payslips
* Do all other tasks as given by the Asst. Manager & Sr. Manager of Accounts
* IXP120 & IXP220 / FingerTec - Time Attendance System
* Download IN/OUT data in all locations and upload it to SAP System.
* Maintain time and attendance data in SAP System.
* Issue/Activate and Release Access Card for new employees.
* Provide detail Time & Attendance data as required.
* Coordinate with the supplier of this Time & Attendance System if problems arise or any other issues related.
* Data Processing
o Cut and Bend Factories Data Processing and Updation to Unix/Oracle System
* This includes data verification, creation of reports, project codes and close coordination with factory engineers and operation executives for any issues.
* Systems Department
* Create Purchase Requisition, Purchase Order, Service Entry Sheets and Goods Receipt Note and Material Issuance of the department in SAP
* Act as a department secretary and personal assistant of Systems - Sr. Manager
* Configure Internet Access and Email Account to workstations
* Handles SLA's/Create Email Addresses as required
* Conduct Physical Audit of servers, workstations and printers across company
* Maintain PC Inventory Database and Files
* Maintain Printer/Fax Inventory along with its consumables within the Group
* Monitor Printer Consumables closely and raise LPO's required
* Create Material, Employee, Vendor and Asset Codes.
* Maintain Wage types, Symbolic Accounts and General Ledger under Human Capital Management module.
* Maintain User Profiles and Provide Object Class/Transaction Codes
* Extract / Verify data from SAP tables
* Handles SAP Backup through transaction code DB13 under IBM Systems Storage TS3100 Tape Library in IBM JS12 Blades Server 7998 Model
* Check Scheduled Backups in our Windows 2003 Server under Backup Utilities
* Do Routine SAP transaction codes checking of server & databases
* Create Transaction Codes and Transport the same to Quality & Production Server.
* Test new developed Transaction Codes or New Procedures Implemented
* Create/Modify SAP User's Manual and other Documentation
* Create and Maintain documents, correspondence, approvals and other files.
* Fully support Administration and Finance departments in relation to HR.
* Provide Support especially solving issues on MS Office and others.
* Assist and Support the Network Engineer in whatever task at hand.
* Perform other tasks as designated by the Señior Manager - Systems.
* Projects created with MS Access 2007
o Utmost PC Inventory Database System
o Utmost Properties Maintenance Service Database
Company: Union Galvasteel Corporation - Calamba Laguna, Philippines
Position: Programmer
Level: Supervisory
Specialization: HCM/Payroll/System Analysis, Design & Development
Industry: Manufacturing (CRC/Corrugated Sheets)
Date Joined: October 24, 2001 Date Left: December 31, 2006
* Prepare documents with close coordination with the users and management to establish business and system requirements
* Create system functional specifications for the design and development of in-house systems
* Collect and build detailed data and process models for system proposals
* Understand and Study company's processes, procedures and work practices
* Build procedural solutions and implement system tests
* Prepare user's manual, database documentations and training presentations
* Conduct training sessions and assess the quality of systems
* Develop In-house Relational Database Management Systems through Microsoft Visual Foxpro.
* Prepare System Flow Charts/Diagrams, Proposals, Documentation and Users Manual.
* Create and Design Screens/Forms and Report formats.
* Setup, Install and Configure Windows 98, XP and in-house systems as required.
* Maintain the network of more than 40 computers from hardware, software to network cable installation across other locations.
* Troubleshoot software, hardware and network problems across other locations
* Responsible for regular backing up of company system data along with user's files.
* Handles ISO Documentation/Files of the department and a liaison between ISO Committee and our group.
* Handles the IT inventory nationwide and all documents of the MIS department.
* Evaluate and Recommend purchase requisition of new computers or peripherals.
* Create presentation materials for the President and other tasks as designated by him.
* Projects created under Microsoft Visual Foxpro 7
o CGL (Continuous Galvanizing Line) - Production and Inventory Monitoring System
o Timekeeping System (data from fingerprint scanner)
o Payroll System
o HRIS (Human Resource Information System) compose of the following systems: 201 System / SL & VL Monitoring System / Hospitalization Ledger System
o PASS (Purchasing And Stores System) - a joint project / Truck Line Up & Logistics System
o Printing of Certification of Compensation Payment/Tax Withheld (data from excel)
* Systems Maintained
o GLAPS (General Ledger/Accounts Payable System) and ARS (Accounts Receivable System) - Created under Foxpro 2.6+
Company: Asia Brewery Incorporated - Cabuyao Laguna, Philippines
Position: Programmer
Level: Supervisory
Specialization: Production/HR/System Analysis, Design & Development
Industry: Manufacturing (FMCG/Food/Beverages)
Date Joined: June 01, 1998 Date Left: October 24, 2001
* Work with users to create documents to identify system requirements
* Make data and process flowcharts/diagrams to create clear project specifications
* Determine and Examine business operations, processes and work flow
* Perform system tests and ensure the integrity of systems
* Develop in-house systems and carry-out functional specifications for management.
* Create system documentations and user manuals
* Provide instructions to user's how to use developed systems
* Setup, Create and Design Database Structure, Forms and Reports.
* Setup, Install and Configure Windows 98, Developed Systems and Other Applications.
* Submit Monthly Accomplishment, Breakage, Production and Inventory Reports to the Management.
* Perform other related functions as designated by the MIS Manager.
* Projects created under Microsoft Visual Foxpro 7
o Industrial Relations Office Information and Inventory System
o Transportation Department - Trip Ticket, Utilization Cost and Job Order System
o Personnel Department Recruitment System
o Electrical Consumption System
* Projects Maintained
o Malt-Silo Milling System
o Brewhouse Inventory, Production and Costing System.
o Tank Farm Inventory and Production System
Tertiary: University of Saint La Salle - Bacolod La Salle Avenue, Bacolod City, Philippines Course: Bachelor of Science major in Computer Science Year Graduated: 1994-1998
Secondary: La Consolacion College - Bacolod Galo Gatuslao St., Bacolod City, Philippines Year Graduated: 1990-1994
Primary: La Consolacion College - Bacolod Galo Gatuslao St., Bacolod City, Philippines Year Graduated: 1983-1990
