Resume

Sign in

Sharepoint Sql Server

Location:
Little Falls, New Jersey, United States
Salary:
95
Posted:
September 10, 2018

Contact this candidate

Resume:

HARSHAD PATEL

MCP, MCAD, MCSD, MCTS

SUMMARY:

More than 12 years of experience in analysis, design, development, integration, testing, research and implementation of several business applications in IT industry and possess good experience with application software relating to Media/Advertising, Financial Accounting, Banking, E-Commerce, ECM, CMS, EPOS, and SharePoint 2013/2010/2007.

More than 6 Years of software development experience in Microsoft SharePoint Server 2013/2010/2007, this includes Custom App/Add-in Development, Collaboration, Enterprise Content Management, Search, Workflow, Portals and Personalization.

Strong experience with Object-oriented programming (OOP)

Experienced in design, development and implementation of web-based applications using Visual Studio 2015/2012/2010/2008/2005, ASP.NET, C#, SOAP and RESTful WEB SERVICES, ADO.NET, XML, CSS, HTML, HTML5, JAVA SCRIPT, JQuery, JSON.Net, AJAX, and Microsoft Enterprise Library 5.0/4.0/2.0.

Strong experience in SharePoint 2013 development for Add-ins, Reusable components, Farm solutions, publishing sites, and site customization.

Experience in an Agile Scrum and Waterfall software development methodology.

Strong experience in design and development of Web Applications using C# ASP.NET Web Forms and MVC .

Experience with implementation of web APIs like Facebook, Google AdWords, YouTube, Bing Ads, Yahoo Gemini, comScore, SocialCode, Prisma, Nielsen, Omniture etc.

Experience in designing and developing Portals using SharePoint 2013/2010/2007.

Experience with implementing user authentication in SharePoint using Claims-based (NTML, Kerberos, basic) and windows classic mode authentication (forms or SAML based authentication)

Experience with PowerShell administration modules.

Experience with SharePoint deployment automation with PowerShell.

Experience of SharePoint upgrades and migration from SP 2007 to SP 2010 and SP 2013.

Experience in developing and deploying SharePoint solutions using App Model and Office 365

development.

Experience with building responsive web design using HTML5, CSS3, and Bootstrap.

Strong eexperience with Nintex forms and workflows.

Experience in automating business processes using SharePoint Workflows using SharePoint Designer and Visual Studio.

Experience with Sharegate SharePoint migration tool.

In- expertise in MS SQL Server 2012/2008/2005/2000, T-SQL, SSRS, SSIS and DTS Packages.

Experience in SOA architecture using Web Service & WCF Services.

Experience in Windows Communication Foundation (WCF) services, Entity Framework.

Experience of working with Third party controls of ComponentArt, Telerik Controls, DevExpress and Dev Component.

Extensively worked with SQL Queries, Transact-SQL (T-SQL), Stored Procedures, database triggers, indexes, cursors, functions, Schema, Types (UDTT), and SQL Jobs.

Experience with diagnostics tools like Advanced REST Client, Postman, Fiddler, IE Inspector, HTTP Analyzer etc.

Experienced in integration of Payment Gateways like PayPal, Authorize.net, VeriSign, Iveri, Yes-Pay and Protx.

Strong experience in deployment and Managing Production and Web Server.

Self-motivated, highly committed to responsibilities. Excellent communication skills and ability to work independently perform well within cross-functional teams.

TECHNICAL & ACADAMIC QUALIFICATION

Master of Science in Information Systems from Stratford University

PROFESSIONAL CERTIFICATIONS

Microsoft Certified Technology Specialist (MCTS)

Microsoft Certified Professional (MCP).

Microsoft Certified Application Developer (MCAD).

Microsoft Certified Solution Developer (MCSD).

TECHNICAL SKILLS

Languages

:

C# .Net, VB.Net, PowerBuilder

GUI/ IDE

:

Visual Studio 2015/2012/2010/2008/2005/2003, SQL Server Management Studio, Visual Basic 6.0

Web Development

:

ASP.Net, C#, MVC, Web Services, ADO.Net, LINQ, REST APIs, ASP 3.0, VBScript, XML, JavaScript, JQuery, Ajax, CSS, CSS3, XML, HTML, HTML5, PowerShell

RDBMS/Server

:

SQL Server 2012/2008/2005/2000, Oracle, MS-Access 2000

Web Server

:

Microsoft IIS 7.0/6.0/5.0

Reporting Tools

:

SQL Server Reporting Services, tableau, Crystal Report

CMS/ECM

Microsoft SharePoint Server 2013/2010/2007, DotNetNuke 3.x – 5.x

Versioning Tools

:

MS Visual Source Safe, TFS, VssConnect

Bug Tracking Tool

:

Microsoft SCSM 2012, OnTime, Mantis

Other Tools

:

Office 365, MS-Office, VISIO,MS Project, Sharegate SharePoint Migration Tool, Component Art Web Controls

PROFESSIONAL EXPERIENCE

PNC Bank, PA

Development Team Lead –SharePoint/ .NET

September 2016 to Present

Responsibilities:

Involved in Requirement gathering, Analysis, Design, Development, Testing and Deployment of SharePoint Artifacts using nintex forms, workflows and SharePoint Add-ins/App.

Responsible for design and development of SharePoint Add-ins

Developed SharePoint provider hosted MVC app with SQL Server backend.

Developed MVC forms/views using Entity model.

Implemented the client chrome control in SharePoint Provider hosted MVC Add-ins

Responsible to set up server prerequisites for Provider hosted app, such as obtaining client signing certificate, issuer id, installing SSL (Secure Sockets Layer) certificate in IIS.

Developed various Nintex forms and workflows for PNC financial services.

Responsible to convert IBS Lotus Notes applications/database to SharePoint 2013.

Maintenance of existing SharePoint 2013 farm solutions.

Developed Activity History/ Log module for C# .Net MVC application using SQL Server 2014.

Responsible to migrate Louts notes data to SharePoint list/libraries.

Developed Reusable components in SharePoint 2013, such as custom lists, workflows, external content types, site columns, event receivers etc.

Responsible for delivering projects using an Agile SCRUM methodology and general IT best practices.

Responsible to manage JIRA for project tracking and issues.

Responsible for deploying solution package to DEV and UAT environments.

Responsible for assigning work to team members including code review and daily progress check-in for assigned tasks.

Responsible to deliver project close and handover documentation.

Tools & Technologies: C# ASP.NET 4.5/4.0/3.5, MVC 6.0, SharePoint Server 2013, Microsoft SQL Server 2014, Microsoft Visual Studio 2015, C, Entity Framework 6.0, JQuery, JavaScript, JSON.Net, JQGrid, Grid.MVC, EPPlus, HTML5, CSS3, Team Foundation Server (TFS), Git – Source Control, JIRA, HP Quality Center (HPQC)

ePharmaSolutions, PA

Principal Solutions SharePoint/.Net Architect

May 2016 to September 2016

ePharmaSolutions (ePS) is a leading provider of e-clinical solutions that improve the way that clinical trial sites are selected, trained, activated, and managed.

Responsibilities:

Involved in Requirement gathering, Analysis, Design and Discovery sessions.

Converted Asp.Net project to SharePoint solutions.

Developed provider hosted app using MVC .Net and SQL Server for clinical trial data.

Developed new functionality to their existing SharePoint system using Nintex forms and workflow.

Tools & Technologies: SharePoint Server 2013, Microsoft SQL Server 2014, Microsoft Visual Studio 2015, Business Intelligence Development Studio,Team Foundation Server, InfoPath, ASP.NET 4.5/4.0/3.5, C#, MVC, JQuery, VBScript, HTML,HTML5, CSS3, JSON.Net

Dentsu Aegis Network, New York

Senior SharePoint/. Net Developer / Architect

Feb 2012 to April 2016

Dentsu Aegis Network is the world's leading, focused media and digital communications group and deliver media and digital communication fit for the media convergent era.

Responsibilities:

Involved in Requirement gathering, Analysis, Design, Development, Testing and Deployment of SharePoint Artifacts C# Asp.Net/InfoPath forms.

oDeveloped various InfoPath forms with workflow for IT and Management like Change Request, HR hire module, Project Request, Incident Post Mortem, IT help desk support etc.

Developed SharePoint-hosted Add-ins (apps) for Office 365.

Used Agile development best practices and proactively offer improvements to the agile development process on a routine basis.

Responsible for APIs development and maintenance using C#, JSON, Json.NET framework, and SQL Server.

Responsible for delivering projects using an Agile SCRUM methodology and general IT best practices.

Work with Project Managers to define and manage project plans, including scope, scheduling, and implementation.

Responsible to mentor other team members in SQL, SSIS and other technical processes.

Responsible for designing custom code for projects that are deployed to SharePoint servers which includes technology selection across the many ways to build code in SharePoint, ensuring the team development environment is configured, creating a strategy for code deployment, versioning, configuration, or structure.

Responsible for adherence to Best Practices in Development and Administration.

Unit testing for all assigned deliverables. Designing and implementing SharePoint workflows and controls in line with our SDLC process.

Involved in maintaining and upgrading features, web parts, workflows for SharePoint, Integrating the portal with other corporate data sources, applications, and knowledge management systems.

Responsible for creating and managing site collections, sub sites, Wiki, Blog, Document library etc. according to business requirements.

Developed web pages/branding in SharePoint 2013 using HTML5, CSS3

Enterprise Content Management (ECM) using Document Center.

Coding, testing and implementing solutions in a SharePoint environment. Taking direction from management and architects in implementing solutions.

Developed Web Parts, Event Handlers, and workflows and deployed them as features.

oCreated dashboard of Project status web part for Budget vs. Actual cost, overdue issues, overdue tasks and task rollup web part.

oDeveloped video management web part with upload, download and playing any video format file.

oCreated custom visual web part that support export and import to a custom tab Web Part without a Web Part zone.

oCreated various web parts like Auto Rotate Images, Create Auto Site collection using custom site template, TreeView web part to display hierarchical view of lists and SubWebs, Delete site, list and libraries web part for site admin, HR Approval, notification and Proxy setup web part, HR IT report with search and export to excel web part and many more to support IT business system.

Worked with Architects, Business Analysts and business process modelers to implement business process management specifications into automated solutions.

Extensively used OOP and SharePoint Object Model fundamentals for programming.

Developed Application Pages, Master Pages and Site pages using SharePoint Designer 2007/2010.

oDeployed Asp.Net web application pages to SharePoint as custom application pages, customized master page as per client specific themes, customized site pages include the home page (default.aspx) and other site pages associated with list and document libraries, such as NewForm.aspx, EditForm.aspx, and AllItems.aspx etc.

Created site columns, content types in list and documents library.

oDefined custom content types for finance, HR, Marketing, Communication Planning, Digital Media etc and deployed centrally and reused for different lists and libraries.

Created reusable core components in C# using SharePoint Object model which are extensively used in the Forms Development in ASP.Net and InfoPath.

Responsible to modify & integrate business processes with existing InfoPath forms.

Custom Workflows with InfoPath forms.

oCreated custom sequential workflow for Change Management and Project Request and HR employment process.

Worked with Timer Jobs and Event Handlers.

oCreated daily and weekly timer job scoped to Web Application level to send site/folder updates to internal/external users/vendors.

Customized site and Item level permission.

Used WSP Builder, MSBuild for Deployments.

Used VBScript for Active Server Pages

Responsible to write PowerShell scripting for repetitive tasks and automation.

Setting up the SharePoint Disaster Recovery (DR) sites with log-shipping and SQL Server AlwaysOn.

Created Deployment packages for Custom Solutions, Custom Web parts and Content types.

Lead SharePoint upgrades and migrations from SP 2007 to SP 2013.

Support end users with all SharePoint related issues.

Manage SharePoint end user accounts, permissions and access rights in accordance with best-practices regarding privacy and security.

Tools & Technologies: Microsoft office SharePoint sever 2013/2010/2007, Microsoft SQL Server 2012/2008/2005, Microsoft Visual Studio 2015/2012/2010/2008, Business Intelligence Development Studio,Team Foundation Server, Source Anywhere - VSS, XML, XSLT, WSS 3.0, InfoPath, ASP.NET 4.5/4.0/3.5, C#, MVC, JQuery, VBScript, HTML,HTML5, CSS, CSS3, JSON.Net, APIs, Office 365, Windows Server 2003/2008 R2, Sharegate Migration Tool, Apple iOS XCode studio.

People’s Unites Bank, Bridgeport CT

Sr.SharePoint Developer/Consultant

Aug 2010 to Jan 2012

Project - Net Forms Development / Data Migration: Net Forms is designed to develop customized .net form for SharePoint Server 2007 including custom workflow and out of the box functionality and other utilities for data migration from IBM Lotus Notes to SharePoint database.

Responsibilities:

Actively interacted with the project mangers and end users to collect the business requirements.

Involved in maintaining and upgrading features, web parts, workflows for SharePoint, Integrating the portal with other corporate data sources, applications, and knowledge management systems.

Responsible for creating and managing site collections, sub sites, Wiki, Blog, Document library etc. according to business requirements.

Enterprise Content Management (ECM) using Document Center.

Responsible for SharePoint 2007 development using lists, libraries, and web parts.

Extensively used OOP and SharePoint Object Model fundamentals for programming.

Developed Application Pages, Master Pages and Site pages using SharePoint Designer 2007.

Created site columns, content types in list and documents library.

Responsible to modify & integrate business processes with existing InfoPath forms.

Used CAML for defining what elements exist on an instance of a site, and the display of these sub-elements in SharePoint Utilization.

Custom Workflows with InfoPath 2007 forms.

Responsible for Data Migration from IBM Lotus Notes 6.5 to SharePoint 2007 Database.

Worked with Event Handlers.

Handle Windows SharePoint Services events by developing an event receiver.

Created Custom SharePoint Features and Deployment.

Document Library Setup, Security Architecture and Workflows Setup

Customized Item level access on a List existing in a Site Collection.

Used WSP Builder, MSBuild for Deployments.

Create and deploy a Windows SharePoint Services solution package.

Actively involved in creating User Manual for new development.

Tools & Technologies: Microsoft office SharePoint sever 2007 (MOSS), Microsoft SQL Server 2005,Microsoft Visual Studio 2008, XML, WSS 3.0, InfoPath, SYNERGY, ASP.NET 5, C#, HTML, Microsoft Office Professional 2007, Windows Server 2003.

Catalyst Cloud Pvt. Ltd, Ahmedabad, INDIA.

Project Leader

May 2009 to July 2010

Catalyst Cloud is an International technology firm providing a wide range of services such as software development, data ware housing, network solutions and business process outsourcing.

Project - AssetMax: AssetMax is end to end software for all type of auto loan management. AssetMax brings together the many different parties to a loan originators, mortgage brokers, and service providers to improve efficiency and accuracy across the life of the application, from loan origination through closing and secondary marketing.

Responsibilities:

Involved in Requirements gathering, Design, and Implementation.

Responsible for Database Design and Server side scripting.

Designed N-tier architecture for consistent development.

Used Microsoft Application Blocks for Data Layer.

Extensive use of LINQ Query.

Developed UI using VB.Net forms.

Microsoft Visual SourceSafe 2005 was used for tracking and managing source code changes.

Created complex stored procedure, function and T-SQL.

Involved in testing and bug fixing.

Tools & Technologies: Visual Studio 2008, C#.Net, SQL Server 2008, LINQ, Visual Source Safe

Project - Interface HR Consultancy: Interface is one of the leading recruiters of Professionals and providing strategic and operational management consulting, IT Services in various domains, Human Resource development etc. The organization has grown in terms of scope of services and the capabilities to mobilize resources across various locations.

Responsibilities:

Extensively used Central Administration to perform server operations and application management tasks including creating and extending web applications, creating site collections and defining quota templates.

Created custom office document templates and associated with site content types to store specific documents.

Involved in Building features, web parts, etc for SharePoint, Integrating the portal with other corporate data sources, applications, and knowledge management systems. Created custom site definitions and list definitions and site templates and list templates for creating custom sites and lists.

Worked on all MOSS features like BDC, Single Sign on and various features for Microsoft Office.

Extensively used OOP and SharePoint Object Model fundamentals for programming.

Customized SharePoint sites by changing layout and themes to have same look and feel.

Performed testing and created documentation for various components developed.

Create custom lists, libraries and site templates for future use

Enterprise Content Management using Document Center and Record Management.

Added Users to a Site using Active Directory

Customized Item level access on a List existing in a Site Collection.

Responsible for deploying a SharePoint Web Parts on WSS.

Used WSP Builder, MSBuild for Deployments.

Create and deploy a Windows SharePoint Services solution package.

Setup portal sites and personalization features.

Created custom web parts and tool parts using Visual Studio .NET 2005 to integrate content from legacy content management application into SharePoint Portal Sites

Tools & Technologies: MOSS 2007, .Net Framework3.5,Microsoft SQL Server 2005/2008, Microsoft Visual Studio 2005, XML, Windows SharePoint Services, InfoPath, ASP.NET, C#, HTML, Windows Server 2003.

Addon Solutions, Ahmedabad, INDIA.

Project Leader/Sr. Software Developer

September 2008 to January 2009

Project - Garmento: The domain was of a garment manufacturer, wherein the entire process of executing the raw material into finished goods needed to automate and their by generating barcode for the finished goods. This system is developed in VS 2008, C#, Asp.Net and SQL Server 2005 for backend.

Responsibilities:

Involved in multiples stages of SDLC of the project namely Requirements gathering, Design, Implementation and Unit Testing.

Design and implement the message contracts with the back end host.

Designing Database and Server side scripting.

Effectively implemented state management techniques using Sessions, View State, Application State and cookies.

Designed N-tier architecture for consistent development.

Responsible for generate reports using SQL Server Reporting Service (SSRS) for tracking row material stocks and orders.

Responsible for Implementing JQuery call for binding data grid, add, edit, view, delete and search functionality.

Developed UI using Asp.Net, Html, CSS, JavaScript, Ajax Control Toolkit, JQuery and flash.

Transfer data from .txt and excel file to SQL Server Database using SSIS.

Microsoft Visual SourceSafe 2005 was used for tracking and managing source code changes.

Implemented custom asynchronous messages between garmento core and back end with WCF web services.

Implemented LINQ to SQL entity for CURD operations.

Created functionality to call web services from client side script (JavaScript).

Created complex stored procedure, function and T-SQL.

Developed Barcode Generation functionality on predefined labels.

Involved in deployment of application on production and web server.

Involved in testing and bug fixing.

Tools & Technologies: Visual Studio 2008,C#.Net, ASP.Net,IIS6,SQL Server 2008, LINQ,WCF,CSS,JavaScript, Ajax Toolkit Controls,Visual Source Safe

SACS Software Limited, London, UK

Software Engineer

April 2008 – August 2008

SACS is a firm of accountants & computer consultants, established in 1991.SACS provide computerized accounting solutions incorporating SAGE Line 50, SAGE Line 100 and SACS Pos-2000 Point of sales software. IT is one of the first sage solutions center in London.

Project - EPOS Web Portal: EPOS Web Portal is E-commerce shopping cart portal, which is connected with EPOS system and showing products on web, generating orders and send updates to EPOS system.

Responsibilities:

Understood Electronic Point of Sales system flow.

Worked with SAGE line 50 linking objects to get data into EPOS system.

Understood functional specifications, designed and developed the applications to meet business requirements.

Responsible to discuss requirement with SAGE and EPOS developers.

Involved in database design, writing stored procedures, functions, triggers and cursors.

Developed Web Service to get Remote data from EPOS system.

Responsible to mange database backup and data synchronization.

Developed front end and admin web pages using Asp.Net, HTML, AJAX, XML, CSS, and JavaScript.

Created live Weather Report using XML and RSS.

Created Crystal reports.

Integrated several Payment Gateways like PayPal, Yes-Pay and Protx.

Developed dynamic Themes and Skins for site UI.

VSSConnect was used for tracking and managing source code changes.

Properly handled client side validations using JavaScript and AJAX validation controls.

Involved in testing and bug fixing.

Responsible to deploy and testing project on Web Servers.

Created system manual for end user.

Tools & Technologies: .Net Framework3.5,Visual Studio 2008,Asp.Net, VB.Net, HTML, DHTML, JavaScript, Ajax Toolkit, Xml,Web Services, Telerik Controls,SQL Server 2005, SQL CE 2005, Smart Device for Pocket PC, Photoshop, Multiple Payment Gateways Integration, IIS,Windows 2003, Deployment & Updates on Web Server.

IBSD Software India Pvt.Ltd, India

Technical Manager

Feb 2006 to Feb 2008

IBSD Software India Pvt.Ltd is a Product based company for Small Business Organization. IBSD has various products like Web Portal, Accounting Software and Network related software, also involved in customization software development.

Project- Bizword Pro System: It is a product for semi government & mid level business contains web portal for accounting, user, group management, seminar library, E-commerce and many more modules.

Tools & Technologies: Visual Studio .Net 2003/2008, Asp.Net, Vb.Net,WCF,LINQ, HTML, DHTML, JavaScript, Ajax, Xml, Web Services, Window Services, SQL Server 2000/2005, SQL Reporting Services,RSS News, Flash, Photoshop, Multiple Payment Gateways Integration,PDA, DotNetNuke Portal Integration & Module and Skins Development,IIS6, VSS Client, VPN, RDC,Deployment on Web Server.

HiddenBrains InfoTech, Ahmedabad, INDIA.

Project Leader

May 2003 - January 2006

HiddenBrains is a company providing professional-level customized solution, Web applications development, full-featured online shopping stores, Software development, Client server technology. HB designs, manage, build and maintain high quality solutions for a wide range of businesses and individuals. HB is an innovative technology industry focused, business driven professional services firm.



Contact this candidate