Parcourir les catégories
Explorer
Fiverr Pro
Français
$
USD
Cory C
@corychristianse
Japon
Anglais, Japonais
À propos de moi
I'm Cory, a software developer with 8+ years in backend and data work, specializing in SQL Server and T-SQL. I tune slow queries and indexes, clean up bad data at scale, and build ETL pipelines. I led an overnight correction of 10M+ warehouse records with zero downtime, cut a property tax report from 20+ minutes to under 2, and led a review of ~10 SQL Server instances that cut backup spend by about $800K/year. I hold a Certificate in Advanced SQL Programming and also work with PostgreSQL, MySQL and API integrations. Based in Sendai, Japan. Send me your query, schema or data problem.
Compétences
Cory C
hors ligne •
Voir mes services
SQL & Requêtes NoSQL
I will take on your sql, sql server and database projects
Expérience professionnelle
Software Developer
Self Employed • Freelance
Jan 2025 - Present • 1 yr 9 mos
Building Packlight, a pre-commercial, invite-based community marketplace with an AI-powered listing pipeline: a seller uploads photos from a phone, tablet or computer, and the app generates a title, description and suggested price using Gemini 2.5 Flash Lite. Moved photo processing into Solid Queue background jobs to decouple AI calls from the web request cycle. Implemented invite-gated auth (Devise and devise_invitable), Google OAuth2 and Cloudflare Turnstile bot protection; separated admin and regular user roles with a Turbo-powered modal edit workflow. Deployed to Railway as a Dockerized container, splitting the Puma web server and Solid Queue worker into separate Procfile processes.
Government of British Columbia
Temps plein • 8 yrs 7 mos
Software Developer
Oct 2021 - Present • 5 yrs
Led a large-scale data-quality remediation across millions of records, implementing new validation rules across multiple SQL Server systems while keeping batch jobs and partner integrations fully operational. Led a data-correction initiative updating over 10 million warehouse records and 3.3 million embedded form fields across dozens of tables, delivered overnight with zero downtime over a 4-month project. Optimized a major property tax report from 20+ minutes to under 2 minutes by restructuring SQL logic, improving index usage, and introducing caching in the processing layer. Led a cost-efficiency review of ~10 on-prem SQL Server instances, cutting backup spend by ~$800K/year and storage cost by ~$100K/year. Designed and built ETL pipelines automating data ingestion from internal services and external agencies, applying validation rules before loading into analytics-ready datasets for BI dashboards. Maintained 40+ secure API endpoints integrated with external partners (LTSA, Petrinex, ICBC, national credit bureaus), ensuring high availability and TLS/HTTPS compliance. Replaced a costly third-party integration platform by designing and building 6 API endpoints and 8 file-transfer workflows in-house using .NET. Reverse-engineered opaque payload behavior and delivered in 7 weeks, coordinating 30–40 stakeholders across 7 teams without disruption. Designed a self-healing OAuth2 authentication workflow with autonomous token management, failure classification, and adaptive retry logic. Provided 4+ years of code reviews, architecture guidance, and mentorship to junior and intermediate developers.
Business Analyst / Software Developer
Mar 2018 - Oct 2021 • 3 yrs 7 mos
Built Python, PowerShell, and SQL Server automation replacing manual data handling with repeatable ETL workflows, improving reliability and auditability of operational datasets. Developed complex T-SQL queries (window functions, CTEs, subqueries, reconciliation logic) powering BI dashboards and data-driven workflows including SMS dialer campaigns targeting 1,000+ delinquent accounts monthly. Replaced legacy Access databases with custom Python MVC applications backed by SQL Server, strengthening data integrity and enabling downstream integrations. Led requirements gathering, testing, rollout, and integration of a new provincial payroll tax (EHT) into shared tax administration software (Gentax), scaling to serve tens of thousands of users.
