PowerShell module SSRS and PowerBi samples for you to gather, store and report on information about your SQL Server estate. You can find more details on the website https://dbareports.io

Major contributor with a full command and current developer of a popular PowerShell module for SQL Server professionals. dbatools is a module filled with functions that help SQL Server DBA's get things done easier and faster. This module simplifies complex instances / database migrations, also helps to validate and implement best practices among others.dbatools is available in the SQL Server Community Collaborative's GitHub repository at github.com/sqlcollaborative/dbatools and in the PowerShell Gallery.

Team Lead for management of several SQL servers, Reporting, Mntc, and Administration.

• Provided the client necessary path to build Data mart and reports using all components of SQL BI (SSIS/SSAS/SSRS)• Lead in development of central reporting repository• Rebuilt Special Billing System• Involved in requirement gathering meetings• Designed Emergency Recovery System for SQL server 2005• Assisted in design Emergency Recovery System SQL Server 2008• Assisted in design of the infrastructure for the various environments (staging and production)• Involved as DBA in various task not limited to file structure, log shipping, deployment, back up schedule• Architected data migration plan using SSIS• Developed SSIS Packages to perform data loads from various types of sources files (Flat files, CSVs)• Developed benchmarking, ranking reports for the pricing team• Developed pricing versioning reports to publish price list for various business regions• Designed security model for delivery of the reports and data driven subscription for various users• Developed complex stored procedures, user defined functions for data migration• Involved in code review, performance tuning• Involved in configuring and deploying the reports for internal and external users• Deployed the SSIS packages, and rdls (SSRS) in various environments• Developed Web Scrapping technology to obtain customer information immediately• Assisted in the management of COGS• Developed web based central location for the Enrollments group• Assisted in the development of web based application for Pricing organization• Assisted in the development of Pricing mobile application for Brokers• Performed weekly, monthly, yearly Audits of the SQL Environment, CFX, Billings, and Carbon Offsets• Created 5 year Forecast program for Pricing and Hedging• Developed multiple adhoc reports upon request of Management• Developed primary reports for Revenue reporting