Post Job Free

Resume

Sign in

Sql Server .Net

Location:
Lee's Summit, MO
Posted:
June 30, 2017

Contact this candidate

Resume:

Abhishek

.Net/UI Developer.

Phn: 816-***-****

E-mail: ac03a9@r.postjobfree.com

PROFESSIONAL SUMMARY:

Around 3 years of experience in designing and developing collaborative solutions using various Microsoft Technologies (ASP.NET 3.5/4.0/4.5, C#, ADO.NET, Web Services and SQL Server 2008/2012/2014).

Good knowledge in software experience in evaluation, design, development, testing, maintenance and production support using SDLC (Software Development Life Cycle) process. Also had extensive amount of knowledge with Agile Methodologies, XP(TDD, continuous integration, pair programming),Waterfall methodologies and SCRUM Framework.

Extensive experience in. Net Technologies which include Object Oriented Languages C#, ADO.NET, Entity Framework, NHibernate, ASP.NET, ASP.NET MVC, MVVM, Web Forms, WPF, web services like Web API and WCF.

Experience in building and deploying web applications using Microsoft Azure.

Extensive command and great exposure in building Web Applications using technologies like HTML5,CSS3, JavaScript, JQuery, NodeJS, AngularJS 1/2, AJAX which are typically used in client side scripting and also Bootstrap classes for responsive design.

Experience in using Object Relational Mapping (ORM) technologies like Entity Framework, NHibernate which are used for the management of the data

Strong knowledge in C# programming language and Microsoft SharePoint which is used for collaboration of documents .

Expertise in creating Views, Partial Views, Strongly Typed Views, Sections, Areas, Controller Actions, Filters, Routing etc In ASP.NETMVC with Razor View Engine and ASPX view pages.

Great command in developing and implementation of RESTful services through WCF, SOAP, SOA, Web API that exposes endpoints using HTTP verbs like GET, PUT, POST, DELETE actions and used FIDDLER tool for testing the service.

Experience in working with IIS (Internet Information Services), ILDASM and ILASM tools.

Expertise in loading the assemblies into GAC (Global Assembly Cache) location by generating Public Key Token (public key and private key pair) through Strong named Tool.

Have strong skills in developing the application using MVC (Model View Controller) framework using Entity Framework with all the three kind of approaches (Schema First Approach, Model First Approach, Code First Approach) which will be used for retrieving and storing the data in the database.

Expertise in SQL Server database (2014/2012/2008) applications using Stored Procedures, Exception Handling, Triggers, Views, Tables, Indexes, Functions(Scalar, Inline table valued, Multi-statement table valued),CTE (Common Table Expression), Error Handling (try, catch), Deadlocks Error Handling and ACID properties.

Worked on LINQ to SQL provider by using both Lambda Expressions and SQL like query expressions in the action methods for performing the desired task.

Good command in the OOPS concepts like Inheritance, Polymorphism, Abstraction, Encapsulation, Interfaces, Exception Handling, Partial Classes, SOLID principles. and also in depth knowledge in 3-Tier, N-Tier architecture pattern that include (Presentation tire, Logical Tire and Data Tire).

Experience in creating reports using Crystal reports and SSRS/SSIS.

Experience in Object Oriented Analysis and Design techniques like UML using Flow Charts/Process Flows, Use Cases and Class, Sequence, Activity, and State Transition diagrams, formulation of deployment strategy and creation of software products as per client requirements.

Experience in performing unit testing using NUnit.

Good knowledge in CRM Custom Solution development.

Experience in using version control tools like Team Foundation Server (TFS) which is used for the code migration between the team members.

Excellent skills in handling the requirements as per client need, great programming ability by constant learning from errors and sharing ideas with the team members. A high-energy technocrat with relationship management, analytical & coordination skills.

Education:

Bachelor's Degree in Information Technology from GITAM University, INDIA.

Masters Degree in Computer Science from University of Central Missouri (UCM), USA

TECHNICAL SKILLS:

Frameworks : Microsoft .Net 4.5/ 4.0/ 3.5.

Programming Languages: C, C++, C# (.Net).

Client side Technologies: HTML, CSS, JavaScript, JQuery, KnockOut Js, NodeJS AngularJS, AJAX, JSON, Bootstrap.

Microsoft Technologies: Microsoft .Net Framework, ASP.NET, MVC 3/4/5, ADO.NET, ADO.NET Entity Framework, LINQ, Webforms, Web API, WPF,WCF.

Development Tools: Visual Studio.NET 2012/2013/2015, Rational Rose, UML.

Databases: SQL Server 2014/2012/2008, ADO.NET, M S Access, T-SQL and Linq to SQL.

Operating Systems: Windows 10/8.1/7/Vista/XP/2000 Professional.

Web Servers: IIS 8.0/7.0/6.0

Methodologies: OOAD, Agile, Scrum and Waterfall.

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

PFROFESSIONAL EXPERIENCE:

Client: TCF Financial, Wayzata, MN September 2016 - Present

Role:Jr.Net Developer.

Responsibilities:

Worked on N-tier architecture to separate the layers and functionality modules.

Worked on enterprise solutions development with rapid SDLC Agile Methodologies (SCRUM).

Developed the application using MVC framework, Entity Framework, WCF, Angular JS, Bootstrap classes, HTML5, CSS3, Java Script.

Worked on several features like Routing, Html helpers, Action Filters, Partial Views in MVC 4.

Developed Interactive UI using UI elements like UIDatePickers, UIPopOverControllers, UITableViewCells, UITabBarControllers, UITableViews, and UISlideViews.

Implemented Angular JS directives, factory, services, providers and custom filters and performed crud operations using $http with respect to the database.

Worked on cloud computing using Microsoft Azure and Addressed web site performance issues across the world with the use of bundling and minification as well as the distribution of static resources using Azure & CDN.

Used Ajax Toolkit & Update Panels for showing Model Pop ups, loading & showing page data asynchronously.

Used Entity Framework to create databases using Code First approach and implemented LINQ to SQL, LINQ to Object Queries & Lambda Expressions to query against strongly typed collections of objects & various data sources and also implemented Data Annotations for different kinds of validation.

Created data access layer to communicate with the SQL Server 2012 and T-SQL (Stored Procedures, Index, Functions, SQL injection, DTS packages, triggers, Updated tables, cursors, tables, views).

Create / Maintain Repository functions containing inline SQL and implemented web services (via Web API Project) to relay data from the repository to JavaScript using Sync/Async Ajax calls.

Worked on various features of WCF such as Service Contracts, Data Contracts, Operation Contracts, Instant Modes and the Security of the services to configure endpoints of WCF and implemented SOAP/REST Services with JSON to retrieve information and also used different bindings like Basic HttpBinding &WSHttpBinding to make it available for different types of clients.

Developed various charts and graphs like bar chart (side by side, stacked), line graphs, pie-charts etc. by using chart expert of Crystal Reports.

Performed Unit tests for each and every functional module using N Unit to detect and solve errors on data-transfer functions for achieving 100% code coverage.

Used TFS (Team Foundation Server) as version control.

Environment: Visual Studio 2012, .NET Framework 4.0, ASP.NET, T-SQL, IIS, AJAX, MVC 4, JSON, JQuery, Entity Framework, SQL Server 2012, Azure, XML, Identity Manager, XSD, XSLT, Web Services, Angular JS Java Script, CSS, XHTML, HTML.

Client: H.S.B.C, INDIA August 2014 - May 2015

Role: Jr.Net Developer

Responsibilities:

Involved in gathering requirements by interacting with the clients and developing Presentation Tire /Business tier /Data Access tier design for the web application and involved in all phases of Software Development Life Cycle (SDLC).

Extensively used UML in the design process of Use cases, Process diagrams, Sequence diagrams, Class diagrams.

Involved in developing User Interfaces using HTML, CSS, JavaScript, Bootstrap, JQuery.

Developed application using MVC 4 framework .

Performed client side validation using JavaScript, JQuery and also implemented Data Annotations (Remote, Required, DataType, Range, DisplayAttribute, DisplayFormat, UiHint etc for different kinds of validation and providing visual feedback using LoadingElementId Ajax Option.

Extensively worked with Action Results, Action Filters and Custom Action Filters, Routing etc

Created Model objects using Entity Data Model with Entity framework.

Implemented design patterns and the entire backend of the application in C# using various object oriented features like classes, interfaces, inheritance, polymorphism etc., and multi-threading.

Used Entity Framework (Code First Approach) to manipulate and retrieve data from the database.

Used FIDDLER tool for testing the service.

Worked on Object oriented design (XML).

Used LINQ to SQL provider for communicate between data source and controller action methods.

Created database Objects like tables, stored procedures and Triggers in SQL to communicate with SQL Server database(2012) .

Used tools like SQLServer integration services(SSIS) in transferring data from one database to another.

Implemented Exception Handling mechanism using .Net Framework Classes.

Created and deployed Web Services using C#, Web API, XML for pulling data records and modified accordingly to interact with the other applications.

Developing and deploying SSRS reports for the reports module like preliminary and final audit reports

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.

Environment: SQL Server 2012. IIS 7, Visual Studio 2012, C#, ADO.NET Entity Frame Work, ASP.NET 4.5, MVC 4, HTML, CSS, JAVA Script, JQuery, AngularJS, Web API, WCF.

Client: Port Trust of India June 2013 - March 2014

Role:Jr.Net Developer

Responsibilities:

Involved in the whole Software Development Life Cycle of the application.

Designed user interface screens and implemented application logic in Microsoft .NET framework using ASP.NET, C#.

Developed ADO.Net based data access layer against SQL Server Database.

Extensive use of HTML, CSS, JavaScript, JQuery for client-side validation..

Implemented AJAX to minimize server round trips to improve overall performance and to provide an advanced user experience.

Extensively used ADO.NET to work with SQL Server database. Used Connection Command, Data Reader, Data Adapter, Data Set and Data Tables for disconnected mode of operation.

Used LINQ for building and executing a query expression.

Created a generic Web API client framework, which was used by UI team in sending the requests to Web API (GET/PUT/POST/DELETE).

Designed the application using HTML Helper and Razor Views in MVC architecture that promotes a clear separation between the different layers.

Designed and deployed various complex reports such as Tabular, Cross-tab, Pie Chart reports, Sub Reports, Drill down reports, and Drop down reports using MS Reporting Services.

Worked on Web API to create HTTP RESTFul services to communicate with UI objects using JSON.

Implemented Multi-Threading and Asynchronous WCF service calls to improve the performance of the application.

Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012 and Flat files using Business Intelligence Development Studio.

Involved in designing and implementing application using .net framework to call the reports from presentation layer.

Used Team Foundation Server (TFS) to manage, communicate documents for review and collaborate the work with team members.

Environment: .Net 4.5, Visual Studio.Net 2012, ASP.NET, C#, ADO.Net, Web Services, Web Forms, Web API, Team Foundation Server, SQL Server 2012, SSRS, SSIS.



Contact this candidate