Hardware Asset Management Officer
About the role
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.