CLAIRE SMITH-EDWARDS
Nashville,TN
Summary
Results-driven Power BI Developer with a proven track record of building impactful reports and dashboards for the Tennessee Department of Education. Skilled in designing Power BI reports, optimizing SQL views, and performing ETL across SQL Server, Excel, Dataverse, and Salesforce. Experienced in embedding Power BI in Power Apps Portals and integrating Canvas Apps with live slicer inputs and write-back to SQL. Fast learner and collaborative team player with strong communication skills and a passion for solving problems through data.
Overview
4
4
years of professional experience
Work History
Dynamics Architect / Power BI Developer
Tennessee Department of Education
05.2022 - Current
- Led the development of Power BI reports across multiple projects, collaborating with stakeholders to define requirements, design data models, and deliver high-impact visualizations.
- Created SQL views for Power BI reporting, fixing and optimizing views that had performance or accuracy issues.
- Revitalized outdated Power BI reports, improving design, usability, and performance by applying modern data modeling and visualization best practices.
- Built and maintained Power BI reports using data from SQL Server, Excel, and Dataverse, with transformations using Power Query (M) and calculations using DAX.
- Implemented Row-Level Security (RLS) in Power BI, including setups based on Azure AD security groups to control access across user roles and teams.
- Troubleshot and resolved common Power BI issues including refresh failures, slow load times with DirectQuery, and complex relationships.
- Developed a Power Automate flow to automate PDF generation of multiple Power BI reports, applying pre-selected slicer values and button interactions.
- Embedded Power BI reports in Power Apps Portals with secure user access and row-level filtering.
- Designed and embedded a Canvas App into a Power BI report that captured live slicer values based on user input and wrote the data to a SQL database.
- Supported and troubleshot user issues across Power Apps, Dynamics 365, and Power BI.
- Performed ETL operations in Power Query from various sources including Salesforce, SQL Server, Excel, and Dataverse.
- Used XrmToolBox and Ribbon Workbench to make customizations within Dynamics 365/Power Apps environments.
Microsoft Dynamics & Power Platform Jr. Engineer
Provisions Group
11.2020 - Current
- Created Power BI reports and dashboards that maintain integrity long-term and contain data from Salesforce, Dataverse, and SQL
- Power BI reports include Project Health, Client Status Reports, Employee Utilization, Sales Earnings, and Year-Over-Year metrics for Revenue
- Designed Salesforce reports and Dashboards that help aid Sales, Recruiting, and Delivery with projected goals
- Documented client processes by deciphering VBA code and processes ran in Access Database. Processes were documented, and a flow diagram was created for each process.
- Performed work for clients that involved re-routing employees to different remote desktop servers and helping employees install and implement new dual-authentication
Education
B.S. - Information Technology
Austin Peay State University
01.2022
A.S. - University Parallel
Columbia State Community College
01.2020
Skills
- Microsoft Certified: Power BI Data Analyst Associate
- Languages: HTML, CSS, JS, SQL, DAX, Power Query M and XML
- Applications/Tools: MS Excel, SSMS, VSCode, DAX Studio, Jira, Xrm Toolbox, and Ribbon Workbench
Timeline
Dynamics Architect / Power BI Developer
Tennessee Department of Education
05.2022 - Current
Microsoft Dynamics & Power Platform Jr. Engineer
Provisions Group
11.2020 - Current
A.S. - University Parallel
Columbia State Community College
B.S. - Information Technology
Austin Peay State University
Similar Profiles
ALLYSON COLLINSALLYSON COLLINS
Senior Manager of Complex Behavior at Tennessee Department of EducationSenior Manager of Complex Behavior at Tennessee Department of Education
DONTAYO GAGEDONTAYO GAGE
Program Coordinator at Tennessee Department of EducationProgram Coordinator at Tennessee Department of Education
Deanna MeyerDeanna Meyer
Director of Strategic Initiatives at Tennessee Department Of EducationDirector of Strategic Initiatives at Tennessee Department Of Education
Lydia AbsarLydia Absar
Overnight Kitchen Production Manager at Five Daughters BakeryOvernight Kitchen Production Manager at Five Daughters Bakery
Thomas DennisThomas Dennis
Counselor at Camp KesemCounselor at Camp Kesem