VARUN MEHROTRA

SharePoint Development, .Net MVC Development, SharePoint Architecture, Office 365, Azure, Application Performance, Platform Support and Analytics

LinkedIn https://www.linkedin.com/in/varun-mehrotra-profile/

Ramsey, NJ (addhkd@r.postjobfree.com)

+1-201-***-****

13-year work experience in software development, SME in SharePoint development, .Net (C#) MVC development, SharePoint Server Object Model (SSOM), Client-Side Object Model (CSOM), JavaScript Object Model (JSOM), PowerShell, Agile software development methodology, Scrum process framework, SharePoint Search, SharePoint architecture design and implementation, SharePoint administration, SharePoint migration and platform support for applications with users around the globe.

Hands-on experience with analytics and reporting using Google Analytics, Cardiolog, Splunk. Expertise in application performance monitoring using AppDynamics, Splunk, Fiddler and Wireshark and migrations using ShareGate, SharePoint Object Model, Content Matrix (Metalogix).

Hands-on experience in developing and supporting Angular applications integrated into SharePoint using REST APIs and SharePoint JSOM.

Hands-on with Office 365 including SharePoint Online, integrating SharePoint with Azure, and knowledge of Azure Service Fabric. Developed and hosted Webhooks for SharePoint Online on Azure as Azure Functions with post processing in background using WebJobs in Azure, also implemented POCs connecting console applications in SharePoint with Azure.

Hands-on with developing mobile apps for Android and iOS using Xamarin (Visual Studio 2019).

Diverse domain knowledge and hands-on experience in implementing governance models.

5-year experience performing Team Lead responsibilities.

Worked in projects with BP, Royal Bank of Canada, TD Ameritrade, KPMG.

KPMG

I worked in multiple projects with KPMG during a tenure of 6+ years, developed SharePoint applications using C# .Net and PowerShell utilizing SharePoint Server Object Model (SSOM) and Client-Side Object Model (CSOM), developed and installed Provided Hosted Apps, Remote Event Receivers, Patterns and Practices, Custom Content Types, Custom Actions, List Templates, Workflows and other key features in SharePoint. Developed and supported Angular applications integrated into SharePoint using REST APIs and SharePoint Java Script Object Model (JSOM).

I extensively researched and implemented Search Ranking optimizations in SharePoint which enhanced search experience for users, developed Custom Search Ranking Models.

Designed, developed and implemented a Content Refresh Process in SharePoint which helped in refreshing non-production environments with sanitized production content for applications hosted on MOSS 2007 and SharePoint 2013, this process helped QA and Business users perform testing on most recent production data in non-production environments which overall helped in improving our product and deliverables.

Designed, developed and implemented Friendly URL architecture integrated into SharePoint which picked up usage rapidly with over 10K users using the platform in span of 2 months after its release and received a promising feedback.

Developed expertise in performance monitoring and analytical tools (AppDynamics, Splunk, Fiddler, Wireshark, Google Analytics, Cardiolog) which added lot of value to deliverables and I also trained my team on these tools.

Implemented and lead many migrations including migrating MOSS 2007 platform from Windows 2003 OS to Windows 2008 R2 and later migrating from MOSS 2007 to SharePoint 2013 (Windows 2012 R2) along with migrating some applications from MOSS 2007 to SharePoint 2010. I also did some successful POCs recently migrating content from SharePoint 2013 to SharePoint 2019 and from SharePoint 2013 to SharePoint Online (Office 365). Over the years I performed migrations using ShareGate, Metalogix (content matrix), SharePoint Object Model (C#/PowerShell scripting).

Administered architecture and health of SharePoint platform and infrastructure, administering 24X7 global support providing direction to support teams for various applications hosted in the SharePoint farm with a user base of over 150K users around the globe.

We (my team) maintained customer confidence throughout my tenure at KPMG, because of strong customer approval rating we continued support and development for several applications along with migrating those applications over to newer technologies and platforms periodically which helped in our team’s overall growth, I feel proud.

Employment History

-IRIS Software Inc., March 2014 to Present

oClients: KPMG

-IRIS CompSoft LLP November 2010 to March 2014

oClients: TD Ameritrade, Royal Bank of Canada, KPMG

-TATA Consultancy Service Limited - December 2009 to November 2010

oClients: BP

-Tech Mahindra Ltd. (Erstwhile Satyam Computer Services Ltd. (Brand: Mahindra Satyam)) - September 2007 to December 2009

oClients: BP

Skills

SharePoint (13 years)

Microsoft .Net (13 years)

C# .Net (13 years)

Client side scripting (13 years)

SharePoint Migration (11 years)

Microsoft SQL Server (9 years)

Fiddler (9 years)

PowerShell (7 years)

Agile (5 years)

Metalogix Content Matrix (5 years)

Team Leader (5 years)

Wireshark (5 years)

Scrum (4 years)

Jira (4 years)

AppDynamics (4 years)

Angular (3 years)

Splunk (3 years)

Git (3 years)

Office 365 (3 year)

Azure (2 year)

ShareGate (2 years)

Cardiolog (2 years)

Xamarin (1 year)

Google Analytics (1 year)

Azure Service Fabric (0.5 year)

Domains

-Banking

-Brokerage

-Oil and Gas

-Knowledge Management (Tax, Advisory, Audit, Clients and Marketing, Industries)

Projects History

KPMG Nov’2013-Apr’2020

-Developed SharePoint applications using SharePoint Server Object Model (SSOM), Client-Side Object Model (CSOM), JavaScript Object Model (JSOM), REST APIs.

-Developed and installed Provider Hosted Apps, Remote Event Receivers, Custom Content Types, Custom Actions, PNPs and other key features in SharePoint.

-Angular 8- developed and supported Angular applications integrated into SharePoint using REST APIs and SharePoint JSOM

-Implemented Search Ranking enhancements in SharePoint, developed Custom Search Ranking Models

-Agile development methodology

-Scrum process framework

-Source control management (Git)

-SharePoint 2013 architecture (SharePoint farm set up, integrating with F5, DataPower for Internal and External Apps)

-POCs on Office 365 and SharePoint 2019 architecture, development and migration

-Team lead, strategizing development and application components architecture

-Production and Non-production environments maintenance, Content Refresh and data sanitization

-Google analytics POCs with Office 365 and SharePoint 2013 and 2019

-Cardiolog analytics integration with SharePoint 2013 and SharePoint 2019

-Splunk custom reporting and logs analysis

-AppDynamics integration with SharePoint and non-SharePoint applications, along with AppDynamics integration with network components

-InfoPath forms development

-SharePoint Workflows development

-Migrations using SharePoint object model, ShareGate, Metalogix (content matrix)

-SharePoint 2003/2007/2010/2013 hands on application development and support

-Client-side scripting hands on with Angular JS, AJAX etc.

-SharePoint 2007 to SharePoint 2013 migrations

-SharePoint 2013 to SharePoint 2019 migrations

-SharePoint 2013 to Office 365 migrations

-DR environment setup for SharePoint farm

TD Ameritrade Jan’2011-Jan’2012 and June’2012-Oct’2013

-Agile development methodology

-SharePoint 2010 custom solution deployments

-Business continuity processes implementation

-Governance model implementation

-Content publishing automation

-Cross site management

-Custom workflows

-InfoPath forms development

-Code reviews, strategize development

Project included development and maintenance of TDA’s intranet SharePoint portal. The portal provides an enriched user-friendly environment to the users to navigate, search and collaborate. It is used by various departments such as HR, Retail distribution, Marketing etc.

Royal Bank of Canada Feb’2012-May’2012

-Agile development methodology

-SharePoint 2010 custom solution deployments

-Centralize documentation and work functions and processes of bankers and other members of Municipal Finance.

-Designed and developed entitlements.

-Item level security implementation

-Metadata tagging features implementation

-CSOM and SSOM SharePoint development methodologies

Project is development and support of web-based technology platform which would centralize documentation and work functions and processes used by bankers and other members of Municipal Finance. These functions include initiating transactions, getting transactions reviewed and approved, handling revenue and expenses for transactions, maintaining on-going client engagements, closing and post-closing activities. The platform centralized activities of 26 offices throughout the United States.

British Petroleum Apr’2008-Nov’2010

-MOSS 2007 application development and support

-Shared service Provider (SSP) implementation

-Search scopes and site configuration management

-User profile management

-Mysites implementation

-Security implementation techniques in MOSS 2007 and Audience targeting features

-Remote log off implementation techniques

-InfoPath 2007 development

-mPro integration with MOSS 20007

-Supported mPro database servers (Oracle) across 12 Global refineries of BP

-Deployed mPro components (new Releases at mPro Application servers)

-SharePoint 2013 application development and support

-InfoPath 2003 development

Project 1:

Project caters to the day-to-day activities of the users at 12 Refineries for BP across the globe, including US, Europe, Australia. Integrating business applications like Laboratory applications (LIMS), PI servers (PI data), Documentums, MAXIMO, SAP etc. together into a MOSS 2007 system utilizing a 3rd Party product called mPro. Daily reporting for >600 operators across each refinery are managed using custom built InfoPath forms with data connections pointing to the SQL database utilizing the custom-built Web services built using .Net framework. A platform for launching and integrating data from different data sources and to maintain daily reporting of data.

Project 2:

Application to enable the admins for a site in US to remotely logoff users with active sessions from a remote terminal server i.e. a citrix server. Application runs as a windows application which using impersonation fetches the details of the active sessions on the remote terminal server and enables the admin to select and log off the user sessions as needed. The application also provides admin with a functionality to lock all user accounts.

Project 3:

Project was an enhancement project for a BP Refinery that enhanced an existing application built on MS Access to a web application using .Net Framework, Asp.Net. The application enabled the refinery to implement safety, training related procedures more efficiently and do the analysis of the same in the best manner. Various categories of users like administrators, users, observers etc. were provided with role-based access to the website. For easy and effective analysis of data application provided pdf reports and charts generated using Asp.Net technology.

Project 4:

Project enabled 20 Units in BP to maintain and log in all their Key Performance Indicator’s (KPI) related Information into SharePoint. It also provided a feature to migrate the data stored in excel files, MS Access and SQL into SharePoint utilizing an interface designed using Microsoft InfoPath tool. The data uploaded on SharePoint was utilized for generating trends in the form of Charts and Graphs for further analysis.

Project 5:

Project captured the daily activities of the operators in the defined report templates (developed using Microsoft InfoPath 2003) published in a SharePoint Server Site for a refinery in BP. Solution backend would utilize a PI Database server and SQL Server 2005 to bind the data to the interface implemented using .Net Framework, SharePoint Server 2003 and Web Services developed on .Net 2005 and XML.

Certifications

-Microsoft Certified Technology Specialist (MCTS): SharePoint 2010 – Application Development

-Microsoft Certified Technology Specialist (MCTS): Microsoft Office SharePoint Server 2007 – Application Development.

-OGPro 101: certification in Oil and Gas Domain (Internal BP)

Education

Bachelor of Technology (Electronics and Telecommunication)

References

1.Name: Nico Alkema

Company: KPMG

Designation: Director

Email Id: addhkd@r.postjobfree.com

Phone Number: +1-201-***-****

2.Name: Jennifer Greve

Company: KPMG

Designation: Manager

Email Id: addhkd@r.postjobfree.com

Phone Number: +1-201-***-****

Contact this candidate