Sql Server Web Services

RAMESH Sr. Dot Net Developer

SUMMARY

**+ years’ experience in analysis, design, development, research and implementation of Software Development Life cycle (SDLC), object oriented software systems and development of Windows Based, Web based, Client/Server and n-tier distributed applications

Strong Technical expertise in using Web Technologies like C#,ASP.NET MVC, Entity Framework, ASP.NET, ADO.NET,WCF Services, JQuery/Java Script, OOPS, Razor View, IIS 5.0/6.0/7.0, Visual Studio.NET 2005/2008/2010/2012/2013, SQL Server 2000/2005/2008/2012.

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

Good Experience with UI Development using Java Script/JQuery, Angular.JS, HTML5 and CSS3.

Strong experience in working with decoupled architecture using MVC.

Strong experience in Client side validations with JAVASCRIPT.

Strong experience with Test Driven Development (TDD) in .NET.

Strong experience in working with relational databases like SQL Server.

Expertise in applying Data Access Technologies Entity Framework and ADO.NET.

Experienced working in version control systems like TFS, GIT, and Visual Source Safe(VSS).

Proven knowledge in Creating and Consuming web services and WCF Services.

Strong Experience with User Interface (UI) Layer, Business Logic Layer and Data Access Layer.

Deployed Websites, having 3-tier architecture (Web Server, Web Services server, Database server).

Strong debugging skills in n-tiered ASP.Net/C# web application.

9+ years of experience in working with MS SQL SERVER

Good experience with RDBMS Architecture, Model, Design & Development including SQL Server, T-SQL, SQL and PL/SQL.

EDUCATION.

2007 Masters in Information Systems.

Texas A&M University

3.75 GPA

2005 Bachelor of technology degree in Computer Science.

Andhra University

CERTIFICATIONS

070-536-Microsoft .Net Framework Application development foundation.

070-515-Web Applications Development with Microsoft .NET Framework 4.5

ACCESS LINKS FOR CERTIFICATES

https://mcp.microsoft.com/Anonymous/Transcript/Validate

Transcript ID: 782687

Access Code: rvanamu81

LINKEDIN PROFILE

https://www.linkedin.com/in/rameshvanamu/

Microsoft Technologies

ASP.NET/2.0/3.5/4.0, WinForms, MVC3/4/5, C#.NET1.1/2.0/3.5/4.5, ADO.NET, VBNET1.1/2.0/3.5, WCF/Web Services, Web API, Entity Framework.

Web Development

ASP.NET 2.0/3.5/4.5, HTML5, AJAX, JavaScript, SOAP, Angular.JS 1.3/2.0, JQuery 1.11/2.0, JSON, CSS3, XML

Languages

C#, XML, XSLT, T-SQL.

Middleware

ADO.NET 1.1/2.0/3.5, Entity Framework 5.0/6.0

Application Development Tools

Team Foundation Server (TFS), MS Office, Visual Studio.Net 2003/05/08/10/Ultimate/12/13

Databases

Relational Databases SQL Server 2000/2005/2008/2012, 2014.

Source Control

TFS,GIT, Visual Source Safe(VSS)

Operating Systems

WINDOWS XP/2000/NT/98/7.

Reporting Tools

Excel Reporting, HTML Reporting, SSRS and Crystal Reports.

TECHNICAL SKILLS

PROFESSIONAL WORK EXPERIENCE

Geico (Chevy Chase), MD 06/2012 – Till date

Senior Dot net Web Developer

Project: Home Owners, Renters, Condo and Boat Insurances

MOAT is a web application developed for agents and customers.

This is developed on MVC, ASP.NET, C# and Entity frame work with SQL Server as Database.

This application helps the customers in completing the online insurance quotes for respective selected property. Agent’s role helps in assisting the customers for any issues in completing the quotes. This application talks with external carrier services using WCF for issuing the quotes.

Responsibilities:

Involved in developing the UI using HTML, JavaScript, JSON, jQuery, AJAX and Bootstrap.

Developed application using ASP.NET MVC and the business logic was coded in C#.

Worked on Test Driven Development (TDD) in Asp.Net MVC Architecture.

Used various JavaScript and jQuery libraries, AJAX for form validation and other interactive features.

Developed application for different browsers and fixed bugs for browser compatibility.

Used ASP.NET MVC and CSS to design the presentation layer of the website.

Developed components to fetch the data from the back end using AJAX and JQUERY.

Involved in writing SQL Queries, Triggers, Views and Stored Procedures.

Created service contract, operation contract and data contract in WCF.

Developed WCF Data services and consumed by MVC application.

Involved in implementing different types of securities and SOAP formats in web services.

Worked on OOPS concepts like Polymorphism, Inheritance, Abstraction, etc in C#.

Worked on hosting WCF service on IIS.

Worked on Dependency Injection, IOC implementation to avoid tight coupling.

Tested stored procedures and functions in SQL Server.

Worked on creating and consuming Web API Services.

Developed JavaScript event calendar to add scheduler to the application.

Developed stored procedures, Views and automated SQL, T-SQL scripts for database maintenance, deployment and installation.

Involved in accessing and assigning the session using JavaScript.

Used JIRA for requirements gathering and testing.

Created SQL queries to perform insert, update or delete operation on SQL Server database

Worked with QA team on daily basis in fixing the reported bugs/defects.

Worked on TFS Source control for managing the source code.

Worked in Scrum Methodology and involved in daily sprint meetings.

Environment: Visual Studio 2012/2013/2015, ASP.NET MVC 4/5, C#.NET, .Net Framework 4.5, WCF, Web API, Entity Framework, JavaScript, jQuery, TDD, Angular JS, JSON, Web Services, SOAP, Ajax, CSS3, Bootstrap, Razor View Engine, XML, XSLT, GIT/TFS, SQL Server 2012/2014.

Capital One (Richmond), VA 03/2011 – 06/2012

Senior Dot net Developer

Project: IRIS

Capital one is financial company. IRIS is a web application developed for agents.

This Application is developed using MVC framework and C#.NET this application helps agents in providing the detailed information of account holders. This application provides detailed information of account holders. This application provides personal information, offers, rewards, survey etc. These are only for information display. There is a Request correspondence page which contains change address and phone, card request or delete, return item and add user. Before accessing this request page there is an additional verification page which authenticates whether the user has provided all the information correctly.

Responsibilities:

Worked on Agile development environment.

Used Team Foundation server (TFS) to manage changes to the source code.

Worked on MVC (Model View Controller) Architecture.

Worked on writing reusable C# Classes with OOP’s.

Worked on setting/changing styles using JavaScript on UI.

Worked on XML Schema validation before calling the service.

Used fault contract to send exception details to the client in WCF.

Used Sub queries and co-related queries in SQL Server.

Worked on Entity Framework for CRUD operations on Customer Database.

Handled Run Time Errors & Design Time Errors by implementing appropriate Error Handlers.

Involved in various types of built in bindings like HTTP binding, WS-HTTP binding for WCF.

Worked on unit testing the applications.

Worked on creating and consuming SOAP based XML web services including XML Schema, SOAP, WSDL.

Used WCF Services to access data from the Remote Application.

Worked on developing the CSS dynamically using JQuery.

Created Indexes to speed up the query process in SQL Server.

Worked on integrating Excel display functionality.

Created Synchronous and Asynchronous Web Service Invocation with JavaScript.

Used AJAX extensively with JavaScript and XML.

Involved in Unit testing and integration testing.

Developed Excel reports using Excel helper classes.

Environment: Visual Studio 2010, ASP.Net, MVC, C#.NET, .Net Framework 3.5, WCF, Web Services, ADO.Net, AJAX, JavaScript, JQuery, IIS, JSON, Entity Framework, SOAP, LINQ, HTML, DHTML, XML, XSLT, Excel Reports, TFS, SQL Server 2008, T-SQL.

AUM (Oakbrook), IL 02/2010 – 03/2011

Senior Dot net Developer

Project: Utility Billing Application

American Utility Management is a Utility management company. Resident billing is a web application developed as tool for Properties and managers of the company. The 100+ Properties of the company cover different regions and companies on daily basis. The property information is served to the portfolio managers for making providers (Water, Gas, Electric) decisions. This application manages and displays the opinions of the Managers of Property, Company and Providers. This data is simultaneously loaded in the database. The residents have access to pay their utility bills online using our utility bill process application. The providers have the options to feed in the opinions, commentary and financial data of companies into the portal. PMs can search/browse the data within the portal. This application is an ASP.Net application with use of AJAX and web parts.

Responsibilities:

Involved in the study of the existing process and gathering requirements

Used agile development methodology.

Developed web pages using C#.NET.

Involved in designing complete database objects like Tables, Views, Stored procedures, and triggers using SQL server Worked on Reusable software components Design and Development

Developed .Net assemblies using C#.NET (Data access and Business Logic)

Worked on Java Script for Client side Validation.

Developed ASP.NET Web Services, SOAP and WSDL.

Developed analyzing the Query plan, logical operators and logical reads in SQL Server.

Worked on JavaScript Form Validation using regular expressions.

Used Visual source Safe (VSS) as source control.

Used transport level and message level security in WCF.

Involved in Exception and Error handling techniques.

Worked on deploying XML Web services on Server.

Worked on Query performance tuning for in SQL Server.

Created transport protocols like HTTP, TCP and MSMQ in WCF.

Involved in writing Java script functions to make all validation are perfect.

Successfully integrated data from multiple data sources including, SQL Server 2000 and legacy data delivered via message queues using ADO.Net

Developed calling ASP.NET web service using JavaScript.

Used Web Services to access data from the Remote Application

Implemented Distributed computing using .NET Remoting

Created DTS packages for data transformation process

Developed lots of reports for both Ad-Hoc and scheduled runs.

Used AJAX extensively with JavaScript and XML.

Environment: Visual Studio 2008, ASP.Net 3.0, C#.NET, WCF, .Net Framework 2.0/3.0, SQL Server 2005, Web Services, ADO.Net, AJAX, JavaScript, HTML, DHTML, XML, XSLT, Crystal Reports and Excel Reports, VSS.

OCFS (Office of Children and Family Services), Albany, NY 05/2009 – 02/2010

Dot net Developer (Front end Design)

Project: Children/Family Services (CAMP CONNECTIONS) (Government Project)

OCFS involves foster care, adoption and adoption assistance, child protective services for Child Abuse and Maltreatment, preventive services for children and families, services for pregnant adolescents, and protective programs for vulnerable adults. CAMPCONNECTION is web development project where officers can register the complaints and then the cases are stage progressed to different stages with investigation and the victims will be facilitated with foster care, adoption assistance etc.

Responsibilities:

Developed ASP.Net web pages using C#.

Worked on all phases in software development life cycle (SDLC).

Worked with Master Pages and Cascade style sheets (CSS) for the Order and Ticket pages.

Developed E-mail component for business notifications for business events.

Used server side client script registration and validations using JavaScript.

Handled Run Time Errors & Design Time Errors by implementing appropriate Error Handlers in ASP.NET.

Involved in fine Tuning and Performance and Query optimization of the Database in SQL server.

Programmed SQL Server 2005 Reporting Services(SSRS) using Microsoft Visual Studio 2008.

Used Ajax Controls for better user performance within the web pages.

Environment: Visual Studio 2008, .NET 3.5, ASP.NET, ADO.NET, SQL Server 2005, T-SQL, Web Services, SOAP, XML Schema, SD, XSL, JavaScript, Crystal Reports, VSS.

Progressive Insurance, May Field, OH 01/2008 – 05/2009

Dot net Developer

Project: Auto Insurance (Insurance)

Progressive Insurance is one of the leading Insurance Company, engaged in business of selling variety of insurance products including Motorcycles, Boat, Motor Homes and Trial Trailer insurance through internet or direct sales representatives. SLIQ (Special Line Internet Quote) is an Internet/Intranet application. Particular emphasis was laid on creating Quotes converting an existing quote into an application, creating policy coverage, make payments, adding and removing drivers for each vehicle. Progressive teamed up with Thought-works for the introduction and implementation of agile methodology and test driven development with constant build and re-factoring.

Responsibilities:

Worked on Web application using ASP.NET.

Used validation controls for client-side validations in ASP.NET.

Extensively worked with C# in ASP.NET to implement business logic.

Worked with dataset, data adapter in ADO.NET for database transactions.

Wrote stored procedures to communicate with the database in SQL server.

Involved in setting up the authentication, authorization and security settings of the application.

Worked on Data bound controls like Data Grid, Data List in ASP. NET for displaying data in web pages.

Environment: Visual Studio 2008/2005, C#.NET, ASP.NET 2.0, ADO.NET, SQL Server 2005, T-SQL, Web Services, SOAP, AJAX, XML Schema, XSD, XSL, JavaScript, Windows 2000 Server, Crystal Reports, VSS.

Amdocs, Hyderabad, INDIA 06/2005 – 12/2006

Dot net Developer

Project: Auto Insurance (Insurance)

This project intended at building a web based Billing application for telecommunication Customer Care System. Customers can work with subsystems, such as Registration, current billing information and resolve customer questions. This application was developed using ASP.NET, C#, ADO.NET and SQL Server.

Responsibilities:

Performed Forms Based Authentication and role Based Authorization.

Worked on developing Web services (ASMX).

Developed Business layer components using C#.

Developed application using ASP.NET and Consumed web services for additional functionality.

Wrote SQL Queries, Stored Procedures and Triggers for CRUD operations in SQL Server.

Developed User controls and Custom controls in the application.

Involved in Documentation, Unit Testing and Integration Testing.

Environment: ASP.NET, C#. NET 1.1, CSS, ADO.NET, JavaScript, Visual Studio 2003, MS Visual SourceSafe .NET Framework 1.1, Web service, SQL Server 2000.

Contact this candidate