Robert M. Foose Email & Phone Number

New York, Ny, Us

Manhattan, Ny, Us

Provide leadership and direction for a six-member team to manage and administer key information systems, deploy and operationalize leading-edge tools and technologies, uphold data management/governance best practices, and oversee reporting processes. Serve as co-chair on the 25-department University Data Governance Committee; project manage a suite of strategic initiatives to embed data governance best practices in all aspects of organizational activities. Conduct periodic assessments of technology usage to identify and capitalize on opportunities for new tool integrations.  Design and enforce integrated policies governing information distribution and hardware/software utilization. Manage, maintain, and continually strengthen relationships with third-party vendors; collaborate to ensure state-of-the-art IT infrastructure. Represent the IA Department on various technology and information management committees. Developed a custom data warehouse to unify, manage, and effectively leverage alumni and development data from disparate systems; streamlined average reporting times from 24 hours to 30 minutes. Recruited a highly qualified team of top talent; scaled the team from two to six via recruitment and internal promotions. Key contributor to a major conversion project; transitioned from Banner 9 Advance to Ellucian CRM Advance to enhance the reach and impact of donor outreach efforts, strengthen security posture, and improve data management/synthesis capabilities for the 60-member IA group. Successfully in-housed a previously outsourced function to deliver $300K+ in annual cost savings.

Baltimore, Md, Us

Supported and continually strengthened data governance efforts; drove the development of an integrated data warehouse, providing a robust framework and definitions for student data across all Johns Hopkins schools. Adapted data architecture to meet the needs of university users and schools for accurate, secure, and timely reporting and dashboard creation. Periodically troubleshot and resolved complex technical issues related to dashboard and report design. Developed SQL, SSRS, and Tableau projects to deliver data-driven insights that inform strategic decision-making. Defined acceptance criteria, established end user requirements via 24-36 interviews, and adapted data warehouse architecture and assets to meet evolving business needs. Maintained documentation related to technical requirements, design, testing, and user guides. Drove the transition and data migration to a new third-party faculty CV platform.  Developed custom Tableau dashboards to accurately identify medical billing inconsistencies for auditors.

New York, Ny, Us

Developed new data assets for use by multiple departments; leveraged internal tools and data sets to identify and capitalize on process improvement opportunities. Conducted periodic data analyses, compiled key financial information, and produced ad hoc reports to guide and inform financial, budgeting, and capital improvement decisions. Recruited and managed a highly qualified team of junior analysts; held them accountable to a high standard of performance. Built mentor-mentee relationships with junior analysts to upskill and elevate team performance. Authored SQL database objects (views, functions, stored procedures) to mitigate redundancy and improve scalability; streamlined monthly financial reporting times from 16 hours to 15 seconds. Led the transition from outdated Excel-based reports to self-service reporting solutions and business intelligence tools. Developed tabular analytic models to serve as semantic data layer in combination with Power BI dashboards. Employed ETL (extract, transform, load) to ingest and cleanse mission-critical data from third-party vendors; contributed to the reduction in outstanding debts to NYC from $1.7MM to $550K. Deployed automated MS Access solutions with VBA to provide data manipulation and reporting capabilities for special projects. Created custom reporting and data visualization to provide greater visibility into open work orders after the transition to a new work order system, resulting in the identification of an ever-increasing backlog of work orders. Empowered staff to uncover and remediate operational challenges at the earliest opportunity.

Hoboken, Nj, Us

Key contributor to multiple special projects to optimize reporting procedures and improve data analysis capabilities. Provided data management and reporting support to the admissions and academic departments; employed the FOCUS reporting language to provide multiple departments with periodic reports. Led an initiative to streamline the tracking, analysis, and reporting of incoming cohort retention data. Compiled and analyzed data to identify potential gender bias in the university’s talent acquisition and promotion practices. Reverse engineered undocumented business logic and key processes from FOCUS code authored by former employees.

New York, New York, Us

Instrumental in the creation of a Business Intelligence driven environment by streamlining and automating key processes, training and empowering end-users, migrating to a new data warehouse, and transitioning from Access/Excel to BI reporting. Developed and administered training programs to ensure maximal adoption of new reporting tools and best practices. Managed a suite of inter-departmental data projects in partnership with Admissions, Financial Aid, and the Registrar’s office. Established a library of data quality reports for data cleansing purposes. Designed, analyzed, and validated new reporting solutions using T-SQL, Excel, and various BI tools.

B.S. In Business Administration, Marketing, Management

Certificate, Information Technology

Certificate, Intro To Ai: Art Of The Possible