James Davis Email & Phone Number

Huntsville, Alabama, United States

Streamlined data collection project, improving data storage for enhanced reporting, directly aligning with the organization's need for superior data management.Initiated and implemented a database maintenance plan, ensuring the smooth functioning of the data for all the needs of the teamDesigned and executed a source control system for schema and dataUndertook data cleansing for a database with full and partial duplicates, enhancing data quality for optimal use.Designed an ETL/ELT project, transitioning data from OLTP schema to OLAP, involving extensive data cleaning, value conversion, and third-party application use for predicting missing values.

Huntsville, Alabama Area

Speed up Budget Planning with a concise Dashboard.Enabled Labor Utilization Monitoring with several Data Visualization.Created an insightful Dashboard into Deliveries in addition to the one requested.ETL to update Active Directory info with HR data.Created C# program to more efficiently download a large file off FTP, replaced SSIS.Azure Usage Monitor Dashboard, also the C# program to get the data via the Azure APIFixed & maintained existing SSIS packages. Replace SSIS with C# or SQL Procedures for better performance Created several DLLs to consolidate code for reuse in many solutions.Work with software and service vendors to get our data integrated into their platform.Improved the efficiency of the main data source restore and load process. Added several endpoints to our internal Web Service for data retrieval, update and delete.Performed all the normal DBA tasks (back ups, restores, index tuning, permissioning, and more).I also create and maintain SSIS packages to pull from various sources into our database for use in reporting. I set up our Redgate SQL Monitor. I also have SQL server DBA responsibilities. Improved many of our daily jobs to run more reliably and faster.

Huntsville, Alabama Area

Huntsville, Alabama Area

Rewrote a daily process using T-SQL and SSIS, this process involved reward points that could be converted to a monetary value. Fixed the expiring of old points. Wrote a C# application to move web site data from a PostgreSQL to MS SQL Database. Used Multi-threading to speed up the process. Found need for a lot of features not in the original requirements and implemented them.Worked with other data importers that read the database of a Forum and moved them to a MS SQL Database from a MySQL Database.Maintained a Forum scrapping program, upgraded it from 2010 Visual Studio to 2013 Visual Studio.

Greater New Orleans Area

The Timsweb Project was part of the government paperless initiative. Oracle ADF was used to create a way for the paper forms to be filled out and submitted electronically. Also used PL/SQL to write a procedure to copy customer data from the live Database instance to the editing instance so customers could change their data and have it reviewed by the government then once approved another PL/SQL procedure updated the live database (updates, inserts, soft deletes).This Link goes to a detailed description of the site I worked on http://www.boem.gov/uploadedFiles/BOEM/Oil_and_Gas_Energy_Program/Leasing/TIMS_Web/TIMS_Web_Getting_Started_Industry_User_Guide.pdf

Decatur, Alabama Area

Contract work with Nucor Steel, Decatur AL.* Used the WonderWare IDE to make a Human Machine Interface to control the mill processes. * Created Active X Controls that could graph real time data from mill equipment. * Designed and implemented a Windows Service withe a heartbeat algorithm.* Wrote a C# application that replaced and improved performance on a process to modify orders right before the manufacturing of that order began, 30X improvement, saving the mill calculated amounts in wasted product.* Developed a web application for inventory and maintenance control for part of the mill equipment. This was part of a cost savings program to see what manufacture's part lasted the longest and performed the best.

Huntsville, Alabama Area

Maintain Email, purchase new computers, maintain daily back ups.

Combat and non-combat duties.Also worked as a Fire Support Specialist.