Hardware Asset Management Officer

Your Role

Key Responsibilities
A. IT Asset Lifecycle Management
•    Maintain accurate inventory records for laptops, desktops, monitors, peripherals, and other IT equipment.
•    Track procurement, receipt, allocation, transfer, repair, replacement, recovery, disposal, and retirement.
•    Record ownership, employee assignment, location, serial numbers, warranty details, and asset movements.
•    Coordinate physical inventory validation with onsite IT teams and monitor aging assets and refresh needs.
B. Asset Inventory and Reconciliation
•    Reconcile physical stock, asset management databases, and employee allocation records.
•    Investigate missing assets, duplicates, incomplete information, and mismatched records.
•    Support periodic audits and verify returned, transferred, and disposed assets with appropriate audit trails.
C. Advanced Excel Reporting and Data Analysis
•    Maintain Excel-based inventory trackers, reconciliation reports, and management dashboards.
•    Analyze large datasets to identify discrepancies, trends, risks, and improvement opportunities.
•    Produce weekly and monthly reports on inventory accuracy, allocation, recovery, aging, and disposal.
•    Automate repetitive reports and consolidate data from multiple sources.
D. Asset Recovery and Employee Offboarding
•    Track assets assigned to separating employees and coordinate timely recovery with HR, IT, Finance, and business teams.
•    Maintain records of unreturned, lost, missing, and damaged assets; produce aging reports and escalate overdue cases.
•    Support accountability and potential chargeback documentation; inspect and record returned equipment.
E. Reporting, Governance, and Compliance
•    Prepare management reporting and monitor agreed asset KPIs and outstanding discrepancies.
•    Follow Capgemini asset management policies, security controls, and documentation requirements.
•    Support internal/external audits, disposal approvals, and continuous process improvements.
F. Stakeholder Coordination
•    Collaborate with GOSS, HR, Finance, Procurement, and business representatives across Philippine locations.
•    Provide accurate asset information to regional IT leadership and follow through on outstanding actions.

Your Profile

Qualifications and Experience
•    Bachelor’s degree in IT, Computer Science, Business Administration, Accounting, MIS, or related field.
•    At least 2–3 years of experience in IT asset management, inventory control, IT operations, or data reporting.
•    Experience with large inventory databases, hardware lifecycle management, and asset reconciliation.
•    Familiarity with ServiceNow, ManageEngine, or similar ITSM/asset systems; multinational or shared-services experience preferred.

Mandatory Advanced Excel Skills
•    XLOOKUP, VLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IF/IFS, IFERROR, and nested formulas.
•    PivotTables, PivotCharts, slicers, advanced filters, conditional formatting, data validation, and duplicate detection.
•    Power Query for cleaning, transforming, and combining data from multiple sources.
•    Interactive KPI dashboards, large-dataset reconciliation, and reporting automation.
•    Power Pivot, VBA macros, Power BI, and related automation are advantageous.