.Net Developer Project Experience Sql Server Web

Ramachandra Panuganti

***********.*********@*****.***

Ph: 603-***-****

SUMMARY

. 5+ years of .NET experience in .Net Framework, Ektron CMS400 v7.6/8.0 in

developing Web Applications.

. Ektron Certified Developer and Administrator

. Expertise in creating applications using ASP.NET, ADO.NET, XML, HTML and

SQL Server 2000/2005/2008.

. Strong knowledge in Object Oriented technology for software design and

implementation.

. Experience in Developing and Consuming XML Web Services using C# and

ASP.NET.

. Hands on Experience in ASP.NET AJAX toolkit and AJAX Extended

Controllers.

. Experience in Java Script & Jquery.

. Expertise in using ASP.NET Validation Controls for form data Validations.

. Experience in Database Analysis, Design, Development, Testing,

Implementation and production, support (SDLC) of Client/Server, N-Tier

and Web based applications.

. Expertise in Database Design and Database Programming using SQL Server

2000/2005/2008.

. Experience in migrating DTS packages to SQL Server Integration Services

(SSIS) and modifying the packages accordingly to use the advanced

features of SQL Server Integration Services.

. Hands on Experience with EDI.

. Strong Experience in data retrieval and manipulations using ADO.NET data

objects such as Dataset, Data Reader, Data list, Data Adapter.

. Experience in writing Stored Procedures, Triggers & Cursors.

. Experience in XML related technologies: XML, XSLT, XPATH, DTD, SOAP, and

XML Schema.

. Experience working Ektron Server Controls.

. Experience in securing web applications using ASP.NET authentication and

authorization mechanisms.

. Experience in creating & using Cascading Style Sheets.

. Experience in Designer tools UML and MS-VISIO.

. Experience in Image Editors Adobe Flash, Adobe Photoshop and MS Front

Page.

. Hands on Knowledge on deploying .NET application using various

mechanisms.

. Experience in generating various Reports using Crystal Reports 12.0

. Experience in creating & using User Controls and Custom Controls.

. Good exposure to the Software Development Life Cycle (SDLC).

. An effective team player that understands the value of working together

towards a common goal

. Ability to rapidly absorb and apply new concepts effectively, innovative

problem solving skills working in a challenging work environment and

meeting strict deadlines.

TECHNICAL SKILLS

Programming C,C++,Visual C#, ASP

Languages

Scripting Languages JavaScript, JQuery

Markup Languages HTML, DHTML, XML

.NET Technologies .NET Framework (1.1/2.0, 3.0/3.5), ADO.NET, .NET

Remoting, Web Services.

Software Engineering SDLC, UML.

Database Development SQL Server (2000/2005/2008), T-SQL, DTS, and MS

Access

Web Technologies ASP.NET, ASP, HTML, AJAX, XML Web Services.

XML Altova XMLSpy 2007, XML, XSL, XSLT, XSD, SOAP,

WSDL, UDDI.

Operating Systems Windows XP/2000/NT/Vista

RAD/IDE Visual Studio 2003/2005/2008, Visual Basic 6.0

Reports Crystal Reports

Version Control Tortoise SVN

Modeling & Testing Microsoft Visio 2003, NUnit 2.2

Tools

PROFESSIONAL EXPERIENCE

Client: Omnix Software

June 2010 - Present

.NET Developer

Omnix Software is a leading international provider of next generation

project automation solutions for telecom infrastructure management. For

more than 10 years, we have been helping clients in over 30 countries

deliver complex network projects and manage their network assets.

Responsibilities:

. Involved in designing the website from scratch using Visual Studio 2008

and Ektron CMS400 v7.6 and upgrading the version to 8.0.

. Created various Web Forms for user login, Account Details, loan

applications and processing and purchases history using ASP.NET.

. Social networking was also part of the project which included blogs,

discussion boards, community groups.

. Implemented Client and Server side validations using JavaScript and

ASP.NET validation controls

. Effectively managed the state using various session management

techniques.

. Used Visual Studio.NET debugger and ASP.NET trace functionality to debug

the application.

. Created Web User Controls, to ensure reusability as needed by different

pages of a session.

. Utilized .NET XML parsing and XSLT features for parsing XML files

containing the information about the customer's statement.

. User various ektron controls like Collections, Forum, Forumblock,

Taxonomy, pagebuilder, sitemap and directory control.

. Utilized the data to redesign critical aspects of the Graphical User

Interfaces to better map with operator needs.

. Develop functional wireframes and GUI prototypes in HTML

. Extensively used Grid View, Details View to display account summary, loan

history and other information on the web pages using Sql data source.

. Designed the site with a multi language feature.

. Used Tortoise SVN for version control and history during development.

. Developed user controls to be used all over the project for the search

functionality.

Environment: Visual Studio 2008, .NET Framework 3.5, ADO.NET, Web Forms,

CSS, XML, XSLT, JavaScript, Web Services, Tortoise SVN, SQL SERVER 2008.

Atria senior living

www.atriaseniorliving.com Nov 2009

- June 2010

.NET Developer

Project Description:

. Atria senior living is the place for Independent living for older

people who want to connect with peers and enjoy an active lifestyle. A

web application, which was developed with various search choices for

the locations, search for a location based on the zip code, schedule a

visit and register as a atria senior member. They can also update

their personal details including email & password, the whole web

application was developed using ektron 7.6, ASP.NET, C#, and ADO.NET.

. Responsibilities:

. Developed various Web Forms and extensively used .NET Validation

Controls and Ektron Server Controls.

. Application Layer was developed using ASP.NET, C#, ADO.NET.

. Developed presentation layer using various Ektron Server-Controls,

HTML controls and user controls

. Developed some of the User Interface modules using Css, java script

and Html

. Used Web Services effectively as per the requirement from client.

. Involved in designing the database architecture.

. Have used Taxonomy for categorizing content, users and groups and

community groups through different departments and then arranging the

contents/groups respective of the departments.

. Worked on various control like list summary, collection, breadcrumbs,

cart, forum Control, analytic control and social networking and soon

with 60 ektron controls.

. Used Triggers and SMTP protocol in .NET to send emails to the customer

. Grid View and Details view was used extensively to display various

SQL Server elements

. Used Form Based Authentication for the Application as a .NET Security

measure by providing a login page

. Involved in preparing product release documentation for all the

activities undertaken at regular intervals for the project management

review and update

. Deployed the application on the production sever by creating the Web

Setup project in Visual Studio.NET

. Utilized .NET XML parsing and XSLT features for parsing XML files

containing the information about the customers statement

. Transferred the site files to the production box using Site

Replication feature.

. Developed user controls for the entire project along with labels and

dropdowns.

Environment: Visual Studio 2008, .NET Framework 3.5, ASP.NET, C#,

ADO.NET, Web Forms, CSS, XML, XSLT, JavaScript, Web Services, SQL

Server 2008,Tortoise SVN, Watir with Ruby.

Diversified Business Communications May

2009 - Nov 2009

.NET Developer

www.culturalfood.com

All Asia Food Expo

Diversified Business Communications Systems is a Leading website for

hosting culinary and hospitality management related expos and exhibitions.

It is mainly categorized according to the type of food e.g.: Asian, Latina,

and Continental Etc.

Responsibilities:

. Involved in Designing, Developing and Testing of all Asian food expo

site.

. Created Object model and Database Diagrams and created Relationships

using Microsoft Visio.

. Created Custom Configuration Section in App.Config and retrieved

values from there.

. Used Ektron Server Controls for Menus, Index Search, Bread Crumbs and

User Registration for the conference.

. Extensively used List Summary, Metadata selectors and custom user

attributes for different types of events and registration pages.

. Created JQuery for displaying conference information as a popup on

mouse hover.

. Extensively used Tortoise SVN for version controlling of source code.

. Implemented Unit and Integration testing using NUnit testing tool.

Environment: Microsoft Visual Studio 2008, C#, XML, NHibernate, SQL Server

2005, .Net Framework 3.5, Tortoise SVN.

Company: Ektron Inc

Client: Johnson Wales University Providence RI. Jan 2009 -

April 2009

Role: .Net Developer

Project Description: Johnson Wales University is one of the largest

universities in Rhode Island which has four campuses in Providence,

Charlotte, Denver and North Miami. The website was mainly designed based on

the campus and the courses offered in the respective campuses.

Responsibilities:

. Involved in redesigning the website using Visual Studio 2008 and Ektron

CMS400 v7.6.

. Created various Web Forms for user login, account summary, loan

applications and Payment history pages using ASP.NET

. Configured Web.Config file for Form based authentication and

authorization

. Implemented Client and Server side validations using JavaScript and

ASP.NET validation controls.

. Used AJAX Tool Kit in Loan Application page for validations, Calendar &

Auto Fill Functionality.

. Effectively managed the state using various session management

techniques.

. Used Visual Studio.NET debugger and ASP.NET trace functionality to debug

the application.

. Created Web User Controls, to ensure reusability as needed by different

pages of a session.

. Used Data Adapters, Datasets, Command & Connection Objects of ADO.NET to

manipulate data in the SQL Server Database

. Utilized .NET XML parsing and XSLT features for parsing XML files

containing the information about the customers statement

. Extensively used Grid View and Details View to display account summary,

loan history and other information on the web pages

. Used Tortoise SVN for version control and history during development

Environment: Ektron CMS 400 v7.5,Visual Studio 2008, .NET Framework 3.0,

ADO.NET, Web Forms, CSS, XML, XSLT, JavaScript, Web Services, Tortoise SVN.

Company: Ektron Inc

Client: Harvest Eating, NC June 2008 - Dec

2008

Role: .Net Developer

Project Description: Harvest Eating, is one of the leading websites for

prospective chefs & has largest collection of the recipes for all the

seasons. The site created has all the information for chefs by offering a

wealth of information, products based on the region. Registered users can

purchase 3 month/6month or 1 Yr subscription to view the recipe videos and

order ingredients online keep track of the status of the orders placed and

delivered right to their home. an Order Processing System was designed and

developed. Also, the OPS maintain customer's contact information, product

information like in-store-stock, seasonal information and its availability.

The Order Processing System is a Web based application.

Responsibilities:

. Involved In developing the website using Ektron CMS v7.5.

. Used Ektron Custom Controls for Smart forms, Forums, Blogs & Discussion

board.

. Created Web forms using ASP.NET and Visual C# in Microsoft .NET Framework

. Used SQL Server 2005 as back end database

. Worked with Embedded Crystal Reports Generator and used common built-in

visual studio features to generate reports.

. Utilized Form Based Authentication for application security using Visual

C#

. Implemented Client and Server Side Validations using ASP.NET and

JavaScript

. Managed application appearance using Cascading Style sheets for ASP.NET

Web forms

. Managed behavior using XML for ASP.NET Web forms

. Created and reused various Ektron User Controls for front-end Web forms

using ASP.NET and C#

. Used XML Web Services through JavaScript on Client side

. Extensive use of Data Tables and Data Relation Objects using ADO.NET

. Made use of Data Grid control for paging and sorting of data in ASP.NET

Web forms

. Using Data Transformation System, database tables in MS EXCEL were

transformed to SQL database

. Utilized Tortoise SVN for version control

Environment: Ektron CMS 400 v7.5,Visual Studio 2005, .NET Framework 3.0,

ADO.NET, Web Forms, CSS, XML, XSLT, JavaScript, Web Services, Tortoise SVN.

Company: Ektron Inc

Client: Princeton Review, NY

Jan 2008 - June-2008

Project: Online Test scheduling System.

Role: .NET Developer.

Project Description: Princeton Review is one of the test preparation

website for SAT GMAT and TOEFL Exams. A web application, developed where a

registered user can login, search for a test site based on the zip code,

schedule a test and register for a course based on his/her academic

background. They can also update their personal details including email &

password etc, the system was developed using ASP.NET, C#, and ADO.NET.

Responsibilities:

. Developed various Web Forms and extensively used .NET Validation Controls

and Ektron Server Controls

. Used Ektron Controls for Contact Us page, Flex Menus and bread crumb

control for page navigation.

. Application Layer was developed using ASP.NET and C#

. Developed presentation layer using various Ektron Server-Controls, HTML

controls and user controls

. Developed some of the UI modules using HTML, JavaScript and CSS

. Consumed Web Services effectively as per the requirement

. Involved in designing the database architecture

. Used ADO.NET for retrieving data from backend database SQL Server 2005

. Used Data Adapters, Datasets and Command & Connection Objects of ADO.NET

to manipulate Data in the SQL Server Database

. Used Triggers and SMTP protocol in .NET to send emails to the customer

. Effectively used various state management techniques offered by ASP.NET

. Grid View was used extensively to display various SQL Server elements

. Used Form Based Authentication for the Application as a .NET Security

measure by providing a login page

. Used Tortoise SVN for source & version control

. Involved in preparing product release documentation for all the

activities undertaken at regular intervals for the project management

review and update

Environment: Ektron CMS v7.5 Visual Studio 2005, .NET Framework 3.0,

ASP.NET, C#, ADO.NET, Web Forms, CSS, XML, XSLT, JavaScript, Web Services,

SQL Server 2005, NUnit 2.2, IIS 6.0, Visual Source Safe.

Client: Catholic Medical Center Sep

2007 - Dec 2007

Project: Patient - Issue Tracking

Role: .NET Developer

Project Description: Catholic Medical Center grew from a small community

hospital to one of the leaders in redefining healthcare delivery and will

be recognized for the passion of its people and partners in providing

quality, innovative care to the patients it serves. I was involved in

migrating the existing ASP website to ASP.NET web application. The website

was enhanced with various features such as; Online account viewing, bill

payment, review medical history, book an online appointment and check for

doctor availability.

Responsibilities:

. Involved in analyzing and designing of the system

. Developed the Web Forms for online account viewing, bill payment, review

medical history, book an online appointment and check for doctor

availability using ASP.NET, C#.NET, XML, JavaScript, AJAX

. Provided Windows based and Form based Security for Login and

Authentication

. Implemented various User Controls and Custom Controls on front-end forms

. Implemented Validation Controls to perform both client side and server

side validation

. ADO.NET was used to access data from SQL Server 2005

. Created Stored Procedure(s), Views and Triggers in SQL Server 2005 for

updating and display of data

. Developed Web Services for defining patient's health disorder and

treatments or tasks that a care provider performs on behalf of the

patient

. Deploying the application on the production sever by creating the Web

Setup project in Visual Studio.NET

. Participated in various client meetings with the team and the project

manager to discuss improvements/amendments in the development of the

section

Environment: Visual Studio.NET 2005, .NET Framework 3.0, C#, ASP.NET,

ADO.NET, HTML, CSS, XML, JavaScript, AJAX, SQL Server 2005, IIS 6.0,

Tortoise SVN.

Client: Woodcraft Supply, Lenexa, KS

Feb 2007 - Aug 2007

Role: .Net Developer

Project: Order Processing System

Description:

Woodcraft Supply, LLC is one of the oldest & largest suppliers of quality

woodworking tools and supplies. The site created has grown into a trusted

resource for woodworkers by offering a wealth of information, services and

products. It distributes its products using the company's direct-store

delivery system. To keep track of the status of the orders placed and

delivered at the store, an Order Processing System was designed and

developed. Also, the OPS maintain customer's contact information, product

information like in-store-stock, manufacture and expiry dates. The Order

Processing System is a Web based intranet application.

Responsibilities:

. Created Web forms using ASP.NET and Visual C# in Microsoft .NET Framework

1.1

. Used SQL Server 2000 as back end database

. Utilized Form Based Authentication for application security using Visual

C#

. Implemented Client and Server Side Validations using ASP.NET and

JavaScript

. Managed application appearance using Cascading Style sheets for ASP.NET

Web forms

. Managed behavior using XML for ASP.NET Web forms

. Created and reused various Web User Controls for front-end Web forms

using ASP.NET and C#

. Used XML Web Services through JavaScript on Client side

. Extensive use of Data Tables and Data Relation Objects using ADO.NET

. Made use of Data Grid control for paging and sorting of data in ASP.NET

Web forms

. Using Data Transformation System, database tables in MS EXCEL were

transformed to SQL database

. Involved in Unit Testing using NUnit tool for developed ASP.NET Web

applications

. Utilized Visual Source Safe for version control

Environment: Visual Studio.NET 2005, C#, ASP.NET, ADO.NET, .NET Remoting, T-

SQL, HTML, CSS, XML, JavaScript, SQL Server 2005, Visual Source Safe 6.0,

Windows 2000 Server

Client: COMPUSA Feb 2006-Jan 2007

Role: Sr.Net Developer

Project Description: Order Management is a layered web application. The

company portal application will be supporting different online stores. This

project includes the main product selector application that stores can sell

different products available from different vendors. It's a continuous

process for different products with different vendors and they need to be

traced and maintained. This project also provides the facility to generate

several types of reports for the stores and vendors regarding to their

transactions. Order Management is a layered web application for backend

order management with complex order workflow management, XML web service

interface with external vendors, and extensive real-time and derived

reporting capabilities.

Responsibiliies:

. Involved in the design, analysis and implementation of the projects.

. Implemented different reusable object oriented layers like

Presentation Layer, Business Object Layer, and Data Access Layer.

. Used ASP.NET, cascading style sheets (CSS) and C# for web application

development.

. Client and Server side Validations are done using Java Script and

ASP.NET Validation Controls.

. Used ADO.NET for database connectivity, implemented stored procedures

on SQL Server Database.

. Created custom control to render data sources like DataSet, DataTable,

DataView and DataReader as CSV output.

. Created highly customized reports using Repeater, DataList and

Gridview with paging and sorting features

. Used Typed Datasets for displaying, updating and deleting data source

through Data Web controls.

. Used .NET Caching techniques, View State technique to hold the values

across the pages.

. Used Calendar Control in the applications.

. Used Web.Config file for connection Strings, implemented Custom Error

handling for the application.

Environment: .Net Framework 2.0, ASP.Net 2.0, ADO.Net, C#, SQL Server 2005,

AJAX,XML, XSLT, IIS.6, Visual Studio 2005, Visual SourceSafe 2005,Web

Services. Nunit tool.

Project: Employee Information & Intranet System Aug 2005

- Jan 2006

Client: RH Technologies

Project Description: The windows based application was developed to manage

& maintain the Employee information and Payroll system of the Company

Responsibilities:

. Designed and Developed Web forms to maintain the employee information

which comprises of their attendance records, work schedules, Time

Sheets.

. Designed and Developed Web forms to maintain the Time Sheets

information of the employees

. Designed and developed reports to produce Time Sheets Reports on a

weekly and monthly basis.

. Responsible for Testing and Deployment of the system.

Environment: Visual Studio 2003, SQL Server 2000, Windows 2000

EDUCATION

Bachelor of Technology, University of Madras, India

Contact this candidate