I am responsible for advancement related database management, gift processing and data entry, reporting and data analysis, as well as data integrity and security. I develop and oversee implementation of gift entry procedures; produces lists, reports, and gift acknowledgements; and contributes to the successful execution of advancement goals and strategies. I will manage, maintain, and develop new solutions for Constituent Relationship Management (CRM) software and tools. I maintain… Show more I am responsible for advancement related database management, gift processing and data entry, reporting and data analysis, as well as data integrity and security. I develop and oversee implementation of gift entry procedures; produces lists, reports, and gift acknowledgements; and contributes to the successful execution of advancement goals and strategies. I will manage, maintain, and develop new solutions for Constituent Relationship Management (CRM) software and tools. I maintain relationships and create/manage tools to facilitate the awarding of privately funded scholarships on campus by all of the colleges and financial aid. I advise and assist the Executive Director of Development as a member of the leadership and decision-making team within the Advancement Office. I supervise the Advancement Services Specialist, student interns and staff, and maintain close working relationships with other members of the advancement leadership team.I also support Alumni with reporting and data accessibility. I assist in facilitating information sharing of scholarship applications to the colleges for privately funded scholarships. In addition I’m responsible for implementing effective reporting throughout the department, maintaining relationships throughout the institution with data stewards of other departments, collecting, accessing and interpreting data and analyzing results. Often involved in analyzing, coordinating and implementing projects such as solicitation and invitation mailing lists, managing constituent-related data, providing prospect ratings, managing Development Director Portfolios, managing budgets and data associated with privately funded scholarships. I am responsible for identifying and solving issues with data migration integrity and accessibility in the Banner system and future software and data management systems. Show less

Provides data analysis, project management and reporting needed for the operational success of the Office of Institutional Advancement. Also provide support to Alumni with reporting and data accessibility. Responsible for implementing effective reporting throughout the department, maintaining relationships throughout the institution with data stewards of other departments, collecting, accessing and interpreting data and analyzing results. Responsible for analyzing, coordinating and implementing… Show more Provides data analysis, project management and reporting needed for the operational success of the Office of Institutional Advancement. Also provide support to Alumni with reporting and data accessibility. Responsible for implementing effective reporting throughout the department, maintaining relationships throughout the institution with data stewards of other departments, collecting, accessing and interpreting data and analyzing results. Responsible for analyzing, coordinating and implementing projects such as solicitation and invitation mailing lists, managing constituent-related data, providing prospect ratings, managing Development Director Portfolios, managing budgets and data associated with privately funded scholarships. Responsible for identifying and solving issues with data migration integrity and accessibility in the Banner system and future software and data management systems. Show less

-Created automatic data integrity programs that insured Banner 9 database had validated data.-Optimized Scholarship budget process to remove shadow databases improving the accuracy of budgets and reducing account deficits.-Created dashboards linked to Banner database to read/write qualification reports for Development directors.-Managed portfolio's for advancement office and generated SQL reports to inform Development directors of lapsed contacts or additional donor… Show more -Created automatic data integrity programs that insured Banner 9 database had validated data.-Optimized Scholarship budget process to remove shadow databases improving the accuracy of budgets and reducing account deficits.-Created dashboards linked to Banner database to read/write qualification reports for Development directors.-Managed portfolio's for advancement office and generated SQL reports to inform Development directors of lapsed contacts or additional donor capacity.-Improved reporting of KPI's for development directors bringing in contact information, solicitations, gifts and pledges from Banner database to inform directors of campaign progress.-Spearheaded proposal to receive funding for new CRM analyzing past giving history and donor retention to forecast donor equity with new system - Created automated reports using SQL Developer and Argos to run daily checks for data errors. This improved the integrity of Advancement data.-Generated SQL/Argos reports to export data into external CRM to bring custom reporting data to mobile platforms for development directors.- Created ADHOC reports using SQL Developer to combine data from multiple sources and tables.- Created and distributed budgets for over 1.5M worth of private scholarships. Show less

Identify immediate short- and long-term opportunities and plans for improvement for advancement clients. Create cross-functional, cross-disciplinary, and cross-synaptic direction for facilitating departmental efficiencies and guide teams through ways to reduce administrative costs while enhancing services.

Used VBA program to create employee time management system tracking hours works and automatically finding time clock errors.Grew business over 300% in the first 3 years. Managed staff and accounts for over 11 years. Annually create, promote and produce new products.Analyzed production costs to set price across all products and improve profitability hitting gross profitability target of 33%Created predictive scheduling using POS sales data and VBA programming resulting… Show more Used VBA program to create employee time management system tracking hours works and automatically finding time clock errors.Grew business over 300% in the first 3 years. Managed staff and accounts for over 11 years. Annually create, promote and produce new products.Analyzed production costs to set price across all products and improve profitability hitting gross profitability target of 33%Created predictive scheduling using POS sales data and VBA programming resulting in a 7% reduction of labor hoursOversaw financial operations of company: Created LLC, managed bank reconciliation, accounts receivable / payable, vendor contracts, etc.Oversaw financial operations of company: Analyzed workflows to optimize production resulting in 12% increase in production speed Developed new projects and operational process that lead to 2,300 unit sold in 2016 increasing gross sales by 8%Created SQL database of customers to better understand customer demographics and target marketingManaged employee payroll, performance, and incentives across multiple locations within the state Show less

Built database analysis program for SUU athletics department that searched two university databases finding missing data and replacing it resulting in a reduction of 10 labor hours used per monthStreamlined reporting functions at local financial institution (SBSU) by improving spreadsheet design and creating VBA programs resulting in increased speed of report generationConducted market research and internal analysis for struggling clothing retailer creating improvements in… Show more Built database analysis program for SUU athletics department that searched two university databases finding missing data and replacing it resulting in a reduction of 10 labor hours used per monthStreamlined reporting functions at local financial institution (SBSU) by improving spreadsheet design and creating VBA programs resulting in increased speed of report generationConducted market research and internal analysis for struggling clothing retailer creating improvements in employee compensation packages, employee scheduling, operational layout, and brand maintenance resulting in positive net profits within the quarter Show less

Tutored quantitative economics and management science: helping graduate and undergraduate students understand statistical analysis software, spreadsheet design, linear programming and mathematicsConverted research reports analyzing complex economics and management studies into simple to understand informational documents for international studentsWorked in Google Docs to create practice problems in linear programming, probability tables, and decision treesWorked… Show more Tutored quantitative economics and management science: helping graduate and undergraduate students understand statistical analysis software, spreadsheet design, linear programming and mathematicsConverted research reports analyzing complex economics and management studies into simple to understand informational documents for international studentsWorked in Google Docs to create practice problems in linear programming, probability tables, and decision treesWorked autonomously to grade assignments before deadlines in Canvas Show less

Created commercials as well as client videos of sports and events. Training with Sony Vegas Professional.