Sql Server .Net

Summary

A competent professional with * years of IT experience in phases of Software Development Life Cycle (SDLC) such as Planning, Analysis, Design, Implementation, Testing and Maintenance of Web Based, Client-Server and N-tier Architectures.

Experienced in a fast paced Agile Development Environment including SCRUM Programming.

Hands on experience in design using Object Oriented Programming Principles like Encapsulation, Inheritance, Polymorphism and Abstraction.

Extensive experience of developing and designing software applications with the .NET Framework, ASP.NET, ADO .NET, AJAX, LINQ, WCF, CSS, Java script, JQUERY, SQL SERVER, Web Services, SOAP. Working with MVC, Windows Environment.

Responsible for designing Presentation Layer (web pages) using the concepts such as Master Pages, User Controls, HTML, XML, CSS, JQuery and also worked with ASP.NET Custom Controls.

Working with MVC, Windows Environment.

Experience in developing ASP.NET Web customs controls, user controls, Data Controls like Grid View, Rich UI with extensive use of ASP.NET AJAX, AngularJS, Bootstrap and JQuery.

Experience in using Language-Integrated Query (LINQ) query and retrieve data from different data sources (LINQ to Objects, LINQ to XML, and LINQ to SQL).

Proficient in Implementing WCF services and consuming using different protocols and implementing features like Security, Debugging and Performance.

Extensive Experience in Implementing View, Model, Controller and View model by using ASP.Net MVC 4.0/3.0 Framework.

Worked extensively with ADO .NET objects such as Data Adapter, Dataset, and Data Reader to interact with databases like SQL Server 2008/2005.

Experience in database related work primarily creating complex stored procedure, Views, Triggers, Functions using PL/SQL, T-SQL.

Hands-on experience with Reporting Tools SQL Server Reporting Services (SSRS).

Technical Skills

Programming Languages: C# .NET(4.5/4.0/3.5/3.0), HTML, T-SQL, PL/SQL

Web Technologies: ASP.NET 4.5/4.0/3.5/3.0, MVC 4.0/3.0, Ajax 3.0/2.0, JQuery, AngularJS, Bootstrap, HTML, CSS3.

Xml Technologies: XML

UI Technologies: WinForms

IDE Tools: Visual Studio 2013/2012/2010/2008/2005, SQL Server Management Studio. SQL Server BI studio

.Net Frameworks: .Net Framework 4.5/.4.0/3.5/3.0

Databases: MS SQL SERVER 2008/2005, MYSQL

Reporting Tools: SQL Server Reporting Services (SSRS 2008/2005)

Version Control Tools: Subversion (SVN), Team Foundation Server (2010/2008)

Middleware: WCF, ADO.NET 4.5/4.0/3.5/3.0, LINQ, LINQ to XML, LINQ to ENTITIES, E-SQL, Web Services, Enterprise Library 5.0/4.0/3.1

Servers: Windows Server 2008/2003/NT, Microsoft IIS (7.0/6.0/5.0/4.0).

Professional Experiences

Client: Anthem, Norfolk VA August 2014 - Present

Role: Senior Dot Net Developer

Description: Cost Containment Unit (CCU) and Prepay application was mainly created for providers, vendors and clients to work together on the unified platform to track the information’s of the claims processing and also to developed a new single page applications for the third party vendors to work on claims and to verify the existing claim information is valid in the facets and Calculate the amount of money overpaid to the providers and adjust them in the future claims.

Responsibilities:

Development of application Cost Containment Unit (CCU) and Prepay.

Implemented ASP MVC 5.0/4.0 framework for the development of the application.

Extensively used JQUERY to make client side validations and used AJAX calls where ever necessary for auto filing fields and performing asynchronous calls.

Created Models, Views, Controller and code behind in MVC

Implemented Interface whenever possible to enhance usability, testability and to increase performance.

Designed Application using prominent design patterns to enhance extensibility, and promote standards to program to an interface rather than implementation.

Controlled overall look and feel of ASP.NET web site by consuming twitter Boot strap.

Extensively used XML and JSON Serialization for transferring the data from controller to view.

Created WCF Services used different bindings to make it available to different types of clients.

Developed ASP.Net Web API Controllers that involved in implementation of service layer components and data object layer components using ASP.Net MVC Web Application.

Consumed different ASP.Net Web API’s to retrieve customers’ information and other application related information

Designed and developed SOA architecture with WCF binding concepts for making data binding for end points.

Used Data List with Paging and Sorting for displaying various data on to the page.

Created, Data Access Layer, Business Logic Layer Classes using C# and .Net 4.0.

Used role based security functionality in MVC to restrict Users to certain pages Read only.

Extensively used pages for the layout of applications and used Partial Views.

Used custom error handling in Web API to pass proper error message rather than generic error message to better understand the error.

Improvised user experience using JQuery. Used JQuery event handling mechanism to dynamically assign events on web controls.

Developed Stored Procedures, Triggers using PL/SQL used accordingly.

Leveraged JQuery for page scripting, AJAX calls and JSON and XML for passing objects from Controller to View and vice versa.

LINQ was extensively used in view extension to parse out unnecessary information and to make call to SQL database.

Created and maintained database objects like complex Stored Procedures, Packages, Triggers, Cursors, Tables, Function’s, and View’s.

Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.

Used Sub Version for source control

Implemented Unit Testing, Integration Testing and System Testing using NUNIT.

Environment: VisualStudio2012, C#, ASP.NET MVC /5.04.0, WCF, Entity Frame Work 4.0, Java Script, JQuery, JSON, Subversion, WCF, Web API, IIS 7.0, AJAX, AngularJS, Bootstrap, HTML, CSS, LINQ, XML, Microsoft Enterprise Library automatic code generation, UNIT, SQL Server 2008 R2, Windows Server 2003, Windows Server 2008 R2/2008.

Client: Xerox, Orange CA February 2013 - July 2014

Role: Senior Dot Net Developer

Description: This application is created for individuals, clients, brokers and small businesses easily shop for, compare and buy health insurance plans with ease from carriers. Application created as a solution for states to comply with the Patient Protection and Affordable Care Act. An intuitive web page will guide consumers through the application process with a number of useful tools including: out of pocket cost calculators, plan sorting by primary care provider, prescription drug availability and hospital network. Application primarily focuses on increasing the number of insured Persons by facilitating the purchase and sale of health insurance that provides quality health care through the creation of a transparent, simplified marketplace of qualified health plans.

Responsibilities:

Involved in gathering project requirements and documenting design specifications

Developed the initial screen designs (layout, code structure, visual cues (icons, graphics, messages, etc.), working with developers and visual designers to provide the finished interface for this system.

Involved in developing Business and Database logic

Created user interface layer by defining the project standards and guidelines.

Used MVC HTML helper controls to display the data

Effectively used Partial Views where ever its useful.

Implemented Data access layer (DAL) using Entity Framework with database SQL Server by creating Functions, Triggers and Store Procedures in T-SQL

Created and consumed WCF services to transfer data about analysis within different departments on the samples provided to them. I had retail experience in health insurance plan.

Implemented Authentication and Authorization security mechanisms.

Closely involved with the database team in developing stored procedures, functions, views, triggers on SQL Server to accomplish the desired functionalities

Performed cross Browser testing, Usability testing, and Database testing

Performed Version Controlling using Team foundation server (TFS)

Implemented data facade layers and LINQ to extract necessary data.

Involved in the process of Unit Testing, and Bug Fixes.

Used Entity framework CODE FIRST to improve the overall performance of the application

Created WCF Services used different bindings to make it available to different types of clients.

Performed code reviews and analyzed all development for performance impact.

Preparing Weekly status reports to show the progress and risks of the project.

Prepared project design document for the application by transforming the requirements from the client.

Proactively shared status to management and actively participated in daily status call with team

Developed database design by diagnosing the client requirements.

Contributed towards the documentation of project implementation user guide.

Used fluent Validations on client side.

Developed web performance test and load tests to check the application performance.

Environment: VisualStudio2012, C#, ASP .NET MVC 4.0, WCF, Entity Frame Work 4.0, HTML, CSS, Java Script, JQuery, WCF SOAP, IIS 7.0, ADO.NET, LINQ, XML, Microsoft Enterprise Library, NUNIT, SQL Server 2008 R2, Windows XP, Windows Server 2003, Windows Server 2008 R2/2008.

Client: Net Health, Pittsburgh PA October 2011 - January 2013

Role: Software Engineer (Web Application Developer)

Description: Life 70 is a life, health and annuity administration system, which streamlines insurance administration by providing one central platform for multiple product lines and operating companies. Life 70 supports key business functions such as new business, agent and commission management, policy administration, billing and collections, claims processing and client management. It has a product engine designed to provide support for an extremely broad range of products featuring over eighty (80) business enhancements including expanded support for variable universal life and variable annuity contracts and a customizable policy transaction history,

Responsibilities:

Developed web performance test and load tests to check the application performance.

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

Works for an innovative project called Wound Expert which is a huge Web Application satisfying the needs and requirements of (majorly) the health clients.

Develops web-based applications or systems while adhering to new development specifications that involve C#, ASP.Net web forms, SQL, JQuery and Ajax.

Extensively used JQUERY to make client side validations and used AJAX calls where ever necessary for auto filing fields and performing asynchronous calls.

Created proof of concept for implementing views in AngularJS rather than using razor for development.

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

Designed Application using prominent design patterns to enhance extensibility, and promote standards to program to an interface rather than implementation.

Controlled overall look and feel of ASP.NET web site by consuming twitter Boot strap.

Extensively used XML and JSON Serialization for transferring the data from controller to view.

Created WCF used different bindings to make it available to different types of clients.

Consumed different ASP.Net Web API’s to retrieve customers’ information and other application related information.

Designed and developed SOA architecture with WCF binding concepts for making data binding for end points.

Used Data List with Paging and Sorting for displaying various data on to the page.

Created, Data Access Layer, Business Logic Layer Classes using C# and .Net 4.0.

Web application development for backend system using AngularJS with cutting edge HTML and CSS techniques.

Involving in code review sessions with the developers and team leads.

Involves in designing the architecture of the applications and also recommend updates to existing architecture.

JQuery library has been used for creation of powerful dynamic Web pages and web applications by using its advanced and cross browser functionality.

Used XML for dynamic data displaying on to the html pages and for exchanging data between applications.

Involved in bug fixing during the System testing, Joint System testing and User acceptance testing.

Generates technical documentation on installation and operation procedures for end users.

Creates the prototypes for demo to the business clients.

Environment: Visual Studio 2012/2010, C#, ASP.NET 4.5/4.0, Java Script, JQuery, TFS 2010, WCF SOAP, JSON, IIS, AJAX, Entity Framework 6.0, LINQ, XML, Microsoft Enterprise Library, SQL Server Integration Services, NUNIT, SQL Server 2008 R2, Windows Server 2008 R2, AngularJS.

Client: Bajaj Allianz Insurance, Chennai, India December 2009 - July 2011

Role: Dot Net Developer

Description: Insurance Management System, IMS was developed which provides information about the claims, issuance, renewal and cancellation of the health insurance policies along with the due payment of the deductibles by the policy holders. The system has the ability to generate reports based on various criteria.

Responsibilities:

Designed and developed user controls for accepting customer inputs and presenting records/results to customer using ASP.NET.

Developed new services/classes and enhanced existing services for database access using C# .NET.

Used Custom Validation, User Validation and Java Script to give access to registered users.

Implemented input validation using the ASP.NET Input Validation Controls and JavaScript.

Provided session level security and role based authentication using session objects and cookies

Used AJAX to improve the performance of the web pages and to display the data on frequently visited pages.

Responsible for displaying dynamic menus based on user privileges

Developed interactive web pages using ASP.NET, C# and ADO.NET.

Wrote and debugged stored procedures and functions in SQL Server.

Involved in unit testing and bug fixing of the project, worked on SSIS to update share point libraries from SQL server tables.

Created User control and Custom controls for the application.

Extensively worked with C# for creating classes of this application and Integrated with ASP.NET pages.

Was responsible for meeting the line of business to discuss the weekly status of the application.

Environment: .NET Framework 3.5, C#, ASP.NET, XML, CSS, ADO.NET, T-SQL, SSIS, Web Services, Windows XP, SQL Server 2005, SSRS, IIS 5.0/6.0, Java Script.

Client: RG Info Systems, Mumbai, India January 2008 - November 2009

Role: Dot Net Developer

Description: First Data Commercial Services application is about the Client line product which is a web-based service designed to provide merchants with access to their payment processing information on Internet. Users pick-and-choose the information they need from a comprehensive database including payment processing details of gift card, check and all credit, debit and EBT card types

Responsibilities:

Involved in understanding and analyzing the clients business, requirements for the system.

Involved in Design and Developing components of this application using ASP.NET, C# .NET, VB. NET, JavaScript.

Architect and implement high volume, high traffic transactional application using conventional design practices(SOA, design by contract)

Implemented business, database access layer classes in C#.

Worked on creating documentation using CSL.

Written SQL Queries, Stored Procedures, Triggers, Backup and Restore Database, Defining roles, creating database users, Assigning Roles to user’s using SQL Server 2005.

Responsible to deliver the give modules without slipping the deadlines and without exceeding the estimated effort.

Application design based on n-tier Architecture.

Extensively involved in developing components for Business and Data tier using C#, ADO.Net, LINQ.

Involved in Performance testing for different bandwidths by using the bandwidth controller.

Involved in preparation of cascade style sheet (CSS) files.

Developed secured web services using .Net, C#, XML/SOAP.

Written code to access secure web service using .Net, Web form using C# and ASP.Net, WSDL, Proxy Class, XML/SOAP.

Environment: .NET Framework 2.0, ASP, C#, VB.NET, XML, Web services, HTML, JavaScript, IIS, Windows 2000 Server, HTML, DHTML, CSS, Ajax Toolkit, CSL, VSS, Visual Studio 2005, SSIS, SQL Server 2005.

Contact this candidate