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.