Scott Shanfeld
*********@*****.*** • 941-***-****
LinkedIn • Sarasota, FL 34277
Seasoned and performance-driven professional with extensive experience in architecting and facilitating delivery of quality and scalable data systems that support organization’s strategic goals. Well-versed in managing complex projects, creating data pipelines for efficient storage, optimizing data workflows, and implementing innovative data solutions. Proactive problem-solver with a knack for providing actionable insights and efficiently integrating new technologies/tools in data engineering processes. Demonstrated skills in collaborating with cross-functional teams to align data strategies with set objectives.
Areas of Expertise
·Data Architecture & Engineering
·Project Management
·Continuous Performance Optimization
·Data Analytics & Reporting
·Data Governance & Compliance
·Security Audit & Risk Assessment
·Data Quality & Integrity
·Technical Team Leadership
·Data-Driven Decision-Making
Professional Experience
Horizon Media, LLC
Senior Technical Operations Specialist, Media Technology & Data
2020 — 2024
Oversaw audit control processes, including HiTrust and CIA, while coordinating with external vendors to maintain robust security measures. Led vendor risk assessments, collaborated with legal teams on contract and policy reviews, and facilitated management of KNIME and AWS services, including RDS, Aurora, EBS, EC2, Redshift, Route 53, and Cloud Formation. Managed HR processes for team and consultant’s onboarding/offboarding. Maintained Snowflake database operations and administered Tableau user access and server solutions.
·Constructed and led robust technical operations team of 10, increasing operational efficiency and team performance.
·Ensured efficient workflow and adherence to Data Governance and Compliance standards.
·Developed and executed new Atlassian solution for improved project management.
·Improved system reliability by creating effective outage and maintenance alert protocols for essential systems.
MullenLowe MediaHub (IPG)
Analyst, Strategic Analytics
2017 — 2020
Developed comprehensive data analysis solutions via SQL, Excel, and Python to drive strategic business decisions. Extracted and synthesized media data to support organizational objectives and crafted tailored reports for media teams. Spearheaded data automation initiative leveraging Amazon Web Services to streamline data processing workflows. Collaborated to ensure timely delivery of data sets/reports and contributed to enhancement of business strategies through meticulous data governance and insightful analytics.
·Initiated communication channels between analytics and IT departments for enhanced tool and resource allocation.
·Generated client-focused dashboards in Tableau, enhancing user experience and data accessibility.
Carat
Senior Associate, Audience Knowledge Team
2016 — 2017
Analyzed and prepared data using SQL, Excel, and Python to ensure accurate database consumption for high-profile projects. Employed various media data sites for data extraction, analysis, and strategic decision-making.
·Formed effective liaisons with teams for streamlined project execution and timely completion.
·Provided critical data analysis and supported key deliverables across SEM, display, and social initiatives.
TRAC Intermodal Inc
Data Quality Analyst
2014 — 2016
Spearheaded large-scale data sets with SQL to identify and resolve data inconsistencies. Employed Excel and Data Validation commands to conduct mathematical analyses and detect discrepancies within data sets. Developed intermediate and advanced SQL scripts for various databases and complex data structures. Generated dashboards and data models to support business decision-making. Implemented fixes for identified data issues and effectively communicated resolutions.
·Overhauled analytics program, optimizing tool utilization and resource allocation.
·Streamlined data validation processes, significantly reducing error rates and improving data quality.
Quality Attributes Software
Data Analyst, 2012 – 2013
Help Desk Engineer, 2012
2012 — 2013
Evaluated and managed large data sets using advanced SQL techniques to uncover anomalies and ensure data integrity. Developed and executed SQL scripts across various databases and conducted data analysis. Engaged with diverse facilities divisions and clients in commercial, educational, healthcare, government, utility, and residential sectors.
·Led creation of facility data management environment for better data accessibility and reliability.
·Successfully completed integrations with intricate systems within/outside US.
Additional Experience
Senior Associate, Reporting and Analytics, iProspect
Education
Bachelor of Science in Electrical Engineering Technologies
University of Hartford, College of Engineering, Technology, & Architecture
Associate of Arts in General Studies
Hillyer College
Course
AI for Business Needs
Technical Skills
Computer & Networking: Atlassian, Microsoft Office Suite, Networking Solutions, Computer Technologies
Marketing: Kenshoo, Atlas by Facebook, Twitter Reporting, Facebook Business Manager, Marin Software, Google DS3, Google DCM, Flashtalking, VisualIQ, CRM-based Software
Programming: MS/SQL, MySQL, PostgreSQL, Oracle PL/SQL, Java, C++, HTML, Python, Snowflake
Mathematics Software: Mathworks Matlab (Math analysis software)
Visualization Suite Tableau, Microsoft BI
Analytical: Microsoft PowerPivot, Microsoft PowerQuery
Others: Familiarity with Watson Artificial Intelligence