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

An independent subsidiary of WellPoint, Inc, National Government Services NGS is one of the largest Medicare contractors in the country, serving nearly 200,000 providers and suppliers and over 20 million customers with Medicare in 20 states and five U.S. territories.

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

Confidential is a media company which has clients all over the globe. . Integration solution is developed to enable inter-business application integration between IPG and its clients. BizTalk is used as integration backbone between different web service processes and SAP.

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

Developed EDI Gateway integration solution based on BizTalk for various Toll clients. It has EDI X12, EDIFACT, EDIINT AS2, Flatfile, XML messages. System handles X12 ANSII EDI format as well as EDIFACT Europe/Asia format. It integrates all trading partners with toll internal systems like SAP, People Soft Accounting, and Java Microsoft based systems. All messages are near real time updates as well as have long running correlations. Used SSL and AS2. All messages are encrypted, compressed and digitally signed between partners. System has capability to send MDN and Technical acknowledgement for all the inbound messages.

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