Sql Server .Net
Resume:
Sumanth Bussa
E-mail:*************@*****.***
Tel: 302-***-****
PROFESSIONAL SUMMARY
.NET Developer with experience in evaluation, design, development, testing, maintenance and production support using SDLC process and methodologies. Strong skills and experience in Object-Oriented Programming using the .NET framework.
Experience in implementation of N-Tier Architecture in Windows and Web based, Client/Server, internet/intranet and distributed applications in Microsoft Technologies.
Hands-on experience in UI Design using Win Forms, Web Forms and programming ASP.NET,C#.NET, ADO.NET, VS.Net 2013/2012/2010/2008/2005, Bootstrap, JavaScript, LINQ, AJAX, JQuery, AngularJS, Web API by using .Net Framework 2.0/3.0/3.5/4.0/4.5.
Expertise in using Language Integrated Query (LINQ) providers for data manipulation.
Experience in Web Services to provide SOA architecture with WCF SOAP\REST and Configuration based activation applications.
Extensively worked on Entity Framework generating ORM Models and integrating them through SQL and LINQ to Entities to message the data.
Extensive experience in ASP.NET MVC implemented Model, View, Controllers, Routing etc. to managing complexity for highly testable presentation Web Applications
Experience in using Language-Integrated Query (LINQ to Objects, LINQ to XML, and LINQ to SQL) and retrieve data from different data sources.
Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, SQL joins and query writing. Database designing and programming skills using SQL Server 2005/2008/2012 and XML data source.
Experience in reporting and analysis using Crystal Reports, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) with the .net environment.
Expertise in Unit and Integration Testing using N-unit Testing Framework.
Experience in using Microsoft Team Foundation Sever (TFS) for code repository, task assignments, and project backlog plan and version control.
Exposure in solving and debugging problems using Fiddler, Developer Tools etc.
An innovative team player proven to work under tight deadlines, adaptable to new software technologies, quick learner and also can work efficiently as an individual.
Education:
Bachelors of Engineering (B.Tech.) in Computer Science & Engineering
Jawaharlal Nehru Technological University, Hyderabad, INDIA
Technical Skills:
Web Technologies : HTML, XML, CSS, HTML5, CSS3, Webforms, Web Services
.Net Technologies : .NET Framework 4.5/4.0/3.5/3.0/2.0/1.1, ASP.NET, ADO.NET, Web api
Win forms, AJAX, LINQ, ASP.NET MVC, Entity Framework.
Programming Languages : C#, PL/SQL, UML
Operating Systems : Windows 2000/7/8/XP
RDBMS : SQL Server, SSRS, SSIS
Version Control : TFS
Web Servers : IIS 5.1/6.0/7.0
Development Tools : Microsoft Visual Studio .NET 2005/2008/2010/2013.
Methodologies : Agile and Waterfall
Reporting Tools : Crystal Reports
Scripting Languages : JavaScript, JQuery, Bootstrap, AngularJS
Professional Experience:
New Mexico State Project (PED), Santa Fe, NM March 2017 - Present
.Net Developer
Responsibilities:
Developing Business logic layer by implementing Object Oriented Programming languages (OOPS) concepts, abstraction, encapsulation, inheritance, polymorphism in C#.
Designing & Developing the controls in user interface using C# and Asp.Net.
Design and development of web forms using HTML, ASP.NET, CSS and Bootstrap
Involving in the Design and Implementation phases of agile software development lifecycle.
Developing various interface screens using ASP.NET and HTML controls for Client-Server interaction.
Creating CSS files to be applied to various web forms on the web pages.
Using JavaScript to create different client side functions that greatly decreased processing time and resource consumption.
Performing client side validation using JavaScript and Jquery.
Experience in using Language-Integrated Query (LINQ to Objects, LINQ to XML, and LINQ to SQL) and retrieve data from different data sources.
Implementing Entity Framework,Linq to Entities and Linq to Sql for connecting the Database and perform all the database transactions
Creating database tables, views, stored procedures and triggers using SQL Server Management Studio
Maintaining build versions and code versions using TFS.
Performing Unit Testing using tools like NUnit which is a derivative of Testing Framework.
Environment: .Net 4.5, ASP.Net, AJAX, JavaScript, JQuery, Entity Framework, Bootstrap,HTML,CSS, LINQ, IIS 7.0, MS Visual Studio 2013, C#, SQL Server 2012 and TFS.
IBM Thomson Reuters, Lansing, MI Sep 2016 - Feb 2017
.Net Developer
Responsibilities:
Experience in all the phases of Full Life Cycle Development (SDLC) involving studying of the user requirements, analyzing, designing, coding, implementation, debugging and testing of the project.
ImplementedAgile methodology for the development of the application and regular adaption to the requirements.
ImplementedWeb Forms using ASP.NET and coding the Business logic in C#.
Designed and developed application using ASP.NET MVC framework.
UsedJQuery to simplify the HTML document traversing and event handling for UI components.
DevelopedJavascript code for client side validations.
ImplementedAjax for asynchronous data transfer to provide better performance.
Designed rich UI using JavaScript library AngularJS.
Worked on creating Rest Services using ASP.NET Web API and C#
Experience in writing Data Access Layers using ADO.net entity Frame Work and LINQ to SQL.
Developed the reports and analysis using Crystal Reports, SQL Server Reporting Services (SSRS) with the .net environment.
Developed database objects such as tables, views and user defined functions for database operations in SQL SERVER.
Participated in designing the SQL Server database objects for the project and involving in writing the Stored Procedures and Database views.
Worked extensively on SQL queries and Joins and working on Performance tuning the Database.
Performed unit testing by using automation testing frameworks.
Implementedexceptional handling using Try, Catch and Finally blocks for the custom error output and Performed testing on the application.
Experience in updating, accessing and version controlling the source code using Team Foundation Server (TFS).
Environment: .Net 4.5, ASP.Net MVC, AJAX, JavaScript, jQuery, AngularJS, Entity Framework, HTML, IIS 7.0, MS Visual Studio 2013, C#, SQL Server 2012 and TFS.
Wells Fargo, San Antonio, Tx Feb 2016 - Aug 2016
.Net Developer
Wells Fargo Home Mortgage is one of the nation’s leading retail mortgage lenders and services one of every six mortgage loans in the nation. A division of Wells Fargo Bank, N.A., it has a national presence in mortgage stores and banking stores, and also serves the home financing needs of customers nationwide through its call centers, Internet presence and third-party production channels.
Responsibilities:
Involved in gathering and analyzing the requirements from the client and actively involving in Full Lifecycle Development.
Implemented Agile methodology for the development of the application.
ImplementedWeb Forms using ASP.NET and coding the Business logic in C#.
ImplementedASP.Net controls like Grid view control, Details view Control, Form view Control, Repeaterand Data list control to display and enable data manipulation at the interface level.
Developed the web pages using ASP.NET, HTML, and CSS for styling the Web pages.
ImplementedAjax for asynchronous data transfer to provide better performance.
ImplementedJQuery and JavaScript for developing rich user interface.
Developed the reports and analysis using SQL Server Reporting Services (SSRS) and SQLServer Integration Services (SSIS) with the .net environment.
Worked with Web API to provide services to HTTP requests.
Used ADO.NET and related data objects such as Data Adapter, Data Reader, Data Set and Data Table forconsistent access to SQL data sources.
Developed database objects such as tables, views, stored procedures and user defined functions fordatabase operations in SQL SERVER.
Experience in working with Team Foundation Server (TFS).
Fixing the bugs and interacted with the testing team to resolve issues.
Environment: .Net 4.5,C#, ASP.Net, ADO.Net, AJAX, JavaScript, JQuery, HTML, IIS 7.0, MS Visual Studio2012, SQL Server 2012 and TFS.
Geico, Macon, GA Jan 2014 – Dec 2015
.Net Developer
Geico is one of the largest insurance companies in USA. It is provider of auto insurance. Auto Insurance System is fully automated and integrated application for managing the Policy plans, Agent Commission, Incurred but not Paid and Settlements. This Insurance Management System gives information of the client, policy details and premium rates and monitors the policies for delayed payments. It manages different claims per policies, claim settlements and allows coverage verifications.
Responsibilities:
Involved in gathering and analyzing the requirements from the client and actively involved in Full Life Cycle Development.
Worked on Agile/Scrum Methodology throughout the project.
Involved in designing and developing application using ASP.NET MVC Framework and C#.
Worked Extensively on OOPS Concepts Encapsulation, Inheritance, Polymorphism, and Abstraction.
Designed the UI pages using the Razor view templates.
Experience in different design patterns such as MVC and MVVM.
Experience in developing the application using Web API to validate the address.
Designed the UI pages using the Data Tables where we can perform Sorting, Paging, and Searching.
Designed the cshtml pages using Html Helpers, Partial Views, JQuery, CSS and JavaScript.
Involved in designing rich UI using JavaScript library AngularJS.
Involved in designing websites using Bootstrap.
Experience on programming, design, understanding and deep functional experience in creating, deploying and consuming of REST Services and Web API.
Used Entity Framework and LINQ to SQL quires to perform the Database operations and Followed database first approach.
Participated in designing the SQL Server database model for the project and involved in writing the Stored Procedures and Database views.
Worked extensively on PL/SQL quires and Joins and worked on Performance tuning the Database.
Implemented windows authentication to authenticate the users to restrict certain permissions to perform operations.
Implemented Exceptional Handling using Try Catch, Finally Blocks for the custom error output.
Experience in working with Team Foundation Server (TFS).
Performed Unit Testing using tools like NUnit which is a derivative of Testing Framework, Integration Testing with Q.A team.
Environment: .Net Framework 4.5, ASP.Net MVC 4.0, SQL Server 2012, Visual Studio 2012, JavaScript, JQuery, Json, CSS, AngularJS, C#, VB.NET, SOAP, REST, Entity Frame Work, TFS 2010/2012, IIS 7.0, AJAX, LINQ, XML, NUNIT.
Kaiser Permanente, Denver, CO Feb 2013 - Dec 2013
.NET Developer
Kaiser has a mission--to provide quality care for our members and their families, and to contribute to the well being of our communities. Kaiser provides various health plans and services to its individuals and families. The health plans includes Medicare Advantage Plans, Senior Advantage Medicare Medicaid Plans and Company Plans.
Responsibilities:
Involved in requirement analysis and application designing sessions with business analysts and team members to outline the proposed IT solution.
Developed application using N tier methodology and followed agile methodology.
Develop Business logic layer by implementing Object Oriented Programming languages (OOPS) concepts, abstraction, encapsulation, inheritance, polymorphism in C#.
Made enhancements to the existing Widget controls in user interface using C# and Asp.Net.
Designed and developed web forms with ASP.Net, JavaScript, JQuery and HTML.
Developed ASP.NET MVC 4 applications using Code First Approach.
Involved in designing and developing the GUI for the user interface with various custom and user controls (Grid View, Data List, Textbox, Calendar, List Controls, Dropdown, Validation Controls etc.).
Created master pages for laying out the common layout of the application for consistent look across all the pages and also themes for the pages.
Used JQuery to simplify the HTML document traversing and event handling for UI components.
Generate Entity Framework context models utilizing database first approach and built library of data access methods.
Implemented Bootstrap framework for styling the HTML pages.
Written Stored Procedures in SQL Server and LINQ to Entities to bind the data.
Used ADO.NET for the database access using SQL Server Data Adapters.
Created the stored procedures, views and functions using SQL Server.
Involved in tuning the Database queries which are degrading the performance of the application.
Used SSRS to generate reports and integrated with asp.net web page using report viewer.
Performed unit testing on some modules.
Handled many production issues and enhanced the User interface as per the requirements.
Experience in updating, accessing and version controlling the source code using Team Foundation Server (TFS).
Environment: .NET Framework 4.0, ASP.NET, ADO.NET, C#, HTML5, SQL Server 2012, JavaScript, JQuery, CSS3, AJAX, Visual studio 2012, MVC 4.0, Entity framework, Nunit, TFS, SSIS, SSRS, Bootstrap, AngularJS.
IkaSystems, Boston, MA Feb 2012 - Jan 2013
.NET Developer
IkaSystems delivers business automation and process solutions that transform how health plans conduct commercial, Medicare, Medicaid, and ACO business. Their integrated yet modular Web-based platform works across all departments and business lines, generating cost savings and ensuring agility in an ever-changing healthcare landscape.
Responsibilities:
Working in Agile Methodologies for rapid development and regular adaption to the varying requirements and continuous delivery of the working software.
Proactively Involved in Full Life Cycle Development (SDLC), provided value added services with development teams and clients throughout the life span of a project.
Designed & Developed Components using C#.NET.
Involved in designing User interface and Prototypes for the application using ASP.NET.
Developed the reusable framework for the application using the ASP.NET MVC Framework.
Worked extensively JavaScript, where we can perform inline editing and client side validations.
Designed and developed UI using ASP.NET, HTML, CSS, JQuery and AJAX.
Used ADO.NET Entity Framework and Linq to Entities Connect to the Database and perform all the database transactions.
Responsible for developing joins, stored procedures, Functions to perform data transactions on SQL Server Database.
Developed SSIS packages to import data from flat files to database.
Involved in debugging high severity defects and UAT.
Involved in Code walkthrough and query optimization.
Fixing the bugs in the application according to the priority set by the customer support.
Performed unit testing using tool NUnit, system testing and performance testing.
Environment: Visual Studio.NET 2010, C#.NET, Asp.net MVC 4.0, ADO.NET, linq, SQL Server 2008, Nunit, Entity framework, .NET Framework 4.0, JavaScript, Ajax, JQuery, Json, TFS.
PacifiCare, Cypress, CA Jan 2011 –Jan 2012
.NET Developer
This is a web application which manages all the inventory of a pharmaceutical company and also has an additional advantage of listing the most purchased medicines and can provide data to any health care center to analyze the frequently occurring cases and also use that data in research process.
Responsibilities:
Involved in gathering of requirements and creation of functional specifications for the project, based on the existing use cases and new use cases proposed by the client.
Worked on Agile Methodology (Scrum) to meet timelines with quality deliverables
Designed and developed GUI with web forms using C#, ASP.NET Controls, AJAX, JQuery and JavaScript.
Used Grid view control, Details view Control, Form view Control, Repeater and Data list control to display and enable data manipulation at the interface level.
Client-Side validations were used as validation controls and JavaScript were coded for functionalities at client-side.
Used ASP.NET MVC framework to support the use of Dependency Injection to inject objects into a class.
Master Pages were used to achieve uniformity in the entire application and CSS were used for theming the pages.
Made use of Microsoft AJAX extensions such as script manager and update panel to make an asynchronous call to retrieve data and update client-side HTML fields for rich user experience.
Used ADO.NET and related data objects such as Data Adapter, Data Reader, Data Set and Data Table for consistent access to SQL data sources.
Created Web Services responsible for communicating and providing real time data from integrated server to Client Application.
Debugged web applications and JavaScript using browser developer tools like Fiddler.
Developed database objects such as tables, views, stored procedures, audit triggers and user defined functions for database operations in SQL SERVER 2008 standard edition.
Implicated test driven development approach using N-Unit Testing.
Logging and error handling mechanisms were implemented throughout the application for robustness.
Used TFS for version control of the source code along with the maintenance of the builds and the relevant documents of the same.
Environment: .NET Framework 4.0, ASP.NET, ADO.NET, C#, SQL Server 2008, JavaScript, HTML, Web Services, Visual Studio.NET 2010, TFS, CSS, Ajax, JQuery, Asp.net MVC 3.0.
Contact this candidate