Data Analyst Engineer

Aarohi Jain

**** **** ***** ****, ********* PA **054 484-***-**** adkbi2@r.postjobfree.com www.linkedin.com/in/aarohijain

Skills

Data & ML Skills

Data Gathering, Data Cleaning, Data Analysis, Data Visualization, Data Forecasting, Data Reporting, Decision Tree, Linear Regression, Logistics Regression, K-means Clustering, Factor Analysis, Hypothesis Analysis

Programming Languages

SQL, UNIX, C++, Python, R, VBA, SAS

Statistical Tools

Tableau, Qlik Sense, Power BI, JMP, Google Analytics, SAS Enterprise Miner, Adobe Analytics, Anaconda, Jupyter Notebook, A/B testing, Sisense, R Studio

Software

Visual Basic, MATLAB, MS Excel, MS PowerPoint, MS Word, JIRA, Confluence, SharePoint

Database

Oracle 12C, Teradata, MySQL, MS Access, MS SQL Server

Methodology

Agile/ Scrum/ Kanban, Waterfall

Operating Systems

Windows, Mac

Work Experience

CrowdDoing- El Dorado Hills, California Jan 2021 –Present

Data Analyst

Analyzed effectiveness of products based on customer feedback.

Interpreted complex data sets from 1 million rows to machine readable and maintainable data using functions in MS Excel.

Employed k-means cluster algorithm using tableau to analyze cost vs effectiveness of products according to customer feedbacks.

Prepared charts using advanced Excel and PowerPoint functionalities like VLOOKUP, Pivot tables and Macros.

Created weekly sales reports and trends for C-level executives.

Fey Algeria Bolivia Project Jan 2020- May 2020

Data Analyst Intern

Researched Fey Algeria Bolivia project to identify underprivileged students in need of financial help using data mining, ANOVA and regression techniques in JMP.

Designed and normalized ER model fabricated a database, inserted data, created stored procedures, triggers in SQL.

Extracted, transformed, loaded, queried data from/into multiple data sources.

Built a predictive model in SAS Enterprise Miner to identify eligible scholars out of the pool applicants.

Sofkin- Bordentown, New Jersey Jan 2018 – Dec 2019

Business Intelligence Analyst

Collected and stored information about donors in MS Access; maintained a 95% error- free rate.

Performed analysis to target the customers by age groups and increased donations by 30%.

Analyzed past 2 years of donation data in Tableau to predict amount donation for the future.

Created presentations of donations and analysis on PowerPoint.

Infosys Ltd – Pune, India Dec 2016 – Oct 2017

System Engineer

Maintained customers datasets, cleaned data in MS Excel which reduced data ambiguity by 90%.

Collaborated with members of several teams during scrums and communicated project requirements efficiently.

Leveraged VBA Macros to automate several tasks using Agile framework and reduced repetitive, manual work by 75%.

Extracted, analyzed and implemented joins and aggregations in SQL to segregate customers in clusters.

Education

Master of Science in Business Intelligence and Analytics Philadelphia, PA

Saint Joseph’s University, GPA – 3.97/4.0

Bachelor of Engineering in Electronics India

Madhav Institute of Technology and Science, GPA – 3.3/4.0

Certification

Qlik Sense Business Analyst Certification

SAS Certified Specialist: Base Programming Using SAS 9.4

Tableau Analyst

SAS - Saint Joseph's University Joint Certificate in Business Intelligence and Analytics

Contact this candidate