Resume

Sign in

Sql Server .Net

Location:
Cleveland, Ohio, 44124, United States
Salary:
90000
Posted:
March 27, 2019

Contact this candidate

Resume:

Rama

.Net Developer

313-***-****

Professional Summary:

Overall 6 years of professional IT Experience in analysis, design, development, testing and implementation of Client/Server and Web-based N-tier architecture systems using Microsoft Technologies.

Experience in programming with .NET Framework using C#, ADO.NET, ASP.NET, PL/SQL, Visual Studio.NET 2015/2013/2012/2010/2008/2005.

Highly proficient in designing and developing application systems in local and distributed environment using various Object Oriented Methodologies.

Excellent knowledge and proficient working experience in .Net Framework (2/3/3.5/4/4.5), C.NET, ASP.NET MVC 2.0/3.0/4.0,WCF, Web API

Experience in Web Technologies like XML, XSLT, HTML/HTML5, CSS/CSS3, JavaScript, JQuery, Angular JS, JSON and AJAX.

Have worked in maintenance assignments for the Logistic domain, involving enhancements and production support.

Experience in handling various backend data sources like SQL SERVER 2014/2012/2008/2005/2000, MS Access, and Oracle 10g/11g

Expertise in writing Constraints, T-SQL Queries, Indexes, Views, Stored Procedures, Cursors, Triggers, and User Defined Functions.

Worked with Microsoft BI tools SSIS and SSRS and experience in building Web Services using WSDL and SOAP Protocol.

Deployed new applications to Azure cloud services.

Experience in using Microsoft IBM Clear case, Visual SourceSafe, and Team Foundation Server for Version Controlling.

Experience in implementing WCF services/Web services, WEB API and experience with UML diagrams.

Proficient in writing Technical and Functional test scripts and experienced in test driven development using MS Unit testing for the piecewise testing of the Applications.

Excellent working knowledge in Developing Windows Services, Web Services, SOAP, XML, XSD, XPATH, IIS and JavaScript.

Experienced with LINQ and Entity Framework 4.0/5.0/5.2

Strong foundation in java script along with Angular Js 1.2/2.0/4 and familiarity with Angular 2.0

Experience in designing User Interface using Third Party Controls (Telerik Controls) to enhance the performance, looks and features of the website.

Experience in developing User Interfaces using ASP.NET, MVC3.0/4.0/5.0, AJAX, XML, HTML/DHTML, CSS, Master Pages, jQuery, Themes, and Java Script.

Experience in securing web applications using ASP.NET authentication and authorization mechanisms.

Experience in MVC (Model View Controller) architecture with ASP.NET framework and Microsoft.Net Design Patterns.

Experience with Data Accessing using Data Adapter, Data Reader and Data Set in ADO.NET and LINQ (Language Integrated Query) Providers for data manipulation Experienced in implementing applications using SOA, LINQ.

Experience in utilizing ASP.NET Server Controls, User Controls, Data Grid control, Form Validation controls, Custom controls.

Technical Skills:

Technologies

.NetFramework1.1,2.0,3.5,4.0 ASP.NET,MVC3.0/4.0, ADO.NET, Entity Framework, LINQ, WCF, Web API, Restful Web Services

Programming Languages

C, C++, C#, VB.NET.

Scripting Languages

Java Script, Ajax Script, PL/SQL, Angular JS

GUI

Visual Studio .Net 2003/2005/2008/2010/2013

RDBMS

SQL Server 2000/7,2005,2008, Oracle 8i/9i/11g

XML related Technologies

XML, XSLT, SOAP, WSDL, UDDI, Web Services.

Operating Systems

Windows 95/98/2000/NT, XP, Windows

Third Party Tools

Telerik Controls, Kendo UI

Professional Experience:

Senior Dot net Developer Cleveland, OH Jan 2018 to Present

Progressive Insurance

Project: IAQ Insurance (Insurance)

Progressive Insurance is one of the leading Insurance Company, engaged in business of selling variety of insurance products including Motorcycles, Boat, Motor Homes and Trial Trailer insurance through internet or direct sales representatives. SLIQ (Special Line Internet Quote) is an Internet/Intranet application. Particular emphasis was laid on creating Quotes converting an existing quote into an application, creating policy coverage, make payments, adding and removing drivers for each vehicle. This application is developed in ASP.NET MVC, C#, JQuery, JavaScript, WCF and Entity frame work with SQL Server as Database.

Responsibilities:

Involved in developing the UI using HTML, JavaScript, JSON, JQuery, AJAX and Bootstrap.

Graphical User Interface (GUI) was designed using ASP.NET MVC4 and the business logic was coded in C# [MVC Controllers].

Used various JavaScript and JQuery libraries, AJAX for form validation and other interactive features.

Developed various web services using WCF in C#.NET and consumed by web application and other systems like Ticketing and Billing Systems.

Deployed new applications to Azure cloud services.

Developed application for different browsers and fixed bugs for browser compatibility.

Tested writing stored procedures and functions in SQL Server.

Experience Microsoft Azure date storage and Azure Data Factory, Data Lake.

Used ASP.NET MVC4, HTML5 and CSS3 to design the presentation layer of the website.

Developed components to fetch the data from the back end using AJAX and JQUERY.

Working on all type of data structures of generic collections in VB.NET.

Developed JQuery for DOM manipulations and traversals.

Provided high availability for IaaS VMs and PaaS role instances for access from other services in the VNet with Azure Internal Load Balancer.

Used JavaScript for client side validations.

Created service contract, operation contract and data contract in WCF.

Worked on bootstrap for creating responsive web design.

Worked on controller, ng-controller and ng-model in Angular JS.

Involved in writing SQL Queries, Triggers, Views and Stored Procedures.

Developed WCF Data services and consumed by MVC application.

Designed GUI application with Win forms in .NET Framework.

Created JQuery for implementing the AJAX capabilities.

Involved in bootstrap java script framework for developing HTML, CSS and Java Script.

Developed JavaScript event calendar to add scheduler to the application.

Developed Http get, posts calls and pass data using Http Post in Angular JS.

Worked on writing SQL Joins queries for combining data from tables in SQL Server.

Published applications into Web, App servers following n-tier architecture into various environments such as Development, Integration, and UAT production.

Worked on hosting WCF service on IIS.

Used HTML 5 validations and new form element types to implement validation in Angular JS.

Working on OOPS concepts like Polymorphism, Inheritance, Abstraction, etc in C#.

Involved in accessing and assigning the session using JavaScript.

Developed Win forms customized properties of a .NET application from XML config file.

Worked on design patterns like singleton, Dependency Injection, IOC implementation to avoid tight coupling with C# language.

Worked on authentication and authorization in ASP.NET application.

Developed stored procedures, Views and automated SQL, T-SQL scripts for database maintenance, deployment and installation.

Working on implementing authentication and authorization in VB.NET.

Used JIRA for requirements gathering and testing.

Created SQL queries to perform insert, update or delete operation on SQL Server database

Worked with QA team on daily basis in fixing the reported bugs/defects.

Worked on TFS Source control for managing the source code.

Participated in various Client meetings with the team and the Project manager to discuss improvements/ amendments in the development of the application.

Worked in Scrum Methodology and involved in daily sprint meetings.

Environment: Visual Studio 2012/2013, ASP.NET MVC 4, C#.NET, .Net Framework 4.5, WCF, Web API, Entity Framework, Azure, Win forms, Java script/JQuery, Angular JS, JSON, Ajax, HTML, IIS, CSS, Bootstrap, Razor View Engine, XML, XSLT, TFS 2010, SQL Server 2012, JIRA.

Client: Office Depot, FL Dec 2016 –Dec 2017

.Net Developer

Responsibilities:

Developed the UI using ASP. NET and C#. Used ASP.NET User Controls, Custom Controls and Data Grid Web Control.

Implemented the project using Agile Methodology and SCRUM Implementation

Developed web pages using HTML, Cascading Style Sheets (CSS), JavaScript and ASP.Net controls.

Designed interactive ASP.NET MVC5 views using JQuery, HTML5, CSS3, Angular JS and AJAX to provide excellent user experience.

Worked with SQL Server 2012 including Transact-SQL, stored procedures, functions, views, triggers, indexes, query tuning, SSIS, and RDBMS.

Developed RESTFUL Web services, APIs, and other back end components and Used AJAX controls for multi lookup in the forms.

Worked with MVC3.5/4.0 architecture application using Razor view engine and Web API.

Worked in multiple projects like DSPM, Digital docs using .net platform.

Worked with Entity Framework, LINQ and Lambda expressions to query and retrieve selective based information from the collection objects.

Design and implemented ASP.NET MVC Angular JS SPA web solutions with industry best practices and design patterns.

Responsible for designing web pages using ASP.NET MVC, C#, JavaScript, JQuery, Angular.JS and HTML controls.

Used Crystal Reports for the reporting part of the application.

Good knowledge and working experience in Angular Js

Used Angular Js 2/4 framework for building web-apps.

Experience using Ajax tool kit, Telerik controls and Kendo UI for Web based applications.

Developed the Business components in VB.Net.

Various Validation controls are used to validate each and every control on a Web form and client side validations with JavaScript and JQuery.

Design and develop web based solutions through all the SDLC phases including business requirements gathering, front end web page design and implementation, database implementation, testing, prepare technical and release documentation.

Excellent experience in creating & consuming Web services using SOAP, XML, REST, JSON

Developed the server side code using C# and client side code using Java Script with Visual Studio IDE and Team Foundation Server.

Developed and Implemented SOA using WCF in the appropriate scenarios to communicate with other applications.

Used Angular Js MVC Framework in the development of the web application

Used ng-React angular module to use react components on the view layer; Angular.js to manage the underlying business logic.

Designed and developed the required SQL stored procedures, T-SQL, and functions.

Involved in test cases preparation and performed unit testing.

Worked on TFS Environment for Source Code Control and have created Branches to work on different versions of the project.

Developed Data Access Layer Using ADO.NET and accessed Data Using Stored Procedures.

Used SQL Server Reporting Services for creating and managing interactive reports.

Performed End-to-End Testing and troubleshooting, debugging and integration.

Environment:.Net3.5,4.0,C#,MVC4.0,Winforms,Visualstudio2012/2010,TFS,CSS,CSS3,Ajax,JQuey JavaScript, Angular JS, JSON,WEBAPI, Entity Framework, Xml, LINQ,REST, Web service, WCF,SQL Server 2012, T-SQL

Client: Bartronics India Limited, India Sep 2014 to Aug2015

Project: Online Transaction System

Role: .Net Developer

Online Transaction System was developed for online transactions like accessing personal accounts, checking balances, Payment of recurring bills, such as mortgages and loan payments, transfer of funds between accounts of its customers and also between this bank and other institutions, loan rates, other products and services, that correspond with the bank.

Responsibilities:

Participated in system specification meetings, analysed user requirements, coordinated with team.

Followed Agile and Scrum Methodology and to produce high Quality software.

Assisted in development of new software solutions in C# domain within .Net development framework.

Worked with Visual Studio 2013/2015 .net Framework3.5/4.0 to implement Business Logic.

Working on developing new applications using C#.Net and ASP.NET MVC 3.0/4.0, Web API.

Developed websites using HTML5, CSS3, JavaScript, Bootstrap, JQuery, XML and Ajax.

Used Razor syntax in creating Asp.Net MVC application by reducing the coding aspect.

Working on developing Views, controllers and business logic models using C#.

Designed and documented REST/HTTP APIs, including JSON data formats and API versioning strategy.

Involved in branding, look and feel of SharePoint sites using SharePoint Designer.

Developed HTML and CSS pages by using Mockups, Wireframes and flow diagrams.

Responsible for developing a new receipt based on business required meeting ITD standards.

Used SQL Server 2012 to build stored procedures, tables and functions.

Used visual studio 2013 to build web applications and to update the existing web applications to the company’s standards and used Bootstrap for Responsive Web design.

Design and develop web based solutions through all the SDLC phases including business requirements gathering, front end web page design and implementation, database implementation, testing, prepare technical and release documentation.

Integrated the E-Commerce platform with the payment gateways and accounting system

Developed single page applications (SPA) for fast access.

Created wireframes and mockup using various tools to make clear idea for Business.

Working on building the Views using Angular JS and followed various patterns.

Utilized ASP.NET validation controls and JavaScript to perform client side validation.

Created Database Objects like Tables, Stored Procedures and Views using SQL Server 2012.

Implemented Ajax Asynchronous and Asynchronous calls.

Working with Entity Framework to access the data from SQL Server 2012/2008

Worked on TFS for version control, Code Review and for automatic builds and continuous Integration.

Environment:.net Framework 3.5/4.0, C#, Visual studio 2013/15, MVC, ASPX/Razor view engine, Entity Framework, C#, Java Script, JSON, Ajax &JQuery, XML, E-commerce, Web services, WCF, LINQ, MS SQL Server 2012/2008, TFS and Agile Methodology, Angular JS.

Project: United health Group, India July 2013 to Aug 2014

Role: .Net Developer

United health Group web-based portal solution accessed via the internet. COMET reporting solution is envisioned to be delivered through an integrated web-based portal that presents interactive dashboards for executive decision making and reports which enables focused analysis.

Responsibilities:

Participated in system specification meetings, analyzed user requirements, coordinated with team.

Followed Agile and Scrum Methodology and to produce high Quality software

Assisted in development of new software solutions in C# domain within .Net development framework.

Worked with Visual Studio 2013/2015 .net Framework3.5/4.0 to implement Business Logic.

Working on developing new applications using C#.Net and ASP.NET MVC 3.0/4.0.

Developed websites using HTML5, Java, CSS3, JavaScript, Bootstrap, JQuery, XML and Ajax.

Used Razor syntax in creating Asp.Net MVC application by reducing the coding aspect.

Working on developing Views, controllers and business logic models using C#.

Designed and documented REST/HTTP APIs, including JSON data formats and API versioning strategy.

Involved in branding, look and feel of SharePoint sites using SharePoint Designer.

Developed HTML and CSS pages by using Mockups, Wireframes and flow diagrams.

Responsible for developing a new receipt based on business required meeting ITD standards.

Used SQL Server 2012 to build stored procedures, tables and functions.

Used visual studio 2013 to build web applications and to update the existing web applications to the company’s standards and Used Bootstrap for Responsive Web design.

Integrated the E-Commerce platform with the payment gateways and accounting system

Developed single page applications (SPA) for fast access.

Created wireframes and mockup using various tools to make clear idea for Business.

Working on building the Views using Angular JS and followed various patterns.

Utilized ASP.NET validation controls and JavaScript to perform client side validation.

Created Database Objects like Tables, Stored Procedures and Views using SQL Server 2012.

Implemented Ajax Asynchronous and Asynchronous calls.

Working with Entity Framework to access the data from SQL Server 2012/2008

Worked on TFS for version control, Code Review and for automatic builds and continuous Integration.

Environment: .Net Framework 3.5/4.0, C#, Visual studio 2013/15, MVC, ASPX/Razor view engine, Entity Framework, C#, Java Script, JSON, Ajax &JQuery, XML, E-commerce, Web services, WCF, LINQ, MS SQL Server 2012/2008, TFS and Agile Methodology, Angular JS

Project: NE-Department of Labor, India Feb 2012 to Jun 2013

Role: .Net Developer

A Department of Labor is a governmental agency responsible for overseeing the incarceration of persons convicted of Tax system, collects employers taxes based on their annual rate, employers can contribute a onetime annual payment to reduce their tax rate. Taxes are calculated based on rate, wages reported per quarter and if any credits are provided to employer. Wage system, collects employees quarterly wages from all the employers in Tax system. Taxes and wages are reported to IRS. The collected employee wage info is used for calculating unemployment, re-employment and training benefits. BPS maintains benefits per employer, individual and benefits claimed. UI application is used for paying employer taxes/contributions by referring Tax data.

Responsibilities:

Creating and maintaining UI prototypes and specifications.

Collaborating with Product Managers and Software Engineers to provide guidelines on solid UI design.

Keeping up to date with the latest industry trends in UI design and usability.

Translating market and product requirements into UI designs in the form of Conceptual models, Wireframes and prototypes.

Responsible for designing web pages using ASP.NET MVC, C#, JavaScript, JQuery, Angular.JS and HTML controls and GUI was developed using C#.NET and ASP.NET.

Developed Business Logic Component using Web Services, WSDL and Implemented client side scripts using JavaScript.

Implemented SOAP (Simple Object Access Protocol) for communication of application.

LINQ to Objects for WCF service call and Used HTML, XML, AJAX, JavaScript, CSS and pure CSS layouts.

SQL Server (OUTPROC) Session State Management and AJAX for rich user experience in designing the screens.

Used .NET Framework 3.0 throughout the project and converted existing code from 2.0 to 3.0.

Modifications were made to the existing GUI using WPF for better look and feel.

Developed and implemented the software release management for the release of web applications.

Wrote ANT Scripts to automate the build process.

Create, maintain and administrating GitHub and Subversion repositories as source code managements.

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

Involved in development of UI (User Interface) Pages using the HTML, Master Pages & ASP.NET Controls and ASP classic controls.

Involved in the design of the system architecture using UML and MS Visio, to develop class diagrams, use cases etc.

Implemented SCRUM methodology for project management and used SSRS for SQL Reporting services.

Developed a demo version of the product to solicit and incorporate feedback into the design.

Worked on ADO.NET components Data Reader, Data adapter, Data Set and Data View to provide connection to the database in SQL server 2008.

Wrote business logic, lookup list and edits for data table in C# and Used Singleton, Class factory and Dispatcher Design Pattern.

Environment: NET Framework, VB.NET, C#, ASP.Net, ADO.NET, Visual Studio 2003, Web services, XML, AJAX, HTML, IIS, SQL Server 2000 and Windows XP

Education: Master’s, California University of Management and Science, Los Angeles, USA, California.

Bachelor’s engineering (Computer Science) from India



Contact this candidate