.Net Sql Server Developer Project Data Service

Indumathi Kurada.

217-***-**** (M) . abm0x8@r.postjobfree.com

Summary:

. Over 5 years of experience in analysis, design, development and

deployment of software applications

. Expertise in developing object oriented programming.

. Extensive Experience in ASP.NET 3.5/ASP.NET 2.0, C#/VB.NET, .NET

Framework 3.5/2.0/1.1, SQL Server 2000/ 2005.

. Design and programming experience with web technologies like HTML, DHTML,

XML and XSL/XSLT and Web Services.

. Extensive Knowledge in Installing,Migrating and Maintaining the Sql

server 2000 to Sql server 2005

. Extensive Experience in developing Web Services with Service Oriented

Architecture (SOA).

. Extensive Knowledge in writing Windows Services, Mobile Applications and

.NET Remoting Objects and very good exposure to object-oriented analysis,

design and implementation in a multi-tier application development

environment.

. Experience with the full software development life cycle (SDLC),

including design and documentation activities.

. Good communication and interpersonal skills.

. Strong problem solving and analytical skills with the ability to clearly

communicate and share solutions at all levels to various audiences

. Proactive attitude, ability to work independently and in a team and a

desire to continuously learn new skills and technology

Certifications (MCP):

Microsoft Technology Specialist (MCTS): Microsoft .NET Framework 2.0-

Application Development Foundation Exam 70-536.

Education:

Master of Science, Computer Science (MS)

University of Illinois at Springfield.

Bachelor of Technology, Information Technology (B.Tech)

Jawaharlal Nehru Technological University.

Skills:

Technologies: Visual Studio 03/05/08, ASP.NET 3.5/2.0/1.1, ASP, C#.NET,

VB.NET, MVC Framework, HTML, DHTML, XML, Java Script, JQuery, Crystal

Reports, Reporting services, Photo Shop, Web Services, WCF, XML/XSD/XSLT,

ADO.NET, Visual Sourcesafe, .NET Remoting, CSS, AJAX.

Databases: Sql Server 2000/05, Oracle, DB2, My Sql, SSIS, MS Access,

Humming Bird, PL/SQL Developer.

Professional Experience:

Antares Management Solutions, Cleveland, OH May

2007 - Nov 2009

.NET Developer

Project Title: 278 Web Service

Environment and Tools: C#.NET 3.5, WCF, ADO.NET, DB2, SQL Server 05,

Harvest, Visual Source Safe.

278 Health Service Review is an HIPAA Compliance. This web service is

developed to support the 278 EDI Transactions. This is referred by

hospitals and it will take in a 278 Request xml file and will give out a

corresponding 278 Response xml file. These requests and responses are in a

specified format predefined by ANSI X12.

Responsibilities

. Defined, Implemented and Hosted a WCF Service Contract in order to

exchange 278 xml files.

. Rewrote code in COBOL to .NET.

. Used XML Schema Definition Tool (XSD.exe) to convert from given XML

Schemas to Classes.

. Designed various classes to process the data.

. Serializing and De-serializing an XML Document to streams.

. Validating XML Document against Schema using XMLReaderSettings.

. Extremely used XMLReader and XmlWriter.

. Involved in integration and testing of all modules.

. Involved in designing the database tables.

. Wrote SQL queries, Stored procedures, Triggers and User Defined functions

to Insert, Update and Select data.

. Documented each and every step of the project.

. Wrote a Document to instruct clients how to plug in and use the service.

Project Title: Review Link Application

Environment and Tools: ASP.NET, Web Services, VSS, ADO.NET, C#.NET, ASP,

DB2, SQL Server, Harvest, Visual Source Safe.

This is a web application which is used by the hospitals to key in

patient's information and gets a review on it.

Responsibilities:

. Developed various web pages.

. Developed User controls and efficiently used Component one controls in

various web pages.

. Used source control software Visual Source Safe 6.0 for effective source

control of the entire project.

. Developed SQL Queries to Insert, Update and Delete data.

. Developed Classes and Interface.

. Developed a Class Library (generated a dll file) in order to achieve

Service Oriented Architecture.

. Used JavaScript to develop Tabs on web pages.

. Converted the whole project from .Net 1.1 framework to .Net 2.0

framework.

. Maintaining ASP(vb script) version of the project and using it as a

reference to build a new one in .Net 2.0.

Project Title: Health Risk Assesment (HRAWebMed)

Environment and Tools: VB.NET, DB2, Visual Source Safe, ADO.NET, Humming

Bird, Team Foundation Server.

HRAWebMed is a console application, which reads the XML file sent by the

clients (Hospitals) and inserts the records of patients read from it into a

DB2 table.

Responsibilities:

. Validating XML file against an XML Schema.

. Reading data from an XML file.

. Writing errors to a text file using Stream Writer.

. Reading data from Excel spreadsheet using ADO.NET.

. Queries to insert rows into a table.

. Used Humming bird in order to view and update content in the DB2 tables.

. Used Harvest to promote it to Production.

. Involved in Unit Testing and Integration Testing

Strategic Systems, Columbus, OH Mar

2007 - May 2007

.NET Developer

Project Title: Accord Project

Environment and Tools: VB.NET, Oracle, ODP.NET, TOAD

Accord Project is a windows application. This system is designed to

generate emails for the clients, who have leased their cars and didn't

return them in a proper condition or made an accident (where the company

ends up paying) asking them to pay the amount the company has spent on the

car. So basically this system will generate reports (excel sheet) having

information about the car they have leased, the money the company has spent

to get into proper condition etc...

Responsibilities:

. Designed and developed various Win forms.

. Used Interop services in order to create an excel sheet and send it via

email (through Microsoft outlook) to clients.

. Used Toad as IDE for Oracle to check the data.

. Stored excel sheets in oracle as type BLOB

. Added search facility in order to look up for a particular record or

records.

. Written various stored procedures and cursors in order to retrieve and

store data.

Progressive Impressions International, Bloomington, IL

Dec 2006 - Mar 2007

Web Developer

Project Title: American Family Insurance Marketing on Demand (AMFMMOD)

Environment and Tools: C#.NET, ASP.NET 2.0, SQL Server 2005, Web Services,

Visual Source Safe, CSS, ADO.NET, Reporting Services.

AMFMMOD is an E-Commerce web application which enables the American Family

Insurance Agents to order all kinds of products like greeting cards,

postcards, self mailers etc for printing so that they can mail them to

their respective clients. This web application also keeps track of agents

profile and information regarding their orders and it allows an agent to

customize the message and the information he wants to be printed on the

products which he is going to order.

Responsibilities;

. Developed various web pages to view and enter data considering many

business rules.

. Provided File Uploading and File downloading options on clients desktop

. Developed web pages for viewing Annual Reports using Reporting services.

. Exporting data from web to Excel, word and Text format.

. Efficiently used User controls and Rad controls in various web pages in

order to show and edit data.

. Used Template columns in the data grid and data Repeaters.

. Used source control software Visual Source Safe 6.0 for effective source

control of the entire project.

. Developed stored procedures and SQL Queries.

. Designed and Created database tables.

. Involved in Unit Testing and Integration Testing.

Illinois Environmental Protection Agency, Springfield, IL

July 2005 - Dec 2006

Web Developer

Project Title: Loan Application (Financial Assistance System).

Environment and Tools: C#.Net 2.0, CSLA.NET 2.0, ASP.NET 2.0 and SQL Server

2005.

Loan Application is a module of Illinois Financial Assistance System. This

Loan Application system is designed to keep track of the information

regarding the applications for loans that come to IEPA. This system allows

IEPA to better monitor the loan applications which are being processed for

approval and also monitors applications after approval.

Responsibilities:

. Developed web application having 5-layers of (Presentation/UI/Business

Logic/Data Access and Data Storage) logical model in it, using asp.net 2.0

and csla.net framework 2.0.

. Involved in various meetings with staff in order to gather information.

. Written use cases and designed various classes.

. Developed class diagrams, flow diagrams and flow charts using UML.

. Developed a Class Library (generated a dll file) which makes the code to

be reused in different applications like windows, web and web services.

. Authentication is implemented through Light Weight Directory Access

Protocol (LDAP).

. Implemented role based security.

. Developed master pages in order to maintain consistent look through out

the system.

. Database design, analysis and development in SQL Server 2005.

. Designed, Created and maintained tables, views.

. Wrote stored procedures and SQL Queries.

. Used "SQL Server Import and Export Wizard" to import data from SQL Server

2000 to SQL Server 2005 which use Data Transformation Services (DTS).

. Used source control software Visual Source Safe 6.0 for effective source

control of the entire project.

. Involved in integration and testing of all modules.

Project Title: Illinois Volunteer Lake Monitoring Program

Environment: ASP.NET 2.0, ADO.NET 2.0, VB.NET 2.0, Web Services, SQL Server

2000, CSS, Visio, AJAX, Atlas, JavaScript, Visual Source Safe 6.0.

VLMP allows citizen volunteers within this program the ability to enter

sampling results and view this information instantaneously enriching their

experience. Data collected by citizens can be accurately and efficiently

tracked for quality control purposes. This project streamlines the business

processes currently in place enhancing the Government-to-Citizen (G2C)

relationship.

Responsibilities:

. Developed 3-tier web application with ASP.NET handling the presentation

layer and business logic layer and a Microsoft SQL Server2000 database as

the data repository.

. Involved in the analysis, UI design, development and implementation of

the application.

. Developed several data flow diagrams, flow charts, class diagrams using

UML

. Implemented Role Based Security model and Salting and hashing of secure

data.

. Form authentication using Light Weight Directory Access Protocol (LDAP)

though Novell

. Developed web pages for viewing announcements, Annual Reports and

Historical Data

. Involved in defining the configuration settings in Web.config file.

. Used source control software Visual Source Safe 6.0 for effective source

control of the entire project.

. Created and maintained tables, stored procedures, views, indexes,

triggers in SQL Server 2000

. Designed data modeling of components using Visio

. Used DTS to transfer data from MS Access to SQLServer2000 and scheduled a

night time job

. Validation of stored procedures making use of Query Analyzer.

. Involved in Unit testing the populated database for consistency.

Project Title: Data Logger

Environment and Tools: VB.Net, Web Services, Windows CE Device and MS

Access

This application is designed mainly to facilitate IEPA Staff working at

field to enter data into a Windows CE Device.

Responsibilities:

. Developed a smart device application which deploys on a Windows CE

(PDA)device.

. Created Web services to extract data from database and read/write it to

an XML file.

. Involved in defining the configuration settings using XML.

. XML was used to insert and retrieve the data from MS Access database.

. Developed Test cases for the components coded.

Raman Institute of Technology, Vijayawada Jan

2004 - Aug 2004

Web Developer

Project Title: Sales and Warranty Management System

Environment and Tools: ASP.NET and Sql Server 2000

This Project is all about computerizing the sales department transaction of

any company or organization and to provide better warranty and service to

customers. The main goal is to reduce human efforts.

Responsibilities:

. Designed and developed friendly user interface.

. Designed database in SQL Server 2000.

. Generated Invoice for each and every customer using crystal reports.

References available on request

Contact this candidate