Sql Server .Net Management Business Oracle Experience

[pic]

Vasantha

TranscriptID:******* 347-***-****

Status:EAD

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

Experience Summary

Around 7 years of IT experience with extensive experience in

designing, analysis, coding, bug fixing, testing and

implementing complex client /server, Intranet and Internet web

applications.

Extensive experience with C#, ASP,ASP.Net,ADO.Net,ADO,AJAX, XML,

XSLT, XPath,LINQ,WCF,WWF,WPF,SILVERLIGHT,Web Service, DOM, SOAP,

Visual Studio.Net 2003/2005/2008, SQL Reporting services,

SSRS,Infragistics 5.3, ASP, HTML,XHTML, DHTML, CSS, JavaScript, and

Crystal Reports 9.0.

Experience in T-SQL, PL/SQL, SQL Server 2000/2005/2008, Oracle 9i/10g,

MS Access, TOAD.

Experience in various Configuration Management tools like Visual

SourceSafe 6.0, Rational Clear Case 2003and PVCS.

Full life cycle experience including analysis, design, development,

testing, implementation and documentation.

Knowledge of SQL Server Reporting Services (SSRS) and SQl Server

Integration Services (SSIS)

Knowledge of Microsoft office Sharepoint server 2007(MOSS) and

Microsoft office Sharepoint services 3.0.(WSS).

Certifications

Brain bench Certified Programmer in ASP.net,ADO.NET and RDBMS

Technical Skills

Operating Systems : Win NT/2000/XP/Vista and MS-DOS

Software Skills : C#, ASP.NET, ADO.net, XML, XSLT, XPATH,

LINQ

Web Service, JavaScript, AJAX,HTML

DOM.WWF, WCF,SILVERLIGHT

RDBMS : Oracle 9i/10g, MS-SQLServer2000/2005/2008

Web Server : IIS 4.0/5.0/6.0

Web Tools : Visual Studio 2003/2005/2008

Networking :TCP/IP Protocal

Reporting Tools : Crystal Reports

Configuration Management Tools: Visual Source Safe 6.0, PVCS and

Rational Clear case 2003 .

PNC Bank NJ Aug 2007 to Present

Projects: Cash Management System - ATM

ATM functionality that will be utilized by ATM Cash Management to

efficiently and effectively manage the cash needs of

the PNC ATM network Cash Management System - ATM is to deliver a web

application solution to the Line of Business to manage their ATM network by

providing a central database repository to generate Replenishment and

Pickup Schedule & an interface to view and update ATM, Vendor & Vault

information and also to transition from the legacy MS Access database to

reliable SQL Server 2005 database with standby database for disaster

recovery.

. Involved in analysis, design, testing and project planning.

. Designed, developed and tested web applications using C#, ASP.Net,

Web Service, SQL Server 2005 and Oracle 10g.

. Developed the application on .Net n-tier architecture and

infrastructure.

. Created validation controls using ASP.net

. Developed Web Services using C# and XML for the Employee

Entitlements.

. Developed Windows service using framework 2.0.

. Developed graphical interface using Adobe Flex (Charting, data

Grids and other Flex controls) and C#.

. Developed and designed all stored procedures to support data

retrieval and insert and updates.

. Created NUnit test cases in Data access Layer and Business Layer

methods.

. Used Microsoft SourceSafe and CVS to maintain source integrity.

. Designed production deployment instruction document.

. Used AJAX for the Client side validation.

. Used Silverlight controls in gridview.

. Involved in Production Support to resolve the client issues.

. Used Microsoft application Blocks. It was an enhanced version

including Oracle ODP for better integration with ADO.Net.

. Used Linq to Retrieve the information from the xml.

Environment: C#, ASP. Net, IIS Web Server, AJAX, Visual Studio.Net

2005/2008, ADO.Net, SQL Server 2005/2008, Oracle 10g, NUnit, Adobe Flex,

VSS,Silverlight,

WCF.WWF.

Verizon NY April 2006 to July 2007

Projects: One Source Project (www22.verizon.com/OneSourceSystem/):

This application is used to get all the Verizon applications like

OneSource, COFEE and VZ.com onto one common platform for their ordering and

pricing services. An Integrated Ordering Infrastructure (I2O) will support

a re-useable cross-channel platform for new product offerings and roll-out.

It will enable new product additions and functionalities with minimal

effort, regardless of which Verizon Channel requires the functionality.

I2O, will collapse duplicate infrastructures, utilizing Microsoft .NET

technologies, thereby eliminating the use of costly platforms such as

Oracle and UNIX

. Designed, coded, implemented and tested applications using C#,

ASP.Net and SQL Server 2005.

. Developed Windows and Web Application using C#, ADO.Net, T-SQL.

. Implemented data access layer adapter components using Microsoft

Enterprise Application blocks, cryptography application block

(encrypting user and password), exception handling application

block (created own exception handlers).

. Developed methods in business layer calling .Net.

. Used third party APIs to retrieve XML data and inserted into

database.

. Involved in design, development, and implementation of local and

long distance application modules.

. Developed error log tool that retrieves error logs from production

servers.

. Created tables, Indexes, Sequences, Synonyms, Views and Triggers.

. Involved in customizing the Windows Forms Data grid.

. Developed custom controls for Windows Forms and generating reports.

. Coordinated with System test and UAT users and fixed all defects in

QC and UAT environment.

. Fixed issues after product released and worked with multiple

releases of the products.

. Coordinated with DBAs regarding creation of stored procedures

needed to collect data from other sources.

. Involved in developing JavaScript functions to handle client-side

validations.

. Worked Test-Driven Development (TDD) practices and unit testing

based on NUnit.

. Demonstrated eXtreme Programming (XP) and followed Test-Driven

Development (TDD) practices to cover unstable requirements.

. Used Visual SourceSafe and Clear Case to maintain source Integrity.

Environment: C#, ASP.Net, Visual Studio. Net 2003 /2005, ADO.Net, XML,

XSLT, Web Services, Infragistics 5.3, JavaScript, PL/SQL Developer, HTML,

CSS, Oracle 9i/10g, Visual SourceSafe 6.0, Clear Case 2003, nUnit, TDD

ePolicy Solutions CA July 2005 to

March 2006

Arch Insurance Group

The main goal of this project is to provide the core technology for

its underwriters, brokers and customers to rate, quote, bind, issue,

endorse, cancel and renew its specialty and commercial property and

casualty business in a real-time environment. Arch is a .net-based, object-

oriented, next-generation architecture that provides a comprehensive, fully

automated insurance distribution system that rates, binds, quotes and

issues policies online in real time at the producer, sub-producer and

customer level. Arch is scalable, easy to customize, and rich in

functionality. Some of Arch's benefits include: greater flexibility and

management of quotes and associated data stored in an XML format; improved

relationships with managing general agents/agents/customers through a multi-

tier channel hierarchy; flexible policy management options using ePolicy

Solutions' Insurance Bus and Customer Management Entity framework; improved

product definition and maintenance; and an External Systems Interface

framework that makes it easier to plug in and implement new tools, such as

third-party rating or document production systems.

. Designed, coded, implemented and tested applications using C#,

ASP.Net, XML, JavaScript and SQL Server 2000.

. Developed methods in business layer calling .Net and C#.

. Used Visual SourceSafe to maintain source integrity.

. Worked with various components to establish database connectivity.

. Attended health check calls and managed testing team.

. Used JavaScript to provide client side validations.

. Developed various stored procedures, constraints and views using

SQL Server.

. Designed database connectivity modules SQL Server 2000 as the

database.

. Developed stored procedures and other database objects.

. Testing and maintenance of the application.

. Updating the status to the Project Lead and interaction with team

members

Environment: C # VBScript, ADO.net, XML, HTML, Visual Studio 2003,

JavaScript, SQL Server 2000, Crystal Reports

World Wide Web Institute India April 2004 to May

2005

www.institute.net

The project, www.Institute.net, is an authorized World Wide Web Institute

for South Asia region of Geneva. The project is developed as per current

standards. It consists of links to the pages like About us, Institutes,

Student Enquiry, Business Enquiry, Feedback form, Email, Online Exam, Chat

and links to the details of various courses offered. Name of the web site

is Institute.net

. Client side programming using JavaScript & HTML

. Server side coding using C# and ASP.net

. Implemented server caching techniques, state management, Forms

Authentication in ASP.NET.

. Extensively used XML to read Email Send data for Staff, Instructor

and Center changes.

. Used Report Viewer controls to show the reports.

. Involved in Unit Testing and integration Testing.

Environment: # VBScript, ADO.net, XML, HTML, Visual Studio.net 2003,

JavaScript, SQL Server 2000

CHARMS January 2003 to March 2004

(Capricon Human Resources Accounting Recruiting Mananagement Sales)

Capricon Human Resources Accounting Recruiting Mananagement Sales (CHARMS)

is a system that integrates all internal departments and remote branches of

CSI, and is designed to increase the efficiency of CSI, in serving its

clients

Using an object oriented approach CHARMS was put through all the detailed

software development lifecycle steps. This included requirement prototyping

technology investigation, application architecture, low level design

construction and testing.

CHARMS is designed as a two tier client server application running on

windows 2000 server, Microsoft IIS web server and SQL server database to

control the backend. Security is provided at various levels including

firewalls, LAN, application and database.

. Client side programming using JavaScript & HTML

. Server side coding using ASP, VBScript.

. Involved in retrieving the data from database using ADO.

. Involved in Unit Testing and Integration.

Environment: HTML, MS-SQLSever, IIS 4.0, ASP, VBScript.

Contact this candidate