Sql Server Web Services

PROJECT SUMMARY:

Over * years of IT Industry experience with key areas of focus in Microsoft based Technologies like .Net, BizTalk Server 2006R2/09/10/2013R2, Windows Communication Foundation, Web Services, SOA and ESB in HealthCare, Finance, Insurance, telecommunication and Pharmaceutical domains.

Over7 years of experience in Microsoft BizTalk Server 2006R2/2009/2010/2013R2

Experienced in BizTalk Project Architecture focusing on integration solutions, worked on multiple N-Tier applications.

Experience with Service Oriented Architecture (SOA) using BizTalk Server, SOAP, and WSDL

Used Custom Adapters and out of the box BizTalk Adapters such as SQL, DB2, HTTP, SOAP, WCF, SAP, MQ, WCF-Basic Http, WCF-SQL, Oracle DB adapter, WCF-Custom

Experience specific to BizTalk Artifacts:

Mapping, Orchestrations, Pipelines, BRE,BAM, HL7 Accelerator.

Experience in designing and building Enterprise Service Bus using ESB Toolkit 2.1 and Enterprise Library 5.0, Itinerary On-Ramp and Off-Ramp

Extensive knowledge of mapping EDI Transactions:810, 820, 834, 835,270, 276, 271,277, 278, 997

Experience in Developing Enterprise Application Integration (EAI), B2B applications, EDI applications and different industry data formats including XML, IDOCS and Flat File schema

Developed and implemented web based applications using C#, VB.Net, ASP.Net/ASP3.0, ADO.Net/ADO, COM, JavaScript.

Worked with Microsoft SQL Server 2005/2008/2012 and Microsoft Access databases to retrieve and manage data.

Good expertise in the development of SQL queries, stored procedures, triggers, views and functions.

Working experience with SSIS.

Experience in providing Logging, Error handling by using Event Handler, and Custom Logging.

Incorporated database technologies such as ODBC, SQL Client, My SQL and OLEDB to interface with MS SQL Server for business applications

Created Web Forms, Win Forms, User Controls and Custom controls using Visual C# .Net and VB.

Experience with Health Care B2B solutions development leveraging the MS BizTalk Accelerator for HL7&HIPAA.

Extensive Experience ofHL7 Accelerator and Electronic Data Interchange(EDI).

Experienced in all aspects of Software Development Life-Cycle(SDLC) and QA Life Cycle.

Strong Technical Leadership skills and co-ordination of tasks with the Onsite and Offshore teams.

Strong experience with Client Interactions, Requirement Analysis, Design meetings, Retrospectives.

Demonstration of Software Applications, strong working experience of SCRUM Agile methodologies.

TECHNICAL SKILLS:

EAI Development

:

BizTalk 2006R2/2010/2013R2, EDI Editor, Orchestration & Pipeline Designer, Maps, BRE, BAM, HAT

.NET Technologies

:

.NET 3.5/4.0, ASP.NET, C#. NET, VB.NET, ADO.NET, Web Services, WCF

Languages

:

C, C#, ASP, SQL, T-SQL, PL/SQL, XML, XSL,XSLT

Data Access

:

ADO.NET, ADO, OLE DB, ODBC

Database

:

SQL Server 2008R2,Oracle 9i, MS Access

Client Technologies

:

AJAX, HTML, XHTML, DHTML, SOAP, CSS

Scripting Languages

:

VBScript, JavaScript

Versioning

:

TFS, Microsoft Visual Source Safe, SVN

PROFESSIONAL EXPERTISE:

Client: HP, Newark, DE May 2015- Present

BizTalk Developer

HPE is implementing Medicare and Medicaid administration for state of Delaware. BizTalk is being utilized as the integration platform to communicate with Providers and enabling payments for them. Part of project implementations include HIPAA standards for health care transactions 270/271, 276/277, 278, 834, 835 and 837I/P/D transactions using the BizTalk and SQL database and MQ series.

Installed and configured BizTalk 2013/2013R2 and SQL Server 2012.

Converted837P4010 to 5010 Standards for Claims Processing through Internal Billing System

Developed applications using Schemas, Orchestrations, Pipelines, Ports and custom XSLT Scripting for Claim and Payments handling through EDI transactions 837 and 835

Extensive development experience with HIPAA Transactions 270, 271, 276, 277, 834, 835 and 837 and experience in complex mapping using inbuilt Functoids

Consumed services like WCF and web services to provide handshake between external systems and downstream systems using different types of BizTalk adapters like FTP, MLLP, MSMQ, WCF-SQL, WCF-WSHTTP

Performance and throttling evaluation of BizTalk Live environments using PerfMon, SysMon, Admin Console and BizTalk360,troubleshooting in clustered environment.

Use SQL Adapters and contributed to developing the necessary Stored Procedures.

Used XML Schemas, SQL generated Schemas using Flat Files for Mapping

Solving the Integration problems and fine tuning for high throughput with BizTalk360

Implemented BAM, LOB adapters enhancements to SOA and web services, B2B integration

Provided technical consulting in identifying, implementing and supporting new BizTalk functionality to entire HPE Network and Projects

Developed custom mechanism for one touch Automatic Deployments using BizTalk Deployment Framework

Expertise in managing TFS code merging and Branching, setting up FTP jobs for file transport

Environment: BizTalk 2013/2013R2, Visual Studio 2010/2012, TFS 2010/2013, SQL Server 2008R2/2012, C#.NET, IIS 7.0

Corning, NY Jun’13 – May’15

BizTalk Consultant

Corning Incorporated is the world leader in specialty glass and ceramics. Drawing on more than 150 years of materials science and process engineering knowledge, Corning creates and makes keystone components that enable high-technology systems for consumer electronics, mobile emissions control, telecommunications and life sciences.

Responsibilities:

Involved in Requirements Gathering, preparing Mapping Documents, Data Analysis.

Build Custom Schemas, Maps to insert X12Data into Oracle tables directly using WCF Adapter

Implemented Custom Schemas to Handle Non-Compliant X12 files as well to accommodate client requirement.

Developed BizTalk Applications to integrate PS, SAP and MES Systems.

Developed Synchronous Inbound Interfaces to facilitate the flow of real time transactions between Plant Systems and SAP using Services method.

Developed complex BizTalk Orchestration to accommodate the Retry mechanism for submitting Sales Order to PS.

Developed a common architecture for receiving files from SAP using ESB Itineraries and Rules Engine.

Worked on various transactions Sales Order, Sales Order Acknowledgement, Material Master, Bill of Material, and Production Order.

Using WCF- Oracle Adapter to integrate with Oracle database server. Worked with various adapters like FTP, SQL, HTTP, SOAP, WCF, FILE and SMTP.

Used BizTalk Adapter Pack V2.0 to interact with the Oracle11g Database server.

Developed Enterprise Service Logging Application to Track transactions for .Net Interfaces using BAM API’s.

Developed XSLT for complex logic which was not possible using native BizTalk mapper tool.

Involved in writing Technical Specs, Deployment Checklists for the Applications developed.

Involved in composing reports with the data from Performance Test, Integration Test and User Acceptance Test.

Involved in Pre-cutover and Post-cutover activities for Go-Live from BizTalk perspective.

Involved in arranging KT sessions for the offshore resources from support perspective.

Used WCF-HTTP, WCF-SAP, MSMQ, FILE, SMTP adapters to enable communications for different protocols.

Environment: BizTalk Server 2010, SAP, People Soft, SOAP Web service, LOB Adapters, Oracle DB adapters, BAM, TFS, ESB 2.0, XML, XSLT, SQLXML 3.0, Visual Studio 2012, MS SQL Server 2008, Windows Server 2003/2008, IIS 6.0.

Fidelity Investments, Boston, MA Aug’12 – Jun 13

BizTalk Developer,

Fidelity Investments, is one of the largest mutual fund groups in the world. Fidelity Investments manages a large family of mutual funds, provides fund distribution and investment advice services, as well as providing discount brokerage services, retirement services, wealth management, securities execution and clearance, life insurance and a number of other services. Involved in delivering various components for configurations including analysis, design, development, unit test, system integration test, HAT test support, partner integration testing and deployment to production.

Responsibilities:

Coordinated activities that include gathering requirements for different partners of the client, documenting all the requirements and technical and functional details.

Created Schemas, Maps, Configured Input and output port, Designed orchestration for processing routing of message.

Implemented custom mapping logic using Scripting Functoids. Involved in writing Script/Custom Functoids based on various protocols, used different adapters (SMTP, HTTP, and FTP) to serve clients request.

Involved in Complex Orchestration design for business processing and Exception handling.

Publishing Schemas and Orchestration sas WCF Services to handle web service requests.

Written Custom Pipeline components and Script functoids using C#.

Designed and developed complex Orchestrations using patterns like sequential convoy, parallel convoy, Split pattern and aggregator pattern for managing message throttle.

Used BAM (Business Activity Monitoring) to track the messages going through different systems and to track failed messages.

Involved in making MSI packages and deployment into Test, Staging and Production Environments.

Involved in fixing and documenting the issues in the Production environment.

Developed mapping involving complex mappings and business rules. Extensively used custom inline C# components and XSLT in mappings.

Used Health and Activity Tracking (HAT) to track and view specific events and messages.

Extensively used advanced mapping functoids like Assert, table looping, and nil value Iteration to implement complex mapping logic.

Monitor BizTalk environments for errors and warnings and engage appropriate project resources to trouble shoot and resolve issues in a timely fashion.

Monitor performance of the environments and recommend scalability of BizTalk when appropriate.

Interact with other functional areas (e.g. R&D, QA, Data Management) in the design and deployment of BizTalk as an enterprise Shared Service.

Environment: BizTalk Server 2006 R2/2013 R2, Visual Studio 2005/2013, SQL Server 2005/2012, Windows Server 2003/2012 R2, C#.NET, XML, Web Services.

Citrix Systems Inc., FL Jul‘11– Jun’ 12

.Net/BizTalk Developer

Citrix Systems, Inc. is a multinational corporation that provides server and desktop virtualization, networking, software as a service and Cloud Computing technologies including Xen open source products. Scope of the project is to migrate large number of existing BizTalk Interfaces from 2006R2 to 2010. Interfaces include Siebel, SAP, EDI, Web Services, and WCF Services.

Responsible in gathering all the Requirements from client, Creation of BizTalk POC's for design

Installation and Configuration of BizTalk ‘10 on Development, Clustered QA & Production environments

Proactively monitored health of BizTalk servers installed at client sites and took preventative actions

Defined topology and specifications for variously sized Citrix clients, including scale-out architectures for large installations and migrations

Worked with WCF,FILE, LOB, MQ Series and Windows SharePoint Services (WSS) Adapters

Effectively troubleshoot using tools such as BizTalk Admin Console, PerfMon,SQL Profiler, Event Viewer, IIS logs, etc., to solve issues with WCF, IIS, slow file import performance, file import map issues/data truncation, bottlenecks in the system such as with SQL Server

Migration and code changes to existing BizTalk 2006 interfaces and implemented WCF-Custom Adapters for SAP Connections

Support multiple production and support environments as well as a number of development and test environments for large projects, Maintain Disaster Recovery environment and procedures

Support teams with issues related to Migration and Upgrade of BizTalk Server Interfaces

Environment: BizTalk 2006R2/2010, Visual Studio 2008, SQL Server 2008R2, WCF, ESB 2.1, Custom Tools

GlaxoSmithKline, Hyd, India

Mar 09 – Apr ‘11

.Net Developer

GlaxoSmithKline is a United Kingdom based pharmaceutical, biological, and healthcare company. With native support for electronic data interchange and BizTalk Server manages many of the company’s business processes faster and more reliably.

Wrote different classes, modules, web-forms in ASP.NET using C# as a code behind language and then included one common namespace. Created assemblies in C# that wrapped the business logic.

Used Dataset, Data Reader and Data Adapter classes of ADO.NET to communicate with the SQL Server 2000. Involved in creating stored Procedures that were used by the assemblies.

Assemblies created also used existing COM and COM+ components.

Designed web user controls and custom controls in order to provide the consistent user interface.

To give HTML documents an attractive and consistent appearance, used Cascading style sheets (CSS) and also applied XSL Transformations. Used XPath for the transformations.

Configured the web.config file to enhance performance of the application.

Implemented Client Side validation using JavaScript as well as a set of validation server controls.

Implemented the concept of web services and DHTML behavior, which enables us to call a remote method in client-side script to update small data changes to a page without requiring full page refresh.

Created test cases for Unit tests, security tests, load and stress tests and database tests.

Tested and submitted test results for approval.

Assisted in deploying web pages on server.

Environment: Windows XP, Microsoft Visual Studio 2003, HTML, DHTML, Java Script, C#.NET, ADO.NET, SQL Server 2003.

Contact this candidate