Resume

Sign in

Sql Server .Net

Location:
Lee's Summit, Missouri, United States
Posted:
October 14, 2016

Contact this candidate

Resume:

YESWANTH RAVELLA

Sr. Dot Net Developer

acw149@r.postjobfree.com

Ph.: 347-***-****

Summary:

* ***** ** ******** *********** experience in Application Design, development and

maintenance with Microsoft Technologies (ASP.NET 3.0/3.5/4.0/4.5, C#4.5/4.0/3.5/2.0,

VB.NET, ADO.NET, Web Services 2.0/4.0, and SQL Server 2008/2012/2014).

7 years of experience in using WCF, WPF and WinForms.

5 years of experience in using MVC 3.0, 4.0, 5.0.

Implemented N-Tier Architecture, Data Access Layer (DAL), Business Logic Layer (BLL)

and User interface (UI).

Thorough knowledge and experience on all phases of Software Development Life Cycle

(SDLC) Experience of using Water Fall, Agile and scrum methodologies.

Proficient in writing SQL Queries, Stored Procedures, and Triggers in Microsoft SQL

Server

Worked extensively in managing database with using ADO.NET, Entity Framework,

LINQ and Lambda Expressions.

Very good experience on working with ASP.NET 2.0/3.0/3.5/4.0 controls like Grid View,

Detail View, Data Source controls such as Object Data Source, SQL Data Source and

Master Pages for consistent layout of pages in the application.

Experience in working on Developing and consuming SOAP over HTTP web Services using

WSDL, UDDI and DISCO protocols.

Experience in creating reports using Crystal reports and SSRS.

Experience working with SSIS packages for data Importing, Cleansing, and Parsing etc.

Extracted, cleaned and validation.

Used SQL Server Management Studio (SSMS) to create Stored Procedures using Joins,

SQL Functions and T-SQL statements.

Extensive experience in database programming using SQL and PL/SQL following industry

best practices.

Experience in Oracle supplied packages, Dynamic SQL, Records, PL/SQL Tables and

Exception Handling.

Interacted with Business Analysts and Users in requirement gathering, built complex queries

using SQL and wrote stored procedures using PL/SQL.

Proficient in building Web Applications using C#.NET4.0/3.5/2.0, ASP.NET 4.0/3.5/2.0,

HTML5, XML, AJAX, JavaScript, JQuery and CSS3 in a Client/Web Server

environment.

Worked on REST Web Services using AngularJS, JavaScript, JQuery, HTML5, CSS3,

Ajax, Web API and Bootstrap.

Experience in front end and backend development using .NET Framework.

Strong experience in using ASP.NET Validation controls.

Worked on .NET Security features such as Authentication & Authorization.

Experience with N-Unit to executes test cases.

Experience on using and working with Tortoise SVN, TFS and GIT source control

systems.

Worked in diverse fields like Health insurance, Banking, E-Commerce, and

Telecommunications.

Proven Ability to analyses problems, root cause, and develop innovative solutions to

business challenges and streamlining operations.

Good team player and communicator with interpersonal and presentation skills & excellent

work ethics, self-motivated, quick learner & flexible to adapt new technologies.

TECHNICAL SKILLSET:

Languages C#, ASP.NET, VB.NET, VBScript, HTML, CSS, DHTML.

Script JavaScript

ADO.NET, LINQ to Entity Framework, CSS, Web Services, User Controls,

Tools & Technologies Agile, Scrum, Team Foundation Server, Bootstrap, CSS, Azure, AJAX,

JQuery, AngularJS, WCF, WPF.

ASP.NET, HTML, HTML5, JavaScript, JQuery, CSS, CSS3, Bootstrap,

Web Development Tools

MVC3.0, MVC4.0, MVC5.0, SOAP, XML.

Development IDE Visual Studio 2008/2010/2012/2013/2015

Databases Microsoft SQL Server 2012/2008/2005, Oracle 10g, 11g, PL/SQL, T-SQL

Operating Systems Windows Server 2008, Windows XP, Windows 7, Windows 8

Web servers ISS 5.0,6.0,7.5

Version Control Visual Source Safe (VSS), Team Foundation Server (TFS)

PROFESSIONAL EXPERIENCE:

Client: Anthem Blue Cross Blue Shield, Chicago, IL Apr2015 -Till

Date

Role: Sr.NET Developer

Project: Smart Quote Enrolment System.

Description: American Health Insurance Company is a leading provider of insurance products and

services nationwide. The purpose of this project was to make the Web Interface easy to use and increase

the online interaction with insurance applicants. And provide the website users a clean web interface to

generate insurance quote online. Project was developed on the .Net4.5 framework. It has service Oriented

architecture which allows enterprises to plug in new services or upgrade existing services in a granular

fashion to address the new business requirements.

Responsibilities:

Designed and Developed a Web application by using MVC 5, Web API, HTML5, CSS3,

Bootstrap, AngularJS, JQuery, and Azure, Ajax.

Worked on complete SDLC utilizing the Agile Methodologies, Monthly Sprints and Daily

Scrums to discuss the development of the application.

Web API handles the data operations between the web application and the database.

Used JQuery client-side scripting for auto complete, tabs, validation, date picking, sorting, auto-

submit and other functions

JQuery validation and MVC 5 unobtrusive validation were used to validate form fields and

provide custom requirements/error messages through C# attributes in the Model

User interface (views) design and development with HTML5 and MVC5 helper methods.

Implemented Web Grid MVC with JQuery/JSON to provide more flexible, editable and sortable

grid view to increase user interaction.

Used angular-toaster library for displaying JavaScript notification

Designed SSIS Packages to transfer data from flat files to SQL Server using Business

Intelligence Development Studio.

Implemented Entity Framework Code First Approach to create database.

Used different Telerik Rad Controls, Free Textbox in Visual Studio applications.

Participated in writing Stored Procedures for performing optimization and other database

operations such as complex SQL queries, views and triggers etc.

Developed and maintained enterprise reporting (SSRS Reporting Services) based on

specifications and business needs and modified existing reports as needed.

Designed the Interface using HTML5, CSS3, Bootstrap, JQuery, and Ajax.

Used Windows-UI (XAML, HTML) to enterprise, modernize & mobilize WinForms

applications.

Used Web API, Entity Framework, LINQ, Lambda Expression, JSON for REST Services.

Used AngularJS directives such as ng-model, ng-bind, and ng-repeat to display data from

AngularJS controllers, factory and services.

Developed coding the presentation layer using WPF.

Worked with WinForms Controls to show how to implement.

Experience in creating and deploying XML Web Services using ASP.NET. Consumed Web

Services from both win forms and ASP.NET Web Forms.

Applied HTTP methods to perform CRUD Operations.

Worked with WebSphere MQ for program to program messaging.

Worked with LINQ and Lambda Expression to perform query operations.

Developed SOAP based WCF Services for providing Search and Authentication services and

RESTful Web API to send and receive web service messages.

Implemented search filter using AngularJS filter, create custom filters for specific use.

Used HTML5 validators, bootstrap validator for handling inputs from the users for client side

validation and data annotations and forms authentication for server-side validation.

Involved in Unit Testing and Integrated Testing.

Deployed the applications on to IIS in Windows server 2008 R2/2012R2.

Environment: Visual Studio 2015/2012, SQL Server 2012, .Net 4.5/4.0/3.5, MVC 5, AngularJS, C#,

JavaScript, HTML5, CSS3,Azure, JSON, N-Tier, WPF, WinForms, WebSphere MQ, SSRS, SSIS, Entity

Framework, LINQ, Lambda Expressions.

Client: Wright-Patt Credit Union, Inc., Dayton, OH Dec2013 Feb2015

Role: Sr.NET Developer

Project: E-Banking

Description: The E-Banking Project involved the enhancement of web-based online banking services to

customers. It gives customers a secure and easy access to online functions that includes creating new

accounts, monthly Statements Account balances, transfer funds and more.

Responsibilities:

Designed and developed navigations control, user controls, and custom controls.

Used ASP.NET Controls, Telerik .NET UI Controls to develop User Interface, Custom controls

and User Controls. Used C# 3.0 features such as Generics, Iterators, Anonymous methods,

Partial classes, Anonymous Types, Lambda Expressions and Extension methods.

Used MVC 4 achieved a clean separation of a layers given into Model, View and Controller.

Used ASP.NET MVC 4.0.

Used Session objects to keep track of session and security attributes built in the ASP.NET MVC

framework.

Developed UI/Components/Classes/Methods for the application and also functionalities such as

data retrieval using C#, ADO.Net.

Creating WCF applications requiring Instance and concurrency management.

Analysed and designed new .NET Web, Batch and WCF application from design to completion

stage.

Designed UI in MVC 4 implementing partial views, Layouts for reusability.

Worked with grid view, data reader, repeater, data list and data table to display data on the UI.

Created design, technical, and support documentation to accurately describe various processes in

the application. Developed exception handling functionality in the Business Logic Layer.

Actively involved in data modeling and contributed in the designing and creation of databases .

Responsible for n-tiered enterprise data driven system design and development, including

database data modeling and development.

Implemented the business logic layer (BLL) and data access layer (DAL) using C# and

ADO.NET. Created complex stored procedures, implemented queries, and views in MS SQL

Server. Used JQuery a concise of JavaScript library for validation on the web pages.

Used JQuery in web pages for better effects and more responsive on the client side.

Developed a Win forms application in C# that manages the user roles, survey, rules and used it to

pull out the profile placed from the SQL database using ADO.NET.

Developed Stored Procedures and Cursors on SQL SERVER 2008, using PL/SQL, to effectively

manage data.

Extensively used the advanced features of PL/SQL like Records, Tables, Object types and

Dynamic SQL.

Created WinForms and Web Forms for developing the applications using win controls,

webserver controls and HTML controls.

Worked on GUI module development using WinForms in C#, ADO.NET for Electronic Data

Interchange.

Actively involved in data modeling and contributed in the designing and creation of databases .

Responsible for n-tiered enterprise data driven system design and development, including

database data modeling and development.

Analyzed and formulated the Test plan from requirements, created the Test scenario from use

cases, test case design from design document, regression and test automation using N Unit

Testing. Worked extensively with XML Serialization and De-Serialization.

Implemented WCF Services which provide the Interfaces (or Access Points) to Client

applications for retrieving data. Debugged and defect fixed during system testing by QA team

and UAT by clients Involved in troubleshooting, monitoring, optimization of SQL Server 2008

database procedures and T-SQL code.

Prepared and executed test cases using N-Unit and experienced in code review, unit testing,

integration testing.

Created complex stored procedures, functions, indexes, tables, views and other T-SQL code and

SQL joins for applications following SQL code standards.

Performed T-SQL tuning and optimization of queries for reports that take longer execution time

using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server

2008/R2.

Used Team Foundation Server (TFS) extensively for version control of the source code.

Environment: C# 4.0/3.0, ADO.NET, WCF, Web Services, MVC 4, Window Forms, SQL Server

2008/R2, Oracle 10g, PL/SQL, IIS 6.0, UML, HTML, Windows 2003, WinForms, Visual Studio 2010

and LINQ, DevExpress Grid Controls, Visual Source Safe.

Client: ShopperTrak, Chicago, IL Jun2012

Nov2013

Role: .NET Developer

Project: RealTimeWeb

Description: RTW [RealTimeWeb] is used by multiple clients like PETCO, Home Depot and Best Buy

etc. Domain of the application is to capture and report Real time website data to the vendors.

Functionality includes providing the statistics of the website traffic, sales and transactions with in given

time range for the vendor. Data is gathered from different sources in variety of formats including json

and XML using the RESTful and SOAP web services. Response is created and exposed in multiple

formats depending on the type of the vendor and business. UI interface is developed to display the

overall Dashboard and performance metrics of the vendor.

Responsibilities:

Worked with Business Analysts in order to understand business requirements and analyse use

cases.

Involved in configuration, customization, and development E-Commerce platform.

Involved in designing Class diagrams and Sequence diagrams using MS Visio.

Actively involved in developing web applications using ASP.NET, C#, ADO.NET and Visual

Studio 2008.

Involved in designing database, creating tables, writing complex queries and writing Stored

Procedures using SQL 2008.

Developed Stored Procedures and Cursors on SQL SERVER 2008, using PL/SQL, to effectively

manage data.

Extensively used the advanced features of PL/SQL like Records, Tables, Object types and

Dynamic SQL.

Extensively used PL/SQL advanced features like Forward Declaration, Procedure Overloading.

Creation of database objects like Tables, Views, Materialized Views, Procedures and Packages

using oracle tools like Toad, and SQL* plus.

Used N-Tier architecture containing Data Access Layer (DAL), Business Logic Layer (BLL) and

Presentation Layer in order to manage code effectively.

Developed E-Commerce functionality in ASP.NET including Google Checkout and N Hibernate.

Implemented Behavior Pattern for code reusability using Web Service as a Mediator.

Used JavaScript and ASP.NET validation controls extensively to handle UI validations.

Used AJAX Control Toolkit and AJAX Extensions like Tab Container, Accordion, Update Panel

and Timer to improve the performance of the web application.

Created WCF Service to retrieve and send information from client side without post-back.

Developed RIA (Rich Interface Application) using Silverlight 2.0.

Extensively used Silverlight page layouts, animated transition controls and key-frame

animations.

Developed coding the presentation layer using WPF and Silverlight.

Implemented WPF in creating custom controls, 3D graphics and Layout controls (Canvas, Stack

panel, Grid etc.).

Used LINQ components in data layer.

Used Visual Source Safe (VSS) to maintain the version control history during development.

Used Crystal Reports as a reporting tool for developing reports.

Extensively used Runtime and Design time exceptional handling techniques.

Performed Unit testing and Integration testing.

Environment: .Net Framework 3.5, ASP.NET, ADO.NET, SQL 2008, C#, JavaScript, JQuery, CSS,

HTML, WCF,XML, XAML, AJAX, VSS, SSIS, SSRS, Visual Studio 2008, LINQ, Crystal Reports, MS

Visio, Silverlight 2.0.

Client: Telstra Telecommunications, Chennai, India Nov2010 May2012

Role: .NET Developer

Project: Telstra

Description: This is a Windows forms based Client Application in Tele communication field. This

application captures the data flow through various processes across several departments in the company.

The project is divided into several modules each automating processes in different departments.

Technicians and supervisors in all the departments of the organization use the application for their daily

experiments. The application is also used by the higher-level management for visualizing the workflow

and productivity reports. This .Net application is delivered via Click Once methodology from Internet

browsers to Windows systems.

Responsibilities:

Designed and developed different modules, classes using VB.NET and designed GUI part with

help of .Net framework 3.0

Developed the complete web application to serve all the applications for different flows.

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

Designed, modelled multi-threaded, enterprise n-tier software agent using WCF web service.

Designed WCF service contract for validating the user input.

Used ASP.NET web server controls like Grid View for displaying the records.

Developed and consumed 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.

Implemented Web Grid MVC 3 with JQuery/JSON to provide more flexible, editable and

sortable grid view to increase user interaction.

Web API implementation for HTTP handling within MVC project.

Extensive understanding in creating and managing Views, Partial Views, Vie w Models, AJAX

HELPERS using ASP.NET MVC.

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 Oracle databases in windows applications internally developed to work within the

company.

Used TFS for Versioning control and configuration management

Followed agile methodology to develop the application.

Set up and developed application onto SIT, Staging and Production environments.

Environment: .NET Framework 4.0, VB.NET, ASP.NET, ADO.NET, Silverlight, WCF, WPF, XAML,

MVVM, MVC 3, XHTML, HTML, JavaScript, jQuery, XML, XSL, XSLT, XAML, T-SQL, SQL Server

2008, LINQ, Entity-Framework, SSRS, Oracle 11g, TOAD, PL/SQL, Telerik Controls, JSON, Visual

Source Safe 6.0, LINQ, Test Directory, MS Excel, TFS, IIS(6.0), NUnit.

Client: Co-Operative Bank, Mumbai, India Jun2008

Oct2010

Role: .NET Developer

Project: Prepaid (Transaction Processing)

Description: Co-Operative Bank provides a nationally connected, locally coordinated payments service

for all sorts of businesses. It enables the transaction processing in a secure and swift manner with total

precision. It is the single card and non-card electronic payment processing solution that lots of businesses

rely on. Prepaid is one of the product/service offered by Co-Op Pay Card which include Prepaid Card

and Gift Card.

Responsibilities:

Involved in the gathering and preparation of requirements specification documents for the task

required.

Prepared product specification documentation and overall program architecture for the task

specified using MS Visio.

Involved in updating the MS SQL Server 2005 database, designing tables and constraints. Wrote

Stored Procedures as and when required.

Involved in testing and debugging the batch-jobs, web pages against MS SQL server and Oracle

server for product migration.

Developed custom page classes in App Code and code-behind to support the presentation layer

Used user controls extensively for reusing code and mark up.

Extensively Enhanced Performance of Database by implementing table partitioning on multiple

tables with hundreds of GB sizes, tuning by creating table partition by date range, and also by

creating multiple data file groups for max utilization of I/Os.

Developed and implement complex T-SQL, VBScript and PowerShell scripts for administration

tasks.

Extensively worked on SSIS for data manipulation and data extraction, ETL Load.

Created extensive reports using SSRS (Tabular, Matrix).

Incorporated encryption and security layers throughout the application.

Generated reports using SSRS (SQL Server Reporting Services).

Converted the daily Batch jobs from VB 6.0 to .NET efficiently without using the conversion

ntools.

Performed unit testing and Integration testing of the application.

Environment: .NET Framework 2.0, C#, Microsoft Visual Studio .NET 2005, Enterprise Library, Visual

Source Safe, ASP.NET, Web Services, OOPS, JavaScript, ADO.NET, MS SQL Server 2005, SSRS.

EDUCATION:

BACHELOR OF TECHNOLOGY IN COMPUTER SCIENCE FROM JNT UNIVERSITY,

INDIA.

MASTERS IN COMPUTER SCIENCE FROM NEW YORK INSTITUTE OF

TECHNOLOGY, USA.



Contact this candidate