Post Job Free

Resume

Sign in

Data Analyst

Location:
Stillwater, OK
Salary:
80000
Posted:
February 25, 2020

Contact this candidate

Resume:

YASHA PASTARIA

+1-405-***-**** adbzp3@r.postjobfree.com www.linkedin.com/in/yashapastaria

SUMMARY

• An entry level data enthusiast with a focus on analyzing large data sets using statistical and analytical knowledge to generate key business insights

• Strong problem-solving skills, attention to details, organized, and results oriented

• Strong interpersonal skills, effective verbal and written communication

• Ability to establish priorities and proceed with objectives with minimal supervision EDUCATION

M.S. in Business Analytics, Oklahoma State University, USA GPA : 3.90/4.0 Expected May 2020 B.E in Biomedical Engineering, SGSITS, India GPA : 7.64/10 June 2017 TECHNICAL SKILLS

Statistical Techniques : Regression, T-test, Hypothesis Testing, ANOVA, Decision Tree, Clustering, Logistic Regression, Random Forest, Neural Network, Gradient Boosting, Principal Component Analysis, Data Mining, Text Analytics, Deep Learning Programming & Tools : Base SAS, SQL, SAS Enterprise Miner, MS Excel, Python, R, SAS Visual Analytics, Power BI, Tableau, Alteryx

WORK EXPERIENCE

• Statistical Data Analyst, Lowen Corporation, Hutchinson, KS May 2019-Aug 2019 o Partnered closely with business function teams including Marketing, Sales, Installation services to identify business requirements and performance metrics

o Presented and clearly communicated analyses and KPI packages to cross-functional groups on a weekly and monthly basis o Translated business issues into testable hypotheses answerable with data and synthesized them into stories and visualizations for non-technical users

PROJECTS

• Identifying Factors Affecting U.S-Mexico Border Crossing Traffic September 2019-Dec 2019 o Web scraped temperature, GDP, exchange rates from multiple websites using Python libraries Beautiful Soup, Numpy o Extracted pro/anti-immigration sentiment from White House articles using Text Analytics in SAS Enterprise Miner o Built Panel Regression models using Random Effects to find drivers of traffic between U.S and Mexico

• Employee Efficiency and Headcount Analysis May 2019-August 2019 o Designed data models in Power BI by removing circular dependencies and unwanted joins thereby reducing data processing time by 3 hours

o Developed an algorithm using DAX measures in Power BI to improve employee efficiency of workers in the plant o Identified reasons for employee turnover using text analytics and suggested strategies for employee retention

• Google Analytics and Facebook Marketing Campaigns Analysis May 2019-August 2019 o Used SQL to pull, clean and analyze datasets from internal( supply chain) and external (customer fulfillment) data o Built DAX measures in Power BI for tracking metrics CTR, CPC, Impressions, Spend, Revenue from marketing campaigns o Built a custom data connector in Power BI to pull ad campaign data from Facebook o Built multiple dashboards in Power BI to report KPIs using scorecard, line charts, funnels and matrix

• Oklahoma State University Athletics September 2018-May 2019 o Analyzing and optimizing the pricing strategy of football game tickets for OSU using Tableau o Predicted churn of seasonal ticket account holders using Decision Trees in SAS and achieved an accuracy of 72% o Presented recommendations that were highly appreciated by clients to improve fan experience CERTIFICATIONS

Tableau Desktop Specialist SAS Certified Predictive Modeler for SAS Enterprise Miner SAS Certified Base Programmer for SAS 9.4 Python Data Science Toolbox, Datacamp Statistical Thinking in Python, Datacamp Cleaning Data in R, Datacamp Visual Analytics on SAS Viya OSU Data Mining Certificate Google Analytics CAMPUS INVOLVEMENT

• Business Student Council for BASA( Business Analytics Student Organization), OSU Oct 2018-2019

• Event Organizer- Club Pratibimb (fine arts and photography club),SGSITS, Indore, India Jul 2014-2016 ACHIEVEMENTS

• Analytics Case Competition winner among 15 teams at Oklahoma State University November 2019

• Won Best Contributed Paper in Business Analytics Section award at Western Users of SAS Software Conference for individual research paper titled “Analyzing Factors Influencing Viewer Count of TED Talks through Text Analytics September 2019

• CIE (Creative, Innovative and Entrepreneur) scholar at OSU, awarded $2,000 scholarship August 2019

• Academic Excellence Scholarship of $500 awarded by Ministry of Human Resource and Development, India January 2016



Contact this candidate