SUMMARY

• Goal oriented professional with around 10 years of experience in Information Technology.
• Functional domain experience involves Financial and Health care.
• Expertise in developing WPF applications, WCF applications, Web applications, Windows applications, in Microsoft Visual Studio (2012/2010/2008/2005 ) using C#.Net, VB.Net, ASP.Net, ADO.net, MVVM, SQL Server.
• Expertise in developing applications using MVVM architecture.
• Expertise in writing LINQ, LAMBDA expressions, Extension Methods in C#.net.
• Expertise in LINQ to SQL and Entity Framework in C#.Net.
• Expert in developing WCF services and web services.
• Proficient in Web Services, XML, XPath, XML Schema, CSS, HTML, AJAX and Java Script.
• Worked extensively with Data Adapter, Dataset, Data reader as a part of ADO.NET to access and update database.
• Expert in using Tortoise SVN.
• Extensive experience in SQL Server Database design, Database maintenance, developing T - SQL queries, stored procedures, Views and triggers using SQL Server 2000, 2005 and 2008.
• Created SSIS Packages using SSIS Designer to import Flat File data into OLEDB(SQL server), Sending files to SFTP using Script Task etc.
• Thorough Knowledge of Various SSIS Objects such as Control Flow Elements like Dataflow Tasks, Containers and Maintenance Tasks and Dataflow components like Dataflow Sources, Dataflow Transformations, Dataflow Destinations, Connections Managers, Exception Handling etc.
• Expert in Analyzing Query Plans, Managing Indexes and Locks, Troubleshooting Deadlocks.
• Expert in MS SQL Server performance tuning, query optimization, Normalization /De-normalization and database design methodology.
• Strong Applications Development experience with back-end databases such as SQL Server, Oracle and MS Access using ADO/ADO.NET, OLEDB, ODBC and SQL client.
• Extensive experience in all phases of Software Development Life Cycle (SDLC) involving requirement analysis, design, development of client/server, web based and n-tier application.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Possess excellent communication and problem solving skills.
• Effective in working independently and collaboratively in teams.
• Effectively used Autosys jobs and SFTP servers.

TECHNICAL SKILLS

Microsoft Technologies: WPF, ASP.NET, C#.NET, VB.NET, ADO.NET (1.1 to 4.0)MVVM, LINQ, Entity Framework, WCF.

Programming Languages: C#.net, VB.net and T-SQL.

Databases: SQL Server 2000, 2005, 2008 and 2008R2.

Scripting Technologies: JavaScript, VB script, AJAX.

Operating systems: Windows 2000, Windows XP, Professional and Windows7.

Web Technologies: ASP.NET, XML, Schemas and Web services

Application Servers: IIS 7.0/6.0

Version Control: Visual Source Safe, Tortoise SVNReporting Tools Crystal Reports, SSRS

SQL Server Tools: Enterprise Manager, Profiler, SSIS, SSRS.

Other Tools: Autosys and SFTP server.

PROFESSIONAL EXPERIENCE

Confidential, NY

Senior C# .NET Developer

Responsibilities:

• Involved in the development of all 3 applications in WPF MVVM (C#) with sql server 2008 as backend.
• Developed required Models, Views and ViewModels as per functional flow of the application.
• Extensively written LINQ queries and Lambda expressions to query the database tables and .net objects.
• Used Entity Framework to generate Data Access classes from the database.
• Developed Extension Methods as and when required.
• Created stored procedures, scripts, views and triggers in database.
• Fine-tuned complex SQL queries and stored procedures to increase performance.
• Generated multiple Enterprise reports in SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, sub-reports, navigation reports (Hyperlink) etc.
• Developed Chart Reports as per the requirement.
• Rendered the SSRS reports in the form PDF, Excel and CSV formats as per the client requirements.
• Generated and deployed different kind reports, like Tabular reports, Matrix reports, List & Chart Reports, Parameterized Reports, Sub Reports according to business requirements in time restricted environment.
• Developed SOAP WCF (Windows Communication Foundation) services.
• Analyzed database performance with SQL Profiler and Optimized indexes to improve query performance.
• Created and deployed SSIS packages to extract data from Flat File to SQL server, Copying files from source to backup and processing folders, sending Email alerts and populated data from MFDS to FEDS databases and scheduled using SQL server agent.
• Done the code reviews maintained the version control and documentation.
• Source code management has been done through SVN.
• Involved in various phases of testing like Unit testing, IUT and UAT.
• Worked with Business Analysts and Users to understand the requirement.

Environment: WPF 4.0, MVVM, C#.net, WCF, EF 4.0, SQL server 2008R2, SSIS, SSRS, Autosys, SFTP.

Confidential

Senior C# .Net Developer

Responsibilities:

• Involved in development and fixing the production issues of the important module “Accounting” which facilitates user to view accounting entries generated for each client. Users can edit the entries, split the entries or provide a different FX Rate to generate new set of entries.
• Involved in the complete Software Development Life Cycle including Analysis, Design, Implementation, Testing and Maintenance.
• Implemented AJAX like concepts for partial post back of the web page.
• Implemented java script functions to validate basic data at client side rather than at server side.
• Implemented proper event handlers and error handling using try catch blocks.
• Creating Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Performing query plans and making sure each and every query is using appropriate useful Indexes.
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Source code management has been done through VSS application.
• Provided technical support to internal developers and external clients.
• Preparing the Test Plan and Test Scenarios Document.
• Done the code reviews maintained the version control and documentation.
• Involved in in Bug fixing and Unit Testing.

Environment: ASP.Net (C#) 2.0, LINQ to SQL, Web Services, Sql server 2008, Crystal Reports.

Confidential

Senior .Net Developer

Responsibilities:

• Developed tools like upload Excel data to data base, dynamic HTML reports design, generating XML templates for mail sending and Excel upload.
• Involved in designing of Crystal Reports as per requirement for inventory module.
• Involved in writing AJAX where ever required.
• Involved in writing code for merging multiple PDFs to single PDF, multiple text files to single text file, Zipping and Unzipping etc.
• Implemented proper event handlers and error handling using try catch blocks of .NET frame work.
• Written complex SQL statements using joins, sub queries and correlated sub queries and Query expression.
• Written HTML for screen design.
• Implemented the concept of Master Pages.
• Fine-tuned complex SQL queries and stored procedures to increase performance.
• Maintained versioning of the application using VSS.
• Extensively used enterprise manager, query analyzer, and SQL Server profiler to create custom and standard reports using crystal reports.
• Have worked with SQL transactions and used try catch blocks in order to achieve consistency in data.
• Involved in in Bug fixing and production support.
• Designed Crystal Reports.
• Involved in in Bug fixing and Unit Testing.

Environment: ASP.Net (C#) 2.0, Sql server 2005, AJAX, Crystal Reports.

Confidential

Senior .Net Developer

Responsibilities:

• Involved in development of the important module “EDI file generation”.
• Involved in the complete Software Development Life Cycle including Analysis, Design, Implementation, Testing and Maintenance.
• Written complex SQL statements using joins, sub queries and correlated sub queries and Query expression.
• Implemented constraints on tables.
• Involved in developing the enhancements which include dual and single monitor facility.
• Involved in client meetings to thoroughly understand the business requirements.
• Done the code reviews maintained the version control and documentation.
• Implemented AJAX like concepts for partial post back of the web page.
• Involved in in Bug fixing and production support.

Environment: ASP.Net (VB) 2.0, Sql Server 2005

Confidential

C# .Net Developer

Responsibilities:

• Involved in development of DTOs (VB classes) to transfer user data from UI to Business to DAL which replaces parameters passing method.
• Involved in writing JavaScript for client side validations where ever required and SQL stored procedures and views.
• Involved in designing of Crystal Reports as per requirement for inventory module.
• Involved in writing AJAX where ever required.
• Involved in writing code for merging multiple PDFs to single PDF, multiple text files to single text file, Zipping and Unzipping etc.
• Implemented proper event handlers and error handling using try catch blocks of .NET frame work.
• Written complex SQL statements using joins, sub queries and correlated sub queries and Query expression.
• Written HTML for screen design.
• Implemented the concept of Master Pages.
• Fine-tuned complex SQL queries and stored procedures to increase performance.
• Maintained versioning of the application using VSS.
• Extensively used enterprise manager, query analyzer, and SQL Server profiler to create custom and standard reports using crystal reports.
• Have worked with SQL transactions and used try catch blocks in order to achieve consistency in data.
• Involved in in Bug fixing and production support.

Environment: ASP.net, C#.net, Microsoft Project Server, Sql server 2005.