Sql Server .Net

Professional Summary:

•Over *+ years of progressive technical and functional experience specializing in analysis, design and development of Internet, Intranet, Client Server and Object Oriented applications built on Microsoft related Technologies with Visual Studio, .Net, C#

•Developing applications leveraging ADO.NET, Entity Framework, and the Microsoft Enterprise Library Application Blocks.

•BuildingwebapplicationswithASP.NETMVC,Telerik Kendo UIJavaScript,jQuery,JSON,HTML,XHTML,CSS,andFirebug.

•Demonstrated proficiency in development using Microsoft.NET technologies like WCF, LINQ, ASP.Net 4.0/3.5, ASP.NET MVC 4.0/3.0, C# (4.0/3.5), AJAX Extensions, Angular JS, JQUERY with MS SQL Server (SQL 2008 R2 / 2005) and Oracle 10g/9i as database.

•Experience in development and implementation of Windows Communication Foundation (WCF),andalso responsible for developing services with versioning, interoperability, security and hosting.

•Experience in development and implementation of Windows Desktop Servicesandalso responsible for creating executables and deploy on servers

•Experience in using AJAX with Angular JS/JQuery for quickly creating efficient and interactive Web applications/Single Page Applications that work across all popular browsers.

•Extensive working experience ASP.NET MVC Framework 3.0 implemented Controller, Controller Actions and Views, Partial Views, Strongly Typed Views and View Models.

•Experience in database related work primarily creating complex stored procedure, Views, Triggers, Functions, using PL/SQL, T-SQL.

•Performance tuning the SSIS Packages by understanding the Data Flow Buffers and deploying them on respective server and effectively using configuration files for using same packages on other environments. Scheduling the SSIS packages by creating a Job using SQL Agent in SSMS which involves nightly maintenance.

•Expertise in model the application's design and functionality using Visio and Unified Modeling Language (UML).

•Very good experience with Reporting Tools SQL Server Reporting Services (SSRS) and Crystal Reports.

•ExperiencedinConfigurationManagement,settingupcompanyVersionpolicies,buildscheduleusingTeam Foundation Server 2010 and Visual Source Safe (VSS), Perforce.

•ExcellentWritten,AnalyticalSkills,VerbalCommunicationskillswithacustomerserviceorientedattitudeand worked with the offshore team as onsite coordinator to provide the update on the daily basis.

Willing to relocate: Anywhere

Authorized to work in the US for any employer

WORK EXPERIENCE

Sr. .Net Developer

KBR GLOBAL IT SOLUTIONS - American Express - Phoenix, AZ -January 2015 to Present

American Express Company is a global travel, financial and network service provider. Founded in 1850, the company provides individuals with charge and credit cards, Travelers Cheques and other stored value products. It also offers financial planning, brokerage services, mutual funds, insurance and other investment products.

Responsibilities:

•Gathered User Requirements that included identifying the use cases and its surroundings.

•Assisted the new hires in explaining the prototype application overview, functionality and preparedtechnical training documents.

•Worked on Agile Methodology to meet timelines with quality deliverables.

•Experience using Infragistics web controls.

•DesigneduserinterfaceforwebformsusingASP.NETMVCandimplementedbusinesslogicusingC#.NET.

•Developed dynamic ASPX pages for Application using ASP.NET MVC, C#.NET and HTML.

•Worked with ASP.NET MVC 3.0, Partial Views, and Master Pages and developed Cascading style sheets (CSS) for consistent look and feel of the website.

•Used JavaScript to perform validations and catch the events on client's browser.

•Designed large numbers of WPF Forms, Custom Controls and User Controls using XAML language for UI

•Used Web Services (SOAP, WSDL) for communicating with other application and components.

•Used ASP.NET MVC Data annotations and Javascript to do validations on the Model Data.

•Deal with ASP.NET server side state management features such as application state, session state and profile properties using C#.NET.

•Used Windows Communication Foundation (WCF) in a self-hosting mechanism, implementing the Service- OrientedArchitecture(SOA)usingtheRESTmethodology,toSOAPmessagesbetweenmetadataendpoints.

•Experience in working with LINQ to Datasets, which uses ADO.Net to handle the communication with the database.

•Extensively worked with LINQ provider and designed the user level application which will build and execute a query expression for Server Side.

•InvolvedinbuildingarichViewinMVCapplicationusingJqueryGrid,ModalPopUpandmanyothercontrols with Paging and Sorting for displaying various data on to the page.

•Bootstrap framework is used to develop front facing web application.

•Extensively used Report Wizard, Report Builder and Report Manager and deploying reports in SQL Server Reporting Services (SSRS).

•Written SQL Queries, Stored Procedures, Triggers in SQL Server 2008 using T-SQL.

•Used Microsoft Team Foundation Server (TFS) for the purpose of version Control and source code maintenance needs.

•Involved in Unit testing, Modular testing, Regression Testing and successful integration of modules and multiple layers in the system.

ENVIRONMENT:.NETFramework4.5,C#.NET,VisualStudio2013/2010,SQLServer2008R2,Infragistics, ADO.NET,JavaScript,HTML,LINQ,T-SQL,IIS7.0,ASP.NETMVC3,WPF,WCF,Webservices,WSDL,

SOAP, REST, JQuery, AJAX, CSS, Telerik, Bootstrap, XML, SSRS, TFS, Windows 2008 Server

Sr. .Net Developer

TCS -PricewaterhouseCoopers-Banglore, India - Oct 2013 to Dec 2014

PriewaterhouseCoopers is a multinational professional services network. PwC is organized into three service lines Assurance, Advisory, Tax.

Responsibilities:

•Involved in understanding and transmitting the business requirements for the project, and translating these into functional specifications

•Developing deployable components into test environment which can be consumed by the power shellscript writers to test the SEP and SEP Manager.

•Designing the interfaces/classes for communication between Java/C++ and C#.

•Developed XML web services and consumed in the application for setting and retrieving the settings from manager to client.

•Developed Views, Stored Procedures, for retrieving data from logs.

•InvolvedindevelopingthenewmodifiedbusinessrequirementsanddesignoftheEntityRelationaldiagrams, sequence diagrams and state diagrams for architecture design and activity description using UML.

•Power GUI is used to write the power shell test scripts for unit testing the developed modules.

•Perforce has used for all the source code maintenance among the entire geo-graphic wide spread team members.

•Collaborator has used for all the code reviews.

Environment: .Net framework 4.0/4.5, Visual Studio 2012, C#, SOAP, Java, C++, Power Shell, SQL Server 2008 R2, Perforce, Collaborator, VM Ware, Power GUI, Saturn (Symantec BTM product).

Sr. .Net Developer

TCS - Liberty Mutual Insurance - Dover, NH -Oct 2011 to Sept 2013

Liberty Mutual Insurance, is an American diversified global insurer, and the second largest property and casualty insurer in the United States. The company offers a wide range of insurance products and services, including personal & commercial automobile, homeowners, fire and surety.

Responsibilities:

•InvolvedinobjectorientedanalysisanddesignusingUML(UnifiedModelingLanguage)techniquessuchas use case, activity, sequence, class and component diagrams using Microsoft Visio.

•Developed the application in 3-Tier architecture, UI Layer, Business Logic Layer and Data Access Layer using C#, ASP.Net, and JavaScript with Sql Server 2008 R2 as the back end.

•Developed and consumed WCF services for getting Commercial insurance premium quotes, Auto Supplement Rate quotes, county codes etc.

•DesignedanddevelopedreportsusingSQLServerReportingServicesforCIMSmodulesthataredesigned to take parameters for query, export into PDF/Excel/Txt formats.

•Implemented Multi-Threading and Asynchronous WCF service calls to improve the performance of the application.

•Used LINQ to Objects, LINQ to SQL to manage, query, and order the list of contacts maintained by the application.

•Developed tables, stored procedures, views, functions and triggers to perform automated rules, updating to related tables in Sql server 2005.

•Implemented GUI using HTML5, TELERIK Controls, CSS and Web Form Controls to create web pages, developed Master Pages, user controls for reuse. Used Ajax Control Toolkit extensively for developing asynchronous and more dynamic parts in the application.

•Performed Code Reviews (manual) to implement performance and coding conventions guidelines.

Environment: .Net framework 4.0, Visual Studio 2010, C#, ASP.NET 3.5, ADO.NET, Sql Server 2008 R2, AJAX Control Toolkit, XML, XSL/XSLT, WCF, JavaScript, TELERIK Controls, Web Forms, HTML, CSS, MS Visio, NUnit, SQL Server Reporting Services, Team Foundation Server (TFS)

Sr. .Net Developer

Satyam Computers - United Health Group - Chicago, IL -Nov2010 to Oct 2011

UnitedHealthGroupanditsaffiliatedcompanieshaveledthemarketplacebyintroducingkeyinnovationsthat health care services more accessible and affordable for customers, improve the quality and coordination of health care services, and help individuals and their physicians make more informed health care decisions.

Responsibilities:

•Developed UI using WPF for the project.

•Involved in binding of the controls with the functionalities.

•Used MVM (Model View Model) architecture to develop the project.

•Involved project meetings of architecting / designing based on the module requirements.

•Configured Internet Information server (IIS) for web services.

•Used "Agile" methodology for the project which involved daily scrums and bi-weekly sprints.

•Developed Custom user controls which are used across the project.

•Performed Unit testing according to the test cases for the modules.

•Assistedinqualityassurancemeasuressuchascodereviews,testcasecreationandunittestingfordifferent modules

•Involved in gathering project requirements and documenting design specifications.

•Involved in LINQ to SQL and object queries using LINQ.

•Involved in implementing WCF services using SOA architecture to talk to different services and get data.

•Involved in solving technical queries and complex business requirements as per Change Requests.

•Involved in writing some stores procedures.

•Used TFS as central repository system.

•Coordinated with QA team during QA and Preproduction testing process for the project.

Environment:.NetFramework3.5,VisualStudio2008,WPF,C#.NET,ASP.NET3.5,HTML,WCF,LINQ,SQL Server 2008, T-SQL, XML, HTML, Java Script, CSS, IIS 6.0, NUNIT, Web Services.

Net Programmer

Satyam Computers - State Bank of India - IN -March 2009 to Nov 2010

State Bank of India is an Indian multinational, Public sector banking and financial services company. It is a government-owned corporation with its headquarters in Mumbai, Maharashtra.

Responsibilities:

•Involved in Requirements Collection, Design, Analysis, Development and Customization of theApplication.

•Involved in user and technical documentation.

•Designed and developed components using C# and .Net framework classes.

•Developed Front End UI screens using Web Forms.

•Used Web Forms and Server controls in ASP.NET.

•Involved in implementing object oriented programming techniques

•Developed connectivity to RDBMS using ADO.NET datasets.

•Developed stored procedures and wrote cursors and Triggers.

•Involved in report generation using SSRS.

•Implemented parameterized functions, procedures and invoking events

•Dealt with various SQL Server issues e.g. creating tables and relation between the tables, adding, updating and deleting the data in the tables and also developed complex stored procedures, functions, packages.

•Developed code for data access routines in ADO.NET, which involved data manipulation with DataReader, Connection collection, arrays, transaction processing and exception handling.

•Created View for fast retrieval and used ADO.net to access the views.

•Extensively used UML for designing.

•Wrote server side validation function for custom validation control.

Environment:NetFramework2.0,VisualStudio2005,C#,ASP.NET2.0,SSRS,ADO.NET,SQLServer2005, Java Script, CSS, XML, UML, IIS.

ADDITIONAL INFORMATION TECHNICAL SKILLS

Programming Languages C++, HTML, T-Sql, PL/SQL

Web Technologies

ASP.NET,ASP.NETMVC4.0/3.0,ASP.NetAjax3.0/2.0,Javascript,Jquery,AngularJS,VBScript,Web Services, IIS.

UI Technologies Winforms,WPF, Jquery UI

IDE Tools Visual,Sql Server Management Studio,Expression

.Net Frameworks .Net Framework Databases MS SQL SERVER 2008, Oracle 10g/9i/8i

Reporting Tool Sql Server Reporting Services (SSRS, Crystal Reports Modeling Tools UML,MS Visio

Version Control Tools Visual SourceSafe(2005), SubVersion, Team Foundation Server(2008) Middleware WCF, ADO.NET, WebServices,Enterprise Library

Servers Windows Server Microsoft

Education:

Bachelor of Engineering from INDIA

Contact this candidate