Sign in

Sql Server .Net

Manassas, Virginia, United States
January 31, 2017

Contact this candidate


Senior .Net Developer


Professional Summary:

IT professional with more than 8 years of experience in .NET Applications, Relational Databases, Object Oriented Applications, Test/Configuration Methodologies.

Hands on experience in all phases of Software Development Life Cycle (SDLC).

Extensively implemented design patterns and best practices.

Implemented coding guidelines using ReSharper.

Extensive involvement in all stages of application development life cycle including requirements, logical and physical architecture modeling, design, development, implementation and support.

Have working experience in C#, VB.NET, C++, Objective-C, .NET, Visual Studio 2005/2008/2010/2012/2013, ASP.Net 3.5/4.0/4.5, Ajax, VSTO, ADO.Net

I am fond of exploring the customer business goals and needs in order to implement them in the mobile applications (iPhone, Android, Windows and Multi-Platform Applications) that will bring great profits to my customer.

Strong understanding of SOLID design principles and exposure to Design Patterns like Singleton, Factory, Builder, Fascade, Strategy, Template etc.

Developed web applications using Test Driven Development (TDD) methodology.

Experience in implementing .NET Security features like Authentication and Authorization using Form-based and Window-based authentication, Authorizing Users, Roles and User Account Impersonation, tracing.

Experience in writing unit tests using MS-Test, NUnit and QUnit.

Implemented MVC and MVVM pattern in projects.

Experienced in design and development of application interfaces using web services.

Understanding of Page Layouts.

Understanding of SharePoint Architecture.

Used WCF, Web services, SOA and LINQ.

Proficient in analyzing the Business Requirements, User Requirement Specifications (URS), Functional Requirement specifications (FRS).

Strong understanding of Object Oriented Analysis and design using C# (OOAD).

Good experience in front-end database programming using ADO.NET with SQL Client & Application Block.

Good knowledge of AJAX Control Toolkit and AJAX Enabled web site.

Knowledge of web technologies like HTML, DHTML, JavaScript, jQuery and CSS.

Expert in creating Web Forms, Win Forms, User Controls and Custom Controls.

Strong abilities in Data Modeling, Database Design, Views, Normalization, Stored Procedures, Triggers, Views and Functions.

Experience in working with Oracle PL/SQL Stored Procedures, Packages and SQL Server Stored Procedures.

Experience working with Crystal Report and SQL Server Reporting Service (SSRS).

Quick in learning new technologies and adapting in new environment.

Effective team player and able to rapidly absorb and apply new concepts effectively.

Diligent and can initiate and work independently.

Can work in a challenging work environment and meet deadlines.

Good experience in coordinating and working with developers (Offshore and Onsite) and End Users in Team based environment.

Technical Skills:


SQL Server (2000/2005/2008), T-SQL, DTS, MS Access, Oracle and PL/SQL

ETL Tools

Informatica, Data stage, SSIS

Programming Languages

Visual Basic 6.0, C#.Net, Vb.Net

Web Technologies

ASP.NET, MVC, Web API, HTML, XML Web Services, Red Gate, WAPT

Scripting Languages

JavaScript, jQuery, Angular JS

Markup Languages


.NET Technologies

.NET Framework (1.1/2.0, 3.0/3.5), Win forms, WPF, Web Services, WCF

ORM Tools

NHibernate, Entity Framework, LINQ to SQL

Report Writer

Crystal Report Writer 6.0, Oracle Reports 2.5/3.0, SSRS



Operating Systems

Windows XP/2000/NT/Vista and UNIX, DOS


Visual Studio 2005/2008/2010

Version Control

Visual SourceSafe, Team Foundation Server(TFS)

Modeling & Testing Tools

Microsoft Visio 2003, Nunit, NMOCK, MOQ, JASMINE, KARMA

Web/App Servers

IIS 7.0/6.0, Apache Tomcat Server

Messaging Technologies


ETL Tools

SSIS, Informatica

Professional Experience:

Innovative Control Systems, WindGap PA Jul’16 - Present

Full stack Developer

Innovative Control Systems is a car wash system which supplies the Applications as AutoSentry, Touch POS, WashConnect to the clients. It has its Own Car Wash System named Sparkle Car Wash Systems which handles all the Required items as AutoSentry, Touch POS, Vacuum etc and has the major Stations in the USA and also in Germany. It Benefits the Users to control the Point of Sale Register and give Special offers to the end users as gift cards, free tickets etc. The System is handling about 250 – 300 clients almost in USA and Germany.


Working through all phases of the application software lifecycle (SDLC) including design, development, Testing and deployment.

Followed Agile Methodology approach to produce high quality applications.

Interact with Clients for the Requirements gathering

Used form controls such as Grid View, Data List, Details view, Repeaters, Dataset Classes for data manipulation

Involved in the Designing and Development of various winforms using

Created stored procedures, Triggers and T-SQL queries from sources of MS SQL server databases.

Assisted in development of maintainable and tested codes in JavaScript languages.

Involved in Unit Testing, Bug fixing and integration testing.

Developed test cases and performed Unit Testing to identify and resolve functional and usability issues.

Developed GUI using ASP.NET Web Forms with Ajax controls.

Developed web pages using Asp.NET, JavaScript for Client side Validation.

Developed the validation process on both client side and server side using ASP.NET validation controls.

Worked on ASP.NET Web Forms, state Management, caching features, configuring optimizations, securing ASP.NET web application

Worked on views, common shared views for user interface using JQuery and JSON.

Deployed and maintained ASP.NET applications running at IIS 6.0.

Used the ASP.NET State Management techniques like Session State, View State to retain the values between the page's transactions

Developed reports using SQL Server Reporting Services (SSRS) and deployed the reports (rdl files) in SQL Server 2005.

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

Extensively involved in Developing Components for Business Layer and Data Layer in C#.

Used LINQ and Entity Frame Work for database connectivity and retrieving data from SQL server.

Created Web Api’s and consumed Restful and Soap Services to Export the Customer Information.

Created the WCF to Generate the Promotion Tickets for the Customers.

Created Configuration Files to Define configurations for Profiles, roles and camera settings, Services etc to retrieve data from the SQL server.

Implemented web based front-end using HTML, CSS, JQuery, and Angular Js

Used Angular Js as framework to create a Single Page Application (SPA) which can bind data to specific views and synchronize data with server

Used Angular Js to create custom directives for navigation bar, sidebar filters for patient data, strict filters for exact match search and other re-usable sections.

Developed the application using C#, ASP.NET 4.6 with MVC with Razor View Engine, AJAX, HTML5, Javascript, CSS3.

Maintain and upgrade an application using ASP.NET MVC Web Application. Using M-V-C pattern with Entity Framework.

Environment: NET Framework 3.5, HTML5, Visual Studio 2015, ASP.NET, C#.NET, SSIS, SSRS, SQL Server 2008, ADO.NET Entity Framework, LINQ, ASP.NET MVC, AngularJS, JQuery, Java Script, Karma, HTML, WCF, WSDL, Web API, XML, JSON and TFS, Visual Studio 2015, C#.

New Century Health, Miramar FL Jul’15 – Jul’16

Full stack Developer

New Century Health has major campuses in Miramar FL and Brea CA. To inspire hope and contribute to health and well-being by providing the best care to every patient through integrated clinical practice, education and research.

The Project eConsults benefit patients by eliminating the need for a second visit, in most cases. It benefits referring care providers by allowing the care management to stay within their control. Also, eConsults take about one-third of the time of face-to-face appointments, which frees up care providers' schedules


Interact with clients for requirements gathering.

Prepared the high level and low level design documents based on approved product specifications.

Developed and designed a web application and GUI using ASP.NET MVC.

Used various Validation controls in ASP.NET MVC Razor Views for validation.

Used Microsoft Azure for the building, managing applications and also deploying data services.

Designing of Win forms and GUI was done as per client requirements.

Used HTML 5 helpers for creating views in MVC5

Worked on RWD (Responsive Web Design) and implemented web applications using AngularJS.

Implemented LINQ, Entity framework 6.0, Nlog, common logging, Elmah and Newtonsoft.json.

Worked on client side coding in JavaScript JQuery libraries and also on agile methodologies.

Implemented the WCF service to ensure that the passwords are encrypted, while reverting back to the database

Used different Telerik Rad Controls, Free Textbox in Visual Studio applications and Sitefinity.

Effectively used security infrastructure for authenticating and authorizing user access as well as performing other security related tasks using C#.NET.

Implemented Object Oriented Programming and MVC design patterns.

Proficient in an assortment of technologies, including bootstrap, Oracle 9i/10g, DB2, Access, MS SQL Server, Visio, C++, WSDL, XML, Python, Windows.

Used form controls such as Grid View, Data List, Details view, Repeaters, Dataset Classes for data manipulation and also worked on DICOM.

Used various tools like karma for testing the developed code and Performed several testing to fix the bugs and ensure the application error-free.

Involved in retrieving and storing customer information using T-SQL, generated reports using SSRS.

Created Stored procedures, User Defined functions, triggers, views using T-SQL for better performance in retrieving the results of the application

Environment: NET Framework 3.5, HTML5, Visual Studio, ASP.NET MVC, C#.NET, SSIS, SSRS, SQL Server 2008, DICOM, Fast Framework, Silverlight, Facets 4.7&5.2, AngularJS, bootstrap, elmah, Newtonsoft.json, edge.js, Karma, HTML, WCF, WSDL, Web API, XML and TFS, Visual Studio 2012, C#.

Alliant Energy, Madison, WI Mar’14 – Jul’15

Sr.Net Developer

This project is designed for Office of the Public Defender (PD) to be a nationally recognized leader in indigent defense that provides superior representation and advocacy, while affirming the dignity of our clients, and operating with fiscal and professional integrity. OPD application is designed to handle the case and document management requirements. It also contains contact information, Time and Billing, Notes, Appointments, and Reports to serve the Public Defenders.


Involved in analysis, design and development of application with full Software Development Life Cycle (SDLC) from inception to peak/delivery.

Participated in the daily stand up SCRUM agile meetings as part of agile process for reporting the day to day developments of the work done.

Developed user interface screens under VisualStudio.NET using ASP.NET MVC and C#.

Created Business Logic Layer & Data Access Layers to implement the MVC architecture.

Involved in user validations and authentications throughLDAP (Lightweight Directory Access Protocol).

Involved in the implementation of client side validations using JQuery and ASP.NET MVC Validation implemented at Controller level.

Designed Graphical User Interface (GUI) using HTML, JavaScript, CSS, Custom Controls, JQuery, JQGrid, and Jquery UI.

Involved in integrating .Net controls into Sitecore.

Involved in integrating Sitecore 6.0 with .NET 2010 for templates, layout, sub-layout, controls, control rendering, placeholder and content.

Created Stored Procedures, Views, Triggers and Complex T-SQL queries in SQL Server.

.Net Framework 4.0, Windows Communication Foundation (WCF) and ASP.NET MVC and new C# 4.0 features like LINQ and NHibernate.

Involved in Web Service unit testing using SoapUI tool.

Developed an AngularJS workflow manager leveraging Angular-UI’s state router for flexible configuration and management of multi-step user input flows.

Migration of vb6 to .Net using was done and also rectified the bugs while migrating.

Created an AngularJSaddon lib that allows component developers to define and bind to W3C Custom Elements (Web Components) from within Angular code.

Used TFS for maintaining versions of code.

Performed Code review and Unit testing for better performance.

Designed Web form’s input validation using the ASP.Net MVC Input Validation Controls and dynamic features using Ajax 2.0, JavaScript and MS Enterprise Library 4.0(Validation Block).

Environment: ASP.Net MVC, Visual Studio 2010, C#, Sitecore6.0,VB6, JavaScript, AngularJS, Bootstrap, Ajax, JQuery, XML, NHibernate, WCF Sevices,TFS Server 2012, SQL Server 2008, Oracle 10g, Active Directory (LDAP), Windows Server 2003,.net framework4.0.

AIG, Huston, TX Nov’12 – Mar’14


American International Group also known as AIG A Worldwide Insurance Company with over 88 million customers in 130 countries. AIG focuses on global capital markets operations, direct investment and retained interests. The organization mainly operates through 3 major entities:

-AIG Property Causality (Insurance for Commercial, institutional and individual customers)

-AIG Life and Retirements (Insurance and retirement services all over US)

-AIG UGC (Insurance that covers mortgage guaranty and mortgage insurance).

The Goal of the Project is to maintain all activities of insurance System. Any customer without visiting the office Manually He can View the Policy Details as: Coverage Amount, Policy Premium dates, Bonus Details and etc. through Web, and the main concept of the project any customer can pay the amount through Online. Administrator is the Super user of the System. He can able to view the reports like policy details etc.


Designed and developed the web pages and master pages using ASP.Net,, and MS Azure, CSS, AJAX, XML and Visual Studio .NET 2008.

Used ASP.NET Server and Validation Controls, HTML controls, AJAX controls to design the web pages and forms with RESTFUL services.

Developed User Interface using .NET.

Used .Net framework 4.0, n-tier architecture and Object Oriented Methodologies for application development.

Extensively used ASP.NET controls for developing the UI.

Developed mobile apps using IOS and Android development for regular use of the customers to know the day to day update.

Designing of forms and GUI was done as per client requirements.

Used the ADO.NET SqlClient Objects like SqlConnection, SqlCommand, SqlDataReader and SqlDataAdapter and Dataset object in the Data Access Layer to fetch the data from the SQL Server 2008 Database.

Effectively used VB.NET security infrastructure for authenticating and authorizing user access as well as performing other security related tasks using C#.NET.

Created event driven Web Forms using VB.NET and implemented form validation using Validation controls using both Custom validation and JQuery was written for Client side validations.

Worked Extensively with Specflow and Query Optimization Techniques to Fetch Data with better Performance Tuning.

Involved in development of MVC patterns for client server interaction.

Successfully migrated the existing code from VB6 to .Net.

Improved the user experience of Webpages by using AJAX and complete preparation of plan using backlog and sprint planning using JIRA.

Involved in implementing the logic using C# and oops concept.

Used Fast Framework and front end web development tools like CSS, JavaScript, HTML, and jQuery.

Involved in developing WCF Web Service using SOAP/HTTP to communicate with legacy systems.

Responsible for maintaining versions of source code using Team Foundation Server 2010

Generated reports using SSRS and writing petapoco queries using Sql builders.

Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files.

Involved in retrieving and storing customer information using T-SQL.

Environment: VB.NET, NET Framework 3.5, Visual Studio, ASP.NET 3.5, VB6, C#.NET, SSIS, SSRS, SQL Server 2008, HTML, XML and MS Visual Source Safe. VisualStudio 2010, C#, ASP.NET MVC 3.0, WCF, RESTFUL, Entity Frame Work 4.0, IOS, Fast Framework, Java Script, JQuery, specflow,TFS 2010, WCF, IIS 7.0, AJAX, ADO.NET, PETAPOCO, SOAP, LINQ, JXDD, XML, SQL Server 2008 R2, Windows Server 2003, Windows Server 2008

Atos, Irvine CA May’11 – Sep’12

.Net Developer


Enfonet gives Enforcement Personnel a report web based tool for viewing the details and progress of an investigation. It provides an easily accessible investigation report tool to deliver current information about firms and individuals that will support the daily operations of Enforcement, in particular the rapid response teams and central triage team


Worked closely with clients in gathering and analyzing requirements and providing solutions that meet the client’s requirements.

Involved in full lifecycle of the project from design, development & Testing.

Supported and developed both web-based applications using ASP.NET as well as client-server applications written in VB.NET.

Produced reports using SQL, Business Intelligence Development (BIDS). Created Report Definition Language (rdl) files for specific templates and formats.

Designing of forms and GUI was done as per client requirements.

Maintaining the billing invoices running through telecommunication services and reconciilating systems.

Designed apps on mobile using Android and IOS development for instant processing using .net technologies.

Data migration on flat file, Excel, PDF file format using SQL Server Integration Services (SSIS).

Programmed client side scripting using Java Script and JQuery.

Branch, merge codes and initiate auto build process on Team Foundation Server 2010.Used VB.NET to develop code behind logic, business tier and SQL Server 2008 for data tier.

Developed, multi-tier web applications utilizing .NET technologies such as C#, SQL Server, LINQ and Entity Framework 4.

Created Data Templates with standard values in Sitecore.

Developed applications on client side coding in JavaScript JQuery libraries, Ajax.

Used Master Pages to achieve uniform template design for the entire application.

Designed and developed a database application for Student Fiscal Services department financial records in VB-6 and VB.NET framework and SQL Server 2000. Created SQL objects of table, schema, views, stored procedures, and ad hoc.

Sparse and merged raw data (flat file) from daily banking transactional processing from banks and updated the information in database system and grant access to designated users with front end interface.

Produced detailed reports in Excel, Word, and XML/XSL transformation by merging database information. Wrote SQL queries with Joins on multiple tables, Stored Procedures, Functions, Triggers, Indexes using SQL Server 2008 TFS is used for version control and tracking the builds.

Performed several testing to fix the bugs and ensure the application error-free.

Written several web application interfaces using the various server-side architectures including Active Server Pages (ASP in both VBScript, and Jscript), ASP.Net (C#, VisualBasic.Net).

Created class diagrams, use case diagrams, activity flow diagrams and object Interaction diagrams using UML Modeling.

Created stored procedures, functions, views and triggers to retrieve the data from the database.

Build deploy and manage applications using Microsoft windows azure cloud computing.

Performed both Manual and Automated testing (unit & functional testing) using Fitness by writing and executing test cases and also prepared weekly status report.

Environment: .NET Framework 4.0, Visual Studio 2010, ASP.NET, ADO.NET, VB.NET, CSS, JavaScript, IOS, IIS, Web Services, HTML,XML/XSLT, SSRS, JQuery, WCF, WPF, Fitness, Sql Server 2008, PL/SQL, Oracle 10g

Quad one Technologies, Hyderabad, India Aug’08 – Mar’11

.Net Developer

BOSS (Brokerage Operations Support system)

To support the Brokerage Operations, Hartford insurance developed an Application named BOSS (Brokerage Operations Support system). Each country will use BOSS and develop applications, reports and business rules as per the local specifications.


Working in an agile environment to deliver higher-quality software far more rapidly.

Successfully organized initial set of requirements into master list of Use Cases.

Involved in development of Web Forms, Classes using C#.NET that incorporates both N-tier architecture and database connectivity.

Designing of forms and GUI was done as per client requirements.

Used Visual Studio .NET 2008 IDE to design the forms, develop and debug the application.

Worked on different aspects of .NET framework like ASP.NET 3.5, ADO.NET and C#.

Involved in designing of User Interface with CSS, HTML, and DHTML.

Developed presentation layer using server-controls, HTML controls and user and custom controls.

Created and deployed Web Services using C#, SOAP, XML for Pulling Customer Service Records.

Modified web services to interact with the other applications and exposed them using SOAP and HTTP.

Used various ASP.NET 3.5 web server controls that included Site Map Path, Menu, Tree View, Grid View and Details View to develop web forms.

Used AJAX to trade data with a web server, without reloading the page.

ADO.NET was used to connect to the data bases in a disconnected oriented architecture.

Created event driven Web Forms using ASP.NET and implemented form validation.

Extensively used Grid view control throughout the application.

Used SOAP to implement Web Services and consumed and published XML web services in the application.

Created CSS files to be applied to various web forms on the web pages.

Using Validation controls using both custom validation and JavaScript was written for Client side validations and also used the new validation controls in VS 2008.

Developed extensive Stored Procedures and Triggers in SQL Server 2005.

Designed SSIS Packages for data loading, auditing and execution tracking. These included a variety of transformations like Execute SQL Task, Script Task, Execute Package Task, File Connection, Derived Column, and For Each Loop.

Involved in Unit Testing and Integration Testing of the entire application.

Implemented version controlling using Visual Source Safe.

Environment: .NET Framework 3.5/2.0, ASP.NET, C#, ADO.NET, XML, Web services, HTML, JavaScript, IIS 6.0, Windows 2000 Server, HTML, DHTML, UML, CSS, UML, Ajax Toolkit,VSS, Visual Studio 2008, SSIS, XML, XSL, HTML, SQL Server 2005.

Contact this candidate