Send me your requriement at [email protected] · Microsoft Certified Technology Specialist (*MCTS*)-SQL Server
· 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. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Visa Transfer OPT, CPT, PT, H1,H4" 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/paul_talluri?hl=en -~----------~----~----~----~------~----~------~--~---
