Ben Chadick Email & Phone Number

Birmingham, Michigan, United States

- Developed and maintained a robust Redshift data infrastructure for Stellantis, Pernod Ricard, and Chick-Fil-A, utilizing Redshift, Python, Databricks, and Glue.- Led ongoing support and evolution of agency's Tableau-based reporting platforms.- Led a team of data engineers, driving innovation in Generative AI integrations within user-facing Tableau dashboards and backend data management processes.- Implemented advanced analytics solutions to enhance decision-making and operational efficiency for high-profile clients.

Birmingham, Michigan, United States

- Led team of data engineers, establishing and maintaining data warehouses for 8 major IPG advertising agency clients, handling over 300 daily/weekly recurring inbound feeds.- Developed and maintained API interfaces to multiple platforms (Facebook, Twitter, Snapchat, LinkedIn, etc.) using Python.- Created reusable Python-based ETL tools and templates, increasing code consistency and quality across the global reporting team.- Designed and implemented a comprehensive quality monitoring and anomaly detection system for client data.

Birmingham, Michigan, United States

- Built and maintained a data warehouse in AWS for Quicken Loans, later scaling solutions for additional clients like FCA and American Express.- Developed complex SQL data transformations and documented reporting requirements directly from agencies.- Developed custom automated solutions, replacing previously manual processes, including but not limited to benchmarking calculations, spend adjustment calculations, publisher-reported overrides

Troy, Michigan

•Developed and executed on configuration management strategies and plans for product engineering projects (baselines, naming conventions, deliverable tracking)•Monitor project health by reporting the status of project work products and deliverables to project milestones. •Minimized testing costs for web-based system by automating regression tests via Selenium/Python scripting. •Created and maintained database solution for tracking and reporting on baselines for work products stored in PTC Integrity (Source Integrity/Requirements Management) and SAP (ERP/DMS).•Achieved reconciliation of non-conformities with configuration management processes and best practices by defining corrective measures and tracking until closure. •Support and adhere to policies, procedures, and operational guidelines related to established quality management system (TS 16949, ISO-26262, etc.)•Led cost-savings efforts for Requirements Management Engineering -- E.g., created Python package to remove problematic watermarks in scanned PDF documents, significantly reduced error rate of existing RM toolset by automating elimination of artifacts caused by OCR conversion process.

Birmingham, Mi

•Defined and implemented ETL processes through a combination of SSIS packages, Python and SQL stored procedures. Emphasis placed on modularity and reusability of objects to minimize re-work.•Established analytics database structure and data management processes for Nationwide, Priority Health, ALDI, Build-A-Bear, MEDC, and MSHDA clients.•Elicited requirements for, designed, built and maintained multi-dimensional databases (SSAS).•Automated data collection through RESTful API integrations: Google Analytics Core Reporting API, DoubleClick for Advertisers Reporting and Trafficking API, Facebook Marketing API, Twitter.•Defined data validation criteria and implemented data validation routines, which significantly improved the consistency of data and eliminated •Worked with teams to identify applications of collected data and automate previously manual processes (e.g., automated spend-pacing tools and reporting dashboards)•Continuously adapted and improved reporting back-end to accommodate changing agency and client requirements.•Coordinated and automated inbound/outbound data transfers with external advertising partners and clients.

Auburn Hills, Mi

•Project management support for cross-functional software teams•Facilitated multiple concurrent process development and improvement projects in the Chrysler Powertrain organization•Administrated team SharePoint site (SharePoint 2007)•Developed and tracked CMMI-based metrics for organizational process capability•Innovated database solutions for managing process capability data•Designed and developed multi-user risk tracking tool through MS Access and SharePoint•Experience creating and implementing Nintex workflows for SharePoint automations•Gained functional understandings of Chrysler powertrain development processes•Facilitated collaborative efforts through integrations of SharePoint with MS Office desktop applications

Auburn Hills, Michigan

•Facilitated Chrysler Powertain process development meetings•Maintained risk/issue logs for multiple ongoing Powertrain Controls projects•Facilitated and coordinated the creation of process evaluation and analysis tools

Ann Arbor, Michigan

•Tasked in researching and organizing data related to cellular-wireless intellectual property rights in China•Wrote comprehensive weekly literature reviews, contributing to the framework of supervising professor’s research