Power Bi Automate
Resume:
Getachew Demsie
********.****@*****.***
Professional Summary:
● I am a result-oriented IT professional with over 10+ years of experience in Analysis, Design, and Development, specializing in PowerApps, Power BI, and Automation, including seamless integration with Dataverse, SharePoint Lists, and other Microsoft technologies.
● Expertise in designing and implementing PowerApps solutions to streamline business processes, including Canvas Apps, Model-driven Apps, and custom connectors for enhanced functionality.
● Proven experience in integrating Power Automate for workflows, notifications, and data synchronization across platforms.
● I am skilled in building robust data models using Dataverse and implementing SharePoint List integration to manage and retrieve data efficiently.
● Strong background in Microsoft Business Intelligence (MSBI) with extensive experience in SQL Server, SSIS, SSRS, and DAX for end-to-end BI solutions.
● Adept at leveraging Power BI to transform raw data into actionable insights through dynamic visualizations and dashboards.
● Demonstrated ability to analyze user requirements, design effective solutions, and implement end-to-end Power Platform and BI projects.
● Experience in automating business processes using Power Automate and integrating geospatial data with Power BI for spatial analysis.
● Automated cross-departmental workflows using Power Automate are integrated with Outlook, Teams, and SharePoint.
Technical Skills:
• Power Platform: Power Apps, Power Automate, Power BI, Power Virtual Agents
• Microsoft 365: SharePoint Online, Microsoft Teams, Excel, Outlook, OneDrive
• Data Sources: Dataverse, SQL Server, Snowflake, Azure Synapse, Excel, CDS, APIs
• Azure Integration: Logic Apps, Azure Functions, Azure Data Factory, Key Vault
• Development: DAX, Power Query (M), T-SQL, Python (basic), JSON, REST APIs
• DevOps & Deployment: Azure DevOps, Git, ALM, solution packaging, CI/CD
• Security & Compliance: Role-based access control (RBAC), DLP policies, Conditional Access
• Certifications (or pursuing): PL-100, PL-400, Azure Fundamentals (AZ-900)
• Tools: Visual Studio Code, Postman, PowerShell, Microsoft Forms, ServiceNow Education:
● Bachelor’s in information technology Hawassa University, Ethiopia Professional Experience:
Cisco Systems, Milpitas, CA May 2021 - Present
PowerApps Power Automate Dynamics 365 Developer Responsibilities:
● Developed and deployed PowerApps solutions to automate business workflows, including complex Canvas Apps and Model-driven Apps.
● Integrated PowerApps with Dataverse, SharePoint Lists, and Azure SQL Database for seamless data management.
● Designed intuitive user interfaces in PowerApps for data entry, approval workflows, and mobile-first applications.
● Led a team of developers to deploy a custom customer service portal integrated with Dynamics 365, reducing customer service operational costs by 25%.
● Integrated PowerApps solutions with Dynamics 365 and SharePoint Lists to create mobile- first applications for field teams.
● Created Power Automate workflows to handle notifications, approvals, and automated data synchronization between systems.
● Built dynamic Power BI dashboards and reports, incorporating advanced DAX calculations for data analysis.
● Implemented row-level security in Power BI for secure access to sensitive data.
● Automated report generation and data refresh schedules using Power Automate.
● Developed custom connectors in Power Platform for integration with proprietary systems and external APIs.
● Conducted training sessions for end-users on PowerApps and Power Automate to enhance adoption.
● Collaborated with cross-functional teams to define business requirements and deliver effective solutions.
Environment: PowerApps, Power Automate, Dataverse, SharePoint, SQL Server, Power BI, DAX, Azure, Visual Studio
American Family Insurance, Madison, Wisconsin, United States July 2016 – April 2021 Power BI Developer Power Platform
Responsibilities:
● Worked closely with SMEs and end-users to gather and refine business requirements for PowerApps and Power BI solutions.
● Designed and implemented PowerApps integrated with SharePoint Lists for real-time data capture and retrieval.
● Developed automated workflows in Power Automate to streamline approvals, notifications, and data updates.
● Created interactive Power BI reports and dashboards, showcasing KPIs and actionable insights for stakeholders.
● Maintained and optimized existing Power BI reports and datasets.
● Utilized DAX functions for advanced calculations and implemented custom measures for business-specific metrics.
● Published Power BI reports and dashboards, ensuring accessibility through web clients and mobile apps.
● Conducted unit testing and performance tuning for Power Platform applications to ensure reliability and efficiency.
Environment: PowerApps, Power Automate, Power BI, SharePoint, SQL Server, DAX, Azure Centene, St. Louis, Missouri, United States Aug 2014 – June 2016 SharePoint Developer / SharePoint Workflow Specialist Responsibilities:
● Developed and maintained SharePoint Online/2013/2016 sites for multiple departments including HR, Finance, and Project Management.
● Created custom SharePoint lists, libraries, content types, and views to support departmental business processes.
● Built SharePoint Designer workflows for document approval, employee onboarding, leave requests, and asset tracking.
● Migrated 40+ InfoPath forms and legacy workflows to Power Apps and Power Automate, ensuring modernization and long-term support.
● Designed custom forms using InfoPath and Power Apps with role-based access, conditional formatting, and external data connections.
● Integrated SharePoint Online with Power Automate flows to trigger notifications, update metadata, and manage list items dynamically.
● Implemented site templates, branding, and permission structures for department portals to ensure consistency and security.
● Worked with stakeholders to gather requirements, design wireframes, and prototype solutions using SharePoint Framework (SPFx).
● Created custom dashboards using Power BI embedded in SharePoint for project tracking, budget performance, and KPI monitoring.
● Built SharePoint-hosted and provider-hosted add-ins to extend native functionality and enhance user experience.
● Managed SharePoint migrations from on-premises to SharePoint Online using Sharegate and PowerShell scripts.
● Configured metadata navigation, managed metadata services, and content types to improve document findability and compliance.
● Maintained governance through site auditing, access reviews, and best practice documentation.
Environment: SharePoint Online, SharePoint 2016/2013, SharePoint Designer 2013, InfoPath 2013, Sharegate, PowerShell, Office 365, Teams.
Contact this candidate