IT Assets and License Manager at Mercedes-Benz Research & Development North America Inc. (2016-03 – Present)
Responsible for defining, implementing, and maintaining a system solution with support of IT operations to ensure asset documentation and lifecycle management of all IT equipment (laptop, server, licenses, network, security, printers, and storage). Define, implement and maintain license management services for all MBRDNA SW. This includes a process/application to track the procurement, deployment, usage, maintenance contract information, transfer and decommissioning of all SW licenses.
- Ensure reporting methods and implementation of reporting for SW licenses (survey, dashboards)
- Coordinate with IT Operations the implementation of HW/SW deployment/transfer/decommissioning
Business Intelligence Reporting Analyst at Insight Global (2015-08 – 2016-02)
Business Area Owner – Network Operations at Quicken Loans (In-House Realty)
- Interacted with Business leaders to determine current and future reporting needs
- Provided Excel based statistical analysis and Dashboards
- Ad hoc SQL Reporting
ITO Svc Delivery Cons III at Hewlett-Packard (2012-08 – 2015-09)
EUC Asset Management Tower Lead. Clients: BCBS, Convatec, Eli Lily, Bristol-Myers Squibb and Symantec
- Motivate, Manage, Train, Mentor on/off shore support staff
- Monitor All Daily Activities
- Metrics Dashboard Development/Maintenance
- Develop/Maintain Multi Source comparison tools for Invoicing, Exception Reporting
- Assisted in mapping the requirements to the source systems, the data warehouse and applicable data marts
- Work on SQL queries to extract the data required for data validation
- Analyzed and developed large quantities of data in SQL to manipulate modify and debug various tables for reporting services
- Developed high level process flows and specifications for internal and external systems involving Remedy, ServiceNow, Altiris and SQL Server databases
- Performed defect tracking using HP Quality Center, casual analysis of defects and provided feedback to the developers
- Assist in Remedy to ServiceNow migration Project
- Facilitated Weekly and Monthly management meetings with sponsor, project manager and technical stakeholders for consistent communication
- Interacted with representatives in supplying information, reporting defects, and obtaining information for specifications and implementation of the requirements
- Provided Excel based statistical analysis and creating pivots tables and charts for business reporting and assistance in data driven decision process
Sr. Business Analyst at Hewlett-Packard (2008-04 – 2012-07)
Internal AsM Metric Lead for Americas. Clients: American, United, US, Dollar Thrifty, Continental Airlines and SEA Enterprise
- Oversee Multiple ABM Clients/ Migrate to a Consistent Business Environment
- Worked closely with Data Analysts, Database Administrators and DataStage Developers to develop and implement logical and physical data models in Asset Center, Asset Manager and SQL Server databases
- Wrote SQL statements to extract, read and update data from the tables for back end testing
- Performed data analysis of existing data through SQL and ETL
- Performed Accuracy Analysis
- Performed IMACD Audits and Reconciliation
- Asset Center Reporting and Validation
- Ad hoc Reporting
- Involved in User Acceptance Testing (UAT) and test execution
- Interacted with developers & various members of my team to discuss and resolve defects and their priorities
- International Travel - Successfully migrated Jr. and Sr. Analyst roles to Wuhan, China
SME Asset Management/Quality Assurance at Electronic Data System (2007-09 – 2008-03)
Client: General Motors Corporation. Team Lead.
- SME for GM Asset and Software License Management Business Rules and Requirements
- Project lead for IMACD Process Deployment to China
- Train and supervise new team in China
- Perform IMACD Audits to determine Data Accuracy/ Root Cause Analysis
- Development and execution of new processes and procedures
SRM Asset and SW Coordinator at Kelly Services for Electronic Data System (2003-02 – 2006-07)
Client: General Motors Corporation
- Maintain HW/SW asset information for GMNA DATA Repository
- Maintain HW/SW asset information for OnStar and all other regions in Asset Center
- Mentored and assisted with training of newly hired associates
- Compile and report daily metrics for Asset Data Correction
- Development of an internal Database to mirror Active Directory
- Assisted on SOLA Project
Site Asset Coordinator at Adecco for Electronic Data System (2003-02 – 2003-10)
Client: General Motors Corporation
- Onsite IT Asset Audits and maintain asset repository
- Execute HW Deployment and HW De-Installation
- Perform IDD Scan for installed SW
- Provide asset inventory data to client management through query/report
Manager at Taylor Gas & Go Inc. (1995 – 2003)
- Responsible for Day to Day Operations
- Maintain work procedures
- Assist with training of new employees
- Perform routine inventory
