Power Bi Developer

Gaurav Patel

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

Phone: 203-***-****

Current Location: Nashville Tennessee

Power BI Developer/SharePoint Administrator

Work Authorization: US Citizen

** ***** *f experience working as Power BI Developer/SharePoint Administrator/IT Analyst.

Skills

Power Platform: Power BI (Power Query, ETL, DAX, SQL, Data Visualization, Data Transformation, Data Modeling, Data Analysis, Database Administration), Power Apps (Dataverse, canvas, model-driven), Power Automate. Tableau. Microsoft SharePoint On-Prem 2010, 2013, 2016, 2019, SharePoint online, Windows Workflow Foundation, Active Directory, Azure AD. Windows Sever: 2000, 2003, 2008 and 2012. IIS Servers: IIS 5.0/6.0/7.0/8.0/8.5. Microsoft Office 365 [Word, Excel (Pivot Tables, Sum, Macros, Average, VLOOKUP, Other formulas), PowerPoint, MS Visio, MS Outlook, MS OneDrive for Business, MS Teams]. Software Methodologies (SDLC): Waterfall Model, Agile Development (Scrum). Tool: Jira. Operating System: Windows, Linux, IOS, Android. Ticketing tool: ServiceNow. Workflow tools: Microsoft InfoPath 2003/2007/2010/2013, Microsoft SharePoint Designer 2007/2010/2013, Nintex. Database and Tools: RDBMS, SQL, Microsoft SQL Server, SSIS, SSRS, T-SQL. Frameworks: HTML, JavaScript, .NET Framework 1.1, 2.0, 3.0, 3.5, 4.0, 4.5, Windows PowerShell. Migration Tools: Sharegate. Messenger tools: Skype for Business, Webex, Lync, MS Teams, Zoom, Cisco jabber.

Collaboration, Prioritization, Visualization, Leadership, Organized, Problem solving, Quick Learner, Effective Communication, Able to work with team and Independent as well, Documentation, Innovation, Project Management, Product Management, Software as a Service (SaaS), ETL, KPIs, Data Visualization, Site and Account Management, Server management, Training Employees and End users, Troubleshooting and support, Security and Permissions, Scripting, Backup and Restore, Import and Export, UAT, Testing, Technical, Analysis, Business Requirements, Requirement Gathering,, Cross-Functional Teams, General Monitoring and Maintenance.

Professional Experience

Power BI Developer

EY, Feb 2024 – Oct 2024

•Gathered data from different sources including Excel, CSV, SQL, Sharepoint and other data sources.

•Transformed the data and produced reports by using the Power BI platform.

•Developed 25+ reports and dashboards resulting in a 30% increase in operational efficiencies.

•Collaborated with the cross-functional teams to identify data sources resulting in a 20% reduction in report development time.

•Improved dashboards functionality by implementing interactive visualizations resulting in a 20% increase in user engagement.

•Identified KPIs with outlined objectives and consistently monitor them.

•Improved overall decision-making 25% by designed and developed BI Reports and providing valuable insights.

•Collaborated with Managers and business users, collected requests, and updated existing BI reports to accommodate business needs.

Power BI Developer / SharePoint Administrator

Alabama Power Company, June 2020 – Nov 2023

•Assisted stakeholders, managers regarding requirements for contents, requests, and update on tickets and incidents on regular basis.

•Consistently ensured compliance with SDLC and agile ceremonies, enhancing project delivery adherence.

•Gathered and analyzed data from different sources including CMDB, SAP, APIs, SQL, Azure and Excel.

•Designed and developed reports and dashboards by using the Power BI platform.

•Developed over 50 reports and dashboards resulting in 30% increase in operational efficiency.

•Collaborated with the finance team to develop a financial reporting dashboard resulting in a 50% reduction in report development time.

•Developed self-service management dashboards, leading to a 20% increase in speed of data analysis

•Enhanced data reporting processes by developing Power BI reports and dashboards.

•Create training documentation to provide Knowledge transfer to other team members.

•Supported and administrated SharePoint Online Office 365 version.

•Helped end users regarding their requests and troubleshot their issues also helped them with providing training and guided materials.

•Helped users to create site collection and guided them how to create subsites, lists, libraries, Web Parts, Site permissions, Online flow, Workflow etc.

•Regular Monitored overall system health, outages, and functionality in Office 365.

•Implemented and maintained security measures to safeguard data and applications in Office 365.

•Helped and troubleshoot user’s issues about customize lists, Mail Flow, pages, Web part, Object provisioning etc.

SharePoint Administrator

Arizona Public Service, Phoenix AZ - Sep 2019 – June 2020

•Assisted end users and provided solutions with troubleshooting with P3, P4 INCs and Workorders tickets as per SLA timeline requirement.

•Helped and provided training to users and teams on their request of how to use different functionalities of SharePoint 2013 on-prem and SharePoint Online Office 365 Sites.

•Supervised and assisted offshore migration team about new external user’s functionality project which will be introduced by company in new SP Online environment.

•Provided appropriate actions and suggestions to team, PM, and supervisors regarding end-to-end functionality aspects from IT architecture team, Service improvement plans, Creating SOP (Standard Operating Procedure) document, Azure AD team, data security and network team to avoid roadblocks before projects release.

•Assisted end users to create Nintex workflow and helped them with their query.

•Created new extranet SharePoint sites, added web part page and new contents which were requested by project supervisor and assistant product manager in new SharePoint online environment.

•Experienced working with cross-functional teams.

•Performed designing, Analyzing and solved Application/Server related issues on regular basis.

•Executed User Acceptance Testing in Test and Prod environment as an existing and new extranet user to check functionality's response and results.

SharePoint Analyst

ADM, Decatur IL - Feb 2019 – Sep 2019

•Administered and supported SharePoint 2010 server.

•Assisted end users and stakeholders on identifying requirements for contents, requests, and tickets within SLAs.

•Managed and checked the overall server health and functionality on a regular basis.

•Monitored and analyzed SharePoint usage and activity, SharePoint disk space usage through the built-in SharePoint reports for each site collection.

•Executed PowerShell scripts to import and export sites, backup and restore, migration of sites and automation of process.

•Managed SharePoint Groups and permissions for domain users and helped PSCA and SSCA regarding Site permissions and permission levels.

•Regularly audited SharePoint environment.

•Participated and assisted SP Developers for SPFx activity.

•Provided ongoing maintenance of the SharePoint portal.

•Involved in service improvement plans for existing functionalities.

•Ensured product quality and timeliness of effort.

•Worked Closely with SME and Migration team for migration (SP 2010 on-prem to SP 2016 on-prem and SharePoint Online/Office 365 Hybrid Environment).

•Shared creative ideas and innovative approaches to build robust capabilities that facilitate collaboration across the project team as well as other key stakeholders.

SharePoint Administrator

Pacific Gas and Electric Company, San Ramon CA - Aug 2017 – Feb 2019

•Perform day-to-day activity like working with end users regarding their different requests (work order and INC) within SLA on identifying requirements for customization and site contents.

•Helped users to create site collection and guided them how to create subsites, lists, libraries, Web Parts, Site permissions and permission levels etc.

•Regularly Monitor and checked the overall server health and functionality.

•Helped users to customize lists, pages, and web parts.

•Regularly monitored events and messages in ULS viewer, event viewer and troubleshooted issues on the portal.

•Regularly reviewed, cleaned-up, managed and configured SharePoint accounts and sites.

•Helped end users to create Microsoft Workflow.

•Helped and involved in patching and maintenance activities for Windows & Exchange servers.

•Monitored SharePoint disk space usage through the built-in SharePoint reports for each site collection.

•Managed Services and managed SharePoint permissions and guided PSCA and SSCA on how to give assign site permission and permission levels to their team members.

•Analyzed and reported upon SharePoint usage and activity.

•Helped and assisted users with Nintex workflows end to end process.

•Provided ongoing maintenance and patch support of the SharePoint portal.

•Configure SharePoint sites to achieve desired functionality based upon business requirements.

•Configured the search center, scheduling the crawls, managed the scopes and different content sources.

•Executed PowerShell scripts to import and export sites, backup and restore, migration of sites and automation of process.

•Checked for operating system, SQL Server and SharePoint patches and cumulative updates.

•Configured My Site for each user to show their profile and personalized page.

•Configured the Enterprise search center, scheduling the crawls, managed the scopes and different content sources like external Site and file share.

IT Analyst (Implementation Coordinator)

State Farm Insurance, Bloomington IL - Feb 2015- Aug 2017

•Gathered and documented customer requirements and applied Agile methodology.

•Helped associates to provide capacity to capture and save mileage information in the process for Application

for data recording purposes and Coordinate all Digital department releases, B2B, B2C, and B2E applications deployment.

•Assisted and responsible for managing deployment activates once the Project is handed to deployment team by Project Manager.

•Responsible for planning, coordination of software releases, patches, and emergency change requests.

•Responsible to assign tasks to Implementation coordinators (On site and Off site).

•Responsible for monitoring progress of deployment activates and gathering updates from Implementation Coordinator.

•Participate in all major Production releases.

•Collect updates from the Implementation coordinator and project team for production and post-production activities.

•Participate in implementation and back-out testing and business checkout assistance.

•Experienced working with cross-functional teams.

•Documented plans change to identify key dependencies and develop Release plans.

•Created a project closer report after deployment.

Certification: PL-900: Microsoft Power Platform Fundamentals.

Education Details

Bachelor of Commerce in Accountancy from Gujarat University, Graduated in 2003

MBA in Business Management from University of North Alabama, Graduated in 2008

Contact this candidate