Heli Shah
Data Analyst

Heli Shah

Former data analyst at The Madison Square Garden Company.
Work with Heli Work with a Data Analyst

About

Heli Shah is a solutions-driven data analyst with over four years of experience in leading cross-functional data in development, documentation, and delivery of process innovations driving the attainment of business goals. Her areas of expertise include statistical analysis, machine learning, data analytics, data visualization, data science research, data reporting, data mining and cleaning, and preparation. At The Madison Square Garden Company, she was responsible for the development and delivery of ad-hoc and scheduled reports and data sourced from the Oracle Fusion Human Capital Management system. Heli also worked as a data analyst at The New School in New York, where she created highly segmented reports and data extracts for development, alumni relations, and other departments throughout the university.

Employment

4 roles
Dec 2021 - Present 4 years 5 months
Senior Business Intelligence Developer
Spectrum
  • Designed and developed ETL workflows and datasets in Alteryx to be used by the BI reporting tool. ETL specific for creating datasets (to be used by Tableau Data Extract for BI)
  • Wrote complex SQL queries with multiple joins to automate/manipulate these extracts in Alteryx.
  • Worked in partnership with the other IT teams and stakeholders concerning the accuracy of data and efficiency of processes.
  • Prepared technical specifications and documentation for Alteryx workflows supporting BI reports.
Jan 2020 - Aug 2020 7 months
Data Analyst
The Madison Square Garden
  • Handled the development and delivery of ad-hoc and scheduled reports and data sourced from the Oracle Fusion Human Capital Management system.
  • Identified, designed, and implemented internal process improvements like automating manual process, optimizing data delivery for greater scalability.
  • Supported the HR function in connection with all reporting and analytic, and managed the roll-out of dashboard functionality and ROI matrix for the company events data, time tracking data for corporate employees and survey response data.
  • Supported data management and integrity and maintained the data dictionary for HR. Created data request form from the base and maintained database in Formstack.
Nov 2018 - Jan 2020 1 year 2 months
Data Analyst
The New School
  • Worked on a predictive modeling to help the development and annual fund team to identify the current and prospective donor trends regarding their responses and gifts. It involved the preparation of data, analysis of the application domain, interpreted the results and linking it to business and suggesting few actionable insights.
  • Assessed problems and concerns in a systematic, logical, and rational manner and monitor project progress by tracking activity, publishing progress reports, and recommending actions.
  • Created highly segmented reports and data extracts for development, alumni relations, and other departments throughout the University. Analyzed and interprets the data to identify issues and recommend appropriate methods to resolve data integrity concerns.
Jan 2017 - Nov 2018 1 year 10 months
Associate Analyst
The Madison Square Garden
  • Analyzed, designed, and assisted to translate high level business requirements into functional specifications for the IT organization and manages changes to such specifications.
  • Assisted in developing utilization reports that were presented to management at monthly meetings.
  • Worked directly with the development team, answered questions related to acceptance criteria and ensured that the work performed meets end user expectations.
  • Developed well-rounded business proposals, the end-users guide for internal approvals and budget processes, SOX compliance for internal workforce applications.

Education

Sep 2016 - Jul 2018 1 year 10 months
MA, Computer Science
Queens College, NY, USA
Sep 2011 - Jun 2015 3 years 9 months
Bachelor of Engineering, Computer Engineering
Gujarat Technical University (GTU)

Portfolio

1 item