Resume

Sign in

Sql Server Web Services

Location:
Gainesville, Georgia, United States
Posted:
January 02, 2018

Contact this candidate

Dinesh

Dot Net Developer

SYNOPSIS

Have * years of experience in Software Application Development, Testing and Implementation experience with Web based and N-tier Architecture involving all stages of Software Development Life Cycle (SDLC).

Experience in Development methodologies like Agile/Scrum, Iterative, and Waterfall models.

Strong technical expertise in using Entity Framework, ASP.NET, MVC, ADO.NET, WCF, Kendo UI, Angular JS, JQuery, JavaScript, AJAX, Razor views, WAS, IIS 4.0/5.0/6.0, Windows Workflow Foundation (WWF), Web Parts and Custom Controls.

Expertise knowledge on HTML5, XHTML, JavaScript, Bootstrap, VBScript, COM, DCOM, Classic ASP applications, XML, XSLT, CSS.

Experience in creating SPA (Single page Applications) based on client side Javascript framework Angular JS, 1.5, 2 employing MVC, MVVM and Web API.

Experience in working with KENDO UI using data grid, list views and creating all day event properties.

Has strong experience and understanding in .Net framework 3.5, 4.0, 4.5 features for designing and developing new application using WCF, NHibernate, GIT and WPF.

WCF was used as serialization and deserialization, source to query retrieve and Data development was done by using C# and dot net. Along with MVVM used Unity as DI container and used PRISM 5, .net 4.5 for WPF.

Working knowledge of Windows Presentation Foundation (WPF), which provides developers with a unified programming model for building rich windows smart client user experiences that incorporate UI, media and documents.

Experienced in .NET n-Tier and Distributed Architectures - Web Services, WCF Services, Web API Restful Services (CORS) to deliver the business agility.

Experience in building Web services using ASP.NET Web API and performing CRUD operations using REST API.

Expertise in implementing Object Oriented Analysis and Design (OOA & OOD) and Service Oriented Architecture (SOA) methodologies.

Extensive working experience in database design and development, for creating complex database queries, writing Constraints, Indexes, Views, Stored Procedures, Triggers and Functions using SQL Server 2012.

Experience in debugging web pages using Fiddler tool and SQL profiler for SQL queries process.

Expertise in LINQ, Lambda Expressions and Task Parallel Library (TPL).

Skilled in developing UML diagrams including use case, sequence, class, interaction, state and deployment diagrams using MS Visio and Rational Rose.

Experience in creating reports by customizing look and feel by using various reports models and pass the parameters according to the business user's request.

Experience in developing, developing reports by using Excel and Report Builder in MSSQL SSRS 2012/2008 R2/ 2012 R2.

Worked extensively with different ADO.NET objects to interact with database and good experience in using ADO.Net objects such as SQL Command Object, Data Reader, Dataset and Data Adapter.

Creating and managing Virtual machines in windows Azure and setting up communication using endpoints.

Good knowledge in Microsoft Azure Cloud services such as IaaS (Infrastructure as a Service), Saas (Software as a Service), Paas (Platform as a services), IOT’s, Visual Studio Online.

Developed extensive stored procedures, triggers, views, functions on SQL server.

Used validation control for both Custom validations and Java Script for Client-side validation.

Expertise in developing Web Forms, Win Forms, Web Services using Dot net Technology.

Worked on TFS for version control, Team build, Data collection and reporting.

Experience on version control systems Tortoise SVN, GitHub, TFS and VSS.

Performed Unit Testing and Integration Testing to meet business functionalities.

Excellent verbal and written communication and inter-personal skills.

TECHNICAL SKILLS

.NET Technologies

ASP.NET MVC, WPF, MVVM, VB.NET, ADO.NET, WCF - RIA, Restful, Web API.

Databases

MSSQLServer 2008 R2, 2012, ORACLE 11g, Windows Azure Cloud.

Frameworks

Entity Framework 3.5, 4, 5,6, Ninject, CSLA framework.

Hosting Services

Web Servers: WAS, IIS 5.0/IIS 6.0/IIS 7.0.

Languages:

C, C++, C#, VB, XAML, PL/SQL, T-SQL, HTML, DHTML, CSS, LINQ.

Scripting Languages

HTML 5, CSS, Java script, JQuery, Ajax, Kendo UI, Angular JS, 1.5, 2.

Design Patterns

MVC design Pattern, Generic Repository Pattern, Singleton, Façade.

Reporting Tools

Crystal Reports features, Reporting Services (SSRS), Active Reports

Other Tools

Fiddler, SQL profiler, ANTS Performance 5

Software Methodologies

Agile Unified Process, UML, Waterfall.

Version Control & Operating system

Team Foundation Server (TFS), Visual Source Safe (VSS), Tortoise SVN, GIT, Subversion, Windows 2008 R2, Windows XP, Windows NT, UNIX

Testing

Unit Testing, Integration Testing, Manual Testing.

PROFESSIONAL EXPERIENCE

Client: Travelers Insurance Duration: Sep 2017 to Present

Locations: Hartford

Role: Application Designer(.Net)

Responsibilities:

Interacting daily with offshore team, Solution Architect and Project Manager for updating the cloud migration status to migrate e-business into Iaas, Paas.

Working on e-business applications in finding out the 3rd party dependencies and attend the client meetings to verify the migration impact.

Finding out the ease of integration with external web services, and recommending the migration strategy with Rehost, Retains- Iaas, Paas, Legacy VM by depends on the application size.

Worked on Performance tuning on SQL server and test the ODBC using WEB State utility tool.

Analyzing the Application and created the Application profiling based on the Software, Technical, Testing and gaps analysis, Dependency stakeholder and sizing recommendations.

Worked on different e-business applications such as batch, console, Angular js, External Line of business applications.

Created a RESTful ASP.Net Web API Stateless Microservices and used Microservices libraries such as Microservices4Net.

Worked on VB.NET applications, MVC Applications, WEB services, API, Batch applications, Windows services applications and refactor the application design.

Used SOAP UI, Fiddler, for testing and debugging the web services.

Worked on SVN tortoise for source control and worked on Client Web state management utilities which stores the session data of the applications.

Performed Regression testing on different dot applications and request the DEVops team for deployment in DEV server through Jenkins and UCD.

Performed use case stories on Rally Kanban which goes request for DevOps team.

Performance Engineering has been done on the batch applications where these applications are releases .bat files for every week through Autosys.

Collaborating with different Clients owner of the applications for migrating the applications into PCF cloud and analyzing the business process flow with Architect.

Performed IIS Server tuning by creating Application pools. And performed Tracing the applications for checking the performance by configuring manually in web.config file.

Checking the Queues, cache, environment variables on DEV server and locating logging tools and configuration for updating those information in Application profiling.

Environment:

ASP.NET 4.5.2, IIS 7.5, Web State Utility, Angular JS, PCF cloud, DebugDiag, dot Trace, Performance tuning, Log4net, WEB API, Web services, WCF, Batch, VB.Net, Console, Windows applications.

Client: Pearson New Jersey Duration: Dec 2016 to August2017

Location: New Jersey

Role: Dot Net Developer

Description:

Pearson is based on educational platform, which is one of the leading educational and professional publishers around the globe. The rapid growth in usage of Tablets, Laptops and smart phones which transforms education to everyone virtually anytime and anywhere, this project focuses on e-learning web portal and application development.

Responsibilities:

Interacted with Business Users for gathering business requirements and involved in analyzing, documenting business requirements, functional requirements for developing Forms, Documents and Reports.

Used TFS for version controlling, branching and merging from Development Server to Stage and Stage to Production Severs.

Work extensively with cross functional teams in an Agile Scrum environment to achieve the tasks within the given sprint deadline.

Used ASP.Net framework for creating WEB API services according to meet the client application side Browser Application.

Implemented Enterprise level application architecture with WEB API using EF, Generic Repository Pattern.

Added all necessary packages in which performed dependency injections using Ninject MVC framework, Moq framework on web applications.

Resolved dependencies using IOC and Dependency Injections in ASP.NET Web API with Ninject and Managed Extensibility Framework.

Involved in requesting Logging and Exception handling in WEB API’s using Action filters, exception filters and Nlog framework.

Utilized Entity framework as a data access layer to SQL server for the REST full based ASP .NET WEB API web services.

Performed Generic Repository Pattern for flexible architecture and to centralize the data logic and web service logic

Used Auto Mapper extension for mapping data type objects and Model class to bind the view.

Worked on attributes on specific controller methods to enable/ disable the CORS cross origin resource sharing.

Used fiddler tool to test ASP.NET Web API token based authentication.

Involved in extending OData capabilities which enables RESTful services support in ASP.NET Web API’s.

Involved in creating front end Applications using Bootstrap, HTML, CSS3, Javascript and worked with SPA Single page applications using Angular Js and created nested loops using Angular 2 with Typescripts

Worked on Angular 2 for creating Templates and route configuration and to call some external web services.

Used Typescripts for routing configuration by integrating Angular 2 libraries.

Created Telerik Kendo UI scheduler with adding a template and experimenting with the all-day event property as per client requirement and involved in customizing the data event programmatically.

Performed Validation controls, Java script and JQuery Validation to validate form fields on client side. And worked on AJAX for remote Validations, updating page on partial side.

Performed Web API and MVC controllers in single project to handle heavy advanced AJAX requests to return the data JSON.

Using Stored Procedures created Web API services and called the service using Jquery Ajax.

Performed Basic Authentication by encrypting the headers values and convert them from base64 string for decryption the headers request parameters.

Created Responsive Web design for supporting Mobile Applications.

Created Pagination by splitting single page into multiple pages in ASP.Net MVC application.

Performed Security operations in ASP.Net MVC application by using attributes to the classes.

Created database, Tables, Inserting Demo Data, displaying data using Entity framework from database.

Used JSON to migrate from Oracle database to SQL database.

Applied Bootstraps to the layout for styling the content.

Consumed some external services WCF to write logs to the database and involved in generating proxy classes by the extension file provide by WCF.

Used TFS for writing User stories and followed Backlogs for pending tasks.

Designed and Implemented Data access layers using LINQ for XML Data.

Used Pivot queries when need to transform data from row-level to column data.

Generated T-SQL code by using Dynamic SQL and handling NULL in T-SQL.

Used Met-data code generation app for years to radically speed up development time dot net applications. It generates all stored procs, class entities, XAML forms, XAML Infragistics Data Grids, SQL Server TVPs, code snippets, etc.

Involved in database design and development, for creating complex database queries, writing Constraints, Indexes, Views, Stored Procedures, Triggers and Functions using SQL Server 2012.

Created and Executed Dynamic SQL on T-SQL.

Created Crystal reports in SQL server 2012 by using prior features.

Created Tables, Indexes, Views, Joins, Stored procedures using SQL server.

Involved in Unit testing, system testing, release management, writing test scripts and scenarios.

Environment:

.NET Framework 4.5, Entity Framework 5, ASP.NET MVC 5, WEB API, ODATA, Nlog, Generic Repository pattern, Auto Mapper, Visual Studio 2012, C#, Ninject Framework, Bootstrap, HTML, XML, XSLT, SQL Server 2012, Ajax, Bootstrap, Angular JS, 2, Crystal reports, T-SQL, Dynamic SQL, JQuery, MVC, SSRS, PL /SQL, TFS.

Client: Standard Register Duration: Dec 2015 to Nov 2016

Location: OHIO

Role: Dot Net Developer

Description:

Standard Register Company provides the Health care applications to the medical field. Generally, their applications based on unique combinations of software and services interacts with users to make health management easier.

Responsibilities:

Involved in a day-day Scrum Software development methodology and Test Driven Development TDD.

Extensively worked in Entity Data Model for implementing Business logic and Data Layer using Entity Framework 4.0

Developed Medical check order management where bio medical monitors are used in critical care applications where users can monitor for any changes.

Highly Involved in Creating Structure and UML Diagrams (Structure Diagrams, Logical Diagrams, and Use Case Diagrams) in assistance with Business Analyst.

Designed Graphical User Interface (GUI) for various web pages using, HTML5, CSS 3, JavaScript and JQuery.

Created Inbound and outbound WCF services / Web Services to integrate with Email client and support applications using C#.Net.

Used WCF services responsible for developing and deploying services on windows in line with service oriented architecture (SOA) and responsible for developing WCF SOAP.

Used WCF to expose business logic as services and defined service contracts, implemented service contracts etc.

Worked with MVC architecture application using ASPX/Razor view engine.

Worked on Angular JS for creating the templates on routing configurations by applying states.

Used Angular JS for calling the web services.

Used Data contract mechanism in Windows Communication foundation for serializing dot net object types into XML.

Worked on creating contracts and classes in WCF for different modules in the application.

Wrote Data Access Layer Methods, T-SQL Queries, Store Procedures, and SQL User Defined functions for fetching Transaction details, Customer Details, and Product Configuration data.

Heavily used LINQ to SQL to retrieve data about Customers & Transactions.

Developed DAL using LINQ Data context object with ADO.NET Entity Framework for LINQ, invoked DB tables and stored procedures and Implemented LINQ Lambda Expressions to query in memory expressions.

Used Microsoft Team Foundation Server for the purpose of version Control and source code maintenance needs.

Performed Intersystems cache by post-relational database for dot net application and dot binding.

Involved in using SQL DDL, for intersystem chache .

Developed Application layer using ASP. Net, Server controls, HTML Controls and Validation controls.

Developed Application using .NET Framework 4.5, Object Oriented Principles (OOP), and n-Tier Architecture.

Developed Application with Azure SDK and run those application in Windows Azure Emulator.

Run the application and debugged before deploying it to the public cloud and later deployed application to Windows Azure Cloud.

Design, develop, migrate servers, relational database and websites to Microsoft azure cloud.

Using Windows Services provided compute and storage platform based on SaaS.

Effectively created reusable controls and Master Pages and integrated them into ASP.NET web pages.

Used Microsoft Test Manager in Visual Studio for running Action Recorded Test Cases and Regression Tests.

Involved in Unit testing, Modular testing, Integration testing and successful integration of modules and multiple layers in the system.

Environment:

C#.Net, Object Oriented Methodologies, Visual Studio 2013, SQL Server 2012, ADO.NET, .NET Framework 4.5, HTML, CSS, jQuery, Bootstrap, Angular JS, Web Service, WCF, XAML, LINQ, IIS, MS VISIO(UML), N-UNIT, n-tier architecture, Agile Methodology, Windows Azure, SaaS,Team Foundation Server (TFS), Automation testing, MVC 4.0.

Next sphere Technologies Duration: Jan 2013 to July2015

Location: India

Role: Dot Net Developer

Responsibilities:

Developed ASP.NET website using C#, HTML, JavaScript, ASP.Net and ADO.Net

Involved in developing the Business Layer and Web User Custom Controls in C#.NET

Created Web and HTML Controls to develop web pages and user controls.

Worked on Web applications using Visual studio 2010, ASP.Net, AJAX, XML, CSS, Bootstrap and Object-oriented techniques.

Implemented SOA architecture and used design patterns such as Facade, Singleton.

Involved in creating customizing share point web parts using c sharp, ASP.NET for object model of web pages.

Extensively worked on SOA using WCF for client request and response.

Designed all necessary database connection classes

Extensively worked on ADO.NET to connect to the SQL database

Designed and develop all necessary Web Forms with .NET framework.

Designed and developed screens for User Interface & Interaction, also developed various Search Screens for different strategies

Developed triggers & stored procedures for automatic insertion & retrieval of Data

Used ADO.Net to access the data from back-end SQL Server database

Performed Unit and Tiered testing of the application.

Used GitHub for version control and to track check-ins and rollback code.

Developed user documentation and program maintenance documentation

Developed screens for user registration and authentication. Used ASP.NET validation controls for validating user data input

Environment: .NET Framework 3.5, ASP.NET 3.5, Visual Studio 2010, WCF, Bootstrap, Win forms, Web Services, SQL Server 2010, JavaScript, HTML, JQuery, CSS, XML, VSS 6.0.

Lobby note India pvt ltd. Duration: April 2011 to Dec 2012

Location: India

Role: Dot Net Developer

Responsibilities:

Created technical documentation at each stage of Software Development Life Cycle (SDLC)

Effectively used ASP.Net state management techniques to maintain state between pages.

Implemented Service Oriented Architecture (SOA)

Developed Applications of ASP.NET using Server controls, HTML Controls, Data Grid, Data List and Validation Controls

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

Designed and developed n-layered applications which constitute Presentation Layer, Business Logic Layer and Data Access Layer

Used CSLA framework for building the business rules validations and for roles in the application.

Analyzed the performance of the application by profiling the code using ANTS Performance Profiler 6 from Red Gate.

Used ANTS Memory Profiler 5 to analyze arbitrarily large number of memory snapshots and for Large Object heap fragmentation statistics.

Created VB Classes for uploading the Loan Documents to the FTP Server.

Generated reports for the Under Writers using Dev Express Reporting Tool and SQL Server Reporting Services (SSRS)

Environment:

.NET Framework 3.0, Visual Studio.NET 2010, VB.NET, ADO.NET, SOA, MVC, Web Services, Developer Express Controls Volume 1, CSLA, ANTS Memory Profiler 5, ANTS Performance Profiler 6, SQL Loader, SQL Server 2008, SSRS, Team Foundation Server, Windows 2008 R2 server.

EDUCATION

Bachelor’s in Jawaharlal Nehru Technology University.



Contact this candidate