koreanger.blogg.se - Windows server 12

Expert in designing Enterprise reports using SQL Server Reporting Services and Excel Pivot table based on OLAP cubes which make use of multiple value selection in Parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.ĭatabase: SQL Server 2005, 2008, 2008 R2, Oracle SQL/SSIS/SSRS.Worked on creating client reports and custom reports (On demand, Ad-hoc Reports, Frequency reports, Summary Reports, Sub Reports, Drill-down, dynamic grouping, Cross-Tab, graphical, aging reports etc) using SQL Server Reporting Services 2012.

Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS and ability to export reports and query results to Excel or PDF

Excellent report creation skills using Microsoft SQL Reporting Services (SSRS).

Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.

Thorough understanding of Kimball's' theory, KPIs, SQL Architecture.

SQL Server OLAP database development including KPIs, Data mining, working wif changing dimensions.

Excellent in High Level Design of ETL DTS Packages& SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

Experience in creating and deploying SSIS Packages on high-activity, normalized transaction systems ETL implementation using SQL Server Integration Services (SSIS).Strong experience in MS SQL Server wif SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).Strong experience wif SQL Server and T-SQL in constructing complex stored procedures, triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, exceptional handling, and data integrity.

Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical and troubleshooting.And Strong experience in Agile Methodology. Experience in the development and testing of Windows/Microsoft and web - based software applications.Including Over 7+ years of experience in analyzing, designing, tuning and developing Client/Server, Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC) using MS SQL Server DTS/SQL Server Integration, Reporting & Analysis Services. Over 12 Years of experience in IT involving development, testing and production support.