Senior Full Stack Developer with 20+ years of experience leading all aspects of application design and development with a strong emphasis on database designing and modeling, SQL/ETL data migrations and database performance tuning and query optimization for both on premise and cloud-based IAAS/PAAS SQL resources in Azure. Effectively led a full SQL/ETL data and system migration from Salesforce to a Microsoft Blazor application achieving a cost-reduction of nearly 60% by leveraging scalable resources in Azure. Deployed applications to cloud-based production environments, setup and coordinated staging and production databases, implemented end-to-end test scripts for test automation, and deployed and validated disaster recovery for both SQL VMs and Azure SQL Databases.
• Expert in analyzing, designing, developing, optimizing and configuring Microsoft SQL Server suite including multiple business intelligence components such as Azure Data Factory, SSIS, SSRS, and DTS and various REST APIs.
• Expert full-stack Web developer with strong HTML5, CSS and JavaScript knowledge and experience.
• Experience as the primary developer on multiple significant systems/data migration projects.
• Primary/sole developer performing a complete migration between, both to and from, Salesforce and SQL Server, including scripting the creation of the data model, relationships and ETL operations.
• Primary/sole developer responsible for large data migration from DOS/QBasic flat file structure into SQL Server for 35 currency exchanges in Chicago, IL. Also heavily involved with VB6/WinForms development of a new POS application using WinForms/VB6.
• Knowledge of and experience with advanced features of SQL Server such as table partitioning, recursive CTEs, aggregate window functions, DML, DDL, Full-Text search, user-defined functions, triggers and procedures.
• Full management and disaster recovery expertise for SQL Server on-prem, Azure SQL Server VM, and the cloud-based Azure SQL Database.
• Experience implementing reporting systems using multiple reporting frameworks such as SSRS, Crystal Reports, DevExpress’ reporting module for XAF and Salesforce Reports.
• Varied experience within Microsoft’s Web development ecosystem as well as WinForms for VB6, Apache Perl development, PostgreSQL, significant VBA for both Excel and MS Access, PowerShell scripting, Windows management and the *nix operating system and installation.
• Experience using 3rd-party SSIS components, Script Tasks, REST APIs to integrate data from platforms such as QuickBooks/Intuit, MailChimp, and ArcGIS.
• Experience with both POS and real estate accounting-related projects such as deal, commission, and invoicing management.
Transact-SQL
JavaScript
CSS 3
HTML5
Data Modeling
Microsoft SQL Server Reporting Services
Data Extraction
Microsoft Azure SQL Database
Data Analysis
ETL
Salesforce
DevExpress
C#
SQL Server Integration Services
Apex