Philip Frederick

Experience

• 

  Total Quality Logistics

  May 2013 - Oct 2013

  Sales Recruiter
• 

  Lebanon Public Library

  Oct 2013 - Sept 2014

  Technology Assistant
• 

  Schaeffer's Investment Research

  Sept 2014 - Oct 2017

  - Responsible for the development of email marketing segmentation using T-SQL and SSIS.- Develops SQL code to create solutions for streamlining otherwise tedious processes.- Gathers requirements for new SQL reports and supported the development of SSRS reports.- Trains end users on the use of Microsoft Dynamics CRM and other enterprise applications.- Facilitated a user advisory board focused on Dynamics CRM improvement.- Creates custom CRM workflows and dialogs to streamline or automate business processes.- Supports end user issues and difficulties with Dynamics CRM.- Leads data integration tasks utilizing Scribe Insight and SSIS.- Self-studied to earn the Microsoft MB2-704 certification in Microsoft Dynamics CRM. Show less - Responsible for overseeing the creation and completion of email marketing campaigns.- Marked up over 3,000 emails in HTML and CSS.- Automated the development of marketing emails utilizing VBA Macros for Microsoft Word.- Eliminated redundant tasks in email development process, leading to greater efficiency.- Increased marketing email sends by 25% from 2014 to 2015.- Grew average daily click sales by 17% from 2014 to 2015 as a result of increased email sends.- Developed relationships with third party clients and handled their email marketing needs. Show less

  • CRM Administrator

    Aug 2016 - Oct 2017

  • Email Operations Specialist

    Sept 2014 - Aug 2016
• 

  TrellisPoint

  Nov 2017 - now

  - Manages the TrellisPoint technical support department- Handles elevated support requests- Ensures technical support cases are completed promptly- Coordinates resources and assigns support tickets appropriately - Develops complex applications using the Dynamics 365 platform.- Utilizes a broad range of tools to manage customer needs, including entity customization, SQL Server integration, and client-side JavaScript.- Deep exposure to a variety of data integration methods with D365, including Scribe Insight, Kingsway Soft, and CozyRoc SSIS.- Hands on experience with migrating data between systems effeciently and successfully.

  • Director of Support Services

    Feb 2025 - now

  • Client Support Manager

    Jul 2021 - Feb 2025

  • Technical Consultant

    Nov 2017 - Jul 2021