Post Job Free

Resume

Sign in

Power Bi Sql Server

Location:
Woodstock, MD
Posted:
July 05, 2023

Contact this candidate

Resume:

Sreekanth Payidi

Contact No: +1-410-***-****

Email-id: adx34k@r.postjobfree.com

Office 365 Administrator & Power Platform Developer and with Azure Administration

Professional Summary:

Around 12 plus years of experience with Office 365 and SharePoint (SharePoint 2016, SharePoint 2013, and SharePoint 2010) which involves developing and maintaining SharePoint Server Farm, Designing, Coding, and Implementing Web-based Applications with Microsoft Technologies (JavaScript, jQuery, Bootstrap, HTML, XML, and CAML).

Good experience in SharePoint Administration (SharePoint 2010, 2013, 2016, and SharePoint online).

Expertise in Office 365.

Knowledge On ADFS and Azure Active Directory and Enterprise applications configuration.

Experience in MS Flows, Teams, and Power Apps.

Expert in Canvas Apps and Model Driven Apps development in Power Apps.

Expert in Instant Flows, Automated flows, and Scheduled Flows in Power Automate.

Expert in Designing SharePoint List forms using Power Apps.

Expert in integrating Power Apps with Power Automate.

Experience in Power apps with CDS.

Experience in creating Dashboards in Power apps.

Designed and developed modern sites and Modern pages in SharePoint online.

Expert in Sites and Content types Provisioning using PnP Power shell.

Knowledge on MS Dynamics 365 tool.

Good knowledge of OOB functionality of MS Dynamics CRM Sales, Marketing, and service

modules. Customized complex applications on the Microsoft Dynamics CRM platform.

Expert in MS Graph and PnP Power Shell.

Experience in Migrating SharePoint 2010 designer workflows to MS flows.

Developed Azure Logic apps to integrate Office 365 Apps.

Expert in configuring and managing Service applications like Search service, Manage metadata, User profile service, BCS, Excel service, and Secure store service applications.

Expert in working on end-user issues and Outages of the SharePoint environment.

Expertise in Azure, OneDrive, and Teams.

Expertise in JavaScript, jQuery, and Bootstrap.

Hands -on Experience in Resolving Client and Server issues in SharePoint.

Expertise in Site Customization and Site Branding.

Expertise in Designing and developing workflows using SharePoint Designer.

Expertise in Windows PowerShell Commands & Scripts.

Expertise in Power BI, Power BI Pro, and Power BI Mobile.

Expertise in Business intelligence tools.

Expertise in Active Directory, IIS, DNS, and Authentication.

Experience in InfoPath Forms.

Expertise in SharePoint migration using Metalogix and Sharegate tools.

Experience in Deployments of Solution packages, custom workflows, custom web parts, Master pages & custom site templates from stage servers to Production servers.

Experience in SharePoint Backups and Restore.

Expertise in Analytics, Data usage, Event viewer, and troubleshooting and resolving issues in a Production environment.

Expertise in Document Management Systems and Content management systems.

Expertise in Nintex Workflows.

Expertise in Documenting the Design Specs, Test Cases, and Runbook.

Expertise in Office web apps.

Knowledge of MVC

Strong experience in system administration, upgrading patches, security, backup, disaster recovery, and performance monitoring.

Worked majorly on production environment support to monitor all the Azure services. Involved in minor code changes to the application and performing CICD in UAT, production.

Worked with various Azure services like Azure app services, Application insights, SQL database, and Azure API management. Working with Azure runbooks for automation tasks using PowerShell.

Have knowledge and experience in administering Microsoft SQL Server.

Strong leadership and teamwork skills, and able to use them effectively with sound technical knowledge to work in fast-paced, dynamic group environments.

Technical Skills:

Operating systems

Windows XP/2000, Windows 7, 8, 10

Programming Languages

C, C++, C#.NET

Web Technologies

Azure Devops, Azure Administration, SharePoint 2007/2010/2013/2016, SharePoint Online ASP.NET, XSLT, XSL, and CSS

Framework tools

.Net Framework 4.5/4.0/3.5

Mark-up languages

HTML, XML and CAML

Scripting languages

Java Script, jQuery, and AngularJS.

RDBMS

SQL Server 2014/2012/2008 R2/2008

Web servers

IIS

Certifications- Microsoft Certified Professional:

AZ - 104 - Microsoft Azure Administrator

Managing Office 365 Identities and Requirements

PL-400 - Microsoft Power Platform Developer

Core Solutions of Microsoft SharePoint Server 2013

Advanced Solutions of Microsoft SharePoint Server 2013

Administering Microsoft SQL Server 2012/2014 Databases

ITIL Certified

Professional Experience:

Projects Worked on:

Name of the Project

SharePoint Online

Client

TTX

Location

Chicago

Duration

Mar 2023 – Present.

Position

Power Platform Architect.

Description

TTX Company (formerly TrailerTrain) is a provider of railcars and related freight car management services to the North American rail industry. Worked as a Power Platform Developer for the internal operation. Using Power Apps and Power Automate built the internal application for TBS and Client contact confirmations.

Responsibilities:

Analyzing the requirements and raising queries or concerns on status Calls.

Worked on Power Apps and Flows.

Converted legacy applications to office apps.

Converted manual process to automation using Power platform.

Generated Reports and displayed them in the company portal using Power BI tools.

Involved in migrating all the subsites using the Sharegate tool from SharePoint 2010 to Office 365.

Involved in configuring Out of the box SharePoint search and created a custom item display template to display search results.

Involved in creating workflows using Nintex.

Worked on SharePoint Power Apps with Common Data servicing connector and customization forms.

Managing Azure Resources (Databases, App Services (Client, Services, tasks))

Monitoring and managing Virtual Machines including patching.

Monitoring APIs and API Access Management.

Monitoring and managing Power BI reports.

Environment: Office 365, SQL Server 2012, PowerApps, Power Automate, Power BI, Azure, SQL Server,

JavaScript, jQuery, HTML, and CSS.

Name of the Project

Office 365 Support and Migration (On-Premises to Cloud)

Client

Bain Capital

Location

Boston, London, Europe

Duration

Oct 2021 – Mar 2023.

Position

Office 365 Administrator and Power Platform Architect.

Description

Bain Capital is an American private investment firm based in Boston. It specializes in private equity, venture capital, credit, public equity, impact investing, life sciences, and real estate. Bain Capital invests across a range of industry sectors and geographic regions. The client wanted to migrate to Office 365 from the existing on-prem environment using Sharegate.

Responsibilities:

Migrating the sites from On-premises to SharePoint Online using the Sharegate tool.

Migrating InfoPath forms to PowerApps.

Migrating SharePoint Designer flows to Power Automate.

Utilized existing forms, converted them to PowerApps from scratch, and upgraded to the latest functionality.

Users and Group management in Office 365.

Designed SharePoint list forms using PowerApps.

Integrated Power Automate & Power BI to the Power Apps

Created a scheduled flow to push certain cell values from Excel to the database table using Power Automate.

Developed Notification flows and Document Approval flows using Power Automate.

Developed Spare Parts Canvas app, modernization app, Production details app, and Design Collection app using Power apps.

Designed and added a Power BI Production dashboard to the Canvas apps.

Collected data from SQL to design Dashboards in Power BI.

Stored and retrieved data from CDS in Power apps.

Created and developed Power BI Dashboards into a rich look.

Integrated Power BI reports in Power Apps and SharePoint Modern pages.

Collected data from SQL to design Dashboards in Power BI.

Written SQL Queries as per Business requirements.

Worked with Business Analysts, and clients to review the business requirements, and prepare technical design documents and non-functional and functional prototypes as needed.

Performed day-to-day SharePoint administration, maintenance, and management of site collections and enterprise applications/platforms and monitoring and the scheduled jobs as required.

Managing Azure Resources (Databases, App Services (Client, Services, tasks))

Monitoring and managing Virtual Machines including patching.

Monitoring APIs and API Access Management.

Environment: Office 365, SQL Server 2012, PowerApps, Power Automate, Power BI, Azure, Sharegate

SQL Server, JavaScript, jQuery, HTML and CSS.

Name of the Project

OneDrive/SharePoint Migration

Client

Isagenix International

Location

Arizona

Duration

March 2019 – September 2021.

Position

SharePoint & Power Platform Developer

Description

Isagenix International LLC is a privately held multi-level marketing (MLM) company sells dietary supplement products such as protein shakes, weight loss supplements, and diet snacks and meals, as well as cosmetics. The Isagenix diet involves consuming Isagenix products, low-calorie meals, and shakes for 30 days, along with other products like cleanses and supplements.

Responsibilities:

Migrated SharePoint 2010 designer workflows to MS flows.

Designed SharePoint list forms using PowerApps.

Developed Spare Parts Canvas app, modernization app, Production details app, and Design Collection app using Power apps.

Designed a Power BI Production dashboard and added it to the Canvas apps.

Designed Analytics in Power BI.

Collected data from SQL to design Dashboards in Power BI.

Stored and retrieved data from CDS in Power apps.

Worked on Power App delegations.

Integrated Azure DB with SharePoint document libraries using MS Flows.

Worked on configuring Azure DevOps for CI/CD pipelines.

Automated the process of deployments using CI/CD pipeline using Azure DevOps.

Collected all reports from the master data and notified business users using Scheduled flows.

Developed Notification flows and Document Approval flows using Power Automate.

Provisioned Site columns, Content types, and Sites using PnP Power shell.

Created a BatchFX jobs and scheduled them to run on a daily, weekly, and monthly basis.

Created a Windows application tool for end users (Grid View) to take the decisions for their external partners and capture their decisions using serialize and deserialize.

Created storage space Increase page for Office 365 sites using Graph APIs

Developed Site Deletion and Site Restore pages using CSOM Graph API (Nothing OOB).

Created OneDrive deletion job if users don’t attest it within a week using C#.

Created a OneDrive Attestation page using ASP.Net.

Created a Windows application to export the data from Excel to SharePoint list.

Created storage space Increase page for Office 365 sites using Graph API’s

Developed Self Service reports for end users using SQL and JavaScript.

Developed training landing page and Quiz page for end users.

Created a tool to add the users in OneDrive groups and grant the OneDrive license by refining from different groups.

Created a tool to add reports to the manager as an addition admin to the OneDrive sites where the users left the company (managing Inactive OneDrive)

Created a job to sync the SharePoint list to SQL database table.

Extensively used User interface controls which use jQuery to validate client-side validation.

Assisting Business partner on their SharePoint issues.

Worked with Business Analysts, clients to review the business requirements, prepare technical design documents and non-functional and functional prototypes as needed.

Performed day-to-day SharePoint administration, maintenance, and management of site collections and enterprise applications/platforms and monitoring and the scheduled jobs as required.

Created runbooks/test cases and keep them updated with the latest version.

Environment: SharePoint 2016, Office 365, ASP.Net, C#, SQL Server 2012, PowerShell, SharePoint

Designer 2013, MS Flow, PowerApps, Power BI, Azure, Sharegate, Metalogix tool, Visual Studio and

JavaScript.

Name of the Project

Registered Child Data Services

Client

World Vision RCDS

Location

California

Duration

August 2018 – April 2022.

Position

Office 365 & Azure Administrator and Application Support Engineer

Description

World Vision International is an Evangelical Christian humanitarian aid, development, and advocacy organization. It prefers to present itself as interdenominational and employs staff from non-evangelical Christian denominations. For their internal children records management, they use the Registered Child Data Services Portal. We have Developed and maintaining and managing World vision RCDS.

Responsibilities:

Monitor and manage resources and log analytics. Involved in minor code changes to the application and performing CICD in UAT and production.

Monitoring and managing Registered Child Data Services Application (Production and UAT)

Application access management and Application Support (Providing details of issues and information using Database queries)

Managing Azure Resources (Databases, App Services (Client, Services, tasks))

Monitoring and managing Virtual Machines including patching.

Monitoring APIs and API Access Management.

Monitoring and managing Power BI reports.

Monitoring and managing files under storage explorer.

Adding new users, creating groups, setting permissions

Worked on Service requests from users on email accounts and password resets.

Troubleshoot active sync issues with mobile devices.

Troubleshoot issues with Microsoft 365 Teams.

Helped team to ensure performance meets or exceeds defined Service Level Agreements.

Maintaining and Managing Azure Active directory users and groups.

Monitoring Sync service between Active directory and Azure AD.

Creating and Managing enterprise applications in Azure AD.

Environment: Office 365, Microsoft Azure, Azure File Explorer, API’s, SQL Server 2014, Power BI, JavaScript,

jQuery, HTML and CSS.

Name of the Project

Office 365 Admin Support and Office Migration from 2013 to 2016

Client

Versum Materials

Location

Tempe, Arizona.

Duration

June 2017 – July 2018.

Position

SharePoint & Power Platform Developer.

Description

Versum Materials is a premier specialty materials supplier to the semiconductor industry separated from the world-leading Industrial Gases Company Air Products. We have worked on migrating 3500+ existing SharePoint sites from Air products to Versum using the Metalogix migration tool. Worked on migrating 2000+ mail accounts including mailboxes, and one drive files from office 2013 to 2016 in AP to Versum transformation.

Responsibilities:

Involved in Requirement gathering from the Business users and prepared documentation.

Adding new users, creating groups, setting permissions

Worked on Service requests from users on email accounts and password resets.

Implementing new functionalities using client scripting in Versum SharePoint.

Migrating mail accounts from Office 2013 to 2016.

Migrating Shared drive folders.

Work with end-users to configure Outlook and OneDrive sync.

Designing of Master Pages, Application Pages, Site Pages, Page layouts, content types, ribbon customization, and Custom Site definitions.

Backup and recovery of Site Collections and Sub sites.

Decommissioned the Sites for Repurposing.

Documented the design specs and test cases and Runbook on projects I worked on.

Environment: Office 365, SharePoint online, Metalogix, PowerShell C#, XSLT, XML, CAML, JavaScript, jQuery.

Name of the Project

Maintaining and managing

Client

Hess Corporation

Position

Office 365 Administrator & SharePoint Developer and Admin.

Duration

May 2015 – June 2017.

Location

New York.

Description

The project's main intention is to support Office 365 Administration and maintain all-intranet SharePoint sites for Hess Corporation under SharePoint 2007, 2010 and 2013. Client performs collaboration activities through SharePoint. They have different versions of SharePoint environments for collaboration. Also, integration with SSRS reports and SAP integration with SharePoint.

Responsibilities:

Adding new users, creating groups, setting permissions

Troubleshooting Technical issues on OneDrive, Teams, and SharePoint

Created PowerShell Script to configure service application.

Maintaining the servers, sites, and deployments in production environments.

Troubleshooting and fixing issues as per the tickets assigned in ServiceNow.

Implementing custom WSP’s additional enhancements in dashboards and extranet sites.

Environment: SharePoint 2013, SharePoint 2010, SharePoint 2007 Visual Studio 2012/2010/2008, SQL Server 2012/2008 R2/2008, PowerShell C#, XSLT, XML, CAML, JavaScript, jQuery

Name of the Project

Internal Portals

Client

Neudesic India

Position

SharePoint Administrator & Developer.

Duration

Sep 2015 – Mar 2016.

Location

Hyderabad, India.

Description

Internal portals for my organization. Worked on creating a Vacation portal with SharePoint 2013 custom functionalities. Also created a site called Connect to store all HCM, Finance related documentation, and end-user inquiries. Created a new portal for IT incident management. All the sites will have internal workflows (Custom and designer) workflows for different levels of approvals and email triggers. Worked on timer jobs and admin activities.

Responsibilities:

Understood the requirements through discussion with the Team.

Analyzed the requirements as per the discussion and raised queries or concerns.

Attended Scrum call daily to update the development progress.

Worked on Nintex workflows to create multiple levels of approval creating Timer Jobs for sending emails.

Created custom Master pages and page layouts.

Created Custom Lists, Libraries, Pages, and web parts.

Managed SharePoint Online user profiles.

Assigned admin roles to users.

Involved in custom deployments.

Configuring and administering User profile service applications using the central administration console.

Environment: SharePoint 2013, Visual Studio 2012/2010/2008, SQL Server 2012/2008 R2/2008, PowerShell C#, XSLT, Nintex, XML, CAML, JavaScript, JQuery

Name of the Project

SharePoint Online Support

Client

Memorial Care

Position

SharePoint Administrator & Developer

Duration

Aug 2014 – Feb 2015.

Location

California.

Description

Memorial Care is a leading nonprofit health system in Orange County and Los Angeles County that includes four hospitals, two medical groups, imaging centers, surgical centers, and much more. We have big dreams for the future of healthcare, so we work every day to make high-quality care easier to access and more affordable.

Responsibilities:

Configuring and administering User profile service application using central administration console.

Responsible for configuring and administering Search service application using the central administration console.

Performing various SharePoint administration activities using SharePoint2010 Management Shell.

Creating Timer Jobs for sending emails.

Managed SharePoint Online user profiles.

Assigned admin roles to users.

Involved in custom deployments.

Migrating SharePoint sites.

Name of the Project

Internal Portal

Client

All Med

Position

SharePoint Administrator & Developer.

Duration

Oct 2013 – Aug 2014.

Location

New York

Description

All Med is a SharePoint 2010 developed for internal activities. The client needs two processes for request changes, control tracking and incident management policies. Change control includes tracking, analysis, and evaluation of change requests and the implementation and evaluation of changes. Incident Management Policy establishes formal processes for detecting, reporting, analyzing, and mitigating threats or violations of security policies and/or controls. Also includes a process to convert Excel files to CSV format.

Responsibilities:

Implemented custom styles to the site and site template.

Developed custom workflows.

Custom command ribbons for Excel to CSV conversions.

Created a WSP Package using Visual Studio 2010 to make the deployment process easy for the client.

Environment: SharePoint 2013, SharePoint 2010, Visual Studio 2010, SQL Server 2008 R2, C#, XSLT, XML, CAML, JavaScript, JQuery.

Name of the Project

SASBU Angola

Client

Chevron

Position

SharePoint Administrator & Developer.

Duration

Aug 2012 – Oct 2013.

Location

California

Description

SharePoint Assessment project. The client had many site collections and needed to check Governance, IRM requirements, Complains, IM policies, Branding, etc. We had to prepare the As-Is-State and To-Be-State documents by verifying the configurations on the existing system. By comparing As-Is-State with To-Be-State, need to provide the Gap analysis document. The gap analysis will help to provide recommendations for the new system.

Key features of this project,

I.Assessment for the 66 site collections

II.Assessed the Governance, IRM requirements, Complains, IM policies, Branding in all the Site collections that adhere to GSPS standards.

Responsibilities:

Member of a Work Port support team which is responsible for SharePoint2010 Administration activities.

Responsible for Installing and configuring SharePoint server 2010 in standalone and server farm environment.

Creating and configuring Web Applications, Site collections, Sub Sites, lists and various Service Applications.

Configuring and administering user profile service application using central administration console.

Responsible for configuring and administering Search service application using central administration console.

Performing various SharePoint administration activities using SharePoint2010 Management Shell.

Troubleshooting the SharePoint errors using diagnostic logs in “14 Hive” directory.

Backup and Restoration of various databases using SqlServer2008, PowerShell and Central Administration console.

Deploying and managing SharePoint solution packages, sandbox solutions, and user solutions using PowerShell cmdlets.

Creating and configuring Websites on IIS 6 & 7 based on requirements.

Monitor and analyze a SharePoint environment and optimize the performance of a SharePoint farm.

Knowledge in migrating from SharePoint 2007 to SharePoint 2010.

Responsible for configuring and managing Service Accounts and Managed accounts using Central admin console.

Exposure on Active directory user and group management based on project requirement.

Responsible for configuring and troubleshooting the workflows in sharepoint2010.

Responsible for setting up the environment from scratch level based on the requirement.

Responsible for coordinating and implementing best practices in SharePoint 2010 farm setup.

Creating and managing security permissions for various sites, sub sites, lists and libraries.

Configuring and administering Managed Meta Data Service, Business Data Connectivity Service and Secure Store Service.

Worked extensively on SharePoint Central Administration management console for various SharePoint Administration activities.

Environment: SharePoint 2010, SharePoint Designer 2010, HTML, CSS, JavaScript, jQuery

Name of the Project

SharePoint Intranet application

Client

Virginia Mason Medical Centre

Position

SharePoint Administrator & Developer.

Duration

May 2011 – August 2012.

Location

Seattle, Washington

Description

SharePoint Intranet application portal for the hospital management system. A new item will be logged for every patient. A new workspace will be added for every patient. Each workspace will have its own calendar, Action task, and Corrective Plan lists with workflows. Will have a new workflow to grab all the changes in the site Customer Details plan list and workflows for the list item.

Key features of this project,

I.Creation of Designer workflows and Custom sites.

II.Creation and Content Query web part to pull the data from all the child site lists.

Responsibilities:

Troubleshooting various application issues using IIS error codes and site creation in IIS.

Responsible for Windows services installation and issues during installation.

Responsible for checking the firewall connectivity between the servers.

Responsible for creating and managing Windows MSMQ and providing permissions.

Worked on SharePoint farm setup and web applications, sites, and list creation using central admin and PowerShell.

Responsible for configuring friendly URLs for SharePoint web applications and Host header updating in the IIS server.

Creating and configuring Business Data Connectivity Service, Managed Meta Data Service, Secure Store Service, and User Profile Service Applications.

Responsible for configuring and troubleshooting the workflows in SharePoint 2010.

Responsible for Content DB backup and restorations using PowerShell, Central Admin Console, and SQL Server 2008.

Worked on Power Shell scripts to deploy the features, solutions, and web parts.

Responsible for troubleshooting the issues in sharepoint2010 with corresponding correlation id.

Environment: SharePoint 2010, Visual Studio 2010, SQL Server 2008 R2, C#, XSLT, XML, CAML, JavaScript, jQuery

Name of the Project

Portal

Client

Pay Northwest

Position

.Net Developer.

Duration

Feb 2011 – Mar 2011.

Location

Washington.

Description

Pay Northwest is a provider of payroll, time and attendance and other employer services to small and medium-sized businesses and not-for-profit organizations. Pay Northwest is dedicated to returning peace of mind and business focus to clients and their employees. Its goal is to relieve clients from administrative and regulatory burdens and deadlines; reduce costs associated with payroll and labor management; provide outstanding customer service, flexibility, and reliability; and deliver added convenience and value to client employees.

Responsibilities:

Worked on new form changes and new pages ‘About us’ and ‘Contact us’ changes in DB queries for forms.

Updating existing pages.

Modifying existing stored procedures in DB as per new changes in the forms.

Worked on showing the latest news and tweet feeds on Home Page.

Environment: Visual Studio 2010, SQL Server 2008, Active Directory

Education Qualification:

Bachelor’s in Electronics and Communication Engineering from JNTUH University May 2008.



Contact this candidate