.Net BizTalk SQL - Integration Specialist

Pranav Patel

Gandhinagar, Gujarat,

India.

Cell: +91-962*******

Curriculum Vitae *********@*****.***

Objective

I want to be in a responsible position, which helps me use best of my

potential, talent and on the very point give me an opportunity of

professional and personal development with achievements of company's goal

and objectives.

. Strong understanding of OOP's Concepts.

. Relevant 2.5+ Year experience in developing Application using ASP.Net, MS

SQL Server 2K and 2K5.

. Relevant 3+ Year experience in developing Application using Microsoft

BizTalk Server, .NET, MS SQL Server 2K, 2K5 and 2K8.

. Relevant 2+ Year experience in designing and developing MS SQL server 2K,

2K5 and 2K8 database with the role as database developer.

. Worked on DTS in SQL 2K and SSIS in SQL 2K8.

. Specialized asp.Net, Web services, BizTalk Server 2004, 2006R2, 2009 and

2010, MS SQL 2K, 2K5 and 2K8, Java Script, XML, XSLT.

. Domain expertise in multi-channel retail and travel and hospitality.

. Involved in analysis, design and development web-based and integration

applications.

. Good exposure of preparing the System Analysis, Design & Coding.

. Well versed with CMMI process and followed it extensively in projects.

. Visited client place to understand existing problem in product as well as

new requirements.

Certification

. Microsoft .NET Framework 2.0-Application Development Foundation

Skill Sets

Programming Languages C, C++, c#.Net, Core Java, HTML, JavaScript, xml,

xslt, NHibernate.

Operating Systems Windows 95/98/2000/XP, Windows Server 2003

Data Base Systems MSSQL 2000, 2005, 2008, SSIS, SSAS, SSRS

Tools Visual studio 2003, 2005, Microsoft BizTalk server

2004,

2006R2, 2009 and 2010, SOAPUI

Other Microsoft Visio, N-Unit, SVN, CVS, Moq

Advance BizTalk Accelerator for RosettaNet, Web Services,

Tools/Technologies N-Tier Architecture, Visual Source Safe 2005, Web

Services, Agile Methodology, TDD

Work Experience

Software Engineer

Company: Cybage Software Pvt Ltd., Gandhinagar

(http://www.cybage.com)

July 2008 - Till date

Project Experience

1. Travel Packager Jun 2011 - Till Date

Language and Technologies involved - Asp .Net MVC 3.0 with Framework 3.5,

MSSQL Server 2008, N-Unit, NHibernate, SOAP, Web Services, TDD

Number of team members: 12

Operating Systems - Windows 7

Project Description - This is a travel website which allows travel agents

to book air, hotel and car. Our client is the biggest airline ticket

consolidator in Europe and we are building a website which also includes

dynamic packaging. Service layer (web services) is a heart of this

website which are created by our team which is going to be called from

MVC website.

Roles and Responsibilities -

. Creating web service as per requirement from UI team.

. Creating unit tests for web services developed.

. Prepared technical notes.

. Help team whenever required.

. Creating required database objects and N-Hibernate mapping.

. Visited client places to understand existing problem in product as

well as new requirements.

2. BizTalk Support and Administration Jul 2008 - Jun 2011

Language and Technologies involved - BizTalk Server 2004 - 2006, MSSQL

Server 2000, .net 2.0

Number of team members: 2

Operating Systems - Windows Server 2003

Project Description - The BizTalk artifacts which were already

implemented and deployed into production environment were to be supported

in case of any issues or enhancements. I am the point of contact for

clients if any issue is raised and I need to monitor the activities on

regular basis. BizTalk troubleshooting and debugging are my key tasks on

this front.

Roles and Responsibilities -

. BizTalk solution Troubleshooting.

. Monitoring BizTalk Artifacts through event log and HAT.

. Enhancements if any (Creating pipeline, configuration of ports).

. Fix the issue occurred.

3. JFLA - Supply Chain Integration May 2009 - Oct 2010

Language and Technologies involved - Microsoft BizTalk Server 2009, MS

SQL Server, xCBL 3.5

Number of team members: 2

Operating Systems - Windows Server 2003

Project Description - This is totally integrated solution between

lubricant supplier BP and its buyer JFLA. There is integration for

purchase order, change order and invoices. When an electronic Purchase

Order is sent from JFLA, it will be received and processed by BP

immediately. The BP middleware, Enabler, will hold the PO and check

availability of the product within JD Edwards and then the middleware

will generate a POA based on the results from JD Edwards. BP will either

'Accept', 'AcceptWithChange' or 'Reject' purchase orders based on various

business rules. Accepted orders will be immediately returned to Defence

and loaded into JFLA DB, while 'AcceptWithChange' or 'Rejected' orders

will trigger an email notification sent to the purchasing officer as well

as loading into JFLA DB. BP will always provide an explanation in the POA

comments field for 'AcceptWithChange' or 'Rejected' statuses which will

appear on the email notification sent to the purchasing officer. POC

messages will also be integrated to the BP middleware and not sent via

email for processing and therefore JFLA must flag all amended orders to

be sent to BP following an 'AcceptWithChange' or 'Rejected' status. BP

will not process amendments without being flagged by Defence or are not

in response to a POA 'AcceptWithChange' or 'Rejected' status as they are

seen as duplicates by BP. BP will response to the POC by sending another

POA with either an 'Accept', 'AcceptWithChange' or 'Reject' status. The

BP Invoice is triggered once the shipment is confirmed within JD Edwards.

BP will generate and send electronic invoice on the same day to JFLA

containing all the required Defence data. An email notification will be

sent immediately to the purchasing officer indicating that an Invoice is

to be loaded for a related PO. An over night batch job will load the

invoice into JFLA DB and match it to the Purchase Order which will then

await the receipt of goods before being triggered for payment.

Roles and Responsibilities -

. BizTalk solution design and development.

. Designed SQL objects like tables, stored procedures, views and

triggers.

. BizTalk feasibility study.

. Led a team.

4. Brakes - CRM Integration Aug 2009 - May 2010

Language and Technologies involved - MSSQL server 2008, SSIS, SSAS, SSRS

Number of team members: 5

Operating Systems - Windows Server 2003

Project Description - The Brakes is leading food service provider in UK.

The integration services they wanted were very demanding and complex as

they deal with many of big customers. The team at cybage is supposed to

integrate between two different systems. The Solution is a fully

integrated, which provides a complete end-to-end business solution. We

were to create database for the web portal (Brakes - CRM) which helps

them to get more out of their customers. The sales managers were the

users who can track their customer's spend over the period of time and

also manage their accounts through the portal. Different CSV files were

to be received daily, processing those files using integration service

and then send an outbound CSV files. We used SQL 2008 database for web

portal and used SQL 2008 integration services as integration service

provider.

Roles and Responsibilities -

. Database design and development.

. Designed SQL objects like tables, stored procedures, views and

triggers.

. SSIS implementation for integrating different types of data flows

between different systems.

. Database Administration.

. Led a team.

5. Conexa - Business Connecting Jul 2008 - Jul 2009

Language and Technologies involved - Microsoft BizTalk Server 2006, MSSQL

Server 2000, .net 2.0

Operating Systems - Windows Server 2003

Number of team members: 3

Project Description - The Conexa Solution is a fully integrated modular

suite of software, specializing in the provision of procurement services

through a number of web based and client based applications, working in

unison to provide a complete end-to-end business procurement solution. As

a solution provider, Conexa incorporates a number of technologies and

systems that cater for the procurement business requirements of both

buyers and suppliers. As Part of an integration project between ERP /

FMIS systems, and online e-procurement B2B or B2C solutions, the need to

securely exchange documents between the different systems becomes

imperative. In e-procurement architecture the online component may be

physically detached from the internal networks where the ERP resides.

This requires the introduction of a data exchange layer capable of

securely and reliably exchanging large amounts of data across the public

network, and have the capacity to exchange data with the internal

databases on the network. The proposition of enabling hosted solutions to

interact with internal ERP systems implies the requirement for data

exchange. This data is necessary to keep both systems up to date on

activities and transactions they handle, in addition to the exchange of

static data. Apart from integrating with internal ERP system there is a

requirement to integrate with trading partners to provide upto date

supply chain management in B2B application. To meet the automation

demands they have integrated their information systems and applications

with those of their suppliers, partners and customers reliably, securely,

and in real time. The system offers around 1 million products to choose

from and it is capable enough to handle 1500 end to end transactions per

day including time for user delay, the theoretical limit is 1000

transactions per minute.

Some salient project statistics:

. Product base of 1 million products

. Peak loads of 300,000 product updates (upon major price updates)

. Integrations through RosettaNet, EDI, XML, SQL and CSV formats

. ERP integrations with SAP, JD Edwards, Microsoft Great Plains,

Concerto

. CRM integrations with Siebel, Microsoft CRM

. Logistics integrations with Minster Logistics

Roles and Responsibilities -

. Define the scope of the integration task after analyzing the

requirements.

. Design integration architecture.

. Developing BizTalk solutions.

. BizTalk administrative work.

. Providing BizTalk support in live production environment.

. Client communication.

. Testing the application.

. Database Development.

. Designed SQL objects like tables, stored procedures, views and

triggers.

. Administrating the existing databases.

. Created PIP 2A1 and 3A4 interfaces for BTARN.

6. AD Server - Advertise management Dec 2007 - Apr 2008

Language and Technologies involved - .Net 2.0 using Visual studio 2005,

MSSQL server 2005, Java script, AJAX

Number of team members: 6

Operating Systems - Windows Server 2003

Project Description - The website is made to act as mediator between

website owners and advertisers that place advertisements of different

advertiser on different websites applying all kinds of optimization.

Roles and Responsibilities -

. Front end development using grid control and css.

. Database design and development.

. Designed SQL objects like tables, stored procedures, views and

triggers.

. Used VSTS 2008 for development.

Qualifications

Degree Institute/University Year of Passing Percentage

Bachelor of Dharamsinh Desai University, May 2008 67.00

Engineering Nadiad

(CE)

H.S.C (12th) Gujarat Secondary Education March 2004 83.11

Board

S.S.C (10th) Gujarat Secondary Education March 2002 89.29

Board

STRENGTHS

. Good communication and Interpersonal skills.

. Ability to work in a team and always remains a valuable contributing

part of the same and work under pressure.

. Self-motivated and Positive attitude.

Personal Details

Name : Pranav Patel

Date of Birth : 16th March 1987

Marital Status : Married

Languages Known : English, Hindi and Gujarati

Hobbies : Playing and Watching Cricket, Reading Books

Permanent Address : O\304, Parshwanath OM Residency,

Near Shreenath Residency,

Opp. Adalaj Petrol Pump, Adalaj,

Gandhinagar-382421

Phone Number : 962-***-****, 999-***-****(H)

Passport Details

Name as on Relatio Passport Date of Expiry Place of

passport nship Number Issue Date Issue

Patel Pranav Self G4165184 19-Jul-200 18-Jul-201 Ahmadabad

Pulkitbhai 7 7

I hereby declare that the information given above is true to the best of my

knowledge.

(Pranav Patel)

Contact this candidate