Data Analyst

Mudit Arora

Arlington, TX ( 682-***-**** * ******.*****@*****.***

Education

University of Texas at Arlington, Arlington, TX: 2020

Master of Science – Industrial Engineering with specialization in Data Analytics

Birla Institute of Technology and Science, Pilani (BITS Pilani), Dubai, UAE: 2015

Bachelor of Engineering – Mechanical Engineering

Professional Experience

MEI GROUP ARLINGTON, TEXAS 2020 TO PRESENT

Data and Reporting Analyst Intern

Motorized manual reporting procedures leveraging VBA and reduced reporting time by 50%

Prepared weekly inventory audit and wholesale reports for producing vital numbers of active and inactive car units, cars available in lots that fall under MEI auto finance

Served as a critical part in migrating data from third party API to in house

Built, published customized interactive reports and dashboards, report scheduling using Tableau Server

Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau

Applied advanced excel functions and tools such as Index and match, VLOOKUP and pivot tables for data cleansing

Developed Tableau workbooks from multiple data sources using data blending and Tableau visualizations using tableau desktop

SERCO MIDDLE EAST ABU DHABI, UAE 2016 TO 2018

Data Analyst

Involved in creating database objects like tables, views, procedures, triggers, SQL queries and functions using T-SQL to provide definition, structure and maintain data efficiently

Revamped manual operating procedures into automated tasks, reducing time consumed for task closure by 15%

Designed analytics dashboards and KPI reports for internal teams to identify critical data points

Generated data for onsite operations team to effectively plan and monitor critical asset management cycle stages, resulting in greater accountability while increasing management efficiency by 17%

Technical Skills

Languages & Databases: Python (NumPy, Pandas, SciPy, Seaborn), T-SQL, R, SQL Server 2008/2012

Probability & Statistics: Hypothesis testing, Data distribution (Norma, Exponential, Uniform, Binomial), R-squared, Correlation Matrix, ANOVA, SLR, p-value test, Modified Levene Test, Stepwise regression

Software & BI Tools: Crystal reporting, Jupyter Notebook, Tableau desktop and Server, SAS and Microsoft Excel

Certifications

T-SQL certificate ● Data Analysis with Pandas & Python ● Fundamentals of Visualization with Tableau

Data Analysis & Visualization with Python ● Fundamentals of Visualization with Tableau

Projects

Multiple Linear Regression Project (Using: SAS) University of Texas at Arlington 2019

Compiled and analyzed effects of 5 factors on heart rate, including exercise, sleep, gender, and BMI; interpreted model diagnostics of different interaction terms to derive comprehensive statistical data applying SAS

Automated FM Procedures Project (Using: SQL & Python) Zayed University 2017

Streamlined Raw data using Pandas data frame to create process workflows using T-SQL to automate more than 500 PPM tasks and task notifications

System Workflows Project (Using: SQL & Tableau) Abu Dhabi Investment Authority 2016 to 2017

Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, Gantt charts to display infographics like task closure time and KPI monitoring using show me functionality

Contact this candidate