Software Engineer Contracta Construction UK
Managed and executed accounting data migration projects, leveraging the Python Pandas library to clean and transform large datasets and ensure data integrity.
Developed a full-stack Django application to automate the monthly depreciation process, replacing a manual spreadsheet-based system and integrating directly with Sage X3's REST API to post journal entries. This streamlined a critical accounting workflow and significantly reduced manual data entry time and errors.
Developed robust Python scripts, featuring logging, type hinting, and comprehensive error handling, to efficiently transform raw bank statement data (CSV) into the required Sage X3 import format
Implemented robust business logic for financial calculations, creating a function to automatically calculate straight-line depreciation and a custom rule to allocate depreciation for unassigned equipment across all active projects.
Engineered a user-centric data management system, including a pandas script to ingest initial asset data, a Django view for monthly allocation uploads, and a "human-in-the-loop" review process to ensure data accuracy before posting to the ERP.
Implemented modern DevOps practices, containerizing the application with Docker and deploying it on a VPS with Nginx and Cloudflare, demonstrating proficiency in building and maintaining a full-stack, production-ready solution.
Utilised Excel Power Query and Power BI to streamline financial processes, resulting in a 75% reduction in statement preparation time.
Conducted comprehensive black box testing on enterprise-level financial software (Sage X3), identifying and documenting defects to improve system quality and stability.