Post Job Free

Resume

Sign in

Project Sql Server

Location:
Ahmedabad, GJ, India
Salary:
2500
Posted:
October 17, 2013

Contact this candidate

Resume:

Mukesh Kumar Ajmera [pic]

*/* **** **********,

Subhashnagar, Girdharnagar

Shahibaug, Ahmedabad, Gujarat,

IN.

E-mail:

ab99u3@r.postjobfree.com

Skype ID : mukeshajmera78

Mobile No: +91

989-***-****

CAREER OBJECTIVE

I intend to build a career with a corporate with committed and

dedicated people where my qualities of a fast learner and ability to take

new challenges can be used. This will help me to utilize my abilities,

enhance my skills and realize my potential, thus in turn providing

professional growth in a resourceful, innovative and flexible working

environment.

EXPERIENCE SUMMARY

7+ years in Software development

. Working at Gateway Techno labs Pvt. Ltd as Sr. Analyst

Programmer since May 1, 2007

. Worked at IndiaNic InfoTech Ltd as a software engineer from

April 2005 to April -2007

. Having working knowledge of various Microsoft technologies [Share

Point 2013/2010, MOSS 2007, NET 2.0 & 3.5, CRM and SQL server].

. Extensively worked on Share Point 2013/2010,MOSS2007 and WSS 3.0

. POST Graduation in MCA from Gujarat University in 2005

. GNIIT from NIIT

Certification

. Microsoft Share Point 2010, Application Development (70-573)

. Microsoft Share Point 2010, Configuring (70-667)

Domain Exposure/Skills

Software

Languages Proficient in: Share Point 2010, MOSS 2007, WSS 3.0, ASP .NET, C#

.NET and CRM.

Familiar with: Ajax, JavaScript, WCF, Silver light, HTML, XML,

XSL, BizTalk, CSS, C++ and C.

Database Microsoft SQL Server, Microsoft Access, Oracle and MySQL

PROJECT EXPERIENCE

Project Name Content Management System

Duration 6 months on-going

Project The current project is the content management system.

Description The different SharePoint customization like, master

page customization, page layouts creation, web part

customization, creation of site based on the site

templates, custom actions, creation of search query,

configuration of search web parts and refinement web

parts in different pages based on the search query,

event receivers,feature receivers, cross publishing

content types,timer jobs, CSS, JavaScript, jquery

metadata properties and fields etc..

I have also configured the user profile service and my

sites and created the feature stapling for the site

master pages.

In some functionality I also need to do integration of

CRM with SharePoint for the document adding

functionality from CRM to SharePoint 2010, I created the

WCF service for the communication.

In the current project client is used the MS-project to

create the tasks in SharePoint and published the tasks

in the SharePoint tasks list. So we have also used the

PWA (Project Web Access) site with SharePoint 2013.

I have also created the sandbox solution for the web

part customization of the task aggregation from

different site using SPSiteDataQuery in office 365

solution.

My responsibilities are also to deploy the solution on

the client environment using PowerShell.

In this project i have also done the content database

migration of SharePoint sites from SharePoint 2010

preview version to SharePoint 2013 RTM version.

I have also migrated the term store content database

from SharePoint 2013 preview version to SharePoint RTM

version.

Creation of deployment documents and functionality

documentation

Responsibilit Senior Analyst Programmer

y

Main Configure MS-Project with application

Challenges Configure search on claim base authentication

application

Tools and Office 365, SQL Server 2012, SharePoint 2013, Visual

Technologies Studio 2012, MS-Project Professional.

Project Name Document Center SharePoint Portal

Duration 7 months

Project Document center SharePoint portal is basically

Description managing the documents among the users on the internet

site. There are different types of users.

The external users (users of the customers of client)

will login to the application via FBA. The external

users will be able to access the account folders to

which they are mapped. The external users will only have

read only access to the folders. They will be able to

download the files uploaded in the account folder

structure. The external users can also register to the

application on internet once they pass through the

validation process. In the validation process the

external user is mapped to the account folder.

The external users and the application activities are

managed by CSR users. They are also FBA users. They are

created by the admin user. They also access the

application over the internet. They can create the

external users. They are associated to the accounts

during their creation. They can upload files to the home

folder of the account folder structure.

The admin user will manage the SharePoint application

and the environment.

Client will upload the files - invoice files and the

user registration files to the FTP server in a batch.

Currently there are two batches per month. The user

files will be read and the database will be updated

accordingly. The zip files for the invoices will be

unzipped to the first level and uploaded to SharePoint.

After approval, the files will be made available under

the account folders and will be visible to the external

users.

Key features :

Read files from FTP server and upload to SharePoint

document library.

Login with application using claim based authentication

(from base authentication) with respectively privileges.

Custom lists and libraries using list definition and

list instance.

Custom Master Page and Pages.

Managed visual studio 2010 solution structure.

Server

architecture [pic]

Responsibilit Senior Analyst Programmer

y

Live URL https://www.comcastdocumentcenter.com/

Main Configure claim base authentication in application

Challenges Configure search on claim base authentication

application

Tools and SharePoint 2010, ASP .net(C#) and Microsoft SQL Server

Technologies 2008

Project Name Course Management System

Duration 10 Months

Project KRM site is managing courses of KRM organization. In

Description which first user register with KRM site after that he

can login. Base on user's right user can perform various

activities like user profile information, education

history, completed courses, company information etc.

Basically KRM site is associate with CRM site. All

information is store in CRM site. Whatever user performs

in share point site, Data will synchronization with CRM

site.

KRM site integrated with Microsoft dynamic CRM.

CRM's web service directly not support to share point

site so create one more layer using custom WCF service.

Custom site definitions for KRM sites.

BCS use for storing data in share point site also it is

maintain synchronization between share point site and

CRM site.

Custom lists and libraries using list definition and

list instance.

Custom Master Page, Pages and Page Layouts.

Managed visual studio 2010 solution structure.

Caching use for better performance.

Responsibilit Working as DTM mode resource.

y

Main Integrated share point and Microsoft dynamic CRM.

Challenges New things of CRM term.

Synchronization between share point site and CRM site.

Tools and Share Point 2010, ASP .net(C#),WCF, CRM,BCS and

Technologies Microsoft SQL Server 2008

Project Name Cargo Management System

Duration 1.2 years

Project One Face web project unifies client websites. The goal

Description is to design and implement websites that effectively and

accurately represent the client brand strategy and

support the company's strategic business targets.

The new web sites combines under one web site the

contents now offered for media and investors in single

corporate web site and solution, service and product

information now shown in separate brand sites

Multilingual and regional site support using variations.

Flash component which show business process.

Custom site definitions for different kind of sites.

Minimize deployment effort using powershell.

Extensive search for list level, site level, field

level.

Well designed site column and content type hierarchy.

Custom lists and libraries

Custom Master Page, Pages and Page Layouts.

Managed visual studio 2010 solution structure.

Layered architecture and using Linq for lists.

Used Managed metadata and taxonomy management.

Responsibilit Working as Analyst Programmer in this project.

y Participated in Technical architecture of Application.

R & D and finalizing approach of some functionality.

Design and develop different features. i.e.

Custom site columns, content types, list.

Metadata term sets and terms hierarchy in Metadata term

store and used in metadata columns of list.

Custom site definition using OOTB publishing site

definition.

Deployment in staging and production environment.

Support and guidance to team members as a senior

resource of project.

Live URL www.cargotec.com

Main Variations site and scripting of power Shell

Challenges

Tools and Share Point 2010, ASP .net(C#) and Microsoft SQL Server

Technologies 2008

Project Name MOSS Intranet portal for Legal Company

Duration 11 months

Project This portal provides intranet functionality and

Description collaboration for the company staff. The application is

divided into multiple site collections. Each site

collection serves one of the collaboration purposes of

the application. This application has many types of

document libraries and each type of document library has

many templates to store different type of legal

documents. Complex content types are available for

document libraries to store different types of document

as per the business requirement. A list of the MOSS

tailoring activities done in this project is as below.

User management and Personalization using User profile

and SSP

On demand dynamic site creation using MOSS object model.

Custom site templates for different kind of sites.

Rendering templates and custom definitions.

Manage document library with complex content type

hierarchy.

Minimize deployment effort for list deployment using

List instances and custom list definition and deployment

of list through feature.

Extensive search for list level, site level, field

level.

Configure Network drive search.

Extensive use for store list items in Caching for

application performance.

Custom Role management.

Create custom site definition.

Content type for solution structure.

Responsibilit Technical architecture of the application

y Configuration of Share Point.

Create all type of content types, List definitions, and

site definitions.

Developing code for security models like overwrite

security for some lists and webs.

Deployment

Main Complex and hierarchical Content type for Different type

Challenges kind of document libraries.

Store document templates in a single location and

association of this template with the content type.

Create Custom field type to display field values from

cross site collection list. And mapped this field as a

lookup field.

Technologies MOSS 2007, .Net C# 3.5, VS 2008, Windows 2003

Database Microsoft SQL Server

Project Name Visitor Log

Duration 1.5 months

Project Visitor log maintain visitor's check in and checkout

Description status and also maintain repeater visitor status. There

are fix Badge (Card) No and for issues new Badge no

takes proper permission from admin using workflow. Using

reports like current visitor, visitor all, company by

visitor, Overdue visitor and repeater visitor admin can

see status.

Manage custom library.

Minimize deployment effort for list deployment using

List instances and custom list definition and deployment

of list through feature.

Responsibilit Technical architecture of the application

y Configuration of Share Point.

Configure share point Form server control

Deployment

Main Configure third party tool for uploading images which

Challenges capture picture and store image in relevant list.

Tools and MOSS 2007, .Net C# 3.5, VS 2008, Windows 2003 &

Technologies Microsoft SQL Server

Project Name Publication House Internet portal

Duration 7 months

Project This portal provides distribution system for the

Description publications house. It is used external file server to

upload big size documents and external database server.

It is a portal with different entities like Titel,

Edition, Fonds, Imprint etc. The following MOSS features

have been included in this application.

Document Management scenario in view of big upload size

requirement and the external file storage environment.

Mix Authentication : FBA [Authentication of user from

membership database] and ADS [Auto Login (for ADS users)

after authentication from ADS for credentials]

User management and Personalization using User profile

and SSP.

Customized Metadata versioning and management in view of

the accessibility and performance considerations.

Achieve content distribution using Site structures.

Minimize deployment effort for list deployment using

List instances.

Custom list definition and deployment of list through

feature.

Extensive search for list level, site level, field

level.

Extensive use for store list items in Caching for

application performance.

Custom Role management.

Content type for solution structure.

Main Configure Multi Pov upload third party tool which upload

Challenges multiple file upload upto 2 GB.

Configure third party tool which is open all document

sin pdf format.

Responsibilit Configuration of Share Point.

y Create all type of content types, List definitions, and

site definitions.

Developing code for security models like overwrite

security for some lists and webs.

Deployment

Tools and MOSS 2007, .Net C# 3.5, VS 2008, Windows 2003 and

Technologies Microsoft SQL Server.

Project Name PONKI Annotation Library

Duration 3 Months

Project The objective is to annotate the documents in the MOSS

Description Library by the authenticated users and other anonymous

user can access it. The major context word interface was

from a Web Service. Used 3-Tier architecture to

implement it in MOSS Site. External Database for search

was being used along with the Full Text Search.

Responsibilit Configuration of Share Point.

y Programming for custom annotate.

Configure ponki web service with moss.

Deployment

Main Configure third party web service(ponki web service)

Challenges

Tools and MOSS 2007, .Net C# 3.5, VS 2008, sql sever 2005 and

Technologies Windows 2003

Project Name Past-Employ Management System

Duration 1.8 year

Project Past-Employ is a fast and easy way to manage all of

Description your employment verification needs. Past-Employ.com is

a service provider to Employers and Verifiers that

allows these entities to obtain the information

requested in a manner that is simple, efficient and

secure. Unlike other database re-sellers,

Past-Employ.com transfers only the information

requested. Past Employ does not compile massive

databases of this information with the intent to resell

- keeping your data with you - and away from potential

security breaches.

Past-employ offers two types of verifications.

Employment Verification:

Social security number, name, most recent

start/termination date, total time employed job title.

This is a standard VOE (Verification of Employment)

Income verification:

All Employment Verification data, as well as pay rate.

Responsibilit Technical architecture of the application

y database design

Programming for admin and employer module.

Deployment

URL www.past-employ.com

Tools and ASP.NET, C#. NET and SQL Server 2005

Technologies

Work Experience

o Currently working at Gateway Techno Labs (P) Limited Ahmedabad since

May 2007 as a Share point Sr. Analyst programmer.

o Worked as a software engineer at IndiaNic InfoTech Limited Ahmedabad

from April 2005 to April 2007.

- Mukesh ajmera

[pic]



Contact this candidate