Sr. Biztalk Consultant Biztalk Consultant Resume
Charlotte, NC
SUMMARY
- Experience of over 9 years as an application Developer and Administration in BizTalk server 2006R 2/ 2009/2010/2013 R2/2016 and .NET.
- Extensive experience in developing, maintaining applications, Web based products, implementation ofPresentation Layer, Business Layer, Database Layer and n - tier Architecture applications.
- Strong knowledge and familiarity of SQL Server 2005/2008/2012/2014 and Visual Studio 2005/2008/2010/2012/2014.
- Hands-on experience in Installation, Configuration, Migration, Designing, Administering and Managing BizTalk Server 2010.Worked extensively on FTP, FILE, SMTP, SQL and SOAP Adapters.
- Knowledge of HL7 transactions and the exchanges associated.
- Good understanding of BizTalk Server 2006R 2/ 2009/2010/2013 R2/2016product features.
- Experience include BAM/BRE in the BizTalk Server environment.
- Experience includes implementing many adapters like MSMQ, SQL, HTTP, FTP, WSS.
- Knowledge of HIPPA EDI Transactions (270, 271, 276, 278, 810, 820, 824, 837, 834, 835) and implementation of solutions in a Retail and Telecommunication health care setting using HIPPA-EDI.
- Extensive knowledge of Developing BizTalk Enterprise solutions using Mapping Schemas, Custom Functoids, Patterns calling COM and .NET Components, and custom pipelines.
- Comprehensive understanding ondeveloping Complex Orchestrations, Implementing Error Handling, Compensation and Failed Message Routing.
- Experienced in BizTalk - SAP - FICO module integration using WCF-SAP Adapter.
- Well versed with implementing solutions leveraging benefits of BRE and invoking policies using Call Rules Shape in orchestrations and .NET assembly.
- Strong experience in Enterprise Application Integration with BizTalk and MQ Series for asynchronous delivery of data using messaging solution.
- Understanding of Business Activity Monitoring (BAM), and Health and Activity Tracking (HAT) for logging and debugging the application process flow.
- Experience working with backend databases SQL Server 2005/2008/2012/2014 , and developing Stored Procedures, Functions, and Triggers for the implementation of data integrity using T-SQL.
- Adequately experienced with XML using in Workflows and automation.
- Adept at developing effective practices, policies and procedures, project documentation and milestones, and technical/business specifications.
- A team player with excellent interpersonal, communication and presentation skills
- Self-motivated with strong initiative and team spirit.
TECHNICAL SKILLS
Integration Tools: BizTalk 2016/2013R 2/2010/2009/2006 R2/2006
BizTalk Tools: HAT, BAM, BREBizTalk Adapters-FILE, FTP, HTTP, SOAP, SQL, MQ Series, SMTP, POP3, WCF, WCF Adapters, MSMQ, SAP, HIPAA Accelerator 3.3/3.0, SWIFT Accelerator 2.3/2.0, HL7EDI Transactions- 270,271,276, 278, 810,820,824, 834, 835, 837, 850, 855,927, 940, 997 Versions (4010, 5010)
Programming Languages: VB.Net, VISUAL BASIC, JavaScript, Java, SQL, C++, C#, HTML, CSS, PHP, HTML5 Python,XML (XPATH, XSD, XSLT). Databases-SQL Server 2014, 2012, 2008 R2/2005, MS Access, Oracle 11g,10g/9i, IBM DB2, PL/SQL and AccessData Formats - EDI, ANSI ASC X12, HIPAA, Flat File, XSLT, XML, XSD.
Operating Systems: Windows 8, Windows 7, Windows Server 2008/2003/ Vista/ XP Pro /NT4.0/ UNIX/ MS -DOS, Linux.
Microsoft Tools: .NET Framework 3.5/3.0/2.0, Visual studio 2014,2013,2012,2010,2008,2005, Visual Source Safe(VSS), Word Excel-Spreadsheet, Outlook PowerPoint, Team Foundation Server(TFS), MS VISIO
Networking Technologies: TCP/IP, Subnet, Configuring Network, Router Configuration, Local Area Network(LAN)
PROFESSIONAL EXPERIENCE
Confidential, Charlotte, NC
Sr. BizTalk Consultant BizTalk Consultant
Responsibilities:
- Installation and Configuration of BizTalk 2013, SQLServer2012 and Visual Studio 2012on Windows 7.
- Up-gradation of BizTalk 2010 to BizTalk2013 and artifacts migration of BizTalk2010 to BizTalk2013 environment.
- Deploying different applications from different services with help of Biztalk2013 Server.
- Used ESB EMF (Exception Management Framework) for Exception Handling in BizTalk Applications.
- Created different interfaces between legacy systems and other Applications using BizTalkServer2013.
- Implemented Business Rules in BizTalk Application using Business Rules Engine (BRE).
- Involved in the system design, development and testing.
- Designed and created the custom pipelines inBiztalkapplications for archiving the requests messages and results messages and for logging.
- Used PowerShell Scripts to Install, Uninstall, Deploy, Redeploy, Undeployed and adding the reference applications to theBiztalkapplication.
- Implemented ESB exception management to communicate BizTalk errors and routing failures.
- Production Support for all BizTalk solution is provided 24X7.
- Used Design Patterns such as Aggregators, Convoys to assemble multiple XML messages into one Outgoing message.
- Developed the BizTalk Orchestration, with WCF service and exposed to Azure Service Bus Relay.
- Worked on designing, developing and testing of integration interfaces with different top of the line BizTalk technologies like Enterprise Service Bus utilizing ESB Toolkit 2.1/2.0, different BizTalk adapters, also proficient in Enterprise Application Integration (EAI) solutions, and in B2B solutions.
- Used Direct Bound Port.
- Created different custom .Net components to be used and called in BizTalk maps, BizTalk business rules and BizTalk orchestration.
- Use various WCF adapters in BizTalk integration.
- Designed SQL Tables and created stored procedures.
- Creation of user manual and supported documents for the production and maintenance.
Environment: BizTalkServer2013, MSMQT, C#, Site Scope, ESB, XML, ASP.NET, SQLServer2012 and Visual Studio2012.
Confidential, Eden Prairie, MN
Sr. BizTalk Consultant
Responsibilities:
- Installation and Configuration of Biztalk 2016, SQL Server2016 and Visual Studio 2015 On Windows 10
- Monitor, troubleshoot, resolve and process inbound and outbound files
- Worked with Exchange data, ensuring compliance with rigorous federal standards.
- Up-gradation of BizTalk 2010, BizTalk2013 to BizTalk 2016 and artifacts migration of BizTalk2010, BizTalk2013 to BizTalk 2016 environment.
- Build innovative ETL solutions for every phase of the data lifecycle
- Develop SQL code and build ETL packages to integrate data
- Be able tocustomize and automate EDI transactions
- Generating the 999 and TA1 Responses from the 820 with the use of file adapter
- Enrollment files being imported into Javelina
- Creating the Stored procedure that will return a xml format of the whole data that we are storing in database
- Mapping out the data for the IC834 enrollment record from the 834
- Importing Multiple file 820 details into the Sql database table
- Worked On the 834 COB Scrubbing to remove COB segments from the loop
- Generating the IC834 Termination, Cancellation, Effectuation from the 834 Inbound
- Processed to insert all the member Records groups with multiple products from inbound 834 into SQL Table
- Worked with SOAP, WCF-SQL, SMTP, FTP and file adapters
- Deploying the application in remote server and production server
- Deploying different applications from different services with help of Biztalk2016 Server
- Configured FILE, SOAP and HTTP adapters to resolve protocols with different systems
- Testing and debugging of positional & delimited records for parsing
- Created Multiple Host & Host instances and configured Adapter handlers in clustered BizTalk Server Production environment.
- Schema Determination for Outgoing EDI Messages, Mapping the EDI files According to the Requirement of the Production,Configuring a Party for an EDI Solution, finding the Issues with EDI Parties.
- Production of X12 (EDI files) from XML files through HIPAA Accelerator 3.3 is being designed and developed using BizTalk components
Environment: BizTalk Server 2016/2013/2010 , SQL Server 2016, Visual Studio 2015, XML, C#,WCF, Microsoft Office, X12 Formats, ETL Solutions.
Confidential, Atlanta, GA
BizTalk Consultant
Responsibilities:
- Involved in Development, Deployment, Testing, and Go-Live stages of the project.
- Installed and configuredBizTalkServer 2009/2010 and theprerequisite software on Developer machines, staging, QA, and Production environments.
- Migrated applications fromBizTalkServer .
- Configured out-of-box pipelines and developed custom pipelines to attach Itineraries to the incoming Xml messages using Business Rule Engine (BRE).
- Developed Messaging and Orchestration Itinerary services to route the incoming xml messages.
- Developed Dynamic Transformations & Endpoint Resolver services using BRE Resolver Extension in Itineraries.
- Designed the Business Process Management using Orchestrations to batch the xml messages on a periodical basis.
- Configured ESB Exception Management Portal to send alert notifications to the subscribers based on fault code.
- Worked with Business Rule Engine to create policies/Rule set for various complex message validations
- Developed policies and vocabularies for various systems based on content types using BRE.
- Configured connection strings for various applications using Single Sign On (SSO).
- CreatedWCFServices responsible for providing real time data from integrated server to Client Application.
- Developed dynamic routing orchestrations to route the messages dynamically using Business Rules.
- Configured Exception in orchestrations and Worked with WCF, MSMQ, File, SOAP, SQL,Http and FTP adapters.
Environment: BizTalkServer 2009/2010/2013 , SOA, IIS 7, C#, Windows Server 2008, SQL Server 2008, Oracle 10g/9i, MS SQL Server Reporting Services, WCF, Visual Studio .Net 2008/2010,TFS, ASP.NET using VB.NET, XSLT.
Confidential, Irving, TX
BizTalk Consultant
Responsibilities:
- Installation and Configuration of BizTalk2006R2, SQLServer2005, HIPAA 3.3.
- Modification of existing schemas based on implementation guide for 834, 835 and 837.
- Part of workflow for 837 Dental encounter processes team which is designed.
- Production of X12 (EDI files) from XML files through HIPAA Accelerator 3.3 is being designed and developed using BizTalk components.
- Worked with HTTP, FTP, SAP, MQ Series, SOAP and SMTP Adapters.
- Planned, designed and developed BizTalk Orchestrations based on internal and Business Partner specifications.
- Worked with ESB Architecture and Developed Custom Pipeline Component as part of the ESB for the use of BRE to define Trading Partner contract.
- Creation and implementation of XML-based forms using InfoPath to gather and share information.
- EDI schemas are translated effectively to IDOC formats and sent to SAP Systems.
- Large file handling performed using the custom pre-processor.
- Enabled a business process which is not precisely structured and highly iterative using Correlation.
Environment: BizTalk 2006 R2, Share Point Services, ASP.Net, VB.Net, .Net 2.0, HIPAA 3.3 and SQL Server 2005.
Confidential, Franklin, TN
.Net Developer
Responsibilities:
- Responsible for creating XSD files that describes NetOxygen database tables and columns which contains loan data to be sent to the third party.
- Involved in the design and development of database, created Complex Queries using DDL & DML, Stored Procedures, and Views using SQL Server and worked on Transact-SQL queries.
- Responsible for creating XSL files that transforms the provider’s response back into the format needed by NetOxygen for import into database.
- Created Web and Win Forms using ASP.NET Server Controls, Validation Controls that are responsible for holding the Response data.
- Worked on Web Services (asmx) to access External Interface Data.
- Worked on creating Interface Request Dialog using C#.Net that allows the user to actually make a request as well as enter in any additional loan context data that is sent to the provider.
- Worked on creating Interface node Interpreter (Event Handler) that resides in the app server and which is responsible for retrieving the request data from database and sending data to data provider.
- Responsible for creating XML configuration files that contains various settings for the interface including the path of XSD and XSL files and also the physical path where the output xml file has to be saved.
- Responsible in building a Flat File that contains the loan context data of all loans and which is sent to the client.
- Worked on creating a windows scheduler task that executes Loan Closing Processor and Recovery Loan Closing Processor on a daily basis.
- Involved in Unit Testing, Integration Testing and System Level Testing and conducted Regression Testing after every code release.
Environment: Visual Studio 2010, SQL Server 2008, C#.Net, VB.Net, LINQ, PL/SQL, .Net Framework 3.5/4.0, NO Studio, NO Enterprise Manager, TFS 2010, XML, XSD, XSL, IIS, Windows 7, Microsoft Visio, Microsoft Office 2010.
Confidential, Willingboro, NJ
.Net Developer
Responsibilities:
- Responsible for requirement gathering and preparing the Requirement Specification Document.
- Developed design documents using Object Oriented Methods & involved in complete life cycle of development using Agile methodology.
- Created rich, easy-to-use Views, Partial Views using Scaffolding Templates and Razor View Engine using MVC.
- Designed business applications using web technologies like HTML, DHTML, XHTML, XSL, JQuery, XSLT and CSS.
- Developed solutions for diverse programming scenarios in C#.Net, employing Object Oriented Programming (OOPS) concepts such as Encapsulation, Inheritance, Polymorphism, and Abstraction.
- Customized .Net Login Controls to implement Authentication and authorization.
- Designed WCF model for building secured and reliable web services for accessing the data across the real-time interfaces.
- Generated the Entity Data model (.EDMX) and associating the POCO entity Objects with Entity Framework.
- Wrote SQL Queries, Stored procedures, Joins, Triggers to process large collection of products and used Data Reader, Data Adapter, SQL Command and Dataset for retrieving data from database using SQL.
- Extensively used collections, interfaces, abstract classes to implement the project and also worked with the Exception Handling.
- Used Ajax Controls like Script Manager which manages the client side script of Ajax and Update Panel which enables sections of a page to be partially rendered without a post back.
- Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS.
