Matthew Piggott

Expert .NET C# object-oriented Software Developer, focused on analysis of business flow.
SQL Server DBA & performance tuning expert. Backup / Restore / Recovery / High Availability.
Skilled in responsive database design, ETL, imports, exports, infrastructure and migration strategies.
Experienced in down to earth analysis techniques, collaborating with management, sales, and clients.
Resourceful database analyst, report designer, data auditor, and resolver of anomalies.
Knowledgeable in data warehouse update strategies, star and snowflake schemas, ETL design.
Seasoned multitasker, calmly balancing urgent, important, and back-burner tasks.
Natural inclination and ability to rapidly become an expert in current work areas.
Strong organizational skills and Remote accountability through habitual note-taking.
Excellent documentation, research, comparison, and project estimation skills.

SQL Server 2000-2019, Oracle, Sybase, DB2 AS/400 & iSeries, Access, OLE & ODBC.
Experienced Visual Studio .NET C# Software Developer, and familiar with VB in .NET.
ASP.NET and Telerik tools, HTML, CSS, Bootstrap, SOAP and REST Services, IIS setup.
JSON, JavaScript, jQuery, XQuery, XML / XSLT, local data caching, AJAX & partial postbacks.
C# inheritance & polymorphism, Interfaces & DI, image handling, encryption, data manipulation.
Advanced C# skills w/ Lambda expressions, LINQ(-to-SQL), SQL CLR, SSIS, XEvent, ADO.NET.
Expert SQL coder, Sproc / Trigger / TVF / CLR author, SSIS package designer, SSAS & SSRS.
SQL Server Table Partitioning, ColumnStore, In-Memory OLTP, Sparse Columns, Encryption.
SQL Server Service Broker, DB Mail, SQL Trace & Profiler, Query Store, Extended Events.
SQL Server Replication, Log shipping, Mirroring, Clustering & High Availability strategies.
TFS source control and workflow, SharePoint, OCR & ABBYY FineReader, ERWin, Visio.
Admin: Windows Server, Unix, Linux, Netware, AS/400. Advanced Windows and Linux scripting.
Present studies: AWS, Data Factory, Data Catalog, .NET Core, Docker, Kubernetes, SQL Server on Linux.

Automotive Marketing with a history of work for Ford, General Motors, Chrysler, Mazda, Jaguar, and Daimler Trucks North America. Experience includes management reporting and market analysis, customer and internal websites, online marketing, print, strategy, customer service admin, and more.
Realtor and related Real Estate marketing, MLS systems, and the Title Insurance industry.
Point-of-Sale and Inventory systems, kiosks, payment devices, transaction logs, PCI credit card privacy, signature capture, internationalization, user and data interfaces, and data warehousing.
Hospitality and Gaming industries including hotel management systems, casino player tracking, dining reservation systems, labor & time management, customer marketing strategies and comps.
Education management for internal training, certifications, and employee benefits.
Medical billing industry with experience in insurance, claim submissions, and payment processing.
Extensive experience developing a wide range of customer service and reporting applications, middle-tier functionality, interfaces, data/object models and tools, ETL, and relational databases.

T-SQL and SSIS, data analysis, import/export, data migrations, and advanced ETL design.
Expert analysis-focused C# and ASP.NET developer with habits of modular coding and commenting.
Traditional & Interactive reporting with dynamic parameter UX, and Web Service / SaaS development.
Database Engineering and Administration, building work/data flow and connecting diverse systems.
Quickly acquiring an understanding of new business & team processes, databases & code structures.
Communication and working with Remote teams, using the right interaction tools for the right things.
Experienced developer mentor and cross team collaborator for integration, scalability, and strategy.

Microsoft Certified Solutions Expert: Data Management and Analytics	2	/ 2020
Microsoft Certified Solutions Associate: SQL Server 2016 Database Development (Charter Member)	11	/ 2016
Microsoft Certified Solutions Developer: Programming in C# Specialist	10	/ 2016
Microsoft Certified IT Professional: Database Developer SQL Server 2008	2	/ 2012
Microsoft Certified Technology Specialist: SQL Server 2008	2	/ 2012
Microsoft Certified IT Professional: Database Developer SQL Server 2005	12	/ 2007
Microsoft Certified IT Professional: Database Administrator SQL Server 2005	12	/ 2007
Microsoft Certified Technology Specialist: SQL Server 2005	12	/ 2007
PowerSoft/Sybase PowerBuilder CPD versions 4, 5, 6	1994-1998

View my Microsoft Certified Professional Transcript	Transcript ID:	778388
View my Microsoft Certified Professional Transcript	Access Code:	matthewpiggott