Glenn White

New York, NY

adkfgo@r.postjobfree.com 917-***-****

Data Analyst

Seasoned data analyst professional leading complex systems expertise for high-growth organizations

Data Analyst with 12+ years of experience in SQL, data design, and methodology implementation. Proven ability in data mining, data visualization, statistical analysis, testing, system analysis and operations. Advanced knowledge of business intelligence tools, experienced in confirming data integrity and understanding complex systems. Excellent team player who collaborates with executives and employees alike to achieve success.

Highlights of Expertise

Experimental Data Analysis & Design

SQL/PeopleSoft/MS Access/Python/R

Data Researching & Documentation

Troubleshooting/Process Reengineering

Human Resources Operations

System Analyst Administration

Data Warehousing/Data Visualization

Business Intelligence Expertise

Advanced Data Mining & Data Technologies

Team Collaboration & Development

Career Experience

Columbia University, New York, NY 2009 to Present

Instrumental in development of new database that integrates data from various archived and active systems.

REPORTING ANALYST/HUMAN RESOURCES INFORMATION SYSTEMS (2017 to Present)

Generate specialized and standard HCM information reports using SQL, PeopleSoft Query, MS Access.

Establish methodology to assess eligibility for Columbia University's 25 Year Club, an employee appreciation program and annual event.

Consult with executive-level staff and management from a vast range of departments in the creation and support of analytical solutions.

Collaborate with the IT department that served a pivotal role in the construction of a consolidated recruitment database.

Fabricate queries to classify archived documents as part of the compliance procedure for HR file retention.

Build, update, maintain, and report from departmental systems.

SENIOR ANALYST, DATA INTEGRITY, HUMAN RESOURCE PROCESSING CENTER (2014 to 2017)

Instituted an overall SME data methodology for the HR transaction system that was responsible for all complex and personalized SQL queries.

Identified and rectified data accuracy challenges inside the PeopleSoft system at Columbia University.

Wrote inquiries concerning eligibility for federal tax and employment policy changes.

Devised file request notification methodology using VBA.

SYSTEMS ANALYST, BENEFITS (2011 to 2014)

Furnished functional and technical competence on all systems, integration of systems, and process participation activities across the Benefits Department organization.

Served as a benefits systems SME and point of contact for all problems relating to the Benefits Department platform.

Formed queries and procedures to validate plans and enrollment benefits with several different forms of eligibility.

Conducted data research on benefits systems that made extensive use of SQL and custom apps.

ADMINISTRATIVE ASSISTANT, HUMAN RESOURCES (2009 to 2011)

Orchestrated payroll, recruiting, management of online files, and paid-time-off monitoring towards the successful operation of CUIMC’s Pediatrics HR office.

Drafted demographic staff reports based on specific department director and department manager requirements using custom-built applications.

Served as a liaison between the Department of Pediatrics and the broader CUIMC HR system.

Spring Mountain Capital, New York, NY 2006 to 2008

Organized, built, and improved new and existing VBA and Java reporting interfaces.

DATABASE COORDINATOR

Formulated specialized hypothetical investment scenarios developed for analytical purposes.

Delivered technical solutions for any problems related to database systems.

Education & Credentials

Columbia University, New York, NY

MASTER OF SCIENCE, APPLIED ANALYTICS (May 2021)

New England Conservatory of Music, Boston, MA

MASTER OF MUSIC, JAZZ PERFORMANCE

Arizona State University, Tempe, AZ

BACHELOR OF MUSIC, JAZZ PERFORMANCE

Miscellaneous

CURATOR AND GRANT MANAGER, JAZZ AT THE SHABAZZ CONCERT SERIES

2014 to 2015

The Malcolm X & Dr. Betty Shabazz Memorial and Educational Center

Jazz at the Shabazz was made possible in part with public funds from the Manhattan Community Arts Fund, supported by the New York City Department of Cultural Affairs in partnership with the City Council and administered by Lower Manhattan Cultural Council.

Contact this candidate