Post Job Free
Sign in

Sql Server .Net

Location:
Atlanta, GA
Posted:
September 30, 2016

Contact this candidate

Resume:

Chamee R

Full Stack .NET Developer

908-***-****

******.******@*****.***

Professional Experience:

•8+ years of strong experience in Design, Development & Implementation of Client/Server Applications, Web-Applications, Windows Applications with proficiency in Object-Oriented Analysis and design.

•Good knowledge in Software Development Life Cycle (SDLC), in every step like requirement gathering, designing, programing and support. Expert in implementing the methodologies like Agile using Scrum and Test Driven Deployment.

•Experience in designing and developing applications based on 3-Tier and N-Tier Client/Server Applications using UML, Design Patterns

•Professional level experience in design, development and implementation of Internet/Intranet applications using C#.NET, ASP.NET MVC, VB.NET, ADO.NET Entity Framework, AJAX, IIS 7.0/6.0, HTML, XHTML, VB Script, Java Script, JQuery, XML, UML and SQL Server (2005/2008/2012).

•Proficiency in .NET technologies including ASP.NET MVC 4.0/3.0/2.0, WPF, Silverlight, WCF, VB.NET, WinForms, ADO.NET, XML Web Services

•Hands on experience with the Dependency Injection (IOC) following the best practices

•Developed the user controls, customs controls for the reusable components usable in multiple pages

•Experience in Windows communication Foundation (WCF), exposure to Windows Presentation Foundation (WPF) and Language Integrated Query (LINQ)

•Hands on experience in developing code for the middle-tier to interact with the databases using ADO.NET using Data grids, Datasets, Paging and Sorting

•Experienced in creating and consuming XML Web Services (REST, SOAP, and WSDL) using VisualStudio.Net, ASP.NET.

•Expertise in using third party controls like Telerik controls & infragistic controls and experience in working with design architectures like MVVM (Model View View Model), MVP and MVC

•Extensive experience in developing User Interfaces using Bootstrap 3.2, Angular JS, ASP.NET AJAX Toolkit, JQuery, XML, HTML5, DHTML, DOM, CSS3, Java Script, JSON.NET and JQuery Proficient in developing web page quickly and effectively using HTML 5, CSS3, JavaScript, Node JS, Angular JS, JQUERY and Bootstrap and also experience in making web page cross browser compatible.

•Experience in working master pages, cascading style sheets (CSS), XML, XSL and XSLT technologies

•Experience in creating automation solutions for day to day work using PowerShell scripts

•Solid understanding and hands-on experience of large-scale database (SQL Server 2005/2008/2012), MySQL, Oracle 10g/11g and experience with writing stored procedures, Triggers, User Defined Functions, Queries, Indexes, Views.

•Experience in writing directives, services and controllers using Angular JS.

•Experience in writing unit tests using MS-Test, NUnit and QUnit.

•Experience working in SQL Server Integration Services (SSIS) packages to extract, transform and load (ETL) data from different databases.

•In-depth experience of T-SQL, SSIS, Reporting and Analytics.

•Experience in various testing methodologies like Unit Testing, Integration Testing using tools like N-Unit and Visual Studio

•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

•Experience in program specification, coding and implementation of the systems after NUnit and Integration testing

•Used versioning tool Visual Source Safe (VSS), Team Foundation Server (TFS) and Current Version Safe (CVS) for version controlling of the application.

•Implemented page level errors using the Event Logs and Log4Net

•Outstanding problem solving, strategic thinking and data analysis skills, strong focus on teamwork and achieving team goals, result oriented and excellent communication skills

•Experience in Creating and Consuming SOA architecture using WCF services. Successfully used several Binding Techniques like (HTTP, TCP) to transport message between Client and WCF service Host.

•Team Player with Committed / Get-the-Job-Done Attitude, highly organized and Excellent People-Interaction Skills

Technical Skills:

Operating Systems

Windows 98/2000/NT/XP/7/8, DOS, Unix, Linux.

Microsoft Technologies

ASP.Net, C#.Net, VB.Net, ADO.Net, Ajax, VB, ASP, Web forms, MVC, Razor.

Web Based Technologies

HTML, HTML5, CSS3 DHTML, XML, XSL, XSLT, Telerik web controls, Kendo controls, Angular JS, Knockout JS, Node JS, Bootstrap

.Net Technologies

Microsoft .NET Framework, ADO.NET, Entity Framework 6, Win Forms, Web Forms, SOAP 1.1, Rest, WSDL, Silverlight, WCF, WPF, SharePoint 2013 –External Contents, Data Connections, Excel Services, performance point, SSRS, Web API

Scripting Languages

JQuery, JavaScript, VBScript, Power shell scripting

Languages

C#, ASP.NET, VB.NET, C, C++, VC++, VB6.0, FoxPro.

Databases

MS SQL Server 2005/2008/2012, LINQ, MySQL, Oracle 7x/8i/9i, MS Access 2000, Sybase.

Content Management Tools

Sitecore, CMS, DotNetNuke

Application Tools

Log4Net, Automapper

Web Servers

IIS 5.0/6.0/7.0

Development Tools

Visual Studio 2005/2008/2010/2012

Reporting Tools

Telerik Reporting Tools

Source Repositories

Tortoise SVN, TFS, VSS, GitHub, Visual Source Safe

Professional Experience:

NiSource, Columbus, OH Sept 2014 – Present

Full Stack .Net Developer

NiSource is a company which provides energy and energy-relative services. This project keeps track of the equipment installed underground like gas pipes, underground wirings etc., and it also helps technicians to manage their work and assign work to their crew's member, check work progress, create reports of work done, etc. This project is generally used by Indiana, Maryland, Ohio and Virginia.

Responsibilities:

•Involved in the SDLC phase of requirement analysis, design, and development of the web based intranet application tool using MVC, WCF and C#.

•Created Business Logic Layer & Data Access Layers in WCF architecture.

•Developed core functionality with the ASP.NET MVC Framework (C#.NET, ADO.NET).

•Implementation of client side validations using JQuery and ASP.NET MVC Validation implemented at Controller level,

•Integrated Kendo framework controls to support HTML5 Controls.

•Involved in Enhancement of existing application utilizing AngularJS, developed routing through web pages and achieved Single page application. Used Angular JS to achieve two-way data binding.

•Integrate the dynamic pages with jQuery too Angular JS and make the pages dynamic.

•Developed system services SOA application platform for use by all web applications utilizing Windows Communication Foundation (WCF) services.

•Implemented Team Foundation Server (TFS) as Version Management system for Microsoft Technologies

•Implemented client side functionality using JQuery

•Integrated the ecommerce platforms with the payment gateways and accounting system.

•Followed N-Tier Architecture and developed multiple layers in the ecommerce Platform.

•Used Kendo UI controls and Telerik controls to design attractive User Interface

•Created DAL (Data Access Layers) to establish database connectivity and data manipulation.

•Used Cascading Style sheets for a unified look and feel of the Web Applications.

•Used Grid View, Data List, and Panels to display and manipulate data in MVC views using Telerik controls.

•Developed custom directives in Angular JS that could be re-used like a template across the application.

•Worked on windows PowerShell scripting for managing system.

•Expertise on PowerShell scripts for automating tasks and process for end to end automation.

•Used Forms Based Authentication to enforce security in to the application

•Designed Administrator pages to handle overall application.

•Designed the source and applications under agile process.

•Developed Email Notification System using MSMQ asynchronous model using WCF Service using net msmq binding.

•Involved in designing Database Architecture.

•Implemented Optimized Stored Procedures.

•Wrote the Database Triggers, Views, and Indexes

•Responsible in developing Stored Procedures, Views, Indexes, Scripts for database transactions on SQL Server 2008.

•Used Layout to provide a unified look and feel to the application.

•Used Telerik Controls to create better, faster and more user-friendly web applications.

•Active participation in unit testing of the application to ensure quality.

•Used Windows Communication Foundation (WCF) for clients to consume multiple services using Rest protocols.

•Involved in installing SharePoint and backup/restore of the client sites on the firms SharePoint environment.

•Used Telerik UI/ Kendo UI/ JQuery Controls for building high quality windows/web applications.

•Optimized LINQ/SQL queries and indexes for SQL Server 2014.

•Fixed bugs reported by QA and UAT, including in Java Script

•Created and consumed ASP.Net Web services and implemented REST full Web API/WCF services for service layer, created Action filters and Exception filters to implement REST API.

•Extensively worked on implementing Service Oriented Architecture (SOA architecture) using Web Services (REST, SOAP, WSDL, and UDDI).

•Implemented WCF SOAP/REST and Consumed WCF Services from both Windows forms and ASP.NET web applications

•Migrated applications from .NET Framework 1.1 to 4.5.

•Maintained the Version, Labeled Versions and Backups of the source using Team Foundation server.

•Supervised the development of functional documents for the application.

•Participated in various client meetings with the team and the Project manager to discuss improvements/amendments in the development of the section.

•Done unit testing for both new enhancement and bug fixing.

Environment: ASP.Net, ADO.Net, Entity Framework4.0, Visual Studio 2013, MVC4.0, SOA, REST, APM, Oracle 11g, SQL Server 2014, HTML, HTML5, CSS3, DHTML, XML, XSL, XSLT, Kendo UI, SharePoint, Java Script, JQuery, Angular JS, Node JS, Bootstrap LINQ, Entity Framework, PowerShell, Windows 7, VS 2005 – VS2010, .Net Framework 4.5.2, Team Foundation Server 2012, SSRS, N Unit test scripts, Telerik Controls, Toad, JIRA, GitHub, Unit Testing.

ATOS, Santa Ana, CA Nov 2013 – Aug 2014

Sr.Net Developer

Truck Load Quoting Pricing Tool application developed for all the sales department of Echo global logistic. The application used for quoting and pricing the carrier clients and customer clients for truckload management. The system used for analyzing the Transcore and echo rate data and enhance business rules and pricing matrix accordingly. The application has dynamic rules and can be easily modified for quoting using the admin web page without any code change making it the robust, flexible and reliable.

Responsibilities:

•Designed Truckload quoting pricing tool for sales staff to quote and price carrier and customer clients using MVC4 ASP.NET, C#, JavaScript and JQuery.

•Created Technical Planning Process, architecture and ER Diagram for the development life cycle before starting the project to have a clear vision and understanding of the full SDLC life cycle of the project.

•Implemented Custom Validation code to test the UI controls as per the business requirements.

•Wrote optimized stored procedure to load Geo lookup data and auto-complete the search control.

•Designed controls to dynamically add intermediate stop and update miles using AJAX controls using JQuery and JavaScript.

•Implemented and used Web Services with the help of WSDL, SOAP to get updates from the third parties.

•Used XML Web Services using SOAP to transfer the amount to transfer application that is remote and global to different financial institutions.

•Worked on the middle tiers in the Billing module of the ecommerce platform.

•Developed the UI using various Kendo components like Grid view, detail template, Tree view, Modal Popup.

•Development of Client Side Validation techniques using JQuery and Angular JS directives.

•Writing Customized Deployment Process templates for deploying source bits to Dev/QA/UAT/PROD Environments using PowerShell & TFS.

•Developed automation and deployment utilities using Bash and PowerShell.

•Developed and Consumed WCF Services/Web Services with Service Oriented Architecture (SOA)

•Customized TFS Work Item templates, configured new state transitions

•Designed the single page web application with the help of angular routing techniques.

•Sorted and filtered the data according to the requirement with help of angular.

•Implemented Custom Directives, Custom filters, and performed modification to improve the performance of angular JS single page web application.

•Involved in performance testing to log the page load times of the tool into windows azure using service.

•Designed and developed summary view to display a rate chart index using MVC4 ASP.NET to help sales in quoting the customers precisely.

•Working Knowledge of Model-View-View-Model (MVVM) & Model View Controller (MVC) Pattern.

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

•Developed Web Services and invoking them by using XML SOAP and WSDL for creating proxy classes. Used Web Services (SOAP, WSDL) for communicating with other application and components

•Extensive use of Web Services, SOAP, XML, XSL to expose the reports to facilitate information sharing.

•Developed service to get a rate matrix from external transcore web service using WCF Service.

•Effectively designed and developed optimized business solution for pricing rule which can be dynamically update, add or delete the rules without major application change helping in the effective SDLC process.

•Designed and developed Rule index matrix using C#.

•Created business solution for Load to truck ratio for origin, destination and equipment category.

•Extensive use of LINQ and Entity Framework to develop data layer.

•Design, Testing, Development and comfortable leading agile team and mentoring Jr. Developers.

•Created new database Truck Load Market pricing database to save truck load rating index information using objects like Store Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server.

•Developed SSRS reports to analyze and enhance Truckload market pricing information.

•Consumed external service providers for payment such as PayPal and Stripe.

•Effectively designed and developed optimized business solution for pricing rule which can be dynamically update, add or delete the rules without major application change helping in the effective SDLC process.

•Developed and consumed external service providers for payment such as PayPal.

•Responsible for designing the ASP.NET application authentication using the .NET Framework, Model View Controller (MVC) and IIS security models.

•Create App fabric caching to cache the Transcore market data which can help in application and data performance enhancement.

•Implemented and developed process and architecture to deploy and test application packages using PowerShell scripts and automate the process.

•Responsible for maintaining versions of source code using SVN subversion.

Environment: C#.Net, ASP.Net, ADO.Net Entity Framework4.0, MVC4.0, SOA, SOAP, Microsoft Visual Studio 2012, Kendo UI, DHTML, HTML, HTML5, CSS3, PowerShell Scripting, JQuery, Angular JS, Node JS AJAX, LINQ, SQL Server 2012, TFS, Web forms, HTML, XML, Event Logs, Visio and Windows XP Professional, WCF.

Johnson & Johnson, Parsippany NJ Jul 2012 – Oct 2013

Sr .Net Developer

The Patient Touch application is a suite of interactive technology solution, cost-effective patient satisfaction platform – with touch-friendly programs that are designed to capture meaningful patient insights and provide more impactful health education tools. Patient Insights – An interactive, web-based survey solution for gathering vital in-practice patient insights, conveniently administered on a touch screen platform with a fully-customizable design interface and intuitive Content Management System.

Responsibilities:

•Involved in analyzing designing of UI/Middle Tier/ Database and transition using iterative Agile Methodologies.

•Developed Views for various modules throughout application using Razor View engine templates.

•Worked with LINQ for .Net and Entity Framework, also wrote stored procedures using Microsoft SQL Server 2008

•Extensively used ADO.NET for connecting to database and calling the procedures and functions and used ADO.NET for data interaction between the web application and the Database usingData Reader, Datasets, and Data Adapters control.

•Involved in creating WCF REST services for various policies and benefits, and consumed them into the web application.

•Developed the web services for preparing the report using XML web services.

•Utilized JQuery for client side validation also used Kendo controls.

•Error Handling has been done using the Log4Net which registers the exceptions occurred.

•Implemented Integration testing and NUnit testing to test the efficiency of the code developed.

•Involved in performance tuning and code cleanup of the old PRO solution/migrated partial modules to MVC, also implemented Dependency injection using Unity.

•Team Source Foundation is used for controlling the Source Control Management

Environment: C#.Net, ASP.NET MVC 3, Entity Framework, Razor, Microsoft Visual Studio 2010, JQuery, AJAX, LINQ, SQL Server 2008, HTML, XML, TSF, Kendo controls, WCF, WPF.

PharMerica Corporation, Tampa, FL Oct 2011 – Jun 2012

Sr .Net Developer

Development of online customer portal has one login for everything that customer need with real-time access. Customers can have the express service requests for account service and on-site services such as audits, surveys and med cart reviews. It has many features like Alerts, Medication order management, Online Billing, medication management reports etc

Responsibilities:

•Designed and developed different modules, classes using C# and designed GUI part with help of .Net framework 3.0

•Extensively worked on developing the complete web application to serve all the applications for their different flows.

•Used ASP.NET web controls and HTML control in the design of web pages.

•Designed, modeled multi-threaded, enterprise n-tier software agent using WCF web service in 3.0 framework.

•Designed WCF service contract for validating the user input.

•Extensively used ASP.NET web server controls like Grid View for displaying the records.

•Experienced in developing and consuming Web Services and n-tier web applications.

•Used JSON, JQuery for the Client side to pass the parameters for hand shake across applications and for client side AJAX call, validations.

•Used ADO.NET for data interaction between the web application and the Database using Data reader, Datasets, and Data Adapters controls.

•Used JavaScript and ASP.NET for AJAX implementation and client side validations.

•Used TFS for Versioning control and configuration management

•Followed agile methodology to develop the application.

•Involved in setting up and developing application onto SIT, Staging and Production environments.

Environment: .Net Framework 4.0, C#, ASP.NET, ADO.NET, WCF, MVC 3, XHTML, HTML, JavaScript, jQuery, XML, XSL, XSLT, XAML, T-SQL, SQL Server 2008, LINQ, Entity-Framework, SSRS, Oracle 11g, TOAD, PL/SQL, JSON, TFS, LINQ, Test Directory, MS Excel, TFS, IIS (6.0), NUnit

Chubb and Sons, Somerset, NJ Jan 2011 – Sept 2011

Sr .Net Developer

Chubb Insurance is one of the largest auto insurance groups in the United States. It sells insurance policies directly to customers online or over phone. Policy Pro is a web based internet application designed to help the Customer's to manage their policies online. It is aimed at providing real time updates of policy information to the customers. The UI of the application is integrated with Chubb and Sons main website.

Responsibilities

•Involved in developing business logic layer and Data Access layer and written methods in C#, Visual Studio.Net

•Used ADO.Net 2.0 technology extensively for data retrieving, querying, storage and manipulation interface screens developed using ASP.Net.

•Involved in writing Complex SQL statements and stored procedures using SQL Server 2008.

•Configured ASP.NET Web.Config file for the entire web application.

Used forms based authentication and role based authorization for security.

•Data binding was extensively used to bind various server controls to the data from database.

•Participated in requirements gathering and analysis.

•Involved in client interaction for the change requests and follow-ups.

•Used Ajax for avoiding post back to the server.

•Responsible for implementing Stored Procedures for Data Retrieval and Updating.

•Responsible for creating Requirements, Test plan and procedures for application testing.

•Worked in the Performance tuning at the Application and Database Layers.

•Worked in taking Backups, Restoring, Import/Export data using MS SQL Server2008 and DTS.

Environment: C#.Net, ASP.Net, ADO.Net, Framework2.0/3.0, Visual Studio.Net 2008, MVC, XHTML, HTML, JavaScript, jQuery, XML, XSL, XSLT, XAML, T-SQL, JavaScript, XML, SQL Server 2008, AJAX and Windows XP Professional.

HDFC, India Apr 2008 – Dec 2010

.Net developer

Bank Care developed by covers entire Front and Back office operations of a Credit Co-Operative Societies and Banks. It handles all daily chores like integrated accounting and Transactions handling with efficiency and provides accurate and up-to-date information. It has been developed by keeping in mind all possible variations in operation of the Co-Operative Credit Societies and Banks.

The Modules Included in the System are:

•Account Management of the Clients/ Uploading Masters Etc.

•Transactions Module.

•Accounting Entries.

•Parameters Entries.

•Extra Utilities(Reports)

Responsibilities:

•Developed User Interface with ASP.NET Controls.

•Used Validation controls to validate the input Data using Validation Controls (like Required Field, Range, Custom and Compare validations).

•Developed JavaScript functions for client validations.

•Mostly worked on the .NET Data Grid controls to display user information.

•Developed Data Access Layer components using ADO.NET technology.

•Complex Stored Procedures were developed in SQL Server 2005 and were invoked from application using the "command" object of ADO.NET.

•Designed 3-Tier Architecture, which facilitates Distributed Architecture.

•Created Stored Procedures in SQL Server 2005.

•Developed XML format reports to send data through secured format.

Environment: C#, .NET 2.0, ASP.NET 2.0, .NET Framework 2.0, SQL Server 2005, ADO.NET, Java Script, XML, Windows 2000 server, Test Cases, Visual Studio 2005.



Contact this candidate