Sql Server .Net

Ramanjaneyulu

Email: ********.***@*****.***

Phone: 201-***-****

PROFESSIONAL SUMMARY:

8+ years of experience in software development life cycle, which includes Requirement Study, Analysis, Design, Development, Integration, Re-Engineering, installation, implementation, testing, configuration management, maintenance and production support of various client/server, N-tier, windows and web applications in various domains using Microsoft .NET Technologies.

Technical expertise in Microsoft Technologies, such as .NET […] ASP.NET, ASP.NET MVC, C#, VB.NET, Web Services, WCF, WPF, SILVERLIGHT 4.0/3.0, LINQ, Entity Framework, IIS, SOAP, XML, DOM, XSL, XSLT, HTML5, DHTML, CSS3, Java Script, Angular JS, AJAX, ADO.Net.

Expert in designing and developing web based and windows based applications using ASP.Net, C#, VB.Net, ADO.Net, Web Services, ASP, IIS, JQuery, HTML, XML, AJAX.

Experience in Systems Analysis, Design, Development and Implementation of various applications as. Involved in all phases of Software Development Life Cycle (SDLC) with N-tier development, agile environment.

Proficient in using XML related technologies including AJAX, XSLT, XPATH and XQUERY.

Expertise in working on development projects utilizing Agile/Scrum development techniques.

Expertise in implementing projects using Service Oriented Architecture (SOA), MVC Architecture, Multi-tier, High-Performance, Scalable and Distributed and architectures

Extensive experience in Multithreading, Object Oriented Programming (OOPS), Object Oriented analysis, design (OOAD).

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

Hands on Experience in databases such as MYSQL, Microsoft SQL Server, ORACLE. MongoDB (No Sql).

Extensive experience with development & deployment of Web Services (SOAP, UDDI & WSDL).

Expertise in developing data access layer using ADO.net, Entity Framework, and Enterprise Libraries.

Strong analytical and conceptual skills in database design, development, writing Stored Procedures, complex SQL, and Triggers with various RDBMS databases.

Experience with Test-Driven Development (TDD) like N-Unit testing frameworks and MS unit Tests.

Extensively worked with ADO.Net to connect to SQL Server using Connection, Command, Data Adapter, Dataset and Data view objects.

Worked with Entity Framework to connect to the database.

Hands on experience in bootstrap with ASP.Net Web forms and ASP.Net MVC.

Developing Prototype for the project using AJAX, Hardcoded JSON, JQuery, AngularJS, JavaScript, HTML, and CSS.

Experienced in XML Web Services (SOAP, WSDL and UDDI), Service Oriented Architecture [SOA] concepts using .NET Framework Recent experience working with PRISM and MVVM design patterns for Silverlight and WPF.

Experience in working with Firefox, IE, Safari, Chrome browsers and webservers like IIS 7.0.

Expertise in programming with SQL, PL/SQL and TSQL, Reporting with SQL Server Reporting Services (SSRS) and Knowledge of SQL Server Integration Services (SSIS).

Experience in developing the business reports using SSRS and .NET using Win Forms and Web Forms.

Experience in building SILVERLIGHT 4.0/3.0 applications using .NET. Involved in building a rich web experiences using SILVERLIGHT, JavaScript and Expression blend.

Experience in data object models like Language-Integrated Query (LINQ) and Entity Data frame work to retrieve and modify data and developed entity data frame work services.

Experience in using ASP.NET AJAX framework for quickly creating efficient and interactive Web applications that work across all popular browsers.

Experienced with Microsoft Application building blocks for .Net projects (Data Access, Exception Handling, Caching and Configuration Management Application Blocks).

Experienced in Service Oriented Architecture [SOA] using Windows communication foundation.

Extensively used various design patterns such as Singleton and Factory Method.

Ability to quickly understand business requirement and architecture to help come up with robust solutions and have good experience in Performance Optimization.

Experience in Database Analysis/Design/Normalization/Manipulation processes using SQL Server 2000/2005/2008/2008 R2/2012 and Oracle10g.

Strong Analytical and Communication Skills, and troubleshooting capabilities Problem Solving Skills as well. Worked well as a part of team and independently.

TECHNICAL SKILLS:

Languages C, C++, Basics of Java, C#.Net and VB.Net

.Net Technologies Asp.Net MVC (3/4/5), Asp.Net Web Forms, Asp.Net Windows Forms, Web API (1.0, 2.0), WCF, WPF, Web Services, ADO.Net, Entity Framework.

Scripting Languages JavaScript, JQuery, Angular Js, Bootstrap, Ajax, Json

Markup Languages HTML, HTML5, XML, XAML, XSLT

UI Designing CSS, CSS3, Bootstrap Framework, jQuery UI, Metro UI, Kendo UI

Databases Microsoft SQL Server (2005, 2008, 2008R2, 2010, 2012), Oracle 10g, MySQL, PostGre SQL, Basics of MongoDb and Cache Db

Methodology Agile methodology, Rational Unified Process and Waterfall method

IDE Visual Studio.net (2013/2012/2010/2008/2005/2003), Adobe Dreamweaver, Sql Server Management Studio, Expression Blend (2.0/3.0/4.0), Visual Basic 6.0.

Business Intelligence SSIS, SSRS

Web Server Internet Information Server (IIS)

Source Controls Visual Source Safe 6.0 (VSS), Team Foundation Server (TFS), Subversion, Tortoise SVN

3rd Party Controls Web RTC, Full calendar, Telerik Controls & Kendo UI, High charts, Google visualization tools, other jQuery plugins

PROFESSIONAL EXPERIENCE:

Client: Allied Electronics, Fort Worth, TX Aug 16 –Till Date

Role: Senior .Net Developer

Description: The purpose of this project is to build the existing website which is in web forms to MVC. Allied also upgraded the existing Endeca On-site Search with Hawk Search Engine to improve the customer search experience with a more dynamic and personalized experience. Allied website offers more than 3 million products and is a powerful tool for any engineer or purchaser.

Responsibilities:

Responsible for the Design, Development and Delivery of all the modules.

Developed Web pages that are more user-interactive using JQuery plugins, JSON, AngularJS, JavaScript and Bootstrap.

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

Designed and developed front-end applications using WPF (Windows Presentation Foundation).

Writing Software Requirement Specifications & Test cases, Object Oriented Analysis and Design using UML with Microsoft Visio 2007.

Wrote application level code to add functionality to the perform client side validation using AngularJS and JavaScript.

Used Team Foundation Server (TFS) for version control of the source code along with the maintenance of the builds and the relevant documents of the same.

Implemented and extensively used the Object Oriented programming concepts.

Created & hosted WCF Services and also used different bindings to make it available to different types of clients.

Good experience in Windows Azure Service Bus, and Windows Azure Document Database.

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

Used ASP.NET MVC to add functionality to individual pages such as to accept input from the page request, invoke the requested actions on the controller.

Worked on SSRS to create stored procedures and developed data transformations to meet Business Requirements and to generate Reports.

Created Views, User Defined Functions, Stored Procedures, and Triggers in SQL Server 2008 for inserting/Updating/Deleting/Retrieving the data.

Implementation of the Business logic layer for MongoDB Services.Implemented N-Tier architecture using C#, ADO.NET, WCF and LINQ.

Used Entity Framework for Database mapping while developing a Data Access Layer.

Supported Operations team during the deployment and troubleshooting the production issues during deployment and on regular basis.

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

Environment: Visual Studio 2015,.Net Framework 4.5, Microsoft Azure, MongoDB, Web API, WCF, C#, ASP.NET MVC, HTML5, CSS3, Javascript, AngularJS, IIS, SQL Server 2012, Entity Framework ORM, Restfull, Bootstrap, SSIS, SSRS, TFS.

Client: Carnival Corporation, Miami, FL Jan 16 – Aug 16

Role: Senior .Net Developer

Description: Carnival cruise is the world’s leading cruise lines founded in 1972. The company with 24 vessels is one of the nine cruise ship brands owned and operated by Carnival Corporation & PLC. The project was to design, develop and support software solutions for the company’s fleet.

Responsibilities:

Involved in the development of the intranet Site using ASP.NET MVC and C#.

Used Data Adapters, Datasets and Command & Connection Objects of ADO.NET to manipulate Data in the SQL Server Database.

Developed SPA app using AngularJS, Kendo UI and EmberJS.

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

Experience in Windows and Web Application using .NET Framework, C#.NET, ASP.NET, VB.NET, Web Services (WSDL, UDDI and SOAP), ADO.NET, and MS SQL Server.

Implemented service oriented component (SOA) Layer using C#.net and WCF to decouple the User Interface (UI) with Business Layer (BL).

Wrote Stored procedures and SQL statements for report generation and data modification activities.

Developed rich client interface using Windows Presentation Foundation (WPF) using XAML.

Designed and developed WCF Services and configured our WCF Services with appropriate endpoints for consuming them in the web application.

Used Cascading Style Sheets (CSS3) for a unified look and feel of the application.

Used Bootstrap for styling to the Header and Footer.

Created various reports like tabular reports, matrix reports, and parameterized reports using SSRS.

Implemented Ajax calls using JQuery and JavaScript

Used JQuery Tables to display data in a customized format in ASP.net web pages.

Used ASP.NET Ajax Toolkit controls like Script Manager, Update Panel, Extender controls

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

Experience in Microsoft Azure IaaS, PaaS and SaaS Architecture, Strategy and Planning. Working knowledge of visual studio 2015 with Azure.

Used Visual Source Safe effectively to handle version control.

Converting an existing Access/Excel/VBA program to VB.NET/SQL Server.

Involved in studying the use-cases to deduce the methods to be implemented in the framework to support the portal.

Environment: .Net 4.0,C#, ASP.NET, ADO.NET, WCF, WPF, MVC4, SQL Server 2008, WCF, CSS3, SOAP, SSIS, SSRS, JavaScript,, Angular JS, TFS, UML, JQuery, Bootstrap, AJAX, IIS

Client: PNC Mortgage, OH Mar 14 – Dec 15

Role: .Net Developer

Description: PNC offers a wide range of services for all customers, from individuals and small businesses, to corporations and government entities. It also provides a wide variety of borrowing options – First-time home buyer, refinance current home, move up to something larger or purchase vacation homes. PNC offers the optimal mortgage solution to ensure customer obtains the best loan.

Responsibilities:

Involved in the Enhancements and Support for various applications.

Developed GUI of ASP .NET web forms using HTML, CSS and JQuery, Ajax, ASP .NET Ajax Library are used for rich interaction and partial page rendering.

Prepare Use Cases and Test Cases.

Application blocks are developed using Microsoft Enterprise Library 3.0.

Written SQL Queries for indexes, triggers, functions and stored procedures.

Design and developed Business Logic Layer and Data Access Layer using LINQ to SQL.

Involved in ASP.NET Security, State Management, Caching and Encryption.

Involved in development and usage of user controls in various web pages.

Implemented the business logic in the middle tier using C#.

Designed and implemented components that convert disconnected record sets to valid XML that are transformed by XSL/XSLT/XPATH files to HTML, DHTML.

Created web services for publishing and consuming data successfully.

Extensively used Validation Controls and Custom validation controls to validate Web forms.

Analyzed and fixed defects.

In depth knowledge of Crystal Reports, Windows Communication Foundation (WCF), Windows Presentation Foundation (WPF) using .NET 3.5/3.0 and Silverlight.

Developed XML and Collection parser using LINQ.

Extensively used HTML and JavaScript as client side scripting languages.

Involved in the code changes and development of new web-forms and connectivity to database to get and store data from and to database.

Involved in writing typical complex SQL queries and stored procedures using T-SQL.

The backend, database connectivity modules were designed using ADO.net with SQL Server as the database.

Used TFS for Version Control.

Effectively used Microsoft Team Foundation Server for Application Configuration Control.

Environment: .Net 4.0, C#.NET, ASP.NET, ADO.NET, AJAX, Visual Studio 2010, XML, HTML, DHTML, CSS, XML, SOAP, JavaScript, jQuery, IIS 7.0, SQL Server 2008, XSLT, Reporting Services, Web Services, Microsoft Enterprise Library

Client: First Citizens Bank, Raleigh, NC Oct 12 – Mar 14

Role: .Net Developer

Description: First Citizens Bank is one of the premier financial service organizations in NC. In this project, I was involved in developing a web portal for the online personal banking module. The bank provides different services like personal banking, business banking, International banking, credit card, brokerage, Home loans, POS and Insurance plans.

Responsibilities:

Analyzed the client’s requirement and was involved in various meetings with Clients.

Involved in designing and developing the User Interface Application using .NET.

Used ADO.NET code to retrieve data from the database and to store back the data to database.

Developed services using XML and XPath.

Controlled overall look and feel of ASP.NET web site by consuming Bootstrap.

Used C# in developing the business logic and implemented the Object Oriented Programming Functionalities.

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.

Used LINQ to build a set of operations, parameters and expressions (Binary, Unary, and Lambda) while “Querying” a set of data from an SQL Server.

Used VSS to maintain the version and source control

Used LINQ was used as a middle ware component encapsulating the business logic.

Client side validations were performed using Java Script and .NET validation controls.

Cascading style sheets (CSS) were used to attain uniformity through all pages.

Used Visual Source Safe for Version Control.

Involved in production support of the application.

Participated in various Clients meeting with the team and the Project Manager to discuss improvements/amendments in the development of the application.

Environment: ASP.NET, C#, ADO.NET, ASP.NET MVC, Web Forms, Angular JS, JavaScript, HTML, CSS, Bootstrap, Restful, WPF, SOA, LINQ, AJAX, Visual Studio, WCF, Web Services, WSDL, IIS, C#, ADO.NET, IIS, TFS, SQL Server 2008.

Client: Philips Health Group – Nashville, TN June 2010 – Sep 2012

Role: Software developer

Description: The project deals with Implementation of health Care handling system for big organizations. This is an Intranet application which is totally web based application for choosing the different Health Care benefits for CareFirst and WellPoint Customers. It provides project management, budgeting and financials, patient management, investigator management, compliance with FDA regulations, and compatibility with event reporting systems. The web application was secured, selectively accessible, and easy to maintain while preserving data integrity.

Responsibilities:

Designed and Developed different modules, using VB.Net.

Used ADO.Net objects such as Data Reader, Dataset and Data Adapter for consistent access to SQL data sources.

Involved in development of Web Forms, classes using ASP.NET that incorporates both N-TierArchitecture, and Database Connectivity.Designed Graphical User Interfaces (GUI) using Layout Pages, HTML, JavaScript, CSS classes and Custom controls.

Developed solutions using C#, ASP.NET MVC and ADO.NET Entity Framework

Designed and created Relational database tables using Normalization, Managed clustered and non-clustered indexes and implemented Relationships b/w tables.

Used Angular JS for SPA and client Side Validation and also performed Asynichorization using Ajax GET and POST HTTP request.

Used Model View Controller (MVC) architectural Design Patterns for the development of the product

Worked on Master pages, partial pages, Themes and HTML helpers using Razor View Engine

Accessed Stored Procedures and Views with ADO.Net programming.

Developed Architecture for the Presentation Layer, Business Logic and Data Access Layer.

Developed Cross Tab Reports, Sub Reports and Parameter Reports by using Crystal Reports.

Utilized ADO.NET Entity framework extensively for data retrieving, querying, storage and manipulation using LINQ

Environment: .Net Framework 2.0, Visual Studio 2005, CSS, ASP.Net, VB.Net, ADO.Net, JavaScript, SQL Server 2005, HTML, XML & XSLT/XPath, XSL, XSD, Crystal Reports, Web Services, Visual Source Safe.

Slokam Technologies – HYD, India May 2008 - May 2010

Role: .Net Developer

Responsibilities:

Responsible for understanding the business & the technology of the client system.

Developing the Design and Functional specifications and Flow of business.

Designed and developed web based UI in C# using different controls like HTML Controls, Data Controls and Web Controls.

Developed front-end screens using ASP.Net Web forms, AJAX, JQuery and JavaScript. Involved in application design based on MVC Design Pattern and OOPS concept.

SSIS packages were developed to load the initial client provided data into database.

Worked on Themes and CSS for the layout of the web application.

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

Created data access layer to communicate with the SQL Server Database with ADO.Net objects.

Worked on ADO.Net components SQL Connection Object, SQL Command Object, Data Reader, Data Adapter, Data Set and Data View to provide communication to the database.

Created Stored Procedures, Functions, and Triggers using T-SQL in SQL Server 2005 to 2008 insert, update, and delete data inside tables.

Developed a data repository page using Data Grid control, ADO.NET.

Created WCF service to allow clients to communicate using WCF services.

Data base restoring and taking back the backup of the database.

Performing unit testing for various modules of the system.

Responsible for imparting application knowledge and technical learning to the new team members inducted into the Project.

Environment: Windows XP, Visual Studio, ASP.NET, ADO.NET, Web forms, Classic ASP, Java Script, Web Services.

Education:

Bachelor of Science in Computer Science, JNTU, INDIA.

Contact this candidate