Senior Data Engineer: proficient individual contributor and consultant for data storage, integration, analysis, and reporting solutions. I have 20 years of experience developing, delivering and maintaining data-driven software solutions and 7 years of experience in applied analytical chemistry.Core Competencies:Software Developmento Solution architecture and designo Agile and Scrum methodologieso Requirements analysiso Effort and cost estimationo Source control (Git / Team Foundation)o Continuous integration and deployment (CI/CD)o Incident and defect resolutiono Unit testing, regression testing and data validationo Lifelong learnerData Storage Platformso Microsoft SQL Servero Enterprise Data Warehouse Designo Azure SQL Databases (managed and single instance)o T-SQL stored procedure and function developmento Administration of SQL Server on-premise solutions and on-premise to cloud migrationo Query tuning and index optimizationo Microsoft Azure Data Lakeo Unstructured and structured delta table design and optimizationo Microsoft Parallel Data Warehouse (Synapse)Data Integrationo Traditional ETL for Enterprise Data Warehouse applicationso Microsoft SQL Server Integration Services (SSIS)o Azure Data Factory pipeline development (ADF)o Azure Databrickso Event driven data stream processing with Scalao Azure Event Hubs integrationo Integration of advanced analytics and machine learning algorithmsData Analysis and Reportingo Microsoft Analysis Services (AAS and SSAS)o Tabular and Multi-dimensional model designo Model processing optimizationo Row level security implementationso Microsoft Power BIo Data visualizationso Microsoft .Net portal development for embedded reporting and data visualizationWeb Application Developmento Visual Studio .Net, MVC, C#.Net, JavaScript librarieso Azure resource configuration and deployment for web applicationso API developmentCommunicationo Highly fluent in verbal and written communication for collaboration on software design and deliveryo Proficient with technical documentation (UML, software architecture and entity-relationship diagrams)Industry Experience: Mortgage loan origination and secondary market investment, K-12 Education, Biotechnology, Environmental Science, Manufacturing, Retail