Sql Server .Net

Jeevan

Mobile: 646-***-****

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

SUMMARY

Microsoft Certified Full Stack Professional offering proven knowledge in web-based information systems, customized applications with around 10 years of experience in the development and maintenance of n-tier web-based applications.

Highly skilled and experienced web developer in all phases of SDLC and different methodologies e.g. Agile, Waterfall and Spiral etc.

Experience in software development with Microsoft Technologies including good experience in C#.NET, ASP.NET, .NET 4.0 & 4.5, MVC 4.0 & 5.0, AngularJS, Angular2, WCF, Web API, LINQ, Entity framework, XML, AJAX, HTML5, REST API using MVC, Microsoft Azure (PaaS), PowerShell, JQuery, TFS, Sql Server, and Agile Development Process.

Exposure to software/tools, TFS, VSS, GitHub, SQL Profiler, Developer Tools, Fire bug, Visio, Fiddler.

Experience in PowerShell scripting, Identity Access Management and Shared Access Signature.

Experience in ADO.NET controls such as Grid View, Data List, Details View, Form View and Repeater.

Experience in dealing with Windows Azure IaaS - Virtual Networks, Virtual Machines, Cloud Services, Resource Groups, Express Route, Traffic Manager, VPN, Load Balancing, Application Gateways, Auto-Scaling.

Developed Single Page Application (SPA) with ASP.Net Web API 2 and Angular JS using Code First Approach in Entity Framework.

Experience of RDMS and Developed Constraints, Join, Views, and Triggers in SQL Server including Writing Views, Stored Procedures, Functions, Cursors and Triggers for search and accessing data from various databases

Assist with configuration of network infrastructure within Azure including, storage, load balancing, virtual machines.

Hands-on experience in Project Planning, Estimation using SCRUM Agile, Kanban methodology and Managing various projects in an onsite / offshore model.

Strong knowledge and experience

Proficiency in working on databases, creating SSIS packages using MS SQL Server 2005/ 2008

Strong experience in Object Oriented technology for software design and implementation

Implemented projects for variety of customers including major General Insurance, Logistics, Banking Finance, and Legal Information Systems.

Developed enterprise level ASP.NET applications using Design Patterns

Experience in Windows Azure Services like PaaS, IaaS, SaaS and worked on Azure PaaS storages like Blob (Page and Block), SQL Azure. Well experienced in deployment & configuration management and Virtualization

Good knowledge and working experience with App services (Web apps, API app, Logic apps, Mobile apps and Functions) in Azure

Wide range of Industry & domain exposure like Banking and Finance, Insurance, Telecom, Security (trading), Inventory Management, Supply chain management, Human Resource Payroll.

Extensive front end and backend development experience and working with .Net Framework […] using Visual Studio.NET […]

Very strong experience in Production support

Proven ability to analyze problems, root causes, and develops innovative solutions to business challenges and streamlining operations.

Experience in using Language-Integrated Query (LINQ) and retrieve data from different data sources (LINQ to Objects, LINQ to XML, and LINQ to SQL)

Expert in Implement deploy and configure Azure websites, configure diagnostics, monitoring and analytics on Azure Platform along with scale and resilience for Azure Web sites

Good in Manage hosting plans for Azure Infrastructure, implementing & deploying workloads on Azure virtual machines (VMs), Design and implement VM storage & good understanding on Implementing images/disks

Implemented .NET Security features such as Authentication & Authorization using Form-based and Window-based Authentication, Authorizing Users, Roles and User Account Impersonation.

Planning and organizational skills that balance work, team support and responsibilities in timely and professional manner & Ability to learn quickly and adapt to new technologies.

TECHNICAL SKILLS

Category

Technologies

Web Technologies

.NET 4.0, 4.5, Web API, WCF, MVC4.0 & 5.0, Microsoft Azure (PaaS), PowerShell

Cloud Platform

Windows Azure

Languages

C# (5.0,4.0, 3.0) .NET (4.5, 4.0,3.5, 3.0), CSOM

Client Script

Java Script, JQuery, AngularJS, Angular2, REST and Mustache.js

Source Control

TFS, VSS, GitHub, SVN

Databases

SQL Server 2012, 2008, 2005, Oracle

Reporting tools

SSIS, SSRS, BI

Tools

NUnit, Fx-Cop, LoadRunner, Fiddler, Postman

CERTIFICATIONS:

Agile Scrum Professional Scrum Master (PSM1)

EDUCATION:

Bachelor of Engineering (Information Technology) from Kakathiya University India.

PROFESSIONAL EXPERIENCE

MetLife - NewYork OCT 2016 – Till Date

Sr.Net developer

Project Description: MetLife Inc. is a leading global provider of insurance, annuities and employee benefit programs. Through its subsidiaries and affiliates, MetLife holds leading market positions in the United States, Japan, Latin America, Asia, Europe, the Middle East and Africa.

Role and Responsibilities:

Used Model View Controller (MVC) design pattern to develop a complex ASP.NET web application

with C# as code behind, AngularJS is used for client side validation.

Expertise in creating the Controllers and Controller Actions, Filters, Routing using ASP.NET MVC.

Created the Data access layer and Data access objects using ADO.NET Entity frame work and LINQ to reduce impedance mismatch.

Developed cloud and app services and hosted in PaaS.

Converted .Net application to Microsoft Azure Cloud Service Project as part of cloud deployment.

Worked on Azure storage.

Leveraged AngularJS for scripting, AJAX calls and JSON and XML for passing objects from Controller to View and vice versa.

Designed and developed Web API Restful services for clients with Microsoft Web API framework.

Worked extensively on the UI, created views by utilizing MVC 5, created view, models and wrote client side validations using jquery and AJAX tool kit.

Used ASP.NET MVC framework to support the use of Dependency Injection to inject objects into a class, instead of relying on the class to create the object itself.

Designed and developed abstract classes, interfaces, classes to construct the business logic using Object Oriented Concepts.

Worked on Azure data visualizations using Power BI

Integrated Azure-based Power BI to various data sources

Published MVC application in to windows Azure.

Troubleshooting Connectivity Issues in the Azure AppFabric Service Bus

Database designed as per business need, Worked with SQL Developer for writing complex stored procedures.

Used Angular JS framework with CSOM to create and bind custom web-parts.

Used Fiddler and Postman tools to verify WebAPI.

Participated and provided input on story requirements, design, estimation and test approach discussions.

Development was done using agile methodology

Environment: Windows Azure, MVC 5.0, C#, Entity Framework, Angular JS, JSON, Ajax, Web API, WCF, SQL Server 2012, SSIS, Fiddler

SUNRX, Pennsylvania Jan 2015 – Sep 2016

Sr.Net Developer

Project Description: SUNRx’s virtual inventory technology is a fully automated system that manages the flow of inventory, information and payments between community health organizations, pharmacies and wholesalers.

Role and Responsibilities:

Effectively involved in various stages of development of the project starting from the project planning until production and maintenance using agile methodology.

Designed, developed and trouble-shoot the application using advanced Microsoft technologies such as ASP.NET MVC with Entity Framework v6, JQuery, HTML5, XML, WCF and CSS3 using Agile development practices.

Used Web API to interact with data layer to access data from the database.

Worked on Microsoft Azure (Public) Cloud to provide IaaS support to client. Create Virtual Machines through Power Shell Script and Azure Portal.

Responsible for Configuring deployment slots, publish websites and web roles on to different deployment slots and swap between the production and staging slots

Responsible for deploying applications in Web apps using Visual studio and implemented continuous integration/deployment using Visual Studio Team Service

Developed a migration approach to move application from On-Premises to Windows Azure web app

Designed and configured Azure Virtual Networks (VNets), subnets, Azure network settings, DHCP address blocks, DNS settings, security policies and routing

Performed DNS configuration, deployments, and other operations

Performed migration of Microsoft SQL server to Azure SQL database

Responsible for managing live-site dev, staging, and prod Azure environments

Implemented Database objects like store procedure, views, function, Indexes, etc.

Asynchronous programming implemented using AJAX.

Used TFS for all the source code maintenance among the whole team members.

Delivered quality performance, team player and mentor others. Excellent analytical and debugging skills.

Environment: C# 5.0, Angular JS, Asp.MVC 5, Web API, Windows Azure, Query, Azure SQL database, SQL Server 2012, SSIS, JSON, Entity Framework, Fiddler, Net Framework 5.0, bootstrap, Batarang.

Inter-IKEA systems, Netherland Mar 2013 – Dec 2014

Sr. Net Developer

Project Description: This application contains the manuals, Films, Images etc. The inter-ikea users search for the required documents in the application and order for the manual or film. After ordering the order is processed and is delivered to the user after different steps.

Roles and Responsibilities:

Implemented application in Agile Methodology (Scrum) from requirement to deployment

Developed C#, data grids and XML to pull the data from the database and display it on the UI.

Adopted HTML, Ajax, CSS5 to selectively update the content in browser and to Develop module under MVC3 architecture.

Used Web Services to access data from the external Applications.

Used ASPX View Engine with MVC3 framework standards-based web applications using well-established design patterns and the power of ASP.NET and the .NET Framework

Developed different User controls which inputs the data and display the data for the web applications using ASP.NET and AJAX.

Involved in Analysis, Design and Development of new releases, features on public site using ASP.Net, JavaScript, and XSL, XML, SQL, and C #.

Used AngularJS for constructing clean, modular, reusable services, models, controllers, and templates, data-binding, and routing.

Involved in Web Services Testing using SoapUI 5.2.1

Responsible for designing Test Cases/Test Scripts/Test Conditions for the Unit Testing and • Integration Testing to verify and validate the web application.

Involved in backend testing, data validation and reports with complex SQL queries involved.

Used LINQ to SQL (object relational mapping) for integrating data validation and business logic rules into data model.

Developed data access layer that supports connections to multiple databases using Entity Framework.

Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.

Utilized TFS for the version control and source code maintenance need.

Created and updated database objects like Complex stored procedures, tables, User defined functions, Views, Triggers, cursors, indexes, Packages using SQL Server 2008.

Environment: .NET Framework 5.0, ASP.NET 3.0, C#, Visual Studio 2010, SQL Server 2008, AJAX, HTML, CSS, JQuery, JSON, Entity Framework, Fiddler

SnapFish Jan 2012 – Feb 2013

Sr. Net Developer

Project Description: SnapFish offers photo products and services for which ValueLabs is the only strategic partner. The services of SnapFish include online photo sharing, photo storage and management, online print ordering and wireless imaging services for camera phone and color handset users.

Role and Responsibilities:

Responsible for analyzing the requirements from the customer and designed the Screens as per the requirements.

Used Master Pages for consistent layout of pages in the application.

Used Multi-Tier Architecture to separate different layers like UI layer, Service layer and database layer.

Developed Rich User Interface using C#, ASP.NET Controls, JavaScript, JQuery, AJAX, HTML and CSS.

Used JavaScript for Client Side page validation scripting to avoid the need for Post Back and thereby improving the performance and responsiveness.

Used Rich server controls of ASP.NET such as data grid and repeater controls.

Performed Input validation using ASP .NET Input Validation Controls.

Developed Web Services and Implemented Customized Data Contracts and Fault Contracts for the WCF Service as per the need of the application.

Created Test Methods for testing the WCF service endpoints and Business Logic layer functions in Visual Studio.

Developed email confirmation/notification mechanism under the ASP.NET.

Used LINQ to SQL to connect to the SQL Server Database from the .NET applications.

Developed SQL Queries, Stores procedures, views and functions to perform database CRUD operations.

Involved in taking Backups, Restoring and Import/Export data using MS SQL Server and involved in following organization standards for code development, peer level code walk through and reviews.

Performed Unit Testing, Integration Testing and System Testing using NUnit.

Created business user and management Reports using SSRS.

Used SQL Profiler for debugging database queries.

Responsible for creating the deployment plan and Release Notes for the applications.

Environment: Visual Studio 2010, CSS, AJAX, JavaScript, C# .NET, SQL Server 2008, LINQ, HTML, XML, XSL, SSRS Reports, Web Services, TFS.

BekaertCorp, Bekaert Belgium Jan 2011 Dec2011

.Net developer/Production support

Project Description: BekaertCorp is a content management portal for internal communications of Bekaert employees. The BekaertCorp portal is integrated with SAP EP portal.

Roles and Responsibilities:

Analysis, Design and Development of modules using ASP. Net, C# under MVC architecture.

Developed web applications Involved in application enhancement in terms of Speed, improved security, Error Logging, Exception handling, Code Reuse with Object Oriented Design and deployment.

Used C#, data grids and XML to pull the data from the database and display it on the UI.

Used HTML, Ajax and CSS to selectively update the content in browser

Implemented client-side validations using JavaScript and JQuery.

Used ASP.NET AJAX Toolkit controls like Script Manager, Update Panel within some existing web pages.

Developed Service Layer using C# and Windows Communication Foundation (WCF).

Consumed Web services using WCF for online transactions using C# and exposed them through SOAP and HTTP.

Developed WCF services to save/get the data for portfolio screen using C#, LINQ

Used ADO.Net components such as Datasets, Data Reader, Data View and Data Table.

Developed SQL server data warehouse for reporting and created SSIS packages to move data from SQL Server and databases to the data warehouse.

Used Team Foundation Server (TFS) for Version Control and Source code repository.

Developed SSRS reports by using Business Intelligence Development Studio.

Prepared Database stored procedures, functions, and SQL queries using Oracle 10g.

Use of the NUnit framework to test the source code by putting assertions in the test classes' methods.

Environment: Visual Studio 2010, CSS, AJAX, JavaScript, C# .NET, SQL Server 2008, LINQ, HTML, XML, XSL, SSRS Reports, Web Services, TFS

KMPG, US Global Mar 2010– Dec 2010

Sr. Net Developer

Project Description: Kpmg is a custom content management portal for internal communications of us kpmg employees. The us portal is logically segregated into various applications like KPMG Policy Center, KPMG Today, Leadership, OTC on business functionality and implementation mechanisms.

Roles and Responsibilities:

Understanding the business requirements and preparing an analysis document.

Develop the Service Oriented Architecture (SOA) using WCF based on the requirement from user.

Involved writing queries and stored procedures to fetch the required data from database and display it in UI layer.

Used N-tier architecture for presentation layer, the Business and Data Access Layers and were coded using C#.

Responsible for designing master pages, creating user controls, writing server side programming and storing data in XML.

Database design as per new requirements for SQL Server 2008.

Developed Webforms using C# and ASP.NET.

Wrote triggers for sending Emails after to clients after any kind of transaction has been made.

Extensively used GridViews sorting and paging.

Implemented Template Columns for Custom Nested GridViews.

Responsible for application deployment through IIS.

Deployment of Application on Test and Production Server.

Handled many production issues and enhancement to the existing live portals.

Worked in Java script library for client side programming, AJAX using JQuery library,Entity framework to collection programming in business objects

WCF service developed for shared platforms enhancements.

Documented functional and technical design specifications for business scenarios involving complex business workflow.

Conduct code review as per coding standards.

Used TFS as source control.

Environment: ASP.NET2.0, C#.NET, ADO.NET, Microsoft Visual Stuidio.NET 2005, IIS 5.0, SQL,XML, XSL, HTML, SQL Server 2000 Enterprise Manager, SQL Server 2005 Query Analyzer, .NET Framework 2.0, and Windows 2003 server

WRDC, Hyderabad Jan 2008– Feb 2010

Software Engineer

Project Description: WRDC is a internet facing site which shows the basic information about WRDC company.

Roles and Responsibilities:

Server Administration: Monitoring, maintaining, and troubleshooting an operational and sustainable SharePoint and SQL Server environment.

Designed the web application in Microsoft Visual Studio 2005 using ASP.net web forms with various controls.

Responsible for developing the Logic using C#.NET

Extensively used ASP.NET 1.1, 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.

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

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

.

Environment: ASP.NET2.0, C#.NET, ADO.NET, Microsoft Visual Stuidio.NET 2005, IIS 5.0, SQL,XML, XSL, HTML, SQL Server 2000 Enterprise Manager, SQL Server 2005 Query Analyzer, .NET Framework 2.0, and Windows 2003 server

Contact this candidate