SUMMARY

• Having 7+ years of IT experience in development of Windows and Web based Software applications using Microsoft Technologies.
• Having 7+Years Of experience on Microsoft BizTalk Server 2006R2/2009/2010/2013/2016.
• Having 6+Years of experience in implementing EDI based solutions.
• Having 5+ Years of experience in create DTS and DTSX packages in SSIS
• Having 5+ Years of experience in SSRS,SSAS
• Experience in store procedure.
• Experience in SAP interfacing technologies
• Expertise in implementing ESB Tool kit.
• Experience with Deploying a SSIS, BizTalk and .Net application.
• Working experience on source controls like TFS, VSS and Clear Case.
• Extensively worked on PL/SQL Procedures, Functions, and Triggers in SQL Server.
• Extensive experience in the areas of Service - oriented architecture (SOA), Patterns, Iterative design methodologies. Highly skilled in Logical Analysis and Quality Assurance.
• Expertise includes Installation, Configuration and Customization of BizTalk Server 2016/2013/2010/2006 R2/2006, .Net Framework, Microsoft SQL Server 2008/2012 in the Windows Environment. Upgraded BizTalk Servers from 2013 to 2016
• Experience in the core areas like EDI/ XML and BizTalk / EDI Configuration, ESB Toolkit, WCF, WCF-SQL, BizTalk Data Mapping using SAP.Net Connectors, HTTP Adaptor, IDocs, ALE, COVAST Accelerator 2006, ANSI X12, Rosetta net 3.0/3.3, EDIFACT, HIPAA 2.0/3.0 and almost of the available BizTalk adaptors.
• Excellent Knowledge in Software Development Life Cycle models
• Experienced implementing interfaces
• with SOA concepts
• Experienced in data archival strategy
• Experienced in Integrating IBM mainframe system to Windows Networks
• Experience in implementing Entity Framework.
• Expertise in publishing and consuming WCF Services and SOAP in BizTalk and .Net
• Hands on experience in Visio diagraming for designing functional and Technical flows
• Expertise in implementing BPM Solutions using Metastorm
• Expertise in implementing financial reconciliation using IntelliMatch

TECHNICAL SKILLS

EDI: 837 P/I/D, X298,X299,X300 (Post Adjudication Claims), 835,834, 850,810,855,856,277CA and 999, 270/271,HL7

Web Servers: IIS (7.5/7.0,6.0/5.0),Apache,Glassfish

BizTalk Adapters: File, FTP, SQL, SOAP, MSMQ, SMTP, Web sphere MQ adapter, WSE 3.0, WCF, Microsoft Dynamics AX 4.0 and LOB Adapter pack.

Data Formats: EDI, XML, Flat File,Acord and Rosetta Net

Accelerators: Edi, Acord and RosettaNet

Web Technologies: HTML4.0, ASP.NET, SharePoint, COM,XML, XSL, XSLT, CSS, VBScript, JavaScript, JQuery, ADO.NET, SOAP

GUI: VisualStudio.NET 2008/2010 and Share point

Databases: SQL Server 2008, My SQL, Oracle.

Integration Tools: BizTalk 2009/2010/2013, ESB Tool kit 2.0/2.1 and SSIS

BPM Tools: Metastom 9.1/9.2, Oracle SOA and IntelliMatch

Environment: Windows server 2008, Virtual PC 2007 and Virtual Server 2005

Programming: C#, ASP.NET, VB.NET, VB Script, JQuery, ADO.NET and SQL

Tools: Visual SourceSafe, Visio 2010, SFTP,BizUnit, SharePoint Services 2007, WSE 3.0,BRE(Business Roles Engine),TFS 2010,BizUnit,MS Build and Clear Case

PROFESSIONAL EXPERIENCE

Confidential

Consultant (BizTalk,EDI )

Responsibilities

• Analyze requirement from existing application
• Design new solution using ESB Toolkit and SOA principles
• Preparing Technical Requirement document with new approach
• Prepare mapping specification between CRM(Microsoft Dynamics),SCM(SAP, PeopleSoft and S4Hana) and EDI 850,810,855&856
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Design and Develop Inbound and Outbound workflows for receiving files from various sources depends on Business Units(FTP,HTTP,WCF-SAP, Dynamics AX 4.0 etc) and send it to destination system(FTP,SFTP, WCF etc) after applying business logic in ESB Toolkit, Business Rule Engine, Orchestrations and Pipeline Components
• Made complex Store procedures and functions
• Writing complex mapping in Inline XSLT,XSLT template and External XSLT
• Create BAM activity and associated API methods to insert Order Level information and reconcile with EDI BAM Activity
• Trading partner setup for the EDI parties and establish end system connectivity for all the end points hosted on end client systems
• Prepare BTDF and automate deployment using TFS deplorer
• Fix defects raised during SIT,UAT and Prod environments

Environment Languages/DatabaseBizTalk Server 2013, EDI 850/810/855/856,ESB Toolkit, BAM API, Entity framework, SQL Server 2008/2010,Microsoft Dynamics AX 4.0 adapter and SSIS

Confidential

PositionDeveloper

Responsibilities

• Collecting requirements from the Business users.
• Estimate effort involved in developing and testing the application
• Preparing Technical Requirement document.
• Create EDI mapping specification document between EDI 837 I/P/D, 835 & 834 and COBOL, Mainframes & Oracle Schema
• Involved in performance tuning of SQL queries and Stored Procedures.
• Create SSIS packages to Load Member and Provider details into Oracle tables from Flat File Generated by Mainframe and Cobol Generated
• Prepared Sub reports, Nested Reports, Drill through Reports & Graphs reports using SSRS
• Developing Inbound and Outbound Maps between EDI 837 P/I/D,835,834 and COBOL Schemas and Oracle DB for Coordinate of Benefit fields
• Writing complex mapping in Inline XSLT, XSLT template and External XSLT
• Update BAM API to update COB fields in existing BAM
• Create and Modify existing SharePoint forms and business logic to show the documents related to new clearing houses and related to this change
• Create ESB Itinerary and Business Rules for COB Fields
• Create 277CA rejection report for COB Elements
• Trading partner setup for the EDI parties
• Fix defects raised during SIT,UAT and Prod environments
• Application deployment

Environment,: Operating System Windows Server 2008 Languages/DatabaseBizTalk Server 2009, EDI 837 I/P/D, EDI 835, 834,ESB Toolkit, BAM API, Oracle SOA, Entity framework, Microsoft Office SharePoint Server(MOSS), SQL Server 2008/2010 and SSIS

Confidential

PositionDeveloper

Responsibilities

• Collecting requirements from the Business users.
• Estimate effort involved in developing and testing the application
• Create Post Adjudication EDI Schemas (X298,X299,X300 and NCPDP) based on WPC Implementation Guide
• Create EDI mapping specification guides between NCPDP, 837 I/P/D (Customized EDI Schema) and COBOL, Mainframe & Oracle Schema
• Create SSIS packages to load data from the NCPDP file into Fast-track (Oracle) database and Generate Daily claim process details report from Claim Adjudication tables
• Design new BizTalk Interface to process new registered Post adjudication EDI schemas
• Developing Inbound and Outbound Maps between 837(X298(P),X299(I) and X300(D)) and Down Stream system Flat file Schemas
• Create and Modify existing SharePoint forms and business logic to show the documents related to new clearing houses and related to this change
• Create EDI Parties for new Partners
• Writing complex mapping in Inline XSLT,XSLT template and External XSLT
• Fix defects raised during SIT,UAT and Prod environments
• Application deployment

Environment Operating System Windows Server 2008Languages/DatabaseBizTalk Server 2009, EDI 837 I/P/D(Post Adjudication), EDI 835, 834,ESB Toolkit, BAM API, Entity framework, Microsoft Office SharePoint Server(MOSS) QNXT, Oracle SOA, SQL Server 2008/2010 and SSIS

Confidential,

BizTalk EDI Analyst

Responsibilities

• Collecting requirements from the Business users.
• Estimate effort involved in developing and testing the application
• Preparing design document specification for Availity
• Create mapping specification document between 837 I/P, 835 and SQL Schemas
• Design SQL tables to save claim information and available to Dimension(UI)
• Developing WCF services to integrate Availity and LifeSynch
• Developing a logic to get all the claims information from EDI 837 and save to Humana DB using BizTalk mapping
• Creating reports using BAM
• Creating claim images based on the claim information in c#.net
• Construct EDI 999 and submit to Availity
• Construct EDI 835 and send back to Availity based on claim approval
• Process EBR and Ack files from Availity for EDI 835
• Trading partner setup for the EDI parties
• Migrate old SQL DTS packages to DTSX packages
• Create new SSIS packages to run reports on daily basis
• Creating Production support tools for easy monitoring and verify messages flow
• Writing unit test cases.
• Execute unit test cases.
• Fix defects raised during SIT,UAT and Prod environments
• Application deployment

EnvironmentLanguages/DatabaseBizTalk Server 2013, ASP.NET, C#.NET, WCF 4.0, EDI 837 I/P, 835, Entity framework, SQL Server 2008/2010 and SSIS