Sql Server .Net
Resume:
VISHWA SALLA
******.******@*****.***
SUMMARY
8+ plus years of experience in Designing and Developing Web applications using Microsoft Technologies, ASP.NET, C#, ADO.NET, SQL Server involving N-Tier, Client/Server Architecture
Involved in Analysis, Design, Development, testing and deployment of Software Development Life Cycle
Excellent experience in creating Web applications using ASP.NET Web Forms, C#, ADO.NET, Web Services, WCF Services, XML, JavaScript, HTML, CSS
Proficient with Web Server Controls, HTML Controls, User Controls, Custom Controls using ASP.NET Expertise with ADO.NET components Dataset, DataTable, DataAdapter and DataReader
Experience in implementing Error handling, Exception management, Tracing and Logging features
Experience in writing client side validation script using JavaScript(JQuery)
Excellent experience in creating & consuming Web services and WCF Services using C#.
Strong abilities in Database Normalization, Stored Procedures, Triggers, Views, Functions
Worked on Singleton, Factory, Façade and ASP.NET MVC Design patterns
Proficiency in Designing and Developing using SQL Server Reporting Services (SSRS)
Experience in using Microsoft Visual SourceSafe and Source Vault for version control
Involved in Code reviews and Unit Testing
Experience in requirements gathering and analysis
Excellent Team player with strong analytical, problem solving, interpersonal skills and quick learning abilities.
Extremely adaptive to new environments and good team work player as well as an individual
Technical Skills
Programming Languages
C# 5.0/4.0, C, ADO.Net, JavaScript, PL/SQL, T-SQL
Web Technologies
ASP.NET 4.5/4.0/3.5, ASP.Net MVC 3, WCF 4.5/4.0, LINQ, XML, Web Services, AJAX
Mark-up/Scripting Language
JavaScript (JQuery), AngularJs,VBScript, HTML, CSS
Framework /Architecture
.NET Framework 4.5/4.0/3.5/3.0
Database
MS SQL Server 2012/2008/2005, Oracle 9i/10g, MS Access
Reporting Tools
SQL Server Reporting Services (SSRS)
Version Control
Team Foundation Server (TFS), Microsoft Visual Source Safe (VSS)
Tools
Nunit, VSTS
Application/Web Servers
Microsoft IIS 7.5/7.0/6.0/5.0
Operating System
Windows 7/VISTA/XP/2003/2000
PROJECT EXPERIENCE
Lincoln Financial Group, Philadelphia, PA October 2015 - Present
Programmer Analyst
Description: Lincoln Financial Group is offering a diverse range of financial services and solutions. With a strong focus on four core business areas life insurance, annuities, retirement plan services, and group protection. The goal of the project was to develop a system that allows advisors to track Insurance and Broker Dealer Business through the Service Life Cycle - Placement, Approval, Pending and Paid
Responsibilities:
Designed and developed .NET web components and user controls using ASP.NET and C#
Involved in analysis, development and testing phases of this project
Developed master pages and handled events between master pages and content pages
Developed Data Access layer using ADO.NET objects DataAdapter, DataSet, DataReader and DataTable.
Programmed ADO.NET for communication between application and the database
Designed and developed WCF Services to exchange data between UI and backend database and consumed WCF services
Created Web forms using Grid View for displaying set of records
Implemented JQuery for Client side sorting and validations
Have used ASP.NET Validation controls to do client-side validations
Implemented LINQ for querying, sorting and filtering complex objects.
Created DataSets to retrieve the data required to generate the reports using SSRS
Involved in unit testing, module testing and integration testing.
Environment: ASP.Net 4.5, C# 4.0, ADO.Net, XML, JavaScript, CSS, HTML, Visual Studio 2012, SQL Server 2012
Lincoln Financial Group, Greensboro, NC July 2013 - March 2014
Programmer Analyst
Description: Lincoln Financial Group is offering a diverse range of financial services and solutions. With a strong focus on four core business areas life insurance, annuities, retirement plan services, and group protection. The goal of the project was to develop a system that allows advisors to track Insurance and Broker Dealer Business through the Service Life Cycle - Placement, Approval, Pending and Paid
Responsibilities:
Designed and developed .NET web components and user controls using ASP.NET and C#
Involved in analysis, development and testing phases of this project
Developed master pages and handled events between master pages and content pages
Developed Data Access layer using ADO.NET objects DataAdapter, DataSet, DataReader and DataTable.
Programmed ADO.NET for communication between application and the database
Designed and developed WCF Services to exchange data between UI and backend database and consumed WCF services
Created Web forms using Grid View for displaying set of records
Implemented JQuery for Client side sorting and validations
Have used ASP.NET Validation controls to do client-side validations
Implemented LINQ for querying, sorting and filtering complex objects.
Created DataSets to retrieve the data required to generate the reports using SSRS
Involved in unit testing, module testing and integration testing.
Environment: ASP.Net 4.5, C# 4.0, ADO.Net, XML, JavaScript, CSS, HTML, Visual Studio 2012, SQL Server 2012
ClarkCounty, Nevada Jan 2013 - May 2013
Programmer Analyst
The County provides municipal services that include fire protection, roads and other public works, parks and recreation, and planning and development. The goal of the application was to provide information for Las Vegas Metro Police, and other departments in Clark County like Criminal History Reports, General Inquiry Reports, Clearance certificates etc
Responsibilities:
Involved in analysis, development and testing phases of this project
Developed master pages and handled events between master pages and content pages
Designed and developed .NET web components and user controls using ASP.NET and C#
Developed Data Access layer using ADO.NET objects DataAdapter, DataSet, DataReader and DataTable.
Programmed ADO.NET for communication between application and the database
Designed and Created database objects such as stored procedures, packages, functions, triggers
Designed and developed WCF Services to exchange data between UI and backend database and consumed WCF services
Created Web forms using Grid View for displaying set of records
Implemented JQuery for Client side sorting and validations
Have used ASP.NET Validation controls to do client-side validations
Implemented LINQ for querying, sorting and filtering complex objects.
Created DataSets to retrieve the data required to generate the reports using SSRS
Involved in unit testing, module testing and integration testing.
Environment: ASP.Net 4.0, C# 4.0, ADO.Net, SSRS, XML, JavaScript, CSS, HTML, Visual Studio 2010, SQL Server 2008, IIS 7.0
Education Profession Standard Board Web Portal Mar 2011 – Dec 2012
www.epsb.ky.gov
EPSB, Frankfort, KY
Programmer Analyst
Education Professional standard Board Web Portal Application provides Cooperating Teacher Payment Program, Legal Case Tracking System, Kentucky Educator Certification Inquiry, Intern Management System, and Program Manager Etc.
Responsibilities:
Involved in designing and developing database tables, stored procedures, triggers and views for different applications.
Developed SQL Server PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules in SQL Server
Have use of Master Pages, CSS and HTML to design look and feel of the web pages in ASP.NET.
Created DataGrid Web forms using Grid View, Data List and Repeater for displaying set of records.
Programmed ADO.NET for communication between application and database, used extensively Data Set, Data Table, Data Views and Data Readers.
Design and developing WCF Services to exchange data between UI and backend database and consumed WCF service by adding (.svc) references.
Client-Side Scripting was performed using Java Script.
Have used ASP.NET Validation controls to do server-side validations and client-side validations based on the user’s browser.
Created multiple DataSets to retrieve the data required to generate the reports and created different types of Reports using SSRS
Performed debugging and testing.
Environment: ASP.Net 3.5, C#3.0, ADO.Net, XML, JavaScript, CSS, HTML, DHTML, Visual Studio 2010, SQL Server 2008, IIS 7.0.
CardioSmart Aug 2009 - Feb 2011
http:// CardioSmart.org
American College of Cardiology, Washington, DC
Programmer
American College of Cardiology advocates the cardiovascular care through education, research promotion, and by ACC members, they signal to their peers and patients their commitment to quality cardiovascular care.
CardioSmart.org is Web application the delivery the patient information. This Application provides details on risk factors, specific conditions, as well as on diagnostic tests and treatments patients may encounter; online blood pressure and condition tracking; a video library; patient stories Featured with to add ACC member profiles, contact information and Specialties services provided to patient’s. Also
Responsibilities:
Involved in analyzing, design, development and testing of the CardioSmart project.
Designed and Developed Web form to listing of cardiovascular physician members Cardiology details based
there Name, Specialties and Nearby Location using ASP.NET, C#, ADO.NET, SQL
Created and Consumed Web Service to get the Physician Members data from SQL Server database using C#,
Web Services, ADO.NET
Created master pages and user controls to design the layout of Cardio Smart WebSite
Designed and Developed Web form to Add Member profile and contact information using ASP.NET, C#
Created and Consumed Web Service to get the Update Members data to SQL Server database
using C#, Web Services, ADO.NET
Worked with ADO.NET objects DataAdapter, DataReader, and DataSet to access the database.
Wrote SQL queries and stored procedures.
Involved in application deployment and database setup for releases.
Performed unit testing, system testing and integration testing
Environment: ASP.NET 3.5, C# 3.0, ADO.NET, XML, JavaScript, CSS, HTML, DHTML, TFS, WCF, Visual Studio 2008, SQL Server 2005, IIS 6.0.
Medical Insurance Invoice Apr 2007 - Jul 2009
http:/www.blueridgeallergy.com
Blue Ridge Allergy and Asthma Inc, Falls Church, VA
Sr.Programmer
Blue Ridge provides healthcare services for various treatments and also performs evaluation for the treatment .This is a web based application to process medical invoices faster and more efficiently. It has the features to handle to complete charge entry system, electronic and paper filing capabilities, tracking and on-line viewing individual payment history, electronic responses from individual payers.
Responsibilities:
Designed and developed Admin and customer modules in ASP.NET, C#, and HTML.
Used ADO.NET for processing and retrieving information from the database.
Developed SQL queries using various joins and developed various dynamic SQL’s throughout the projects.
Involved in designing and developing data base tables, stored procedures, triggers and views
Used ADO.NET for processing and retrieving information from the database.
Developed views, stored procedures, functions and triggers in SQL Server 2005 to fulfill business requirements.
Created WCF service to create, retrieve, update and delete bill transactions.
Developed JavaScript’s for client side validation.
Worked with QA team to quickly resolve issues.
Performed Unit testing to test the application for performance.
Involved in test meetings to discuss the issues arising out of testing.
Responsible for Development of Various reports in Crystal Report
Environment: ASP.NET 3.5, C# 3.0, ADO.NET, XML, JavaScript, CSS, HTML, DHTML, TFS, WCF, Visual Studio 2005, SQL Server 2005, IIS 6.0.
Web Shopping Feb 2006 - Mar 2007
http:/www.chattary.com
Chattary Ajwan InfoTech, Ahmedabad
Programmer
This project is an online shopping network. It is a virtual self - serving shopping avenue. It allows the Administrator to add the products to the website based on the categories. It also allows to process the orders placed by the customer and to know about the order status. In this a customer can browse the catalog, add products to their personal shopping cart and when finished check out and finalize the sale. It also contains an Admin module through which customer and products can be maintained.
Responsibilities:
Designed and developed Admin and customer modules in ASP.NET, VB.NET, and HTML.
Used ADO.NET for processing and retrieving information from the database.
Developed views, stored procedures, functions and triggers in SQL Server 2005 to fulfill business requirements.
Developed JavaScript’s for client side validation.
Worked with QA team to quickly resolve issues.
Performed Unit testing to test the application for performance.
Involved in test meetings to discuss the issues arising out of testing.
Responsible for Development of Various reports in Crystal Report
Environment: ASP.NET 2.0, C#2.0, Crystal report, ADO.NET, XML, JavaScript, CSS, HTML, DHTML, TFS, WCF, Visual Studio 2005, SQL Server 2005, IIS 6.0.
Educational Qualification
Bachelor of Engineering, Nagpur University
Contact this candidate