Internship BI Analyst resume example

• Under supervision, built a Power BI measure dictionary and reconciled DAX totals at detail and aggregate levels; tested row-level access with accounts representing different reporting teams.
• The team consolidated 6 revenue sources into a tested semantic model with owner-approved definitions; I supported research preparation, validation, and documentation under mentor review. The team removed a recurring quality failure from the reviewed workflow; confirmed with my mentor that my contribution was limited to the assigned support and validation work.
• The team rebuilt 9 operating dashboards around decisions, thresholds, and drill paths; I supported research preparation, validation, and documentation under mentor review. The team sustained the adoption gain after rollout; confirmed with my mentor that my contribution was limited to the assigned support and validation work.
• Under supervision, owned a SQL data-model reconciliation using known reference totals, resolved inconsistent Tableau and QuickSight measures and completed a shared metric dictionary.
• Under supervision, built Python ETL checks using data-quality assertions, reduced weekly dashboard reconciliation from 95 to 40 minutes and published the statistics validation notebook.

• In a mentor-reviewed simulation, built SQL data modeling and ETL checks for a compliance reporting mart, separating event time from load time; reconciled control totals before publishing the dataset to dashboards.
• As a second supervised exercise, created QuickSight dashboards with row-level access and data visualization that exposed missing evidence; used Python checks to compare exported totals with the reporting mart after each refresh.
• Under supervision, the team implemented freshness, reconciliation, and ownership checks for 31 executive metrics; I supported research preparation, validation, and documentation under mentor review
• Generated synthetic source records with duplicates, late arrivals and corrected values; wrote assertions for row counts and key uniqueness, and recorded the expected effect of each case on the reported metric.
• Compared the analytical output with a manually calculated reference table, traced differences to a transformation step, and retained a data dictionary and rerun instructions alongside the corrected query.
• Owned the synthetic-data validation using a manually calculated reference, resolved duplicate-key inflation and completed a notebook that reproduces the corrected totals.

Relevant coursework: Algorithms, operating systems, databases, computer networks

Power BI · DAX · Metric definitions · Row-level security

• Published an independent methods note using reproducible queries, explaining the data grain, excluded records and sensitivity of the result to a changed denominator.