MCTS - SACHIN GUPTA

Email: pdqfz4@r.postjobfree.com

Cell: +1-515-***-****

Sachin is a Certified BizTalk specialist with 6 + years of experience in software development of Enterprise Application Integration and SOA Technologies. He has excellent hands-on experience in Microsoft BizTalk Server 2004 / 2006 / 2006R2 / 2009 / 2010, EDI, XML and MS ESB Guidance; as well as .Net technologies. He has worked extensively on Design of Architecture, Installation & Configuration of BizTalk Server infrastructure, creation of Schemas, Maps, Orchestrations, Rules Engine and Custom Pipelines and on Advanced BizTalk Server 2010 / 2009 / 2006 R2 / 2006 / 2004 Orchestration concepts. He has worked on migrating applications from BizTalk Server 2002 to 2004. Sachin has in-depth knowledge of .NET Framework including C#, LINQ and WCF Services and also has experience in developing WCF services using .Net Framework 3.0/3.5, C#.NET, SQL Server 2000/2005/2008, HTML, IIS, Visual Studio 2003/2005/2008. He has worked on WCF, SOAP, File, CRM, SQL and FTP Adapters and on publishing and consuming WCF Services and Web Services. Sachin has good communication and inter-personal skills.

CERTIFICATIONS:

• Microsoft Certified Technology Specialist (BizTalk Server 2006 Custom Applications)

TECHNICAL SKILLS:

BizTalk: BizTalk Server 2010 / 2009/2006/R2/2004/2002, BizTalk Administration, EDI (4010 to 5010 upgrade), HIPAA , Messaging Manager, Editor, Mapper, Orchestration, Pipelines and Adapters, Document Tracking, Web Services, WCF, Business Rules and MS ESB Guidance

Languages: C#.NET

Web Development: HTML, XML, XSLT and XPath

. NET Technology: CLR, CLS, .Net Framework classes, XML Web Services (SOAP), VisualStudio.Net 2003 / 2005 / 2008

RDBMS: SQL Server 2000/2005/2008

Operating System: Windows XP, Windows Server 2003 /2008

Tools/Technologies: IIS, Object Oriented Programming Techniques, SOA Development Techniques

Other Tools: Microsoft Visio, Visual Source Safe (VSS), TFS and PVCS

PROFESSIONAL EXPERIENCE:

Applications Consultant, Humana, Louisville, KY

Clinical IT – Clinical Guidance Exchange Utilization Management 10/11-Till Date

Humana, Inc. is one of the America’s largest Health Insurance Provider.

Responsibilities:

• Involved in the designing and implementation of the new components for Authorization Management.

• Working as a senior integration resource with the team to help them in understanding the capabilities of BizTalk server so that they can do the development on the provided design in a much efficient manner.

• Involved with the Business Analysts / Scrum Masters in defining the new requirements and to validate the detailed business requirement documents.

• Developed end-to-end BizTalk projects, consuming and exposing the Data Exchanges as WCF Services using LOB WCF adapters like WCF-Basic, WCF-Http or WCF-SQL.

• Designed and developed several new and complex Schemas, Maps, Orchestrations, Ports, Pipelines and Pipeline Components for the project.

• Involved in some pilot projects to test and define the integration with Mainframe.

• Working on the performance tuning of the solution so that the total response time for the authorization is brought down.

Environment: BizTalk Server 2009, Visual Studio.NET 2008, Windows Server 2008, Windows XP SP3.

BizTalk / EDI Consultant, Build A Bear Workshop, St. Louis, MO

EDI Implementation 08/11-10/11

Build A Bear Workshop is one of the fastest growing soft toy manufacturing and one of the 100 Best Companies to Work For company based out of St. Louis, Missouri. BAB is building up its IT infrastructure as its growing in size. There was an immediate need for BAB to implement EDI for automating the Purchasing process therefore they needed someone to help them in setting up their EDI environment. So that they could start placing their orders using the EDI 850 transaction set and receives the PO Acknowledgment back EDI 855 transaction set. All the BAB stores used to send their weekly supply orders using the Excel sheet to the Purchasing department, where one of the associate used to run a batch process to populate the orders table with the new orders data. Than a BizTalk SQL receive location used to pick the new orders data and used to send that data to the different vendors using the EDI send ports by using the parties and the agreements.

Responsibilities:

• Involved in the designing and implementation of the new components for the PO process.

• Involved in setting up the development, test and production environments.

• Involved in setting up the parties and agreements for the different Trading partners.

• Responsible for setting up the test strategy with the trading partners

Environment: BizTalk Server 2010, Visual Studio.NET 2010, Windows Server 2008, Windows XP SP3.

Senior IT Solutions Developer, Wellmark-Blue Cross Blue Shield, Des Moines, IA

Enterprise Service Bus (National Accounts) 08/10-07/11

Wellmark BCBS is a franchise for Blue Cross Blue Shield, which is America’s leading health insurance provider. Wellmark is enhancing its IT infrastructure and in the process they decided to implement an Enterprise Service Bus for meeting their integration needs using BizTalk server 2009, the service bus is built upon SOA. Wellmark is currently hosting its core business applications such as Claims, Members, Agents, Imaging, Providers, Benefits, etc. on different platforms like Mainframe, ASP.Net, Kovis, etc. The task of upgrading all these core services from its current versions to the new improved SOA version is undertaken by a team called Integration and Core Services. All the new services are built as BizTalk 2009 components and exposed as WCF endpoints. This ESB infrastructure is using artifacts of BizTalk 2009 extensively.

Responsibilities:

• Involved in the designing and implementation of the new components for different services like Claims, Members and the Pregnancy Program.

• Working as a senior integration consultant with the team to help them in understanding the capabilities of BizTalk server in a much efficient manner.

• Involved with the Business Analysts in defining the new requirements and to validate the detailed business requirement documents.

• Developed end-to-end BizTalk projects, consuming and exposing the Data Exchanges as WCF Services using LOB WCF adapters like WCF-Basic, WCF-Http or WCF-SQL.

• Designed and developed several new and complex Schemas, Maps, Orchestrations, Ports, Pipelines and Pipeline Components for the project.

• Involved in some pilot projects to test and define the integration with Mainframe.

• Also worked on EDI 4010 to 5010 upgrade (HIPAA) – X 12 (837)

Environment: BizTalk Server 2009, Visual Studio.NET 2008, BizTalk Server 2009, Windows Server 2008, Windows XP SP3.

BizTalk Developer, Capgemini Consulting India Pvt. Ltd., India 06/08 – 07/10

BizTalk Designer/Developer, Praxair Inc., NY 03/09 – 07/10

Praxair Logistics System

Praxair Inc. is a fortune 500 company, based out of Buffalo, NY, and supplies atmospheric, process and speciality gases, high-performance coatings, and related services and technologies to a wide diversity of customers. Praxair serves a wide range of industries: aerospace, food and beverages, healthcare, semiconductors, chemicals, refining, oil and gas production, primary metals and metal fabrication, as well as other areas of general industry. The WPF application is a smart client application developed in .Net 3.5 using WSSF and WCF. BizTalk 2006 R2 is also used for integrating with the other isolated applications like SCADA, RTU, OBC, etc.

Responsibilities:

• Had extensive discussions with the end client to discuss requirements and decide upon the BizTalk architecture.

• Coordinated with the BAs to come up with the final Requirement Documents.

• Developed end-to-end BizTalk projects, consuming and exposing the Data Exchanges as WCF Services using LOB WCF adapters.

• Designed and developed several new and complex Schemas, Maps, Business Rules, Orchestrations, Ports and Pipelines for the projects.

• Conducted Code-Review and approved developers’ design and development.

• Developed end-to-end WCF Services using .Net 3.5.

• Worked on tools like WSSF (Web Service Software Factory), LINQ Pad (SQL to LINQ converter) & Linqer (SQL to LINQ converter).

• Engaged in writing unit tests with code coverage of more than 80%.

Environment: BizTalk Server 2006 R2, Visual Studio.NET 2005 (for BizTalk 2006 R2) / 2008 (for WCF), WSSF, LINQ Pad and Linqer, Windows Server 2003 (for BizTalk) / 2008 (for WCF), Windows XP SP2.

BizTalk Team Lead, Reliance General Insurance Corp. Ltd., India 06/08 – 01/09

Reliance General Insurance – SOA

This was India's first project on MS ESB Guidance. RGICL is one of the fastest growing General Insurance companies in India. The need was to integrate the isolated systems, developed over the past many years, which were based on disparate technologies. Microsoft had come up with a new SOA product called MS ESB Guidance built upon BizTalk 2006 R2. Using ESB Guidance, different applications at RGICL were integrated. These systems include Savvion Workflow, Blaze Rules, Documentum and many other WCF and SQL Server systems.

Responsibilities:

• Analyzed systems and implemented Enterprise Service Bus for integrating these systems using MS ESB Guidance 1.0 (BizTalk 2006R2); by working closely with Microsoft Architect, Business Analysts and DBAs.

• Created several new End To End interface projects, right from creating Technical Specifications to designing, testing and implementing them in Production.

• Designed and developed several new and complex Schemas, Maps, Business Rules, Orchestrations, Ports and Pipelines and Itinerary files for the project

• Planned and administered day-to-day production activities and monitored the integrity of the output documents

• Implemented and ran the test cycle using TFS Unit test suite.

• Used VSS for Source Control.

• Trained the developers whenever necessary to bring them up to speed

• Conducted Code-Reviews and approved developers’ design and development tasks.

• Interacted with all levels of RGICL to understand their systems and provided detailed proposals and reports to higher level managers

• Provided detailed Documents, Reports, justifications and explanations in meetings to top level managers for the ESB.

• Configured, Scheduled and Managed Purging jobs.

Environment: BizTalk Server 2006R2, Visual Studio.NET 2005, MS SQL Server 2005, Team Foundation Server, Microsoft Visual SourceSafe and MS ESB Guidance package, Windows Server 2003/ Windows XP SP2.

Analyst Programmer, Fidelity Business Services India Pvt. Ltd., India 01/07 – 05/08

XTARC integration for Fidelity Investments Ltd., U.K.

Fidelity Business Services India (FBSI) Private Ltd. is an India based software services centre of Fidelity Investments. FBSI provides software services to Fidelity Investment group of companies across Europe, Far East Asia and US. Fidelity has this vision to automate its diversified applications. These diversified applications were XTARC workflow system, FILENET Content Management Server and different business services. The solution integrated those applications using BizTalk 2006.

Responsibilities:

• Interacted closely with the Fidelity Architects to understand the business requirements.

• Studied existing systems to understand the integration points and the input / output document types.

• Designed and developed several new and complex Schemas, Maps, Business Rules, Orchestrations, Ports and Pipelines for the projects

• Scanned the documents and created the work items for testing.

• Ran end to end process which involved systems like FileNet, XTRAC, Neurascript and other business services.

• Conducted Unit Testing and End to End Testing by interacting with end users.

• Moved the projects from Dev to Test and Production environments seamlessly

• Coordinated with the build team to make sure that build goes as per the build plan.

• Trained support staff to take care of BizTalk admin activities by using the BizTalk Admin Console and HAT Monitor and maintain BizTalk environment on a daily basis.

• Gained extensive financial domain knowledge.

Environment: BizTalk Server 2006, Visual Studio.NET 2005, MS SQL Server 2005, PVCS (Source Control), Neurascript Server, XTRAC (using HTTP web service calls) and FILENET (using APIs), Windows Server 2003 / Windows XP.

BizTalk Developer, Capgemini Consulting India Pvt. Ltd., India 08/05 – 01/07

Neste Oil Migration- for Neste Oil, Finland 01/06 – 01/07

Neste Oil is one of the biggest Oil Distribution Companies in Finland. Neste Oil had 11 integrated interfaces on BizTalk 2002 and this solution had to be updated to BizTalk 2004 for extending the functionality to the maximum. This required integrating a total of 11 different systems. The data was coming from different sources like www.neste.fi , private queues and the FTP locations and in the different file formats like XML and flat files. This data had to be correlated, transformed and refined and sent to the different Systems like the Oracle databases by the use of either Third Party components or the Call to the web services. This required the use of FTP Adapters and calling web services through SOAP adapters.

Responsibilities:

• Requirement gathering from the old source code and client interactions.

• Designed and developed several new and complex Schemas, Maps, Business Rules, Orchestrations, Ports and Pipelines for the projects.

• Conducted Code-Review and approved developers’ design and development.

• Used VSS for Source Control.

• Provided detailed Documents and Reports

• Installed BizTalk on different environments like Test / Prod.

Environment: BizTalk Server 2004, Visual Studio.NET 2003, Windows Server 2003, Windows XP.

HP Control Tower - for HP, USA 08/05 – 12/05

HP required a centralized Event Tracking and Reporting System for its Warranty Management Data. This required integrating a total of 14 source system providing warranty data in various formats (Xml file feed, SQL feeds, SAP, Flat files). This data had to be aggregated, correlated and sent to the event tracking system (Viewlocity) over HTTP protocol and to reporting system (MS SQL OLAP).

Responsibilities:

• Developed several new and complex Schemas, Maps, Business Rules, Orchestrations, Ports and Pipelines for the projects.

• Used VSS for Source Control.

• Provided detailed Documents and Reports

• Installed BizTalk on different environments.

Environment: BizTalk Server 2004, Visual Studio.NET, Windows Server 2003, Windows XP, 2003.

EDUCATION:

• Master of Computer Applications - Jaypee Institute of Information Technology, India

• Bachelor of Computer Applications - University College of Business Studies, India

Contact this candidate