Sql Server Project

SHANTHAN R BODDI

PROFESSIONAL SUMMARY

. Over Five years of experience in the IT industry working with

Microsoft technologies and Over Three years of experience working with

SharePoint technologies: SharePoint Portal Administration, Designing

and Development (SharePoint 2010 Server, MOSS 2007).

. Experience with developing applications using C SHARP, ASP.NET,

ADO.NET, HTML, Exchange Server, Active Directory, XML, and SQL Server

2005/2008.

. Extensive experience on planning, installation, deployment,

configuration and support of SharePoint 2010,MOSS 2007, SPS 2003,

Windows SharePoint Services 3.0 with Windows Server 2003/2008, IIS and

SQL Server 2005/2008.

. Experienced with Search engine optimization and Site Design.

. Hands-on experience in designing and implementing various SharePoint

Web Parts, Business Data Catalog (BDC), BCS (SharePoint 2010) event

handlers, Features, Workflows, Content Types, custom Document

Libraries and Lists.

. Worked extensively on Portal sites, Records Management, Search,

Indexing and Backups.

. Knowledge of plan and design for security of Windows SharePoint

Services.

. Strong proficiency in designing and developing InfoPath 2007/2010

forms for workflows.

. Involved in requirement gathering, analysis, design, development and

deployment.

TECHNICAL SKILLS

.Net Framework (1.1, 2.0, 3.0,3.5) Visual VB .NET, C#,

Languages ASP.Net, ASP 3.0, Visual Basic 6.0, HTML, Java, TSQL,

VBScript, JavaScript, VBA.

Operating System DOS, Windows NT/98/XP/2000/2003/Vista/2008

Server Applications Microsoft Windows SharePoint Services 3.0, Microsoft

Office SharePoint Server 2007, IIS 5.0/ 6.0/7.0,

SharePoint 2010

.NET Technologies ASP.Net, ADO.NET, ADO, XML, XML web Services, Win Forms,

Web Form

Databases SQL Server 2000/2005/2008

Security Microsoft Forefront (Client, Exchange, SharePoint), ISA

Server 2006

Visual Studio.Net ( 2005, 2008, 2010), Visual Basic 6.0,

Visual Interdev, Crystal Reports 9, SharePoint Designer

IDE 2007/2010, InfoPath 2007/2010, UML, TOAD, Visio

Stored Procedures, Views, Functions and Triggers,

Database Programming Cursors in SQL Server

Methodologies Client/Server Architecture, N-tier application

architecture, OOA, Prototyping, Process Models

Markup Languages DHTML, HTML, XHTML 1.0, XML, XSL, XSLT, XPath, CSS

Testing Tools Jaws 8.0

EDUCATIONAL/ACADEMIC QUALIFICATIONS& CERTIFICATIONS

. Bachelor's in Electrical Engineering, JNTU, INDIA

. Master's in Computer Software Engineering, Virginia, USA

. Microsoft Certified Technology Specialist (MCTS) - Share Point

Server application Development

PROJECTS' PROFILE:

FedEx, Memphis, TN

Mar'12 - Present

SharePoint 2010 Designer/Developer

Project Description: FedEx has a large number of internal websites that

they want to move over to a SharePoint Server 2010, they had EADS

(Enterprise Architecture Design Services) web site, which has several

service areas and sub sites under each services. Redesigned and moved all

of them to SharePoint 2010.

Responsibilities:

. Developed project plan and External Functional Requirements to build

out SharePoint application across EADS.

. Gather requirements from Content Owners of each Service area.

. Created a Sample Template to Content Owners based upon client

Requirement.

. Worked on Two Site Collections, SharePoint Standard 2010(external

customers who are in FedEx LDAP can have access) and SharePoint

Enterprise 2010(Internal to their service area)

. Developed Custom Mater Pages and Page-Layouts(EADS welcome page,

EADS Landing page, EADS Service area page, EADS Blank Page and more)

. Create a Custom CSS files and applied to Mater Page for better look

and feel using SharePoint Designer 2010.

. Customized and Branded SharePoint Site using CSS and SharePoint

Designer along with HTML, Jscript, JQuery and XSL.

. Worked with Static and Dynamic Reports, Organizational Chart (EADS

Personnel Roster), Calendars (Meeting Minutes workspace).

. Worked on Large SharePoint Custom Lists (Task Matrix List) and

created a Keyword Search to a List.

. Email functionality to send service area reports directly to their

respective libraries with Document Retention.

. Worked with Data bound dropdown list, parameter filters, Excel

Services, Access Services, Visio Services and Performance Point

Services.

. Worked extensively on Data View Web parts and Content Editor Web

parts.

. Created forms using InfoPath Designer, published to SharePoint and

save forms to PDF.

. Developed and Implemented SharePoint Governance Plan for EADS.

. Train Content Owners of each service area on basic SharePoint

functionality and documented it.

Environment: Windows Server 2008 R2, SharePoint Server 2010, Microsoft .NET

Framework 3.5, Visual Studio 2010,C#, SharePoint Designer 2010, SQL Server

2008 R2, IIS 7.0.

General Motors Tech Center, MI

Sep'11 - Feb'12

SharePoint 2010 Admin/Developer

Project Description: GM-MLP is a manufacturing learning portal, Learning

portal that is used by manufacturing employees needs to register the course

and complete it before a specific time, They are two types of course Job

Role courses and Technical courses, some of these courses are mandatory

depending on the region, Once the course is completed there will be a test

attached to it to complete certification, credit will be calculated. This

project is implemented in Agile scrum Methodology with weekly sprint and

monthly release

Responsibilities:

. Analyze current business requirements and map to SharePoint 2010.

. Installed, configured and designed server farm concepts for medium

servers.

. Imported User Profiles from Active Directory by scheduling profile

imports using Central Administration and Profile and Import Settings

. Installed and configured search, used the STSADM commands and Power

shell commands to deploy features create Web Applications, Site

Collections and perform backups

. Identify new areas on an ongoing basis where SharePoint 2010 can be

leveraged

. Manage permissions and restrict and revoke access where necessary.

. Create, leverage and manage content types, site columns and

templates for re-use in the sites.

. Implemented multilingual features for the user to choose the native

language.

. Create custom reusable workflows using SharePoint Designer 2010.

. Developed custom InfoPath form to populate the user data from user

profile using web service (SOAP).

. Used REST for query the SharePoint List in the client API's

. Setup and manage alerts to monitor activity on business critical

information as required.

. Establish a Governance Forum

. Ensure uniform navigation throughout sites

. Provide guidance to business units on structure of their sites.

. Manage search scopes and best bets with input from business units.

. Constantly revisit and review content to ensure business relevance.

. Customize and maintain landing page to encourage traffic and user

adoption

. Monitor site usage and follow up on dormancy on a monthly basis.

. Monitor for excessive complexity and suggest streamlined

alternatives.

. Monitor to ensure workflow and tasks are working correctly and

emails are going out.

. Ongoing research to determine what SharePoint 2010 can do.

Environment: Windows Server 2008 R2, SharePoint Server 2010, Microsoft .NET

Framework 3.5, Visual Studio 2010,C#, SharePoint Designer 2010, SQL Server

2008 R2, IIS 7.0.

Niagara Waters, Ontario, CA

Feb'11 - Aug '11

SharePoint 2010 Admin/Developer

Project Description: Niagara water provides customers with quality and

innovative products. They wanted to implement SharePoint portal to share

all their Departments data and information. They have around 14 departments

and worked around those departments and deployed SharePoint application

across these departments.

Responsibilities:

. Developed project plan to build out SharePoint application across all

the departments.

. Build both Development and Production environments, and installed

SharePoint2010 and database on both environments

. Developed and created Functional requirement document for all

departments.

. Interviewed all the departments Super user individually and gather

requirements of their department

. Worked on HR department, build out HR department site, gather and

collected all the information that they want to put on SharePoint

. Worked on forms, links, Corporate calendar, Resource calendar,

newsletter, organizational charts both static and dynamic, electronic

documents,

. Worked on dashboards and Niagara Scorecards to display data from

different files(xml, excel, flat files)

. Worked on Vacation Request Form (using InfoPath2010) by creating a

custom list and associated workflow to it.

. Added necessary links to their sites so they can open their external

links within SharePoint

. Worked on different paper based forms and converted them into

electronic documents

. Created Content deployment path from staging to production.

. Worked on Summary Link web part, content query web part, data view web

part, newsletter and announcements.

. Worked on mobile application, where the users can login same

SharePoint application in their mobile browser.

. Deployed solutions using content deployment and back/restore to their

production environment.

. Used SharePoint Designer 2010 for customizations of SharePoint sites

. Created dynamic organizational charts using SharePoint Object Model

and used Content Editor Web parts all around the design page.

Environment: Windows 2008 Enterprise R2, SQL Server 2008, Active Directory,

IIS, SharePoint 2010, Microsoft Visual Studio ultimate 2010, SharePoint

designer 2010.

Inteva Products, Troy, MI

July'10 - Feb'11

SharePoint 2010 Developer/Designer

Project Description: Inteva Products is a global experience leader in

designing, engineering, manufacturing and supporting Automotive with global

resources. They wanted to change their Homepage to a new design with better

look and feel, to do some customizations and design master page which

applies to their site collections.

Responsibilities:

. Developed project plan for a successful home page.

. Gathered Graphics, pictures, curves and other information from the

company.

. Developed a site with publishing portal template so the manager can

publish the site.

. Worked on master page which includes background color, logo change,

tagline, global links and menu tabs.

. Worked on Content page which includes subhead image, announcements web

parts with image on it, RSS feed.

. Configured Farm based authentication and used it for creating internet

websites or portal.

. Handled security setup for different groups of people at different

levels with authentication and encryption.

. Used Third-Party Web parts to implement high quality, scalable and

extendable SharePoint Solutions

. Worked on Custom Search scopes to show dropdown lists for all sites.

. Added necessary links to their quick launch bar and directed them to a

resultant page.

. Worked on Bookmarks so the user can delete or add links.

. Deployed solutions using content deployment and back/restore to their

production environment.

. Created custom News Aggregator web parts to display text with

image(custom content type, custom page layout and custom web part)

. Used SharePoint Designer 2010 for customizations, Created new CSS file

for better look and feel, changed HTML code to their default master

page.

. Created Auto generated list using SharePoint Object Model and used

Content Editor Web parts all around the design page.

Environment: Windows 2008 Enterprise Server, SQL Server 2008, Active

Directory, IIS 7.0, Microsoft Office SharePoint 2007/SharePoint 2010,

Microsoft Visual Studio .NET 2008, SharePoint designer 2007/2010.

Environment: Windows 2008 Enterprise Server, SQL Server 2008, SharePoint

2010, Visual studio 2010, Visual source safe, Active Directory, IIS.

Farmers Insurance, Independence, OH

Oct'09 - July'10

Share Point Developer

Project Description: Farmers Insurance (Bristol West Insurance Group) is a

non standard auto insurance company with one billion return premium. They

had a SharePoint 2003 website that needs some clean-up, some quick tasks to

be completed and do some knowledge transfer to their current full time

staff. They had a QA site that has a forum group and they want to put more

logic around that and also their QA site doesn't match their production

site. They needed to upgrade/migrate from SharePoint 2003 to SharePoint

2007.

Responsibilities:

. Worked with QA discussion and suggestion enhancements, which includes

SQL database changes, SharePoint changes.

. Changed email functionality on QA suggestion and discussion forms.

. Added sort capabilities on QA suggestion form.

. Worked with paging functionality (limit view 10 issues per page).

. Worked on webpage changes which include adding, removing fields.

. Created a new database (ZIP_REQUEST_DB) table, new form for a new

project (New Zip Code Requests).

. Created a workflow for a new form during initial request and during

approval/denial process.

. Created a view/list of all Zip Code Requests.

. Migration included consolidating a few hundreds of portals, large

number of databases and Custom Applications from SharePoint Portal

Server (SPS 2003) to MOSS 2007.

. Used C# and SharePoint Object Model for creating Web parts for

manipulation of Custom List.

. Trained the information workers on creating sites, documents

libraries, lists, assigning permissions to sites, sub sites, folders,

list and documents (item level security).

Environment: Windows 2003 Enterprise Server, SQL Server 2005,, SharePoint

2007, Visual studio 2005, Visual source safe, Active Directory, IIS,,

Microsoft Exchange Server 2007, Microsoft Visual Studio .NET 2005.

Broadgate Inc Jan'09 - Oct' 09

System developer

Project Description: Developed Time Sheet and Invoice applications along

with Requirements Gathering.

Responsibilities:

. Installed and configured SharePoint.

. Worked with Info path and share Point designer.

. Gained experience in system operations and various types of hardware and

software.

. Installed various Operating Systems like Win NT Server, Win XP, Win 2003

Server, Win 2008 Server.

. Designed and implemented a daily backup plan.

. Monitor physical operation of all equipment, including servers and modem

racks.

. Systems administrator for approximately 100 users.

. Microsoft Workstation support and administration (Windows XP, 2000, NT)

. Microsoft Office Suite support and administration

. DNS support and administration

Contact this candidate