SUMMARY:

• Over 7 Years of experience in Client/Server and Web Application and Windows Applications development using Microsoft Technologies and .NET Framework.
• Strong skills on .NET Framework using ASP.NET, C#, SQL Server
• Strong skills on SQL Development, SSIS, SSRS, SSAS
• Solid experience in creating CSS 3 (Cascading Style Sheets), Themes and Skins.
• Excellent understanding of Object Oriented Programming Methodology in the IT industry.
• Highly Proficient in designing queries in accessing data and hands - on experience in query structuring, performance optimization using SQL Server 2005/2008/2012/2014.
• Strong in Web Technologies like JavaScript, Web Services, HTML5, XML, XML Schemas, CSS 3, MVC4.
• Good experience in developing desktop applications using Windows Forms.
• Good understanding of Normalization, De-normalization and Database design methodology.
• Experienced in handling data efficiently in OLTP/OLAP and Data warehousing environment.
• Strong SQL Server 2000/2005/2008 developer skills including writing Stored Procedures, User Defined Functions, Triggers, Views and Indexes.
• Good knowledge on automating the system by using notification service and creating alerts, jobs and maintenance plans.
• Experienced in Troubleshooting, Query Optimization, Performance tuning of stored procedures.
• Proficient in scheduling and creating reports using SQL Server Agent.
• Experienced in front end technologies HTML and HTML5, JavaScript, CSS3, jQuery.

TECHNICAL SKILLS:

• Microsoft SQL Server 2005/2008/2008- R2/2012
• SQL Server Business Intelligence Development Studio(BIDS)
• SQL Server Analysis Services (SSAS)
• SQL Server Integration Services (SSIS)
• SQL Server Reporting Services (SSRS)
• VB6
• VB.Net
• Oracle 8i/9i/10g/11g
• MySQL
• C
• C++
• C#
• MS-Access
• MS-Excel
• SQL
• T-SQL
• HTML
• DHTML
• ASP
• ASP.NET
• VB
• VB.NET
• XML
• MS Visual Studio 2005/2008
• 2010
• Crystal Reports
• DTS
• SQL Profiler
• MS Visio
• SharePoint
• UNIX
• DTS
• CCS3
• HTML5.

PROFESSIONAL EXPERIENCE:

Confidential, Arkansas

Software Developer

Responsibilities:

• Involve in enhancement and maintenance of .NET applications. designed various databases for DHS applications.
• Wrote Complex stored procedure, Triggers, Views, Constraints and rules on database objects.
• Analyzed, designed and provided Ad-hoc, standard and executive summary reporting services (SSRS) for internal use and client presentation.
• Optimized SQL statements for customer summary reports to improve the performance of long running Reports.
• Involved in performing Full Back up, Recovery and Restoration of the test and Development server databases.
• Involve in front end technologies HTML and HTML5, JavaScript, CSS3, jQuery

Environment:: MS SQL Server 2012 R2/2014, Integration Services (SSIS), Analysis Services (SSAS) Reporting Services (SSRS), BIDS, Visual Studio 2013, MS Visio 2007, Windows Server 2008, ASP.Net, C#,VBA, Oracle database. DTS.

Confidential, Long Island, New York

.NET Developer

Responsibilities:

• Gathered Requirements from the end users and created the front end and backup databases.
• Developed and Maintained Applications by using C# and ASP.net.
• Created Multidimensional cubes and reports from Data Warehouse.
• Involved in upgrading and maintaining MS SQL Server 2008R2 and migration of databases from SQL Server 2008 to SQL Server 2012.
• Used Joins, correlated and non- correlated sub-queries for complex business queries involving multiple tables from different databases.
• Wrote Complex stored procedure, Triggers, Views, Constraints and rules on database objects.
• Optimized SQL statements for customer summary reports to improve the performance of long running Reports.

Environment:: MS SQL Server 2008 R2/2014, Integration Services (SSIS), Analysis Services (SSAS) Reporting Services (SSRS), BIDS, Visual Studio 2008, MS Visio 2007, Windows Server 2008, ASP.Net, C#,VBA, Oracle database. DTS.

Confidential, Phoenix, Arizona

.NET /BI Developer

Responsibilities:

• Involved in designing and troubleshooting .NET applications
• Gathered Requirements from the end user and created the structure of the schema and data for database tables.
• Involved in upgrading and maintaining MS SQL Server 2008R2 and migration of databases from SQL Server 2008 to SQL Server 2014.
• Used Joins, correlated and non- correlated sub-queries for complex business queries involving multiple tables from different databases.
• Involved in job scheduling using MS SQL server agent.
• Diagnosing and tuning the server optimal performance using SQL Server 2014 SQL Profiler and Database Engine Tuning Wizards.
• Involved in front end developer by using HTML and HTML5, JavaScript, CSS, jQuery,

Environment:: MS SQL Server 2008 R2/2014, Integration Services (SSIS), Analysis Services (SSAS) Reporting Services (SSRS), BIDS, Visual Studio 2008, MS Visio 2007, Windows Server 2008, ASP.Net, C#, MS Access, UNIX, VBA, VB6, Oracle database. DTS.

Confidential, Florida

.Net Developer

Responsibilities:

• Involved in upgrading and maintaining .Net Applications and MS SQL Server
• Analyzed, designed and provided Ad-hoc, standard and executive summary reporting services (SSRS) for internal use and client presentation.
• Responsible for the deployment of the reports on the Reporting services website and implementation of Subscriptions.
• Optimized SQL statements for customer summary reports to improve the performance of long running Reports.
• Involved in job scheduling using MS SQL server agent.
• Involved in front end applications to support and maintenance by using HTML and HTML5, JavaScript, CSS3, jQuery.
• Involved in performing Full Back up, Recovery and Restoration of the test and Development server databases.

Environment:: MS SQL Server 2008 R2/2012, Integration Services (SSIS), Analysis Services (SSAS) Reporting Services (SSRS), BIDS, Visual Studio 2008, MS Visio 2007, Windows Server 2008, ASP.Net, C#, HTML, CSS3, XML.