Biztalk Consultant Resume
Charlotte North, CarolinA
OBJECTIVE
- A position in the Software Industry with a vision and drive to leverage evolving technologies to create highly cohesive as well as loosely coupled service - oriented applications
SUMMARY
- Software developer with over 10 years of experience in all phases of software development life cycle including planning, requirements analysis, design, development, testing, deployment and production support.
- Extensive experience in design and development of scalable EAI/EDI solutions for complex problems using BizTalk Server, Azure, .NET Framework, SQL Server, WCF, REST and SSIS in Mid-to-Large size organizations.
- Built asynchronous messaging systems and effectively applied various Enterprise Integration patterns using BizTalk Orchestrations, Pipelines, Maps, SQL/SharePoint/MSMQ/WCF/SAP/3rd party Adapters, Logic Apps, Service Bus, BRE and BAM.
- Experience in Analysis, Design, Development and Testing of web applications using ASP.Net, C#, VB.Net, ADO.Net, LINQ, SQL Server, Oracle, Crystal Reports, JavaScript, AJAX etc.
- Proficient in gathering requirements, creating Business and Functional Requirements Documents, Use Case diagrams. Prepared Documentation for projects including System Requirements, Functional Specifications, Change Management, Test Cases and User Guide etc.
- Team player with strong analytical, problem solving and interpersonal skills.
TECHNICAL SKILLS
.NET Technologies: C#.NET, WCF, VB.NET, ASP.NET, ADO.NET
Middleware: BizTalk Server 2006/2009/2010/2013 R2/2016, Azure Logic Apps, Service Bus, Web Services, WCF, REST, ESB Toolkit, SSIS
Web Technologies: HTML, XML/SOAP, XPATH, XSLT, CSS, PHP, ASP, Servlets, JSP, JavaScript, VB Script, AJAX
Languages: C, C++, C#, VB 6.0, SQL, T-SQL, PL/SQL, Java
Databases: MS SQL Server 2017/2014/2008 , Oracle, MySQL, MS Access
Development Tools: Visual Studio.NET 2015/2013/2012/2010/2008 , Eclipse
Web Servers: Internet Information Server IIS 5.0/6.0/7.0, Apache Tomcat
Reporting Tools: Crystal Reports, SQL Server Reporting Services
Source Control: Team Foundation Server, Visual Source Safe, CVS
Other Tools: Dynamics CRM, JIRA, ServiceNow, SharePoint, BizTalk Health Monitor, BizTalk360, MS Visio, Dev Express, Telerik, Dreamweaver, Flash
PROFESSIONAL EXPERIENCE
Confidential - Charlotte, North Carolina
BizTalk Consultant
Responsibilities:
- Worked as a Lead Architect and was responsible for Design and Implementation of BizTalk 2016 Group on Azure Infrastructure as a Service (IaaS) with Always-On High-Availability SQL Server Group.
- Key member of the technology team to develop systems strategy for application and process integration between county departments and vendors.
- Evaluated products and technologies for use in development process, recommended and implemented use of BizTalk Server 2016 on Azure IaaS.
- Create and establish architectural plans for application, develop new strategies, liaison with other departments in the county to resolve issues.
- Developed BizTalk maps to transform data from external format to schemas required for internal applications and vice-versa.
- Used custom pipelines for de-batching of envelopes and processing individual messages, performing lookups, modifying namespaces and renaming files.
- Created Orchestrations to execute complex workflows by applying various orchestration design patterns.
- Used BRE Composer for defining Business Rules and called them from Orchestrations to determine the validity of the message source, lookups and routing etc.
- Integrated vendor REST APIs with in-house applications using BizTalk to help support various department workflows.
- Worked with out-of-the-box BizTalk adapters including FILE, SFTP, SQL, WCF-Custom, WCF-BasicHttp, WCF-WebHttp, MSMQ, MQSC adapters.
- Used Azure Service Bus to send/receive messages using asynchronous operations between applications and services.
- Designed and developed applications using BizTalk and Service Bus to integrate in-house applications with Dynamics 365.
- Worked with SQL server databases and created stored procedures that were needed for BizTalk interfaces.
- Refactored and migrated legacy BizTalk applications and other integration applications over to BizTalk 2016.
- Performed functional, system and technical design reviews, as well as code reviews.
- Supported SIT and UAT phases of Quality Assurance efforts, additionally served as member of Production Support Team.
- Used BizTalk Heath Monitor, to monitor and gather information about BizTalk group, detect any issues, identify any potential problems in advance.
Environment: BizTalk Server 2016, Azure, C#.NET, SQL Server 2017, Logic Apps, Service Bus, WCF, REST, XML, XPath, XSLT, JSON, SSIS, Dynamics 365(CRM), Visual Studio 2015, Team Foundation Server.
Confidential - Los Angeles, California
BizTalk Consultant
Responsibilities:
- Designed and developed multiple Supply Chain transactions using BizTalk as a middle-tier between PT's Warehouse Management Systems (WMS) and partner's EDI.
- Have good understanding of EDI solution architecture and comfortable working with various EDI schemas, mapping EDI to canonicals and vice-versa, EDI pipelines, EDI batching, Party and Business Profile configuration.
- Developed BizTalk interfaces for processing EDI X12 transactions which include 832, 850, 940, 856, 943, 944, 846, 753, and 754.
- Transformed inbound ItemMaster(832), PurchaseOrder(850), SalesOrder(940), Receipt(943), and InboundASN(856) transactions from ANSCII X 12 format to the canonicals and loaded them to the WMS tables.
- Created EDI outbound messages for ShipmentASN(856), ReceiptAck(944), InventoryInquiry(846) from the WMS upload tables.
- Experience in developing document schemas, flat-file and envelope schemas, and various methods of schema re-use.
- Developed canonical schemas which were used as standardized data models for different applications in the organization.
- Developed BizTalk maps to transform data from external format (XML/EDI/Flat-file) to canonical schemas and vice-versa.
- Experience in using various mapping functoids, scripting functoid, custom functoid development and writing custom XSLT.
- Created custom pipeline components for property promotion, performing look-ups, validating messages, replacing identifiers, message enrichment, large message processing, adding/modifying namespaces, renaming files etc.
- Configured Party and Business Profiles for my organization to receive EDI messages from trading partners and return a 997 acknowledgment message. Also configured parties and business profiles for trading partners to send outbound EDI.
- Created Orchestrations to execute complex workflows applying various orchestration design patterns.
- Worked with out-of-the-box BizTalk adapters including FILE, SFTP, SQL, SAP, WCF-Custom, WCF-BasicHttp, WCF-NetTcp, WCF-WebHttp.
- Made RESTful API calls using BizTalk to receive JSON messages for client’s Product, Variant and Order entities. Created JSON messages to post the Shipment information for the processed orders.
- Worked with SQL server databases and created stored procedures that were needed for BizTalk interfaces.
- Maintained and actively supported production systems and assisted in resolving production issues.
Environment: BizTalk Server 2013 R2, Visual Studio 2013, C#.NET, WCF, REST, SQL Server 2014, EDI, XML, XPath, XSLT, JSON, SSIS, BizTalk Health Monitor, Team Foundation Server.
Confidential - Irvine, California
BizTalk Developer
Responsibilities:
- Analysis, design and development of Fulfillment hub applications and integrating core processes with Order hub and Warehouse management systems which also involved migration of certain legacy processes.
- Developed canonical schemas which were used as standardized data models for different applications in the organization.
- Developed BizTalk maps to transform data from external format to canonical schemas and vice-versa.
- Used various advanced functoids, scripting functoid and custom XPath/XSLT to perform complex XML Transformations.
- Used custom pipelines for de-batching of envelopes and processing individual messages, performing lookups, editing namespaces, and renaming files.
- Created Orchestrations to execute complex workflows applying various orchestration design patterns.
- Used BRE Composer for defining Business Rules and called them from Orchestrations and WCF services to determine the validity of the message source, lookups and routing etc.
- Created WCF Services to call Order hub APIs to post updates to orders and consumed them from various Fulfillment hub applications.
- Worked with out-of-the-box BizTalk adapters including FILE, SFTP, SQL, SAP, WCF-Custom, WCF-BasicHttp, WCF-NetTcp, WCF-WebHttp.
- Created BizTalk interfaces to consume vendor’s REST API end points using WCF-WebHttp adapters, to GET orders received in JSON format. Created JSON messages from WMS processed data to POST fulfillments.
- Responsible for installing and configuring the BizTalk SAP adapter. Also responsible for architecture and development of BizTalk solution to receive SAP IDOCS and mapped to canonical format.
- Used BizTalk Maps and custom XSLT to process different SAP IDOCs for Item, SalesOrder, Receipt, ReceiptAck and ShipConfirmation.
- Designed and built several custom pipeline components for assigning file header properties and for handling IDOC namespace actions in send ports.
- Designed and Developed SQL scripts to create Events and Notices Database and created stored procedures to insert/update/delete the records, developed stored procedures to query different tables used by the Biztalk interfaces. These stored procedures are used by different applications throughout the Fulfillment Hub and Order Hub.
- Created and maintained SQL Server Integration Services (SSIS) packages for Back Order Notices and other daily batch processes.
- Maintained and actively supported production systems and assisted in resolving production issues.
- Helped set up definitions and process for test phases including product test, integration test, system test and User Acceptance Test (UAT).
Environment: BizTalk Server 2013 R2, .NET Framework 4.5, C#.NET, ASP.NET, WCF, REST, LINQ to SQL, SQL Server 2014, SSIS, XML, XPath, XSLT, SSRS, Visual Studio 2013, BizTalk Health Monitor, BTDF, Bamboo, Team Foundation Server.