Post Job Free

Resume

Sign in

Sql Server .Net

Location:
Glen Allen, VA
Salary:
$60/hr
Posted:
June 27, 2018

Contact this candidate

Resume:

Rohit N

Email id: ac51lp@r.postjobfree.com

Ph no: 732-***-****

SUMMARY:

8+ years of extensive experience with all phases of Software Development Life Cycle (SDLC) Analysis, Design, Development and Testing

Experience developing Web Forms, Web Services, Win Services, Web Pages using various .NET Frameworks.

Design, Develop and Implement Web Applications using .NET Framework Architecture including C# .NET, Win Forms, ASP.NET, AJAX, WCF, Web Services, Angular Js, JQuery, ADO.NET, Data Entity Framework, XML, IIS and Visual Studio.

Developed web based applications using ASP.NET, C# .NET, ADO.NET, Entity Framework, VB. Net, Silverlight, JQuery, WCF, LINQ, JSON, AngularJS, MSEL, HTML5 and XML.

Experience with various development methodologies like Agile, Test Driven Development

Experience in developing Web Applications using ASP.NET Full stack (MVC framework, Web API)

Extensively Used LINQ to SQL, LINQ to XML and LINQ to Objects for retrieving the data efficiently and Just in Time manner.

Experienced in developing Single Page Application (SPA) by using AngularJS.

Experienced in responsive UI design and tools such as HTML4/5, CSS3, Bootstrap, AJAX, and AngularJS.

Experienced and fully engaged in Software Development Life Cycle (SDLC) which includes gathering and analyzing business requirements, functional/technical specifications, designing, developing, testing, deploying the applications, and providing production support.

Very well versed with Web related technologies/concepts like JQuery, JQuery UI, JavaScript, AJAX, State Management, Caching, XSS and Security

Extensive knowledge of applying Object Oriented Analysis and Design (OOAD) for modeling a system.

Experience in SQL Server and SSIS (Integration Service) package design, constructing, and deployment.

RDBMS Experience with Stored Procedures, Functions, Views and Triggers and imports and exports of Data in SQL Server.

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

Strong expertise in database design and programming skills.

Hands on experience in creating content driven and user-friendly application using WPF and Silver light.

Extensive knowledge of C# object oriented programming language concepts like Abstraction, Polymorphism, Inheritance and Encapsulation.

Experience in design and development of applications using N-Tier Architecture.

Experienced in developing triggers, user defined functions and stored procedures.

Experienced in ADO.NET components such as Datasets, Data Adapters, Data Readers.

Ability to manage and deliver multiple projects on time.

Experienced in Manual Testing and Automation Testing.

Knowledge in writing Test Plans, Test Cases and Test Scripts.

Experience in Functional Testing, Unit Testing, GUI Testing, Back-end Testing using SQL, Browser Compatibility Testing, Web Services Testing, System Testing and UAT.

Understanding of Business Intelligence Architecture, ETL Processes, Data marts and Data-warehouse Design. Strong debugging skills in n-tiered ASP.Net/C#web application.

Deployed Websites, having 3-tier architecture (Web Server, Web Services server, Database server). Good knowledge in developing web API.

Working knowledge on Azure cloud IaaS and PaaS Services.

Experience in maintaining automation framework and PowerShell as Scripting Language.

Expertise in database design and database programming in MS-SQL Server (using stored procedures, functions and triggers), Access and networked Paradox.

Extensive Knowledge on MongoDB.

Experience in writing queries, Indexes, triggers, views, functions, stored procedures, designing & normalization of relational database in Transact SQL and PL/SQL using SQL Server Oracle 9i/10g.

Experience in the strategy and practical implementation of AWS Cloud-Specific technologies including AWS EC2, EBS, S3, VPC, ELB, Cloud Front, Cloud Formation, Elastic Cache, Cloud Watch, RedShift, Lambda, SNS, Dynamo DB and also Devops tools like Jenkins, Ansible, Chef, Puppet and Docker.

Good Experience in database development in creating complex database Queries, Views, Stored Procedures, User Defined Functions, Cursors and Triggers.

Good Knowledge in SharePoint, BizTalk Server, RabbitMQ, Couchbase (MS SQL) and Windows Azure.

TECHNICAL SKILLS:

Operating System

Windows 2000/XP/Vista/ Windows 7/8/10

Microsoft Technologies

Net Frame work, ASP.NET, ADO.NET, MVC, LINQ, Entity Framework

Programming Languages

C#.Net, VB.Net, C

Web Technology

ASP.NET Classic ASP, HTML, HTML5 XML, XHTML, DHTML, XAML, ASP.Net MVC, WPF, WCF, Ajax, CSS, CSS3, Bootstrap and Silverlight2.0/3.0, XPATH, XSLT, Web services, WSDL, WWF, UML, SOAP, SOA.

Environments:

Microsoft Visual Studio […] Eclipse 3.0

Scripting Languages

Java Script, JQuery, JSON

Database

SQL Server, MongoDB

Web Servers

IIS 5.0/ 6.0/7.0

Areas of Knowledge

Angular, Microsoft Azure

WORK EXPERIENCE:

Capital One, Glen Allen, VA Sep 2016 - Present

Sr .Net Developer

Responsibilities:

Designed and developed various abstract classes, interfaces, classes to construct the business logic using C# and VB Net.

Involved in developing web roles with rich UI usingASP.NET MVC 5, HTML 5, CSS3, CSS, DHTML, AJAX, jQuery, Jason, WEB.

Worked with MVC architecture application using ASPX View engine and WEB API

Used Web API for HTTP and REST based GET, POST, PUT, DELETE and Returning JSON format.

Worked with Windows Azure Worker Roles & Web Roles.

Involved in different phases of the Software Development Life Cycle (SDLC

) including Designing, Programming and Documentation.

Developing Master pages for the application and used Telerik controls for grid view.

Design and development of master pages, content pages and user controls using Infragistics and AJAX tool kit.

Installed, Configured and implemented Genesys Framework components.

Designed and developed complete front-end application using Classic ASP

Prepared and maintained ASP.NET user interfaces with Telerik controls.

Used Active Directory Password resets, Created and modified Exchange mailbox distribution lists. Created and managed network user groups

Implement Spring Integration for listeners of FTP File manager, SOR monitoring, and RabbitMQ message handling

Client side validation was done using JavaScript and Configured the IIS.

Used ASP.NET validation controls (Required field validator, regular expression validator, compare validator, range validator), User Controls, Custom Controls, Data Grid Web Control.

Designed and developed Rebranding controls as a User Controls in Silver light 2.0

Maintained build versions and code versions using GIT's Version Control

Redesign and development of Sphynx Software website using C#, Microsoft .Net, ASP .Net MVC, SQL Server, Content Management System (CMS).

Manipulated data using CRUD operations of MongoDB and SQL management studio and handled database access and data transmission based on RESTful web service.

Involved in front end development using ASP.NET, JavaScript, Angular JS, jQuery, HTML, Bootstrap and CSS.

Designed and developed web forms using Classic ASP.NET.

Developing Genesys Routing Strategies.

Worked on middleware technologies including WMB message broker and MQ.

Leveraged AngularJS resources for all data access, encapsulating URLs and standardizing data access interfaces.

Utilized AngularJS Services, Factory and Dependency Injection techniques to ensure an Inversion of Control (IOC) by focusing on minimizing the number of watchers in order to increase the performance.

Use of automated authoring and training tools, RWD Info Pak Publisher, Info Pak Simulator, Adobe Captivate, Visio, and Snagit

Performed unit testing on every new version before sending it for User Acceptance Test (UAT).

Made use of the JavaScript functions for browser Check of the application.

Used Multithreading to monitor objects to ensure that block of code runs without interrupting from any other code running on other threads

Used SQL 2012 reporting services (SSRS) to provide highly customized reports in a real time system.

Handled Configuration (Session, authentication and authorization, custom errors, tracing) or the online transactions by the customer and creating user login and privileges.

Migrated some of the modules from. Net Framework 2.0 to 3.0.

Coding- Worked as a developer for C++ based library as Controller and Backend classes.

Worked on HTML5 and Java script with integration of Kendo UI for developing grids, charts and schedulers.

Used NHibernate to create DAO, DTO layers and mapping the database tables.

Created Integration Services SSIS package to import raw data from MS Excel to the SQL Server.

SSIS was used for creating packages and automating them using SQL scheduler.

Used WPF to create rich clients as B2B applications.

Installed BizTalk server 2010, HIS Server 2010, and ESB tool kit in all environments like Dev. Test Staging.

Developed custom tools to automation testing for a data loading. Guided the team to develop web roles using ASP.NET MVC 5, HTML5.

Environment: Microsoft Visual Studio 2010, C#, ASP.Net 4.0, .NET Framework 4.5 WCF, Web Forms, JavaScript, Telerik Controls, SSRS JQuery, HTML5, CSS, AngularJS, SQL Server 2012, Entity Framework, MVC 4.0, AGILE Methodology

Barclays, Wilmington, DE May 2015 – Aug 2016

.Net C# Developer

Responsibilities:

Developed Workflows using ASP.NET as part of the business processes. The Workflows served the purpose of document filling, processing, approval/disapproval and notifications.

Used JQuery from the client side to access the DOM elements from the ASP .NET Web Pages.

Using MVC architecture creating controllers, views and models and HTML5 along with the Razor.

Making the Ajax call and return the response in the JSON to bind in the Telerik Kendo UI Grid MVC.

Extensively worked in consuming XML, JSON web services over HTTP using SOAP, WCF services and Web API/REST APIs with c#.

Worked extensively on Microsoft Technologies including C#, ASP.NET 4.0/3.5 MVC 3.0, 4.0 Framework, VB.NET, Microsoft Internet Information Server 6.0,7.0.

Used MVC5, for the web application.

Used Angular JS 1.5 for dynamic binding and Jquery with Kendo UI.

Creating the C# Web API/REST APIs services for HTTP/HTTPS which will be accessible for most of the clients.

Developed independent UI modules using Prism framework and MVVM pattern. Worked on defining logical modules coupled with Regions to define UI work flows specific to functionality.

Used Multi-Threading to process to perform background tasks, Whenever there is discrete work

Worked in different areas including Collaboration, Document Management, Portal and Content Management System (CMS).

Experience with LINQ to Entities or LINQ to SQL Behavior Driven Development (BDD), Windows Workflow (WF), and SQL backend programming, data modeling, client-server Connectivity, stored procedures and triggers programming.

Worked with the Development, Test, and Production environment in Microsoft Azure Active Directory.

Intensive use of CSS3, HTML5, Jquery, JavaScript, Anychart to design look and feel of the web pages with interactive and rich display.

Creating Generic functionality for reusability with in application, to avoid the redundancy.

Used bootstrap in the front end to accomplish a responsive UI Design.

Used Entity Framework Data First approach.

Using C# LINQ over collections and Entity framework for data querying and filtering the results.

Effectively used C# ADO.Net Components such as DataSet, DataAdapter and DataReader.

Extensively worked with C# ADO.NET Data access mechanism using datasets/data reader, data tables and row filters.

Built front-end SPA using HTML5, AngularJS, Bootstrap and backend server using ASP.NET Web API.

Customized and consumed Web API with $http service to achieve CRUD operations.

Performed AngularJS Form Validation and AngularJS Form properties with ng-show and created a custom validation directive for comparing two input values.

Extensively involved in developing SQL Server, T-SQL, Pl/SQL schema objects such as Indexed views, stored procedures, triggers, Performance tuning, roles and users.

Created Database objects such as Stored Procedures, Tables, Indexes and Triggers in SQL and Pl/SQL etc.

Extensively worked with TFS as the source control repository and timely merging to the testing and staging.

Performed intensive Workflow testing following the test case documents.

Environment: .NET 2012, ASP.NET MVC 4.0, HTML, JavaScript, jQuery, LINQ, ADO.NET, SQL Server 2008, SQL Server Profiler Tool, XML, InfoPath Forms, IIS 7.0, MS Visual Source Safe 2005, XML Web Services, WCF RIA Services, Net meeting, Communicator, Outlook, MS Office

Wells Fargo, Charlotte, NC Nov 2013 – Apr 2015

.Net Developer

Responsibilities:

Proficient in designing and developing enterprise solutions utilizing MVC Framework technology.

Involved in the SDLC of requirement analysis, design and development of the web based application in the fast paced agile methodology.

Developed scalable distributed applications utilizing a combination of the following. (WCF, REST-ful Web Services,ASP.NET, SOAP based Web Services and ADO.NET)

Created views, queries, and indexes and stored procedures in SQL backend to quickly debug and fix issues.

Extensive experience in developing data driven applications utilizing significant relational database engines like MS-SQL as part of the overall application architecture.

Memory management, parallel programming and design patterns.

Worked with various authentication mechanisms for making the web-service layer and database connections more secure.

Release management and handling code deployments to IIS.

Used Dependency injection and Inversion of control concepts in the development for delivering loosely coupled systems.

Developed, Designed, modeled, architected and consumed WCF services with n-tier software agent. Optimized existing MS Excel workbooks to increase productivity using VBA.

Followed Agile Test-Driven Development (TDD) and Behavior driven development (BDD) methodology using JUnit framework.

Used Unified Modelling Language (UML) technologies for design and develop application include class diagrams, sequence diagrams, activity diagrams using VISIO 2012 and UI Wireframes. Used RabbitMQ as messaging broker.

Created a virtual network on windows Azure to connect all the servers.

Worked with version controller Team Foundation Server (TFS) for maintaining history of source-code and project documents.

Developed and tested user-friendly navigators by utilizing JavaScript and VB .NET.

Designed the front end of the application using Python, C/C++, HTML5, CSS, LESS, CSLA, AJAX, Kendo UI, JSON and JQuery, VB script. Creating applications using VB.NET and enhancing projects for .NET applications.

Design and implement Responsive design website using Bootstrap CSS3.

Used Angular2 Dependency Injection (DI) to inject Angular Service and custom Service.

Contributed in the design of the front-end UI application using WPF and developed the business logic using C# backend in the form of View Models.

Documentation and development support for JIRA Service Desk.

Experience in maintaining and writing a complex Queries in Elastic Search.

Involved in the development of micro services for all the 4 models using combination of python. Designing and implementation of a micro services architecture.

Created custom ASP.NET pages and configured forms and views for new modules to be added to MS Dynamics Ecommerce and CRM system.

Experience working with PowerShell and Node JS.

Analyzing and improving the efficiency, scalability, stability, and security of applications and in-house systems to help scale the company.

Loading data into tables using SQL server import and export wizard and VS SSIS packages.

Used JavaScript library for validations and developed entire code using VB.NET and C#.

Updated the entire application to be cross browser compatible.

Used jQuery, jQuery UI and AJAX as needed for better user experience.

Wrote test cases for user acceptance test.

Custom node.js proxy used to simulate API responses before client implementation was complete, and to proxy requests to finished client APIs, handling authentication, custom headers, virtual application root, etc. .

Responsible for troubleshoot and bug fixing of the tasks.

Environment: Microsoft Visual Studio 2013, MVC 4.0, ASP.NET, PowerShell scripting, node.js, C#, Web Forms, JavaScript, SSRS, SSIS, JQuery, HTML5, CSS, SQL Server 2012, Entity Framework, WINSCP, Putty, AGILE Methodology

Jr. Net Developer Jan 2012 - Sep 2013

Aviva Life Insurance, Hyderabad, Telangana

Responsibilities:

Followed AGILE development methodology with daily SCRUM meetings.

Developed Web application using ASP.Net MVC framework

Created and consumed web services using WCF framework.

Used jQuery, jQuery UI and AJAX as needed for better user experience.

Utilized Team Foundation Server (TFS) for the purpose of version control and source code maintenance needs.

Worked with QA to prepare various test cases and helped in production support.

Heavily involved with database development including performance optimization.

Maintained Visual Source Safe.

Used Agile Methodologies like XP, pair programming to support rapid iterative software development.

Wrote test cases for user acceptance test.

Documentation of developed Components and module.

Responsible for Database support of the application.

Involved in production support and release planning.

Environment: Visual Studio 2010/2012, ASP.NET MVC 3.0/4.0, C#.NET, WCF, SQL SERVER 2008, LINQ, JavaScript, Team Foundation Server, XML, ADO.NET, Windows Server 2008.

.Net Programmer Analyst Jun 2009 - Nov 2011

Kensium Solutions Pvt ltd, Hyderabad, Telangana

Responsibilities:

Interacting with Client to gather requirements and document all the requirements

Involved in the Analysis, Design and Development of the enhancement system

Designed User Interface with HTML and Cascading Style Sheets (CSS).

Involved in creation of application setup and reports using ASP, HTML, DHTML, and Validations were performed using VBScript and JavaScript and J-query.

Involved in Object Oriented Analysis and Graphic User Interface (GUI).

Implemented Object oriented concepts effectively like inheritance, overloading, abstract class, etc.,

Developed JavaScript and JQuery files for client-side validations.

Created (BLL) Business Logic Layer and Presentation layer in VB.NET

Contributed significantly to design of the object model in the middle tier

Created Common DATA Access Layer (DAL) Using Visual Basic 6.0 and ADO.NET

Involved in Database Design using SQL Server 2000

Creating Packages and Stored Procedures

Environment: VB.NET, ASP.NET, ADO.NET, Visual Basic 6.0, Window Forms, Web Services, SQL Server 2000, JavaScript, Visual Source safe, HTML, CSS.



Contact this candidate