Empower senior leadership and management by delivering descriptive and predictive analytics in support of key strategic initiatives on customer preferences, sales relationships, and market trends. Deliver actionable insights and recommendations that are accessible to all stakeholders through effective communication.Design and implement data models and interactive dashboards in Tableau that provide insights to business leaders that drive strategy around product management, sales and marketing efforts, and strategic pricing.Work closely with data engineering to build an analytics data warehouse by auditing existing data structures, collaborating with stakeholders to create requirements, identifying and implementing business logic, developing SQL scripts for data pipelines, and assisting with ETL workflow design.Support essential business processes by building, maintaining, and improving SSRS reports and the stored procedures, views, and tables that support them. Provide ad hoc data analysis and reporting for unique customer needs.Key technologies leveraged: SQL (MS SQL Server and Redshift), Python, Tableau, SSRS, Microsoft Excel

Lead efforts in data mining and data modeling to drive strategies around fundraising and organizational effectivenessLead conversations with senior management, end users, and technical team to develop functional and technical specifications, assess business processes, and implement best practicesWork closely with the Executive Director of Advancement Services to manage technical projects through a coordinated project lifecycle from analysis to implementation, focusing on data driven fundraising efforts and business intelligence best practicesOversee the full lifecycle of Advancement reporting including report development, accuracy and maintenance and archival. Provide support of Ellucian Advance web infrastructure, database structure, and application.Provide oversight and direction for institutional campaign reporting structures and dashboarding effortsKey technologies leveraged: SQL (Oracle), SAS, Tableau, Microsoft Excel, Crystal Reports

Lead the division’s reporting efforts, with a focus on the university’s comprehensive blended campaign, through the development, modification, and automation of report programming and design, delivering interactive key performance indicator dashboards for division management, and managing and contributing to the development of ad hoc reporting requests fulfilled by the Reporting and Analytics team (Manager, Data Analyst, and student employee) that aggregate information in ways not available in existing reports.Manage the Data Analyst’s campaign auditing and data analysis projects for purposes of effective and accurate campaign reporting and ensuring actionable information delivery to division stakeholders that empowers data-driven decision-making and strategy building.Lead statistical data analysis efforts in support of current or new Division processes and Divisional goal setting. Build and test predictive models that assist the Division with meeting its strategic goals.Perform quality assurance testing and data verification on stored procedures and scripts authored by other team members.Key technologies leveraged: SQL (Oracle), SAS, Tableau, Microsoft Excel, Crystal Reports

1. Interact with a cross functional work team to provide customer support to RIT’s Division of Development and Alumni Relations, and all users of RIT’s donor management system and alumni online community. 2. Develop and modify report programming, prompt design, and output design to meet business requirements, resolve issues, or enhance functionality. Assist in development and delivery of various ad-hoc report requests from division staff with a focus on aggregating information in ways not available through existing reports. 3. Perform statistical data analysis in support of current or new Division processes and Divisional goal setting. Using statistical modeling collaborate with the technical team to build and test predictive models that assist the Division with meeting its strategic goals by identifying entities having potential for philanthropic interest and/or affinity for volunteerism and/or proclivity towards event attendance. 4. Participate in the activities of a virtual “Data Management” team to improve and enhance the level of data integrity to the Division by developing, testing and debugging SQL scripts to assist in data validation and data maintenance. 5. Perform quality assurance testing and data verification on stored procedures and scripts authored by other team members.

• Use SQL tools and Microsoft Excel to provide data for various customers• Assist Advancement Information Services team in data modeling and data discovery

•Create, review, and process Accounts Payable documents while ensuring accuracy and meeting deadlines •Produce budget reports in Microsoft Excel using pivot tables, macros, and statistical analysis

•Utilized Microsoft Excel and Word to contribute to the development of different sports card brands•Communicate with brand managers to determine what kind of image was needed for each brand of cards based on the needs and wants of consumers and the company•Performed quality assurance so that text, data, and images used for cards were accurate