<ul><li>SQL Server Database Development: Design, develop, maintain, and optimize SQL Server databases, stored procedures, functions, views, indexes, and complex T-SQL queries to support enterprise data processing and reporting requirements.</li><li>ETL Development and Data Integration: Develop, maintain, and troubleshoot SSIS packages to extract, transform, and load data from multiple source systems into SQL Server staging and reporting databases.</li><li>Incremental Data Loading: Implement incremental data integration processes for Microsoft Dynamics 365 CRM and other source systems, including change tracking, data synchronization, validation, and historical data maintenance.</li><li>Production Support and Troubleshooting: Monitor SQL Server Agent jobs and scheduled ETL processes, investigate package failures, resolve data discrepancies, perform root-cause analysis, and maintain reliable daily data loads.</li><li>Performance Optimization: Analyze and optimize complex stored procedures, SQL queries, indexing strategies, and ETL workflows to improve database performance and processing efficiency.</li><li>SSRS Reporting and Business Intelligence: Develop, maintain, and troubleshoot SSRS reports, datasets, parameters, and scheduled reporting processes to deliver accurate business information to stakeholders.</li><li>Power BI Reporting and Analytics: Support Power BI dashboards, KPI calculations, data models, report performance, and reporting enhancements to enable sales performance monitoring and management decision-making.</li><li>CRM Data Integration: Integrate and maintain data from Dynamics 365 CRM entities, including Accounts, Contacts, Opportunities, Sales Orders, and Invoices, ensuring consistency across operational and analytical systems.</li><li>Data Quality and Business Logic: Implement data validation, transformation rules, historical tracking, commission calculations, regional assignment logic, and reporting reconciliations to meet business requirements.</li><li>Automation and Power Platform: Develop Power Automate workflows and Power Apps solutions to automate reporting notifications, business processes, data entry, and operational activities.</li><li>Data Migration and Modernization: Support legacy data migration, SSIS package upgrades, SQL Server environment changes, and integration between on-premises SQL Server and modern data platforms.</li><li>Technical Leadership and Collaboration: Analyze business requirements, translate them into technical solutions, coordinate development and testing, troubleshoot complex issues, document processes, and support business users and stakeholders.</li></ul><p></p>
