SAM HASS
Portland, OR ******@*****.*** 503-***-****
Senior Business Systems Analyst Marketing Analyst Sales & Marketing Analyst Database Analyst
15+ years of experience as Systems Analyst with focus in business software and systems. Strong background working with clients, designers, and programmers to identify requirements, provide cost analysis, assist with creating user interfaces, and develop implementation timelines. In-depth understanding of project lifecycle, including all phases of system and software development. Proven track record in testing, quality assurance, and networking. Superior communication, presentation, and interpersonal skills. Experience analyzing, developing, enforcing, maintaining, and updating Information security policies, with customer personal information, as well as financial, product, and operational data.
CORE COMPETENCIES
• Data Governance
• Forecasting
• Master Data Management
• Database Analytics
• Primary Research
• Statistical Modeling
• Reporting Services
• Marketing Test Design
• Qualitative Methodologies
• Quantitative Methodologies
• Policies Training / Management
• Pardot Marketing Automation
• Quality Management
• Business Intelligence Policy
• Project Management
• Strong Interpersonal Skills
• Creative Problem Solving
• Regulatory Requirements
• Regulatory Compliance
• Financial Test Design
• Mentor Ability to Lead
• Professional Demeanor
• Deadline Oriented
• Strong Analytical Skills
• Complex Resolutions
• Internal Collaboration
• Big Data Quality Compliance
• Quality Management
PROFESSIONAL EXPERIENCE
PERSONAL SABBATICAL May 22022 - Current
• Caregiver for family and self through COVID
•Complete Certification as Peer Counselor, State of Oregon
• Online Courses to maintain, build new skills in SQL, Python, and ML/AI
• BSA work for local non-profits
• Other classes and volunteer leadership
MULTNOMAH COUNTY Business System Analyst April 2022-May 2022
• Design new data structures for incoming and outbound data from disparate legal data sources across county
• Work with diverse teams to ensure data is accurately understood, shared, and documented
NIKE Senior Business Systems Analyst, Member Hub and Consumer Data Engineering August 2021-February 2022
• Design new data structures for incoming and outbound data
• Work with diverse teams to ensure data is accurately understood, shared, and documented
• Utilize Visio and other tools to document and communicate data flows and logical processes
COLUMBIA SPORTSWEAR Senior Business Systems Analyst, Data Ingestion August 2019-May 2020
• Address data and drive: system design, documenting, auditing, consulting on big data platforms.
• Re-platform all e-commerce sites, focusing on Loyalty and Account Master Data Management per quality compliance.
• Perform requirements gathering with business stakeholders to ensure change management.
• Translate requirements into scope of work for developers for the goal of new business analysis policies.
• Write documentation for current state and future state highlighting where changes were made.
• Serve as Loyalty and Account Management liaison to the brick and mortar retail side of the business.
• Utilize Visio and other tools to document and communicate data flows and logical processes
NIKE Senior Business Systems Analyst, Data Ingestion August 2018-August 2019
• Designed data quality solutions for sales, operations, planning and machine learning with ERP.
• Use of big data platforms, Amazon Web Services, SQL, and Snowflake to profile and validate data quality.
• Master data responsibility for product dimensional data quality in support of (ED&A) enterprise data quality analytics.
• Utilize Visio and other tools to document and communicate data flows and logical processes
3DEGREES INC. Marketing Analyst May 2016-September 2017
• Designed, executed, and reported on marketing tests data through mail, email, and other channels.
• Designed and developed B2C CRM solution, including managing master customer data and training end users.
• Selected, installed, and executed B2B marketing automation solution.
• Successfully launched new market research product offering, with first year billings over $250k.
• Managed PPC campaigns: 4 different product lines with distinct performance metrics & continuous improvement.
NORM THOMPSON Marketing Database Analyst January 2015-February 2016
• Designed, executed, and reported on marketing campaigns, promotions, and test performance.
• Conducted longitudinal performance analysis on merchandise and promotional producti
• Provided super-user support to Marketing, Finance, and Merchandising functions.
• Utilize Visio and other tools to document and communicate data flows and logical processes
HOLIDAY RETIREMENT Sales & Marketing Analyst April 2012-December 2013
• Developed Sales and Marketing recurring reporting.
• Performed ad hoc analysis requiring consolidation of diverse data quality sets and sources.
• Sales and marketing tool development and campaign training support.
LUCY ACTIVEWEAR Marketing Database Analyst July 2008– November 2011
• Managed all aspects of brand wide CRM strategy, platform, and master marketing data management and governance.
• Drove data quality and completeness goals across a 50+ location retail chain.
• Directly managed outsourced CRM solution vendor.
• Utilize Visio and other tools to document and communicate data flows and logical processes
INTEL Marketing Solutions Data Manager Direct Marketing Operations Database Manager June 2002– June 2008
• Designed solutions integrating CRM, strategic planning, marketing automation, & budgeting with leadership.
• Managed controlled master marketing terminology across multiple marketing solutions and geographies.
• Created tool and process to support change control of marketing terminology.
• Train Corporate, leadership, North & South American teams on use of Marketing Resource Management.
• Sabbatical coverage managing Business and Marketing Development Fund operations.
• Managed response database of 2.2M B2B and B2C records in compliance with privacy regulations.
• Managed lead distribution and sales management material and tools in English and other languages.
• Designed and analyzed end-user and reseller channel marketing programs.
• Integrated direct marketing campaign development and execution.
• Quantitative regulatory metrics analysis and structured database design, providing super-user support.
• Utilize Visio and other tools to document and communicate data flows and logical processes
EDUCATION
University of Oregon MBA-Marketing, Decision Science June 2000-June 2002
Rhodes College BA-International Studies August 1994-June 1994
SOFTWARE & APPLICATIONS
Google Office Suite
Google Analytics
Adwords
AWS
Snowflake
Salesforce
KWI Retail POS
Tableau
MS Office Suite
MS SQL Server
MS Word
MS Excel
MS PowerPoint
MS Access
Visio
Harte-Hanks
SQL
Faraday GIS
Pardot
SPSS PSPP
Confluence
Jira Slack
Cognos
MicroStrategy
SharePoint