Post Job Free
Sign in

Project Business Sql Server Sharepoint .Net Data

Location:
Miami, FL, 33125
Posted:
March 09, 2010

Contact this candidate

Resume:

ASHISH KAMDAR

Email: abnfp7@r.postjobfree.com

Profile: I have completed my masters with specialization in Insurance Management. I have

total experience of over 12 years in architecting, designing, developing and implementing

IT solutions with a deep understanding of Microsoft technology stack. I have worked on

diverse projects ranging from client/server systems to B2B/B2C Enterprise Portals, ECM,

EAI, SCM, CRM, ERP, Business Intelligence, OLAP/DataWarehouse, Reporting,

Enterprise Workflows and Collaboration and this has given me a well-rounded exposure

and a solid understanding in providing effective solutions to resolve complex business

problems in any kind of scenarios. Having excellent communication and leadership skills

has helped me in dealing directly with clients during onsite engagements and effectively

completing projects within strict timeframes and positive outcomes. However I believe my

forte is in deeply understanding the problems from business perspective in order to

effectively architect solutions, utilizing latest technologies, to provide efficient solutions.

Ares of Interest: Primarily interested in providing solutions in areas of Enterprise Portals,

Workflows and Collaboration predominantly using Microsoft technologies with products like

SharePoint Server, InfoPath & Office 2007, BizTalk Server, .net, Asp.net, C# etc

Experience Summary:

Microsoft InfoPath 2007

Designing InfoPath forms, form templates, template parts, master-detail forms

Integrating InfoPath forms with Microsoft Outlook, SharePoint, Databases, Web services, Hosting

environment etc

Working with Master-Detail forms, Multiple views, Digital signing

Construction of Browser-Compatible forms

Working with different Form Submit options

Publishing forms using diverse publishing options along with property promotion

Working with Main and Secondary Data Connections and Data Source

Submitting and Retrieving data with various data sources

Working with Form Security and Trust options

Utilizing various form-filling options like Conditional formatting, Data Validation and Rules

Creation etc

Creation of Workflow Initiation and Association forms

Working with Roles and role-based views

Building reusable form templates using Template-parts

Installation and configuration of Forms Services for deploying Browser-Compatible forms

Microsoft Office SharePoint Server (MOSS) 2007

Designing and Implementing custom workflows in SharePoint using Windows Workflow

Foundation (3.0)

Programming workflows that support Serial/Parallel execution, Send email notifications, enable

Timeouts and Escalations, Delegation of task to peers etc

Configuring and using out-of-the-box SharePoint workflows

Driving SharePoint workflows from Microsoft Office clients like Word, Outlook etc

Working with provisioning of Sites, Site collections, Lists, Document Libraries, Content Types etc

Working with collaboration tools like Blogs, Wikis, Meeting and Document Workspaces, RSS

feeds etc

ASHISH KAMDAR

Email: abnfp7@r.postjobfree.com

Working with communication tools like Announcements, Discussion boards, Calendar, Contacts,

Tasks, Project Tasks, Surveys, Issue Tracking etc

Working with various available libraries like Document, Form, Picture, Wiki Page, Report, Slide,

Data Connection etc.

Working with creation and configuration of available and custom Web parts

Working with Personalization features like Alerts, My Site, My Links etc.

Managing site security, permission and security groups

Configuring various search options

Using CAML to query list and filter data in Web parts

Working with Features and Solutions

Handling List events using Event Receivers

Integrating Business Data using Business Data Catalog with its associated Web parts

Working with Excel Services

Working with out-of-the-box features like Document Management, Project Collaboration &

Management, Content Management, Records Management etc.

Microsoft BizTalk Server

Designing, Developing & Implementing Enterprise Application Integration workflows using BizTalk

Server

Development of Custom Functiods and Custom Pipeline Components

Proficient in using BizTalk Mapper for transformation of formats and writing custom XSLT scripts

for complex transformation operations

Working with stack of BizTalk Adapters like File, FTP, HTTP, SOAP, MQ Series, MSMQ, POP3,

SMTP, SQL, WSE, WCF etc.

Good knowhow of implementing various Enterprise Integration Patterns

Architecting solutions which utilize Publish-Subscribe architecture of BizTalk to implement

loosely-coupled solutions for Service-Oriented or Enterprise Message Bus scenarios

Exposure to designing solutions requiring use of Sequential and Parallel Convoys for ordered

delivery of message and in avoiding race condition situations

Efficiently segregate Business rules from the processing of application by utilizing Business Rules

Engine available for complex policy-based processing conditions

Exposure to using Business Activity Monitoring (BAM) functionality in order to achieve insight of

transactions being processed as typically required in BPM scenarios. BizTalk offers the

complete plumbing required for tracking messages being processed at every stage and this

data is transported to OLAP-based database for Analytical reporting to monitor trends. This

enables BizTalk to be used also for Complex Event Processing (CEP) type of scenarios.

Worked on projects utilizing EDI document processing with both standards X12 (for North

America) and EDIFACT (for European and rest of America) by using enhanced EDI capabilities of

BizTalk server along with business rules validation software (EDIFECS).

Good knowledge of utilizing Service-oriented capabilities of BizTalk by Consuming external web

services using SOAP adapter as well as by exposing BizTalk Orchestration as Web Service to be

utilized by other applications.

Exposure to designing workflows which enable processing of Long-running transactions along

with synchronous as well as asynchronous message processing capabilities

Experience in writing automatic build test cases using external tools like BizUnit or using in-built

auto build features of BizTalk 2009

Good hands on experience in providing solutions with the interrelated technology set of BizTalk,

SharePoint and InfoPath. This three products serve to complement each other nicely and can

be used for architecting a solution where BizTalk fulfills need for driving the enterprise

workflow, SharePoint can be used as User Interface to report progress of workflow and

ASHISH KAMDAR

Email: abnfp7@r.postjobfree.com

completion of milestones and InfoPath can be used to trigger workflow and also get users to

take various actions at intermediate stages of workflow processing. Windows SharePoint

Service adapter in BizTalk makes it very easy to connect with SharePoint and Forms services

in SharePoint makes it possible to use InfoPath in browser for those users who do not have

InfoPath installed on their desktops.

Education:

Masters in Insurance Management from Alagappa University, India

Bachelor in Computer Engineering (B.E. – Computers) from Mumbai University, India

Technical Skills:

Microsoft .net, Asp.net, Vb.net, C#, SOAP/Web Service/Xml/Xslt, MSMQ, IIS

Microsoft Visual Studio.net 2008 (.net 1.0/1.1/2.0/3.0/3.5)

Microsoft BizTalk Server 2009/2006 R2/2004/2002/2000

Microsoft SharePoint Server (MOSS) 2007

Microsoft InfoPath 2007

Microsoft Host Integration Server 2006

Microsoft SQL Server 2005

Microsoft Commerce Server 2000

Microsoft Analysis Services 2000

Business Objects 5.1

IBM MQ Series 5.1

Siebel CRM 7.7

ProClarity 4.1

Oracle 7.3

Microsoft Windows XP, 2000 & 2003 Operating System

Microsoft Visual Source Safe and Team Foundation Server

Awards & Recognition:

Presented with Best Technical Lead Award

Presented with SifyWay Award for the theme “Putting Customers First”

Presented with Customer Excellence Award

Project chosen as Best Project based on Client feedback

Project Details:

Development of Enterprise Workflows in SharePoint

Project 1:

The project involved setting up SharePoint as Enterprise Portal and

Description

development of customized workflows using Windows Workflow

foundation (3.0) and deploying them in SharePoint Server 2007. User

Interface for workflows were developed using InfoPath 2007 and were

deployed on SharePoint utilizing Forms Services so that the InfoPath

forms could be used from browser to take care of employees who did not

have InfoPath 2007 installed on their desktops. The construction included

workflows for typical enterprise functions like Leave Requisition,Travel

Requisition, Conference Room booking, Employee claims etc. The

workflows required approval at various stages which was done by sending

emails and leveraging features of SharePoint’s tight integration with

Microsoft Outlook. The workflows supported serial or parallel processing

ASHISH KAMDAR

Email: abnfp7@r.postjobfree.com

and it allowed setting of approval-timeouts, escalations and reassignment

of tasks to peers. The project also included setting up other features of

SharePoint like Document Management, Content Management,

Collaboration, Blogs, Wikis, Document and Forms Libraries and

configuring search and indexing capabilities.

Jan 09 – Nov 09

Duration

4

Team size

As a Consultant, my responsibilities included

• Gathering Business Requirements

Creation of Functional Specification Document (FSD)

Lead the team in creation of High-Level Design HLD document

Configuration of SharePoint in Development, Staging and Production

environments

Construction of artifacts in InfoPath and deployment in SharePoint

Roles & environment

Responsibilities Construction, Configuration and Deployment of Workflows using Windows

Workflow foundation

Customization of SharePoint portal according to business needs

• Configuration of Search and Document Management features of

SharePoint.

• Creation of Test plans and testing scenarios

Bug resolution and post-production support

MOSS 2007, InfoPath 2007, Office Enterprise 2007, Windows Workflow

Domain/Langua

Foundation (3.0), Windows 2003 Server, Visual Studio.net 2008, SQL

ge/OS/Tools

Server 2005, IIS (6.0)

used

Trading Partner Integration using BizTalk Server

Project 2:

This project was a prototype built for a client who is one of the largest retail

chain of stores in Sweden with a big network of vendors who supply

products. The client wanted us to develop a prototype which involved

integration with its large number of trading partners (vendors) for exchange

of Invoice information in either EDIFACT or SVEFACT formats. The

invoices data resided in clients IBM Mainframe system. The prototype

involved utilizing BizTalk Server act as a gateway for exchange of

information. It used BizTalk Adapter for DB2 along with Microsoft Host

Description

Integration Server 2006 for executing transactions on IBM Mainframe on

one side while on the other side, it utilized FTP adapter to transmit and

receive files from each trading partner. BizTalk Mapper was used

extensively for conversion from clients internal canonical format into

trading partners EDIFACT or SVEFACT formats. This project also made

use of Reliable messaging and Guaranteed delivery features of FTP

adapter.

Aug 08 – Nov 08

Duration

2

Team size

ASHISH KAMDAR

Email: abnfp7@r.postjobfree.com

This was an onsite work and as a Project Leader (Integration), my

responsibilities included

• Development of a canonical invoice format based on clients invoice data in

mainframe

Understanding EDIFACT and SVEFACT invoice formats and schemas

Configuration and setting of BizTalk adapter for DB2 to interact with

mainframe systems

Roles & Collecting business requirements for the proof-of-concept to understand

Responsibilities core functional goals of business

Technical architecture and

Developing Schemas, Maps and necessary artifacts for the solution in

BizTalk

Presentation of the prototype to clients internal technical team

Deploying the working prototype in clients environment

Creating complete documentation for the prototype

Microsoft BizTalk Server 2006 R2, EDIFACT, SVEFACT, Microsoft Host

Domain/Langua

Integration Server 2006, VisualStudio.net 2005, Windows 2003 Server,

ge/OS/Tools

SQL Server 2005, BizTalk adapter for DB2

used

HIPAA 4010 transactions with BizTalk Server in a Health Insurance

Project 3:

Product for US Government

This big US company has a product for Health Insurance domain called

Interchange. The product is primarily sold to State Governments across

United States for implementation of HIPAA transactions for Medicare and

Medicaid. This product uses Microsoft BizTalk Server for transformation of

formats from HIPAA/X12 EDI documents. The product also uses EDIFECS

Description

XEngine for validating HIPAA business rules. The transactions

implemented are 820, 835, 837 I/D/P, 270/271, 276/277. The product is

based on Microsoft .net technology and processes EDI X12 files between

the client (State government) and its Trading partners.

Mar 07 – May 08

Duration

18

Team size

ASHISH KAMDAR

Email: abnfp7@r.postjobfree.com

As a Project Leader – Integration, my responsibilities included the

following

• To follow the coding standards and guidelines agreed upon for each client

during the initial interaction phase

Assess requirements of clients and assist in pre-sales for understanding

the gap and customizations required to be done in the product for each

clients

Technical architecture and High Level design document creation

Creation of implementation plan keeping in mind clients Infrastructure

Follow technical guidelines stipulated as part of enhancement of the

product for newer versions

Allocating work to team members and helping them understand the big

picture of how their work will have a final impact on overall working of the

product

Roles & Status reports and work-item tracking for each team member

Responsibilities Communicating with team members spread in 3 different geographies (US,

Canada and India)

Regular conference calls to monitor the progress of work and mitigate any

issues or concerns with team members

Assisting the client in capacity planning keeping in mind the SLAs required

for transaction processing

Creation of test plans and test cases

Taking appropriate measures so that there is no violation of HIPAA rules

by any of the team members working on the project regarding client’s data.

Co-ordination with other teams (unix and .net) to ensure no gaps in

interfaces designed

Following up with other teams for build errors or bugs/defects reported

during the testing phase

Overall Implementation and Post-production support

Domain/Langua

Microsoft BizTalk Server 2006, EDIFECS XEngine, Visual Studio.net 2005,

ge/OS/Tools

Windows 2003 Server, SQL Server 2005, MSMQ

used

SOA-based Travel Booking Engine using BizTalk for Travel Domain

Project 4:

This project was a prototype built for a US client who has more than 60

offices in Southern California with agents providing services of booking

travel products like Air, Car, Hotel, Tour, Cruises etc. The project

demonstrated how to build a desktop-based Travel booking engine that

connects to Galileo GDS as well as with many other supplier websites with

BizTalk Server as middle-ware. The project also entailed integration with

Description

client’s internal applications like Accounting (Legacy), Customer Master

(Mainframe AS390), Marketing (Terradata), and Onyx (CRM Package).

The product communicated with Galileo GDS travel system using its

XMLSelect web service API whereas it integrated with the supplier

websites using customized OTA Standard specific documents.

Nov 05 – Oct 06

Duration

15

Team size

ASHISH KAMDAR

Email: abnfp7@r.postjobfree.com

I worked on this project as Integration Consultant (Onsite) and my

responsibilities included the following

• Responsible for requirements gathering and system design

• Study of XMLSelect to interact with online travel booking system using

their web services API.

• Collection of Business requirements for the project

Creation of Project milestones and work breakdown structure for delivery

Development of a working prototype to demonstrate successful execution

of transactions with online travel booking system Galileo

Creation of technical design document and doing code reviews

Roles & Creation of Schemas, Maps, Orchestrations in BizTalk for the travel

Responsibilities booking process

Development and execution of Unit, System, Integration, Stress and User

acceptance testing

Prepared user manuals and user-training documents

Implementing coding standards in development process as per

organization nomenclature policies

Database design and optimizations

Interaction with clients business users as well as their various agent offices

for feedback post implementation

Responsible for project implementation and support

Domain/Langua

BizTalk Server 2004, SOAP/Web Services. Asp.net, Vb.net, Windows

ge/OS/Tools

2000 Server, Xml, Xslt, SQL Server 2000, IIS (5.0)

used

EDI document interchange in a Supply Chain scenario using BizTalk

Project 5:

This client is a multi-billion dollar online retailer of software and hardware

products. It uses a legacy system running in Cobol on HP3000

environment for processing orders. This system can only export data in

flat-files. This client deals with two vendors who accept documents in EDI

formats only. These vendors have establishments in 4 different places

(Austria, Bahn, Germany, and Netherlands) hence the client needs to

generate a customized order message for each of these establishments.

The documents that exchanged are Order, Order Response and Dispatch

Advices. The client orders are required to be converted from flat-file into

Description

EDIFACT D97A standard and against an order, the vendor respond with

Order Response and Dispatch Advices which need to be converted from

EDIFACT D97A standard to flat-file formats as required by legacy system.

BizTalk Mapper was used extensively for transformation between the EDI

and flat-file format. The orders were required to be uploaded at vendors

FTP server and the responses to orders were required to be downloaded

from the vendor’s server again. Hence BizTalk FTP adapter was used

extensively for uploading and downloading of these files

Jul 05 – Oct 05

Duration

3

Team size

ASHISH KAMDAR

Email: abnfp7@r.postjobfree.com

I was working on this project as Integration Consultant and my

responsibilities were

• Analyzing the requirements and architecting and designing the system

Understanding the different types of schemas and their transformation

requirements

Creating integration interfaces for exchanging with each trading partner

Ensuring to follow the coding standards and specific file-naming

Roles & conventions pertaining to each client and their specific location

Responsibilities

• Implement the complete scenario and Coordinating with vendors to carry

out testing according to the developed test plans

• Bug resolution and fixing before final release

Implementing the solution in the production environment

Providing post-implementation support

Creation the complete documentation for the system

Domain/Langua

BizTalk Server 2004, SQL Server 2000, Windows 2000 Server,

ge/OS/Tools

VisualStudio.net 2003

used

Integration of a B2C Portal on Commerce Server with Microsoft

Project 6:

Navision ERP using BizTalk

This solution used Microsoft BizTalk Server 2004 as the middleware to

provide a loosely-coupled integration between the Commerce server

based website and NAVISION ERP for interchange of business

documents such as Sales Order, Product Catalog, Product Inventory and

various Order Status Notifications like Picking, Shipment, Delivery,

Return/Rejected etc. Navision Commerce Gateway was used for

Description

communication between Navision ERP and BizTalk Server. Complex

mapping was achieved by using BizTalk Mapper for transformation of XML

documents into different formats required by commerce server business

objects and Navision ERP system. The communication between

Commerce website and BizTalk server was done using BizTalk Http

adapter

Feb 05 – May 05

Duration

7

Team size

As a Integration Consultant in this project, my responsibilities included

• Business requirements gathering

System and technical architecture and design

Creation of Functional specification and High level design documents

Creation of technical artifacts according the organization standards

Understanding the integration architecture of Navision

Design of interfaces for integration with other systems

Roles &

Construction of the system along with Unit, System and Integration testing

Responsibilities

carried out periodically

Configuration of the working system in Staging and Production

environments

Pre-production readiness and roll-out

Post-production support

BizTalk Server 2004, Commerce Server 2002, Navision 4.0, Asp.net,

Domain/Langua

Vb.net, Windows 2000 Server, SQL Server 2000, Visual Studio.net 2003,

ge/OS/Tools

IIS (4.0)

ASHISH KAMDAR

Email: abnfp7@r.postjobfree.com

used

Enterprise Application Integration using BizTalk Server

Project 7:

This project was done for a major pharmaceutical company in India and

involved using BizTalk server for file-based integration of applications

present at various locations. The client had 5 manufacturing facilities and 3

offices all interconnected on a WAN. All these locations were using the

same application but maintaining their own copy of data and there was no

interchange of data between them. This made it difficult to get the real-time

consolidated reports and there was no accurate planning and forecasting

Description

happening which resulted in lot of indirect losses in inventory, warehouse

and production. Here BizTalk Server messaging features were

implemented to achieve integration between all the applications of the

enterprise. BizTalk Server was used as a centralized document exchange

gateway and features like Guaranteed Delivery and Scheduled

interchange were used to enable exchange of information in the non-

business hours in order to optimize the use of bandwidth

Oct 04 – Dec 04

Duration

2

Team size

As an Integration Architect in this project, my duties were as follows

• Analysis of customer requirements

Studying of customers network architecture and type and frequency of

different types of data flowing among them

Design a solution to optimize and regularize this flow of data

Construction of artifacts in BizTalk according to design

Configuration and Installation of BizTalk Server and its associated

Roles & components

Responsibilities Creation of Technical documents

Planning for Staging and Production environments

Implementation of test plans and test cases as per the plans

• Planning for Go Live and Coordinating with personnel’s and various

locations

• Post-production support and defect resolution

Domain/Langua

Windows 2003 Server, BizTalk Server 2004, ASP, COM, VB 6.0, Visual

ge/OS/Tools

Studio 2003, SQL Server 2000

used

Business Intelligence reporting using OLAP and Business Objects

Project 8:

for a Travel company

This project was for a domestic travel company. The client had a

client/server based applications for doing travel bookings and data for that

was recorded in a SQL Server 2000 database. The work involved doing

and Extract-Transform-load (ETL) to load this data into an OLAP database

Description

based on Ms Analysis Service 2000 and then using Business Objects as

front-end to generate reports. The solution gave the client ability to do

dynamic and ad-hoc reporting as well as enabling the slice-and-dice facility

to look at reports of various timeframes and determine business trends.

Jun 04 – Aug 04

Duration

ASHISH KAMDAR

Email: abnfp7@r.postjobfree.com

2

Team size

As a B.I. Consultant, my responsibilities included

• Technical analysis and design recommendations for application

development

• Requirement analysis and system and Olap database design

• Design of ETL artifacts and their periodicity and granularity determination

Scheduled configuration of data transfer from OLTP SQL Server database

to OLAP Analysis service database

Roles & Generation of cubes for data aggregation

Responsibilities Construction of reports using Business Objects front-end

Optimization of data aggregations in the cube for optimum performance

while reporting

Presentation of the solution and training to each business users

Incorporating feedback and resolving defects and errors reported by users

Configuration and Implementing of the solution on each users desktop

Creation of User manual and system documentation for the project

Domain/Langua

Business Objects (5.1), MS Analysis Service 2000, DTS, VB 6.0, SQL

ge/OS/Tools

Server 2000

used

Backward Supply chain integration solution for Trading Partners

Project 9:

The client is a premier Healthcare product manufacturing company and it

deals with a very big number of suppliers who supply them raw materials

or finished products. In order to tune its manufacturing process in

synchronization with its suppliers, it needs to know the Delivery Schedules

and Dispatches of when the suppliers are going to supply. The ERP

system also maintains centralized updated copy of data like Artwork,

Product Specifications and Payments which need to be disseminated to

Description

the suppliers on periodic basis. Hence a web-based portal was developed

which allowed the suppliers to upload the data in excel formats as well as

download the product and payment information which got updated

everyday in SAP. Additionally the system also allowed the client as well as

the Suppliers to set alerts which were sent as emails. This project helped

the client to optimize its backward supply chain process which led to good

benefits.

Feb 04 – May 04

Duration

5

Team size

I was a Project Leader for this project and my responsibilities involved

• Business requirement gathering and documenting

Design, develop, implement and deploy artifacts related to asp.net website

Testing the flow of data from and to clients ERP system

• Coordinating with clients ERP team to agree on data formats and file-

Roles &

naming conventions

Responsibilities

• Configuring the solution on Test, Staging and Production environments

Interacting with vendors to resolve issues or problems related to system

usage

Document the complete system and create user manuals to disseminate to

vendors who are going to be using this system.

Asp.net, C#, SQL Server 2000, VisualStudio 6.0, IIS (4.0)

Domain/Langua

ASHISH KAMDAR

Email: abnfp7@r.postjobfree.com

ge/OS/Tools

used

Messaging-based integration using IBM MQ Series between

Project 10:

mainframes and remotely hosted website

This apex bank of India allows banks to buy and sell Government of India

bonds (GOI bonds) daily. This are traded like an exchange where

everyday a lot of buying and selling happens and the prices change every

second. These transactions are carried out in the Mainframe AS390

system at clients office. These transactions needed to be reflected on the

website which was hosted with an ISP at remote location. This was

achieved by using an MQ series bridge between the two locations and the

Description

data was transmitted with the delay of less than a minute between the

transaction taking place in mainframe and the data appearing on the

website. MQ series channels and queues were set up for transmission of

different categories of bonds The project involved learning, installing,

configuring and setup of MQ series software at both locations and

configuring it to work with AS390 mainframe system

Nov 03 – Jan 04

Duration

4

Team size

As an Integration architect, my responsibilities included

• Analyze the data transfer requirements and protocols required for data

transfer

Analyze the security, performance, authentication and QoS requirements

for the solution

• Installation and configuration of MQ Series software at both end of

transmission channel

Setup of channels and queues on both sides

Roles &

Construction of modules in website for interfacing with IBM MQ series

Responsibilities

channels and queues

• Setup of website at remote Isp location

• Perform Unit testing, System testing, Integration testing and User

acceptance testing

Monitoring the flow of data and ensuring the SLAs are met by the

implemented solution

Post-production support and documentation

Domain/Langua

IBM MQ Series (5.1), Asp, SQL Server 2000, VB 6.0, Windows 2000

ge/OS/Tools

Server

used

A B2C portal for ordering DVD/VCD for US/UK/India geographies with

Project 11:

online payment gateway integration

This project involved development of a B2C portal which could be used for

Description

Selling or Renting DVD/VCD on ownership or Pay-per-view basis. The

website included registration module for new user and then hosted a huge

catalog for customers to choose from. There were additional options

available to maintain a list of favourites or alerts of various types like Price,

Availability or discounts. There was an integration with 3 payment

gateways for online payment options (US-Paypal, UK-Barclays & India-

ASHISH KAMDAR

Email: abnfp7@r.postjobfree.com

ICICI Payment Gateway)

Feb 03 – Sep 03

Duration

8

Team size

As a Project Leader, my duties included the following

• Business requirements gathering

Creation of FSD and URD documents

Technical architecture and design of system

Roles &

Construction of the system

Responsibilities

Testing on Staging and Production environments

Post-Production support

Domain/Langua

Asp, COM, MTS, VBScript, JavaScript, IIS(5.0), SQL Server 2000,

ge/OS/Tools

Windows 2000 Advanced Server

used

A Loyalty Management Portal for a UK firm offering

Project 12:

Benefits/Incentives services

A portal for UK client to provide Benefits/Incentives services to companies

by way of a Shopping site. The portal runs as Application Service Provider

(ASP) and hosts a catalog of products that can be bought by employees of

companies who are members of this portal. The portal had to also

Description

integrate with other existing legacy systems on AS390/DB2,

Maconomy(Accounting Package), Credit Card Processing System as well

as with 3rd party sites using Socket Connection over web

Jan 02 – Oct 02

Duration

9

Team size

As a Project Leader my responsibilities were

• Understanding business and technical requirements

Creating High-level and low-level requirements and design documents

Creation of use cases and test plans

Database schema design

Design of modules and components

Roles &

Delegating work to team members and setting up code version control

Responsibilities

procedures

Construction of overall system

Responsible for Unit testing, system testing, UAT testing

Production (Go Live) planning and co-ordination with clients other system

personnel’s

Post-production support

Domain/Langua

Asp.net, C#, .Net framework 1.0, SQL Server 2000

ge/OS/Tools

used

A B2C portal for a UK Travel publication company

Project 13:

This client is a major travel publication company based in UK and they

Description

publish a lot of travel-related publications like Maps, Timetables, and

Schedules on a periodic basis. This B2C portal allowed users to buy these

publications using a shopping cart and online payment facilities. The site

also allowed the client to provide monthly/yearly subscriptions to its

ASHISH KAMDAR

Email: abnfp7@r.postjobfree.com

registered users as well as offering various types of discounts. Having a

user-base of registered members also allowed the client to enhance its

marketing campaigns on its Travel products and services

Sep 01 – Dec 01

Duration

3

Team size

I was serving as Project Leader in this project and my responsibilities

included

• Design and Develop and Implement and n-tier website based on Microsoft

architecture

Prepare User manuals and system documentation

Roles &

Technical System and Database schema design

Responsibilities

Create queries, stored procedures and triggers in SQL Server

Implementation of system at clients onsite office and carry out testing

onsite

Domain/Langua

ASP.Net, VB.Net, .Net Framework 1.0, JavaScript, SQL Server 2000,

ge/OS/Tools

VisualStudio 2000

used

Implementation of Rosettanet standard (RNIF 1.1) using BizTalk

Project 14:

This project was a proof-of-concept to check the usability of Rosettanet

accelerator for BizTalk for one of the leading motherboard manufactures

belonging to Electronic Component (EC) industry. The client dealt with a

big number of vendors for its business of manufacturing motherboards and

wanted to establish a standardized business process and common formats

for dealing with its vendors. The project involved studying the BizTalk

Description

Rosettanet kit and identifying the Partner Interface Processes (PIPs) that

needed to be implemented for the client using BizTalk Server. The project

made extensive use of Xml/XSl and all the messages that were exchanged

between the client and it vendors were Rosettanet Framework 1.1

compliant (RNIF 1.1). Three PIPs that were used are 3A2, 3A4 and 3A7

May 01 – Aug 01

Duration

5

Team size

As a Team Leader, I was responsible for

• Analysis, Design, Develop, Test and Deploy the system

Roles & System Documentation

Responsibilities Testing

Post-production support

Domain/Langua

BizTalk Server 2000, SQL Server 2000, Rosettanet Accelerator for

ge/OS/Tools

BizTalk, Windows 2000 Server

used

Development of an Auction Engine for a steel vortal

Project 15:

This project involved development of a trading portal for carrying out

Description

transactions in steel industry by means of Auctions (Item auction, Capacity

auction, LOT auction and Secondary auction), Reverse Auctions and

RFQs. The portal also consisted of other functionality like Closed-User

ASHISH KAMDAR

Email: abnfp7@r.postjobfree.com

Group Auctions, Auction Targeting, Auto-Bidding, Channel Strip(a

downloadable plug-in on desktop showing latest Auction Prices), Auction

Expiry, Preferred Partner Interfacing, Dynamic Product Configuration etc

May 00 – Apr 01

Duration

15

Team size

As a Team Leader, my duties include the following

• Analysis, Design, Develop, Test and Deploy the system

System Documentation

Roles &

Testing

Responsibilities

Post-production support

Domain/Langua

Active Server Pages (ASP), COM, MTS, Oracle (7.1), IIS (5.0)

ge/OS/Tools

used

_______



Contact this candidate