Carl Setzer

Data Analyst
Web Developer
Systems Analyst
Project Manager


Contents:
- Education/Skills
- Projects
- Experience
- Certifications

Key Skills:
- HTML, CSS, & JavaScript
- Create and manage sites with WordPress
- Data, Database Theory and Design
- Organizing teams and projects

A bit about me:

Quick summary:

Education

Associates In Technical Arts | Edmonds College

Selected coursework:

  • HTML
  • JavaScript & jQuery
  • PHP
  • WordPress, Joomla!, SEO
  • Introduction to Amazon Web Services and Cloud Platforms
  • CSS
  • Application and Cloud Development Tools
  • Introduction to Programming (Visual Basic)
  • Database Theory and Design
  • SQL
  • Systems Analysis
  • Systems Design and Development
  • Project Management
  • Introduction to Graphic Design
  • Intermediate Graphic Design

Certificates:

  • CIW Site Development Associate
  • MTA Windows Operating System Fundamentals
  • MTA Introduction to Programming Using HTML & CSS
  • Business Systems Analysis
  • Requirements Analysis
  • Database Theory & Design
  • Application Specialist Certificate of Completion

Experience

IT Analyst | Edmonds Waterfront Center

March 2023 - Present

  • Managed IT and AV projects with external vendors
  • Managed and tracked IT budget
  • Documenting IT and AV system structure, processes, and procedures
  • Configure and deploy new technology assets
  • Desktop support and troubleshooting technical issues
  • Develop system requirements and write Scopes of Work for non-technical team projects
  • Technical guidance for website.

Technology Coordinator and Administrative Assistant | Trinity Lutheran Church and Schools

April 2022 - Present

  • Coordinate projects with Asana
  • Sound and video tech support for live streaming and in-person events
  • Manage Wix website
  • Coordinate with multiple stakeholders for significant events (funerals, baptisms, etc.)
  • Create flyers and bulletins with Publisher and InDesign
  • Create meeting minutes and reports

Owner | Setzer Digital

April 2011 - Present

Freelance consulting services.

  • Created and managed websites with HTML, CSS, WordPress, Squarespace, Wix, and Webbly
  • Created and edited video for YouTube, Vimeo, etc with Adobe Premier Pro
  • Photographed art for the creation of media assets
  • Created YouTube thumbnails, bulletin graphics, Instagram posts, and other media with Photoshop, Adobe Spark and Canva
  • Setup and managed email/newsletter services, mainly Mailchimp, but also Substack and others
  • Setup and updated the Google Business and Bing Business pages
  • Sound and video tech support for livestreaming and in-person events

Digital Marketing Manager | Steel Realty Group

September 2019 - February 2020

Managed multiple marketing efforts and other projects:

  • Manage digital marketing for an up and coming real estate brokerage
  • Edited marketing images and graphics with Photoshop
  • Created thumbnails for YouTube, Instagram and other sites with PhotoShop
  • Created ad copy and images for Facebook and Google Ads PPC Campaigns
  • Created and managed email campaigns and newsletters with kvCore, real estate specific tools
  • Coordinated ghost-writing of book, as well as publication
  • Researched local housing statistics for combined marketing campaign. Elements included direct mail, geomarketing PPC, with Facebook and Google remarketing
  • Configured and managed online ad accounts with Google, Facebook, and Yelp
  • Setup and updated the Google Business and Bing Business pages

Project Coordinator | Eagle Country Construction

January 2017 - July 2019

  • Managed multiple development projects from initial conceptualization, permit submittal, through preparing construction team for permit issuance
  • Coordinated multiple consultants to develop our project documentation required for several different government agencies
  • Researched potential opportunities, creating an feasibility/ROI analysis and projected budget
  • Created offers and coordinated transactions with agents, sellers, buyers and managing brokers
  • Developed and managed project timelines and budgets in Buildertrend, Project, Excel, and Visio, ensuring timely communications with all stakeholders
  • Tracked and maintained information for multiple sources, both internal and external, ensuring effective dissemination to all affected sources
  • Provided front line IT support for office, including resolving network and desktop issues, new equipment procurement and training staff on new systems. Created and managed company website. Also managed social media accounts
  • Created site plans and edited house plans with AutoCAD
  • Crafted marketing materials with InDesign, Photoshop, and Publisher

Office Manager | C & K Real Estate

July 2011 - December 2016

  • Developed Excel based team dashboard for tracking and reporting of progress towards yearly, quarterly and monthly KPIs, increasing our production volumes by 50%
  • Developed and implemented CRM plans for 800+ database.
  • Verified transaction compliance, coordinated between other real estate agents, escrow agents, mortgage lenders, buyers and sellers to ensure on-time closings
  • Reviewed contracts and offer materials ensuring comliance for bank and government owned property. Verified transaction compliance with state and other requirements
  • Coordinated between other real estate agents, escrow agents, mortgage lenders, buyers and sellers to ensure on-time closings
  • Coordinated acquisition of resources for new hires, managed repair and maintenance
  • Tracked and submitted expense reimbursements with the asset management teams for institutional property owners and internal accounting
  • Managed all IT and technical issues for team, from resolving network issues, troubleshooting PC issues, equipment procurement and setup
  • Created and updated company website, managed social media posts, more than tripling our social media likes and followers

Microsoft | Program Manager, Coordinator and Business Administrator

August 2009 - January 2011

  • Team and project management
  • Established and mapped team rhythms, developed scorecards, reports and communications for team, both internal and external, utilizing Excel, PowerPoint, Sharepoint, and Project for the globally disbursed team
  • Managed logistics for multiple high-profile events and meetings
  • Managed team assets from PCs to space allocation. Coordinated internal moves and new hire equipment and access procurement
  • Monthly financial reporting to team, directors and fiance organization
  • Regular project communications, reporting and interdepartmental coordination
  • Managed office space, supplies, equipment and access to key systems for globally distributed team located throughout multiple global facilities with MSS, HeadTrax, MyOrder and MSExpense
  • Created Opex reporting, produced monthly reclass and accrual reporting, managed expense reports across the team. Created internal reporting with Excel
  • Managed team distribution lists and Sharepoint site access, and headcount in HR tools
  • Managed team office and technology needs

Coordinator | Starbucks

April 2005 - February 2009

  • Worked across the department’s functional groups to maximize collaboration and for effective administrative support. Managed team and executive calendars
  • Developed tools with Excel and Oracle for budget tracking for $12 million budget, collected information from multiple departments and assembled into non-technical reports
  • Collaborated across multiple functional groups to develop briefing materials for executive speaking events (up to and including the CEO and Chairman) and crisis response, received commendation by CEO
  • Direct administrative support VP and Director of Public Affairs including calendaring, meeting and office logistics, correspondence. Also supported the Executive Assistant to the SVP of Global Communications and the greater 30-person department in numerous capacities including calendaring, coordinating travel and expense reporting
  • Monitored company-wide inbound executive speaker requests, creating monthly reporting, and coordinating event logistics for executive team. Creating travel and event briefings for executives from the C-suite on down
  • Crafted executive PowerPoint presentations across the company for multiple speaking events and venues, ensured timely and accurate information. Served as a liaison for external organizations, coordinating executive travel, and onsite logistics
  • Coordinated events, internal and external, including reserving space, managing catering, and arranging presentation equipment
  • As a member of the Annual Meeting core team, coordinated VIP and key guest seating and other logistics. Worked with Diversity team to provide accessibility accommodations to guests as needed, including ASL interpretation and services for Deaf-Blind shareholders
  • Utilized Excel to create and distribute the Global Reputation Recap Report for Senior Leadership Team