Project Sql Server

CARRER OBJECTIVE:

To be efficient, capable and leading software professional working on

cutting edge technologies in thriving on excellence and challenges. To seek

a Competitive edge and a challenging work environment in the field of

Information Technology.

EXPERIENCE SUMMARY

. Senior Software Engineer having more than 7 years of experience in

Software Development Life Cycle including analysis, development and

testing.

. Involved in developing various kinds of Enterprise Level Distributed

applications which include Thin Client, Smart Client and Server

applications.

. Experienced in building applications using Client/Server architecture;

designing highly scalable OOAD and Service Oriented Architecture(SOA)

based business applications for Banking and Finance, Healthcare and

Retail sectors using Microsoft .NET Framework 2.0, 3.5 and 4.0, ASMX

Web Services, WCF with C# 3.0,4.0, ADO.NET, XML, XSD, MVP and SQL

Server.

. Hands-on experience with Configuration Management Tools like MS VSS,

Tortoise SVN, Team Foundation Server and GIT.

. Experienced in working with WebServiceDefinitionLanguage (WSDL) in

Middleware services with SOAP 1.0 and SOAP 1.1 protocol

specifications.

. Worked on DataBase First approach of .NET Entity Framework v.5.0 using

the EDMX Model.

. Hands on experience in designing the Report Definition Language (RDL)

using the SQL Server Reporting Services 2010.

. Worked on different types of APIs like Aspose v7.6.1, SoftArtisans

OfficeWriter 7.1 to generate various kinds of advanced MS Excel

reports.

. Used IBM Rational Clear Quest, YouTrack, HP Quality Center to manage

the work items and issues raised during various phases of development.

. Worked in various XML based technologies like XSLT, XSD etc.

. Used Microsoft Visio to visualize and design standard software

application layers and modules in form of UML diagram.

. Developed .NET desktop applications using various external user

interface controls like Infragistics v12.2, DevExpress12.2 etc.

. Built Middleware services using IBM WebSphere DataPower tool with

FrontSideHandler(FSH), Back Side handler(FSH), Enterprise Service Bus

etc.

. Used IBM WebSphere Web Service Registry And Repository(WSRR) to

maintain the SOA governance.

. Thoroughly test the developed applications using Unit test and

performed code reviews to ensure proper coding techniques, standards,

and approaches as well as adherence to standards being followed

. Worked closely with Business analyst, technical team, stack holders /

clients to understand requirements and transform into Functional

specifications and Technical Specifications.

. Have consistently met project schedules and deadlines with high

quality deliveries.

. Excellent Inter-Personal, Communication Skills, Analytical and Problem

Solving skills.

. Results oriented with a strong work ethic and team oriented

Development experience

. Willing to learn and adapt to new challenges, has excellent

communications skills and strong interpersonal skills, which provide

the ability to interact with client, end-users, managers, technical

personnel and team members.

TECHNICAL SKILLS:

C# 3.0, 4.0

Web Services

Programming Languages, Simple Object Access Protocol(SOAP)

Patterns, Protocols and Architecture Pattern - Model View Presenter(MVP)

XML Technologies Software Design Patterns

Extensible Markup Language(XML)

Extensible Stylesheet Language(XSL)

Extensible Application Markup Language(XAML)

.NET Web Services

Windows Communication Foundation

ADO.NET

Windows Services

Tools Microsoft Visual Studio 2005/2008/2010/2012

Rapid SQL

SOAP UI

IBM Web ServiceRegistryAndRepository(WSRR)

IBM WebSphere DataPower X152 Appliance

Dia for UML and Class Diagrams

RDBMS/Databases/Reporting SQL Server 2000/2005/2008/2012, Oracle 10G, MS

Services Access, SSRS 2012

Operating Systems MS Windows XP, Windows 7, 2000/2003/2008 server

Batch Scheduler Autosys

Source Code Maintenance Microsoft VSTFS, Visual Source Safe,

Subversion(SVN), GIT

Application Hosting IIS 5.0, 6.0, 7.0

Services

SOA Technologies Windows Communication Foundation, IBM Websphere

Datapower, IBM Web Service Registry and

Repository(WSRR)

XML Tools Altova XML Spy

MS Office Tools MS Office, Excel, Visio

Change/Defect Management IBM Rational ClearQuest 7.1.1.3

Incident Management HP Service Manager

External API and UI Tools Aspose v7.6.1

DevExpress v12.2

Infragistics v12.2

Education

Bachelor in Technology with Information Technology from West Bengal

University Of Technology(WBUT), Kolkata, India with 1st Class, August 2006.

Employment Details

ANA-DATA Consulting Inc. - Dec 2013 - Present

IBM India - Sep 2011 - Nov 2013

Cognizant Technology Solutions - Apr 2011 - Sep 2011

Syntel Ltd. - Oct 2006 - Apr 2011

PROFESSIONAL EXPERIENCE

Dec 2013 - Customer Name: Stone Harbor Investment Partners, New York, USA

Present

Project Title: SBAM

Position: Software Developer

Project Stone Harbor Investment Partners offers a range of fixed income

Description investment strategies and multi-sector allocation portfolios

via separately managed accounts as well as institutional funds.

It has a centralized asset management application named - SBAM.

This application is being used extensively to generate all

kinds of risk reports, performance reports and analyzing

holdings data etc. This is a multi-tier application and the UI

is enriched with few custom tools like Infragistics, DevExpress

etc. Entire application is built on .NET framework 4.0.

Roles and Enhancing the existing application as per the functional needs.

Responsibility

Designing and developing the software modules, coding, Unit

Testing and deployment.

Working on the Sql Server Reporting services which are very

crucial in generating various Analytics and Performance reports

for the operations team.

Developed various new modules using .NET Framework 4.0, C#

language, MVP design pattern, WCF etc.

Developed new database procedures in SQL Server 2012 using SQL

Server management Studio.

Built various excel reports and PDF reports using SSRS 2012,

Aspose and OfficeWriter.

Implemented new screens using Infragistics v12.2, DevExpress

v.12.2 UI controls.

Used the Infragistics.WIN.UltraWINGrid vastly in this

application.

Used Microsoft Visio and Dia to design the modules and low

level architecture flows

Prepared & executed Unit Test Cases, Technical Specifications

and Functional Specifications.

Ensures issues are identified, tracked, reported on and

resolved in a timely manner, provided 24/7 support.

Team Size 20

Technical C#.NET, Microsoft Visual Studio 2012, Database- SQL Server

Environment 2008, Aspose 7.6.1, Dev Express 12.2, Infragistics 12.2, GIT,

YouTrack, Aspose v12.2, DevExpress v.12.2

Sep 2011 - Customer Name: Horizon BCBSNJ, USA

Nov 2013 Project Title: Message Oriented Middleware

Position: Senior System Engineer

Project Horizon Blue Cross Blue Shield of New Jersey - has a number of

Description individual systems that are integral to their business. The

purpose of MOM is to develop an enterprise wide common

messaging infrastructure for the interchange of information

between systems. The desired goal out of MOM is to provide

clients a set of services that need information from a system.

Now client only needs to call a set of centrally managed

Message Services, and these Services will use the pre-built

transports/interfaces such as Web Services or MQ Series to

perform the data interchange tasks. The purpose of MOM is to

implement the Message Oriented Middleware (MOM) environment to

provide the customer's service representatives with real time

information related to Claim, Provider, Member, Billing and

Payment.

Roles and Work on any high priority issues raised by the client/end user

Responsibility for the particular application or interfaces and ensure 24*7

availability of the applications.

Design the change which is occurring for the new enhancements

or Work Requests.

Preparing Class B, Class C, Class D level estimation documents

for the new changes coming into the MOM Application.

Create Low Level Design documents for the service which is

going to be impacted for the enhancement.

Prepare Unit Test cases for the new functionality which will be

deployed into different regions post the execution of these

unit test cases.

Work on in-flight enhancements of the application for future

releases. Work on the coding or programming part of the

functionality to give the physical shape to the requirement.

Prepare the Deployment Guides for the newly implemented

functionalities. These guides will be used by the Release

management team while deploying the functionality into

different regions like SIT, UAT etc. PROD Deployment will be

done by the MOM team only.

Preparing Deployment Plans for the Monthly Scheduled PROD

deployment. Deploy the functionality into PROD environment once

the Work Request gets UAT business sign off.

Providing PROD support to the existing MOM Web Services and IVR

services.

Leading a team of 8 senior IBM Datapower developers and 4

senior Microsoft .NET Developers.

Developing modules in both IBM DataPower and Microsoft .NET

technology.

Team Size 30

Technical C#.NET, Microsoft Visual Studio .Net 2005, Database- SQL Server

Environment 2008, IBM WebSphere DataPower XI52, IBM WebSphere Web Service

Registry and Repository, SOAP UI, Microsoft Visio, IBM

WebSphere MQ Series, Team Foundation Server, Subversion(SVN)

Apr 2011 - Customer Name: SCHWANS(USA)

Till date Project Title: Application Maintenance

Position: Associate

Project This project is world's one of the biggest Mainframe to .NET

Description migration project happened during the year of 2000 - 2002. It

automates the supply chain management of SCHWANS and driven

SCHWANS business to a next higher level.

Role and Solving the incidents in PROD environment.

Responsibility Closely worked with the end users to solve the incidents they

are facing with the Handheld device. Also worked as data

analyst for this project.

Team Size 15

Technical C#.NET, Microsoft Visual Studio .Net 2005, Database- SQL Server

Environment 2005

Feb 2009 - Mar Customer Name: American International Group (AIG)

2011 Project Title: AIG GPS

Position: Technical Lead - .NET

Project The purpose of GPS project is to make this system in such a way

Description that it should be capable of supporting the requirements of

New York and Hong Kong region pricing operations including

additional price feeds, price source hierarchies, Creation of

Golden Copies and Publication. On Daily basis, total around

26000 AIG Holding securities are being processed by this GPS

application.

Role and Preparing LLDs for the initial establishment of the new

Responsibility screens.

Development, Unit Testing. Coordinate design and implementation

of application.

Writing the Adapter code in order to retrieve the AIG holdings

from PAM database and update the database with the new price

received from various vendors.

Designing the GPS application modules using the MVP pattern

Interaction with the stake holders of the screens and features;

and transforming the functional points into low level technical

details

Used Infragistics v7.1 as the external UI interface controls

Wrote code in C# 2.0 using the Microsoft Visual Studio 2005

IDE.

Provide technical leadership to the junior team member.

Giving PROD Support during the Warranty Support period. Also

played a role of onsite coordinator for my project. Played a

crucial role to solve various functional and technical PROD

issues quickly within the given timeline.

Responsible for providing appropriate test environments and

test programs.

Designed and developed Multi-tier and multi layered scalable

workflow application using .NET 2.0.

Team Size 25

Technical C#.NET, Microsoft Visual Studio .Net 2005, Database- Oracle,

Environment Infragistics Tools, Oracle 10g, Autosys.

Jul 2007 - Customer Name: Wells Fargo Bank, USA

Jan 2009 Project Title: SG2 (ShotGun2)

Position: Analyst Programmer

Project The purpose of the project is to develop a new system

Description infrastructure supporting Wells Fargo Financial Loaning (WFFL)

business processes. This project consists of stepwise loan

processing such as Loan Origination, Property Mortgage, Due

diligence on Property, Guarantor of the Loan, Underwriting and

Settlement of Loan.

Role and Involved in the partial development that was a part of the

Responsibilit maintenance activity, code review of the developed code and the

y unit testing of the project.

Wrote the modules using .NET 2.0 an C# 2.0

Team Size 6

Technical C#, Win forms, Microsoft Visual Studio .Net 2003, SQL Server

Environment 2003, Web Services.

Nov 2006 - Customer Name: Wells Fargo Bank, USA

Jun 2007 Project Title: - LIMS (Leasing Information Management System)

Position: Analyst Programmer

Project The purpose of the project is to develop a new system

Description infrastructure supporting

Wells Fargo Financial Leasing (WFFL) business processes. This

project consists of stepwise

lease processing such as Lease Origination and an Entire Life

cycle of a Lease. While doing all such steps system generates

different documents that take the data from database.

Role and Involved in coding .NET Programs, writing stored Procedures and

Responsibilit direct onsite communication.

y Developed a number of batch jobs using .NET Framework 2.0

Added new features like lease verification, lease entitlements

etc. to the existing screens .

Team Size 69

Technical C#, Win forms, Microsoft Visual Studio .Net 2003, SQL Server

Environment 2003.

PROFESSIONAL ACCOMPLISHMENT

Reward & Certifications

* MCP: Microsoft .NET Framework - Application Development Foundation

* Orion Award winner in IBM in 2013

* Best Team Member Award in Cognizant in the year of 2011

* Smart Team member award for Q3 of 2007 in Syntel Inc.

* Smart Individual Employee award for Q2 of 2008 in Syntel Inc.

* Insurance Excellence Award in August 2010 in Syntel Inc.

* Certified with Banking and Financial Services domain (NCFM) from

National Stock Exchange

(NSE). INDIA.

OTHER PARTICULARS

Total Industry Experience: 7 Years 6 Months

Current Address: 201 Saint Pauls Avenue, APT 16W, Jersey City, NJ 07306,

USA

Permanent Address: K-12, Purbasha, Sodepur, Kolkata -700113, INDIA

Passport No: L2532268

Date Of Birth: 01/20/1984

LinkedIn: http://lnkd.in/7x3k7n

Email: ***.***********@*****.***

Cell: 848-***-****

Contact this candidate