Power Bi Developer

Michelle Love

**********@*******.*** 256-***-**** Linked In

BI Developer

Skills

BI Reporting: Power BI, Power BI Paginated, SSRS, Tableau, Crystal Reports, MS Access, Tabular Editor

Databases: SQL, Snowflake, Azure Data Factory

Data Analysis: SSMS, dBeaver, Snowflake Query

Programming Language: SQL, DAX, M Query, VB

Automation: Power Automate, Power Apps

Microsoft Fabric: Views, dataflows, data objects

Data Modeling: SSIS, SSAS

Additional: ERP System modifications, EDI processes

Experience

BI Developer Committee for Children Jan 2025 – Apr 2025 (short term contract)

Full cycle development of Power BI reports.

Data analysis using SQL (SSMS).

Update and troubleshoot existing reports for measure or data issues.

Work closely with DW team to ensure we have data required for reporting.

Create Power Automate flows to trigger report refreshes, scheduled exports, data alerts, automate manual transfer of data from Fabric data views to create text files transfer via SFTP connection.

Power BI Paginated reporting for data exports.

Advanced DAX calculations and dynamic measures, calculated columns.

Use of Dax Studio and Power BI profiler for report optimization

Creation of MS Fabric objects and assist in transfer from on prem to Fabric objects via dataflows

Verify data in MS Fabric objects match those in original SQL tables/views.

BI Developer Poolcorp Nov 2024 – Jan 2025 (short term contract)

Full cycle development of Power BI reports.

Data analysis using SQL (SSMS), Create and maintain ETL Processes using SSIS.

Administration user security for reporting access.

Update and troubleshoot existing reports for measure or data issues.

Work closely with DW team to ensure we have data required for reporting.

Create Power Automate flows to trigger report refreshes, scheduled exports, and data alerts.

Power BI Paginated reporting for data exports.

Advanced DAX calculations and dynamic measures, calculated columns.

Use of Dax Studio and Power BI profiler for report optimization

Use of Tabular Editor for measures and scripting

BI Developer / PBI Admin Trader Interactive Dec 2021 – May 2024

Full cycle development of Power BI reports using Snowflake DW.

Data analysis using SQL, Snowflake, dBeaver, Azure Data Factory

Administration of Power BI workspaces, gateway updates, certificate tracking, security groups, report access, KRI reporting..

Update and troubleshoot existing reports for measure or data issues.

Create style guide for developers to standardize reports.

Work closely with DW team to ensure we have data required for reporting.

Work with development team to create processes for publishing reports and maintaining documentation on updates.

Create Power Automate flows to trigger report refreshes, scheduled exports, and data alerts.

Used Power Automate flows to import and transform data from other sources (google sheets, excel, etc), and incorporate that information into datasets as needed for reporting projects.

As an admin, I was the intermediary between our development team and the IT team to create and establish user security (Azure AD) groups and establish row level security for our reporting workspaces and individual reports. This included our embedded reports (75k user access)

Creation of Power BI Admin reports with connection to Power BI API to verify scheduled and viaAPI data refreshes. These also included user access information to workspaces or individual reports to quickly see who had access to what within reporting environment.

Power BI Paginated reporting for data exports.

Advanced DAX calculations and dynamic measures, calculated columns.

Use of Power Apps for version control of Power BI reports

Use of Dax Studio and Power BI profiler for report optimization

Use of Tabular Editor for measures and scripting

BI Developer Quikrete Feb 2020 - Nov 2021

Full cycle development of Power BI reports - from gathering of requirements to designing and deploying reports and dashboards.

Work with clients to establish report requirements and visualization needs. Generate ad-hoc advanced reporting using Power BI.

Collaborate with the data engineering team to determine appropriate data modeling, loading of data warehouse, and build of SSAS cube.

Validate data used in reports using SQL, MDX, DAX and Showcase Query. Work with all areas of business to assess data needs for future reporting projects.

Create stored procedures to transform data from data warehouse to usable reporting tables.

Verification and analysis of data in Excel using advanced formulas and pivot tables

Create macros using VB in Excel for data analysis

columns.

As part of our team, I was the intermediary between our development team and the IT team to create and establish user security (Azure AD) groups and establish row level security for our reporting workspaces and individual reports. This included our embedded reports (40k user access)

Use of Power Apps for version control of Power BI reports

Use of Dax Studio and Power BI profiler for report optimization

columns.

Use of Power Apps for version control of Power BI reports

Use of Dax Studio and Power BI profiler for report optimization

BI Developer SAIA Aug 2018 - Jan 2020

Convert existing Tableau reports to Power BI

Establish ETL procedures for moving data for reporting base data.

Document all ETL procedures

Author complex stored procedures, views, functions and scripts to support development team and leadership data analytics needs.

Create Power BI reports based on customer requirements

Create ETL processes using SSIS to build out OLAP cubes for reporting needs in Sales

Pull data from our CRM (Salesforce) for Pay for Performance reporting to deliver KPI information to the Sales Management team.

SSRS Reporting and Data Analyst / ERP Analyst Hitachi Koki Feb 2017 - Aug 2018

Though hired with the initial responsibility of transferring all existing Access and Excel reports to SSRS and creation of data warehouse, I also took on maintenance, support, and customization of the ERP system

Analyzed existing reports for purpose and re-create more efficient reports to provide the needed data via SSRS. Creating scheduled report distribution to eliminate manual processing of data to customers.

Created a custom application for tracking Help Desk issues and provide MIS KPI information.

Assumed maintenance and troubleshooting of EDI transactions during department transition. I continued to monitor and assist with new EDI setups and issues.

Authored complex stored procedures, views, functions and scripts to support development team and leadership data analytics needs.

I tied in the ERP system data with our Warehouse Management system data to provide workflow reporting (allowing tracking of orders and shipments through the warehouse - status updates). I was also in charge of any modifications or code updates to the ERP system,

Data Analyst Flight Global Sep 2016 to Jan 2017

Verify new data sent in by customers against existing data in the travel data system and make corrections as necessary.

Re-verify data once updates have been made to ensure accuracy.

Log and scan finished report documents back into the document sharing system for future reference.

Project-based Consulting Oct 2015 to September 2016

Build custom queries, using SQL and custom reports in Crystal Reports and SSRS.

Create automation (VB based) macros to help users automate functionality in both Excel and Outlook.

Building ways, through SQL queries and reporting, to shorten the amount of time it takes workers to do data comparison on patient information.

Setting up computers and peripherals for new offices and users.

This in addition to other computer projects as needed.

IT Analyst BTD Manufacturing Feb 2014 to Oct 2015

Hired as an IT Analyst to assist in managing an ERP system as well as build custom applications and reports that tied in both the ERP system as well as the manufacturing software applications.

Build custom reports and queries, using SQL queries and custom reports in Crystal Reports and SSRS.

Create custom applications to track employee certification as well as employee performance.

Create an interface between the ERP system and the labor force tracking system.

QA Analyst M3 Accounting & Analytics Aug 2012 to May 2013

QA Lead for one of the company’s newest software lines.

Test and research issues with software as they were found. This included SQL queries to the database tables to resolve issues.

Performance testing of software response times using Seleniun and Firebug.

Documentation of How To and FAQ manuals for end users.

Following the progress of another QA member that was assigned to my team and directing her next steps.

Working closely with the Business Analyst to ensure that the software followed the correct business logic.

Recommending then writing up functional specifications for new functionality.

Writing up existing issues using our tracking tool TFS.

Additional Work Experience:

Software Validation Consultant: Vrooms - Contracted to create the validation process for the Software-as-a-Service they provide to clinical, preclinical and translational research facilities.

Software Consultant and Project Manager: St Joseph’s Research Institute - Assessed the needs in their preclinical facility for software and technological solutions to data management, archiving and retrieval of final reports and documentation, cost accounting and budgeting, micro chipping solutions. Planned the integration of all these systems on some base level through custom proprietary software solutions. Include factors of GLP compliance issues with regard to all software and hardware systems recommended.

Applications Developer: St Joseph’s Research Institute - Designed, built, and implemented systems for Children’s Healthcare of Atlanta at Egleston (CHOA), SJRI Preclinical Research, and the SJRI Cardiovascular Education Department.

IT Manager / Access Developer: Designed and implemented an Access database that provided efficient management and evaluation of patient and office visit information. Lead the successful installation of a new network server at a new office location, and had individual workstations upgraded as necessary.

Contact this candidate