Benjamin Zamudio

Executed data migration processes and troubleshot inconsistencies across client reporting systems to ensure high data accuracy. Developed and maintained custom Looker reports and dashboards using LookML and SQL, resolving reporting issues and supporting client requirements. Analyzed and processed large-scale sales data with Google BigQuery for smooth ingestion and historical accuracy. Built custom data visualization features integrating SQL, React.js, and D3.js, and tested/optimized existing SQL queries and reporting workflows to improve overall pipeline performance.

Designed and delivered interactive business reports and dashboards for retail clients using Looker (LookML) and SQL. Created custom UI visualization components using D3.js, React.js, and JavaScript to meet specific reporting needs. Handled client reporting tickets, debugged visualization issues, performed metric calculations, and applied data filters. Maintained and documented standard operating procedures for internal reporting and daily data verification.

Analyzed, tested, and debugged REST API integrations between client e-commerce platforms and core company systems to ensure smooth data flow. Consumed and integrated third-party APIs/tools including Shopify (Liquid), ShipStation, Mailchimp, and Mandrill. Monitored system-to-system communications, identified and resolved connectivity issues and payload errors. Conducted end-to-end integration testing for new online store implementations prior to production rollout.