Sql Server .Net

Chaitanya

************@*****.*** Mobile: 704-***-****

Professional Summary

* ***** ** *********** ********** crossing in both Windows and Web-based Microsoft technologies. Proficient in C#, WPF, WinForms, ASP.NET, ASP.Net MVC, WCF, AJAX, Silverlight with an experience in .NET Framework and SQL Server with emphasis on object-oriented programming.

Strong in the complete Software Development Life Cycle (SDLC) including requirements definition, design, programming / testing and implementation of major systems.

Developed and Designed Web Application using MVC design pattern, Web Forms, User Control, Derived Control and Custom Control as Validation Controls, Navigation controls, Data toolbox controls using ADO.NET & ASP.NET with C# codes behind classes, Validated these pages using JavaScript, under Visual Studio. NET environment.

Developed Solutions for Diverse Programming Scenarios in C#, Object Oriented Analysis (OOA), Object Oriented Design (OOD), and Object Oriented Programming (OOP) Concepts as Encapsulation, Inheritance, Polymorphism, Abstraction, Multithreading and Modularity to maximize the advantage of code reuse.

Rich Experience working with ADO.NET objects as Data Reader, Dataset and Data Adapter for consistent access to SQL&Oracle data sources.

Extensive Experience in Language Integrated Query as LINQ to Object, LINQ to SQL, LINQ to XML, Entity Framework, ODBC, OLEDB, Microsoft SQL Server and Oracle.

Strong Exposure in MVC Web Applications as Validation using Data Annotation, Model-View-Controller (MVC), Razor syntax, Layout, Partial view, Unit Test& Third-party Authentication.

Extensively applied the advantage of separation of concern &Repository design pattern for model data and in-depth knowledge of .NET Framework, Common Language Runtime (CLR), Garbage Collection (GC), Common Type System (CTS).

Utilized the framework concept to develop Web Form application, Windows Form application and MVC Web application.

Developed Front-end for ASP.NET Web applications, using HTML5/HTML, JavaScript, JQuery, Master Pages, CSS3 and CSS.

Strong Exposure in several DESIGN PATTERNS such as Singleton, Factory and ASP.NET MVC. Developed highly decoupled application using Facade, Factory, and Observerpatterns

Extensive experience in handling Internet Information Server (IIS), Creating and configuring the virtual directories, map them to physical folders and configuration of the applications for domain authentication, Data Transformation Services (DTS) in SQL Server.

Experience in design and implementation of services using WCF SOAP\REST, creating REST services using ASP .NET Web API.

Working experience on the source control software packages like Microsoft Visual Source Safe (VSS), Team foundation Server (TFS) and Tortoise SVN.

A highly motivated individual who is always learning, able to work to tight deadlines, and who can communicate effectively with technical peers as well as business users.

Tools & Technologies:

Microsoft Technologies

.NET Framework 4.5/4.0/3.5/3.0/2.0/1.x, ADO.NET, LINQ, ADO.NET, Entity Framework WPF, WCF, WWF, COM,N-hibernate

Languages

C#, ASP.NET, VB.NET

Frameworks

.NET MVC 4/5, MVVM, JS, JavaScript, Angular JS, Bootstrap

Web Development Technologies

ASP.NET, Web Services, Web Forms, Win Forms, AJAX, AJAX Toolkit HTML5/HTML, CSS3/CSS, DHTML, XML, XAML Enterprise Library, XPATH, XSD, JavaScript, JQuery, XHTML, CSS3,CSS5,SOAP,Web API, REST, Session bag, Expression Trees, Extension Methods, Impersonation, Auto Mappers, IOC, Visual Source Safe (VSS), Generic Repository pattern

Database Technologies

MS SQL Server, MS Access, Oracle, MySQL, MS Access

Microsoft Software

Visual Studio.NET

Reporting & ETL Integration Tools

Crystal Reports, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)

Operating System

Windows 2008/2007/2003/2000/NT/XP/Vista/98

Version Control

VSS, Team Foundation Server (TFS), Cruise control, SVN

Application Server

IIS 7/6/5

Design Pattern

MVC, MVP, MVVM

SDLC Methodologies

AGILE, SCRUM, RUP, Waterfall, UML

OLTP, OLAP, Other Skills

MS SSMS, SSIS, SSRS, SQL Server Analysis Services (SSAS)

Testing Framework & Tools

JIRA, MS Test Manager, SoapUI

Projects:

Sr .Net Developer Feb 2015 - Present

American Airlines, Dallas, TX

Description: American Airlines Inc. is a major U.S. airline headquartered in Fort Worth, Texas. It operates an extensive international and domestic network, with scheduled flights throughout North America, the Caribbean, South America, Europe, and Asia. Its route network centers around five "cornerstone" hubs are in Dallas/Fort Worth, New York, Los Angeles, Miami, and Chicago.

Responsibilities:

●Implemented View Model concepts in Model-View-Control (MVC5) software architecture in Web Applications to develop new objects from the retrieving data collections for better separation concern.

●Designed and Developed user interfaces using ASP.NET Web forms, Visual C# and interacted with Bas for resolving functional issues. C# for code using Partial classes, Abstract classes, Delegate methods & developed user controls for the binding of data's in Master pages.

●Achieved both Server-Side and Client-Side Validation using Data Annotations, C#.NET, HTML5/HTML helper, CSS3/CSS, Master Pages, JavaScript, JQuery, Web Parts and Data controls, which are used for the entire site giving the site a dynamic look.

●Developed presentation-tier ASP.NET pages in C#, HTML using techniques such as Data Grid control, Validation Control, session state management.

●Implemented Forms Based Authentication,ASP.NET Validation Controls used for user validation, User state through User Session & Application Page objects, deferred session state was built to store & retrieve session information of users, data retrieval using ADO.NET.

●Created and deployed XML Web Services (WCF) using C#, used them to generate the proxy class files based on the Web Services and consumed in Web application.

●Created and maintained SSIS packages to Import/Export data from Flat files, XML, Excel and Oracle. Extracted Transformed and Loaded data from different sources to Data warehouse using SSIS and created ad-hoc reports using SSRS.

●Developed highly decoupled application using Model View Presenter, Factory, & Observer patterns. Business Logic & Data Access layers communicated via interfaces.

●Entities class as the model layer in MVP. Transported data across layers using these entities class & in application release & responsible for defect free migration in various environments.

●Used LINQ to Entities, LINQ to SQL, LINQ to XML and LINQ to Objects for retrieving the data proficiently. Used LINQ to manipulate and fetch the data from database. Utilized WPF&LINQto SQLFrameworks to write quality code in business tiers.

●Used Team Foundation Server (TFS) for project repository and versioning control, and source code along with the maintenance of the builds and the relevant documents of the same.

Environment:.NET Framework 4.0, Visual Studio 2012, ASP.NET MVC5, AJAX, C#.NET, WCF, SOAP, Web API/ Web Services, MS SQL Server 2012, SSMS, SQL, TSQL, TFS, LINQ To SQL, SoapUI, IIS7.5/7.0, SSRS, SSIS, Team Foundation Server2012 (TFS)

Sr .Net Developer Nov 2013 - Jan 2015

Department of Transport, Richmond, VA

Description: The Virginia Department of Transportation is the State of Virginia governmental organization responsible for state transportation infrastructure. This project includes ongoing operations and maintenance as well as planning for future needs of the state and its citizens. It’s responsible for overseeing the disbursement of federal, state, and grant funding for the transportation programs of the state.

Responsibilities:

Designed the complete solution using N-tier Architecture model and design patterns mainly Abstract Factory and Singleton.

Worked on Agile Methodology to practice-based methodology for modeling and documentation of software-based systems.

Developed the business components Class, ASP.NET web services using C#, SOAP to encapsulate business logic components to be used in distributed environment.

Configured Windows Communication Foundation(WCF) service to authenticate clients with Windows credentials for intranet applications for login validations.

Used ASP.NET Page lifecycle Techniques and handle a control's initialization, instantiating controls, restoring and maintaining state, running event handler code, and rendering.

Developed Web forms for User Interfaces using ASP.NET and C#.NET using Server controls, HTML controls and User controls.

Used C#.NET and PL/SQL Procedures in-order to access the oracle database for the front-end presentation.

Implemented ORM mapping between C# & Oracle using N-Hibernate.

Implemented features of ASP.NET AJAX such as Calendar Controls, Repeater Control, and Validation controls, Dataset, Security using forms authentication.

Created data access layer to communicate with the SQL Server Database using N-Hibernate.

Developed the necessary Stored Procedures.

Created Complex Views using Joins for robust and fast retrieval of data in SQL Server using T-SQL.

Created Unit tests using NUnit Framework and Experienced in creating complicated SQL queries.

Created batch processes for processing end of day files.

Used Tortoise SVN for Source Control.

Environment: C# .NET, ASP.NET, ADO.NET, Microsoft Visual Studio 2010, AJAX, PL/SQL, Oracle 10g, Hibernate, WCF, LINQ, NANT, SQL Server 2008 R2, XML, XSLT, XPATH, CSS, NUnit.

.Net Developer Jan 2013 - Oct 2013

Lender Processing Services, Westminster, CO

Description: LPS Field Services is in the business of providing field services to mortgage servicers for satisfying their loan servicing requirements which are governed by Federal, State and local laws. These Field services comprise of Inspections and Preservation of the assets of the mortgage servicers.

Responsibilities:

Gathering the requirements for building the application.

Prepare high level and detailed design documents.

Prepare Use Cases and Test Cases.

Developed the application using C#.net, MVC, Angular JS, SQL Server technologies.

Developed Classes, interfaces for the Data Access layer using C# and Entity Framework.

Used JQuery for browser compatibility and telerik controls for rich UI functionality.

Meeting with QA for bugs/enhancements in modules.

Actively participate in database design meetings.

Maintaining Audit Log using Sql Server R2 Change Tracking System.

Developed XML and Collection parser using LINQ.

Writing WCF Services to interact with Business Components.

Actively participate in code reviews.

Actively involved in new R&D work as and when required.

Handled the TFS branching & merging.

Created TFS team builds for the application.

Automated the deployment of application on lower and higher environments.

Involved in release and deployment of the application.

Team Co-Ordination with offshore folks.

Prepared Technical document for future development reference.

Used TFS for Version Control.

Environment: Visual Studio 2010,C#, ASP.Net, .NET Framework 3.5, SQL Server 2008 and 2012, Entity Framework, WCF, LINQ, MVC Pattern, Web Forms, Web Parts, JQuery, XML, TFS 2010, Windows 7/2008.

.Net Developer Aug 2011 – Dec 2012

Chevron Corporation, Dallas, TX

Description: GOM Offshore Logistics is an application suite targeted for the offshore users (Offshore dispatchers, Facility Managers, Shorebase dispatchers etc.) of Gulf of Mexico to perform their daily logistics tasks like the Shipping and Receiving, Vessel Tracking, Inventory management, Personnel on Board. These applications are developed as plugins under the Smartbox Framework.

Responsibilities:

Created ASP.NET pages with web server controls for the presentation layer.

Implemented validation using validation controls, JQuery and JavaScript client side validations.

Developed web applications using ASP.NET and AJAX Extensions under MVC architecture.

Created WinForms and Web Forms for developing the applications using winControls, webserver controls and HTML controls.

Using Entity Framework, connected to relational data by writing LINQ to SQL queries.

Involved in all the phases of the Software Development Life Cycle including System Analysis, Design and Development.

Implemented Page level security and permissions based on the authentication details.

Developed administrative functions such as assigning property viewing permissions and adding system users.

Written Web Service for Messaging module passing user data from Manager to Sales Team and vice versa using C#.Net.

Designed reports and written some dynamic calculations for reports using SQL Server Reporting Services.

Data Formatting was done using HTML, CSS and client side scripting using JQuery.

Involved in the development of business logic in C#. NET.

Created web custom controls and web user controls where necessary.

Created and consumed WCF Services using C#, ADO.NET and SQL Server

Resolved issues in other applications that are used VB.NET.

Working with Team Foundation Server as the source for version control and project / issue management.

Environment: ASP.NET, C#, ADO.NET, Visual Studio.NET 2008, T- SQL, XML, SQL Server 2005,Oracle 10i, .NET Framework 3.5, WCF, WPF,AJAX Control Toolkit, TFS, Infragistics, NHibernate, SQL Server 2005 HTML, XML, Web Services.

.Net Developer Jun 2008 - Jul 2011

Avon Technologies, INDIA

Description: Net Asset Management brings state-of-the-art software technology to financial institutions and their Advisors. Various products offered by the company allow institutions, such as advisory firms, insurance companies, broker-dealers and banks to private label their web-based platform to provide separate account and mutual fund wrap programs to advisors. It also automates the fee-based advisory business and integrates sophisticated financial planning products and services.

Responsibilities:

Involved in discussions with users/managers to gather necessary requirements.

Designed and developed Asset Allocation module

Developed online financial reports using Active PDF

Designed and developed various dynamic financial charts and images using Chart FX

Developed Web Services that is used to download Client data from the Advisory firms on daily basis

Developed services using XML and XPath.

Involved in Requirements Gathering, Development and Testing of the application.

Developed reusable and optimized .NET components using C#.

Written some client side script using JavaScript.

Involved in Studying of existing database design and implementing required enhancements.

Implemented AJAX in many web pages.

Identified and created indexes to fetch the data efficiently and wrote stored procedures to update and retrieve data effectively in SQL Server.

Involved in Unit & Integration testing of the application.

Used VSS to maintain the version and source control.

Involved in Documentation of the project

Environment: ASP.NET 2.0, 3.0 C#, XML, SOAP, Java Script, DHTML, Crystal Reports, and MS SQL Server 2000

Contact this candidate