PRASHANT SHARMA

Microsoft *** Consultant – SharePoint and Microsoft Power Platform

540-***-****

ad4k9g@r.postjobfree.com

SUMMARY

Highly accomplished IT Professional with a total of over 20 years of experience delivering exceptional technical solutions and strategic IT leadership.

Adept at designing, implementing, and managing complex systems that optimize efficiency and drive business growth.

Proven track record of successfully aligning IT initiatives with organizational goals to enhance productivity, streamline operations, and ensure seamless functionality.

Skilled in team leadership, project management, collaborating with stakeholders, and fostering cross-functional collaboration.

Extensive hands-on experience in the architect, design, development and implementation of Internet portals, extranet and Intranet collaboration applications on SharePoint Server 2007/2010/2013/2016/2019 and SharePoint Online

My expertise extends to the Power Platform suite, including Power Apps, Power BI, Power Automate, and Power Virtual Agents. Leveraging these tools, I have developed custom applications that streamline processes, empower users, and transform raw data into actionable insights. By harnessing Power Platform's capabilities, I enable organizations to adapt quickly to changing business needs.

SharePoint Administration and Management experience includes PowerShell Scripting using SharePoint Management Shell and PnP PowerShell, management and configuration of SharePoint Accounts, Content Databases, Web Applications, Site Collections and Sites, configuring and managing service applications such as User Profile Service, Search Services, Secure Store and Business Connectivity Services.

Experienced in the design, development and implementation of Internet, Business applications

(using ASP, ASP.NET (C# & VB.NET), WCF, AJAX, PHP 5, MySQL 5, Smarty Templating Engine, JavaScript, jQuery, COM)

EDUCATION

BACHELOR IN INFORMATION TECHNOLOGY, INDIRA GANDHI NATIONAL OPEN UNIVERSITY – INDIA (2006)

HIGH SCHOOL GRAUDATE, TAGORE INTERNATION SCHOOL – INDIA (1999) PROFESSIONAL CERTIFICATIONS

Microsoft Certified Technology Specialist

.NET Framework 4, Web Applications

.NET Framework 4, Accessing Data

Microsoft SharePoint 2010

2

Microsoft Certified Professional

Querying Microsoft SQL Server 2012

Administering Microsoft SQL Server 2012 Databases

Microsoft Applied Skills

Create and Manage automate processes by using Power Automate CORE TECHNICAL SKILLS

SharePoint Online/2019/2016/2013/2010

SharePoint Migrations – SharePoint Migration Tool / ShareGate / MetaLogix

SharePoint PowerShell / SharePoint Online Management Shell / SharePoint CLI / PnP PowerShell

SharePoint Framework (SPFx) development

SharePoint Designer, InfoPath Forms

Power Automate/ Power Apps/ Power BI / Virtual Agents

Project Management

ASP.NET, MVC

Agile Methodologies

SQL Server – 2002/2004/2008/2012/2014

ACHIEVEMENTS & AWARDS

Created a SharePoint reporting solution that sends generates reports based on data collected from various third-party tools, collate, and send out these reports as emails to stakeholders at various levels of management which saves users from generating these reports manually thus saving a lot of precious time.

A set of multi-million-dollar projects were dead in tracks as the businesses were not able to store the documentation needed for the project in the right structure and format as the SharePoint Sites to store these documentations were not getting created due to a Microsoft and PnP Provisioning Engine error. I quickly troubleshooted & resolved the issue with these new SharePoint site collections and got these projects on track and came up with a solution in case such errors prop up again.

Investigated and determined the root cause of an On-Premises SharePoint environment performance issues where multiple in-house administrators failed to figure out.

Got recognized by Cargill’s HR Breakthrough Awards for successfully developing and deploying their Breakthrough System which is used by the entire organization to recognize exceptional solutions, services or innovations that has achieved positive impacts at Cargill. PROFESSIONAL EXPERIENCE

JULY 2018 – PRESENT

MICROSOFT 365 CONSULTANT, CARGILL INC (MN, USA)

Digital Business Operations and Services (DBOS) Team provides SharePoint customization services to other Cargill teams and departments. I am part of the DBOS team and help other teams at Cargill create custom solutions in SharePoint and Microsoft Power Platform. Roles and responsibilities:

Architected, designed, and developed various SharePoint Online sites for various departments. 3

Involved in executing the initial discovery phase to determine and help define the scope of the project.

Involved in creating the Project estimate, Project Plan and the proposal explaining the strategy for the project.

Effectively collaborating with Stakeholders to identify and address key pain points within the project and to formulate strategic recommendations to enhance project efficiency and mitigate challenges.

Involved in defining site architectures and taxonomy models.

Created design mockups and graphics.

Involved in investigation slow responding sites and figuring out the root cause and the help mitigating the issue.

Involved in creating various SPFx based web parts for various projects throughout Cargill.

Created multiple Power Automates in-order to automate various business processes.

Created multiple Power Apps both Canvas and Model-driven for various departments.

Created various Reporting solutions using Power BI.

Created chatbots using Microsoft Virtual Agents and Azure Cognitive Services.

Investigated a broken PowerShell based Provisioning process and remedy the issue that was affecting multiple billion dollars projects.

Deployed and configured PnP Modern Search Web Parts on various sites as the current OOTB web parts did not have the desired features.

Migrated content from multiple on-prem sites to SharePoint Online.

Converted legacy SharePoint On-prem custom solutions into SPFx based SharePoint online solutions.

Conducted multiple workshops to showcase the features of custom SharePoint Solutions.

Converted various InfoPath Forms to Power Apps Canvas App.

Converted SharePoint 2013 Designer Workflows to Power Automates. Below are some notable projects:

Build Project Document Management System (SPO, jQuery, PnP PowerShell, Power Automate), an application used to create Site Collections based on a template site using the PnP Site Provisioning script. The site provisioning script had not been working correctly and was erroring out consistently. So, we did a cause-analysis and figured out why the issue is occurring and then how to fix the issue to make sure that it does not occur again. This project also involves providing support for any issue that may occur while sites are provisioned using the automated process and at the same time add enhancements to the existing BPDM3 template.

EMEA Engineering Agreement Automation (SPO, SPFx, Power Automate), automated the creation of their Engineering Agreement Documents, instead of entering Project-related information directly into a word document template, the goal was to create a form for capturing the Engineering data, implement a multi-tier approval process, generate Engineering Agreement as a word document and then populate an existing custom list with updated data for reporting purposes via an existing Power BI Report.

QA/QC Reporting (Power BI, PowerShell, Power Apps), Power BI Solution created from data collected from various applications like Clarizen, SharePoint and Cargill Data Lake. Reports created are sent to Global and Corporate Leaders on a quarterly basis to showcase the progress of various Build Projects.

R&D Technical U Site Redesign (SPO, SPFx, Data Modelling, PnP Modern Search Web Parts), Engineered a solution that transformed a complex multi-site collection into a concise 5-page solution, optimizing accessibility and user experience.

S2C Wrapper (Power Apps Model-driven App, Power Automates, Dataverse), developed a Power App to facilitate the Source to Contract process. They wanted an easy-to-use portal for 4

the procurement practitioners and buyers of CSSP. The system also requires an automated communication process between the suppliers and buyers. Environment: SharePoint Online, jQuery, PnP PowerShell, PnP Modern Search Web Parts, Power Automate / Apps / BI, Dataverse, SPFx, ReactJS, Fabric UI, CDP. APRIL 2018 – JUNE 2018

SR. SHAREPOINT ARCHITECT, CIRRUS AIRCRAFT (MN, USA) Cirrus Aircraft is an aircraft manufacturer based out of Duluth, MN. Due to organizational transformation, they were looking to convert their Playbook to digital format in SharePoint online and then train the crew and the management to use it effectively. Roles and responsibilities:

Involved in the initial requirements analysis and gathering.

Involved in creating the Project estimate and the Project Plan.

Collaborated closely with Stakeholders to capture accurate business needs and translated them into actionable Project Specifications.

Involved in creating data dictionary.

Used PowerShell to create all the needed site columns, content types and custom lists.

Created SPFx webparts that would allow crew and the management to manage the Playbook.

Involved in unit testing and deployment.

Assisted with technical documentation and user manual. Environment: SharePoint Online, jQuery, PnP PowerShell, SPFx, ReactJS, Fabric UI. AUGUST 2017 – JUNE 2018

SR. SHAREPOINT ARCHITECT, SRS DISTRIBUTORS (TX, USA) SRS Distributors provides air medical emergency services and has collaborated with other such providers to provide seamless access to such services. The project involved troubleshooting the existing performance issue with the existing on-premises SharePoint farm that later transformed into creating multiple SharePoint custom solutions and migrating content from On-Prem to SharePoint Online. Roles and responsibilities:

Involved in assessment of the existing SharePoint Farm.

Conducted a technical review of the current SharePoint 2013 environment.

Involved in recommending SharePoint Best Practices for Document Repositories, Version Control, Tags and Metadata for Search, architecture of SharePoint Team Sites.

Creating workflows for handling users requests for creating Team Sites with a specific site structure with default Document Libraries and Lists.

Involved in creating recommendations for SharePoint Backup/Archival Processes

Developed and deployed several Nintex Forms and Workflows for processing the incoming data from various external sources.

Developed and deployed timer jobs for creating notifications based on business processes.

Defined and developed Information Architecture Plan, Implementation roadmap and Archival Strategies.

Conducted tests with various Migration tools like Sharegate, Metalogix, Saketa, etc. to determine the best migration tool.

Migrated the sites from SharePoint 2013 to SharePoint Online using Metalogix’s Essentials for Office 365 tool.

Created and implemented various test plans for testing the migrations. 5

Environment: SharePoint 2013, jQuery, PowerShell, C#, Nintex Workflows, Sharegate, Metalogix, Saketa.

JANUARY 2017 – JULY 2017

SHAREPOINT ARCHITECT, RAISING CANES (TX, USA)

Raising Canes corporate wanted to refresh their SharePoint Intranet with emphasis on responsive design, enhancements to Search functionality, department specific layouts and various other custom development.

Roles and responsibilities:

Conducted Technical review and planning of the current and the new environment.

Worked with the client in-order to hash out the new design – look n feel, master pages and page layouts.

Designed, developed, and implemented the responsive design.

Created various master pages for various web applications, page layouts for department sites.

Worked with the client in-order to determine the enhancements needed to Search and implemented them.

Created PowerShell scripts for deploying all the changes to the Production Environment. Environment: SharePoint 2013, jQuery, PowerShell, C#, .NET, Bootstrap. AUGUST 2016 – DECEMBER 2016

SHAREPOINT ARCHITECT, CED DALLAS (TX, USA)

CED Dallas is an electric distributor providing electrical products to its customers. The project involved migrating the content from SharePoint 2010 to all the way to SharePoint 2016. Their existing SharePoint 2010 environment had a lot of custom code which needed to be upgraded as well to make it compatible with SharePoint 2013/2016. They also needed support in managing their existing farm till their SharePoint Administrator would return from his vacation. Roles and responsibilities:

Analyzed and documented all the installed components, features, applications, and custom developments in the current SP 2010 Environment.

Worked with the client’s technical team to update their current custom code to make it compatible with SharePoint 2013/2016 environments.

Worked with offshore team to facilitate the migration process.

Created scripts and test plans for the migration.

Conducted test migrations to QA Environments in-order to uncover issues with custom code.

Troubleshoot and fixed various issues with custom code to make it compatible with SharePoint 2013/2016.

Modified InfoPath Forms with respect to accessing User Profile Services via from Basic Authentication in SharePoint 2010 to Claims Authentication in SharePoint 2013/2016.

Executed the migration to SharePoint 2013 and then to the SharePoint 2016 Environment.

Managing and checking the overall server health and functionality

Monitoring SharePoint disk space usage through the built-in SharePoint reports for each site collection

Managing SharePoint permissions

Analyzing and reporting upon SharePoint usage and activity 6

Regular review of the events and messages reported in Event Viewer and Performance Monitor

Handled SharePoint-related Helpdesk Tickets.

Environment: SharePoint 2010 / 2013 / 2016, PowerShell, C#, .NET, SQL Server, Windows Server. FEBRUARY 2016 – JULY 2016

SHAREPOINT ARCHITECT, XCEL ENERGY (MN, USA)

Xcel Energy HR department wanted to create a knowledge-based management system. I was to provide support to the HR Team in-order to build this system in SharePoint. Due to restrictions imposed by the Xcel Energy IT Team, the HR team ultimately decided to build this using ASP.NET, MVC, and Entity Framework.

Roles and responsibilities:

Involved in gathering and analyzing the requirements, evaluating the existing data and related procedures of the project.

Designed, developed, and architected the structure of the portal.

Developed UI with emphasis on responsive UI following corporate branding guidelines.

Managed and worked closely with offshore teams to meet Project deadlines.

Utilized the latest SQL Azure features to build a robust and reliable search feature with ranked results.

Developed a custom content versioning mechanism where content is automatically versioned along with the ability to restore a previous version.

Developed a google-like spell checker which checks the spelling of the searched text and suggests corrections.

Conducted various workshops to provide training to the end-user. Environment: SharePoint 2010, PowerShell, C#, .NET, SQL Server, Windows Server. SEPTEMBER 2015 – JANUARY 2016

SHAREPOINT ARCHITECT, AMERICAN GENERAL (IA, USA)

American General wanted to migrate all their content from SharePoint 2013 to SharePoint Online. Roles and responsibilities:

Conducted a technical review of the current SharePoint 2013 environment.

Worked with the client to discuss challenges, goals, and objectives.

Defined and developed Information Architecture Plan, Implementation roadmap and Archival Strategies.

Conducted tests with various Migration tools like Sharegate, Metalogix, Saketa, etc. to determine the best migration tool.

Migrated the sites from SharePoint 2013 to SharePoint Online using Metalogix’s Essentials for Office 365 tool.

Created and implemented various test plans for testing the migrations. Environment: SharePoint 2013 / Online, PowerShell, Metalogix’s Essentials for Office 365. APRIL 2014 – AUGUST 2015

BI & SR. SHAREPOINT DEVELOPER, GILLETTE’S CHILDREN HOSPITAL (MN, USA) The project involved designing and developing a Data Warehouse solution for a children’s hospital with data from a set of legacy medical applications for a non-profit healthcare provider with focuses on 7

pediatric medical treatment and research. It also needed to develop a SharePoint App which allows patients to take various surveys as ordered by the Provider American General wanted to migrate all their content from SharePoint 2013 to SharePoint Online. Roles and responsibilities:

Developed a SharePoint 2013 App which enables the IS and the Registration Staff to configure/manage and schedule surveys.

Developed a SharePoint 2013 App which enables the Patient to take various surveys on an iPad.

Developed a LIGHTSWITCH Application which enables operators to input responses to intake questions to calling patients so that the patients would not have spent a lot of time answering these questions when they come in for treatment.

Developed an LIGHTSWITCH Application which enables the physicians to enter data specific for speech and hearing-impaired patients and then transfer that data to the National Outcomes Measurement System electronically so that they run reports and compare their data to the National Average.

Developed a Branding solution with emphasis on user experience, cross-platform compatibility, and corporate branding guidelines.

Compliment SharePoint functionality and usability with custom user experience enhancements such as managed metadata-driven navigation, news tickers, accessibility improvements, etc.

Developed, implemented, and maintained technical structure for data warehouse and data mart.

Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.

Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2012 and in adding calculations using MDX.

Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2008 R2/2012 that maintained data. Involved in the complete data warehouse development life cycle.

Developed dashboard reports using Performance Point/Power BI 2013, Reporting Services and ad-hoc reporting using Report Builder.

Involved in gathering business data, analyzing the requirements, evaluating the existing data and related procedures of the project.

Worked extensively with the end-users of various departments to gather Business Data for the requirements and gave demos to the department heads.

Developed a Branding solution with emphasis on responsive UI and corporate branding guidelines.

Developed content-driven collaboration sites using custom site definitions and SharePoint Collaboration features.

Training internal department members on administration of SharePoint, governance, and best practices.

Automating various forms and workflow using SharePoint Workflow Manager. Environment: SQL Server 2008 R2/2012 – SSIS, SSAS, SharePoint 2013, HTML Light Switch 2013, .NET 4, C#, jQuery, and JavaScript.

SEPTEMBER 2013 – MARCH 2014

BI & SHAREPOINT DEVELOPER, REGIS CORPORATION (MN, USA) Regis is a big salon chain, and they had a Field Reporting Application built on .NET. They needed support in managing the Application and create new reports using the SSAS Platform. Roles and responsibilities:

8

Developed the Admin Module using ASP.NET with VB.NET which is used for configuring access to the reports as well as a feature of turning on/off any specific reports.

Developed reports to display Sales Information based on different Hierarchy Levels using Telerik Reporting.

Developed the Sales Dashboard which states past, current, and future targets for users based on their Hierarchy Level using Kendo UI Data Wiz Widgets and WCF.

Wrote MDX Queries to fetch data from the Cube for several reports with complex background logic.

Optimized a lot of reports and brought the load time down by more than 200%.

Created a small Controls Values Validation application to validate whether the pulled by a certain SSIS packages from the Source matches what is transformed into the Destination Database.

Environment: SSAS 2012, TELERIK REPORTS, MDX QUERIES, KENDO UI, .NET 4, C#, VB.NET, jQuery and JavaScript.

APRIL 2012 – AUGUST 2013

SR. SHAREPOINT DEVELOPER, HUNTER ROBERTS (NYC, USA) Hunter Roberts is a large construction group based out of NYC. They wanted to create a Contracts Management Portal in SharePoint. This portal includes, but is not limited to, the business processes, structure and resources that will be applied to the contract management phase. Roles and responsibilities:

Involved in gathering business data, analyzing the requirements, evaluating the existing data and related procedures of the project.

Developed project plan identifying key dates and resource requirements for the project.

Managed and coordinated day to day activities with two offshore teams.

Responsible for coordinating with the Technical Manager from the client’s side daily.

Involved in defining and developing the initial Application Architecture.

Involved in making sure that the application adheres to the defined scope and business processes.

Created a set of SharePoint 2013 timer-jobs which creates sub-sites based on a pre-defined site template and list item statuses residing under SP2010 environment.

Created a Partner Registration App using C#, .Net and approval process via SPD workflows.

I was involved in upgrading the farm from SharePoint 2010 to SharePoint 2013.

Created a custom Map web part that would display all the Project Site Locations on Bing Maps. Environment: SharePoint 2010 / 2013 / 2016, SharePoint Designer, PowerShell, C#, .NET, SQL Server, Windows Server.

OCTOBER 2005 – MARCH 2012

PROJECT MANAGER (IT), ROOT INFO SOLUTIONS PVT. LTD. (DELHI, INDIA)

Accomplished seamless initiation, planning, management, execution, control, and deployment of content-driven, CRM-based solutions, and E-commerce enabled web applications, ensuring project success and client satisfaction.

Interacted proactively with clients, extracting precise requirements, and executing project plans to deliver tailored solutions, fostering strong client relationships and project success.

Distinguished record of training and grooming fresh IT professionals, transforming them into future IT experts, measured by their enhanced skills and contributions to project success. 9

OCTOBER 2002 – SEPTEMBER 2005

PROGRAMMER ANALYST, CRESSANDA SOLUTIONS PVT. LTD. (DELHI, INDIA)

Accomplished the bridging of the gap between Web-Designers and Web-Developers, fostering seamless collaboration and synergy within cross-functional teams, resulting in enhanced project outcomes.

Analyzed, developed, and deployed content-driven and E-commerce enabled web applications, achieving optimal functionality and user experience, as measured by increased user engagement and satisfaction.

Demonstrated creativity and innovation by developing captivating 3D presentations for product promotion, measured by heightened visual appeal and increased product visibility. REFERENCES

Available upon request.

Contact this candidate