Sql Server Project

Summary:

. IT (Information Technology) Technical Lead with over 9 yrs of

extensive hands-on and experience in business process analysis,

software design/development, execution and implementation.

. Excellent communication skills with a history of developing effective

relationships with technical staff as well as senior management.

. Expert in designing and developing of EAI layer using BizTalk server

2004/2006 R2.

. Good experience in developing projects in .NET framework, web

applications and tuning the applications.

. Solid principles and techniques while approaching software development

from both practical and process perspective. Methodical approach to

work. Ability to prioritize problems, diagnose them and manage them

through to their resolution.

. Complete understanding of SDLC (Software Development Life Cycle).

. Experience in requirements gathering, system and database

design, programming, regression testing,

. Good knowledge in Object Oriented Analysis and Design (OOAD), and SQL

Server.

. Ability to deliver comprehensive BI through MS solutions including MS

Excel, Microsoft Office Share point Server (MOSS), and Performance

Point Server 2007

. Excellent verbal and interpersonal skills; good analytical and

debugging skills; systematic approach to system architecture design

and programming tasks

Software: Microsoft BizTalk Server 2004/2006/2006R2, Microsoft SQl64 Bit

adapter, Swift accelerator, Edi base adapter, Microsoft Visual Studio

.NET 2003/2005/2008, Microsoft Office Share Point Server 2007, Microsoft

Office InfoPath, IBM MQ Series 5.2, C sharp, XML Spy, MS SQL server

6.0/6.5/7.0/2000/2005,Oracle 7.0/8.0/9i, Microsoft Project.

Languages and technologies: JAVA with JDK 1.5,J2EE, C#, .Net,

ADO.NET,ASP.NET, XML, XSLT, X Path, DTD, XSD, Service Oriented

Architecture (SOA), WCF, HTML, ASP, Web Services,SOAP,WSDL, MSMQ

Protocols and networking: FTP/SFTP, HTTP/HTTPS, SOAP, POP3, SMTP.

Operating systems: Windows 2003 server, Windows Vista, Windows XP,

Windows 2000 server, Window 95

EDI Transactions: ANSI X12, 810, 834, 835, 837, 997

Accelerators: Covast EDI, Swift, my SAP

Swift Messages : MT535,536,900,910,598,202,210,541,543,304

Certifications

. Microsoft Certified Professional of Designing and Implementing

Solutions with Microsoft BizTalk Server 2004.

. Java certified programmer (JCP) from Sun Microsystems.

Education

Bachelors of Science Kanpur University 1995 India

Advanced Diploma in Software Engineering Aptech LTD 1998, India

Cleared 'O' Level from DEOACC Society, Indira Gandhi Open University,

2000, India

Certificate in Computers (CIC) from IGNOU, 2001, India

Projects Summary:

Radian Group Inc.

Dec2009 to Till Date

BizTalk Business Analyst

Radian is a leading provider of credit enhancement for the global financial

and capital markets. Radian provides financial guaranty and mortgage

insurance to protect lenders against loan default and to enable homebuyers

to purchase homes more quickly and with smaller down payments.

. Designed/manage applications which consumes and publish the web

services from BizTalk environment and provides information using SOA

concepts

. Applications use ESB tool kit for error handling and notifications.

. Install, configure, and develop SQL Server Reporting Services (SSRS)

. Develop and deliver dynamic reporting solutions using SQL Server 2005

Reporting Services (SSRS)

. Documented/knowledge transfer the complete application design to the

company employees for the easy management of applications.

Environment: BizTalk Server 2006R2/2009, C#, .Net3.5, ESB 2.0

Implementations, Soap UI,WSDL,XML,XML schema design, XSLT, Windows

2003,IIS,visual studio 2005/2008, Web services, WSDL, SQL server 2005

ING Investments, New York City

June 2008 to Nov 2009

Business Analyst / BizTalk Lead

ING a global financial institution of Dutch origin offering banking,

insurance and asset management to over 85 million private, corporate and

institutional clients.

. Established BizTalk development framework and lead a team of five

developers through the full development life cycle of the BizTalk

applications of the client's ("ING Third-party Outsourcing project).

. Analyzed, designed, developed and supported 25 BizTalk applications.

. Interacted with technical staff and business staff for requirement

determination and the technical documentation.

. Involved with building the business Logic, functional definition, design

and developed workflows code to communicate between the MQ series and

database through BizTalk orchestrations.

. Orchestrated long-running business processes that required system

touch points as well as workflow definitions and business rules.

Designed and deployed the customized solutions that routes the Swift

like messages to MQ channels.

. Involved in installation, packaging and the management of applications

on the production/UAT servers.

. System load balancing and fail-over architecture were designed and

planed. Fine tuning work was performed to remove performance

bottleneck and to shorten performance latency.

. Documented/knowledge transfer the complete application design to the

company employees for the easy management of applications.

Environment: BizTalk Server 2006 R2, C#, .Net, SWIFT message pack2007,

XSLT, Windows 2003, MSSQL Server 2005, MQ series

HBMJ Consulting INC, New York City

Nov 2007 to May 2008

Sr. Application Engineer

HBMJ is a boutique consulting firm specializing in back-office solutions

for hedge funds, fund administrators and prime brokers.

. Designed, managed and contributed in different consulting projects for

Hedge funds industry for HBMJ clients like UBS NYC, round table North

Carolina, Brahmin NYC etc.

. Analyzed business processes and converted business needs into

developer oriented specifications and designs.

. Implemented various modules of the application using J2EE and Struts

. Designed and built customized solutions in BizTalk to integrate work

flow manager with Geneva using BizTalk orchestration, soap adapter,

FTP adapter, POP3 and SMTP adapter.

. Conducted workflow, process diagram and gap analysis to derive

requirements for existing systems enhancements.

. Prepared documents for the new developers to understand the

intricacies of the project.

Environment: BizTalk Server 2006/2004, C#, .Net, Geneva 7.0, XSLT, Windows

2003, Share Point Portal Server 2007, MSSQL Server 2005

Advent Inc, Murray Hill, NJ

Aug 2007 to Oct 2007

BizTalk Developer/Designer

Advent specializes in development of mission critical systems in the ocean

transportation vertical market

. Worked as a BizTalk consultant .Involved in managing and

troubleshooting the applications which keeps the track of goods from

the point of loading to unloading of goods.

. Actively participated on performance enhancement of EDI/EDIFACT data

coming from the FTP location of the shipping company which BizTalk

captures and transform into XML or EDI format as per the client's

requirement.

. Designed custom C# external assemblies to be used across all BizTalk

development.

. I was involved in the design changes of BizTalk solutions,

modifications in the schemas, maps, workflows, documentation of

complete workflow structure, designing deployment scripts and

configuration of BizTalk in different environments.

Environment: BizTalk Server 2006/C#, .Net MSSQL Server 2005, XML Schemas,

EDI Base adapter, XSLT, Windows server 2003 .

Weight Watchers, New York City

Jul 2006 to June 2007

BizTalk Developer

. Designed and developed solutions on BizTalk 2006 with TOPXML database

adaptor to create EAI layer which was common for their all clients.

. I was involved in Web service integration where XML Web services

(WSDL) provides the messages to the third party for credit card

authentication in the purchase module of ecommerce portal

. Coordinating with client for the specifications and oracle developers

to develop the stored procedures.

. Installed and customized a Business Knowledge system using Share Point

Portal Server 2007 for the company Intranet.

. Coordinated with the Share point portal team for designing the sites

for corporate divisions.

Environment: BizTalk Server 2006/C#, .Net MSSQL Server 2005, XML Schemas,

XSLT, Windows 2003.

Citigroup, New York City

Aug 2005 to June 2006

Designer/Integration Expert

. Lead designer/Integration expert for the Geneva 6.0 Integration

project using BizTalk 2004 to implement an end-to-end solutions.

Involved in the full life cycle of the project and actively

participated in designing, development, testing and production

support.

. In charge of converting all current data loading interfaces to the new

platform.

. Developed Custom Pipeline Components, custom functions and workflows

to handle specific file structure

. Published orchestration interfaces as a web service for Web Method

accessed by Web Method invoked SOAP messages.

. Developed Web Services to provide interaction with other web and

desktop applications.

Environment: BizTalk Server 2006/2004, C#, .Net, Geneva 7.0, XML Schemas,

XSLT, Windows 2003, IIS, SQL Server 2005 .

BITECH Ltd. New Delhi India

Jul 2003 -Dec 2004

Corporate Trainer (IT)

. Presenting seminar on latest technologies for client Chambal

Fertilizer and Chemical Ltd.

. Software development for in house projects on web consultancy.

. Studying the market condition on a continuous basis and give feedback

to the management on market expectations and competition.

Environment: C++, .Net MSSQL Server, Visual Basic, Windows 95

Perfect Software Pvt. Ltd. New Delhi India

Jul2001 - May 2003

Programmer

. Worked as a programmer on different projects.

. I developed report and payroll module for a school automation project.

. I developed module of booking and cancellation of cylinders and the

payroll for a gas agency.

Environment: C++, .Net MSSQL Server, Visual Basic Windows

Contact this candidate