Summary:

• Over 7 + years of extensive hands-on experience in all phases of software development lifecycle, with a primary focus on Integration, Data migration, Requirements Gathering, Design Development, and Deployment.
• Over 5+ years of extensive experience in interacting with business to gather/understand the requirements.
• Over 5+ years of experience in leading various communication calls to trouble shoot/diagnosis the production issues
• More than Five years of Experience in developing workflows in BizTalk Server 2004/2006/2006 R2/2010 using BizTalk schemas, BizTalk Orchestrations, BizTalk Mappings, BizTalk Pipelines, BizTalk functoids, BizTalk adapters.
• Hands on Experience on Creating and implementing Web services in BizTalk using BizTalk Artifacts, Logical ports, Tracking Profile Editor, BizTalk Orchestration Designer (XLANG Scheduling), creating Business Rules using Business Rule Composer and BAM and Administration of BizTalk server like Managing, Tracking documents, Trouble shooting.
• Used BizTalk Adapters such as File, SQL, HTTP, SOAP, FTP, MQ-Series, WSS, SAP, WCF, nSoftware SFTP Adapter v3 and Custom Adapters.
• Experience in Service Oriented Architecture (SOA), Web Services and WCF using BizTalk 2006/R2.
• Experience in configuring and mapping EDI/HIPPA 820, 810, 850, 856, 834, 835, 837 , 997 and EDIFACT D96A transactions
• Experience in Administering the BizTalk Servers and BizTalk applications. Involved in Admin activities like Troubleshooting, Deploy application through to go-live and Production Support.
• Worked with MOSS 2007.
• Good Working knowledge and understanding on ESB Concepts.
• Experience in using InfoPath 2003/2007.
• Involved in Various Client/Server Communication services in Distributed Application Developments using Preprocessing and Post processing Scripts usingMQ series and MSMQ.
• Experience with creating parties, Generating & Translating and working on EDI Documents using Microsoft Visual Studio .NET and BizTalk server.
• Worked with Team Foundation Server 2010.
• Extensive working experience with SQL-Server 2000/2005/2008, T-SQL, and development of complex Stored Procedures, Triggers, Joins.
• Experience in developing applications using .NET Framework, Visual Studio .NET, C#, VB.NET, ASP.NET, Web Forms, ADO.NET, Win Forms, CSS, HTML/DHTML, MS-SQL Server 2000/2005, T- SQL, XML, XSLT and IIS 6.0/7.0.
• Good knowledge in using SOAP/Web Services (WS), WSDL, XML/XSL and Java Script.
• Extensive experience in leading all stages of system development efforts, including customer interaction, requirements gathering, design, architecture, testing and support..
• Ability to plan the projects development and cope up with team with excellent analytical, communication, organizational, administrative, interpersonal, and leadership skills.
• Excellent team player with problem-solving and trouble-shooting capabilities.
• Can easily adapt to any new technologies with ease and comfort.

Technical Skills:

Operating Systems : Windows2000/2003/2008 server, NT, XP, Vista
.NET Technologies : C#, VB.NET, ASP.NET, ADO.NET, Web Services
RDBMS : SQL Server 2000/2005/2008 and MS-Access
Languages : T-SQL, PL/SQL, C, C++, VB
Reporting Tools : SQL Server Reporting Services
Languages (Web) : ASP.NET, ASP, COM, XML (SOAP), XSLT, JavaScript, HTML and CSS
Protocols : HTTP, HTTPS, SOAP, SMTP, FTP, POP3, TCP/IP, UDP
IDEs : Visual Studio.Net 2003/2005/2008
Web Servers : Internet Information Server 5.1/6
Enterprise Servers : BizTalk server 2004/2006/2006(R2)/2009/2010.
Tools : Altova MissionKit (MapForce, XML Spy, DiffDog) 2008(SP2)/2009(SP1), SOAPSonar Enterprise, Event Reporter Infragistics, Web ServiceEnhancements 3.0, Enterprise Library, MS Office 2003/2007, MS Office Infopath 2003/2007, Microsoft Office OneNote 2007, MS FrontPage, MS Visio, Visual Source Safe 6.0, Manual Test cases, MQ Series.

CERTIFICATIONS:

Microsoft BizTalk Server - Developing Business Process and Integration Solutions Using
Microsoft BizTalk Server 2006 R2

PROJECTS SUMMARY

Confidential
Calabasas, CA July '12- Present

Confidential is the leader in landscape design-build, landscape construction, landscape maintenance, landscape architecture, tree care services, tree growing Company.

This project is mainly creating Work Orders in corporate CRM and JDE from all branches in US.

In this project I have Integrated Client Applications with CRM 2011 and JDE using BizTalk Server 2010 for creating Extra Work Orders and other related entities in CRM. In this project BizTalk receives JSON message from client application and BizTalk Sync Process Syncs Data from Branch database into CRM and JDE Periodically. BizTalk create, update and Delete Sales Orders and different types of entities in CRM and JDE.

Responsibilities:

• Installed and Configured Microsoft BizTalk Server 2010, ESB Toolkit and ESB Exception Notification Services.
• Designed and developed BizTalk artifacts like Orchestrations, Pipelines, and Maps.
• Develop document specification schemas, channels and ports in BizTalk server for Inbound and outbound message processing.
• Configured ports to accept JSON Message for Client.
• Transformed XMLs File in BizTalk Maps using Functoids, custom Calling .NET Assemblies and Custom XSLTs for complex mappings.
• Worked WCF SQL Adaptor for pulling and pushing data from SQL Server 2008 R2 for implementing BizTalk Sync Process.
• Analyzing CRM entities and Integrating with CRM for creating, querying, updating and deleting all CRM entities using BizTalk.
• User JDE API's for creating, updating and deleting Orders in JDE.
• Used Batch API's in CRM for creating, updating and deleting CRM in Batches.
• Configured Alerts in ESB Notification Services for sending send email notifications based on the type errors and category.
• Worked with different Adapters like WCF-Custom, FILE, HTTP, WCF-SQL etc.
• Created Policies and Rules using Business Rule Composer according the requirements and published the policies and used inside the orchestration for different Internal Processes.
• Created Dynamic BRE Process for executing Business Rules based on the type of message.
• Implemented Caching Mechanism and Parallel processing for improving the performance.
• Debugging BizTalk Processes.
• Used Scripting Functoids to handle conditional data using inline C# as well as calling external .NET assemblies and used Database Functoids like Lookup, ValueExtactor and other functoids to access the database and for verifying the data before inserting.
• Used TFS 2010/Could TFS for Source Control.
• Content Based Routing of messages has been implemented using Property Schemas for implementing Pub-Sub Architecture for loosely coupled and dynamic system.
• Created custom events in the Event Log and Tracing information inside the orchestration for tracking purpose.
• Deploy the application from Development to Test and from Test to Production for each Rollouts.
• Provide post go-live support and troubleshooting.

Environment:

Microsoft BizTalk Server 2010, Visual Studio 2010, TFS 2010, CRM 2011, JDE, Microsoft SQL Server 2008R2, Windows Server 2008, 7.0, SOA, Microsoft Visual 2010, C#, XML, XSLT, XPATH, WCF, WSDL, Altova XMLSpy, Altova Map Force, Microsoft Office OneNote 2007.

Confidential
Monroe, NC May '12- June '12

Integration Analyst

Enterprise Pricing Software solution (PROS):

Confidential is a leading provider of electronic security products and services, fire protection and detection products and services, and valves and controls.

This Enterprise Pricing Software solution is mainly for Managing Confidential Revenue using PROS Revenue Management Suite. The PROS Revenue Management Suite gives the power to apply revenue and profit-maximizing business strategies to determine the most profitable mix of customers. With PROS\' forecasting and optimization technologies, you can determine-in real time-the most profitable mix of prices to offer your customers. Our advanced decision-support capabilities address your most sophisticated users\' business requirements.

This project is mainly integrating diverse ERP systems like SAP, BAAN and Pronto to PROS System. Informatic and BizTalk has to integrate with ERP\'s and Data Warehouse to update or move Revenue related data like Cutomers, Price, Cost and all Sales Order related data in to PROS.

Responsibilities:

• Gathered user and business requirements through interviews, surveys, prototyping and observing.
• Analyzed and prioritized user and business requirements as system requirements that must be included while developing the software.
• Created Use Case Diagrams, Data Flow Diagrams and Sequence Diagrams in MS Visio.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Regular discussions with developers to make them understand the use cases and function requirements of the client.
• Scheduled meetings with developers, system analyst and testers to collaborate resource allocation and project completion using MS Project.
• Helped prepare Logical Data Models that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions and descriptions of the relationships between the data elements to analyze and document business data requirements.
• Created designs and Mapping Requirements for the ETL Development.
• Helped developers and technical team in preparing the test cases and test plan that meets the user requirements.
• Tracked problems from start to correction and test.

Environment:
Informatica PowerCenter 8.6, SQL Server 2008 R2, MS Access, Excel, Oracle 9i, Toad, Windows, MS Project, MS Visio.

Confidential
Pittsburgh, PA Aug '08-Apr '12

BizTalk Developer/Admin

Confidential deliver cost-effective, reliable systems and services to municipal, institutional, and industrial customers worldwide. Thousands of companies rely on Siemens Water Technologies to help them meet their needs for clean water. I have worked on two different projects.

BigMachines Integration with SAP:

This project is an Integrating CRM Portal 2000 with BigMachines and BigMachines with SAP using BizTalk Server 2010 for creating sales orders in SAP and Upgrading existing projects to BizTalk Server 2010. In BigMachines Integration project users create quotes in CRM and CRM sends quote request to BizTalk and BizTalk creates quote Transaction in BigMachines and after the Approval process in BigMachines , BigMachines sends Sales Order to BizTalk and BizTalk will create Sales Orders in SAP using WCF-LOB Adapter, getting Price, Cost and Discounts from SAP for Configurable and non-configurable Materials in BigMachines using BAPI and Bulk uploads using nSoftware SFTP Adapter for securely transferring load files to BigMachines.

Travel and Expense TIBCO Replacement Project:

Travel and Expense project is a TIBCO replacement project. BizTalk has to receive request from WCF service and it has to decide according to the request and do the business processes.

This Travel and Expense project focuses on the consolidation of all financial processes onto one integrated financial accounting system that will consolidate all business processes.

This project was developed in BizTalk Server 2006 R2 and .Net2.0 environment, with Visual Studio 2005 and SQL Server 2005, EDI Application and SAP. Transactions like Flat Files, Positional Files EDI based files like for Payment Application I have used EDIFACT PAYMUL, Corporate Card ApplicationI have used 820 and SAP IDOCs all were processed Using BizTalk.

Responsibilities:

• Designed and developed BizTalk artifacts like Orchestrations, Pipelines, Maps, Schemas.
• Develop document specification schemas, channels and ports in BizTalk server for Inbound and outbound.
• Configured IIS for BizTalk Web Services and Enabled MSDTC.
• Upgraded Existing Application to BizTalk Server 2010.
• Published BizTalk Orchestrations as WCF Service and Configured Request-Response Ports using WCF-CustomIsolated adapter.
• Consumed Web Service in the BizTalk Project and Configured Send ports to send Web service request and get response back from that web service.
• Implemented Service Oriented Architecture environment for Message routing and Communication using WCF and Web Services.
• Installed and configured nSoftware SFTP Adapter for securely transferring files over to BigMachines.
• Configured IIS with SSL Certificates for Securely Transferring data between BigMachines and BizTalk using HTTP Adapter.
• Transformed XML and Flat File Schemas in BizTalk Map using Functoids, and C # and Calling .NET Assemble.
• Created Microsoft Office InfoPath Form as User Interface by consuming the BizTalk WCF Service for sending the Request and getting back the response from the service.
• Worked with SAP Transactional Methods like IDOC's and RFC's for Messaging.
• Worked with different Adapters like WCF-Custom, WCF-CustomIsolated, WCF-WSHttp, WCF-BasicHttp, Windows SharePoint Services, FILE, HTTP, SOAP, SQL, FTP and SFTP.
• Developed Error Handling Orchestrations for the Business Processes and Pipeline errors.
• Developed Complex Orchestrations for processing EDI Transactions EFACT D96A and X12 820.
• Used Custom XSLT Template for complex Mappings.
• Created Maps for converting Inbound Flat File to EDIFACT D96A and EDI 820 files.
• Created Policies and Facts using Business Rule Composer according the requirement and published the policies and used inside the orchestration for validating the Message.
• Used HAT for Message Tracking and Debugging the Orchestration.
• Used Scripting Functoids to handle conditional data using inline C# as well as calling external .NET assemblies and used Database Fuctoids like Lookup, ValueExtactor and other fuctoids to access the database and for verifying the data before inserting.
• Maintained different Versions using Visual Source Safe/TFS 2010.
• Used SOAP Sonar Enterprise for testing BizTalk Services.
• Content Based Routing of messages has been implemented using Property Schemas
• Created custom events in the Event Log inside the orchestration for debugging .
• Lead the BizTalk team.
• Deploy the application through to go-live.
• Installing Biztalk server Hotfix to improve the performance.
• Used MsgBoxViewer for troubleshooting BizTalk.
• Provide post go-live support and troubleshooting.

.SAP Data Migration and Integration:

This project was a massive integration effort, integrating diverse legacy systems in to SAP. BizTalk has to integrate SAP system to update or to make any changes to data in SAP system. Different Business Processes like Material Masters, Sales Orders, Business Partners, Bill of Materials, and General Ledger Posting were developed using BizTalk . BizTalk Integration with SAP is done by using different ALE IDoc interfaces using WCF-LOB Adapter. Different Transactions like for Business partner I have used CREMAS and DEBMAS, for Material Masters MATMAS, for Bill of Materials BOMMAT, for Ledger Posting GL_POSTING01, for Sales Orders YORDSID2 all were processed Using BizTalk and MapForce2008/2009.

This project is developed in BizTalk Server 2006 R2 and .Net2.0 environment, with Visual Studio 2005 and SQL Server 2005, SAP. Transactions like Flat Files, Positional Files and SAP IDOCs all were processed Using BizTalk and MapForce2008/2009.

• Meet extremely tight integration schedules for integrating involving multiple legacy systems and the target SAP system in Germany
• Analyze Data Migration requirements from a business standpoint and design mapping requirements using SAP's IDOC layer.
• Designed and developed BizTalk artifacts like Orchestrations, Pipelines, and Maps.
• Develop document specification schemas, channels and ports in BizTalk server for Inbound and outbound.
• Develop Custom pipeline component for removing control characters from the inbound xml file.
• Transformed XML and Flat File Schemas in BizTalk Map using Functoids, and C # and Calling .NET Assemble.
• Created Microsoft Office InfoPath Form as User Interface for creating the customer and vendor Requests.
• Worked on Data Migration from SQL Server 2005, creating Map using Altova MapForce for extracting the Data from the SQL Server directly and Creating the SAP IDOC's and loading it into SAP using BizTalk.
• Worked with SAP Transactional Methods like IDOC's and RFC's for Messaging
• Used SQL Adapter to access the database for implementing Business Process.
• Worked with different Adapters like WCF-Custom, Windows SharePoint Services, FILE, HTTP,, SQL, and FTP.
• Created Policies and Facts using Business Rule Composer according the requirement and published the policies and used inside the orchestration for validating the Message.
• Used HAT for Message Tracking and for Debugging the Orchestration.
• Used Scripting Functoids to handle conditional data using inline C# as well as calling external .NET assemblies and used Database Fuctoids like Lookup, ValueExtactor and other fuctoids to access the database and for verifying the data before inserting.
• Maintained different Versions using Visual Source Safe.
• Content Based Routing of messages has been implemented using Property Schemas
• Created custom events in the Event Log inside the orchestration for Tracking purpose.
• Lead the BizTalk team.
• Deploy the application through to go-live.
• Provide post go-live support and troubleshooting.
• Align the development process to Siemens Compliance standards as well as best practices .
• Be the single point of contact for the SAP team in Germany with SAP counterparts in Germany
• Administer the server for the first 3 integration “waves” until data loads were stable.

Environment:

Microsoft BizTalk Server 2006-R2/2010, Visual Source Safe 2005, Share Point Server 2007, Microsoft SQL Server 2005/2008R2, Windows Server 2003/2008, IIS6.0/7.0, SOA, Microsoft Visual Studio 2005/2008/2010 with Microsoft .Net Framework 2.0 / 3.0/3.5, C#, ASP.NET, Web Services, XML, XSLT, XPATH, WCF, SAP, WSDL, Altova XMLSpy 2008/2009, Altova Map Force 2008/2009, Microsoft Office OneNote 2007, MS InfoPath Form 2003/2007, SOAP Sonar Enterprise 4.

Confidential
Rockville, MD Jun '07-July '08

BizTalk Consultant

Health Claims Processing System:
Electronic Claim Submission allows providers to safely submit and track HIPAA-compliant electronic claims to Confidential via the Availity Health Information Network without manual intervention. Availity-registered providers can send claims electronically to Johns Hopkins using either the online real-time claims submission transaction or the batch Electronic Data Interchange (EDI) option.

Responsibilities:

• Actively involved in Microsoft BizTalk Server 2006 R2 Installation and configuration.
• Developed EDI Mapping Inbound and Outbound Transactions/Schemas like 837(I P, D), 835, 278, 997, Encounters(837(I, P, D)) and Cross Over(837 (I, P))
• Designed complex orchestrations for business processing and Exception handling. Exceptions are logged and configured using enterprise library.
• Published Schemas to web service to handle web service requests with third party partners.
• Published Orchestration as a web service to handle request from third party partners.
• Configured WCF web services to interact with legacy systems
• Used BAM (Business Activity Monitoring) to track the messages going through different systems and also to track failed messages.
• Involved in implementing Transport level security by configuring IIS, encryption and decryption using digital certificates using X509.
• Developed customized MSI packages and deployed into Test, Staging and Production Environments.
• Involved in installation and configuration of AD (Active Directory) with various BizTalk, clustered SQL Servers, BizTalk Groups, and Users.
• Actively involved in BizTalk Administration in Host management (Host and Host Instance), Adapters configuration, Ports (Send and Receive), TPE, Custom Pipelines and custom functoids.
• Implemented Microsoft Enterprise Library to configure Ports, Archive locations for different applications and logging events.

Environment:
C#, ASP.NET, BizTalk Server 2006 R2, SFTP, BAM, Enterprise Library, HIPAA, HL7, SCOM 2007, XML, Web Services, UML, SQL Server 2005, Visual Studio.NET 2008, Microsoft Visio, Windows 2003,Windows Services, AD(Active Directory)

Confidential
Plano, TX July '06 – Apr '07

BizTalk Consultant

Confidential is the leading provider of cleaning, environmental, and re-refining solutions providing a host of cleaning and environmental services for companies of all sizes, like Parts cleaning, Environmental cleaning, and Oil services.

Confidential Migration Project :

This Project is a migration from Seebeyond to BizTalk environment that is migrating business functionalities/processes from Seebeyond application to BizTalk applications. This project has been developed in .Net2.0 environment and BizTalk server 2006, with Visual Studio 2005 and SQL Server 2005, ORACLE, IBM SERVERS (BAP), Sun Solaris 890, EDI Editor Tool and SAP. Transactions like Flat Files, Positional Files EDI based files like 810, 850, 856 and 997 generated with ERP application, are processed by using Business processes.

Responsibilities:

• Involved in all the phases (Development, Staging, and Production) deployment of the BizTalk Server 2006.
• Configured BizTalk Servers under single BizTalk Group to scale up applications.
• Considered Performance by Configuring BizTalk Servers as Receive, Processing and Transmitting servers.
• Configured and managed BizTalk Artifacts under individual Applications.
• Configured IIS for web services and web applications
• Creating Hosts for individual applications.
• BizTalk Server Groups with Active/Passive SQL Server 2005 Clusters
• NFS Message Size limit and its implications for BizTalk server Development.
• Enabled NFS Connectivity for Inbound Receive folders and configured as cluster resource under Cluster Administrator MMC
• Tuning BizTalk Servers for performance by considering no of CPUs and making changes at all Configuration files like Machine, Web and Application configuration files.
• Optimizing BizTalk Orchestrations by choosing ADO Thread model, Transaction model, Asynchronous Processes, Short lived Transactions and In-Process COM Components
• Created SQL Jobs, Alerts, Backups and SQL Server Logs files for recovering data using SQL Server Management and Enterprise Manager.
• Installed MOM agents on BizTalk Servers for Monitoring.
• Creating Scheduled Tasks and Window Services using Visual Studio.
• Suggested in creating Service accounts and Domain Groups for BizTalk Servers under Active Directory.
• Involved in Creating and Configuring the Schemas for EDI files coordinating with ERP Application, business users and the application developers.
• Configured connectivity to BAP-AIX server application using Edifecs, Gentran to get XML Input parameters for Document Specifications using theBizTalk Editor and also involved in validating the documents using Editor.
• Performance Monitoring using Windows Performance Monitor, MOM, Health Monitor
• Monitored the business activities extensively by using the MOM tool.
• Configured Event Viewer for BizTalk Server related errors and viewed application-related errors in event viewer
• Created Documentation for all applications and processes and hosted to Share point portals

Environment:

Windows2003,Microsoft .NET Framework 2.0, ASP.NET, C#, VB.NET, ADO.NET, XML,XSLT, Edifecs, Gentran, SQL Server 2005, IIS 7.0, Visual SourceSafe, CSS, JavaScript, MQ Series , VisualStudio2005, BizTalkServer2006,SQLServer2005,Oracle 9i,Oracle 10g,NFS for Unix Machines, Crystal Reports 10.

Confidential
Melville, NY Aug '05 – Jun '06

.Net Consultant

The Population Management Tool is an application that will help to collect PPO and HMO patient data for the RMMC's Pay for Performance Program. The application will collect patient data across all conditions and data elements. PMT is designed to view and update HMO and PPO patients' data their labs, tests, conditions, medications and patient demographics.

Responsibilities:

• Involved in gathering of requirements by interacting with client, understanding the project specifications and developing Requirements Handler.
• Involved in analyzing the requirements that are gathered and producing design document as per the understanding and get it approved by the client.
• A Use-Case document is created for each and every module in the Requirements Handler, design document based on which development is done.
• Application is a web based application that is developed using ASP.Net, C#, and ADO.Net. The development is based on Model View Architecture.
• Developed Stored Procedures, Views to handle the editing the data.
• Designed and developed the database using SQL Server 2000.
• Used ADO.NET to communicate the SQL Server 2000 database.
• Wrote complex Queries, Stored Procedures.
• Uploaded the data from flat file, which is inserted in SQL tables Using DTS.
• Involved in Unit Testing of the developed module's and findings are documented for peer reviews.
• Involved in the successful execution of the project.

Environment:
ASP.NET, C#, ADO.NET, SQL Server 2000, VSS and Windows XP.

.Net Consultant

Customer Support Management System project is an internet application, which automates customer support division of Aster Teleservices. The application is designed to store information regarding the customer and their support calls. When a call is received from customer, the problem details are registered in a database. Subsequent calls are updated into the record. The auto mailer system sends messages to the concerned technical support team. The system also helps in tracking the unresolved customer calls and escalating the same at periodic intervals.

Responsibilities:

• Created Web forms using ASP.NET.
• Used JavaScript for client side validation.
• Developed user controls and custom controls.
• Used ADO.NET to access the SQL Server 2000 database.
• Design and Creation of SQL Server 2000 Database Objects.
• Created tables, keys, stored procedures in the database.
• Participated in the planning, analysis, and design of the project.

Environment:

ASP.NET, ADO.NET, JavaScript, Windows 2000, MS SQL Server 2000, HTML, IIS 5.0.

EDUCATION:

Bachelors in Technology, Electronics and Communication Engineering.