Developing Microsoft SQL reports., SQL Server Reporting Service (SSRS), SQL server Management Studio (SSMS), SQL server Integration Services (SSIS) and scripting within a multi-instance ERP database landscape
Design, develop, and maintain reporting and business intelligence solutions using tools including SSRS, SSMS, SSIS, and Visual Studio.
Develop complex SQL queries involving multiple tables using inner and outer joins, sub-queries, aggregate functions, unions, and other techniques.
Develop and maintain ETL scripts for data integration, transformation, and cleansing from varied sources (databases, APIs, flat files). Utilize SSIS, PowerShell, Power Automate, and other automation scripts that facilitate Enterprise Reporting.
Optimize reporting and dashboard performance, ensuring fast load times and responsive user experience.
Minimum 5 years professional experience in SQL Database reporting