Data Analyst
Resume:
Brian S. Siders
LinkedIn: https://www.linkedin.com/in/briansiders/
Wells Fargo Bank, Phoenix, Az
Remediation Data Lead, Contract
• Explored, evaluated, designed, tested and validated high level regulatory remediations strategies, quality and data.
• Provided data discovery and analytics as well as defining and implementing data strategies for new remediations.
• Ensured adherence to compliance and legal regulations and policies on all projects managed.
• Provided end-to-end ownership of analysis efforts including requirements development, code development, documentation and validation.
• Collaborated and consulted with peers, colleagues, and more experienced managers to resolve issues and achieve goals. Sleep Number Corporation, Minneapolis, Mn
Sr. Database Marketing Analyst
• Developed and shared informative, actionable, and concise performance results of CRM Marketing campaigns.
• Developed CRM Marketing analytic testing plans, generated hypotheses, and assessed performance.
• Proactively monitored KPIs and trends and provided appropriate awareness using Excel and Power BI.
• Developed and operationalized recurring reports in support of the CRM Marketing programs.
• Managed and developed code for email marketing campaigns, processes and scheduling using SAS and Oracle Responsys.
• Collaborated with business leaders and SME's on direct mail campaigns, providing data and reporting support.
• Assisted in modeling creation, predictive and quantitative analysis and advanced visualization techniques.
• Developed customer tier process for email targeting.
• Converted Excel dashboards to Power BI.
• Supported analytics operations team to maintain quality data and systems by defining process improvements and data mining. US Bank, Minneapolis, Mn
Database Marketing Analyst
Del Mastro & Eels, Scottsdale, Az
Project Engineer (Commercial Construction)
Wells Fargo Mortgage, Phoenix, Az
Application and Reporting Engineer
Liberty Mutual / Prudential P&C, Scottsdale, Az
Reporting Analyst
• Converted CRM Monthly Executive reports for direct mail and email campaign results from an Excel based reporting tool to an automated Power BI dashboard utilizing SAS as the tool for data extraction.
• Developed a customer email tier process that grouped customers based on their email and purchasing activity.
• Developed an automated daily report delivered via email displaying results for the triggered email campaigns.
• Participated in the conversion of data tables, programs, reports and schedules from base SAS to SAS Viya.
• Developed an effective email campaign measuring process to track sales performance utilizing Oracle Responsys data tables in combination with the Sleep Number data warehouse using SAS and Power BI. Introduction
Aug'07 - Jan'11
Skillsets
Recent Projects
Sep'12 - Jul '14
Apr'05 - Aug'07
Jul'97 - Nov'04
Dec'14 - Jan'23
ad5r2v@r.postjobfree.com
Apr'23 - Curr
Professional Experience
Data / Marketing / Reporting analyst with over 15 years of experience in developing reporting dashboards, data & campaign management and creating, building and executing SAS/SQL programs. Skilled in data cleansing, data integrity, reporting accuracy, evaluating reporting processes and implementing improvements and efficiency. Experienced in absorbing, consolidating and reporting on data from multiple sources, collaborating with vendors and adhering to data practices, rules and regulations. Skilled in analyzing data tables, and identifying anomalies, trends and providing insight and recommendations. Excellent communication and interpersonal skills with the ability to conduct meetings and build relationships between stakeholders. w SAS Viya w Power BI w Access w TSQL
w Base SAS 9.4 w Tableau w Power BI w Visio
w SAS EG w Crystal w Tableau w Outlook
w SAS Macros w MS Project w Power Query w Teradata w SQL w VBA w SSRS w Excel
Page 1 of 1
Contact this candidate