Sql Server Web Services
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