We provide IT Staff Augmentation Services!

Sr. Biztalk/ssis Admin/consultant Resume

0/5 (Submit Your Rating)

SUMMARY

  • Over 13 years of IT experience as Web, Client, Server and Integration Application Developer in Internet, Intranet, Client/Server, N - tier technologies and ERP (SAP, Oracle, DB2) and Worked with Financial, Manufacturing, Retail, Public Sector and Healthcare domain Projects.
  • More than 13 years’ experience working with various Microsoft products right from ASP, VB to ASP.NET, C#, MS SQL Server 2000/2003/2005/2008 R2/2012
  • Over 10 years of experience with Development and Administration with various versions of BizTalk 2004/2006/2006 R 2/2009/2010/2013 (Orchestrations, Pipelines, Ports, Rules Engine, Schemas, Maps, BAM), C#, ASP.NET, Web Services, .NET Framework, ADO.NET, VB.NET, mySAP, Oracle Adapter, COVAST Accelerator, Rosetta net 3.0/3.3, EDIFACT, HIPAA 2.0/3.0, HL7, MQ Series and IBM MQ Series 5.0/6.1
  • Experienced in Development of Creating ASP.NET Web Forms, Win Forms, User Controls, ASP.NET MVC pages, WCF and XML Web Services.
  • Experience in Custom Pipeline Components development & familiar in using Adapters (SOAP, FILE, SQL, FTP, MySap, SMTP and EDI) With BizTalk 2004/2006/2009/2010.
  • Expertise in EAI Tools such as SAP XI, developing Software Landscape Development, Integration Repository, Integration Directory and Runtime Work Bench.
  • Experience using ESB, BRE Rule Engines such as Microsoft BizTalk Server Business Rule Engine & Business Rule Composer.
  • Hands on experience in the EDI/ XML, experienced in Inbound & Outbound Interfaces, BizTalk / EDI Configuration, BizTalk Data Mapping using ANSI ASC X12, HIPAA Standards and HL7 Standards
  • Working knowledge of R Scripting.

TECHNICAL SKILLS

Web Servers: IIS (6.0/5.0/4.0), Windows Share Point 2003

BizTalk Adapters: File, SFTP, FTPS, WCF SQL, WCF-SAP, WCF-Oracle, SQL, SOAP, MSMQ, SMTP, MySAP, IBM MQ adapter, HIPAA, RFID, WSE 2.0/3.0

Tracking Tool: BAM, BAS, HAT, ESB Portal

Data Formats: SOAP, ANSI ASC X12, AS2, EDIFACT, XML, IDOC, FLATFILE, WSE 2.0, COVAST EDI, RFC, BAPI

SAP: ALE, SAP.NET Connectors(2.0/1.0), IDOC, RFC, BAPI

Web Technologies: ASP, HTML4.0, DHTML, VB.NET, ASP.NET, COM, COM+ XML2.0, XSL, XSLT, CSS, VBScript, JavaScript, JSP, EJB, ADO.NET, SOAP

GUI: VisualStudio.NET 2003/2005/2008/2010/2012 , Itinerary Designer, VisualBasic6.0/5.0/4.0, Visual Interdev 6.5/6.0, Toad, SQL Management Studio

Databases: Oracle (10g/9i/8i/8/7.2), SQL Server 2012/2008R, MS Access 7.0/97, DB2 AS400.

Integration Tools: BizTalk 2013/2010/2009/2006 R2/2006/2004, ESB 2.2/2.1 (Itineraries, Portal) BizTalk Server Administration, SAP.Net Connector, SAP XI 3.0

Environment: Win Win 2012/2008/2003/2000/98/95/3. x, Windows NT 4.0,VMWare, Virtual PC 2004/2007 and Virtual Server 2005

Programming: C#, ASP.NET, ASP.NET MVC5.0, VB.NET, ABAP, VBScript, Java Script, Core Java, J2EE Web Services, C, C++, ADO.NET, Reporting Services 2008/2000

Tools: Visual SourceSafe, Visio 2003/2007, SFTP, Enterprise Library 1.1/2.0, BizUnit, SharePoint Server 2010, Team Foundation Server

EDI: X12, AS2, HIPPA, HL7, ROSETTANET 3.0/3.3/3.5

EDI Transactions: 270, 271, 276, 277, 834, 835, 837, 850, 855, 864, 997, 999, 5010, Orders01, Orders04, Invoice01.

Queues: MSMQ, IBM MQ, Oracle MQ

PROFESSIONAL EXPERIENCE

Confidential

Sr. BizTalk/SSIS admin/Consultant

Responsibilities:

  • Involved in communication with Business Analysts and helped Senior Integration Architect in the preparation of Functional Specification and Requirement specification documents.
  • Installed and configured BizTalk and ESB portal in the Sandbox, Dev, Test and Production Environment.
  • Involved in Designing the BizTalk solution for various verticals within Manufacturing Operation Management
  • Involved in stake holder communication and ensured risks are identified and communicated to stakeholders
  • Installed and configured BizTalk and ESB Portal in the Sandbox and Development Environments.
  • Designed and developed ESB itineraries for TMAC(Terminal Management and Account System), IPCS (Integrated Process Control System) and SIPS interfaces
  • Integration of BSD (SAP ECC) with OPD (Operation Dashboard), LIMS (Laboratory Information management Systems), STS (Sample Transport System), IP21 Historian, OPC (OLEDB for process Control), PCOM (Packaging Center Operations Management), PED (Portable Electronic Device) and QOM (Quality Operations Management)
  • Designed Reusable components for Tracking (generic component which can be used independent to the project) and ESB Exception Tracking (Generic exception framework for publishing to ESB portal where it can be resubmitted)
  • Designed and developed WCF services and exposed BizTalk as WCF services
  • Upgraded BizTalk 2010 Solution to BizTalk 2013 solutions.
  • Archived Messages into Azure using Azure Service Bus
  • Loading data from various sources like OLEDB, flat files to Meridium APM Server, HWS (Hazardous Waste System) and ECEMS(Environmental Data Management System) applications Using SSIS
  • Created SSIS package to load data from Large Flat File to Large Flat File and Flat File to SQL Server 2005 using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, Slowly Changing Dimension
  • Monitored Teams performance and helped them by mentoring and helping them to understand the components and helped them in resolution of their issues and handled communication with onsite.
  • Worked on complex interfaces to interact BizTalk with OREM SAP PI Services
  • Worked on Change requests for OPD Dashboard (ASP.NET MVC and WCF application) and supported in the production environment
  • Supported Meridium, Websites and BizTalk applications in the production environment.
  • Created oracle/SQL scripts to createnew tables, views, Procedures, Functions, queriesfor new enhancement in the application using TOAD & SQL Development Studio.

Environment: BizTalk Server 2010/2013,TFS, Meridium APO, ESB Toolkit2.1, Itinerary Designer, SAP PI, BizUnit, SAP Web service, Azure Service Bus, Oracle, Oracle Advanced Queue, Adapter pack2.0, ESB2.1, ASP.NET MVC5.0, ASP.NET, C#,.Net Framework 3.0/3.5, WCF, ADO.NET, JavaScript, XML, XSLT, XML Web Services, SQL Server 2008R2, Windows 2003 Server, OPC .

Confidential

Sr. BizTalk admin/Developer

Responsibilities:

  • Supported the mission critical Payments application and ensured smooth processing and no escalations
  • Involved in communication of Voyager major upgrade (SAP core banking) and worked closely with project team to identify and possible resolution of the risks associated with the upgrade
  • Designed, developed, tested and deployed the BizTalk Change Requests to production environment.
  • Worked on Various Improvements to Faster Payments and Bulk load Application
  • Automated Manual keying of failed payments for Faster Payments and later enhanced to Bulk Load application
  • Involved in designing the Schemas, Orchestrations, writing custom Pipelines and designing the orchestration flows for Complex business process and used native BizTalk adapters
  • Involved in the installation of BizTalk Management Pack for SCOM 2007R2. Configured Alerts for BizTalk management Pack in SCOM 2007R2.
  • Worked on Automation of various reports which provide the snapshot of the application and sent to all the stakeholders everyday
  • Setup Business Activity Monitoring (BAM) for end to end logging
  • Extensively worked on automation of various activities and automated 70% of tasks and reporting activities
  • Worked with Business Analysts to gather requirement for enhancements.
  • Designed and developed Dashboard functionality using Excel services by enabling/activating appropriate features and establishing data connections to SQL Server.

Environment: BizTalk Server 2010, SCOM 2007R2, SAP Core banking, BAM, Adapter pack2.0, ASP.NET, C#,.Net Framework 3.0/3.5, WCF, ADO.NET, JavaScript, XML, XSLT, XML Web Services, SQL Server 2008R2, Windows 2003 Server.

Confidential

Sr. BizTalk/SSIS admin/Lead

Responsibilities:

  • Performed installation and configuration of AD (Active Directory) with various BizTalk, clustered SQL Servers, BizTalk Groups, and Users and configured MOM Server.
  • Developed EDI Schemas and Maps for 270, 271 (Health Care Eligibility/Benefit Inquiry and response) and 276, 277 (Health Care Claim Status Request/Response), 834, 835 Enrolment Eligibility & Claim payment transactions.
  • Developed Canonical Hl7 Schemas, Maps, Custom XSLT, Custom pipelines, Business Activity Monitoring.
  • Involved in the installation of BizTalk Management Pack for SCOM 2007R2. Configured Alerts for BizTalk management Pack in SCOM 2007R2.
  • Created Custom Monitor and Alert in SCOM 2007R2 for BizTalk and SQL Services.
  • Configured BizTalk to process HL7 ORU messages and sends an ACK for acknowledgement. It is part of the Enterprise Service Hub (ESB) with various interfaces including web services using SFTP.
  • Designed Orchestration Process to sequence transactions and process transactions into Oracle database using WCF based Oracle adapter
  • Implemented the system for processing medical claim documents received in a variety of formats, which in turn will be converted to XML.
  • Worked on solving, troubleshooting and documenting the issues in the Production environment
  • Design and develop.NET components and systems, including web services and user interfaces

Environment: BizTalk Server 2009, Adapter pack2.0, ASP.NET, C#, Ajax toolkit2.0, Host Adapter, SFTP, HL7, HIPPA, .Net Framework 3.0/3.5, WCF, WSS3.0, ADO.NET, JavaScript, XML, XSLT, SCOM 2007R2, XML Web Services, SQL Server 2008R2, Windows 2003 Server. WCF Adapter for SQL, WCF Adapter for Oracle.

Confidential

BizTalk Lead

Responsibilities:

  • Installed and configured BizTalk and ESB portal in the Dev, Test and Production Environment.
  • Created Functional Specification and Technical Specification for the TFS work Items.
  • Designed Schemas, Orchestrations, writing custom Pipelines and exception Handling.
  • Performed installation and configuration of AD (Active Directory) with various BizTalk users and groups, clustered SQL Servers
  • Worked with exception handling to ensure all the errors were handled properly.
  • Worked with custom XSLT for mapping input schema to the exact target request Schema
  • Worked with various adapters (File, WCF, SharePoint, SMTP, MS Dynamics CRM, MSMQ) and EDI & AS2 Accelerators to receive and process message
  • Performed Tracking the messages and debugging Orchestration using HAT tool and BizTalk admin console.
  • Worked with orchestration which integrates with Exact target web service
  • Involved in tracking various stages as well as tracking validation errors using eTrack application (BAM API)
  • Worked with octopus (deployment tool) to automate BizTalk and database build and deployment
  • Supported BizTalk Application 24X7.

Environment: BizTalk Server 2010, MS Dynamics AIX 2009, EDIFACT, AS2 ACORD RLC, AMS and DRI, Adapter pack2.0, ESB2.1, ASP.NET, C#,.Net Framework 3.0/3.5, WCF, EDI, AS2, EDIFACT, Team foundation Server, ADO.NET, JavaScript, XML, XSLT, XML Web Services, SQL Server 2008, Windows 2003 Server, MS Dynamics CRM.

Confidential, AZ

BizTalk Admin/Integration Consultant

Responsibilities:

  • Worked with Electronic laboratory based reporting for unsolicited observation messages that comes from various labs around Arizona and involved in designing the Schemas, Orchestrations, writing custom Pipelines and designing the orchestration flows for various business process.
  • Worked with various adapters (File, WCF, SharePoint, SMTP, pop3, WCF for oracle and WCF for SQL) to receive and process message.
  • Use WCF adapter for SQL to poll data specific to H1N1 and STD from SQL Server 2007 located in HS domain and map it to Oracle database using WCF Lob adapter for Oracle located in HSP domain.
  • Created Schemas and Maps for 834 Enrollment Process, Inbound 837 for storing the Inbound EDI into the database using SQL Adapter, and Outbound and Inbound maps for the 835 Health Care Claim Payment/Advice, Maps for Inbound 835 Claim Payment/Advice for storing the Inbound EDI into Database using SQL Adapter
  • Developed the connectivity and delivery of the messages, the positive Ack / Negative Ack back to the sender party.
  • Worked on customizing receive pipeline in include filtering based on Lo inc codes present in the database and also modified various subfields to allow the Microsoft parser to parse the HL7 file.
  • Involved in mapping HIPPA 835, 837 files to Oracle Database in HSP Domain by using ftp adapter to receive various HIPPA files and mapped to the database using custom XSLT mapping
  • Involved in the configuration of MOM 2005 with BizTalk 2009 and configuring application specific errors with MOM to send e-mail alert notifications.
  • Receiving Hl7 messages using WCF adapter, SharePoint adapter, File adapter and pop3 adapter and used SQL adapter to store into SQL server.

Environment: BizTalk Server 2009, HL7 accelerator, Adapter pack2.0, SharePoint adapter, ASP.NET, C#, Ajax toolkit2.0, Host Adapter, SFTP, HL7, HIPPA, .Net Framework 3.0/3.5, WCF, WSS3.0, MOSS2007, ADO.NET, JavaScript, XML, XSLT, XML Web Services, SQL Server 2008, Windows 2003 Server. WCF Adapter for SQL, WCF Adapter for Oracle.

Confidential, WA

Sr. .Net/Biztalk Consultant

Responsibilities:

  • Designed, Developed E-Trip application and deployed existing solution into multi server environment with high availability, fault tolerant systems and clustered SQL Server environment
  • Implemented MOM 2005 with BizTalk 2006 R2 and configuring application specific errors with MOM to send e-mail alert notifications.
  • Performed installation and configuration of AD (Active Directory) with various BizTalk users and groups, clustered SQL Servers
  • Extensively worked on integrating with various agencies like DOP (Department of Patrol), DOL (Department of Licensee), DSHS(Department of Health Service) and AOP
  • Involved in developing PCH and CACH application using ASP.NET, C#, HTML, CSS, Ajax.
  • Involved in complex orchestration design for business processing and retry Patterns.
  • Extensively worked with custom XSLT mapping to map the required input to the desired output XLS file.
  • Worked with WCF, soap, SMTP, http, DB2 and Oracle adapter to communicate with state agencies.
  • Performed installation and configuration of WSE3.0 and SSL for the applications in the dev environment and performed upgrading to WCF.
  • Involved in deployment of PCH and CACH application and E-Trip Application.
  • Involved in integrating with J2ee Web services, XML Web services, WSE and J2EE Web services (Axis 2.0)
  • Involved in migration of old QA servers to new QA servers and old Prod Servers to new Prod Servers
  • Performed MSI packages and deployment into Test, Staging and Production Environments

Environment: ASP.NET, C#, WCF, WF, LINQ, BizTalk Server 2006R2, Oracle Adapter, Host Adapter, Ajax, .Net Framework 2.0/3.0, Team foundation Server, WCF, WF, WSS3.0, MOSS2007, Oracle 11i, HIPPA, ADO.NET, JavaScript, Visual Source Safe, XML, XSLT, XML Web Services, J2EE Web Services, Tomcat, SQL Server 2005, Net weaver 2004s, Windows 2003 Server.

Confidential

Sr. .Net/Biztalk Consultant

Responsibilities:

  • Involved in multi-server installation and configuration of BizTalk 04/06. Development, Production and UAT servers environment
  • Actively involved in BizTalk Administration in Host management (Host and Host Instance), Adapters configuration, Ports (Send and Receive), HAT, TPE, Custom Pipelines and custom functoids.
  • Involved in configuring SQL Adapter in sending messages to SQL Server from BizTalk Server.
  • Involved in designing of schemas for Parts Ordering Request, Response and Acknowledgement schemas
  • Responsible for developing the screens for various modules using HTML, JavaScript, ASP.NET, VB.NET, C#, LINQ, XML, WCF.
  • Exposed Orchestration as web service and communicating with SAP using SOAP adapter Developed Custom Pipeline components for the schema generated by DB2 adapters.
  • Worked with Rules Engine, Custom Pipeline and custom XSLT mapping to map the required input to the desired output
  • Involved in solving and documenting the issues in the Production environment

Environment: BizTalk Server 2006R2, C#, VB.NET, ADO.NET, Rosettanet, Silverlight, JavaScript, MOSS2007, SSRS, SSIS, WSS3.0, ASP.NET, XML, XSLT, Web Services, BizUnit, SQL Server 2005, DB2 AS400, Windows 2003 Server.

Confidential, WA

Sr .Net/ BizTalk Consultant

Responsibilities:

  • Involved in requirement gathering and documenting IARD( Interface Architecture Requirement Design) and BRD (Business Requirement Design)
  • Worked with various Endpoint systems such as SAP, CLX (Mainframe system), DMS (DMZ system), LMS
  • Created and implemented Business rules using rule engine composer and extensively worked with vocabularies and expressions.
  • Extensively worked with Schemas, orchestration, Maps, BRE and HAT
  • Designed and developed Endpoint Manager Solution which solely responsible for exception management and retry mechanisms.
  • Involved in Developing and debugging of ABAP Remote Functional modules (RFC) to enable them to integrate with BizTalk.
  • Worked on designing and development of Enterprise Library 2.0 for exception management and Logging.
  • Involved in complex orchestration design for business processing and retry Patterns.

Environment: BizTalk Server 2006, C#, VB.NET, ADO.NET, Silverlight, Enterprise Library2.0, SMS, ABAP, JavaScript, ASP.NET, WCF, WF, Ajax, Visual Source Safe, XML, XSLT, Web Services, ROSETTANET, BizUnit, SQL Server 2005, SAP ECC 6.0, IDOC, SAP PI7.0, IBM Db2, Windows 2003 Server.

Confidential

Sr .Net/ Integration Developer

Responsibilities:

  • Involved in installation and configuration of AD (Active Directory) with various BizTalk, clustered SQL Servers, BizTalk Groups, and Users
  • Involved in installation and configuration of BizTalk 06. Building Prod, UAT and Development servers environment
  • Worked with MySAP Transmitter which sends IDocs, BAPIs, and RFCs to the appropriate SAP system.
  • Worked with MySAP Receiver which acts as a listener, waiting for IDocs, BAPIs, and RFCs to be sent by SAP
  • Extensively worked on BAM (Business Activity Monitoring), custom Functoids, Custom pipelines and complex Mapping.
  • Developed Vocabularies and polices for business rules using Business Rule Composer Tool
  • Involved partially in upgrading from BizTalk 2004 to BizTalk 2006
  • Integrated BizTalk with SAP XI3.0 and ABAP Web services

Environment: BizTalk Server 2006, C#, VB.NET, ADO.NET, JavaScript, ABAP, SAP XI3.0, BAM, ASP.NET, Visual Source Safe, XML, XSL, Web Services, SQL Server 2005, SAP ECC5.0, IDOC, ALE, SQL Loader, T-SQL, Windows 2003 Server, Reporting Services 2005

Confidential

.Net Developer

Responsibilities:

  • Responsible for developing the screens for various modules using HTML,JavaScript, ASP.NET, C#, VB.NET, ADO.NET, XML, Web Services
  • Worked on migrating ASP solution to ASP.Net Solution
  • Production support.

Environment: C#, VB.NET, ADO.NET, classic ASP, Classic VB, JavaScript, COM+, ASP.NET, Web Services, JavaScript, HTML, SQL Server2000, VisualStudio.NET, HTML, Microsoft Visio, Windows NT/2000, Visual SourceSafe6.0, Crystal Reports XI

We'd love your feedback!