Resume

Sign in

Sql Server .Net

Location:
New York, New York, United States
Posted:
January 30, 2018

Contact this candidate

Resume:

Nagaraj

732-***-****

ac39bt@r.postjobfree.com

PROFESSIONAL SUMMARY:

Over 8 years of Professional experience in all phases of software development life cycle (SDLC) especially in Design, Development, Testing and Deploying of applications.

Experience in Requirement Analysis, Design, Conceptual Design, and Developing Process Flow diagrams, Use Case diagrams, Data Flow diagrams, Development and Testing of business modules.

Experience in Waterfall, Agile and Scrum Development Methodologies.

Experience in Software Development Life Cycle (SDLC), Testing and Implementation using C#, VB.Net, .NET Framework, .NET Serviced Components, .NET Web Services, SQL Server 2012/2008 and Oracle 10g/9i with N-tier & MVC development environments.

Worked extensively with .NET Framework 4.5/4.0/3.5/3.0 and Visual Studio 2015/2013/2012/2008.

Created Web applications using MVC design pattern and Rendered HTML using MVC 5.0.

Extensively used HTML, DHTML, JavaScript, jQuery, VBScript, COM, DCOM, XML, XSLT, CSS.

Experience in creating Web Forms, User Controls, Custom controls, Views, Partial Views, .Net Web Services and SOAP.

Experience in report generation using AJAX Extensions, AJAX Toolkit, Debugging and Exception handling.

Expertise in server-side programming, creating and using Tables, Database schemas, Writing Complex Queries, Stored Procedures, Functions, Triggers, Cursors, and Indexes.

Experience in work with Language Integrated Query (LINQ) in relational databases and enumerable classes.

Translated complicated enterprise specific Business rules and Procedures into appropriate Business logic components such as Stored Procedures, Triggers and Security Models.

Good Cognizance in Database PL-SQL, SQL Queries and strong working knowledge of VB 6.0.

Extensively used AJAX to interact with .NET Web Services asynchronously in ASP.NET (2.0) applications.

Good experience in database programming using ADO.NET objects such as SQL / OLEDB connection, Command, Data Reader, Dataset and Data Adapter.

Designed and Developed Webpages with ADO.Net & Entity Framework for data loading and processing with SQL Server 2014/2012/2008 as backend.

Competitive in writing Stored Procedure, Views, Triggers and Cursors using T-SQL for the SQL Server, DB2 databases in the backend.

Experience in Creating Reports using SQL Server Reporting Services (SSRS), SSIS, and Crystal Reports.

Good Knowledge in Microsoft Azure Cloud Computing development, web roles and Azure SQL Server.

Knowledge on Microsoft Azure Cloud Services (PaaS & IaaS), Application Insights, Document DB, Azure Monitoring, Key Vault, Visual Studio Online (VSO) and SQL Azure.

Performed NUnit Testing for the piecewise testing of the Applications.

Experience in using Source Code Control Systems like TFS, GIT and SVN.

Excellent Oral, written, communication skills, interpersonal and time management skills.

TECHNICAL SKILLS:

Programming Languages

C#, VB (9.0/8.0/7.0), C, C++

.NET Technologies

.NET Framework (4.5/4.0/3.5/3.0), ASP.NET (4.6/4.5/4.0/3.5/3.0), ASP.NET MVC, ADO.NET, Win Forms, Web controls, Custom Controls, User Controls, Web Services, WCF, WPF.

Databases

SQL Server 2014/2012/2010/2008, MySQL, PLSQL, Oracle 10g/9i., SSIS, SSRS and Crystal Reports

Internet Programming

HTML5, DHTML, JavaScript, jQuery, XML, CSS, DOM, BOM, XSL, XSLT, COM, WSDL, SOAP.

Operating Systems

WIN XP/VISTA/7, Windows 9x/NT/2000/2003.

Development Tools

MS Visual Studio 2015/2013/2012/2010/2008.

Web Server

Microsoft Internet Information Services (IIS)

Work EXPERIENCE:

JP Morgan Chase – NYC, NY July 2016 – Present

Role: Sr. .Net Application Developer

Responsibilities:

Implemented the project according to the Software Development Life Cycle (SDLC) and programming by using fast paced agile methodology, involving task completion, user stories, and iterations.

Implement agile scrum methodology in application development.

Implementation of client-side validations using ASP.NET 4.6 MVC Validation implemented at Controller level.

Worked on design and development of SOA application, Data Access Components, business components and UI components using MVC.Net, JavaScript, jQuery, HTML and CSS3.

Created Business Logic Layer & Data Access Layers to implement the MVC architecture.

Implemented Get, Post by using Controller actions and Caching by using Action Filters and Child actions in Controller and return Razor HTML to View through Action Results.

Implemented AJAX features to reduce full post back, for improving the efficiency and interactivity across web applications.

created and modified Existing tables, views, triggers and sequences to suit the application requirements and developed data access layer using Entity framework.

Worked with both SQL Server 2014 and Oracle 11g as part of various applications.

Created and maintained database objects like complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins.

Written Queries using T-SQL Statements, Views, User Defined Functions, Stored Procedures, Triggers in SQL Server 2008 for inserting/Updating/Deleting the data into the relational tables.

Developed stored procedures for application use.

Developed RESTFUL/WCF Web services and other back end components.

Logging framework Log4.Net is used for log messages. Implemented log4.Net for application logging and to troubleshoot issues in debug mode.

Created custom directives, decorators, and services using AngularJS to interface with REST services.

Implemented AngularJS as the development framework to build a Single-Page Application.

Worked on triggers and cursors to manipulate data in backend development.

Involved in code review, bug tracking and fixing and Integration testing.

Created test plans and performed unit and regression testing on the application.

Environment:

C#.Net, .NET Framework 4.5, ASP.NET 4.6, Entity Framework, SQL Server 2014, MVC 5.0, Web API, LINQ, SSIS, IIS, Telerik, XML, Visual Studio 2015, WCF, HTML, CSS3, AJAX, Angular2, JavaScript, TFS 2010, TDD, GIT, Jenkins.

ATOS, Orange County, CA Jan 2016 – June 2016

Role: .Net Application Developer

Responsibilities:

Involved in Requirements gathering, Conceptual Design, Analysis, and Detail design, Development and System Testing.

Participated in regular client meetings and communicated with clients for knowledge transfer.

Implement agile scrum methodology in application development.

Implementation of client-side validations using ASP.NET MVC Validation implemented at Controller level.

Used JavaScript, AngularJS and AJAX technologies for front end user input validations and Restful web service calls.

Created and Consumed WCF Web Services& RIA Services.

Responsible for the designing common services to achieve SOA objectives of reusing services and reduce size of codes for faster processing and memory management.

Handled ASP.NET features such as Exception Handling, and Custom Error Messages.

Involved in retrieving data using LINQ to SQL and LINQ to Objects with ASP.NET, worked with the database using LINQ to SQL.

Implemented Single Page Design and customized directive and filter criteria by using AngularJS.

Developed SPM application using WPF, XAML, Prism, MVVM pattern and used dependency Injection Container

Used Windows Presentation Foundation (WPF) for developing desktop applications.

Handled Run Time Errors & Design Time Errors by implementing appropriate Error handlers in C#.Net.

Created Stored Procedures to perform automated rules, updating to related tables using SQL Server 2012.

Written Stored Procedures in SQL Server 2008 and used ADO .NET with Grid View, Data List, and Details view, Repeaters, Dataset Classes for data manipulation.

Created Windows Forms application, CS Data Validation Tool to query the Collection server database to find out the missing or corrupt data by comparing the oracle database values.

Used Entity Framework for the use of LINQ based data access.

Participated in collaborative team environment with Team Foundation Server to create pages and created custom eDiscovery operations reports with Crystal Report XIII

Developed stored procedures using T-SQL for implementing business logic and worked on Oracle performance tuning.

Created test plans and performed unit, integration and regression testing on the application.

Environment: VB.Net, .NET Framework 4.0, MVC 4.0, ASP.NET 4.0, Entity Framework 6.0, ADO .NET, SQL SERVER 2012, XML, T-SQL, IIS, Visio, Visual Studio, Python, TFS 2013, WCF, WPF, CSS3, HTML, JavaScript, jQuery, AngularJS, SSIS, SSRS Reports, GIT, Jenkins, JIRA.

Barclays, Wilmington, DE Mar 2014 – Dec 2015

Role: .NET Developer

Responsibilities:

Developed a 3-Tier Application and designed the Data Access Layer, and Business Logic Layer using C#, VB.NET, ASP.NET, MVC and ADO.NET.

Experienced in employing Object-Oriented Programming (OOP) concepts such as: encapsulation, inheritance, polymorphism and abstraction.

Implement agile scrum methodology in application development.

Utilized ADO.NET technology extensively for data retrieving, querying, storage and manipulation using LINQ.

Implemented web application using .NET Web services 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.

Worked on design and development of SOA application, Data Access Components, business components and UI components using MVC.Net, JavaScript, jQuery, HTML and CSS.

Developed Windows Forms (Win Forms) based upon the client request and Implemented graphical user interface (GUI) for web forms.

Implemented MVC Architecture on client side and creating Models, Controllers, and Views Scope etc. Using Angular JS, Coded frontend interface with Angular JS, CSS and HTML5.

Used Angular JS framework to implement Single Page Application and Created HTML pages using Angular JS directives for driver and vehicle modules.

Used Windows Presentation Foundation (WPF) for developing desktop applications

Handling Front end and back end using ASP.Net, JavaScript, XAML, C#, VB.Net Windows Services.

Created and maintained database objects like complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins.

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

Designed, modeled and architected multi-threaded, enterprise n-tier software agent using Windows Communication Foundation (WCF) web service hosted in a Windows service.

Written Stored Procedures in SQL Server 2008 and used ADO .NET with Grid View, Data List, and Details view, Repeaters, Dataset Classes for data manipulation.

Written Queries using T-SQL Statements, Views, User Defined Functions, Stored Procedures, Triggers in SQL Server 2008 for inserting/Updating/Deleting the data into the relational tables.

Created user level security in reports to allow restricted viewing to users of different levels and implemented data driven subscriptions using SSRS.

Created test plans and performed unit, integration and regression testing on the application.

Environment: Visual Studio 2008, VB.Net, C#.Net, .Net Framework 3.5, ASP.NET MVC, ADO.NET, SOA, Entity Framework, Win Forms, WCF, WPF, JavaScript, jQuery, AngularJS, Windows Server 2008, SQL Server 2008, PL/SQL, IIS 6.0, SSRS, GIT, Jenkins, Jira, python, HTML, AJAX Toolkit, CSS.

Client: VISA, Denver, CO Aug 2012 – Feb 2014

Role: ASP.NET Developer

Responsibilities:

Experienced in all phases of SDLC which Involves Project Planning, Analysis, Design, Documentation, Development, implementation and support of software applications.

Involved in Use Case analysis and Developed use-case diagrams using MS Visio 2007.

Involved in Data Model, Work Flow and Web frame designing Using Microsoft Visio.

Implemented web application using .NET Web services (framework).

Performed input validations on Web Forms using various .NET Validation Controls.

Developed Reports Using Crystal Reports.

Used Team Foundation Server (TFS) extensively for version control of the source code along with the maintenance of the builds and the relevant documents of the same.

Involved in Maintenance / Enhancements of the application which includes developing the new reports

Extensively used both Dataset and Data Reader to gather data from database and used Grid View, Data List, Detail View and Repeater controls to the display the data in a desired format.

Involved in database design on SQL Server 2000 and development of different database objects containing functions, triggers, store procedures to manipulate database of the application

Creating Tabular Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services 2008 R2 and Created ad-hoc reports Using Report Builder.

Used Enterprise library Data Access block in DAL to connect to database.

Designed and developed Stored Procedures, Views and Triggers.

Implemented TDD with Unit testing for better performance.

Environment: .Net Framework 3.0, ASP.Net, C#.Net, IIS, Web services, SQL Server, Visual Studio 2010, Win Forms, Oracle 10g, TFS 2010, Crystal Report.

VSigma IT Pvt Ltd, India May 2009 – June 2012

.NET Developer

Responsibilities:

Developed applications based on requirements and specifications.

Gathered the requirements for the development of the application and translated the complex business needs into technical solutions.

Involved in Scrum Agile Collaborative development process adapting to changing circumstances in the development of the project.

Designed and developed custom jQuery components for the front-end client-side validations.

Utilized ADO.NET to establish the connection between server-side web application and Microsoft SQL server.

Implemented the LINQ to SQL for mapping the tables and stored procedures to access the data from the database.

Extensively used GIT hub for the version control.

Performed Unit testing by writing and executing test cases.

Environment: Visual Studio, VB.Net, .NET 2008, ASP.NET 3.0, C#.NET, ADO.NET, IIS, SQL Server.



Contact this candidate