Post Job Free

Resume

Sign in

Sql Server .Net

Location:
Hyderabad, Telangana, India
Posted:
December 15, 2016

Contact this candidate

Resume:

Divya G

.NET Developer

Phone: +1-469-***-****

Email Id: acxwm9@r.postjobfree.com

Summary:

Around 8+ years of experience in Analysis, Design, Coding, Testing and implementation of Web and Windows based Applications using .NET technologies in accordance with the best practice methodologies and complete Software Development Life Cycle.

Expertise in programming with C#, VB.NET, ASP.NET, ADO.NET, SQL-Server 2015/2012/2008/2005/2000, Oracle 10g/9i, Visual Studio 2016/2015/2013/2010, Ajax, LINQ, CSS and IIS 7/6.

Expertise in web technologies like HTML, XHTML, DHTML, XML, XSLT and JavaScript.

Extensive working experience in database design and development, for creating complex database queries, writing Constraints, Indexes, Views, and Stored Procedures and Functions using T-SQL in SQL and MySQL.

Expertise in Object Oriented Analysis (OOA) and Object Oriented Design (OOD) using Unified Modeling Language (UML) and Object Oriented Programming (OOPS concepts).

Extensive working experience with different methodologies like Agile, Scrum, Test-driven development (TDD)using Fakes and Waterfall methodologies.

Hands on experience in creating content driven and user-friendly applications using Expression Blend, WPF and Silverlight.

Extensive experience with process modeling using UML, Flow charts, Sequence diagrams, Activity diagrams and Use cases by using tools like MS Visio.

Proficient with .NET Web Services, Windows Communication Foundation (WCF) using WSDL, SOAP and UDDI protocols.

Expertise in Developing WCF Services that implement the Service-Oriented Architecture (SOA).

Good experience with N-Tier architecture and MVC pattern.

Good knowledge and experience with Web Forms, HTML5, CSS3, AJAX, JQuery, JavaScript, JSON, VBScript, and designing User Interfaces and knowledge on Telerik Kendo UI.

Expertise in Design and Development of Interfaces, User Controls and Custom Controls using ASP.NET and C#.

Expertise in using SQL Helper Class, Error Handling and Logging Microsoft Enterprise Application Blocks.

Experience in handling various backend data sources like MS Access and XML Data source.

Implemented .NET Security features such as Authentication & Authorization using Form-based and Window-based Authentication, Authorizing Users, Roles and User Account Impersonation.

Knowledge on Windows based applications using WinForms and Parent Form.

Experience in using various version controlling tools like Visual SourceSafe, Sub Version and Team Foundation Server.

Proficient in writing Technical and Functional test scripts. Experienced in test driven development using N-Unit Testing for the piecewise testing of the Applications and had experience in assisting our testing team with tools like Fakes framework.

Knowledge on ADO.NET Entity Framework objects layer and modeling layer.

Proven ability to analyze problems, root causes, and develop innovative solutions to business challenges and streamlining operations.

Experience in handling Multiple Message Patterns and Reliable and queued Messages and Durable Messages working with WCF.

Exceptional ability to quickly master new Technologies and capable of working in-group as well as independently with a sense of responsibility and ownership.

Experience in creating ETL packages using SQL Server 2005 Integration Services (SSIS).

Technical Skills:

.NET Technologies

ASP.NET (4.6,4.5.1/4.5/4.0), ADO.NET, SQL, ENTITY FRAMEWORK (5.0/4.0), XML, Web Services (SOAP, WSDL), Web Forms, Win Forms, RESTful Services, Web API LINQ, WCF, WPF, MVC (5.0/4.0/3.0).

Programming Languages

C#.Net (4.5/4.0/3.5/3.0), VB.NET, Visual Basic 6.0, and C Programming, SQL.

Markup Languages

XML, XSTL, XAML, HTML 5.0/4.0, CSS /CSS3

Scripting Languages

JavaScript, jQuery, AngularJS 1.4/1.0, Ajax

Database

Microsoft SQL Server 2005/2008/2012, Oracle (9i/10g/11g), PL/SQL, MS Access 2013/2010/2007

Operating Systems

Windows 2000/XP Professional/Vista/7/8/8.1 and Windows 10.

Application Tools

MS-Office (Excel, Access, Word), Microsoft Project.

Web Servers

Microsoft Internet Information Server (IIS 5.0/6.0/7.0/7.5)

Development Tools

Visual Studio (2015/2013/2012/2010/2008/2005), Team Foundation Server (2008/2010/2012/2015), Visual Source Safe (VSS), Tortoise SVN, Microsoft Azure, GitHub.

Reporting Tools

Crystal Reports (2010 / 9 / 8.5 / 8), SQL Server Reporting Services (SSRS), NUnit Framework.

Professional Experience:

UnitedHealth Group, Plano, TX May2015-TillDate

Sr. DOT Net Developer

Description: UnitedHealth Group Inc.is an American diversified managed health care company. UnitedHealth Group offers a spectrum of products and services through two operating businesses, United Healthcare and Optum, both subsidiaries of UnitedHealth Group. The major projects were designed to work as an Agent facing application on surveys and claims. Both windows and web applications are used at best to support the process of providing quality support. Windows application has all the functionality required for the internal users to accept all the Cases and process. Used Asp.net MVC for building Web pages with css3 to give html5 documents for consistent appearance.

Responsibilities:

Involved in the complete Software Development Life Cycle including Design, Implementation, Testing and Maintenance

Responsible for designing the ASP.NET application Authentication using .NET Framework, Model View Controller (MVC) and IIS 7.5 security model.

Used Windows Communication Foundation(WCF) to develop Web service messages and manage protocol-level communication by using the WS-* protocols.

Designed WEBFORMS using ASP.NET for developing the search doctor module.

Used Microsoft Team Foundation Server (TFS) for source access management.

Used ASP.NET MVC Page Controller pattern to add functionality to individual pages such that to accept input from the page request, invoke the requested actions.

Responsible for Designing and Developing the Reusable UI Components Like MVC Master Pages ‘Layouts and Nested Layouts’, ‘View Start’ and MVC User Controls ‘Partial Views’.

Experience in working with JavaScript Frameworks like Angular JS, which simplifies JavaScript object bindings with HTML Elements and client server communications.

Created various Angular Services and injected them into Angular Controllers (using Dependency Injection) to enable AJAX calls and created Custom angular directives to create own HTML tags and induce functional behavior to those tags.

Implemented AJAX functionality using Angular JS to load contents individually in different partial views to minimize loading time and for better user experience.

Used Entity Framework Code First Approach to interact with Database and implemented the Mappings, Model Changes, CRUD (Create, Retrieve, Update, Delete) operations and dealt with performance issues.

Developed ASP.NET MVC 5 applications using Code First Approach in Entity Framework and UI in Razor View Engine.

Used ADO.NET for SQL server database interactions using Data Adapters Data Reader and Dataset.

Used SOAP over http to Implement Web Services and Consumed and published XML web services in the application.

Used JSON to transmit data between Server and Web Application an alternative to XML Serialization.

Consumed Restful Web Services with Angular JS updating the Model and Views of the application.

Used ASP.NET MVC Page Controller pattern to add functionality to individual pages such that to accept input from the page request, invoke the requested actions.

Implemented WEB API Services for CRUD operations with HTTP verbs GET, POST, PUT and DELETE.

Used HTTP Response Exception to handle the exceptions in Web API and customized the Exceptions using Exception Filters and registered them at the Action Level.

Used Cascading Style Sheets (CSS) to import various styles in Html for the views (Presentation layer).

Worked on all the required Stored Procedures, User Defined Functions, Triggers, and Views using T-SQL as per business logic.

Extensively used LINQ to SQL, LINQ to Entities to manipulate the data in database.

Implemented Unit Testing using NUnit and involved in Integration Testing and Regression Testing.

Used various report items like tables, sub report and charts to develop the reports in SSRS (SQL Server Reporting Service).

Implemented Reports using SQL Server Reporting Services, Crystal Reports by using stored procedures implemented in the SQL Server 2012/2008.

Worked in AGILE and SCRUM environment regularly attending the Status Meetings and updating status to Scrum Master.

Actively participated in Design reviews for creating new functionalities for Anthem clients.

Involved in the process of developing Technical design specification documents.

Environment: Visual Studio 2015/2016, SQL SERVER 2015, ADO.NET, IIS7.5/7.0, .NET Framework 4.5.1, C#.NET 4.0, ASP.NET, MVC 5.0, LINQ, TFS, Web Services, WCF, Razor, Entity Framework 4.5, JavaScript, Ajax, CSS3, Angular JS 1.4, NUnit, Web API, HTML5, RESTful Services, SOAP, T-SQL (Transact- SQL), AGILE Methodology

State Farm Insurance, Bloomington, IL Aug 2013 to April 2015

Role: .Net Developer

Description: The major projects were designed to work as an Agent facing application, Emphasis was laid on Agents creating Quotes converting an existing quote into an application, creating Policy coverage, administer their customers, make payments etc. I was also involved in different phases of other applications, majorly working as a Frontend and backend developer for internal applications.

Responsibilities:

Interacting with client for requirements, discussing the feasibility of requirements, designing the layout of web pages, Architecture and participating in the development.

Involved in designing, trading and documentation of application flows and developed functional diagrams using Visio.

Created and consumed Restful Web Services to transfer Claims Data between Claims IT group and our application (using progressive architecture).

Design & Develop Presentation Layer User Interface screens using Web Forms and used CSS3 to give HTML5 documents an attractive and consistent appearance.

Designed with user experience and performance in mind, Infragistics Windows Forms controls giving the ability to focus on business logic.

Used Custom Validations, Validation Controls and performed validations both on client side and server side.

Created the security framework for implementing a strong authorization and authentication.

Client side validation was handled using JavaScript and ASP.NET controls.

Supported the application 24*7 handling user issues, incidents and problems.

Developed the middle tier business logic components using .net framework that interact with the database and processes all the data for the presentation layer to display and involved in various phases of database design like Logical and Physical layers.

Worked extensively on designing database tables, Stored Procedures, Functions and Triggers using SQL Server 2008.

Provided Session Management and View State to preserve the state of session variables.

Developed rich client interface using Windows presentation Foundation (WPF) and Silverlight 3.0.

Involved in Supporting and Troubleshoot Data conversion activities throughout the phases of development.

Handled Run Time & Design Time Errors by implementing appropriate Error Handlers in C# and Tracing.

Involved in unit testing and integration testing of the application.

Involved in Source Code Integration in Azure automation using GitHub Repository as the versioning tool.

Environment: ASP.NET 4.0, C#.Net Framework4.0, ADO.NET, OOPS, HTML5, CSS3, JavaScript, AJAX, WPF, Silverlight, Visual Studio 2015, UML, SQL Server 2015, Web Forms, Web Services, GitHub

Client: Comcast, Philadelphia, PA Dec 2011 to July2013 Role: .Net Developer

Description: Comcast, is an American multinational mass media company largest cable TV company and is the largest broadcasting and largest cable company in the world by revenue and largest home Internet service provider in the United States, home telephone service provider.

Responsibilities:

Participated in System Analysis and Application Designing Sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed IT solution.

Developed a 3- tier web application following Agile development methodology.

Developed programming scenarios in C#, object oriented Programming (OOP) concepts such as: encapsulation, inheritance, polymorphism, and abstraction.

Involved with Analysis and designing of the application.

Used Tortoise SVN as Source Control and Document management.

Performed unit testing to ensure quality and optimum performance output.

Engaged in development of web pages using ASP.NET MVC4.0, XML, VB.Net, CSS and UI enhancement coding.

Involved in design and maintenance of DB2 Server database, including requirements analysis, design, data conversion, data loading, testing and implementation.

Writing Stored procedures, triggers, views and function for enhancements and development.

C#.NET is used to program business logic including Code-behind files and Classes in the middle tier.

Used JavaScript and .NET Validation Controls for performing client-side validations.

Developed Service Oriented Architecture (SOA) that provided methods for system development and integration.

Extensively involved in User Interface designing using Web forms and Win forms.

Extensively Created GUI User Controls using server controls of ASP.Net like Data grids, Repeaters, Textbox, Button, Dropdown List etc.

Designed user interface screens and implementing / coding application logic under Microsoft .NET framework using C# to use .NET features that powered with CLR.

Worked on ADO.NET Entity Framework and LINQ for developing the core data layers.

Designed and Architected the Application using MVC and designed the application using responsive web design to work on different devices.

Worked in ASP.NET Web Forms, ASP.NET State Management, ASP.NET caching features, configuring ASP.NET optimizations, securing ASP.NET web application and used ADO.Net to connect to SQL Server.

Developed client side validation through Angular JS and dynamic UI using JavaScript and HTML5 and DHTML.

Implemented SSIS and DTS packages to extract, transform and load data packages.

Used Web forms, ADO.Net in ASP.Net for security checking purposes.

Documentation of developed Components and module.

Testing and packing of the developed module.

Responsible for Database support of the application.

Performed database operations on SQL Server 2012 to create and maintain customer’s information by creating SQL queries, stored procedures, functions, and views.

Created complicated reports like parameter based reports, sub reports, well formatted reports, matrix reports, chart and tabular using SSRS 2008.

Environment: Windows server, Visual Studio 2010/2013, ASP.Net, C#, VB.Net, ADO.Net, XML, .NET Framework 4.0, IIS 6.0, C#.NET, HTML4, CSS, AJAX, JavaScript, Angular JS, Tortoise SVN, Web Services, SQL Server 2012, T-SQL, Crystal Reports, SSIS, SQL Reporting Services(SSRS).

GGK Technologies., India Aug 2008 to Oct 2011

.Net Developer

Description: This intranet application included pages that allow employees to submit problems they experience with software, hardware or their computers as help desk tickets that are sent to an IT administrator. It also has pages where company employees discuss important company related affairs and an address book that provides detailed information about every employee within the company. The admin tools section provides the interface for these kinds of interaction. Inside the site, there is also a page that allows administrators to send e-mail newsletters to the company employees.

Responsibilities:

Involved in Requirement Analysis, designed and developed Web application using ASP.NET 2.0 and C#.

Designed the ASP.Net pages and the master and the navigation pages.

Used Team Foundation Server (TFS) as the source control in the entire development life cycle of the application.

Implemented Business layer using Windows Communication Foundation (WCF).

Used Ajax in different ways to avoid full page post-back and make the application more users interactive.

Created tables, indexes and other database objects for application.

Involved designing the front-end screens and checking for the client validations on the screen controls while inputting the required information.

Optimized queries within existing SQL stored procedures.

Designed and developed various web server controls including Data Grid, Data List and Navigation controls.

Developed codes in business layer for retrieving and storing data to and from the database using the ADO.Net connectivity tools.

Environment: C#.NET, ASP.NET 3.0, Web Forms, wcf, HTML, XML, AJAX, SQL server 2008, TFS, ADO.NET

Education: Bachelor of Technology, Jawaharlal Nehru Technological University.



Contact this candidate