Biztalk Consultant Resume
ArizonA
SUMMARY
- More than Eight years of experience in System Analysis, Design, Development and Implementation of Software applications and other Project methodologies.
- More than 6 years of solid EAI and B2B Experience with Service Oriented Architecture(SOA) using BizTalk Server 2013R2\2013\ 2010\2009\2006R2 .Experience in BizTalk Server Administration, Installation, and configuration in multi - server Environment.
- Hands on experience in developing complex scalable integration solutions dat are loosely coupled using BizTalk Server, Enterprise service Bus (ESB Toolkit), Business Rules Engine (BRE) and Web Services.
- Experience Implementing Complex Design Patterns in Orchestrations and ability to create sequential convoys, parallel convoys, calling pipelines in orchestration to fulfill business needs.
- Experience in creating complex integration solutions with better retries\exception handling mechanism and ability to recover the failed transactions by using various transaction types.
- Extensive knowledge with all the Adapters within BizTalk (WCF-Custom, WCF-SQL, WCF-LOB, SOAP/HTTP, FILE, FTP, SFTP, MSMQ, SQL and SMTP).
- Extensive experience in creating Custom Pipeline Components and C# Helper Classes to implement data validations and data integrity checks.
- Extensive knowledge in using EDI-HIPPA transactions such as 834,837 and EDI transactions such as 270,278,856, 810, 850.
- Complex transition design development and implementation of EDI 270 for BATCH and MIME transactions in MMIS project
- Hands on experience in implementing integration solutions using combination of Enterprise Service Bus (ESB), BizTalk and Business Rule Engine (BRE).
- Used ESB Exception Management Framework to communicate BizTalk errors and routing failures to ESB Portal/Custom Front Ends.
- Worked Extensively on SAP R/3 environment for EAI & EDI transactions with BAPI, IDoc . Expertise in Interface programs for importing data from feeder systems to different modules
- Assisted Infrastructure Team in maintain Healthy BizTalk Server environment by taking care of monthly security patching and deploying the cumulative update as and when required.
- Experience in training Customers/Business users in using the applications and using their feedback to make the applications more user friendly.
- Effective leadership skills with good written, verbal communication and presentation skills. Self-motivated with result oriented approach.
- Involved in Problem Evaluations sessions to perform Root Cause Analysis and resolve production issues.
- Involved in Integration Application solution design, code reviews and also assisted in creating test plans.
- Involved in Integration and performance testing the applications and assisted in fine tuning the solutions.
- Flexible and capable of performing multiple roles, during the lifecycle of the project, such as requirement analysis, design, development and administration.
- Experience in creating detailed Functional and Technical Specification documents for multiple projects.
TECHNICAL SKILLS
Programming Languages: C#, C/C++, T-SQL, PL/SQL.
BizTalk Tools and Middleware servers: BizTalk Server 2013R2/2013/ 2010/2009, BizTalk Mapper, BRE, BAM, ESB Toolkit.
Web Technologies: ASP.NET, ASP, XML, XSL, XSLT, XPATH, WSDL, WCF.
Markup Languages& Data Formats: HTML, XML, XSL, EDI, ANSI ASC X12, HIPAA, Flat File.
Databases Tools: MS SQL Server 2012/2008R2, Oracle 11g.
Integrated Development Environments: MS Visual studio 2013/2012/2008, TFS, Visual Source Safe.
EAI Adapters: HTTP, WCF-Custom, WCF-Web Http, WCF-LOB, FTP, SFTP, FILE, Oracle, SOAP, SQL, MSMQ and MQ Series.
Operating systems: Windows Server 2000/2003/2008/2008R2/2012, Windows 2000/XP/7
Other tools: MS Office, Outlook, Enterprise Library 4.1 / 5.1, SSIS, Visio 2003/2007, MS OneNote
PROFESSIONAL EXPERIENCE
Confidential, Arizona
BizTalk Consultant
Responsibilities:
- Installed and Configured BizTalk Server 2010, Visual Studio 2010 and SQL Server 2008R2 in Development and Test Environment.
- Implemented Complex Mappings using Custom XSLT Templates in BizTalk mapper and calling custom .NET Assemblies.
- Worked on Integration with Microsoft Dynamics CRM and analyzing CRM entities for creating, querying, updating and deleting all CRM entities using BizTalk and Organization Service.
- Worked on CRM adapter and CRM authentication token and responsible for sending and receiving data from MS Dynamics.
- Publish BizTalk Schemas as WCF Service and Developing Itineraries for different Methods.
- Developing WCF services for internal teams and also for some external Vendors based on the requirements.
- Experience in FetchXmlquery to fetch data in CRM Dynamics in BizTalk and responsible for SOAP exceptions and general exceptions. Experience in creating Custom Pipeline Component using C# for preprocessing messages in BizTalk.
- Deployment of BizTalk and .NET C# applications. Utilized MS SQL Server, SOAP, File, SQL, CRM Adapter and Oracle BizTalk adapters.
- Hands on experience in SAP BizTalk adapter setup, SAP IDoc mapping, SAP BAPI call and RFC calls.
- Created BizTalk applications to consume the EDI files received from trading partners and mapped them to internal canonical format.
- Configure Alerts in ESB Notification Services for sending send email notifications based on the type errors and category
- Created Message Archive, Message Context Property Modifier and PGP Encryption and Decryption a generic custom pipeline components and developed several pipeline components as needed.
- Created complex transformation maps for HIPAA transactions 270/276/277/278/834/835 using functoids and XSLT.
- Implemented In-Memory Caching Mechanism and parallel processing for improving the performance and also Implemented Impersonation for auditing purpose.
- Hands on experience in generate an XSLT file from an existing map created using the BizTalk Mapper and used Team Foundation Server 2010/2015 for build and development of the application.
- Deployed and delivered the builds for the various environments like Dev Staging, QA, and Production environments. Developed Microsoft SQL Server stored procedures and staging tables for pushing and pulling data to/from BizTalk.
Environment:VisualStudio2010,BizTalkServer2010,SQLServer2008R2,CRMDynamics,.NetFramework3.5/4.0/4.5/4.51,WCFServices, AdvancedFunctoids, Flat Files, XML Entity Framework, XPATH, TFS, FetchXmlQuery.
Confidential, Tallahassee, FL
BizTalk Consultant
Responsibilities:
- Experience Installing and Configuring BizTalk Server 2010, Visual Studio 2010 and SQL Server 2008R2 in Development and Test Environment.
- Implemented End to End integration solution using BizTalk for ensuring the integration with SQL Server and Legacy Systems.
- Worked on different BizTalk Adapters like File, FTP, SMTP, SFTP adapter and WCF-Custom Isolated, WCF-Basic HTTP.
- Provide over night/weekend support for the applications for high priority transaction and worked on call support 24/7 every two weeks.
- Experience in creating Custom Pipeline Component using C# for preprocessing messages in BizTalk.
- Created BizTalk applications to consume the HIPAA EDI files received from trading partners and mapped them to internal canonical format.
- Entity Data model was used for developing the individual business Services for the MMIS.
- Managed large and Complex transition design development and implementation of EDI 270 for BATCH and MIME transactions in MMIS project
- Worked with Health Insurance Portability and Accountability Act HIPAA and Complied with MMIS
- Created complex transformation maps for HIPAA transactions 270, 271, 276, 277, 837, 835 using functoids and XSLT.
- Created outbound batched EDI Files using out of the box batch orchestrations and custom batching techniques.
- Configured MSMQ Adapters in the BizTalk Administration Console at the Receive port to retrieve the inbound transaction files (270, 276) from the queues.
- Created the SQL tables to be used as placeholder for archiving historic claims data.
- Created stored procedures to handle insert and extract claims data for interaction into the SQL Tables in the database.
- Configured the SQL adapter to communicate with the database.
- Also configured the FTP adapter to send the outbound transaction (271, 277) files to external trading partners.
- Created Test documents and test scenarios for testing the work flow of all BizTalk applications.
- Assisted QA Team in functional testing and integrated testing of various stages.
- Created change control requests to promote Code changes to UAT and PRODUCTION environments.
- Prepared unit test cases and involved in the end to end testing of the BizTalk interfaces.
Environment: Visual Studio 2010, BizTalk Server 2010, SQL Server2008R2, .Net Framework 3.5/4.0/4.5/4.5.1,WCF Services, Advanced Functoids, Flat Files, XML Entity Framework, XPATH, TFS, Oracle Business Suite.
Confidential, Hoboken, NJ
BizTalk Consultant
Responsibilities:
- Installed and configuring of BizTalk Server 2013R2/2013/2010, Visual Studio 2013/2012/2010, SQL Server 2012/2008R2.
- Involved In place Upgrade of BizTalk Environment from BizTalk 2010 to BizTalk 2013 and assisted in conversion and testing of the applications.
- Install and configure the BizTalk ESB Toolkit 2.2/2.1 components, deployed the ESB Exceptions portal in Dev and Test Environment for handling exceptions.
- Extensive experience creating Custom pipeline component for implementing encryption, decryption and data compression of inbound and outbound messages transmitted to external trading partners and financial institution.
- Created complex maps to transform messages in BizTalk using most of the advanced Functoids, also extensively used inline XSLT and C# scripts to achieve complex transformations.
- Experience using Call and Start orchestration shapes to make nested orchestration calls to achieve business functionality and code reusability.
- Used Start Orchestration to carry out various tasks asynchronously like sending emails to a group while simultaneously resuming the workflow.
- Hands on Experience creating Itineraries and used BRE to implement dynamically implement transformations and to resolve end points.
- Experience Publishing BizTalk Schemas as Web Services and WCF Services and implemented secured message transmission.
- Experience in Creating and updating SQL objects like table, stored procedures, views, indexes.
- Utilized SSO Configuration Application Manager for storing and retrieving configuration data from SSO Database.
- Developed Complex SQL Server stored procedures and staging tables for persisting and extracting data to implement various data validations and lookups.
- Worked with MSI packages and binding files for the deployment/promotion of BizTalk applications into higher environments.
Environment:-Visual Studio 2013/2012, BizTalk Server 2013R2/2013/2010, SQL Server,2008 R/2012, .Net Framework 3.5/4.0/4.5/4.5.1,WCF Services, Entity Framework, XPATH, TFS, Oracle Business Suite.
Confidential, Jersey City, NJ
BizTalk Consultant
Responsibilities:
- Experience Installing and Configuring BizTalk Server 2010, Visual Studio 2008 and SQL Server 2008 in Development and Test Environment.
- Solid Knowledge in Custom Pipeline Component development & familiar in using all BizTalk and third party Adapters.
- Installed and configured ESB Toolkit and deployed ESB portal for exception handling and retry mechanism.
- Experience installing and implementing ESB Architecture using ESB Toolkit, BRE.
- Configured ESB Exception Management Portal to send alert notifications to the subscribers based on fault code.
- Experience using Business Rules Engine for performing various message level validations and runtime decisions.
- Consumed External Web services using BizTalk and implemented Robust Error Handling and Compensation Logic.
- Created custom Error reports for various interfaces sent them out as E-mails as and when exceptions occur in BizTalk.
- Published and subscribed messages directly from Message box using direct binding and filters
- Extensively used Event Viewer to detect and solve the error messages and issues underlying it.
- Assisted QA team in creating test cases and involved in the end to end testing of the BizTalk interfaces.
- Assisted DBA’s in setting up BizTalk Database maintenance jobs to maintain healthy BizTalk Environment.
- Created PowerShell Scripts to backup all BizTalk Applications and their bindings as and when required.
Environment:- BizTalk Server 2010,ESB Toolkit 2.0,BRE, Visual Studio2008, C#, MS SQL Server 2008R2, Microsoft Office Share Point Portal Server 2010, WCF Services.
Confidential, Augusta, ME
BizTalk Consultant
Responsibilities:
- Installed and Configured BizTalk Server 2009, SQL Server 2008 and Visual Studio 2008.
- Created dynamic Send Ports in the Orchestrations for ease of routing based on data content.
- Involved in Setting up the Trading Partner profiles and implementing document definitions and Organization parameters.
- Experience in creating Custom Pipeline Component using C# for preprocessing messages in BizTalk.
- Experience deploying and using Custom third party Adapters like Codeplex Blogical SFTP adapter.
- Worked on different BizTalk Adapters like File, FTP, SMTP, blogical sftp adapter and WCF-Custom.
- Configured BizTalk HTTP adapter to receive files from HTTP post.
- Created MSIs and scripts for deploying/promoting the Applications to higher environment.
- Worked on Complex Orchestrations using Convoys, mapping multiple source and target schemas.
- Experience using the SQL Profiler to trace the Database operations.
- Created High Level Technical Documents and Detailed Design documents for all BizTalk interfaces.
- Actively participated in Unit/Integration Testing usingBizTalk and Involved in Error Handling and Bug Fixing.
- Involved in documenting Application Specific Documents from the analyst provided process of business.
- Created change control requests to promote Code changes to UAT and production environments.
- Prepared unit test cases and involved in the end to end testing of the BizTalk interfaces.
- Created the SQL tables to be used as placeholder for archiving historic claims data.
- Created stored procedures to handle insert and extract claims data for interaction into the SQL Tables in the database
- Assisted QA Team in functional testing and integrated testing of various stages
Environment:- BizTalk Server 2009, SQL Server 2008, Visual Studio 2008,.NET Framework 3.0/3.5, WCF Services, Advanced Functions, Flat Files, XML, Single Sign-On (SSO), ADO.NET, TFS.
Confidential
Programmer Analyst
Responsibilities:
- Responsible for Requirements analysis, architecture development, System design, development and implementation
- Analyzing the Business requirement specifications, Use cases, and UI specification documents
- Defining the applications functional objectives by leading requirements-gathering interviews with business team, Subject Matter Experts, and softwarearchitects.
- Developing user controls and implementing code behind technique for rapid application development.
- Implemented Forms based authentication to provide secure access to different modules based on the profile information.
- Designing Web forms and code associated methods using ASP.NET and C#.
- Designed and developing triggers to replicate the model master data to different sub systems.
- Implemented ADO.NET technology for database transactions with data providers.
- Developed procedures, used by ASP.NET to perform database transactions and retrieve data.
- Extensively used debugging methodology and exception handling techniques.
Environment:- ASP.Net, ADO.Net, HTML, DHTML, C#, Microsoft Visual Studio.Net, SQL Navigator, Windows NT/2000, IIS, SQL Server, Java Script.