Sql Server .Net

Kumar

Sr. Dot Net Developer

Contact Details

Name: Shoban

Phone: 312-***-****

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

Professional Experience

* ***** ** ** ********** with exceptional skills in Analysis, Design and Development of high scalable Multi-tiered Web Applications, Distributed Applications and Web Services using Microsoft Technologies in Finance, Banking, Telecom and Healthcare domains.

Expertise in developing Web-based and Windows-based applications using C#, VB.NET, ASP.NET,AJAX, UML, JavaScript, VBScript, XML, CSS, SQL-Server 2008/2005/2000, Oracle 11g/10g/9i/8i and Visual Studio 2010/2008/2005/2003.

Experience in implementing the MVC 3.0/4.0/5.0 design pattern to standardize the application architecture.

Extensive working experiencewith different methodologies like Agile (Scrum), Test-driven development (TDD) and Waterfall methodologies.

Extensive experience in developing User Interfaces using Bootstrap 3.2, AngularJS, ASP.NET, AJAX, JQuery, XML, HTML5/DHTML, CSS, JavaScript, and JQuery .

Worked extensively on server controls and implemented various user controls using both C# and VB. NET.

Extensively worked ASP.NET MVC4 applications using Database Code First Approach in Entity Framework 4.3/5.0/6.0 and UI in Razor View Engine and client side framework AngularJS, Bootstrap and HTML 5.

Extensively workedon AngularJS framework in ASP pages to run as Offline Application in browser that avoid IIS dependency installation and configuration.

Extensive experience in design and development of MVC and Web Form applications.

Good Experience in MVC 4.0 framework to reduce the complexity and to get full control over the behavior of the application.

Experience in Implementation of client side validations using JQuery and ASP.NET MVCvalidation implemented at Controller level.

Strong knowledge of Object Oriented Analysis and Design (OOAD) concepts including inheritance, polymorphism, and abstraction.

Very Good Experience in creating and consuming web services and WCF SOAP\REST, WEB API services.

Expertise in Developing WCF Services that implement the Service-Oriented Architecture (SOA).

Experience in developing Web Applications using third party controls Infragistics and Telerik.

Experience in database design and implementing Administration and database objects like stored procedures, functions, triggers and constraints.

Extensive working experience in database design and development, for creating complex database queries, writing Constraints, Indexes, Views, Stored Procedures and Functions using T-SQL and PL/SQL in SQL Server 2000/2005/2008, Orac1le 8i/9i/10g.

Experience in developing Custom Reports and different types of Tabular, Matrix, Ad-hoc and distributed reports in multiple formats using Crystal Reports and SQL Server Reporting Services (SSRS).

Hands on experience using Source Code Control Systems like Microsoft Visual Source Safe and Microsoft Team Foundation Server.

Ability to prioritize tasks/Multitask and execute them to perfection and able to work in a high pressure environment and capable of working in a team and as an individual.

Excellent Interpersonal and Communication skills coupled with strong technical and problem solving capabilities.

Technical Skills:

Programming Languages: C++, C#.Net(4.5/4.0/3.5/3.0),VB.NET(10.0/9.0/8.0), HTML, T-Sql, PL/SQL

Web Technologies: ASP.NET 4.5/4.0/3.5/3.0/2.0, MVC 5.0/4.0/3.0, Ajax 3.0/2.0, Javascript, Jquery, AngularJS, VB Script, Bootstrap, XML, HTML5, CSS3.

UI Technologies: Winforms,WPF, MVVM

IDE Tools: Visual Studio 2013/2012/2010, DevExpress, Sql Server Management Studio,Expression Blend(4.0/3.0)

.Net Frameworks: .Net Framework 4.5/4.0/3.5/3.0/2.0

Database: SQL Server 2008/2005/2000(T-SQL), Oracle 11g/10g/9i/8i (PL/SQL), MS Access.

Reporting Services: Sql Server Reporting Services (SSRS 2008/2005), Crystal Reports.

Enterprise Servers: Microsoft IIS(7.0/6.0/5.0),Windows Server 2008/2003/NT

Version Control Tools: Visual SourceSafe(2005), SubVersion, Team Foundation Server(2010/2008).

Middleware: WCF, ADO.NET 4.0/3.5/3.0/2.0, MSMQ, Web Services,Web API,LINQ, LINQ to XML, LINQ to ENTITIES, Enterprise Library 5.0/4.0/3.1

PROFESSIONAL EXPERIENCE

Client:M&T Bank, Buffalo,NY Oct 2014 to Till date

Role: Sr.Net Developer

Responsibilities:

Involved in the Software Development Life Cycle (SDLC) for documentation, designing, development phase of the System.

Used Web API as an ideal platform in building Restful applications on .NET Framework.

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

Responsible for designing the ASP.NET application authentication using .NET Framework, Model View Controller MVC and IIS security model.

Implemented View Model patterns/ in creating and managing Views, Partial Views, View Models, Web APIs using ASP.NET MVC, Custom Error Pages.

Created AngularJS Controllers, Scope, Model, view, Services, Factory etc., which Isolate scopes perform operations in UI.

Implemented ORM FrameworkEntity Framework Code First Approach with Repository Pattern and its implementation over the Business and Presentation layers.

Implemented CRUD operations, performance tuning like disabling the Lazy loading and enabling Eager loading, compiles queries etc.. using LINQ to Entities.

Implemented Entity Framework Migrations to enforce the frequent changes in Conceputal layer changes to database.

Created and consumedASP.NET Web services and implemented REST full Web API/WCF services for service layer, created Action filters and Exception filters to implement REST API.

Developed Applications using VB.Net, .NET Framework 3.5, Object Oriented Principles and

n-tier architecture.

Enterprise n-tier software agent using Windows Communication Foundation (WCF) web service hosted on IIS.

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

Development of enterprise reports by pulling data from various sources and presenting in SQL Server Reporting Services (SSRS).

Responsible for maintaining versions of source code using Team Foundation Server.

Prepared WCF Service layer to handle client-service interaction. Involved package creation and deployment.

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

Designed and developed user interface for web application and intranet application using VisualStudio2010, ASP.NET, MVC, C # .NET, and AJAX, XML and CSS with object oriented programming techniques. Used various features of C# and C#.Net (e.g. reflections, generics, partial classes, LINQ etc.).

Leveraged WCF mechanisms like sessioning, Instance management, and concurrency to make our services more robust and scalable

Created the link servers to pull the data from different data sources and used them in the stored procedure which will be executing on the scheduled basis through SQL agent

Created automatically running stored procedures for day-end operation using SQL Server agent

Created new tables, wrote stored procedures for applications and some user defined functions

Responsible in developing Stored Procedures, Views, Indexes, Scripts for database transactions on SQL server 2012. Involved in Troubleshooting and Debugging of the application within Stipulated time.

Created automated Unit test plans and performed Unit testing modules according to the requirements and development standards with NUnit testing.

Environment:Visual Studio 2013/2012, C#, ASP.NET MVC 5.0/4.0, Entity Framwork 6.0/4.3, WCF, WEB API, TFS 2013, AngularJS, Microsoft Enterprise Library, IIS 7.0, HTML 5, DOM, DHTML, XHTML, Rest Web Services, LINQ to Entities, SQL Server 2008 R2.

Client: CernerKansas, MO. Sept 2013 – Sept 2014

Role: Sr.Net Developer

Responsibilities:

Developed cross browser compatible, customer facing online application based on N–Tier Architecture.

Dealt with Bootstrapto present the application in a visually appealing manner and to render customer information as users were adding details to their profile.

Implemented the DAL using the Entity Framework 6.0 Database-First paradigm and Wrote Linq to entity queries in the DAL layer to fetch the data.

Generated business objects in DAL layer to implement more functionality in Entities.

Used Interfaces, Delegates, Generics and Collections in the business logic layer.

Maintaining the version of the project in Team Foundation Server (TFS) by merging the module developed with latest version in TFS.

Designed and developed Services using WCF and also leveraged WCF security mechanism at transport level with windows authentication type for our intranet applications.

Implemented debugging and exception logging mechnasims modules for WCF services which will be used in Business to Business services to save time and cost.

Implemented various endpoints to establish communication with multiple transport protocols.

Involved in development of webservices and other required modules in vb.net

Implemented Layouts and partial view to maintain the consistent look and feel for Razor Web pages.

Implemented Controllers and Actionresults and Custom Action Filters and Routing Mechanisams.

Implemented Custom httphelpers and strong typed helpers in Views.

Providing Release Management and Build Automation with TFS 2013 Build Automation.

Responsible for Automated Staging Server Version Deployment to Production.

Writing Stored Procedures and User Defined Scalar Functions (UDFs) to be used in the SSIS packages SQL Scripts.

Creating – Tables, Indexes, Views, User defined functions, Triggers, Parameterized Stored Procedures, Constraints and Roles.

Developed procedures and functions for business &data transactions with Error Handling.

Used Re-Sharper and Style Cop for code enhancement.Designed and coded application components in an Agile environment.

Environment: .NET Framwork 4.0, Visual Studio 2012, ASP.NET 4.0, C# 4.5, HTML, CSS, WCF, SOAP UI, XML, LINQ, SQL Server 2008, SSRS, ORACLE11G, PL/SQL and TFS.

Client: Amtrak, Washington, DC Oct 2012 – Aug 2013

Role: Sr.Net Developer

Responsibilities:

Created Dashboards for Organization, Guide, Contract Monitor, Finance and Manager roles.

Designed Master Pages by using Visual Studio .NET 2010 and Creating Style Sheets for formatting the Webpages based on the business requirements and functional requirements document.

Created web user interface using ASP.NET for the users to generate reports.

Designed and developed user interface modules using HTML 5, CSS 3 and JavaScript.

Created Master Page features for consistent layout of pages in the application.

Created Entity Framework Database First Modelfor ASP.NETapplication used LINQ to Entities and Lambda Expressions for the data access layer.

Worked on ASP.NET State Management Techniques like View State, Sessions, Caching (Output Caching).

Designed and developed user interface for web application and intranet application using VisualStudio2010, ASP.NET, MVC, C # .NET, and AJAX, XML and CSS with object oriented programming techniques. Used various features of C# and C#.Net (e.g. reflections, generics, partial classes, LINQ etc.).

Implemented Authentication and Authorization using Web.Config file. Configured for users Authorization and role based security.

Used XML for Data Storage and XSLT to transform the SQL queries returned as XML nodes.

Used the ASP.NET built in Membership provider to manage user accounts and user roles.

Created Stored Procedures in SQL Server that gets the data for the given input values and tuned queries in frequently used Stored Procedures.

Designed and developed Crystal Reports based on Design Specification and the Prototype.

Used controls like Group, Cross-Tab, Picture, Pie Charts and Bar Charts in Crystal Reports.

Created sub-reports inside the main report and changed the sub-report links so that the sub-report also gets the same parameters that of main report.

Used Crystal Reports as a reporting tool for developing reports.

Created Indexes, Views and Stored Procedures for quick and efficient retrieval of data using SQL Server 2012.

Developed Web Services using Windows Communication Foundation (WCF) for integration with other systems

Created and consumed services using WCF, C# to generate and e-mail those reports to the requested user

Used Team Foundation Server (TFS) to maintain the version control history during development.

Conducts comprehensive testing of developed objects in development and QA environments, including regression testing before any changes are released to the Production environment to minimize bugs.

Created SSIS packages for importing data from various data files/excel to the data source Utilized Trace and Debug flags within the web application in the development and test environments of the application.

Environment:.NET Framework 3.5/4.0, Visual Studio 2008/2010, ASP.NET 3.5/4.0, C#, HTML, CSS, JavaScript, WCF, XML, XSD, XSLT, PL/SQL TOAD For Oracle 10g, Crystal Reports, VSS and Infragistics Controls.

Client: GILEAD Sciences, Foster City, CA Oct 2011 – Sept 2012

Role: .Net Developer

Responsibilities:

Involved in communicating with the clients, gathering requirements for the development of preprocessing logic of Loan Origination module, Routing and Escalation Logic and other web and business tier components.

Involved in creating and consuming XML Web Services for processing Orders.

Designed and developed the user interface for various tools and implemented VB.NET validation controls, JavaScript, jQuery, CSS for server and client side validations respectively.

Involved in production support of various applications developed in VB.NET and C#.

Extensively used the ASP.NET Ajax Controls like Script Manager, Update Panels and Updated Triggers to make the page more responsive and interactive to the users.

Implemented Data Access layer, Caching Application block, Application validation, Exception handling and logging components using Microsoft Enterprise Library 4.1 Application Blocks.

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

Developed Reusable Classes using VB.NET.

Extensively used WCF services, thereby achieving complete Service Oriented Architecture.

Worked with data migration. Used tools like SQL Server integration services (SSIS) in transferring data from one database to another.

Extensively worked with Global asax to monitor and trigger application level events.

Created Database objects like Tables, Stored Procedures and Triggers in SQL Server 2008.

Used ADO.NET objects such as Data Reader, Data Adapter and Data Set to object data source fetch and handle user data.

Responsible for maintaining versions of source code using Team Foundation Server.

Environment:Visual Studio 2010/2008, .NET Framework 3.5/4.0, ASP.NET 3.5/4.0, ADO.NET, VB.NET, AJAX, XML, Infragistics Controls, SOAP, SQL Server 2008, JavaScript, LINQ, JQuery, WCF, SSRS, SSIS, And Team Foundation Server(TFS)

Client: HSBC - Pune, India April 2009 – Aug 2011

Role: .Net Programmer

Responsibilities:

Involved in Analysis, Design, Coding, and Testing and maintenance phase of modules of software life cycle.

Designed and developed complete front-end application using VB.NET Web Forms.

Developed the components for middle tier (Business Layer) using VB.NET.

Designed web forms by implementing CSS, HTML and JavaScript.

Created User Controls for the header and footer of the website which appears in all the pages.

Worked extensively on web forms and data binding controls like data list and drop down boxes. Used pagination and sorting features of data grid in reports.

Designed and developed stored procedures and User defined functions SQL Server Database. Implemented role based security and customizable workflows based on a user's role.

Created queries and stored procedures in the SQL Server Database

Implemented validation using ASP.NET validation controls.

Extensively worked on ADO.NET objects.

Environment:ASP.NET 2.0, ADO.NET, C#, VB.NET 2005, .NET Framewrok 2.0, XML, MS SQL Server 2000, SQL, IIS6.0, WINDOWS 2000, SSRS 2005.

Intranz solutions, Hyderabad, India June 2007-Mar 2009

Role: Web Developer

Responsibilities:

Gained valuable experience working with ASP.NET and C#, developed application logic in C#.

Gained knowledge about all aspects of the software product life cycle from inception to delivery of product. Tasks included: user needs assessment, user interface design, ASP development, JavaScript development, database design, SQL Server, Code Reviews testing, user support &ongoing code maintenance.

Involved in migrating the application from Asp to Asp.net.

Developed many Web Forms using C# and ASP.NET and used AJAX in some forms.

Gained experience working in a team based environment.

Used Grid Views to display data and formatted using Sorting and Paging.

Gained knowledge about Web Services for user authentication.

Environment: C#.Net, ASP.Net, JavaScript, SQL Server 2005, HTML, CSS, Web services.

Contact this candidate