Biztalk Developer Resume
Irvine, CaliforniA
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 more than 9 years of experience in all phases of software development life cycle from requirements gathering till deployment and production support using Microsoft technology stack.
- Experience in Design, Development, Configuration and Maintenance of Scalable EAI/EDI Solutions using BizTalk Server 2009/2010/2013 R2 in Mid - to-Large size organizations.
- Built asynchronous messaging systems and effectively applied various Enterprise Integration patterns using BizTalk Orchestrations, Pipelines, Mappings, SQL/SharePoint/MSMQ/WCF/SAP/3rd party Adapters, ESB toolkit, BRE, BAM.
- Extensive experience in designing and developing scalable solutions for complex problems using Microsoft technology stack including .NET Framework, BizTalk Server, SQL Server and SSIS.
- 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, developing Business and Functional Requirement Documents (BRD and FRD), Created Use Case diagrams, Class diagrams, State Transition Diagrams and Activity Diagrams using UML methodology in MS Visio.
- Prepared Documentation for the Projects including System Requirements, Functional Specifications, Change Management, Test Cases, Issue Management, and User Guide etc.
- Team player with strong analytical, problem solving and interpersonal skills.
TECHNICAL SKILLS:
.NET Technologies & Languages: C#.NET, WCF, VB.NET, ASP.NET, ADO.NET
Middleware: COM, DCOM, Web Services, MSMQ, WCF, REST, BizTalk Server 2006/ 2009/2010/2013 /2013R2, ESB Toolkit, SSIS
Web Technologies: HTML, DHTML, XHTML, 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 2014/2008/2005 , Oracle, MySQL, MS Access
Development Tools: Visual Studio.NET 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 Code Control: Team Foundation Server, Visual Source Safe, CVS
Other Tools: BizTalk360, Dev Express, Telerik, JIRA, ServiceNow, Sharepoint, Rational Rose, MS Visio, MS FrontPage, MS Office, Dreamweaver, Flash, Fireworks
EXPERIENCE:
Confidential, Irvine, California
BizTalk Developer
Responsibilities:
- Involved in analysis, design and development of the Integration modules in Fulfillment Hub Core Application Migration.
- Co-ordinate efforts of various design teams in bringing together new feature from conceptualization to deployment by managing roadmap, scheduling efforts and meeting milestones.
- Gather requirements from business owners, perform system analysis & create business and functional requirement documents /user stories in Rally for the Change Request/Enhancements.
- Contribute in defining timelines and project plans; monitored estimates, feasibility, effort, time and compatibility.
- Created BizTalk Orchestrations for executing Business processes, Configured send/receive pipelines and created Custom Pipelines.
- Used Custom pipelines in de-batching of envelopes and processing individual messages, performing lookups, and renaming files.
- Used BizTalk Rule Engine Composer for defining Business Rules and Used Business rules in Orchestration to determine the validity of the message source, lookups and routing.
- Developed canonical Schemas which were used as a standardized data models for the business documents in the organization.
- Developed BizTalk maps to transform data from external format to canonical schemas and canonical schemas to formats required by various applications.
- Used Scripting Functoids and Xpath/XSLT templates to perform complex XML Transformations.
- Lead design and development efforts for Fulfillment hub application integrating core processes with Order hub and Warehouse management systems which involved automation of certain legacy processes and creation of proprietary flat files.
- Created WCF Services to call Order hub APIs to post updates to orders and consumed them from various Fulfillment hub applications.
- Worked on out of the box BizTalk adapters including FILE, SFTP, WCF-Custom, WCF-BasicHttp, WCF-NetTcp, WCF-WebHttp.
- Designed and Developed SQL scripts to create the COEvents 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.
- Worked with SQL server 2014 databases and created stored procedures that were needed for BizTalk interfaces and SSIS packages.
- Created and maintained SQL Server Integration Services (SSIS) packages for Back Order Notices and other daily batch processes.
- Created and maintained various reports for Business using SQL Server Reporting Services (SSRS).
- Maintained and actively supported production systems and assisted in resolving production related issues.
- Involved in developing use cases, user manuals, flow charts and design documents using UML.
- Created test cases for components and identified the test data needed to execute the test cases.
- Set up definitions and process for test phases including product test, integration test, system test and User Acceptance Test (UAT).
- Worked with the Product Vendors on enhancements and bug fixes to the products used in the enterprise.
- Used Agile Software Development methodology to enable efficient and effective software development.
Environment: BizTalk Server 2013 R2, SSIS, .NET Framework 4.5, C#.NET, ASP.NET, WCF, REST, LINQ to SQL, SQL Server 2014, XML, Xpath, XSLT, SSRS, Visual Studio 2013, BTDF, Bamboo, Team Foundation Server.
Confidential, Denver, Colorado.
BizTalk Developer
Responsibilities:
- Involved in design, development, testing and deployment of various Integration modules.
- Maintained comprehensive responsibility for business process improvement, developing opportunities for enhancement across existing processes and implementing innovative best practices.
- Analyzed BizTalk 2009 processes and various other legacy processes and migrated them to BizTalk 2013 and SQL server integration services.
- Designed and developed Dynamic Routing Orchestration for handling incoming files from vendors/clients, processed those messages based on the business rules.
- Implemented failed message routing for the above application using an orchestration that routes the message to a location on the fileshare, creates help desk tickets and notifies certain groups based on the type of error.
- Designed and built several custom pipeline components for assigning file header properties, performing loan number lookups, assembling, disassembling messages, and moving large messages.
- Used BizTalk Rule Engine Composer for defining Business Rules and Used Business rules in Orchestration to determine the validity of the message source, lookups and routing.
- Created, tested and deployed policies and vocabularies needed for Business rules.
- Responsible for architecting and building a solution which allowed for vendor data feeds to be received from SFTP and mapped to flat file format by BizTalk to be sent through MSMQ adapter to loan workout system.
- Lead design and development efforts for MERs link application integrating core processes with MERs (Mortgage Electronic Registration system) which involved automation of certain legacy processes and creation of proprietary flat files to send owner occupancy details, transfer of rights, loan deactivation etc.
- Used orchestrations, pipelines, mapping to handle the business flow for processing these files and applied transformations to convert the files to proprietary flat files needed by MERs.
- Processed acknowledgement files from MERs systems and implemented error handling which created a help desk ticket.
- Created and used C# helper classes that were used by Orchestrations, maps and business rules.
- Used SFTP adapters, Orchestration, Mapping to develop a process to read an Outlook inbox for BPO (Broker Price Option) files that come as an email and gather the BPO results, perform lookups, process the results, upload the attachment to image repository and call APIs.
- Worked on integration between SharePoint and BizTalk where SharePoint lists had to be updated with the results from a business process.
- Worked with SQL server 2008 databases and created stored procedures that were needed for BizTalk interfaces and SSIS packages.
- Created SSIS packages for Human Resources Extract that SLS gets from PeopleSoft to load the data into database so that people in IT get access to certain applications on DEV/STG environments.
- Created Use case Models using Rational Rose to indicate Actors and Use cases in various Business Processes.
- Set up definitions and process for test phases including product test, integration test, system test and User Acceptance Test (UAT).
- Worked as scrum master and held daily stand-ups in agile team.
Environment: BizTalk Server 2013, SSIS, .NET Framework 4.5, C#.NET, ASP.NET, WCF, Web API, LINQ to SQL, SQL Server 2008 R2, XML, Xpath, XSLT, Visual Studio 2012, BTDF, Team Foundation Server, MS Access.
Confidential, Austin, Texas
Software Engineer
Responsibilities:
- Involved in analysis, design and development of the Integration modules in Claims System Migration Project.
- Responsible for installation, configuration, troubleshooting, support and administration of BizTalk 2010 Server Group.
- Gather requirements from business owners, perform system analysis & create business and functional requirement documents /user stories for the Change Request/Enhancements.
- Designed and Developed interfaces for HIPAA 5010 EDI Transactions 837I/P/D, 834, 270/271, 276/277, 999 using BizTalk 2009/2010, .NET, SQL Server.
- Created schemas, maps, orchestrations and business rules for processing HIPAA transactions 837 for claims and 999 Ack.
- Used Scripting Functoids and Xpath/XSLT templates to perform complex XML Transformations.
- Developed the business logic for doing the lookup in the 27x Member Eligibility Service (270) and Claim Status Service (276) for identifying the member in the transaction based on FirstCare Rules.
- Developed .net dlls for the 835 BizTalk Interface to convert the SSN/Internal id on the remit to an External Id, also to convert internal provider id to NPI on the remit and lookup the trading partner id for inserting it into the EDI header.
- Created BizTalk Orchestrations for executing Business processes, Configured send/receive pipelines and created Custom Pipelines.
- Used Custom pipelines in de-batching of envelopes and processing individual messages, performing lookups, and renaming files.
- Used BizTalk Rule Engine Composer for defining Business Rules and Used Business rules in Orchestration.
- Created activities, views, deployed the views, and performed tracing using Business Activity Monitoring (BAM).
- Designed and Developed SQL scripts to create the Claim Counts Database and created stored procedures to insert the counts, developed stored procedures to query different tables used by the EDI Eco System. These stored procedures are used by different applications throughout the EDI system.
- Involved in developing user test cases, user manuals, flow charts and design documents using UML.
- Used Agile Software Development methodology to enable efficient and effective software development.
- Created test cases for components and identified the test data needed to execute the test cases.
- Involved in development of new portals for Providers, Groups, Agents and Members which are built to support our new core system.
- Developed ASPX web pages for Application using ASP.NET, C#.NET, XML, XSL/XSLT, HTML and JavaScript.
- Worked on Dev Express RAD Controls including Grid Views, validation and other data presentation controls to display data in a customized format in the ASP.NET web pages.
- Used LINQ to SQL and C# 4.0 for Data Access and exposed business logic using WCF Services.
- Created database tables, Stored Procedures, Views, functions and SQL agent jobs on SQL Server 2005.
- Developed Prior Authorization Web Service solution.
- Developed WCF Provider Enrollment Service using BizTalk 2009 and WCF Adapter.
- Used BizTalk Rule Engine Composer for defining Business Rules used during Open Enrollment of groups.
- Developed canonical Schemas for mapping both claim system's data into a common database for Recovery and Other Insurance Tools.
- Maintained and actively supported production systems and assisted in resolving production related issues.
- Modified and Maintained report generation using SQL Server Reporting Services (SSRS) and MS Access.
- Maintained and supported legacy applications working on VBScript, MS Access.
- Used Visual Studio Team Foundation Server for Source Control.
- Followed agile development methodology with 2 week iterations (sprints).
Environment: BizTalk Server 2010, .NET Framework 4.0, C#.NET, ASP.NET, WCF, BRE, LINQ to SQL, EDI, HIPAA, VB.NET, Microsoft Enterprise Library, MS SQL Server 2005, XML, Xpath, XSLT, Team Foundation Server, BizTalk360, 3rd party n-software adapters, BTDF, SSIS, SSRS, MS Access.
Confidential, Alabama
Programmer Analyst
Responsibilities:
- Developed and implemented the core application using ASP.Net, VB.Net which involved interaction with Database for retrieving and binding the data on the web form.
- Involved in system design, generating and developing schemas, mapping and deploying applications.
- Designed and developed orchestrations for business process with exception handling.
- Designed & Derived Flat File Schemas for trading partner communication.
- Developed and configured custom send/receive pipelines.
- Designed and developed policies using Business rules engine.
- Monitored all the business activities using the Business Activity Monitoring (BAM) while working on production support.
- Used Microsoft Business Rule Composer for designing rules within the policies.
- Deployed orchestrations as Web Services and WCF Services.
- Implemented ESB solutions for dynamic messaging using ESB Toolkit 2.0.
- Created and deployed itinerary services, on-ramp and off-ramps for ESB.
- Used ESB pipelines that came with ESB toolkit including Itinerary Receive, Itinerary Select Receive, and Itinerary Send pipelines.
- Configured ESB pipeline components including Itinerary Selector, Itinerary Cache, and Dispatcher component.
- Used ESB exception management framework for capturing, extracting, normalizing and reporting ESB exceptions.
- Created a Batch Parser tool that is used for Server Maintenance using Win-Forms and C#.NET.
- Developed and implemented the core application using ASP.Net, VB.Net which involved interaction with Database for retrieving and binding the data on the web form.
- Created Stored Procedures, Functions, Triggers and Cursors using T-SQL.
- Used Data Grids, Grid Views and other data presentation controls to display data in a customized format in the ASP.NET web pages.
- Created and Consumed Web Services that were used to expose the functionality of the Data objects.
- Worked on Classic ASP in maintaining one of the legacy applications.
- Created reports using SQL server reporting services (SSRS).
Environment: .NET Framework 3.5, BizTalk Server 2009, ESB Toolkit 2.0, C#.NET, VB.NET, ASP.NET, WCF, HL7, ADO.NET, Win-Forms, Classic ASP, JavaScript, AJAX, MS SQL Server 2005,SSRS, BizUnit, Visual Source Safe.
Confidential
Associate Developer
Responsibilities:
- Developed n-tier application using ASP.NET Web Forms for server process and user interface and using C#.NET classes.
- Developed the web application with custom controls, user controls, master page, and content pages for consistent GUI.
- Developed Data Access layer using ADO.NET and C#.NET.
- Created stored procedures and triggers in the Store Front database.
- Created Web Services that enable other third party web sites.
- Developed a Windows application using Win forms to support the application. And also to perform some administrative functions on the application.
- Used ASP.NET Server controls and Validation controls.
- Created and deployed Web Services in Application for accessing the database.
- Generated reports using Crystal Reports.
Environment: .Net Framework 2.0/3.5, ASP.NET, C#, ADO.NET, Web Services, XML, AJAX, CSS, HTML, SQL Server 2000,Visual Studio 2005, Visual Source Safe.