Sql Server Project

Pavani Vaddi

(: 217-***-****

E-mail: ************@*****.***

IT PROFESSIONAL - SOFTWARE DEVELOPMENT

Expertise in Software Development from the feasibility to the

implementation stage

. Hands-on experience in SDLC (requirements gathering, design, development,

deployment and testing), Internet, Intranet, Client/Server, Multi-tier

and Windows applications development.

. Well versed in development of applications using various Microsoft .NET

Technologies like C#, ASP.NET 1.1/2.0/3.0/3.5, ADO.NET, XML, Visual

Studio.NET, SQL Server 2005/2008.

. Experienced in handling various projects from the feasibility to the

implementation stage while handling research & requirement analysis.

. Experience in web & windows development of Health Care.

. Strong debugging and problem solving skills with excellent understanding

of system development methodologies, techniques and tools.

. Proficient in creating Web Forms, Win Forms, Navigation controls, User

Controls and Custom controls, Master Pages, Cascading Style Sheets (CSS)

and data extraction.

. Proficient in writing procedures, functions, triggers from large and

complex data sources using SQL server 2005/2008 with added advantage of

expertise in writing Complex SQL Queries.

. Possess sound knowledge in Object oriented programming, Memory

management, Garbage Collection, Exception handling, debugging, security

and next-generation interfaces with reusable AJAX components.

Technical Skills

Technologies: ASP.NET, C#.NET, CSS, ADO.Net, AJAX and Web services.

Scripting Languages: Java Script and HTML.

RDBMS: SQL Server 2005/2008, MS-Access

Others: Reporting Services

SAP Data warehousing: SAP BI 7.0 and BW

ERP Package: SAP R/3, ECC 6.0

Career Profile

Regions bank

09/13 to Present

Brimingham, AL

.Net Developer

Regions Bank works for the value added services like financial services,

retirement services, corporate and municipal bonds, natural resource

services for the customers of the regions bank. This application involves

providing accessibility for these services to the customers online. The

application checks the client validity and allows them to check offered

plans online and subscribe for the services. The client can also check the

status of their returns upon subscription .The relevant data is gathered

from various sources and a list of different options is displayed to the

user in a graphical format.

Responsibilities:

. Developed UI components using ASP.NET and C#.

. Interacted with external clients for and requirements gathering.

. Involved in Analysis and Design of all the modules within the

application.

. Created ASP.NET Web forms, Win Forms and server controls to display

dynamic data obtained through the use of Microsoft ADO.NET and Data

binding.

. Used CSS (Cascading Style Sheets) for branding purposes and user look

and feel and JavaScript for Client side validation.

. Heavily used .NET Web Controls, Validation Controls and User

Controls.

. Used Caching feature to increase the user response.

. Extensively used the ASP.NET features like Grid View, Detail View and

other controls.

. Used cookies, Sessions and View state to store user information.

. Wrote SQL stored procedures, Functions to execute various database

routines.

. Worked on security issues related to user Authentication and

Authorization.

. Designed and Created Complex Reports, Sub-Reports using Crystal

reports.

Environment:

Visual Studio.NET, ASP.NET, C#, ADO.Net, Java Script, CSS, SQL Server,

Crystal Reports, HTML.

AHIMA (American Health Information Management Association)

10/12 to 09/13

Chicago, IL

.Net Developer

AHIMA offers a wide range of coding programs. Obviously it needs an

application where the classes can be scheduled and the students submit

their applications. All the data collected from the online applications

will be stored in the database and allow the staff to accept or reject the

applications accordingly and also arrange online classes for those

qualified students.

Responsibilities:

. Design and coding of the project.

. Developing web services and Consumption of them.

. Involved in the development of all modules in this project.

. Write system design documents.

. Document via a log, the calls, problems and the support that is

provided.

. Extensively used Java Scripts for implementing various business

functionalities.

. Involved in Software Development Life Cycle of the project (SDLC).

. Ability to analyze performance and scale bottlenecks and propose

solutions to mitigate them.

. Used File Net Professional capture in our project to auto index values

by reading barcode values.

. Worked on SQL Server Reporting Services.

Environment:

ASP.NET, C#.NET, XML, ASP.NET Web Services, SQL Server 2005, CSS and Visual

Studio .NET.

Transdyne IT Services(Sandiago, CA)

09/08 to 05/12

Hyderabad, India.

Project 1: Web Delivery

Description - Web Delivery streamlines document-based business processes

and eliminates lost documents, delays, and help desk calls, by providing

immediate, Web-based distribution and access to documents. Unlike static

document repositories, Web Delivery are designed to ensure recipients are

notified and receive documents based on sender authorized delivery

options, and document lifecycle. Unique Web Delivery recipient accounts

provide document recipients with self-managed configuration, delivery

options, and member access, which reduce sender maintenance. Maintenance

of history of all customer interactions with alerts for scheduling future

communications.

Environment:

Visual Studio.NET, ASP.Net, C#, Web services, CSS and SQL Server2008.

Project 2: Smart Flow

Description - System used by medical transcription companies to

distribute voice files automatically among employees, transcription and

proofreading of distributed files and generating feedback and audits for

transcribed documents. Includes macros developed in word and excel like

gender checks, auto phrases, populating patient details and implementing

validations as per the client's request for user convenience, reducing

error rate and smooth transition of workflow while transcribing

documents.

Environment:

Visual Studio.NET, ASP.Net, C#, Ms-Word and SQL Server 2008.

Project 3: Auto Uploader / Downloader

Description - Download dictated voice files from client servers to

company US server and then to India server through FTP. Upload the

completed transcripts from India server to US server and then to client

server. All the details pertaining to the voice files like account

information, provider information, duration of the audio file, etc., are

captured and automated during the download process. Documents will

directly be sent to clients' printers during the upload process.

Multithreading has been implemented in this project to speed up the

process. Billing will be generated while uploading the documents to

client.

Environment:

Visual Studio.NET, ASP.Net, C#, Web services, Windows Services and SQL

Server.

Responsibilities:

. Requirement gathering and R&D process.

. User Interface designing

. Developed Coding in C#; Implemented Ajax Validations.

. Performance of unit testing, preparation of documentation for

developed design and code modules.

. Maintenance of client interaction for collation of requirements. Also

involved in designing of Master Page and Themes for admin module.

. Developed CSS Style Sheet of Entire Portal.

. Worked on 3 tier architecture.

. Developed the reports module using crystal reports.

. Functioned as Developer involved in analysis, design and development

of project, developed detailed technical specifications for subsystems

and code for enhancement of existing programs or development of new

programs.

. Translated business requirements into technical specifications,

designed and modeled classes.

. Implemented client side validations using Java Script and User Control

for rich user interface.

. Used AJAX Controls and Extenders to increase the functionality of web

page and reduce network traffic besides implementing partial page

updates using Update Panel of ASP.NET AJAX.

. Maintained records in excel spreadsheets and explored data into SQL

Server Database.

Production support Executive in TransDyne IT Services, INDIA from Aug 2003

to Aug 2008.

. Maintaining TAT (turnaround time frame of 2 to 24 hours) per

client requirements and taking care of stat requests.

. Keeping track of the volumes and informing client if there is

any discrepancy.

. Assisting the production managers regarding the previous day's

performance and any additional expectations set for the day.

Data searching from the archives.

. Handling billing issues and getting approvals by coordinating

with US Office.

. Putting across the client requests to various departments in

improving efficiency.

. Logging complaints into Complaint Mngt System.

Education

B.C.A. (Bachelor of Computer Applications) from M.C.R.P. University,

Bhopal, India

Contact this candidate