Sql Server Developer
Resume:
Suman Vadde
Phone No: 773-***-****
*********@*****.***
/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