Sql Server .Net

RAMESH

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, ASP.NET,

Entity Framework, ADO.NET,WCF Services, JQuery/Java Script, OOPS, Razor View, IIS

5.0/4.0/6.0, Visual Studio.NET 2005/2008/2010/2012, SQL Server 2000/2005/2008/2012.

• Excellent knowledge in Object Oriented analysis and design (OOAD), Agile Development

Methodology, Service Oriented Architecture (SOA) and Model-View-Controller Architectures

(MVC).

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

• Experience in unit and System Testing.

• Experienced working in version control systems like TFS, Visual Source Safe and

Clear Case 4.1.

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

• Extensive experience utilizing programming languages and technologies including ASP.NET,

C#.NET, ASP, Visual basic 6.0 to build analytical applications

• Proven knowledge in Creating and Consuming web services.

• Experience with multithreading high performance GUI trading system design using C#.NET.

• Strong Experience with Three Layers i.e., 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.

• Extensive experience with MS SQL Server 2000/2005/2008/2012, T-SQL, SSRS, SSIS.

• Proficient in writing stored procedures, Functions, Cursors, Packages, and Database Triggers

using SQL Server2000/2005/2008/2012 and Oracle

• Expertise in creating DTS packages in SQL Server.

• 5+ years of experience in working with MS SQL SERVER

• RDBMS Architecture, Model, Design & Development including SQL Server, T-SQL, Oracle,

SQL, PL/SQL.

TECHNICAL SKILLS

Microsoft .NET Technologies: ASP.NET 1.1/2.0/3.5/4.0, MVC 3/4,C#.NET 1.1/2.0/3.5/4.5,

ADO.NET, VBNET 1.1/2.0/3.5, ASP.NET, WCF/Web Services,

.NET Remoting.

Web Development: AJAX, HTML, ASP.NET 1.1/2.0/3.5/4.5, CSS, XML, XSL, WSDL

Development Tools: VisualStudio.NET 2003/2005 /2008/2010, Visual Studio 6.0

Middleware: COM/DCOM/COM+, ADO, ADO.NET 1.1/2.0, ActiveX

Web Servers: IIS 5.1. IIS 6.0/7.0

Languages: C#.NET 1.1/2.0/3.5, JQuery, JavaScript, XML/XSL, UML, T-SQL,

C++, MS SharePoint Server 2007

Databases: SQL Server 2000/2005/2008/2012, Oracle

Source Control: TFS, Visual Source Safe 6.0

Operating Systems: WINDOWS XP/2000/NT/98/7

Reporting Tools: Excel Reporting

PROFESSIONAL EXPERIENCE

Geico (Chevy Chase), MD Jun 2012 – Till date

Dotnet Developer

Project: Home Owners, Renters, Condo and Boat Insurances

Geico is Insurance company .MOAT is a web application developed for agents and customers.

This is developed in 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:

• Worked on Agile development environment.

• Worked on Model View Controller (MVC) frame work for achieving test driven development

approach.

• Worked on C#.NET language for the application .

• Worked on JQuery for Client side Validation and display UI controls.

• Worked on designing the UI in Razor view engine and referring to the model for basic

validation.

• Maintained the Web UI compatibility in all major Browsers (IE7 and above, Firefox and

chrome).

• Worked extensively on CSS for making the application responsive over all screen sizes.

• Successfully integrated Controllers, mappers and Models and mapped the mapper with

service layer.

• Used WCF for Data services and also for connecting to the carrier services for getting the

final quote.

• Worked on Data Validation scripts and created some batch scripts in SQl Server for validating

the data before deployment.

• Involved in daily scrum meetings and weekly release meetings for status updates.

• Worked on few utilities in WPF for maintain the database validation scripts.

Environment: Visual Studio 2010, ASP.NET MVC 3/4, C#.NET, .Net Framework 4.5, WCF, Entity

Framework, JQuery, Razor View Engine, XML,XSLT, TFS 2010, SQL Server 2012, CSS.

Capital One (Richmond), VA Mar 2011 – Jun 2012

Dotnet Developer

Project: IRIS Credit Card

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 Agile development environment

• Worked on Object Oriented Analysis and Design.

• Developed ASP.Net web pages using C#.NET

• Worked on Java Script for Client side Validation

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

• Worked on MVC (Model View Controller) Architecture.

• Handled Run Time Errors & Design Time Errors by implementing appropriate Error

Handlers.

• Successfully integrated data from multiple data sources including, SQL Server 2000 and

legacy data delivered via message queues using ADO.Net

• Used WCF Services to access data from the Remote Application

• Worked on integrating Excel display functionality

• Used AJAX extensively with JavaScript and XML.

• Involved in Unit testing and integration testing

• Developed Excel reports using Excel helper classes.

Environment: Visual Studio 2008, ASP.Net 3.5, MVC, C#.NET, .Net Framework 3.5, WCF, Web

Services, ADO.Net, AJAX, Java Script, HTML, DHTML, XML, XSLT, Excel Reports, TFS.

AUM (Oakbrook), IL Feb 2010 – Mar 2011

Dotnet Developer

Project: Utility Bills

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

• Used Visual source Safe(VSS) as source control

• Involved in Exception and Error handling techniques.

• 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

• 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, .Net Framework 2.0/3.0, SQL Server 2005,

Web Services, ADO.Net, AJAX, Java Script, HTML, DHTML, XML, XSLT, Crystal Reports and

Excel Reports, VSS.

OCFS (Office of Children and Family Services), Albany, NY May 09 – Feb 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#

• Used software development life cycle (SDLC)

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

• Used C# generics for creating custom collections.

• Developed assemblies using C#

• Designed and implemented the deployment procedures.

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

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

in ASP.NET

• Developed the membership module of Activation, Admin, and login and Account info.

• Implemented .NET security model by using Windows Based authentication modes

• Involved in writing database objects like Stored Procedures, functions, cursors and triggers in

the data access layer.

• Used .Net Remoting to get data from the remote .Net Application.

• Involved in fine Tuning and Performance and Query optimization of the Database

• Imported the database tables from other data source SQL Server, flat files to SQL Server

using Import/Export of SSIS

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

2008

• Building reports using Crystal Reports for the application

• 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, Windows 2000 Server, Crystal Reports, VSS.

Progressive Insurance, May Field, OH Nov 08 - May 09

Senior 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:

• Involved in initial requirement gathering

• It was 3-Tier Architecture web Application developed using ASP.NET

• Worked in User Interface layer, Business Logic layer and also in the Data Access layer with

the SQL Server.

• Played an active role in analyzing, documenting and designing the application

• Creating ASP.Net web pages using C#.NET

• Worked with Master Pages and Cascade style sheets (CSS) for the web pages.

• Used Visual source Safe(VSS) to manage changes to the source code

• Worked on Java Script for Client side Validation

• Used Web Services to access data from the Remote Application.

• Created DTS packages for data transformation process

• Used Customized Exception handling class for the handling exceptions in each layer with

event logging

• Creating .Net assemblies using C#.NET

• Wrote Stored Procedures, Functions and Triggers using SQL Server.

• Programmed SQL Server 2005 Reporting Services using Microsoft Visual Studio 2005

• Performed unit testing on each module developed

• Participated in system integration testing

• Worked on deploying the application on to development, staging and production servers.

• Used AJAX tool kit for better user experience in the web pages in the application.

• Developed custom reports using Crystal Reports

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.

ADP, Hyderabad Jun 06 - Nov 08

Dot net Developer

Project: Payroll Application (Payroll)

Payroll application is a web application developed for calculating the payable wages, calculated based

on the base rate of the employee plus overtime done for that job described by the invoice. Overtime

calculations can be defined by the user. Also the payroll must be able to produce reports for wages

payable at every Time.

Responsibilities:

• Involved in initial requirement gathering

• It was 3-Tier Architecture web Application developed using ASP.NET

• Worked in User Interface layer, Business Logic layer and also in the Data Access layer with

the SQL Server.

• Played an active role in analyzing, documenting and designing the application

• Creating ASP.Net web pages using C#

• Worked with Master Pages and Cascade style sheets (CSS) for the web pages.

• Used Visual source Safe(VSS) to manage changes to the source code

• Worked on Java Script for Client side Validation

• Used Web Services to access data from the Remote Application.

• Created DTS packages for data transformation process

• Used Customized Exception handling class for the handling exceptions in each layer with

event logging

• Creating .Net assemblies using C#

• Wrote Stored Procedures, Functions and Triggers using SQL Server.

• Programmed SQL Server 2005 Reporting Services using Microsoft Visual Studio 2005

• Performed unit testing on each module developed

• Participated in system integration testing

• Worked on deploying the application on to development, staging and production servers.

• Used AJAX tool kit for better user experience in the web pages in the application.

• Developed custom reports using Crystal Reports

Environment: Visual Studio 2005, ASP.Net 2.0, C#, SQL Server 2005/2000, Web Services,

ADO.Net, AJAX, Java Script, HTML, DHTML, XML, XSLT, Crystal Reports.

EDUCATION

Bachelor of Science, Computer Science from Andhra University, India 2003

CERTIFICATIONS Microsoft Certified Professional: MCP in Developing and Implementing

Web based Applications with Microsoft C# .NET and Microsoft Visual Studio .NET, Year 2008

Contact this candidate