Badges
Certifications
Work Experience
Senior Software Engineer
Education Networks of America• October 2021 - Present
Software Engineer
LifeStorage• July 2017 - October 2021
RESPONSIBILITIES: •Learning ColdFusion, and GoLang to help support the current web infrastructure and convert to a new web infrastructure •Help maintain intranet and external websites through back-end development in SQL, ColdFusion, Go, and JavaScript •Created web-based CRM for internal team using ColdFusion, BootStrap, jQuery, MS SQL Server, ajax, CSS •Enhanced end-user experience to external website by properly finding and applying indexes, creating stored procedures and using SQL third-party tuning apps to find what needs the most assistance. •Leveraged Idera tools, including SQL Diagnostic Manager, SQL Doctor, SQL Check, SQL EEvent Profiler, SQL Page Viewer, SQL Update Statistics, and SQL Query Store Optimizer, to help update processes and scripts running on SQL Server •Created monthly update for IP to Location translation to accurately pinpoint users geographical location based on their IP address •Implemented a box-stacking function within SQL to upgrade website and increase efficiency regarding users requesting how many boxes, cases or bottles of wine will fit in a storage space. •Designed a User-Interface for a department to be able to draft all invoices for all customers in a single click, and then be able to manage, update, delete, and send the invoices after review. Leveraged MS SQL Server, Stored Procedures and ColdFusion for this process. •Optimized the external website's Site Search feature, de-associating with the Google site search API that was previously used by many sites and is currently not supported by Google, using Nutch and Solr, thus providing end-users quick and relevant results that would be ranked appropriately. •Created internal intranet only user-interface to connect and update the external FAQ section on the external website. •Utilized'Full-text' indexing and adjusted the search feature so users searching for a question or answer, internally or externally, could get an appropriate and ranked result based on it
Software Engineer
Sumitomo Rubber USA• February 2015 - July 2017
RESPONSIBILITIES: •Updated and upgraded Overtime Excel based program for several departments. •Installed and standardized a version control system using SubversionEdge as a central server and assisted clients using TortoiseSVN and AnkhSVN to connect to the central SVN repository and server •Enhanced intranet page to be standard across all areas while adding functionality. •Created web reporting, structure, framework and pages for the local plant using PHP and jQuery. •Updated all internal websites from PHP 5.1 to PHP 7.1 and maintained security updates, patches and additional features •Migrated applications on all web-based servers from older OS to newer OS, one domain to another, one set of IPs to another and an Active Directory sets •Implemented universal XML download button on all of the external vendor websites that are hosted internally to help with product ordering while assuring quality and fast response. •Converted and coded an old call-off system and process to a new web based application with security and leveraging Oracle as the back-end database •Created a simple web-based user self-service password reset utility for all associates in the plant to utilize, reducing helpdesk calls •Administrator, designer and custom content creator for the Samsung MagicInfo TV's displaying important information and plant metrics •Built Emergency Response Team In/Out display based on key-card access •Built Web Applications in house and created a standard to template to replace old existing Excel and Access applications •Created web based tool and storage for data for the Specifications System for Curing, giving ability to customize layouts, content and more, and included barcodes that work with our system •Administered, Installed, Setup and oversaw all the MS SQL Servers •Created 3 SSRS Servers and successfully built and implemented several reports •Built a tool to help measure scrap and waste by specific details •Created interfaces in SSIS and VBScript to move data
Software Engineer
M&T Bank• July 2013 - July 2015
RESPONSIBILITIES: •Used SSIS, SSRS, MS Excel, MS Access, MS SQL Server, MS SharePoint, T-SQL, SQL and MS Outlook Daily for running reports and delivering them. •Created, maintained and designed SharePoint portal for requests coming into the Strategic •Solutions team using SharePoint Designer, •SharePoint built-in design tools, jQuery, JavaScript, CSS, HTML and Workflows. •Integrated SharePoint request portal with other processes including a Project Tracker and a Task Tracker, connecting three different functions for requests. •Programed VBScript automation to gather Western Union Speedpay reports and data and upload to SQL Server, which later was changed to VB .NET and C# .NET automation in a scheduled SSIS package. •Upgraded over 50 reports generated via MS Access Database Macros to automated SSIS processes or Stored Procedures embedded in an Excel Document, including an LOB daily summary report. •Specialized in VB, .NET, VBA, JavaScript, SQL, ASP, PHP and C# through NetBeans, Eclipse and MS Visual Studio. ACHIEVEMENTS: •Recreated various reports generated by other departments within our own department to give more granular and loan level details about the summary given. •Lead the TCPA project for reporting while maintaining all the codes on the system and generating gap reporting for manual work that helped decrease deficiencies while highlighting milestones and achievements by the various units. •Produced and designed reporting and automation for CFPB readiness and compliance to help maintain audit amenability while also identifying other gaps and inconsistencies that exist. •Automated 250+ daily reports using SSIS and over 30 monthly reports for over 50,000 generated reports in 1 year. •Created a calendar database for the company that is used for Business Day Calculations and more, as well as a VBScript that will regenerate the database in any desired location, and a zip code database with a SQL script to calculate the distance to other zip codes.
Software Engineer
Bank of America• November 2006 - June 2013
RESPONSIBILITIES: •Used SSIS, SSRS, MS Excel, MS Access, MS SQL Server, Teradata, AS400, iSeries, MS Sharepoint, DBVisualizer, Toad, T-SQL, SQL and MS Outlook Daily for running reports and delivering them. •Managed Projects, maps, and workflows using MS Visio, TFS, MS Project, MS Powerpoint to deliver monthly projects. •Managed as an administrator several SQL Servers and their containing databases. •Utilized SQL Server Studio with SSIS, TFS, SSRS, Toad and Teradata to run daily functions. •Created many various UI using UX designs with VB, VBA, VB.NET, MS Access, SQL, C#, ASP, ASP.NET, jQuery, Javascript, MS Sharepoint Designer and others to create, design and maintain interfaces for deliverables. •Specialized in VB, .NET, VBA, Javascript, SQL, ASP, PHP and C# through Netbeans, Eclipse and MS Visual Studio. ACHIEVEMENTS: •Instituted and continued over 98% on every FHLMC Quarterly Mod Reconciliation audit finding, an increase from previous audit findings of 4%. •Created, designed and maintained system (Database, UI, SharePoint, Wiki, SSIS automation and reports) for FNMA Hard Reject reconciliation efforts. •Originated and coordinated new system for FHLMC Inventory Tracking including database administration, web reports, GUI, SSRS and SSIS. •Completed FHLMC LMTW HAMP 15,000+ file backlog in 30 days and implemented automation going forward for all FHLMC LMTW remediation processes. •Initiated forbearance, forgiveness and miscellaneous fee remediation process streamlining over 60,000 transactions being validated monthly and generating a report within 2 business days.
Education
University of Phoenix
Computer Science, BS• January 2013 - June 2017
BS - Database Management & Software Development AA - Database Management Certificates - Data Modeling/Warehousing, Database Administration, Advanced Software Development, Mobile Application Development