Sql Server .Net
Resume:
Rajasekhar Konda
*************@*****.***
Profile
10+ years of experience in Development, Testing and implementation of client-server, internet and intranet based applications
Strong object oriented and web, mobile development background with experience developing projects using ASP.Net, C#, C++
Extensive experience using MVC Razor views, Filters, Validations, routing, frameworks.
Strong web programming skills using Html5, CSS3, jQuery, Node.js, Telerik controls.
Expertise in using .NET data access technologies including ADO.NET and LINQ to SQL
Experienced in creating and consuming RESTFUL and SOAP web services using WCF
Hands on experience working with both Relational Databases (SQL Server 2008, Oracle) and NoSQL databases (Mongo DB)
Comfortable in working on agile methodologies, domain driven design, code refactoring and test-driven development.
Technical Skills
Programming Languages C#, VB.Net, Visual Basic 6, SQL, C++, Power Builder
Web Development ASP.Net 4.5\4.0, MVC 5, HTML5, CSS3, Java Script, AJAX,
IIS Web Server, JSON, XML\XSLT, Telerik, SharePoint 2010, Silverlight
JavaScript Libraries Angular.js, Java Script, Require, Backbone, Type Script, Knock Out,
Boot Strap, EXT JS, Sencha Touch
Development Tools Visual Studio 2013/2010, SSIS, Visual Interdev 6.0, Dreamweaver,
NUnit, SSAS
DBMS Microsoft SQL Server 2000/2005/2008, Sybase, MS Access 2000
Data Access Technologies ADO.Net, LINQ to SQL, ODBC, DAO/RDO/ADO, ActiveX,
Operating Systems Windows 2008/2003/XP, UNIX, Mac OS
Source Control TFS, Harvest, SVN
Reporting Tools SSRS, Telerik Reporting, Silverlight Reporting, WPF Reporting, Crystal Reports
Workflow Tools SharePoint 2010, Workflow Gen, Black-Perl, Black-Point
Professional Experience
.Net Developer, Tegrit Apr 2016 – Till Date
Pension Admin: Worked on the Pension-admin project to build end-end tool. Which allow participant to search, create, order, copy quote, validate cart, and export order. It provides option to send electronic email to recipients once the quote, orders are placed. Business logic is implemented using the C#.Net, MVC. SQL is used the back-end relational database to store and retrieve information for tool.
Responsibilities:
Worked in Agile Scrum Methodology, actively participated in Retrospective, backlog grooming, Team sync meetings
Implemented the structure map and service contract objects to integrate with client
Configured the dependency bootstrap for Initializing, validating the classes and encrypting the modules.
Created the SQL scripts to perform CRUD operations based on input passed to Stored Procedures
Created the razor views using HTML5, CSS3 to display the data associated with form view model
Used JQuery to create the model dialog for showing the several billing options for each product
Implemented the business logic using the service contracts, channels, interfaces, classes, Inheritance, OOPS concepts
Extensively used Auto Mapper to map new\existing Model to View Model
Made use of Google ISAPI to create the TimeLine employment history reports
Enabled Un Obstrucive AJAX to POST and partial post back to server
C# OOPS concepts are used to create, update, manage shopping cart, items, session, cache
Created Ajax calls to Get, Post, Put data to server using REST URL
Applied the CSS Styles to display warnings, validation messages
Used the LINQ to create the dynamic library for orders, Quote
Created the Unit, Integration, Functional test cases using the N Unit framework
Used TFS as version control for code repository
Environment: C#, SQL, .Net, LINQ, Entity, Html5, CSS, CSS3, REST, SOAP, Ajax, JQuery, N Unit, MOQ, Angular, bootstrap, TFS, Agile, REST, WCF
.Net Developer, Dell Nov 2015 – Apr 2016
Nexus: Worked on the Nexus NGVL project to build end-end sales tool. Which allow user to create quote, order, copy quote, validate cart, and export order. It provides option to send electronic email to recipients once the quote, orders are placed. Business logic is implemented using the C#.Net, MVC. SQL is used the back-end relational database to store and retrieve information for tool.
Responsibilities:
Worked in Agile Scrum Methodology, actively participated in Retrospective, backlog grooming, Team sync meetings
Implemented the structure map and service contract objects to integrate with client
Configured the dependency bootstrap for Initializing, validating the classes and encrypting the modules.
Implemented the business logic using the service contracts, channels, interfaces, classes, Inheritance, OOPS concepts
Validated, Formatted and mapped all data to associated Model object.
Created Ajax calls to Get, Post, Put data to server using REST URL
Created the Unit, Integration, Functional test cases using the Rhino, N Behave, NUnit framework
Encrypted, Decrypted the application settings when connected to SQL Server
worked with off-shore team for development related tasks
Environment: C#, SQL, .Net, MVC 5, LINQ, Entity, Html5, CSS, CSS3, REST, SOAP, Ajax, JQuery, Java Script, Structure Map, NUnit, Mock, Angular, TFS, Agile, REST, SOAP, WCF, Boot Strapper, MVC, Ingrain, Web API
.Net Developer, 3M Jan 2014 – Oct 2015
Barracuda: Barracuda is a web-based map-centric and responsive modern software solution for Automatic License plate recognition. It allows the user to configure/manage devices, events, hotlists, dispatch, notifications & Alerts for comparing and get matched events by consuming from service bus
Responsibilities:
Worked on Agile Methodology which includes Daily scrums, Retrospective, planning and backlog grooming
Extensively used ASP.NET MVC for routing, unobtrusive validation and filtering
Created Areas and Razor Views as part of UI using ASP.NET MVC framework
Implemented Asynchronous communication to authorize client requests using AJAX
Implemented C# LINQ as part of business logic
Implemented Service Host Factory for hosting WCF services such as Notification, Dispatch and Hotlist events
Processed the matched Events using Multi-Threading concepts
Extensively used WEBAPI to communicate between external and internal services
JQuery is used to select the elements and add events to the elements at runtime.
JSON is used to serialize and De serialized the data received from WEBAPI
Implemented IOC dependency injection to resolve dependencies for Interfaces, classes
Made use of Silverlight to create a Rich UI
Boot Strap is extensively used to build responsive UI Design
Java Script is used to manipulate the DOM
Created unit test using Microsoft Unit Testing Framework
Implemented mock objects as part of unit tests using Just Mock Framework
TFS is used as a version control for code repository
Updated SSL certificates to access the application source
Windows Azure is used to deploy the application and manage roles of users
Environment:Asp.net MVC 5.0, C#, WEB API,LINQ,MS SQL Azure, Ajax, Razor View Engine, WCF, IIS, SOAP, REST, LINQ, IOC Repository, TDD, Microsoft Unit Test Framework, Just Mock, Service Bus, HTML5, CSS3,JQuery,JSON,TFS, Log4Net, Boot Strap, XML
Software Engineer, Visa Feb 2013 – Dec 2013
Request Management Portal: Designed and Developed Applications and Multipage Estimate Form for the service portfolio managers, and the factory team to provision servers. The form place holders allow adding servers, estimate, labor hours, Hardware Components necessary for funding. It provides action to provision and view estimate\offerings for requested items, and Export\Print grid in multiple formats.
Responsibilities:
Used agile methodology for developing enterprise applications.
Participated in all phases of application involving gathering business requirements, analyzing the data, design, develop, maintain, testing
Used DHTML to dynamically display and show the templates based on user assets
Used Angular JS to bind the data and filter the results to display on single page apps.
Mentored the Junior Developers in troubleshooting, creating patterns, UI bindings
Implemented client-side validations using ASP.NET4.5 Validation Controls
Used JavaScript to create Client-Side Dynamic content UI and ASP.NET 4.5 and C# to modify and Add Server Controls for Dynamic Server-Side Code.
WEBAPI is extensively used to push data from server side to client side based on user token
Java Script is used to manipulate the DOM
Used the Windows Azure to deploy and develop the web and worker Roles
JSON is used to consume the data as a string format in name/value format.
JQuery is used to toggle the styles between the html elements
Environment:.Net4.5, SQL 2010,CSS3, JQuery, ASP.Net4.5, Active Directory, Ajax, JSON, XML, REST, Java Script, data injection, MVC4, WEB API,, HTML5, JSON,OWIN, JQuery UI,SSL, Windows Azure, WEBAPI
Senior Software Developer, EMSI Health Insurance May 2012 – Feb 2013
EMSI Case Management: Built the quick spec enterprise software service for the EMSI. This provides the ability to do Auto/Manual diagnosis and the functionality to clear the requirements of outside order for several products such as EXAM, APS, and PHI. These diagnosis methods are used by various parties to generate quotes when billing Insurance companies for services based on order. Security was one of the features implemented for viewing quick spec pricing details for users during page load.
Responsibilities:
Worked with agile scrum methodology to develop project
Built and Consumed SOAP web services to get Insurance details by Patient ID
Created rich and interactive UI using WPF
Designed the interface using XAML with controls like Combo Box, Textbox, Label, Grid, and Group Box Controls.
WEBAPI is used to transfer the data between the client and services with RESTFULL Calls
Designed, Built custom wizard to show questions, answers with help of C#, XAML
JSON is used to GET and POST data to services.
Boot Strap is used to build a responsive UI Design
WCF Basic Http Binding is used to get billing, exam service details by passing carrier, DOB, Account Number arguments to functions.
CSS3 is extensively used to apply styles to all master pages
Designed and coded WPF components used to collect display and manipulate data.
Made use of OOPS concepts to implements business services by communicating with windows service communication foundation(WCF)
Security is wrapped around WPF grid, button, textbox, animation expander to validate if user has permission to view billing details
JQuery is used to remove the data by filtering the application on page.
JQuery UI is used to apply themes and made use of calendar control and popover
Windows Azure is used to apply the role for users based on permissions
Environment: XAML, WPF, WCF, SQL 2008, Telerik Rad Controls, Visual Studio 2010, C#, CSS, SOAP, Typescript, ERP,Node.JS,Silverlight,CSS3,WEBAPI, Windows Azure
E-Nation: This application is designed and implemented for Examiners and Branch Managers in order for them to process all the incoming orders, by updating their Customers personal details, Enter status for each orders, maintain discussions, notifications, Schedule for an appointment with the customer in order for them to go through the medical and physical examinations and based on the results the customer might be eligible for the Type of Insurances they are willing to apply for with the Insurance companies.
Responsibilities:
Was involved in designing, developing, testing phases of the SDLC on the application implementation.
Designed and developed UI layers using MVC ASP.Net 4.0 Razor Views using Visual Studio 2010 and .Net framework 4.
Built the logic for interacting with the WEBAPI using the Backbone
Used Require library to run the files on page load
Used MVC Telerik controls to design website.
Used agile methodology to implement various applications, and to do different sprints and also involved in daily scrum for everyday update.
Client side validations using JavaScript, JQUERY and also used MVC validations.
JQuery, Ajax functions to handle partial post backs in MVC applications.
Used CSS3 for style sheets, Master Pages for consistency, and User controls depending on the requirements.
OWIN is used to build the application and communicate with the services.
Used Web.Config to have some of the keys declared for the applications and hence used it in anywhere within the application, and also for maintaining authentication and authorization for many different users depending on their roles.
Tested application after integrating code with the existing one.
JQuery UI is used to apply themes and made use of calendar control and popover
Environment: MVC 3 Razor View, C# 4.0, .Net 4.0, Visual Studio 2010, JQuery, Ajax,SQL 2008, ADO.Net, Perforce, CSS3 Styles, REST, Web Services, Telerik RAD Controls, Backbone, Require, Handlebar, OWIN, JQuery UI
Senior Web Developer, Wells Fargo Mar 2011 – May 2012
Loss Mitigation Application: Designed, Developed, and Maintained the Loan modification program for Wells Fargo Mortgage. This system is designed to allow the borrowers with possible modification of their home mortgages. The manager, underwriter and Processors are given privileges to successfully qualify borrowers for loan modifications by verifying Income, validating all mod conditions are satisfied. This provides ability for users to generate letters for modified loans either manually or through Batch process. Designed the User interface using ASP.Net, HTML and C Sharp to implement logic for processing loans by interfacing with SQL server
Responsibilities:
Used agile development methodology for project process.
Used MVC Design Patterns to design and develop UI Layer with Visual Studio.Net 2010
Implemented the repository patterns to decouple the entity objects from UI layers
Created an instance of model to bind in controller to bind to user controls in code behind
Configure the Global. asax configuration file to route the incoming request to appropriate actions in controller
Created the folders for views, models, controller, and shared layout in solution.
Designed user interfaces using html5, CSS3, Adobe Photoshop CS5
Java Script is used to manipulate the HTML Elements
Called XML web services to retrieve, manipulate and update data accessing main frame
Wrote complex stored procedures, triggers, Queries and fine-tuned the database indexes using SQL
JSON is used to transfer the data between the client and server side
Created reusable classes to format and validate data on Client Side
JQuery UI is used to apply themes and made use of calendar control and popover
OAuth is used to authorize the users with external sites
OWIN is used to interact with the services from client side
Thoroughly tested various modules of the system and fixed the bugs.
Configured the Client application to reference the web services using Proxy Instance.
Boot Strap is used to build a responsive UI Design
Updated SSL certificates to access the application source
Windows Azure is used to deploy the application.
Environment: .Net 4.0, Visual Studio 2010, Java Script, HTML5, HTML, Web Services, SQL Server 2005, Ajax, C#, ASP.Net, SOAP, JSON, Java Script, JQuery UI, Boot Strap, SSL, Windows Azure
Web Developer, ST Aerospace San Antonio, L.P. Jan 2009- Mar 2011
Training Web Application: Built online training web application for training department. It provides users to access, view interfaces based on their membership (groups, roles) in active directory. Supervisors will be able to view and track training records for their employees and schedule classes through online intranet web application. Designed and developed application in visual studio 2008, SQL Server 2008 as back-end relational database, where asp.net used for designing user interfaces, C#.net to implement business logic by establishing connection with server side controls.
Responsibilities
Developed reports with SQL Server reporting services, Crystal reports
Used web services to connect with SQL Reporting services
Developed business objects using asp.net for various modules
Produced Requirements, High level design, Detail Design documents for customer portal
Created and deployed reports with business intelligence studio
Implemented ado.net to access and display results in report.
Environment: ASP. Net, SSRS, Visual Studio 2008, C#.Net, Java Script, ADO.NET, Visual Source Safe, SSRS, IIS, SQL Server, telerik.
Man Hour Clocking System: Designed and Developed Man Hour Clocking System application for Production Department. System provides choice for mechanics to clock-in and out jobs, where this data efficiently used by payroll to create pay check for every two weeks. This web application is completely built in visual studio 2008 with user interfaces designed in asp.net and vb.net for business logic, made use of SQL Server 2008 for saving the scanned jobs information in database.
Responsibilities
Actively participated in gathering requirements for application
Analyzed and Designed for creating the application
Applied different themes, CSS, XHTML to several pages in site for better look and feel
Written Common classes to share and ease of maintenance
Utilized visual source safe control for adding new/existing shared files and applications
Developed and maintain the application by using visual studio 2008.
Worked with the team to define, create tables, security permissions on database in SQL server 2008
Added the Contract Attributes for the functions to be shared between SOAP Service and Client
Environment: ASP. Net, C#, Java Script, ADO.NET, XML, XSL,Ajax, XSLT, HTML, CSS, Visual Studio 2008, Visual Source Safe, .Net Framework, IIS, SQL Server, SOAP.
.Net Developer, SAU Jan 07 – Dec 08
Description: Designed and developed an employment portal for Human Department. This portal provides students the ability to search for jobs, post resumes, and apply for open positions. This web application is built entirely in Visual Studio.Net 2005, using ASP.Net, C# and HTML technologies for the user interface and Microsoft SQL Server as the backend database. Responsible for designing, creating tables and stored procedures in SQL Server, and used ADO.Net to connect the web application with the database. Created a search engine to provide university faculty and staff the ability to search student skills that match their needs. ADO.Net and Grid view control have been extensively used to provide the web interface; normalized the SQL server database for fast data retrieval and created parameterized stored procedures to find and retrieve data based on the skills.
Responsibilities
Involved in Analysis, Design and Development of the application.
Wrote VB Script for user define functions in SSRS
Configured the report manager, report server to give permissions to different users in SSRS
Consumed the web services to marshal and un-marshal the objects passed as data sets between Services and client.
Developed modules of the application using ASP.NET, C# using Visual Studio 2005.
Created the user control to achieve the reusability of controls through out the application.
Extensively used AJAX to present a very intuitive user experience
Creating and consumed Web Services in C#.Net
Implemented Stored Procedures call in the business layer (ADO.Net) for use of Web layer.
Used ADO.NET objects (sqlConnection, sqlDataAdapter, sqlCommand, sqlDataReader and Dataset) to connect to SQL Server 2000.
Environment: ASP. Net, C#, Java Script, ADO.NET, XML, XSL, XSLT, HTML, CSS, VB Script,Visual Studio 2005, Visual Source Safe, .Net Framework, IIS, SQL Server, SSAS, SSRS, REST.
Web Developer, BE Soft Technologies Aug 2003 – Dec 2006
Attendance Analysis System: Developed an attendance analysis system to facilitate day-to-day handling of attendance process by the faculty of engineering colleges. The application keeps track of attendance of every student analyzes it and finally builds a Microsoft Office report. Web application was developed using Visual Studio 2003.
Responsibilities
Involved in the Analysis, design and architecture of the overall application.
Involved design and development of user interface forms using Win Forms
Developed tables, triggers and stored procedures, Packages in Oracle
Developed data access layer to interact with the database using ADO.NET.
Environment: Visual Studio 2003, C#.NET, IIS, ADO.NET, ASP.NET 1.1, HTML, JavaScript, CSS, ADO, COM, SQL Server, MS Access.
Education
M.S. Computer Science, Southern Arkansas University GPA: 3.5
B.Tech. Computer Science, JNTU, and India GPA: 3.6
Contact this candidate