.Net Data Sales Sql Server Business Developer

Vyaghra S Kolluri

972-***-****(cell)

abm61y@r.postjobfree.com

Experience Summary

> 4+ years of IT Industry experience in Software Development involving

Analysis, Design, Development, Testing of applications and implementing n-

tier Client/Server applications using Object Oriented design

methodologies.

> Experience in developing Web based and Windows based applications using

.NET Framework, ASP.NET, VB.NET, C#. NET, ADO.NET, XML, XSLT.

> Expertise in developing/consuming Web Services using C#. NET, VB.NET, and

ASP.NET.

> Excellent skills in implementing ETL packages using DTS and SSIS 2008 and

expertise in generating reports using MS Reporting services, Crystal

Reports and business intelligence tools.

> Experience in design and development using latest technologies including

.NET 3.5/3.0, Windows Communication Foundation (WCF), Windows

Presentation Foundation (WPF), Service Oriented Architecture (SOA).

> Expertise in designing tables, database schemas, triggers, normalization

and store procedures on SQL server 2000/2005/2008.

> Experience in using Version Control System like Visual Source Safe, Team

Foundation Server.

> Strong knowledge in Object Oriented Analysis and Design (OOAD), agile

development methodology.

> Excellent communication and interpersonal skills.

Technical Skills

Operating Windows 9x,NT,2000,XP, Unix, Linux

Systems

Applications and Windows,Web-BasedApplications(C#.NET,VB.NET,ASP,

Technologies ASP.Net1.1/2.0, UML, ADO, AJAX, HTML, CSS, VB Script,

Java Script).

Web Services (XML, WSDL, SOAP, UDDI)

SSIS, DTS

Databases SQL Server 2000/2005 (T-SQL, Stored procedures, Triggers,

DML, DDL, DTS), Oracle 8i/9i/10g.

Web Servers Internet Information Server(IIS)

Development Microsoft Visual Studio.Net 2005/2008, DTS and SSIS,

Tools Final Builder,RedGate,TFS

Languages ASP.NET 1.1/2.0, C# .NET, VB.NET, C++, SQL, PL/SQL,

T-SQL, XML, HTML, JavaScript.

Reporting Tools MS Reporting Services,Crystal Reports, Business

Intelligence

Professional Experience

Humana Inc, Louisville, KY

April08 -Till Date

Applications Consultant

Description:

HumanaOne offers health insurance plans to individuals and family.

Applications are processed through various channels Online Application

(Consumers), Call centre Application (Tele-sales), Agent Work Bench

(Agents). These applications were re-designed for incorporating new

features which included ability to handle multiple surveys, multiple

workflows, signing the documents, auto issuing applications, introducing

new products specific to the consumer.

. Created dynamic GUIs with .Net Web Controls and Data Bound Web Forms.

. Involved in loading the documents on to the Adobe Document Server and

populating these Documents via web service.

. Worked on ASP.NET state Management, ASP.NET caching features,

configuring ASP.NET optimizations, securing ASP.NET web application.

. Wrote and supported DTS packages to extract data and feed them to

Underwriting Database and generated reports using Microsoft Reporting

services, Crystal reports.

. Migration of DTS Packages to SSIS Packages.

. Extensively worked on Transformations for data loading as well as data

validations. Designed and developed processes to identify the data

errors and provide suggestions to resolve them.

. Developed Windows Forms (WPF/XAML) and user controls (WPF) using MS

Visual Studio Team System 2008.

. Developed business objects in C# for implementation of business logic.

. Used JavaScript and ASP.NET Input Validation Controls for client side

validations.

. Was part of development of an Emphesys paper app which was a windows

based application were in used the WPF for greater look and feel of

the application.

. Extensively used Team Foundation server and was responsible for moving

code and data between various environments using tools Final Builder

and Red gate respectively.

. Supported numerous applications as part of On-call and resolved

incidents to meet the necessary SLA's.

. Utilized agile development methodology for creating new functionality

and updating the scrum work using Version One.

. Worked extensively on SQL server 2005 by creating jobs and

functionality for automating processes.

. Designed and Developed Data Access Layer to connect to the SQL Server

2005.

. Used ADO.NET objects such as Data Reader, Dataset and Data Adapter,

for consistent access to SQL 2005 data sources.

. Performed Unit Testing and System Integration Testing.

Environment: C#,XAML(WPF),.NET Framework 3.5 ADO.NET, Agile(Scrum)

Methodology,ASP.NET1.1/2.0/3.5, SQL Server 2000/2005/2008, Java script,

Windows XP/NT,Visual Studios 2008, TFS, Final Builder, Red Gate, DTS, SSIS,

Version One.

Citi Bank, Cincinnati, OH April

07 - March08

.Net/SQL Developer

Description

CitiBank is a leading financial service organization which provides various

banking features like online banking, online bill pay, etc. The project

involved development of a web based application, used for printing checks,

mailing, generating positive pay files to bank, tracking void / stopped

checks. This banking system reconciles transactions and always balances

account(s) debits and credits at the end of the year. This system is highly

secured and allows only authorized users to create new bank accounts and

reconciles checks. Application has many reports like Stop/void checks

Report, Re-printed checks report, Manual entries, user activity and many

more.

Responsibilities

. Developed GUI and Middle Tier using C# on .Net architecture.

. Developed used cases, sequence diagrams.

. Contributed towards the security model in .NET framework for the

administration module using Windows Authentication based on Role-based

security.

. Implemented XML Web Services in C# based on SOAP protocols using XML

extensively for data transfers.

. Used rich server controls of ASP.NET like Calendar and Data Grid.

. Extensively used JavaScript for client side validations.

. Used ADO.NET and data objects such as Data Adapter, Data Reader, Dataset,

Data table, and XMLTextreader/Writer for consistent access to SQL data

sources.

. Data Access Application Blocks were used for data manipulation and

retrieval.

. Involved in creating tables, stored procedures in SQL for data

manipulation and retrieval.

. Responsible for the debugging, testing, implementation of different

modules and developing web services

. Involved in UNIT testing and writing test cases in Test Directory.

Environment: C#, ASP.NET1.1, ADO.Net XML, JavaScript, SQL Server2000,

Windows XP, Visual Studios.Net 2003

Kroll, New Orleans LA

Oct06 - March 07

.Net Developer

Description

This intranet based application was designed and developed for the

pharmaceutical sales leads to do their business online. The system is aimed

to facilitate them with product information, distribution data of samples

to physicians and their usage analysis. The sales managers are provided

with login accounts to analyze and control the operations in their area.

All the data is recorded in the database which was used to analyze the

usage statistics. This architecture, being developed, includes an extended

3-Tier application architecture model using component-oriented middleware.

Responsibilities

. Analyzed business requirements and designed application using UML

Methodology and OOA/OOD structure

. Designed the application using extensive web controls and style sheets

. Front-end application was developed using ASP.NET Web Forms

. Designed database layer in .NET to communicate with database through

ADO.NET

. Created ASP.NET User Controls to reduce the complexity of user interface

design

. Created Validation Controls in ASP.NET web forms to capture new order and

customers, customer payments for validation

. Responsible for developing and creating Tables, Views and Stored

Procedures

. Wrote Stored procedures to populate customers, shipping, receivables

reports, month wise orders chart, inserting and updating users,

customers, create orders, customer's payments

Environment: ASP.NET, VB.NET, ADO.NET, ORACLE 9i, HTML, XML, CSS,

JavaScript, IIS, Windows 2000.

Infosys, India

June 05 - Aug 06

Internship

Description

NAMCO is an n-Tier architecture web based Core Banking Solutions with the

following facilities of Personal Loan, Jewel Loan, Deposits (FD/RD),

Savings A/c, Current A/c, NSC etc. It has modules for Insurance

Modification,Nominee Availability Details, Rejected Policy Status,

creation of loan, disbursal, repayment, EMI rescheduling with options like

changing the tenor, EMI Amount, Closure, Pre closure, Late closure, Showing

template for all the calculations and saving them. It has modules for User

Privileges -Create Role, Create User, Assign Role, and Map Role.

Responsibilities

. Served as a support consultant to project team in selecting

technologies and developing System architecture.

. Participated in the system study and preparation of software

requirement specifications and Database design.

. Developed data services using ADO.NET, also involved in testing the

applications.

. Writing SQL queries, SQL procedures, to handle the business rules and

data integrity.

. Involved in writing the documentation, testing the applications and

providing training to the users and team members.

Environment: ASP.NET, ADO.NET, IIS 5.0, HTML, CSS, DHTML, SQL Server 2000,

C#, Windows 2000

Education

Master's in Engineering at Louisiana Tech University

References

Available Upon Request

Contact this candidate