Paul Silver Email & Phone Number

Pittsburgh, Pa, Us

ManagementLed Prospect Development and Analytics team, oversaw fundraising analytics, prospect management, and prospect research.Analyticso Created new analytics ecosystemo Created SQL Data Models, established new enterprise-wide analytics programo In SQL Server Management Studio (SSMS), wrote over 150 SQL viewso Implemented Microsoft Power BI as the principal data visualization, business intelligence toolo Imported SSMS tables and views, creating PBI queries, Performed Power Query data transformationso Created PBI data models: building tables and relationshipso End-to-end developer for leadership reports and dashboards: exploratory data analyses, donor segmentation, fundraising metricso Directed two analysts: project managing report/dashboard development; tested reports and dashboards developed by direct reportso Power BI Service Administration: For multiple departments, created Apps with defined audiences, workspaces, managed semantic model auto refresheso Created analytics ecosystem for fundraising campaign: Established new CRM coding protocols; wrote SQL queries; conducted data mining operations; created data models; end-to-end developer of Power BI Dashboard reports/dashboards for museum leadership and Development dept.o Overhauled Fundraising Plan Reporting: Created Raiser’s Edge proposal appeal attributes, establishing a 1st-time explicit link between proposal data and gift/pledge data, enabling full-cycle projections-to-performance reportingWorkflow Managemento Established Asana as my team’s workflow platform, which was then adopted by Development dept., a staff of sixty-eighto Designed/implemented data requests/processing workflow for Development dept.o Created Asana forms, projects, task templates, and automated rules—conditional logic to undergird standard operating procedures which routed to multiple teamso Miro: Business Process Visualization: Diagrammed workflows for programs and projects, SOPs, and reporting criteria.

Pittsburgh, Pa

o Lead prospect moves management and prospect data analytics for schools of the health sciences and UPMC.o Supervised two clinical data analysts and one prospect researchero Created dashboards for gift officers and researchers, and trained users in the context of policies and protocols.o Created PRM Feeder-Leads Algorithm which presented leads for researching that in two years yielded 838 identified prospectso Co-Conceived and coded enterprise-wide business logic for prospect management assignment recommendations formalized in the prospect management and assignment policy.o Project Manager for the Clinical Dashboard, Major Prospect Leads Review Meeting (MPLR), andMPLR/Clinical Prospect Qualification Workflow. This working group, tool, meeting, and workflow identifies, assigns, and tracks the qualification of clinical prospects with verified ratings of $1M and above. Over 100 prospects assigned.

Pittsburgh, Pa

o Conducted major gift fundraising analytics.o Partnered with gift officers for prospect identification.o Ellucian Advance: managed prospect and proposal data.o Wrote Prospect and Proposal management protocol guides.

Pittsburgh, Pa

o Wrote/edited personalized major gift acknowledgements for Pitt/MHSF leadership.o Created the MHSF President’s Donor Watch List, Gift Report & Acknowledgment Program.o Co-Directed scholarship recipient thank you videos that were voted “Best Idea” at the Case District II Donor Relations Professionals conference: Award-Winning Stewardship Day!o Answered donor inquiries as contact for gift receipts & endowment reports.

Master Of Arts - Ma, Arts Administration

Thesis topic: Cause-related marketing & online fundraising Internship: Museum of Modern Art - Prospect Research Arts Administration.

Bachelor Of Fine Arts, Photography

High School Diploma