Data Analyst At Ibm
Performed IT asset management services for newly acquired and existing state and federal government accounts. Managed more than 50K workstations, servers, and mainframe devices in accordance with ITAR regulations. Created reports used for tracking ownership, location, warranty, and financial information of assets. • Managed asset lifecycles from procurement to decommission in the CMDB of ServiceNow and the IBM Smart Cloud Control Desk (SCCD) ITSM tool based on ITIL best practices for asset management. • Created reports in Excel, using SQL queries in IBM QMF (SQL Server) and Cognos Analytics to mine the data, that were uploaded to share points and dashboards for use by IBM project offices and customers.• Led project that conducted wall to wall inventories at 56 data centers in U.S., capturing 95% of missing assets, with 80% missing prior to project.• Created ITIL Knowledge management documentation for processes and procedures used to manage assets and configuration items.• Automated process for uploading data into DB2 database by coding Python scripts, utilizing regular expressions to scrape data from MS Word documents.