Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.
Job description
Description The Asset & Partner Management professional will be responsible for overseeing the end‑to‑end lifecycle of IT assets across the USGI Legal Entity. Working within the Infrastructure & Solutions department, you will maintain a reliable asset inventory, coordinate with internal partners and external vendors, and provide actionable insights through reporting and analysis. This role ensures assets are tracked, compliant, and aligned with business objectives while supporting continuous improvement of asset management processes.
Responsibilities
Maintain a centralized IT asset inventory database and ensure data accuracy.
Track asset movements, assignments, upgrades, and disposals on a daily basis.
Coordinate with internal partners and external vendors for procurement, support, and contract compliance.
Conduct regular physical audits and reconcile discrepancies with the system of record.
Generate and distribute reports on asset utilization, cost, and compliance metrics.
Manage the full asset lifecycle, including onboarding, upgrades, and decommissioning.
Ensure adherence to corporate policies, security standards, and regulatory requirements.
Support the IT service desk with asset‑related inquiries and issue resolution.
Develop, document, and continuously improve asset management procedures and workflows.
Provide training and guidance to staff on asset tracking tools and best practices.
Qualifications
Bachelor’s degree in Information Technology, Business, or a related field.
Minimum 3 years of experience in IT asset management or a similar role.
Strong knowledge of asset lifecycle processes and industry best practices.
Proficiency with CMDB/ITSM tools such as ServiceNow or Remedy.
Advanced Excel and SQL reporting skills.
Detail‑oriented with strong analytical and problem‑solving abilities.
Excellent communication and stakeholder management skills.
Ability to work independently and collaboratively in cross‑functional teams.
Understanding of procurement, vendor management, and contract administration.
This guide is for freshers and experienced professionals in India preparing for the Excel round of MIS executive, accounts, operations, back-office and data analyst interviews, where a practical Excel test is common. It has 60 questions with answers in three levels: the basics every fresher must know (references, VLOOKUP, IF, SUMIFS, text and date functions, pivot tables), real work problems for 1-4 years of experience (lookup errors, dynamic arrays, slicers, Goal Seek), and senior topics such as Power Query, the Data Model, large-file performance and building a monthly MIS report. Sample data and formulas are shown as small tables with their results. Rebuild each example in Excel (Microsoft 365) as you read, then take the mock test.
Questions you may be asked
What is the difference between relative, absolute and mixed cell references?
How does VLOOKUP work, and why do you usually set its last argument to FALSE?