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.

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.

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.

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.)

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)

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

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