SUMMARY

• Goal oriented professional with around 11 years of experience in Information Technology.
• 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.
• Functional domain experience involves Financial and Health care.
• Expertise in developing Web applications, Windows applications, WPF applications, WCF applications in Microsoft Visual Studio (2012/2010/2008/2005/2003 ) using C#.Net, VB.Net, ASP.Net, ADO.net, MVC, SQL Server, SSIS,SSRS and SSAS.
• Expertise in developing applications using MVC 5.0/4.0/3.0 architecture.
• Expertise in writing LINQ, LAMBDA expressions, JQuery, JSON, Angular JS, CSS, HTML, HTML5, AJAX and Java Script.
• Expertise in Entity Frame Work and creating Extension Methods in C#.Net.
• Expert in developing SOA based web services and WCF services.
• Expert in developing Microsoft BizTalk Server applications using Microsoft BizTalk Server 2009/2010/2013.
• Proficient in defining business process with BizTalk orchestration.
• Extensive experience on BizTalk adapters, Pipelines, Maps, Custom Pipelines, File Assemblers/ Disassemblers, Schema Editor etc.
• Expert in integrating applications using BizTalk Server (2009/2010/2013 ).
• Proficient in Web Services, XML, XPath, XML Schema, CSS, HTML, AJAX, Java Script and JQuery.
• Worked extensively with Data Adapter, Dataset, Data reader as a part of ADO.NET to access and update database.
• Expert in using Team Foundation Server (TFS).
• 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.
• Expert in creating User defined table types which are new with SQL SERVER 2008 and used them in the .net applications to pass multiple rows of data in a single call to database.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel workbooks to SQL Server 2008.
• 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 using Checkpoint File to re-run the package, Transaction Options and Bulk Copy Program (BCP).
• Experienced in writing Parameterized queries for generating Tabular, Matrix, Chart reports, Formatting report layout, sub reports using Global Variables, Expressions, Functions (Custom Coding), Sorting the data, defining data source and subtotals for the reports using SSRS 2008.
• Expert in developing Reports like Standard parameter Reports, cascading parameter Reports using SSRS.
• Experienced in defining Query for generating drill down reports in SSRS and deploying.
• Good knowledge in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS). Expertise includes FACT & Dimension Tables.
• 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.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Knowledge in health care EDI formats and HIPPA (Ex:837P).
• Possess excellent communication and problem solving skills.
• Effective in working independently and collaboratively in teams.

TECHNICAL SKILLS

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

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

Databases: Oracle 8i, Sql Server 2000, 2005, 2008 and 2008R2.

Scripting Technologies: JavaScript, VB script, JQuery, Angular JS, AJAX.

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

Web Technologies: HTML, HTML5, CSS, CSS3, ASP, ASP.NET, XML, Schemas and Web services.

Application Servers: IIS 7.0/6.0

Version Control: Visual Source Safe, Tortoise SVN, Team Foundation Server (TFS)

Reporting Tools: Crystal Reports, SSRS

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

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

Environment: ASP.Net MVC 4.0(C# RAZOR), Entity Framework, LINQ, JQUERY, AJAX, JSON, WCF, WPF, Sql server 2008R2, BIDS 2008,BIZTALK Server 2013.

Senior Lead Developer

Responsibilities:

• Involved in the development (re-engineering) of all 3 applications from VBA to ASP.NET MVC (C#) with sql server 2008 as backend.
• Written views with RAZOR syntax for automatic encoding of output of view.
• Developed required Models, Views and Controllers as per functional flow of the application.
• Extensively written LINQ queries and Lambda expressions to query the database tables and .net objects.
• Implemented MVC AJAX as well as JQUERY AJAX for partial page updates.
• Used Entity Framework to generate Data Access classes from the database.
• Developed Extension Methods as and when required.
• Developed SOA based SOAP WCF services (Windows Communication Foundation).
• Written JQuery in views for client side events, validations and styling.
• Used Biztalk server 2013 to connect to SFTP server through SFTP adapter to download files from SFTP server.
• Developed one of the applications using WPF.
• Created stored procedures, scripts, views and triggers in database.
• Created User defined table types which are new with SQL SERVER 2008 and used them in the .net applications to pass multiple rows of data in a single call to database.
• Fine-tuned complex SQL queries and stored procedures to increase performance.
• Generated multiple Enterprise reports (SSRS/Crystal) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, 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, Cascaded Parameterized Reports and Interactive reports according to business requirements in time restricted environment.
• Analyzed database performance with SQL Profiler and Optimized indexes to improve query performance.
• Created and deployed SSIS packages and scheduled using SQL server agent.
• Done the code reviews maintained the version control and documentation.
• Source code management has been done through Team Foundation Server (TFS).
• Involved in various phases of testing like Unit testing, IUT and UAT.
• Worked with Business Analysts and Users to understand the requirement.
• Involved in production support as one of the key members.

Confidential, Tampa, Florida

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

Senior Lead Developer/Sr. C# .Net Developer

Responsibilities:

• Involved in development 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 Team Foundation Server (TFS). application.
• Developed SOAP WCF (Windows Communication Foundation) services.
• 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.

Confidential

Environment: .ASP.Net (C#) 3.5, BizTalk Server 2009, Sql server 2008.

Senior .Net Developer

Responsibilities:

• Involved in development of the important module “CCD creation”.
• Design, develop, document, test and deploy Biztalk artifacts to Integration, test and production environment.
• Wrote C#.Net modules to be called from BizTalk.
• Deployed the BizTalk applications on the production server after creating the application as MSI files.
• Actively worked with BizTalk Rules Engine.
• BizTalk development involved creating Schemas, Maps, Orchestrations and Configurations of various Adapters, Custom components in C#.Net.
• Configuration of BizTalk Adapters, deployment and production roll out.
• Involved in exporting MSI packages to test and production environments.
• Involved in understanding the API given by user in order to store data in Diversinet Vault.
• Have worked on CCR, CCD and HL7 formats to thoroughly understand the layout and sections of formats.
• Created wallets and cards to store in Diversinet Vault with data fetched from different file formats.
• Worked extensively on XML and XML schemas to generate CCD format.
• Involved in client meeting to thoroughly understand the business requirements.
• Worked on BizTalk server and Web Services to accomplish various tasks.
• Have gone through complete API given by Diversinet to better use of methods.
• Involved in developing the Biz Talk application for picking up files from FTP and calling web service from Biz Talk application.
• Involved in in Bug fixing and Unit Testing.

Confidential

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

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 meeting 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.

Confidential

Environment: .ASP.Net (VB) 2.0, Sql server 2005, XML, JavaScript, Crystal Reports.

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, try catch blocks in order to achieve consistency in data.
• Involved in in Bug fixing and production support.

Confidential

Environment: .ASP.Net (C#) 2.0, Sql server 2000, JavaScript.

C# .Net Developer

Responsibilities:

• Involved in development of some of the forms and writing stored procedures and JavaScript.
• Involved in the complete Software Development Life Cycle including Analysis, Design, Implementation, Testing and Maintenance.
• Written HTML for screen design.
• Involved in writing JavaScript for client side validations.
• Written SQL statements using joins, sub queries and correlated sub queries and Query expression.
• Created indexes, constraints and rules on database objects.
• Involved in writing test cases.
• Involved in unit testing and Bug fixing.

Confidential

Environment: .ASP.Net (C#) 2.0, Sql server 2000, JavaScript.

Jr. Developer

Responsibilities:

• Involved in design and development of some of the forms and writing stored procedures and JavaScript.
• Created indexes, constraints and rules on database objects.
• Involved in the complete Software Development Life Cycle including Analysis, Design, Implementation, Testing and Maintenance.
• Written SQL statements using joins, sub queries and correlated sub queries.
• Involved in writing JavaScript for client side validations.
• Written HTML for screen design.
• Involved in writing test cases.
• Involved in unit testing and Bug fixing.