Ms sql business intelligence development studio

MS SQL BUSINESS INTELLIGENCE DEVELOPMENT STUDIO ARCHIVE
MS SQL BUSINESS INTELLIGENCE DEVELOPMENT STUDIO WINDOWS

Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies.

Strong Applications Development experience with back-end databases such as SQL Server, Oracle and MS Access using ADO/ADO, OLEDB, ODBC and SQL client.

MS SQL BUSINESS INTELLIGENCE DEVELOPMENT STUDIO WINDOWS

Experience in tools like Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.

Excellent skills in Database backup, Replication, recovery, restoration, DTS and Linked servers.

Good understanding of Normalization /De-normalization and database design methodology.

Expertise in report generation using SQL Server Reporting Services 2005 (SSRS).

Experience in Trouble Shooting and Query Optimization.

Experience in design, development, and implementation of SQL Server Analysis Services(SSAS) reports/cubes.

Strong experience in MS SQL Server 2005/2008/2012 with Business Intelligence in SQL Server Reporting Services and SQL Server Analysis Services of 2005/2008.

Proficiency in creating different types of report such as Cross-Tab, Drill-down, Tabular, Top N, Summary, Sub reports, Charts and Graphs and formatting them using SSRS 2005/2000.

Experience with Physical & logical data modeling using All-Fusion Erwin Data Modeler.

Good experience in Dimensional modeling using Star Schema/Snowflake modeling concepts and Kimball/Inmon strategies.

Experience in creating and deploying SSIS packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.

Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Services (DTS), SQL Server Integration Services (SSIS) 2005, Bulk Insert/ BCP utility.

Efficient usage of DBCC commands to increase the performance of the query.

Created different tabular reports using Power BI features and enhanced them based on user requirements.

Experience in optimizing the database by creating various Clustered, Non-clustered Indexes.

Extensive experience creating database objects such as Tables, Constraints, Indexes, Views, Indexed Views, Stored Procedures, Triggers and Cursors on Microsoft SQL Server 2000/ 2005/2008/2012.

Strong T-SQL Server 2000/ 2005/2008/2012 Developer Skills including writing Stored Procedures, User-Defined Functions, Triggers, Views and Indexes.

MS SQL BUSINESS INTELLIGENCE DEVELOPMENT STUDIO ARCHIVE

Experience with high availability systems, 100+ Gigabyte databases, hundreds of databases in a highly transactional environment with proper data Archive and Purge processes.

Extensive experience in both OLTP and OLAP database designs and implementation strategies.

Experience in creating/deploying Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS) packages, Reporting Services (SSRS) and Analysis Services SSAS).

Strong Transact - SQL query writing skills (DDL, DML, and DCL).

Over 7+ years of experience in Database Design, Analysis, Development, and Support of Microsoft SQL Server 2012/20.

Ms sql business intelligence development studio