Subdivision, Brgy. Gaya-Gaya,
San Jose Del Monte, Bulacan
Email Address: ***********@*****.***
Mobile No. (091*-***-****
Michael Mabait Mercado
Experience:
> December 2013 to Present Talent 2
Eastwood, Libis
Payroll Team Lead (1st Line Operation Manager)
. Supervises Payroll Assistants and Payroll Executives in performing
monthly payroll process activities as scheduled for each client.
. Prepares Work Allocation of the team every month.
. Review the Team Calendar of the team every month.
. Reviews and approves client's payroll calendar yearly for the existing
clients.
. Approves request for leave and overtime of team members.
. Coaches and develops team members by assisting on concerns and enquiries.
. Deals appropriately with issues raised by the team members, and escalate
it to the Assistant Payroll Delivery Manager/ Payroll Delivery Manager
and prepares issue logs if necessary.
. Periodically performs performance review of team members.
. Enforces and reviews client pay step and checklist every month.
. Be a point of contact to client for major payroll processing change.
. Serves as a reliever to the Payroll Executive/Assistant to ensure that
duties are covered in their absence.
. Checks and approves daily TMS submitted by team members.
. Creates codes and generates bank file if needed.
. Monitors team's Monthly Checklist for Finance, Fund Requisition and Fund
Reconciliation.
. Monitors and organizes the team's Operation mailbox and ensure each email
is addressed.
. Checks on team's SOP on files/documents storage in Payroll Delivery and
Finance drive
. Ensures Year-end Tax Filing is performed timely and accurately
. Provides assistance to Assistant Payroll Delivery Manager and Payroll
Delivery Manager, including any ad-hoc duties required
> September 2012 to December 2013 IBM Global Process Services
Eastwood, Libis
Project Manager (UK Payroll Account - 1st Line Operation
Manager)
. Accountable for planning, prioritizing and executing Payroll projects
by working with all applicable parties
. Develop required project documentation identifying project goals and
tasks and generating assignments consistent to meet objectives
. Establish change management procedures, including evaluation and
communication for project duration.
. Develop reporting strategy for project
. Maintain clear communication with all parties regarding mutual
expectations
. Build business relationships beyond the project environment
. Provide feedback and focus to all team members
. Responsible for projects and actively execute to project plan while
maintaining quality standards
. Ensure that all commitments are met in accordance with project
goals/objectives
. Manage change, formulate action plans, mitigate risk to minimize
delays
. Actively take advantage of change opportunities and recommend new or
revised strategies for project integration
. Evaluate and communicate final project status
. Actively identify efficiencies for future implementations
. Actively use project methods, processes and tools
. Drive the use of project document control and management
. Serve as Payroll lead on various internal projects
. Lead Payroll Process improvement efforts
. Coordinate with other internal HR functions throughout the UK
. Review of Payroll cases for process/communication enhancements
. Work with all levels of management as required.
> August 2011 to August 2012 Megawide Construction Corp. San
Juan
Payroll Officer
. Uploading of Head Office attendance (biometrics) to payroll system
. Checking and validating of the uploaded text file from the biometrics
(whether if there's blank time in or out for that cut-off)
. Encoding of Leave filed with the employees (VL & SL).
. Generate the payroll for the encoded and uploaded attendance in
payroll system (simply by clicking the generate button in payroll
system)
. Checking and validating the errors encountered by the payroll system
(Usually the errors that the system reported is: there is a time in
but there is no time out; there is a time out but there is no time in;
there is an overtime time in but there is no overtime time out; there
is an overtime time out but there is no overtime time in)
. After checking, validating and editing of the said errors generated by
the system they will re-generate the payroll system and check it again
until such time that the system has no errors.
. Encoding of Deductions such as SSS Loan, HDMF Loan, Personal loan,
Emergency loan, AUB Loan, Cash Advance, SSS Condonation etc.
. Encoding of adjustment such as salary increase or adjustment.
. After encoding of these deductions and adjustment they will now click
the bank advice button to compute the salary of the various employees'
salary.
. Generate the bank advice report in the payroll system
. Check and validate the bank advice report that the system generated
. Summarize the bank advice report such as:
- Employees (with atm's)
- For Check Preparation (no atm)
- Hold salary (resigned and awol)
. Printing of bank advice report (to be signed by the signatories)
. Uploading the summarized bank advice report into the parsomatic
systems of Metrobank
. Prepares the payroll analysis report
. Save the uploaded payroll text file into diskette
. Submit the signed bank advice report and diskette to Metrobank (Pasay
Libertad Branch)
. Computing of 13th Month Pay
. Computing of Leave Convertion (SL - 100% and VL - 50%)
. Computing Final Pay of resigned employees
. Prepares the Annual Alphalist (per year)
> September 2005 - July 2011 Asia Select, Inc Makati
City
Senior Associate, Payroll / Billing & Collection
. Timekeeping
o Counts/Time keeps daily man hour's as stated on daily time
records (DTR).
o Prepares man hours summary report per client to be forwarded to
accounting for payroll processing.
. Payroll
o Encodes time keep man hours on the payroll system based on
client assignment.
o Checks the accuracy of man hours encoded per employee vs. time
keep stated on employee's DTR.
. BDO ATD and Payroll Proof List
o Monitors BDO ATD and payroll proof list for signature.
o Send to BDO- cash card payroll thru e-mail.
o Fax to BDO- cash card payroll proof list.
o Confirms from BDO cash card payroll of receipt of e-mail and
fax.
. Billing Documentation
o Checks accuracy of billing summary and details.
o Prepares complete attachment of sales invoice such as original
DTR and billing summary.
o Monitors 100% billing of clients every pay day.
. Sales Invoice Transmittal.
o Prepares transmittal report to monitor complete sales invoice.
o Monitors transmittal of sales invoice to client.
. DTR and Sales Invoice Filing
o Records date of receipt on Aging Summary
o Files Sales Invoice
. Collection
o Conducts telephone collection of due accounts
o Conducts telephone follow-up on the status of sales invoice
. Preparation of Request for Payment
o Prepares request for payment of various expenses
o Monitors request for payment made
> 2002 - 2005 Pagent Duralco Products, Inc. Ortigas
Systems Administrator
. Together with project leader, review and analyze encountered
problem with the system.
. Investigate and prepare possible solutions.
. If problem persist, propose implementation plan and schedule to
principal for presentation & discussion.
. Check if principal have executed proper solutions to encountered
problems.
. Constant communication with principal regarding the implemented
program and report inconsistencies.
> 2001 - 2002 Alexander Resources Inc. Makati City
Technical Support Specialist
HARDWARE (PC, PRINTER, SCANNER, TAPE DRIVE AND MODEM)
. Installing, Troubleshooting and maintenance of PC's.
. Provide help desk support to end users through desktop
applications training.
. Server and workstations installation and troubleshooting.
. Manage project implementation, install and configure PC
servers/workstation.
. Evaluate, test and outsource new hardware products.
. Ensure that all facilities or equipment is functional.
. Daily backuping of our system (APIS, BOSE, BILLING and BUSINESS
WORK)
SOFTWARE (MSOFFICE '97 & 2000, MS OUTLOOK, MICROSOFT WINDOWS NT 4.0,
MICROSOFTWINDOWS '95, '98, '00, NORTON ANTI VIRUS, ETC.)
. Installing Software (any kind of Softwares)
. Install additional workstations to present LAN setup required,
configuring.
. Assists end-users in solving problems regarding software.
. Downloading and updating of Anti-Virus (daily).
NETWORKING (WINDOWS NT 4.0)
. Installation of windows NT 4.0 mapping and granting of access
rights to users.
. Windows NT configuration, implementation, structure cabling,
maintaining, and troubleshooting.
. Handles network maintenance.
. Checking of network per PC using the MS DOS application.
. Checking of email connection with Pacific Internet.
BOSE (Business Operating System for Enterprise)
. Together with project leader, review and analyze
encountered problem with the system.
. Investigate and prepare possible solutions.
. If problem persist, propose implementation plan and
schedule to principal for presentation & discussion.
. Check if principal have executed proper solutions to
encountered problems.
. Constant communication with principal regarding the
implemented program and report inconsistencies.
> 2000 - 2001 Negros Navigation Co., Inc.
Pier
Passage Analyst
. Issuing Passage Tickets.
. Generating of Passages Collection Report and accounting summary.
. Updating the daily and monthly Pax Volume and Cpass report.
> 1999 - 2000 Monterey Foods Corporation (San Miguel Corp.)
Navotas
Planning Coordinator
. Updating my daily inventory based on our daily withdrawal /
issuance.
. Good Receipts (Sale's Invoice's & Delivery Receipts).
. Confirming our daily Franchising Mixes (confirmatory coming from
Quality Control).
. Preparing a purchase requisition based on our critical stocks.
. Updating our daily issuance to S.A.P. System.
. Inputting/Encoding of Purchase Requisition to S.A.P. System.
> 1998 - 1999 San Miguel Foods Inc. (San Miguel Corp.)
Makati City
Accounts Receivable Processor II
. Monitors payments and insures correctness and completeness of
data needed for proper encoding of payments.
. Monitors payments thru returned crates and offset such to the
proper invoices.
. Prepares necessary credit/debit memos requested and double
checks its correctness and completeness.
. Coordinate with sales group for any additional requirements of
correctness for the proper recording of A/R sales as well as
payments, credit/debit memos and such.
> 1997 - 1998 San Miguel Campo Carne Corp. (San Miguel Corp.)
Pasig
Accounts Receivable Processor I
. Monitors payments and insures correctness and completeness of
data needed for proper encoding of payments.
. Monitors payments thru returned crates and offset such to the
proper invoices.
. Prepares necessary credit/debit memos requested and double
checks its correctness and completeness.
. Coordinate with sales group for any additional requirements of
correctness for the proper recording of A/R sales as well as
payments, credit/debit memos and such.
Interpersonal Traits and Skills
. Highly dynamic and result oriented.
. Highly systematic and organized with keen eye for detail.
. Highly responsible and steadfast even under tight schedules and
deadlines.
. Computer literacy: Microsoft Office Applications (Word, Excel)
Internet
References:
Available upon request.
[pic]