Post Job Free
Sign in

Sql Server .Net

Location:
North Andover, MA, 01845
Salary:
70000
Posted:
August 16, 2016

Contact this candidate

Resume:

Ramesh

Email : *******.******@*****.***

Reach me @ 510-***-****

Summary:

Over 6 years of software development experience in design, development, integration and implementation of web applications using Microsoft .Net Technologies.

Expertise in the entire Software Development Life Cycle (SDLC).

Developed N-Tier (including business and data tier) applications. Well versed with Back end, Middle tier and front end.

Used Microsoft Entity Framework Code First approach for the Data Access Layer for the ASP.NET MVC 3 application.

Expertise on .Net Framework with good exposure on Foundation Classes (WCF).

Designed the Web Forms and the Web Pages using almost all the ASP.Net controls.

Extensively used JavaScript for client side validations.

Experience in developing complex queries, Stored Procedures, triggers and cursors using SQL Server 2005/2008/2012.

Expertise in XML, XSLT, XPATH, HTML, DHTML, CSS, jQuery.

Extensive experience in implementing applications using AJAX to increase user experience and application efficiency with a dynamic user interface.

Experienced in customizing and adopting Microsoft provided APPLICATION BLOCKS (Validation, Logging, Exception, Data, and Security).

Good experience in LINQ and ADO.NET Entity Data Model Framework.

Used SQL Server Integration Services (SSIS) in reporting and analysis with the .net environment.

Expertise in designing and developing complex user interfaces (GUI) using ASP.NET and MVC.

Excellent knowledge in Object Oriented analysis and design (OOAD), Agile Development Methodology and Model-View-Controller Architectures (MVC).

Highly Knowledgeable in ASP.NET MVC 4.0 in implementing Model, View and Controllers with State Management, Security, Action methods etc.

Experience in using Configuration Management tools like Visual Source Safe (VSS), SVN, Team Foundation Server (TFS), Git hub.

Highly organized with the ability to meet deadlines and ability to work as a team player as well as an individual.

Work experience of Scrum methodology.

Technical Skills:

.NET Technologies

ASP.NET, ADO.NET, Web Service, AJAX, WPF, WCF, MVC and LINQ.

Languages

C, C++, Visual Basic 5.0/6.0, C#, VB.NET, T-SQL, PL/SQL.

Frameworks

. NET Framework 2.0/3.0/3.5.

RDBMS

SQL Server 2012/2008/2005/2000, MS Access.

IDE

Visual Studio 2005/2008/2010, Microsoft Visio

Servers

IIS 6.0/7.0.

Internet Technologies

Java Script, AJAX, Jquery, XML, XSLT, HTML, CSS, Web Services, WSDL/SOAP, AJAX

Services, WSDL/SOAP, AJAX

Services, WSDL/SOAP, AJAX

Interface Tools

Telerik, DevX Controls.

Version Control Tools

Visual Source Safe (VSS), TFS, TortoiseSVN, GIT

Reporting Tools

SQL Server Reporting Services (SSRS), Crystal Reports 8.5/9

Operating System

Windows 7/Vista/2003/XP/2000/98, Windows Server 2008/2003, Linux.

Modeling Tools

UML, Visio

Project Experience:

Client: Anthem Insurance Companies, Inc, Atlanta,GA Mar 2015 -Present

Web Developer

Description:

Anthem, Inc. is working to transform health care with trusted and caring solutions.

Responsibilities:

Followed the standard for Software Development Life Cycle Processes (Selection of a Life Cycle Model, Project Initiation, Project Monitoring and Control, Requirements, Design, Implementation, Installation, Operation and Support.

Developed and supported the application using ASP.NET MVC 4.0 with Razor syntax, C#.NET, AJAX, JQuery, JSON, HTML, JavaScript, Bootstrap and CSS.

Worked on enhancing and maintaining the applications as per the business need needed.

Independently worked on developing document handler using the HTML5.

Used Microsoft Entity Framework Code First approach for the Data Access Layer for ASP.NET MVC4 application.

Proposed and developed property management improvement initiatives.

Used IIS logs to identify the issues on the webserver and monitored application errors through event viewer.

Involved in creating web pages using Angular JS, JavaScript, JQuery, HTML 5.0 and CSS.

Created the Editor and Display templates for MVC controls.

Consumed azure web services and managed deployment through cloud platform.

Used Master Pages, shared layouts, CSS & Themes for the consistent look of the application.

Created View models to encapsulate all models and classes used on the different views for a more organized, structured, and clean code.

Improved user experience using JQuery. Used JQuery event handling mechanism to dynamically assign events on web controls.

Based on the support tickets, fixed bugs on priority basis

Deployed Applications from Development TFS to Staging, Production Support, and UAT and Production servers.

Involved in prioritizing the issues and identifying the root cause analysis and bug fixes.

Involved in writing SQL Statements, Views and Stored Procedures, Indexes to validate data and ensure system integrity and security Written LINQ functions for data access.

Developed test-driven development (TDD) strategy guiding use of the N-unit testing framework.

Used Team Foundation Server (TFS) for continuous integration and version control.

Used Fiddler to debug web request and responses to solve user issues on the client side.

Reviewed code to ensure that all the Processes and Standards are being ensured that correct implementation of requirements, coding standard, project architecture, efficient code writing techniques etc.

Participated in periodic technical reviews of various modules and developed schema to improve them.

Actively participated in Scrum meetings of the project implemented in agile methodology.

Environment: C#, ASP.NET, TDD, .Net Framework 4.5/4.0,, SQL 2010, Visual Studio2013,AZURE, Telerik Rad Controls, MVC, SOAP Web services, XML, OOP, WCF, REST, HTML 5, WebAPI, N-Tier Architecture, Agile, SCRUM..

Client: Service Master, Memphis, TN Sept 2013- Feb 2015

.Net Developer

Description:

Service Master is a company which provides residential and commercial services.

Responsibilities:

Closely worked with the offshore team to coordinate development efforts for various high impact modules

Analyzed current and to-be state of the application based on the requirement specifications

Implemented client-side Validation Controls using JavaScript and Visual Studio markup validator.

Designed and developed Web pages using ASP.NET, C#, HTML, JavaScript, CSS and Server controls

Strong understanding in Object Oriented programming and the ability to develop and support applications in C#/.NET

Designed Web forms using User Controls and Server Controls in Visual Studio .NET 2010

Wrote Stored Procedures, Triggers and SQL Queries and LINQ in SQL Server 2008.

Implemented Data Access Layer to communicate with the SQL Server 2012 Database through Entity Framework 6.1 Data First approach with LINQ.

Exposed all Claims Processing Data through IIS hosted WCF services.

Implemented all Service Interfaces in C#.NET, utilizing many reusable Class libraries

Developed Class Diagrams, Sequence Diagrams, ER Diagrams and flow charts for the application to effectively share knowledge with QA teams

Developed presentation layer using HTML Controls and Cascading Style Sheet.

Built Web Application design using JavaScript, Angular JS, MVC2, CSS and HTML .

Proactively conducted knowledge sharing sessions with all onshore and offshore teams towards the end of the contract

Environment: .Net Frameworks, Visual Studio.Net, JQuery, C#, SQL, PL/SQL, ASP.NET MVC, HTML, CSS, JavaScript, Angular JS, LINQ,Entity Framework.

Client: Trident USA Health Services, Camp hill, PA April 2011- Aug'2013

Role: .NET Developer

Description:

Trident Medical Center is a tertiary-care hospital providing a comprehensive range of services and specialties expected by a major medical center.

Responsibilities:

Involved in gathering all requirements from the client and provided expertise advice for better enhancement of the application.

Tested and provided expertise advice in other projects. Developed and resolved enhancements, issues in the project.

Managed an offshore team that reports directly to me. Followed MVC architecture.

Implemented Server and Client side validations using ASP.NET validation controls, JQuery and JavaScript.

Developed WCF web services for calling API methods. Developed the project in secured protocols.

Used Power GUI to write the Power Shell test scripts for unit testing the developed modules.

Experienced in deploying the project in different environments. Integrated the application in client server such that application is independent from the database and other dependencies.

Designed and developed several SQL Server Stored Procedures, Triggers, and Views for API methods in the project.

Wrote Data Access Layer Methods (ADO.NET), T-SQL Queries, Store Procedures, and SQL User Defined functions for fetching Transaction details, Customer Details, and Product Configuration data

Environment: Visual Studio 2010, MVC2,ASP.Net 4.0, C#.Net, CSS, JavaScript, J-Query, TFS, OOAD, SOAP,IIS 7.5,IIS6.0, Web Services, Power Shell Scripting, XML, SQL-Server 2008, SSRS.

Client: PNC Bank, Bangalore, India Feb 2010- March 2011

Software Engineer

Description:

PNC offers a wide range of services for all our customers, from individuals and small businesses, to corporations and government entities.

Responsibilities:

Designed and developed the user interfaces of the application using ASP.NET, HTML Controls, XHTML, AJAX, Java Script and CSS, Win Forms using C#.

Involved in performance testing for project using Visual studio Load Testing 2012 and Jmeter.

Extensive development of ASP.NET UI pages using Master pages, AJAX, client, server and custom controls for manipulating and displaying data on the Webpages.

Developed presentation layer using HTML Controls and Cascading Style Sheet.

Implemented Messaging Application for Automatic Processing of email messages to the sales representatives automatically using WCF.

Implemented Test driven development using Nunit and Mocking Frameworks.

Developed web form and window forms for clients in C# using (WPF) Windows Presentation Foundation, XAML and XML

Involved in creating activities and processes for (WWF) Windows Workflow Foundation.

Implemented OOP’s concepts in various utility classes which are used across whole project using ASP.NET 3.0, C#, ADO.NET.

Handled Errors using error handling exceptions, tracing and debugging

Implemented Client-side validation using JavaScript and AJAX.

Utilized ADO.NET technology extensively for data retrieving, querying, storage and manipulation.

Participated in designing database and created complex stored procedures, triggers and views using SQL Server 2005.

Involved in optimization of database queries, made extensive use of query execution plan, SQL server profiler, index tuning wizard tools in SQL server 2005

Involved in writing complex queries, Stored Procedures and generating reports using SSRS.

Environnent: C#, ASP.Net, ADO.Net, AJAX, JavaScript, CSS, XHTML, HTML, XML, XAML, XSL, SSRS, WCF, WPF, Win Forms, SQL Server 2005, Visual Studio 2008, Visual Source Safe.



Contact this candidate