Sql Server .Net

Location:

Atlanta, GA

Posted:

September 04, 2016

Contact this candidate

Resume:

Satish Reddy K

404-***-****

*******.************@*****.***

.Net Developer

Professional Summary

6+ years of experience in Analysis, Design, Development, Implementation, Deployment and testing of Client/Server, windows and web applications using .Net framework 4.5/4.0/3.5/3.0 implementing object oriented principles with proficiency in all stages of SDLC.

Expertise in various Microsoft technologies using Microsoft Technologies including ASP.NET 4.5/4.0/3.5/3.0, MVC, .NET Framework 4.5/4.0/3.5/3.0, AJAX, VB.NET, C#, Java Script, JQuery, ADO.NET, VB6, Classic ASP, Crystal Reports, SQL Server reporting services (SSRS), WCF, IIS 5.0/6.0/7.0, Web services, CSS, HTML, XML, Oracle, SQL 2012/2008/2005.

Have experience implementing Service Oriented Architecture (SOA) with WCF Services, Restful services and Web Services using SOAP, WSDL.

Strong in Agile/Scrum software development, waterfall and Test Driven Development.

Experience using VSS, TFS and SVN for version Control.

Extensive experience in object oriented programming (OOPS), SQL, WPF.

Designed and implemented the N-tier application using C#.net.

Good working experience on LINQ to Objects, LINQ to SQL, LINQ to XML and MVVM framework

Excellent knowledge in Object Oriented analysis and design (OOAD), Service Oriented Architecture (SOA) and Model-View-Controller Architectures (MVC).

Developed applications using WPF, Infragistics, Autofac, Telerik and DevExpress.

Experience in converting/rewriting applications from old .net frameworks like 1.1/2.0 to new .net frameworks like 4.0/4.5.

Also worked as a windows application developer in using Win Forms, Timers, etc. and in creating Windows Services as scheduled jobs.

Extensively worked in writing SQL Queries, stored procedures, Tables, database triggers, cursors, exception handlers, DTS Export & Import.

Experience working in an agile development environment. Migrated web applications into the Sitecore CMS System.

Good knowledge of database design, database creation, back up and restoring, Tables Creation, Stored Procedures, Views, Triggers, Functions, SSIS, SSRS, SSAS and Programming Experience using SQL server 2010/08/05.

Experience in data accessing using ADO.net, Power Pivot T-SQL, LINQ (Language Integrated Query) for data manipulation.

Experience in using Server controls, User controls, Custom controls, HTML controls and Ajax toolkit controls in designing ASP.net web forms.

Strong expertise in developing reports using crystal reports. Strong experience in developing Web services and WCF.

Experience in maintenance/bug fixing in windows and web based applications.

Hands on experience on version control tools like Team Foundation Server and Rational Clear Case.

Adapted in changing technical environments with strong organizational and analytical skills.

Excellent communication and presentation skills.

Ability to work in groups as well as independently and a constant learner.

Expertise in writing unit test cases using NUnit and MSTEST frameworks.

Expertise in designing CSS style sheets for different browsers and well aware of UML diagrams.

Good at analysis, strong interpersonal, analytical and organizational skills with an ability to manage multiple projects with minimal or no supervision.

Technical Skills:

Languages

ASP.NET, VB.NET, C#, T- SQL, PL/SQL, HTML-5, UML, XML.

RDBMS

Oracle 7i/8i/9i/10g, MS Access 2003/2007, MS SQL Server2000/2005/2008/2012.

Methodologies

Agile, Scrum, Test Driven Development (TDD) and Waterfall.

Scripting Language

JavaScript, JQuery, VB Script, DHTML/HTML, CSS, XML, and JSON, Angular JS.

Web Services

XML (XSL/XSLT), SOAP, WSDL, UDDI, HTTP, WCF.

Version Control Tools

VSS, SVN, TFS.

Reporting Tool

Crystal Reports, SSRS (SQL Server Reporting Services), SSIS, SSA.

Networking

TCP/IP, UDP, SNMP, SMTP

Testing Tools

Manual Testing, NUnit Testing.

Development Tools

Visual Studio.NET 2013/2012/2010/2008, SQL Server Management Studio, MS Visio, Adobe Photoshop.

Operating Systems

Windows 2003/XP/Vista/7/8/10.

Professional Experience:

Client: Home site Insurance-Boston, MA Mar'2015 – Till Date

Sr.Net Developer

Description: Home site Insurance Company retrieves data regarding the homeowners, renters and condominium insurance nationwide. Based on this data Home Site Insurance Company visualizes the growth of their customers in various insurance policies and plan accordingly to increase the sales growth.

Responsibilities:

Extended ASP.NET, MVC 3 application by creating Views, Controller actions and Model classes.

Used Microsoft Entity Framework Code First approach for the Data Access Layer and defined entities that are used for data access MVC application.

Used C#.NET as language to develop code behind business logic.

Designed UI screens for accessing product details, comparisons, client details and monitoring sales and promotional activities and wrote jQuery functions for client side validation.

Developed User Interface (UI) using WPF for the better look and feel of the desktop-based application.

Developed the WPF application in PRISM framework, thus creating loosely coupled components for the application.

Worked on Multi-Asset Class Strategies(MACS)

Used jQuery UI API for the animation and UI development of ASP.NET MVC 3 application.

Performed integration of application environment and source code management to enhance error free processing of BizTalk server

Wrote Stored Procedures, Triggers and SQL Queries in SQL Server 2008.

Developed and consumed WCF Web Service to access data layer components.

Implemented Authentication and Authorization using Web.Config file. Configured for users Authorization and role based security

Applied Themes and CSS styles for UI design of WebPages and Used Ajax and JavaScript to minimize number of Page Refresh.

Involved in the design of the Use Case Diagrams and class diagrams using Microsoft Visio.

Reworked on a part of the GUIs to improve interface without affecting the performance of the application.

Used XML for data storage and XSLT to transform the SQL queries returned as XML nodes.

Used SOAP protocol to transfer the XML based message such as applicant's requests and loan information over computer networks.

Involved in Outlook Plugin Development.

Generated customized reports using Crystal Reporting tool.

Used object oriented analysis design (OOAD).

Added functionality into GUI where Admin can select different database records and export them to Microsoft Excel.

Extensively used SSIS to create packages to move data from a single data source to a destination

Created Weekly and Monthly reports in SQL Server Reporting Service. Used CVS as a central repository and source code control

Participated in meetings with Business users and with other project teams to ensure that the volatile business requirements reflect in the project development.

Environment: ASP.Net 4.0, C#, Entity Framework 4.1, Visual Studio 2008/2010, MVC 3, jQuery, AJAX, SQL Server 2008, Silverlight, SSRS, SSIS, Web Services, WPF, WCF, XML, Angular JS.

General Motors, Detroit, MI Jan’14 – Feb’15

Sr.Net Developer

General Motors is a global automotive company united by a single purpose to earn customers for life. General Motors technology has always been on the forefront, we continue to excel in development and strive to push exciting advancements in alternative energy and purposeful vehicle design. We consistently adopt policies and develop technologies that promote a cleaner planet from supply chain to manufacturing vehicles to put on the road.

Responsibilities:

Involved with the client team to design and develop the application according to client requirement using WCF, SOA, and ASP.NET with the business logic implemented using C#.

Involved in projecting Flow Diagrams and business processes also documenting every stage of SDLC.

Configured the VS.NET environment, IIS Server 6.0

Used ADO.NET objects to retrieve and update data to the database

Used Object Oriented Programming (OOP) to make it more efficient

Created ASP.NET web pages that provide new features and enhanced user experience

Involved in creating new web forms

Used C#.NET to write server-side code for the user interfaces.

Front-end application was designed in Silver light along with Rad Controls for Bayer Health Care

Implemented Data Annotations for Silver Light Validation to avoid data entry error.

Created Tables, Views and Stored Procedures in SQL Server 2005

Implemented Identity-aware applications using Windows Identity foundation(WIF)

Used ASP.NET to create pages for reporting and used RESTful Services

Implemented Microsoft Enterprise Library to connect to SQL server database with Silver Light Enabled WCF Service for retrieving, manipulating, querying, storing data from the database with the Silver light module.

Performed Windows Service.

Design and Implement WCF services layer hosted on Windows Azure.

Designed and Developed Web Services using Visual C#.net, XML web services SOAP Extension.

Designed user interface screens using user controls and Web forms. Designed and developed Custom controls to use with web forms using WPF, infragistics controls, Dev Express.

Created a unit which automatically refreshes particular part of page using AJAX

Unit testing of all developed pages and modules

Environment: Visual Studio, ASP.NET, ADO.NET, C#, XML, IIS, JavaScript, Ajax, CSS, Master Pages, VSS, Unit Testing, SQL Server 2008, Silverlight, WCF, WPF, Angular JS.

Hilton Worldwide Brands, Plano, TX Jun’13 - Dec’14

Role: Senior Programmer Analyst

Project Description: On Q Property Management system is the room reservation system used by Hotel users at each property. This is a VB6 application. My contract was mainly to support this application and helping in rewriting of this application in .NET. It consists of several modules like Guest reservations, House Accounts, Group Master, etc. Involved in writing custom management application which allows hotel users to setup their environment.

Responsibilities:

Followed Scrum methodology with a sprint of 2 weeks, involved in daily stand-up meetings.

Involved in task estimates by playing Poker in Scrum.

Maintained and added new enhancements to existing VB6 application as per hotel user’s requirement.

Involved in writing custom management application which allows hotel users to setup their environment.

Wrote application using Web API to talk to external applications and also involved in writing small ASP.NET Web Forms applications with VB.NET, C# as programming languages.

Wrote CCAMS windows services for handling credit card transactions to stick for PCI compliance.

Involved in re-architecting the application with a cloud concept and moved few properties into this architecture which was a huge success.

Created and consumed WCF services, RESTFUL services. Tested these services using SOAP UI and Web Service Studio.

Used MSTest as a Unit testing framework before making a check-in.

Used COM interoperability for interaction between COM objects and .NET objects.

Used SQL Server as backend database and worked in modifying, writing new stored procedures, views and user defined functions.

Worked with multiple databases in multiple applications.

Wrote Powershell scripts for deploying code and registering OCX, DLL, etc.

Used SVN Tortoise tool for version controlling and used it as a document collaboration tool too.

Used Quality Center as a defect tracking tool and followed defect life cycle as per QA team.

Environment: Visual Studio.Net 2013, ASP.NET, VB6, VB.NET, C#, Web API, WCF, RESTFUL Services, SQL Server 2008, SOAP UI, Web Service Studio, SVN, Agile/Scrum, Angular JS, Powershell, Quality Center, Windows Server 2012.

Bayer Health Care, Morristown, NJ Oct’12 - May’13

Role: .Net Developer

Project: Event Registration

Bayer is focused health care company and provides diabetes care. Event Registration application allows all employees to view and register for events and access personal profile information online. Re-Designed and re-write the user interface of an intranet web-based work flow application.