PROFESSIONAL SUMMARY

• About 7 years of experience in analyzing, designing and developing of Integration solutions, Internet/Intranet, and windows applications
• Extensive experience of 4 years in Microsoft BizTalk Confidential
• Experience using XML related technologies including XML, XSD, XSLT, and XPATH.
• Developed BizTalk Server artifacts such as Orchestrations, Maps, Schemas, Adapters, Ports, Pipelines and using Custom Functoids.
• Created Custom Pipeline Components.
• Experience in publishing Schemas and Orchestrations as WCF service, and consuming WCF and Web Services.
• Used Custom Adapters and out of the box BizTalk Adapters such as SQL, File, FTP, SFTP, HTTP, SMTP, SOAP, MQ Series, Windows SharePoint Services WSS .
• Hands on experience on Business Activity Monitoring BAM .
• Experience in Creating and Deploying Business Rule Policies.
• Worked on .Net 3.0, 3.5 and 4.0 Framework.
• Experience with HIPAA Transactions 270, 271, 276, 820, 834, 835, 837I/P/D and 999.
• Extensive experience in BI Solutions using SSAS, SSRS and T-SQL Programming using DDL, DML, DCL Commands for various business applications
• Created various SSRS Reports involving variety of features like Reports, Charts, Maps, Filters, Sub-Reports, Drilldown, Drill-Through, Multi-valued parameters etc.
• Good testing, analysis, troubleshooting and problem-solving skills with attention to detail.
• Excellent analytical and programming abilities in using technology to create elegant, flexible and maintainable solutions for complex development problems.
• Good leadership skills, written and verbal communication skills with ability to interact with cross-functional teams.

Technical Skills

Confidential

• BizTalk Tools : Orchestration Designer, Schema Designer, BizTalk Mapper, Pipeline Designer, Business Rule Engine Confidential
• Database : SQL Server Confidential
• Operating System : Windows7, Windows vista, Windows XP, Server 2003/2008.
• Languages : C ,HTTP, WCF, FTP, SFTP, FILE, SOAP, SAP, SQL Server, EDI, SSAS, SSRS and Microsoft Visual Studio Confidential

Professional Experience:

Confidential

Title: Senior Developer

Responsibilities:

• Designing pipeline components for both Inbound and outgoing messages.
• Provided solutions with Installation and configuration of Confidential
• Provided solution using both physical and logical ports.
• Designed and generated XML Schemas based on business document representations.
• Clustering of BizTalk server for high availability.
• Designed and developed policies using Business rules engine.
• Configuring Host and Host Instances on the BizTalk Administration console.
• Involved in BizTalk server security, High availability and maintenance of SSO database.
• Provide solutions for administrative activities such as development of monitoring message cleanup, tracking data clean up.
• Created receive and send ports to integrate with trading partners.
• Provided solutions for web development and winforms using ASP.Net and C .Net
• Created complex SQL stored procedures using Microsoft SQL server Confidential
• System improvement by automating the deployment task. Migration of the EMR system to the latest technologies.
• Created tabular, charts and graphs as per customer requirements using SSRS
• Highly involved in creating, structuring, formatting using Report designer and Report builder

Environment: Confidential

C .Net, ASP.NET, MS SQL Server 2008 r2, Windows Server 2008 r2, Microsoft XP Professional, Visual Studio

Confidential

Consultant

Responsibilities

• Responsible for gathering requirements, Analysis, Design and Development.
• Worked with Service Oriented Architecture using BizTalk 2009.
• Integrated BizTalk Server with internal back end systems.
• Used BTS for Routing BizTalk Messages.
• 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.
• Converted Biz Talk maps to .Net maps using C to improve the performance.
• 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, MSMQ, FTP, SQL, WSS, SAP, 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 2009.
• Performance monitoring for BizTalk 2009 developed applications.
• Improved BizTalk Interfaces with better Error Handling and logging features.
• Prepared Unit test cases and involved in the end to end testing of the BizTalk interfaces.

Environment

C , BizTalk 2009, MS SQL Server 2008 R2, TFS, Windows Server 2008 r2, Visual Studio

Confidential

Confidential

Responsibilities

• Created Flat file schema, Generic/Canonical schema, Property schema, Envelope schema.
• Created Maps Orchestrations.
• Writing .NET API, Custom components for pipelines.
• Testing, and deploying into various environments DEV, Staging, QA, UAT and production
• Developing activities/views and KPI for BAM.
• Installing BizTalk servers and configuring.
• Testing, and deploying into different servers
• Supporting Production systems.

Environment: BizTalk Server 2009, MS SQL 2008 r2, Visual Studio, VSS

Confidential

Title: Administrator/Developer

• Fiserv A Fortune 500 Company is the world's largest service provider to banks, credit
• Unions, lending institutions, and investment advisors a nationally-recognized single-source
• Solution provider to insurance companies and agents and a growing presence in health plan
• Administration.
• Life Suite is a product of Fiserv Insurance Solutions for maintaining the Insurance details which
• Was given to Insurance Clients - Aetna, ALFA, United Health Care, AXA and IAC.

Responsibilities:

• Gathered the business requirements
• Designed and developed various components using BizTalk 2009 as an Enterprise Application Integration Tool
• Developed Orchestrations for business logics
• Used Functions for converting dates, for look ups and convert legacy data to new defined values
• Developed Functions that extracts data from billing systems and delivers into a folder as a flat file, which are delivered as a XML web services after being processed by custom Ports
• Developed XML Schemas for representing Flat Files Positional Delimited and other XML files
• Developed Maps for mapping different Flat File schemas to XML Schemas

Environment:

BizTalk Server 2009, SQL Server 2008, Windows Server 2003, Visual Studio

Confidential

Software Engineer

Responsibilities:

• queries to upgrade SQL Server performance using SQL Server Confidential
• Worked with T-SQL to create Tables, Views, Triggers and Stored Procedures
• Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan
• Developed Tablix Reports, Sub Reports, Matrix Reports, Charts, and Drill down reports, Ad Hoc reports using SQL Server Reporting Services SSRS
• Worked on Dashboard using SSRS
• Identified and worked with Parameters for parameterized reports in SSRS 2005/2008/2008 R2
• Designed and created Reports templates, bar graphs and pie charts based on financial data.
• Developed Query for generating drill down and drill through reports in SSRS 05/08
• Uploaded reports on to the report manager and organized them in to folders.
• Created Development and Production support documents

Environment: MS SQL, Visual Studio, VSS