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 accelerate 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.