Power Bi Platform

Professional Summary:

Power Platform Developer with expertise in designing and implementing solutions using Power Apps, Power Automate, and Power BI.

Proficient in front-end languages and modern web frameworks such as HTML, CSS, JavaScript, React, and Angular for building intuitive and responsive user interfaces.

Skilled in Azure services, API integration, and Power Shell scripting to integrate and extend the functionality of SharePoint and Power Platform solutions.

Experienced in working with Microsoft Dataverse and data entity modeling to create robust data models and enable efficient data management.

Proven ability to automate business processes using Power Automate and develop interactive reports and dashboards using Power BI.

Knowledgeable in implementing Business Process Flow (BPF) to guide users through predefined processes and improve workflow efficiency.

Strong problem-solving skills and ability to collaborate with cross-functional teams to gather requirements and deliver tailored solutions.

Demonstrated ability to analyze user requirements, design effective solutions, and

implement end-to-end BI and automation projects.

Experience in creating advanced chart types, visualizations, and complex calculations to

manipulate the data as per business need through Power BI and Tableau

Integrated geospatial data from various sources into Power BI, ensuring seamless

mapping and spatial analysis.

Worked on Power BI &mapping capabilities, incorporating layers, tooltips, and drill-

through actions for enhanced user experience.

Well-versed in SharePoint customization and configuration, including SharePoint Designer, InfoPath forms, and SharePoint workflows.

Demonstrated ability to deliver projects on time and within budget, ensuring high-quality standards and customer satisfaction.

Excellent communication and interpersonal skills, with a focus on effectively understanding and addressing business needs.

Experience with Snowflake database.

Skill Summary:

Power Platform: Power Apps, Power Automate (Flow), Power BI, Power Virtual Agents

Web Development: HTML, CSS, JavaScript

Programming Languages: C#, .NET Framework

Microsoft 365: Microsoft Teams, Dynamics 365

Database: SQL Server

Version Control: Azure DevOps

Education and Certification

Masters In English Literature

Certified Power Platform Developer

Professional Experience

Montgomery County Public Schools, Rockville, Maryland 11/2022 - Present

Power BI Power Platform Developer

Developed migration strategy from Info Path to Power Apps and Power Automate, which involved assessing existing Info Path forms, identifying their functionalities, and determining the best approach to replicate or enhance them using Power Platform tools.

Led the development of Power Apps for data entry, approval workflows, and mobile

applications, improving user productivity.

Designed user-friendly and efficient applications using Power Apps.

Leveraged Power Automate to automate workflows previously handled by Info Path forms.

Integrated data sources into Power Apps and Power Automate solutions which involved connecting to SharePoint lists or other data repositories used in conjunction with Info Path forms.

Conducted testing of migrated forms and workflows to ensure they function correctly. Identified and resolved any issues or discrepancies during the migration process.

Provided training and documentation for end-users on how to use the new Power Apps and Power Automate solutions effectively. This involved creating user guides, conducting training sessions, and providing ongoing support as needed.

Continuously improved migrated solutions based on user feedback and changing business requirements. This involves iterating on designs, making enhancements, and optimizing performance over time.

Designed, developed, and deployed custom business applications and automation solutions using Microsoft Power Platform tools.

Demonstrated collaboration with business stakeholders to gather requirements, translate them into technical solutions, and ensure successful implementation.

Worked in cross-functional teams, including collaborating with other IT teams and departments to integrate and deploy Power Platform solutions effectively.

Used DAX table functions including FILTER, ALL, VALUES, DISTINCT and

RELATEDTABLE.

Used Power BI, Power Pivot to develop data analysis prototype, and used Power View

and Power Map to visualize reports.

Create and customize simple visualizations, Combination charts, Slicers, Map

visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts,

Gauges, and single-number cards.

Troubleshoot issues, conduct testing, and optimize performance in Power Platform solutions.

Applied agile methodologies and practices for iterative development and continuous improvement of Power Platform solutions to rework and rephrase content quickly and efficiently.

Administered and maintained SharePoint environment, ensuring high availability, reliability and performance.

Assisted in the administration and maintenance of network and server infrastructure

Provided technical support for SharePoint users, addressing issues and providing guidance on best practices

Magellan Health, Columbia, MD 01/2018 -11/2022

Power Platform Developer

Designed and developed custom Power Apps (model-driven and canvas apps) to automate complex business workflows and improve productivity.

Configured and customized Power Automate workflows to automate tasks, notifications, and approvals across different business systems.

Integrated Power Apps and Power Automate with external systems using APIs and connectors to streamline data exchange and integration.

Created interactive dashboards and reports using Power BI to provide real-time insights into workflow performance and bottlenecks.

Leveraged Azure services to implement serverless functions and logic for advanced workflow automation scenarios.

Developed PowerShell scripts to automate deployment and administration tasks for the Power Platform solutions.

Modeled data entities in Dataverse and designed data entity relationships to ensure accurate data representation and integrity.

Conducted data entity modeling and mapping to support data integration and synchronization between different systems.

Implemented business process flows to guide users through complex workflows and ensure compliance with business rules.

Provided training and documentation to end-users, enabling them to effectively utilize the Power Platform solutions and troubleshoot issues.

Utilized Power BI components for data visualization, implemented row-level security,

and managed the Power BI environment.

Imported data from various sources to Power BI, performed data cleaning, and applied

DAX queries.

Developed visual reports, dashboards, and KPI scorecards using Power BI desktop.

Designed and developed RDBMS(Relational Database Management System) Solutions in order to meet specific business requirements in order to deliver optimal Data organization, integrity, and accessibility.

Maintained and Developed SQL Queries, stored procedures and Views to support Application Development and Data Analysis.

Developed custom SharePoint solutions using Codes such as HTML, CSS,Java Script and other Web Technologies

District of Colombia Public Schools, DC 01/2013 - 12/2017

Database/BI Developer

Collaborated with Business Systems Analysts to fine-tune specifications and ensure database constraints were met.

Worked closely with SME’s end users/internal customers to understand project/requirement scope and involved in providing solution to implement or support production issues.

Involved in the logical and physical data models of databases and prepared test cases for existing solution and new solutions to validate the solution met requirements.

Created database tables with various constraints including primary key, foreign key, etc.

Loaded data from flat data files into SQL Server database tables using bcp, bulk insert, and table export/import, SSIS package

Power user of SQL queries with multi-table joins, group functions, subqueries, set operations and T-SQL.

Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.

Assist with documentation of tasks and processes for business and technical teams use of data quality, metadata, ETL tools.

Created views to display required information on user interface, and triggers to validate consistent data entry into the database.

Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting by customizing URL Access.

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.

Contact this candidate