Business System Analyst

Automated manual workflows across a cooperative's daily operations, including a member lookup tool that reduced search time from about 60 seconds to under 5 seconds, and a legal document batch processor that cut preparation time from hours to under 1 minute. Focused on replacing repetitive manual work with reliable, low-maintenance automation that non-technical staff can use directly.

Built and maintained a Python ETL pipeline that reduced ATM transaction processing from over 2 hours to under 5 minutes. Used Python for data migration work that improved accuracy from 70 percent to 99 percent across 7,000 plus member accounts. Wrote automation scripts for a legal document batch processor and a member lookup tool. Comfortable working independently across the full pipeline from data extraction to final output.

Authored the SpellNumber VBA system used in a live loan document system since 2022. Built a flag-based batch processor handling 14 form sheets for legal mediation document prep, cutting preparation time from hours to under 1 minute. Comfortable writing VBA that integrates directly with Excel workflows non-technical staff already use.

Led data migration from a legacy Excel-based master sheet to a structured database system, improving accuracy from 70 percent to 99 percent. Resolved real-world data issues including duplicate client records, Excel serial date formats, and mixed account types requiring new classification. Sequenced the migration carefully, ensuring account identity data was in place before schema design.

Designed and maintained the database architecture for a cooperative operations system serving 7,000 plus member accounts, using SQLite as the backend for a Flask-based application. Handled schema design for savings, loans, and member data, including resolving duplicate records and establishing the savings database as the master identity anchor during migration. Comfortable writing queries for reconciliation, reporting, and data integrity checks.

Built an ETL pipeline that reduced ATM transaction processing time from over 2 hours to under 5 minutes, including cross-platform integration with command line tools. Also built a savings interest extractor that scans thousands of individual member account files as part of a recurring data pipeline. Comfortable owning a pipeline end to end, from raw data extraction to final reporting output.

Five years as the sole technical resource for a multi-purpose cooperative, building and maintaining all production systems serving 7,000 plus member accounts, including loan processing, savings, and member data systems. Directly familiar with cooperative banking operations, financial reconciliation, and the regulatory and reporting needs of a financial services environment.