
Jake P
Python, SQL Data Developer, ML Pipelines, Dashboards and Automation
Habilidades

Revisa mis servicios


Porfolio
Experiencia laboral
Python Developer & Data Analyst
Freelance Web Designer • Freelance
Apr 2026 - Present • 3 mos
Designed and deployed a full accounting software system in Python for multiple private small business clients. System includes automated invoicing, financial report generation, expense tracking, and data export to Excel. Built entirely from scratch and actively used in daily business operations. The system also delivers data analysis, automation scripts, and SQL reporting for clients across different industries.
Accountant
Maryland • Tiempo completo
Aug 2022 - Jun 2025 • 2 yrs 10 mos
Accountant, City of Annapolis — Department of Transportation Served as the primary accounting resource for the Transportation department, collaborating daily with Finance, Purchasing, and the Mayor’s Office. Trusted across all departments for financial accuracy, compliance, and operational guidance in a high-volume municipal environment. Key responsibilities included: • Full-cycle accounts payable and receivable processing, including requisition and purchase order verification, invoice matching, vendor relationship management, and compliance with city financial policies and regulatory requirements. • Payroll processing and oversight for 60+ employees, ensuring timely and accurate payments in full compliance with all regulations. • Assistance with budget preparation for Federal Transit Administration (FTA) and MTA grant applications, plus annual fiscal planning presented to city council. • Generation and analysis of financial reports using Munis ERP (Tyler Technologies) and advanced Excel, delivering data-driven insights for budgeting, auditing, and decision-making across departments. • Creation of journal vouchers from source documents and spreadsheets; maintenance of cross-reference files for active/closed purchase orders and Capital Improvement Projects. • Cash handling, deposit reconciliation, and oversight of bulk transactions (including bus pass sales) with strong emphasis on accuracy and customer service. • Full support for internal and external audits through preparation of thorough documentation and strict adherence to financial reporting standards. • Training, management, and supervision of incoming Accounting Associates and clerical staff to maintain consistent departmental procedures and accuracy. This role strengthened my expertise in government accounting, grant compliance, ERP systems (Tyler Technologies), and delivering reliable financial operations under regulatory scrutiny.