Sql Server Project
Resume:
Ankitkumar Barot
(Ankit.D.Barot @gmail.com)
Professional Summary
1. 11 years of IT experience that includes BizTalk Server 2013/2010/2009/2006/2004, HIPAA /EDI, XML, ASP.Net, C #.Net, VB.Net.
2. Extensive experience as a developer in Microsoft BizTalk Server 2013/2010/2009/2006/2004.
3. In-depth knowledge of Microsoft's .NET Framework, Visual Studio IDE, using VB.Net and C#.Net.
4. Experience with HIPAA/EDI solutions using BizTalk Server 2013/2010/ 2009/2006/2004.
5. Proficiency in Architecture, Administration, Development, Testing and Deployment of BizTalk solutions.
6. Strong understanding of BizTalk architecture, core components, pub/sub architecture, and content based-routing.
7. Proficient in MS SQL Server, XML, XSLT, Visual Studio, C# .NET language.
8. Strong knowledge in developing collaborative software projects using Team Foundation Server.
9. Extensive experience in using databases like SQL Server 2008/2005/2000 and writing Stored Procedures, Triggers, Joins.
10. Experience includes BRE/HAT in the BizTalk Server environment along with ESB and BAM.
11. Experience includes implementing many adapters like WCF, MSMQ, SQL, FTP, WSS.
12. Excellent communication (written and oral) and interpersonal skills.
13. BizTalk Consultant with hands on experience in the core areas like EDI/ XML, Highly skilled in Inbound & Outbound Interfaces, BizTalk / EDI Configuration, BizTalk Data Mapping using ANSI ASC X12, HIPAA Standards.
14. Experienced in Integration Patterns like Convoys, Aggregator and Splitter.
15. Experienced in developing Custom Pipelines and deploying Schemas, Orchestrations and Maps for BizTalk BizTalk 2013/2010/2009/2006/2004.
16. Experience in different business industries like Insurance and Financial.
17. Experience with .Net Technologies like C#.Net, VB.Net, ASP.Net, Visual Studio 2013/2012/2010/2008/2005/2003 along with client side scripting - Java script.
18. Highly motivated and always eager to learn new technologies with fast adaptability to new platforms and environments
Technical skills
Integration Technology
BizTalk Server 2013/2010/2009/2006/2004
BizTalk Tools
BRE, HAT, BizTalk Terminator, MessageBox Viewer, Deployment
Framework for BizTalk (BTDF), ESB, BAM
BizTalk Adapters
WCF, FILE, FTP, HTTP, SQL, MQ Series, SMTP, WSS, HIPAA
Accelerator
EDI Transactions
270, 271, 834, 835, 837, 997, 999, 277CA
Database
SQL Server 2012/2008/2005, MS Access 2000
Development Tools
Visual Studio 2012/2010/2008/2005, ASP.Net, Web Services, ASP, HTML, XML, Java Script, VB Script, WCF
Development Frameworks
DotNet 2.0, DotNet 3.0, DotNet 4.0, DotNet 4.5
Programming Languages
C#.Net, VB.Net, Visual Basic 6.0, JavaScript, XML (XPATH,
XSLT, XSD)
Environment
System Integrations, Client-Server Technologies
Source control tools
Team Foundation Server (TFS), Visual Source Safe (VSS)
Other tools
EDI NotePad, CC.Net, BizUnit, NUnit, NUnitASP, AJAX, XSLT,
Visio
Custom developed Tools
EDI Generator, EDI Record Remover, WCF Endpoints -
Processing, Business Rules - Vocabularies/Policies Deletion,
BizTalk Party Management, BizTalk Map context accessor
Domains
Health Care, Financial, Banking, Insurance
Certifications
Ø Microsoft Application Developer (MCAD)
Ø Microsoft Certified Solution Developer in .Net (MCSD)
Ø Microsoft Technology Specialist (MCTS)
Ø 070-487 Developing Windows Azure and Web Services
Ø 070-583 PRO: Designing and Developing Windows Azure Applications
Ø 070-595 TS: Developing Business Process and Integration Solutions by Using Microsoft BizTalk Server 2010
Ø 070-542 TS: Microsoft Office SharePoint Server 2007 - Application Development
Ø 070-235 TS: Developing Business Process and Integration Solutions using Microsoft® BizTalk® Server 2006
Professional Projects Summary
Client name: Emblem Health Location: New York, NY
Project name: Extended 837 Duration: Feb 2015 to Till Date
Description: This project is an extension of existing claims process.
Responsibilities:
Analyzed business requirements, Design of data flow and architecure of BizTalk solution(s).
Designed XML schemas, designed orchestrations including Debatching and Correlation logic, designed/developed complex maps for vendor integration.
Developed Complex Orchestrations for processing.
Performance testing and optimization for large files processing.
Implemented business rule policies using BRE.
Developing MSI packages for deploying into QA/PROD environment.
Involved in Deployment and Troubleshooting issues in the application.
Environment:
BizTalk Server 2013, Visual Studio 2012, C#.Net, SQL Server 2012, TFS
Client name: Emblem Health Location: New York, NY
Project name: Optimization - Real-time 270/271 Duration: Jan 2015 to Till Date
Description: This project is an optimization of existing 270/271 transactions.
Responsibilities:
Analyzed existing Real-time BizTalk solutions.
Designed and developed optimization for various BizTalk components like Map, Orchestration. Pipeline.
Performance testing and optimization for large files processing.
Developing MSI packages for deploying into QA/PROD environment.
Involved in Deployment and Troubleshooting issues in the application.
Environment:
BizTalk Server 2013, Visual Studio 2012, C#.Net, SQL Server 2012, TFS
Client name: Emblem Health Location: New York, NY
Project name: MED REC Duration: Dec 2014 to Till Date
Description: This project is an implementation of Auto-adjudication of Medicaid Reclamations claims from HMS vendors.
Responsibilities:
Analyzed business requirements, Design of data flow and architecure of BizTalk solution(s).
Designed ESB Itineraries for validation on incoming claims.
Designed XML schemas, orchestrations, designed/developed complex maps.
Developed Complex Orchestrations for processing.
Performance testing and optimization for large files processing.
Implemented business rule policies using BRE.
BAM Logging and Monitoring.
Developing MSI packages for deploying into QA/PROD environment.
Involved in Deployment and Troubleshooting issues in the application.
Environment:
BizTalk Server 2009, Visual Studio 2008, C#.Net, SQL Server 2008, TFS, ESB 2.0, BAM
Client name: Emblem Health Location: New York, NY
Project name: EDI Gateway Duration: Dec 2014 to Till Date
Description: This project is based on the foundation of custom framework built on top of BizTalk. It servers as Gateway for all EDI transactions with all vendors for both incoming and outgoing EDIs.
Responsibilities:
Analyzed business requirements, Design of data flow and architecure of BizTalk solution(s).
Customized ESB Portal.
Designed ESB Itineraries for validation on incoming claims.
Designed XML schemas, orchestrations, designed/developed complex maps.
Developed Complex Orchestrations for processing.
Performance testing and optimization for large files processing.
Implemented business rule policies using BRE.
BAM Logging and Monitoring.
Developing MSI packages for deploying into QA/PROD environment.
Involved in Deployment and Troubleshooting issues in the application.
Environment:
BizTalk Server 2009, Visual Studio 2008, C#.Net, SQL Server 2008, TFS, ESB 2.0, BAM
Client name: Selective Insurance Location: Branchville, NJ
Project name: BCAS Duration: July 2013 to Nov 2014
Description: The Best In CLAS project (CLAS Refresh) is a rewrite of the CLAS application with a focus on a streamlined, intuitive flow through the quoting process to allow the agents and underwriters to arrive at a quotable price more efficiently.
Responsibilities:
Analyzed business requirements, Design of data flow and architecure of BizTalk solution(s).
Designed XML schemas, designed orchestrations including Debatching and Correlation logic, designed/developed complex maps for vendor integration.
Developed Complex Orchestrations for processing.
Performance testing and optimization for large files processing.
Helping offshore development team in developing complex logic.
Implemented business rule policies using BRE.
Developing MSI packages for deploying into QA/PROD environment.
Involved in Deployment and Troubleshooting issues in the application.
Environment:
BizTalk Server 2010, Visual Studio 2010, C#.Net, SQL Server 2008 R2
Client name: Selective Insurance Location: Branchville, NJ
Project name: CAS - Phase I Duration: Jan 2013 to Jun 2013
Description: This application is used by Agents an Employees to Issue quote and convert quotes into policies.
Responsibilities:
Analyzed business requirements, Design of data flow and entire architecure of BizTalk solution(s).
Designed XML schemas, designed orchestrations including Debatching and Correlation logic, designed/developed complex maps for vendor integration.
Developed Complex Orchestrations for processing.
Performance testing and optimization for large files processing.
Helping offshore development team in developing complex logic.
Implemented business rule policies using BRE.
Developing MSI packages for deploying into QA/PROD environment.
Involved in Deployment and Troubleshooting issues in the application.
Environment:
BizTalk Server 2009, Visual Studio 2008, C#.Net, SQL Server 2008
Client name: Assurant Health Location: Milwaukee, WI
Project name: HIPAA 5010 - 834 - Phase II Duration: Jul 2012 to Dec 2012
Description: HIPAA 834 transaction is Member' Eligibility data. The source of the data is Enterprise Data Warehouse which transfers data to BizTalk. Rich set of Business rules are developed to identify Destination of the given member in BizTalk Rule Engine. Based upon Destination, data is converted into HIPAA 834 5010 EDI format considering vendor specific requirements. The solution is flexiable to generate data for new vendor by just adding Business rules in BizTalk. Based upon data, BizTalk also connects and retrieves data from DB2.
Responsibilities:
Analyzed business requirements, Design of data flow and entire architecure of BizTalk solution(s).
Designed XML schemas, designed orchestrations including Debatching and Correlation logic, designed/developed complex maps for vendor integration.
Developed connection to DB2 from BizTalk for data lookup.
Developed Complex Orchestrations for processing.
Performance testing and optimization for large files processing.
Helping offshore development team in developing complex logic.
Implemented business rule policies using BRE.
Developing MSI packages for deploying into QA/PROD environment.
Involved in Deployment and Troubleshooting issues in the application.
Environment:
BizTalk Server 2009, Visual Studio 2008, C#.Net, DB2
Client name: Assurant Health Location: Milwaukee, WI
Project name: eDelivery - EOB Duration: Jan 2012 to Jun 2012
Description: The solution is an extention to existing BizTalk solution for setting Member' eDelivery preference and sending out email alerts when EOB (Explanation Of Benefits) statements are avaiable for member to view online. For Audit and Balance control purpose, designed process in BizTalk to track data flow.
Responsibilities:
Understanding business requirements, Written technical design documents for BizTalk 2009 interfaces.
Developed BizTalk Orchestrations based on internal and Business Partner specifications.
Enhacing existing processes in BizTalk.
Used out of box adapters like WCF, SQLServer.
Designed BizTalk process for Audit and Balance control requirements.
Worked extensively with SQL Adapter to interact with SQL server.
Environment:
BizTalk Server 2009, Visual Studio 2008, C#.Net, SQL Server, ESB 2.0
Client name: Assurant Health Location: Milwaukee, WI
Project name: GMS - xPression - SBC Duration: May 2011 to Dec 2011
Description: As part of the solution, BizTalk functions as intergration between 2 different systems. GMS is an Admin system wherein Member' documents related data is maintained which needs to be printed as PDF by another system called xPression. From GMS, BizTalk receives data in multiple flat files during night batch processing. BizTalk disassembles all documents based upon their type and also maintains log during processing tracking how many documents were received from GMS and how many of those sent to xPression and in which output file.
Responsibilities:
Design BizTalk solution based upon Analysis of requirements.
Converting requirements into technical design documents.
Used Flat-file schema on inbound.
Used Flat File disassembler and assembler components to convert Flat-file to xml and vice versa.
Designed BizTalk process for balancing requirements.
Performance testing and optimization for large files processing.
Developing MSI packages for deploying in to QA and Production environment.
Involved in Deployment and Troubleshooting issues in the application.
Environment:
BizTalk Server 2009, Visual Studio 2008, C#.Net, SQL Server 2008
Client name: Assurant Health Location: Milwaukee, WI
Project name: 835 Outbound to JPMC Duration: Jan 2011 to Apr 2011
Description: It is an enhancement to existing solution wherein specific error handing has to be done while sending 835 Outbound to JP morgan.
Responsibilities:
Understand existing BizTalk solution.
Develop BizTalk artifacts like Pipeline components, custom Pipelines.
Developing MSI packages for deploying in to QA and Production environment.
Involved in Deployment and Troubleshooting issues in the application.
Environment:
BizTalk Server 2009, Visual Studio 2008, SQL Server 2008
Client name: Assurant Health Location: Milwaukee, WI
Project name: HIPAA 5010 - 834 - Phase I Duration: Aug 2010 to Dec 2010
Description: Using BizTalk Server 2009, as part of this project, there is integration setup between EDW and various trading partners. At end of the process, BizTalk solution(s) generates HIPAA 834 EDI(s) to be sent out to trading partners.
Responsibilities:
Develop BizTalk artifacts like Schemas, Maps, Pipeline components and Orchestrations.
Developing MSI packages for deploying in to QA and Production environment.
Involved in Deployment and Troubleshooting issues in the application.
Environment:
BizTalk Server 2009, Visual Studio 2008, SQL Server 2008
Client name: Assurant Health Location: Milwaukee, WI
Project name: Siebel - MQ Router Duration: Apr 2010 to Jul 2010
Description: This solution was developed to alleviate the dependency that Siebel had on MQ Series runtime (installed on Siebel server) which incurred extra licensing cost. This solution polls the messages from MQ Series and posts it to Siebel via HTTPS POST.
Responsibilities:
Coordinate with Siebel team to understand existing interface and functionality.
Development of BizTalk artifacts.
Testing connectivity with Siebel from BizTalk.
Developing MSI packages for deploying in to QA and Production environment.
Coordinating/Supporting with testing team during stabilization phase.
Involved in Deployment and Troubleshooting issues in the application.
Environment:
BizTalk Server 2009, MQ Series, Visual Studio 2008
Client name: Assurant Health Location: Milwaukee, WI
Project name: Eligibility - Core Routing Engine Duration: Dec 2009 to Mar 2010
Description: The eligibility interface is used to transfer product or benefit enrollment information to partners or internal systems. The intent of this interface is to meet the need for communicating the initial enrollment and subsequent maintenance of individuals who are enrolled in insurance products to these partners or systems.
Responsibilities:
Development of BizTalk schemas, map, pipelines and orchestration.
Developing coding conventions and standards to enhance source code management and
Increase software maintainability.
Used TFS as source code control repository.
Used BRE for validating custom rules.
Developing MSI packages for deploying in to QA and Production environment.
Coordinating/Supporting with testing team during stabilization phase.
Involved in Deployment and Troubleshooting issues in the application.
Environment:
BizTalk Server 2009, Visual Studio 2008, SQL Server 2008
Client name: Barclays Location: London, UK
Project name: Barclays - Skycard Duration: Nov 2008 to Nov 2009
Description: The Skycard product has processes which are setup for integration between various system using BizTalk 2006.
Responsibilities:
Development of BizTalk schemas, map, pipelines, pipeline components and orchestration.
Used BRE for validating custom rules.
Developing MSI packages for deploying in to QA and Production environment.
Coordinating/Supporting with testing team during stabilization phase.
Involved in Deployment and Troubleshooting issues in the application.
Environment:
BizTalk Server 2006, Visual Studio 2005
Client name: ECC Location: Pune, India
Project name: ECC Duration: Jan 2008 to Oct 2008
Description: The client has Customer repository to maintaine. Based upon events, sending out notifications to attendees is part of the functionality in this system.
Responsibilities:
Development of BizTalk schemas, maps, pipelines and orchestrations.
Used VSS as source code control repository.
Used BRE for validating custom rules.
Developing MSI packages for deploying in to QA and Production environment.
Coordinating/Supporting with testing team during stabilization phase.
Involved in Deployment and Troubleshooting issues in the application.
Environment:
BizTalk Server 2006, Visual Studio 2005
Client name: Banco Popular Location: Pune, India
Project name: CLPA - Metavante Duration: Nov 2005 to Dec 2007
Description: The client has Customer Loan Pipeline application which is extentively used to track customer information along with his/her Loan details. BizTalk was introduced as a integration system between different interfaces to facilate communication between extrenal systems and CLPA web application.
Responsibilities:
Development of BizTalk schemas, maps, pipelines and orchestrations.
Used VSS as source code control repository.
Used BRE for validating custom rules.
Developing MSI packages for deploying in to QA and Production environment.
Coordinating/Supporting with testing team during stabilization phase.
Involved in Deployment and Troubleshooting issues in the application.
Environment:
BizTalk Server 2006, Visual Studio 2005
Education
M.Sc. in Computer Applications and IT
Trainings and Seminars
Attended training on HIAPP/EDI, HIPAA 5010 with BizTalk Server 2009 in Chicago, USA by the external vendor.
Attended corporate training on BizTalk Server 2006.
Attended Microsoft Seminar on Visual Studio 2005 and SQL Server 2005.
Contact this candidate