Sign in

Sql Server .Net

Texas, United States
October 04, 2016

Contact this candidate


Kavitha Reddy



*+ years of extensive experience in developing Client-Server and Web-based n-tier Architecture applications for windows and web based technology.

Proficient in Web Programming to enhance user experience and performance using JavaScript, J-Query, AJAX Toolkit and CSS.

Experience in developing applications using ASP.Net MVC 4.0 Framework, HTML5, CSS 3.0 and Entity Framework.

Used N-Hibernate as an object relational mapping tool.

Used SAML as an open standard data format for exchanging authentication and authorization data.

Experience in creating Server objects like Tables, Stored Procedures, Views, Indexes, Triggers, Cursors, user defined data types and functions.

Developed N-tier web applications using Visual Studio 2008/2010/2012/2013, C#, ASP.Net 3.0/3.5/4.0/4.5/5.0, ADO.Net, WCF, XML, SOAP,, Web Services, Web Forms, Win Forms, Microsoft .Net Frameworks.

Created Stored Procedures PL/SQL statements, Functions to manipulate the databases.

Implemented ADO.Net data access techniques i.e. SQL Connection Objects, SQL Command Objects, Data Set Objects, Data Reader Objects and Data Adapter objects using Data Grid and Data List in ADO.Net.

Extensively used LINQ (LINQ to SQL, LINQ to XML), ADO.NET, Entity Framework 4.0/5.0/6.0 and T-SQL in developing Data Access Layer.

Strong working experience in managing security policies including Authentication, Authorization, Identity, Encryption, Personalization, Membership, Roles, Profiles and Resources Access Control.

Used Windows Form to write rich client applications for Pc & etc.

Microsoft Access experience including application architecture design, table design, and wiring queries/stored procedure, forms and VBA code. Used DB2 to store, analyze and retrieve the data efficiently.

Experienced in design and development of Visual Basic applications.

Extensive experience with development & deployment of Web services (UDDI & WSDL), WCF services, SOA and MSMQ using the .NET Framework 3.0/3.5/4.0/4.5.

Worked extensively on XHTML, Oracle, HTML, HTML5, GUI, PL/SQL, XSLT, XAML and XML.

Extensively worked on developing applications using ASP.Net MVC.

Worked on CRYSTAL REPORTS for managing business intelligence applications.

Good Experience with MVP, MVVM, MVC and Singleton design pattern.

Good knowledge on Web API, WPF, Azure/Cloud, Silverlight and Microsoft Dynamics CRM.

Good Experience with WWF 3.0/4.0, Oracle, Log4net and Angular JS

Good Experience with IOC (Inversion of Control) and Dependency Injection.

Familiar with JavaScript libraries like Knockout.JS and Bootstrap templates and Backbone.js & Angular.js 8 framework.

Knowledge on CMS (Content Management Systems), WCF.

Used socket programming to have two applications communicate with each other.

Experience with Entity Framework approaches such as code-first and database-first.

Worked with IIS and Windows Server 2008 during application deployment.

Proficiency with Object Oriented Principles, Concepts and Best Practices.



ASP.NET, C#,, Java Script, j Query, HTML, WSDL, C, XML, XSLT

.Net Technologies

ASP.NET, ADO.NET, AJAX, C#.NET, Entity Framework 6.0/5.0/4.0, Web Forms, MVC based development, Crystal reports, Java Script, j Query, Backbone.js, TSF, CSS, Data models, WCF, WWF, MSMQ.IIS


PL/SQL, MS SQL SERVER 2008, SQL Server 2005/2008/2012, Oracle

Development Tools

Visual Studio 2005/2008/2010/2012/2013, SQL Server Management Studio 2012/2008/2005.


Windows 7/Vista/XP/NT/98, Windows Server 2008/2003.

Reporting Tools

SSIS, SSRS, Microsoft Reporting Services, Crystal Reports.

Hardware Exposure

System Integrating, Trouble Shooting, Handling of Intel 805X processors and programming them with C language.


Name of Degree: Bachelors of Technology

Specialization: Computer Science Engineering



Client: Bank of America, Hopewell, NJ Oct 2015- Present

Role: Senior Application/.Net Developer Domain: Financial

Bank of America is one of the world's largest financial institutions, serving individuals, small- and middle-market businesses and large corporations with a full range of banking, investing, asset management and other financial and risk management products and services

Project Description:

The Bank of America Integration allows Aprimo’s campaign management and dialogue manager users to pass existing customer information in real-time to Aprimo. This integration allows bank’s marketing team to conduct campaigns and offer different products and rewards to customers and for future campaign segmentation. Defined the business flow in Biztalk Orchestration and used Asynchronous communication and content enriches pattern to contact credit bureau for customer credit history information.


Worked with Product Manager to hash out requirements and helped bridge the gap between business requirements and technical implementation.

Used DDD (Domain Driven Design) concepts to help design and document architecture to promote Ubiquitous language and improve shared understanding of the project.

Involved throughout in Software Development Life Cycle (SDLC) process.

Involved in Design, Coding and testing phases of the project.

Practiced Agile Methodology in order to review progress of project in monthly sprints.

Followed Single Responsibility design principle throughout the project.

Used SOAP and REST services for requesting information from endpoints.

Used C#.NET to develop code for business and repository layer.

Worked with Web Api for building RESTful applications on the .Net Framework.

Used JQuery, Node.js in the JSP pages.

Created views and parital views – UI and middle tier for various modules using C#, MVC (Razor View Engine), AJAX, jQuery, HTML, CSS.

Extensive experience in developing tools using Access, VBA, Excel environment.

Used technologies provided by the .Net framework including ASP.NET, ADO.Net, Web services using SOAP and data manipulation using XML. Design of multiple web APIs.

Involved in coding member validation business functionality using WCF and client front end layers using WPF and Silverlight.

Create VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.

Developed Validating transactions using XML.

Experience in using interactive user experiences for Web Application.

Working with SOAP to provide communication between applications running on different operating systems, with different technologies and programming languages.

Technology leadership for the direction of the Cloud based application using Node.JS and MS SQL Server integrating to a proprietary framework.

Experience in Data Modeling, Designing and Creating Tables, Views, Stores Procedures, Triggers against Oracle 10g PL/SQL.

Working with windows Power Shell for task automation and configuration management.

Used the latest WPF/XAML vector based UI framework for the front end and WCF to implement the various services such as the QA services.

Design, Development of Win Forms using C#, Java Script for the user interface using the cdde behind class technique.

Enforce compliance with dynamic processing and security policies by using ESB.

Experience in using RAPID APPLICATION DEVELOPMENT (RAD), to create a system that can be modularized in 2-3 months of time.

Mainly used XML for encoding documents in a format which in both human & machine readable.

Have used Service Oriented Architecture (SOA) to develop web services.

Also used Azure for Scaling and checking the reliability of the applications which were developed during the project.

Testing and reproducing the issue to determine if there is a defect.

Experience with all phases of SDLC in the waterfall model and Agile (SCRUM) methodologies.

Used BizTalk framework provided by Microsoft for integrating with the web services that supports both SOAP and WSDL.

Strong working experience in managing Security policies including Authentication, Authorization, Identity, Encryption, Personalization, Membership, Roles, Profiles and Resource Access Control.

Working with Power Shell to provide a scripting language for the applications.

Experience with Angular JS for creating Single page Applications.

Experience with Web Services, Web Forms, Win Forms, Microsoft .Net Frameworks.

Used MVVM, Unity, Factory, Abstract Factory, Singleton, MVP and MVC design patterns.

Used LINQ to aggregate data from repository layers.

Wrote business logic to fetch and update data from database and displayed on Win Forms.

Used collections, interfaces, abstract classes to implement the project and also worked with the Exception Handling.

Used WCF services for communicating with Microsoft SCCM (System Center Configuration Manager) server. One of the purposes was for license management.

Experience working on MVVM (Model View, View Model) in applications.

Experience working on Windows 8.

Used Bootstrap CSS for front end design.

Used SQL Server 2012 Standard Edition for database.

Involved in writing test plans and writing test scripts for Unit Testing.

Used Team Foundation Server (TFS) for version control.

Environment: ASP.NET 4.0, C#, Web Services, WCF, MVC 4.0, WWF, LINQ, HTML, DB2, CS, Excel, Access, VBA, IIS, Visual Studio 2013/2012,Pl/SQL, SQL Server 2008/2012, RESTFUL, SQL Server Management Studio 2012, BizTalk, Entity Framework 5.0, AJAX, ADO .NET Framework, MVC Architecture Hibernate, TFS, SSIS, WPF, SOAP, Angular JS, Backbone.js, Unit Testing, Agile(Scrum), Azure, SAML, MVVM, XML, XSLT, WIX, MS Dynamic CRM.

Client: UBS, Milwaukee, WI Feb 2013 to Sep 2015

Role: Senior .Net/MVC Developer Domain: Financial

UBS works with private clients, institutions and corporations around the world to help answer some of life's questions – whether through expert wealth management advice, investment banking and asset management expertise, or general banking advice in Switzerland.

Project Description:

Resource Management application is used by internal users to keep track of various projects budget information. This application allows them to view all the projects which are Submitted, Planning, Completed, and Cancelled. The application also allows viewing hierarchical information based on the Roles (Project Coordinator, Assigned Lead, and Admin). Once the budgets are allocated for the projects, Project manager can allocate the funds for the current years and upcoming years.


Understanding and analyzing the client’s requirement.

Involved in the development of new applications and enhancement of existing applications to provide additional functionality.

Developed web forms in ASP.Net using C#.Net, AJAX Controls, HTML and JavaScript.

Developed several MVC applications with ASP.NET MVC, JavaScript, jQuery, JSON, HTML, XHTML, CSS, and REST Client.

Used SignalR to add real-time web functionality to Kendo UI grids.

Using Bootstrap, implemented a Responsive Web Design. After the initial page load, application executed all data transactions with the server through MVC 4 Web API via JSON, no additional full page loads were initiated. Implementing client-side data-binding via knockout.js (MVVM pattern).

Used SOAP and REST services for requesting information from endpoints.

Used Nugget Package Manager to produce and consume several nugget packages which are used in several applications.

Used Windows Power Shell Scripting which provides full access to COM and WMI enabling administrators to perform administrative tasks on both local and remote Windows systems.

Used XSLT to convert one XML document to other XML document like pdf, HTML for web pages.

Extensive massaging & analyzing data using MS Excel, Pivot Tables & Charts and VBA.

Have used Service Oriented Architecture (SOA) to develop web services.

Wrote stored procedures with complex SQL queries.

Written Complex PL/SQL Scripts, Stored Procedures and Views in Oracle 10g database, Optimized NHibernate queries by looking at raw SQL generated.

Assisted with automation of finance department’s manual processes by writing VBA code and using macros and formulas to speed processes and maximize accuracy.

Used List, Trees, Toolbars, Menus and Context Menus for navigating between pages in Windows Presentation Foundation (WPF).

Working with SOAP for exchanging information.

Implemented application business logic in C# with MVP design pattern to increase unit tests support.

Extensive logging and error handling was performed in C# using log4net.

Created tables and Stored Procedures in SQL Server 2008 and used LINQ for querying objects.

Used Axosoft for bug reporting, project and release tracking.

Developed word forms using VBA to conduct various surveys in order to optimize monthly report based on team usage.

Designed the application as 3-tier architecture with extensive use of Object Oriented Programming techniques.

Used C#.NET to develop code business and repository layer.

Experience using Silverlight in creating and using interactive user.

Used BizTalk framework provided by Microsoft for integrating with the web services that supports both SOAP and WSDL.

Used LINQ to retrieve the data from the backend through NHibernate.

Used Team Foundation Server as Source Control.

Resolved QA bugs for front end and back end.

Returned data to front-end in JSON format.

Be available on-call rotation to assist in project development, operational and maintenance issues in all the environments (DV, QA and UAT).

Environment: C#, ASP.NET MVC 3.0, AJAX, bootstrap, Js, WCF, VB.Net, NHibernate, WPF, CSS3 60, LINQ, JSON, Entity Framework, Visual Studio 2010, VBA, EAI, HTML5, XHTML, SQL SERVER 2008, jQuery6, T-SQL 8, Backbone.js & Angular.js 8 framework, VSS, IIS, Web Services, SOAP, Silver light, Rapid Application Development (RAD), Azure.

Client: Caliber Home Loans, Irving, TX Aug 2010 – Dec 2012

Role: Senior Programmer Analyst Domain: Financial

Caliber Home Loans is a full-service national mortgage lender and agency direct seller/servicer. Caliber originates loans through various channels and transaction types, including a network of retail branches, wholesale lending, and correspondent lending, and a consumer-direct centralized operation specializing in a variety of loan programs for purchase and refinance such as conforming, jumbo, and government products

Project Description:

This project is mainly about Mortgage enables home owners to convert part of their home equity into liquid funds without having to sell their property, give up the title, or get new conventional mortgage financing with monthly payments. Reverse Mortgage system is designed to maintain the Reverse Mortgage Loans. This application maintains lender, property, borrower, rate, payment, balances, contact details and status of each loan. And the system also generates various reports viz. Cash Book, Deposits, Repayment Log, Insurance tracking etc.


Created several ASP.NET pages using ASP.NET, C#, ADO.NET, LINQ and SQL Server 2008.

Designed User Controls (.ascx) for document upload, Comments Input, Multi Select Dropdown and Risk Question Control, which was used heavily across the application.

Created Business Layer/Data Access Layer using C#, ADO.NET, LINQ and SQL Server 2008.

Created WCF services to expose HLBVA data using C# and LINQ-SQL.

Used LLBNGen for code generation of stored procedures and Entity Framework.

Worked on IBM File Net for the workflow of the project.

Worked with SQL Server Integration Services (SSIS).

Created Stored Procedures/Functions in SQL Server Using T-SQL.

Extensively worked on developing applications using Azure.

Designed and implemented the UI with extensive use of Dojo, JavaScript, JQuery and Ajax.

Designed reports using SSRS and called them in Web Application.

Worked on Performance related Issues in SQL Server database.

Consumed web services (WCF) created by Rule server application.

Developed WCF services to save/get the data for portfolio screen using C# and LINQ.

Used CSS classes/skins for client side control UI formatting and provide same look and feel throughout the application.

Created SSIS packages to extract data from different Databases.

Used Microsoft Team Foundation Server for source repository and version control.

Started working on migrating ASP.NET application to ASP.NET MVC application.

Created windows application in win forms, C# and LINQ-SQL.

Used Team Foundation Server (TFS) for source code management.

Environment: ASP.NET 3.5, MVC2.0, C#, ADO.NET, VS.NET, T-SQL, XML, SQL Server 2005/2008, AJAX Control Toolkit, SOAP, LINQ, JQuery, TFS, ORM, Winforms.

Client: Cyient, Bangalore, India April 2008 –June2010

Role: .Net Developer Domain: IT Services

Cyient is an acknowledged leader in engineering design services, design-led manufacturing, networks and operations, data transformation, and analytics. We collaborate with our clients to help them achieve more and together shape a better future.

Project Description:

In this project, our team analyzed designed and developed a fully functional website using ASP.NET. The website is an N-tier (3 tier) web application designed, developed and updated using .NET framework 3.5.


Got trained on various techniques in .NET application development with ASP Web Forms, Win Forms, C#.NET as code behind and SQL Server 2005 as database.

Understanding the functional requirements, studying the system specifications and designing the Object Model for the software using Object Oriented Techniques with the 3-tier architecture.

Designed and developed user interface using ASP.NET and C#.NET.

Developed user controls and validation controls using ASP.NET.

Created applications using SILVERLIGHT.

Was involved in all the stages of development from the Design till the Maintenance.

Master Pages were developed and used for uniformly and CSS were coded and used for implementing themes.

Implemented business logic as .NET Framework assemblies using C#.NET.

Used ADO.NET and related data objects such as Data Adapter, Data Reader, Data Set and Data Table for consistent access to SQL data sources. Used LINQ for updating data through C#.

Coded Stored Procedures that contained joins and used in ADO.NET for creating, updating, or deleting the data and even perform some information related tasks with multiple tables.

Prepared user documentation.

Environment: .Net 2.0, C#, Visual Studio 2005/2008, Java Script, SQL Server Management Studio 2005, ADO.NET Entity Framework, Silver light.

Contact this candidate