PROFESSIONAL SUMMARY

• 6.6 years of working experience in software development using .Net and MS SQL Server.
• 5+ years of experience in C#.NET and T - SQL.
• 1 + years of working experience in Web Application development using Asp.Net and C#.
• 2+ Year working experience in desktop application development using C#
• 2 Years of development experience in SSIS and Performance point Server.
• 5+ years of experience in OO programming, analysis and design
• Knowledge in Design patterns
• Extensive experience in using C#, T-SQL (including dynamic SQL) in SQL Server 2008/2005/2000 platforms.
• Expert in MS SQL Server suite of products like SQL Server Integration Services.
• Experienced in working with websites development in ASP.NET.
• Reviewed, analyzed, and modified programming systems including encoding, testing, debugging and installing to support an organization's client/server software applications.
• Expert in defining data source and building data source views and recognizing fact and dimension tables.
• Experienced in data loads, database integration/conversions, performance tuning and optimization.
• Well-versed with database Installation, configuration, maintenance, monitoring, backups and recoveries, develop and debug Stored Procedures and Triggers.
• Capable of forming and maintaining positive and productive working relationships in internal, external and team environments.
• Excellent oral and written communication skills, quick learner, can adapt to a new technology with ability to take new roles in minimum time

TECHNICAL SKILLS

Languages: C#, T-SQL

Web Technologies: ASP.Net1.1, ASP.Net2.0, HTML, WCF, ADO.Net

Scripting Languages: JavaScript

Source control: VSS, TFS

Tools: VS2003,VS2005,VS2008,VS2010

Operating Systems: Windows2000/2003Server, Windows 2007

Database: MS SQL SERVER2000/2005/2008

SOA: WCF

Others: ADO.Net, XML, OOPS, LINQ

Frameworks: .Net1.1, .Net2.0, .Net3.0, .Net3.5, .Net 4.0

Design Patterns: FACADE, Factory, Strategy, Abstract Factory, Singleton

PROFESSIONAL EXPERIENCE

Confidential, Redmond, WA

Responsibilities:

• Utilized dynamic T-SQL within functions, stored procedures, views, and tables.
• Heavily involved in working with dynamic SQL by concatenating the strings with char (39) which executes various store procedures and update statements one after another.
• Created numerous simple to complex queries involving self joins, correlated sub queries as per business requirements. Tuned and optimized queries by altering the database design, analyzing different query options, and indexing strategies.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Employed the Database Engine Tuning Advisor to analyze the performance effects of workloads and implemented its recommendations wherever appropriate.
• Performed data validation checks during Staging, before loading the data into the Data warehouse.
• Implemented business rules using constraints like Check, Primary Key, and Foreign Key on tables.
• Created views, indexes and stored procedures to improve the process of data retrieval. Verified the execution plan and used the SQL Server profiler to improve performance of the database.
• Worked creating on unit test framework for the application.

Technology: MS SQL server 2005, C#, Visual Studio 2005, Microsoft Business Intelligence 2005, Performance point Server 2007

Developer

Confidential, Redmond, WA

Responsibilities:

• Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files.
• Configured SQL mail agent for sending mails upon package deployment.
• Also created several event handlers to send alerts, success messages, and error messages and implemented detailed logging.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data cleansing and aggregating the required data.
• Participated in testing and verification of the entire database/data warehouse system after migration.
• Developed dimensions and fact tables based upon the requirements and based on these facts and dimensions, designed SSAS cubes
• Reviewed the architecture of the data warehouse for preserving data accuracy and integrity and used to investigate a lot on Data Discrepancies.
• Involved creating detailed documentation for the migration, creation of data warehouse and all other tasks.
• Worked on developing the websites for internal purpose of application in ASP.NET.
• Unit test case creation and execution.
• Regression testing Bug fixing.

Developer

Technology: MS SQL server 2005, C#

Responsibilities:

• Responsible for documenting design, providing estimates, programming specifications, performing unit and systems testing, and recording test results.
• Developed, tested and implemented Referential Integrity rules and regulations through constraints and normalization of the transactional database system.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Unit test case creation and execution.
• Regression testing
• Bug fixing.

Developer

Technology: MS SQL server 2005, C#.NET, ASP.NET, JavaScript, TSQL

Responsibilities:

• Responsible for documenting design, providing estimates, programming specifications, performing unit and systems testing, and recording test results.
• Developed, tested and implemented Referential Integrity rules and regulations through constraints and normalization of the transactional database system.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Unit test case creation and execution.
• Regression testing and bug fixing.