Generating SSRS reports which included various reporting features such as groups, sub-groups, adjacent-groups, group by total, group by sub-totals, grand-totals, drill-downs, drill through, sub-reports, navigation reports.Designing and implementing the snapshots report, report subscription, data-driven subscription and report caching using report manager.Developed complex stored procedures, views, and temporary tables as per the requirement.Worked on the reports module of the project as a developer on ms SQL server 2012 (using SSRS, t-SQL, scripts, stored procedures, and views).Created SQL server reports based on the requirements using SSRS 2008.Excellent report creation skills using Microsoft SQL server 2012/2008r2 reporting services (SSRS) with proficiency in using report designer as well as report builder.Experience in working on cube structure optimization for MDX query performance in analysis services 2008. Migrated DTS packages from SQL Server 2000 to SQL server 2012 as SSIS packages.Involving in the analysis of report design requirements and actively participating and interacting with team lead, technical manager and lead business analyst to understand the business requirements.Working on various possible performance-related issues including database tuning with the sole intention of achieving faster response times and better throughput.Creating dimension model for reporting system by identifying required dimensions and facts using Erwin.Creating action filters, parameters and calculating the sets for preparing dashboards and worksheets in Tableau‬‬.Creating and managing the clustered indexes and non clustered indexes and optimized queries using execution plan.Developing the tabular queries for efficient analysis of report using pivot/unpivot in T-SQL.Building, publishing customized interactive reports and dashboards, report scheduling using tableau server.Extensively utilizing the joins and sub-queries to streamline complex questions including different table.Writing the stored procedures and user-defined scalar functions (UDFS) to be used in the SSIS packages and SQL scripts.Creating the database objects - schemas, tables, indexes, views, user-defined functions, cursors, triggers, stored procedure, constraints, and roles.Working on full life cycle development (SDLC) involving in all stages of development.The educational qualification required is a degree in computer science or equivalent. The individual should have good knowledge of RDBMS, working knowledge of windows forms is an added advantage. The skills required are knowledge of management system, complex programming languages, and project accounting. There are other responsibilities like performing testing and troubleshooting and documenting database architecture codes and user instructions. The SQL Server Developer Resume also highlights duties like performing quality checks, keeping track of changes, reviewing developmental code and providing the users with data required for metrics and analysis. The roles and responsibilities underlined in the job description template are importing client data into the database and exporting data back to the client, designing a relational data warehouse for business intelligence, designing complex queries like stored procedures, triggers, functions to support processes and maintaining the system integrations. SQL Server Developer is responsible for the creation, maintenance and support of database in organizations.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |