Ervin Santiago

Working on application which will allow accounting department to generate and auto import cost files into our collections system. Also generates reports based on said files.

Migrated production databases from SQL Server 2008R2 to a SQL Server 2014 Cluster environment. Process involved the backing up and restoring production databases to new cluster server. Prep work was done where production databases that were mirrored had their mirror broken and reestablished between SQL Server 2008 and the new SQL Server 2014 cluster. This allowed for a savings of 14 hours during the go live phase of the project. Backed up and restored all non mirrored databases using t-SQL… Show more

Migrated production databases from SQL Server 2008R2 to a SQL Server 2014 Cluster environment. Process involved the backing up and restoring production databases to new cluster server. Prep work was done where production databases that were mirrored had their mirror broken and reestablished between SQL Server 2008 and the new SQL Server 2014 cluster. This allowed for a savings of 14 hours during the go live phase of the project. Backed up and restored all non mirrored databases using t-SQL scripts, restored to new server using t-SQL Scripts. Also setup mirroring between the new SQL Server 2014 Cluster and new SQL Server 2014 mirror server. Show less

Created program using VB to take a single column text file from the JEFIS court filing and parses out the data into an importable excel file.

Using VBA created form within Excel which allows end users to select varios fields from SQL database and returns results based on selections and, if file number provided, run query returning selected fields for file numbers provided. Can search multiple tables depending on what information they are looking for.

VBA program which uses SQL backend to pull court filling costs based on file number. Users had to manually check for costs based on file number and zip code and look online or in legal diary for costs.

Utilizing our CRM's ODBC connections I created a program, initially using VBA then migrated to VB, that would pull data from the software and write to tab delimited text file. I created a SQL SSIS package that would see the files that were generated and based on the file name know which table in the database to insert the data into. This is used to refresh data nightly and during intervals throughout the day for reporting and automation purposes. The VB program pulls the data directly into… Show more

Utilizing our CRM's ODBC connections I created a program, initially using VBA then migrated to VB, that would pull data from the software and write to tab delimited text file. I created a SQL SSIS package that would see the files that were generated and based on the file name know which table in the database to insert the data into. This is used to refresh data nightly and during intervals throughout the day for reporting and automation purposes. The VB program pulls the data directly into the SQL database. Show less