Luc Cote

Analytics and Reporting Resume

Analytics Engineer | Reporting and Data Systems

Data and systems professional with experience in healthcare reporting, SQL, dashboards, workflow automation, software development, and municipal technology.

Experience

3D Generalist, Systems Analyst, Project Manager and Developer · Independent Contractor

2007–Present

Independent real-time production, systems analysis, software development, and technical mentorship.

  • Deliver 3D assets, characters, environments, tools and technical solutions for Unreal Engine, Unity, VR, AR, HoloLens and custom-engine projects.
  • Build Maya tools and automation scripts in Python and MEL for rigging, skinning, blend shapes, export and artist workflows.
  • Advise teams on pipeline design, real-time optimization, PBR and non-PBR materials, photogrammetry, character deformation and production planning.
  • Train artists and junior developers in Maya, custom tools, engine workflows and technical problem-solving; pursue independent software and game projects using AI-assisted development.

Report Writer and Database Analyst · Sweetser

2025-08–2026-01

Clinical, operational, compliance, and program reporting in the Welligent environment.

  • Developed and maintained SQL Server queries and Crystal Reports for clinical, operational, compliance and program reporting within the Welligent environment.
  • Used T-SQL and SSMS to transform relational and form-based data with joins, common table expressions (CTEs), temporary tables, window functions, date calculations and validation logic.
  • Built and supported Power BI reporting and Microsoft Forms, SharePoint and Power Automate workflows for intake, attendance and program data.
  • Worked with program leaders and end users to define requirements, investigate data discrepancies, troubleshoot reports and document calculation logic and recurring reporting processes.

Software Developer · Netrush

2017-12–2019-10

Marketplace analytics and internal software platforms.

  • Developed internal tools and platforms to analyze Amazon Marketplace sales data and support business planning for Netrush and its partners.
  • Created dashboards and data visualizations in Salesforce Einstein Analytics using data from Azure and internal systems.
  • Built Azure Functions, APIs, backend methods, custom objects and React/Redux interfaces during the transition from Salesforce to an in-house platform.
  • Worked with C#, JavaScript, HTML, CSS/Sass, Apex, SQL Server, Azure Storage, Azure DevOps and Power BI across application and reporting workflows.

Systems Analyst · City of Casper

2015–2017

Municipal technology, GIS visualization, and systems modernization.

  • Managed web, dashboard, database and technology projects supporting municipal operations, public communication and service modernization.
  • Evaluated and coordinated system upgrades across city departments with internal users, IT staff, vendors and project stakeholders.
  • Created 3D city models at multiple levels of detail using Esri CityEngine and ArcGIS data, with supporting interfaces and visual assets.
  • Applied SQL Server, Visual Studio, Power BI, SharePoint Designer, C#, JavaScript, HTML, Adobe Creative Cloud, Maya and Unity to municipal projects.

Projects

Duckbills / BudgetApp

Personal budgeting and bill-tracking application

  • Develop a cross-device budgeting application with AI-assisted implementation and debugging, evolving a Python/Excel reminder tool into a React, TypeScript and Vite PWA.
  • Work with Supabase authentication and PostgreSQL data models for households, bills, payments, imports and reminders, including row-level security and data-validation workflows.
  • Define product behavior, review application results and iterate on guided imports, dashboards and reminders. Use Git/GitHub, GitHub Actions, Vitest, Playwright, Vercel and Sentry within the development workflow.

CareerOS and CareerOS Forge

Career data and document-generation platform

  • Build a structured career-data platform that stores verified experience and supports targeted resumes, portfolio pages, cover letters, case studies, search and visualizations.
  • Use Python, FastAPI, SQLAlchemy, SQLite/PostgreSQL-ready data models, React, TypeScript, D3.js, Jinja2, JSON Schema validation, automated testing and GitHub Pages deployment.
  • Extend the workflow through CareerOS Forge with configuration-driven repository scaffolding and validated, print-ready resume generation.

Skills

Data and business intelligence: SQL Server, T-SQL, SQL Server Management Studio (SSMS), Crystal Reports, Power BI, Welligent, Excel, relational databases, data validation, ETL workflows, dashboards, operational reporting, Salesforce Einstein Analytics, PostgreSQL, Supabase, SQLiteSoftware and web development: Python, C#, JavaScript, TypeScript, React, Redux, HTML, CSS/Sass, Apex, MEL, REST APIs, Azure Functions, Azure Storage, FastAPI, SQLAlchemy, Jinja2, D3.js, Vite, Progressive Web Applications (PWAs)Automation and collaboration: Microsoft 365, SharePoint, SharePoint Designer, Microsoft Forms, Power Automate, Git, GitHub, GitHub Actions, Azure DevOps, Visual Studio, VS Code, Jira, Perforce, ShotGridAI-assisted workflows: ChatGPT/OpenAI, Codex, Claude, GitHub Copilot, AI-assisted Coding, Debugging, Research, Documentation, Prototyping, Analysis, Workflow Development

Education

Bachelor of Science · The Art Institute of Portland

2004–2007

Game Art and Design