Data Analyst Assistant

Shah Mazhar

Bronx, NY ***** adfyl1@r.postjobfree.com linkedin.com/in/shah-mazhar/ github.com/Shah-Mazhar EXPERIENCE

Queens College Institutional Effectiveness Queens, NY College Assistant October 2019 - Present

Writes python scripts for password protection and sending emails with reports from Oracle Database and updates the scripts in GitHub using Git.

Researches over 3000 worldwide educational institutions and programs from a raw dataset and cleans it into unique parameters and values in Excel.

Researches 10 college rankings surveys and documents multiple variables, metrics and methodology as datasets of each survey in Excel.

Macaulay Honors College CUNY Summer Corps New York, NY Data Analytics Intern July 2019 – August 2019

Researched with team of five student interns over 400 companies to analyze labor market for CUNY students to build a pipeline between small-mid sized companies and CUNY graduates.

Assisted in data cleaning using vlookup and countif functions in Excel.

Utilized collected data to detect trends in the workforce regarding majors, skillsets and job positions using Pandas in Colab.

PROJECTS

Cleaning Up Data (VBA) September 2020

Created a dummy worksheet which is a similar worksheet of the existing 4 worksheets and recorded 2 macros that add headers and format the headers.

Created a While loop that goes through 4 worksheets and call back the macros that was recorded.

Eliminated the dummy worksheet and ran the code which automated data cleaning based on the macros for all the worksheets.

Projective Cancer Mortality Model for China (Python) November 2019

Imported two csv files that has the datasets for deaths by cancer and life expectancy of China and used pandas to read it.

Defined a TimeSeries function that takes deaths by cancer in China at 1990 and made a projection of deaths by cancer in China until 2050.

Generated two graphs, one with the projection model and another that shows the relationship between deaths by cancer vs life expectancy of China.

Presented to 20 people with a quad chart that consists of the objective, methodology, results, and conclusion of the project.

TECHNICAL SKILLS

Software: Word, PowerPoint, Excel, Office 365, CUNYFirst, Tableau, thinkorswim, QuickBooks Programming Language: VBA, Python, SQL, MATLAB, R, C++ Tools & Technology: Jupyter, Atom, PostgreSQL, Git, GitHub, Colab, R-Studio Spoken Language: English (Advanced), Bengali (Advanced), Hindi (Conversational), Urdu (Conversational) EDUCATION

Queens College (CUNY) Queens, NY

Bachelor of Arts in Applied Mathematics & Bachelor of Arts in Economics August 2020 CERTIFICATIONS

-Udemy: Microsoft Excel- Excel from Beginner to Advanced September 2020

-Udemy: The Complete SQL Bootcamp January 2020

-Udemy: Complete Data Analysis Course for Beginners July 2019

Contact this candidate