*MS* *SQL Server Developer / (SSIS), (SSRS), (SSAS).* ** *Send me requriement at [email protected]* ** · 7 years of experience in IT as *MS* *SQL Server Developer/DBA.*
· Extensive and diversified hands-on experience designing, implementation and administration SQL Server* Relational Database / Warehouse* in small, medium, and large organizations. · Extensive experience in *OLTP/OLAP* environment. · Experience in Microsoft SQL 2005 Server *migration* from SQL Server 2000, Integration Service (*SSIS*), Reporting Service (*SSRS*), and Analysis Service (*SSAS*). · *Backup *and* Recovery* of *MS SQL 2000 / 2005* Server Databases. · Extensive experience creating database* objects *such as* tables, views, constraints, indexed / materialized views, stored procedures, triggers, cursors, Common Table Expressions (CTE’s)* on MS SQL Server 2000/2005. · Outstanding knowledge in writing complex database queries, stored procedures, triggers in MS SQL Server using *SSIS*, Data Transformation Services (*DTS*) and* BCP* utility. · Expertise in Transact-*SQL (DDL, DML*), views, stored procedures and also using database triggers. · Excellent skills in utilizing System stored Procedures, views from the system (master db) and database (local db) catalog. · Excellent experience in utilizing extended stored Procedures*.* · Extensive knowledge in Tuning T-*SQL* queries to improve the database performance and availability. · *Data modeling* using* *ER-Win & MS Visio 2003/2007*.* · Excellent skills in implementing *ETL Packages* using *DTS*2000and *SSIS *2005/2008. · Proficient in implementing all transformations available on the * SSIS* toolbox. · Good experience in Designing* Aggregations* and pre-calculating in SSAS 2005 and 2008. · Excellent experience in *Designing*, *Processing* and * Partitioning* *cubes*, and knowledge of *Data mining.* · Excellent hands on experience in* *creating* measures, KPI’s *as well as defining Actions, translations and perspectives. · Excellent hands on experience deploying SSAS Objects* *using* *deployment wizard* *or using* *Synchronize database wizard*.* · Excellent hand on experience in creating* report model* on *SSAS cubes*, as well as changing default configuration on existing cubes. · Expert in working with *MDX Queries.* · Expertise in report generation using SQL Server Reporting Services (*SSRS*). · Outstanding knowledge in creating *drill down reports*, *ad-hoc reports* and *drill through reports* using the *ROLAP *as a source*.* · Experience in converting *Actuate* reports into SSRS. · Excellent* *hands on experience *scheduling *and the* deployment *of the* reports* and *uploading* files to a *report server* *catalog *from the *report manger.* · Experience in deploying reports on Microsoft Office SharePoint Server (*MOSS*). · Excellent skills in Microsoft SQL Server 2008/2005/2000 backend programming*.* · Excellent skills in using Client/Server architecture in implementing MS SQL Server based application. · Excellent organization skills, goal-oriented, with great* *communication skills*.* · Outstanding analytical, troubleshooting Skill.** *Technical Skills:* Languages : T-SQL, C++, VB.Net 2005, HTML, VBscript. Operating Systems : Windows 98/2000/2003/XP/Vista, Win 2000/2003 Server. Database : SQL Server 2008, 2005, 2000. Database Tools :* *SQL Server Enterprise Manager, SQL Profiler, SQLQuery Analyzer, index Tuning Wizard, BCP, DTS Import/Export, SQL Agents, SQLAlerts, SQL Jobs, SQL Mail, SQL Server Management Studio, SQL Server Integration Services [SSIS]. BI Tools : SSBI Development Studio, SSAS / SSIS / SSRS 2008 and 2005. Others : ER-Win, MS Office, MS Visio, Crystal Report. Thanks Durgesh shroti Urooj corporation --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Open Source Erp & Crm" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/open-source-erp-crm -~----------~----~----~----~------~----~------~--~---
