SUMMARY

• A Microsoft Certified Professional with over 8+ 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.
• Experience in interacting with business to gather/understand the requirements.
• Extensive experience in leading various communication calls to trouble shoot/diagnosis the production issues
• Experience in developing workflows in BizTalk Server 2006/2006 R2/2010/2013 using BizTalk schemas, BizTalk Orchestrations, BizTalk Mappings, BizTalk Pipelines, BizTalk functoids, BizTalk adapters.
• Hands on Experience in 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, Siebel, WCF, nSoftware SFTP Adapter v3 and Custom Adapters.
• Experience in Service Oriented Architecture (SOA), WCF Services and WCF Services using BizTalk 2006/R 2/2009/2010/2013.
• Experience in configuring and mapping EDI/HIPPA 820, 810, 850, 856, 834, 835, 837, 997 and EDIFACT D96A, HL7 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.
• Experience in developing ESB Solutions using ESB Toolkit.
• Experience in using InfoPath 2003/2007.
• Experience with creating parties, Generating & Translating and working on EDI Documents using Microsoft Visual Studio .NET and BizTalk server.
• Extensive working experience with SQL-Server 2000/2005/2008 , T-SQL, SSIS and development of complex Stored Procedures, Joins.
• 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: Windows 2003/2008 server, XP, Vista

.NET Technologies: C#, VB.NET, ASP.NET, ADO.NET, WCF Services

Database & Tools: SQL Server 2012/2008R2/2005, PostgreSQL, TOAD and MS-Access

Languages: T-SQL, PL/SQL, C

Languages (Web): ASP.NET, XML (SOAP), XSLT

IDEs: Visual Studio 2005/2008/2010/2012

Web Servers: Internet Information Server 5.1/6/7

Enterprise Servers: BizTalk server 2006/2006(R 2)/2009/2010/2013.

Tools: Altova Mission Kit (Map Force, XML Spy, DiffDog) 2008(SP2)/2009(SP1)SOAP UI, SOAP Sonar Enterprise, Event Reporter InfragisticsEnterprise Library, MS Office 2003/2007/2010 , MS Office InfoPathn 2003/2007/2010 , Microsoft Office OneNote 2007, MS VisioVisual Source Safe 6.0, TFS 2010/2013, MQ Series.

PROFESSIONAL EXPERIENCE

Confidential, Mountlake Terrace, WA

Sr. BizTalk/ESB/SSIS/WCF Consultant

Responsibilities:

• Installed and Configured ESB Toolkit, ESB Portal and ESB Exception Notification Services on existing BizTalk 2010 Infrastructure.
• Design and Develop New interface using BizTalk ESB Components.
• Redesign existing applications to use ESB Features.
• Develop Itinerary based solution for ESB services and using existing generic ESB Services in Enterprise level.
• Develop SSIS ETL Packages using SQL Server 2012 to process data available in Flat Files, Excel Files and store in SQL Database.
• Develop SSIS Packages to load data from SQL Data base to CRM using Kingsway Soft Adapter.
• Analyzing CRM entities and Integrating with CRM for creating, querying, updating and deleting all CRM entities using BizTalk and Organization Service.
• Publish BizTalk Schemas as WCF Service and Developing Itineraries for different Methods.
• Used BRE Resolvers to dynamically select Itineraries, Maps and Route Messages based on the different requests and criteria.
• Integrating with External vendor using REST API’s.
• Design and Develop Interfaces for EDI based solution for Transactions like 270/276/277/278/834/835/837 using BizTalk.
• Developing WCF services for internal teams and also for some external Vendors based on the requirements.
• Configure Alerts in ESB Notification Services for sending send email notifications based on the type errors and category.
• Created Policies and Rules using Business Rule Composer according the requirements and published the policies and used inside the orchestration for different Internal Processes.
• Implemented Caching Mechanism and parallel processing for improving the performance.
• Debugging BizTalk Processes.
• Implemented Complex Mappings using Custom XSLT Templates in BizTalk mapper and calling custom .NET Assemblies.
• Used TFS 2010/2015 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/2012, TFS 2010/2015, CRM 2011, Microsoft SQL Server 2008R2/2012, Windows Server 2008/2012, SOA, C#, XML, XSLT, XPATH, WCF, WSDL.

Confidential, Princeton, NJ

Sr. BizTalk/SSIS Consultant

Responsibilities:

• Understand the business requirement, Build and modify database components as per the requirements of business intelligence, resolve database performance issues.
• Responsible for Design, Planning, Execution, and Closure of Development, Quality Assurance and support activities for the project.
• Designing and Developing New BizTalk interfaces using ESB Toolkit.
• Modifying and Supporting Existing BizTalk Applications.
• Create SQL stored procedures, views, functions, triggers and optimizing & tuning the SQL code.
• Process the data using SQL Server 2008/PostgreSQL and SSIS ETL Packages. Develop the scripts and Store procedures used to process the data available in flat files and store in SQL database
• Troubleshooting daily production issues, coding enhancements, providing administrative support and supporting strategic initiatives.

Environment: Microsoft BizTalk Server 2010, Visual Studio 2010, TFS 2010, Microsoft SQL Server 2008R2, Windows Server 2008, PostgreSQL, PG Admin, SOA, C#, XML, XSLT, XPATH, WCF, WSDL.

Confidential, Chicago, IL

Sr. BizTalk Developer/Lead

Responsibilities:

• Installed and Configured Microsoft BizTalk Server 2013, ESB Toolkit and ESB Exception Notification Services.
• Designed and developed different Interfaces for Integrating External vendors, Siebel, Stepwise Rating and Facets.
• Upgraded BizTalk Server 2006 R2 applications in to BizTalk Server 2013.
• Developed Orchestration to implement Dynamic mapping and Routing Mechanism.
• Develop document specification schemas, channels and ports in BizTalk server for Inbound and outbound message processing.
• Implemented Complex Mappings using Custom XSLT Templates in BizTalk mapper and calling custom .NET Assemblies and Custom SSO Configuration values.
• Used WCF SQL Adaptor for loading Accounts, Quotes, Products, and Policies in to Facets System by calling Stored Procedures. And also pulling and pushing data in to SQL Server 2008 R2/2005 for implementing interfaces.
• Integrated with Service Bus for Windows Server.
• Used StepWise API’s for creating quotes in Stepwise Rating System. This will return the eligible Plans and rates for the group of members in a Quote based on different Rating Rules.
• Worked with ESB Exception Handling Framework for implementing Exception Handling in our Applications.
• Developed Canonical Schemas and used Pub-Sub Architecture.
• 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 to improve performance of the Rating Services.
• Improved the performance of the Transformation by using custom XSLT for Complex Mappings.
• Worked with SSIS to centralized data.
• Good Knowledge and understanding on ESB Itineraries.
• Used HAT for Message Tracking and Debugging the 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 2008/2013 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 2013/2006R2, Visual Studio 2005/2012, TFS 2008/2013, Siebel CRM 7.8/8.1, Microsoft SQL Server 2005/2008R2, SSIS, Windows Server 2008/2003, Service Bus 1.1, IIS 6.0/7.0, SOA, C#, LINQ, XML, XSLT, XPATH, WCF, WSDL, Microsoft Office OneNote 2007, Parasoft, SOAP UI.

Confidential, CA

Sr. BizTalk Developer/Admin

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 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

Integration Analyst

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 - Miami, FL

.Net/BizTalk Developer

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.
• Worked on web based Application that is developed using ASP.Net, C#, and ADO.Net. The development is based on Model View Architecture.
• 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.
• 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, ADO.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.