• Created Database Objects like Tables, Functions, Indexes and Triggers.
• Schedule the reports to keep generating at specific time intervals.
• Develop reports using SQL Server Reporting Services and utilizing complex SQL queries and stored procedures. Configure and maintain Report Manager and Report Server for SSRS.
• Design and build DWH database ETL framework for data validation and movement.
• Design and build an ETL framework to pass parameters, call child packages.
• Experience in writing SQL queries and optimizing the queries in SQL Server 2008.
• Scheduled weekly jobs and Maintenance tasks for better performance
• Performed application program enhancements, troubleshooting and bug fixes as required.
• Developed standards and guidelines to maintain and develop and administer the SQL Server database.
• Experience in witing Dynamic Sql.
• Experience in Error Handling.
• Experience in automating stored procedures.