Sql Server Project

[pic] [pic]

Name : Pankaj R Darure

Present Address : **** ****** ***** ****, *** 523, Houston, TX, USA.

Contact No : +1-713-***-**** (cell)

Email : ******.******@*****.***

Date of Birth : Oct-02-1974

SUMMARY

. Total Experience : 11.5 Years (Since July' 98)

. Experience (IT) : 10 Years (Since Sept' 2000)

. Experience (Functional) : 1.5 years

. Current Designation/Role : SharePoint Technical Architect/Lead

Developer

. Skill Sets : MOSS 2007, SharePoint Portal Server 2003,

ASP.NET, C#, jQuery, VB / ASP,

COM / DCOM, MTS / COM+, SQL Server 2005, Oracle

8/i.

. Skill set Details : Massive Deployments (2000 Site

Collections, 18000 sites), Developing Custom

Master Pages, Custom Site

Definitions/templates, List Definitions, Site

Columns, Content Types, Advanced Search/Managed

properties, custom web parts/web controls,

Features Stapling, Event Handlers, Event

Receiver Assembly Features, Cross-Site

Collection lookup and cascading dropdown

metadata using jQuery, SharePoint Timer Jobs,

Solution Deployment packages (.WSP), SPS2003 to

MOSS 2007 content migration, MOSS/WSS Object

Model, InfoPath forms development, Workflows,

Single Sign On using SiteMinder using custom

HTTP Module, Dual Authentication using AD/LDAP

etc

CERTIFICATIONS

MCP (.Net) : Microsoft Certified Professional

MCAD (.Net) : Microsoft Certified Application Developer (070-315,

070-316, 070-229 and

070-320)

EDUCATIONAL QUALIFICATION

Year Degree College/University Percentage/CGPA

2000 Post Graduate Boston's Computer 86%(Distinction)

Diploma in Software Institute, Mumbai,

Application India

Engineering

1998 M.Tech. (Textile Anna University, 8.71 CGPA*

Technology) Chennai, India (Distinction)

1996 B.Tech. (Textile Shivaji University, 66 % (Distinction)

Technology) Kolhapur, India

1992 H.S.C. (XIIth) Pune Divisional 89 % (PCM)

Board, India (Distinction)

1990 S.S.C. (Xth) Pune Divisional 85 % (Distinction)

Board, India

* 1 CGPA is equivalent to 10 %

. Successfully achieved Microsoft Certified Application Developer

(MCAD.NET).

. Completed M.TECH. (Master of Technology) with Distinction from Anna

University, Chennai, India in 1998 securing 8.71 CGPA out of total CGPA

of 10 (1 CGPA is equivalent to 10 %).

. Qualified all India entrance GATE-96.

. Secured the First rank in the first as well as the second semester of

M.Tech.

. Secured the First rank in the Shivaji University during the second year

of B.Tech. course.

. One of the Top Five university rankers throughout the B.Tech. (Bachelor

of Technology) course.

. Recipient of the Best Student Award in B.Tech.

. Completed B.TECH (Distinction) from Shivaji University, Kolhapur,

Maharashtra, India in 1996.

PROFESSIONAL TRAINING

. Successfully completed 6 months Full Time Post Graduate Diploma course in

"Software Application and Engineering" at Boston's Computer Institute,

Mumbai.

. Undergone professional training in Basic Java and Enterprise Java by

Synergetics Information Technology Services (India) Pvt. Ltd.

. Attended many Microsoft's training sessions at various places related to

the technologies I'm working on i.e. ASP.NET, C#, SharePoint Portal

Server 2003, MOS 2007, SQL Server 2000, SQL Server 2005.

TECHNICAL SKILLS

Operating Systems : Windows'95,'98 and Windows NT, 2003

Front End Tools : ASP.NET, VB6.0, ASP, JDK1.3

Code Behind : C#

Middle Tier : COM / DCOM (ActiveX DLLs)

Technology : MS Office SharePoint Server (MOSS) 2007,

SharePoint Portal Server (SPS)

2003

COM+ (WIN 2000)

RDBMS : Oracle 8/i, SQL Server 2000, SQL Server 2005

Other Tools Used : Microsoft Office SharePoint Designer 2007,

Microsoft Office InfoPath 2007, Rational XDE.NET 2003, ERWin, TOAD (Tool

For Oracle Application Developers)

Past Work Experience

1. Worked with an Indian IT Giant Wipro Technologies as a SharePoint

Specialist/Architect. (Feb 2004 to Sep-2008 i.e. 56 months). Wipro

Technologies is a 98000 employee IT Consulting firm.

Profile : Involved in all phases of a project life cycle

including Requirements Gathering, Design, Development and Implementation

for customization/configuration of MOSS 2007 portal with custom

SharePoint components including the SharePoint object model and inbuilt

features like Content Types, Site/List definitions. Master Pages, Page

layout, Features and Microsoft preferred deployment methodology like

Windows Solution Package Deployment.

2. Worked with Datamatics Ltd., Mumbai, as Associate Software Consultant in

Software Development Dept. (Sep-2000 to Jan-2004 i.e. 41 months)

Profile : Involved in Software Design (Rational XDE.NET

2003, ERWin) and Development, testing and debugging, preparing reusable

components, preparing Component Specifications and Component Test

Plans, integration of various modules in the project etc.

3. Worked with one of the top textile companies of India, Bombay Dyeing &

Mfg. Co Ltd., Mumbai, as a Purchase Executive in Materials Management

Dept. (July-1998 to March-2000 i.e. 18 months)

Profile : Involved in Materials Management and Purchase

activities.

PROJECTS UNDERTAKEN:

1. MOSS 2007 deployment and customization for Shell, USA

Title : Development and customization of MS Office SharePoint

Server (MOSS) 2007 for Shell, USA

Client : Shell, USA

Duration : Sept 2008 - Till Date (25 months till date).

O/S : Windows Server 2003

Tech. Details : MS Office SharePoint Server (MOSS) 2007 (including

object model), Windows SharePoint

Services 3.0, Visual Studio 2008

Database : SQL Server 2005.

Description : Cri-Criterion, a division of Shell, decided to

start using Microsoft SharePoint Portal Server (one of the worldwide best

selling product by Microsoft) for all content management purposes.

Considering all Customers, all Locations under each Customer, all Units

under each Location and at least a Cycle for each Unit, the total number

of SharePoint sites are around 18000. Each site is customized to suit the

business needs and is fully loaded with many automated customized

components including, but not limited to, necessary Site Columns, Content

Types, List Definitions, Site Definitions, Site Permissions Levels,

complex web parts, automated metadata assignment using event handlers,

SharePoint Timer Jobs, Bulk Site Creation tool, Bulk Site Update Tool,

jQueries etc. I have heavily used SharePoint Object Model (also called

APIs) in most of my projects.

I, as a sole Architect and Developer, designed and developed the whole

portal (with 18000 sites) including all its components, while making sure

to follow Best Practices suggested by Microsoft and Org level standards

depicted by the parent company Shell. The deployment is in the form of

Solution Package which is the only suggested technique by Microsoft for

multi-server SharePoint farms. I am also involved in meeting customers

i.e. end users to understand their requirements which I translate into

Technical Design Documents before starting the actual development.

Team Size : currently 3 onsite

Role : Onsite Architect, developer and support.

2. MOSS 2007 deployment and customization for PepsiCo, USA

Title : Development and customization of MS Office SharePoint

Server (MOSS) 2007 for PepsiCo, USA

Client : PepsiCo, USA

Duration : March 2008 - Sept 2008 (3 months till date).

O/S : Windows Server 2003

Tech. Details : MS Office SharePoint Server (MOSS) 2007 (including

object model), Windows SharePoint

Services 3.0

Database : SQL Server 2005.

Description : PepsiCo decided to use MOSS 2007 as their Team

Collaboration Portal. PepsiCo has an existing implementation of LDAP

(Java IDx) as well as MS Active Directory. Most of the internal

applications use LDAP Authentication as part of Single Sing On using Site

Minder. I have implemented SharePoint as a Dual Authentication approach,

one using Windows Authentication with AD and the second using Form Based

Authentication against LDAP. I have also configured the LDAP SharePoint

web application to take part in the existing SSO (Single Sign On)

environment. I have created a custom MasterPage for PepsiCo Branding and

have used the Solution Deployment Technique, which is a preferred

deployment technique as suggested by Microsoft, which automatically takes

care of the deployment on the multiple WFE servers within the farm. I am

also involved in an InfoPath form development and a custom workflow using

VS.Net 2005. I have used Feature Stapling technique to Activate the

Custom MasterPage Feature on the OOTB Site Definitions. I have used Event-

Receiver Assembly Feature to apply the Custom MasterPage to the newly

created Sites automatically. I have implemented a common Global

Navigation (horizontal) across multiple Site Collections.

Team Size : currently 1 onsite

Role : Onsite Architect, doing frequent interaction with

client.

3. MOSS 2007 customization for Autodesk, USA

Title : Development and customization of MS Office SharePoint

Server (MOSS) 2007 for Autodesk, USA

Client : Autodesk, USA

Duration : July 2007 - Feb 2008 (8 months).

O/S : Windows 2003

Tech. Details : MS Office SharePoint Server (MOSS) 2007 (including

object model), Windows SharePoint

Services 3.0

Database : SQL Server 2005.

Description : Autodesk has decided to go for MOSS as their

intranet portal for knowledge management. In this project I played a role

of Architect as well as tech lead/project lead from offshore. We created

custom Master Page, custom page layouts using Microsoft preferred ways.

We have used techniques like "Feature Stapling" for automatic activation

of some custom Features when a new site is created from an OOTB site

definition. We have used advanced techniques like "Event Receiver

assembly" so that we can execute our custom code immediately after our

custom Feature gets activated using the above mentioned Stapling

technique. We are customizing the MySite layout (without touching the

OOTB site definition) and developing some custom RSS reader web parts

which can pull different News articles to display on the MySite based on

the logged in user's Department from the User Profile Database. We used

FxCop to enforce Microsoft coding standards.

We have developed a "Site Migration tool" which can migrate Site

Collections from SPS2003 platform to MOSS 2007 platform with the help of

only a few button clicks. Our tool internally uses SharePoint object

model as well as command line utilities like PRESCAN, STSADM and

SMIGRATE. We have received a lot of appreciation from client for this

tool because this tool has helped everybody to reduce the manual complex

Content Database Migration process to a very simple UI based desktop

application. The tool internally restores the site collections in a

separate content database on the intermediate server before migration and

eventually backs-up the MOSS content database so that this can be

shipped/restored on the PROD MOSS farm.

Team Size : 4 (offshore) + 1 onsite

Role : Offshore Architect as well as project lead/manager,

doing frequent interaction with client.

4. MOSS 2007 customization for Microsoft, Belgium

Title : Development and customization of MS Office SharePoint

Server 2007 for Microsoft, Belgium office.

Client : Microsoft, Belgium

Duration : Apr 2007 -Jun 2007

O/S : Windows 2003

Tech. Details : MS Office SharePoint Server (MOSS) 2007

Database : SQL Server 2005.

Description : Microsoft, Belgium decided to outsource/subcontract

their MOSS 2007 customization project to Wipro. During this project, we

created custom site columns, custom content types, custom List

definitions, custom Document Library definitions, custom image library

definitions and custom Site definitions using Microsoft's preferred

methodology/technology. We deployed all these as Features. We created

solution deployment package (.wsp) while sending the deliverables to

onsite because it is the most preferred way of SharePoint solution

deployment suggested by Microsoft.

Team Size : 3 (offshore)

Role : Offshore Architect as well as project lead/manager, did

everyday interaction with client.

5. SharePoint Portal Server 2003 customization for National Grid, UK

Title : Development and customization of SharePoint Portal

Server 2003 for National Grid, UK office.

Client : National Grid, UK

Duration : Aug 2006 - Mar 2007 (7 months)

O/S : Windows 2003

Tech. Details : SharePoint Portal Server 2003 (including object model),

ASP.NET (C# as code behind)

Database : SQL Server 2000.

Description : National Grid decided to go for SharePoint Portal

Server as their intranet portal which will be replacing their legacy ASP

based intranet portal. NG has given this contract to my employer i.e.

Wipro Technologies. In this project, my role is interacting with the

client/users on day to day basis to understand the functional

requirements, convert those into the technically detailed explanation for

the offshore team so that these requirements can be implemented in the

form of either configuration or customization, using FrontPage 2002 as

well as interacting with the offshore team on a daily basis to discuss

the requirements and various ways to implement those considering pros and

cons. Before delivering the components developed by the offshore team,

testing it thoroughly and finally delivering it to the client side

servers.

Team Size : 6 (offshore)

Role : Onsite coordinator and Technical Lead.

6. Health Care Live Demo for Microsoft using MS Office SharePoint Server

(MOSS) 2007

Title : Development and customization of SharePoint Portal

Server 2007 for a Microsoft Demo.

Client : Microsoft, USA

Duration : May 2006 - July 2006(3 months).

O/S : Windows 2003

Tech. Details : SharePoint Portal Server 2007 BETA (including object

model), ASP.NET (C# as code behind)

Database : SQL Server 2005.

Description : Customizing MOSS 2007. Developed Custom Web parts

and integrated the web parts developed by other team members with the

actual Health Care Portal. Modified Master Pages to change the look and

feel of the Out of The Box pages. Integrated Knowledge Network with

SharePoint Server to enable the people search based on the Keyword,

Internal people and External People search. Created and deployed a report

using SQL Server Reporting Services.

Team Size : 8 (offshore)

Role : Technical Lead.

7. Customization of SharePoint Portal Server 2003 for Morgan Stanley

Title : Development and customization of Sharepoint Portal

Server for Morgan Stanley.

Client : Morgan Stanley, USA

Duration : December 2004 - April 2006 (approx 17 months), 3 months

onsite (Morgan Stanley NY office).

O/S : Windows 2003

Tech. Details : Sharepoint Portal Server 2003 (including object model),

ASP.NET (C# as code behind)

Database : SQL Server 2000.

Description : As a core member of prestigious Sharepoint

Engineering (SPENG) group which provides the third level (L-3) of support

to the Sharepoint Infracture in Morgan Stanley.

The project includes customizing out of the box behavior of Microsoft

Sharepoint Portal Server to suit the requirements of Morgan Stanley. For

this I have developed certain key server controls (.ascx) and

AdminWebparts using Sharepoint Object Model, which are placed on the

pages. At the same time, I have also developed certain .aspx pages to

replace the existing pages provided by Microsoft as the current pages

were lacking some important functionalities required by Morgan Stanley.

The controls developed by me have replaced the out of the box controls

provided by Microsoft because Morgan Stanley requirements were not

getting fulfilled with the existing controls.

Team Size : 3 (offshore)

Role : Offshore team lead and sole owner of critical custom

components like Admin web parts, Navigation web controls, Site/Area

creation work flow. Gathering the client requirements, (onsite) Design,

Development and Testing- Designing system architecture and reusable

components. Writing test plans for the server components and pages

developed by me.

8. Web Site Development (as an employee of Wipro Technologies, Pune)

Title : Automation of HR management System.

Client : 3SG Corp, USA (Final client: SOS i.e. Secretary of

State, Ohio State, USA)

Duration : February 2004 - November 2004 (10 months)

O/S : Windows 2000

Tech. Details : ASP.NET (C# as code behind)

Database : SQL Server 2000.

Description : The project includes automation of complete HR

department which includes three modules viz. HR system, Performance

Appraisal System and Leave-payroll system. HR module consists of employee

maintenance related activities. PAS (Performance Appraisal System)

consists of entire Annual and Probationary Appraisal flow right from HR

personnel and employees to supervisors. Leave Balance & Payroll system

consists of all activities related to leave balances, leave

application/modification/cancellation, leave approvals at two levels,

online attendance recording/updating etc.

Team Size : 7

Role : Design, Development and Testing- Designing system

architecture and reusable components. Testing and debugging of the Leave

module. Preparing Component specification and Component test plan

document for the leave module. Written a large number of Database Stored

Procedures (SPs) in SQL Server 2000 following modular-reusable approach.

9. Web Site Development (as an employee of Datamatics Ltd. SEEPZ, Mumbai)

Title : Canon Online Examination System (e-learning).

Client : Canon, UK

Duration : August 2002 - January 2004 (18 months)

O/S : Windows 2000

Tech. Details : ASP.NET (C# as code behind), deploying .NET components

in COM+, Rational

XDE.NET 2003 for preparing class diagrams/sequence

diagrams, ERWin for database designing.

Database : SQL Server 2000.

Description : Canon (UK), European Division is establishing web

based e-learning portal for training and assessing their employee's

worldwide. The Portal has primarily 5 modules namely the Administration,

Membership Management, Course, Assessment and Reports Module

respectively.

The Administration Module deals with the handling of master's data. All

modules use this data to perform inter/intra modular transactions.

The Membership Management deals with the user management. The

administrators can view and add users to their respective groups. The

administrator can search users based on their current competency levels.

The users can view and update their profiles.

The Course Module deals with the handling of course registrations by

users and progress tracking mechanism of the users by their respective

superiors. The system facilitates the Administrator to mentor their

subordinates and also supports a tracking mechanism for checking the

progress of the subordinates. The Course Module also handles the

management of the Course Material and how it has to be assigned to the

users for assessing. The Course Module is SCORM compliant, the

specification suggested by the e-learning consortium.

The Assessment Module primarily deals with the Assessment creation and

its maintenance. It allows the administrators to create various

assessments based upon the type of courses and system requirements.

Using the Reports module, wide range of reports like User mark sheets,

certification and broad statistical analysis monthly reports can be drawn

out which provide details about the percentage progress of individual

users located in distinct locations and many more.

Team Size : 20

Role : Design and Development - Designing system architecture

and components considering design patterns suggested by Microsoft.

Preparing Component specification and Component test plan document.

Presently leading a team of two developers.

10. Web Site Development (as an employee of Datamatics Ltd. SEEPZ, Mumbai)

Title : CDB BUPA.

Client : British United Provident Association, UK

Duration : February 2002 - July 2002 (6 months)

O/S : Windows NT

Tech. Details : ASP, COM/DCOM, MTS/COM+

Database : Oracle8.

Description : The current competitor's database application has

the functionality to compare products but caters only to the PMI (Private

Medical Insurance) market sector in the Health & Care Funding Business

Unit. This project has been initiated to expand the current competitor

database on the BUPA intranet. The new system will cover market sectors

and competitors relevant to Wellness, Hospitals and Care Services, and

other UK Membership product sectors. It will also be flexible enough to

allow further modules to be added as BUPA continues to expand its

Business Units or Market Sectors.

Team Size : 15

Role : As a programmer/developer performed the following tasks

. Development of prototype screens in HTML.

. Development using ASP 2.0 for communication with XMLRPC server,

writing of stored procedures in Oracle.

11. Web Site Development (as an employee of Datamatics Ltd. SEEPZ,

Mumbai)

Title : Onpoint Enterprise.

Client : ORION, Canada

Duration : November 2001 - January 2002 (3 months)

O/S : Windows 2000

Tech. Details : ASP, COM/DCOM deploying components in COM+ (MTS)

Database : Oracle8i.

Description : OnPoint Enterprise is a web-based tool. It is a

part of Orion's OnPoint Suite of products. OnPoint-Enterprise is being

developed using ASP, COM and Java applets. It is a component-based,

extensible web GIS application providing geo-processing capabilities. It

provides for powerful spatial query, display, analysis and map printing

functionality. OnPoint-Enterprise is fast, user-friendly, and feature-

rich.

Team Size : 3

Role : Programmer-Involved in coding of ASP and COM using

Oracle as the back-end.

12. Application Development : (as an employee of Datamatics Ltd. SEEPZ,

Mumbai)

Title : Financial Planner.

Client : ECLIPTEC, Germany.

Duration : August 2001 - October 2001 (3 months)

O/S : Windows 98/NT

Tech. Details : JDK 1.3 and Graphics Tool (Infragistics PVChart).

Database : Oracle8.

Description : The system helps financial consultants for

calculating monthly pension during the retirement period of their

customers. System uses base values of the customer like income, age, tax,

and marital status, wished pension, all investments in securities,

government pension schemes and computes the pension. If there is

difference between wished income and calculated pension, then system

suggest different ways of investments (investments in stocks, in saving

deposits, in properties), which can be made to come to the wished income.

Team Size : 3

Role : Programmer - Involved in developing common reusable

components, designing GUI and testing the components for all possible

bugs.

13. Application Development (as an employee of Datamatics Ltd. SEEPZ,

Mumbai)

Title : Automation of Visakhapatanam Post Trust.

Client : Visakhapatanam Post Trust, Visakhapatanam, AP.

Duration : September 2000 - July 2001 (11 months)

O/S : Windows 98/NT

Tech. Details : VB6.0, ASP, COM/DCOM deploying components in MTS.

Database : Oracle8.

Description : Project includes full automation of different

systems of Port e.g. Port Operations, Railway Operations, Personal,

Finance and Material Management Systems. The Materials Management Module

(which was handled by me) includes automation of most of the time-

consuming manual processes like raising an indent, online verification

and approval of the same from the superiors, automatically forwarding the

indent to purchase department if the store manager confirms the non-

availability of the goods stock being requested, to amend the purchase

order, send the purchase order/amendment in the form of crystal report

(Seagate), to maintain the stock of inventory, accept/reject goods,

approve/reject the payment for these goods and other related activities

like goods issue, accept the returned goods from the various departments

etc.

The project was based on the three tier, client-server architecture.

Team Size : 4

Role : Module Leader - Involved in designing forms and classes

in VB using ActiveX dlls. During implementation (On Site), interacted

with the client and successfully received acceptance. Also involved in

assigning tasks to team members and collecting deliveries from them on

the timely basis for the complete integration.

Contact this candidate