Post Job Free

Resume

Sign in

Sql Server Customer Service

Location:
Fort Worth, TX
Posted:
March 28, 2017

Contact this candidate

Resume:

Umakanth

Ph: 949-***-****

Email-ID: aczi4j@r.postjobfree.com

Professional Summary:

Having 8+ years of experience in Project life cycle, analysis, design and development of Web Applications using the technologies Visual Studio.NET, ASP.NET, C#, OOPS, MVC, JQuery, Ajax, XML, SQL Server.

Extensive knowledge and experience in MVC, C#, VB.NET, Web Services, Web API, WCF,WPF, LINQ, IIS, SOAP, XML, XSL, XSLT, .NET Remoting,ADO.NET, Entity Framework, RESTfulWeb Services.

Hands on experience in design using object oriented programming principles like Encapsulation, Inheritance, Polymorphism, and Abstraction.

Developed responsive and perceptive user interface for the web using XHTML/CSS 3.0 and both custom ASP.NET and AJAX scripts as well as MS AJAX for ASP.NET library.

Designed & developed interface using Win Forms, ASP. Net and C#.Net.

Extensive experience in Designing professional UI Web Applications using Front End Technologies like HTML, CSS, JavaScript, JQuery, AJAX, JSON, AngularJS and Bootstrap.

Expertise in Creating and Managing database objects like Stored Procedures, Functions, Triggers, Views, Schemas, and Constraints.

Professional development of Database application using MS Access, MS SQL Server 2005/2008/2012, and LINQ.

Designed presentation tier i.e. web pages, using the concepts such as Master pages, Themes, HTML, XML, CSS, Custom controls, Java script, JQuery, CSS3, HTML5, and DHTML.

Good hands on experience on Sitecore CMS.

Handling the tasks of designing and maintaining SQL databases and VB6 applications

Design and Implementation of Desktop Applications with Microsoft Visual Basic 6.0

Analyze Requirements and Define Solution Architecture

Design and Implementation of Web Solutions with Microsoft Visual InterDev 6.0

Expertise in C#.Net, VB.Net, ASP.Net, JQuery, Ajax in Windows and Web Application development.

Designed, tested, implemented and supported VB.NET-PL/SQL Oracle programs for payments processing, data analysis, QA and data mining.

Designed VB.NET, VB6 and Excel user interfaces for ORACLE database.

Experience in deploying, configuring and maintaining the web sites and services on IIS 7.0 with and without secured socket layer.

Experience in MVC (Model View Controller) architecture with ASP.NET framework and Microsoft.Net Design Patterns.

Strong experience in designing and consuming Windows Communication Foundation (WCF) with different types of bindings and securities.

Demonstrated proficiency in development using Microsoft .Net technologies like C#, ASP.Net, AJAX, MVC, Web Services, Data Structures, Windows Azure (Cloud Computing)and Entity Frame Work.

Expertise in developing Client/Server Applications on Three tier Architecture, N-Tier Architecture, SOA (Service-Oriented Architecture), Web Services (SOAP, WSDL and UDDI), Model View Controller(MVC).

Experience with Business Intelligence Tools like SSIS and SSRS.

Knowledge on developing Reports using SQL Server Reporting Services (SSRS).

Experienced in continuous process improvement within systems development areas of Application design, development, implementation and Unit Testing/Debugging.

Excellent written, analytical skills, verbal communication skills with a customer service oriented attitude.

EDUCATION: Bachelor of Technology in Computer Science Engineering from JNTU, India.

Technical Skills:

Technical Specialization : Net, MVC4/5, ADO.Net, WCF, WPF, UML, AJAX, Win Forms, Web Forms,

Web Services, Windows Services

IDE Tools : Visual Studio .Net 2003/2005/2008/2010/2012, Visual Studio 6.0, N-unit

Testing Framework, MS Testing Framework.

Languages : ASP.Net, VB.Net, C#, C/C++

Scripting : XML, JSON, XSL, XSD, DTD, HTML4&5/XHTML, DHTML, JQuery, CSS, Java

Script, Angular JS and VB Script

Web Servers : Internet Information Services 10.0/8.0/7.0/6.0

Database : SQL Server 2014/2008/2005/2000, MySQL, Oracle 10/11g

Version ManagementTools : Team Foundation Server (TFS), Visual Source Safe 2008

Operating Systems : Windows NT/ 2003Server/ 2008Server/ XP/ Vista/ 7/8/10

Reporting Tools : SQL Server Reporting Services (SSRS), SQL Server Integration services (SSRS)

PROFESSIONAL EXPERIENCE:

Client: Novartis, Fort Worth, Texas AUG 2015 – Present

Role: Sr.Net Developer

Description: This is a Pharmaceutical application this Project is mainly divided in to three modules. The Customer perception module provides information of the customer's profile, health tips, updated medicines, etc. The customers can place new orders, view previous orders or cancel existing orders. Administrator can control over all application, his responsibilities are to view the patient list, the profile of any individual patient, and administrate all the users.

Roles and Responsibilities:

Actively Involved in SDLC phases in Agile methodology and Scrum Provide better estimates and actively involved in Scrum meetings for requirement analysis, task analysis and progress discussions.

Analysis, Design, Developing, testing and supporting of .NET web applications using .Net Framework 4.5, ASP.NET C#, MVC design patterns, Entity Framework, GUI, HTML, CSS, AJAX, JSON, JavaScript and Angular JS.

Involved in implementation of Entity Framework ORM for business to domain model. Define Domain Entities and Relationships using Microsoft Entity Framework Code First approach and Data first approach.

Designing and developing required web interface and web applications using ASP.Net MVC 5.0, C#.Net, ASP.Net ADO.Net and Entity framework as per the design specifications.

Developed Business and Data Access layers using C#, WCF, ADO.Net, DQL and SQL Server. Used Session objects, Cookies, View State and Caching concepts for state maintenance.

Worked on Service Oriented Architecture (SOA). Developed XML Web and WCF Services

Developed a Module that enables the administrator to provide access rights to users based on their credentials.

Worked on Stored Procedures, Triggers, and Views in the SQL Server 2008.

Implemented Presentation layer in Web application using MVC views, multiple Layouts, Partial Views, strongly typed Views, Razor view engine, Bootstrap, HTML helpers anddifferent CSS.

Developed Stored Procedures, Functions, Views and Triggers for Data Manipulation, ensuring set up relations includes indexing, constraints, foreign keys, primary key etc. using SQL Server.

Implemented Language Integrated Query (LINQ) for extension of query and transform data with using Linq-to-SQL, Linq-to-Objects, Linq-to-XML and migrations when models change.

Configure and expose Restful services utilizing Web API, Designed and developed various Classes in C#.NET to implement the business logic and event handling.

Worked on Angular JS to simplify both development and testing of such applications by providing framework for client-side Model-view-controller (MVC) architecture, along with components used in rich internet applications.

Implemented Angular JS Controllers to maintain each view data and implemented Angular Service calls using Angular JS Factory.

Involved in development of utilities in Windows Azure Service Bus in order to exchange messages during the communication of windows and legacy mainframe applications.

Used XML, XSL & XSLT for developing various reports and export to excel features.

Used Team Foundation Server (TFS) as a source code repository and version controlling.

Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.

Environment: .NET Framework 4.5,C# .NET, VB.NET, ASP.NET,MVC 5, Web API, Entity Framework, LINQ,WCF, Visual Studio, XML/XSLT, XSL, CSS, Bootstrap, JavaScript, JSON, AngularJS, AJAX, Ajax Control Tool kit, SQL Server 2012/2014, SSIS, SSRS,, Microsoft Azure, IIS, Team Foundation Server(TFS).

Client: Lowes, Mooresville, NC MAY 2013 – JUN 2015

Role: Sr.Net Developer

Description: This project is comprised of four major divisions called order, availability, Revenue recognition and Delivery. This project mainly includes integration of applications lowes.com- website where user logs online and orders a product, our team was responsible for the inventory management, secure transaction processing, and send’s email to customer from system once the order is placed i.e. confirmation Email.

Roles and Responsibilities:

Used Agile method and actively participated in the sprint planning and review.

Involved in all the phases of the Software Development Life Cycle (SDLC) including System Analysis, Design and Development. Here, as part of Software Development Life Cycle, the application was built on the Scrum Methodology, where we used to have daily scrum meetings with our developer’s team and scrum master.

Used C# language in developing the Business logic, where in extensively implemented the OOP’s functionalities.

Experienced in Developing and Enhancing MVC, Layouts, Partial Views by using HTML, CSS

Implemented Reports Functionality using modules UI (MVC and Kendo UI), Service (Web API)

Extensively worked on designing User Interface for the application.

Developed GUI using ASP.NET MVC with Ajax controls.

Developed Web User Controls and Custom User Controls to minimize code redundancy.

Validated pages using Asp.Net on server side and, Angular JavaScript for Client side Validation.

Used AJAX controls like Cascaded drop-down and Calendar for look and feel in the MVC.

Developed HTML5 prototype of the web pages using CSS3, according to the requirements.

Designed MVC design pattern for ASP.Net application development using the ASP.Net MVC frameworkextensively used Partial Views, Custom HTML Helper, Filters and Razor View Engine in ASP.NETMVC Framework to develop Web UI with HTML5, CSS3 and AngularJS.

Implemented Server and Client side validations using ASP.NET validation controls and JavaScript. Used JQuery to validate user controls and web forms.

Used Angular JS and other front end libraries and frameworks for developing front end web applications.

Extensively created T-SQL, Stored Procedures, Functions, Triggers, Indexes and Views in the MS SQLServer 2012.

Worked on Angular JS to simplify both development and testing of such applications by providing framework for client-side model-view-controller (MVC) architecture, along with components used in rich internet applications.

Worked on Entity Framework ORM with Code-First approach.

Designed and developed Service Oriented Architecture (SOA) services using Web Services/ WCF in C#.NET.

Implemented Two Way Data-binding in Angular JS which makes the application to handle the automatic synchronization of data between the model and view components.

Designed, modeled and architected multi-threaded, enterprise n-tier software agent using Windows Communication Foundation (WCF) web service hosted in a Windows.

Used Team Foundation Server (TFS) as a source code repository and version controlling.

Environment: Visual Studio, .NET Framework, C#.Net, ASP.Net, ASP.Net MVC 4.0, Entity Framework, WCF, LINQ, RESTful Web Services, HTML, XHTML, LINQ, SSRS, CSS, JQuery, AngularJS 1.6/1.5, Node Js, MS SQL Server 2012, SOAP, ASP.Net Web API, TFS, IIS.

Client: Fidelity Investments (FMR), Boston, MA DEC 2010 – MAR 2013

Role: .Net Developer

Description: I was involved Loan Monitoring System Applications, The Loan Monitoring System is intended to deliver a system to support credit management for the bank. The system is used for accepting loan forms, generating reports and tracking the status of loans. The Loan Monitoring System application was developed using ASP.NET, MVC, HTML5, CSS3, Ajax and uses MS SQL Server 2008 as the database. The application consists of two different modules: Pre-qualification and Decision System

Roles and Responsibilities:

Involved in gathering the requirements, analysis, design &development of the project.

Developed Agile Software Development methodologies to enable efficient and effective high-quality software development.

Used ADO.NET for the Data Access Layer for the ASP.NET MVC 4 application using HTML5 and Razor view. Used ADO.NET to provide connectivity to SQL Server 2008 back end database.

Involved in development of Web Forms, classes using ASP.NET that incorporates both N-TierArchitecture, and Database Connectivity.

Created and deployed Web Services using ASP.NET, SOAP and XML for Pulling Customer Service Records.

Modified Web Services to interact with the other applications and exposed them using SOAP and HTTP.

Used WCF for developing and deploying services on windows in line with the Service Oriented Architecture (SOA).

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.

Created the Data access layer and Data access objects using ADO.Net and LINQ to reduce impedance mismatch.

Developed Stored Procedures, Triggers, and Views in SQL Server 2008 for accessing the database.

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

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

Used Angular JS to develop a standalone test application, in scope of future usage of the framework, Angular JS, Ajax module is used to handle Restful calls to enable communication between view components and server.

Implemented client side validation to avoid back and forward between server-client and provide better user experience using Angular JS.

Environment: Visual Studio, .NET Framework 4.0, C#.Net, ASP.Net, ASP.Net MVC 4.0, Web Services, SQL Server 2008, WCF, ADO.NET, HTML, CSS, Web API, SSRS, JavaScript, JQuery, SOAP, Bootstrap, AJAX, XML, XSLT, IIS 7.5, Team Foundation Server.

Client: Prudential Insurance Company AUG 2008 – SEP 2010

Hyderabad, Andhra Pradesh, India

Role: Jr.Net Developer

Roles and Responsibilities:

Design and development of web pages using ASP.Net.

Actively involved in scrum meetings for requirement analysis, task analysis and progress discussions.

Worked on User Interface extensively and developed Win Forms and web forms using C#.

Developed front-end screens using ASP.Net Web forms, AJAX, JQuery and JavaScript.

Used ASP.NET Validation controls to validate user inputs Like Required Field validator, Compare Validator, Regular Expression Validator, Validation Summary, and Range validator.

Used ADO.NET to provide database connectivity and data access method to obtain data from SQL Server database.

Prepare high level and detailed design documents.

Prepare Use Cases and Test Cases.

Developed the application using C#.Net, Web Forms, Java Script, JQuery, 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.

Actively participate in database design meetings.

Maintaining Audit Log using SQL Server and Update Tracking System.

Developed XML and Collection parser using LINQ.

Writing WCF Services to interact with Business Components.

Implemented the Object Oriented Programming Concepts like Abstraction, Polymorphism, Inheritance and Encapsulation.

Created stored procedures, and triggers to perform updates to related tables using SQL Server.

Used LINQ to write the SQL quires to create store procedures, Tables and to write data in to the table etc.

Worked on ORM framework using Entity Framework to automate database activities.

Used HTML & CSS Email Templates to campaign about open requirements

Constructed SQL queries using various joins to access SQL Server database efficiently.

Extensively used try catch blocks throughout the development cycle to ensure proper Exception handling and logging.

Used to work on SQL server concepts like DML, DDL, DCL, and TCL. Created queries and stored procedures.

Environment: Microsoft Visual Studio, ASP.NET, C#, ADO.NET, SQL Server 2005, HTML, CSS, XML, AJAX, LINQ, IIS, Win Forms, Web Forms, OOPS, JQuery, and Java Script.



Contact this candidate