Sql Server Web Services

Tulasi Kilaru

.NET Developer

Email : ******.*******@*****.*** Cell : 201-***-****

EXECUTIVE SUMMARY:

5+ years of experience in Software Design, Analysis, Development and Implementation of various Web Applications, Windows Applications and Client/Server applications using Microsoft Technologies.

Experience with the .Net Framework (4.0/3.5/3.0) in developing applications using C#, VB.NET, SQL-Server, ADO.NET and ASP.NET and .Net Core.

Extensively used the editors Visual Studio 2013/ 2015/2017 and Visual Source Safe and Team Foundation Server for version control.

Proficient in Object Oriented Design/Development (OOD), Model View Control (MVC), MVVM and Test-Driven Development (TDD).

Worked with Object Relational Mapping (ORM) by using ADO.NET Entity Framework and knowledge LINQ to SQL.

Experience in implementing in web based ASP.NET like Web Services, Windows Communication Foundation (WCF), Windows Service, WEB API, WPF to standardize the application architecture.

Work experience with Service-oriented architecture (SOA) for design principles used during the phases of systems development and integration in computing.

Solid Knowledge on Solid Object-Oriented Programming /Analysis and Design Concepts, Design Patterns, Data Structures and Software Development Life Cycle.

Proficient in creating and consuming Services and Endpoints using WCF, Good knowledge of Web Services SOAP and REST.

Excellent working experience in Object Oriented Programming methodology including concepts Encapsulation, Inheritance, Abstraction and Polymorphism.

Extensive working experience in Design Patterns,Data base design, Normalization and development for creating complex database queries, writing Constraints, Indexes, Views, Triggers, Joins, Stored Procedures and Functions using T-SQL and PL/SQL(Procedural Language/Structured Query Language) Functions and SSIS/DTS Packages in MS SQL Server.

Experience in all stages of Software development cycle(SDLC) using N-tier Architecture and different design patterns like MVC, MVVM and Dependency injection.

Experience in client side data bindings like jQuery, Kendo UI,AngularJS and creating Responsive web pages using Bootstrap framework and CSS3.

Experience in infrastructure provisioning tools like active Azure Active Directory in Microsoft Azure and PowerShell.

Working Knowledge on Patch management for production workstations for deploying operating systems updates in different environments.

Good experience in writing server side and client side validations using JavaScript and jQuery

Extensive experience in customization of Work Items, Transition Matrix in TFS.

Worked on Crystal Reports.

Experience in using ASP.NET Web applications involving User controls, Server controls, ASP.NET State Management.

Good understanding of Agile, Scrum, Waterfall methodologies.

Experienced in SQL Server Integration Services (SSIS) and SQL Server Reporting Service (SSRS) and used all types of transformations.

Strong ability to adapt and learn new technologies.

RELEVANT TECHNICAL SKILLS:

Languages

C#, T-SQL, PL/SQL.

Tools and IDE

Microsoft Visual Studio 2013/2015/2017

Web Technologies

ASP.Net, MVC 5 ADO.Net, WCF, WPF LINQ, HTML, CSS, XML, Bootstrap, Kendo UI.

Server Scripting

ASP.NET 3.5/4.0, PowerShell Scripting

Client Scripting

JavaScript, JQuery, Angular JS

Database

MS-SQL Server 2012/2014/2016, SQL Server Integration Services (SSIS).

Testing and Reporting

MS SQL Reporting Services, Crystal Reports

Versioning

MS-Team Foundation Server (TFS)

Operating Systems

Windows 2010/2008/7/Vista

Methodology

Agile, Scrum

Web Servers

IIS 7.5/7.0

PROFESSIONAL EXPERIENCE:

United Health Group, Ontario, CA June 2017 – Till Date

Full Stack. NET Developer

Description: UnitedHealth Group Inc. is a diversified managed health care company which is committed to introduce innovative approaches, products and services that can improve personal health programs. This Project is related to develop Web Applications using MVC architectural Pattern with Web Services to provide user friendly product. We used scrum Methodologies for smooth functioning software that meets development requirements.

Responsibilities:

Involved in Design, Development and Testing of web pages following ASP.NET MVC 5 architecture using .NET Framework.

Implemented MVC pattern to accomplish task of isolating Presentation Layer & Data Layer and designed it by using jQuery, JavaScript and WCF.

Used Ajax with MVC to retrieve data from server inorder to make Web Applications more responsive which improves user’s experience and used jQuery for performing Ajax calls in MVC.

Designed UI interfaces HTML, CSS, Kendo UI and involved in the design and development of the User Interface using ASP.NET MVC and WCF.

Used Kendo UI to provide visual charts and graphs of pertinent financial data utilizing Telerik Kendo UI user controls.

Used JavaScript extensively to enhance the UI and to make application looks more dynamic and to perform client-side validations.

Used Entity framework ORM at data access layer and developed Store procedures where complexity is high and executed using Entity framework.

Experience in working with Language Integrated Query(LINQ) especially LINQ to SQL

Developed classes and Provided support for consumed existing WCF services and worked on WCF Services using C# to authenticate lookup and retrieve the data from database.

Implemented WCF Web Services for publishing and consuming data successfully

Integrated workflow with SharePoint using to gauge the project's status and evaluate the business requirement documents and processes.

Used AJAX partial page updates and extensively used AJAX extenders with UI control elements.

Extensively used T-SQL, in writing database queries, constraints, views, joins and store procedures, XML data type in SQL Server programming.

Involved in Created and deployed the Windows Service for Emails and Implemented the Email utility using windows service and involved in Involving into Coding, Bug Fixing and Code Reviewing.

Used TFS for is used for source control, reporting, data collection and project tracking purposes.

Developed and worked with SAP Crystal reports.

Involved in Unit Testing and running the test case to proper functioning and for code coverage.

Actively Participated in requirement gathering, Design, Development of application.

Environment: .Net Framework, C#, ASP.Net, Visual Studio 2015/2017, SQL Server 2012, Entity Framework 6.1, LINQ, TFS, HTML, CSS, Java Script, jQuery, Kendo UI, Ajax, IIS, WCF Web Services, Crystal Reports.

Gilead Sciences, Foster City, CA Aug 2016 – April 2017

Full Stack .NET Developer

Description: Gilead Sciences, Inc. is a research-based biopharmaceutical company focused on the discovery, development, and commercialization of innovative medicines. Worked on design and development of MVC Web for drug interactions and discovery systems. It has developed a strategy that relies on collaboration in the commercialization and research sectors as well as acquisitions of smaller companies with promising products.

Responsibilities:

Involved in different phases of SDLC including Designing, Programming, Testing and Documentation.

Developed user interfaces using, ASP.Net, Web API Razor, Entity Framework 5.0 and Code Behind modules, interfacing routines and managed services also worked with Model View Controller MVC for created design pattern.

Used an Agile, Scrum approach methodology for software development.

Implemented ASP.NET MVC mechanism to display product Catalogs and categories and used built -in attribute routing that comes with MVC 5.

Worked on PowerShell for automating deployment. Used TFS for source control and bug

Tracking.

Used Restful Web API's to expose the analytics data to the clients and created message handlers in Web API to implement global level authentication.

Used WPF for rendering user interfaces in WinForms and implemented WPF in creating custom controls, 3D graphics.

Worked with SOA to make changes easier i.e. flexibility. Legacy architecture makes Rigid integration and saves time and money.

Used Microsoft Entity Framework Database First approach for the Data Access Layer.

Telerik controls and Kendo UI snippets were used for UI rich content and JSON based development work and Worked with the Kendo UI using Grid and Chart controls.

TDD was used for development due high necessity for bug free software.

Extensive experience with SQL, stored procedures, functions, triggers, relational modeling and design.

Experience in creating packages for ETL tasks using SSIS and designed reports using SSRS and deployed those to report server.

Used Tortoise (SVN) to check-in, check-out and merge files to avoid conflicts.

Performed NUnit Testing, Integration to find and fix the errors in the application code.

Used Silver light as a free plug-in, powered by the .NET framework and compatible with multiple browsers, devices and operating systems, bringing a new level of interactivity wherever the Web works.

Maintained good working relationships with internal support teams and Client.

Environment: MVC5, ASP.NET Framework 4.5, VisualStudio2015, LINQ, Razor 3.0, PowerShell, TDD, WPF, Web API, TDD, Web Services, EntityFramework6, Ajax, JavaScript, jQuery, Angular 2, Bootstrap, HTML5, HTML CSS3, CSS, DOM, CMS, SOAP, SQL Server 2014, TFS 2012 Nunit.

Cast Light Healthcare, Manhattan, NY Jan 2015 - July 2016

Full Stack .Net Developer

Description: Castlight Health Group is one of the nation’s major managed health care companies which offers a classified products and services. Castlight Health was developed in the year 2008, this company had long-time reaching to alter healthcare in the United States. It enables employers to deliver best benefits to people for taking better healthcare decisions. The project was about to design and develop the data model and to increase performance by writing different kinds of queries. And a health benefit program engages employees to make better healthcare decisions.

Responsibilities:

Involved in Design and Developing components of this application using ASP.NET, WEB API, C# .NET, JavaScript, XSLT.

Experience in creating and using WinForms to create functionality in networking module.

Involved in the iterative process of developing in Agile and Scrum environment.

Application components are developed in an agile environment utilizing a test driven development approach.

Developed Single Page Application SPA apps for a cross-platform JavaScript based solution using AngularJS1.1.0, NodeJS and Bootstrap.

Knowledge of using Continuous Integration / Continuous Deployment (CI-CD) tools as Jenkins.

Created, customized, SharePoint Portal Sites, updated content, and created custom navigation i.e. structuring document folders, quick launch etc.

Built product catalog using elastic search and Nest API for search feature.

Developed complex UI using HTML5, JavaScriptCSS3, Bootstrap.

Used JQuery, JSON for performing Ajax calls and manipulating DOM objects.

Developed Business layer with C# using dependency injection pattern using N inject.

Experience in working with web services and windows communication foundation (WCF) based on SOAP/ JSON and provided support and consumed existing WCF services.

Integrated Azure Active Directory for all user authentication/authorization and organization profiles.

Created a script to add indexes to SQL Azure tables.

Developed Store procedures where complexity is high and executed using Entity framework and also used it as object relational mapper for data access layer.

Implemented LINQ for querying, sorting, filtering the complex objects.

Created Web Services (SOAP, WSDL) for communicating with other application and component.

Involved in testing the web services of REST and SAOP services

Actively Participated in requirement gathering, Design, Development of application.

Created Stored Procedures and triggers for complex business rules and eextensively used T-SQL, XML data type in SQL Server programming.

Experience migrating from GIT-Hub to GIT and also used for source code management

Designed and Implemented SSIS package to extract, transform and Load (ETL) data operations from multiple heterogeneous systems to SQL Server.

Designed reports using Report Wizard, SQL Server Reporting Service (SSRS) and deployed those to web portal.

Written N Units and tested it with Test Drive Development (TDD).

Created test cases for Unit Test and prepared technical design documents.

Developed Business Object Universe and universe queries.

Environment .Net Framework 4.0, C#, ASP.Net, Visual Studio 2010, SQL Server 2008 R2, TDD, ADO.NET, WinForms, CSS, Java Script, Angular JS, IIS, HTML/DHTML, WCF Web Services, MS Azure,

AJAX.

Mattress Firm, Houston, TX Aug 2013 - Dec 2013

.Net Developer

Description: Mattress Firm has the largest geographic footprint in the United States among multi-brand mattress retailers. It focuses on a unique shopping experience for the customer with a large selection of quality brand name mattresses, beds and bedding products. This project is salesbased retailing business, which involved in designing using C#, ADO.NET, ASP.NET, JQUERY & SQL SERVER.

Responsibilities:

Involved in gathering information from clients and analyzed the information and provided with the best solutions which meet client's requirements.

Used classic ASP, ASP.NET 3.5 for developing the presentation layer components.

Thoroughly enforced page validation and client side and server-side validations using ASP.Net Validation controls.

Developed an intranet application for business users that is used to maintain and support as per business requirement.

Involved in application design based on MVVM, and OOPs concepts on WPF and Silverlight platforms.

Worked with CRM to manage and analyze customer interactions and data throughout the customer lifecycle, with the goal of improving business relationships with customers, assisting in customer retention and driving sales growth.

Involved in working with Windows PowerShell for task automation and Management.

Involved in developing single page application structure with multiple modules using AngularJS.

Used ADO.Net technology extensively for data retrieving, querying storage and manipulation.

Used the objects in ADO.Net like Datasets and Data readers for retrieving the data form database.

All the classes developed were useful in providing the functionality of Data Layer and thereby giving access to the Database.

Have written Stored Procedures for performance optimization and other database operations such as Complex SQL queries, views and triggers etc.

Developed crystal reports from the analysis and are displayed in the form of graphs using fusion charts.

Implemented the business logic by developing new Assemblies using C#.NET.

Used TFS (Team Foundation Server) for version controlling and used TDD for testing.

Creating Web.Config files for setting up the application by writing database connections.

Performed integration testing and system testing and obtained results with minimal defects.

Involved in debugging and fixing the bugs in the application.

Environment: C#.Net, ASP.NET 3.5, ADO.NET, VB Script, HTML, jQuery, SQL Server 2005, Windows Server 2008 and TFS.

HDFC Bank, India Sep 2012 - June 2013

.Net Developer

Description: HDFC bank limited is an Indian banking and financial service company that offers a wide range of banking and financial services to retail customers and corporates through a wide variety of delivery channels. HDFC bank is the preferred NRI banking service provider in India. Our global network of correspondent banks to wide range of remittance options empowers to remit money to India from anywhere and our robust technologies framework allows banking without visiting the branch.

Responsibilities:

Developing Application with UI, Business and Data Access layers using ASP.NET and C#.NET from Scratch and implemented the project using MVVM pattern.

Designing and developing different modules using C#, ASP.NET and Sql Server.

Designing and Developing User Control pages.

Used ADO.Net technologies to access data from SQL Server database.

Creating Complex stored procedures, tables for both Application and Reports.

Consuming and processing Web services data.

Used Reflection software to interact with Main Frame.

Providing UAT and Production support for applications to fix defects.

Used grid views to retrieve and display data in the required format.

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

Used Java script for Client and server-side interaction and for other custom functionalities.

Designed web forms by implementing CSS, XML,HTML and JavaScript.

Created User Controls for the header and footer of the website which appears in all the pages.

Worked extensively on web forms and data binding controls like data list and drop down boxes.

Used pagination and sorting features of data grid in reports.

Environment: .NET Framework 2.0 & 4.0, ASP.NET2.0 & 4.0, C#, AJAX, HTML, JavaScript, Sql Server 2008, Visual Studio 2005 & 2010, Tortoise SVN, Reflection Work Space, Crystal Reports 2010.

Contact this candidate