Sql Server Insurance
Resume:
Email: ****@*********.***
Mobile: 925-***-****
SUMMERY:
. Over 9+ years of Experience in IT Industry With 7 years in Web,
Client, Server Applications and Integrating between the Applications
using BizTalk Server and 2 years in .Net Technology.
. Solid experience with Software Development Life Cycle (SDLC) and
project methodologies.
. Extensive developing experience in various industries including
Insurance, Financial Services, Manufacturing, Banking, Health care
projects etc.
. Thorough understanding of BizTalk server architecture concepts such
as Adapters, Pipelines, Schemas, Maps, Orchestrations, Role Links,
Publish-Subscribe messaging and their respective roles.
. Skilled in using BizTalk Editor, Mapper, Pipeline Designer,
Orchestration Designer, HAT, Orchestration Debugger, Business Rule
Composer and Tracking Profile Editor.
. Solid EAI and B2B developing experience with BizTalk server.
. Experience in developing applications with BizTalk Server
2004/2006/2006 R2/2009/2010.
. Good Knowledge and experiences of advanced subject in BizTalk such
as Security, Transaction, Compensation, Convoy and Scalability.
. Working experience and good knowledge of ESB, Business Activity
Monitoring (BAM) and Business Rules Engine (BRE).
. Experience in RosettaNet, ANSII X12 and HIPAA 2.0/3.0.
. Experience in .NET Framework, Windows and Web based application
development using Microsoft.NET technologies including ASP.NET,
C#.NET, VB.NET and Web services, Enterprise Library, SSRS, SSIS, T-SQL
and Stored Procedures with SQL Server.
. Experience in creating Web Services using C#.NET and WCF services.
. Excellent Object-Oriented Programming skills in C#.
. Experience with XML, XSLT, Web Services and SOA.
. Strong knowledge in WCF, WPF, COM+, SOAP and CRM.
. Excellent communication, interpersonal skills and strong
organizational skills.
TECHNICAL EXPERIENCE:
Languages Microsoft C#, VB.NET, Visual Basic 5.0/6.0, and C
Web ASP.NET, XML, Web Services, MVC 4.0 and KendoUI
Technologies
Markup HTML, XML, XSL
Languages
Scripting VB Script
languages
XML XML, XSL, XSLT, Info Path, XPATH, Web Services
Technologies
RDBMS MS SQL Server 2000/2005/2008/2012, Oracle 7.x/8.x, MS
Access, SSIS
Operating Windows Server 2000/2003/2008, Windows XP/7/8, MS DOS,
Systems Linux, Unix
IDE MS Visual Studio.NET 2003,Ms Visual Studio
2005/2008/2010/2012
Enterprise BizTalk Server 2004/2006/2006R2/2009/2010 BAM, BRE,
Servers BizTalk Administration and Configuration
ERP ECC 6.0 eph6
EDI ANSI X12, HIPPA and RosettaNet
Database ADO.NET, ADO
Access
Technologies
Reporting Crystal Reports 7.0/9.0, SSRS
Tools
Modeling Tools MS Visio 2007
Version MS Visual Source Safe (VSS), TFS
Control
WORK EXPERIENCE:
Tate and Lyle, Decatur, IL
Aug' 13 to Till Date
Role : Senior BizTalk Consultant/Administrator
Tate & Lyle is a global provider of distinctive, high quality
ingredients and solutions to the food, beverage and other industries. Tate
& Lyle use innovative technology to turn raw materials into distinctive,
high quality ingredients for our customers. These ingredients add taste,
texture, nutrition and increased functionality to products that millions of
people around the world use or consume every day.
.
Tasks and Responsibilities:
. Designed complex orchestrations for execution of business process and
Exception handling.
. Exported & Imported MSI packages & Binding files for BizTalk
deployment on Multi servers for Development, QA and Production
Environments.
. Deployed and maintained the applications in BizTalk admin console.
. Troubleshooting and maintained the applications using BizTalk
Administration tool.
. Created and configured the receive ports and send ports with the FILE,
SQL, WCF-Custom, EldosFTP, HTTP and windows sharepoint services
adapters.
. Created SQL stored procedures to generate the XML data from database.
. Made extensive use of looping, table looping, scripting and logical
functoids for more complex mappings.
. Developed several Interfaces/Orchestrations to integrate SAP ECC 6.0
using RFC call/Idoc.
. Involved in EDI UAT testing, X12 file validation with customer specs
for 850, 855, 856, 404, 860, 864, 824 and 810 transactions.
. Update the Business Process Integration maps as per the
partners/business requirement.
. Troubleshooting inbound and outbound IDOC's in SAP ECC 6.0 systems
using t-codes(we02, we19, va03, vl03n, vt03n and vf03).
. Good knowledge about ISTM methodology and SDM.
. Executed the test scripts and created defects in HPQC ALM 12.0.
. Performed application documentation and provided technical support.
Environment:
BizTalk Server 2009, C#, XML, EDI, Web Services, SQL Server 2008, Visual
Studio 2005/2008, Windows Server 2008, VSS, SAP ECC 6.0, SAP NW 7.2
Dow Corning Corporation, Midland, MI
Jun' 12 to Aug' 13
Role : Senior BizTalk Developer/Administrator
Dow Corning provides performance-enhancing solutions to serve the
diverse needs of more than 25,000 customers worldwide. A global leader in
silicones, silicon-based technology and innovation, Dow Corning offers more
than 7,000 products and services via the company's Dow Corning and
XIAMETER (www.xiameter.com) brands.
Tasks and Responsibilities:
. Troubleshooting and maintained the applications using BizTalk
Administration tool, IIS, RosettaNet accelerator, Ponton and B2B
tracking etc.
. Created and configured the receive ports and send ports and with the
SMTP, FTP, SOAP, SQL, WCF-SAP, WCF-Custom and POP3 adapters.
. Involved in implementing B2B partner and personal certificates in
RosettaNet administration console and Paton.
. Involved in EDI, GUSI, PapiNet and CIDX Mapping to different formats
and some Maps moved from BizTalk 06R2 to BizTalk 2009.
. Designed complex orchestrations for execution of business process and
Exception handling.
. Exported & Imported MSI packages & Binding files for BizTalk
deployment on Multiserver for Development, QA and Production
Environments.
. Deployed and maintained the applications in BizTalk admin console.
. Created new Hosts, Host Instances for POP3 adapter.
. Created and scheduled the tasks using Task Scheduler.
. Created scripts and batch files to prevent reoccurrence of issues.
. Troubleshooting inbound and outbound IDOC's (Orders02, Orders04, Order
responses and Invoices) in SAP ECC 6.0 systems using transactional
codes.
. Good knowledge about ISTM methodology and SDM. Working experience in
production support environment (Incident Management, Problem
Management & Request management).
. Performed application documentation and provided technical support.
Environment:
BizTalk Server 2010, RosettaNet accelerator, C#, XML, EDI, Web Services,
SQL Server 2008, Visual Studio 2008/2010, Windows Server 2008, .NET
Framework 3.5/4.0, TFS, SAP ECC 6.0, SAP NW 7.2
Forrest T. Jones & Company, Kansas City, MO
Nov' 10 to Jun' 12
Role: Senior BizTalk Consultant/ Administrator
Forrest T. Jones & Company (FTJ) is an insurance agency and
administrator that was established in 1953 to provide insurance products
and other financial services to members of associations and other affinity
groups.FTJ currently provides insurance programs to more than 80 national
associations and employer groups with more than 1.5 million members.
Tasks and Responsibilities:
. Involved in creating Software Development Life Cycle (Analysis,
Design, Development, Testing and Deployment) of project.
. Developed the Orchestrations, Schemas, Custom Functoids and maps to
process the acknowledgments received from the legacy systems and send
the email Notifications to the recipients in case of errors.
. Created and configured the receive ports, send ports and send port
groups with the SMTP, FTP, POP3, HTTP and SFTP adapters.
. Developed the custom send port pipeline component using C# to format
the XML acknowledgement in to the HTML notifications.
. Developed the XSLT transforms to convert the XML in to the HTML and
used in send pipeline component.
. Developed the Orchestration with the dynamic binding, handled the
exception using the scope shape and wrote to the event log.
. Created transformation Maps for EDI ANSI X12 850,855 & 810
transactions.
. Configured and managed EDI Parties for AS2, EDI transactions.
. EDI to and from SAP transactions, Excel to SAP.
. Wrote the SQL stored procedures to generate the XML data from
database.
. Called the .NET classes from orchestrations and posted the messages to
the WCF web services.
. Supported Business Intelligence applications using MS SSIS.
. Created and configured the receive ports, send ports and send port
groups.
. Used Health and Activity Tracking (HAT) to track and view specific
events and messages.
. Tested the applications and installed in the production server.
Environment:
C#.Net, ASP.Net, BizTalk Server 2009/2010, FILE, XML, FTP, BAM, HAT, Web
Services, SQL Server 2008/2008 R2, Windows Server 2003/2008, Visual Studio
2008/2010, .NET Framework 3.5/4.0, TFS, IIS 7.0, Microsoft Visio
Liberty International Underwriter, New York, NY
Aug' 09 to Oct' 10
Role : Senior BizTalk Developer/ Administrator
Liberty International Underwriters (LIU), a division of Liberty Mutual
Group, was formed in 1999 as a global specialty lines business with an
emphasis on niche insurance products distributed through the independent
broker network. LIU is a major focal point for specialized coverage of
complex risks for Liberty Mutual.
Tasks and Responsibilities:
. Involved in development Custom Pipeline components and Custom
functoids.
. Completed Microsoft BizTalk Server 2009 Installation and configuration
in Multi-server Environment.
. Involved in EDI Mapping to different formats and some Maps moved from
BizTalk 2006R2 to 2009.
. Designed BAM Activities and Aggregations for different flows.
Tracking milestones using BAM API's
. Designed complex orchestrations for execution of business process and
Exception handling.
. Implemented BRE for business validations and ESB logging exceptions.
. Actively involved in installation and configuration of BizTalk Server
2009 on multiserver in Development and Production systems with cluster
SQL server 2005.
. Configured EDI/AS2 and over HTTP with Partner Management.
. Configured BAM activities and Aggregations in the BAM portal to view
end to end messages. To view Received and Send messages through BAM
custom implementation Portal. Created BAM alerts for failed messages.
. Involved in implementing Transport level security by configuring IIS,
encryption and decryption using digital certificates using X509.
. Build MSI packages for BizTalk deployment on Multiserver for
Development and Production Environments.
. Actively involved in development and support of BizTalk
. Implemented ESB to handle errors in the event log from different
applications (flows).
Environment:
BizTalk Server 2009, C#, BAM, BRE, ESB,WCF, SCOM/MOM 2005, XML, EDI,
EDI/AS2, Web Services, SQL Server 2005, Visual Studio 2008 Sp1, Windows
Server 2008,VPC 2007, Virtual Server 2005, SQL Cluster Servers
WACHOVIA BANK, Saint Louis, MO
Nov' 08 to July' 09
Role: Senior BizTalk Developer/Consultant
Wachovia provides a broad range of banking, asset management, wealth
management, and corporate and investment banking products and services. It
is one of the largest providers of financial services in the United States.
Tasks and Responsibilities:
. Used the Schema Design Patterns to Create Simple and Complex Schema
type and optimize common schema, Canonical Schemas separately.
. Created WCF Enabled web service using ASP.NET, VB.NET.
. Used Maps and mapping functoids extensively and wrote test cases using
Mapping helper.
. Used BizTalk Design pattern for Decoupling BizTalk Orchestration
Processes.
. Business Process Management is used for manual and automated
workflows.
. Used Asynchronous (start Orchestration) and Synchronous (Call
Orchestration) technique of the Orchestrations.
. Dynamic routing of messaging used based on Process Request.
. Documenting the process flow, mapping requirement, orchestration
Message Flow.
. Used BAM to retrieve Status milestone.
. Used SQL Adapter to Update, Extract data from the SQL Server Database.
. Developed the stored procedures for the updating the database,
retrieving data from application Tables.
. Integrated the mailing functionality using an in-house mailer service.
This was used for sending Information to client about the Transaction
Process Status.
Environment: Windows Enterprise Server 2003, IIS 6.0, .NET Framework,
BizTalk Server 2006 R2, SQL Server 2005, C#, ASP.NET, ADO.NET, VB.NET,
Visual Studio .NET 2005, Visual Source Safe.
Common Fund, Wilton, CT
Dec' 06 to Oct' 08
Position: BizTalk Developer
Strategic Solution is web based integrated investment solution
includes Investment Management, Monitoring, Reporting and Rebalancing. The
main objective is simplification and standardization across the Common Fund
group by Leveraging existing solutions, Standardizing and reducing the
custom solutions as much as possible, As part of this External applications
are integrated using BizTalk Server 2006 as an Integration Hub.
Tasks and Responsibilities:
. Gave architectural review of the system and improved its performance.
. Troubleshot and maintained the application using HAT, IIS, BizTalk
Administration tool, and etc.
. Development involves creating Schemas, Maps, Orchestrations and
Configurations of various Adapters, Custom components in C#.Net.
. Used SOAP, HTTP, MQ Series and MSMQ adapters.
. Custom pipeline components and web services are used.
. Scripts (WMI and Batch) are used to deploy the solution.
. Message Encrypting and Signing.
. System integration test.
. Integrated BizTalk Server with SQL Server using SQL Adapter.
. Implemented error handling to effectively and actively monitor the
business activities using Business Activity Monitoring (BAM)
. Managed business processes and tracked the status of an Orchestration
using Health Activity Monitoring (HAT)
. Performed application documentation and provided technical support.
Environment: Windows Enterprise Server 2003, IIS 6.0, .NET Framework,
BizTalk Server 2006, SQL Server 2005, ASP.NET, C#, ADO.NET, Visual Studio
.NET.
Fusion Technologies IT PVT Ltd, Chennai, India
July' 05 to Nov' 06
Role : BizTalk\C# Developer
Fusion provides IT solutions for Financial Services,
Telecommunication and Manufacturing Sectors. I was involved in several
major projects as a BizTalk\C# Developer.
Project: Insurance Tracking Project. This B2B solution for an
insurance company helps other financial organizations (lenders) to
keep track of their borrowers' insurance status. Borrowers' insurance
documents are routed through BizTalk server and are evaluated against
the corresponding loans. When an insurance document failed evaluation,
lenders are notified and appropriated actions are taken.
Tasks and Responsibilities:
. Gathering the Client Requirements by participating 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.
. Installed BizTalk, configured the various components, defined schemas,
maps, orchestration, ports, receivers and envelopes
. Used BizTalk Server for defining XML Schema and XML files
. Developed Business Orchestrations this included use of different
custom functoids and looping
. Used different BizTalk patterns like correlation and convoys to
integrate messages in an efficient manner
. Implemented Custom Pipeline Components using C# to disassemble the
messages
. Configured different adapters File adapter, SQL,FILE,HTTP, MSMQ and
SOAP to send and receive messages
. Used .NET Validation controls to perform both client side and server
side validation
. Involved in creating test plans and Test cases, performed unit testing
and integration testing
. Documented and Transferred the knowledge to use and deploy the
solution efficiently
Environment:
BizTalk 2004, C#, ASP.NET, SQL Server 2000/2005, XML, Windows Server 2003,
Visual Studio 2003/2005, HAT, BAM, IIS 6.0.
Contact this candidate