SUMMARY:

• Extensive experience in Enterprise Application Integration, Business to Business solutions, application.
• Expertise in designing middleware architecture and custom development, utilizing Microsoft Technologies, SOA. Designs, REST services and develop high level, and detailed BizTalk solutions for high volume messaging using best design patterns.
• Extensive experience in installing & configuring VMs, Shared Development environments
• Experience in error handling using ESB Toolkit and logging

TECHNICAL SKILLS:

Operating Systems: Windows NT/2000/2003, XP, 7 Enterprise

Applications: MS BizTalk 2013 R2, MS SQL Server 2012, IIS, SharePoint Services, SSIS, SSO, ESB, EDI, HL HIPAA, BAM, BRE

Development: C#, VB.NET, ASP.NET, SQL, XML, XSLT, XSD, WCF, WF, JavaScript, HTML, CSS, Visual Studio - 2010 TFS, ICD9, ICD10, QNXT

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Biztalk Developer / Lead

Environment: BizTalk Server 2013 R2, SSIS, Visual Studio .NET, MS-SQL WCF, C#, ASP.NET, XML, XSD, BAM, HAT, SSO, SOA .NET, SQL Server 2012, HL7 ADT and ORU

Responsibilities:

• Designed BizTalk Handshaking process involving legacy, BizTalk Interfaces having data source/destination staging tables, and error reconciliation process.
• Participated in the initialImpact Analysis(ICD-10) for all the critical functions, i.e., & Enrollment, Claims Processing, Utilization Management, Medical Policy, Reporting, Vendor Management, etc.
• Participated in ICD 9 to ICD 10 codes conversion.
• Created Encounter Biztalk Applications using EDI 837 claim schemas. Generated the Encounter data from Hill Physicians to transfer to 14 different providers.
• Created custom mappings betweenICD-9 and ICD-10 codes
• Prepared BizTalk environment plan in terms ofBizTalk/SQL Server/SAN/Network topologies, disaster recovery/failover BizTalk environments
• Designed and developed Biztalk applications for the QNXT claims processing using EDI .
• Developed, unit tested the various applications for EDI 834 enrollment applications.
• Managed electronic hospital admissions and lab results using Biztalk HL7 adapter.
• Configured the parties, profiles and agreements for various providers in Biztalk Administration.
• Generated the schemas using the WCF-SQL adapter wizard to get the data or update the data from the stored procedures.
• Designed and developed receive and send pipelines.
• Designed and created the custom pipelines in Biztalk applications for tracking of the messages and for adding and saving the context of the messages using C#.
• Developed the maps using different types of Functoids, XSLT, Inline C# and external assembly.
• Involved in writing middleware technical specifications for various interfaces.
• Designed and developed the middleware error handling mechanism using ESB.
• Designed and developed BAM infrastructure (BAM Activities/Views/ BAM API/Messaging Eventstream Interceptors) to track transactions in/out of the system to the exchange.
• Created BAM activities and deployed them on BAM Portal Web Site to track the success rate and state of the transactions.
• Wrote complex stored procedure to create the XMLs or to get data to conduct complex business functional.
• Set up and configured Biztalk in various environments and deployed the applications on different environments (Test, UAT, PPR) using custom bat programs.
• Extensively used the WCF-SQL, WCF-Custom, file, SMTP, MSMQ, WCF-BasicHttp, WCF-WSHttp FTP adapters.
• Constructed SQL Queries, Stored Procedures, Indexes, Functions and, Views to support efficient data storage and manipulation
• Utilized Microsoft’s SQL Server Integration Services (SSIS) to orchestrate the extraction of data from QNXT, and third-party system
• Created complex SSIS packages for ETL from Master Data Stage to Stage to Production DBs.
• Designed SSISPackagesto transfer data from flat files to SQL Server
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Involved inMonitoring andtroubleshooting complex packages
• Created the Unit Test documents after end to end testing for negative and positive test scenarios
• Clustered Biztalk SQL environments
• Load balance Biztalk - Master/Slave Biztalk Architecture
• High availability host configuration
• Optimization of host threshold in memory settings.
• Deployed the applications on different environments using the BizTalk using BizTalk Deployment Framework
• Evaluated suitability of various BizTalk adapters for the middleware implementation.

Confidential

Sr. Biztalk Consultant

Environment: BizTalk 2010, SSIS, Visual Studio .NET, MS-SQL WCF, C#, ASP.NET, XML, XSD, BAM, HAT, SSO, SOA 1.2

Responsibilities:

• Designed and developed the Biztalk applications to transfer and synch the data between PeopleSoft and Maximo.Actively participated in JAD sessions for Biztalk applications and actively interacted with client team in techno-functional meetings.
• Created different types of schemas for the various interfaces.
• Generated the schemas using the WCF-SQL adapter wizard to get the data or update the data from the stored procedures.
• Used BizTalk WCF Service Consuming Wizardfor generating the schemas and orchestration from the service WSDL to send the requests to WCF service and get the response back from the WCF service.
• Used the BizTalk WCF Service Publishing Wizard to Publish Orchestrations as WCF Services to get the message from service into DCP from external agencies.
• Designed and developed receive and send pipelines.
• Designed and created the custom pipelines in Biztalk applications for tracking of the messages and for adding and saving the context of the messages.
• Developed the maps using different types of Functoids, XSLT, Inline C# and external assembly.
• Extensively used Biztalk ESB Toolkit for processing the People-Soft and Maximo Data.
• Used various design patterns including Message Routing Patterns, Message Transformation Patterns, Scatter Gather Patterns
• Used different types of resolvers including custom resolvers with resolution types of Map/EndPoint.
• Used different types of Itinerary Service Extenders - On-Ramp, Messaging, Off-Ramp, Orchestration Extenders.
• Designed and developed complex orchestrations.
• Wrote complex stored procedure to create the XMLs or to get data to conduct complex business functional requirements for outbound interfaces and also for updating the status of the Batch..
• Set up and configured Biztalk in various environments and deployed the applications on different environments (Test, UAT, PPR) using custom bat programs.
• Extensively used the WCF-SQL, WCF-Custom, file, SMTP, MSMQ, WCF-BasicHttp, WCF-WSHttp FTP adapters.
• Created the Unit Test documents after end to end testing for negative and positive test scenarios.

Confidential

Sr. Biztalk Lead

Environment: BizTalk 2010, SSIS, Visual Studio .NET, MS-SQL WCF, C#, ASP.NET, XML, XSD, BAM, HAT, SSO, SOA 1.2

Responsibilities:

• Designed and developed various applications by implementing various design patterns in Orchestration - Aggregator, Content Based Routing, Dynamic Routing, Error Handling, Message Broker, Message Translator, Convoys, Scatter and Gather, Splitter etc.Designed and developed the Biztalk applications to transfer and synch the claim and claimant data between EDD and 20 different agencies like DOL, TWR, IDM, ODPD etc.
• Actively participated in JAD sessions for Biztalk applications and actively interacted with client team in techno-functional meetings.
• Created schemas for flat files and for xml files for the various interfaces.
• Generated the schemas using the WCF-SQL adapter wizard to get the data or update the data from the stored procedures.
• Used BizTalk WCF Service Consuming Wizardfor generating the schemas and orchestration from the service WSDL to send the requests to WCF service and get the response back from the WCF service.
• Used the BizTalk WCF Service Publishing Wizard to Publish Orchestrations as WCF Services to get the message from service into UIMOD from external agencies.
• Designed and developed receive and send pipelines.
• Designed and created the custom pipelines in Biztalk applications for archiving the requests messages and results messages and for logging.
• Developed the maps using different types of Functoids, XSLT, Inline C# and external assembly.
• Designed and developed complex orchestrations including common orchestrations which will be called from the other orchestrations. Also created the start Orchestrations which will be started using start Orchestration shape.
• Designed and developed the Biztalk applications for automatic email correspondences using SMTP Util, Xlang custom formatter, SMTP adapter.
• Created BAM activities and deployed them on BAM Portal Web Site to track the success rate and state of the transactions.
• Wrote complex stored procedure to create the XMLs or to get data to conduct complex business functional requirements for outbound interfaces and also for updating the status of the Batch.
• Developed the .net class for formatting, validation of the messages and to check mandatory fields.
• Extensively used the WCF-SQL, WCF-Custom, file, SMTP, MSMQ, WCF-BasicHttp, WCF-WSHttp FTP adapters.
• Set up and configured Biztalk in various environments and deployed the applications on different environments (Test, UAT, PPR) using custom bat programs.
• Scheduled the Biztalk Batch jobs using custom Gateway application.
• Designed and developed end to end SSIS packages for archival and retention of logs.
• Involved in reverse engineering of Biztalk applications which were developed for batch/ETL jobs into SSIS packages.
• Deployed the SSIS packages on different environments (Test, UAT, PPR, and PROD) and scheduled the SQL server Agent Jobs to execute the SSIS packages.
• Created the Unit Test documents after end to end testing for negative and positive test scenarios.
• Followed ITIL process (Incident Management, Problem Management & Release Management) to ensure the standardized methods and procedures are used for efficient and prompt handling of all the changes.
• UIMOD went live successfully in Sept 2013.
• Production Monitoring of the applications and provided support on various issues raised by client

Confidential

SVC Info Developer III (Senior .NET C# BizTalk Developer)

Environment: BizTalk 2010, CRM 2011, SSIS, Visual Studio .NET, WCF, C#, ASP.NET, XML, XSD, Windows Server 2003, BAM, HATT-SQL, ESB Toolkit, EDI, HIPAA

Responsibilities:

• Participated in the JAD sessions to discuss the design and development of the interfaces. And helped in creating the design document for the Batch processing using BizTalk.
• Designed and developed end to end SSIS packages to get the data from the CRM system using execution of stored procedure and splitting the XML into child record XMLs and logged the failure and success of the SSIS packages by updating the log tables.
• Wrote complex stored procedure to create the XML as per the data elements requirement for the schema of the batch jobs and also updated the logger table for success and failure of the execution of stored procedures
• Generated the schemas using the WCF-SQL adapter wizard and also using BizTalk WCF Service Consuming Wizardfor generating the schemas from the service WSDL.
• Published BizTalk Schema as WCF service from BizTalk using BizTalk WCF service publishing wizard to send the message into FLELIS system from external agencies.
• Developed the Orchestrations for the batch jobs to create the notifications and to create incidents or to terminate eligibilitiesDeveloped the .net class libraries which were called from BizTalk orchestration to integrate with Microsoft Dynamics CRM 2011.
• Created the various classes to create the cases (CRM Incidents), create the task activities and terminate the eligibilities etc.
• Extensively used the WCF-SQL, WCF-Custom, file, SMTP, MSMQ, WCF-BasicHttp, WCF-WSHttp adapters.
• Implemented BAM to monitor the activities and milestones.
• Responsible for creating PoliciesusingBusiness Rule Engine.
• Installed and configured the BizTalk ESB Toolkit components, Monitored exceptions in the web-based ESB Management Console and Created complex itineraries.
• Deployed the applications on different environments (UAT, SIT) using the BizTalk using BizTalk Deployment Framework directly from TFS.
• Deployed the SSIS packages on different environments (UAT, SIT) and scheduled the SQL server Agent Jobs to execute the SSIS packages.
• Created the Unit Test documents after end to end testing for negative and positive test scenarios.

Confidential

SVC Info Developer III (Senior .NET C# BizTalk Developer)

Environment: BizTalk 2009/2010, Visual Studio .NET, WCF, C#, ASP.NET, XML, XSD, Windows Server 2003, BAM, HAT, T-SQL.NET 3.0, SQL Server 2008

Responsibilities:

• Implemented the .Net frame-work for the BizTalk server solution for the various interfaces.
• Developed C# components that carry out the complex functionality of the BizTalk server solution.
• Created schemas for flat files and for xml files for the various interfaces.
• Developed custom pipelines in BizTalk Server solution.
• Developed common and reusable Orchestration for the interfaces to send data out of the Tax and Wage System.
• Created maps for the interfaces to outbound files.
• Designed and implemented the custom .Net component for generating logical records.
• Designed and developed the custom .Net component for processing the logical records.
• Designed and developed the custom .Net component for result accumulators for various interfaces.
• Implemented error handling with Custom Exception, Failed Message Routing and with calling the orchestration and implemented batch restart for BizTalk server solution.
• Created BAM Activities in Excel Sheet for reporting purpose and for BAM Portal.
• Used Microsoft SQL Server 2008 to create tables, views, stored procedures, user defined functions, triggers and indexes
• Implemented Adapters: SQL, DB2, MSMQ, MQSE, File, WCF, Http.
• Actively Worked with BizTalk Rules Engine, written Business Process Vocabulary and Rules.
• Extensively worked on BizTalk Administrator Console for error tracking, managing applications on different servers, deployed applications to Development, Staging, Test and production BizTalk servers.
• Developed WCF and WF components for the modules assigned
• Also worked in Registration, Tax and Wage modules:-
• Designed front end using WCSF design pattern. Model - View - Presenter is used to define the properties on view and then controller is used to call WCF services.
• Implemented & Unit test WCF Services.
• Created the business objects and used Oracle Imaging and Process for sending correspondence to employers.

Confidential

Responsibilities:

• Contributed to architecture design, delivered design artifacts for different modules.
• Comprehended the application framework and designed & developed appropriate MVP artifacts.

Confidential, OR

Responsibilities:

• Was responsible for the design and development of custom .Net components.
• Developed TSQL functions, stored procedures and scripts.
• Created BizTalk components (Orchestration, Pipelines, Schemas, and maps)
• Worked on EDI schemas and maps for the HIPAA 834 Enrollment/ HIPAA 837 Health Care Claims.
• Received a HL7 ORU (Observation Result) Message.
• Converted that message to an ORU 2.4 Version message.
• Added the necessary MSH Segment.
• Captured the ACK Message
• Tuned queries using hints, monitoring index usage

Confidential, Fremont, CA

Developer/ Analyst

Environment: BizTalk 2006, Visual Studio .NET, WCF, AJAX, C#, ASP.NET 3.0, XML, XSD, Windows Server 2003, BAM, HAT, T-SQL.NET 3.0, SQL Server 2005, EDI

Responsibilities:

• Installation and Configuration of the Portal Server, Web Parts and Active Directory.
• Developed schemas for xml and flat files
• Developed and deployed Orchestrations for different Services falling under SOA Architecture.
• Define BAM Activities and Preparation of Business Requirements Aggregations.
• Used Microsoft SQL Server 2005 to create tables, views, stored procedures, and user defined functions, triggers and indexes.
• Working with T-SQL includes transaction control, exception and error handlingAnd declaration of variables.
• Developed business rules.
• Created rules in .NET environment.
• Plan and execute production deployment and release management..
• Implementation of agile SDLC.
• Developed MAPS to be used in the orchestration.
• Developed DTS packages to bulk transfer the data on a schedule basis.
• Created orchestrations that could be exposed as web services.
• Developed C# components that carry out the complex mapping.
• Preparation of SQL Reports based on Reporting Database.
• Prepared Change Requests and Test Cases and Impact Analysis of change requests.
• Worked with WCF, defined the service contracts.
• Implemented the WCF services and configured the bindings.
• Mapped various types of documents Flat file to XML, Flat file to EDI, EDI to XML
• Experience in Agile environment.
• Created Custom Pipeline Components to handle specific file Structure.
• Used C# to create custom functions in the BizTalk Mapper.
• Conducted Functional, Integration and Load testing.
• Prepared Technical & Functional Specification documents.
• Documented and Transfer the knowledge to the users to use the Product very efficiently.
• Monitoring- HAT - Health Activity Tracking

Confidential

EAI/B2B Implementation - Developer

Responsibilities:

• Was responsible for creating: COM+ (.NET) objects for use as AIC’s in BizTalk 2002, XSD schemas from Rosetta net Pip specifications, utility objects for BizTalk 2004, and maps between Rosetta net schemas and internal process canonical Xml for use in BizTalk 2004 orchestrations.

Confidential

Developer/ Analyst

Responsibilities:

• Designed, developed and documented computer programs applying knowledge of programming techniques and computer systems. Evaluated user request for new or modified program, such as for financial or human resource management to determine feasibility, cost and time required, compatibility with current system and computer capabilities.
• Designed, developed and maintained client/server, web-based applications.
• Consulted with users to identify current operating procedures and clarify program objectives.
• Prepared flow charts and diagrams to illustrate sequence of steps, program must follow and to describe logical operations.
• Analyzed, reviewed and altered programs to increase operations efficiency or adapt to new requirements.
• Wrote manuals for users to describe installation and operational procedures and provided technical assistance to program user.