Nicholas K. Xiong
Tampa,FL
Summary
Dynamic software engineer with a proven track record at Advantage Solutions, enhancing ETL workflows by 20% through automation. Proficient in C# and .NET technologies, delivering high-performance solutions while fostering team collaboration. Committed to optimizing processes and ensuring robust application security through OAuth implementations.
Overview
20
20
years of professional experience
Work History
Software Engineer
Advantage Solutions
Tampa, USA
01.2016 - Current
- Developing scalable automating data collections from .NET 7 Web APIs, databases, and flat files using scheduled scripts improving ETL workflow by 15-20% overall.
- Developing Python script to scan local folders, move files into respective sub-directories based on file extensions, and delete duplicates resulting in faster 200+ uploads weekly.
- Implementing .NET 7 Web API key validations, ensuring OAuth scopes, and rate limiters to prevent abuse of backend servers resulting in limited numbers of requests per minute improving performances and latency.
- Implementing OAuth token verifying user’s identity and log them in improving identity management and tracking.
- Automating Azure CI/CD pipeline so that automatically test, builds, and deploys applications to the Cloud reducing deployment times allowing team to ship new features faster.
- Performance post-deployment integration and UI tests against newly deployed environment to ensure everything works as expected resulting in lower production issues.
- Creating an automated, script-based indexing and defragmentation schedule that reduced nightly index maintenance window times from hours to minutes.
Software Engineer
Patterson Companies, Inc.
10.2013 - 12.2015
- Created .NET 3.5 WCF services, data integration, and facilitating communication between clients and servers.
- Developed services integrated OAuth, serving 1000+ daily users improving a smooth user experience on SAAS apps.
- Optimized indexes improving query performance across multiple applications reducing SQL performances and maintenances.
- Restructured a legacy single-database table containing thousands of rows into a partitioned, highly normalized schema and enforcing strict foreign keys.
Web Developer
Dell, Inc./Compellent
05.2011 - 09.2012
- Designed .NET 3.0 Web Apps that automated sales reports integrated SSRS and improving accuracy in extracting Dynamic CRM data.
- Implemented authorization and authentication security protocols verifying identity and restricts access to sensitive resources.
- Created stored procedures pulling thousands of records daily data dump from Dynamic CRM onto SQL Server 2008 so reports are generated daily.
Web Content Developer/Contractor
Foodsmart Express
09.2008 - 04.2011
- Identified business needs; gathered requirements.
- Designed and maintained Web Apps in .NET 2.0.
- Designed SQL Server schemas.
- Implemented and ensured accuracy of web portal content using CMS.
- Administrated SQL Server and optimizing SQL performances.
Web Developer
United HealthCare Inc./Optum Health
05.2007 - 09.2008
- Planned, designed and developed Healthcare management system.
- Built .NET 2.0 Web Apps ensuring user-friendly and high performances experiences.
- Designed SQL Server 2000 schemas.
Developer/Contractor
BearingPoint Inc.
08.2006 - 01.2007
- Designed and developed auto insurance that streamlined claims processing.
- Executed post-release updates and unit test.
Education
Master of Science - Computer Science
Northeastern Illinois University
Chicago, IL12.2005
Bachelor of Science - Computer Science
Northeastern Illinois University
Chicago, IL06.1995
Skills
- C# and NET technologies
- T-SQL and SQL databases
- JavaScript and TypeScript
- Python programming
- Entity Framework and Dapper
- Web API and RESTful services
- CQRS and SOLID principles
- Object-oriented programming
- Design patterns in software development
- Microservices architecture
- HTML, CSS, and Bootstrap
- JSON data handling
- Nodejs and Angular 11
- React 16 and Vite
- Visual Studio and Rider IDEs
- Git version control
- Docker containerization
- Postman for API testing
- Azure cloud services
- GitHub for version management
- oAuth and JWT authentication
- Jest and Vitest testing frameworks
- Serilog for logging
- GitHub Copilot for code assistance
- Claude AI for coding support
- Prometheus monitoring tools
- Grafana for visualization
- Splunk for data analysis
Languages
C#
T-SQL
JavaScript
Python
Timeline
Software Engineer
Advantage Solutions
01.2016 - Current
Software Engineer
Patterson Companies, Inc.
10.2013 - 12.2015
Web Developer
Dell, Inc./Compellent
05.2011 - 09.2012
Web Content Developer/Contractor
Foodsmart Express
09.2008 - 04.2011
Web Developer
United HealthCare Inc./Optum Health
05.2007 - 09.2008
Developer/Contractor
BearingPoint Inc.
08.2006 - 01.2007
Master of Science - Computer Science
Northeastern Illinois University
Bachelor of Science - Computer Science
Northeastern Illinois University