Excelled in generating formatted SQL server Reports by writing parameterized queries using SSRS 2008.Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import / export data feeds to / from OLAP data warehouse and claim system.Entity relationship diagram (ERD) development / normalization and physical database schema design.Expertise in Developing and Extending MS SQL Server Analysis Services 2005 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.Experience in extracting and transforming data using SSIS, DTS Import/Export Data, Bulk Insert, BCP and DTS Packages.Experience with T-SQL in writing triggers, tables, user defined functions, views, indexes, and relational database models and data integrity, and experience in migrating SQL Server 2000 to SQL Server 2005/2008/R 2/2012/2014.Experience with 2005/2008 concepts like data partitioning, online indexing, DDL triggers, DMV, DMF.Extensive experience withSQL development with strong knowledge in RDBMS and T - SQL concepts.Installation and configuration of SQL server 2014/2012/2008/2005/2000 with Health Care, Manufacturing and IT sectors.Five years of experience in Implementation, Administration and Support of MS SQL Server 7.0/ 2000/2005/2008 R2/2012/2014 in Development, Test, UAT and Production Environments.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |