Tom Pfadenhauer Email & Phone Number

Melbourne, Fl, Us

Melbourne, Florida, United States

• Database administrator for over 200 databases.• Manage SQL Server backups and recovery.• Created a custom process to automatically restore and verify all database backups.• Responsible for database server performance tuning – query plan and statistics analysis, index management and code refactoring.• Created custom alerting/reporting strategies for SQL Servers.• Perform data recovery operations as needed.• Ensure SQL Servers are patched.• Perform new SQL Server installations and upgrades.• Create Power BI data models, Power BI reports and SSRS reports for business analytics.• Create new SQL Server databases, procedures, tables, views, triggers and other database objects.• Create SSIS integrations for data import, export and communications between systems.• Develop and maintain a data warehouse to support an integrated view of information across the organization. • Manage and extend Salesforce solution for the Recruiting team.• Built calling solution for donor follow-up calling.• Built Marketing dashboards and reports for major donor analysis, event participation and donation trending.• Built Finance dashboards and reports for income, expense and variance reporting.• Build operational dashboards and reports for tracking key performance metrics.• Support business user requests for Donor Direct’s StudioEnterprise.• Create new custom entities and custom actions for StudioEnterprise.• Created and managed a custom process to automatically refresh non-production environments for Donor Direct’s StudioEnterprise and Advanced StudioOnline.• Created integration between StudioEnterprise and HubSpot.• Prepared and presented communications for executives related to business reports and performance metrics.• Ensure that projects for system integrations remain consistent with objectives, costs and schedules set by leadership.

Orlando, Florida, United States

• Administered all SQL Servers and databases.• Built data warehouse to integrate Marketing and Advancement data.• Built custom process to manage and send annual giving statements.• Extended donor receipting process.• Built custom donor calling solution.• Created Azure based integration solution for 3rd party marketing partner (DSA).• Created custom integration between donor management system (StudioEnterprise) and general ledger (NetSuite).• Built Power BI dashboards and reports to support the Marketing and Advancement teams.• Built custom integration between mail scanning system (RTL) and donor management system.• Created numerous custom entities and actions to extend the donor management system.• Coordinated service contract with donor system vendor to ensure work was accomplished as promised on schedule and within budget.

• Developed budget system for President’s Management Agenda for the Office of Budget. • Helped develop an agency fully-loaded workload unit cost.• Coordinated process with executives for “rolling up” the budget, making adjustments requested by other agencies (like OMB) and pushing those changes back down.• Prepared meeting agendas and met regularly with executive staff to coordinate development of new budget formulation system.• Presented project status updates to executive staff.• Worked with business process consultants from Lockheed Martin to document budget process requirements.• Led initiatives to assess vendors offering budget formulation solutions.• Worked with contracted Lockheed analysts and Oracle developers to conduct budget system proof-of-concept.• Presented budget system to top SSA executives.• Interviewed and trained new employees.

Master'S Certificate, Database Systems Technology

Bachelor Of Science - Bs, Computer Information Systems