Post Job Free

Resume

Sign in

Developer Experience Business Sql Server .Net

Location:
Charlottesville, VA, 22903
Posted:
July 06, 2011

Contact this candidate

Resume:

REDDY BABU

Sr. BizTalk Developer/Administrator

E-mail id: abg73v@r.postjobfree.com

Mobile # 408-***-****

Professional Summary

. Experienced as an IT Professional/Developer for more than 8+ years of

which more than 4+ years include extensive experience in using BizTalk

Server 2006/2006 R2/2009 in design, development and implementations in

Web/Desktop/Client Server Applications and business solutions with

expertise in Microsoft technologies using .NET, Visual Studio and SQL

Server. I have performed various roles from that of a developer to an

architect in various business domains.

. Implemented BizTalk custom adapters to access the ESB. Utilized

BizTalk 2009's Business Activity Monitoring (BAM), Business Activity

Services (BAS), and Health and Activity Tracking (HAT) tools to

monitor BizTalk 2009 processes.

. 5+ years of experience in BizTalk 2004, 2006 R2, 2009, 2010.

. Extensive experience in the areas of Service-oriented architecture

(SOA), Patterns, Iterative design methodologies. Highly skilled in

Logical Analysis and Quality Assurance.

. Expertise includes Installation, Configuration and Customization of

BizTalk Server 2009/2006 R2 / 2006/2004, .Net Framework, Microsoft SQL

Server 2005/2000 in the Windows Environment.

. Extensively worked on PL/SQL Procedures, Functions, Triggers, Packages

and DTS Packages in SQL Server.

. Worked in 32 bit and 64 bit environments.

. Worked on SOA (Service Oriented Architecture) and ESB (Enterprise

Server Bus).

. Worked Extensively on SAP R/3 environment for EAI & EDI transactions

with BAPI, Idoc, LSMW and ALE Expertise in Interface programs for

importing data from feeder systems to different modules.

. Experience of configuring and mapping EDI 850, 855, 810, 820, 831,

824,864, 852,867 and 997 transactions.

. Experience of configuring and mapping of HIPAA EDI transactions 837(P,

D, I), 835, 834, 276/277, 270/271 and 278.

. Experience in the core areas like EDI/ XML and BizTalk / EDI

Configuration, ESB Toolkit, WCF, WCF-SQL, BizTalk Data Mapping using

SAP.Net Connectors, HTTP Adaptor, IDocs, ALE, COVAST Accelerator 2006,

ANSI X12, Rosetta net 3.0/3.3, EDIFACT, HIPAA 2.0/3.0 and almost of

the available BizTalk adaptors.

. Hands on experience in Share point installation, configuration, and

troubleshooting the server.

. Created SSIS Packages for Data Movement and database maintenance.

. Strong command on the application data. Excellent knowledge of various

data formatting including XML Messages, EDI, Flat Files, SAP

databases, Oracle, SQL Server 2000/2005, DB2, IDMS and IMS.

. Installed and configured all components (Enterprise SSO, Group,

BizTalk Run Server, MSMQT, Business Rules Engine, HWS Runtime and BAM

Tools) of BizTalk Server 2006 and 2004 and Covast Accelerator 2006.

. Installation of Cluster Environment also experience with Database

connectivity and failover of DB.

. Development of multi-tiered Client/Server applications along with

Internet / Intranet application development experience.

. Excellent Knowledge and Working experience of Object Oriented

programming model.

. Knowledge in Java, J2EE (JSP, Servlets).

. Excellent knowledge in writing SQL queries and stored procedures.

. Excellent Knowledge in Software Development Life Cycle models

. Excellent Knowledge in Sarbanes-Oxley Procedures.

. Experience in project management tools like Clarity and MS Project

Technical Skills

Web Servers IIS (7.0,6.0/5.0/4.0), Windows Share Point 2003/2007/2009

BizTalk File, FTP, SQL, SOAP, MSMQ, SMTP, My SAP, Web sphere MQ

Adapters adapter, HIPAA, WSE 2.0/3.0, WCF

Data Formats SOAP, ANSI ASC X12, AS2, EDIFACT, XML, IDOC, FLATFILE, WSE

2.0, COVAST EDI, RFC, BAPI

SAP ALE, SAP.NET Connectors(2.0/1.0), IDoc, RFC, BAPI

Web ASP, HTML4.0, DHTML, VB.NET, ASP.NET, COM, COM+ XML2.0,

Technologies XSL, XSLT, CSS, VBScript, JavaScript, JSP, EJB, ADO.NET,

SOAP

GUI VisualStudio.NET2003/2005, VisualBasic6.0/5.0/4.0, Visual

Interdev 6.5/6.0

Databases Oracle (9i/8i/8/7.2), SQL Server 2005/2000/7.0, MS Access

7.0/97, DB2 AS400.

Integration BizTalk 2004/ 2006/2006R2/2009/2010, BizTalk Server

Tools Administration, SAP.Net Connector, SAP XI 3.0/PI7.0

Environment Windows server 2008/ 2003/2000/98/95/3.x, Windows NT

4.0,VMWare, Virtual PC 2004/2007 and Virtual Server 2005

Programming C#, ASP.NET, VB.NET, ABAP, VB Script, Java Script, JSP,

EJB, JDBC, J2EE Web Services, C, C++, ADO.NET, Reporting

Services 2000

Tools Visual SourceSafe, Visio 2003, SFTP, Enterprise Library

1.1/2.0, BizUnit, SharePoint Services 2007, WSE

3.0,BRE(Business Roles Engine)

Professional Experience

Sr. BizTalk Admin /Developer Sep. 09 to

Till Date

Wells Fargo,MD

Responsibilities:

. Used existing Deployment utility via MSI for BTS Application

deployment into QA and Production servers.

. Managed the load across the BizTalk server group.

Environment:

. Act as the BizTalk administrator and be the single point of contact

for deployments of new projects and upgrade of existing projects.

. BizTalk 2009 installation, configuration, high availability

clustering.

. Installation and setup of Single sign on (SSO) and also involved with

clustering on SSO and SQL Server 2008.

. Hands on Experience in working on SharePoint Adapter services send

approved and denied orders to SharePoint site.

. Used BRE for validating custom rules.

. Ability to write WMI scripts and experience and in depth knowledge of

SSO.

. Tracked Messages Flow, Orchestration and logged process exceptions to

existing integration DB portal using exposed WCF Service

. Involved in Admin activities like Admin console, Perf Mon, SQL

Profiler, IIS logs etc to

Improve the performance of SQL server.

Monitoring and resolving the issues of client's server to make healthy

.

. Hands on experience in sending messages from BizTalk server to

Microsoft Dynamics using the eConnect send Adapter.

. Sending Pre approved and approved orders Email attachments to CSRM and

GM through SMTP Protocol and Email attachments sending HTML Formats.

. Developed the BizTalk Orchestration for Database Polling using Oracle

DB WCF adapter and ODP.Net adapter.

. Installed BizTalk 2009 into multi-box server farms for DEV, UAT, PROD

and DR environments.

. Assisted IT department with architecture, development and deployment

of BizTalk and .NET C# applications. Utilized MS SQL Server, SOAP,

File, and Oracle BizTalk adapters.

. Responsible for providing accurate estimations for all the integrated

related solutions.

. Hands on experience in SAP BizTalk adapter setup, SAP IDoc mapping,

SAP BAPI call and RFC calls.

. Generated SAP Services in BizTalk generating schemas and binding file.

. Hands on experience in generate an XSLT file from an existing map

created using the BizTalk Mapper.

. Schema, Map, Orchestration development for inbound order files from

new trading partner McAfee using Rosetta Net document transactions

standards.

. Map development/maintenance using proprietary application files to:

proprietary, 940, 945, 856, 997 X12 [versions 004010, 004030, and

003010VICS]; Warehouse Shipping Order, Warehouse Shipping Advice, Ship

Notice/Manifest, acknowledgements.

. System process design analysis for outbound ASN using 856 Advance Ship

Notification.

. Documentation of EDI system process and EDI mappings from McAfee file

to Baan application file.

. Designed and developed logging framework for tracking exception data

using business rules engine.

. Involved in clustering BizTalk 2006 R2, Sql Server 2005 and IBM MQ

Series on Windows server 2003.

. Used Xml Digital Signature and XML Encryption for Inbound and Outbound

Transactions.

BizTalk Server 2009/2006 R2, Web Services, BAM, HAT, Business Rules,

IIS6.0, SQL Server 2008/2005, BizUnit, Visual Studio 2008/2005, XML,

Adapters, Documentation, Test Case preparation, HTTP, SFTP, SOAP, Windows

Server 2008/2003, .NET framework 3.5

Sr. BizTalk Developer Feb. 07 -Aug.

09

American RedCross, AshBurn,VA

Responsibilities:

. BizTalk 2009 installation, configuration, high availability

clustering.

. Installation and setup of Single sign on (SSO) and also involved with

clustering on SSO and SQL Server 2008.

. Hands on Experience in working on SharePoint Adapter services send

approved and denied orders to SharePoint site.

. Hands on experience in sending messages from BizTalk server to

Microsoft Dynamics using the eConnect send Adapter.

. Sending Pre approved and approved orders Email attachments to CSRM and

GM through SMTP Protocol and Email attachments sending HTML Formats.

. Developed the BizTalk Orchestration for Database Polling using Oracle

DB WCF adapter and ODP.Net adapter.

. Installed BizTalk 2009 into multi-box server farms for DEV, UAT, PROD

and DR environments.

. Assisted IT department with architecture, development and deployment

of BizTalk and .NET C# applications. Utilized MS SQL Server, SOAP,

File, and Oracle BizTalk adapters.

. Responsible for providing accurate estimations for all the integrated

related solutions.

. Hands on experience in SAP BizTalk adapter setup, SAP IDoc mapping,

SAP BAPI call and RFC calls.

. Generated SAP Services in BizTalk generating schemas and binding file.

. Hands on experience in generate an XSLT file from an existing map

created using the BizTalk Mapper.

. Installed and configured the ESB guidance and configured custom

Exception handling procedures.

. Implemented BAM and other ESB guidance artifacts in the custom

orchestrations

. Developed Custom C#.Net Components for BizTalk Applications.

. Designed and created BAM reports using TPE and BAM APIs and generated

Reports in BAM Portal.

. Responsible for SOAP exceptions and General exceptions.

. Responsible for developing the orchestrations including Correlation

and Retry Mechanism.

. Worked on Common product list, receiving data from SharePoint updating

common product table using SharePoint view and GUID.

. Responsible for defining the business rules using Business Rule

Engine.

. Generated Services in BizTalk generating schemas and binding file.

. Designed and created BAM reports for EDI 850,855,867,846 and 810

transactions and also logged exceptions data to BAM DB.

. Responsible for developing the components for Business Filter Engine.

. Helped SAP development team(s) on setting up partner profiles, ports,

RFC destinations and IDOC_XML service for inbound IDocs

. Wrote business rule policies and vocabulary to handle several rules

. Designed and developed several maps

o SAP Purchase Order IDoc - ORDERS05 to X12 2002, 3030 and 4010

850

o SAP Payments IDoc - PEXR2002 to X12 4010 820

o SAP Payment Controls IDoc - IDCREF01 to X12 4010 831

o SAP Product Activity IDoc - ZPROACT01 to X12 3030 852

o SAP Bills Custom IDoc to X12 4010 810

o PO Acknowledgement X12 2002, 3030 and 4010 855 to IDoc -

ORDERS05

o Customers Payments X12 4010 820 to Custom XML document to SAP XI

server

o Inbound Invoices X12 4010 810 to SAP IDoc - INVOIC01

. Developed custom pipeline components for PGP Encryption and Decryption

. Developed a windows program to load party setup data from a

spreadsheet. Used BTS Catalog Explorer object.

. Developed a windows service to control BizTalk Scheduling.

. Worked on production support after go live and resolved on an average

five to six tickets per day.

. Developed MSI packages and deployed in to QA and production

environment

. Designed, developed and tested disaster recovery methodologies

. Wrote several C#.Net class libraries for database lookup, data

processing and to develop typed BAM APIs and capture the BAM data.

Environment:

BizTalk Server 2006/2006 R2, Visual C#, ASP.NET, EDI/XML Schemas, SQL

Server 2005, Windows Server 2003, Visual Studio 2005, Microsoft Visio,

PVCS, XML, IIS 6.0

BizTalk Developer Aug. 06 -

Feb. 07

Toyota Financials,MI

Automated Vehicle Scheduling System (AVS)

Description:

The Automated Vehicle Scheduling System (AVS) in Ford Motor Company is an

integration project implemented using BizTalk Server based on SOA. Using

BizTalk, three different systems The Manufacturing System, Inventory System

and the Shipping Carrier systems have been integrated in order to

facilitate workflow between these systems thereby improving the performance

of delivery systems.

Responsibilities:

. Designed and developed different BizTalk artifacts including

Orchestrations, send and receive ports, pipeline components, messaging

components, Adapters, to applications for integration.

. Installed and configured BizTalk on developer machine.

. My responsibilities include developing the Orchestrations that

interfaced with the external Web Service applications.

. Implemented Schemas as WCF Services to be called by front end

applications.

. Developed Stored Procedures that will be called from SQL Adapter to

retrieve data logically based on business requirements.

. Developed Schemas and Maps to define the structure of information that

flows in BizTalk.

. Implemented WS-Reliable Messaging using BTS Messaging Engine.

. Implemented BAM Observer model for writing in to BAM.

. Used BAM to create Views to monitor and analyze Key Performance

Indicators.

. Knowledge of BTS explorer to create automotive administrative tasks.

. Content Based Routing of messages has been implemented using Property

Schemas.

. Developed all required transformation Maps required by the

Orchestrations.

. Used Request-Response Receive Ports along with Solicit-Response send

ports to send synchronous response from the receiver application back

to the requester.

. Created Policies using Business Rule Composer.

. Accessed business rules from orchestrations and Custom Pipeline

Components.

. Involved in Analysis, Testing and development cycles performing

multiple tasks throughout the project.

Environment:

BizTalk 2006(R2), C#, ASP.NET, SQL Server 2005, PVCS, XML, Windows Server

2003, Visual Studio 2005, HAT, Business Rule Engine, BAM, IIS 6.0.

BizTalk Developer Aug. 04 - Jul.

06

All State Insurance Co. North Brook, IL

Common Processing System (CPS)

Description:

The Allstate Financial Group provides investment, retirement, and life

insurance products. Those products are sold through exclusive Allstate

agents or nonexclusive producers, such as banks, securities firms, and

independent agents. The CPS project provides anywhere, anytime access to

the information that producers need to meet customer needs, by integrating

with policy management systems, extending their functionality for Web-based

access by Allstate's countrywide network of producers and direct system-to-

system integration with larger producers such as banks and brokerage

houses.

Responsibilities:

. Designed and developing schemas for source and destination XML

messages.

. Completed Microsoft BizTalk Server 2004/2006 Installation and

configuration in Multiserver Environment.

. Migrated BizTalk Server 2004 to BizTalk Server 2006.

. Wrote Several WMI Scripts for BizTalk Application Management Such as

Host, Ports, And Suspended Messages etc.

. Developed SOA solution for provider enrollment which automates the

process of registering and managing Agents.

. Designed and developed complex orchestrations for business processing

and exception handling. Captured exceptions using Scope shape and

wrote to event log, archived to a file folder and also e-mailed to

specific e-mail account using BizTalk SMTP adaptor.

. Actively involved in BizTalk Administration in Host management (Host

and Host Instance), Adapters configuration, Ports (Send and Receive),

HAT, Custom Pipelines.

. Developed EDI Mappings for following EDI transaction sets:

. Healthcare Claim Payment/Advice - 835

. Benefit enrollment and maintenance transaction set(834)

. Authorization Request and Response - 278

. 837_4010X096.SEF Health Care Claim: Institutional

. 837_4010X097.SEF Health Care Claim: Dental

. 837_4010X098.SEF Health Care Claim: Professional

. Converted X12 format XMLs to interchange XML format using HIPAA 3.0.

. Worked on production support after go live and resolved on an average

five to six tickets per day.

Environment:

C#.Net, VB.Net, ASP.Net, BizTalk Server 2004/2006, FTP, BAM, BAS, HIPAA

3.0, XML, Web Services, SQL Server 2000/2005, Windows Server 2003,

VisualStudio.NET 2005, Microsoft Visio 2003.

Satyam Computers services, Hyderabad May 02 -

Jul. 04

Responsibilities:

. Created Web Services for the financial institutions and their ACH

(Automatic Clearing House) Information using VB.NET and designed and

developed UI (User Interface) layer.

. Developed UI for Account Management which contains - Accounts &

Products, Account daily reports and weekly/monthly statements.

. Used ADO.NET for SQL Server data access. Used Namespaces System. Data

and System. Data Sql client to connect to MS SQL Server.

. Used third party Validation Controls to validate user inputs and group

validation, which are not provided by the ASP.NET validation controls.

. Written stored procedures for MAXDB and MSDE Databases.

. Responsible for writing the Quality code so that data will not be lost

when there are network problems.

. Developed interfaces for multiple implementation.

. Used Reflection to dynamically load the Assemblies.

. Responsible for Documentation of the above.

. Responsible for writing TestCases.

. Responsible for Deployment and training the users.

. Involved in analysis, design and development of the functional

specifications.

. Involved in designing the database.

. Responsible for writing T-SQL and stored procedures which were in turn

called by Data Access Layer using ADO.NET.

. Win CVS is used for the version control.

. Created Stored Procedures, tables and views in SQLServer2000

Environment:

VB, ASP.NET, MS Visual Studio.NET, Win CVS, Sql server, Windows XP, DHTML,

JavaScript, VB script, VB5.0, VC++, COM, Oracle7.2, ODBC, PL/SQL, DLL,

Crystal Reports4.0 and UNIX.

Education

. Masters from University of North Texas, TX.



Contact this candidate