Sql Server Software Engineer
Resume:
Andrew J. Raymond
Rochester, MN
****@****************.***
SENIOR SOFTWARE ENGINEER
Expert in Enterprise Systems Development and SQL Server Solutions
Specialist in Complex System Integration and Modern Development Practices
Over 20 years of experience designing and maintaining mission-critical business applications in C#/.NET
Deep expertise in SQL Server design, optimization, and large-scale data management solutions
Full-stack development expertise spanning front-end UI, middleware integration, and database architecture
Track record of mentoring development teams and guiding successful Agile methodology transitions
Proven ability to modernize and integrate complex enterprise systems across multiple platforms
TECHNICAL SKILLS
Programming & Development
C# and .NET Framework/Core (15+ years)
ASP.NET (WebForms, MVC, Web API)
SQL Server (design, optimization, replication)
JavaScript/TypeScript
SOLID principles and design patterns
Database Technologies
SQL Server Management & Administration
Database Architecture & Design
SSIS/SSRS Implementation
Performance Tuning & Query Optimization
Database Security & Compliance
Development Practices
Agile/Scrum Methodologies
CI/CD Pipelines (Azure DevOps)
Test-Driven Development
Code Review & Quality Assurance
Technical Documentation
System Architecture
Multi-tier Application Design
Service-Oriented Architecture
Legacy System Modernization
Enterprise Application Integration
API Design & Implementation
WEX Benefits
March 2021 to April 2025
A leading provider of benefits administration technology solutions managing Health Savings Accounts (HSAs), Flexible Spending Accounts (FSAs), Health Reimbursement Arrangements (HRAs), COBRA administration, and related benefits programs. The platform handles complex financial transactions and integrations across multiple benefits programs for thousands of employers and their employees.
Technical Environment
Enhanced and tuned critical query performance and legacy stored procedures in high-volume OLTP/OLAP systems across 20+ databases
Built and supported complex SSIS packages and SSRS solutions in a multi-tenant environment
Developed and maintained systems handling PHI and PII with HIPAA, HITECH, and GLBA compliance
Worked within established security frameworks for access control and sensitive data handling
Utilized full Azure DevOps ecosystem for source control, Scrum management, and deployment pipelines
Supporting Technologies
Maintained and enhanced enterprise applications using C# and modern .NET technologies
Worked with diverse technologies including ASP.NET WebForms/WinForms, WCF, SOAP web services, Razor, Entity Framework, and ADO.NET
Professional Impact
Bridged customer enhancement needs with legacy system constraints while ensuring technical sustainability
Advocated for practical implementation of modern development practices that maintained project delivery timelines
Served with pride on Employee Resource Group board, advocating for workplace accessibility and inclusion initiatives
Axonom, Inc.
2015 to 2021
A provider of SaaS Configure-Price-Quote (CPQ) solutions featuring text, 2D, and 3D visualization capabilities, offering deep customization and integration with major CRM and ERP systems.
Technical Environment
Developed and maintained SQL Server backend supporting customizable CPQ implementations
Created complex data exchange solutions connecting CPQ platform to customer systems
Built custom features and secure data exchange protocols across full technology stack
Introduced initial source control and configuration management practices in startup environment
Supporting Technologies
Developed solutions using C#, .NET, SQL Server, and AngularJS
Created system interfaces for external systems including Microsoft Dynamics 365, with additional connectivity to SalesForce and NetSuite platforms
Professional Impact
Delivered successful CPQ implementations across diverse industries including industrial manufacturing, medical equipment, and data center infrastructure
Balanced rapid delivery requirements with efforts to establish sustainable development practices
Provided technical guidance for customer-specific customization requirements while maintaining system integrity
Mitchell 1
2005 to 2015
Provider of integrated software solutions for automotive service professionals, delivering CRM, shop management systems, and technical information services to thousands of automotive repair facilities nationwide.
Technical Environment
Designed and implemented SQL Server replication architecture for massive CRM system supporting 2,500+ automotive shops, millions of customers and tens of millions of repair records
Architected SSRS-based solution for automated distribution of business metrics while optimizing OLTP/OLAP workload separation
Led database re-engineering projects and served as technical escalation specialist for critical issues
Supporting Technologies
Developed solutions using C#, ASP.NET, Windows Forms, and SQL Server
Maintained legacy systems including VB 6.0 applications while managing modernization efforts
Professional Impact
Drove successful transformation of legacy systems to modern SQL Server architecture
Established reputation as trusted technical resource for crisis resolution and system optimization
EDUCATION
Master of Science in Software Engineering (MSSE), Walden University, 2011
Bachelor of Science in Computer Science, Minor in Mathematics, Cal State University, Hayward, 1984
Contact this candidate