Post Job Free

Resume

Sign in

Sql Server Insurance

Location:
Hyderabad, Telangana, 500057, India
Posted:
October 15, 2014

Contact this candidate

Resume:

Email: acgdw0@r.postjobfree.com

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 Server 2010, 2009,

2006 r2, 2006.

. 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

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

BizTalk Tools : Orchestration Designer, Schema Designer, BizTalk Mapper,

Pipeline Designer, Business Rule Engine (BRE).

Database : SQL Server 2005/2008/2012.

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 2010, 2008, 2005,

2003.

Professional Experience:

WellPoint, Indianapolis, IN July 2013-

Till Date

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 BizTalk Developer

Responsibilities:

. Designing pipeline components for both Inbound and outgoing messages.

. Provided solutions with Installation and configuration of Biztalk Server

2010

. 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 2008 and

2008 R2

. 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: BizTalk Server2010, C#.Net, ASP.NET, MS SQL Server 2008 r2,

Windows Server 2008 r2, Microsoft XP Professional, Visual Studio

IPG (Inter Public Group), NY City, NY

Jan 2013 - June 2013

BizTalk Consultant

IPG 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

BizTalk Developer, Toll Logistics, NY October 2011 to

Dec 2012

Project Name: TollEDI Gateway

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

Fiserv Insurance Solutions, Colorado Springs CO

Aug2010 - Sep2011

Title: BizTalk 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

Aditya Birla Minacs Limited Hyderabad, India

June2007 - July2010

Software Engineer

Responsibilities:

. Rewrote SQL queries to upgrade SQL Server performance using SQL Server

2005/2008/2008 R2

. 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 2008/2005, Visual Studio, VSS

Education:

Bachelors in Information technology



Contact this candidate