We provide IT Staff Augmentation Services!

Senior Biztalk & Sql Developer Resume

New York City, NY

SUMMARY

  • Expertise in enterprise application integration (EAI) and B2B integration with heterogeneous systems using BizTalk server and Testing
  • Having a hands on experience with BizTalk server 2016/2013R 2/2013/2010/2009 .
  • Experience in Microsoft SQL Server 2005/2008R2/2010/2012 database design, Tables, Stored Procedures, User Defined Function
  • Worked with BizTalk adapters like WCF - SQL, WCF Custom, WCF-Web http, Schedule, File, SQL, HTTP, SOAP, MQSC, and MSMQ.
  • Hands on experience in consuming web services and WCF Services and configuring WCF-SQL adapter.
  • Good experience in HTML, XML, XPath, XQuery, XSD, XSL, XSLT, AJAX 2.0.
  • Experience in writing complex SQL queries and optimizing the queries in SQL Server 2008 R2.
  • Experience in Inbound & outbound Interfaces using BizTalk artifacts such as Schemas, Pipelines, Mapping, orchestrations, BRE for flat files, databases, XML, EDI.
  • Experience in configuring of BizTalk Server adapters that ships with BizTalk like Oracle, SQL, SOAP, POP3, HTTP, WCF LOB Adapters.
  • Experience in technologies like BAM, BRE.
  • Hands on experience on BizTalk 2009/2006R2 cluster with HIPPA-EDI (ANSI-X12), EDI and knowledge in HIPPA 4010 and 5010-ICD 10 standards
  • Experience in configuring HIPPA/EDI adapter for BizTalk HIPPA 5010 standard.
  • Good experience on HIPAAEDITransactions (277CA, 271, 272, 834, 835, 999) and implementation of different projects and solutions in a health care setting using HIPAA-EDI.
  • Expertise in publishing and consuming WCF Services and SOAP inBizTalkand .Net
  • Have experience with VB.NET, C#, Web Services, IIS, XML, XSD, and MS SQL Server
  • Real time exposure of creating Map, orchestration, custom pipeline component development
  • BizTalk Server Application debugging
  • Excellent Communication skills and ability to work in a team environment
  • Self-starter and ability to adapt and learn new things quickly.
  • Good Interpersonal skills, a good team player, highly committed, result oriented, hard working with a quest and zeal to learn new technologies and undertake challenging opportunities.
  • XML Schema: Designed and Defined the structure of an XML instance message for trading partners based on the Functional Specification Document
  • Flat file schema. Created the structure of a class of instance messages that use a flat file format, either delimited or positional or some combination thereof.
  • Envelope schema. Created an envelope schema to define the structure of XML envelopes, which are used to wrap one or more XML business documents into a single XML instance message and de-batched the files using XPath
  • Property schema: Created Property Schema in order to get specific values from deep within an instance message to the message context, so that BTS artifacts can access and make use of it
  • Canonical Schema: Hands on experience of creating Canonical schema for internal purpose (EAI) and for decouple the BizTalk flow control mapping from any other system's schemas. It helps to keep consistency across solutions and integrations and offer the opportunity for reuse.
  • Extensive mapping using BizTalk Mapper to transform incoming XML/Flat file to subsequent small individual XML file using several logical and Advance functoids.
  • Used Database functiods in order to extract Customer ID
  • Used Advance functoids like Iteration, Looping and Record Count in order to check the number of transactions in one envelope schema
  • Extensively used Inline XSLT and Inline C# in scripting and Looping functoids for nested segments as well as other Advance and Logical functoids for more complex mappings
  • Compiled XSLC Transform - for performance.

TECHNICAL SKILLS

EAI and B2B Integration Tools: BizTalk Server 2016/2013R 2/2013/2010/2009

Programming Languages: C#, VB.Net, C++, Java, SQL

Databases: MS SQL Server 2012/2008R2/2008/2005

Web Technologies: ASP.NET, JavaScript, VB Script, WSS, and CSS

Tools: Visual Studio 2013/2012/2010/2008/2005

Protocols: HTTP, FTP, SMTP, SOAP, POP3 and TCP/IP

EDI/HIPAA Transactions: 270, 271, 834, 835, and 997

Data Formats: EDI, ANSI ASC X12, HIPPA, Flat File, XML, XSD, XSLT, CSV

BizTalk Tools: HAT, BAM, BRE, TPE, ESB

BizTalk Adapters: HTTP, FILE, SOAP, SQL, WCF, FTP, SMTP, POP3, EDI, MQSeries, MQSC, WSS, SAP, Swift Accelerator 2.0/2.3, HIPAA EDI Accelerator 3.3/3.0

PROFESSIONAL EXPERIENCE

Confidential, New York City, NY

Senior BizTalk & SQL Developer

Responsibilities:

  • Worked on Agile development methodology and responsible for the scrum deliverables for 3 weeks release cycle.
  • Involved in gathering User Stories, Analysis, Design, Development, Deployment and Testing stages of the Enrollment & Billing project.
  • DesignedEDIsolution to processEDI834 enrollment transactions.
  • Implemented Schemas, Pipeline components, Maps, Orchestrations and .net Components.
  • Created canonical schemas in order to convert the EDI 834 files into Flat File to load the data into downstream applications.
  • Utilized .NET helper classes in the orchestrations to perform the business process in efficient manner.
  • Created Trading partner agreements and configured Parties in the Admin Console in order to on board various EDI 834 transactions for various Line of Businesses.
  • Implemented Batching, De-batching, and Singleton and Throttling design patterns.
  • Created custom pipeline components for batching, de-batching and validating the inbound 834 files.
  • Created various tables and stored procedures in order to insert/update the member details, transaction details and the batch details to the table.
  • Extensively used XSLTs for more complex mappings.
  • Exposed orchestrations as web service in order to fetch the details about the member history from the core systems and process the enrollment transactions accordingly.
  • Configured the SFTP ports using adapters in order to receive/send the 834 files from/to the New York State of Health.
  • Efficiently utilized ESB management console to fix the fault messages.
  • Worked on enhancements of dashboard applications built on .NET with BizTalk database in the backend.
  • Worked closely with business and finance team on financial reporting and reconciliation analysis for different LOBs and report the premium impact to business and contributed to business by working on payment and recovery activities and created reconciliation reports from BizTalk databases in order to verify the premium impacts.
  • Worked with third party vendors and finance team and developed customized reports from BizTalk tables like Effectuations report, Outbound report, Terms report, Data extraction report etc on different Line of Business like Essential Plan, Qualified Health Plan, Child Health Plan and Medicaid and coordinate with third party vendors to analyze and understand how many members are enrolled, effectuated and outbound is sent for the effectuated members.
  • Created complex Queries using SQL Server Management Studio to fetch data from different BizTalk tables using various types of joins, database links and formatted the results into Excel.
  • Created SQL jobs to run the SSIS packages in order to generate the outbound file.
  • Provided post deployment support during releases and validated the results and shared across the business.
  • Troubleshoot production issues for the production tickets and helped to resolve the issues at the earliest and given quick turnaround.
  • Worked on support and maintenance during off-hours and provided emergency-fix for critical issues.
  • Involved on admin related activities for processing inbound and outbound files.
  • Performing data management projects and fulfilling ad-hocrequests from business and finance by utilizing data management software like Excel.
  • Taken additional responsibilities and worked as BizTalk Admin for 3 months as backfill for colleague.
  • During this time, worked on server monitoring, production server maintenance, file transfers to state and provided 24/7 on call support.
  • Activities included, processing inbound and outbound files on production region.
  • Running daily Effectuation files for assigning benefit packages for members enrolled.
  • Restarting instances whenever processing issue happened and monitored SQL resources.
  • Provided admin support for 7 different projects running on the production server including enrollment, payments, billings and claims.

Confidential, Maumee, OH

Senior BizTalk Developer

Responsibilities:

  • Participated in all phases of analysis, design and implementation of Ford’s Global program IN BizTalk Server application.
  • Worked on Scrum method of agile development.
  • Part of team in Development of Common Application Framework (CAF) framework to handle the incoming data.
  • Extensive mapping using BizTalk Mapper to transform incoming XML/Flat file to subsequent small individual XML file using several logical and Advance functoids.
  • Design and Develop Canceled Sales process to prevent Sales Surveys from being send to customer in cases where it is known that the sales has been cancelled. Merge/update/Insert store procedure
  • Documented Data Mapping used for input in development of data extraction components and stored procedures.
  • Design and Developed custom pipeline component in C# to clean bad data receipts from database tables for Report generation
  • Identified source application and Modeled Data extraction Components, and route messages to and from SQL Server used with WCF SQL Adapter
  • Filtered bad data from legacy systems using T-SQL procedures.
  • Designed and Developed Response Generator Orchestration to generate reports based on the system types. And automate entire report generation process using dynamic maps, dynamic ports and dynamic output file name change.
  • UsedESBException management framework to communicateBizTalkerrors and routing failures.
  • Implemented Exception handling with Alerts in the Orchestrations and Custom .Net Libraries using ESBTool Kit 2.2 Exception Handling Management Portal.
  • Extensively used Inline XSLT and Inline C# in scripting and Looping functoids for nested segments as well as other Advance and Logical functoids for more complex mappings
  • Deployed BizTalk Application in Staging and Production Environment.
  • Managed the Testing phase, coordinating with external users, Tracking changes and completion before deadlines.
  • Documented my entire work to facilitate the knowledge transfer process to the clients.
  • Coordinated all project related communications for the team with the project manager
  • Involved in planning oftimely deliverables - scheduling tasks and working in a mode that the project timelines are met.

Confidential

BizTalk Developer

Responsibilities:

  • Developed automated B2B applications sending receiving EDI files, which are converted to XML and imported in SQL Server via stored procedures using SQLBizTalkAdapter.
  • Implemented SAP, SQL, File, FTP (Guaranteed Delivery), SMTP and SOAP adapters.
  • Experience with building service-oriented applications using WCF.
  • DevelopedBizTalkorchestrations for processing EDI files 846 (Inventory Inquiry Advice), 850 (Purchase Order), 860 (Purchase Order Change Request), 869 (Order Status Inquiry).
  • Used Scripting Functoids to write complex logic.
  • Developed Transformations usingBizTalkMapper to map flat file Schemas and XML schemas.
  • Used the XML disassembler and assembler at receive port and send ports.
  • Created custom pipeline components for Encryption and Decryption usingBizTalk2010.
  • Created Stored Procedures to retrieve data from Databases.
  • Developed policies for various systems based on messaging rules and business rules using BRE.
  • Tracked Business process in BAM by creating Milestones and configured Tracking Profile Editor.
  • Deployed BizTalk projects on Test and Production servers.

Confidential

BizTalk Developer

Responsibilities:

  • Worked on Agile development methodology.
  • Actively participated in Scrum meetings updating the Daily execution status to the clients.
  • Have taken the Ownership of various scrums and delivered the deliverables on time with 100% Quality.
  • Responsible for developing BizTalk application to transfer files from client system to in-house downstream systems.
  • Created various physical Send Ports and Receive Ports-Locations.
  • Worked on Content Based Routing and created dynamic Send Ports in the Orchestrations for ease of routing based on data content.
  • Extensively Used Microsoft SQL Server 2008 to create tables, views, stored procedures.
  • Generated schemas for Flat Files and created for xml files for the various interfaces.
  • Good experience on consuming Web Services and WCF services.
  • Created custom pipeline components in order to transfer larger size files.
  • Created Reports and Documents using complex stored procedures and complex queries from the SQL database.
  • Good experience on Exception Handling.
  • Deployed applications to Staging and production.
  • Good knowledge on documentation of processes and procedures.
  • Tracking and sending Daily/Weekly status reports on task completion and defect fixes.

Hire Now