Sign in

Sql Server Web Services

April 14, 2016

Contact this candidate





Around 8+ years of experience in Analysis, Design, Development of application using Microsoft .Net technologies which include ASP.NET, ADO.NET, XML, XHTML, JavaScript, Angular JS, Web Services, MVC, SPA etc.

Hands-on experience in developing Web Applications.

Knowledgeable in all phases of Software Development Life Cycle (SDLC) include designing, development, coding, debugging, testing, implementation and maintenance of software.

Experienced with ASP.NET and its components: AJAX, Entity Framework and LINQ to SQL.

Experience with developing web application by using the Model View Controller (MVC) Pattern.

Extensively used Windows Communication Foundation (WCF) and Web services for Web applications using SOAP, WSDL and UDDI.

Experience in writing SQL statements, stored procedures, Functions, Views, and Triggers of SQL Server and MYSQL database.

Worked on Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

Also experienced with creating master pages, validation control, user controls, customized controls and JavaScript.

Good experience in deploying and testing web applications on IIS 5.0/6.0.

Also used AccuRev, Tortoise SVN and Team Foundation Server (TFS) for source control.

Experience in analytical and technical skills and developing systems using different software methodologies like Agile (Scrum) and Waterfall.

Also have knowledge about IOS applications (IPhone & I Pad).

Excellent understanding of system development methodologies, strong problem solving skills and a flexible team player.

Demonstrated successful technical details and good communication skills with clients.


Operating System:

MSDOS, Windows, Mac OSX

Programming Skills:

C, Objective C, C#, HTML, XHTML, CSS, JavaScript,

AJAX, Web Services, T-SQL, XML

Web Technologies:

ASP.NET 3.0/3.5/4.0/4.5, WinForms, Ajax, WSDL, MVC 4, SPA, WCF.


MS SQL Server 2008 R2/2010/2012, MS Access, MS Excel 2010,MesaSQLite 3.2.6,MySQL Workbench 5.2

Developer Tools:

Telerik RadControls


Visual Studio 2008/2010/2012/2013

Source Control Tools:

Visual Studio Team Foundation Server, AccuRev, Rally, Tortoise SVN 1.8.11.

Application Software:

MS Office, Dreamweaver, MS FrontPage


Costco Wholesale - Issaquah, WA

Dot Net Developer Sept 2015 - Till date

With hundreds of locations worldwide, Costco is a membership warehouse club which provides a wide selection of merchandise, plus the convenience of specialty departments and exclusive member services, all designed to make shopping experience a pleasurable one. Costco - Tokenization Project main goal is to make respective changes on Order Management System (OMS) such that no sensitive information is stored on the application to meet PCI compliance.


Order Management System (OMS) is a Windows Form application developed using C# as programming language.

Involved and worked on enhancements on functionalities to avoid storing any sensitive information on OMS application.

Instrumental in avoiding storing of credit card numbers and other privacy/sensitive information in databases.

Worked on several SQL Scripts to CRUD a database table.

Replaced the storing of privacy information with the use of tokenization process (TNSPayment Gateway) throughout the application.

Developed, verified (SoapUI) and utilized number of web services to work with tokenization process.

Performed impact analysis to study the different impact areas (UI/Database/WebServices changes).

Planned, coordinated and supervised the tasks with offshore team (6 developers) and completed the different impact areas.

Used Agile methodologies for team collaboration and for project work flow.

Environment: Visual Studio 2012, SQL Server 2008, WinForms, C#, JavaScript, Bootstrap, Angular JS, SPA, Tortoise SVN 1.8.11, SOAP UI 5.2.0, Beyond Compare.

Symetra – Bellevue, WA

Dot Net Developer March 2015 - Sept 2015

Symetra is a United States-based family of companies providing retirement plans, employee benefits, annuities and life insurance through independent distributors nationwide. The project, I am working is NBI (New Business Implementation) is an easy to use, web-based and integrated application to replace the current tool, Implementation Record and Checklist. Thereby enabling an efficient implementation process and establishing a positive first impression with new customers.


Responsible for understanding the requirements and developing the project for desired output.

NBI is developed on MVC 4 architecture.

Developed and worked on various UI pages, core logic on controller, models, web services and entity framework based on requirements.

Worked on several SQL Scripts to CRUD a database table.

Also tested all web services and other methods using NUnit Framework.

Worked on EXCEL sheets to create a template for customer output which enable to print the data extracted.

Involved in Agile (Scrum) Methodologies for teams collaboration, self-management and flexibility to adapt to emerging business realities.

Scrum Sprints lasted for two weeks long (9 days) and as part of methodology attended Planning, Pre-planning and Daily Scrum meetings for every Sprint.

Environment: .Net Frame Work 4.0/4.5,Visual Studio 2013, SQL Server 2008 R2, Reshaper 9.1, AccuRev 4.9.1, Agile/Scrum, Rally, NUnit Framework, EXCEL 2010, ASP.NET, C#, MVC 4,Entity Framework, LINQ, WCF, Web Service, Ajax, CSS, Bootstrap, Angular JS and JavaScript.

Estee Lauder Companies Online - Melville, NY

Application Developer Nov 2012 – Feb 2015

The Estee Lauder Companies, Inc is a manufacturer and marketer of skincare, makeup, fragrance and hair care products that are sold in over 150 countries and territories. Estee Lauder Companies Online has a global presence in Europe, Asia, North, and Latin America including emerging countries.


Designed and developed the application using MVC Architecture.

Worked on creating Web applications using ASP.Net, MVC, JavaScript, CSS, XML, HTML and Java Script.

Used HTML5 and AJAX for developing controls and web forms in the application.

Developed Cascading Style Sheets (CSS) for User Interface uniformity throughout the application.

Develop Business logic layer by implementing Object Oriented Programming (OOPS) concepts in C#.

Created SSIS packages for the extracting, transforming and loading the data from different systems into SQL Server 2008R2 and automated the Tasks using SSIS Package.

Created monthly portfolio reports using SSRS

Developed and consumed Web Services.

Conducted unit and functional testing.

Provided production support and enhanced the User interface as per the requirements.

Frequent Client interactions to make sure the deliverables on time.

Environment: Visual Studio 2008/2010, C#, SQL Server 2008, Windows server 2008, IIS 7.0, ASP.NET 4.0, ADO.NET, XML, WCF, MVC, SSIS, SSRS.

Nationwide Insurance Company - Scottsdale, AZ

Dot Net Developer Oct 2010 – Oct 2012

Nationwide is a fortune 100 company that offers a full range of insurance and financial services across the country, including car, motorcycle, boat, homeowners, pet, farm, life and commercial insurance, as well as administrative services, annuities, mortgages, mutual funds, pensions, long-term savings plans and specialty health services.


Involved in gathering requirements from business and evaluated the technical specifications to determine feasibility

Responsible for designing and developing UI features such as Master pages, CSS, JavaScript and for rich look and uniformity throughout the website.

Implemented AJAX features for asynchronous data transfer and partial page updates.

Extensively designed re-usable .NET web custom controls and attractive web forms in C#.

Developed ASP.NET caching features, configuring ASP.NET optimizations, securing ASP.NET web application.

Involved in Integrating WCF Services with the web services that are exposed externally.

Extensively used web services for transferring the data to other data base models and also created web methods for taking data input.

Involved in creating tables, views, triggers and stored procedures and also performing various data operations in SQL Server.

Involved in performing data operations and responsible for data retrieval based on the conditions supplied by the user on a SQL server.

Environment: .Net Frame Work 4.0/4.5,Visual Studio 2010/2012, ASP.NET, C#, WCF, LINQ, Web Service, Ajax, SOAP, CSS, HTML, Web forms, XML, IIS, JavaScript, TFS, Agile/Scrum and SQL Server 2008/2012.

United Insurance – Hyderabad, India

Jr.Net Developer May 2007 – Sept 2010

United provides health insurance plans and products for individual using their application. United application is a web-based application mainly deals with the generation of the reports, product sell and data process for the end users.


Worked on web forms in ASP.Net, C#.

Written different stored procedures and SQL statements for reports.

Used ADO.Net for database connectivity

Worked on creating Web controls.

Created required tables and procedures in SQL Server 2008

Worked on print module with XML data using word template

Used SQL Compare tool to compare data from old database

Worked on implementing N-Tier architecture design

Environment: .Net Framework 3.0, Visual Studio 2008, SQL Server 2008, Window Server 2003, ASP.Net, SQL Joins, N-Tier Architecture, C#, SQL Compare, ADO.Net, Web controls, Web forms.

Contact this candidate