Design & development of "Listings Application" a windows application which handles the listing or customer details displayed in the specific format in the yellow pages book published annually and semi-annually. Customers get option of how to display their information to their respective clients and provides them option to list their businesses on the online portal. Credit card transactions are handled by Credit Card Terminal used by clients/customers of Global Directories depending upon the respective payment plans. Handling of customer data and other relevant information is done by robust reporting system.Responsibilities:• Designed and developed different modules, classes using C# and Designed GUI Part with help of .NET framework 4.5.• Developed a Graphical User Interface (GUI) for Credit Card Terminal application in windows forms.• Re-designed the database to reduce the complexity and to adjust to new business requirements• Created Store Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.• Used ADO.NET classes to get the data from the database.• Used the built-in mechanisms of SQL Server for the data integrity like Default, Not Null, Check, Unique, Primary Key, and Foreign Key, etc.• Used Entity Framework to get the data from database and establish the connection with the application.• Retrieved data using LINQ to SQL Classes and stored procedure, tables and views.• Extensively used Entity Framework and complex stored procedures in T-SQL to fetch data.• Developed a Graphical User Interface (GUI) for a server-side web application with ASP.NET MVC Views, jQuery, LINQ, JSON and AJAX in Visual Studio.