SUMMARY:

• 8 years of combined experience in SQL development along with Software Development using .NET & C#, Web development, Windows application development, Database technologies; Object oriented programming, System Analysis, and Design.
• Experience in Creating SQL database, performed monitoring and restoring of SQL database.
• Good in - depth understanding and experience in RDBMS Database Design and Developed Constraints, Join, Views and Triggers in SQL Server 2012/2008R 2/2008/2005. Including Writing Views, Stored Procedures, Functions, Cursors, and Triggers for search and accessing data from various databases.
• Experience in generating the reports using SQL Server Reporting services (SSRS) and Crystal Reports and experience in SQL Server Integration Service (SSIS) and SQL Server Analysis Services (SSAS), MS Access.
• Updated older techniques of writing queries and database connectivity using Entity framework and LINQ.
• Integrate various sql databases to create a data ware house and applied ETL process and generated so many reports through SSRS.
• Performed SQL query performance tuning by creating and modifying indexes, setting transaction isolation level to avoid deadlocks situations.
• Used inline queries and CTE to replace complexities of sub queries and enhanced query execution time successfully .
• Pulled data across multiple database servers, connected data sources by SSIS.
• Performed ETL process to migrate data from multiple data sources to destination data server by creating packages.
• Solid experience in writing and maintaining PL/SQL scripts, tables, indexes, views, stored procedures, triggers and user defined functions in SQL Server.
• Experience in developing application Design pattern mostly in Singleton, Abstract Factory, Factory design pattern.
• Extensive experience in developing Internet applications using .NET Framework 2.0/3.0/ 3.5/4.0/4. 5 developing experience in C#, ASP.NET, MVC 4.0/5.0, VB.NET.
• Hands on experience in developing Multi-tier/N-Tier Architectures and implementing the concept of Object Oriented Programming (OOPS) Concepts including Interface, Inheritance, Abstraction, and Polymorphism.
• Experience in gathering customer requirements and functional requirements and converting them to technical requirements, applying OOAD concepts, Design Patterns.
• Experience in UML to design Interaction diagrams, sequence diagrams, use case diagrams in MS Visio etc.
• Proficient in creating multi-threaded applications in C# in different ways using thread pool, task parallel library, background worker, Begin Invoke.
• Good understanding of .net Collections (Arrays / Lists / Hash table), Generics.
• Experience in Microsoft Application building blocks for .NET projects (Data Access, Exception Handling, Caching, and Configuration Management Application Blocks).
• Experience in Dependency Injection using MVC Structure Map.
• Experience in using IIS server for Deployment of the application, monitored performance and supported production environment.
• Expertise in Building Single Page Application (SPA) using HTML5, CSS3, and Angular JS, ASP.NET MVC 5.x/4.x, ASP.NET, Web API 2.x, Entity Framework 6.x/5.x/4. x., Telerik.
• Worked on React JS framework to develop interactive websites based on client needs.
• Proficient in Creating, Consuming and Publishing XML Web Services (SOAP, WSDL, UDDI) using .NET Framework and Solid understanding of Service Oriented Architectures (SOA).
• Updated versions of older design techniques using CSS3 and HTML5 with JSON.
• Expert in Creating Entity classes, relationships between entity classes using LINQ (Language Integrated Query) to SQL to manage relational data as objects with Entity Framework.
• Experience in using tools like Database Engine Tuning Advisor, Index Tuning Wizard, and Windows Performance Monitor for Tuning SQL Server Performance.
• Good Experience in creating User Control in WPF for various project with rich UI components and XAML based UI development
• Developed Graphical User Interfaces using HTML, CSS, XAML, Java Script, AJAX and WPF.
• Extensively developed applications in Win Forms, Web Forms, MVC, and Single Page Application Architectural patterns.
• Performed unit testing and integrated testing for fixing the bugs, writing test cases, test plans and generating test scripts.
• Prepared Technical design document, Use cases, Test cases and User manuals for various projects and good at Bug fixing, Code reviews, and Unit & System testing.
• Migrate new systems or developed new versions of applications like perseguider version 3.0 to 4.0.
• Migrate a classic asp project to asp.net application, also migrate windows applications to web applications.
• Excellent trouble shooting skills using Chrome Development Tools.
• Expertise in Code reviews, Defined coding standards using .NET Technologies.
• Provide technical support and guidance to staff and clients.

TECHNICAL SKILLS:

Microsoft Technologies: ASP.NET 4.5,ASP.NET 4.0, ASP.NET 3.5, ASP.NET 2.0, C# .NET, ADO.NET, WCF, AJAX control tool kit, Microsoft reports

Tools: HTML, HTML 5, CSS, CSS3, XML, SSRS, LINQ to SQL, LINQ to XML, Design Patterns, MVC, Entity Framework

Languages: C#, VB, Core JAVA, C++, Classic ASP, T-SQL, PL/SQL, NoSQL

Scripting Languages: Java Script, VB Script, AJAX, CSS, CSS3, JSON(Java Script Object Notation), BSON, Angular 2 and 4.

Databases: SQL Server 2000, 2005, 2008, 2012,2014 MS-Access, MongoDB

Operating Systems: Windows 2000 Server/NT, XP

IDE Tools: VisualStudio 2013/2012/2010/2008/2005

Reporting Tools: Crystal Reports, SSIS, SSRS,ETL

Servers: IIS 6.0, IIS 7.0

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Senior SQL/.Net Developer

Responsibilities:

• Complete SDLC, which includes Requirements Gathering, Analysis, Design, Development, Implementation, Upgrade, Enhancements, Maintenance, Support and Bug Fixing. Responsible for writing code-behind business logic for C# win-form application.
• Designed Graphical User Interface (GUI) using Master Pages, Web Forms, HTML 5.0, JavaScript, Angular Js, CSS and Custom Controls, Themes. Used Control Templates for Customization.
• Experience in Agile development mythology and AJAX functionality to improve the responsiveness.
• Follow Agile Scrum methodology to implement application. Designed and Developed different modules, Class using C# and Designed GUI Part with help of .Net framework 4.5, ASP.Net, C#.Net, ADO.Net, XML, SQL Server 2014 and Visual Studio.Net 2013.
• Created Relational Database using Normalization, Implement Relationships between tables, Data table, Stored Procedure, View in SQL Server 2012.
• Created ASP.NET MVC architecture, ASP.NET Web Forms, LINQ queries and Windows Communication Foundation (WCF).
• Used JavaScript to enhance the dynamics and interactive features of web page by allowing user to perform calculations, Validate form inputs, add special effects, Customize selections, Confirmation, Used AJAX including JQuery library.
• Used JSON for exchanging data between a browser and the server.
• Worked with ASP.Net Web Forms and State Management, Caching features, securing the web application. Used Object oriented Programming (OOP) to make it more efficient .
• Used ADO.Net data objects such as Connection, Command, Data Adapter, Data Reader, Dataset, Data Table and XML for consistent access to SQL data sources.
• Responsible for writing the LINQ queries to process and retrieve the objects.
• Created Relational Database using Normalization, Implement Relationships between tables, Data table, Stored Procedure, View in SQL Server 2014.
• Used WCF Rest services for developing the services (cost calculation) and exposed those using SOAP & Http Protocols.
• Managed clustered and non-clustered indexes and implemented Relationships b/w tables.
• Created Pivot table and CTE common table expression for creating a user defined report view.
• Worked on SQL Server integration services (SSIS) and SQL Server Reporting Services (SSRS). migrated multiple databases and fetched huge data using SSIS packages and scheduled as jobs.
• Created the test scripts for the stored procedures using VS 2013.

Environment : Net Framework 4.5, C#, Asp.Net, ADO.Net, MSAjax.Net, WCF, XHTML, HTML 5.0, XML,T-SQL, SQL Server 2014, SSRS(SQL Server Reporting Services), SSIS (SQL Server Integration Services),Java Scripts, CSS, Web Services, IIS.

Confidential

Responsibilities:

• Implemented Agile Scrum methodology. Used software development life cycle (SDLC) for implementing application. Used .Net framework 4.0, ASP.Net, C#, ADO.Net, SQL server 2012 for creating different modules and GUI for application.
• Designed Graphical User Interface (GUI) using Master Pages, Web Forms, HTML 5.0, JavaScript, Angular Js, CSS and Custom Controls, Themes, AJAX controls. Used Control Templates for Customization.
• Used JavaScript to enhance the dynamics and interactive features of web page by allowing user to perform calculations, Validate form inputs, add special effects, Customize selections, Confirmation, Used AJAX including JQuery library.
• Used WCF for developing the services (Login Authentication) and exposed those using SOAP & Http Protocols.
• Used JSON variable and objects for exchanging data between a browser and the server and used JSON with java script.
• Worked with ASP.Net Web Forms and State Management, Caching features, securing the web application. Used Object oriented Programming (OOP) to make it more efficient.
• Used ADO.Net data objects such as Connection, Command, Data Adapter, Data Reader, Dataset, Data Table and XML for consistent access to SQL data sources.
• Created Relational Database using Normalization, Implement Relationships between tables, Data table, Stored Procedure, View in SQL Server 2012.
• Coding for various Modules, Error Handling, Modification and Testing, Bug solving of the change requests.
• Handled runtime and design time errors by implementing the appropriate error handlers in C#.Net. Resolved potential issues that arose during the execution of development.
• Created the data base tables, pre and post scripts for the deployments, Functions, Indexes, and SQL Server 2012.
• Created a Sql data-ware house that merge 4-5 sql databases, excel databases and access databases, Oracle databases. Created several SSRS reports by pulling data from huge ware house and created several agent jobs for pushing data from multiple sources to a big destination (SQL).
• Designed, developed and maintained relational databases.
• Gathered business requirements and converted it into SQL stored procedures for database specific projects
• Created files, views, tables and data sets to support the query optimization.
• Performed ETL (Extract, Transform and Load) and created many procedures to operate them.
• Managed data base performance using indexes (clustered and non-clustered) and database tuning.
• Created SSIS packages and scheduled job through SQL agents.
• Created multiple reports using SSRS and deployed.
• Maintained logs for each and every transaction in sql server.
• Researched and resolved data issues related to existing data and processes.

Environment: Net Framework 4.0, C#, Asp.Net, ADO.Net, MSAjax.Net, LINQ, WCF, XHTML, HTML 5.0, XML,T-SQL, SQL Server 2008/2012, ADO.Net Entity Framework, LINQ, SSRS(SQL Server Reporting Services), SSIS (SQL Server Integration Services),Java Scripts, CSS, Web Services

Confidential, New Jersey

Full stack Developer

Responsibilities:

• Complete SDLC, which includes Requirements Gathering, Analysis, Design, Development, Implementation, Upgrade, Enhancements, Maintenance, Support and Bug Fixing. Responsible for writing code-behind business logic for C# win-form application.
• This tool is completely understands the customers need and try to satisfy their requirements by providing them relevant products and services, and for future use it saves their data and their queries .
• Designed Graphical User Interface (GUI) using Master Pages, Web Forms, HTML 5.0, JavaScript, Angular Js 2 and 4, CSS and Custom Controls, Themes. Used Control Templates for Customization.
• Experience in Agile development mythology and AJAX functionality to improve the responsiveness.
• Follow Agile Scrum methodology to implement application. Designed and Developed different modules, Class using C# and Designed GUI Part with help of .Net framework 4.5, ASP.Net, C#.Net, ADO.Net, XML, SQL Server 2014 and Visual Studio.Net 2013.
• Created ASP.NET MVC architecture, ASP.NET Web Forms, LINQ queries and Windows Communication Foundation (WCF).
• Updated older forms, methods, technologies. Also updated designing part by updating css to css 3 HTML to HTML 5.
• Updated legacy technique of data connectivity or data pushing and pulling using entity framework and LINQ.
• Used JavaScript to enhance the dynamics and interactive features of web page by allowing user to perform calculations, Validate form inputs, add special effects, Customize selections, Confirmation, Used AJAX including JQuery library.
• Used JSON for exchanging data between a browser and the server.
• Worked with ASP.Net Web Forms and State Management, Caching features, securing the web application. Used Object oriented Programming (OOP) to make it more efficient.
• Used ADO.Net data objects such as Connection, Command, Data Adapter, Data Reader, Dataset, Data Table and XML for consistent access to SQL data sources.
• Responsible for writing the LINQ queries to process and retrieve the objects.
• Created Relational Database using Normalization, Implement Relationships between tables, Data table, Stored Procedure, View in SQL Server 2014.
• Used WCF Rest services for developing the services (cost calculation) and exposed those using SOAP & Http Protocols.
• Managed clustered and non-clustered indexes and implemented Relationships b/w tables.
• Created Pivot table and CTE common table expression for creating a user defined report view.
• Worked on SQL Server integration services (SSIS) and SQL Server Reporting Services (SSRS). migrated multiple databases and fetched huge data using SSIS packages and scheduled as jobs.
• Created the test scripts for the stored procedures using VS 2013.

Environment: Net Framework 4.5, C#, Asp.Net, ADO.Net, MSAjax.Net, WCF, XHTML, HTML 5.0, XML,T-SQL, SQL Server 2014, SSRS(SQL Server Reporting Services), SSIS (SQL Server Integration Services),Java Scripts, CSS, Web Services, IIS.

Confidential

Senior .Net Developer

Responsibilities:

• Involved in SDLC in whole project, in Analysis, design and coding part. Designed and Developed different modules, Class using C# and Designed GUI Part. Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#, the middle tier contained all the business logic.
• This tool contains forms that are created at run time according to user requirement. All controls like text boxes, buttons, grid view, dropdown, tables, and many more are auto generated.
• Developed dynamic ASPX web pages for Application using ASP.Net, C#.Net, XML, HTML and JavaScript. Developed the Web Application in ASP.Net 4.0 using Master Page, Themes & skins to maintain the consistent look and feel throughout the application.
• Used ADO.Net objects such as Data Reader, Dataset and Data Adapter for consistent access to SQL data sources.
• System design and development using MVC and design patterns, code review.
• This tool contains various reports, created by using SSRS reports and Microsoft reports as well with customized formatting to highlight important data as per requirement.
• Used JavaScript to enhance the dynamics and interactive features of web page by allowing user to perform calculations, Validate form inputs, Customize selections, Confirmation, Used AJAX including JQuery library.
• Implement java scripts for data validation and to perform edit check on the data. Participated in full development life-cycle using Object Oriented Programming (OOPS) concepts and agile. Used MS Enterprise Library to implement Caching, Data Access, Exception Handling, Security, Validation and Unity.
• Used WCF for developing the services (Login Authentication) and exposed those using SOAP & Http Protocols.
• Worked with ASP.Net Web Forms and State Management, Caching features, securing the web application. Used Object oriented Programming (OOP) to make it more efficient.
• Created interactive menus using HTML, CSS and java scripts.
• Error Handling at run time, coding for time to time Modification and Testing.
• Handled runtime and design time errors by implementing the appropriate error handlers in C#.Net. Resolved potential issues that arose during the execution of development.
• Designed and created Relational database tables using Normalization, Managed clustered and non-clustered indexes and implemented Relationships b/w tables.
• Writing and maintaining PL/SQL scripts, tables, views, stored procedures, triggers and user defined functions in SQL Server 2008.
• Maintained track of each operation on data (Insertion/deletion/any update).

Environment: Net Framework 4.0, C#, Asp.Net, ADO.Net, MSAjax.Net, LINQ, WPF, WCF, XHTML, HTML 5.0, XML,T-SQL, SQL Server 2008, ADO.Net Entity Framework, LINQ, Microsoft Reporting, Java Scripts, CSS,CSS 3, Web Services, IIS.

Confidential

Responsibilities:

• Designed and Developed different modules, Class using C# and Designed GUI Part with help of .Net framework 4.0, ASP.Net, C#.Net, ADO.Net, XML, XSD, SQL Server 2008 and Visual Studio.Net 2010.
• Designed, modeled multi-threaded, enterprise n-tier software agent using WCF web service hosted in a Windows service.
• Creating the technical specification documents and class diagrams by understanding the business and functional specification documents.
• Developed application using ASP.NET MVC Framework, LINQ queries and Windows Communication Foundation (WCF).
• Developed dynamic ASPX web pages for Application using ASP.Net, C#.Net, HTML.
• Used different Telerik Controls.
• Used Cascading Style Sheet (CSS) to attain uniformity through all the pages.
• Used JavaScript to enhance the dynamics and interactive features of web page by allowing user to perform calculations, Validate form inputs, add special effects, Customize selections, Confirmation, Used AJAX including JQuery library.
• Implement classes for data validation and to perform edit check on the data. Participated in full development life-cycle using Object Oriented Programming (OOPS) concepts and agile. Used MS Enterprise Library to implement Caching, Data Access, Exception Handling, Security, Validation and Unity.
• Created a service to Fetch Outlook mails into our application, categories mails, and maintained those TAT, and generates reports according to them using c#.
• Used WCF for developing the services (Login Authentication) and exposed those using SOAP & Http Protocols.
• Worked with ASP.Net Web Forms and State Management, Caching features, securing the web application. Used Object oriented Programming (OOP) to make it more efficient.
• Used ADO.Net data objects such as Connection, Command, Data Adapter, Data Reader, Dataset, Data Table and XML for consistent access to SQL data sources.
• Coding for various Modules, Error Handling, Modification and Testing, Bug solving of the change requests.
• Handled runtime and design time errors by implementing the appropriate error handlers in C#.Net. Resolved potential issues that arose during the execution of development.
• Writing and maintaining PL/SQL scripts, tables, indexes, views, stored procedures, triggers and user defined functions in SQL Server 2008.

Environment: Net Framework 4.0, C#, Asp.Net, ADO.Net, MSAjax.Net, LINQ,WPF, WCF, XHTML, HTML, HTML 5.0, XML,T-SQL, SQL Server 2005, ADO.Net Entity Framework, LINQ, Microsoft Reporting, Java Scripts, CSS,CSS 3, Web Services, IIS.

Confidential

Responsibilities:

• Complete SDLC, which includes Requirements Gathering, Analysis, Design, Development, Implementation, Upgrade, Enhancements, Maintenance, Support and Bug Fixing. Responsible for writing code-behind business logic for C# win-form application.
• Designed Graphical User Interface (GUI) using Master Pages, Web Forms, HTML, JavaScript, CSS and Custom Controls, Themes, AJAX controls.
• Used JavaScript to enhance the dynamics and interactive features of web page by allowing user to perform calculations, Validate form inputs, add special effects, Customize selections, Confirmation, Used AJAX.
• Worked with ASP.Net Web Forms and State Management (Cookies, sessions, view state).
• Used ADO.Net data objects such as Connection, Command, Data Adapter, Data Reader, Dataset, and Data Table for consistent access to SQL data sources.
• Coding for various Modules, Error Handling, Modification and Testing, Bug solving of the change requests.
• Used different Telerik Controls, Free Textbox in Visual Studio applications
• Handled runtime and design time errors by implementing the appropriate error handlers in C#.Net. Resolved potential issues that arose during the execution of development.
• Worked on grid views for data representations with Sorting and Paging, and applied cells specific condition formatting.
• Stored grid view data in excel with proper formatting via c# code for better understanding.
• Created complex T-SQL procedures, views for run time and triggered each DML statement.

Environment: Net Framework 4.0, C#, Asp.Net, ADO.Net, MSAjax.Net, LINQ, WP F, XHTML, HTML, HTML 5.0, XML,T-SQL, SQL Server 2005, ADO.Net Entity Framework, LINQ, Microsoft Reporting, Java Scripts, CSS, Web Services, IIS.

Confidential

Senior .Net Developer

Responsibilities:

• Involved in analysis, design and development of application with full Software Development Life Cycle (SDLC) from analysis and design to implementation with .Net Technologies. Designed and Developed different modules, Class using C# and Designed GUI Part in .Net.
• Implemented the presentation layer using Master Pages, HTML, XML and JavaScript.
• Used CSS for common appearance all over the website.
• Developed Web forms using ASP.Net server controls and validated input using Java Script.
• Worked with Grid Controls, Sever controls to meet the client requirements.
• Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#, ADO.Net. The middle tier contained all the business logic. Participated in full development life-cycle using Object Oriented Programming (OOPS) concepts .
• Created Business Logic Layer and Presentation layer in ASP.NET.
• Created Common Data Access Layer using ADO.NET.
• Used ADO.Net objects such as Data Adapter, Data Reader and Dataset for data access.
• Fixed the bugs and extended the functionality for existing applications.
• Worked with ASP.Net Web Forms and State Management, Caching features, securing the web application.
• Created Relational Database using Normalization, Implement Relationships between tables, Data table, Stored Procedure, View in SQL Server 2008.

Environment: Net Framework 4.0, C#, Asp.Net, ADO.Net, MSAjax.Net, HTML, HTML 5.0, XML,T-SQL, SQL Server 2005, Crystal Reports, Java Scripts, CSS, IIS, Excel.

Confidential

.Net Developer

Responsibilities:

• Involved in different phases of Software Development Life Cycle (SDLC) including Designing, Programming, Testing and Documentation.
• Developed complex web forms using ASP.Net server-side scripting with C#, .Net Framework 3.5. Designed, modeled multi-threaded.
• Implemented the presentation layer using Master Pages, HTML, XML and JavaScript.
• Used CSS for common appearance all over the website.
• Developed Web forms using ASP.Net server controls and validated input using Java Script.
• Worked with Grid Controls, Sever controls to meet the client requirements.
• Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#, ADO.Net. The middle tier contained all the business logic. Participated in full development life-cycle using Object Oriented Programming (OOPS) concepts.
• Created Business Logic Layer and Presentation layer in ASP.NET.
• Created Common Data Access Layer using ADO.NET.
• Used ADO.Net objects such as Data Adapter, Data Reader and Dataset for data access.
• Worked with ASP.Net Web Forms and State Management, Caching features, securing the web application.
• Created Relational Database using Normalization, Implement Relationships between tables, Data table, Stored Procedure, View in SQL Server 2008.

Environment: Net Framework 4.0, C#, Asp.Net, ADO.Net, MSAjax.Net, HTML, XML, T-SQL, SQL Server 2005, Crystal Reports, Java Scripts, CSS, IIS, Excel.