Glenn White (SpankMobley)

United States

@glennsnoise

Data Analyst

Badges

Java
Python
Days of Code

Certifications

glennsnoise has not earned any certificates yet.

Work Experience

  • Senior Business Development Analyst

    Columbia University Irving Medical Center•  January 2024 - Present•  New York, NY

    • Significantly reducing workflow time by automating projects using VBA and Python • Auditing and approval of business plans, lease agreements, and funding documents • Liaison between CUIMC departments and New York Presbyterian Hospital

  • Clinical Data Navigator

    Columbia University Irving Medical Center•  October 2022 - January 2024•  New York, NY

    • Worked with department faculty and staff in defining clinical research data needs, metrics, and methodologies • SQL Server data mining using Epic and legacy database systems • Reduced turnaround time of clinical data requests by over 50%

  • Institutional Data Analyst

    Weill Cornell Medicine•  November 2021 - October 2022•  New York, NY

    • Developed reports and Power BI dashboards with key metrics for leadership across Capital Planning, Human Resources, and other financial and operational concerns • Created faculty attrition trend analysis rubric to define faculty attrition metrics and address potential problems using SQL Server, Python, and Tableau • Defined and implemented best practices for department data import, integrity, and handling

  • Senior Reporting Analyst, HRIS

    Columbia University•  July 2009 - October 2021•  New York, NY

    • Participated in HRIS departmental strategic planning, system enhancements, and development • Developed dashboards, Oracle SQL and Excel dashboard reporting strategies, and metrics for tracking COVID-19 pandemic-related employee attrition (presented to senior institutional leadership) • Defined metrics and developed SQL and Excel tracking system for institution-wide employment reward program (25 Year Club) • Developed automated Python reporting processes to monitor campus access and compliance during COVID-19 pandemic • Assisted with financial reporting and MS Excel/Access reporting needs for Benefits Accounting and Benefits Systems • Created custom reports for leadership to forecast impact of potential HR policy changes • Developed dozens of Oracle SQL processes to address and resolve data integrity concerns

Education

  • Columbia University, New York

    Applied Analytics, MS•  January 2019 - May 2021

  • New England Conservatory of Music

    Jazz, MM•  August 2003 - May 2005

  • Arizona State University, Tempe

    Jazz, BM•  September 1991 - December 1996

Skills

SQL
Python(Advanced)
VBA