Experience in creating KPI's, Aggregation, Perspectives, Partitions in CUBE using SQL Analysis Services.
Defined relationship between dimensions and measures groups, calculated slowly changing dimensions, KPI for different OLAP cubes.Proficient in Extracting, Transforming and Loading (ETL tools) using SSIS, DTS Import/Export Data, Bulk Insert, BCP, DTS Packages and SSIS packages.Migration of Data from one database to another new or existing database or up gradation of Facets Database using SQL Loader Tools.Expertise in utilizing Lookups, sorting, filtering, implementing pivot tables, understanding Excel data item and project status report compiling.Experience in Database Development, Modeling, with good understanding of Normalization /De-normalization, Normal Form and database design methodology.Involved in creating database Tables, Views, Triggers and Stored procedures in T-SQL as required for enhancements and change requests. In depth knowledge of SQL server / T-SQL programming.Senior SQL Server Developer with over 5 years of experience with strong background in Analyzing, Designing, Developing, Administering, Implementing and Testing of Client/Server application’s using MS SQL Server 2012/2008(R2)/2008/2005 and its suite of products SSIS, SSAS, and SSRS and BI - ETL experience using Pentaho Data Integration (Kettle and Spoon).
0 kommentar(er)
