Open to opportunities

Andrew Frederick

@andrewfrederick

Message

Senior Python automation developer building API-driven integrations and data pipelines.

United States

Message

What I'm looking for

I’m looking for a role where I can build Python automation and API-driven integrations that eliminate manual reporting work, connect business systems reliably, and let me collaborate closely with stakeholders to deliver measurable efficiency gains.

I’m a Python Developer focused on automation, APIs, and systems integration, with 14+ years of web development experience and 5+ years dedicated to Python-based automation and integration solutions. I design tools and data pipelines that connect business systems, streamline reporting workflows, and reduce manual operational work.

At Allured Business Media, I built API-driven data pipelines using REST and GraphQL to aggregate, normalize, and process datasets from 5,000 to 200,000 records, and I automated 5 business-critical reports to cut generation time from 3–10 hours to ~15 minutes. I also automate Google Sheets dashboards used by 5 internal teams, develop lightweight internal tools and front-end interfaces for operational data, and translate business needs into practical technical solutions across non-technical and highly technical stakeholders.

Experience

Work history, roles, and key accomplishments

Senior Front-End Developer

Allured Business Media

Oct 2015 - Jan 2026 (10 years 3 months)

Designed Python-based automation and integrations connecting CRM, CMS, and audience data systems. Built REST/GraphQL-driven data pipelines for 5,000–200,000 records and reduced report generation time from 3–10 hours to ~15 minutes via automated workflows.

Python REST APIs GraphQL Data Pipelines NumPy Pandas Django Jira

Design Manager

Allured Business Media

Feb 2012 - Sep 2015 (3 years 7 months)

Led a team of 4 graphic designers across B2B print and digital publications. Established design standards and workflows, customized Jira for design-driven projects, and led UX strategy including wireframes and interfaces for data-driven products.

UX Strategy Wireframing Usability Testing Jira Stakeholder Management Team Leadership Visual Design

Front-End Designer & Developer

Allured Business Media

Feb 2010 - Feb 2012 (2 years)

Designed and developed front-end interfaces using UI/UX best practices, collaborating with back-end developers on building and system migrations. Partnered with editorial, marketing, and operations teams to deliver usable, data-informed UIs.

HTML CSS JavaScript UI UX Design Front End Developer Usability Testing Cross Functional Collaboration Stakeholder Management System Integration

Web Designer

Allured Business Media

Mar 2008 - Feb 2010 (1 year 11 months)

Designed and maintained websites and digital assets for B2B media brands. Supported CMS workflows and content publishing processes in coordination with internal teams.

Website Design HTML CSS Digital Asset Creation Workflows UI UX Design Adobe Illustrator Photoshop InDesign

Graphic Designer

Allured Business Media

Jun 2006 - Mar 2008 (1 year 9 months)

Created visual assets for print and digital media in support of multiple publications. Collaborated with cross-department teams on branding and layout needs across several B2B titles.

Print And Digital Design Adobe Illustrator Photoshop InDesign Branding Layout Design