Krom820

Highly experienced Business Intelligence professional with deep knowledge and understanding of data analytics and ELT. Ability to connect to multiple, disparate sources of data. Skilled at creating metrics and visualizations that both executives and general users can easily understand.

Demonstrated ability to identify high-level KPI measures to gauge what is working well and what needs improvement. Deep knowledge and understanding of the Raiser's Edge CRM database including user permissions, table structure, querying, exporting and creating robust Excel dashboards.

Director of Business Intelligence at Metropolitan Ministries (2016-01 – 2026-05-29)

• Extract, load and transform data from multiple, disparate data sources, and create data sources as needed.
• Create multi-page KPI Dashboards in Power BI and Excel utilizing charts, tables, data cards and gauges for all departments and teams across the entire organization.
• Meet with all teams to learn their primary program objectives and goals and recommend high-level KPIS.
• Administer Raiser's Edge database and provide advisory support to teams.
• Oversee, train and coach Business Intelligence Manager and support staff.
• Create BI Dashboard standards to ensure dashboards have a similar look, and visualizations are presented in order of importance.
• Create dashboard documentation to ensure continuity of processes as staff leave.
• Set up refresh schedules in Power BI Service.
• Troubleshoot data refresh failures.
• Identify data errors and work with teams to make corrections.
• Create ad hoc reports as needed, including Board Meetings, Marketing publications and other annual reports.
• Created a high-level Organization KPI Dashboard comprised of data used in various dashboards in addition to other sources, targeted to Executive Leadership, Board Members and to Marketing Publications.

Donor Database Manager at Metropolitan Ministries (2008-01 – 2016-12)

• Cleanse data to eliminate 3000+ duplicate records.
• Lock down tables and create drop downs to ensure consistency.
• Create and maintain user permissions.
• Conduct End-User training and create User Data Entry Guides.
• Create ad-hoc reports and create methodology for users to request new reports.
• Led data migration from hosted database to cloud database.
• Performed data extractions for Marketing purposes, working alongside external Marketing company.
• Adapted database to capture organization-specific data.
• Created comprehensive/drillable custom Excel dashboard for CEO and Fundraising Team to monitor performance and metrics.
• Created Donor Pyramid and high-level fundraising metric report in Excel for Board Meetings.
• SharePoint Administrator