ZachWalter

Promoted to Lead Business Systems Analyst — September 2024

• Primary administrator of Interprose ACE, a licensed SaaS collections platform; leverages deep PostgreSQL customization to build and maintain workflows, automated jobs, and business logic.

• Executed a full system migration from a legacy platform to Interprose ACE, building T-SQL queries to extract, transform, and map all account, payment, contact, and workflow data to the new system's schema; coordinated with vendors and rebuilt critical operational workflows to ensure business continuity.

• Led an inventory reconciliation project between internal and client systems, coordinating with the client team to obtain missing data points, building ETL loads, and creating custom exports — eliminating manual posting on 20,000+ accounts and resolving approximately $20 million in active balances.

• Designs and maintains custom reports and automated data extraction pipelines to support business operations and collections workflows.

• Developed Python scripts for data mining and automated data extraction.

• Handles HIPAA-regulated health data and personally identifiable information (PII) in compliance with data privacy requirements, ensuring sensitive data is secured through encrypted communications and controlled file transfer protocols.

• Partners with clients to configure custom workflows, manage account assignments and payment adjustments, provision user access, and troubleshoot operational issues end-to-end.

• Collaborated on a full frontend redesign for a client site, contributing to UI implementation from design through deployment.

• Built reusable UI components and responsive web applications using React, Next.js, Gatsby, HTML, CSS, and SCSS.

• Translated Figma designs into production-ready code, bridging design and development workflows.

• Built a data-driven React application implementing async data fetching, filtering, and aggregated display of customer order and points data.

• Developed a portfolio site for a web designer, translating their creative vision into a live WordPress implementation.

• Connected frontends to Supabase and Firebase for real-time data and user authentication.

• Compiled a product data aggregation sheet for submission to state regulatory authorities.

• Provided high-volume customer service (50+ customers daily) in a fast-paced environment.

• Managed multiple concurrent residential projects from inspection through completion.

• Coordinated with clients, insurance adjusters, and contractors to drive successful outcomes.