how to use sql business intelligence development studio

HOW TO USE SQL BUSINESS INTELLIGENCE DEVELOPMENT STUDIO SOFTWARE
HOW TO USE SQL BUSINESS INTELLIGENCE DEVELOPMENT STUDIO WINDOWS

Operating Systems: Windows 2000/2003/XP/NT/Vista.

SQL Server Tools: MS SQL Server 2008R2/2008/2005 / 2000/7.0, MSSQL Server Reporting Services 2008R2/2008/2005/2000 (SSRS), MSSQL Server Analysis Services 2008R2/20082005(SSAS), MSSQL Server Integration Services 2008R2/2008/2005 (SSIS), Data Transformation Services(DTS), Oracle 9i/10g, ODBC, OLTP, OLAP, SQL Server Management studio (SSMS), MS SQL Server 2000 Enterprise Manager, SQL Query Analyzer, Web Services, SQL Profiler, Bulk Copy Program (BCP).

Flexible, enthusiastic and project oriented team player with excellent written, verbal communication to develop creative solutions for challenging client needs.

Experience in maintaining database, including updating statistics, re-indexing, structure modifications, and index analysis and also Log Shipping, Mirroring & Replication to restore Database backup.

Expertise in Database driven web based application developer: using SQL Server 2000, MS Access, Visual SourceSafe, MS SharePoint, MS FrontPage.

Experience in Dimensional Data Modeling Star and Snow Flake Schemas.

Expertise in identification of Business & Data requirements and converting them into conceptual & logical data models.

Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.

Good experience in writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.

Extensive experience with monitoring, tuning, analyzing DB performance and allocating server resources to achieve optimum DB performance by performing various query-optimization techniques.

Experience in using BCP and Bulk Insert commands while working with Flat filesĮxtensive knowledge of Relational Database Management Systems including MS SQL Server 7.0/ 2000/ 2005/2008 R2, Oracle 8i/ 9i/ 10g, DB2and Teradata.

Experience in creating SQL Logins, Roles and Authentication modes as a part of security policies for various categories of users.

Well-versed with database Installation, configuration, maintenance, monitoring, backups and recoveries, develop and debug Stored Procedures and Triggers.Proficient in Data Migration from sources like MS Access, SQL server, Text Files, Excel to SQL server 2000/2005/2008 using SQL Server Integration Services (SSIS).Experience in SSIS, SSAS and SSRS of MS SQL Server tools.Over 6+ years of experience in SQL Server development and administration with DBA duties.

HOW TO USE SQL BUSINESS INTELLIGENCE DEVELOPMENT STUDIO SOFTWARE

Around 7 years of IT experience with over 6+ years of experience in SQL Server and involved in all phases of Software Development life cycle from gathering requirement, development, implementation, testing and support.

How to use sql business intelligence development studio