Skip to content

Resume

Resume

Text version

Full text

Spencer Lenahan

Evansville, Indiana ·spencerlenahan@gmail.com · LinkedIn

Education

University of Evansville

Aug 2023 - May 2027

B.S. Computer Science; Minor in Statistics and Data Science · Expected May 2027

GPA 3.95 · Dean's List

Relevant coursework: Data Analysis, Fundamentals of Programming I & II, Software Engineering, Databases, R for Data Science, Computer Architecture, Programming Languages, Experimental Design, Logic Design

Southern Indiana Career & Technical Center

Aug 2021 - May 2023

Computer Science

Certifications

  • Microsoft Certified: Azure Developer Associate, Microsoft · Dec 2025

Experience

Software Engineering Intern (Returning), Guidepath Consulting

Jun 2026 - Present

Evansville, IN

  • Developed architecture and provisioned secure AI user interfaces backed by agentic logic, reducing multitenant security risks.
  • Designed and deployed e-commerce interfaces to distribute software and generate business leads for customer acquisition.
  • Supported a global telecom supply chain organization's ERP implementation through Boomi integration development.
  • Embedded sandboxed, dynamically provisioned AI chatbots into e-commerce websites to surface product information while minimizing infrastructure costs.

Undergraduate Data Visualization Developer, Center for Civic Education

Aug 2025 - Dec 2025

Evansville, IN

  • Cleaned order data and built a national heatmap, bar charts and line charts analyzing customer demographics across educational textbook orders, turning raw transaction records into a readable picture of who the Center reaches.

Technical Intern, Guidepath Consulting

Feb 2025 - Aug 2025

Evansville, IN

  • Developed an AI-powered Outlook Sales Agent that processes incoming sales orders, checks order status, and returns detailed product and order information, taken from design requirements through end-to-end development and deployment, integrated with a Model Context Protocol (MCP) server.
  • Built MCP servers backing Dynamics 365 Finance & Operations, extracting customers, products, sales orders, inventory and product descriptions, and handling Data Management Framework operations for bulk enterprise import/export.
  • Delivered end-to-end Sales Orders and Sales Returns automation with Celigo (iPaaS), integrating Shopify into Microsoft Dynamics 365 Business Central to streamline order management.
  • Built Power Automate flows syncing Azure DevOps work items with Microsoft Planner, turning a draft workflow into a fully operational solution with clearer task visibility and better progress reporting for the team.

Undergraduate Data Science Researcher, The Data Mine at Purdue University

Jan 2025 - Dec 2025

Evansville, IN

  • Collaborated with AstraZeneca to develop an Intelligent Data Model that transforms unstructured equipment data into accessible formats, enabling the business to generate insights and drive further enhancements.
  • Partnered with AstraZeneca to replace paper-based Quality Control logbooks with a digital system, reducing manual errors and accelerating audit processes.

Information Technology Intern, University of Southern Indiana

Jan 2024 - May 2024

Evansville, IN

  • Developed Python scripts with the IT department to diagnose and patch network vulnerabilities across university systems.

Leadership & service

Lead Game Developer, Sensory Inclusion

Sep 2024 - Present

Led end-to-end technical development of an inclusive learning mobile application, architecting and implementing core game mechanics from design through deployment.

Vice President, Association for Computing Machinery (ACM)

Aug 2023 - Present

Social Chairman, Phi Gamma Delta

Aug 2023 - May 2024

Selected projects

AI Outlook Sales Agent (Model Context Protocol, Microsoft Dynamics 365, Azure, AI agents)

An AI agent living in Outlook that reads incoming sales orders, checks status, and answers product questions against live ERP data.

Dynamics 365 MCP Servers (Model Context Protocol, Dynamics 365 Finance & Operations, Data Management Framework, REST APIs)

Model Context Protocol servers exposing live Dynamics 365 Finance & Operations data (customers, products, orders, inventory) to AI agents.

Shopify → Business Central Order Automation (Celigo (iPaaS), Shopify, Dynamics 365 Business Central, REST APIs)

An end-to-end Sales Orders and Sales Returns workflow built on Celigo, connecting a Shopify storefront to Microsoft Dynamics 365 Business Central.

Intelligent Data Model for Equipment Data (Data modeling, Unstructured data extraction, Python)

A research project with AstraZeneca turning unstructured manufacturing equipment data into a queryable model the business could act on.

Skills

Languages
C# · Python · SQL · TypeScript · R
AI & agents
Model Context Protocol (MCP) · AI agent design · Tool/function calling · Prompt engineering
Microsoft Dynamics 365
Dynamics 365 Finance & Operations · Dynamics 365 Business Central · Data Management Framework · Bulk import/export APIs
Integration & automation
Celigo (iPaaS) · Shopify integration · Power Automate · REST APIs · Webhooks
Cloud & tooling
Microsoft Azure · Azure DevOps · Git
Data
Data modeling · Unstructured data extraction · Data pipelines · Data analysis & visualization · Statistics · Requirements gathering