Post Job Free

Resume

Sign in

Sql Server .Net

Location:
Gandhinagar, GJ, 382010, India
Posted:
February 23, 2016

Contact this candidate

Resume:

Mahesh

980-***-****

actnsc@r.postjobfree.com

Lok

Email: actnsc@r.postjobfree.com

Phone:203-***-**** Ext 216

PROFESSIONAL SUMMARY:

.NET consultant with 7+ years of experience in IT with expertise & exposure to all the stages in software development life cycle including requirements gathering, software design, development and testing/support using Microsoft Technologies.

Extensive experience with Microsoft.Net Technologies (.NET Framework, MS Visual Studio .NET, ASP.NET, ADO .NET, C#.NET, Windows Services, LINQ, Web Services/WCF), EntityFramework and various relational databases (SQL Server, Oracle).

Experienced in Object Oriented Programming and Design Patterns.

Worked in Water Fall and Agile/Scrum methodology.

Experience in front-end HTML/HTML5, JavaScript (including JQuery, AngularJs, and Sugar Js) and CSS/CSS3 and designed and implemented the UI with extensive use of JavaScript, JQuery and Ajax.

Involved in Client Interaction meetings and in co-coordinating releases with multiple/Onshore/offshore teams.

Developed GUI using Web based (Web Forms, ASP.NET) application development using C#.

Worked on Web applications using MVC2.0/3.0/4.0.

Experienced in consuming and developing Web Services using Simple Object Access Protocol, developing Service Oriented Architecture [SOA] based services

Developed services using Windows Communication Foundation (WCF)

Working experience with JAVASCRIPT, JQuery, JSON, AJAX, HTML5/4

Strong analytical and programming skills with proven track record in creating elegant, flexible and maintainable solutions as per Business Requirements.

Involved in Unit testing, Integration testing and Functional testing.

Working knowledge in configuration and version management using Visual Source Safe (VSS),Clear-Case, Subversion (SVN) and Team Foundation Server (TFS2008/2010)

Extensively used Data Reader and Datasets in ADO.Net to retrieve, display, edit and update data in the database.

Experience with Unit Testing, System Testing, Performance Testing and Load Testing.

Experienced with LINQ and Entity Framework

Well-versed knowledge in SQL, T-SQL, stored procedures, functions, cursors, triggers, views, joins using SQL Server 2005/2008/2012.

Working experience with SSRSreports and SSIS packages

Good Knowledge in designing Use-Case diagrams, Class diagrams, Interaction diagrams (Sequence diagrams, Activity diagrams and Collaboration diagrams) using Designer tools like MS Visio.

Good understanding of technology with focus on delivering business solutions.

Comprehensive problem solving abilities, excellent verbal and written communication skills, Interpersonal Skills and Leadership Qualities.

TECHNICAL SKILLS:

Languages

C#, VB.Net, Javascript, JQuery

.Net Technologies

ADO.Net, ASP.Net 2.0/3.0/3.5/4.0, ASP.NET MVC, .Net Framework 1.1/2.0/3.0/3.5/4.0, WCF Web Services, WPF, LINQ, Entity Framework

Web Technologies

XML, HTML, DHTML, XHTML, WSDL, UDDI, CSS, XSL, XSLT, JavaScript, JQuery, JSON, AJAX

Databases

MS-SQL Server 2000/2005/2008, Oracle, MS Access 97/2000, TSQL, PL/SQL

Other tools

Visual Studio .NET 2005/2008/2010, Microsoft Visio, Dreamweaver

Web Servers

IIS 5.0/6.0/7.0

Versioning Tools

Visual SourceSafe(VSS), Subversion(SVN) and Team Foundation Server (TFS)

Source Code Control:

Subversion(SVN), IBM Rational Clear Case, Vault Professional, Visual Source Safe (VSS)

Operating Systems

Windows Win7/Vista/XP/NT/Server 2000/2003/2008

EXPERIENCE:

Hartigen, Houston, TX

Jan ‘15 – Till Date

.Net Developer

Hartigen is full-service energy consulting and Software Company that delivers deep subject matter expertise and rapid software application development capabilities. Its strength is working with clients to define the need, transform it into an efficient solution, and see it through to delivery.

Responsibilities:

Participated in meetings with Business users and with other project teams to ensure that the volatile business requirements reflect in the project development.

Involved in complete Life Cycle including Analysis, Design, Development and Testing and followed Agile Methodology

Developed the application using ASP.NET MVC 4.0/5.0, C#/Vb.Net, SQL Server 2012/2014and SDLC on the visual studio IDE.

Designed and implemented User Interface Layer using ASP.NET MVC 4.0 and unit tested it.

Used EntityFramework for ORM mapping to relational databases, classes to database tables and CLR data types to SQL server data types.

Implemented the applications using SOAarchitecture

Used Razor syntax in creating Asp.NetMVC application by reducing the coding aspect.

Created and Consumed WCFServices in the serviceslayer

Used T-SQL to include querying and making changes in the database, using functions, Stored procedures, triggers and CRUD statements in SQL Server 2012/2014

Worked on Implementing SSIS packages using BIDS for Data Transformation and Loading, scheduling the synchs between databases

Worked with SSRS reports and its datasources using BIDS

Used AngularJs, Bootstrap for building the UI Modals.

Also worked on implementing the OOP’s, OOD patterns in the project.

Used Javascript and Jquery for client side scripting to create highly responsive interfaces for users.

Implemented Ajax features of JavaScript to have the specific content loaded as per user needs.

Also wrote Model Classes under MVC 4.0 using the principles of OOP’s.

Maintaining a web application using IIS 7.5.

Developed and consumed Web services using WEB API and WCF platforms.

Worked on JQuery to implement customized behavior of the website.

Used SOAP protocol for accessing web based services and communication between applications

Performed application development modules and activities.

Used ADO.NET for communication withOracle11i Database

Involved in System Unit Testing and Integration testing in development environment and ensuring application is according to specifications.

Involved in the designing phase of database and creating the SQL scripts.

Also involved in writing queries using LINQ feature.

Played an active role in implementing the Business Logic Layer.

Studied the existing Application and designed new screens for the Web Application.

Created HTML scripts using HTML 5 version to inculcate JavaScript data and in order to validate HTML/DHTML form’s data that was submitted by the user.

Worked on Team Foundation Server for source control and versions controls, branching & merging

Environment:.NET Framework 4.0/3.5, MS Visual Studio.NET 2012/2010, BIDS, Entity Framework, MVC, ASP.NET, C#.NET, VB.NET, UML, CSS, JavaScript, jQuery, XML, Angularjs,LINQ,TFS, SQL Server 2012/2014, SSIS, SSRS, IIS 7.5, Windows Server 2003/2008.

Optum Insurance, CT

Sept '13 - Dec '14

.Net Developer

Optum is a trading name of Unites Health Care which provides Health insurance and medical care options for small business and employer groups, individuals and families, Medicare, dental and pharmacy benefits. The solution was to build a backend system to handle the billing, invoicing, and installments and auto-renewals.

Responsibilities:

Developed and performed Unit Testing onASP.NET MVC 4.0/3.0 applications using Razor View Engine

Involved in requirement gathering, functional and technical specification.

Followed Agile with SCRUM implementation for development cycle.

Used OOPs concepts in project development. Worked on Implementing MVCdesign pattern for developing the Web Application.

Developed and used various Web forms, Custom Controls and User controls using ASP.NET, C# and JavaScript.

Developed Web Applications using HTML, CSS, AJAX, IIS 7.0, and C#, VB.NET, ASP.NET, JavaScript, XML, SOAP and Visual Studio.

Designed the user interface screens and implemented application logic under the Microsoft .Net Framework using C#.

Followed TDD (Test Driven Development) while developing the applications

Created and consumed Restful API with using Web API

Developed and consumed WCF Service to access data layer components.

Developed the application using various patterns including MVC 4.0, Singleton and Dependency Injection.

Used WCF for designing and deploying distributed applications under (SOA) implementation

Designed and Implemented Business rules engine using C#.

Developed reusable user controls& used third party custom web controls using C#, ASP.NET.

Developing screens using ASP.Net server controls & doing form field validations server side validations using C# and ASP.Net.

Worked on Master pages to build consistent and maintainable user interface.

Worked with LINQ and EntityFramework in the data layer

Programmed ADO.NET for communication between application and database, used extensively Dataset, Data Table, and Data Readers.

Performed logging using Microsoft Enterprise Application Blocks

Developed Tables, Stored Procedures, Triggers and Functions in SQL Server 2012.

Worked on SSIS packages and scheduled jobs and SSRS reports using BIDS

Worked with Unit Testing of all the modules developed.

Developed the data base objects like Tables, Views, Stored Procedures, and Triggers using SQL Server 2008.

Environment:.NET 3.5/4.0, ASP.NET, C#, VB.NET, Visual Studio 2010/2008, TDD, HTML 4/5, XML, MVC 3.0/4.0, ADO.NET, Entity Framework, SOAP, WCF Services, WPF, WEB API, Javascript, JQuery, T-SQL, SQL Server 2012, SSIS, SSRS, BIDS, CSS, Ajax, Ms Visio, TFS, IIS 7.0, Fiddler

Xerox, NY

Feb ’12 – Aug’13

.NET Developer

Xerox Corporation has been a leader in document technology and services providers. . Worked on Xerox's marketing, retail and sales applications which help all the sales persons to do their task effectively and also it help the sales managers to keep track of the retail sales and run the reports to see the performance.

Responsibilities:

Involved in all phases of Agile SDLC which Involves Project Planning, Analysis, Design, Documentation, Development, implementation and support of software applications based on N-tier architecture.

Involved in the process of designing and developing web based UI Layout using ASP.NET.

Worked with TelerikRad Controls to develop rich interactive engaging User Interfaces

Developed the Business Logic Layer using C# .NET.

Worked with LINQ to SQL,EntityFramework in the data access layers and WCF Services in the services layer.

Worked on WPF applications to build desktop tools

Used extensively JavaScript and ASP.NET AJAX for front end and Ajax framework.

Implemented client side logic using Java Script.

Used Ajax (Asynchronous JavaScript and XML) for calling server-side code from the client side to avoid post-backs, making the process faster.

Created and consumed WCF web services in the application

Used ASP.NET client side and server side state management to preserve data

Used ASP.Net caching to improve the performance of the pages

Responsible for writing stored procedures in T-SQL for backend communication.

Created triggers, functions, cursors and joins on database tables in SQL Server database

Worked with Oracle database and maintained the existing Stored Procedures and other objects using PL/SQL

Involved in Unit testing, bug fixing and User acceptance testing.

Used TFS (Team Foundation Server) for source control.

Environment:Visual Studio.NET 2012/2010, .NET Framework 4.5/4.0, TDD, C#.NET, ADO.NET, Entity Framework, LINQ to SQL, ASP.NET, AJAX, XML, SOAP, TelerikRadcontrols, Fiddler, TFS 2008, SVN (SubVersion), SQL SERVER 2008/2005, BIDS, Oracle 10g, WCF, WPF.

ToysRUs - Wayne, NJ

Oct’09 to Dec ‘11

.Net Developer

ToysRUs is a baby super market with its retail stores all over the country. Retail Point of Sale is the register software and is installed on the registers, which are the transaction terminals. Applications on the register are used by the Retail Store associates. Retail Register Applications are used to perform various tasks like scanning the items, offering deals/offers and completing the transactions using Cash/Credit/Debit etc.

Responsibilities:

Developed UML Diagrams using MS Visio

Involved in Business Analysis and Development of Application

Created and consumed WCF services in theService layer.

Developed SOA Application using Services layer, Business Logic Layer, Presentation Layer and Database Layer.

Extensively used Master Pages to achieve consistent look and feel of the web site.

Implemented Authentication in ASP.NET application

Involved in developing Web Services and invoking them by using XML, SOAP and WSDL for creating proxy classes.

Created event driven Web Forms using ASP.NET and implemented form validation using Validation controls using both Custom validation and JavaScript was written for Client side validations.

Worked on SQL Server 2008 to access the database in an efficient manner using LINQ to SQL.

Used ADO.NET objects, Dataset, Data Table, Data Relations and Data Adapter for manipulating, retrieving, storing and displaying data from SQL Server 2008 Data Source.

Extensively used Data binding concept to display the required data.

Involved in creating stored procedures, triggers, and views in SQL Server 2005 for data manipulation and retrieval using T-SQL.

Involved in ETL packages maintenance using SSIS

Created and Updated Queries, Stored Procedures and Triggers.

Performed Unit testing using Visual Studio

Used VSS asrepository purpose.

Environment:.NET 2.0/3.5/4.5, ASP.NET 2.0/3.0/4.0, C# 3.0, VB.NET, Visual Studio 2010/2008/2005, MS SQL Server 2005, IIS 6.0, WCF, WPF, LINQ, Crystal Reports, VSS, AJAX, ADO.NET, LINQ to SQL, XML, SOAP, XML, XAML, SSIS, SSRS, BIDS, T-SQL, Visual SourceSafe 6.0, Agile, IIS

TCS - India

.Net Developer

Aug '08 - Sep '09

This application is a novel approach to enhance the learning capabilities by adopting modern technology. Aim is to see that the learner (user) gets a better grasp of understanding of the subject material through this WBT. The titles involve Search functionality, quiz and Web based content. The tutorial had the following features. Login, Navigation between the pages, Page Numbering, User Session, User-Time spent and Time left, Glossary, Quiz, Question Bank, Search and a graph to display the performance in the test taken.

Responsibilities:

Involved in Design, Development and testing of application.

Design Web pages using C#, VB.NET, ASP.NET, HTML, JavaScript, and CSS.

Participated in requirement gathering sessions with the client and preparation/modifying of the requirements in Requirement Specification document.

Implemented client side custom validation using JavaScript.

Created User controls, web controls in ASP.NET

Involved in the design, development and maintenance of the SQL Server 2005.

Performed Unit testing, debugging and problem solving.

Environment: C#, VB.NET, ASP.Net, HTML, XML, SOAP, CSS, JavaScript, TSQL, SQL Server 2005, IIS 5.0/6.0

EDUCATION:

Bachelors in Technology



Contact this candidate