PROFESSIONAL SUMMARY

• 12 years experience in system design and development of client server applications.
• Excellent working experience in .NET framework and BizTalk Server 2002/2004/2006.
• Experience in Web Portal, BizTalk Server implementation.
• Used XML schema, XSLT, Orchestration, ASP.NET, VB.NET, C . NET, ADO.NET, XML and VS.NET.
• Strong development skills in Visual Basic 4.0 to 6.0, ASP 2.0/3.0, Visual Studio, MS SQL Server 7.0/2000/2005, Oracle 7.x/8i/9i, JavaScript, VB Script, ASP.Net, VB.Net, C , XML, COM, HTML DHTML.
• Excellent experience in BizTalk installation and administration.
• Experience developing EAI and B2B applications using BizTalk Server 2006 R2, 2006/2004/2002, Port, Channel, and BizTalk Adapter for SQL Server and BizTalk Mapper Tool.
• Good knowledge of SharePoint 2003.
• Design and develop the Intranet and Internet sites using ASP.NET, VB.NET, C , ASP, JavaScript and HTML.
• Strong skills in Visual Basic 6.0/5.0/4.0, Crystal Reports 4.5 to 10.0 and ActiveX.
• Expertise in MS SQL Server 6.5/7.0/2000/2005, Oracle 7.x/8.0/9i and MS Access 7.0/2000.
• Experience on Windows 95/98/ME/NT/2000, UNIX and MS DOS.
• Architect BizTalk solutions using SOA messaging standards.
• Design develops solutions using Scrum methodology, Test-Driven Development TDD , Agile Software Development using continuous integration CI processes.
• Create Code Review Checklist for Naming, Schema, Mapping, Orchestration, Configuration, overall solution architecture.
• Mentor team members in design, develop, test and implement solutions.

TECHNICAL SKILLS

• O/S: Windows 2003 / 2000 / NT 4.0 / 98 / 95 / 3.1 and UNIX.
• GUI: C , VB.NET, VB 6.0, 5.0, 4.0, 3.0, ASP, Visual Studio.NET and ActiveX, HTML, PowerBuilder, Forms 6i and Dreamweaver.
• Languages: C , C, C , SQL, PL/SQL, Java, VBScript and Power Script.
• RDBMS: BizTalk Server 2002/2004, SharePoint Portal Server and SQL Server 2005/2000 / 7.0, Oracle 6.x / 7.x / 8.0/8i/9i and MS Access 2000/7.0/2.0.
• Tools: Windows Registry, RDO, ADO, ODBC, Crystal Reports 8.0, MS Front-page, Java Apps and MS Office.
• Web Servers: IIS and Tomcat Apache.

PROFESSIONAL EXPERIENCE

Confidential

Sr. BizTalk Consultant

• Design interface Enterprise Imaging Cyclone, Lot Query, and ACCIS Cyclone, E2B plus Extended Process.
• Design implements enterprise imaging interface.
• Publish work list Adverse Events as web service for consumption by enterprise imaging.
• Used WCF Security Transport/windows and assign to service account.
• WCF-Custom to query oracle db to fetch Lot details based on Lot number.
• Envelope schema to wrap Safety message.
• Identify Safety message by namespace for Argus process to consume.
• Create custom send pipeline component to add DOCTYPE to transformed XML to validate DTD in Argus process.
• Worked on ERP application which used the SAP and EDI adapters to communicate.
• Create E2B Plus extension by writing PL/SQL and adding child elements to DTD.
• Create custom exceptions and unit tests.

Environment: BizTalk Server 2006 R2, XML, MS Visio, Oracle, Windows 2003 Server, and C , VS.Net 2005 , TFS 2005, Oracle 10g/11g

Confidential

Biztalk Architect

Confidential data through interface will replicate data from PIS to REPRD database and from there to subscribing systems.

Responsibilities:

• Involved in creating POC's for several different interfaces.
• Used different adapters File, SMTP, Oracle Adapter, JN Bridge BizTalk Adapter, SQL Adapter, WCF- Oracle custom Adapter, WCF-Basic http Adapter to create the POC's.
• Create Canonical Schemas for product, Media Territory messages.
• Used the pub/sub Architecture to publish all IPLS messages to canonical format.
• Create DWHUB Orchestration process using Helper Class in .Net to debatch product data and iterate though XML using XPathNavigator and update 16 different tables using dataset and using a single transaction for updates.
• Created Business Entities and Config XML files for database mapping in the business layer using C language.
• Used xsl and xslt to complete some of the transformations in media/territory.
• Involved in debatch Orchestration process for Media Territory to Send data to Oracle financials using WCF-Basic Https Adapter.
• Deployment of SSIS Packages in different environment and executing them.
• Analyzed the EDI document and created Batching in BizTalk server.
• Created Parties in BizTalk server to differentiate between each vendor and there Senders ID.
• Used EDI adapters and Pipelines for Processing the Data.
• Involved in Creating Custom Exception Handling Orchestrations and publishing Schemas as Web Services for other process like ETL to publish exceptions and status as well as other Orchestration using pub/sub to publish exceptions and status messages which will be updates in oracle database.

Environment: BizTalk Server 2006 R2, C , XML, XML SPY, MS Visio, MS SQL Server 2005, TSQL, DTS, SSIS, Windows 2003 Server, and VS.Net 2005 , TFS 2005, Oracle 10g/11g

Confidential

BizTalk Architet

Confidential batch process will look for un-submitted Shop Deluxe orders, which will be published to the Message Queue and passed onto the Service layer E BUS for routing in to the Deluxe backend order system IROC .

Responsibilities:

• Experience with SOA, collaborates with architects and developers designing and developing a BizTalk Enterprise Service Bus
• Used Agile Software Development integration CI processes, and Scrum meetings.
• Create BizTalk development processes and implement the designs.
• Gather business requirements.
• Created the complex gap analysis between SD and IROC service.
• Design the work flow of the Orchestration.
• Used the Schema Design Patterns to Create Canonical Schemas and optimize common schema separately.
• Create xsl transformation between SD requests to PLOROC request. Scripting to validate conditions and generate sequence numbers.
• Debatch Smart mailer message before sending to Smart mailer WCF Service.
• Created WCF service to push data for smart mailer. Updates Oracle database with the corrected pre sorted mailer information.
• BAM to monitor counter when IROC sends status back to ATG.
• Created schemas to consume and produce X12 EDI 834, 837, 856 and 997 transactions.
• Mapped the EDI Documents to internal schemas to call Web Services/WCF Services.
• Designed and developed SQL Server Integration Services SSIS for data migration.
• Restructured the stored procedure, designing, coding and developing the same using the MS SQL Server Integration services SSIS .
• Used HTTP protocols to communicate with servlet.
• Request MQ to get request from ShopDeluxe and a response MQ to communicate status of Orders placed.
• Used SSO and read values from Excel spread sheet to read Environment variables.
• Published message errors using error handling exceptions.
• Unit test XSLT and end to end Orchestrations test using VSTS
• Trained other developers in using TDD.
• Code review overall solution architecture.

Environment: BizTalk Server 2006 R2, EDI, C , WCF Services, XML, XSL, XSLT, XML SPY, MS Visio, MS SQL Server 2005, DTS, Windows 2003 Server, BAM and VS.Net 2005

Confidential

Sr. BizTalk Consultant

Confidential is to facilitate outbound exchange of data from IVPA to Billing Collections. This message is sent when a new agreement is signed with a credit union/ Agreement-related / Policy related / invoice related. It contains all the Billing Collection information of the credit union.

Responsibilities:

• Design artifacts using Scrum methodology, Test-Driven Development TDD
• Participated in design of horizontally scalable platform.
• Gather business requirements. Design the work flow of the Orchestration.
• Create Schemas and optimize common schema separately.
• Used the Pub/Sub model to facilitate loosely coupled service and reusability.
• Used BizTalk Design pattern for Decoupling BizTalk Orchestration Processes by Using Direct Binding
• Used the Schema Design Patterns to Create Canonical Schemas and optimize common schema separately.
• Documentation - xpath incoming schema and map canonical schema in worksheet.
• Publish orchestration as a web service using WSE 3.0. Configure client web service WSE 3.0 enabled.
• Used all mapping functoids as and when required.
• Scripting using XSLT to create record elements.
• Published message errors using error handling component to SharePoint server.
• Used Map test using Map Helper for all the maps in B C.
• Used BizUnit for testing Orchestration.
• Trained other developers in using TDD.

The Confidential is used by Business Application in Confidential Mutual to facilitate the Assembling, Imaging and Printing of business documents to be generated in batch in the form of XML message. Based on the action required confidential will Assemble, Image and store or Print documents in batch.

Responsibilities:

• Used the BTSNTsvcexec to store configuration information.
• Used Null Adapter in printing to create correlation.
• Used correlation for getting the Assembly Status message.
• Design artifacts using Scrum methodology, Test-Driven Development TDD
• Dynamic routing of messaging used to send to vendors.
• Call Orchestration was used to get Batch Status from the Assembly, Imaging Printing to send status to Process Controller.
• DocGen helper class used to update status.
• Used BAM to retrieve Status milestone.
• All the maps and Orchestration used map tests and BizUnit tests.

Responsibilities:

• Create Posting File Schema. Design the workflow for extraction and processing the posting file.
• Design artifacts using Scrum methodology, Test-Driven Development TDD
• The generation of posting files is related to the billing period. If a Credit Union receiving Interest and/or payment increase appear in the batch process Posting will initiate the process with Tracking.
• Trained other developers in using TDD.
• Used Pub/Sub model to subscribe to posting Files.
• Used SQL Adapter to extract Posting information.
• Used Debatching to send CPF Web Service to send 50 in a batch as request.
• Used .Net Helper Class to create Tracking Request XML message to send to CPF.
• Used Custom XSLT to group certificates for each organization.
• Used xpath in XML SPY to evaluate.
• Stored Configuration data in tables to retrieve transform information.
• Used pub sub between Extract and Process Posting Service Orchestrations.
• XSLT in scripting to get Type Code, counts and Amount information.
• Used BAM to monitor the above data.
• Used Unit test and mapper test for all maps and orchestrations.
• Supplements the existing standards available at CUNA Mutual Group.
• Trained other developers in using TDD.

Environment: BizTalk Server 2006, C , Web Services WSE 3.0 enabled, XML, XSL, XSLT, XML SPY, MS Visio, MS SQL Server 2005, Windows 2003 Server, and VS.Net 2005.

Confidential

SR. BizTalk Consultant Architect

Confidential Program Schedule data from different providers are sent in different file formats Flat files, messages are transmitted through FTP mechanism and sent to TVGuide database.

Responsibilities:

• Defined Schema Specification and validated against sample data.
• Used pipelines for flat files.
• Used BizTalk Editor for Creating different maps and used Functoids and SQL Custom Functoids to get values and Inline C Codes for Factoids.
• Developed Orchestrations for the business Process.
• Define xml binding files to deploy the BizTalk assemblies and configure the ports for File, FTP, SMTP and MS SQL Server adapters.
• BizTalk Mapper Tool was used to map source and destination Specification.
• Deployment of Biztalk applications on development and build environments.
• Installation and Configuration of Biztalk server.
• Developed solutions including XSD schemas, Biztalk maps, and orchestrations using Visual Studio.NET
• Create Deployment Scripts for deploying maps, ports and assemblies and UN-deploy, redeploy assemblies.
• Bug Fixing identify issues when business requirements change in the algorithms in stored procedures when data get massaged using ticket system in SharePoint.
• As new providers come in new schemas, maps are created deployed in QA, UAT and production on a regular basis.
• Resolve BizTalk production issues using BizTalk Administration Console and HAT, SQL Server 2000.
• Used BizTalk explorer to configure Ports and monitor BizTalk Hosts and Orchestrations.
• Used HAT to monitor activities in production environment and bug fix.

Environment: BizTalk Server 2004/2006, Web Services, XML, XSL, XSLT, MS Visio, MS SQL Server 2000, MS SQL Server 2005, Windows XP, Windows 2003 Server, VS.Net 2003/2005.

Confidential

BizTalk Consultant

Confidential in conjunction with Confidential had identified a series of messages that are being triggered by both applications following an event that occurs within the warehouse, Confidential. These messages are transmitted through an FTP mechanism utilizing standard XML and proprietary XML Rosettanet messages. Communication is directed from Confidential data center, through UPS data center, into the Miami DMZ and vice versa.

Responsibilities:

• Defined Schema Specification and validated against sample data.
• Used pipelines for flat files.
• Used BizTalk Editor for Creating different maps and used Functoids and SQL Custom Functoids to get values and Inline C Codes for Functoids.
• Created XML Inbound, Outbound Schema using BizTalk Editor to represent Delimited Flat files, Positional Flat files and XML files.
• Used Functions to convert dates, do lookups and to conversion legacy data to new defined values. The data is extracted from Billing System and dropped in a folder as a delimited or positional flat file. These files are then picked up by BizTalk and processed using Channel's and Port's and given out in XML format for the Web Services.
• Designed and developed BizTalk Orchestration to implement business logic.
• Developed Orchestrations for the business Process.
• Used Parties and Role Links for different Vendors.
• Used File, FTP, Https adapters.
• Calls were made to Web services to integrate with UPS application to create orders and shipment information, User Authentication.
• Used BizTalk explorer to configure Ports and monitor BizTalk Hosts and Orchestrations.
• Used HAT to monitor activities in production environment and bug fix.

Environment: BizTalk Server 2004, VS.Net 2003, Web Services, XML, XSL, XSLT, MS Visio, MS SQL Server 2000 and Windows XP / 2003 Server.

Confidential

BizTalk Consultant

Data is entered at the aggregated level- usually combined based on rules that the analyst must be trained and remember. Documents are printed and highlighted and then data is manually entered. The objective was to create a framework and build and information-processing platform that will enable global data to increase content coverage without increasing staffing levels. Perform timely analysis of content through automated techniques. BizTalk 2004 Server was used to transfer the data from the companies and process it. Provide customers with a better quality product through improved data accuracy. Provide data transparency.

Responsibilities:

• Defined XML schema Specification.
• Ports were configured to send and receive data from different locations.
• Web services were used to get data from trading partners.
• BizTalk Mapper Tool was used to map source and destination Specification.
• BizTalk Orchestration Designer was used for Business Process Designing.
• BizTalk Editor Tool was utilized for designing schema.
• Used Functoids for complex data conversions.
• Used File Adapter to receive published files from Folders.
• ASP.Net was used to display refined data for business analyst.
• Created various data driven web parts using C , MS SQL Server 2000, XML.
• Migrated existing ASP based intranet into SharePoint using ASP.NET, C , ADO.NET, XML and Visual Studio.NET.
• Used WebServices to expose the Documents.
• SQL Adapter used with Stored Procedures for Database Operations.

Environment: ASP.Net, BizTalk Server 2004, Web Services, ADO.NET, XML, XSL, XSLT, UML, TSQL, Stored Procedures, Views, MS Visio, MS SQL Server 2000 and Windows 2003.

Confidential

BizTalk Developer

Confidential trading partners will utilize the Microsoft BizTalk Server 2004 to link their back-office enterprise resource planning ERP solutions to the online marketplace, resulting in shorter procurement cycles, increased purchasing efficiencies, and reduced cost.

Responsibilities:

• Designed and configured the BizTalk document schemas.
• Used BizTalk 2004 Server for transferring files and Mapper were used for mapping.
• Defined XML schema Specification.
• Port and Channel were configured to send and receive document from BizTalk Server.
• Used BizTalk receive function to grab the message from the queue and passes the XML data into SQL Server stored procedures.
• Used XML Document for data exchange between businesses associate.
• BizTalk Mapper Tool is used to map source and destination Specification.
• BizTalk Orchestration Designer was used for Business Process Designing.
• Used WebServices for data transferred.
• Handled exceptions using customized classes that defined specific level exceptions.
• Used ADO.Net classes like SqlConnection, SqlAdapters, SqlDataReader and Sql Command classes for data access. Used WebServices to expose the Documents from the .NET Application.

Environment: C , ASP.Net, VSS, BizTalk Server 2004, ADO.NET, XML, XSLT, MS Visio, MS SQL Server 2000, Stored Procedures, Views, VB Script, JavaScript and Windows 2000.

Confidential

.Net Developer

The Confidential system is an existing financial application that allows merchants to record, defer, and apply vendor income to margin accounts. The AVI business goal was to allow Target to collect vendor income at the point in time that it is earned and to allow merchandising the flexibility of applying this income to department financials as needed. Develop VB.Net web service program based on schedule run once a time and get the latest updated information from remote website using SOAP and WSDL.

Responsibilities:

• Requirement analysis and designed the architecture and framework of application.
• Used ASP.NET to develop the site.
• Design and implement database structures,
• Used VB.Net for coding.
• Used SQL Server database as back end database.
• Develop Web Services for the transfer of data from remote site.
• Implemented full text search.
• Implementation of CSS for centralized control over similar look and feel of the application.
• Used UTF8 encoding to support multiple languages.

ASP.Net, VB.Net, VB, ASP, SOAP, WSDL, MS SQL Server 2000, Stored Procedures, Views, Functions, ADO.NET, IIS, VB Script, PL/SQL, JavaScript and Windows 2000.

Confidential Web Developer

Confidential is an online shopping center. This site provides information about Rice, spice, herbs, shopping, health, food, cooking, club activities and entertainment. It is designed with SSL for Security. Drafted out the initial and detailed design of the Website.

Responsibilities:

• Involved in system study, preparation of documents like functional design specification, detail design specification and basic functional design.
• Involved in the complete design of the website.
• Designing of the screens using Visual Interdev 6.0, MS Front page Express, ASP 2.0. Coding of class modules, Active X Controls, etc.
• Design of the database using MS SQL Server 7.0
• Used ADO for database connectivity.
• Creation of the front-end screen using Visual Basic 6.0.
• Client side validation done using Visual Basic 6.0.
• Developed various COM Components using Visual Basic 6.0.

Environment: ASP, COM, PL/SQL, VB 6.0, Visual Studio, Visual Interdev, MS Front Page, JavaScript, VB Script, HTML, SSL, MS SQL Server 6.5 and IIS 4.0.

Confidential VB Developer Developed Integrated Financial Accounting, Purchase Inventory and Sales system for Confidential. The modules include Confidential.

Responsibilities:

• Responsibilities included system study, preparing the Customer Requirement specifications, High Level Designing, Low Level Designing.
• Involved in coding of procedures and functions common to all modules and coding of transaction modules. Was also involved in coding of Sales Order Transaction Module.
• Functional requirement Analysis.
• Developing the functional design using Visual Basic.
• Documenting the same using MS Word.
• Designing Tables using MS SQL Server.
• Designing the screens and coding using Visual Basic.
• Testing and Debugging. Developed Reports using Crystal Reports.

Environment: Visual Basic 5.0, MS SQL Server, Crystal Reports 4.5, and WinNT.

Confidential

VB Developer

This System was developed to maintain the Annual Maintenance Contract transaction between Info Power and its clients. The system consists of three modules, Master, Transaction and Reports. This System generates various reports like Billing, Master reports, and Service call by date, and Service call by customer Monthly , service calls by problem code, calls by Engineer.

Responsibilities:

• Was involved in the design of the system, developing screens and generating reports.
• Created functions for calculating the total hours worked by each individual.
• Created reports for unattended calls based on priority.
• Interacted with the clients for their maintenance and training.

Environment: Visual Basic 4.0, Oracle 7.1, Crystal Reports 4.5, and Windows 95.