• Engineered and optimized sophisticated data and reporting solutions using T-SQL, SSRS, and SSIS to boost performance and operational efficiency.• Managed large-scale data from multiple platforms, ensuring seamless integration and processing.• Demonstrated proficiency in crafting advanced T-SQL queries, including complex stored procedures, CTEs, functions, and optimized database operations.• Enhanced SQL query performance through strategic optimization and logic… Show more • Engineered and optimized sophisticated data and reporting solutions using T-SQL, SSRS, and SSIS to boost performance and operational efficiency.• Managed large-scale data from multiple platforms, ensuring seamless integration and processing.• Demonstrated proficiency in crafting advanced T-SQL queries, including complex stored procedures, CTEs, functions, and optimized database operations.• Enhanced SQL query performance through strategic optimization and logic refinement.• Provided oversight for 24x7 operations, managing several thousand reports, dashboards, and client reviews monthly, including 250+ scheduled and ad hoc reports.• Collaborated across departments to drive impactful business and process improvements, enhancing overall operational efficiency.• Led the design and implementation of SSIS packages, optimizing ETL data processes with advanced T-SQL techniques.• Implemented dynamic Report Server (SSRS) and Power BI dashboards, leveraging intricate data structures to improve report scalability and performance. Show less

• Deployed SQL Server 2005 for the department, optimizing data retrieval and manipulation for improved efficiency in reporting.• Implemented SQL Server Reporting Services (SSRS) and managed a robust report server on the intranet, facilitating seamless distribution of reports across the department.• Designed, developed, and deployed SQL Server Integration Services (SSIS) packages to automate manual import and export processes, enhancing operational efficiency.• Provided… Show more • Deployed SQL Server 2005 for the department, optimizing data retrieval and manipulation for improved efficiency in reporting.• Implemented SQL Server Reporting Services (SSRS) and managed a robust report server on the intranet, facilitating seamless distribution of reports across the department.• Designed, developed, and deployed SQL Server Integration Services (SSIS) packages to automate manual import and export processes, enhancing operational efficiency.• Provided database administration including creation, management, and backup processes, alongside user/object security management.• Supported daily, monthly, and quarterly reports, ensuring timely delivery and operational continuity.• Developed web-based reports using SQL Server Reporting Services, enhancing data accessibility and usability.• Automated report generation using VBA, Visual Basic .NET, VBScript, integrating SQL Server 2005, Access, Excel, SSIS, SSRS, and web pages to accelerate data retrieval.• Collaborated with the Six Sigma Team to plan, implement, and execute cost-saving projects, achieving over $50k in annual savings within the first six months Show less