Project Sql Server

Ramakrishna Mantrawadi

email id: *.**********@*****.***

Phone : 908-***-****

Professional Summary

. Over 8 years of total IT experience through all the phases of Software

Development Life Cycle Implementation of Client/Server applications.

. Experienced in installation, configuration, development and deployment

of Microsoft Office SharePoint Server 2013/10/07.

. Worked Extensively with SharePoint Designer 2013/10/07 and CSS

(Cascading Style Sheet) to change the look and feel of the SharePoint

Portal.

. Experience in Configuring FAST Search Services for SharePoint 2010

. Experience in using 3rd Party tools from Devexpress, Quest, Bamboo,

Nintex 2007 in various Projects

. Experience in working with Services, Business Data Catalog (BDC)

Studio, Web Parts, Workflows, Master pages and Content Types, CAML

Query Builder provided by Share Point.

. Experience in building custom InfoPath Forms using InfoPath

2010/2007 and Visual Studio Tools for Application (VSTA).

. Experience in configuring Excel Services to share, secure and manage

Microsoft Office Excel workbooks as interactive reports throughout the

Enterprise.

. Experience in working with JQuery to make SharePoint site

more Interactive and Interesting.

. 4 years experience in .NET technologies with Designing, Development

and Deployment of High-Performance, Scalable, Distributed

Applications.

. Developed Web Forms and Win Forms applications with .NET Framework

3.5/3.0/2.0.

. Experienced in Object Oriented real world Implementation /Design

Patterns and their implementation using polymorphism, inheritance and

encapsulation.

. Proficient in working with XML technologies such as XML DOM, DTD/XSD,

XSLT, XPath.

. Good working knowledge of designing SQL, Tables, Indexes, Stored

Procedures, UDFs, Triggers for different Relational Databases.

. Experienced in working with SQL Server Management Studio /SQL Server

Integration Services (SSIS)/ SQL Server Reporting Services (SSRS).

. Excellent team player with proven ability to achieve short-term and

long-term goals.

Education & Certifications:

. Bachelor of Engineering in Computer Science, SCSVMV, India

. MCTS(70-542) in Microsoft Office SharePoint Server 2007 Application

Development

. MCTS(70-528) in Web-based Client Development

. Brain Bench Certified in C# programming Language

Technical Skills

Microsoft Technologies SharePoint 2013/10, MOSS2007

Programming Languages C#, VB.NET

Web Development Technologies ASP.NET, HTML, Ajax, WCF

Databases & Database SQL Server 2008/2005, MS-Access 2000, .Net

Technologies API for MySQL

Development Environments Visual Studio 2012/10/08/05, SharePoint

Designer 2013/10/07,

Reporting Tools & Document SQL Server 2005 Reporting Services, MS

Services Business Intelligence

XML Technologies XML, XSLT, Web Services

Operating Systems Windows XP / 7

Professional Experience

Littler Mendelson Mar

2015 - Till date

Sr. SharePoint Developer

San Francisco

Littler is the largest global employment and labor law practice with more

than 1,000 attorneys in over 60 offices worldwide. Littler represents

management in all aspects of employment and labor law and serves as a

single source solution provider to the global employer community. This

project is migration from existing content management systems (Law Port) to

SharePoint 2010

. Interacted with the Business users for requirement analysis and

prepared documentation.

. Defined Migration strategy from Law Port to SharePoint 2010

. Defined Taxonomy to tag documents.

. Developed Web Parts, InfoPath forms.

. SharePoint application development using client-side technologies

(CSOM, JSOM)

. Migrated using Metalogix ( Content matrix file share and SharePoint)

editions

. Design Master Page, page layouts.

. Provided application support and systems administration.

Environment: SharePoint 2010, SharePoint designer 2010,SharePoint

Workflow, Asp.net,c#, Jquery, Powershell, Bamboo, JIRA, Windows server

2008r2, SQL Server 2008 r2

Gilead Sciences Nov 14 -

Feb 2015

Sr. SharePoint Developer/Admin

Foster city

Gilead Sciences, Inc. is a research-based biopharmaceutical company that

discovers, develops and commercializes innovative medicines in areas of

unmet medical need. This project is about automation and approval of

Materials who wants to research on Compounds developed by Gilead.

. Interacted with the Business users for requirement analysis and

prepared documentation.

. Configured dev/Integration environment for SharePoint 2013.

. Entire Application is developed using JSOM, REST, HTML5

. Created Provider hosted app to achieve Esign functionality

. Worked on consuming SAML for user validation.

. Created 3 level approval workflow using SharePoint designer 2013

. Created dynamic filtering using Jquery for reports, Search,

Dashboards.

Environment: SharePoint 2013, SharePoint designer 2013, SharePoint Workflow,c#,Asp.net, Jquery, Knockout js, Powershell, Windows server 2008r2, SQL

Server 2008 r2

Jamba Juice

Oct 12 - Oct

14

SharePoint Architect/Developer/Admin

Emeryville, CA

Founded in 1990, out of a vision to inspire and simplify healthy living,

Jamba Juice is a leading restaurant retailer.

This project is internet/intranet based portal used for Day to day

communication, HR, reports on sales for both franchise and company owned

stores.

. Interacted with the Business users for requirement analysis and

created technical specifications based on the requirements.

. Extensive experience on retail domain.

. Configure dev/QA/production environment for SharePoint 2013/10.

. Design/Develop/Deploy and maintenance of multiple projects like

HRB(Human Resource Bridge),CSM (community sales program),CRF(change

request forms),JSD.

. Worked on creating custom Web-parts, list definitions, content types,

event handlers, timer jobs etc.

. Deployed and Integrated Yammer on SharePoint portal.

. Installed/Integrated ccscan to SharePoint .

. Branded portal using custom master pages, css files.

. Customized SharePoint ribbon and deployed new ribbon elements using

features

. Integrated third party web services from Aloha CFC, FEIN into

SharePoint.

. Worked with client side object model using JavaScript and JQuery

. Developed multiple components which interact with line of business SQL

server data source.

. Migrated from SharePoint 2010 to SharePoint 2013.

. Designed and developed multilevel workflows using SP designer and

visual studio.

. Assisted and trained end-user community with SharePoint site

customization

Environment: Visual Studio 2012/10, C#, SharePoint 2013/10, ASP.NET,

SharePoint Workflow, Powershell, Devexpress, Knockout js, WCF, JQuery,

AJAX, Windows Server 2012 r2/08 r2, and SQL Server 2012/08 r2.

Avaya

Aug 12-

Sept 12

Sr SharePoint developer

Basking Ridge,NJ

Avaya is a global provider of business collaboration and communications

solutions, providing unified communications, contact centers, networking

and related services to companies of all sizes around the world. This is

project is migrating Lotus Notes to Moss 2007.

. Analyze Lotus Notes Database and understand the existing

functionality.

. Created InfoPath form using InfoPath 2007.

. Created a SharePoint designer 2007 Workflows.

. Used JQuery and CSS to achieve functionality, look and feel.

Environment: Lotus Notes 4.5, Moss 2007, SharePoint designer 2007, JQuery,

Infopath 2007.

NYC Department of Information Technology & Telecommunications

June 12 - July 12

Sr. SharePoint Developer

The Landmarks Preservation Commission is the New York City agency that is

responsible for identifying and designating the City's landmarks and the

buildings in the City's historic districts. The Commission also regulates

changes to designated buildings. This project is based on MOSS 2007 which

is used as Internet/Intranet portal.

. Involved in Design and development of SharePoint portal.

. Configured FBA on MOSS 2007

. Created Application pages and WebParts

. Update/Change Stored procedures

Environment: Moss 2007, Sql 2008,Visual studio 2008,Javascript,Windows

2008 r2

Wipro Technologies

Nov 11 - May 12

Client: Novartis

East

Hanover, NJ

Team Lead/ Developer

WEBSDG department of Novartis Corporation develops and supports Web

applications developed in SharePoint

which are used by Novartis employees globally. This project is about

migration from Lotus Notes database to

SharePoint 2010.Other than migration we also develop and maintain

applications based on SharePoint 2010/2007.

. Analyze Lotus Notes Database template and identify SharePoint OOB

sites template that matches the

structure and functionality.

. Documentation of Functional Requirement specifications.

. Responsible for coordinating and implementing best use practices, and

communicating with company

management best use scenarios.

. Prepare Migration plan. Create jobs using Quest Migration Tool.

. Coordinate with team members located at off shore for migration and

application support.

. Documented common tasks and collaborated among team members.

. Involved in Administrative tasks like backup/Restore, installing

Features.

. Set up the Content Organizer and rules for document routing.

. Followed FX Cop to remove code warnings.

. Created List Forms using InfoPath 2010, Visual WebParts, Workflow on

SharePoint 2010.

. Develop Master Pages, Page Layouts for branding and customizing and

improved the look and feel of the

Sites created using CSS and JQuery.

. Created a Managed Metadata column that mapped to an existing term set

. Created and managed terms within term sets

. Involved import/export term sets data using BulkTaxonomy TermSet

Importer/Exporter Tool.

. Actively worked with end-users to define document requirements, for

designing, developing and testing

solutions to resolve them.

. Train End users, Site Owners the most comprehensive lineup of

practical SharePoint technologies.

Environment: SharePoint 2010, Visual Studio 2010, SharePoint designer 2010,

JQuery, Quest

Migration Manager

Philadelphia Insurance Companies,BalaCynwyd,PA

Techinal Lead

May 11

- Oct 11

PHLY is a team of motivated, high achievers committed to delivering

innovative products and unsurpassed service to niche insurance markets. The

group of companies market, underwrite and finance certain personal and

commercial lines of insurance nationwide through independent agents &

brokers, direct sales and the internet.

. Involved in Analysis, Design, Development of the project.

. Involved in development and manintenece of existing MOSS 2007.

. Migrated MOSS 2007 to SharePoint 2010 using Content Database attach

detach process.

. Created custom List definitions, Event Handlers, Custom Web parts and

Content Types.

. Created List Forms using Infopath 2010,Visual WebParts, WebServices

and also Customized ribbon on SharePoint 2010.

. Developed Master Pages, Page Layouts for branding and customizing and

improved the look and feel of the Sites created using Cascading Style

Sheets and JQuery.

. Created Custom Web Services for Updating System Status which is used

for both internal usage and also by external vendors.

. Developed various InfoPath forms using VSTA .

. Used BCS for connecting to an Oracle Database.

. Worked on defining crawl rules,Customizing OOB Search,User Profiles

WebParts.

. Designed and developed various custom defined reports using SQL Server

Reporting Services (SSRS) and deployed them on MOSS 2007 Portal.

. Developed Workflows using SharePoint designer 2010.

Environment: Visual Studio .Net 2010/2008, C#, SharePoint 2010, MOSS 2007,

ASP.NET, Web services,

JQuery, Windows Server 2008, and SQL Server 2008.

Cognizant,Bridge Water,NJ

Nov 10 - May 11

Client: Merck

Sr.SharePoint Consultant

Merck is a global pharmaceutical company; the project goal is to provide a

new Intranet Web Based Solution to employees of different departments for

sharing and maintaining documents, product specifications and Images

amongst them. This is a migration project from Eroom to Team Sites.The

product benefits them in better reuse of their knowledge assets, greater

functionality with minimal learning curve, and faster time to market and

increase revenues. Specific functionality includes Central Repository,

Document Logging and Version Control, Easy to use InfoPath Forms, Workflow

Processes and Approval Functionality.

. Involved in Analysis, Design, Development phases of the project.

. Analysed business processes that could be automated and formulate

plan in SharePoint

. Produce system documentation for processes, components and solutions

. Provided mentoring and technical guidance to less experienced members

of the SharePoint Development Group

. Build and manage the "Knowledge Center" community.

. Created Site Templates, Site Columns, Document Libraries, Lists, List

Views, Event Handlers, Custom Web parts and Content Type.

. Lead off-Shore Team of 4 people.

. Migrated site collections, existing content from SharePoint Server

2007 to MOSS 2010.

. Extensively worked on Post Migration issues.

. Worked on user issues raised through the ticketing system.

. Create collaboration sites in SharePoint and train users on usage and

configuration of these sites.

. Developed Master Pages, Page Layouts for branding and customizing and

improved the look and feel of the Sites created using Cascading Style

Sheets.

. Developed custom Multilevel, Feedback approval Workflows using

InfoPath forms and Visual Studio 2008 for the approval process of each

order.

. Developed user targeted solutions using User profiles, Audience

features.

. Managed Users on various sites. Created Audiences to target to

specific Content to a defined set of users based on the User Profile.

. Performed in the MOSS Search functionality by creating Crawl rules,

XSLT and managed properties for Search.

. Worked on Quest Web Parts like list view, chart view in configuring

Team Sites.

Environment: Visual Studio .Net 2008, C#, MOSS 2007, WSS 3.0, ASP.NET, XML,

Web services, SharePoint Designer 2007, HTML, XML, JavaScript, Windows

Server 2003, and SQL Server 2005.

Ascentium Corporation, Bellevue, WA

Mar 10 - OCT 10

Sr.SharePoint Developer/Admin

Ascentium delivers unmatched user experiences and innovative business

solutions by fusing consultative insight, inspired creative chops, and

technological wizardry. They create multichannel connections between brands

and customers and help clients fully, profitably engage a digitized,

mobilized world.

. Worked on multiple projects with different clients like Nintendo,

Microsoft, Oldcastle Precast,World Vision.

. Involved in gathering and preparation of requirements specification

documents.

. Created Site Columns and Content Types, List Definitions, Lists, List

Views, Event Handlers, Custom Web parts.

. Customized Look & Feel of portal by modifying Master Pages and using

Cascading Style Sheet.

. Designed different forms with the help of MS InfoPath 2007 and Visual

Studio Tools for Application and customized views based on user roles.

. Developed Visual Web Parts, Workflows on SharePoint 2010.

. Worked with Visual Studio .Net with C# and Share Point Object Model

for addition & customization of Portal.

. Designed and Develped workflows using Nintex and Visual Studio

2010/2008 for different workflow tasks.

. Designed different Approval Processes with the help of workflows and

implement them for Document Library.

. Used SharePoint designer to create Data view Web Parts, Content Query

Web parts and also Applied Branding to the portal and team sites.

. Used BDC Meta Man to Application definition file and also used out of

box Web Parts like Business Data List Web Part, Business Data Item Web

Part.

. Implemented CAML Queries for extracting list contents in web-parts.

Designed CAML queries with the help of CAML Query Builder.

. Created & Deployed Web Parts by using C# and SharePoint Object Model.

. Used AJAX Control Toolkit in web pages for asynchronous processing

. Developed Reports using SSRS and integrated with MOSS 2007.

Environment: SharePoint 2010, MOSS 2007, Microsoft Visual Studio 2010/08,

Nintex 2007, SharePoint Designer 2010/07,Microsoft InfoPath 2007, C#,

LINQ, CSS, Java Script, JQuery,Json, TFS.

Hitachi, CA.

July 09- Feb 10

Document Management & Collaboration Portal

Sr.SharePoint Developer

The project goal is to provide a new Intranet Web Based Solution to

employees of different departments for sharing and maintaining documents,

product specifications and Images amongst them. The product benefits them

in better reuse of their knowledge assets, greater functionality with

minimal learning curve, and faster time to market and increased revenues.

Specific functionality includes Central Repository, Document Logging and

Version Control, Easy to use InfoPath Forms, Workflow Processes and

Approval Functionality.

. Involved in gathering and preparation of requirements specification

documents.

. Created Site Templates, Site Columns, KPI, Document Libraries, Lists,

List Views, Event Handlers, Custom Web parts and Content Type.

. Involved in Administrative tasks like Configuring Crawl rules, back

up/Restore, installing Features.

. Deployed Site Features and Custom List with Site Columns and Content

Type by using Share Point Features Manager.

. Customized Look & Feel of portal by modifying Master Pages and using

Cascading Style Sheet.

. Designed different forms with the help of MS InfoPath 2007 and Visual

Studio Tools for Application and customized views based on user roles.

. Worked with Visual Studio .Net with C# and Share Point Object Model

for addition & customization of Portal.

. Used Nintex workflows and custom Workflows using Visual Studio 2008

for different business scenarios within the application.

. Used SharePoint designer to create Data view Web Parts, Content Query

Web parts and also Applied Branding to the portal and team sites.

. Used out of Box Information policy features for Document Management.

. Implemented CAML Queries for extracting list contents in web-parts.

Designed CAML queries with the help of CAML Query Builder.

. Created & Deployed Simple & Connectable Web Parts by using C# and

SharePoint Object Model.

. Configured Excel Services to allow company users to share

financial data within excel files with certain managers.

Environment: MOSS 2007, Windows SharePoint Services (WSS 3.0), Microsoft

Visual Studio 2008, Nintex Work Flow 2007, SharePoint Designer 2007,

Windows Workflow Foundation, C#, LINQ, WCF, CSS,Java Script, TFS.

First Reserve Corporation, Greenwich, CT

Jan 08-june 09

Document Management & Collaboration Portal

Sr.SharePoint Developer

First Reserve Corporation is an Energy industry investor, making both

private equity and infrastructure investments throughout the energy value

chain. The project goal is to provide a new Intranet Web Based Solution to

employees of different departments. Specific functionality includes Central

Repository, Document Logging and Version Control, Easy to use InfoPath

Forms, Workflow Processes and Approval Functionality.

. Designed and developed the SharePoint Portal Architecture for the

organization using MOSS 2007 and WSS Sites.

. Used Web services for online transactions using C# and integrated it

with MOSS 2007 using custom Web Parts.

. Participated in all major phases of development including project

analysis, requirements gathering.

. Enabled version controlling for newly created Document Libraries and

enabled information policy management including labels and expiration

periods.

. Developed custom web parts making use of the SharePoint object model.

. Created Custom office document templates and associated with site

content types.

. Developed several InfoPath forms to automate employee requests. Forms

had managed code which made use of MOSS web services.

. Setup MOSS environment to use multiple authentication models to

allow internal company users to authenticate using Active

Directory and for external vendors to use Forms Based

Authentication to access specific content.

. Created Workflows using MS-Visual Studio2005 as well as using

SharePoint Designer.

. Used third party tools to create BDC (Business Data Catalogue)

application definition files.

. Configured Audit Policies for documents and items in the portal to

specify which events can be audited.

. Used ADO.net disconnected architecture was used to access SQL Server

database.

. Performed Administration of database by importing and exporting data

from different using SQL Server 2005.

. Developed stored procedures,triggers in SQL Server 2005.

. Configured Excel Services to allow company users to share

financial data within excel files with certain managers.

. Developed Reports using SSRS and integrated with MOSS 2007.

. Developed Data access assemblies in C# and isolated data access logic

from business layer and front end.

Environment : MOSS 2007, SharePoint Designer 2007, Visual Studio 2005,

Windows Workflow Foundation C#, ASP.NET, XML, ADO.NET, IIS, Web Services,

SQL2005, SVN.

Bellsouth Atlanta, GA

May 07-Dec 07

Warehouse Management System (WMS)

.Net / SharePoint Consultant

The Warehouse Management System is a complete warehousing and distribution

solutions application. It is an online site to maintain the warehousing

details of various companies having their products stored at multiple

locations across the country. This WMS consists of seven modules namely

Administration, Maintenance, Inbound, Warehouse Operations, Outbound, and

inquiries, Reports

. Involved in Analysis, Design and Development of Application.

. Prepared documentation and technical specifications for the work

given.

. Helped customize the look and feel of Share Point Portal Server 2003

to match the design that was provided by their design department. This

included extensive use of CSS, custom web parts.

. Extensively used MS Front Page to

incorporate branding and look and feel for SPS 2003 Sites.

. Created a Project Management site with features for assigning tasks,

tracking project status, bug fixing and prioritization, discussing

critical issues etc.

. Designed InfoPath 2003 forms with dependant controls, repeating

controls, multiple data sources, field promotion and scripting

. Developed User controls and Server Controls for Web Graphical User

Interfaces in C# and ASP.net.

. Created Web Services to handle for searching resources, time tracking

. Involved in database Design and written stored procedures and

triggers.

. Developed Web Forms and User controls using ASP.net, Java script,

. Created database details, business logic system administration

screens.

. Participated in discussions assisting Business Analysts and System

Administrators in analyzing and developing UI and time box planning.

Environment: Share point portal 2003 services, Asp.Net, C#.Net, SQL

Server2005, Java Script,

Microsoft Visual Studio2003.

Constellation HB, CA

June 2006-Apr 2007

Constellation HB Web Portal

C#/ASP.Net Developer

The objective of Constellation HB Web Portal (Web Application) is to offer

a suite of online applications designed to help clients sales group to sale

& Purchase and rentals the home over the Intranet. It allows end users to

access available home sites and plans information, and also maintaining the

database of the clients for keeping them update regarding new offerings and

vacant places available. The project also incorporates all the

customization related to home sites in terms of different options and

incentives offerings.

. Involved in the gathering and preparation of requirements

specification documents.

. Designed the databases, based on the designs specified in the design

phase, using SQL Server 2000.

. Involved in designing application architecture, which consisted of

laying out class diagrams, and sequence diagrams by using MS Visio.

. Developed the application as a three-tier application with UI in the

presentation layer, business logic in the middle layer using ASP.Net,

C# and database activity in the backend.

. Used ADO.NET disconnected Dataset model to access the databases and

gather all relevant

. Information to be stored.

. Defined required XML, XSD to store the metadata of the compliance

policies. Wrote XSLT scripts to

. consume/customize XML data available from ADO.NET

. Developed Web Services for obtaining structured data for sales

representatives.

. Performed required field, comparison, range, custom validations of the

input controls of the web forms.

. Implemented Authorization and Authentication via role-based security

in order to restrict accessibility to certain modules.

. Tested using Diagnostics utilities (Tracing & Debugging) and

documented the changes as well as performed NUnit testing.

. Maintenance of the existing ASP pages combined with the new developed

ASP.NET web pages to provide the required functionalities.

. Developed and Deployed service based components in COM+ and also used

normal COM components in the .NET environment

Environment: Microsoft Visual Studio .NET, ASP.Net 1.1, C#, SQL Server

2000, MS Visio,

JavaScript, VSS, ADO.Net.

Contact this candidate