Sql Server Developer

Professional Summary

. * Plus years of IT experience, out of 5 plus years of BizTalk that

includes Client / Server Application Programming, BizTalk

Server2010/2009/2006 R2/2006, HIPAA /EDI, XML, ASP.Net, VB.Net, C#

. Experience in developing applications with BizTalk Server

2006/2006R2/2009/2010

. Experience in setting up BizTalk Server installation and configuration

. Proficient in writing SQL Stored Procedures, Functions, Triggers and

complex SQL scripts for data analysis.

. Experience specific to BizTalk technologies: Messaging, Deployment and

Admin Console, Adapters, Orchestrations, Pipelines, various Processors

. Experience with WCF services

. 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

. Ability to learn quickly and adapt to new changes. Good team player

. Very experienced in client interaction (understanding business

requirements, business data flow and data relations)

. Worked in the agile environment with sustainable development, face-to-

face conversations.

. Good adaptability to the continues change requirements.

Technical Skills

BizTalk Servers : Microsoft BizTalk Server 2010, 2009, 2006 r2, 2006.

BizTalk Tools : Orchestration Designer, Schema Designer, BizTalk

Mapper, Pipeline Designer,

Enterprise Service Bus (ESB),

Business Activity Monitoring (BAM), Business

Rule Engine (BRE).

Database : SQL Server 2005/2008/2012.

Operating System : Windows7, Windows vista, Windows XP, Server 2003/2008.

Languages : C#, C.HTTP, WCF, FTP, SFTP, FILE, Oracle, SOAP, SAP, SQL

Server, EDI, DB2, SSIS and Microsoft Visual Studio 2010,

2008, 2005, 2003.

Professional Experience

Social Interest Solutions (SIS) Sacramento, CA

Role: Sr BizTalk Developer Sep 2013- Till Date

Social Interest Solutions (SIS) is a mission-driven, nonprofit organization

dedicated to leveraging technology innovation to improve consumers' quality

of life. Our signature One-e-App technology platform enables individuals

and families to efficiently identify, access, and enroll in eligible public

and private health and social services. Other SIS products help consumers

and the organizations and agencies serving them connect to benefits and

services and operate more effectively and efficiently.

Responsibilities

. Responsible for gathering requirements, Analysis, Design and

Development and documenting the solution.

. Worked with Service Oriented Architecture using BizTalk 2010.

. Integrated BizTalk Server with internal back end systems.

. Used BTS for Routing BizTalk Messages.

. Implemented EDI transactions like 834 (Eligibility) for different

parties as per HIPAA compliance.

. Worked on Flat File schemas to convert data from XML to Legacy format.

. Used BizTalk Mapper to map XSD files to meet data transformation

requirements.

. Used custom pipelines to handle conditional data.

. Configured SMTP Adapter to send success/error E-mail alerts to users.

. Configured SFTP Adapter to send the reports, by extracting the data

from different databases.

. Worked with File, FTP, SQL, SFTP, WCF, HTTP Adapters.

. Planned, designed and developed BizTalk Orchestrations based on

internal and Business Partner specifications.

. Developed BizTalk Orchestrations to consume .Net Assemblies.

. Developed BizTalk Orchestrations to split bulk messages.

. Involved in Unit, System and Regression testing of the interfaces

developed in BizTalk 2010.

. Performance monitoring for BizTalk 2010 developed applications.

. Maintaining the performance, integrity and quality of all database

instances and DB servers and Wrote stored procedures for accessing the

data from SQL.

. Improved BizTalk Interfaces with better Error Handling and logging

features.

. 7/24 support of BizTalk Server 2010

. Prepared Unit test cases and involved in the end-to-end testing of the

BizTalk interfaces.

Environment: C#, BizTalk 2010, MS SQL Server 2008 R2, TFS, Windows Server

2008 r2, Visual Studio

Munich RE, PrincetonNJ April 2012

-August 2013

Role: BizTalk Consultant

Munich Re stands for exceptional solution-based expertise, consistent risk

management, financial stability and client proximity. In the financial year

2013, the Munich Re Group achieved a profit of E3.3bn on premium income of

E51.5bn. It operates in all lines of insurance, with almost 45,000

employees throughout the world.

Responsibilities

. Coordinate activities which include gathering requirements for

different partners of the client, documenting all the requirements and

technical and functional details.

. Installed and configured BizTalk 2009 server.

. Implemented EDI transactions like 837(Claims Professional and

Institutional), 834 (Eligibility) for different parties as per HIPAA

compliance.

. Created and configured party information for all the parties in

BizTalk admin console.

. Developed mapping involving complex mappings and business rules.

. Used Native BizTalk SQL Adapter and WCF Custom SQL Adapter for

communication with SQL Server 2008.

. Developed Custom Pipeline components as per the requirements.

. Developed Vocabularies and polices for business rules using Business

Rule Composer Tool.

. Configured the BizTalk host instances and Adapters for Host.

. Extensively worked on promoting code from development to other

environments, Customized packages and deployed on multiple servers.

Environment: BizTalk Server 2009, SQL Server 2008R2, Visual

Studio.NET 2008.

AmeriHealth, Pennsylvania

Feb 2011 - March 2012

Role: BizTalk Developer

Responsibilities:

. Responsible for developing Orchestrations, Maps, deployment and end to

end testing of 270/271,276/277 and 278 5010 HIPAA EDI transactions.

. Created schemas for 270/271, 276/277 processes and created maps for

mapping the web service response to the output.

. Made extensive use of logical and Scripting functoids for creating

complex mappings

. Configured different Receive Ports and send Ports for end-to-end

workflow by configuring different pipelines and adapters.

. Involved in deployment and debugging of the code

. Created Stored Procedures for storing the data and retrieving the data

to and from databases before sending the file to BX for non-local

members.

. Generated 997 Acknowledgements for Inbound Claims encapsulating

information on rejects

. Documented and Transferred the knowledge to use and deploy the

solution efficiently

. Installed and configured BizTalk 2010 server.

. Maintaining the performance, integrity and quality of the servers.

Environment: BizTalk Server 2010, C#, ASP.Net, Visual studio 2008,

Windows server 2008, SQL Server 2008.

Perficient Inc. March 2010-

Jan 2011

Role: BizTalk Developer

Project: Anci-Care, Dallas, TX

Anci-Care is in the business of health care. Develop and architect

Symitar Integration using BizTalk Server 2006R2.

Responsibilities:

. Worked on HIPAA EDI X12 v4010 documents: Health Care Claims (X12 837),

Claim Status (X12 276), Claim payment (X12 835), Eligibility &

Enrollment (X12 834) transactions.

. Install and Configure BizTalk Server 2006R2 for Test and Production.

. Established development framework by identifying right BizTalk

components to use, project dependency structure for solution, defining

the coding standards, process for build automation.

. Create a deployment Script for automate deployment in Dev., Test and

Production.

. Setup Business Activity Monitoring (BAM) for end-to-end logging.

. Configured EDI Batcher Mechanism to handle outgoing EDI Batches based

on batch criteria.

. Implemented Exception handling, Exception Handling management portal,

BizTalk operations console using ESB 2.0 Toolkit.

Environment: Visual Studio 2005, BizTalk 2006R2, C#, ESB, BizTalk Adapter

for WCF, TFS.

HDFC (P) Ltd, India

October 2007- Feb 2009

Role: .NET Developer,

Responsibilities:

. Worked as a software developer responsible for development of forms

using visual basic .NET.

. Write Data base queries and create Stored Procedures.

. Create, Maintain Tables.

. Security aspects of the application.

. Documentation of the functional and technical aspects of the

application.

Environment: Visual Studio 2005, VB.NET, SQL Server 2005.

Global India Technologies, India

July 2006 - Sep 2007

Role: .NET Developer,

Responsibilities:

. Design & Development of UI using, HTML, CSS, VB Script and JavaScript.

. Performed Validation using JavaScript at Client site.

. Created classes to use in the web service.

. Worked with Master Pages that were common throughout the application

and content pages.

. Design and Development of COM components for Business Logic.

. Exported data from SQL Server.

. Designed and implemented the application using VB.NET and ADO.NET with

MS Visual Studio.

. Wrote stored procedures for accessing the data from SQL.

. Wrote user defined Functions and Triggers.

Environment: Visual Studio 2005, VB.NET, ADO.NET, MS SQL Server, Web

Services, HTML, JavaScript, CSS, XML, IIS, .NET Framework and Windows.

Education

Bachelor of Engineering

Contact this candidate