Swapnil Kulkarni

**** ******** ***

Nashville TN - 37211

Summary:

Over 12 years of expertise in developing integration and product based applications in Health care, Insurance domains using BizTalk Server, SSIS, C#, VB.NET, ADO.net, WCF,SOA, XML Web Services, SQL Server, HL7, EDI.

Extensive development experience in project life cycle activities and technical support including Configuration Management using Team Foundation Server (TFS) and VSS.

Extensive knowledge of developing workflows in BizTalk Server using BizTalk schemas, BizTalk Orchestrations, BizTalk Mappings, BizTalk Pipelines, Pipeline components and BizTalk adapters

Knowledge of BizTalk adapters (FILE, FTP, WCF, SMTP, SQL etc.).

Expertise Enterprise Application Integration (EAI), B2B, Health Care, SAP Integration with Legacy Systems using BizTalk Server.

Worked with the EDI Doc like 837, 835.

Hands on Experience in HL7 messages and developing workflows for HL7 integration

Expertise in database development, creating complex stored procedures, user defined functions, triggers using Microsoft SQL Server 2005 & 2008, using tools like SQL server management studio.

Extensive experience in XML, XSLT and X-Path.

Acquainted with SSIS.

Implemented design patterns like Abstract Factory, Singleton, Canonical, Scatter and Gather etc.

Experience in unit testing and test driven development.

Proven problem solving and programming skills.

Ability to work closely with users and lead cross-functional teams.

Ability to handle multiple concurrent assignments effectively.

Possessing strong communication skills, adaptability and understanding of business processes.

Versatile team player as well as independent contributor with good problem solving and interpersonal skills.

Technical Skills:

Languages

C# 2.0 / VB .Net, ADO .Net

Middleware

BizTalk Server 2013/2010/2009/2006-R2/2006

Databases

SQL Server 2005/ 2008 /2012, Oracle 8i / 9i, DB2

Application Server

Internet Information Server (IIS) 5.0 / 6.0 /7.0

OS

Windows 2008/2003/XP/2000/NT/7

Framework

.Net Framework 1.0, 1.1 2.0,3.5, 4.0

Tools & Utilities

VisualStudio.Net, Visual Source Safe, XML, XSLT, X-Path, XSD, WCF Services, Web Services, SOA

Domain Knowledge

Healthcare HL7, EDI

Education:

Masters in Computer Applications 2002 Dr. Ambedkar University Aurangabad MH India

B.Sc. (Physics, Math, Computer Sci.) 1999 Dr. Ambedkar University Aurangabad MH India

Professional Experience:

HCA, Nashville, TN Jan 2011 – till date

Role – Senior BizTalk Developer

Project – Patient Accounting Open Connect (Enterprise Application Integration)

Project Summary:

HCA, Hospital Corporation of America is a Nashville-based one of the nation's first hospital companies which locally manages facilities that includes about 163 hospitals and 110 freestanding surgery centers in 20 states and England and employing approximately 199,000 people. The goal for the project is to integrate the Patient Account system which is a Mainframe System with all the Hospitals HL7 systems by converting in to HL2.5. Also provide a standard tracking, reconciliation and reporting system

Few HIS systems integrated with Patient Accounting

Meditech

EPIC

HMS

Siemens Invision

McKesson Series

McKesson STAR

Responsibilities:

Created technical specifications for different functionalities

Implemented business process using Orchestration.

Created pipeline components using C#.

Created BAM and exception handling.

Created canonical and HIS system specific schemas.

WCF-Service to get data from DB2 database.

Input output ports using various BizTalk adapters.

Created stored procedures to fetch and store data using BizTalk SQL and WCF-Sql adapter.

Created various maps for transformation of data from one system to other.

Used Team Foundation Server (TFS) for version control.

Creating technical specifications and unit test case scenarios for different functionalities.

Used BTDF scripts for one click deployment and configuration.

Environment:

BizTalk Serve 2010, Sql Server 2008, SSIS, HL7, C# .Net, SOA

Adapters: MLLP, DB2, WCF SQL, FILE, SMTP, WCF HTTP, SFTP

HCA, Nashville, TN Aug 2010 – Jan 2011

Role – Senior BizTalk Developer

Project – ECW Relay Health Integration (Business 2 Business Integration)

Project Summary:

Relay Health Assurance Plus project is a Business to Business Integration project between internal vendor billing application (ECW) and External Claim/Billing application Relay Health. This is an EDI project where BizTalk is used for integrating the E-Clinical Works application (ECW) and the Relay Health (RH) application. ECW is HCA application used for processing claims and send EDI messages out to Payers. RH is a third party claim processing system used for applying health care edits and sending to the Payers. So, BizTalk is used to send and receive EDI file from ECW and RH.

Responsibilities:

Created technical specifications for different functionalities

Implemented business process using Orchestration.

Created pipeline components using C#.

Created BAM and exception handling.

Created canonical and HIS system specific schemas.

Input output ports using various BizTalk adapters.

Created stored procedures to fetch and store data using BizTalk SQL and WCF-Sql adapter.

Created various maps for transformation of data from one system to other.

Used Team Foundation Server (TFS) for version control.

Creating technical specifications and unit test case scenarios for different functionalities.

Used BTDF scripts for one click deployment and configuration.

Environment:

BizTalk Serve 2010, Sql Server 2008, HL7, C# .Net, SOA

Adapters: WCF SQL, FILE, WCF HTTP, SFTP, EDI

Tieto, Germany Aug 2008 – Aug 2010

Role – Senior BizTalk Developer

Project – SAP (Health Care Module) Integration (Business 2 Business Integration)

Project Summary:

iMedOne has one module which deals with all the external systems for data transfer using HL7, PROSOFT, XML etc. Many hospitals in Germany are using SAP (ISH Module) as a master system. They use this system for keeping all the master data. So data in iMedOne and SAP system needs to be in sink as hospital is using both the systems in parallel. To achieve the above thing we have done integration using the SAP adapter for BizTalk. So we were getting data from SAP by calling BAPI’s and storing data in iMedOne

Responsibilities:

Involved in requirements gathering and project designing.

Prepared the Design Documents and Development of the System.

Created various Custom components which are Re- Usable.

Actively involved in customer meetings to understand business needs and timely changes to the initial requirements.

BizTalk: Creating Schemas, Mappings,Orchestrations

configuring File, SQL, SAP Adapters

Creating of rules using Business Rule Composer.

Creating Activities, Views, deploying the Views, Tracking the BAM

Involved in creating tables, stored procedures in SQL Server 2008 for data manipulation and retrieval.

Environment:

BizTalk Serve 2009, Sql Server 2008, C# .Net

Adapters: WCF SQL, FILE, WCF, WCF-SAP

Tieto, Germany July 2006 - July 2008

Role – Senior BizTalk Developer

Project – Integration Server Redesign (Product Integration)

Project Summary:

iMedOne is a product which evolved during last 15 years and due to central system in hospital it needs to communicate with all other subsystems in hospital and other legal parties and government institutions. So there were various interfaces developed using various languages and deployed at customer. But many of the languages are out dated and the interfaces are not able to meet all the new needs of the subsystems as they are also changed. To overcome this problem of meeting the customer needs and integrating with the new systems we have decided to re write all the interfaces using a standard tool i.e. BizTalk as BizTalk is standard tool for business integration & comes with Accelerator for HL7 and SAP and various features of EAP, BPA.

Responsibilities:

Involved in requirements gathering and project designing.

Prepared the Design Documents and Development of the System.

Created various Custom components which are Re- Usable.

Actively involved in customer meetings to understand business needs and timely changes to the initial requirements.

BizTalk: Creating Schemas, Mappings,Orchestrations

Configuring File, SQL, SAP Adapters

Creating of rules using Business Rule Composer.

Creating Activities, Views, deploying the Views, Tracking the BAM

Involved in creating tables, stored procedures in SQL Server 2008 for data manipulation and retrieval.

Environment:

BizTalk Serve 2009/2006, Sql Server 2008, HL7, C# .Net

Adapters: WCF SQL, FILE, WCF, MLLP

Tieto, Germany July 2005 - July 2006

Role - .Sr. Net developer

Project – Layouter Designer

Project summary:

UDL (User Defined Layout) technology in iMedOne enables hospitals to build in their specific workflows into the system and extend the standard modules with specific modules as and when required. iMedOne supports a seamless integration of these extensions into the standard modules such that the user finds these to be inherent part of the software itself. UDL Technology makes the software a powerful system in this changing world.

Responsibilities:

Created Graphical User Interfaces (GUI) as per client requirements.

Used ADO.NET technology for data retrieving, querying, storage and manipulation.

Integrated with existing product so that end user can use it easily.

Used TFS for version control and automatic builds.

Environment:

C# 2.0, Visual Studio.Net, ADO.Net, Oracle 8i,

First-Insight, Hillsboro, OR, (Offshore India) Mar 2004 – June 2005

Role - Developer

Project - Paperless Practice Mgmt. & Electronic Medical Records Sol

Project Summary:

MaximEyes is powerful and well-integrated software offers electronic medical records, scheduling, billing, patient demographics, recall, Insurance, optical point-of-sale, inventory management, and much more. It even connects with ophthalmic equipment inside your office and insurance carriers outside your office Maxim Eyes is HIPAA compliant for electronic claims submission. MaximEyes Offers security features for billing staff and exam module security capabilities that allow for exam locking that is doctor specified. Because HIPAA security standards are always evolving. Responsibilities:

Involved in understanding requirements

Involved in development.

Involved in preparing the test case documents.

Environment:

FilemakerPro, Visual Basic

Contact this candidate