killocommercial.blogg.se - Developer sql server for mac

#DEVELOPER SQL SERVER FOR MAC SOFTWARE#
#DEVELOPER SQL SERVER FOR MAC WINDOWS 7#

#DEVELOPER SQL SERVER FOR MAC WINDOWS 7#

Operating Systems: Windows server 2003,windows 95/98/NT/4.0/2000/XP, Windows 7

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development StudioīI Tools: SQL Server Integration Services(SSIS), SQL Server Analysis Services(SSAS), SQL Server Reporting Services(SSRS)ĭatabases: MS SQL Server 2012/2008R2/2008/2005/2000, Oracle 8i,9i/10g, MS Access 97/2000.ĭata Modeling Tools: MS-Visio, Erwin 7.2/4.5, Visual Studio Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis Services (SSAS).Knowledge and experience in designing, developing and deploying Reports and Dashboards.Experience in SQL Server Analysis Services (SSAS) OLAP Cubes and Data Mining, SSAS 6.5/ 7.0/ 2000/ 2005/ 2008/2008R2/2012. Expert in creating packages, Jobs, Sending Alerts using SQL Mail.Experience converting MS Access reports to SQL Server Reporting Services.Experience in generating formatted SQL server Reports, handling Parameterized SSRS 2005/2008.Expert in uploading SQL Server Reports on to the report manager and organize them in folders and worked with delivering the reports using ‘pulled’ and ‘pushed’ methodologies.Extensive experience in creating SQL Reporting Services (SSRS) and SSIS Infrastructure that pulls data from data sources and provides a simple to use reporting environment.Utilized Integration Services (SSIS) to produce a Data Mapping and Data Mart for reporting.Data analysis and data migration by transferring them using SSIS packages.Extensively used SSIS Import/Export Wizard for performing the ETL operations.

Experience in migration of DTS Packages to SSIS Packages and loaded the data from SQL Server 2000 to SQL Server 2005 as well as Sybase database.

Extracting, Transforming and loading of data using SQL Server DTS.

Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP and DTS utility.

Creation and maintenance of Databases, creating Roles and managing user permissions, resolving deadlocks.

#DEVELOPER SQL SERVER FOR MAC SOFTWARE#

Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.Knowledge of databases in clustered and unclustered environments.Experience with Transact - SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.Extensive 7+ years of IT development experience as SQL Server Developer 2000/ 2005/ 2008/2008R2/2012.