IT professional with 20+ years’ experience in technical application support with fortune 500 IT outsourcing companies. Supported Helpdesk, Asset Management, and Financial systems. A strong emphasis on understanding and managing the data. Used my programming abilities to create tools that automated my work and increased my accuracy and efficiency.
Creative Problem Solving | Excellent Communication | Data Collection & Entry | SQL Queries | Data Analysis & Manipulation | Scripting using Python, VB, T - SQL| Software Deployment | Asset Inventory | Helpdesk Application Support | Remedy
Python, NodeJS, MS Access programming, Excel, MS Office automation, Visual Basic, SQL Server 2012, T-SQL, Relational Databases
Data Analyst/ SQL Developer
Gathered data from MySQL, SQL Server 2016, Google Big Query, and from Excel Spreadsheets.
Modeled new data requirement by creating new tables and the relationships between them.
Used web scraping to gather data.
Created a NodeJS application to download data from an API.
Confidential, Austin, TX
Used the Python programming language to create a script that used as input a csv file of load data and output a sql script that loaded this data into a temporary table on the production database. That way joins could be done between the load data and production data and updates could be accurately check as soon as they were completed, instead of spot checking a few values.
Worked tickets from users. These ranged from “can’t log onto the system” to “can log on but not seeing the data I normally see”.
Confidential, Fort Worth, TX
Global Outsourcing Support
Supported the helpdesk by validating data and loading it into the system. Transitioned the data from CA Unicenter helpdesk to BMC Remedy helpdesk. I used MS Access and Visual Basic programming to create a windows based program that validated new data loads and created a load file. This program was shared with my colleagues on the data team (6 of them) and improved our efficiency and accuracy.
Involved in rolling out the new Asset Management System (AMS) created by CSC. There were many issues with the new system. I determined that the data was not loaded into it correctly. I revised our data gathering methods and data validation, which greatly improved the accuracy of the system. For this I was promoted to Technical Staff A and given an 11% raise in pay. I became the data expert for the system.
Installed the AMS client side software at client sites. Had to learn about ip addresses and DHCP, and be able to trouble shoot problems when it would not load.
Helped run wall to wall inventories of IT assets when a new client was acquired by CSC. Trained people how to gather the data, validated the data gathered and loaded it into the database.
Created a software package for validating data at the NSA account. Since I did not have security clearance, had to create the software and train an NSA employee to use it.
Wrote PL/SQL script to extract data from the Oracle database used for asset management.
Did the coding for an interface between our MSA software Purchase Order system and a PeopleSoft system.