Post Job Free
Sign in

Sql Server Developer

Location:
San Francisco, CA
Posted:
February 05, 2015

Contact this candidate

Resume:

GV- Senior BizTalk Developer

Summary:

** plus years of IT and technical experience involved in a wide diversity of industries such as

Telecommunications, Automotive, Energy, Healthcare Projects, Supply Chain Solutions and Web

Applications Projects. Activities include Designing, Developing, Testing, Debugging and Support.

• 7 plus years of solid experience BizTalk 2010/2009/2006R2/2006/2004 (Orchestrations, Pipelines,

Ports, Business Rule Composer, Schemas, Maps, BAM, ESB Toolkit), C#, VB.NET, ASP.NET, Web

Services, WCF, .NET Framework, ADO.NET.

• Creating Web Forms, Win Forms, User Controls, Custom Controls.

• Solid knowledge in Custom Pipeline Component development and familiar in using Adapters (SOAP,

FILE, SQL, FTP, HIPAA, EDI, WCF) with BizTalk 2010/2009/2006R2/2006/2004.

• EDI Transactions 834, 835,270, 271, 276, 277, 278, 997

Technical Skills:

• Primary Skills: BizTalk 2010/2009/2006R2/2006/2004, EDI, SQL Server 2005/2008 R2, .NET, C#,

VB.NET

• Biztalk Tools: BAM, HAT, BRE, ESB, Biztalk Admin Console

• Biztalk Adapters: HTTP, FILE, SOAP, SQL, WCF, SMTP, POP3, MSMQ, HIPAA

• Languages: C#, VB.Net, ASP.Net, Java, VB6, C++, C, T-SQL, HTML, XSLT, JQuery, Javascript

• Databases: MS SQL Server 2008R2/2008/2005, MySQL, MS Access, SSIS

• IDE: Microsoft Visual Studio 10/08/05, SQL Server Management Studio, HP Quality Center

9.2, SQL Server Business Intelligence Development Studio, NetBeans

• Operating Systems: Windows XP/Vista/7, Windows Server 2008/2003

• Source Control Team Foundation Server, TortoiseSVN, MS Visual SourceSafe

• Data Formats XML, EDI, HIPAA, Flat-File, XSD, XSLT, CSV

• EDI Transactions 834, 835,270, 271, 276, 277, 278, 997

Education:

• Bachelor's in Computer Science - European University

Professional Experience:

Senior BizTalk Developer – Camp Hill, PA, Deloitte Mar2014 to

present

Page 1 of 8

GV- Senior BizTalk Developer

Deloitte project is under the domain of Public and Child Welfare for the state of PA. CWIS project is related to

exchange of Child Welfare data between different counties and Child Welfare Investigation System (CWIS).

Different business interfaces like referral information, clearance, and system notifications are implemented as a

part of the project. These new interfaces automated most of the manual work done by county workers

improving the performance and accuracy of welfare services provided by county.

• Practical experience in System Design, System Analysis and Project Builds to meet the Requirement

Specifications.

• Developed and maintained BizTalk maps to transform messages to different layouts using functoids

and custom XSLT software.

• Created and updated custom pipeline C# software to write activities to BAM and to repair any defects

that were detected during the test phase.

• Developed and maintained BizTalk Orchestrations and created C# software for use in these

orchestrations.

• Created SQL stored procedures which were called by both maps and orchestrations.

• Created, modified and deployed Business Rules which defined the structure and control of the project.

• Created custom .Net software applications to assist with the testing of the project.

• Worked closely with the Test Team to fix defects that arose during System Test and SIT, and assisted

with System Test when required.

• Created Release Documents after each project build.

• Worked with Team Foundation Server which offered source control to the project.

• Used BAM and ESB Management Portal to track messages and activities.

• Working on ASP.NET projects for various clients.

• Practical experience working with Web services and WCF services.

• Design SQL code and created SQL Server Integration Services (SSIS) package files.

• Built and deployed projects to different environments.

• Provided support to System Test and fixed defects that arose.

• Worked with TortoiseSVN as a source control.

• Environments: BizTalk Server 2010, BizTalk ESB Toolkit 2.1, C#, VB.NET, SQL Server 2008 R2,

Visual Studio.Net 2008, HP Quality Center 9.2, Team Foundation Server, SQL Server Business

Intelligence Development Studio

Senior BizTalk Developer -Illumina - San Diego, CA April 2012 to

Feb2014

Illumina manufactures and markets integrated systems for the analysis of genetic variation and biological

function and its innovative, array-based solutions for DNA, RNA, and protein analysis serve as tools for

disease research, drug development, and the development of molecular tests in the clinic. Illumina elaborate

BizTalk to integrate with Eone applications, customers and their third-party vendors to receipt and transferring

data.

• Working with two different projects, one to integrate with JDE second with third-party vendors

Page 2 of 8

GV- Senior BizTalk Developer

• Installed and configured BizTalk server 2010

• Configured adapters for JDE one applications and configured BizTalk adapters like WCF-SQL, WCF

Custom, WCF-Web http, Schedule, File, SQL, HTTP, SOAP, MSMQ

• Fulfilling integration among Eone applications like JDE systems, customers and third party vendors

with illumina standards

• Worked with BA to gather and verify requirements, Prepared all technical and functional documents

actively working with technical teams to gather all requirements and performing Gap analysis

• Designed the solutions for various interfaces

• Developed complex maps

• Created various Composite, Canonical, Envelop, Document and flat file schemas

• Designed composite SQL Stored Procedures to ably interact with JDE SQL Server

• Developed the ESB Itineraries, Orchestrations that interfaced with the external Web Service

applications

• Configured UDDI Services to organizing, discovering, reusing, and managing Web services.

• Worked with WCF Custom Adapter bindings to access endpoint services.

• Used ESB Toolkit 2.1 for loosely coupled composition of service endpoints and management of

service interactions.

• Used ESB Exception Management Framework to create, repair, resubmit, and compensate fault

messages.

• Used ESB Itinerary Test Client application for testing.

• Developed the Orchestrations that are integrating with the various endpoints

• Created and deployed Policies using Business Rule Composer.

• Implementing a key role in the designing of solutions

• Strong understanding of BizTalk architecture and core components, pub/sub architecture, content

based-routing and maps.

• Configured and maintained BizTalk Artifacts like Maps, pipelines etc.

Page 3 of 8

GV- Senior BizTalk Developer

• Strong organizational, time-management and multi-tasking skills

• Maintaining code reviews to assure that followed architecture standards, code consistency and

maintainability.

• Responsible for BizTalk builds and deployment.

• Environment: BizTalk 2010, SQL Server 2008/2005, XML, Windows Server 2008/2003, Visual

Studio 2010

BizTalk developer -Hewlett Packard - Cupertino, CA Jul2011 to

Mar2012

The project HP Control Tower involved various operations to standardize the data to be loaded from the legacy

system to the new UI on a day to day basis. HP and Compaq computers deals with multiple transactions over a

period of time involving cases, claims, shipments, parts, labor and returns. These events needed to be tracked

and the existing system used individual systems to maintain this data. The HP Control Tower project removes

all the hassles for going to multiple systems to obtain data instead present it at one location.

• Gathered the Client Requirements by participated in meetings and involved in Analysis, Design and

development of the Application.

• Designed and developed different BizTalk interfaces including Orchestrations, send and receive ports,

pipeline components, messaging components, Adapters, to applications for integration.

• Developed Business Orchestrations this included use of different custom functoids and looping.

• Installed BizTalk, configured the various components, schemas, maps, orchestrations and ports.

• Implemented error handling to effectively and actively monitor the business activities using Business

Activity Monitoring (BAM).

• Implemented Custom Pipeline Components using C# to disassemble the messages.

• Involved in creating test plans and Test cases, performed unit testing and integration testing.

• Used BizTalk Server for defining XML Schema and XML files.

• Used different BizTalk patterns like correlation and convoys to integrate messages in an efficient

manner.

• Used .NET Validation controls to perform both client side and server side validation.

• Configured different adapters File adapter, SQL, FILE, HTTP, MSMQ and SOAP to send and receive

messages.

Page 4 of 8

GV- Senior BizTalk Developer

• Managed business processes and tracked the status of an Orchestration using Health Activity

Monitoring (HAT).

• Documented and transferred the knowledge to use and deployed the solution efficiently.

• Environments: BizTalk 2009, .Net frame work 2.0, Visual studio 2005, C#, SQL Server 2008,

Windows sever 2008

BizTalk Developer -Open Access Technology International Inc - Minneapolis, MN

Jan2011 to Jun2011

Open Access Technology International, Inc. (OATI) has been the leading provider of innovative web-based

software Solutions to the Energy Industry in North America for over 13 years. The purpose of this project is to

send and receive Web-based Transaction between OATI and its Trading Partners.

• Installation and Configuration of BizTalk 2010, SQL Server 2008 and also Visual Studio 2010.

• Provided 24X7 Production Support for all BizTalk and .Net Solutions.

• Consumed External Web services and implemented Robust Error Handling and Compensation Logic.

• Designed and developed various Stored Procedures to Insert, Update and Delete messages in the

Database.

• Applied API code inside the orchestration for BAM call.

• Configured BizTalk SOAP adapter to send and receive files from web into orchestration.

• Configured a SQL adapter to update data retrieved from web Application into a database.

• Involved in configuring SQL Adapter in sending messages to SQL Server from BizTalk Server and

vice versa.

• Created and used C# Assembly to explore WMI Events for Production Support.

• Used SMTP adapter to send information regarding failed messages to administrator.

• Used ESB exception handling framework for Exception Management within Orchestration.

• Handled Exceptions using the Custom Logging component in C#.

• Applied Custom Pipelines using C# for complex messages and handled them within orchestration.

• Environment: BizTalk Server 2010, C#, ASP.Net, ADO.Net, SQL Server 2005, T-SQL and Visual

Studio 2008

Page 5 of 8

GV- Senior BizTalk Developer

BizTalk developer -Well mark BlueCross Blue Shield - Des Moines, IA Mar2009 to

Dec2010

Well mark Blue Cross and Blue Shield is a mutual insurance company owned by its policyholders. Project

involved referring to the existing code in .net and to implement the same using BizTalk server 2009 compatible

to HIPAA 5010 version. Activities included implementation, maintenance, bug resolution and production

support for the 270/271, 276/277, 278 and 835 transactions.

• Revising the existing code and HIPAA implementations guides, understanding the changes for 4010

and 5010 versions and implementing the same business logic that applies to 5010 version

• Developing and updated orchestrations to implement the business logic with in BizTalk for the HIPAA

version 5010

• Implementing the direct binding ports with filter expressions within the orchestrations

• Extensive use of XSLT maps both for inbound and outbound maps implementing scripting functoids

with a lot of XSLT functions and inline scripts

• Created custom SQL Stored Procedures which were utilized in Maps and Orchestrations by BizTalk

Server

• Implemented .Net code with in BizTalk and making use of .Net methods in the orchestrations.

• Customizing the HIPAA base schemas for the internal Wellmark use and also to incorporate the rules

of association.

• Developing Orchestrations for error handling

• Extensive use of MQ Series adapter and filter expressions for routing and thus creating a complete end

to end flow of the data.

• Debugging the code and error fixing

• Working closely with Business people, DBA's, Architects and Tech lead to understand the

requirements and the existing issues and proposing the possible solutions.

• Collectively working as a team to figure out the best approaches to resolve the issues.

• Meeting the deadlines in time and making sure all the milestones are met

• Writing the installation documents and staging the code to TFS, thus providing the support for the

deployment to Test and Production servers

Page 6 of 8

GV- Senior BizTalk Developer

• Maintaining the application after the Production release and keeping the track of the bugs and fixing

those issues quickly and releasing the new code to Production.

• Working closely with Business and assisting them with their testing and understanding their

requirements and making the appropriate changes.

• Unit testing from my side and creating necessary EDI files for the testing and creating test cases for

testing certain .Net components.

• Environments: BizTalk 2009, C#, Team Foundation Server, Windows Server 2008, SQL Server 2008,

Visual Studio.Net 2008

BizTalk Developer -Cardinal Health - Dublin, OH May2007 to

Dec2008

Cardinal Health mainly handles business process integration required between their clients. Business

integration deals with medical, hospital and health care. Depends on the clients request, then it decides which

data has to be sent. In production block based on the items, request will be processed & transferred to the

corresponding details and at a time response will be send to the referred clients. It should be dynamically done

by this project for new business partners also. By using Biztalk2006R2 receiving and distributing HIPAA

transactions between Cardinal and its trading partners. Processed the claims of 837 Health Care Claim for

Payment and did 834 Benefit Enrollment & Maintenance.

• Involved in product Analysis, Design and Development of application Matching XML/Flat files of

various formats from disparate applications using BizTalk 2006 Schema.

• Transformed XML schemas using Maps and XSLT transformations.

• Development of interfaces using BizTalk Server 2006.

• Deployed BizTalk applications and packaged by creating MSI Files.

• Involved in Schema Design using BizTalk Editor.

• Created and worked on promoted schemas.

• Coding custom pipeline components for BizTalk Server 2006 using C#.NET

• Designed and Developed BizTalk 2006 integration solution

• Actively worked with BizTalk Rules Engine, written business process rules.

• Used the BTSNTsvc.exe to store configuration information and used App domain and Applied Pattern

assignment Rule to manage multiple configurations File.

• Developed HIPAA interfaces as per vendor specifications (BTAHIPAA).

Page 7 of 8

GV- Senior BizTalk Developer

• Calling .NET components from Orchestrations in BizTalk 2006 Solution.

• Involved in Unit, System and Regression testing of the interfaces developed in BizTalk 2004.

• Performance monitoring for BizTalk 2006 developed applications.

• Environment: BizTalk Server 2006, HIPAA, Visual Studio.NET, .Net 3.0, Oracle, SQL Server 2005,

UML, XML, XSLT, Windows Server 2003.

Network Specialist -Kyivstar, Cherkasy, Ukraine Mar2004 to

Apr2007

• Responsible for providing technical support to customers

• Network set up and troubleshooting

Page 8 of 8



Contact this candidate