Koteswararao C.

Over 4 years of experience as a MS SQL Server Developer/Architect in various industries such as IT, Finance, Insurance. Proficient in MS SQL Server 2005/2008/2008R2, Business Intelligence using MS SQL Server Integration Services(SSIS), MS SQL Server Reporting Services(SSRS), and MS SQL Server Analysis Services(SSAS). Expert in migration of databases from older versions of SQL Server (2005) to SQL Server 2008/2008R2. Experience with installation & configuration of SQL server 2005/2008/2008R2, Reporting Services (SSRS). Integrated and transformed data from different data sources like Oracle, DB2, Excel, and Flat Files to SQL Server 2008R2 using OLE DB connection providers by creating various SSIS packages. Performed several transformations and data cleansing on data including fuzzy lookup, slowly changing dimension, union all, merge join and check points/break points. Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Index, Views, User Functions, SQL joins, Relational Database Systems following Data Integrity and normalization Proficient in database and data warehouse design and developing ER diagrams logical and physical data modeling and Dimensional Data Models using Erwin tool ,Visio and Eclipse. Expertise in Developing and Extending SSAS Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries. Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel PowerPivot table based on OLAP cubes. Adept in creating ad-hoc, drill-down, sub-Report, parameterized, cascading parameterized, drill-through, chart, tabular, matrix reports. Experience in configuring report manager for creating report subscriptions, snapshots, and caching. Excellent experience in Designing, Maintaining & Tuning various RDBMS like SQL server 2000/2005/2008/2008 R2, MS Access databases and strong knowledge of SDLC principles. Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance. Expert in database creation, maintenance, monitoring, backups and recoveries using SQL Server Agent, Import/Export Wizard and Maintenance Plans.