David M. Email & Phone Number

Chicago, Illinois, United States

- Optimized Azure Data Factory flows and integrated new data sources into the data mart, significantly enhancing operational efficiency and data accuracy.- Led comprehensive data audits within Advance (Oracle), Data Mart (Microsoft SSMS), Azure Data Factory, Power Automate, and Power BI reports to ensure data integrity, collaborating closely with management to proactively resolve risks in data mart planning.- Designed and implemented complex queries, automated processes, and interactive… Show more - Optimized Azure Data Factory flows and integrated new data sources into the data mart, significantly enhancing operational efficiency and data accuracy.- Led comprehensive data audits within Advance (Oracle), Data Mart (Microsoft SSMS), Azure Data Factory, Power Automate, and Power BI reports to ensure data integrity, collaborating closely with management to proactively resolve risks in data mart planning.- Designed and implemented complex queries, automated processes, and interactive dashboards for advanced data analysis, empowering decision-making across various departments.- Produced regular and ad-hoc reports that track fundraiser productivity and organizational goals, leveraging the data warehouse structure for comprehensive insights.- Supervised and mentored one staff member, fostering a collaborative environment to enhance their skills and knowledge in data management practices.- Documented intricate dataflows, developed systematic fault detection systems to identify and correct issues, and provided cross-training and skill development opportunities for team members. Show less

Chicago

- Developed and produced detailed dashboards and visualizations using Power BI Report Builder and Desktop, enabling comprehensive reporting that supports strategic decision-making across various departments.- Created and optimized datasets from multiple tables and sources to facilitate in-depth data analysis and predictive modeling, providing actionable insights for executives and gift officers.- Built and managed Azure Data Factory pipelines to ensure seamless data transfer from… Show more - Developed and produced detailed dashboards and visualizations using Power BI Report Builder and Desktop, enabling comprehensive reporting that supports strategic decision-making across various departments.- Created and optimized datasets from multiple tables and sources to facilitate in-depth data analysis and predictive modeling, providing actionable insights for executives and gift officers.- Built and managed Azure Data Factory pipelines to ensure seamless data transfer from external sources into the Data Mart, enhancing data accessibility and operational efficiency.- Automated notification processes using Microsoft Power Automate, streamlining communication and ensuring timely alerts for data-related updates and issues.- Designed and refined data entry and maintenance processes through native CRM features and custom applications, improving overall data quality and user experience.- Conducted thorough audits and updates of existing Power BI reports to ensure data accuracy and integrity, while programming standard and ad-hoc reports using Oracle SQL, SQL Server, PL/SQL, and other reporting tools.- Established and implemented data integrity audits, providing ongoing guidance to teams managing gift, prospect, and biographic records, ensuring adherence to best practices. Show less

Greater Chicago Area

- Responsible for training and orientating new staff to Advance database and provide support for users on an on-going basis. - Developed data loaders to mass upload data into the Advance database in an effort to increase data integrity and productivity within the department. - Produced standard and ad-hoc reports for the various departments within Philanthropy using SQL and Crystal Reports. - Foster departmental and external relationships to establish policy and procedures for the… Show more - Responsible for training and orientating new staff to Advance database and provide support for users on an on-going basis. - Developed data loaders to mass upload data into the Advance database in an effort to increase data integrity and productivity within the department. - Produced standard and ad-hoc reports for the various departments within Philanthropy using SQL and Crystal Reports. - Foster departmental and external relationships to establish policy and procedures for the integration of data into the Advance database.- Created MS Access database for the department as a resource to request and track departmental report requests. - Administer application security for new and existing Advance database users. - Work with the Technology Advisory Group to forecast department technology needs and goals for each fiscal year. Show less

Chicago

- Worked directly with faculty and staff on opportunity identification, cultivation, and solicitation of grant support. - Created MS Access database to maintain a comprehensive, up-to-date schedule of faculty distributions, course buyouts and faculty/staff grant payroll. • Resolved grant-related salary budget issues identified by Restricted Accounting or other DePaul University offices. - Administered technical support and guidance to Principal Investigators (PI) during the… Show more - Worked directly with faculty and staff on opportunity identification, cultivation, and solicitation of grant support. - Created MS Access database to maintain a comprehensive, up-to-date schedule of faculty distributions, course buyouts and faculty/staff grant payroll. • Resolved grant-related salary budget issues identified by Restricted Accounting or other DePaul University offices. - Administered technical support and guidance to Principal Investigators (PI) during the implementation process of the grant award. - Update and archive the funding opportunities on the Office of Research Services SharePoint website. - Developed audit policy and procedures to ensure grants funds are utilized as proposed; residual balances under services agreements are satisfactorily assigned; budget modification requests are correctly prepared, as needed; and extensions are considered and solicited. Show less

Greater Chicago Area

- Coordinated with housing management software to assign over 1,000 housing units to students relative to new agreements, room change requests, and judicial room changes. - Developed and distributed mass communications to students, parents, and professional staff in regards to all relative housing information. - Organized the processing of system transaction with the university’s PeopleSoft student information system. - Created Access databases to communicate and track room changes,… Show more - Coordinated with housing management software to assign over 1,000 housing units to students relative to new agreements, room change requests, and judicial room changes. - Developed and distributed mass communications to students, parents, and professional staff in regards to all relative housing information. - Organized the processing of system transaction with the university’s PeopleSoft student information system. - Created Access databases to communicate and track room changes, new assignments, cancellations, students on waitlist and billing information for Housing Services and Residential Education.- Supervised, scheduled, trained, evaluated, and professionally developed four student employees. - Utilized SQL to develop occupancy reports for Senior Management. - Developed internal audit policy and procedures to help ensure the integrity and accuracy of the information input in the housing data software. Show less

Greater Chicago Area

- Corroborated with Development team by supplying information to assist with special projects, including (but not limited to) supplying and reconciling donor lists in support of vendor database screenings, structured prospect interview projects, volunteer management initiatives, and peer rating and screening projects. - Helped develop Data Entry Audit Reports to ensure and increase the accuracy of data entered into Advance database. - Enhanced and reorganized Prospect Management… Show more - Corroborated with Development team by supplying information to assist with special projects, including (but not limited to) supplying and reconciling donor lists in support of vendor database screenings, structured prospect interview projects, volunteer management initiatives, and peer rating and screening projects. - Helped develop Data Entry Audit Reports to ensure and increase the accuracy of data entered into Advance database. - Enhanced and reorganized Prospect Management policies and procedures. - Conducted wealth and assets research on potential donors to determine their capacity to donate a major gift ($25,000 and above) to the university. - Trained new and existing staff members in maximization of fund-raising efforts through the use of the Prospect Tracking Module of the Advance database. - Collaborated with the Director of Prospect Management to ensure the integrity of information related to the evaluation of fundraising staff performance. Show less

Greater Chicago Area

- Organized the processing, fulfillment and receipting of all gifts for the Development Department, adhering to institutional data processing/ accounting procedures, and generating the appropriate monthly reports. - Coordinated streamlining of all related services and integration of all daily functions into the Member and Donor Services processing, fulfillment and reporting system under the guidance of the Director and Manager, Member and Donor Services. - Collaborated with the Tribute… Show more - Organized the processing, fulfillment and receipting of all gifts for the Development Department, adhering to institutional data processing/ accounting procedures, and generating the appropriate monthly reports. - Coordinated streamlining of all related services and integration of all daily functions into the Member and Donor Services processing, fulfillment and reporting system under the guidance of the Director and Manager, Member and Donor Services. - Collaborated with the Tribute Gift Program team’s daily operations, including the maintenance of donor database, contribution details and correspondence with donors. - Strategized with the management team in the coordination of development strategies for expanding and enhancing the Annual Fund, specifically through implantation of spring and year-end appeals. - Assisted in moving donors up the "pipeline" of giving within the Garden’s donor level memberships and provided support for the new President’s Circle program for unrestricted gifts of $1,000 and above. - Provided excellent and personal customer service to Annual Fund donors by answering questions and resolving problems. Show less

Master Of Science, Public Service Management

Bachelor Of Arts, Political Science

Education record