Troy Clarke
Cherry Tree Co. (Freelance)
Mississauga,Canada
1
Language
25
Years of experience
Software Engineer building SQL Server, REST API, and cloud systems that support billing and financial data at enterprise scale. Modernizes hybrid environments across AWS, Azure, and GCP, including 1TB+ database migrations and legacy-to-distributed platform moves that reduced operational overhead by 25%. Partners with product, QA, DevOps, and engineering to translate complex business rules into clear code, architecture diagrams, and validation documentation.
Work History
Solutions Engineer
12 Years 7 Months- Migrated mid-market enterprise clients from QuickBooks to Dynamics CRM during mergers, preserving financial ledger continuity with 100% user adoption.
- Directed client-facing discovery and solution blueprinting, mapping engineering architectures directly to long-term business scale.
- Delivered embedded consulting and system blueprints, providing engineering training to enhance client self-sufficiency.
Software Engineer
3 Years- Architected scalable cloud and API frameworks to support high-volume billing and financial data systems across hybrid infrastructure.
- Modernized industrial workflows by migrating legacy on-prem systems to distributed multi-cloud architectures (AWS/Azure/GCP), reducing operational overhead by 25%.
- Engineered SQL Server migrations for 1TB+ mission-critical datasets, maintaining < 1 hour of downtime across 50M+ rows.
- Led technical discovery sessions with product, QA, DevOps, and engineering teams to translate complex business rules into actionable codebases.
- Authored system architecture diagrams and technical proposals to streamline communication and maintain project scope across cross-functional teams.
Sr. Programming Consultant
12 Years- Developed Microsoft business solutions using .NET (C#, VB), SQL, and JavaScript, enhancing Dynamics GP capabilities and removing manual workarounds for back-office teams.
- Built custom CRM plug-ins that automated manual lead capture pipelines, cutting sales representative administrative overhead by 5+ hours per week.
- Collaborated with corporate executives, product owners, and engineering peers to deliver production-ready software systems, ensuring alignment with business objectives.
Skills
Cloud Architecture
API Architecture
REST
Integration Patterns
Microservices
Event-driven architecture
Infrastructure as code
Kubernetes
Terraform
Cross-functional alignment
Discovery & requirements translation
Solution blueprinting
Pre-sales support
Technical consulting
Developer mentorship
Full lifecycle ownership
Architecture review
Delivery planning
Stakeholder communication
Software development
Software troubleshooting
Solution design
Front-end development
SQL
Javascript
Data analysis
Agile methodologies
Python
Web technologies
Code debugging
API integration
Software documentation
Machine learning
Analytics
Software design
Microsoft .NET
SELECTED ACHIEVEMENTS
- Data Scale: Architected ETL and CI/CD pipelines that consolidated 100M+ record datasets across corporate acquisitions with zero data drift.
- System Integrity: Eliminated systemic inventory and pricing drift across distributed platforms, recovering and securing financial reporting accuracy for enterprise systems.
- Cloud Modernization: Orchestrated multi-cloud transitions (AWS, Azure, GCP) that achieved 25% operational overhead reductions and 99.99% system availability.
- Process Automation: Built custom CRM extensions that automated manual lead tracking workflows, saving sales teams 5+ hours weekly per user.
Timeline
Software Engineer
KUBRA Data Transfer Ltd
01.2022 - 01.2025Read More
Solutions Engineer
Cherry Tree Co. (Freelance)
01.2014 - CurrentRead More
Sr. Programming Consultant
UXC Eclipse (formerly Tectura)
01.2002 - 01.2014Read More