Post Job Free

Resume

Sign in

Sql Server Developer

Location:
Bellevue, WA, 98007
Posted:
May 21, 2013

Contact this candidate

Resume:

Suman Vadde

Phone No: 773-***-****

abvuqv@r.postjobfree.com

/cgi-

bin/compose?mailto=1&msg=MSG1022089468.46&start=869797&len=53319&src=&type=x

&to=anurodh_k%40rediffmail%2ecom&cc=&bcc=&subject=&body=&curmbox=F000000001&

a=e5bebac9b4f42009d60eb8da0d4cdf08

Professional Summary:

Having 7+ years of work experience in Microsoft Technologies BizTalk Server

2004/2006/2006 R2/2009, C#.net, Ado.Net, SSIS, SQL server and XML.

Strong expertise in all aspects of Software Development Life-Cycle (SDLC),

Testing & Implementation and Support with good skills in application

development of Integration systems.

Strong Working experience in Microsoft IDEs Visual Studio and SQL server

management studio.

Expertise Experience and understanding of Microsoft BizTalk Server 2006

(R2)/2009, Adapters, Windows Communication Foundation (WCF).

Good Experience in analysis, design, development, implementation and

support of EAI solutions and B2B solutions.

Excellent Expertise in developing BizTalk Server Solution artifacts like

Orchestrations, Maps, Schemas, Adapters, Ports and Pipelines.

Extensive working experience in configuring and implementing out of the box

BizTalk Adapters such as SQL, FTP, File, SMTP, SOAP, WCF, and SAP.

Design and programming experience with web technologies like XML, XML

Schema, XPATH, WSDL, Web Services and WCF.

Expertise Working experience in WCF and Web Services creation and

implementation in BizTalk 2006 (R2) and also consumed Web Services hosted

by other systems.

Good knowledge on using SOAP UI tool to test various synchronous web / WCF

services.

Good working knowledge and experience in using SQL SERVER 2005 /2008 and

SQL Server Integration Services (SSIS).

Strong experience in developing Stored Procedures and implementing them in

BizTalk solution.

Excellent debugging skills using BizTalk Administration and Health and

Activity Tracking (HAT) tools. Strong knowledge and familiarity on BTS

Business Rules Engine (BRE) and Business Activity Monitoring (BAM).

Excellent skills in understanding business needs and converting them into

technical solutions.

Expertise in debugging and resolving the production issues and monitoring

the production environment.

Monitored the BizTalk group hub for the suspended messages and debugged the

orchestrations for identifying the flow.

Monitored the BizTalk WCF services in IIS for high availability and also

monitored the SQL server for all the BizTalk databases.

Flexible and capable of performing multiple roles, during the lifecycle of

the project, such as requirement analysis, design, development and

administration.

Effective team player with excellent problem solving abilities, quick

learner, easily adaptable to new environment with meticulous nature and a

persevering attitude with strong technical skills.

Education:

Bachelor of Engineering, Jawaharlal Nehru Technological University,

Hyderabad, India.

Technical Skills Set:

Operating system Windows 2003/2008, XP and Windows 7

MW development Microsoft BizTalk Server 2006R2/2009,

technology Mapper, Orchestration and Pipeline Designer

and HAT

.Net Technologies .Net 3.5, C#.net,ADO.Net, Web Service and

WCF

Application / Web server IIS 6.0

Languages C#,SQL,XML

IDEs Visual Studio, SQL server Management Studio

RDBMS SQL Server 2005/2008

ETL SSIS

Packages MS-Office, XML, Knowledge on XSLT and

X-path,OAGIS

Version Control Team Foundation Server(TFS), Microsoft

Visual Source Safe(VSS)

Tools SOAP UI, Octopus

Professional Experience:

ESB Message Bus - Redmond, WA

BizTalk Consultant, Nov 2012 - Till Date.

Environment: BizTalk Server 2009, Visual studio 2008, C#.Net, SQL server

2008, Microsoft Team Foundation Server, Octopus

Description:

The ESB Message Bus plays a key role in onboarding OBA's to ESB. ESB CTP

Help team also provides continuous support to Tenant team's for new

releases of ESB. Tenant teams play an important role of bridging between

OBA Team and ESB CTP Help Team. Currently MDM HCP and Org are the key OBA's

(Publishers) for ESB with 18+ subscribers. ESB 3.0 targets to standardize

the Enterprise Bus for MSIT and onboard more MSIT apps as OBAs.

Responsibilities:

Generated and Developed Schemas, Maps and Orchestrations.

Published BizTalk Orchestration as synchronous WCF service using BizTalk

WCF service publishing wizard.

Consumed all the synchronous SAP services from the BizTalk Orchestration.

Deployed the code into QA servers for system Integration testing.

Tested all the synchronous BizTalk WCF services with SOAP UI testing tool.

Performing the smoke test in ESB CTP environment before releasing the

server.

Involved in the connectivity test for all environment OBA endpoints from

corresponding environments of the BizTalk server.

Monitored the BizTalk WCF services in IIS for high availability and also

monitored the SQL server for all the BizTalk databases for Perf testing.

STEP - Wolters Kluwer, Chicago, IL

BizTalk Developer, Nov 2011 - Jun 2012.

Environment: BizTalk Server 2009, BVTS Visual studio 2008, C#.Net, SQL

server 2008, Microsoft Team Foundation Server, SQL Server Integration

Services, SOAP UI

Description:

Wolters Kluwer is a leading global publisher and software product and

information provider to professionals around the world. CCH, one of the

four brands of Wolters Kluwer Law & Business is the leading provider of

information services, software and workflow tools for tax, accounting,

legal and business professionals. The SAP TAL ETC Program (STEP) is an

initiative for TAL to migrate from existing Order to Cash Systems (OMS and

VISTA), multiple financial systems (PeopleSoft & JD Edwards) and supporting

data warehouses and reporting systems to one integrated SAP implementation

based on the existing LTRE implementations with a consistent set of

business rules across TAL USA. The goal of STEP Project is integrating

TAL's multiple legacy back office systems under a single SAP framework.

STEP addresses the transition of underlying ERP data and processes from OMS

to new, SAP data sources.

Responsibilities:

Involved in requirement analysis and helped the Business Analyst team to

understand and correlate the requirements.

Provided high level design and low level design documents by understanding

the functionality.

Involved in the connectivity test for all environment SAP services from

corresponding environments of the BizTalk server.

Involved in facilitating the connectivity for the SAP services from BizTalk

server using firewall requests with infra-structure team.

Implemented the business process defined by the business analyst and

creating the Orchestrations necessary to implement those using BizTalk

Server 2009.

Generated and Developed Schemas, Maps and Orchestrations.

Consumed all the synchronous SAP services and Java web services from the

BizTalk Orchestration.

Created and executed all the unit test cases, supported various teams for

integration testing.

Published BizTalk Orchestration as synchronous WCF service using BizTalk

WCF service publishing wizard.

Tested all the synchronous BizTalk WCF services with SOAP UI testing tool.

Generated MSIs and Bindings of the BizTalk applications web support team to

deploy the BizTalk application in other environments like test and

production.

Monitored the BizTalk WCF services in IIS for high availability and also

monitored the SQL server for all the BizTalk databases.

Monitored the BizTalk group hub for the suspended messages and debugged the

orchestrations for identifying the flow.

Developed a tool to reprocess all the failed orders / transactions which

are occurred due to any outage or network glitches.

Sales Process Integration - Tyco Flow Controls, Singapore.

BizTalk Developer Support Engineer, Feb 2010 - Oct 2010

Environment: BizTalk Server 2009, Visual studio 2008, C#.Net, SQL server

2008, Microsoft Team Foundation Server, Microsoft Dynamics CRM 4.0, SOAP

UI

Description:

Tyco Flow Control is a major business segment of Tyco International and a

leading global supplier of flow management, water and environmental systems

and thermal control solutions. Tyco BizTalk Integration project enables the

integration of Tyco's SAP systems and Microsoft CRM Dynamics system.

BizTalk interfaces for various transactions like Opportunity, Contract,

Quote, Sales Order, Purchase Order, Delivery Order, Invoices have been

developed.

Responsibilities:

Involved in requirement analysis and helped the BA team to gather the

requirements.

Developed BizTalk schemas to accept the various inbound and outbound

messages across the BizTalk environment.

Created transformations using BizTalk mapper editor for the enrichment of

data.

Designed and developed business process flow using BizTalk Orchestration

editor based on the functional flow diagram.

Exposed all the synchronous BizTalk Orchestrations as WCF services using

BizTalk WCF service publishing wizard.

Created and executed all the unit test cases, supported various teams for

integration testing.

Extensively used SOAP, FILE and SQL adapters to connect various inbound and

outbound applications.

Exported MSI and Binding files for the deployment of the services in

different environments (Test and Production).

Used SOAP UI testing tool for the testing of BizTalk WCF services.

Used Health and Activity Tracking tool for orchestration debugging.

Monitored the BizTalk group hub for the suspended messages and debugged the

orchestrations for identifying the flow.

Monitored and checked the health of all the production SQL server, BizTalk

servers and web servers.

Allianz Life Insurance - FFIC, India

BizTalk Consultant, Nov 2008 - Dec 2009.

Environment: Microsoft BizTalk Server 2006 R2, Visual studio 2008,

Microsoft C#.NET, Microsoft SQL Server 2005, Microsoft Team Foundation

Server

Description:

Allianz life insurance is the Insurance client. Client has their operations

throughout world. We have done the project for their BPM Activities using

Lombardi Team works tool. In the project the company representative takes

the requests from the customers and processes the request and publishes the

request details through the BizTalk to Onbase and Inforce systems. After

getting the response from the Onbase system sends the email notifications

to the customers with the attachments. Finally using performance server

creates the graphical reports and charts based on request.

Responsibilities:

Involved in requirement gathering, analyzing, coding and deploying the

solution.

Developed TSD (Technical System Design) document for the development and

also developed Implementation notes for release of the Interfaces.

Exposing services as a web services and Consuming external web services.

Converting input data to the PDF and Excel formats.

Creating email notifications using SMTP Adapter.

Creating graphs and charts using performance server.

Generated archive files for the deployment of the Interfaces in different

environments like Integration testing and Pre Production and Production.

Used Health and Activity Tracking (H.A.T) tool and event viewer for

tracking transaction message flow of the BizTalk orchestration.

Fuel Price Optimization - Tesco HSC

BizTalk Developer May 2008 - Oct 2008

Environment: BizTalk Server 2006 R2, Visual studio 2008, Microsoft C#.NET,

Microsoft SQL Server 2005, Microsoft Team Foundation Server, SOAP UI.

Responsibilities:

Involved in requirement analysis and worked with Business analyst team to

understand the requirements during the requirement gathering workshop.

Worked on high level design and low level design documents by understanding

the functionality.

Developed XSD schemas using BizTalk schema editor to accept the various

inbound and outbound messages across the BizTalk environment.

Implemented data enrichment using BizTalk mapper editor for various

interfaces from inbound to outbound formats.

Developed the business process flow using BizTalk orchestration to automate

the complete process.

Used WCF_BasicHttp (SOAP protocol) adapter to consume/call the SAP

services.

Published BizTalk orchestrations as WCF service using BizTalk WCF Service

Publishing wizard to cater the synchronous communication.

Created and executed Unit test cases supported various team for integration

testing.

Testing of BizTalk WCF services with SOAP UI testing tool.

Generated MSI and Binding files for the deployment of BizTalk application

in other environments like test and production.

IM (Integration Manager) - Intel, India.

BizTalk Developer, Mar 2008 - May 2008

Environment: BizTalk Server 2006 R2, Visual studio 2008, Microsoft C#.NET,

Microsoft SQL Server 2005, Microsoft Team Foundation Server, Tibco IM.

Description:

This project is to migrate the existing Tibco integration system into

BizTalk server 2006 R2.

Responsibilities:

Involved in requirement gathering and analysis.

Involved in reengineering the existing Tibco system.

Provided high level design and low level design documents by understanding

the functionality.

Worked on POC for the WCF Oracle Adapter.

Developed BizTalk schema artifacts according to inbound and outbound

message formats.

Developed transformations between various messages formats using BizTalk

mapper Editor.

Implemented Business process flow using BizTalk orchestrations editor based

on the functional flows.

Used FTP, File and SQL adapters to connect both inbound and outbound

applications.

Created and Executed Unit test cases and supported various team for

integration testing.

Generated MSI and Binding files for the deployment of BizTalk services in

other environments like test and production.

Supply Chain Management - Intel, India.

BizTalk Developer, May 2007 - Feb 2008

Environment: BizTalk Server 2006 R2, Visual studio 2008, Microsoft C#.NET,

Microsoft SQL Server 2005, Microsoft Team Foundation Server.

Responsibilities:

Involved in requirement gathering, analysis and development.

Developed various BizTalk artifacts like schemas for inbound/outbound

message formats and maps for transformations and data enrichment.

Used BizTalk Orchestration Designer for designing and development of

business process, flow charts, various transactions and Exception Handling.

Created receive and send ports to transport the messages between various

inbound and outbound applications using BizTalk server.

Scheduled to BizTalk receive locations to run the service at specified time

interval.

Called external assemblies from the Orchestration to send mails and remove

the service headers form the raw xml messages.

Generated MSI and Binding files for the deployment of the BizTalk

interfaces in various environments like test and production.

Bank Loan Processing - NatWest, UK.

Developer, Dec 2006 - May 2007

Environment: BizTalk Server 2006, Visual studio 2008, Microsoft C#.NET,

Microsoft SQL Server 2005,

Contribution:

Responsible for requirement analysis, design and development.

Developed Validations in Identifying Individuals.

Implementing required database access using ADO. NET.

Deploying source code into QA machine and manual testing.

Developing User Controls

Involved in creating the BizTalk Schemas and Maps.

CMS - PMG Ltd, US.

Developer, May 2005 - July 2006

Environment: Visual studio 2008, Microsoft C#.NET, Microsoft SQL Server

2005.

Contribution:

. Responsible for requirement analysis, design and development.

. Developed Validations in Identifying Individuals.

. Implementing required database access using ADO. NET.

. Deploying source code into QA machine and manual testing.

. Developing User Controls



Contact this candidate