Power Bi Automate

TECHNICAL SUMMARY

* ***** ** ********** ** Microsoft SharePoint On-Premises, SharePoint Online, and Office 365.

Extensive expertise in Microsoft Power Platform tools: PowerApps, Power Automate, Power BI, Microsoft Teams, and OneDrive for Business.

Proficient in creating Canvas apps, Model-driven apps, Power automate workflows and Power BI reports and dashboards.

Experienced in designing and developing canvas and modern-driven applications, with a strong focus on ensuring full compliance with Section 508 accessibility standards.

Skilled in developing and optimizing Dataverse databases for model-driven apps, ensuring efficient data management and seamless app performance.

Strong knowledge of creating various solutions using out-of-the-box features in SharePoint 2010/2013/2016, and SharePoint online environment, such as, web parts, workflows, Site Column, Content Types, Target Audience, permission.

Created workflow to automate business process using Power Automate with multiple connectors and conditions.

Involved in Software Development Life Cycle (SDLC) from requirement gathering to production and post-production stages,

Hands-on experience with migration from SharePoint on-premises to SharePoint Online/Office 365 using Sharegate.

Conducted comprehensive unit testing to identify and resolve software defects early in the development cycle, significantly reducing the incidence of bugs in later stages and improving overall product quality.

Well-versed in creating custom forms and workflows using Nintex forms and Nintex workflows to automate business processes in SharePoint applications.

Created client-side object models using CSS, JavaScript, and HTML along with jQuery to manipulate SharePoint data and to customize SharePoint lists, and libraries.

Integrated RESTful APIs with PowerApps and SharePoint using JSON to enable secure, real-time data access from external systems.

Involved in implementing Agile project management methodology, in all phases of SDLC and supporting and mentoring company SharePoint users.

Implemented scalable, secure solutions with role-based access control in Power Apps and SharePoint,ensuring compliance with data governance and IT security policies.

Collaborated with cross-functional teams and presented technical solutions to non-technical stakeholders, ensuring alignment with business needs and driving user adoption.

Authored clear documentation, training materials, and user guides to support solution rollout and empower business users with self-service capabilities.

Highly motivated, self-disciplined, detail-oriented, and well-organized.

Experienced in integrating Egnyte with SharePoint to enhance document security, manage file sharing and permissions, and ensure compliant archival and deletion of sensitive documents.

TECHNICAL SKILL

MS SharePoint Technologies: SharePoint Designer 2013, InfoPath Designer 2013, SharePoint 2010, 2013, 2016, 2019, SharePoint Online, Microsoft Teams, Microsoft Form, Microsoft Power Platform, Microsoft Dynamics 365, Microsoft Graph API, Azure Logic Apps, SSRS, and SSIS

Programming Language: C# and python

Data security: Egnyte

Workflow: SharePoint Designer 2013, Nintex, and Power Automate (Flow)

Database: MS SQL Server 2016/2012/2008/2005

Scripting Language: JavaScript, jQuery, HTML5, CSS, CSS3, Bootstrap, Angular, and React

Migration tool: Sharegate

Version control: Git

Agile methodology: JIRA

Data analysis: Tableau and Power BI

Ticketing Tools: ServiceNow and Remedy

Cloud Computing: AWS and Azure

CI/CD: Azure DevOps

Virtualization: Docker and Kubernetes

Linux Distributions: Ubuntu and CentOS

1.AMERI HEALTH (APRIL 2023–PRESENT) WASHINGTON DC

SharePoint / Power Platform Developer

Responsibilities:

Designed and developed applications using Microsoft Power Apps and automated business process using Power Automate with multiple connectors and conditions.

Built and automated the nomination process using PowerApps and Power Automate and developed detailed reports with Power BI.

Proficient in designing and implementing integrated solutions utilizing Power Apps, MS SQL, Active Directory (AD), and MS SharePoint to drive optimized data management, secure access control, and improved collaboration.

Implemented Document Approval System using Power Apps and Power Automate for streamlined processes.

Developed advanced folder permission workflows using Power Automate to enhance data access control and security.

Configured user roles and permissions within Power Apps environments to control access and maintain data integrity.

Developed a dynamic onboarding dashboard using Power BI, integrating SharePoint lists and SQL databases for comprehensive insights into the onboarding journey.

Developed and maintained efficient data connections within PowerApps, ensuring seamless integration with various data sources for reliable and consistent data access.

Experienced in implementing both managed and unmanaged solutions within the Power Platform environment.

Provided user training and support on basic security measures and ALM practices to promote awareness and compliance.

Proficient in creating and managing Teams and channels in Microsoft Teams, enabling effective organization of project discussions, file storage, and meetings across teams and departments.

Developed pre-migration documentation and executed post-migration validation using PowerShell and Sharegate 20, ensuring a seamless transition to SharePoint Online with minimal disruption to end-users

Experienced in developing and optimizing Dataverse databases for model-driven apps, ensuring efficient data management and seamless app performance.

Integrated APIs into PowerApps to access and utilize external data.

Developed a custom SharePoint Framework web part to enhance user experience and streamline data presentation on SharePoint sites.

Developed PowerShell scripts to automate tasks, such as app deployment, environment setup, and data migration.

Leveraged Azure services, such as Azure Functions and Azure Logic Apps, to build scalable and robust backend processes.

Prepared documentation for Power users and Application owners.

Provided Technical Support, Troubleshoot issues and bugs through help desk ticket request as well as direct request from the client.

Designed and developed canvas and modern-driven applications, ensuring full compliance with Section 508 accessibility standards.

Designed an asset request form and automated the process using Power Automate, using Power BI for generating insightful reports.

Participated in Agile Scrum meetings to drive clear communication and progress in software development projects.

Designed, developed, and maintained custom SharePoint themes, templates, master pages, and page layouts to enhance branding and optimize the user experience, leveraging best practices in UI/UX design.

Applied advanced relational database concepts to design and optimize data storage schemas within PowerApps, enhancing data integrity and performance.

Designed the intranet using Hub sites during migration to make the search and navigation capabilities.

Managed permissions effectively by utilizing Office 365 groups, SharePoint groups, and Security groups.

Analyzing, visualizing, reporting, and aggregating data in dashboards using Power BI in Office 365 Environment.

Participated in code reviews, ensuring adherence to best practices and quality standards.

Designed end-to-end automated workflows for operations teams, reducing manual intervention by 70% and improving SLA compliance using Power Automate and Dataverse.

I identified inefficiencies in existing business processes and proposed scalable, low-code solutions using Power Platform tools to streamline approval cycles and data collection.

2. BABEL STREET (MARCH 2021 –APRIL 2023) RESTON, VA

SharePoint Developer/Administrator

Responsibilities:

Worked on migrating contents from SharePoint 2013 to SharePoint, rebuilding the applications using Power Platform tools.

Managed and migrated SharePoint sites from on-premises to SharePoint Online using ShareGate20, achieving 100% data retention and zero downtime.

Rebuild InfoPath forms using Canvas Apps and SharePoint designer workflows using Power Automate during migration.

Developed SharePoint Framework (SPFx) webpart to show images and videos in carousel.

Used Client-side JavaScript and REST API for calling data from SharePoint list and displayed the data using web parts.

Customized SharePoint list using Nintex forms added rules, hide, and show controls and customized the form using JavaScript and CSS.

Developed Nintex forms and built Workflow to automate Onboarding process.

Automated Project Proposal Management System by using Nintex workflow.

Brought External Data from SQL Server using BCS, used SharePoint designer to created external content type and created external list in SharePoint site.

Participated in migration process from SharePoint 2013 on-premises to SharePoint 2013 online (Office 365) and from SharePoint 2010 to SharePoint 2016 on-premises.

Created Picture Library Slide Show Web Part for official events pictures.

Provided Technical Support, Troubleshoot issues and bugs through help desk ticket request as well as direct request from the client.

Provided support for SharePoint Online Intranet portal sites, duties ranging from administering user access, new site creation requests.

Developed and maintained documentation of all processes associated with administration of the sites and duties performed to support.

3. PNC BANK (JANUARY 2017– MARCH 2021) PITTSBURG, PA

SharePoint Developer

Responsibilities:

Participated in creating pre-migration documentation and conducted post-migration testing using PowerShell and Sharegate, ensuring smooth transition and minimizing disruption.

Implemented and configured SharePoint 2013 Intranet for document management and collaboration.

Created user alerts to notify SharePoint users.

Configure search service for SharePoint 2013.

Performed operation on SharePoint data using CAML and LINQ and display the data using web parts.

Used Client-Side Object Model (CSOM) to retrieve, update and manage SharePoint data.

Deployed a solution to testing and production environment by using PowerShell script.

Migrated SharePoint 2010 to SharePoint 2013 using Sharegate.

Created database and tables in SQL Server and performed CRUD operation using TSQL statement and backup and restore content database of SharePoint sites.

Created and customized OOTB lists, libraries, views, site columns, content types, CEWP.

Automated the Approval Process through OOTB workflows and SharePoint Designer workflow to improve business process efficiency.

Set up permission for individuals and groups on SharePoint sites, lists, libraries, and items.

Developed custom web parts, Site column and content type and deployed in staging and production servers.

Setup and provide day-to-day end-user support through email, desktop, and telephone support in a highly collaborative team environment.

EDUCATION AND CERTIFICATIONS:

BSc. In Computer Science: Haramaya University

MCSE: Microsoft® Certified Solution Expert:

PL-400: Certified Microsoft Power Platform Developer

Contact this candidate