Sql Server Project

Sphani

SUMMARY:

• Over * years of professional experience as a .NET Developer in analysis, design and

implementation of web based, windows based client-server applications in Microsoft

Technologies using ASP.NET 4.0/3.5/2.0/1.1, Design patterns, Win Forms, Web Forms, Web

Services.

• Strong expertise in designing and developing Web Applications using HTML, DHTML, CSS,

XML, XSLT, AJAX, JavaScript, MVC, MVP, Microsoft SharePoint portal server 2003/2007,

WCF, WPF, Web Services.

• Experience in Front End and Back End development using C#.NET, VB.NET, SQL Server,

ADO.Net

• Worked on Operating Systems Vista/Windows XP Professional / 2000 / NT 4.0, UNIX.

• Skilled in developing scalable, 3-Tier, N-Tier distributed .NET applications using Web

Services, Windows Services and WCF, WPF

• Strong database design and programming skills in SQL Server, SQL Stored Procedures,

functions, User Defined Functions, triggers, Cursors, Indexing, Views on SQL Server, Oracle

Database.

• Used version control tools like Microsoft Visual Source Safe 2005/6.0, Microsoft Team

Foundation Server (TFS), Concurrent Versions System (CVS).

• Extensively worked in Oracle, SQL, PL/SQL, Query performance tuning, Created DDL scripts,

Created database objects like Tables, Views, Indexes, Synonyms and Sequences.

• Have expertise and working knowledge of .Net 4.0/3.5, LINQ, WCF, WF, WPF, JQuery, JSON

and Silverlight .

• Involved in Development, maintenance and Production Support in most of the projects

• Experience with Client-side and Server Side Developments.

• Strong Experiences in creating and consuming XML Web Services and having knowledge of

SOAP, SOAP HEADER,SOAP EXCEPTION and UDDI.

• Experience in designing and creating complex reports including sub reports, cross tabs and

formulas with complex logic using Crystal Reports and SSRS on SQL Server.

• Experience in Extracting and Transforming data using SSIS in SQL Server.

• Worked with Agile software development methodology using SCRUM and Test Driven

Development.

• Good Experience in creating the test cases and performing Unit testing, Integration and

debugging of bugs in the developed applications.

• Quick in learning new technologies and problem solving skills at any tense and deadline

situations.

• Being a team player with problem-solving and trouble-shooting capabilities, I am confident of

solving the problem at any tense and deadline situations.

EDUCATION:

• Bachelor of Technology from Jawaharlal Nehru Technological University, India.

TECHNICAL SKILLS:

Design Patterns: MVC, MVP, M-V-V-M.

Web Technologies: ASP.NET, ASP, AJAX, HTML, DHTML, XHTML, CSS, XML,XAML,

ADO, ADO.NET, LINQ, WCF, Web services.

Web & Application Servers: IIS 5.0/6.0/7.0

Programming Languages: ASP.NET 4.0/3.5/2.0/1.1, C#, VB.NET, C++, Java

Scripting Languages: Java Script, AJAX (Asynchronous Java Script and XML)

Databases: SQL Server 2008/2005/2000, Windows Server 2003, Oracle 10g/9i,

MS- Access 2003/2000/97,Mysql

Integration Servers: SSIS

Middleware: COM, ODBC

Development Environments: Microsoft Visual Studio.NET 2012/2010/2008/2005, Microsoft Visual

Interdev, Ms-Office 2008/2003

Office Tools: MS Office, Excel, Power Point

Version control Tools: TFS, Microsoft Visual Source Safe 6.0

Protocols: TCP/IP, FTP, HTTP, SOAP

Methodologies: Agile, SCRUM

Operating Systems: Windows 95/98, Windows NT /2000 advanced server,

Windows XP and Vista.

PROFESSIONAL EXPERIENCE:

Publix, Lakeland FL March 2013 – Present

. Net Developer (Project: Food Production and Replenishment )

Food Production and Replenishment is a replacement of existing system APMG. The goal of this project

is to develop a new store level Bakery Management System and provide support of business processes

associated with forecasting demand, managing orders and inventory, receiving shipments, planning

production and producing items. The project involves developing a new store systems user interface to

support Bakery providing efficient interaction between associate and system and allow the system to

maintain accurate Inventory.

Responsibilities:

• Involved in all phases of project lifecycle SDLC i.e. requirement gathering, analysis, design,

application development and testing for the project.

• Extensive experience in designing and developing various User interfaces and front end screens

using ASP.NET, Html, XML, and XSLT

• Experience in designing and developing, maintaining the Presentation layer, Business logic layer

and Data Access layer using ASP.NET, C# and Sql Server.

• Followed Iterative AGILE Methodology for project development and participated in daily

scrum meetings.

• Experience in using Version control tool Team foundation server (TFS) for the entire

development cycle.

• Strong database programming involving creating Tables and writing SQL Stored Procedures,

User Defined Functions, Views and LINQ queries on SQL Server.

• Developed three batch applications to extract and retrieve data in efficient way and transfer files

securely to EDW which are scheduled to run in the background.

• Experience in creating different User Controls that are reused in the entire project.

• Involved in training sessions for Enterprise Class Library NFX and got hands on experience with

tools like FX Query and FX Configure.

• Strong Experience in creating and consuming XML Web Services and having knowledge o f

SOAP, SOAP HEADER, and SOAP EXCEPTION

• Used ASP.NET Validation controls and JavaScript for client side and server side validations.

• Involved in designing and developing Telerik Rad controls for Presentation Layer.

• Skilled in developing scalable, 3 Tier and N-Tier distributed .NET applications using Web

Services and WCF.

• Designed & Deployed SQL Server Integration Services (SSIS), SQL Server Reporting

Services (SSRS) packages for updating the Point Of Sales records from Excel to SQL database.

• Migrated the functionality from existing asp pages to new aspx pages and also added new

functionality to reflect the Business Users requirements.

• Developed Design Documentation using Class Diagrams, Sequence Diagrams, Use Cases and

Activity Diagrams using Microsoft Visio.

• Experience with Unit Testing in .NET Framework 3.5 & 4.0

• Perform research and development work on latest Microsoft technologies, implement and

upgrade to latest Microsoft products like .NET Framework 4, Visual Studio 2010, SQL Server

2008 and Windows Server 2008.

• Participated in meetings with Business users and with other project teams to ensure that the

volatile business requirements reflect in the project development.

Environment: .NET Framework 4.0/3.5, C# 3.5, ASP.NET 4.0/3.5, HTML, JavaScript, Cascading Style

Sheets, Classic asp.net, LINQ, WCF, ADO.NET, XML, XML Web Services, SOAP, JavaScript, CSS,

Visual Studio 2012/2010/2008, SQL Server 2008/2005, TFS, ADO.Net, IIS 6.0, AJAX, J Query,

JavaScript, CSS, MS-Visio 2010/2007, UML,WPF,SOAP, N-Unit,IIS 6.0

Department of Public Welfare, Harrisburg PA August 2011 – Feb 2013

.Net Developer (Project: Enterprise Certification)

Description:

Enterprise Certification is a Licensing System to determine the standards of the Child Care

Centers and provide "Certificate of Compliance" to the Child Care Centers in the State, based on the

priorities and needs of the Neighborhood. The system monitors the provider and Location(s), when a

provider submits an application for the Certificate to run a Location till a Certificate has been generated.

A designated State Representative will be sent to the Location to Inquire about the services provided

through a Location, and determines the Providers capability in effective functioning of the Location to

meet the Purpose and needs of the Child and parent.

Responsibilities:

• Design, code, test, and support .NET web applications using ASP.NET, C#, Visual Studio 2010,

HTML,CSS, GUI, AJAX, JavaScript, Multithreading, ADO.Net .

• Involved in development of various methods of Presentation Layers, Business Layers and Data

Access Layers in C#.NET and ADO.NET.

• Involved in designing and Development of applications using Web Services/ WCF and support

of WPF based desktop clients.

• Developed ASP.NET MVC applications using Code First Approach in Entity Framework and

UI in Razor View Engine and also have experience with the MVC Architecture

• Expertise in application development using C# and ASP.NET MVC 1.0/3.0 Framework

• Extensive experience on Ajax, J Query, JSON and JavaScript for reports in ASP. Net Web

Pages.

• Developed the projects using SCRUM/Agile project development methodology and actively

participated in daily status meetings.

• Extensive experience to create SQL stored procedures, functions, triggers, Cursors, Indexing

using SQL Server 2008

• Involved in development and implementation of WCF service (services, bindings, service

contract, data contract and operation contract) for .Net web application.

• Experience in using code collaborator and TFS for code reviews.

• Extensively used Data Adapter, Data Set, Data Table, Data View, Data Grid, Data List, and

Data Reader for binding data from database to the various web forms using ADO.Net

• Extensively worked on development of .NET batch applications for back end which processes

high volume of data and generate files with various formats.

• Writing PL/SQL stored procedures, User defined Functions, complex SQL queries with Joins,

Stored Procedures, Cursors Views, Performance Tuning.

• Experience in creating SSIS packages and migrating DTS packages to SSIS to assist in

developing business solutions

• Developed Design Documentation using Class Diagrams, Sequence Diagrams, Use Cases and

Activity Diagrams using Microsoft Visio.

• Involved in designing, developing, coding, and testing reports using Crystal Reports 9.0

interface and PL/SQL queries.

• Tested pages for proper operation by implementing Unit and Integration testing using NUNIT.

• Giving the 24x7 on call Production Support and Bugs Fixing for all applications.

Environment: .NET Framework 4.0/3.5,Visual Studio 2010/2008, C#,Vb.net, ASP.Net, ADO.Net,

MVC Design Pattern, XML Web Services, SOAP, WSDL, HTML, JavaScript, CSS, UML, IIS 7.0/6.0,

SQL Server 2008,Oracle 9i/10g, NUnit Testing, Object Oriented Design (OOD), TFS, AJAX, Active

Directory, Windows Server 2008, Windows XP.

Cerner Corporation, MO June 2010 – July 2011

.Net Developer

Description:

The project focused on the development of a portal for keeping track of current sales activities.

The portal was based on the n-tier architecture with various UI, Business, Business Facades, and Web

Service and Data application layer. It utilized the in house .net framework components for the Data

Access, Security, Logging, Exception and common functions.

Responsibilities:

• Developed GUI using C#, ASP.NET, HTML, XML,J query, Ajax Controls, CSS and Web

Form Controls to create web pages.

• Involved in System Analysis, Design, Coding, Data conversion, Development, Implementation

and Testing.

• Building web applications with ASP.NET, JavaScript, J Query, JSON, HTML, XHTML, CSS

• Involved in the integration of Microsoft Enterprise Application Blocks (EAB) into ASP.NET

application using MSMQ.

• Performed client and server validations using ASP.NET Validation Controls and Javascript.

• Used ADO.NET and data objects such as Data Adapter, Data Reader, Dataset, data table for

consistent access to SQL data sources

• Experience in using the N-Tier Architecture separating the business, presentation and data

models.

• Strong database programming involving creating Tables and writing SQL Stored Procedures,

User Defined Functions, Views, Triggers on SQL Server.

• Writing T-SQL stored procedures to retrieve or update data in the database, User defined

Functions, complex SQL queries with Joins, Stored Procedures, Cursors, and Views on SQL

Server.

• Used Server side Controls, event driven code, Tracing and Debugging features, just in time

compilation, Caching Services for better performance. ..

• Designed and Deployed SQL Server Integration Services (SSIS) packages.

• Used Microsoft Visual Source Safe (VSS) for the source code and version control of the project.

• Implementing Security using .Net Security features such as Authentication & Authorization,

Custom authentication.

• Involved in designing, developing, coding, and testing reports using Crystal Reports 9.0

interface and PL/SQL queries

• Worked on Performance improvement for the application by analyzing & tuning (Performance

Tuning) for the queries, joins, and views in SQL Server 2008.

• Created various kinds of reports using Crystal Reports 9 like Crosstabs, Sub reports, Main

reports.

Environment: Microsoft Visual Studio 2010/2008/2005, Object Oriented Design (OOD), C#.Net,

ASP.Net, MSMQ, Microsoft Enterprise Application Blocks, COM, SOAP Web Services, XML, XSLT,

Web forms, SQL Server 2005/2000, JavaScript, HTML, Cascading Style Sheets, PL-SQL, Oracle 9i,

UML, Crystal Reports 9.0, Windows Server 2000.

Citizens Trust Bank, GA. November 2008- May 2010

.Net Developer (Online Banking project)

Description:

The aim of the project was to allow Online Banking for customers to access account information, transfer

funds and pay bills online through internet and register as Citizens Trust Bank customers and order new

services receive new articles regarding the services and so on. The data access layer needed to be

developed including business classes, which is responsible for storage, retrieval utilizing ADO.Net data

access layer. The project should also enable the Bank Manager to add new service information and to edit

and delete the old service information through this online banking web application.

Responsibilities:

• Designed and Developed Web Application using C#, ASP.Net.

• Involved in all phases of project lifecycle SDLC i.e. requirement gathering, analysis, design,

application development and testing for the project.

• Migrated the functionality from existing asp pages to new aspx pages and also added new

functionality to reflect the Business Users requirements.

• Developed web pages and validated these pages using ASP.NET and JavaScript.

• Extensively used Data Adapter, Data Set, Data Table, Data View, Data Grid, Data List, Data

Repeater and Data Reader for binding data from database to the various web forms.

• Used ADO.NET extensively for data retrieving, querying, storing and manipulating on SQL

Server 2005.

• Created Stored Procedure in Oracle for data retrievals and updates. Also modularized the stored

procedures, Functions, views, PL/SQL for fast retrieval of data.

• Designed Web Service for ordered bank check.

• Used XML technologies for producing news information.

• Performed Unit testing on all interfaces developed.

• Used Visual Source Safe for Version Control and Crystal Reports 9.0 as a reporting tool for

developing sub reports and main reports.

Environment: Visual Studio 2008/2005, .NET Framework 3.0, Object Oriented Development (OOD), C#, ASP.Net, IIS, ADO.Net, Visual Source Safe, HTML, CSS, JavaScript, T-SQL, Stored Procedures,

Functions, Triggers, Cursors, XML Web Services, SOAP, WSDL, NUnit testing, SQL Server 2005,

Crystal Reports 9.0, MS Visio and UML

Bajaj Allianz Insurance, India August 2007 - October 2008

Project: Insurance Management system

.Net Programmer

Description:

Insurance Management System, IMS was developed which provides information about the

claims, issuance, renewal and cancellation of the health insurance policies along with the due payment of

the deductibles by the policy holders. The system has the ability to generate reports based on various

criteria

Responsibilities:

• Developed and implemented the web page interfaces.

• Developed validation functions using C# and Java Script.

• Used ADO.NET and data objects such as Data Adapter, Data Reader, Dataset, data table

for consistent access to SQL data sources.

• Created ASP.NET pages using C#.NET for middle-tier processing of client requests with

ADO.NET interfaces for database and implemented stored procedures

• Developed SQL stored procedures.

• Participated in meetings with Business users and with other project teams to ensure that the

volatile business requirements reflect in the project development

• Responsible for Unit and Integration testing and assuring that the assemblies are developed.

• Participated in creating front end ASP forms and stored procedures.

Environment: C#, ASP.NET, ADO.NET, HTML, Java Script, MS SQL Server 2000, Microsoft Visual

Studio.NET., Microsoft visio.

Contact this candidate