Sql Server Software Developer

Summary:

Full Stack .Net Developer with *+ years of experience in designing, developing and implementing .Net applications.

Solid understanding of Object Oriented Analysis and Design (OOD), UML and RDBMS concepts.

Experience in using and implementing Design patterns like Abstract factory, Singleton, Object pool a standard solution to common problems in software design.

Experienced in all phases of software development life cycle (SDLC) – Feasibility study, Project Analysis, Requirements, Design, Development, Testing, Documentation, UAT, Deployment and support.

Experienced in working with Iterative Agile Programming Methodologies, Waterfall methodologies, Scrum and Test-driven development (TDD).

Demonstrated proficiency in development using Microsoft.NET technologies like WCF ASP.Net 4.0/3.5, ASP.NET MVC 5.0/4.0, C#(4.0/3.5)AJAX Extensions, jQuery with MS SQL Server (SQL 2008 R2/2012 ) as database.

Experience in web UI technologies using HTML, jQuery, JavaScript, Angular Js as well as XML, XSL, JSON.

Developed components in ASP.NET using ADO.NET providing functionality of the Data Layer and give access to the database for Inserting, Updating, Deleting and getting the information from the database through Business layer.

Responsible for UI developments and custom views using MVC Razor and ASCX, HTML, HTML5, jQuery, JSON, XAML and CSS which interacts with Business layer objects and contents from external source.

Developed, unit tested various web forms, Custom controls, Controllers in C# and ASP.Net.

Familiar with new C# 2.0/3.0/4.0 features such as Generics, Iterators. Anonymous methods, Partial classes, Named arguments and optional arguments, Extension methods.

Experienced with WCF, Web Services, Web API and .NET Remoting using TCP/IP and Multithreaded programming.

Experience with ASP.NET and its components: AJAX, Entity Framework, Language-Integrated Query (LINQ) query and retrieve data from different data sources (LINQ to SQL), ASP.NET Providers and Typed Datasets.

Experienced in Service Oriented Architecture [SOA] using WCF.

Experience in creating Single Page Web Application using Angular JS.

Worked extensively with ADO.NET objects such as Data Adapter, Dataset, and Data Reader to interact with databases like SQL Server 2008 /2005/2000.

Exposure to Angular 2,4 & Type Script Concepts using Visual Code.

Exposure to VB.net and Visual Script.

Experience in database related work primarily creating complex stored procedure, Views, Triggers, Functions, using PL/SQL, T-SQL.

Experienced in Configuration Management, setting up company Version policies, build schedule using Team Foundation Server (TFS) 2010/2008 and Visual Source Safe (VSS), Rally, Jira.

Hands on experience in Unit testing, Integration testing, Load Testing & Functional testing.

Technical Skills:

Programming Language

C, C++, C#,VB.Net, T-SQL, PL/SQL

Technologies

ASP.Net, LINQ, ASP.Net MVC, WCF, WPF

Web Technologies

HTML, HTML5, CSS, WCF, WPF, Bootstrap, JavaScript, jQuery, AngularJS, AJAX, Web Services, Asp.Net Web API,SSRS,SSIS, Soap and Restful API

XML Technologies

XML, XSLT, XAML

Database

SQL Server 2000/2005/2008/2012/2014

Web Services Message Formats

XML, JSON

Tools

Crystal Reports, Microsoft-Office, Microsoft Visio, Sql Server Reporting Services (SSRS 2005/2008).

Source Control

Version Control System(VCS), Team Foundation Server,GIT

Web Server

IIS, Apache,Node Server.

Operating Systems

Windows 2000/XP/7/8, MS DOS, UNIX GUI

Development Tools

Microsoft Visual Studio .NET 2005/2008/2010/2012/2013/2015/2017

WORK EXPERIENCE:

IntraEdge Inc. Jun 2017- Present

Location: Chandler

Project name: Underwriting Guidelines

Client: Argo Group

Location: Chandler

Software Developer

Interface with management, business analysts, project managers, IT Architects and other developers, along with internal customers, to understand requirements and develop needs according to business requirements

Performed testing of various types including Test Driven Development, unit, system, integration, and non-functional testing.

Participated in promotion of software releases across all environments and change management.

Supported production issues on call.

Worked with a team to create detailed project specifications, requirements and estimates.

Ensure tasks and projects are completed on time and within scope.

Worked with production operations department to ensure deployments roll out smoothly and customers receive appropriate support.

Researched and implemented new technologies to enhance current processes, security and performance document software designs.

Support and development of multiple web-based .NET applications, and web services.

Application development using ASP.NET 4.5, C#.NET, MVC, SQL Server.

Exclusively used JQuery1.10.1 to dynamically insert html snippets into web page based on user authentication.

Developing responsive, mobile first applications using JQuery.

Binding the data on UI.

Lead and participated in code reviews.

Wrote Stored Procedures, Functions and Triggers as per the requirements.

Work closely with software architects to ensure decisions meet long-term enterprise needs.

Analyze system requirements, design, and document solutions using rally and Agile methodologies.

Working in the Agile/Scrum development environment with frequently changing requirements and actively participated in scrum meetings and reviews.

Designed the front-end applications, user interactive (UI) web pages using web technologies like Hybrid HTML5, XHTML, and CSS.

REST - the standard HTTP request and response mechanism, simplifying implementation and providing for a looser coupling of the client and server.

Involved in deploying the application on the IIS server.

Environment: Visual Studio, C#,Angular JS, JSON, XML, IIS, JavaScript, JQuery, CSS, HTML, Git Hub, Bit Bucket, REST API, Trello, ASP .Net Web API, C#, Sql Server, T-SQL

IntraEdge Inc. March 2016- Jun2017

Project name: DOTC FA UBL

Client: American Airlines

Software Developer

Interface with management, business analysts, project managers, IT Architects and other developers, along with internal customers, to understand requirements and develop needs according to business requirements

Performed testing of various types including Test Driven Development, unit, system, integration, and non-functional testing.

Participated in promotion of software releases across all environments and change management.

Supported production issues on call.

Lead and mentor Junior/Intern developers.

Worked with a team to create detailed project specifications, requirements and estimates.

Ensure tasks and projects are completed on time and within scope.

Worked with production operations department to ensure deployments roll out smoothly and customers receive appropriate support.

Researched and implemented new technologies to enhance current processes, security and performance document software designs.

Developed and enforce policy and procedural changes within the development group.

Developed coding standards and adhere to best practices and security guidelines.

Support and development of multiple web-based .NET applications, and web services.

Support and development for creating Web Pages using Angular JS.

Support and development of dynamic module loader using Angular Bootstrap and SystemJS.

Used Typescript as a programming language for having object-oriented class based feature for JavaScript.

Exclusively used JQuery1.10.1 to dynamically insert html snippets into web page based on user authentication.

Developing responsive, mobile first applications on the web using AngularJS single page application.

Developed Custom directives to be reused across different modules in the application.

Support and development of angular material as UI Component framework to reuse UI components across application.

Participated in TFS (Team Foundation Service) as change management tool and for code repository.

Lead and participate in code reviews.

Work closely with software architects to ensure decisions meet long-term enterprise needs.

Wrote Stored Procedures, Functions and Triggers as per the requirements.

Analyze system requirements, design, and document solutions using rally and Agile methodologies.

Developed the UI layout and front-end programming (HTML) for web application that matched requirements.

Working in the Agile/Scrum development environment with frequently changing requirements and actively participated in scrum meetings and reviews.

Bootstrap used along with AngularJS in creating the Application.

Designed the front-end applications, user interactive (UI) web pages using web technologies like Hybrid HTML5, XHTML, and CSS, less files.

REST - the standard HTTP request and response mechanism, simplifying implementation and providing for a looser coupling of the client and server.

Involved in deploying the application on the IIS server.

Environment: Visual Studio, C#, XML, IIS, JavaScript, JQuery, CSS, HTML, TFS, Angular JS, REST API, RALLY, ASP .Net Web API, C#, Sql Server 2014, T/Sql

Sierra Consulting July 2015- Aug 2015

Software Developer

Responsibilities:

Developed the application Framework in ASP.NET primarily using C#.NET with the business logic implemented using .Net Assemblies

Extensively used C#.NET to develop server side event handling and components to handle business process.

Migration of the Web Application to Cloud, Amazon Web Service (AWS).

Created Data Tables and Applied the Web Service Enhancements to the Web Service so that the reliability increases.

Created Data Tables and have written Stored Procedures for all the Transactions in and out of the Database using SQL server 2008.

Created a Data Layer object in C# language which gives the common classes of methods to execute stored procedures into a Data Set, Data Table and Data Reader.

Used Jenkins for deploying the project.

Environment: Visual Studio, ASP.NET, ADO.NET, C#, XML, IIS, JavaScript, SQL Server 2012, CSS, Master Pages, VSS, MSSQL Server, AWS, Cloud Formation Script, Chef Script

Bridge Oceans, Pune, India Oct 2011 - July 2014

Software Developer

Responsibilities:

Involved in the complete Software Development Life Cycle including Analysis, Design, Implementation, Testing and Maintenance.

Build up a website for restaurant that includes multi restaurants which includes features for connecting several famous food chains in the cities allows user to online order food of their choice.

Developed the application Framework in ASP.NET primarily using C#.NET with the business logic implemented using .Net Assemblies

Used ASP.Net MVC building a WebApp for Student Exam Preparations.

Responsible for maintaining and supporting websites using full stack development.

Involved in application enhancements and new feature implementation and deployment.

Responsible for Improving application performance/responsiveness, security, Error Logging and Exception handling.

Enhancing the old applications while developing new Applications.

Support Production calls, and fixed the defect as earliest as possible.

Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.

Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.

Prepared the complete data mapping for all the migrated jobs using SSIS.

Researched and implemented new technologies to enhance current processes, security and performance document software designs.

Developed and enforce policy and procedural changes within the development group.

Developed coding standards and adhere to best practices and security guidelines.

Written Stored Procedures in SQL Server 2008,2010,2012 used EDMX as conceptual Model and LINQ to Entities to bind the data to Grid View, Data List,Details view, Repeaters, Dataset Classes for data manipulation.

Designed Graphical User Interface (GUI) using Master Pages, HTML, JavaScript and CSS classes

UsedJQuery and AJAX to make the User Interface more responsive.

Responsible for designing and developing the database objects like Tables, Views, and Complex T-SQL Store Procedures involving Joins

and using Temporary Tables, UDF (User Defined Functions).

Implemented CRUD functionality with Entity framework (ORM) in ASP.NET MVC and implemented sorting, filtering and paging with Entity framework in MVC.

Developed WCF Soap Service and consumed on front end using jQuery.

Retrieving the data using LINQ.

Environment: ASP.NET, C#, ADO.NET, XML, Web Services & WCF,WPF, HTML, jQuery, CSS, SQL Server2008,2010 IIS 6.0, Windows XP, VSS, NUnit, Visual Studio 2008,2010 & 2012, SSRS,SSIS.

L&T Technology Services Limited Formerly known as June 2010 - Sep 2011

Larsen n Toubro IES, Mumbai, India

Software Developer

Responsibilities: -

Involved in requirements gathering and requirements analysis, created various analysis phase artifacts such as Use Cases, and Wireframes. Participated in the architecture of the entire application.

Developed Web pages using ASP.NET, HTML, CSS, and JavaScript.

Design and Developed several reusable controls such as header, footer, and address controls using ASP.NET.

Business objects using C# resolved many critical issues for the customer at earliest.

Developed data access components using C# and ADO.NET.

Passed Training in C, C++ and RTOS.

Performed Testing on the existing applications, and thus enhancing them.

EDUCATION:

Marist College, Poughkeepsie, NY Aug 2014 – Dec 2015

Master of Information Systems Management

IIIT, Bangalore, India July 2009 - July 2010

Post Graduate Diploma in Software Development

I.E.T, Bundelkhand University, Jhansi, India July 2005 – July 2009

Bachelor of Technology, Computer Science

Certificates

C, C++ and RTOS (Larsen n Toubro Integrated Engineering Services)

Contact this candidate