Sql Server .Net

CHARAN

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

Sr. Dot Net Developer Ph.: 913-***-****

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, ADO.NET, Web Services 2.0/4.0, and SQL Server 2008/2012/2014).

5 years of experience in using WCF, WPF and ASP.NET MVC.

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.

Worked with ASP.NET MVC and Entity Framework.

Good Knowledge of 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.

Good Knowledge on Web Services (SOAP, WSDL, UDDI), XML.

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.

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.

Good knowledge on Third party software like telerik web controls.

Excellent communication skills.

Worked in diverse fields like Health, Transportation (METRO RAIL), banking, Real Estate, Tele communications.

Proven Ability to analyse 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

Tools & Technologies

ADO.NET, LINQ to Entity Framework, CSS, Web Services, User Controls, Agile, Scrum, Team Foundation Server, Bootstrap, CSS, AJAX, JQuery, AngularJS, WCF, WPF.

Web Development Tools

ASP.NET, HTML, HTML5, JavaScript, JQuery, CSS, CSS3, Bootstrap, MVC4, MVC5, 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

Client: CSS, Kansas City, MO. Mar 2015 – till date

Sr. Net Developer

Project: Member Site

Description: CSS is the first company to address the issue of home showing inefficiencies in the residential real estate community. CSS currently schedules over 20 million showings per year and has over 170,000 real estate agent members in over 70 markets across the U.S. In CSS, we are working on a project called Member site, it helps the local agents to register for the business locations, upload the new property details and assist customers in respective area to schedule an appointment with local retail broker.

Responsibilities:

Created a Web application by using MVC 5, Web API, HTML5, CSS3, Bootstrap, AngularJS, JQuery, AJAX.

MVC handles the session and routes for the whole system.

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

Used Entity Framework for Database Operation.

Developed and maintained enterprise reporting (SSRS Reporting Services) based on specifications and business needs and modified existing reports as needed.

Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.

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

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

Applied HTTP methods to perform CRUD Operations

Worked with LINQ and Lambda Expression to perform query operations

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

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

Used tab-panel and dialog to manipulate the forms.

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

Environment: Visual Studio 2015/2012, SQL Server 2012, .Net 4.5/4.0/3.5, MVC 5 Web API, AngularJS, C#, JavaScript, HTML5, CSS3, JSON, N-Tier, SSRS, SSIS, Entity Framework, LINQ, Lambda Expressions.

Client: Life Lock, Tempe, AZ. Dec 2013 – Feb 2015

Sr. Net Developer

Project: swift

Description: The Current project is SWIFT. This is a Windows forms based Client Application. Main objective of this application to provide robust theft protection. 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.

Responsibilities:

Designed and developed SWIFT application using ASP.NET 4.0, MVC 5, Bootstrap, Entity Framework 6.0, C#.

Worked in Agile Methodology for implementing the Project.

Worked extensively with JQuery UI Components like Grid, Dropdown List, Date Picker, Tab Strip, Tool Tip, Combo Box etc.

Responsible for Designing and Developing of Reports using SQL Server Reporting services (SSRS).

Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Intelligence Development Studio (BIDS).

Worked extensively with editable Grids. Also involved writing different event handler like data bound, change, edit, save for Grid.

Implemented Client Side Validations using Data Annotation Attributes.

Used C# to write business layer.

Used LINQ for data retrieving, querying, storage and manipulation interface screens developed using ASP.Net.

Published Web services using C#.NET to interact with the other applications and exposed them using SOAP and HTTP.

Extensively used JavaScript for UI interaction, XML for data transmission via WCF services and data manipulation using LINQ.

Used ADO.NET (Data Adapters, Data Sets) for database connectivity to SQL Server database.

Created the reusable and optimized Web Services using C#.NET. These services included self-defined structures for data input and were exposed using WSDL with SOAP format as well as consumption interfaces for them.

Used Unity for dependency Injection.

Linq and Stored procedures were used for data retrieval.

Used NUnit Framework for writing test cases.

Performed Unit Testing of the developed component and web forms and worked closely with manual testers and automation testers, User Acceptance testers for ensuring the desired functionality is achieved.

Involved in meetings with business users and QA team.

Environment: ASP.NET 4.5/4.0, MVC 5, C# 4.0, T-SQL, JavaScript, JQuery, AJAX, Web API’s, Entity Framework 6.0, Bootstrap, NUnit, SSIS, SSRS.

Client: Verizon, Ashburn, VA Jun 2012 – Nov 2013

Senior Software Engineer (.Net)

Project: GBeORdering

Description: Verizon provides fast and accurate services to customers by issuing offers or discounts, according to the availability in the area. GBeOrdering is part of Verizon.com which is used to provide services to customers. These services (phone, DSL, FIOS TV and FIOS Internet services), are shown based on the customer location and eligibility (new users and existing users). This application features powerful search functionality using Web services to process customer's account information and retrieve the products. This application also helps the customers in ordering the right products by offering different plans and bundles options.

Responsibilities:

Developed application using ASP.NET 4.0, MVC 3, Razor, C#, HTML5/CSS3, JavaScript, HTML helpers.

Implemented Model-View-Controller pattern to provide clean separation of concerns.

Implemented database approach to create Entity framework model to handle exchange of data between the database and web application.

Used data annotation for server-side validation and JavaScript validators for the client side validation.

Created Graphical User Interface (GUI) applications that was designed using ASP.NET 4.0/3.5 and the business logic was coded in C#.

Followed the N-tier architecture for the application development with Presentation Layer (UI), Data Access Layer (DAL) and Business logic layer (BLL).

Prepared various test cases to fix the bugs and ensure the application error-free.

Used .Net Framework class library to build user interface that separated application logic from presentation code using code behind pages.

Designed User Controls for component reusability.

Used Repeater Control to display customized menus.

Used AJAX (popups, autocomplete, date picker) to create better, faster and more user-friendly applications.

Used ADO.NET to access and modify data stored in the client’s database and to complete business requirements.

Used SQL queries and stored procedure for Database Operations.

Created stored procedure for user Authentication to avoid SQL injection.

Designed and developed Class Libraries for Data Access, Exception Handling, Logging and Session Management etc.

Maintain user authentication based on user role .

Environment: Visual Studio 2010/2008, .Net Framework 4.0/3.5, C#, ASP.NET, SQL Server 2008, WCF Web Services, ADO.Net, HTML, AJAX, JavaScript, AJAX, NTier and Web forms.

Client: L&T Metro Works, Hyderabad, India. Nov 2010 to May 2012

Dot Net developer

Project: Metro Hyderabad

Description: L & T Metro Works is leading Construction company in India, company provides all kinds of construction services. The largest construction lead. I worked on a project which was creating a web application to save the materials related for each zone. It also provides supervisors a space for submitting their status. This application is an upgrade implantation for the extended functionalities for Pre Quoting and Agent Lead Processing. As there are many zones these supervision helps in integrating the whole work.

Responsibilities:

Responsible for developing the Logic using C#.NET.

Extensively used ASP.NET 2.0, HTML, CSS and Web controls for developing front end screens.

Implemented Business Logic using C# and Data Access Layer using ADO.NET.

Suggested various design changes in SQL Server tables and Stored Procedures.

Used ADO.NET for database connectivity on SQL Server Database.

Used ASP.Net validation controls and custom validation controls for client side validations.

Used XML and XSL Transformations to display content on the website.

Helped the Production Team and Testing Team in solving the complex issues.

Successfully handled all the change requests, code defects and Data Configuration Bugs.

Worked closely with business users to define reporting requirements and documenting the requirements in order to design, develop and maintain Crystal reports.

Involved in Unit Testing during development and maintenance phases.

Environment: C#, ASP.Net, ADO.NET, JavaScript, Microsoft SQL Server 2008, XML, XSLT Windows XP, Crystal Reports, CSS.

Client: ICICI Bank, Hyderabad, India. June 2008 to Oct 2010

Jr. Dot Net developer

Project: Prepaid card

Description: ICICI Bank is a first private bank which is 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 all the phases of the Software Development Life Cycle (SDLC).

Performed functional requirement analysis and was involved in system design based on n-tier architecture.

Re-wrote parts of existing application modules for performance and implemented the reusability.

Involved in the development of Business Logic Layer and Data Access Layer in C#.

Created classes and modules in C# using Visual Studio.

Developed the Front End using ASP.NET and Code behind using C#.NET.

Used features like Dataset, Data Reader and Data Adapter to develop a Data Access Layer using ADO.NET. Involved in Database design.

Wrote and used stored procedures and triggers using T-SQL in SQL Server 2005.

Wrote Windows services for job scheduling of auto e-mail notifications.

Worked on the Calendar Control to display the scheduled transfers.

Created .NET Crystal Reports for statistical analysis of usage of the system, which can be accessed as web report as well as in PDF format using acrobat reader.

Used Windows Services to trigger the scheduled transfers.

Used Custom Validations Controls with JavaScript for client side validations.

Environment: C#.NET, ASP.NET, ADO.NET, HTML, Java Script, SQL Server 2005, T-SQL, Crystal Reports, XML, IIS 5.0, Visio, Visual Source Safe, Windows.

Education:

Bachelor’s degree from JNTU university, Hyderabad, INDIA

Contact this candidate