Advantage Sales & Marketing
Engineering work for the largest U.S. consumer packaged goods retail merchandising agency, supporting operations across more than 1,200 clients.
Developed a reusable C# middle-tier framework with strongly typed configuration, LINQ-based ADP employee data access, and domain objects encapsulating entity data and business behavior. Centralizing these components in one assembly made updates easy to propagate across applications.
Created automated processes integrating ASM's PTS database with Comdata to request employee credit cards, update spending limits, and change card status in cases of fraud, theft, or loss.
Partnered with database administrators to test and deploy standardized SSIS packages for prepaid card processing, configure environment-specific variables in SQL Server, troubleshoot production workflows, and coordinate file shares and scheduled FTP exchanges with Comdata.
Authored a comprehensive SSIS testing strategy with functional objectives, techniques, completion criteria, and special considerations that satisfied ASM change-management requirements and SOX compliance.
Created a SharePoint wiki documenting the shared class library with UML class and sequence diagrams, generated API documentation, sample code, and unit-test coverage guidance.
Technology stack