VISHAL TANEJA

469-***-**** adg4f2@r.postjobfree.com www.linkedin.com/in/vishal-taneja

EDUCATION

The University of Texas at Dallas, MS in Business Analytics (STEM), Excellence Scholarship May 2020 Rajiv Gandhi Technological University, B S I n M e c h a n ii c a l E ngineering June 2015 SKILLS

Programming/databases SQL, NoSQL, R, Python, Hadoop, Sqoop, Hive, Impala, PySpark, MySQL, ORACLE, SQLite, MongoDB,PostgreSQL

Analytical & BI Tools Tableau, Power BI, Qlik View, Minitab, SAS,,Matlab,ArcGIS, Google & Adobe Analytics, KNIME Functional Skills Data Analytics, Data Manipulation, Project Management, Data Mining, Negotiation, Geo- Spatial analysis, Marketing Analytics, Prescriptive Analytics, Problem Solving, Supply Chain, Communication, Leadership, Econometrics, Model Building, Data Modeling, Data Visualization, Statistics, Marketing, Database Design, Procurement Statistical & Quantitative

skills:

Regression, ANOVA Test, LDA, PCA,QDA,SVM, KNN,T- Test, Post-Hoc, K-means Clustering, Classification, Decision Trees, Naive Bayes Classifier Relevant Coursework Business Analytics with R, Statistics and Data Analysis, Database Foundations for Analytics, Social Media Business, Big Data, Predictive Analytics Using SAS, Marketing & Web Analytics,Spreadsheet modeling and Analytics

RELEVANT EXPERIENCE

Child Poverty Action Lab, Dallas(USA) January2020 – April2020 Data Analyst (Practicum)

• Collected data from various sites like data.texas.gov, diversitydata kids.org on various family indicators that impact child poverty for Dallas, Collin, Denton & Tarrant counties.

• Created a family sub-index assigning scores to various counties and used Python’s Scikit-learn library to standardize score

• Used tableau to make dashboard and presented findings to the Director of Analytics, CPAL Daikin Air Conditioning India Private Ltd. Gurugram September2015 – August 2018 Data Analyst

• Formulated Customized ‘SQL ' queries to pull & gather data from disparate data sources, thereby drawing pertinent insights from it.

• Conducted Spend Analysis using wide array of technologies like Tableau, PowerBI and SAS.

• Collaborated with IT teams to automate redundant tasks using VBA and Macros, which led to an increase in operational efficiency by 15%

• Performed rigorous quantitative & statistical analyses using concepts like A/B testing, Hypotheses testing to draw insights & conclusions from data to the tune of $1M using R, Python & SQL BHEL (Bharat Heavy Electricals Ltd.)Bhopal, India June2013-June2015 Reporting analyst

• Improved assembly line efficiency by 2% by analyzing historical line data using Tableau, PowerBI and SAS.

• Partnered with IT teamed to drive improvements in data warehouses, data management system, and various analytics platforms .

• Increased revenue by 10% to $2 Million by analyzing Historical Spend data and developing forecast models. RELEVANT PROJECTS

• Location Intelligence to assess the best possible location for Asian restaurant using ArcGIS March 2020

• Performed market Basket Analysis on a complex Retail Dataset using Python,SeaBorn,Matplotlib January 2020

• Analyses of Grocery Scanner Data to understand effects of promotion & Advertising on sales of various Mayonnaise brand using SAS, Advanced MS Excel & Tableau October 2019

• Integrated analytics of disaster using R & tableau by K-means clustering & decision trees June 2019

• Multi-map visualization of 10 years natural disaster data & refinery location data of an December 2019 energy company using tableau and advanced excel.

• Performed customer segmentation of Retail dataset using Python to identify potential and profitable Customer segment. March 2019

• Developed a prediction model to predict a customer churn by analyzing Dataset using Logistic Regrssion

Contact this candidate