Post Job Free

Resume

Sign in

Sql Server Web Services

Location:
Kings Mountain, NC
Posted:
December 06, 2013

Contact this candidate

Resume:

Ritwik Sanyal

SUMMARY

. Over * years of progressive experience in developing high scalable

web, Distributed, Client-Server applications using Microsoft

Technologies in Insurance, Banking, Sales and HealthCare domains.

. Expert in designing, developing advanced business applications using

.Net Framework 1.1/2.0/3.5/4.0, SOA, C#, ASP.Net, MVC, ADO.Net,

NHibernate, WCF, .Net (Web services, WSDL), Windows Services, SQL

Server, HTML, Java Script, CSS, XML, XSLT, XSD, OOPS, Fiddler and UML.

. Very good experience in developing applications using .Net Framework

3.5, Windows Communication Foundation(WCF), Web Services, MVC,

ASP.NET, NHibernate, XML, SQL Server and SSIS

. Extensive experience in working with NHibernate.

. Proficient in working with technologies like Web Services (SOAP, WSDL,

UDDI) and AJAX.

. Strong experience developing C# Web Applications using MVC and

ASP.NET.

. Exceptional ability in using tools like Visual Studio, Visual

Interdev, Visual Source Safe and Clear Case.

. Expertise in developing Stored procedures, functions and Triggers

using SQL Server 2000/2005.

. Experience in Object Oriented Methodologies (OOAD), Service Oriented

Architecture (SOA), Agile, Scrum and Design Pattern.

. Extensively worked in project life cycle SDLC activities like

Analysis, Design, Development, and Deployment& Installation.

. Undergone training on SEI-CMM and ISO quality standards.

. Expertise in working with PDF generator, Menu, Tree view and

Infragistics, Aspose, Teleric, DevExpress 3rd party controls.

. Experience in providing day-to-day production support on existing .net

applications.

. Possessing strong analytical skills, a good team player with good

leadership qualities and strong oral and written communication skills.

. Versatile team player as well as independent contributor with good

problem solving and interpersonal skills.

TECHNICAL SKILLS

Languages: C#, VB.Net, JavaScript, HTML

Database: SQL SERVER 2008/2005/2000, SSIS

Operating System: Windows 2003/2000/XP.

Web Servers: IIS 5.1, IIS 6.0, IIS 7.0

Technologies: .Net Framework 4.0/3.5/3.0/2.0/1.1, ASP.NET, MVC, WCF, Web

Services, NHibernate, ADO.Net, ASP, ADO, XML, AJAX,

JavaScript, Visual Studio 2010/2008/2005/2003, XSLT, DTD,

DOM, CSS, Team Foundation Server and Winforms.

Tools: Visual Studio IDE, Visual Interdev, TOAD, Microsoft Visio,

NUnit

Source Code Control: TFS, Visual Source Safe (VSS), SVN, Serena, Clear

Case (CC).

Third party controls: Infragistic, Teleric.

Deployment Tools: ClickOnce, TeamBuild, MS Deploy

EDUCATION

Bachelor of Commerce from University of Calcutta in the year 1999

Professional Certification

Diploma in Software Technology in the year 2002

WORK EXPERIENCE

Bank of America -Charlotte NC Duration

Nov 2012 - Till Date

Application Developer / Production Support

Project: Anti Money Laundering

Description:

Bank of America has implemented an enterprise-wide Anti-Money Laundering

(AML) compliance program, which covers all of its subsidiaries and

affiliates, and is reasonably designed to comply with applicable laws and

regulations. Currently Anti Money Laundering Reporting Tool (ART) has 20

applications devel-oped using .NET Framework 3.5 using VB.NET, SQL Server

2005 and WCF that interfaces with Actimize and has upstream and downstream

impact.

Responsibilities:

. Involved in SDLC life cycle from the Requirements to development, unit

testing and deployment of the application module.

. Developed Business, Data and Presentation layers of the application

using ASP.NET, WCF, Web Services, XML, ADO.NET, OOPS, Windows

Services.

. Extensively used .Net framework 3.5, VB.NET, Visual Studio 2008, Sql

Server 2005, SSIS and WCF

. Implemented web services and Windows Communication Foundation (WCF).

. Developed Stored procedures, functions and Triggers using SQL Server

2005.

. Singleton class is implemented to make sure single instance of

application is created.

. Observer design pattern is implemented to make changes to UI based on

behavioral changes.

. Implemented web farming for this application.

. Used LINQ and WCF.

. Searialization and deserialization of classes are implemented.

. Generated scripts for database deployment.

. Provided technical direction and guidance to the team.

. Coordinating with the end application users.

. Coordinating with offshore team.

. Reviewing code before delivery.

. Unit Testing.

Technologies: VB.NET, .NET Framework 3.5, ASP.NET, IIS 7, WCF, XML,

ADO.NET, SQL Server 2005

Environment: IIS 6.0, TFS, SVN

Municipal Bond Investors Assurance (MBIA) -Armonk, NY

Duration April 2011 - Nov 2012

Application Developer

Project: CPMS

Description:

CPMS is a web based application developed using MVC Razor Views through

which MBIA tracks the payments made to claims made by the parties. It

tracks the various stages of payments made to the parties and sent email

commucation at each stage. It provides roles based interface for the

approvers who approves the payments at its different stages.

Responsibilities:

. Involved in SDLC life cycle from the Requirements to development, unit

testing and deployment of the application.

. Developed Business, Data and Presentation layers of the application.

. Extensively used MVC, .Net framework 3.5, C#, Visual Studio 2008,

NHibernate, Web Services and Oracle 10g.

. Implemented security through AzMan

. Worked with XML, XSLT and Xpath to provide dynamic webpages.

. Worked on infragistics third party controls.

. Used NHibernate queries to pull data from the oracle database.

. Implemented web services.

. Implimented Webfarm.

. Developed business classes and business logic in C#.

. Team Foundation Server (TFS) implemented.

. Ajax control toolkit 3.5 and Ajax controls are used to provide

interactive web interface to users.

. Written Java script codes.

. Coordinating with the end application users.

. Coordinating with offshore team.

. Reviewing code before delivery.

. Unit Testing.

. Participating in the quality audit.

Technologies: C#, .NET Framework 3.5, AzMan, MVC, XMLHTTP, IIS 7,

NHibernate, Web Services, Infragistics, XML, AzMan, Oracle 10g

Environment:

IIS 7.0, TFS, Serena, Web Farm

Project: eRcruitement

Description:

eRecruitement is a web based HR application developed using MVC Razor Views

through which MBIA HR manages recruitement and job creation process. It

provides roles based interface to manage the reqcruitement process at its

different stages.

Responsibilities:

. Involved in SDLC life cycle from the Requirements to development, unit

testing and deployment of the application.

. Developed Business, Data and Presentation layers of the application.

. Extensively used MVC, .Net framework 3.5, C#, Visual Studio 2008,

NHibernate, Web Services and Oracle 10g.

. Implemented security through AzMan

. Worked with XML, XSLT and Xpath to provide dynamic webpages.

. Worked on DevExpress third party controls.

. Implemented a spell checker feature using DevExpress and JQuery

. Used NHibernate queries to pull data from the oracle database.

. Implemented web services.

. Implimented Webfarm.

. Developed business classes and business logic in C#.

. Team Foundation Server (TFS) implemented.

. Ajax control toolkit 3.5 and Ajax controls are used to provide

interactive web interface to users.

. Written Java script codes.

. Coordinating with the end application users.

. Coordinating with offshore team.

. Reviewing code before delivery.

. Unit Testing.

. Participating in the quality audit.

Technologies: C#, .NET Framework 3.5, AzMan, MVC, XMLHTTP, IIS 7,

NHibernate, Web Services, DevExpress, XML, AzMan, Oracle 10g

Environment:

IIS 7.0, TFS, Serena, Web Farm

Project: eTapp

Description:

eTapp is a web based application developed using MVC Razor Views through

which MBIA manages its project cost . It provides roles based interface to

manage time clocking, time approval, reporting of project cost by the

consultant and managers at its different stages.

Responsibilities:

. Involved in SDLC life cycle from the Requirements to development, unit

testing and deployment of the application.

. Developed Business, Data and Presentation layers of the application.

. Extensively used MVC, .Net framework 3.5, C#, Visual Studio 2008,

NHibernate, Web Services and Oracle 10g.

. Implemented security through AzMan

. Worked with XML, XSLT and Xpath to provide dynamic webpages.

. Worked on Teleric third party controls.

. Used NHibernate queries to pull data from the oracle database.

. Implemented web services.

. Implimented Webfarm.

. Developed business classes and business logic in C#.

. Team Foundation Server (TFS) implemented.

. Ajax control toolkit 3.5 and Ajax controls are used to provide

interactive web interface to users.

. Written Java script codes.

. Coordinating with the end application users.

. Coordinating with offshore team.

. Reviewing code before delivery.

. Unit Testing.

. Participating in the quality audit.

Technologies: C#, .NET Framework 3.5, AzMan, MVC, XMLHTTP, IIS 7,

NHibernate, Web Services, DevExpress, XML, AzMan, Oracle 10g

Environment:

IIS 7.0, TFS, Serena, Web Farm

Travel Planners, NYC, NY Duration July 2009 -

March 2011

Application Developer, Designer

Project: CSI Integration System

Description:

CSI is an interface modeled on SOA being used by a third party group called

compu systems that sells rooms that are under the umbrella of travel

planners. Its an interface developed using WCF RESTFul services modeled on

SOA that are being consumed by the third party group of hotels. It exposes

a set of services through which the the third party CS group searches for

availability of rooms within a seprifed date range and reserves, modifies,

views and cancels the existing reservation.

Responsibilities:

. Involved in SDLC life cycle from the Requirements to development, unit

testing and deployment of the application.

. Designed and developed the entire interface which is based on SOA

using WCF RESTFul services.

. Designed and architected the classes & project using MSVisio.

. Developed and designed the data contract through which data is

exchanged between the travel planners and third party CS group.

. Developed and designed the service contract and the services through

which the third party CS group searches for availability of rooms

within a seprifed date range and reserves, modifies, views and cancels

the existing reservation.

. Extensively used .Net framework 3.5, C#, Visual Studio 2008, WCF and

SQL Server 2005.

. Developed Stored procedures, functions and Triggers using SQL Server

2005.

. Unit testing using Fiddler.

. Performed error logging using Log4Net.

Technologies: C#, .NET Framework 3.5, IIS 6, WCF, ASP.NET, XML, SQL Server

2005

Environment:

IIS 6.0, Visual Source Safe

Project: TP Multi Room Reservation Engine

Description:

It's an web based application that searches for availability of rooms

within sepicified date range and location, acquire locks on the rooms,

allows the customers to specify details for each of the rooms and then

confirms the confirmation and sends out email notification.

Responsibilities:

. Involved in SDLC life cycle from the Requirements to development, unit

testing and deployment of the application.

. Developed Business, Data and Presentation layers of the application.

. Extensively used ASP.NET, .Net framework 3.5, C#, Visual Studio 2008,

Web Services, AJAX and SQL Server 2005.

. Developed Stored procedures, functions and Triggers using SQL Server

2005.

. Worked with XML, XSLT and Xpath to provide dynamic webpages.

. Implemented web services.

. Implimented Webfarm.

. Developed business classes and business logic in C#.

. Ajax control toolkit 3.5 and Ajax controls are used to provide

interactive web interface to users.

. Written Java script codes.

. Coordinating with the end application users.

. Reviewing code before delivery.

. Unit Testing.

. Providing technical direction and guidance to the team.

Technologies: C#, .NET Framework 3.5, IIS 6, WCF, ASP.NET, XML, SQL Server

2005

Environment:

IIS 6.0, Visual Source Safe

Project: Orchestrator

Description:

It's an web based application that provides the admin aspect of the room

reservation system. This system enables the users to add room, hotel,

maintain room rates along with other useful admin features

Responsibilities:

. Involved in SDLC life cycle from the Requirements to development, unit

testing and deployment of the application.

. Developed Business, Data and Presentation layers of the application.

. Extensively used ASP.NET, .Net framework 3.5, C#, Visual Studio 2008,

Web Services, AJAX and SQL Server 2005.

. Developed Stored procedures, functions and Triggers using SQL Server

2005.

. Worked with XML, XSLT and Xpath to provide dynamic webpages.

. Implemented web services.

. Implimented Webfarm.

. Developed business classes and business logic in C#.

. Ajax control toolkit 3.5 and Ajax controls are used to provide

interactive web interface to users.

. Written Java script codes.

. Coordinating with the end application users.

. Reviewing code before delivery.

. Unit Testing.

. Providing technical direction and guidance to the team.

Technologies: C#, .NET Framework 3.5, IIS 6, WCF, ASP.NET, XML, SQL Server

2005

Environment:

IIS 6.0, Visual Source Safe

University Health System Consortium, NYC, NY

Duration July 2008 - June 2009

Application Developer, Designer

Project: Patient Safety Net

Description:

This PSN application is basically an enhanced, modernized version of the

existing legacy application with additional functionalities.

UHC has decided that the current application topology, consisting of a

mixture of ASP and ASP .Net tech-nology, requires a unified re-

architecture, design and build. By initiating this project, UHC

demonstrates its commitment to maintaining its leading position as an

incident reporting solution provider to the university medical community.

Responsibilities:

. Involved in SDLC life cycle from the Requirements to development, unit

testing and deployment of the application.

. Developed Business, Data and Presentation layers of the application.

. Extensively used WCF, ASP.NET, .Net framework 3.5, C#, Visual Studio

2008, Web Services, AJAX and SQL Server 2005.

. Developed WCF services to implement SOA based architechture in the

middle layer of the application that interacts with SQL Server

Database which in turn was consumed by the ASP.NET web UI.

. Hosted the WCF service on Windows Service.

. Developed the web pages that present data to the users by consuming

the WCF services in middle layer.

. Developed Windows Services to interact with PA-PSRS interfaces by

exchanging feed files using FTP.

. Developed Stored procedures, functions and Triggers using SQL Server

2005.

. Worked with XML, XSLT and Xpath to provide dynamic webpages.

. Implimented Webfarm.

. Developed business classes and business logic in C#.

. Ajax control toolkit 3.5 and Ajax controls are used to provide

interactive web interface to users.

. Written Java script codes.

. Coordinating with the end application users.

. Reviewing code before delivery.

. Unit Testing.

Technologies: C#, .NET Framework 3.5, IIS 6, WCF, ASP.NET, XML, SQL Server

2005, Windows Services, FTP

Environment:

IIS 6.0, Rational Clear Case

Dell, Austin, TX Duration February

2007 - May 2008

Application Developer

Project: Order Broker Backend Services (OB BE)

Description:

Dell customers places all the orders either online i.e. through Dell.Com or

offline i.e. through cus-tomer care unit across the globe.

From online itself around 50,000 orders are placed each and every day

across the whole world and this particular application is responsible for

processing this huge number orders through vari-ous channels. These

channels consists of various components each performing different process-

ing on the order. These channels are developed with Windows Services known

as OrderBroker Backend that picks up orders from the database one by one

and process them through various channels based on the region from which

the order has been placed.

Responsibilities:

. Involved in SDLC life cycle from the Requirements to development, unit

testing and deployment of the application.

. Developed Business, Data and Windows Service layers of the

application.

. Extensively used Windows Services, Web Services, .Net framework 2.0,

C#, Visual Studio 2005 and Oracle 10g.

. Developed Windows Services that processes the orders received from

online DELL.COM application.

. Developed Web Services that pulls data from other regions like EMEA

and APJ.

. Worked with XML.

. Developed business classes and business logic in C#.

. Coordinating with the end application users.

. Reviewing code before delivery.

. Unit Testing.

Technologies: .NET 2.0, Microsoft Visual Studio 2005, Windows Services,

XML, Web Services, Oracle 10G, Microsoft VSTS (configuration management).

Environment:

TFS, Windows Services Consol

Project: Global Email Services (GES)

Description:

It's a combination of Web Service and windows service application which is

responsible for sending multi lingual order

(Acknowledgement/Confirmation/Cancellation/Change/Shipping) emails to the

customer and sales representatives across the world. Any applications

dealing with Sales and Order of Dell products should use the web services

exposed by GES to send emails.

Responsibilities:

. Involved in SDLC life cycle from the Requirements to development, unit

testing and deployment of the application.

. Developed Business, Data and Windows Service layers of the

application.

. Extensively used Windows Services, Web Services, .Net framework 2.0,

C#, Visual Studio 2005 and Oracle 10g.

. Developed Web Services to implement SOA which are consumed by the

other applications in the order processing chain to trigger multi

lingual (based on region) email notifications at various stages of the

order.

. Developed Windows Services that processes the orders received from

online DELL.COM application.

. Worked with XML, XSLT and XPATH to generate multi-lingual email body

depending upon the region.

. Developed business classes and business logic in C#.

. Coordinating with the end application users.

. Reviewing code before delivery.

. Unit Testing.

Technologies: .NET 2.0, Microsoft Visual Studio 2005, Windows Services,

XML, Web Services, Oracle 10G, Microsoft VSTS (configuration management).

Environment:

TFS, IIS 6.0, Windows Services Consol

PMIFM UK Duration August 2006 -

Jan 2007

Application Developer

Project: Raptor

Description:

Developed a web based field marketing management system. The use of this

application is to ful-fill day-to-day operations related to the business of

the client and there by increasing the overall out put of the organization.

This application inputs data collected by the field executives working in

different part of UK for their respective clients and generates the

reports, creates questioners and manage customer in-formation and the

information of field executives and their respective managers. After

receiving order from the customer collect feed of a particular product the

system allocates the filed execu-tives in respective region based on their

location and after the field executives collect data they in-put those into

the system, which then generates necessary reports to provide required

informa-tion.

Responsibilities:

. Involved in SDLC life cycle from the Requirements to development, unit

testing and deployment of the application.

. Developed Business, Data and Presentation layers of the application.

. Extensively used ASP.NET, .Net framework 2.0, C#, Visual Studio 2005,

Web Services, AJAX and SQL Server 2000.

. Developed Web services to implement SOA based architechture in the

middle layer of the application that interacts with SQL Server

Database which in turn was consumed by the ASP.NET web UI.

. Hosted the Web service on IIS.

. Developed the web pages that present data to the users by consuming

the WCF services in middle layer.

. Designed the database of the application on SQL Server 2000.

. Developed Stored procedures, functions and Triggers using SQL Server

2000.

. Developed business classes and business logic in C#.

. Ajax control toolkit and Ajax controls are used to provide interactive

web interface to users.

. Written Java script codes.

. Coordinating with the end application users.

. Reviewing code before delivery.

. Unit Testing.

Technologies: C#, .NET Framework 2.0, IIS 6, ASP.NET, XML, SQL Server 2000,

Web Services

Environment:

IIS 6.0, Visual Source Safe

Probrand, UK

Duration Dec 2004 - July - 2006

Application Developer

Project: Sales and Marketing Yields (SAMY)

Description:

Developed a large web based enterprise application which handles the day to

day business of the client by sending quotations to the customers, placing

orders, recording delivery information, managing various annual maintenance

agreements, selling various after employment services, managing customer

information etc. and there by increasing the overall productivity of the

organi-zation.

Responsibilities:

. Involved in SDLC life cycle from the Requirements to development, unit

testing and deployment of the application.

. Developed Business, Data and Presentation layers of the application.

. Extensively used ASP.NET, .Net framework 1.1, C#, Visual Studio and

SQL Server 2000.

. Developed the web pages that present data to the users using ASP.NET

and C#.

. Designed the database of the application on SQL Server 2000.

. Developed Stored procedures, functions and Triggers using SQL Server

2000.

. Developed business classes and business logic in C#.

. Written Java script codes.

. Coordinating with the end application users.

. Reviewing code before delivery.

. Unit Testing.

Technologies: C#, .NET Framework 1.1, IIS 6, ASP.NET, SQL Server 2000

Environment:

IIS 6.0, Visual Source Safe

Standard and Poors, UK

Duration May 2004 - Nov 2004

Application Developer

Project: Funds-CMS

Description:

Developed a data feeding engine for one of world's leading provider of

independent credit ratings, market indices, risk evaluation, investment

research, data and valuations.

This is a data feeding engine which collects data from various CSVs entered

by different fund managers across 21 countries and insert them into the SQL

Server 2000 database in a proper structure which in turn is being displayed

by the web pages (developed by a different team).

This engine has been built purely on SQL Server 2000 using stored

procedures and DTS pack-ages to fetch data from the CSVs and insert them

into the SQL Server 2000 database in a proper structure.

Responsibilities:

. Developed Stored procedures, functions and Triggers using SQL Server

2000.

. Developed DTS packages.

. Coordinating with the end application users.

. Reviewing code before delivery.

. Unit Testing.

Technologies: SQL Server 2000, DTS Packages

Environment: Windows, Visual Source Safe



Contact this candidate