Description
SUMMARY: * Over 2+ years of IT experience in Design, Development & Administration of Business Intelligence Solutions with Microsoft SQL Server 2012/2008R2/2008/2005/2000. * Good experience with .Net Framework (2.0/3.0/3.5/4.0), ASP.Net, VB.Net, C#, ADO.Net, XML, XHTML, DHTML, Java Script, CSS, HTML, VB Script, Visual Studio, Active Server Pages (ASP.NET), IIS, Web Services. * Good experience in Information Technology field as a SQL Server Developer with strong expertise in SQL Server Development, Designing Stored Procedures/Transact-SQL Coding. * Hands on Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2012/2008R2/2008/2005/2000. * Knowledge in creating complex Stored Procedures, User Defined Functions, and effective Triggers to facilitate efficient data manipulation and data integrity * Efficient in creating Sub-Queries and Joins for complex queries involving multiple tables. * Worked with T-SQL, DDL, and DML Scripts and established relationships between tables using Primary Keys and Foreign Keys. * Knowledge in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS), OLAP and OLTP. * Worked on Performance Tuning, Query Optimization, Client/Server Connectivity, and running Database Consistency Checks using DBCC Utilities. * Experience in performance tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations. * Excellent hands on experience in creating groups, hierarchies, measures, KPIs and in creating MDX cubes, dimensions using SSAS. * Worked with end users/business analysts to understand business requirements, recommended technical solutions and documented functional requirements. * Good understanding of Relational Database Management Systems (RDBMS), Normalization, Multi-Dimensional (Star) and Snowflake logical and physical data modeling. * Highly skilled and experienced in agile development process for diverse requirements. * Strong analytical and problem solving skills. * Worked on different operating systems and platform of software and application development. * An effective communicator with exceptional relationship management skills with the ability to relate to people at any level of business and management. * Extensive Knowledge in MS SQL Server configuration manager, performance tuning, SQL Profiler, client/server connectivity, query optimization, back-up/recovery.
Accomplishments
Highlights:
Keywords
