Sharepoint Sql Server

Kumar Yashwanth

Houston, TX (*****)

Cell: 224-***-****

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

PROFESSIONAL SUMMARY:

5+years of Professional experience in Microsoft SharePoint with proven success in Design, Development, Implementation, Deployment and implementation of client-server window based and web based applications.

Experience in installing, configuring, administering, maintaining and troubleshooting Microsoft SharePoint Server 2016/2013, SharePoint Online, SharePoint 2010, MOSS 2007, and WSS 3.0on Internet Information Services and MS Windows R2 and MS Windows Server 2012.

Expert knowledge on software development lifecycle (SDLC) and Quality process.

Skilled knowledge on SharePoint Work Flow, Web Parts, Navigation Control, Content Types, Document Libraries, Templates, Lists, Site Collections, Site Definitions, Events, Lists, Wikis, Blogs, List Alerts, Site columns, Views for Branding.

Worked in different areas including Collaboration, Document Management, Portal, and Web Content Management.

Experience in implementing SharePoint technologies on medium to large Farms and performing Farm, Application and Site Collection Level Administration.

Experience in Client Object Model and Server Object Model in developing applications.

Expertise in Migration SharePoint 2010 to SharePoint 2013, SharePoint Online, and from 2007 to 2010.

Strong proficiency in designing and developing InfoPath.

Hands-on Experience on SharePoint Designer like Master Pages, CSS Themes.

Worked on Active Directory and experience in implementing and configuring all Service Applications like BDC/BCS, Excel Services, Access Services, Visio Services, Performance Point Service, Managed Metadata Service, Search services, User Profile Service and Secure Store Service.

Worked on online SharePoint Administrative works.

Experience in Creating and Configuring Records Management Center in SharePoint 2016, SharePoint 2013, 2010 according to business requirements.

Implemented Network Load Balancing between SharePoint Server 2016, 2013 and 2010 front end web servers.

Performed SQL server maintenance activities such as backup and restore, setting up mirroring, detach and attach of SQL databases.

Strong knowledge and experience in Object Oriented Programming.

Good in scripting technologies HTML, DHTML, VB Script, Java Script, CSS, XML

Good communication, problem solving, and interpersonal skills with the ability to work independently or with individuals at all levels

Expert in translating business requirements into technical solutions and provide it with quality, usability, security and scalability.

Experience using Tableau Server, Tableau Desktop, Hadoop and various Databases.

Expertise in designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the business/client requirement.

Expertise on SAP BW-BO integration and Web-Intelligence reporting on it.

Administration of SharePoint online, Lync online and Exchange online (Office 365).

TECHNICAL SKILLS:

SharePoint Tech:

MOSS 2007, SharePoint 2010, SharePoint 2013, SharePoint 2016 and SharePoint Online Windows SharePoint Services 2.0/3.0, SharePoint API, BDC, BCS, Excel Services, Microsoft Office InfoPath 2007/2010/2013/2016. Access Services, Visio Services, Office 365

Operating System:

Windows XP/Vista/2000/Server 2003/2008/2012R2

Database:

Microsoft SQL Server 2000/2005/2008/2012 R2, Oracle 9i/8i, MS Access

Microsoft Tech:

C#.NET, VB.NET, Visual Basic

Internet:

ASP.NET 1.1/2.0, XSLT, XML, HTML, DHTML, CAML

Reporting Tools:

Crystal Reports 9/10, SSRS

ETL Tools:

DTS, MS SSIS (SQL Server Integration Services)

MS Servers:

IIS 5.0/6.0/7.0

Tools and IDEs:

Microsoft InfoPath 2003/2007/2010/2013, Visual studio 2003/2005/ 2008/2013, CSS, AJAX, UML, Microsoft SharePoint Designer 2007/ 2010/2013, Windows PowerShell.

Frameworks:

.NET Framework 1.1, 2.0,3.0,3.5,4

Version Control Tools:

VSS 6.0, CVS, VS Team System

Scripting Languages:

JavaScript, VBScript, CSS

PROFESSIONAL EXPERIENCE:

Hess Corporation, Houston TX Sep 2016 – Till date

SharePoint Admin / Dev

Project Description:

Hess Corporation is a leading global independent energy company engaged in the exploration and production of crude oil and natural gas. Portfolio is about evenly split between unconventional and conventional; U.S. and international; and onshore and offshore. Hess exploration strategy is to create future growth options that deliver long-term value by focusing on proven and emerging oil-prone plays in the Atlantic Basin – areas and exploration team understands well and that leverage offshore drilling and development capabilities.

Responsibilities:

Served as SharePoint Administrator/ Developer for companywide intranet and responsible for maintaining SharePoint2010/2013/2016 Online and Microsoft Office SharePoint Server 2007.

Involved in all phases of Software Development Life Cycle including requirements gathering, design, development, testing, implementation and post production support for SharePoint Online (Office 365).

Involved in Migration from SharePoint 2010/MOSS 2007 to SharePoint Online.

Developed solutions utilizing SharePoint Designer by editing and deploying master pages, CSS, JavaScript code, and customizing navigation and page table layouts and Worked on branding publishing sites using Design manager.

Prepared SharePoint 2010 upgrade and testing plans

Migration remediation tasks included troubleshooting issues related to all aspects of SharePointOnline including permissions, site content, master pages, themes, workflows, Custom web parts, content types, notifications, and metadata.

Involved in a native-upgrade wherein the existing content databases are detached from SP2013, SP2010 and attached to SP2016. During attachment, the databases get upgraded and the content is made available on SharePoint2016.

Provided ongoing maintenance of the SharePoint portal.

Integrated SharePoint Online with Office 365 features like Yammer and Video Portal.

Created a multiple approval custom workflow in SharePoint Designer to automate the business process.

Created and published Forms in InfoPath based on the requirement.

Collaborated with multiple departments and application leads to successfully integrate SharePoint applications with non-SharePoint applications and improve business processes

Performed full and partial user import from Active Directory to synchronize user profiles and properties. Created Audiences using user profiles to enforce security of Web parts usage. Created Timer Job definition to run job on schedule time by the SharePoint Administrator.

Implemented and customized several web parts like Content Query and Content Search web parts, Search Results and Refinement, Page Viewer, Query String Filter web part and Connectable web parts. Implemented a Cross-Site web part to view contents of a document library across different sub-sites.

Used PowerShell Scripts to perform SharePoint administration tasks for password changes, and site collection setup and during migration.

Involved in installation and configuration of SharePoint 2013/2016.

Successfully Migrated SharePoint Site from SharePoint 2010 to SharePoint 2013/2016 using

Sharegate.

Create and develop SharePoint Shared calendars to pull Outlook calendar Data into SharePoint calendars.

Troubleshooting skills in connectivity and migrations to MS O365, Outlook and cloud.

Involved in Branding, creating the Master Pages, Page Layouts, Mega Menu and customization.

Worked on InfoPath forms (Form Design, Views, Business rules)

Daily activities involved backup and restore of sites using PowerShell scripts and Windows task schedulers.

Worked on Nintex Works and Forms.

Integrated other LOB applications to SharePoint and vice versa using Data Sync Studio.

Worked on configuring SharePoint 2010 Services – Search Services, Excel Services, Business Data Connectivity Services and Performance Point Services.

Worked on BCS with SharePoint Designer, connected with External Data Sources and developed External Content Types.

Created Web Parts to Create List and Libraries with document Publish, Ordering and Grouping Feature.

Configured and customized Web Parts and Export/ImportWeb Parts to another site.

Worked on Archiving process using PowerShell and windows task scheduler.

Configured the Service Applications like Search, User Profile Synchronization, Business data connectivity Services etc.

Responsible for SharePoint issues for entire company which include Maintaining site collections, public website, and external sharing, document management, backup/restore, day to day trouble shooting of moderate to complex issues, Coordination with Microsoft for SharePoint support when required, Administration and technical support to end users.

Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.

Assisted users to publish and collaborate reports via a web browser embed Tableau views in other web applications in SharePoint.

Environment: SharePoint Server 2010, Office 365, SharePoint Online, MOSS 2007, IIS 7.0, Active Directory, Windows 2007, SQL Server 2008. SharePoint Designer 2007/2010/2013, MS-InfoPath 2007/ 2010/2013, .Net, C#, CSS, HTML, AJAX, JavaScript, JQuery, Web services, XML, XSLT, Tableau

Endo Pharmaceuticals, Dallas TX Apr 2016 – Aug 2016

SharePoint Admin / Developer

Project Description:

Endo is a leading health provider company in Malvern committed to help Medicare and Medicaid Beneficiaries. The goal of this project is to enable access to business-determined encounter-related attributes and associated code sets in the user interfaces. The requirement is that data will be obtained directly from the appropriate source systems and will be maintained in a single source of truth (HDM) before populating individual data marts.

Responsibilities:

Participated in requirement gathering and analysis phase to understand the Business user's requirements.

Conducted detailed problem tracking, resolutions and completion of all actions and issues by their deadlines.

Customized the Master Pages and CSS files for Branding and to provide the portal with a consistent look and feel using SharePoint.

Validated upgraded Production server farm and issue resolution

Enabled content types and configured Metadata Navigation for libraries and lists. Created and managed Custom Site Definitions, Site Templates, Site Columns, Document and Picture Libraries, Links, Events, Creating custom SharePoint Lists, List Views, Document libraries, Custom Page Layouts.

Worked on Site Collection, Site Configuration, and Site Template, Site Definition and list definition using SharePoint 2013 Team Site and Meeting Workspace for managing Web portal information.

Developed custom Web Parts for SharePoint using ASP.NET.

Worked on SharePoint object model, custom Timer Jobs, Event Handlers, Feature Receivers, Audience Targeting, CAML Query, Page Layouts, SharePoint Designer, and InfoPath Forms 2013/2016.

Developed a custom utility to import the existing project data from excel to SharePoint and created various charts and reports using Excel Web services.

Worked with communication tools like Announcements, Discussion boards, Calendar, Contacts, Tasks, Project Tasks, Surveys, Issue Tracking etc.

Lead Migration from SharePoint 2010 site collections & solutions to SharePoint 2013.

Utilized Central Administration site to manage corporate server farm and created/extended web applications to isolate SharePoint sites.

Worked on Design and Development of User Interfaces using HTML, JavaScript, LINQ, CSS, ASP.Net, XML and AJAX.

Worked on Kerberos, Integrated Windows authentication protocol, and supports advanced security features including Advanced Encryption Standard (AES) encryption and mutual authentication of clients and servers.

Perform typical administrative activities such as backup, restore, and site creation.

Worked with SharePoint backup solutions using PowerShell, SQL Server, and STSADM. Monitored the server load and enhanced its performance throughout the development and deployment of the functionality.

Developed dashboards which includes geographical Mapping functionalities and advanced data visualization features of Tableau involving multiple dimensions and measures.

Migrated all the dashboards from ParAccel connection to Amazon Redshift connection

Worked on all the data manipulation features in Tableau like calculated fields, Parameters, Table calculations, sets, filters, custom sorting etc.

Environment: SharePoint2016/ 2013/2010, Windows 2012/2008, SQL Server 2012/2008, Active Directory, IIS, Microsoft Exchange Server 2007/2010, SharePoint designer 2013/2010, MS Office 2013/2010, STSADM, PowerShell, LDAP, ASP.NET 3.5, XML/XSLT, C#, HTML, JavaScript.

Sapphire IT Services, Houston TX May 2014 – Mar 2016

SharePoint Developer / Admin

Project Description:

Sapphire IT Services is a multinational Health Care company. The Company delivers analytic tools, benchmarks, research, and services to the healthcare industry, including hospitals, employers, health plans, clinicians, pharmaceutical, biotech and medical device companies. Especially worked on Site collections.

Responsibilities:

Worked with multiple groups in the company to create SharePoint applications as per their business requirements.

Conducted migration and upgrade approach for the overall Web application

Understanding the business requirement and Server sizing.

Created sites, redesigned site look and feel, navigation depending upon the requirements related to different project types and provided support.

Designed custom page layouts for site pages using SharePoint designer, customized the portal UI to create new look and feel for the departmental site using SharePoint designer.

Developed custom workflows using SharePoint designer to notify/approvals/feedback with the teams associated with the project hierarchy.

Set up security at different levels in the SharePoint sites using the SharePoint groups and Active Directory groups

Crystal reports were used to build reports after each task performed in the Portal and maintenance ined MOSS 2010 portal.

Extensively used Out Of the Box web parts like Content editor web parts, business data web parts, query string web parts, filter and search web parts to customize the WebPages data layouts.

Created libraries and Views for the InfoPath form to be published and to manage metadata generated from InfoPath promoted columns.

Created custom site templates with custom content types applicable to multiple releases, trained users to create and manage their own sites using these templates.

Worked on SharePoint Search, setting up Search query rules, result types, display template and customizing search.

Custom Development of SharePoint features using Visual Studio 2013 and Deployment of custom feature using Power Shell.

created business intelligence (BI) dashboards with scorecard, report, and filter Web Parts that contain interactive data visualizations

Designing of storage and disk type with allocation.

Used jQuery for validation of data entry page and for passing the query string to the next page.

Provided technical support to end users.

Farm performance and availability for administration tasks.

Installed SharePoint cumulative update, service pack in different SharePoint environments based on proper validation in UAT and DEV environments. Monitoring and troubleshooting of Central Administration health issues, ULS Log and event viewer

Created, responded to and tracked user tickets entered in Remedy issue tracking system

Responded to helpdesk and general IT inquiries; diagnosed and resolved issues and provided technical support for 700+ users

Performed troubleshooting and handled escalated issues; ensured minimal disruption and efficient operational support

To get the reports on SharePoint site collections, used tools like Axcelar Control Point, Nintex for creating forms and workflows, Sitrion One/AirWatch for enterprise mobility suite.

Used SharePoint Nintex workflow to create, design workflows and custom forms.

Environment: SharePoint Server 2010, Windows SharePoint Services(WSS) 3.0, SharePoint Designer 2010, Visual Studio.NET 2010, C# .Net, MVC 3.0, VB.Net, ASP.NET 3.5, MS-InfoPath 2010, Windows server 2008 R2, SQL SERVER 2008, CSS, HTML, IIS 7.0, AJAX, JavaScript, Web services, XML, XSLT.

GET SET Solutions, India April 2013 – April 2014

SharePoint Admin/Developer

Project Description:

Get Set Solutions is a multinational Lodging services holding company, which is headquartered in Hyderabad, India. This project mainly involves integrating data from multiple source systems, enabling a central view across the enterprise and presenting the organization's information consistently and worked with collaboration team for site collections, sites and designing WebPages in SharePoint.

Responsibilities:

Extensively worked with Business Team and Functional Team to review business requirements, and Functional clarifications.

Responsible for all architectural considerations and technical decisions.

Deployed and customized collaborative and publishing site collections, sites, web parts, document libraries, lists, and views.

Extensively knowledge of all features of FAST Search for SharePoint 2010 and how to optimize the user search experience

Designed new pages and altered exiting pages using ASP.Net 4.0, C#

Recoded few VB.Net pages in C#.Net

Used typed dataset to interact with the database.

Designed and programmed user interface, business logic and data access components to meet user requirements using ASP.NET, ADO.NET, HTML, CSS and JavaScript.

Created a console application for crawling of content sources programmatically using C# and Visual studio 2010.

Created a Custom Edit form for the SharePoint List to categorize the field in the list using JQuery slide panel.

Used sessions across the website in order to maintain the security in accessing the application.

Developed Windows service to read the data from database and create XML files.

Worked on SQL Server querying the database and modified stored procedures according to the requirements.

Worked on SSIS packages, which integrate the data between the Portal and Payroll databases.

Crystal reports were used to build reports after each task performed in the Portal and Maintained MOSS 2010 portal.

Performed share point admin tasks in SharePoint 2010.

Worked on Audiences, User Profiles, libraries, and personalization links in SharePoint.

Created custom Lookup columns.

Using Excel Services developed custom Reporting Solution embedded with custom KPI Lists, Web Parts and Excel Workbooks

Used tracking system to keep in track the issues and solving them on daily basis.

Environment: Microsoft SharePoint Server 2010, ASP.Net 4.0, JQuery, SQL Server 2008, TFS, Windows Server 2010, Ajax, SSIS.

IT Elegant Pvt. Ltd., India Mar 2012 – Mar 2013

SharePoint Developer

Project Description:

ITELEGANT has developed a mix of professionals with domain and functional experience, Worked as a SharePoint developer creating SharePoint sites, site collections design for storing the information.

Responsibilities:

Developed and maintained SharePoint documentation as it relates to policies, procedures, architecture, and application integration.

Configured Secured Store Service Application and Target Application ID to access the External SQL Data source.

Configured BCS Application to allow external list to access external SQL data source.

Created External Content types of tables and Views with multiple filter parameters from SharePoint Designer.

Used JavaScript Client Object Model to update, create and delete the items in SharePoint pages using SharePoint Designer.

Created separate calendar lists like out of office and vacations which are linked with basic notification workflows so that a group notification is send out to the entire team when an out of office or vacation request is submitted by a team member.

With OPS module configured PowerShell access in Office 365.

Implemented custom document centers and wiki’s for each individual site with the inclusion of private and shared document centers.

Used audience targeting for various areas.

Network Load Balancing of WFE as per the client request.

Used Powershell script to Back up particular site, site collection and web application and performed most of the administrative task.

Created various InfoPath forms for users to fill them and published them to SharePoint form library.

Deployed various WSP packaged using both Central Administration as well as STSADM utility.

Performed Backup and Restore using PowerShell and Central Administration.

Installed Cumulative Updates on QA, Test, Development and Production Environment.

Used BDC to integrate business data from back-end server (SQL) application

Created and Configured User Profile Service Managed Metadata Service, Search Service Application.

Created CSS to match the intranet site according to policies in place by the marketing department

Deployed custom in-house written web part (Image Flipper)

Created Web Application and Site Collections as per requirement.

Activated and deactivated Features through STSADM in SharePoint 2010

Created Task List, Project List and Calendar List based on business needs.

Created approval Workflow process in the Document libraries.

Used jQuery for validation of data entry page and for passing the query string to the next page.

Used jQuery for multiple selection dropdown in reporting page and for accessing the DOM objects.

Used escalations within the service request process where a request is escalated based on the escalation schedule associated with the corresponding request type.

Created horizontal and vertical menu bars in a SharePoint site using HTML, CSS and JavaScript.

Created multiple data view web parts and .asp web pages to access data from other SQL server databases and SharePoint lists.

Used web part connection from SharePoint Designer and used Data view web part for reporting purpose.

Used JavaScript code to export the current table data to an Excel spreadsheet for the External List.

Made a very attractive custom form from SharePoint Designer for data entry for External List.

Environment: SP Server 2010, SP Designer 2010, MS Office 2010, Visio 2010, Windows Server 2008 R2, IIS 7.0

Education:

Bachelor's from JNTU-Hyderabad, 2013.

Contact this candidate