Brian S. Siders

Introduction

Professional Experience

Sleep Number Corporation, Minneapolis, Mn

Sr. Database Marketing Analyst • Managed analytics, execution, and performance results of comprehensive CRM Marketing programs

• Proactively identified new and profitable areas of opportunity for targeting, segmentation, and CRM Marketing programs.

• Developed and shared informative, actionable, and concise performance results of CRM Marketing programs including

engagement, ROI, incrementality, and recommendations.

• Developed CRM Marketing analytic testing plans, generate hypotheses, and assess performance.

• Developed definitions and baselines and owned the provision and accuracy of these metrics.

• Proactively monitored KPIs and trends and provided appropriate awareness and solutions to help ensure business goals are met.

• Developed and operationalized recurring reports in support of the CRM Marketing programs.

• Managed daily email triggered campaigns, processes and scheduling

• Managed ETL process between vendors by ensuring data quality

• Made insightful, sharable, and easily digested recommendations based on analytics and findings.

• Support analytics operations team to maintain quality data and systems by defining process improvements, data mining, and alerting team of opportunities.

• Worked extensively with CRM managers to inform and provide guidance relating to program strategy.

• Supported statistical modeling implementation and maintenance.

• Managed, prioritized, fulfilled, and documented ad hoc analysis.

• Responsible for all phases of email reporting from data extraction to visualization.

• Redesigned and managed Email reporting converting from Excel to Power BI.

• Managed daily file transfer process between systems and vendors.

• Contact for vendor data rules and validation.

• Created, built and managed email reporting program.

• Defined attribution logic for email sales.

• Created triggered email notifications for overnight processing errors. US Bank, Minneapolis, Mn

Database Marketing Analyst • Successfully delivered list criteria for over 100 direct mail and email campaigns

• Automated the branch closure process saving over 200 hours of manual process

• Responsible for maintaining the company email database

• Worked with multiple vendors delivering and receiving data

• Scrubbed data to ensure data integrity

• Enhanced existing reporting into complex user friendly dashboards

• Executed on average 20 ad hoc requests per week from upper management United Healthcare, Minneapolis, Mn

SAS Programmer • Converted a complex Access database into SAS code.

(3mo contract) • Provided insight and adjustments to existing Excel programs. Apr'12 - Jul'12

Aug'15 - Jan'23

aduwt7@r.postjobfree.com

612-***-****

Sep'12 - Jun'15

Experienced data and reporting analyst with over 15 years experience in developing complex reporting dashboards, managing big data and creating, building and executing SAS/SQL programs. Skilled in data cleansing, data integrity, reporting accuracy, evaluating reporting processes and implementing solutions. Skilled in analyzing data and identifying anomalies. Advanced Excel knowledge with over 15 years of executive reporting, applying macros, complex formulas, pivot tables, drop downs, slicers and visualization techniques. Page 1 of 2

Brian S. Siders

aduwt7@r.postjobfree.com

612-***-****

Wells Fargo Bank, Phoenix, Az

Implementation Consultant • Responsible for monitoring overnight scripts and troubleshooting issues.

(12mo contract) • Updated daily reports for upper management.

• Excel SME, assisted coworkers with questions on reporting, formulas and automation. Wells Fargo Mortgage, Phoenix, Az

Application and Reporting Engineer • Automated existing morning reporting updates which I was hired to maintain

• Redesigned existing reporting in Excel

• Automated morning reporting updates saving 2-3 hours per day

• Managed ETL process between vendors

• Member of team that converted executive reports (Excel) reports to SSRS dashboards

• Provided insight and adjustments to existing Excel programs Liberty Mutual Insurance, Scottsdale, Az

SAS Analyst • Converted all reporting from SAS mainframe printouts to Excel

• Built and managed reporting library for Western Region P&C

• Reported daily sales to Regional Sales Managers using SAS mainframe to Excel

• Source for data requests (ad hoc) from all department within the company Skillsets

w SAS Viya w Excel w HTML w Responsys

w Base SAS 9.4 w Power BI w CSS w MailChimp

w SAS EG w Access w WordPress w MS Email Mgr.

w Proc SQL w Word w HostGator w FTP

w SQL w PowerPointw Dreamweaver w Pac2000

w SSRS w Visio w GoDaddy w DB2

w Power BI w Outlook w MS Project w PHP

w Synapse w Report Writer w VBA w Python

Jul'00 - Nov'04

Jan'11 - Jan'12

Apr'05 - Aug'07

Page 2 of 2

Contact this candidate