Marketing Automation, Database Administration

ERIK JOHNSON

**** *** ****** ** • Holladay, UT **121

801-***-**** • ***********@*******.***

PROFESSIONAL PROFILE

Twenty years of experience in network and database administration, digital marketing, data analysis and reporting. Skilled with various Customer Relationship Management and Marketing Automation platforms. Significant experience working with small or start-up companies looking to automate and streamline office workflow. Trained and mentored several people to help them achieve success in various technology fields. Seeking an opportunity to work as part of a team in a challenging role using my proven abilities and expertise.

TECHNICAL SKILLS

• Networking: LAN, WAN, VPN, Telecom, VoIP, Routers, Firewalls, DNS, DHCP

• Servers: Windows Server (2003, 2008, 2012), MS Exchange, IIS, MS SQL, MySQL

• Programming: HTML, SQL, App/Code Generators

• CRM: SugarCRM, Infusionsoft, Mindfire Studio

• Call Center: Oracle (Telephony@Work), Noble Systems, Five-9

• Applications: MS Office Suite (Excel, Word, Access, Outlook), SQL Server Management Studio, MySQL Workbench, Adobe Acrobat, MS Power BI

• Other: Microsoft Windows, Database Management, Remote Access, Cloud / SaaS Application Deployment, System Design

EXPERIENCE

Turnkey Direct Marketing Salt Lake City, UT 2013 - 2017 Automation Programmer / Database Administrator

Responsible for the setup, deployment, testing and tracking of automated marketing campaigns. Maintained several databases and API integration with clients. Performed segmentation analysis and reporting. Collaborated with in-house and client marketing teams to maximize efficiency and results of digital marketing strategies.

Highlighted Accomplishments:

• Converted manual email and SMS deployment to Mindfire Studio automated marketing platform. Implemented a custom API for data flow between client databases, in-house databases and the hosted Mindfire Studio platform.

• Developed a suite of custom reporting including automation to pull the data from various sources and generate the reports. Results were utilized for campaign testing which led to a measurable increase in campaign performance and success.

• Wrote scripts and macros for Microsoft Office enabling colleagues to dramatically improve speed and accuracy of routines they previously ran manually. DLG Legal Sandy, UT 2010 - 2013

Network / Systems Administrator

Managed file servers, database and web servers at an independent management and marketing firm serving law practices and administrative staff. Consulted with representatives of various law firms to understand their client tracking and billing needs and implemented those needs to improve productivity. Highlighted Accomplishments:

• Created a custom CRM using a .NET app generator and Visual Studio. Implemented lead and client management, document generation, time tracking and billing in the CRM.

• Setup network file server, groupware and intranet for access from all remote offices. ePlanet Communications Provo, UT 2006 - 2009

Network / Database Administrator

Responsible for the complete setup and administration of computer network and VoIP phone system for call center starting with 20 stations and growing to 64 plus several work-from-home agents. Highlighted Accomplishments:

• Collaborated with owners of the company to select and install multimedia IP-based contact center technology.

• Programmed and maintained inbound, outbound, predictive, chat and email campaigns.

• Managed back-end databases maintaining data integrity, replication, load-balancing and backups. EDUCATION

Weber State University – General Studies

University of Utah – General Studies

Microsoft Certified Professional

Contact this candidate