Sql Server .Net

Surya Prakash Pandey

+91-844******* ***********@*****.***

(.Net/MVC Developer)

OBJECTIVE

A challenging position that will utilize my extensive technical skills and will lead me to innovative work environment.

SUMMARY

Around 5 years of experience in analysis, design and development of client/server, web based and 3-tier application. Expert in developing windows applications, web applications, windows services and web services in Microsoft Visual Studio .Net IDE using C# 2.0, C# 3.5, 4.0 ASP.NET, ADO.NET and SQL Server.

Certified from Microsoft in MCTS (Microsoft Certified Technology Specialist).

Worked extensively with Data Adapter, Dataset, Data reader as a part of ADO.NET to access and update database.

Extensive experience in SQL Server Database design, Database maintenance, developing T-SQL queries, stored procedures, and triggers using SQL Server 2000/2005/2008 R2.

Expert in debugging an application using the debugging tools provided by the Visual Studio.Net IDE.

Effective in working independently and collaboratively in teams.

TECHNICAL SKILLS

Microsoft Technologies : ASP.NET 2.0, 3.5,4.0, VC#, ADO.NET

Programming Languages : C# 2.0,3.5,4.0

RDBMS : SQL Server 2005, 2008, 2008 R2.

Operating Systems : Windows 95/2000/NT, XP,7

Development Tools : VisualStudio.NET 2003/2005/2008/2010/2012

Reporting Tools : Crystal Reports 8.5/SAP Crystal Reports.

Application Servers : IIS 7

Scripting Language : Java Script, JQuery, HTML

Latest Technologies : ASP MVC 4.0, Entity Framework .

Payment Gateway : EBS, PayPal, All Types of Payment Gateway Integration.

Third Party Controls : Used Telerik Asp.net Ajax controls in web based applications.

Web Services : WCF, Web Services, Rest API .

Cloud Technologies : Share point Online 2013, Office 365

PROFESSIONAL EXPERIENCE

A1 Technology Inc. Sept-2015 to Present

Software Developer

A1 Technology is innovative software Development and outsourcing Company. A1 deals in various domain like Retail, Healthcare and Human resource based ERP Applications. They have expertise in mobile apps development in different - different domain.

Web URL – http://www.a1technology.com/

CommonTrainer.com

This is service provider web portal to users. This application is basically for professionals. In which we take the requirements from users and send to our registered professionals with matching criteria. They can contact to customers and provide the service and take the charges for same. So it’s a B2C based concept we implemented on live so every needy can take the advantage and can save the money and time as well.

Environment: ASP MVC 4.0, SQL Server 2012, ADO.NET, JQuery, BootStrap, WCF Rest.

Prometheus - USA - Nestle Healthcare Company.

Prometheus is a part of Nestle USA Company . Basically, this is a healthcare company . I worked on their mobile product . for that i have created the Back end architecture and provides the rest API to mobile developers. In this project, I have integrated the Share point to WCF .

Environment: C#, WCF Rest, ADO.Net,SQL Server 2012, Share point Online 2013,Office 365

M3M India Pvt Ltd. Sep-2014 to Sept -2015

Web Developer

M3M india is largest Real estate company based in Delhi NCR . They have 500+ Employee strength in Gurgaon Office . Basically, they deals in Land, Education, Infrastructure . they have 100+ members in IT development team .

Web URL – http://www.m3mindia.com

Task Manager.

It’s a kind of Task workflow system. In which Admin can assign the task to user and track the task status till completion. There are some major modules developed by me.

Assign Task to user.

Keep tracking every day.

Keep the history of ongoing process.

Private doc and message sharing.

Process or task hold/pause system..

Task rollback to user or any level of individuals.

Task or process re assign.

Approver on each transaction of task or process.

Task will assume completed, when approver will approve the same.

Environment: ASP.NET 4.0, ADO.NET, Microsoft Visual Studio 2010, SQL Server 2008 R2, Entity Framework.

AppsLogic Software Pvt Ltd. Feb-2013 to Sept -2014

Web Developer

AppsLogic Software is innovative software Development Company. AppsLogic deals in various domain like Retail, Healthcare and Human resource based ERP and Applications. They have their own ERP and provides reliable automation system to their clients as per the requirements.

Web URL – http://www.appslogicsoft.com

NexGen ERP System.

NexGen ERP, it’s a kind of ERP Product of AppsLogic Software. Basically we provide SaaS based services using this product. It's a complete ERP, in which there are multiple module like POS, Inventory, Accounting, HR and Biometric integration part, so we can manage a complete business by this product.

Environment: ASP.NET 4.0, ADO.NET, Microsoft Visual Studio 2010, SQL Server 2008 R2, ADO.NE, WCF. (Third Party Control – Telerik ASP.NET Ajax Controls.)

Dawar International Pvt Ltd. March -2011 to Jan 2013

.Net Developer

Dawars is a largest electronics retail chain and e-commerce company in Delhi NCR . They have around 30 outlet in NCR.

Dawars provides services in B2C and B2B . they have great clients in NCR like Sony, Samsung,

Snapdeal, Let's Buy etc.

Web URL – http://www.dawarsopenworld.com

Dawar’s ERP

Dawar’s ERP is a retail Industry management solution. This Application basically do the POS, Inventory, Accounting and supply chain management task successfully, And provide a best and user friendly interface to the users and admin as well.

Responsibilities:

Used 3-tier architecture for presentation layer, the Business and Data Access Layers and were coded using C#.

Developed application logic using C#.

Written stored procedures, Function, triggers using SQL in SQL SERVER 2008.

Configured Master Data like Material Master, Vendor master and created different purchase info records according to client needs

Worked on message API’s using C#.

Using Mail System to send the automation mail to all the high end clients.

Worked intensely on the User Interface.

Developed Win forms (using C#).

Deployment of Application on Test and Production Server.

Handled many production issues and enhancement to the existing live Software

Environment : C#.NET, ADO.NET, Microsoft Visual Studio.NET 2008, SQL, XML, SQL Server 2005 Enterprise Manager, .NET Framework

Dawar’s Service System.

Dawar’s service System is an online customer complaint Management System for Electronics Retail industries. This project takes care of all activities related to enterprise retail industry. This project mainly includes Configuration, Preferences, Sales, Demo, Complaint, for customer support and various related reports. This project had developed to handle large transactions of client’s complaint and requests.

Responsibilities:

Used 3-tier architecture for presentation layer, Business and Data Access Layers and were coded using C#.

Developed application logic using C#.

Written stored procedures, function, triggers using SQL 2005, 2008 R2.

Worked intensely on the User Interface.

Developed Win forms (using C#).

Worked on third party API’s using C#.

Using Mail system to send the automation mail to all the prestigious clients.

Worked on exporting reports to Excel from Grid views.

Worked on crystal Report to view monthly Executive Reports etc.

Deployment of Application on Test and Production Server.

Handled many production issues and enhancement to the existing live Application.

Environment : C#.NET, ADO.NET, Microsoft Visual Studio.NET 2008, SQL, XML, SQL Server 2005 Enterprise Manager, .NET Framework

EDUCATION

MCA from IGNOU.

B.sc in IT from Kuvempu University Karnataka.

GNIIT from NIIT Bangalore.

CERTIFICATION

Microsoft certified technology specialist in .NET 2.0(Code-70-528)

Microsoft certified technology specialist in Asp.net 2.0(Code-70-536)

PERSONAL DETAILS

Father’s Name – Pramod Pandey

Date of Birth – 15 July 1990

Language Known – Hindi, English

Marital Status – Single

Contact this candidate